Data Analyst Architect

Mikhail Krivitskiy

Email: *******.***@****.***

Phone: (301) 404- 4621

Address: ***** ********** ****** *********, ** 20850

COMPETENCIES:

Data Modeling and Architecture

Complex Data Analytics

ETL and ELT Development

Cloud Computing: AWS, EC2, S3, Lambda

Data Management: AWS Glue, RDS

Data Governance and Maturity Evaluation

Business Intelligence and Visualization

Software Development Life Cycle

Informatica, Erwin, Oracle Data Integrator

Agile Methodologies and Practices

Oracle, Business Objects, Power BI

Software Management Tools

SQL, PostgreSQL, PL/SQL, Python

Microsoft Office Tools

EXPERIENCE SUMMARY:

Accomplished professional with over 30 years of comprehensive experience as a Data Analyst, ETL Developer, Data Architect, and Software Developer. Demonstrated success in delivering innovative solutions across diverse projects for prominent government agencies, including the FDA, CMS, VA, and DEA.

Booz Allen/Drugs Enforcement Agency (DEA)

National Forensic Laboratory Information System (NFLIS) 09/2024 – Current

As a Data Architect, Mr. Krivitskiy designed and developed OLAP data structures to facilitate external file data loading, improving system performance and scalability. Built additional datasets to capture metadata, ensuring consistent data tracking.

Designed and implemented AWS Glue ETL processes for the NFLIS Drugs Use Case during the Proof-of-concept phase for advanced data transformation capabilities, providing data transformation and efficient loading into a PostgreSQL database.

Created data modeling documentation, including Data Dictionaries, Entity Relationship Diagrams (ERDs) and a Data Glossary to ensure consistency and alignment with project objectives and to ensure efficient system development.

Utilized AI technologies to generate test files and create detailed test cases for various workflow scenarios, ensuring robust data quality validation.

Booz Allen/Centers for Medicare & Medicaid Services (CMS)

Advanced Providers Screening (APS) 10/2021 – 06/2024

Mr. Krivitskiy served as a Senior Data Analyst, working on enhancing the APS system for Medicare screening by automating data validation to detect potential fraud. Additionally, identified and resolved data-related issues and discrepancies to ensure accuracy, integrity, and efficient processing within the system

Supported data migration initiatives to ensure consistent and accurate system upgrades. Created comprehensive data mapping and optimized data loading workflows to enabling informed, data-driven decision-making.

Developed and implemented Python scripts to automate data processing and visualization in Grafana data reporting and visualizations, enhancing real-time monitoring and reporting efficiency for CMS clients.

Conducted comprehensive vendors data reconciliation processes across diverse sources with varying structures and formats to ensure data quality and consistency.

Booz Allen/Veterans Affairs (VA)

VA Interoperability Assessment VA/OTI 08/2018 – 10/2021

Led data management initiatives as Project Manager and Solution Architect, supporting VA’s Electronic Health Record Modernization (EHRM) program to integrate VA and the Department of Defense (DoD) into single enterprise-level solution.

Conducted Database management assessments of various VA programs to generate actionable results and recommendations to improve data operations.

Designed and refined the Interoperability Maturity Matrix framework and assessment tools to evaluate system integration capabilities.

Booz Allen/Food and Drug Administration (FDA) / (CBER)

Vaccine Adverse Events Reporting System (VAERS) 07/2008 – 08/2018

Participated in the design and implementation of the e-VAERS project, incorporating electronic submission data from vaccine manufacturers to streamline post-marketing safety reporting. Developed efficient data processing workflows to ensure accurate loading, enhancing regulatory compliance and improving Adverse event tracking.

Engineered validation and parsing processes for HL-7 compliant electronic submissions using Informatica Data Transformation, ensuring data integrity and system integration.

Designed and structured database architecture for the CBAERS Data Mart using Erwin, optimizing data storage, accessibility, and analytics for regulatory reporting.

RS Information Systems/Food and Drug Administration (FDA) / (CBER)

Vaccine Adverse Events Reporting System (VAERS) 05/1998 – 07/2008

Designed and implemented a client-server application for the VAERS system using Oracle Forms/Reports and Business Objects, supporting the Vaccine Safety Branch (VSB) and enabling comprehensive Review and Compliance process.

Led the development and operational execution of VAERS application, ensuring accurate capturing of Vaccine Adverse Events information for FDA-regulated biological products.

Designed, developed, and optimized ETL processes leveraging Informatica Power Center to enhance data loading, processing, and integration with Data Mart applications. Improved data accessibility and reporting efficiency.

CERTIFICATIONS:

Agile SAFe5 Practitioner

Informatica – MDM and PowerCenter

SAP Education – Business Objects

EDUCATOIN:

B.S. Business Administration Kiev Technology Institution, Ukraine May 1992

Contact this candidate