Application developer in the financial sector utilizing .NET C /VB.NET VSTO Excel VBA Excel/Access databases and SQL to develop application front-end middleware and database back-end components with excellent communication and team leadership skills delivering well-executed software to enhance business processes.

• Software Development / Data Management
• Application development utilizing procedural object-oriented OOP and functional methodologies design patterns forms WinForms/WPF Excel add-ins XLAM/VSTO
• Informal AD/Agile techniques as well as projects covering the full SDLC from requirements gathering through planning development testing UAT deployment and documentation
• Data automation and exchange utilizing databases such SQL Server/OLAP Cubes Sybase Oracle and Access text files via XML Excel and text and services such as WCF
• Management reporting design and automation in Access/Excel using VBA and .NET with dashboards pivot tables charts standard/pivot linked data refreshes and toolbars or with SSRS
• Programming Languages/Tools
• Primary C VB.NET VBA for Excel/Access SQL Transact-SQL T-SQL
• Secondary ASP.NET MVC Razor X/HTML CSS PHP VBScript MDX PL/SQL LINQ F XAML XML/XSD SQL Server Reporting Services SSRS Entity Framework EF
• IDE s / Tools / Code Management Visual Studio FxCop SQL Server Management Studio SQL Server Integration Services SSIS SQL Server Data Tools Business Intelligence Design Studio BIDS Quest Toad for Oracle Team Foundation Server TFS Tortoise SVN HP Quality Center
• Other Visio Professional Office Professional Excel-Access-Word-PowerPoint SQL Server Migration Assistant SSMA
• Business Domains Projects
• Financial industry with particular focus on management reporting for risk management trading and IT as well as accounting business continuity planning BCP and expense management

• Architected a modeling desktop application for use by portfolio managers and traders to estimate liquidity scores and trading costs by sector duration and rating with a WPF XAML-based front-end and Entity Framework data tier implementing MVVM and a SQL server backend
• Created a back-to-front solution for portfolio managers and analysts to search portfolio position information for various security parameters that was performant on large data sets using SSIS and SQL for ETL and an Excel C VSTO add-in for filtering and retrieval
• Developed a tool suite that improved management s view of portfolio models with an Excel 2007 VBA add-in that automated models extraction into XML an ETL process to transform imports into an MS SQL data mart and an ASP.NET MVC website enabling both management of dimensions and display of results
• Expanded a user-developed VBA-based reporting system adding an Excel 2007 ribbon UI process controls logging and error-trapping as well as adding a C .NET VSTO add-in to provide threaded SQL execution improving overall process execution time by 60

• Created a suite of tools for stress testing a WCF service simplifying service adoption providing multi-threaded client capacity and service monitoring utilizing WinForms/WPF and classes
• Reduced polling and memory leaks by 400x in an Excel VSTO add-in and WCF-based service implementing a Publisher/Subscriber Observer pattern
• Provided a collection of AD and LDAP-focused tools and reports to cross-reference system and database logs providing support for monitoring database security and group migration in Access/VBA and C
• Developed a tool for quants to view risk sensitivities across aggregation levels utilizing WCF services OLAP cubes and databases as Model-View-Presenter MVP for platform flexibility
• Built a variety of innovative Excel-based add-ins e.g. automated migration of OLAP-based pivot tables to new SSAS schemas and automation/scheduling of pivot table updates using C /VSTO with ribbon and panel UI
• Created a flexible application for testing OLAP cubes using simultaneous threaded clients to improve performance and system monitoring built in VB.NET and SQL server
• Designed a Excel VBA template for reporting trader s limits utilization automating on-demand creation of a matrix of pivot tables and charts to assist traders in managing risk
• Designed a desktop application managing portfolio limits automating procedures with multi-tabbed forms to minimize complexity and reduce human errors using Access 2002/2003
• Confidential Developer Excel Access VBA SQL
• Developed SQL Server stored procedures to report on trade modifications and P L so that errors could be reported/charted reducing costly trade breaks and smoothing P L variance
• Prototyped an Access/SQL Server application for commenting classification and reporting of operational losses enabling management to more effectively reduce middle office errors
• Assisted an Access DB to SQL Server migration converting Access VBA and queries to SQL Server functions views and stored procedures migrating over 400 tables and 300 queries
• Automated numerous Excel reports for risk reporting in Excel combining pivots table and charts dynamic named ranges custom toolbars and remote data sources Access/SQL Server
• Created a replicated Access database that processed multiple varied files and dimensioned data with the purpose of reporting to senior management and reducing trade breaks
• Built a reusable Access/Excel reporting framework aggregating sources on trade breaks cost/position with a multi-tabbed form FX rates import procedures and report production

• Planned project deadlines and targets via regular client meetings as well as presented weekly deliverables via Microsoft LiveMeeting to garner feedback
• Developed and improved upon processes to analyze communicate manage and report data between ATT Cisco and NCR increasing annual billing by more than .5M
• Confidential Senior Developer Access Excel VBA
• Redesigned an Excel application converting SAS file-based data to SQL Server-based data enhancing reporting and usability while also enabling drill-down into Excel pivot table data via custom classes

Senior Developer Access Excel VBA

• Coded business logic for budget reporting process in Access reduced time and effort involved in reporting along with developing an Excel workbook add-in for easier data manipulation