SUMMARY:

• Good experience on QA EDI ETL UAT Web Services, System Integration Testing (SIT) and Data Analysis of various business applications in Client/Server environments, web - based applications data warehousing solutions, ETL and Business Intelligence solutions.
• Excellent ETL/BI testing experience with extensive backend testing with good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architectures and Database concepts.
• Excellent understanding of Web Based testing.
• Expertise in Integration testing, System Testing, and generating test plans, test cases and test scripts.
• Experience in Front-end GUI testing of web based applications and client/server applications.
• Strong skills in performing System Integration, Acceptance, Functionality, Front End and GUI Testing.
• Performed System, Integration, Smoke, Regression testing and UAT.
• Performed ETL/BI testing and Backend testing using SQL Queries.
• Extensive experience in writing complex SQL and PL/SQL scripts
• 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).­
• 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.
• Excellent experience on migration from Oracle reports to Business Objects.
• Tested the entire functionality of the application on different browsers and operating systems.
• Experienced using test management tools like Quality Center and Clear Quest, Test Director.
• Experience in usage of defect tracking tools Quality Center for logging the defects, generation of reports and analyzes the reports.
• Good knowledge in using UNIX environments.
• Worked as onsite offshore coordinator.
• Comprehensive knowledge of Test Driven Development, Agile and Waterfall Methodology.
• Experience in all phases of software development life cycle that includes requirement study, analysis study, and testing of various client/server and web application.
• Quick learner with an ability to rapidly achieve design and production requirements, detail-oriented with good organizational skills.
• Experience in Testing ETL, Store Procedures, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys, Cron tab, Control-M.
• Ability to deal with a fast paced production environment.

TECHNICAL SKILL SET:

Languages: SQL, PL/SQL

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2012

Operating Systems: Microsoft Windows 98/XP, UNIX

RDMS Query Tools: TOAD, SQL Assistant, SQL Navigator, SQL * Plus, Rapid SQL

Test Management Tools: HP Quality Center

Version Control Tools: Rational Clear Case

Defect Tracking Tools: Rational Clear Quest, HP Quality Center,JIRA

Incident Mgmt. Tools : BMC Remedy

Scheduling Tools : Autosys

Reporting Tools : Crystal Reports, Cognos, SSRS, OBIEE

ETL Tools : Ab Initio, Informatica Power Center

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL/Database Tester

Responsibilities:

• Worked with business analysts in preparing test plan and test cases based on BRD and STM document for the mapping developed through the ETL tool from the requirements.
• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.  
• Reviewed the Business Requirement Documents and the Functional Specification. 
• Actively participated in stand up meetings, story reviews, involved in the agile process.
• Prepared Test Plan from the Business Requirements and Functional Specification. 
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation. 
• Responsible for different Data mapping activities from Source systems to Teradata
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate test cases.  
• Involved in test management and defect management using Team Foundation Server (TFS).
• Validate the responses of web services by passing various requests using soap UI.
• Conducted Data Migration testing and Web Interface testing.
• Involved in extensive DATA validation using SQL queries and back-end testing. 
• As QA Tester, performed responsibilities with both the functionality and back end testing. 
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application. 
• Reviewed Informatica mappings and test cases before delivering to Client. 
• Testing has been done based on Change Requests and Defect Requests. 
• Extensively used Informatica power center for extraction, transformation and loading process. 
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records. 
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log. 
• Involved with ETL test data creation for all the ETL mapping rules.  
• Used Erwin for analyzing the relationships between tables and complex composite keys that exists on the tables.
• Tested different detail, summary reports and on demand reports.  
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands, and worked with the UNIX shell scripts.
• Validated the responses of web services by passing various requests in SOAP UI, and used HP Quality Center as test management tool.
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Involved with project backlogs and sprint backlogs.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Validated the data moving from multiple sources to target using Informatica data validation option
• 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.

Environment: Informatica, SharePoint, HP ALM, Web Services, Soap UI, JIRA, XML, Oracle 11g, SQL Server 2012, PL/SQL.

Confidential,VA

ETL Tester | QA Analyst

Responsibilities:

• Involved in sending Report status of all conversion-related data tasks to RPM Data Conversion Lead.
• Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team
• Participated as a product owner/user in requirements/design, testing and providing user feedback on data conversion tools
• Recommended for efficiencies/process improvements to streamline overall conversion
• Participated in rollout planning and strategy meetings to provide input on teams role in the process
• Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team.
• Participated as a product owner/user in requirements/design, testing and providing user feedback on data conversion tools
• Developed ETL Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Worked on writing SQL queries to verify the count and data difference between source tables to landing tables, landing to staging tables and staging to base tables.
• Wrote several complex queries to validate De-normalized tables and materialized views.
• Created and maintained test cases for ETL mappings and design documents for production support in HP ALM based on the Source to Target documents
• Validated the MDM tables by executing the SQL scripts based on the transformation/clinching rules and designed Test data for Informatica MDM to be entered through IDD.
• Tested the ETL Informatica mappings and other ETL Processes (DW testing)
• Worked on validating ETL target tables in table level and column level looking at the complexity of Source to Target document.
• Tested data migration to ensure that integrity of data was not compromised
• Involved in preparation of Defect reports, Weekly status report and presentation documents with testing data and testing results
• Performed defect tracking and reporting with strong emphasis on root cause analysis to determine where and why defects are being introduced in the development process using SQL to narrow down the root cause of the problem
• Created data set for process ability to validate different workflows for ETL mapping rules to test the functionality according to requirements of the FMDR application
• Involved in communicating with business, support, and development teams to resolve issues during test execution.
• Worked in Agile Software Development environment, Participated in daily stand-ups, Iteration planning meetings and Iteration Retrospective meetings
• Effectively communicate testing activities and findings in oral and written formats
• Developed test cases in Excel and uploaded to Quality Center.

Environment: HP ALM, Informatica, Clarity, Service Now, ORACLE, XML, Clear Quest, UNIX, putty, TOAD, SQL, PL/SQL, MS SharePoint

Confidential,NC

ETL BI Tester

Responsibilities:

• Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports, OLAP and CUBES.
• Wrote complex SQL queries for positive and negative testing in validating data ware house tables.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Conducted Test plan reviews, Test case reviews by analyzing the requirement specifications.
• Worked on traceability matrix to map Test cases against Requirements using Quality Center.
• Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports.
• Involved in working with slowly Changing Dimension type 1, type2 and type 3 based on the requirement.
• Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis.
• Tested Product for Copay, HRA, MOPS Maximum Out of Pocket, PSL Plan Stop Loss.
• Validated Source - Target mappings applying various transformation rules and Business Rules.
• Validated Data ware house DB2 tables and verified the defects.
• Involved in testing Data Stage ETL jobs for the data quality and number of the records.
• Validated Adhoc Reports, OLAP Reports for Data Accuracy.
• Created various complex SQL scripts for functional validation of ETL applications.
• Worked in creating scenarios for row count validations in EDW.
• Created test sets based on scenarios to validate EDW.
• Participated in Defect Review meetings periodically.
• Worked on Test management using DOORS.
• Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
• Working Experience with Agile Development Methodology.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers
• Responsible for reviewing and modifying test scripts after initial iterations of testing phases to incorporate changes in project environment

Environment: DB2, Netezza SQL Server, SSIS, Cognos 8.0, IBM Data Stage, Remedy, DOORS

Verisk Health,VA

Quality Analyst | BI Tester | Manual

Responsibilities:

• Created Test Plan and test scenarios looking at the MMIS Requirement Documents: Benefits Requirement Documentation, GCP Documentation for testing.
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss the impact of the changes, problem tickets and prepare project milestone plans.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Involved in business analysis and project management, coordinating between the team members according to the business requirements.
• Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Created and maintained procedures and documentation.
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• 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.
• Recommend ways and workarounds for HIPAA 5010 (EDI X12 837,834,278,270) upgrades.
• Organized meetings and led JAD sessions to ensure legal and compliance deadlines of CMS (Centers for Medicare and Medicaid Services) are met.
• ICD 9  -  ICD 10 Conversion Project  -  Worked in the analysis of the ICD 9  -  10 codes conversion Project. Worked with GEM processes and concepts.
• Complete Understanding of the ICD-10-CM and ICD-10-PCS code sets.
• Involved in end to end testing of Oracle E-Business Billing and Payment Processing.
• Validated the translated HIPAA files with the proprietary CCR (Common Claim Record) implementations.
• Managed the testing and verification of HIPAA standard transactions, and EDI messages (837),
• Organized and conducted meetings, briefings, demonstrations, conducted JAD sessions, and wrote minutes of project meetings.
• Involved and worked updating the official changes to the tabular list, instruction manual and alphabetical index of ICD- 9 to ICD-10 in regards to data transactions.
• Performed “UAT” for 5010 and ICD 10 codes.
• Extensively involved in testing. Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Actively resolved day-to-day technology needs of the business unit with a focus on the analysis of processes.
• Involved in project planning and coordination.
• Prepared the Business Workflow using MS-Visio with input, output, Pre and Post conditions
• Developed recommendations and designed solutions for process improvements.
• Responsible for submitting status reports to management summarizing completed projects/tasks.

Environment: Informatica Power Center 8.1, MS SQL Server 2012, XML, TOAD 9.2, Oracle 9.2, HP Quality Center

Confidential,RI

Quality Analyst | BI Tester

Responsibilities:

• Responsible for developing and executing test plans, test cases, and SQL scripts based on the requirements and Source to Target documents and also responsible for creating and updating user-defined functions to meet the current business requirements.
• Involved in extensive end to end DATA validation and back-end testing using SQL queries.
• Written several complex SQL queries for validating staging and data warehouse Tables.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Validated database structure based on the Source to Target documents.
• Used Informatica workflow manager to execute the workflows and informatica workflow monitor to monitor the status of the workflows.
• Performed Black Box Testing based on the functional requirements and product specifications of the application including smoke, regression and functional testing using Quality Center.
• Performed User Acceptance Testing, GUI testing, Smoke testing etc.
• Involved in daily stand up meetings, weekly project follow-up meetings to update the LOE and report on the testing progress.
• Reported defects on Quality Center and followed bug life cycle.
• Have tested reconcile and incremental ETL loads for the project.
• Involved in validating various batch jobs scheduled using autosys
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Involved in validating SSAS cubes according to functional specifications.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
• Tested the Front-end functionality for the application.
• Used Informatica MDM to cleanse data coming from source and to deliver consolidated and reliable data
• Used IDD to insert data to MDM through UI
• Developed test cases in Excel and uploaded to Quality Center.
• Involved in testing reports and closely worked with operations, and Release teams to resolve the production issues.
• Designed test data using MS Excel sheet to test the application with positive and negative inputs.
• Involved in managing test cases and test execution in TFS
• Used Toad to run SQL queries to check data is populating as expected from tables.

Environment: Informatica Power Center, SQL, PL/SQL, Cognos, SQL Server 2005, SSIS, SSRS, Java, XML, Autosys, Clear Case, Clear Quest, TFS, UNIX, TOAD