Accomplished developer of data moving, data processing, data storing
Resume:
Igor Vinogradsky
****.***********@*****.***
Accomplished developer of data moving, data processing, data storing, and data QA solutions for OLTP, DW, OLAP / DSS and file processing systems.
Strong analytical, design, and development skills.
Masterful at developing efficient dataflow solutions.
A senior hands-on problem solver, adept at engineering complex database stored procedures, functions, triggers, custom data integrity solutions.
Passionate about optimizing data loading solutions by fine-tuning, refining, and enhancing processes to achieve high efficiency
Professional Experience Summary:
Hands-on experience with design, development, implementation, and support of complex SSIS solutions and custom database access layers.
Hands-on experience with identifying, documenting, developing, implementing, and validating data lineage and data mapping documentation, 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.
Strong experience with development and implementation of data migration / re-platforming solutions between heterogeneous data silos; data wrangling utilizing custom TSQL-based and/or SSIS-based solutions.
Hands-on experience with developing ERDs for OLTP, OLAP, DSS.
Strong hands-on experience with building, implementing, and maintaining comprehensive automated systems for all aspects of the data QA.
Adept in being part of off-site/off-shore engineering teams that spanned different time zones and continents.
SQL Server, SSIS, TSQL, SSMS, C#, VSTA, BIDS/SSDT/VS integrated shells, VBS, SSRS, TFS, GIT, SharePoint, Jira,
MySQL, Teradata, Oracle PL/SQL, Sybase, IBM Cognos DataManager, IBM Infosphere DataStage 11.5
MS Visio/ErWin,
CompTIA Security+ Certified, June-2024, Microsoft Certified:
Azure Data Fundamentals Certified, July-2024
DB2/UDB 9 Certified User
Active Secret Security Clearance
WORK EXPERIENCE
Aug 2021 - January 2025, Tiber Creek Consulting, Senior Database Developer.
Responsibilities and duties :
Participated in the transition and contributed to conversion and further expansion of the in-house solutions that received and processed data from the legacy (mostly Mainframe-based) systems over to the IPSS-A and other upstream systems to the in-house operational and DataMart databases used for support of the downstream analytical systems.
Developed complex database stored procedures, SQL server-side functions, and triggers for facilitating efficient data collection, data wrangling, data cleansing and delivering to the target databases
Designed, developed, and maintained SSIS (with VSTA/C# extensions), and T-SQL ETL processes.
Provided support to the front-end development partners for building analytic applications for business decision making and information services
Provided code mentorship to the team members, conducting code reviews, and resolving the production code defects.
Data worked with related to the MODS, MDR, SMMS, RCMS.
(MODS - Medical Operation Data System, MDR / MHS - Military Health System Data Repository
SMSS - Strength Maintenance Management System, RCMS - Reserve Component Automation System
IPPS-A - Integrated Personnel and Pay System)
May 2017 – Aug 2021, The Kaiser Permanente Medical Group, Financial and Operation Services (TPMG FOS): Data Architect, Database and ETL solutions developer for collecting and processing the data and delivering information related to allocation of funds to medical centers, monitoring operational/financial performance, providing cost data that integrated complex factors for financial planning and budgeting
Contributed to the conceptual design, development and implementation of a new generation of the FOS - Financial and Operational Systems - Data Warehouse - from the database modeling and design to the upstream and downstream ETL processes development that collected the TPMG's financial and operational data hosted on the mainframe DB2, ORACLE, HADOOP, TERADATA and other upstream source systems, as well as the ones that fed the downstream data-mart systems.
Recovered and improved the legacy upstream systems data flows and underlying data lineages.
Converted the existing Datamanager ETL processes to DataStage-based processes and SSIS-based processes.
Microsoft SQL Server 2016, T-SQL, SSIS, PowerBI, VS 2017 (SSDT), Oracle 10, PL/SQL, Teradata, Hadoop, IBM Cognos DataManager, IBM Infosphere DataStage 11.5, EDI flat files
Feb 2017 – May 2017: BEBE Design Studios, Inc.Senior Database Developer, ETL and database processes
Design, development, and implementation of 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, Oracle / PL/SQL, Linux
Feb 2016 - Feb 2017: First Republic Bank
Senior Data Warehouse ETL Developer
Participated in the design, development, and enhancement of the ETL solutions for delivering data from the various business lines (Banking, Wealth Management, Lending) and conversion from the existing FRB banking platforms to the "New Generation" Data Warehouse.
Environment: SQL Server 2012, SSIS, T-SQL, #C.NET, TFS, SQL Server Data Tools, Oracle, PL/SQL, Mainframe originated flat files
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; adjusted the existing in-house solution from ICD-9 to ICD-10; performed some data modeling;
Designed, developed and delivered to the production an ETL solution that provided daily processing of 40+ flat files that were FTP-ed from the field offices in, put them through a multi-step transformation process that delivered their information to the data warehouse and the subsequent reporting layer database.
Environment: SQL Server 2012, SSIS, SSRS, ORACLE PL/SQL
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, PowerBI, SSRS, Microsoft SQL Server Management Studio 11.2, ORACLE, 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 DQ 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
Oct 2009 - Apr 2010: Wells Fargo Bank - 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 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)
Education: MS in Math
US Citizen
Active DoD Security Clearance
Contact this candidate