SUMMARY:

• 13 years of Software QA experience in Banking, Finance, HealthCare Insurance & e - Governance projects
• Hands-on experience in ETL (MDS & EDW on Azure), BI & Data Migration Testing
• Expertise in the usage of DataStage and SSIS packages and in their troubleshooting
• Developed complex SQL queries as part of ETL/BI validations like Daily/Delta loads, data aggregations, and duplicate/null/truncation checks
• Hands-on experience in SSMS, TOAD, SQL-Developer, Hive, & Impala
• Hands-on experience in QTP, ALM, & Visual Studio/TFS
• Strong knowledge in SDLC & STLC and proficient with Agile Methodology
• As a Scrum Master, facilitated Daily Stand-ups, Story Grooming, Sprint backlog & Retrospective sessions
• Hands-on experience in designing and executing Test Plan & Test Cases
• Knowledge of designing and coordinating the implementation of software test environment
• Well-versed in Test Estimates and metrics generation like DRE, Cost of Quality, and Rework percentage
• Self-motivated and quick learner of new concepts and techniques with effective communication

TECHNICAL SKILLS:

Operating System: Windows 10,7, & Linux

Cloud Integration: Microsoft Azure, & Bigdata HDFS

Testing Tools: HP UFT11.5, & HP ALM 11

ETL Tools: IBM InfoSphere DataStage 8.0, & SSIS

Programming: : PL/SQL, VB Macros & Linux commands

Utility Tools: Toad for Oracle/SQL 12.0, SSMS, Visual Studio tools, HUE (Hive/Impala/Oozie), Tectia & Putty

RDBMS: MS SQL Server and Oracle 11g

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

QA Lead

Responsibilities:

• Testing data flows using querying tools like TOAD, SQL Developer, & HUE and evaluating corresponding Bigdata HDFS files using Hive, Impala, & Putty scripts
• Triggering Autosys and DataStage Jobs that loads data into Data Lake. And monitoring logs, & workflows using Oozie Editor (/workflow dashboard)
• Reviewing Sqoop & Spark actions, Validating Transformation logic & Rule engine alerts to ensure proper sourcing of data into Big Data
• Involved in reviewing Test Plans which included test deliverables, features to be tested/not tested based on BRD & Acceptance Criteria
• Involved in Creating the Business Assurance Strategy, Test Strategy & Test Completion Documents
• Created Test Cases according to the Business requirements and ensured that all the positive and negative scenarios are covered

Confidential

QA Lead

Responsibilities:

• Scrum Master - Facilitating Stand-ups, Sprint reviews, Story grooming sessions & Retrospectives
• Test Lead - Design Test Plan and Assigning Tasks to team members to ensure everyone has sufficient work throughout the sprints
• Managing sprints with the help of Rally tool by updating user stories and tasks
• Involving in Test estimation and impact analysis
• Performing validations like Data comparison / record count / Schema / Null & Duplicate checks at different stages like source to staging to target to BI apps
• Preparation of SQL scripts for ETL, & BI Testing to validate daily/delta loads specially to check for transformation logic, data truncation, & duplicates
• Performing compatibility testing on EDW & MDS servers and their upstream applications whenever there is an upgrade in Microsoft Azure
• Coordinating with Developers, Business Analysts and offshore testing team
• Involved in Test Environment setup with all hardware and software needs
• Preparation of Traceability Matrix and updating the metrics dashboard at the end of each sprint

Confidential

ETL Test Lead & Scrum Master

Responsibilities:

• Throughout the project in various iterations & Sprints I conducted System Integration Testing
• Built complex SQL queries to validate transformation logic, & aggregations
• Prepared Test Plan and Testing Strategies for Data Warehousing system CBRM
• Extensively interacted with developers, & Business Analysts to understand requirements
• Involved in writing test cases in Quality Center 9.0 and 11.0(ALM)
• Validated complex ETL mappings, metadata and reusable transformations for daily & delta loads.
• Extracted data from various sources like Oracle, flat files, iSeries and DB2 servers using DataStage / SQL jobs and written SQL queries for the same as part of validations.
• Involved in validation of upstream applications like Dashboards and Cognos Reports
• Participated in Story grooming & Retrospective sessions, and in project status meetings
• Prepared QA Sign-off Reports with details of test execution, test coverage and defect summary.

Confidential

Sr.QA Analyst & Salesforce Admin/QA

Responsibilities:

• Worked on Security settings like Profiles, Permission Sets, OWD, Sharing rules
• Validated Workflow Rules, Upload Process, Process Builder, and Assignment & Escalation rules
• Reviewed Test Case documents designed by test analysts
• Coordinated with Developers, Business Analysts and offshore testing team
• Authored SQL scripts to validate transformation logics & aggregations and to cover the scenarios like checking duplicates, null values, truncated values
• Involved in Test Environment setup with all hardware and software needs
• Validated data loaded by Data Loader jobs in Salesforce
• Prepared Test Data using SQL scripts based on Metadata & design docs

Confidential

QA Analyst

Responsibilities:

• Developed test cases based on test matrix including test data preparation for Data Transformations, Data quality, Performance and scalability.
• Developed SQL queries /scripts to validate duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed Count Validation, Schema and Transactional Data Quality Validation with extensive SQL querying on Staging, Data warehouse and Data Marts.
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Confidential

Sr. QA Analyst

Responsibilities:

• Developed SQL Queries/Scripts to validate Data migration scenarios (from MS Access and flat files to SQL Server2005)
• Developed Test Cases and SQL Queries to perform Data upgradation scenarios (from SQL Server 2005 to SQL Server 2008)
• Authored and reviewed Test Cases based on the Use Case documents
• Involved in Test estimation and impact analysis; Managed Defect Reporting & Status
• Attended HLD/LLD walkthroughs for thorough understanding of business requirements

Confidential

QA Analyst

Responsibilities:

• Authored and reviewed Test Plan and Test Cases
• Involved in writing complex SQL scripts to validate various stages and sub reports of Funnel
• Defect Management - Reporting bugs and tracking till its closure
• Attending HLD/LLD walkthroughs for thorough understanding of business requirements