SUMMARY:

• 8 years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Expertise in Business Requirement gathering through JAD sessions, interviews, workshops and walkthroughs, and main concentration in Business Process Flow and Business modeling tools as a Business analyst
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Well versed with various types Software Development methodologies - Water fall, Agile, RUP, Iterative and extreme Programming.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Experience on CLAIMS and Confidential standard testing
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Datastage tools.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in scheduling the Informatica, Ab Initio, Datastage jobs using Appworx, Ctrl-M & Autosys.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experience in testing Confidential EDI Transactions, Experience on 835, 276/277 EDI Transactions and Enrollment, Billing and claims processing in FACETS.
• Have experience in Healthcare core processing systems Facets
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Experience in All modules of Facets 4.31 and Facets 4.71.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules

PROFESSIONAL EXPERIENCE:

ETL Tools: Informatica Power Center 9.1/8.6/8.1/7.1 , Data Stage 8.x

Client Side Skills: SQL, PL/SQL, UNIX shell scripting, XML

Databases: MS SQL Server 2005/2008, Oracle 9g/9i /10g/11g, IBM DB2, Sybase Central V6.0, Teradata SQL Assistant, EDWARD Data Warehouse.

Languages: C, C++, Basic SQL, HTML, Java.

Operating System: Windows 2000/2003/XP/Vista/Windows 7, Windows 8, UNIX/Solaris

Methodologies: Data Modeling Logical / Physical, Star/Snowflake Schema, FACT & Dimension Tables, ETL, Software Development Life Cycle (SDLC)

Dimensional Modeling: Star-Schema Modeling, Snowflake Modeling, Physical and Data Modeling

Tools: Toad, SQL developer, MS Project, JIRA, MS Visio, QTP, Facets 4.7/4.8/5.01 , Claredi, HP ALM 11.0, SOAP UI, Enterprise Scheduler

Technical Skills: HP Quality Center 10.0/11.0, BAM Report Manager, Ultra Edit, Facets 4.71, Facets 5.01, Microsoft Office 2010, Enterprise Scheduler, Notepad++, SharePoint, XML Generator, SOAP UI 5.0, HP UFE 11.5, Facets Data Model Reader.

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Sr. ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10
• Tested ETL jobs as per business rules using ETL design document
• Involved in Test plan, Test case preparation and assigning defects through TFS (Team Foundation Server
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Analyzed the FACETS Requirements and conducted gap analysis.
• Conducted Business validations for different FACETS modules Providers, Billing, Claims and Membership
• Defined data requirements and elements used in XML transactions.
• Worked with business team to test the reports developed in Cognos
• Developed Data flow Analysis and Modeling for Healthcare applications and categorized the applications according to Confidential 4010, ICD 9.0 and Institutional Guidelines.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Developed UAT test cases for business users and worked closely with them to execute UAT test cases.
• Experience is creating test cases to validate functionality and performing UAT testing
• Tested Dimensional tables SCD Type 1, Type 2 and Fact Tables in Star Schema
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Prepared Test Cases based on business requirements and business rules for Confidential EDI Transaction 834, 276/277, 270/271, 837/835.
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET, ASP.NET
• Did testing of SOA end to end, Service by service and Interface by Interface
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys.
• Worked in an agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Involved in automation of test cases using QTP and Did functional testing using QTP
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Scheduled the jobs using Auto sys and automated the jobs to be run at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Did work with SOA testing involving SOAP, XML, and REST. Analyzed Mapping and System Bottlenecks to improve the performance of various ETL Jobs.
• Built database based on technical requirements. Managed and extracted Metadata associated with ETL processes.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Involved in extensive DATA validation using SQL queries and back - end testing.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio.

Environment: Informatica 8.6.1, MS SQL Server 2008, TFS, VSTS, Oracle 11g / 10g, SQL, PL/SQL, IBM DB2 8.0, AGILE/scrum, Teradata V2R6, Teradata SQL Assistant, SOAP, SOAPUI, Web Services, Cognos 8.0 Series, HP QTP 9, HP Quality Center 10, Toad, Autosys, SSIS, Unix Shell Scripting, Windows

Confidential, Joshua Tree, CA

Sr. ETL QA Tester

Responsibilities:

• Designed and executed various well described Test scripts for System testing based on the Functional Design Document.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the Data Base by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Prepared test cases in Test Plan tab execute in Test Lab and logged defects using Application Management Life Cycle QC 11.
• Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
• Running test scripts for facets applications and modules
• Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
• Test data entry into Facets application in the test environment for creating groups, subscribers and family members.
• Worked on Web Services graphs, where the real time requests comes in and made sure the response is being sent back utilizing Soap UI
• Investigating issues occurred while System testing and Regression testing.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used DWH ETL for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica.
• Tested the Membership and claims files (XML) in Facets.
• Test data entry into Facets application in the test environment for creating groups, subscribers and family members.
• Conducted Confidential Gateway Testing. Tested Subscribers/Providers and claims in Facets.
• Tested the Membership and claims files (XML) in Facets.
• Transactions focused on were 270,271,276,278,834, 835, and 837.
• Tested the EDI 837 interfaces, developed test cases and test scripts for 837, 835, Institutional and Professional Confidential transactions.
• System Integration testing for Facets core modules with external systems.
• Tested reports developed by Business Objects Universes for both Adhoc& Canned Reporting users of Business Objects XI
• Have programming skills in SQL and PL/SQL and experience in Oracle databases on UNIX and Windows platforms.
• Execution of Batch jobs using Autosys and validation the backend tables using SQL.
• Wrote SQL and PL/SQL scripts to validate the database systems and backend database.
• Written and executed the functional and regression test script using Test Script QTP.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in testing Business Report developed in Business Objects XIR2
• Tested data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Environment: DWH ETL Informatica 9x, Oracle 11g/10g, Teradata, Business Objects, XML, XSLT, Altova XML, Autosys, Quality Center 10.0, DTS,, TOAD, SSIS, HP ALM, QTP, SSRS, SSAS, SQL Assistant 6.0, PL/SQL, UNIX, HTML, PERL, MS Access, Flat Files.

Confidential

Data/System Analyst

Responsibilities:

• Interacts with business users/ stakeholders to identify business needs, gathered requirements and generated deliverables like Business Requirement Documents (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the project.
• Involved in Confidential Complaint X12N837 Transaction testing.
• Involved in testing the claims conversion from Mainframe to Facets. Also involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversion to Facets.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements and also worked on reporting skill set.
• Experience in writing the test cases and test plans for Facets
• Conducted JAD sessions with business units and stakeholders to define project scope
• Implement, maintain, provide support and improve upon use of Microsoft SharePoint and Strategic Management System (SMS) capabilities to support the needs of the organization
• Escalated issues that were related to project to resolve them without impacting deliverable or timelines.
• Worked in team environment to successfully deploy the projects and was involved in status update meetings.
• Created test plan and scripts for user acceptance testing (UAT) to ensure business requirements are exceeded.
• Created Use Cases and Test Cases to validate data displayed in database.
• Wrote SQL Queries to validate data from different databases.
• Extracted data from data warehouse by writing SQL Queries
• Performed functional testing of questionnaire system after development to ensure business requirements are exceeded.
• Defined clear targets and objectives and communicate them to other team members to ensure projects are completed on time, under budget and exceeding expectations.
• Experience in EDI Files data load in data warehouse
• Supervised work of four team members, offering constructive feedback on work performance to increase staff skill levels.
• Document defects and execute test cases to ensure issues are resolved in a timely manner.

Confidential, Silver Spring, MD

QA Analyst

Responsibilities:

• Involved in Complete Testing Life Cycle that involved in QA analysis, Test Planning, Creating Test Cases both Automation and automated, test execution, test results analysis and defect handling.
• Involved in developing Test Design, Test Cases and Test Plan.
• Designed and developed the High Level & Detailed Test Plan using standards.
• Implemented Automation process in manual testing environment using Test Suite.
• Performed Black Box Testing for functional flow of the applications.
• Parameterized dynamic data with base line test data for each load and developed Recovery scenarios.
• Involved in developing test cases for various stages with adherence to smoke, integration, end - to-end, Regression, User Acceptance, Usability, Sanity and Ad-hoc testing.
• Worked Web based .Net, Java application testing.
• Exported Test Cases using Excel add-in into HP ALM and converted them into Test Scenarios for automating in Test Plan and Test Lab module.
• Used HP ALM as the defect tracking tool to track, review and generate report on bugs.
• Generated Project status reports through HP ALM and Document Generator for team meetings and Management review.
• Used SQL queries to perform data base testing; prepared manual test cases to test the GUI application and also to perform data testing.
• Migrated manual test cases into UFT for Regression testing using Web and Java add-ins and advanced functions using VB Script.
• Developed Functional Libraries for cleanup, setting up test environments and application for Regression testing and Importing Production data for Validation using UFT.
• Developed Automation Scripts that runs around the test cases in a single run without any exceptions for regression testing.
• Tested new test cases and automated them for further loads to reduce testing effort and time using UFT.
• Worked with Standard checkpoints, Page checkpoints, Table checkpoints in UFT while doing the functional test on the web application.
• Developed and maintained a Hybrid Framework using UFT.
• Mentored novice QA Testers on UFT and QC latest versions and on advanced features.
• Wrote reports for projects and worked with different project managers.
• Involved in reporting weekly project condition to the project manager and the team lead.
• Attended review meetings and walkthroughs to discuss the status of the project.

Environment: AJAX, DB2, Oracle, CSS, C#, HTML, SQL, XML, MS Office, Windows, HP ALM, UFT, Java, J2EE, Java Script, VBScript.

Confidential, Charlotte, NC

QA Analyst

Responsibilities:

• Involved in the all phases of Software Test Lifecycle activities.
• Worked on Members, Providers, Claims, enrollment and Payment Modules of Facets 4.71.
• Tested the Confidential EDI, Member Enrollment 834, Claims and Payment 837/835 transactions according to test scenarios and verify the data with Facets on different modules.
• Validate the date from EDI transaction in the front end as well as back end.
• Trained and mentored junior testers with business critical functions and processes in order to prepare all testing related documentation.
• Worked on CIC files for EDI 834 new enrollment.
• Developing EDI 834 transactions using Confidential 5010 specified rules.
• Identifying issues with System testing Support and Defect tracking.
• Conducted Validations for different Facets modules Providers, Claims and Membership
• Executing SQL Queries for the reports before mass and after mass reports to check for claims routing
• Development of SQL queries as per the request from the business team in SQL server.
• Edit claims (EDI Claims) with UltraEdit.
• Verified the application's functionality on different Configurations by performing Configuration Testing.
• Wrote complex SQL queries in TOAD to perform Back - End testing.
• Interacted with programmers to identify and resolve technical issues.
• Played a major role in Interface testing both functionally and manually.
• Assigned problems to appropriate software development team for fixes.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury QualityCenter.
• Bug Reporting and Tracking using Mercury Quality Center.
• Used Quality Center documentation management and defect tracking.
• Represented QA team in Defect Triage Meetings, weekly status meetings with IT and business people.

Environment: Trizetto Facets 4.71, Mercury Quality Center, SQL SERVER, Internet explore