Igor Vinogradsky

415-***-****

All US Time Zones

Accomplished developer of data delivering, data processing, and data providing solutions for OLTP, OLAP/DW, BI analytical and decision support systems, with strong analytical and designing, SSIS, TSQL programming skills

Professional Experience Summary:

Extensive hands-on experience in

. designing, developing, implementing and supporting complex TSQL based database access layers

. building ETL, Data Warehousing, Business Intelligence solutions; identifying, documenting, developing, implementing, and validating data lineage and data mapping, complex business and technical requirements for traditional and cloud-based OLTP, OLAP / DW, DSS environments for high-volume transactional and analytical systems in the banking, health management, retail, securities, financial, and other industries.

. building automated data quality verification solutions for ETL, data warehousing, and DSS / analytical systems.

Adept in being part of and leading off-site/off-shore engineering teams that spanned different time zones and continents.

SQL Server 2019 (and prev), SSIS, SSRS, TFS, SharePoint, tSQL, c#, VSTA, BIDS/SSDT/VS integrated shells, SSMS, Oracle RDBMS, PL/SQL, DataGrid, Informatica Cloud / IICS, Azure Data Factory (ADF), IBM Data Manager

WORK EXPERIENCE

Aug 2021 - Current, Tiber Creek Consulting, Senior Database Developer.

Responcibilities and duties:

. Developing of complex database stored procedures, functions, triggers to facilitate efficient data manipulation and data consistency

. Designing, developing, maintening of the SSIS and TSQL ETL and database processes.

. providing support to build analytic applications for business decision making and information services

. Providing code mentorship to the team members, conducting code reviews, resolving the production code defects.

May 2017 – Aug 2021, The Kaiser Permanente Medical Group, Financial and Operation Services: Staff Data Architect, Database and ETL solutions developer

Design, development, production support and maintenance and performance tuning of the Financial and Operating data ETL and analytical database solutions.

Principal contributor to the conceptual design, development and implementation of a new generation of the FOS Data Warehouse - from the database modeling and design to the upstream and downstream ETL processes development that collect the company’s financial and operation data hosted on the mainframe DB2 and SAS, ORACLE, HADOOP, TERADATA and other upstream source systems, as well as the ones that feed the downstream data-mart systems.

Recovering and improving the legacy upstream systems data flows and underlying data lineages; intense/in depth collaboration with the data consuming entities.

Microsoft SQL Server 2016, T-SQL, SSIS, SSRS, VS 2017 (SSDT), IBM DATA MANAGER

Feb 2017 – May 2017: BEBE Design Studios, Inc.

Senior Database DeveloperL ETL and database processes

Design, development, and implementation a OLTP to OLAP and OLAP to DSS ETL solutions, the DW and the DS Reporting System.

Environment: SQL Server 2012, SSIS, SSRS, SharePoint, T-SQL, VBS, LINUX

Feb 2016 - Feb 2017: First Republic Bank

Senior Data Warehouse ETL Developer

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

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

Apr 2015 - Feb 2016 Pacific Pulmonary Services, Inc

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.

May 2014 - Apr 2015 Rodan + Fields® Dermatologists

Senior Data Solutions 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, RedGate DB Tools, Microsoft Visual Studio 2013

Dec 2012 - May 2014: CalCPA - California Society of the CPAs

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 CalCPA 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

Mar 2012 - Dec 2012: DBBest Technologies, 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, O_RA_CLE 10, PL/SQL.

Apr 2010 - Mar 2012: Wells Fargo - San Francisco, CA

Bank Secrecy Act and Anti-Money Laundering (BSA/AML)

ETL, Data Warehousing and Analytics Systems' 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 Wells Fargo 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/Acti_mize custom fraud prevention monitoring UI tool for the Wells Fargo 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

Wells Fargo Bank - San Francisco, CA Oct 2009 - Apr 2010

Data Migration; Data Quality Solutions Lead Developer

Data Analysis, Data Mining, Data Profiling, Development of the test-ware for verification of the IN_FOR_MA_TI_CA-based ETL for migrating Wachovia's data into the Wells Fargo target data silos.

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

(prior professional/work/experience history is available upon request)

(professional references available upon request)

Education: MS in Math

US Citizen

Contact this candidate