Sean is a very bright, articulate, motivated and enthusiastic Senior Developer with a wealth of technical expertise specialising in C#.NET and SQL Server. He has 14 years commercial experience spanning investment management and financial services.
C# | .NET 4.0 | SQL | Agile | TDD | WPF | MVVM | WinForms | Prism | DDD | DI, IoC | Rx
NUnit | XUnit | moq | AOP (PostSharp) | Design Patterns | Unity | MEF | Castle DynamicProxy, Windsor
WCF | SQL Server 2012 | Azure, Cloud Hosting | SSIS | SSRS | XAML | XML | ADO.NET
Microsoft Enterprise Library | Full SDLC | ASP.NET | VB.NET | VBA | VB6
IKM percentile for .NET 3.5: >98% (April 2012)
VS2010 | PostSharp | Infragistics | SSMS2012 | Subversion Git SVN Tortoise | ReSharper | TFS
Currency Overlay | Equities | Derivatives | Fixed Income | Asset Management | Risk | Valuation
Senior Developer @ From June 2014 to March 2015 (10 months) London, United KingdomLead Developer @ • Designed and developed a new critical tool to facilitate currency overlay (hedging and tactical), working directly with domain experts using an Agile TDD process
• Included exposure currency management, FX order generation, interfaces for back and middle office
• Facilitates process for forward position rollover, monitoring guideline breaches, strategic trades, calculation of P&L, tracking errors, compliance and counterparty risk
• Bloomberg integration for indices and forward FX prices
• MVC WinForms UI, WCF, developed using TDD, and introduced some BDD
• SQL database schema and stored procedure design – TDD harnesses for new stored procedures
• SSRS (SQL2012) for valuation and P&L reporting
• SQL scripting, comparison and deployment automation using VS2010 database projects, all SQL objects versioned with SVN
• Refactoring of brownfield codebase, introduced patterns, DI, loose coupling, added unit and integration tests with NUnit
• Added aspect-oriented programming using PostSharp (compile-time weaving) with method interception aspects for transaction management, exception handling and logging From January 2013 to April 2014 (1 year 4 months) Analyst Developer (Charles River) @ • Wrote XML messaging component for TradeFlow to CRD using SSIS, custom .NET assembly, CRD API, IBM WebSphere and BizTalk for processing acknowledgement files and message queues
• CRD - Bloomberg integration changes
• Batch process report configuration and interfaces with accounting systems (SSIS, SQL procs)
• Ad hoc queries for order management, preparing trade data for transaction reporting for FSA
• Upgrade from CRD v8 to CRD v9, analysis of schema changes, index performance, review of SQL job and SSIS interfaces
• Various work for compliance rules, ad hoc reports and interfacing with accounting systems
• Introduced Visual Studio Database Projects, full change control and automation of releases From May 2012 to December 2012 (8 months) London, United KingdomLead Developer @ System encompasses placing orders, portfolio modelling, settlement, management fees, client valuation reporting, capital events, dividend entitlements, performance calculation, MI, pooled accounting, custodian cash feeds and cash account management and also interfaces with Bloomberg, CTM Omgeo and latterly Charles River.
• Direct contact with many parts of the business including requirements gathering from front office dealing desk
• Responsible for full development life cycle including builds in an Agile setup sometimes involving prototyping and pair programming
• Developed WPF prototypes for new modules using Prism and MVVM design patterns
• Wrote unit tests using VS2010 and NUnit and adopted TDD methodologies for order management
• Designed and implemented solution architecture with business objects, .NET Remoting and WCF
• Developed new interface for Charles River using WCF
• Developed multithreaded Rx code for operations such as performance calculations
• Developed security module with Bloomberg interfaces for derivatives, bonds, equities and funds
• Infragistics .NET Advantage Dev. Suite used extensively in the presentation layer with style sheets
• Added control inheritance to extend and fix bugs with the Infragistics .NET control suite
• Designed UI structure and navigation with Infragistics docking windows, grids, trees and menus
• TFS including administration and power tools and the tf command line utility
• Wrote stored procedures and improved performance on existing stored procedures and investigated slow running queries and helped redesign tables, indices and views
• Introduced new T-SQL such as Common Table Expressions (CTEs) and better query structure
• Introduced design patterns to the project, saving considerable coding time. Implemented and oversaw coding standards and code reviews.
• Trainer and mentor for junior developers. From May 2007 to April 2012 (5 years) London, United KingdomDatabase Development Co-ordinator @ Worked as a database developer and architect, responsible for all aspects of database solutions for both clients and internal projects. The role included some resource management and mentoring.
• .NET, SQL Server 2000, Access ADP, XML
• Designed and developed a client/server IT Request system from scratch that was integrated with Active Directory data, used automation of Excel and Outlook, sent automatic e-mails, provided comprehensive tracking of requests, complex MI and data driven user customisable forms.
• Designed and developed a base complaints handling system used by all medium to large client projects in the business. The system included a custom MI tool, auditing, user customisable mail merge facility and interfaced with 3rd party systems used by clients.
• Customisation of the complaints handling database, upload utility for the automatic upload of cases sent by the client; the utility included comprehensive exception reporting by e-mail using DTS
• Designed and developed a powerful generic MI tool for user-customisable complex reports and automation of Excel templates for presentation
• Designed a .NET service for a regular XML two-way data feed for integration with a large client’s new third party database application From March 2004 to May 2007 (3 years 3 months) Senior Implementation Consultant @ • Clients included Philips, Consignia, Heineken, Vodafone and Barclays Bank.
• Developed client/server and n-tier software using VB6, VBA, COM, T-SQL, XML, XSLT
• Ad-hoc and implementation projects for clients, including providing technical specifications and estimate summaries
• Specification and coding of custom data migrations and data refreshes for clients who were migrating or refreshing their HR data to our systems
• Wrote and conducted technical training for implementation team, the support and consultancy teams and externally to both clients and distributors
• Spent final 6 months in a Team Leader role responsible for time and resource planning for the team, interviewing candidates for senior and junior roles, putting together process plans, skills matrices and internally reviewing technical specifications, estimates and actual work From 2000 to 2004 (4 years)
BSc (Hons), Mathematics @ The University of Manchester From 1996 to 1999 Marlwood Sean Fackrell is skilled in: Business Analysis, Microsoft SQL Server, C#, Stakeholder Management, ASP.NET, SQL, ASP.NET MVC, Databases, Scrum, Endorsements, WCF, SDLC, Data Warehousing, XML, SSIS, VB.NET, Agile Methodologies, .NET, T-SQL