PROFESSIONAL SUMMARY:

• Over 9+Years of IT experience in the Software Quality Assurance, working as ETL tester testing in different environments and platforms.
• 3 years of experience in Data Warehouse applications testing using Teradata on multiple platforms.
• Experienced with ETL processes using Informatica Power Center
• Experience in Functionality testing, System testing, Ad - hoc testing, Regression testing and E2E testing.
• Estimating the QA timeline, resource allocation and tracking of efforts and issues.
• Worked in Agile Methodology using Version-One for tracking User Story Task and Activity.
• Designed Test Cases & Executed in HP-ALM with Defect Tracking
• Logged the Business Requirements in IBM Doors with the collaborative effort of Product Owners.
• Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents with Business & Product Owners.
• Prepare QA Documents including Requirements Tractability Metrics, Test Data, Test Result Metrics, and Defect Reports and Test Status Reports.
• Good expertise in using TOAD and Teradata Studio.
• Good Knowledge on Dimensional modeling, Star schema, extraction, transformation and loading (ETL) process.
• Excellent Knowledge in defect tracking and various reports and change request process.
• Experience with various test management tools such as Clear Quest &JIRA.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent experience with Data base testing and strong SQL skills - ORACLE
• Excellent analytical & Testing skills with problem-solving approach.

TECHNICAL SKILLS:

Testing Black: Box, White-Box

Testing Tools HP: ALM, Bugzilla

ETL Tools: Informatica Powercenter 9.1.0

Reporting Tools: Business Object, Tableau 10.1

Defect/Test: Management

Tools HP: QC, Clear Quest, Jira

Languages: SQL, Unix

Databases: Oracle 10g, Teradata 12

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Test Manager

Responsibilities:

• Developed Test Plan, Test Cases based on BRD and FRD, performed smoke test to decide credibility of the build in order to initiate the testing.
• Create Test design estimations timeline based on reviewed scope.
• Performed Manual testing and regression.
• Conducted Functional and Regression Tests and interacted with developers to fix defects and resolve.
• Extensively used HP-ALM for designing Test case & Execution & defect Tracking.
• Performed Functional, Integration, System, Regression, and UAT during the various phases of the application.
• Involved in preparation of test data to test the functionality of the Informatica mappings.
• Prepared agile test approach and test summary report for Release.
• Involved in Testing of complicated mapping components such as Joiner, Aggregator, Lookup transformations
• Developed complex SQL queries to test the database values for data integrity.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Closely worked with developers and System Engineers to nail down the technical problems.
• Reported the bugs, Emailed notifications to the developers using the HP-ALM.
• Flexible, resourceful, and self-motivated and can work as a team and independently too.

Environment: Tableau, HP-ALM, Oracle, Informatica, Agile, UNIX, Version One

Confidential

ETL Tester

Responsibilities:

• Developed Test Plan and Test Cases based on the Test Strategy Document and performed smoke test to decide credibility of the build
• Preparing Test data as per the requirements.
• Reviewing Test Plan, Test Cases, and Test data with the project team and finally with the Subject Matter Expert (Client team).
• Conducted Static, Functional and Regression Tests and interacted with developers to fix defects and resolve
• Assisted users with Test Case samples and other test deliverables before UAT during the various phases of the application.
• Developed complex SQL queries to test the database values for data integrity.
• Validating the Test data after Test execution, with Detail design document. Proper analysis to find the root cause behind any mismatch.
• Closely worked with developers and System Engineers to nail down the technical problems.
• Tracking Bugs and log it into the HP QC tool.

Environment: Informatica, HP-ALM, Oracle, Agile, UNIX, Version One

Confidential

Reporting Developer Lead

Responsibilities:

• MBVP (Merchant Business Visualization Platform) was about creating various dashboards using Tableau visualization tool for analytical reporting by business users from merchant relationship teams.
• Understanding Business stakeholders’ requirements for various kind of analytical reports
• Work on designing the Data Model for dashboards
• Collaborate with Informatica ETL development team to populate data into the fact and dimension tables
• Creating dashboards in Tableau using the tables populated by the ETL
• Work with end users during UAT and fix any bugs or enhancements reported by them

Environment: Informatica Power Centre 9.1.0, Tableau 10.1

Confidential

Software Quality Analyst Lead

Responsibilities:

• Leading a project team of 8 associates
• Writing Test Plan, Test Cases based on the Detail Design document provided by Developers.
• Preparing Test data as per the requirements.
• Reviewing Test Plan, Test Cases, and Test data with the project team and finally with the Subject Matter Expert (Client team).
• Validating the Test data after Test execution, with Detail design document. Proper analysis to find the root cause behind any mismatch.
• Tracking Bugs and log it into the HP QC tool.
• After all fixes, preparing UAT Spread sheet, Coordinating the UAT with business users and work with the developers to fix any bug.
• Uploading Test cases, Test Plan in HP ALM (Application Life Cycle Management).
• At the end of the testing we need to prepare Test Findings Report.
• Resource allocation - Deciding on resource allocation as per Work Order and complexity of various modules given for testing.

Environment: Informatica Power Centre 9.1.0, HP ALM, HP QC

Confidential

System Data Analyst

Responsibilities:

• Media research was all about reporting solution for iTunes online store first by analyzing the user requirement followed by generating the extract using business logic, validating the records and finally delivering to end users in accurate look and feel and the attachments in desired format.
• Responsible for translating business requirements to technical requirement by proper identification of the user requirement and the exact look and feel of the reports to be generated
• Involved in identifying the exact tables and columns to be fetched on basis of suitable conditions which needs extensive data and database analysis skills and experience on the business and application design
• Involved in development including DDL and DML operations for adhoc requests, Query optimization using explain plan and minimum resource, Usage of utilities to reduce response time
• Involved in shell scripting for huge report extract text file and HTML for inline sections and attachments of interim reporting
• Major responsibilities to ensure that all the reports being delivered will work efficiently and effectively and delivery in minimum time schedule for both regular and critical ad-hoc reports
• Automating the reporting solution for iTunes customer care dept. This project was about development of an UI portal to execute regular base reports instead of performing repetitive work manually.
• The UI portal was developed by a third-party vendor. We developed the back-end processing of that UI portal.
• Developed several procedures and macros for different types of regular reports
• Rigorous testing and validation of all the functionalities
• Ensure completion of the project within deadline

Environment: Teradata 12, Unix