SUMMARY

• Over 9 years of IT experience with Analyzing/ Designing/ Developing testing operations in several business areas including Insurance, E - Commerce and Banking.
• Having 6 years of experience in Analysis and Testing of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expertise in OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Expertise in writing SQL Queries using Oracle 11g, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
• Extensive experience in ETL Test processes, Business Intelligence, QA Testing and Test Methodologies.
• Proficient experience in Oracle Apps 11i/ R12 - E-Business Suite, Financial modules like General Ledger(GL), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets(FA) and FAH interface.
• Experience in testing of Oracle Applications modules, Multi Org, TCA Architecture, Multi Currencies Setups, Chart of Accounts, multiple payment processing methods, integrations with external banks, and financial institutions, and Invoice processing.
• Extremely involved in preparation of Test Plan and Test Strategy documents.
• Extremely involved in writing Test Scenarios, Test Cases, Test Execution, Defect Tracking and follow-up’s with dev and BA teams.
• Strong working experience on Different types of testing viz., Integration testing, System Integration testing, End to End testing, Regression and UAT testing and so on.
• Very good experience in preparation of Requirement Traceability Matrix(RTM), Test Summary Reports, Daily execution status, WSR reports and Defect Life Cycle Management.
• Experience on testing using tools such as Selenium, QTP Pro 8.2/9.2/11.0.
• Extensive experience in QC/ALM-11.0(Test management tool) and Very good knowledge in Microsoft Team Foundation Server 2012 (TFS-2012) and Microsoft Test Manager.
• Expertise in Software Development (SDLC) and Testing Life Cycles (STLC).
• Worked under project methodologies like Agile, Waterfall, Incremental Models and have a knowledge in other project methodologies like SCRUM, Prototype, V-Model.
• Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.

TECHNICAL SKILLS

Operating Systems: Windows 7 and 8 /XP, Windows NT 4.0, 2000, and UNIX.

ERP Technologies: Oracle Apps 11i and R12, Finance Modules - GL, AR, AP, FAH and FA.

ETL Tools: Informatica 9.1/8.6.1/8.1.

Databases: MS-Access, Oracle10g,/11g.

Languages: C, C++, JAVA, SQL, PL/SQL, Visual Basic, VB Script.

Testing Tools: QTP8.2/9.2, 11.0, Selenium, Load runner 9.0 and Test director, QC, ALM 11.0, TFS 2012, Test Manager, e-PMO, Bugzilla, JIRA, Mantis, BugHost, Issue tracker, Oracle SQL Developer, MS SQL Server

Configuration tools: SVN, VSS and CVS.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Senior QA and ETL Test Analyst

Responsibilities:

• Understanding the Business Requirements and involved in identifying scope of testing.
• Involved in preparation of Test planning document and Test Strategy document.
• Understand the data mapping from source to target tables and business logic used to populate target table.
• Writing and execute the SQL queries to make sure the data from Source systems to Target tables and validated the Transformations/Business logics.
• Verify the Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Making sure the all transactional level/ Policy masters data is moved to OLAP warehouse data base.
• Involved in Oracle EBS application configuration testing for financial modules.
• Involved in preparation of Test execution status, weekly status reports, Capacity Utilization and Forecast reports, and Test metrics reports.
• Responsible for performing Sanity and Smoke testing before kickoff System Testing.
• Responsible for internal and external Reviews for Test Description document and track the Review records till closer.
• Responsible for conducting time to time Knowledge Transfer meetings and imparting domain knowledge within Offshore and Onshore teams.
• Task assignment to team members and making sure the all offshore deliverable.
• Participates in regular Defect meetings with developers and Management for reviews, walkthroughs and bug dance.
• Responsible and helps to Test Manager in preparation of Test release document.

Environment: Oracle Apps EBS- R12, Informatica 9.1, OBIEE, Infogix, Oracle 11g, AutoSys, TRECS, CorpTAX, Windows 7, UNIX, Testing.

Confidential, Columbus, OH

Senior ETL Tester

Responsibilities:

• Understanding the Business Requirements and involved in identifying scope of testing.
• Involved in preparation of Test planning document and Test Strategy document.
• Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data.
• Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.
• Writing and execute the SQL queries to make sure the data from Source systems to Target tables and validated the Transformations/Business logics.
• Verify the Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Responsible for performing Sanity and Smoke testing before kickoff System Testing.
• Responsible for internal and external Reviews for Test Description document and track the Review records till closer.
• Responsible for conducting time to time Knowledge Transfer meetings and imparting domain knowledge within Offshore and Onshore teams.
• Participates in regular Defect meetings with developers and Management for reviews, walkthroughs and bug dance.
• Responsible and helps to Test Manager in preparation of Test release document.
• Extensively performed ETL and QA Testing process to ensure the quality of the software.

Environment: Informatica 8.6, OBIEE, Oracle 10g, TOAD for Oracle, Quality Center 10.0, MS Excel and Windows XP, UNIX, AutoSys tool.

Confidential, Schaumburg, IL

ETL Tester

Responsibilities:

• Understanding the Business Requirements and involved in identifying scope of testing.
• Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data.
• Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.
• Writing and execute the SQL queries to make sure the data from Source systems to Target tables and validated the Transformations/Business logics.
• Verify the Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Performed Sanity and Smoke testing before kickoff System Testing.
• Responsible for conducting time to time Knowledge Transfer meetings and imparting domain knowledge within the teams.
• Responsible for preparation of Test case design documents and Test data set up's according to business requirements of clients. .
• Coordinated with project managers and developers, and analyzed all tests conducted on various products and components.
• Involved in Integration, Functional, System Integration, End to End testing, Regression Configurations, Security, Nonfunctional Tastings.
• Involved in stress tests on various web applications and ensured its compatibility with operating systems.
• Documented all automated scripts, prepared variable checks and conducted stress tests.
• Responsible for conducting time to time Knowledge Transfer meetings and imparting domain knowledge within teams.
• Participates in regular Defect meetings with developers and Management for reviews, walkthroughs and Defect meetings.
• Extensively performed ETL and QA Testing process to ensure the quality of the software.

Environment: .Net, ASP .Net, HTML, DHTL, Informatica 8.6, Oracle Reports, Oracle 10g, Oracle SQL Developer, Quality Center 10.0, QTP 10.0, MS Excel and Windows XP, UNIX, AutoSys tool. Manual and Automation Testing.

Confidential

QA Consultant

Responsibilities:

• Understanding the Requirements, Functional Specifications and the Application.
• Involved in designing the Test Cases using Functional Specifications Conducted extensive manual Black Box testing to better understand the functionality of the Application.
• Peer reviewed the Test Cases and made recommendations.
• Test Environment Setup and Performed the Functional and Regression Testing
• Detecting bugs, classifying them based on the severity, and documenting them.
• Open Defect\'s with help of Bugzilla wherever discrepancies found in the code and assigning them to development Team.
• Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Coordinated with Developers for Defect analysis and performed Regression Testing.
• Developed Test Matrix to give a better view of testing effort.
• Extensively performed Manual Testing process to ensure the quality of the software.

Environment: JAVA, Servlets, JSP, J2EE, JDBC-ODBC, ORACLE 9i, Tomcat 5.5, Manual and Automation Testing.