SUMMARY:

• More than thirteen years of professional experience in Quality Assurance process with extensive experience in Manual, Automation and Back end Testing and Project Management at different designations.
• More than eight years of solid testing experience in Data Warehouse and customer facing applications.
• Strong knowledge of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Bug Life Cycle.
• Experienced in reviewing Business requirements and developing formal test plans and scripts.
• Very strong in preparing and executing Test Cases, Test Plans and Scripts.
• Experienced in FT, iUAT and RIT environments.
• Good knowledge in Oracle, PL/SQL, SQL Server, T - SQL, data manipulation.
• Experienced Lead Test Analyst on various Reporting tools Cognos, Business Objects and SQL Server Reporting Services (SSRS).
• Have extensive Testing experience on various ETL tools SQL Server Integration Services (SSIS), Informatica and Ab-Initio.
• Strong exposure to Teradata and SAP ABAP.
• Exposure to ETL automation DVO and Platinum.
• Experienced handling Mercury Quality Center, ALM and QTP tools.
• Exposure to UNIX, Linux OS and XML.
• Possess strong exposure and experience in Content Management in the E Learning Industry.
• Have strong experience handing offshore and onsite teams.
• Co-ordinate with Development, Tech BAs and Project Management teams regarding QA requirements, Efforts, resourcing, Test efforts and resourcing.
• Have strong experience in Project Management and Resource Management.
• Prepared project plans for QA using Microsoft Project Plan (MPP).
• An enthusiastic, flexible and self disciplined individual seeking an opportunity to play a challenging creative role with a commitment to company excellence.
• Experienced content development and testing gained from working with International Clients based at US, Italy, Spain and Japan in the e-Learning industry.
• Effective in oral and verbal communications.
• An excellent Team player.
• Preparing the test plan for long term projects.
• Preparing the traceability matrix.
• Reviewing and approving the test cases.
• Preparing Test Strategies and Validation of data
• Creating scenarios for load and performance test.
• Experience in identifying performance improvements using TOAD.

TECHNICAL EXPERTISE

RDBMS: Oracle 9.0/10G, SQL Server 2000, SQL Server 2005, MS Access

Database Tools: Toad 8.x/9.x, SQL Plus

ETL Tools: SSIS, Informatica 8.x/9.x, Ab Initio

Operating Systems: MS-DOS, UNIX, Linux. Windows -95,98, and NT

MS Office: MS Word, MS Excel, MS PowerPoint

Test Management Tool: Bugzilla, Jira, HP ALM/Mercury Quality Center

Testing Tools: Microsoft Web Application stress tool, Adobe Flex, Load Runner, Rational Performance tool for SAP

Scheduling Tool: Control-M, Tivoli Workload Scheduler

Languages: SAP-ABAP/4, C, C++

Web Designing Tools: Adobe Photoshop CS2, Macromedia Flash MX 2004 Macromedia Dream weaver MX, Image Ready, Director 8.0, Fireworks and HTML, XML

PROJECT EXPERIENCE

Confidential

Data QA Lead

Tools: Informatica, Oracle, Unix, ControlM, MS Office Suite, QC-ALM, Sharepoint

Responsibilities:

• Onsite Test Lead for Confidential Applications (OPERA, DAL) managing a team of 3 members.
• Preparing the QA test plan, Test strategy, Test Execution, and Project Deliverables.
• Member of IT QA group supporting Functional, Integrated UAT and RIT Testing.
• Managing the QA environments for functional testing (Database & UNIX component deployments).
• Working on ETL tool Informatica, PL/SQL & UNIX Platform.
• Working on Oracle Database writing complex SQL Queries for testing validation and data integrity.
• Attending FRD walkthroughs to understand the project runbook to support iUAT every release.
• Working with cross functional groups like development, data modelers and deployment teams.
• Attending Project meetings with Clients and all stakeholders.
• Working as a Project Coordinator ensuring all issues faced by offshore were consolidated and resolved with all stake holders.
• Conduct daily defect calls and establish a defect process that enabled movement of defects and closure in a timely manner.
• Delivering daily status report & defects management using HP Quality Control.
• Involving in Defect Tracking Analysis report & Metrics Traceability.
• Instrumental in communicating issues / risks and resolutions across globally dispersed cross functional teams.
• Releasing stable, scalable, Production system that satisfies client requirements.

Confidential

DWBI Test Lead

Tools: Ab-Initio, Teradata, Cognos, Unix, Mainframe TWS, MS Office Suite, QC-ALM, Sharepoint

Responsibilities:

• Performed the role of a Test Lead and was responsible for driving the project team to use ALM as Test Management repository to capture finalized requirement and to track the changes to address Change Requests.
• Prepared Test estimates to provide functional end to end testing services for the project.
• Reviewed Test Plan, Test Strategy and test cases developed by team offshore with the KeyBank clients.
• Part of the review discussions specific to Test Plan, Test Strategy, Test Cases with the stakeholders.
• Provided support by helping the LOBs to perform UAT and helped them with defect tracking and triage.
• Worked with the LDM, PDM, ETL, Support and project team to enable the functional testing activities performed as per the schedule.
• Anchored the end to end testing defect triage calls with the project team and with Line Of Business during UAT.
• Worked with the PDM team to analyze the populated in the core view and traced back the to analyze the data in View with the underlined BDW layer which is sourced from Lease Pak.
• Validated the data lineage from source to staging and from staging to target and to the Shared Foundation Data layer.
• Ensured a timely move of the application to PROD without any errors.

Designer Shoe Warehouse

ETL QA Analyst

Tools: Informatica 8.1.1, Oracle, Teradata, JESTA forms, MS Office Suite, Quality Center, Sharepoint, ATG Bcc

Responsibilities:

• Prepared Test Plan based on the requirement and design document.
• Constant interaction with Dev, BA, PM for successful test support for the project.

Confidential, Minneapolis, MN

LEAD ETL QA Analyst

Tools: SQL SERVER 2008, SSIS, SSRS, SSAS, MS Office Suite