We provide IT Staff Augmentation Services!

Sr.qa Analyst Resume

Frankfort, KY

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 2010
To December 2010 Confidential
Chicago, IL
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 2010 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
INDIA
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

January 2008
To August 2009 Confidential
India
QA ANALYST


Project: The Ecrins2 application provided order-promising capabilities to HP business users. Ecrins2 was a critical application responsible for order promising and allocation management. Therefore, Ecrins2 had built-in High Availability to ensure 24/7 uptime. High Availability is achieved through server and data replication. All transactions are mirrored on a primary and secondary server, which facilitated business for: Inventory reduction and faster response to changes in Supply & Demand.
Responsibilities:

  • Involved in leading and participating in the full software life cycle for testing activities - from test planning, test execution to test monitoring, status reporting, documentation and data validation.
  • Reviewed requirements documented (mapping document) by Business Analyst for thorough understanding of the application.
  • Validated the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
  • Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
  • Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
  • Validated the external data source by connecting through Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
  • Tests included System Testing, Regression and Business Objects reports testing.
  • Provided flexible & high quality support to wider Testing strategies on key regular deliverables & ad-hoc reporting issues.
  • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Validated the reporting objects in the reporter against the design specification document.
  • Validated the data files from source to make sure correct data has been captured to be loaded to target tables.
  • Validated the load process of ETL to make sure the target tables are populated according the data mapping providing it satisfied the transformation rules.
  • Validated the Archive process to purge the data that met the defined business rules.
  • ETL validation, Data Model Validation.
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping.
  • Performed data migration activities in informatica one version to another version
  • Retested the modifications, once bugs were fixed after reinstalling the application.
  • Reported the bugs through email notifications to developers using Mercury Quality Center.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
  • Lead and schedule QA project status meetings and publish meeting minutes.
  • Developed presentation and testing implementation learning to other testing resources for cross functional training.

Environment: Informatica 7.1.4 and 8.1 Power Center, Oracle 8i, DB2, Toad, UNIX, Mercury Quality Center

July 2006
To December 2007 Confidential
India

Project: One view data warehouse provided one day old data and data for different business geographic (LA, NA, EMEA, ASIA) for MOTOROLA which refreshed only once in 6 hours. The DSC (digital supply chain) portal received the data from idea (it fed directly to DSC), mini view and BO reports, which were built up on one view.
Responsibilities:

  • Involved in test planning, writing test cases/scripts, test case automation and test execution.
  • Documented test scenarios and wrote test cases.
  • Prepared ETL and SQL routines/code for performance ETL testing (system and
  • Integration testing).
  • Verified report data with source, field level data verification.
  • Familiar with defect management systems
  • Read and understood data model.
  • Participated in Full Lifecycle Development on large projects.
  • Understood Unit, Functional, System, Performance, Technical and Operational testing and the tools utilized.
  • Knowledge of software development life cycle principles and awareness of Agile practices.
  • Experienced with data migration testing, data validation testing.
  • ETL tool testing & data integrity testing.

Environment: Informatica 8.1, oracle 9i, PL/SQl Developer, UNIX.

July 2005
To June 2006 Confidential
India


Project: Confidential, is the nation's leading provider of diagnostic testing, information and services perform diagnostic laboratory tests for million of patients each year with a vast network of over 2,000 patient service centers.The interfaces extracted data from the various source systems transformed the data according to the business logic and populated the Data mart in Oracle 9i.

  • Involved in understanding the business requirements.
  • Worked on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.
  • Created the Mappings Using Transformations like Expression, Router, Filter, Normalizer, Sequence Generator, Joiner, Lookup, Sorter and Aggregator.
  • Derived facets by analysis of the text of an item using entity extraction techniques.
  • Tested the Performance of Mapping and was responsible for design, development and Test Cases
  • Scheduled the sessions and workflows.

Environment: Informatica 7.1.2 (Power Connect, Power Mart, Power Center, Designer, Workflow Manager, Administrator and Repository Manager) Oracle 9i, PL/SQL, TOAD, Business Objects 6.5, UNIX

January 2004
To June 2005 Confidential
India

Confidential, Consumer Electronics (PCE), the consumer care division for Philips India Limited, Its countrywide business is divided into a number of sales and marketing regions, areas, markets, SKUs (Stock Keeping Units).

  • Understanding of Business Requirement Specifications
  • Design and Execution of Test Cases, Test Scripts and Test Data
  • Find and report defects and subsequently validating the fix,repeating the process until done.

Environment: Asp. NET, C#.NET, SQL Server

June 2003
To December 2003 Confidential
India

  • Understanding of Business Requirement Specifications and System Requirement Specifications.
  • Design and Execution of Test Cases, Test Scripts and Test Data
  • Find and report defects and subsequently validating the fix,repeating the process until done.

Environment: Test Directory, C#.NET, SQL Server

Hire Now