PROFESSIONAL SUMMARY:

• 8 - years of experience in Software Quality Assurance (QA) and tested Data Warehouse Database (ETL &BI), Data Analysis, Web Services, and Client-Server Systems and Applications for P&C Insurance, Banking-Mortgage, Financial and Healthcare domains.
• Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Extensive working knowledge on P&C Insurance domain.
• Involved in developing and maintaining Test Matrix and Traceability Matrix.
• Experience in implementing various QA methodologies involving preparing Test Plans, writing Test Cases and executing them.
• Strong in handling defect tracking and reporting process using ALM, Rational Clear Quest, Team Foundation Server- TFS, JIRA, Rally, Bugzilla.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Experience in implementing Point of Sale (POS) system that replaces Legacy System in the Stores and Warehouse with added functionality enhancement.
• Solid exposure to Data Analysis, Data verification, Data Migration, Data Validation and Data Cleansing.
• Extensively worked on database query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Experience on working with different models such as Star and Snowflake and strong working knowledge in dimensional modeling.
• Excellent working experience in banking involving residential Mortgage and Loan Origination Systems.
• Expertise in test management using HP Quality Center and maintained versioned objects using Rational Clear Case.
• Experienced with ETL tools like Informatica, SSIS, Datastage, and Ab Initio.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Worked in Product Testing, CRM Testing, Web Testing, DW-BI Testing and MDM Testing.
• Experience working in a FACET environment and gained knowledge about various modules of a FACET system such as claims, membership and pre-pricing etc.
• Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7
• Experience worked on any requirement upgrade and/or change request while doing UAT.
• Skilled knowledge on different modules within Healthcare Claims Adjudication Process (Membership process, Billing process and enrollment and claims processing).­
• Created Data Driven tests using SOAP UI to test the web services with different inputs
• Experienced in testing Crystal, SSRS, Cognos and Business Objects, OBIEE Reports.
• Experience in Data Analysis, Data Validation, Data Verification, data profiling, identifying data mismatch and Good experience with data sources.
• Tested several complex reports generated by Business Intelligence tool like Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors. 
• Extensively worked on Batch scheduling tools such as Autosys to run and monitor ETL jobs.
• Involved in preparation of RTMs, Defect Reports and Weekly Status Reports.
• Knowledge on the phases of Agile methodology.
• Experienced in coordinating testing effort between on shore and off shore teams.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.

TECHNICAL SKILLS:

QA TOOLS: ALM, JIRA

ETL TOOLS: Informatica Power Center, Informatica IDQ, 9.x/8.x/7.x, Ab Initio

DBMS / Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Databases: Oracle11/g/10g/9i, SQL Server 2008/2005/2000 , DB2, Sybase Teradata V2R6/V2R5

Languages: SQL, PL/SQL

Version Control Tools: Rational Clear Case, CVS, WIN

Requirements Tools: Doors

Operating Systems: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

BI / Reporting Tools: IBM Cognos 8.0, MicroStrategy, Business Objects BOXI, SSRS, SSAS

Other Tools: TextPad, PuTTY, MDM, SOAP UI, Web Services

Guidewire workshop: Policy, Claim and Billing Center Application

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

DWH/ ETL | UAT BI | Guidewire Application Tester

Environment: GuideWire Insurance Suite, Agile, Cognos10.0, RALLY, SQL, PL/SQL, HP ALM, SSIS, SQL Server 2008R2, Windows, Clear Quest, SQL, MDM,PL/SQL, Micro Strategy, UNIX, Putty, SOAP UI, Shell Scripting, Soap UI, SOA, Web Services, .NET, HTML, ASP .NET

Responsibilities:

• End to End testing of Guide wire Insurance Suite 7.0 (Policy, Billing & Claims) and Supporting DWH and Business Intelligence Solutions
• Sprint planning for determining & Documenting Testing efforts required for deliverables targeted for iteration/releases
• Working with release manager/DBAs for deploying right application build into the Testing as well as Development environment.
• Application Clock Movement and Batch Run as well carrying out users/administrative roles/permissions(Agents/UW) in the application for testing functionalities supporting core insurance operations —underwriting, policy administration, billing, and claims
• Tested Business Requirement/ETL Mapping Rules/Reports against various GW functionalities/modules and data flows from UI to OLTP DB to Replication DB to Staging to Data Mart/EDW to Reports
• Integration testing between the systems (Policy, Billing & Claims) to create test data/scenarios for ETL, BI and UAT Testing manually as well as by employing UFT
• Performed Back-End testing using SQL queries within the QTP Script to compare and retrieve data by using Data Base Check points.
• Validated the responses of web services by passing various requests in SOAP UI.
• Worked in Product Testing, CRM Testing, Web Testing, DW-BI Testing and MDM Testing.
• Involved in implementing MDM initiatives to improve corporate wide address validation via a web service and third party software.
• Validating the Data Mapping logic against business rules, UI, data dictionaries and SQL query results
• Performed Negative testing using SSIS to find how the packaging performs when it encounters invalid and unexpected values
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Validating on-demand as well as periodic/delta/daily data loads/refresh and reconcile loads across various databases
• Validating the data flow from UI through to Staging DB to Reporting Data Mart using SQL Scripts
• Validating Data Migration & Conversion of Policies, Claims from multiple Legacy Sources into GuideWire Application and supporting DWH and BI solutions.
• Created Data Driven tests using SOAP UI to test the web services with different inputs
• Validating data flows/mismatch between staging DB and dimensional model
• Work with BA,DA,ETL Developer, BI Developer and Users for ad-hoc solutions/Reports
• Attended review sessions with Data Analyst for any structural change (Due to incomplete Business requirement/granularity issues) and upgrade in the Data Mart solutions/Table solutions
• Reviewing report requirement with BA and ensuring if they contradict granularity or is supported by existing functionalities as well as DWH solutions
• Data Creation in each Center for validating the UI & creating complex scenario that would suffice the Reports targeted for the sprint/iteration/releases
• Tested critical Query Studio/Report Studio reports generated from Cognos for cosmetic errors, Functional error and Data Mapping error.
• Tested reports generated in business objects and Micro strategy.
• Running period reports in production environment track issues in Serena Business Manager-An IT task Management/Ticket Management Tool
• Wrote Complex SQL queries to support and validate the tables and reports under test.
• Testing in Development, Test, Stabilization, UAT and production environments.
• Extensively involved in functional testing, regression testing, performance testing, volume testing
• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.
• Attended Defect Review meeting for tracking/escalating defect status to the team
• Tracking Defects, generating defect Reports in ALM/Quality Center as per Severity and Priority
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Test Management through ALM and RALLY.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments

Confidential, Los Angeles, CA

Sr. DWH | ETL| UAT BI Tester

Environment: UNIX, Informatica 9.1, Data Stage 8.0, SQL, Clear Case, Clear Quest, RequisitePro, Quality Center, SharePoint, Web Services, SOA, Soap UI, Web Services, MDM, Micro Strategy, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, PuTTy, Flat Files, Session Logs, Rally.

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.
• Performed Manual Testing as well as Automation Testing for the EDI transactions.
• Worked on the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Performed Data Validation by testing the delta/daily and reconcile/data loads. 
• Created SQL compare statements to validate Actual results with the Expected Results.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL. 
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Created Data Driven tests using SOAP UI to test the web services with different inputs.
• Worked on Different Modules like Billings, Membership, Claim and Provider in MMIS application.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Developed Test cases as well as Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Developed and executed test cases and test scripts, and also worked with the UNIX shell scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Used HP Quality Center as test management tool.
• Validated the responses of web services by passing various requests in SOAP UI.
• Tested Cognos Reports according to the business requirements.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down reports.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Extensively written SQL to confirm the data transfer from sources to target.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files, querying the database) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL mappings through data stage director and monitored status.
• Tested the ETL Data Stage and other ETL Processes (DW Testing). 
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Confidential, Manchester, NH

QA DW ETL Tester | QA Analyst | Data Analyst

Environment: HP Quality Center 10.00, Oracle 11g, TOAD, UNIX, IBM Cognos 10, Flat Files, Session Logs, SQL/PL SQL, Business Objects, SQL Server 2008 R2, Ab Initio, SSIS, SSRS, XML, SOAP UI MDM, Rational Clear Quest, Clear Case SharePoint, Micro Strategy, Web Services, Soap UI, SOA, DB2, PL/SQL, PuTTy, Flat Files

Responsibilities:

• Tested and Validated the Migration data based on the Migration Mapping requirement and also had been a part of the EDW Redesign team as Migration/ETL tester.
• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Completed Provider and Member data migration validation, while created test plan and testing strategy for Sponsor and Claim data validations and migration.
• Tested reports generated in business objects and Micro strategy.
• Written Complex SQL Query against the EDW database for the data migration and validation. Responsible to translate business requirements into quality assurance test cases. 
• Reviewed test scenarios, test cases and Data warehouse Test Results. 
• Developed test scripts using SQL queries to validate data.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
• Extensively used TFM to track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities. 
• Reviewing the test activities through daily Agile Software development stand-up meetings.
• Once the EDW redesign was successfully completed, was transferred to Production Support as QAT for Production Support where my responsibilities were creating Test plan, Test Scenarios and Test cases based on Service Desk Express tickets assigned to Production Support Team.(Service Desk tickets assigned from EDW, Interfaces and Extracts /Business Intelligence(BI) Reports(Crystal and Cognos)
• Providing Test Execution reports and Defect Test reports through Dashboard (Excel combination of Both Test and Defect Report) to the Business and Project Manager.
• Working with Production Support team to go through the service desk tickets assigned, and determine the ETA for fixing the issue and promote it back to the Production.
• Creating Project Plan with milestones encompassing resource requisition, Environment Schedules, Start/End dates for Test Planning, Test Data and Test Execution phases.
• Analyzing Help Desk Support workflows and assisted in the development of code to fix the issue related to the tickets assigned.
• Found the defects when running the test cases and assign to Production Support Developers using Quality Center.
• Preparing the SQL script to validate the data of Interfaces/Extracts and Reports in the backend (Database) using SQL Server Management Studio and SQL Navigator.
• Came up with various compound SQL queries while validating the code change done by Production Support Developer to fix the issue and close the ticket assigned.
• Responsible for Query Log, Defect Log, Work Allocation Sheets, Daily Status Reports.
• Executed and validated various SSIS packages in effort to run the different Units/extracts (CSV, XML).
• Requirement Traceability Matrix was created and well maintained in order to confirm the full requirement coverage.
• Created Data Driven tests using SOAP UI to test the web services with different inputs.
• Tested the ETL Processes, Interfaces and Extracts, Reports, Web Applications, Utility Apps, BizTalk and Minor Enhancement Requests (Enhancement requests to existing units).
• Based on the ticket (requirement for Production Support) assigned Cognos and as well as Crystal Reports was tested.
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.

Confidential, Seattle, WA

DW UAT ETL Tester | POS Tester | QA Analyst

Environment: Ab Initio (GDE 1.14), SQL *Loader, PL/SQL, SQL, PL/SQL, T-SQL, XML, XSLT, XML Spy 2008, Rally, SOAP UI, Web Services, Oracle 10g, Micro Strategy, Business Intelligence, Cognos, SQL Server 2008, PeopleSoft, MS Visio, Windows 7/ XP

Responsibilities:

• Implemented Point of Sale (POS) system that replaces Legacy System in the Stores and Warehouse with added functionality enhancement.
• Worked as an ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Responsible for testing the reports according to client’s requirement using Business Objects.
• Validated the joins and data using the business objects universe.
• Validated PeopleSoft information getting consolidated into reporting database to allow combined reports to be generated.
• Tested reports generated in business objects and Micro strategy.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Prepared technical specifications and Source to Target mappings.
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Tested SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Created Data Driven tests using SOAP UI to test the web services with different inputs
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Involved in testing Ab Initio graphs based on data mapping requirements.
• Written complex joins to validate large database volumes.
• Collected performance statistics of each query, function, and procedure and worked with business users for acceptable performance criteria.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Used UNIX to run the graphs related to Ab initio.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts and validated them.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Responsible in testing Initial and daily loads of ETL Ab Initio graphs.
• Validated complex Ab initio graphs using SCD type II involving transformations such as Expression, joiner, aggregator, lookup, update strategy, and filter.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.

Confidential, Louisville, KY

DWH | ETL | UAT BI Tester

Environment: Rational Manual Tester, ClearQuest, Cognos, ASP.NET, VB.NET, IIS, SQL, SSIS, SQL Server 2005, SOAP UI, Mainframes, XML, Oracle 9i, SQL Navigator.

Responsibilities:

• Worked as an ETL/BI Report Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Developed Test Plan and Acceptance Criteria.
• Involved in Business Functionality Review meetings, JAD Sessions and Use-Case Analysis.
• Followed Agile testing methodology and performed testing in iterations.
• Experience with executing both functional, usability and deployment testing
• Attended daily Scrum calls for status report
• Extensively participated in Sprint retrospective for improved process
• Performed both Manual and Automation testing
• Conducted SIT, System, Functional, GUI and UAT Tests
• Tested the Patient Management in EPIC
• Tested the Billing (Professional/Hospital) and claims.
• Validated the claims for Medicare.
• Created Data Driven tests using SOAP UI to test the web services with different inputs
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Extensively mapping the requirements to test cases -- Traceability Matrix.
• Enhanced the automated Regression Scripts and Conducted Data Driven Testing.
• Tested the ETL (Extraction, Transformation and Loading) process using Informatica.
• Performed Schema validation, inbound and Outbound Data Validation.
• Tested the source, Target databases, mapping and Transformations.
• Worked with data files (Flat Files, XML, SAS) Data files.
• Performed Data Validation and backend testing by writing SQL queries.
• Tested the reports generated using Business Objects.
• Responsible for validation of user credentials and password validation for web portals.
• Supervised the use of Rational Clear Quest for Defect Reporting.
• Responsible for preparation of weekly status report.