PROFESSIONAL SUMMARY:

• More than 13 years of experience in Software Quality Assurance Testing as a Test Lead and Beta Configuration Manager. Good understanding of Data warehouse, ETL, ERP, Client/Server. Experience in Waterfall and Agile methodologies.
• Strong understanding in SDLC, Project Life cycle and Test Methodologies.
• Extensively worked as a Beta Change manager including Change Management, Configuration Management, Release Management and Problem Management.
• Executed the tasks in Beta as per the project Implementation Plan. Promote and Install code from lower environment to Beta through Harvest tool, DB changes, UNIX code and Informatica mappings etc.
• Extensive experience in Quality Center for Managing/Executing Test cases, Defect tracking and reporting.
• Experience in Integration Testing, System Testing (Functionality, Regression), Performance Testing and User Acceptance Testing.
• Created the System Test, User Acceptance Test scenarios and test cases based Business and Function requirement documents,
• Proficient in Data Warehouse testing like testing batch loads, Error/ rejected records processing, testing of Data Quality Checks and process dependencies.
• Coordinated and managed offshore testing team. Reviewed the implementation plan with project tech leads.
• Reviewed the Requirement documents or story cards and Developed Test Scenarios, Test Cases and Test Scripts.
• Solid and hands - on experience in designing and maintaining test plans.
• Expert in root cause analysis and data Analysis. Developing test data, test checklist, Test coverage metrics.
• Extensive experience in Manual Testing of ETL and BI. Expertise in Data Warehousing and ETL Testing concepts (Dimension Data Modeling, Star Schema and Snowflake Schema)
• Excellent understanding of relational database concepts including normalization, referential integrity, joining tables, SQL, DDL and DML.
• Work closely with Developers in resolving the issues. Conducted project test case review and testing status meetings. Managed daily assigned tasks were completed in accordance with time.
• Communicating with Developers, project managers and application rollout groups to set and meet quality standards.
• Ability to communicate effectively at all levels of the Testing and Development process.
• Attended the GO-NO-GO meetings and sign-off the project.

TECHNICAL SKILLS:

Operating Systems: Windows NT/95, 98/2000/XP, Macintosh UNIX, DOS, Sun Solaris.

Languages: C, XML, SQL, PL/SQL

Testing Tools: WinRunner, Silk5.0, Silk Performer, Ruby-Cucumber, Quality Center, JIRA

Databases: Oracle, MS SQL Server, DB2, MS Access, Teradata and Netezza

Tools: & Utilities TOAD, WinSQL, SQL Navigator, Putty, Harvest, Maestro, Hamming bird

Reporting Tools: Micro Strategy, Business Objects.

ETL Tools: Data stage 7x, AbInitio and Informatica 9.0.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Test Lead

Responsibilities:

• Extensive experience in Data Warehousing and ETL Testing/concepts.
• Participated in daily stand-up and System Requirement Document review meetings.
• Prepared test cases and SQL Scripts based on Requirements/Stories.
• Reviewed the test cases with Development and testing team.
• Coordinated with source systems and scheduled the End-to-End flow dates.
• Create and managed defects through JIRA and Quality Center.
• Executed test case and validated the data from source to target.
• Manage and co-ordinate with off-shore team.

Environment: Netezza, Hadoop, Tosca, Jira, Quality Center

Confidential, Minneapolis, MN

Test Lead

Responsibilities:

• Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reports Testing of Web apps.
• Participated in review meetings (System Requirement Document).
• Prepared test cases and Test Scripts based on Design & Requirement documents.
• Responsible for Validating the XML file based on the XSD.
• Tested XML for correct values, tags, data elements, sequence and order.
• Tested the application if the correct values are displayed after a change made in XML and the functionality .
• Experience in analyzing EDI requirements and mapping documents.
• Experience in EDI transactions (837,997,999,270, 271,278).
• Good Knowledge in various EDI X12, EDIFACT standards and Flat Files (Prop Format).
• Verified Translated EDI Output file with Paper Map as per the requirements.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility.
• Worked Extensively with EDI Inbound and outbound claims processing systems.
• Extensively Used BIZTALK and TPAM for validating EDI files.
• Written the complex SQL queries and executed to validate the data from source to target.
• Used Quality Center to design and execute the test cases, create, manage defects.
• Created and assigned the defects. Worked closely with developers to resolve defects.
• Used SharePoint to store document and version control.

Environment: SQL Server, BizTalk, TPam, Oracle, XML and Quality Center

Confidential, Irving, TX

Test Lead

Responsibilities:

• Involved in CRD validation, Benefits Preview Checkpoint, Coding Checkpoint, Query Testing and Peer Review
• Responsible for Performing Adhoc, Query and Smoke Testing
• Responsible for providing timely updates to the customer
• Responsible for attending the Triage calls and getting clarifications and reporting issues
• Responsible for updating status and uploading test artifacts in the web based application SFDC

Environment: SQL Server, Oracle and Quality Center

Confidential, Chicago, IL

Test Lead

Responsibilities:

• Participated in daily stand-up and System Requirement Document review meetings.
• Prepared test cases and TSQL Scripts based on Requirement documents.
• Reviewed the Master Test Strategy, Test cases with Development and testing team.
• Coordinated with source systems and scheduled the End-to-End beta flow dates.
• Create and managed defects through JIRA.
• Performed Traceability Matrix that maps test cases to requirements Coverage Analysis.
• Executed test case and validated the data from source to target.
• Involved and managed System, Regression and Integration Testing.
• Reviewed the defects with project team and communicated the status.

Environment: SQL Server, Oracle, Teradata and JIRA

Confidential, Chicago, IL

Consultant

Responsibilities:

• Participated in review meetings (System Requirement Document).
• Prepared test cases and Test Scripts based on Design & Requirement documents.
• Written the complex SQL queries and executed to validate the data from source to target.
• Used Quality Center to design and execute the test cases, create, manage defects.
• Created and assigned the defects. Worked closely with developers to resolve defects.

Environment: Netezza, Oracle, UNIX, Informatica, Quality Center, Business Objects

Confidential, Chicago, IL

Test Lead

Responsibilities:

• Participated in review meetings (System Requirement Document or Story Cards).
• Prepared Project Testing Estimates, Master Test Strategy and Test Plans documents.
• Prepared test cases and Test Scripts based on Design & Requirement documents.
• Reviewed the Master Test Strategy, Test cases with Development and testing team.
• Coordinated with source systems and scheduled the End-to-End beta flow dates.
• Used Quality Center to design and execute the test cases, create, manage defects.
• Performed Traceability Matrix that maps test cases to requirements Coverage Analysis.
• Verified the Implementation Plan and approved to move the code to Beta environment.
• Executed, completed test flows successfully and Communicated to the project teams.
• Involved and managed Static, Regression, Integration, System and Acceptance Testing.
• Written the complex SQL queries and executed to validate the data from source to target.
• Strong experience in Data Analysis, Data Profiling, Data Integration and Metadata Management (MDM).
• Validated the Meta data, Data Quality Checks and verified the UNIX logs.
• Coordinate, manage and support testing efforts with upstream and downstream systems.
• Created and assigned the defects. Worked closely with developers to resolve defects.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology .
• Prepared Test data and validated Transformation rules.
• Validated report fields present in the reports are as agreed in the specifications.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Conducted, participated the defect, status review Meetings and provided the status reports.
• Managed daily assigned tasks were completed in accordance with time.
• Coordinating the Team on how to do the tests in different environments.
• Created User Acceptance Test scenarios and test cases based Business and Function requirement documents,
• Reviewed the implementation plan with project tech leads.
• Attended the GO-NO-GO meetings and sign-off the project.
• Verified the Implementation Check list and approved the RFC to implement the project.
• Performed the Post Implementation Testing in Production.
• Performed the root cause analysis for defects/break fix issues.
• As a Beta Change manager involved in Change, Configuration, Release and Problem Management.
• Executed the tasks in Beta as per the project Implementation Plan. Promote and Install code from lower environment to Beta through Harvest tool, Data Base changes, UNIX code and Informatica mappings etc.
• Performed the Database, Harvest and Unix Quarterly Password changes.

Environment: Windows XP, Netezza, Teradata, Oracle, Unix, MicroStrategy, Informatica, Quality Center, Business Objects, Harvest, Webfocus, Maestro, Agile, Waterfall