SUMMARY

• Having 7 years of experience in Test Management, Test Planning, Web Application Testing, Data Warehouse testing using Informatica, PL/SQL and Reports testing, strong strategic vision and demonstrated ability to inspire/mentor QA teams, negotiating and communication skills.
• Perform End - to-End test planning, test execution and reporting activities for multiple testing projects (both Agile and Waterfall)
• Expertise in understanding and reviewing the Business Requirement Document (BRD), Functional Specification Document (FSD), Data Model, Source-to-target mapping document (STTM)
• Extensive experience in writing and maintaining extensive test strategies, plans, cases and scripts
• 3+ years of experience in migration projects ETL testing, DWH Business Objects report testing and Database testing
• 2+ years of experience in testing API calls manually using Postman tool for HTTP methods such as GET/POST
• Experience on web services tools Rest API and understanding of HTTP code responses
• Experience using query tools for Oracle and MS SQL Server to validate reports and troubleshoot data quality issues.
• 2 years of working experience in Project management functioning tool JIRA for bug tracking, issue tracking and stories/task management
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and validation of fixed bugs
• Having flexibility in working with Data Warehousing tools expertise in writing the SQL statements
• Good understanding and exposure on data warehousing architecture/concepts and ETL Concepts
• Good experience in different Databases like Teradata, SQL Server, BODS, SSRS Reports
• Expertise on testing Front end reports/dashboards like Tableau reports & Power BI Reports
• Experience in defect management tool HP ALM/Quality Center, test case design, test execution and test reports
• Good knowledge on Informatica, Hive, Sqoop, HBase and PIG for big data testing
• Good knowledge on Dimensional Data Modeling like Star Schema, Snow-flake Schema and fact tables
• Self-motivated, excellent communication skills, detail oriented, confident, quick learner
• Worked on Agile development methodologies and hands-on experience in Functional and Non-Functional testing
• Business Process Re-engineering, Total quality management, ISO /CMMI Level 5 / Six Sigma certified
• Effectively involved in communicating with managers and offshore- onsite teams

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Java

ETL Tools: Informatica, BODS

Hadoop Ecosystems: HDFS, Hive, Pig, SQOOP, OOZIE

No SQL: Databases Hbase

Databases: Oracle, SQL Server, Teradata14, MySQL, Toad

Test Management Tools: HP Quality Center / HP ALM and Jira

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Quality Analyst

Responsibilities:

• Analyze business requirements, user stories and design and develop detailed test cases
• Collaborate with product/business process team and application developers to ensure all features of the project are integrated and reviewed
• Develop and execute functional/system test cases to ensure product meets functional and design specifications.
• Creating test plans for functional E2E testing of new Releases, Enhancements and Fixes
• Prepare Test Strategy, Test Plan and Test Closure Reports for the project
• Execute test suite developed for the iteration and capture execution logs and test evidences in Jira
• Generated detailed execution report and publish in Confluence
• Involved in Root Cause Analysis and enhance test suite to increase test coverage
• Prepare and maintain Requirements Traceability Matrix and ensure that the new requirements do not contradict existing system logic
• Performed manual testing on API Calls by using HTTP methods like Get and Post calls and validated response codes using Postman tool.
• Performed back-end testing to ensure data consistency on front end
• Prioritized test cases based on criticality/complexity/coverage and merged few test cases to save the test effort since there were many builds planned during the closure of the project.
• Organized formal test case review sessions with project team and incorporated feedback to ensure that the project requirements are being captured correctly prior to test execution.
• Extensively executed SQL queries in order to view successful transactions of data
• Escalated showstopper/blocker issues and cooperated with the developers to fix the bugs early by providing detailed inputs to avoid delays/stoppage in the plan.
• Performed different checks like row count, duplicate, null, table structure, data validation based on the data mapping report provided
• Developed Root Cause Analysis for all the defects identified during UAT
• Publish weekly status report of testing progress and defects to all Stakeholders
• Create and manage defects in the Jira and track them to closure
• In Agile deliveries, participate in daily meetings and scrum ceremonies and take ownership of test activities

Environment: Java, Oracle, Oracle SQL Developer, Jira, Confluence and Windows OS

Confidential

Senior Consultant

Responsibilities:

• Analyze business requirements, user stories and design and develop test cases
• Responsible for reviewing of test plans for team members to ensure high quality deliverables
• Creating test plan, test scenarios, test cases and test scripts based on functional requirements
• Verifying the data flow in different stages like Source to staging, EDW, Semantic, SSAS Cubes and power BI reports
• Performed different checks like row count, duplicate, null, table structure, data validation based on the data mapping report provided
• Execute functional/system test cases to ensure product meets functional and design specifications
• Experience in testing XML files and validating the data loaded to staging tables.
• Extensively executed SQL queries in order to view successful transactions of data
• Performing Root Cause Analysis of the failed test cases and provides related data samples to client.
• Defect tracking knowledge and deep understanding of various defect metrics
• Track QA schedule and report on daily basis
• Preparing and supporting QA and UAT test environments.
• Leading the testing team and reporting test activities to manager
• Strong decision-making, interpersonal skills with excellent verbal and written communication skills
• Submit the daily/weekly test status and summary reports

Confidential

Consultant

Responsibilities:

• Analyze business requirements, user stories and design and develop test cases
• Create test scenarios, test cases and test scripts based on functional requirements
• Verifying the data flow in different stages like Source to staging, EDW, Semantic, SSAS Cubes and power BI reports
• Performed different checks like row count, duplicate, null, table structure, data validation based on the data mapping report provided
• Tested ETL process to ensure before data and after data validation process
• Tested the messages published by ETL tool and data loaded into various databases
• Execute functional/system test cases to ensure product meets functional and design specifications
• Involved in end to end testing activities along with the team
• Performs functional and regression testing in support of quality
• Extensively tested SSAS Cubes and reports testing
• Communicating test status and progress clearly to all stakeholders