ALBERT YAKHNIN

917-***-**** ad4pnm@r.postjobfree.com https://www.linkedin.com/in/albertyakhnin Brooklyn, NY 11214

Focus Of Interest: ETL TESTER ETL QA ANALYST

SUMMARY STATEMENT

Accomplished Sr. ETL Tester/ETL QA Data Analyst with over two decades of experience in ETL testing, data quality assurance, and collaborative project delivery.

Specializing in testing the extraction, transformation, and loading (ETL) of data. Solid understanding and knowledge of testing methodologies, data migration, and data quality.

Proficient in developing end-to-end ETL testing strategies and contributing to the seamless execution of data migration projects, ensuring data integrity and adherence to compliance standards.

Excels in employing advanced data analysis techniques, optimizing testing processes, and enhancing team efficiency. Eager to leverage a strong track record of success and a deep understanding of industry requirements in a Sr. ETL Tester/ETL QA Data Analyst role, focusing on designing, testing, and implementing data warehousing ETL and business intelligence solutions, driving data accuracy and quality in dynamic environments.

TECHNICAL PROFICIENCIES

Development Methodologies: Agile, Kanban, Scrum, Waterfall, Iterative

Operating System: Windows, Mac OS, Linux, Sun Solaris, HP-UX

ETL Tools: MS SSIS, Talend, Informatica Power Center, Pentaho Data Integrator, DVO

BI Tools: Tableau, Power BI, MS SSRS, Cognos

Office Tools: MS Office Suite, MS Project, Microsoft SharePoint, Adobe Products

Web Technologies: AWS services JSON, XML, HTML, JavaScript, and VBScript

Testing Tools: Toad, SQL Server Management Studio, Redgate SQL Data, Oracle SQL

Developer, MySQL Workbench, dbForge, Dbever, Aqua Data Studio

Defect and Management Tool: JIRA, gTest, ALM, HP Quality Center, JAMA, QMetry

Scheduling Tools: Autosys, iXp Workload Automation, Apache Airflow, VisualCron

Languages: T-SQL, PL-SQL, HTML, UML, Korn Shell, XML

RDBMS: Snowflake, Oracle, Microsoft Azure Databricks, PostgreSQL AWS Redshift,

MS SQL server, MySQL, DB2

EXPERIENCE

Blue Cross Blue Shield of Michigan

Sr. ETL Tester/ETL QA Data Analyst September 2023 — March 2024

Developed comprehensive end-to-end testing strategies for data migration projects, ensuring seamless transition and integrity of PPO business data. Gathered, analyzed, and documented change request business requirements, contributing to the creation of detailed regression test strategies. Employed advanced data consolidation, editing, and normalization techniques to reinforce data quality. Validated and enhanced the quality of data by executing and refining SQL scripts and queries. Performed thorough integration and regression testing to ensure comprehensive coverage and data accuracy.

Played a pivotal role in maintaining data quality and integrity during the migration of the PPO business to NASCO.

Optimized ETL testing processes, decreasing testing duration by utilizing third-party software.

Assisted team in delivering complex data migration projects on time, demonstrating strong collaboration and proficiency.

Designed and maintained crosswalk files to uphold precise data attribution for providers and organizations.

Ensured strict adherence to HIPAA standards to maintain the security and confidentiality of patient data.

Kepro

Sr. ETL QA Data Analyst February 2023 — September 2023

Orchestrated the Medicaid and Medicare HIPPA data migration project, ensuring secure and accurate transfer of medical provider and member information. Managed meticulous documentation of test case outcomes in the tracking system for audit-ready quality assurance. Collaborated closely with the Scrum team to address project aspects promptly and efficiently.

Maintained comprehensive test case documentation, facilitating quality assurance and compliance.

Developed and executed test cases derived from Jira stories to validate the ETL process, ensuring data integrity from source to target.

Streamlined the ETL process by reviewing and verifying mapping documents for accurate data integration.

Executed Informatica workflows with Active Batch in compliance with business mapping guidelines and performed SQL script queries on MS SQL Server to confirm data accuracy.

Fostered team collaboration, contributing to the timely achievement of project milestones.

Bank of America

ETL Automation Specialist September 2022 — January 2023

Enhanced economic scenario data governance through strategic migration and upgrade of the database, ensuring optimized diagnostic and reporting capabilities. Designed and executed test scenarios, precisely tracking results in the qTest management system. Prepared and maintained SIT environments for Autosys job execution, demonstrating proficiency in SQL script queries to validate data quality.

Streamlined test case execution and analysis based on Jira stories, improving testing efficiency and accuracy.

Ensured the integrity of data migration and ETL processes through comprehensive validation and quality checks.

Achieved certification in TOSCA within a 3-month self-driven project, poised to apply skills in future automation tasks.

Facilitated effective communication and coordination between offshore and inshore teams, enhancing project workflow.

Mindtree

ETL, DQ Automation Engineer December 2021 — August 2022

Managed end-to-end data validation and transfer processes for the Snowflake project, ensuring accuracy and integrity throughout the data lifecycle. Developed comprehensive plans detailing data flow and lifecycle management, and oversaw Data Warehouse Implementation and Data Migration tasks including validation, clean-up, and mapping. Conducted rigorous data quality testing to maintain high standards of architecture and integration capabilities, providing expert technical assistance in database management and integration solutions.

Mastered new technologies, including Databricks and Snowflake, to enhance project delivery and data handling capabilities.

Played a pivotal role in on-time project deliveries, demonstrating strong collaboration and technical proficiency.

Contributed to the successful implementation of the Snowflake project, ensuring seamless data transfers and quality assurance.

Streamlined data validation processes, optimizing data lifecycle management for GreenSky.com.

Provided critical technical support, improving integration capabilities and database management systems.

Inspire Brands

ETL QA Engineer May 2021 — November 2021

Developed and institutionalized formal QA processes, ensuring adherence to industry best practices within the team.

Assisted in delivering projects on time, contributing to team efficiency and project success.

Validated and reconciled data from various sources, ensuring accuracy and consistency in reporting.

Analyzed and reviewed data ingestion results in Azure Databricks, enhancing data quality and reliability.

Examined ER Data pipeline schemas, maintaining data structure integrity and standards.

Zelis

ETL Test Lead Nov 2020— April 2021

Tested ETL SSIS packages utilizing Microsoft Visual Studio and Management Studio.

Used analytic tools such as SSRS and Tableau reports for data analysis.

Prepared the source to target mapping specification.

Responsible for maintaining Test Reports and Defect Metrics.

Developed and validated SQL scripts for both ETL and EDW testing.

Optum

Sr. ETL Data MDM Analyst Aug 2020— Nov 2020

Tested ETL SSIS packages utilizing Microsoft Visual Studio and Management Studio.

Used analytic tools such as SSRS and Tableau reports for data analysis.

Prepared the source to target mapping specification.

Responsible for maintaining Test Reports and Defect Metrics.

Developed and validated SQL scripts for both ETL and EDW testing.

Transamerica

Sr. QA EDL Data Analyst Feb 2020— May 2020

Recruited to assess and examine complex data and turn it into information and insight to inform business decisions.

Monitored performance and quality control plan to identify any issues to improve systems and database designs.

Collaborated with cross-functional project teams, including MS SSIS ETL development and data quality assurance.

Maintained documentation of data governance procedures, policies, and compliance.

ADDITIONAL EXPERIENCE

Senior Backend Quality Assurance Tester - Northwell Health - May 2019 — November 2019

ETL QA Engineer - Remedy Partners - September 2018 — May 2019

Senior QA Analyst - Cox Automotive, Inc./Dealertrack - December 2014 — August 2018

Senior Quality Assurance Analyst - Oppenheimer Funds - August 2007 — October 2014

EDUCATION

Master Degree in Engineering

Polytechnic University, Russia

Certificate Program, Technical Invention Methodologist Certificate

Institute of Invention, Russia

Computer Science Studies

SYRIT College

LICENSES & CERTIFICATIONS

Tricentis Tosca Automation Specialist Level 1

Tricentis Tosca Automation Specialist Level 2

Writing SQL Queries Certificate, Tree International Learning

Advanced Data Warehouse Testing using SQL, Real-Time Technology Solutions, Inc.

Data Warehouse and ETL Testing Fundamentals, Real-Time Technology Solutions, Inc.

Data Warehouse Testing using SQL Certificate, Real-Time Technology Solutions, Inc.

ADDITIONAL SKILLS

Excellent problem-solving and analytical skills.

Strong communication and interpersonal abilities, facilitating effective collaboration.

Proven ability to adapt to rapidly changing technologies and work in fast-paced environments.

Detail-oriented with a focus on delivering high-quality results.

Continuous learner, actively seeking professional development opportunities.

Contact this candidate