SUMMARY:

• 10+ years of experience in Software Quality Assurance with a good understanding of the QA process, with hands - on experience in Automated testing and Manual testing.
• Experience using open source tools like TestLink for Test management and Trac for Defect management
• Experience in preparing Test strategy, Test plans and Test Summary report and actively provided feedbacks and recommendations for the project document reviews
• Involved in maintaining Traceability Matrix to ensure comprehensive test coverage of requirement
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor)
• Experience in Qlickview Dashboard Cognos Report and TM1 cube Testing .
• Experience in web application and Non Functional Testing
• Experience in working with delimited, fixed length data and create SAS dataset using XML data with SAS Mapper
• Worked in Test lead capacity for various projects which involved understanding the project charter, requirements, design and communicating expectations to the team to help prepare the Test deliverables
• Participated in Business case development and provided early test effort estimates.
• Ability to analyze data anomalies between multiple systems and understand the complexity of the Data Movement, Data Migration and Data Integration projects
• Hands on experience in Reporting issues/bugs, works closely with developer to resolve and validate.
• Experience in data warehouse testing with third-party tools and verifying data against various database systems using SQL queries to validate data and backend testing
• Actively trained the new members of the team and provided sessions cross teams and coordinated testing between the on-shore/off-shore teams
• Participated in requirements and high level design reviews for the "system under test"
• Experience working in Unix 32/64 bit environment and familiar with Unix utilities and commands
• Knowledge working on Mainframe/Host applications.
• Team player and self-starter with excellent communication, coordination, documentation, and interpersonal skills
• Good understanding of a software development lifecycle( SDLC) methodologies and agile techniques

TECHNICAL SKILLS:

• Product/Project Development Lifecycle
• QA Process/Test Plan creation
• Training and Documentation
• Product Quality testing
• QA Testing/ UAT (User Acceptance Test)
• Automated/Manual testing/Integration
• Data Warehousing/ETL testing
• SOA (Service Oriented Architecture)
• Defect/Bug reporting, logging and tracking
• Defect Management tools: - Trac, Bugzilla
• Data access tools: IBM Data Studio, Microsoft Query, DB Visualizer, DB Editor
• Test management tools: Quality Center, Rational Clear Quest, Test Link
• ETL tools: -Informatica, SAS
• Databases: - Oracle,DB2, MS Access MySQL, Postgres, WinSQL
• Programming: - Shell script, Java,C,C++
• Operating Systems: - Unix, Linux -32 & 64 bit platforms,Windows
• Reporting: Cognos, Bussiness Objects,TM1,Qlikview
• Host Applications: Micro Focus Rumba

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Test Analyst-Technical

Responsibilities:

• Working as Test lead for various projects which involved understanding the project charter, requirements, design and communicating expectations to the team to help prepare the Test deliverables
• Identify the Risks, Issues and Dependencies and documenting in project notes
• Prepare the Test schedule and plan the test activities and communicate to the project and planner
• Oversee the test script preparation activities, uploading to test link and enforce test entrance and exit criteria
• Monitor Testing Defects for any escalation needs or defect triage procedures
• Experience using the Database client tools to connect to the database for verify and validate data with SQL
• Identified Automation possibilities in Unix with scripts to verify log results and scripts help validate the data by data comparison
• Adept in writing shell scripts using powerful simple and Compound Unix utilities to automate the testing efforts
• Received a ppreciation from Test/Project Managers for hard work, effort and extremely effective in getting team quickly up to speed, thoroughness and excellent communications with the team and business partners resulted in quickly gaining respect from the developers, timely identification of the defects, finding root cause, appropriate escalation to defect triage team, coordinating between the developers and help verify the fix.
• Experience in working in Data Migration, Qlikview Dash board, Cognos Reports, TM1 cube Adhoc Reporting, BO Crystal reports in projects under BIRA and EPMA
• Experience in working in data movement validation to Hadoop big data environment.
• Coordinated between the offshore and onsite project team by communicating the project expectations and constantly monitoring the offshore deliverables via mails and conference calls
• Proactively provided feedback while reviewing project deliverables to gain insight into the project scope and objective
• Coordinated with the Implementation Coordinator and Release coordinator to align/adjust the test activities to meet the Implementation/Release schedule expectations

Confidential, FL

Sr. DW Analyst/ETL Tester

Responsibilities:

• Responsible for developing software Test Plans, Test Case Design and Test Scripts.
• Involved in testing both web based and client server applications.
• Involved in functional, system, integration, end-to-end testing and regression testing.
• Participated in all aspects of the software development life cycle.
• Worked closely with the analyst to gather information required for creating test cases.
• Identified and created test data for test execution.
• Written and executed test scripts to verify the Test cases using QTP.
• Created and enhanced numerous test scripts to handle changes in the objects of the GUI and in the testing environment using QTP.
• Performed back-end testing manually by generating SQL queries for System Test Databases.
• Reporting and tracking software defects in HP Quality Centre 9.2 and re-creating them to assist developers for faster resolution.
• Apply technical expertise to organize and implement black-box test efforts and to analyze requirements for software design, development and validation.
• Loaded data from flat files to source tables using SQL *Loader and Informatica Power Mart.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Conducted Functionality, URL Link Testing and Regression Testing during the various testing phases of the application using QTP.
• Created Modules, reusable QTP (QuickTest Professional) Scripts for the use of other testers.
• Analyze the business and technical specifications and participated in walk-throughs and sign-off meetings.
• Participated in defect review meetings with the team members.
• Implemented whole life cycle of QA Methodologies starting from Planning, Capturing, Creating, Executing, Reporting, and Tracking the defects using Quality Center 9.2.
• Used MS-Word and Microsoft Excel for documentation.
• Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various transactions on the system

Environment: Windows 2003 Server, Windows 2000, VB, Mercury Tools - QTP,, Quality Center, SQL Navigator 5.5, Oracle 9i, Informatica Power Center, TOAD,, Visual Source Safe, HTML, XML, Java, and VB script.

Confidential, TN

Sr. DW Analyst/ETL Tester

Responsibilities:

• Involved in writing Test cases and developing Test Plans.
• Found the Defects when running the test cases in Test Director.
• Developed Functional Test Cases based on the BDR specification.
• Performed Regression testing for every modification in the application & new builds using QTP.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to Confidential using Informatica Workflow Manager.
• Functioned as Project Lead to implement an effective and efficient test regression test bed. Test Automation using QTP
• Developed automated Test Scripts using QTP
• Verified Transformation rules in REFORMAT & JOIN components.
• Responsible for GUI Testing, System Testing (SIT), Regression Testing and Acceptance Testing(UAT).
• Tested the application on different browsers and verified the links of the application.
• Use SQL to test backend functionality.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.
• Attended Daily Stand Up meetings, and provide Testing status of assigned work.
• Executed Functional, integration test cases.
• Participated in overall end-to-end testing.
• Represented bugs scrub meetings, and for review and find resolution to the defects.
• Raising the defects in Mercury Quality Centre and doing root cause analysis whenever necessary
• Preparing the execution report and documenting the observations and defects.

Environment: Informatica Power Center, SQL Server2000, Oracle, XML, Windows XP, MS-word, Data Migration

Confidential, MN

Sr. DW/ETL Tester

Responsibilities:

• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.
• Analyzed the ETL design documents to understand the logic.
• Performing Integration testing for all the Mappings in “Customer Order Tracking DM” and documenting the results.
• Performed troubleshooting the loading failure cases, including database problems.
• Worked on different Test Decks on different releases for East & West on Orders and Pre-orders.
• Developed Base line scripts for testing the future releases of the application using Quick Test Pro (QTP).
• Prepared Functional, scope and ETL mapping documents for COT Data mart.
• Executed the test cases for Staging Tables and Member tables and validate the data results.
• Updated the test cases on based on the requirement changes and executed the test cases.
• Wrote complex SQL queries and Data Mart Staging Tables to validate the data results and documented.
• Prepared Test Plans, Test Scripts, Test cases and validated the Test cases.
• Created and monitored daily incident Report.
• Utilized Win Runner extensively.
• Involved in Regression, Release and System Integration testing.
• Used Quality Center for the bug tracking purposes.
• Participated in overall end-to-end testing.
• Working with different data sources, like Oracle, Teradata, Flat files, xml files, and handling huge data.
• Included in meetings with the Development Team to discuss the open defects.
• Supporting and coordinating onsite/offshore teams.

Environment: Oracle 10g/11g, Informatica Power Center, Linux, TeradataV6, IBM Lotus Notes, HP Quality center 9.0, Microsoft TFS

Confidential, CT

DW Tester/QA Analyst

Responsibilities:

• Involved in writing Test cases and developing Test Plans.
• Ran the UNIX shell scripts to count the records for ALSS Source to Stage and Comparing with header Tables
• Found the Defects when running the test cases in Test Director in data stage jobs
• Involved in reviewing Business Requirements and Use Cases.
• Automated scripts using Win runner.
• Conducted data driven tests using win runner.
• QTP was integrated with Win runner.
• Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing.
• Tested the application on different browsers and verified the links of the application.
• Use SQL & PL/SQL to test backend functionality.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.

Environment: Informatica 7.x, Oracle 8i/9i, SQL Server 2005, Microsoft Office, UNIX, Windows NT