SUMMARY:

• Extensive experience in identifying, documenting, developing, implementing, and validating business requirements in OLTP, OLAP / Data Warehousing environments for high - volume transactional and analytical systems in the banking, health management, securities trading, credit card transactions processing, and other industries.
• Extensive experience in building automated quality verification systems for ETL, Data Warehouse, and analytical solutions.
• Adept in being part of off-site/off-shore teams that spanned different continents.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Data Warehouse ETL Developer

• Design, development, enhancement of the ETL solutions for transferring data from the various business lines from the existing banking platform to the new one.

Environment: SQL Server 2012, SSIS, T-SQL, #C.NET, TFS, SQL Server Data Tools

Confidential, Novato, CA

Data Solutions Senior Consultant

• Design, development, implementation of the Operational Data Store and the ETL system for populating it; performing the task of a data modeler, a database architect, an ETL designer and developer, a reporting layer designer and developer.
• The system provides a daily processing of 40+ flat files that are FTP-ed in and put through a multi-step transformation process that delivers their information to the data warehouse and the subsequent reporting layer database.

Environment: SQL Server 2012, SSIS, SSRS.

Confidential, San Francisco, CA

Senior Consultant

• Development and maintenance of the R&F Uni-level Breakaway Hybrid Compensation Plan (ULBHCP) SSRS-based reporting solution - developed and/or enhanced 40 reports, including development and performance tuning of the underlying SQL SERVER TSQL stored procedures.
• Development and maintenance of the ULBHCP automated data quality validation solutions of the ETL system that delivers the R&F E-Commerce data to the ULBHCP reporting layer database, automated the data quality verification process of major data inflows, such as the account management, order processing and cancellation, product inventory maintenance.
• Researched, analyzed, and addressed the R&F ETL and reporting layer’s flaws, performance bottlenecks
• Extensive regular communications with the ULBHCP business analysts over new and change requests for new and existing SSRS reports, improvement of the end-user experience.

Environment: SQL SERVER 2012, SSIS, SSRS, Microsoft SQL Server Management Studio 11.2, Microsoft Visual Studio 2013

Confidential, San Francisco, CA

Business Analytics and Applications Lead Developer

• Led a DEV/BA team of 3 people
• Developed, maintained and expanded the data management solutions for heterogeneous data silos/database systems residing in SQL SERVER 2005, 2008r2, SQL SERVER 2012, SalesForce Cloud solution
• Built and maintained data interfaces between various data nodes to assure timely synchronization of the business critical information across the company-wide topology
• Developed custom ETL and Analytical solutions to support strategic business planning and decision making processes
• Identified and resolved data quality issues in partnership with business owners and external vendors
• Supported the UAT activities; assured sufficient quality data for productive UAT cycles, resolved data issues and addressed/fixed defects found
• Reviewed and assessed technologies/solutions provided by external vendors to ensure smooth integration with the existing Confidential ones
• Provided/created business analysis, formal specifications, implementation and post-implementation and production support for the in-house reporting, analytics, and data synchronization solutions
• Participated in and contributed to the Change Control and Management Decision activities by providing business and systems justification for proposed change requests.

Environment: SQL SERVER 2008, SQL SERVER 2012, SSIS, SSRS

Confidential, San Francisco, CA

Senior Consultant for AUTODESK EIS

• Development, enhancement, tuning of the data access layer; providing the data to the consuming Web Services; development of stored procedures, triggers, finding/addressing custom ETL performance bottlenecks and functional deficiencies, data related maintenance, data quality, data cleansing; queries performance tuning / optimization.

Environment: SQL SERVER 2008, T-SQL, ORACLE 10, PL/SQL.

Confidential, San Francisco, CA

Test-Ware QA Lead Developer

• Development of test-ware for verification of the vendor-specific and in-house ETL solutions developed for collecting money movement transactions within, between, in and out of various Confidential divisions (retail banking, wholesale banking, investment management, securities trading) and accumulating these transactions in the centralized EDW for analysis, interception, and reporting those individuals, organizations and institutions that did not comply with the BSA/AML rules and regulations to the federal government.
• My solutions were also used to validate the correct implementation of the latest BSA/AML requirements monitoring via a Fortent/Actimize custom fraud prevention monitoring UI tool for the Confidential fraud prevention specialist, and some other in-house systems, which obtained the information directly from the EDW or from downstream Data Marts.

Environment: UDB, SQL SERVER, DB2, ORACLE, TERADATA, UNIX, WINDOWS, MAINFRAME

Confidential, San Francisco, CA

Data Migration & Data Quality Solutions Lead Developer

• Data Analysis, Data Mining, Data Profiling, Development of the test-ware for verification of the INFORMATICA-based ETL for migrating Wachovia’s data into the Confidential target data silos.

Environment: ORACLE 10, SQL SERVER 2008, PL/SQL, T-SQL