SUMMARY

• 10 plus years of Software Quality Assurance/ automation testing/Implementation experience in requirement gathering, analysis, design, develop, Testing/validating, maintaining, troubleshooting, process improvement.
• Currently working with clientFederal National Mortgage Association ( Confidential ) and Freddie Mac.
• Experience onCapital Markets, Corporate Finance,Mortgage& securitization, Banking, Healthcare, and Government Services.
• Having good experience on Techno functional knowledgeof following modulesOM, &HRMS/Payroll, GL, AR.
• Having good experience on the ERP E - Business suit testingOracle(R12)
• Having good experience on testing cloud (AWS) environments.
• Experience on Automation Testing usingRIT,Selenium,and Load Runner.
• Working experience with User Stories, Use Cases, Sprint Planning, Test Cases and Test Plan in Agile environment
• Having good experience on Talend OpenStudio, Informatics (Data warehousing) OLAP Testing.
• Having good experience onData Migration.
• Experience on testing Oracle Application Testing Suite(OATS)
• Created the End-to-End traceability with requirements, test cases, test results and defects in Quality Center.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Experience in Metadata and analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Having experience onOracle 9i RDBMS(Package, Function &Database trigger, View) and Oracle Developer Forms 6i/ Reports 6i, SQL Plus, PL/SQL
• Reviewed the Requirements, Test Approach, Test Scenarios, Test Conditions, Test Scripts and identified gaps.
• Understanding & co-ordinating customer needs/requirements and provide solution in adherence to the delivery schedule and as per the SLA.
• Have experience on performing Integration, System, Functional, GUI, Regression, ERP, Data Warehouse / ETL and UAT.
• Proficient in White box, Black box, Regression, APT, IPT, QA/Testing methodologies, SDLC and Agile processes.
• Expertise in analyzing, designing, developing and executing Test plans, Test cases, Test scripts and Traceability Matrix from requirements/specifications.
• Solid understanding of quality control best practices, automated testing, and defect management skills
• Have experience working with Oracle E-Business suit (R12)
• Experience with QA tools including bug/defect tracking systems, Test Management software such as Test Director, Quality Center, Test Manager, ALM, Rally,Clear Quest and automation tool- RIT.
• Strong skills in RDBMS (Oracle, PL/SQL, SQL Server, DB2) backend testing, table manipulations using SQL queries, generating reports to ensure data integrity and validating business rules.
• Possess excellent communication skills, ability to work as a team member, as well as independently.

TECHNICAL SKILLS

Testing Tools: Test Director, Quality Center,ALM (Application Lifecycle Management), Test Manager, Rational Clear quest, RIT, Selenium.

Languages: Toad, Sqldeveloper, SQL, PL/SQL, HTML, XML

Database: Oracle, SQL Server, Big Data Hadoop and DB2,Talend OpenStudio.

ETL / Reporting Tools: Informatica, Business Objects, Talend OpenStudio.

Script: Java Script, VB Script

GUI: Form 6i, Report6i, Platinum Erwin, Oracle Apps11i&Oracle R12

Defect Tracking Tool: Quality Center / Rally, Clear Quest, PVCS Tracker, Winscp, Splunk

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Test Lead

Responsibilities:

• Involved in requirements review, analysis and gap analysis of the applications
• Involved in scum meeting and Amigo review.
• Involved with ETL test data creation for all the ETL mapping rules.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in Data Migration.
• Preparation of Packages for validation of data from Staging Tables to Interface Tables.
• Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing
• Reviewed Test plan and test cases with business, developers and management.
• Executed Functional and Regression test cases and test scripts for Organizational and Vendor management tools
• Involved in Application Product Testing, Integration Product Testing and UAT.
• Identified and Created defects in Rally and worked with developers to resolve.
• Prepared lesions learned and flow / process documents
• Tested UI design, flows, screens and navigation to all modules of applications.
• Prepared daily, weekly and monthly metrics to management
• Extensively developed / used SQL queries to validate backend tables and database integrity.

Environment: Sqldeveloper, Oracle, SQL, TOAD, Rally, XMLspy, ALM, WinSCP,Talend openStudio (ETL)Client: - Confidential, Washington DC

Confidential

Test Lead

Responsibilities:

• Involved in requirements review, analysis and gap analysis of the applications
• Involved in scum meeting and Amigo review.
• Involved with ETL test data creation for all the ETL mapping rules.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Preparation of Packages for validation of data from Staging Tables to Interface Tables.
• Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing
• Reviewed Test plan and test cases with business, developers and management.
• Executed Functional and Regression test cases and test scripts for Organizational and Vendor management tools
• Involved in Application Product Testing, Integration Product Testing and UAT.
• Identified and Created defects in Rally and worked with developers to resolve.
• Prepared lesions learned and flow / process documents
• Tested UI design, flows, screens and navigation to all modules of applications.
• Prepared daily, weekly and monthly metrics to management
• Extensively developed / used SQL queries to validate backend tables and database integrity.

Environment: Sqldeveloper, Oracle, SQL, TOAD, Rally, XMLspy, ALM, WinSCP, Splunk,RIT, ETL

Confidential, Mentor, OH

Test Lead

Responsibilities:

• Involved in requirements review, analysis and gap analysis of the applications
• Preparation of Packages for validation of data from Staging Tables to Interface Tables
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Drafted and Developed test plan and test cases test scripts for Functional, Integration and regression testing
• Reviewed Test plan and test cases with business, developers and management.
• Executed Functionaland Regression test cases and test scripts for Organizational and Vendor management tools
• Involved in Application Product Testing, Integration Product Testing and UAT.
• Validated organizational process, project management and employee management like employee payroll and benefits based on employee grades.
• Identified and Created defects in Quality Center and worked with developers to resolve.
• Prepared lesions learned and flow / process documents
• Tested UI design, flows, screens and navigation to all modules of applications.
• Prepared daily, weekly and monthly metrics to management
• Extensively developed / used SQL queries to validate backend tables and database integrity.

Environment: Oracle Apps, Oracle, SQL, TOAD, Quality Center, Windows, MS-Office Suite.

Confidential, Minneapolis, MN

SR.QA

Responsibilities:

• Analyze and identify the gaps on business requirements - BRD, HLD of the applications
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Tested a number of complex ETL mappings, applets and reusable transformations for daily data loads.
• Extracted data from various sources like Oracle.
• Resolve the gaps and draft a test plan based on requirements
• Develops test cases and test scripts for Functional, Integration and regression testing
• Reviews Test plan and test cases with internal teams and external teams
• Updated test plan, test cases and scripts based on feedback from teams and business, and loaded test cases in to Quality Center / ALM
• Executed Functional, Integration (End to End) and Regression test cases and test scripts for Work Request.
• Created defects in Quality Center / ClearQuest and works with development team and business to resolve defects
• Prepared lesions learned and process improvement documents
• Data conversion inbound and out bound of Taleo.
• Data conversion of Short term Disability.
• Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.
• Involved creating customer using ERP(Oracle Apps) Front End Environment, and Created Work RequestPrepared weekly metrics to management
• Extensively developed / used SQL queries to validate backend tables.

Environment: ERP (Oracle Apps), Oracle, SQL, TOAD, Quality Center (ALM), Clear Quest, UNIX,Agile scum.

Confidential

SR.QA

Responsibilities:

• Involved in review / analyze the business requirements.
• Developed test plan, test cases for Inventory module based on business requirements.
• Reviewed the test cases with SME and Business.
• Modified and enhanced the test cases based on SME and Business directions.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Used Quality Center for Test cases management and Defects management.
• Data conversion inbound and out bound of Taleo
• Preparation of Packages for validation of data from Created data for UAT
• Tested a number of complex ETL mappings, applets and reusable transformations for daily data loads.
• Created daily/weekly test cases metrics to provide status to management
• Worked with SME and business and cross functional teams in fixing and closing defects.
• Developed SQL Queries for Back end validations.

Environment: ERP (Oracle Apps), Oracle, SQL, TOAD, Quality Center (ALM), Clear Quest, UNIX, Agile scum.

Confidential, MN

Test Lead

Responsibilities:

• Involved in requirements and gap analysis
• Involved in APT,IPT and UAT
• Preparation of Packages for validation of data from
• Developed test cases, test plan based on requirements and user stories; executed test cases
• Worked on setting up the test beds for different configurations
• Involved in daily standups, scrum meetings, triage / defect meetings
• Tracked and maintained user stories in Rally and test cases in TFS / Test Manager
• Developed test scripts for Functional and Regression testing.
• Performed Functional, Regression, Security, Boundary, Scalability, Stress and SST.
• Used TCPMon to get request and response xml data
• Worked on complete defect life cycle.

Environment: Oracle Apps (R12) UNIX, SQL, SQL Server, MS-Office Suite.

Confidential

Test Lead

Responsibilities:

• Leading Oracle Apps Team.
• Involved in APT,IPT and UAT
• Preparation of Packages for validation of data from Staging Tables to Interface Tables.
• Worked with developers, business and cross functional teams in fixing and closing defects.
• Performed Back end validations using SQL Queries and UNIX commands.

Environment: Oracle Apps, UNIX, DOS, SQL, Oracle, TOAD, Agile, MS-Office Suite.

Confidential

Sr. QA Analyst

Responsibilities:

• Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .
• Extract data file from vertex tool and upload it Unix
• Run SQL loader program
• Extract employee from different state in USA and run Quick pay
• Involved in APT,IPT and UAT
• We are giving Techno function support
• Preparation and validation for Oracle Package, Procedure, Function and view.
• Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.
• Online transaction processing, inventory management and etc.
• Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Confidential

Responsibilities:

• Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .
• Extract data from legacy system and upload to Oracle Base Table.
• Run SQL loader program
• Extract employee from different state in USA and run Quick pay
• Involved in APT,IPT and UAT
• We are giving Techno function support
• Preparation and validation for Oracle Package, Procedure, Function and view.
• Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.
• Online transaction processing, inventory management and etc.
• Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Environment: Sqldeveloper, Oracle, SQL, Talend openStudio, TOAD, Rally, XMLspy, ALM, WinSCP, Splunk, RIT

Confidential

QA Analyst

Responsibilities:

• Involved in Integration testing (End to End) from customer creation, Developed Test plan and executed Test cases based on FD .
• Extract data file from diffrent source and load to source table
• Run SQL loader program
• Involved in Data cleanse.
• Involved in APT,IPT and UAT
• We are giving Techno function support
• Preparation and validation for Oracle Package, Procedure, Function and view.
• Involved in ongoing support like Data Creation, execution support and resolve issues for (UAT) User Acceptance Testing.
• Online transaction processing, inventory management and etc.
• Extensively used defect tracking tools like Quality Center, ALM, Rally / Clear Quest etc.

Environment: Sqldeveloper, Oracle, SQL, Talend openStudio (ETL), TOAD, Rally, MySQL, ALM, WinSCP.