PROFESSIONAL SUMMARY:

• Test lead with 13 years of experience in analyzing, planning, managing & delivering BI/ETL testing projects/programs with strong onsite/offshore coordination skills.
• Strong working experience in agile methodology and performing different roles (Scrum master/Product owner).
• Strong experience in build deployment/migration in UNIX.
• Analyze and query multiple, complex databases and systems to produce reports.
• Strong Experience in ETL Testing, DWH Testing & BI Testing.
• Strong Experience in SDLC.
• Strong database testing expertise and SQL Querying capabilities .
• Extensive ETL testing experience using Informatica.
• Experience in BI reporting testing using Business Objects and Micro strategy.
• ETL testing experience using Informatica 8/9 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Sound knowledge and exposure in working with the various relational databases like Oracle, Sybase and Netezza, Teradata.
• Good experience in working on scheduling Tool (Tidal).
• Strong experience in using test management tool HP Quality center.
• ISTQB (International Software Testing Qualifications Board) Certified Tester.
• Certified in NCFM (NSE’s Certification in Financial Markets) - Beginner’s Module.
• Certified in NCFM (NSE’s Certification in Financial Markets) - Derivative’s Module.
• Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel.
• Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.

TECHINICAL EXPERTISE:

Testing: ETL testing, BI Testing, DWH Testing.

Database: Oracle 9i,10g and Sybase,Sql server,Netezza,Teradata

Languages: C,C ++,SQL

Operating Systems: Windows, Unix

CM Tool: Visual Source Safe 2005,SVN Tortoise

BI Tools: BusinessObjects,Informatica,Toad,Proclarity,Microstrategy,syncsort

Defect Management Tool: HP Quality Center 9.2, HP ALM 11, Rally

Telnet/FTP Client: Putty,WinScp

ETL scheduling and monitoring tool: Cisco Tidal

PROFESSIONAL EXPERIENCE:

Confidential

Technical Test Lead

Charlotte, NC 

Environment: Teradata, Netezza, Micro strategy, Informatica, Sync sort

Responsibilities:

• Lead End to End ETL testing activities.
• Managing and mentoring of QA resources.
• Onsite/Offshore Co-ordination.
• Test code deployment/migration in UNIX environment using Putty & WinSCP.
• Test Plan Preparation.
• Database/Backend verification - executing basic and complex queries using winsql
• Report testing using Micro strategy.
• Effort Estimation Preparation
• Peer Review of QA Scenarios & Test cases
• Test Reporting & Status Reporting
• Defect life cycle Management.
• Test Automation using Perfaware

Confidential 

Charlotte, NC

Environment: Netezza, Informatica, Sync sort

Responsibilities:

• Lead End to End ETL testing activities
• Offshore Co-ordination.
• Test Environment Configuration
• Data Migration testing
• Test Plan & Test strategy Preparation
• Database/Backend verification - executing basic and complex queries using winsql
• Effort Estimation Preparation
• Peer Review of QA Scenarios & Test cases
• Generate test cases and test scripts from the Requirements

Confidential, Charlotte, NC

 ETL Test Lead

Responsibilities:

• Lead End to End ETL testing activities
• Offshore Co-ordination.
• Test Environment Configuration
• Data Migration testing
• Test Plan & Test strategy Preparation
• Database/Backend verification - executing basic and complex queries using winsql
• Effort Estimation Preparation
• Peer Review of QA Scenarios & Test cases
• Generate test cases and test scripts from the Requirements

Confidential

 BI Test Lead

Responsibilities:

• Lead End to End BI Testing activities
• Mentoring & Guiding the Junior Resources on executing their deliverables smoothly.
• Testing of reports and universes created in Business objects
• Perform End to End testing between different source systems.
• Perform Functional testing, Regression Testing.
• Database/Backend verification - executing basic and complex queries using Quest Toad
• Verification and Validation of ETL mappings using Informatica Power Center Designer
• Prepare Effort Estimation and review estimation prepared by other resources in the team
• Peer Review of QA Scenarios & Test cases
• Prepare Test Plan
• Generate test cases and test scripts from the Requirements
• Defect Management using HP Quality Center ALM 11
• Prepare the Defect Status Report
• Prepare Traceability matrix.
• Prepare readiness review documents
• Prepare QA artifacts
• Prepare test status report
• Running defect status calls with stakeholders

Confidential

Senior Quality Assurance Analyst

Responsibilities:

• Testing of universe and reports using Business Objects application
• Perform Functional testing and Regression testing
• Data flow validation from source systems to target data warehouse via transient and persistent schemas.
• Data reconciliation activities/validation such as Inconsistent and redundant data in a data warehouse, Loss of Data during ETL process, Incorrect cleansing (e.g., use of incorrect codes) and Incorrect aggregation techniques resulting either in the Cartesian product or data being dropped due to incorrect join conditions.
• Verifying possible data discrepancies that may occur due to simultaneous data feeds happening from multiple source systems to target warehouse.
• Database/Backend verification - executing basic and complex queries using Quest Toad
• Verification and Validation of ETL mappings using Informatica Power Center Designer
• Perform end to end testing independently

Confidential

Associate Consultant 

Responsibilities:

• Verify business requirements and functional specifications
• Generate test cases and test data from the Specifications documents.
• Perform functional, GUI, regression, system integration (SIT), browser compatibility Testing.
• ETL Testing - Verification and Validation of ETL mappings using Informatica Power Center Designer against those specified in ETL Mapping Document
• Perform the Backend Testing (Database Testing) by writing sql queries.
• Business Objects Reports/Universes Testing.
• Defect Logging using the Mercury Quality Center9.0
• Prepare the QA Status Reports using the Test Results.
• Prepare the UAT Test cases.