SUMMARY:

• 13+ years of software development and testing experience with perfect blend of soft and technical skills in Data Warehouse ETL tools and Databases. Good experience in ALM, HP Quality Center, ETL Tools and Databases.
• Extensive testing and Development experience in ETL Tools like Data Stage, Informatica and Ab initio. Extensively worked in Database testing which includes Oracle 9i, Oracle 11.2, Teradata, SQL Server and IBM UDB DB2. Tested Web Applications using QTP, Selenium and HP Unified Functional Testing and OBIEE Reports. In - depth knowledge and experience in all phases of project testing life cycle and methodologies. Good experience in Agile, Water Fall methodologies.
• Played various roles like Developer, Tester, Module Lead, Onsite Coordinator, Quality Analyst Lead and Manager. Have good experience in migration projects (ETL and Database migration) Proficient in interacting with customers, transforming requirements into Test Plan and leading team to ensure the delivery of quality testing solutions as per customer requirements. Highly motivated and self-confident.
• Possess good problem solving, good grasping power and good oral & written communication skills. Web Service/API tested using SOAP UI and CA LISA/Dev Test Working on BIG DATA testing Good team player and possess good interpersonal skills. Mentored junior team members by providing technical guidance Working in On-site / Offshore (Hybrid) Delivery Model throughout the IT career. Extensively worked in multi-vendor / team environment and have excellent communication / coordination skills across vendors / teams.
• Highly flexible and adoptable. A quick learner and learned lot of new technologies / framework / processes quickly when the job demands and successfully implemented them. Methodical and thorough, and can always be counted on to produce accurate solutions. Worked well under pressure and delivered all projects successfully. Have experience in customer presentation and estimation.

TECHNICAL SKILLS:

Software Testing Methodologies: Agile (Scrum), Water Fall.

Test Management Tools: HP Quality Center, Test Director, HP Application Lifecycle Management

ETL Tools: Ab initio, Informatica, Data Stage, SQL server DTS packages

Big Data Technologies: Spark, Hadoop, Yarn, Kafka, Hive, Pig, HBase

Cloud Technologies: Microsoft Azure

Requirement Management: Jira, IBM Rational Team Concert

Languages: VB Scripting, Java, C, C++

Databases: DB2, Oracle 9i, Oracle 11.2, Teradata, SQL Server 2008, IBM UDB DB2

Operating Systems: Unix, Windows 98/NT/2000/XP/Vista/Win7

Productivity Tools: WinSCP, Adobe Acrobat, MS Office, Putty, SQL Developer, Teradata SQL Assistant, Teradata BTEQ scripts, QTP, HP Unified Functional Testing, Platinum, OMNI, Bravo, UFT, SOAP UI, CA Lisa/Dev Test, ADPART, FIS

Design Tools: MS Visio, Oracle SQL Modeling

Configuration Management: Rational Clear Case, Visual SourceSafe, HPSM

Scheduling Tools: Control-M; IBM Tivoli Maestro, Autosys

Reporting Tool: OBIEE, Qlik Tool

Domain Knowledge: Retail, Insurance, Finance, Health Care

PROFESSIONAL EXPERIENCE:

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. System testing, User Acceptance Testing and test support. Automating the Regression Test cases using QTP/Selenium. Test Data Set up Deployment planning & co-ordination.

SKILL: Azure cloud, Spark, Kafka, Apache Hadoop Yarn, Jira, Java, UNIX, Unified Desktop, ETL testing

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Review the work product from senior and junior testers and ensure quality. System testing, User Acceptance Testing and test support. Automating the Regression Test cases using QTP/Selenium. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination.

SKILL: Oracle 9i, Oracle 11.2, HP Quality Center, UNIX, Unified Desktop, ETL testing, QTP, HP Unified Functional Testing, Platinum, Data Stage 8.1,11.3.1,Autosys,OMNI,ADPART,Selenium

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Review the work product from senior and junior testers and ensure quality. System testing, User Acceptance Testing and test support. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination.

SKILL: WINSCP, Oracle SQL, HP Quality Center, UNIX, OBIEE, ETL Testing.

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Automated the data validation between ERISA/IRW reports to the database using Teradata BTEQ scripts. Review the work product from senior and junior testers and ensure quality. Used QTP to generate the ERISA reports from OBIEE reports for different set of plan numbers. System testing, User Acceptance Testing and test support. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination.

SKILL: Teradata SQL, SQL Server 2005, HP Quality Center, UNIX, OBIEE, ETL testing, QTP.

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Review the work product from senior and junior testers and ensure quality. System testing, User Acceptance Testing and test support. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination.

SKILL: Teradata SQL, WINSCP, Oracle SQL, HP Quality Center, UNIX, OBIEE, ETL Testing.

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Review the work product from senior and junior testers and ensure quality. System testing, User Acceptance Testing and test support. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination.

SKILL: Oracle SQL, HP Quality Center, UNIX, OBIEE, ETL Testing.

Confidential

Senior Quality Analyst Lead

Responsibilities:

• Identifying and scoping the project requirements by working with Business Analyst, Business Stakeholders and Reporting team. Participated in defining Test Plan. Effort estimation, Analysis and led offshore team in the preparation of Test Cases. Review the work product from senior and junior testers and ensure quality.
• System testing, User Acceptance Testing and test support. On-site/offshore co-ordination, Test Data Set up Deployment planning & co-ordination. Responsible for delivery tracking against the project plan and weekly status reports to clients. Tested the OBIEE reports by doing the Graphical User Interface validation and data validation of the reports using QTP. Tested the URL’s for the IBM Business Glossary project and the search functions in the site.

SKILL: SQL Server, Oracle SQL, HP Quality Center, UNIX, OBIEE, QTP, ETL Testing.

Confidential

Quality Analyst Lead

Responsibilities:

• Attend sprint planning meeting with business to understand the requirements Preparation of Business Assurance Test Strategy document that articulates the consolidated list of top business risks for a particular enhancement. Review of System Test Cases created by Offshore QA team in HP Quality Center for each enhancement.
• Test data setup (in System Test/Pre-prod environments) by extracting data from Production Teradata or Sql Server tables. System Testing the Ab intio graphs in UNIX environment. Review the System Test Results document prepared by Offshore. Monitor the updating of System Test defects in Quality Center by Offshore QA team Support User Acceptance Testing by setting up the data for business users. Responsible for obtaining UAT signoff from business. Performing Pre-prod testing Preparing Test Completion Report (TCR)

SKILL: Ab initio, SQL Server DTS Packages, HP Quality Center 10.0, UNIX, Oracle, Teradata, SQL Server, HPSM, Clear Case Explorer, Control-M

Confidential

Quality Analyst/Lead

Responsibilities:

• User Stories are the primary requirement document for this project. I involved in analyzing the user stories. Involved in the preparation of Test Plan/Test Cases/Test Script Test data setup (in System Test/Pre-prod environments) by extracting data from Production Teradata or Sql Server tables. System Testing the Ab intio graphs in UNIX environment. Updating System Test defects in Quality Center. Performing Pre-prod testing Preparing Test Completion Report (TCR) Performed the review of System Test Plan and System Test Cases by QA team. Coordinated QA activities with my Onshore counterparts and Offshore QA team.

SKILL: Ab initio, SQL Server DTS Packages, HP Quality Center 10.0, UNIX, Oracle, Teradata, SQL Server, HPSM, Clear Case Explorer, Control-M

Confidential

ETL Developer/Test Lead

Responsibilities:

• Coordinates the Test Data Management (TDM) refresh process to load test data to the various test environments Manages the refresh calendar for the various test environments. Communicates the refresh schedule to all interested teams (including the business Data Quality team) Communicates when TDM refreshes are complete.
• Develop Data stage jobs and Manages all release testing cycles and offshore testing resources Working with TTS management to prioritize and manage workload Communicates issues found during testing including defects as a result of new projects and those found to be carryovers from production Facilitates daily defect review meetings during Release Testing Works with development teams and offshore testing team to resolve bugs found during Release Testing Coordinates the communication with source systems (e.g. POS), vendor systems (e.g. Experian) when doing Release Testing Creates test sets in Test Director for each Release cycle and reports test results

SKILL: IBM Web Sphere Data Stage, Mercury Test Director, UNIX, Remedy, IBM UDB DB2PVCS, Web Based Software Deployment, Control-M

Confidential

ETL Developer

Responsibilities:

• Involve in clarifying all queries / questions that business users have on reports for various applications. Doing the root cause analysis of a particular issue and provide a recommendation for solution. Develop, optimize, Data stage jobs Holding responsibility for overall technical aspects like developing Ascential Datastage 7.5.1. Jobs to enhance the system, analyze, provide solution for issues. Involving in the preparation of Test cases and Review deliverables. Responsible for initiating meetings with Onshore team.

SKILL: IBM Web Sphere Data Stage, Mercury Test Director, UNIX, Remedy, IBM UDB DB2PVCS, Web Based Software Deployment, Control-M

Confidential

Developer/Production Support Analyst

Responsibilities:

• Involved in the Tran EVA Enhancement (Phase 3) development works which includes developing Informatica mappings, Preparing and executing UTC, Testing, developing
• Teradata BTEQ scripts.
• Monitor jobs in maestro and Informatica work flow monitor and Teradata Performance Monitor Fix on Fail - Handle ticket in case of abend Perform manual data validation and inform Onshore Counterpart in case of mismatch between expected and obtained result in validation

SKILL: Informatica, PL/SQL, UNIX, Maestro JS console Scheduler, Oracle 9i, Shell scripts, Teradata PMONBTEQ,SQL Assistant, TOAD,VB 6.0