SUMMARY

• A self - motivated Business Intelligence (BI), ETL & Data-Warehouse Test Analyst having 7.5 years of experience in the field of Data, BI and Analytics that include: requirement analysis & documentation, testing software including web and mobile applications, data warehouse & ETL testing, OLAP Cubes, dashboards & analytical reports testing, designing and implementing end to test plans, data verification & validation, automated testing of complex business logics, data ingestion using AWS technologies.
• Good understanding and experience of working in agile scrum methodology and understanding of BI, Data, ETL&DWH domain.
• Requirement analysis and data analysis of complex and large systems.
• Designing and developing automated test scripts for Data, ETL and DWH testing by using SQL.
• Extract definitions testing written in SQL to extract data from source application as part of ETL.
• Structural Testing, Data Completeness, Data Integrity, Referential Integrity, Extract Files, Complex Business Transformation Rules verification.
• Identifying test data requirements and mocking up data to create specific business scenarios.
• Dashboards and Analytical Reports Testing with different BI Tools (Data Quality, Look & Feel of reports).
• Operational reports testing (SQL and DB2 scripts).
• Analysis Cubes Testing including calculated measures, dimensions/hierarchal dimensions, KPI’s.
• Web based applications testing.
• Root cause analysis of defects and identifying resolutions (Debugging stored procedures, SQL scripts).
• Automated testing of AWS data ingestion framework that extracts data from various source systems (DB, txt, CSV files) and store the data into AWS s3 buckets for further downstream usage.
• Testing of ETL batch execution, scheduling and alerts and monitoring.
• Automated testing of source to target mappings for data extraction and complex transformation logics.
• Works as an independent QA resource thus leading and managing all testing plans, regression plans and test activities.
• Planning, designing, developing, and implementing comprehensive QA test plans, End to End test strategy, regression plans, positive & negative test cases.
• Preparing test evidence, test summary and test closure reports.
• Actively taking part in all scrum meeting on daily basis within onshore and offshore team, project planning, sprint planning, sprint reviews & retro, refining backlogs/acceptance criteria and providing test estimations.
• Planning and executing all types of testing including Functional &UI testing, End to End Integration Testing, Sanity Testing, Regression Testing and UAT & PVT.
• Daily based communication and working with Project Managers (OffShore/OnShore), Product owner, BA, QA and Dev team to ensure all project and testing related activities are running smoothly, business requirements are met, and defects have been resolved.
• Mentoring and Training new joiners.
• Strong concepts of SDLC, STLC, Defect management and agile, scrum processes.
• Good problem solving and analytical skills.
• Research experience in the field of big data and analytics: scrapping, cleaning, manipulating and visualization data using R.
• Expertise in Version One, Team Foundation Server and Jira Reporting Tools.
• Proficient in all Microsoft Office Suite, namely Word, PowerPoint and Excel.
• Strong communication skills both oral and written.

TECHNICAL SKILLS

Programming Languages: HTML/CSS, C/C++, SQL, R, Python.

Tools: & Technologies: SQL Server Management Studio, Toad for DB2, MS BI Stack (SSIS, SSAS, SSRS), Informatica ETL, OLAP, RDBMS, Aginity workbench for Redshift, PostgreSQL (pgAdmin), Oracle SQL Dev, AWS cloud technologies, DynamoDB, EMR for spark, Control-M, Airflow, Microsoft Visual Studio/Management Studio, Power BI, Tableau, VersionOne, Jira, TFS.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Test Analyst

Responsibilities:

• Automated testing of data ingestion framework that extracts the data from various line of business applications (SQL DBs, Flat files, txt, CSV) and ingest the data into AWS s3 buckets.
• Incremental load testing of data ingestion built within spark framework as change data capture was not enabled in source systems.
• Fully automated testing of business rules engine that holds complex business rules against various source systems. Business rules identifies customers that are eligible for different types of membership and when to cease the membership of existing members.
• Testing of exception capturing framework that filters out any record that does not satisfy different data quality checks configured within rules engine.
• Automated testing of member register, built on top of rules engine. Spark jobs that consume the data from rules engine result set, performs additional business logics and identified members are inserted/updated in member register ICDB and DynamoDB tables.
• Running batch jobs via command line/EMR for spark, testing ETL batch execution, scheduling and alerts and monitoring via Airflow/Control M/Talent.
• Performing different types of testing, functional, regression, UAT and PVT.
• Developing and implementing end to end test strategy of these complex data ingestion, rules engine and member register systems.
• Designing, Developing and Implementing Comprehensive QA test plans & positive/negative test cases, writing test evidence documents, generating test summary and closure reports.

Confidential

Senior BI, ETL & DWH Test Analyst

Responsibilities:

• ETL & Data warehouse Testing: Data Verification & Validation from Source ->Extracts->Staging->Fact & Dimension till the BI reports thus assuring extracted data meets the business requirements.
• Performing all type of testing using SQL including Structural Testing, Data Completeness, Data Integrity, Referential Integrity, and Business Transformation Rules verification.
• ETL Testing: Source to target data matching, duplicates validation, Data mapping validation thus making sure all business transformation rules are met.
• BI Reports Testing built on Power BI tool.
• End to End testing of reports by generating test scenarios in BlueDoor tool (source application for superannuation business).
• Designing and developing automated test scripts for ETL and DWH testing.
• Designing, Developing and Implementing Comprehensive QA test plans & positive/negative test cases, generating test summary and closure reports.

Confidential

BI, ETL & DWH Test Analyst

Responsibilities:

• Data warehouse testing in Oracle SQL Developer (Performing all type of testing including Structural Testing, Data Completeness, Data Integrity, Referential Integrity, Business Transformation Rules verification).
• ETL Testing: XML and JSON source files in AWS S3 buckets to Redshift Staging to Oracle data warehouse in SQL developer.
• AWS Athena tables and views testing.
• Performing all aspects of verification including Sanity, Integration, Functional, Regression, UAT and PVT testing.
• Testing ETL batch scheduling with Control M and Talend ETL jobs.
• Monitoring batch logs, testing rejected record logs within PostgreSQL.
• Testing Json and XML File load into staging tables (Data quality, data completeness, data integrity verification)
• Designing, Developing and Implementing Comprehensive QA test plans, test cases and test evidence using Jira.
• Liaising with Project Managers, BA and Dev team to ensure all business requirements are met and defects have been resolved on time.

Confidential

Senior BI, ETL&DWH Test Analyst

Responsibilities:

• ETL and Data Warehouse (star schema) Testing (SSIS, SSAS, SSRS), Data Verification & Validation from Source ->Extracts->Staging->Fact & Dimension till Application (Performing all type of testing including Structural Testing, Data Completeness, Data Integrity, Referential Integrity, Business Transformation Logics verification).
• Requirement analysis and software documentation.
• Analysis Cubes Testing including calculated measures, dimensions/hierarchal dimensions, KPI’s.
• ETL Testing: Source to target data matching, making sure all business transformation rules are met.
• “Mortgage Data Analytics” reports testing built on MicroStrategy BI tool, assuring reports data meets business requirements.
• “Mortgage Data Analytics” web application Testing.
• Designing, Developing and Implementing Comprehensive QA test plans & test cases.
• Liaising with Project Managers (OffShore/OnShore), BA and Dev team to ensure all business requirements are met and defects have been resolved on time.

Confidential

Senior BI, ETL&DWH Test Analyst

Responsibilities:

• Review and analyze business requirements.
• ETL & Data warehouse (star schema) Testing (SSIS, SSAS, SSRS): Data Verification & Validation from Source ->Extracts->Staging->Fact & Dimension->OLAP Cube, till the Application thus assuring extracted data meets the business requirements.
• Performing all type of testing using SQL (SQL server management studio) including Structural Testing, Data Completeness, Data Integrity, Referential Integrity, and Business Transformation Rules verification.
• Analysis Cubes Testing including calculated measures, dimensions/hierarchal dimensions, KPI’s.
• ETL Testing: Source to target data matching, discarded duplicates validation, auditing, making sure all business transformation rules are met.
• Dashboards and Analytical Reports Testing with different BI Tools (Data Quality, Look & Feel of reports).
• Operational reports testing (SQL and DB2 scripts).
• Android and Windows 8 Tablet Application Testing.
• “Insurer Analytics” web application testing (Silverlight/HTML5).
• Operational Reports Testing (both SQL and DB2 scripts) thus assuring reports are extracted desired data as per business requirements and look & feel of reports.
• Designing, Developing and Implementing Comprehensive QA test plans & positive/negative test cases, generating test summary and closure reports.
• Reporting Defects on Version One and creating Regression Plans on Version One and generating test execution reports.
• Test data generation for testing functional requirements.
• Testing of Extract Definitions written in SQL to extract data from source applications.
• Data Count Testing, Auditing and Verification of Primary-Foreign Key Relationship (ETL), testing stored procedures and views.
• SCD Types Testing in DWH tables.
• DWH full load and incremental load testing.
• Data Quality Check plus verifying its flow & transformation.
• Application DB & DataWarehouse Deployments using PowerShell Command.
• Root cause analysis of defects in reports, ETL & DW by debugging scripts, stored procedures, views and extract definitions and providing resolutions to developers.
• Performing all aspects of verification including Sanity, Integration, Functional, Regression, UAT testing.
• Release Deployment of Core and Config Releases on Server.
• Worked on Client-side project as an independent QA resource thus leading, managing all testing plans, regression plans and test activities.
• Daily based communication and working with Project Managers (OffShore/OnShore), Product owner, BA, QA and Dev team to ensure all project and testing related activities are running smoothly, business requirements are met, and defects have been resolved.
• Regular Interaction with Offshore team via WebEx & other Communicating Software’s thus implementing Agile & Scrum methodologies.