SUMMARY:

• Professional with expert knowledge in SQL BI technology and its application for financial services and other industries. CPA with fund accounting experience. Proven ability to work with business users to elicit and understand business requirements, deliver BRD documents, and design, develop and manage applications. Experienced in full system development life cycle (SDLC).Extensive experience in business and technology allow me to fit in either a business or a technical department. Experienced wearing many hats; successful as a single contributor or managing teams. Looking for a challenge and the opportunity to contribute.
• Passion for working with business stakeholders to create business intelligence solutions encompassing reporting, ETL and databases to improve their ability to access and utilize critical information. I am looking for an organization which will maximize the use of my skills.
• Newly completed several Tableau training courses. Learned step - by-step procedures for building 50 unique visually sophisticated reports; covering a wide spectrum of Tableau’s capabilities.

TECHNICAL SKILLS:

Analyst: Business and Systems Requirements Documents (BRD and SRD), Detailed Documentation of Existing Systems, Use Case and UML, Status Reporting, MS Project, PMP course

BI: Tableau, Power BI (Power Query, Power Pivot, Power View), Cognos Report Studio & Framework Manager, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

ETL: SQL Server Integration (SSIS)

Database: SQL Server 2016 and prior using SSMS, Oracle using TOAD, MS Access, complex SQL, extensive T-SQL Stored Procedures

Datamodeling: Erwin and Visio

Programming: C#, VB.NET, SSIS (App Dev), Excel VBA, Perl, VB6, C

PROFESSIONAL EXPERIENCE:

VP Finance Manager

Confidential

Responsibilities:

• Business analyst, designer, and developer for the Product Valuation Group. Work with many teams to determine the best business and technical approaches to provide and solve business needs.
• Business analysis and functional business specifications associated with monthly PVG derivative and security price valuation processes. This includes data from derivative, trading, sub-ledger positions, GL accounting systems, and reference systems. SME on our GL accounting systems.
• Remediate the Completeness Check from the existing general ledger balances to the new SAP accounting system. The existing and new systems have very different accounting structures. 10 million balances and 5 million reference records.
• Built a new Completeness Check, which compares PVG submissions to the general ledger by business unit, legal entity, asset type, and region. Extensive stored procedure logic and Excel VBA for uploads and reporting.
• SOX quarterly reporting built using SQL to create custom hierarchies to establish materiality of SAP balances.
• Built a statistical sampling application for back-testing security pricing (C#).
• Teaming with our security reference group, they extended their API to allow for the retrieval of asset classifications and bond ratings.
• Provide statistical samples from security trades, grouped by custom asset classifications.
• Apply standard deviation and z-score to each selected security across several vendor prices.
• Built a large SSIS analytics application which provides monthly collateralized derivative reports for each Line of Business. This application is used to identify material pricing issues and breaks with counterparties.
• Based on TriOptima reports and the trade database, comparative month-end mark-to-market values between the bank and the counterparty are presented.
• Excel reports are created within SSIS scripts using C# and the Excel Office Object.
• Reports include detail trade, LOB, SubLOB, counterparty, trader, aging, top valuation differences from counterparties, related FX derivatives, CP submission, comparative review against month-end + 5 business days for CP differences.
• Support many finance users in PVG corporate, PVG LOB (quants) and Finance LOB, by providing financial data to assist their valuation efforts.
• BA on Equity Option Metrics using Consensus and Market volatilities for pricing revaluation.
• Built a prototype application for automating the retrieval of historic security prices from Bloomberg, Interactive Data, Reuters, and Markit through vendor web services and HTTPS. (C#, SSIS, VBA, SQL Server).
• Tableau reports. Built TD databases using C#.

Consultant

Confidential

Responsibilities:

• Custom Portfolio Asset Management (PAM) system.
• PAM Projects: added non-qualified dividends and income, and dividend reinvestment.
• PAM Enhancements: trades, holdings, transfers/receipts, general ledger, automated posting entries.
• PAM Development: Heavy emphasis on complex SQL Server stored procedures, using VB with a custom application framework.
• Business analyst for a new reference product system (Golden Copy) using Asset Control as their framework.
• Counterparty reference data.

VP, Back Office Development for Accounting

Confidential

Responsibilities:

• Perl and C++ in Unix. Oracle 10g and 9i.
• Developed 30 financial reports in Cognos Report Studio. Built packages using Cognos Framework Manager.
• Developed major application which rebuilt all production databases to support risk counterparty and improve daily urpl (NAV) calculation performance, by allowing offsetting positions to collapse.
• Maintenance of ledger chart of accounts, posting entries, trade types, and aggregations.
• Fund accounting concepts used to separate ledgers, trading books, trade types, security types, and aggregations across ledgers based on combinations of book, security, and counterparty.

Assistant Vice-President

Confidential

Responsibilities:

• Designed and coded a Windows based reengineering project for Confidential ’s mutual fund accounting department.

Senior Programmer

Confidential

Responsibilities:

• Mutual Fund Pricing System, used daily by the accountants supporting over 100 mutual funds to calculate NAV.
• Designed, coded, and managed a Mutual Fund Accounting Payment System for Dean Witter.

Manager Business Applications Development

Confidential

Responsibilities:

• Transitioned the team from ASP to .NET / ADO.NET, data modeling and Use Case documentation.
• Major projects include Global HR and workflow applications (Oracle, Microsoft SQL Server, Unicenter).
• Analysis for the purchase of a new Incident Management system (CA Unicenter). Subsequent development of reports using SQL Server 2005 Reporting Services. Personally coded an extensive framework built on ADO.NET.

CTO / VP Software Development

Confidential

Responsibilities:

• An e-learning company for IT Management. Major clients included Microsoft, IBM and EDS.
• In charge of the design and development of new and existing software products, and corporate systems.
• Led the effort to use e-book technology to deliver custom rich-media CD programs for customers.
• Conceptualized the business and technical design for a suite of Internet TV and multicasting products.

VP of Technology

Confidential

Responsibilities:

• In charge of the design and development of an e-mail hosted solution.
• Supervised and architected work assignments, established technology direction and made technical decisions.
• Designed and maintained the data-model (Erwin), coded, performed code reviews, participated in stress tests, performed QA, and participated in the installation of the web site.