David Brantley Email & Phone Number

Baltimore, Maryland Area

Collaborated in the development of a system for fair valuation and netting of derivatives in energy trading context; using Oracle, PL/SQL, Microsoft SSIS and C#.Reverse-engineered and documented legacy FAS compliance systems, developed batch processes, developed interface between MS SQL databases and Oracle risk system data stores, worked with financial controllers and accounting staff to elicit requirements and facilitate UAT.Developed daily profit statement system for energy trading to provide preliminary profit/loss data ahead of ledger posting; using Oracle, PL/SQL, C#, and Business Objects.Provided primary support working directly with end-users and financial controllers to resolve data issues and coordinate UAT activities; instructed two additional contractors in the design and maintenance of system and handed over support and maintenance.Architected and developed automated trade confirmation system for natural gas trading, delivering cost savings of $200,000 per annum by eliminating use of third-party clearinghouse, and labor savings of approximately 1 FTE by reducing manual matching of paper confirms; using C#, WCF, MS Enterprise Framework, PL/SQL, Altova MapForce, TX Text Control.Developed client-facing REST service for trade submissions, maintained and improved existing accounting and trade capture systems.

Baltimore, Maryland Area

Championed process improvements and best practices; evaluated customer needs and wrote specifications for new releases; conducted technical interviews of prospective hires; investigated and resolved SQL performance problems resulting in 30 – 80% performance improvements. Developed Windows Service for on-demand loading of operational and performance data to reporting system; using .NET Remoting, C#. Prototyped solutions and conducted benchmarking to select architecture.Developed multi-threaded Windows Service with plug-in architecture and custom framework allowing new data feeds to be developed independently and integrated rapidly.Led redesign of system for producing financial statements; using Visual Basic, C#, Actuate eReporting and .NET Interop. Results include 40 – 50% increased throughput, reduced licensing costs and improved failover time. System served 20,000 external clients.Led four-person team in converting 120 reports.Contracted with consultants to develop single sign-on capability for Actuate iPortal.Designed and led development of custom C# DLL interface to eReporting server via SOAP.Designed and implemented server farm architecture.Architected and implemented Web-based front end for account reconciliation system using ASP.NET. Designed XML-based tag language enabling end-users to develop report templates in MS Office; developed software to process PowerPoint and Excel files replacing tags with live data from portfolio accounting system and third-party data, and assembling pages into final presentation; trained end-users and oversaw deployment.Conducted architecture and design review of in-house fixed income valuation application; using ASP.NET, Oracle PL/SQL. Rewrote batch jobs to manage security identifiers resulting in significant reduction of data duplication and import errors. Developed application for regression testing of database queries as part of a conversion project from Sybase to MS SQL; using C#.

Delivered instruction in Visual Basic programming.

Washington D.C. Metro Area

Provided and supervised specification, design, coding, testing and implementation of applications for health care information dissemination for the National Institutes of Health.Provided database design and support for medical research teams; using Microsoft Access and Visual Basic.Wrote and assisted in drafting proposals for Federal contracts.Developed electronic storefront for division of National Institutes of Health; using Great Plains Dynamics C/S+ and MS Commerce Server.Developed contact database using a customized Symantec Act! database and supervised data entry team in importation of paper records.Led transition from Paradox-based order taking and fulfillment system to Visual Basic / Access solution.Developed Access solution for inventory taking by warehouse personnel.

Baltimore, Maryland Area

Provided specification, design, coding, testing and roll-out of customized data marts to health care providers; using HP COBOL, MicroFocus COBOL, PowerBuilder, Perl, C++ and Informix 4GL.Designed database of industry benchmarks.Developed test protocols for validation of input data and deliverables.Developed custom bug tracking database in Lotus Notes.Developed and delivered in-house training in Unix and SQL.