PROFESSIONAL SUMMARY:

• Having 11+ Years of Extensive Experience end - to-end Data Warehouse Testing, Data Migration, BIG DATA Testing, Automation Testing, SOAP UI, Mobile Testing and Guidewire Testing Projects.
• Expertise in Guidewire Policy Center, Billing Center, Claim Center, Contacts Manager Applications testing.
• Expertise in ETL Testing, BI Testing, Database Testing and Report testing.
• Experience in BI tools testing like OBIEE, ODI,BO, BODS, SSRS, SSIS, Cognos, Tableau, QlikVeiw, Abintio, Data stage and Informatica.
• Experience in BO Reports and OBIEE Reports, Tableau Reports Development.
• Experience in PIG scripting and HIVE scripting for BIG DATA applications.
• Experience in Apache Oozie Job Scheduler & AutoSys Job Scheduler.
• Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, Functions & Triggers using SQL Developer and TOAD as development tools.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277, 837/835 transactions.
• Having experience in Informatica TDM, Oracle MDM, Informatica IDD, IBM InfoSphere and IBM Curam Software.
• Expertise in Software Testing Life Cycle (STLC) & Bug Life cycle and SDLC.
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents
• Having Experience in Insurance, Heath Care, Financial, Banking, Sales & Airline Domain.
• Experience in Design, Execution and reviewing of Test cases/Test Scripts/SQL Scripts.
• Experience in different types of testing Retesting, Regression, Risk Based, BAT,GUI, System, SIT, UAT, E2E, Sanity, Pilot, Ad-hoc, Security, Boundary, Browser Compatibility, Smoke Testing.
• Having good knowledge on HP QTP Automation using VB Script and Descriptive Programming.
• Having Good knowledge on SOAP UI testing, Selenium Web driver, IDC, Selenium RC, BDD Cucumber Automation tools.
• Good Experience on Wed based Applications & Client Server applications.
• Having experience in Agile Methodology, Waterfall Methodology & V model Methodology.
• Expertise in working on Defect Tracking Tools (HP ALM, HP QC, JIRA and Bugzilla, Clear Quest).
• Experience in managing onsite and offshore QA teams.
• Ability to produce realistic Testing schedules and Test Planning and able to handle big size of Testing team.
• Quick learner, good interpersonal skills and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/2000/NT, MAC Power PC 10.4,Unix

BI Tools: BO XIR2,BODS,SSRS,SSIS,Informatica,ILM Cognos, AutoSys, QlikVeiw, OBIEE, Oracle MDM, IDD Tableau, Datastage, Abintio and ODI 12C.

Automation Testing Tools: QTP 9.2, BDD Cucumber, Selenium Web Driver, SOAP UI

Databases: Oracle 11G, SQL Server 2008, Teradata, DB2, MongoDB, Netezza

Languages: C, C++, TSL, VB Scripting, Shell Scripting, Java.

Web Technologies: HTML, ASP, Java Script

Test Management tools: HP ALM, Project Place, JIRA, Quality Center, TFS, Clear Quest, Rational DOORS Next Generation (RDNG),RTC

Browsers: IE, Safari, Firebox,Crome

Guidewire Tools: Policy Center, Billing Center, Claim Center and Contacts Manager

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento

Data Migration Test Lead

Environment: Guidewire Policy Center, Billing Center, Claim Center Contacts Manager, SSIS, XML, SOAP UI, SQL Server UNIX, SQL Server Agent, TFS and IBM AIX and Cognos.

Responsibilities:

• Understanding Busiess requirments and Trasformation logics.
• Understadning the mapping document and Desingn Document.
• Reviewed the Design Document with the whole project team in order to make sure the requirements are feasible to implement and testable.
• Prepared Test Strategy and Test Paln for this Data Migration.
• ETL Jobs status monitoring on production server.
• Validating Data Completeness and Corrects of Loaded data in Target System.
• Identified effective test data, tracked Business and system Requirement coverage.
• Understanding the Functionality of the Cognos Reports.
• Involved in the Congos Reports Data validation with Source tables.
• As per end user requests prepared and sent Cognos Adhoc reports.
• Involved in end users taining on Cognos reports preparation.
• Validated the Cognos report format and layout with Business requiments.
• Validated Congos Report Filters and Prompts as per BRD document.
• Involved in the preparation & Execution of SQL scriptcs to validate the Target Data.
• Designed Test Cases as per the requirement specifications and Mapping Document.
• Created Test Cases and Test Scripts to validate Source and Target data.
• Developed and executed Re-usable SQL Scripts.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Analyzed the root cause of the failed Test cases and provided the related data samples to the client.
• Detected issues and logged and classified them based on the severity.
• Validated Congos reports data with source data and Targrt data.
• Interacting with the developers on a regular basis for load updates and defect fixes.
• Managed the execution in Test Management Tool HP ALM.

Confidential, New York

ETL QA Lead

Environment: Abintio, Oracle 11G, UNIX and QlikVeiw, AutoSys, SOAP UI, XML files, Flat Files, SQOOP, Flume, HiveQL, Pig Latin, BDD Cucumber, Selenium Web Driver

Responsibilities:

• Understanding the Business requirements & Mapping document.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents.
• Mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Involved in testing the batch programs by using the AutoSys tool.
• Exclusively tested the inbound and outbound batch jobs.
• Validated stored data in Hadoop layer using HIVE.
• Validated ETL Mappings (Extract, Transform and Load) scripts and jobs by using SQOOP and A PIG to import data from Source systems to HDFS.
• Clarification log preparation and monitoring the status.
• Created and Reviewed Test Scenarios, Test Cases and Test Data
• Understanding on each source systems and its transactions.
• Verifying QlikVeiw Dashboard Data.
• Sending Daily status reports to Confidential QA manager

Confidential, New York

ETL QA Lead

Environment: Informatica 9.1, Business Objects, Oracle 11g, SQL PL/SQL, XML Spy 2013, Teradata V2R6, Teradata SQL

Responsibilities:

• Wrote test cases based on ETL mapping document for testing the entire ETL workflow.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Backend integration transferring data, extracting data and loading into RDBMS such as Oracle and SQL Server.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL Work Flow Validation.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Extensively involved in manual testing of validating the XML files and the corresponding exception handling scenario.
• Validated the XML files of Merchants data coming through OFD end point
• Performed integration testing, Unit testing, regression testing and load testing on various modules
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Automation of Ab Initio graphs using AutoSys Jobs.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Understanding the Functionality of the Business Objects Reports.
• Involved in the Business Objects Reports Data validation with Source tables.
• Validated the Business Objects report format and layout with Business requirements.
• Validated Business Objects Report Filters and Default Filters as per BRD document.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System JIRA to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results
• Involved in design, source to target mappings between sources to operational staging targets, using Informatica Designer.
• Involved in performance tuning of the jobs
• Used T-SQL for validating the data generated at OLAP server.

Confidential

Sr.Software Quality Control Engineer

Environment: BO, Informatica 9.1, Oracle 11 G, FACETS Test Management tool: HP Quality Centre 9.2

Responsibilities:

• Understanding the requirements & Functionality of the Reports.
• Experienced in testing different solutions such as FACETS, EPIC and other claim processing solutions.
• Managed all phases and FACETS of a multiyear implementation.
• Tested Claims processing flow by dropping claims through the HIPAA gateway
• Created mapping's for Backend systems for EDI transaction and Web Interfaces.
• Review and understand the ETL processes, functionality & identify test requirements and coverage
• Involved in the Reports Data validation with Source tables.
• Involved in the preparation & Execution of SQL scriptcs to validate the Target Data.
• Involved in the preparation & Execution of Test cases.
• Understanding the Functionality of the Business Objects Reports.
• Involved in the Business Objects Reports Data validation with Source tables.
• Validated the Business Objects report format and layout with Business requirements.
• Validated Business Objects Report Filters and Default Filters as per BRD document.
• Involved in Preparation of Test plan.
• Logging and tracking defects through HP QC 9.2

Confidential

Sr.Software Quality Control Engineer

Environment: SSRS Dashboard, SQL Server 2005

Responsibilities:

• Understanding the requirements & Functionality of the application.
• Involved in the preparation & Execution of Test cases.
• Involved in the Data validation of Dashboard with Source.
• Logging and tracking defects through JIRA
• Preparation of Defect Summary Report
• Reporting to the onsite Coordinator about the Status on daily con-call

Confidential

Sr.Software Quality Control Engineer

Environment: BO, BODS, SQL Server 2005

Responsibilities:

• Understanding the requirements & Functionality of the BO Reports.
• Involved in the preparation & Execution of Test cases.
• Understanding the Functionality of the Business Objects Reports.
• Involved in the Business Objects Reports Data validation with Source tables.
• Validated the Business Objects report format and layout with Business requirements.
• Validated Business Objects Report Filters and Default Filters as per BRD document.
• Logging and tracking defects through JIRA

Confidential

Sr.Software Quality Control Engineer

Environment: .Net, C++ and SQL Server 2005

Responsibilities:

• Understanding the requirements & Functionality of the Reports.
• Supporting End Users of OtisPlan+ across the world.
• Involved in the preparation & Execution of Test cases.
• Involved in the Presentation Reports Data validation with Source tables.
• Logging and tracking defects through HP QC 9.2

Confidential

Test Engineer

Environment: J2EE, Struts, Windows 2000, Web logic, Oracle10 G

Responsibilities:

• Understanding the requirements & Functionality of the application.
• Involved in the preparation of Test cases.
• Involved in the Preparation of Test data.
• Identified Test requirement and checked if the test cases were complete enough to test the Business functionality
• Experience in bug tracking and solving with project teams.
• Interacted with Developers and discussed technical problems, reported Bugs
• Analyzing test results & reporting Issues using Project Place.
• Attended weekly status meetings and provide detailed Status report to the Client.

Confidential, Kansas City

Test Engineer

Environment: Microsoft .Net, Oracle, HTML.

Responsibilities:

• Coordination with Team
• Involved in writing Test cases and executing Test cases.
• Involved in Peer Reviews
• Bug Reporting through Clear Quest
• Preparation of defect summary report And test data
• Involved in Status updates, Review meetings with the clients.
• Extensively performed Manual Testing process to ensure the quality of the Application.