SUMMARY

Master’s Degree in Computer Science and 7.5 Years Experience in Software Quality Testing and 2 years of Data migration exp on Data Warehouse environment in various domains like Telecom, HealthCare, Insurance and Government with an emphasis on Manual, System, Integration, Regression and User Acceptance Testing (UAT). 4 years of experience in web based applications Testing using Java and .Net. 3.5 years of large Data Warehouse applications using Informatica and Data stage (ODS, ETL process, BI, Data Marts, EDW) on multiple platforms. Data Cleansing and Data merging Activities on ETL processes

• Experienced in all phases of Testing Lifecycle with expertise in the Integration and Functional, Input domain, User Interface, Sanity testing, Regression and Re-testing.
• Complete Software Development Lifecycle (SDLC) experience from business analysis to development, testing, deployment, documenting, maintaining and user training.
• Worked closely with business analysts, programmers, and end users in a cross functional team.
• Possesses a vast experience in testing the entire project lifecycle both in the client/server, distributed and Web environments.
• Experience in coordinating efforts between development teams and offshore enterprise test team.
• Worked with Database migration Testing experience in different versions of Informatica
• Expertise in black box, functional, regression, integration, Interface, Ad-hoc Testing, and User Acceptance Testing(UAT).
• Experience in Data Migration Testing and Data marts.
• Experience in Preparation of Test Plan, Test Scenarios, Test Cases and Test Data
• Experience in software requirement analysis, Modeling, Configuration Management and Change Management.
• Good Experience in review of test cases and Preparing Test Reports
• Database experience includes Oracle, SQL Server and Teradata.
• Extensive experience in Quality Center (QC) and TFS.
• Experience in system testing and integration testing o
• Good experience in UNIX and Windows platform.
• Expertise in Testing Data Marts, ETL (informatica, Data stage and Abinito) and OLAP (Cognos, Business Object), Reporting and Documentation.
• Experience in software analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.
• Worked with SDLC process like Waterfall model, AGILE methodology.
• Expertise in Testing Data Marts, ETL and OLAP, Reporting and Documentation.
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica
• Experience in Fact tables and Dimensional modeling.
• Strong experience in SQL Commands worked with Database testing
• Experience on Data profiling, ETL Data Validation and Complex SQL Queries
• Familiarity with testing process and software life cycle models(SDLC & STLC)
• Strong experience in SQL Commands Select,Joins,Union
• Strong experience in Testing Procedures/Functions, Packages and Triggers using PL/SQL.
• Effective execution of Test cases and Preparation of Test Data manually

EDUCATION

Master’s Degree in Computer Applications

TECHNICAL SKILLS

Testing Tools: Mercury Quality Center, Test Director, Jira, TFS

ETL: Informatica 4.7/ 5.X/ 6.X / 7.1/8.1.1/8.6, Ab inito, Data stage

OLAP Tools: Cognos, Business Objects 5.1.2/6

RDBMS: Oracle/7i/8i/9i, 10g Teradata, DB2, SQL server

Languages: COBOL, JCL, C, C++, Java, XML, SQL, VB

Web Technologies: HTML, ASP, Java Script, Java Servlets, Web Logic

GUI Tools: Erwin, TOAD, Teradata SQL Assistant

Operation Systems: Windows, UNIX, Linux, Solaris.

EXPERIENCE

January 2011
To Present Confidential,Frankfort, KY
Sr. QA ANALYST

Project: To provide a comprehensive customer service site, The Kentucky Child Support Web Portal, where custodial parents, non-custodial parents, and general citizens can access child support information and other general information. The scope of this project is to generate Federal reports like 157,34A, canned reports, and dash boards.
Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Gathering the requirements and preparing the case generation.
• Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Preparation of Test Plan, Test Scenario and Test Cases based on Functional Specification Document.
• Preparation of Requirement Traceability Matrix ,Test Metrics and Deployment manual
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica
• Performed Interface and Integration(SIT) Testing
• Perform User Acceptance Testing with UAT test scenarios.
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool
• Find and report defects and subsequently validating the fix, repeating the process until done.
• Track Sheet Maintenance and map the use case to requirement.
• Build deployment activities and participate in design (spec) reviews with the Core team.
• Evaluate and suggest improvements to the software development process.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Conduct Project Domain and Internal Project Functionality Training Sessions.
• Work closely with the software engineers to ensure successful, high quality releases.
• Understand Business Requirement Specifications and System Requirement Specifications.
• Perform the data load activities based on mapping specification document and data load from source System to Target system.
• Extract data from different source systems using Data Services tools.
• Validate the load process of ETL to make sure the target tables are populated according the data mapping.
• Source(ODS) to target data validation Field to Field verification
• Perform end to end ETL testing using Informatica ETL tool
• Involved in BA walkthroughs and ETL Specification Document
• Create the universe based on the Reporting specification document.
• Prepare the SQL Server 2008 queries to fetch the data from databases.

Environment: .Net 4.0, ASP.net 4.0, SQL Server 2008, Web Methods and Web services, Business Objects, Informatica 8.6, WCF 4.0, TFS 2010, TFS

October 2010To December 2010

Confidential,
Sr. QA ANALYST

Project: The NCPDP provides monthly update files for Provider Groups, Pharmacies, Payment Centers and the Pharmacy association to a Provider Group or Payment Center. They contain information to add, change or delete demographic information for the NCPDP and/or Payment Center. The Pharmacy’s association to the NCPDP and/or Payment Center can be added, changed, or deleted which will be changed by processing these files.
Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Provided review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Prepared Test Cases and Test Scenarios based on Functional Specification Document, Use Cases.
• Performed Sanity Testing, Data Driven Testing & Ad-hoc testing as required.
• Performed System Testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Performed Interface and End to End Testing
• Performed User Acceptance Testing with UAT test scenarios.
• Extensively used SQL queries for data validation and backend testing.
• Found and reported defects and subsequently validated the fix, repeating the process until done.
• Involved in Build deployment activities and participated in design (spec) reviews with the Core team.
• Worked closely with the software engineers to ensure successful, high quality releases.
• Ran the ETL process from Source to Target (PBS) system in UNIX environment.
• Verified outperform generated file feed format and compared with PBS data.
• Checked the control table data for error messages.
• Verified field level data.
• Validated the load process of ETL to make sure the target tables were populated according the data mapping providing it satisfied the transformation rules.
• Loaded the data into PBS System.

Environment:UNIX, TLINE 5.0,Java,J2EE,EJB, WebSphere6.0, Oracle10g,Jira, Informatica 8.0, Quality Center 9.2(QC)

March 2010
To September Confidential, Chicago, IL
Sr. QA ANALYST

Project: To address the required changes to the Agent Rebate process, procedures, and related systems in order to meet the Mythos 2010 implementation timeframe.
It was determined that Mythos 2010 initiatives for Pricing and Rewards would impact the Agent Rebate Process. To ensure the Agent Channel was not adversely impacted in the short term with the Mythos 2010 launch, the new processes and/or systematic changes were needed to occur to support accurate and timely equipment rebate payments to Agents.
Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Prepared Test Cases based on Functional Requirement Specification Document, Use Cases, and Low Level Design document.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Performed data migration activities in informatica one version to another version
• Performed System, Functional, Interface and Integration Testing.
• Performed Regression and Retesting
• Validated the data Source (CARES system) to Target (EDH system).
• Source to target data validation Field to Field verification.
• Performed end to end ETL testing using Informatica ETL tool.
• Involved in BA walkthroughs and ETL Specification Document.
• Created SQL queries to fetch and verify the data from Source and Target (Teradata).
• Conducted on the ODS data testing and Knowledge on XML.
• Loaded the data into Teradata.
• Involved in Build deployment activities and ran UNIX scripts.
• Prepared of Test Scenarios, Deployment manual and Test Metrics.
• Performed Sanity Testing, Data Driven Testing & Ad-hoc testing.
• Verified outperform, generated file feed, formatted and compared with cares data.
• Checked the control table data, verified report data with source.
• Ran the ETL process from CARES to EDH (Teradata) in UNIX environment.
• Designed the Requirement Traceability Matrix document based on the Functional Requirement document and Test Cases document.
• Provided daily status to Test Lead.
• Defect Logging and Verifying resolved bugs and reported regular progress to the Test Manager.
• Conducted peer review of test cases and provided comments.
• Defect logging in bug tracking tool (QC) and Verifying resolved bugs.
• Worked closely with the Developer and BA to ensure successful, high quality releases
• Verified report data with source.
• Field level data verification.

Environment: Java, EJB, Web Logic Server, Informatica 8.0 and 8.6, Oracle 10g, Teradata, Toad,
UNIX, Quality Center 9.2

September 2009
To February 2010, Confidential,
QA ANALYST

Project: The Quote-to-Cash (Q2C) program implemented global standardized processes and platforms from the customer quote through cash collection cycle.
Responsibilities:

• Understanding Functional Requirement Specifications and System Requirement Specifications
• Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications
• Design and Execution of Test Scenarios and Test Cases based on Functional Specification Document, Use Cases, Low Level Design document
• Preparation of Requirement Traceability Matrix ,Test Metrics and Deployment manual
• Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Performed User Acceptance Testing with UAT test scenarios.
• Extensively used SQL queries for data validation and backend testing.
• Functionality, Interface, and Regression testing
• Report defects and subsequently validating the fix, repeating the process until done.
• Tracking and Managed defects usingQuality Center
• Work closely with the software engineers to ensure successful, high quality releases.
  

Environment: Quality Center(9.2),Java,JSP,EJB,Oracle9i,Toad,WebLogic Server