SUMMARY

• Highly skilled and result oriented professional with more than 12.5 yearsdiversified experience (including 7 years lead exp) intesting, quality assurance (QA) operations across large organizations, including a Fortune 40 company. Successfully worked as a lead on many projects, independently performed all the end - to-end QA tasks.
• 8 years of lead QA & BA experience in analysis and testing of efforts on Business Intelligence solutions, Business Architecture and Data Warehousing/ Data Mart Design, Data Analysis, Data Mapping, Manual, ETL, OLAP, Client/Server applications
• Possess strong knowledge in different IT industries on various domains including Insurance, Finance, Auto, Banking, Health Care, Mutual Funds (MF), Life, Internal Cash, claims, ECS (Electronic Claims Service) and P&C.
• Expertise in different types of testing on like GUI, Integration, Functional, Regression, System testing, Smoke testing, Negative testing, Black box testing, Grey box testing, UAT, Performance Testing, Implementation testing and Production support testing.
• As a test lead/BA lead worked on over 100 Business Intelligence (BI) projects at State Farm (SF). Projects include ETL, Data warehouse, Dashboard/Reports (Qlikview, Cognos, BO), EPMA (Extract engine & Supply engine), SR, Strategic Migration, Integrated and Hadoop.
• Expertise on various LOB/domains including Life, Bank, Mutual Funds (MF), Associate Register (AR), Client, Property & Causality (P&C), Confidential, State Farm Payment Plan (SFPP), Electronic Claim Services (ECS), Strategic Resources (SR), Bank Credit Card, Lead Management System (LMS), Agency Awards, Agency Analytics, Pulse.
• Knowledge in automation of Web-based and large Client/Server/Multi-tier applications.
• Worked in several areas of SDLC including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation. Independently completed End-End testing during the systems development life cycle (SDLC) for majority of my projects.
• Worked under testing methodologies like Agile-SCRUM and Waterfall Model. Expertise in AGILE Methodologies, AGILE Manifesto and Scrum processes. Directed test efforts using risk-based and agile methods
• Experience on big data Hadoop migration & EPMA (enterprise performance management analytics) projects & validation using extract and supply engine
• ETL/ Informatica Lead Tester, with focus on Data warehousing, Business Intelligence. Vast experience on validating Extraction, Transformation and Load (ETL), Includes ETL across different platforms, multiple databases to DB2 and flat files.
• Experienced with web services testing and automating using SOAPUI and REST
• Automation scripting using Win Runner, Jasmine, Load Runner and QTP including acquiring requirements, estimation, execution of the automation suites for different releases, as required, and doing analysis of failures.
• Knowledge in Selenium automation using Selenium, Java, Coded UI
• Excellent customer facing skills and able to handle multiple competing priorities in a fast-paced environment with strict deadlines, support business critical applications.
• Skilled in working across organizational boundaries, bringing together people with diverse perspectives and experience to find solutions.
• Motivated problem solver with strong analytical skills & capable and knowledgeable team member with excellent written and Verbal communication skills

TECHNICAL SKILLS

Domains: Auto, Health, Life, Bank, Mutual Funds, Client, Claims, ECS, Big Data Analytics, Analytics Dashboards, Sales Force, Hadoop, Infrastructure, Associate Register

Databases: Oracle, IBM DB2, Technical Platform Database (TP) postgres tables, Optim, TOAD, MS Access, SQL, PL/SQL

Operating Systems & Tools: Windows, UNIX/AIX, Linux (Putty & SSH Client)

Testing Tools: Test Link, Trac, Selenium, Quality Center/Application Lifecycle Management (ALM), JIRA, SOAPUI, REST, Rational Lifecycle Tool, Rational RequisitePro, Rational Test Manager, HP Quality Center, Rational ClearCase, HP ALM, Rational Clear Quest, Rational Functional Tester, Rational Manual Tester, IBM Optim, Toad, HP Service Manager, Control M 10.1, 11.0, COBOL, CICS, JCL

Automation Testing Tools: Selenium, QTP, Load Runner

Languages/Frameworks: Java, Object Oriented Concepts, behavior-driven development (BDD), XML, HTML

ETL: Informatica 9.1.1 and 9.6.1 (Repository, Designer, Workflow Monitor, Data Map and Manager), Ab Initio

Microsoft Suite: Microsoft Project, Microsoft Office Applications, Access Database; MS Excel; MS Visio, Excel Functions, Financial, Pivot, Dashboards and charts.

Reporting Tool: Qlikview, Business Objects, Cognos, SAS

Others: MS SharePoint 2010/2013, IBM Doors, Lotus Notes, Primavera, Rational tools: Requisite pro, Rational Rose, Guide wire insurance suite (Policy Center, Billing Center. Claim Center), Clear Case, Office 365, Skype for Business, Ultraedit

PROFESSIONAL EXPERIENCE

Confidential, Bloomington

Test Lead

Responsibilities:

• Worked with SME, Business Analysts, Developers and product owners in understanding and analysis of requirements (functional, technical) and design specifications for conversion and ETL.
• Involved with working in all the phases of SDLC methodologies.
• Major Job responsibilities as a test lead includes creation of Test Strategy, Test Plan, SUT, Test Cases, Test Logs, Test Results, Test Coverage Matrix, Evidence of Test (EOT), Test Summary Report; setting up test environment including data capture; executing and validating Test Cases; routing Validation Approval Package (VAP).
• Executed & validated ETL scripts on Linux server. Validated the outcomes from Extraction, Transformation and Load (ETL) as per requirements, source-target mapping and data transformation rules. Carried out the implementation testing and supported production implementation.
• Performed Defect Triage activities including root cause analysis and analyzing application logs for errors.

Test Lead

Confidential

Responsibilities:

• Interacted with business managers to understand the functionality of the application and developed the detailed test cases based on functional and technical requirements.
• Validated the functionality of extract engine and supply engine. Validated all the data in EPMA landing zone as per requirements, source-target mapping and data transformation rules.
• Involved in big data Hadoop testing (EIDC server). Validated target data in Hadoop platform in comparison with source data in technical platform (TP- postgres tables).
• Modernized architecture to provide more flexible solutions. Reduced or eliminate pain points with the current system. Improved customer experiences and provide more accurate information to business areas who consume CIM data.

Test Lead

Responsibilities:

• Analyzed & validated business requirements &ETL Mappings from Source to target tables for enhancements on different applications (LOBs) by conducting meetings, interviews, prototyping and Brainstorming sessions with stakeholders, SME, developers and product owners.
• Extensively used agile methodology’s best practices during the SDLC. Worked in a tightly integrated product suite in a fast-paced, highly collaborative, Agile /Scrum development environment.
• Major Job responsibilities as a test lead includes creation of Test Strategy, Test Plan, SUT, Test Cases, Test Logs, Test Results, Test Coverage Matrix, Evidence of Test (EOT), Test Summary Report; setting up test environment including data capture; executing and validating Test Cases; routing Validation Approval Package (VAP).
• Pairing up with developers/product owners to understand complex test cases. Tested Full load & Incremental load as a part of End-End testing & UAT testing.
• Compared data in FDW1.0 with data in FDW2.0 (before and after changes) for different applications. Wrote complex SQLQueries to check/validate data.
• Validated various reports using Cognos, Business Objects, qlikview reports and dashboards as per business requirements
• Defects were tracked, reviewed and analyzed using TRAC and reported daily to the project team.

Test Lead

Confidential

Responsibilities:

• Developed test cases based on business requirements, functional, technical specifications, and development standards. Test cases included test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Extensively used agile methodology’s best practices during the SDLC. Conducted every day scrum meetings with project team to improve the efficiency and productivity of each sprint.
• Major Job responsibilities as a test lead & providing all test deliverables
• Developed SQL queries for Source to Target Mapping &Back-end testing/Database testing as a part of end to end testing.
• Ensured Error logs and audit tables are generated and populated properly
• Validated Cognos & Qlikview reports based on Functional Requirements

Confidential

Test Lead

Responsibilities:

• Extensively used agile methodology’s best practices during the SDLC. As a sprint team member participating in Epic/Story workshops, estimations, building automation backlogs, planning, stand ups etc.
• Involved in full life cycle testing including GUI, integration, UAT, Regression test on new builds of the application.
• Worked with DBA in setting up the test environment, loading with data from multiple sources.
• Executed and tested Linux shell scripts. Automated the execution through control-M scheduler.
• Performed verification of Linux & informatica logs using Putty while performing the testing.
• Validated Extraction of test data from source and loading of data into DB2 tables. Completely tested and verified that the source data is extracted correctly, transformed and loaded into the data warehouse, reports.Validating the data passed to downstream systems
• Organized triage and cross functional meetings to discuss the priorities of defects logged and delivery time.
• Validated cognos and qlikview reports based on functional & nonfunctional Requirements.
• Tested Complex Reports in functionalities like Slice and Dice Drill Down Functions Cross Tabs Master/Detail and Formulae.

Test Lead

Confidential

Responsibilities:

• Created Complex test case scenarios, which requires EDI HIPAA and ICD10 knowledge.
• Evaluated on HIPAA compliances and HIPAA transactions. setting up test environment (both DEV and Formal/Simprod) and capturing test data for unit, system, acceptance and implementation testing. Scrubbing all SPI/NPI (sensitive) information as per SF standards.
• Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and also monitoring the Production Environment
• Involved in End-to-End system testing (major focus on functionality ®ression testing), UAT and implementation testing
• Identified and thoroughly analyzed defects, issues, risks, and action items along with identifying the business requirements & the system requirements as part of the project team.

Test Lead

Confidential

Responsibilities:

• Expertise in analysing& validating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery.
• Ensured Error logs and audit tables are generated and populated properly
• Performed Data Analysis and developed Data Mapping documents
• Involved in full life cycle testing (end-end) including regression test on new builds of the application.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Test Lead

Confidential

Responsibilities:

• Worked on Claim processing module which involved Receipt and Verification of Claim Forms, Claims Enquiry and Response, Adjudication, Healthcare Claim Payment/Advice.
• Adjudicated Medical (Professional and Institutional) Claims in Claims adjudication and procedures, pay professionals and members, select Individual claims for payments, change the claims status of an individual payment to hold or release, create, print, or display explanation of benefits (EOB) for a member or explanation of payments (EOP) for a provider.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Efficiently handled defect management process in all forms of testing.Conducted meetings with developers and SME in resolving the issues.

Environment: DB2 SQL, Windows, Unix/Linux Shell scripting, DB2 import/export, DB2 Load, Control - M scheduler, Informatica IDQ, Informatica MDM, Informatica Power Center, Agile, Ab Initio (Co.Op 2.15, GDE 1.15.9.2), HP ALM, MS Office, SOAPUI, REST, QC Oracle 9i/10g, PL/SQL, Teradata, Clear Quest, Cognos. BO, Qlikview, SAS,TRAC, Testlink, Technical platforms(TP), Hadoop EIDC server, EPMA extract engine, supply engine

Confidential, Chicago

Senior QA Analyst

Responsibilities:

• Responsible for interacting with client for requirements gathering, analyzing requirements, and creating detailed specifications. Resource planning, allocation as well.
• Involved in Preparation, Reviewing and Execution of test cases.
• Performed GUI, Functional, System and Regression Testing.
• Attending Daily status meetings and provide detailed status report to the client.
• Creating GUI Maps per coding standards. Creating and modifying Compiled Modules per coding standards.
• Creating /executing the test scripts using QTP and thereby getting the test results. Modifying the test scripts per coding standards. Update / generate the test cases based on the enhancement. Peer Reviews of the test scripts
• Analyzing the test results and reporting Bugs. Tracking the Bugs using Clear Quest until the Bugs are closed.
• Extensively performed manual testing to ensure the quality of the Software
• Worked with the Process leads to understand and document the clinical trial process.
• Coordinating Test data generation with Test data developer. Reviewing Test results. Preparing Test Status Reports from QC.
• Worked with the Lead BA to develop Requirement Management Plan and Communication Plan.
• Performed brainstorming session with the BA Team to analyze, validate and finalize functional requirements.
• Used Load Runner to regularly test performance life cycle

Environment: Java, Oracle PL/SQL, XML, UNIX, PVCS, HP-Load Runner, Mercury Quality Centre, UML, MS Office, MS Visio, QTP, HTML, SAS (Reporting)

Confidential, Rhode land, NJ

Sr. Test Co-coordinator

Responsibilities:

• Understanding the Requirements\FDs\EDs\Test Scenarios. Involved in Script Reviews
• Test Environment preparation (Perform Environment Smoke Test with new Builds)
• Test Case Preparation & Peer Review. Update the scripts with the enhancement documents. Developing test scripts using TSL.
• Reporting the Defects using the Quality Centre, follow-up on the defect status for closure. Documenting the Defects using Quality Centre
• Executing SQL statements to extracts data from tables and verify the output using SAS tool
• Guiding the new joiners in understanding the process (Execution/Defects etc)
• Creating and modifying Compiled Modules and function Libraries.
• Test Execution. Performing Data Driven Test for the developed test scripts. Involving in Regression testing.
• Tracking the defects through Clear case.
• Created customized LoadRunner VuGen scripts at API level with manual correlation, user defined functions, development libraries (classes and methods), and error handling
• Extensively used HP Loadrunner for performance testing
• Modified and Executed automated and manual test scripts for different modules using QTP

Environment: HP-LoadRunner, QTP, Oracle, PL /SQL, UNIX, MS Office, SAS (reporting)

Confidential

Sr. QA Analyst

Responsibilities:

• Performing functional and regression testing manually. Took more projects from Onsite specially to test the functionality. This involves in attending review meetings, preparing status reports, estimations etc.
• Analyzed Developers specifications and converted them into Manual Test Cases.
• Involved in preparing, reviewing Test Strategy Documents (TSD), Test Case Documents (TCD), Test Data sheets.
• Extensively performed Manual Testing process. Executing the TCD’s, while performing the functional/regression testing for various builds.
• Designed and developed test scripts using Quick test Professional and managed testing activities using Mercury Quality Center
• Firewall Monitor; Extensively used HP Loadrunner for performance testing

Environment: Java, Oracle, SQL, XML, UNIX, PVCS, Mercury Quality Center, Rational suite, UML, QTP, MS Office, MS Visio, HP-LoadRunner

Confidential

Responsibilities:

• Domain expert, Analyzed System and Functional Specification documents, understanding the Requirements
• Test Environment preparation (Perform Environment Smoke Test with new Builds)
• Report Defects, Follow-up on the defect status for closure.
• Preparation of the test plan, system test case preparation & execution
• Scripts Update - System testing scripts updates based on latest functional updates from business
• Review Test Artifacts. Preparation of Guidelines and Checklist
• Creating the Test Scenarios, executing and generating reports using LoadRunner
• Performance Testing - Load testing, stress testing and soak testing of the application. Represent the QA team in the AGILE daily stand-up meetings. Assign stories to QA team every iteration and track progress
• Executed the tests to verify the web GUI using Quick Test Pro Write SQL queries to test and verify system and database models to ensure quality.

Environment: Quick Test Pro (QTP), Quality Center (Test Management), Oracle, SQL Server, Mingle (Requirement management), MS Office, PVCS (Configuration Management), Performance Tester (Performance Test), Citrix, HP-LoadRunner, Windows XP, UNIX