PROFESSIONAL SUMMARY

• Eight years of solid experience as a QA EDI ETL UAT Web Services, System Integration Testing (SIT) and Data Analysis of various business applications in Client/Server environments, web - based applications for Bank, Health, Financial data warehousing solutions, ETL and Business Intelligence solutions.
• Strong working experience on Data Centric Testing - built a customer data centric data warehouse to analyze transactions across finance, risk collections and consumer relations.
• Implemented various QA methodologies involving preparing Test Plans, writing Test Cases and executing them.
• Extensively worked with data warehousing, data scrubbing, data cleansing, data profiling as well as data frequency analysis.
• Experience in Functional integration 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.
• Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Developed and maintained Test Matrix and Traceability Matrix.
• Very strong in handling defect tracking and reporting process using ALM, Rational Clear Quest, Team Foundation Server- TFS, JIRA, Rally, Bugzilla.
• 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.
• Worked with different models such as Star and Snowflake and strong working knowledge in dimensional modeling.
• Experienced with ETL tools like Informatica.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Used Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Skilled knowledge on different modules within Healthcare Claims Adjudication Process (Membership process, Billing process and enrollment and claims processing).­
• Experience in Data Analysis, Data Validation, Data Verification, identifying data mismatch and Good experience with data sources.
• 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).
• ­Experience providing primary analysis for business processes running on the EDI (Electronic Data Interchange) standard.
• Strong in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors. 
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Lead testing effort between on shore and off shore teams in a couple of projects.
• Solid knowledge on all the phases of Agile methodology.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SSIS, SSRS, Data Stage, Ab Initio

QA Tools: HP - Quality Center ALM, Test Director)

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

Languages: SQL

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000 , DB2

BI / Reporting Tools: IBM Cognos 8.0, SSRS, OBIEE

Defect Tracking: HP ALM, Serena Business Manager, Bugzilla, JIRA, Clear Quest, Rally, TFS

Scheduling Tools: Autosys, Control M

WORK EXPERIENCE:

Confidential, Mount Laurel, NJ

ETL UAT SQL Tester

Environment: Oracle 11g, TOAD, Informatica 9.5, SSIS, Micro Strategy, JIRA, TFS, HP ALM, Autosys, UNIX, SOAP UI.

Responsibilities:

• Worked on commercial lending and market products such as loans, deposits.
• Worked in manipulating, cleansing & processing data using Excel, Access and SQL.
• Involved in loading, extracting and validation of the data.
• Extensively involved in data analysis in customer requests and involved in reporting statistical findings to team lead and management.
• Analyzing the raw data, drawing conclusions & developing recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Performed daily system checks, data entry, and data auditing, creating data reports & monitoring all data for accuracy.
• Worked with developers, database administrators and data architect and made sure that data quality around business decisions is maintained.
• Involved in Smoke Test and Acceptance Testing.
• Work on developing UI in Salesforce.com like profiles, role, user setup, permission, public groups, sharing rules customizations for sales and service cloud. 
• Developed the complete Test documents involving Test Plan, Test Cases and Test Scripts by analyzing Business requirement documents and Use cases.
• Prepared Requirement Traceability Matrix (RTM) for test scenarios, tested Status reports and Test Sign off documents.
• Involved in test management and defect management using Team Foundation Server (TFS).
• Performed database (metadata) validation before loading the data into the target tables.
• Tracked and executed the User Acceptance Test cases (UAT) with respect to the requirements to determine the feature coverage.
• Wrote complex SQL queries using TOAD.
• Performed Backend database testing by executing the Group functions, complex Joins and sub-queries.
• Used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created test cases, traceability matrix based on mapping document and requirements.
• Involved in validating the web services testing using the Soap UI.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on change requests and defect Requests.
• Effectively coordinated with development team for closing a defect using Team Foundation Server.
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Have tested reconcile and incremental ETL loads for the project.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data Warehouse.
• Got trained in testing Hadoop based applications and hive.

Confidential, Minnetonka, MN

ETL Tester | EDI Tester

Environment: Data Stage 8.0, SQL, Cognos 8.0, Clear Case, Clear Quest, RequisitePro, Quality Center, Facets, Share Point, PL/SQL, UNIX,

Responsibilities:

• Created Plans and Strategies for Confidential to streamline their Systems including EDI Transactions so they are able to pass through the EDI Gateway.
• 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.
• 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.

Confidential, Minneapolis, MN

ETL Tester

Environment: Oracle 11g, SQL, PL/SQL, Web Services, Cognos, Informatica Power center 9.5, SSRS, Quality Center 11, JIRA, UNIX, BMC Remedy.

Responsibilities:

• Analyzed the raw data, drawing conclusions & developing recommendations writing SQL scripts to manipulate data for data loads and extracts.
• Performed data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the Cognos reports.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Developed test cases based on functional requirements, reports specifications, data mapping requirements and system specifications.
• Used Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result maintenance.
• Involved in test management and defect management using Team Foundation Server (TFS).
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Effective defect tracking and reporting to improve communications and reduce delay.
• Exhaustive unit level, integration and regression testing for all the modules of the application.
• Wrote several complex SQL queries for data verification, data validation, data quality checks.
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Involved in preparation of System Test Results after Test case execution.
• Worked with data base validation, constraints validation, record counts, source to target validation, random sampling and error processing.
• Involved in O&M mode of project post deployment and resolving deployment issues.
• Tested data migration to ensure that integrity of data was not compromised.
• Used HP Quality Center as Test Management tool.
• Validate the responses of web services by passing various requests using soap UI.
• Conducted Data Migration testing and Web Interface testing.
• Used Jira as defect management tool and SharePoint as version control tool.
• Extensively used Informatica Workflow to run workflows / mappings and monitored the session logs in Informatica Workflow Monitor.
• Responsible in testing Initial and daily loads of ETL jobs.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Actively participated in stand up meetings, story reviews, and retrospectives of the Agile process.

Confidential, New York City, NY

SQL Tester | ETL QA Analyst

Environment: Informatica Power Center 9.0, TOAD 10, SQL, PL/SQL, UNIX, DB2, SSRS/SSAS, Flat Files, XML Files, Text files, TFS.

Responsibilities:

• 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.  
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing (SSAS) and Report testing (SSRS). 
• 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. 
• 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).
• Tested several business reports including Summarized, Master-Detailed and Drill Down reports developed by SSRS. 
• 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.    

Confidential, Juno Beach, FL

UAT ETL Tester

Environment: Ab Initio, Oracle 9i, SQL Server 2003, SQL, PL/SQL, TFS, Windows XP, MS Office Suite, Test Director

Responsibilities:

• Validated SQL and stored procedures for the data warehousing application projects.
• Documented business requirements by facilitating sessions between business and technical team
• Involved in systems design and implementation of standardized business processes
• Generated and compiled reports based on findings with probable causes and possible solutions to systems issues.
• Validate the responses of web services by passing various requests using soap UI.
• Extensively used Joins in order to get records from different tables
• Validated Triggers that are implemented to enforce Integrity constraints, Cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling.
• Validated various Ab Initio graphs according to functional requirements.
• Involved in maintaining and first level troubleshooting of the database.
• Analyzed and wrote logics, tests for software solutions involving database extraction
• Designed and implemented a new information database for supporting interfaces
• Ensured accurate data transfer from sources into the newly designed system
• Validated PL/SQL stored Procedures used for customers placing regular orders
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Consulted with users and stakeholders to ensure that requirements are met
• Familiarized with software development lifecycle and configuration management