SR ETL DATA Analyst
Resume:
ALBERT YAKHNIN
Brooklyn, NY ***** 917-***-**** ad5voo@r.postjobfree.com LinkedIn Profile FOCUS OF INTEREST: ETL TESTER MANUAL QA ANALYST BACK-END MANUAL QA As a degreed ETL QA Tester with over 15 years of IT quality assurance expertise, I excel in analysis, manual, and automation testing. As a collaborative team player known for analytical problem-solving, I deliver high- quality work within deadlines. Proficient in AWS, SQL Server, SSIS, SSRS, SSAS, Pentaho, and Informatica, I specialize in ETL processes, data warehousing, migration, and officiating. Skilled in Power BI, Tableau, and Cognos, I conduct data analysis, profiling, and various testing methodologies including functional, regression, and system integration testing.
SUMMARY OF QUALIFICATION
● Over 15 years of real-time expertise testing ETL applications.
● Extensive IT professional background in analyzing, designing, developing, testing, and managing IT projects.
● Proficient in data-centric testing methodologies, including ETL testing, data quality testing, data migration testing, slowly changing dimension (SCD) testing, and reference data testing.
● Skilled in developing and documenting test scripts, test cases, defect tracking, and reports.
● Analyze business and software requirements to formulate test plans and cases for manual and automated testing.
● Well-versed in various types of testing, including Black Box, White Box, Functional, Integration, UAT, and Regression Testing.
● Proficient in crafting and maintaining automated test scripts.
● Proficient in designing and executing comprehensive ETL test cases and scenarios, ensuring data accuracy and integrity for Power BI reports and dashboards.
● Possess strong SQL skills for database validation and backend ETL testing.
● Experienced in evaluating BI reports using SQL.
● Competent on UNIX platform.
● Provide post-implementation support for all deliverables. CORE COMPETENCIES
Quality Assurance/Control
Data-centric testing
Business Requirements
Team Collaboration
Process Automation
Systems Integration
Regression Testing
Requirements Mapping
ETL Logic Validation
Data Warehousing/Analysis
SQL Script Development
Agile/Waterfall Methodology
ETL Test Solution Automation
Bug Tracking/Reporting
Software Test Life Cycle
(STLC)
SQA, Testing and Methods
Application Testing
Report/Defect Tracking
TECHNICAL SKILLS
Development Methodologies: Agile Kanban, Scrum, Waterfall, Iterative Automation tools: DVO, TOSCA DI, QuerySurge
Languages: Python, T-SQL, PL-SQL, HTML Korn Shell, XML ETL Tools: MS SSIS, Talend, Informatica Power Center, Pentaho Data Integrator RDBMS: Snowflake, Oracle, Azure Databricks, PostgreSQL, Redshift, MS SQL server, MySQL, DB2
BI Tools: Tableau, MS SSRS, Cognos, Power BI
Office Tools: MS Office Suite, MS Project, Microsoft SharePoint, Adobe Products Web Technologies: AWS services JSON, XML, HTML, JavaScript, and VBScript ALBERT YAKHNIN 917-470- 2952 • ad5voo@r.postjobfree.com Page 2 of 4
Testing Tools: Toad, SQL Server Management Studio, Dbever, Redgate SQL Data, Oracle SQL Developer, MySQL Workbench, dbForge, 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 EDUCATION AND CERTIFICATIONS
Master’s Degree in Engineering
Computer Science Studies, SYRIT College
Technical Invention Methodologist, Institute of Invention
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. PROFESSIONAL EXPERIENCE
Sr. ETL Analyst/Data Analyst Blue Cross Blue Shield of Michigan Sept 2023 – March 2024 Hired to Assist in end-to-end testing for the data migration of PPO business to NASCO.
Captured Change Request Business Requirements and crafted a precise Regression Test Strategy.
Created crosswalk files specific to provider or provider organizations' data attribution.
Adhered to HIPAA standards for secure patient data
Applied advanced techniques in data consolidation, editing, and normalization to guarantee data quality.
Execute SQL scripts queries to validate quality of the data.
Introduced an automated regression test, reducing the organization's release cycle time by 25% year over year.
Collaborated with cross-functional teams to define and implement testing strategies for Power BI projects, contributing to the delivery of insightful and actionable business intelligence. Sr. QA data Analyst Kepro Feb 2023 – Sept 2023
Employed to help with the state-level Medicaid and Medicare HIPPA data migration implementation project for medical providers and members.
Responsible for developing, executing, and interpreting test cases based on Jira stories.
Contributed innovative ideas that improved software quality by proposing process changes, which boosted throughput by 25% and reduced defect rates by 10%.
Proficient in executing Informatica workflows with Active Batch, adhering to business mapping guidelines.,
Skilled in running SQL script queries on MS SQL Server to validate data accuracy and consistency.
Review mapping document to ensure successful ETL process and accurate data injection from source to target.
Automated regression testing of software updates, cutting manual execution time by 15 % while improving accuracy.
Sr. ETL Automation Specialist Bank of America Sept 2022 – Dec 2022 Brought on board to aid in the rollout of an ESG (Economic Scenario Generation) endeavor, targeting the enhancement of economic scenario data governance. The core objective encompassed migrating and upgrading the database to optimize diagnostic procedures and reporting functionalities.
Designed and optimized 19 inline views and SQL queries in 30 days after joining the organization
Keep truck test cases results in qTest management system
Prepare SIT environment for Autosys jobs execution.
Execute SQL scripts queries to validate quality of the data.
Review Mapping document to ensure that ETL process was successful and that the data injection was correctly populated from source to target.
ALBERT YAKHNIN 917-470- 2952 • ad5voo@r.postjobfree.com Page 3 of 4
Communicate with offshore and inshore teams in a timely and professional manner. ETL, DQ Automation Engineer Mindtree Dec 2021 - Aug 2022
In charge of end-to-end data validation and data transfer to the Snowflake project for GreenSky.com.
Skilled in leveraging Talend for ETL testing, adept at identifying and resolving data discrepancies and enhancing overall system efficiency.
Conducted manual testing and SQL investigations across multiple teams.
Managed data quality analysis tasks for Data Warehouse projects, employing Talend for ETL testing.
Executed Talend workflows for sorting data extraction, cleansing, and transformation processes, seamlessly integrating with Airflow and Azure Data Factor.
ETL QA Engineer Inspire Brands May 2021 - Nov 2021
Build and developed formal QA processes, assuring that the team is using industry-accepted best practices.
Create and implement formal QA processes to ensure that the team follows industry best practices.
Data Validation/Data Reconciliation from numerous sources ware completed.
Examine data ingestion results according to the mapping requirements in the Azure Databricks cloud environment.
ER Data pipeline schemas were reviewed.
ETL / QA Lead Zelis Nov 2020 – April 2021
Established and evolve formal QA processes, ensuring that the team is using industry-accepted best practices.
Utilized Python data validation scripts to ensure the accuracy and integrity of datasets, streamlining QA processes and minimizing errors.
Tested ETL SSIS packages utilizing Microsoft Visual Studio and Management Studio.
Used analytic tools such as SSRS and Tableau reports for data analysis.
Cut annual development costs by $50K through building reusable SQL queries and data encapsulation.
Proficient ETL Tester skilled in utilizing Python for comprehensive data validation and error handling, ensuring data consistency and adherence to quality standards.
Developed and validated SQL scripts for both ETL and DW testing. Sr. ETL Data MDM Analyst Optum Aug 2020 – Nov 2020
Conduct data profiling when on boarding new data sources by using Informatica Analyst.
Review and analyze functional and design specifications documents.
Skilled in implementing MDM solutions to maintain data integrity across systems.
Involved in test planning, writing test cases/scripts, creating reusable test data, test case automation, and test execution.
Proficient ETL Data MDM Analyst specializing in data integration, transformation, and quality assurance.
Reviewed of data sets for quality issues, duplicates merge possibilities and uniqueness.
Identified and formally resolve data quality and matching issues within the Master Data Management environment. Sr. QA ETL Data Analyst Transamerica 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.
Worked closely with business, product owners, systems architects, Functional team to build and maintain the imperative plans and methods to a variety of analyses.
Collaborated with cross-functional project teams, including MS SSIS ETL development and data quality assurance.
Coordinated with team members/support teams effectively to diagnose and determine results.
Maintained documentation of data governance procedures, policies, and compliance ALBERT YAKHNIN 917-470- 2952 • ad5voo@r.postjobfree.com Page 4 of 4
EDI ETL QA Global Innovation Consulting Nov 2019 – Feb 2020 Responsible for collecting medical data for internal reporting systems by using BI SSIS, MS SQL for medical health care providers, working on cross-functional projects, including ETL development, HIPAA compliance.
Managed digital exchange of Electronic Health Record (EHR) data between authorized healthcare providers across organizations to enable secure sharing of patient information.
Demonstrated proficiency in ETL testing, leveraging Python for efficiency.
Experienced in thorough testing and validation of EDI data to ensure accuracy and compliance. Senior EDI Quality Assurance Tester Northwell Health May 2019 – Nov 2019 Worked with the internal Engineering, Design, and Product Management teams to determine the product and documentation requirements as well as the business context, and analyze EDI functional requirements to assure that requirements are testable.
Deep understanding of ETL processes and their integration with EDI standards.
Specialized in claims, enrollment, eligibility verification, and back-end payment cycle for health insurance plans.
Skilled in collaborating with cross-functional teams to understand business requirements and translate them into effective ETL test cases, ensuring alignment with EDI standards. ETL QA Engineer Remedy Partners Sep 2018 – May 2019 Hired to implement QA processes, including defect tracking, test case management, and automated testing strategies. Other duties included coordinating QA processes and activities across the teams, developing Test Plan, Test Design, Test Cases, and Test Script, conducting Test Execution, and Test Status Reporting, and performing Black Box, Manual, Functional, Regression, Integration, and System tests.
Implemented QA processes and coordinated activities across teams.
Conducted various tests including Black Box, Manual, Functional, Regression, Integration, and System tests.
Analyzed test case scenarios for Care Spot healthcare services and performed data validation using AWS and Glue. Senior QA Analyst Cox Automotive /Dealertrack Dec 2014 – Aug 2018 Responsible for developing test scripts for testing and implementing automated ETL test solutions for data warehouse while assisting them in the development of all testing-related documentation such as test cases/scripts and defect reports.
Led data cleansing projects and developed automated ETL test solutions for Cox Automotive Marketing.
Created test scripts, performed ETL testing using MS SSIS, and prepared test summary reports.
Oversee all aspects of quality assurance including establishing metrics and developing new tools and processes to ensure quality goals are met.
Senior Quality Assurance Analyst Oppenheimer Funds Aug 1999– Oct 2014
Managed quality assurance activities, developed test cases/scripts, and conducted extensive testing for Oppenheimer. Funds.
Skilled in overseeing the implementation and maintenance of MDM systems, guaranteeing efficient data governance and compliance with industry standards.
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