Home

Albert Yakhnin - ETL TESTER | ETL QA ANALYST

[email protected]

Location: Brooklyn, New York, USA

Relocation: no

Visa: usc

Albert Yakhnin Sr. ETL Analyst/Data Analyst [email protected] 917-470-2952 www.linkedin.com/in/albertyakhnin/ Brooklyn, NY, 11214 Accomplished Sr. ETL Analyst/Data Analyst with over two decades of experience in the IT domain, offering a wealth of expertise in ETL testing, data quality assurance, and collaborative project delivery. Proficient in developing end-to-end 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. Committed to professional development, as evidenced by the swift acquisition of new technology proficiencies and relevant certifications. Eager to leverage a strong track record of success and a deep understanding of industry requirements in a Senior ETL Analyst/Data Analyst role, focusing on 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, 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, HP Quality Center, 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 Career Experience Blue Cross Blue Shield of Michigan Sr. ETL Analyst/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 meticulous 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. Optimized 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. Played a pivotal role in maintaining data quality and integrity during the migration of the PPO business to NASCO. 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. 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. 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. Played a pivotal role in the successful implementation of a state-level data migration project. Fostered team collaboration, contributing to the timely achievement of project milestones. 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. Bank of America Sr. ETL Automation Specialist September 2022 December 2022 Enhanced economic scenario data governance through strategic migration and upgrade of the database, ensuring optimized diagnostic and reporting capabilities. Designed and executed test scenarios, meticulously 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. Diligently reviewed ETL mapping documents to verify successful data transfer from source to target, facilitating seamless collaboration with offshore and inshore teams. Achieved certification in TOSCA within a 3-month self-driven project, poised to apply skills in future automation tasks. 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 thorough validation and quality checks. 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. Additional Experience ETL Test Lead - Zelis - November 2020 April 2021 Sr. ETL Data MDM Analyst - Optum - August 2020 November 2020 Sr. QA ETL Data Analyst - Transamerica - February 2020 May 2020 Sr. ETL QA - Global Innovation Consulting - November 2019 February 2020 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 Bachelor of Engineering Technical Invention Methodologist Institute of Invention 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. Keywords: quality analyst user experience business intelligence information technology hewlett packard microsoft procedural language New York