SUMMARY

• Over 20 years of MIS/ITarchitecture, design and development experience,mostly with large financial, hedge fund, trading and banking firms. Full project life cycle, project management, team lead and business analysis. Very experienced working with application and data integration and consolidation projects.
• Extensive database modeling, architecture design and development experience in MS SQL Server, Sybase and Oracle, including conceptual, logical and physical design. Experienced with analysis, modeling, normalization, database object development stored procedures, triggers, functions, constraints, tables, and indices , performance tuning, partitioning and SQL optimization. Experience with data modeling tools such as ERWin, ERStudio, Visio, CAST Workbench, others. Have worked with multi-terabyte databases and their unique requirements for performance optimization.
• Experienced in MIS reporting and dashboard development with a variety of tools, including MS SQL Server Reporting Services, QlikView, data export to Excel, Crystal Reports and Access.
• Extensive business analysis experience working with all levels of executives, management, stakeholders and end users. Creation of Business Requirements BRD documentation, gap analysis, project planning and timelines, standards and practices, standard operating procedures, technical and user documentation. Experienced with Microsoft Project. Experienced with Agile / SCRUM development projects as well as Rapid Application and Joint Application Development RAD/JAD and Rational UML methods.
• Experienced with Microsoft development languages: C .Net , VB, VBA, and VB.NET. Have worked extensively with object oriented design and development projects. Developed front end applications in WinForms and WPF. Minor experience with JavaScript and Java. Exposure to ASP.NET 3.5 and Silverlight web development. Experience with Visual Studio all versions . Experienced with MS Office development and integration, including Excel, Word and Outlook object models. Worked with various source versioning software Visual Source Safe, SVN . Experienced in the design and development of applications using Web Services/WSDL based interfaces.
• Experienced in multinational data and application projects with locations such as Toronto, London, Geneva, and Tokyo. Worked with multilanguage and localization issues.

RECENT EMPLOYMENT DETAILS

Technical Project Manager

Confidential

• The initial project leveraged my experience in integrating Bloomberg Market Data Services with existing and new MS SQL Server data tables and automated processing. This entailed the creation and automation of capturing daily key asset values and reference data using Bloomberg's Open Market Data API's. Work included the business requirements gathering, analysis and design of various software and database components and processes, with subsequent development of C DLLs, Microsoft SSIS packages and database tables, stored procedures, triggers, etc. Import/Export of Fixed Income data to Excel design and development of Excel spreadsheets for management reporting. Data consolidation and export to third party vendors Omgeo . Use of Altova UModel , Visual Studio 2012,TIDAL Job Scheduler, MS SQL Server 2008/2012.Development under modified Agile methodology using JIRA.

Technical Project Manager

Confidential

• This project with the Risk Management group was to consolidate US risk data and develop new management reports for daily and historic risk metrics such as VAR, Delta, volatility Vega , Theta and others for various exchange traded and OTC derivative products as well as monitoring market and counterparty credit risks in the New York office in conjunction with the London home office.
• The project required creation of Business Requirements Documents BRDs , Gap Analysis and technical specifications documents as well as working with all levels of management and stakeholders Using Microsoft BI tools SQL Server, Reporting, Integration and Analysis Services , new batch processes and online reports were defined and created, with automation functions that would incorporate SSRS report-generated graphics directly into critical Risk Management Committee MS Word documents.
• Use of Excel object model in data exports and imports. Design of data entry/display front-end screens in WPF. Design and development of SSIS packages to create Excel reports. Other requirements included logical and physical database design, creation of transact-SQL procedures, MDX Analysis Services scripts and batch processing SSIS packages, development of Oracle PL/SQL Stored Procedures as well as C front end and server-side application development. Development of data extracts from Sybase databases.

Senior Data Architect

Confidential

• Worked on a variety of database projects for internal systems R D group Projects include the architecture and integration of the company's various internal Event Planning and Marketing Campaign systems and reports. Work entailed the consolidation and integration of several disparate applications into a unified, coordinated event planning, budgeting and expense tracking system. Responsible for the conceptual, logical and physical design of MS SQL Server databases for use in planning and coordinating internal and external conferences, seminars, trade shows and other promotional and educational events. Development of C data entry WinForms and web services WSDL applications. Development in Bloomberg proprietary terminal applications/JavaScript. Development of various reportsfor both dashboards and detailed reporting using tools such as SQL Server Reporting Services, QlikView, Excel and others. ASP.NET code-behind development.Use of LINQ within C applications. Worked on several SharePoint development projects.Other work included developing custom C applications for integrating 3rd party products scanners, Email .

SeniorData Architect/Developer

Confidential

• Work at Confidential included the design and development of a Market Data retrieval system and its use by numerous Excel spreadsheets.Design and development of front-end and middle-tier C and WSDL/IIS applications to connect and retrieve Bloomberg historical ticker prices.Responsibilities included business analysis, user requirements gathering, project design and scheduling MS Project . Worked extensively as a liaison with Bloomberg Data Services technical and sales representatives. The project implemented an Agile development methodology.
• Other work included data modeling ERWin , extensive transact-SQL development stored procedures, triggers, functions, etc. , interfacing SQL data with Business Objects, SSRS and Excel for report generation of summary market data for trend analysis as well as process control and daily process status reports Creation/maintenance of sophisticated Excel workbooks using various financials and data retrieval functions as well as VBA development. Interfacing downloaded historical market data and other Bloomberg reference data for analysis and reporting SSIS ETL package creation as well as custom front-end and middle-tier DLL development. Development of data maintenance WPF Windows screens and ASP.NET web pages.

Technical Project Manager

Confidential

• Technical Project Manager for several new initiatives dealing with Business Analysis and IMS applications used for Credit Card P L and trend analysis. Project involved development of new set of database metrics and applications inMS SQL Server in order to replace third-party vendor's application and associated costs. Project planning, data analysis, gap analysis, supervision of three developers/analysts. Reporting to Project Management Office creation of treasury and credit card profit/loss reporting in Excel and SSRS.

Database Analyst/Architect

Confidential

• This short-term project entailed the assessment of several MS SQL Server databases used as a back-end data mart for the company's Neilson Television ratings research and reporting application. The assessment revealed several key problems in both dynamic SQL and stored procedure creation as well as problems with the middle-tier Business Objects universes and dynamic SQL generation. A series of findings and recommendations were developed and given to IT management.Additional features and corrections made to existing C WinFormsand Excel report generation applications.