Focus of Interest: ETL QA Tester ETL QA Data Analyst
Accomplished and results-driven Sr. Technical Quality Assurance professional with over 20 years of experience in IT quality assurance, involving analysis, both manual and automation testing of client server and web applications. Proven expertise in ETL/ Data warehouse back end testing and BI Intelligence reports testing with strong knowledge of Software Test Life Cycle, including feasibility requirements analysis, design, testing, implementation, and support. Demonstrated ability to validate the completeness, integrity, and accuracy of data. Hands-on team player with outstanding communication, interpersonal, analytical, and problem-solving skills, and ability to work independently and deliver work on time.
Summary of Qualification
●Over 15 years of real time experience testing web based, ETL applications.
●IT Professional progressive experience in analyzing, designing, developing, testing, and managing information technology projects.
●Develop and document test scripts, test cases, defect tracking and reports.
●Analyze the results of software tests and provide results for use in development code inspections and group reviews of project deliverables.
●Documentation and maintenance of test suites.
●Analyzed business requirements, software requirement specifications to create test plans and test cases for manual and automated testing.
●Experience in different types of testing: Black Box Testing, White Box Testing, Functional Testing, Integration Testing, UAT, and Regression Testing.
●Developed and maintained automated test scripts.
●Manage test environment for integration testing activities.
●Extensive experience in writing SQL to validate the database systems and for backend ETL testing.
●Testing, Initial and Incremental ETL, data loads.
●Experience tested various BI reports using SQL.
●Proficient in working with UNIX platform.
●Reporting End of the Day Report to the Project Managers.
●Provide post-implementation support for all deliverables.
ETL Logic Validation
SQL Script Development
ETL Test Solution Automation
Software Test Life Cycle (STLC)
SQA, Testing and Methods
Development Methodologies: Agile, Scrum, Waterfall, Iterative
Operating System: Mac OS/, Windows, Sun Solaris, HP-UX, IBM AIX
ETL Tools: MS SSIS, Pentaho Data Integrator, Informatica PowerCenter, DVO, Centerprise Data Integrator
BI Tools: Tableau, MS SSRS, Cognos
Office Tools: MS Office Suite, MS Project, Microsoft SharePoint, Adobe Products
Testing Tools: SQL Workbench / J MySQL Workbench, SQLDBX, Compare It, Redgate SQL Data, SQL Server Management Studio, DBeaver, FuseIT, SFDC Explorer, AQT Advanced Query Tool, Aqua Data Studio, FlySpeed SQL, Diffpdf, dbForge
Defect and Management Tool: JIRA, HP Quality Center, JAMA ALM, QMetry
Scheduling Tools: Autosys
Languages: T-SQL, PL-SQL, HTML, UML, Korn Shell, XML
RDBMS: AWS Redshirt, MySQL, MS-SQL, Oracle, DB2, Sybase, MS Access
Sr. ETL Data MDM Analyst Optum, Eden Prairie, MN August 2020 – Present
Identify and formally resolve data quality and matching issues within the Master Data Management environment.
Conduct data profiling when on boarding new data sources by using Informatica Analyst.
Review and analyst functional and design specifications documents.
Test ETL Informatica Power Center workflows. and SSIS packages.
Use analytic tools such as SSRS and Tableau reports for data analysis.
Preparing the source to target mapping specification.
Identify test requirements from design document and mapping documents
Involve in test planning, writing test cases/scripts, creating reusable test data, test case automation, and test execution
Execute manual and automated functional test cases.
Review of data sets for quality issues, duplicates, merge possibilities and uniqueness.
Maintain documentation of data governance procedures, policies, and compliance.
Sr. QA ETL Data Analyst Transamerica, Harrison, NY 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 architect, Functional team to build and maintain the imperative plans and methods to a variety of analyses.
Assisted with benchmarking KPIs and contributed in improving delivery and processes.
Collaborate with cross-functional project teams, including MS SSIS ETL development and data quality assurance.
Coordinate with team members/support teams effectively to diagnose and determine results.
Maintain documentation of data governance procedures, policies, and compliance.
Sr. ETL QA Global Innovation Consulting, Brooklyn, NY 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 data, back end database validation, and BI visualization. Analyzed mapping inbound HL7 messages to hospital’s EHR Systems.
Worked with EHR information on authorized providers in a digital format to enable sharing information with other providers across various healthcare organizations.
Monitored Allscripts Sunrise form results connecting all clinical and financial aspects of a hospital or health system for inpatient, emergency, and outpatient care.
Senior Backend Quality Assurance Tester Northwell Health, New Hyde Park, NY 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 functional requirements to assure that requirements are testable.
Worked with Claims, enrollment, eligibility verification for members and providers, benefits setup and back-end payment cycle.
Good knowledge of Health Insurance Plans and experience in determining the membership eligibility, billing experience within life and disability in health plans with thorough understanding of CPT coding.
Developed Test Plan, UAT test strategy, Test Scenarios, Test Scripts, UAT Test Scripts and Test Reports.
Worked as Quality Assurance Tester for All Scripts, a health care provider.
Reported data inconsistency or errors on the functional specifications to the Business Analyst.
Translated the business functional requirements into high-level test scenarios with test opinion, created a test plan, and provided test estimates to QA Manager for project scheduling purposes.
Promoted detailed test cases using HP Quality Center Software, ensuring that tests include all features of the system, and the whole test-to-requirement coverage.
Conducted various types of QA software testing, including manual functional, web usability, system integration, cross-browser compatibility, HIPAA compliance, back end database validation, and mobile application testing.
Recorded software issues with HP Quality Center and support development with brief and accurate steps for duplication of issues found.
ETL QA Engineer Remedy Partners, Inc., New York, NY Sept 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.
Analyzed test case scenarios for Care Spot, health care services, including: o Electronic medical records (EMR) and practice management systems.
Created test data pipelines into cloud AWS and Glue.
Wrote SQL queries manually and also built SQL queries using SQLDBX to validate the Customers ' addresses and accounts level data.
Worked in Amazon AWS Lambda, Amazon Simple Queue Service (Amazon SQS) environment
Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
Debugged the SQL-Statements and stored procedures for various business scenarios and performed extensive Data Validation, Data Verification against Data Warehouse.
Loaded Flat File Data into Teradata tables using Unix Shell scripts, used HP Quality Center to upload all test cases in Test plan and Test lab modules, and tested several AWS Redshift Mappings to validate the business conditions.
Senior QA Analyst Cox Automotive, Inc./Dealertrack, New Hyde Park, NY Dec 2014 – Aug 2018
Involved in the data cleansing project for Cox Automotive Marketing Department by using Centerprise Data Integrator. 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.
Consistently ensured all test case standards are met in all test cases included in the regression suite.
Created test beds and seed test data using (SQL), or by other means based on the environment, to ensure complete coverage of business requirements, functional and technical specifications are met.
Developed complex SQL scripts that validate business requirements and source to target mapping within the data warehouse.
Ensured all software products, applications and data met the highest possible quality standards by following industry recognized QA methodologies and best practices.
Performed extensive ETL testing using MS SSIS and adhering to testing requirements developed at ETL and BI tools while reviewing scripts for positive and negative test scenarios, then preparing test summary reports.
Senior Quality Assurance Analyst Oppenheimer Funds, New York, NY Aug 1999 – Oct 2014
Hired to perform Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values. Worked with Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor. Validated the data moving from multiple sources to target using Informatica data validation option. Ran workflow used Informatica Workflow Manager.
Extensively used Informatica for extraction, transformation and loading process.
Managed software quality assurance and testing in a wide variety of projects and environments. Integrated knowledge and working experience with test planning, test execution and test results analysis based on Business Requirements.
Discussed test cases for regression testing with quality engineers for each build and validated and executed ETL jobs scheduled in Autosys.
Wrote SQL queries to validate the ETL logic of the application. Updated and modified UNIX kornsell scripts consumed by various processes of the ETL process.
Analyzed various documents and prepared test cases covering all requirements of the application deliverables.
Education and Certifications
Bachelor’s Degree of Engineering, Polytechnic University, Russia
Invention Methodology Certificate, Institute of Invention, Russia
Computer Science Studies, SYRIT College
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.