SUMMARY:

• 9 years of experience in Software Quality Assurance and Quality Control.
• Excellent Functional knowledge on various domains like Finance, Banking, Derivatives, Equities, Fixed Income, Insurance, Healthcare and Telecommunication and Restaurant.
• Good knowledge of Quality Assurance methodologies like Agile, Waterfall, V-Model, RUP, Scrum, RAD, UML, TDD.
• Knowledge of healthcare insurance domain with testing EDI transactions.
• Worked with various EDI transactions like 834,835,837,276,277,387 in accordance with HIPPA standards.
• More than 4 years of experience in ETL Testing / Data Warehousing within the environment of Oracle, SQL Server, Informatica Power Center 9.1/8.6/ 7.1, PowerMart 6.2/ 5.1/ 4.7.x Repository Manager, Mapping Designer, Server manager, Transformation Developer and Warehouse designer .

Working knowledge on the Citrix Server.

• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases and also involved in review of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Extensive experience in testing Data warehousing environment, experience in testing to ensure that ETL process functions well with all the upstream and downstream processes.
• Extensively Testing knowledge in SAP R/3, FI/CO, SD, MM, and HR, MDM and FSCM, SAP CRM IPM Modules.
• Building the Data Mining Database - Collected data from different data source, eliminated irrelevant and unneeded data, imputed the missing value using k-nearest neighbor.
• Documentation for all kinds of reports and SSIS packages.
• Proficient in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing User Acceptance testing UAT Involved in Load Testing, Performance Testing Stress Testing.
• Tested ETL applications in relational databases and flat files using Informatica and tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
• Has good knowledge of Software Development Life Cycle SDLC Software Development Life Cycle SDLC and Software Testing Life Cycle STLC .
• Well versed with writing detailed test cases for functional non functional requirements.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts test cases for Manual, Automated bug tracking tools.
• Experience in Data warehousing integration services: SSIS, Reporting Service: SSRS and SSAS and also involved in the report generation of BI systems using Crystal Reports.
• Specialized in Business Intelligence areas such as Data Integration, Data Masking.
• Responsible for collection of metrics/ reporting on metrics/ design preventative and corrective measures for senior management consideration.
• Understanding and experience working on a variety of technologies such as UNIX, HTML, VB Script, XML.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience in IT testing with expertise in test plan preparation, system testing and in automated tools such as QTP and SOAPUI.
• Expertise in use of Quality Center QC Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Experience in interacting with business analysts, developers, technical support help them base line the requirement specifications.
• Attend periodic meetings, teleconferences and led discussions on problem resolution.
• Experience with version control, configuration management and change control procedures using tools such as Rational ClearCase.
• Extensive experience working with onsite/ off site team model aware of the cultural issues aware of the issues in terms of planning efforts/ schedules etc.

TECHNICAL SKILLS:

• Testing Tools: Quick Test Pro QTP , WinRunner, SOAP UI,
• Bug Reporting Tools: Bugzilla, Mantis, ALM, Quality Center 9/10, JIRA, Test Director, Rational Clear Quest, Citrix.
• ETL/Data Warehouse Tools: Crystal Reports 14 10, SSIS, SSRS, EDI, Oracle Designer 10g, 9i, Erwin 8, 7.2, 4.1, Business Objects 5.0.3, 4.1.4 , Informatica PowerMart4.7.2/5.1, Power Center 9.1/ 8.6/ 8.1, Power Plug and Power Connect , Cognos Power Play 7.5/ 7.1, SAP R/3 4.5
• Database: Oracle 9i, 10g, 11g, SQL Server 2005/ 2008, MS Access, MYSQL
• Languages: C, HTML, XML, VB Script, Java Script, SQL, Oracle and PL/SQL.
• Operating System: Windows 7/2000/2003/XP/NT/VISTA, LINUX, UNIX, MS-DOS.
• Other Tools: MS Office Word, Excel, PowerPoint, Outlook , MS Project, MS Visio, Toad, IBM Clear Case

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL QA Analyst/Tester

Responsibilities:

• Attended walk though meeting in which business rules and functionalities were discussed
• Coordinated all QA activities and enhancements using Agile Methodology.
• Developed Test Plan and wrote Test Cases.
• Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing and GUI testing.
• Performed Cross browser compatibility testing and cross platform compatibility.
• Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center QC .
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Designed various test Cases with different test conditions.
• Validated correct process of ETL.
• Built and performed test cases for END to END testing using JIRA and SQL.
• Hands on experience in collecting several metrics and preparation of defect reports.
• Tested data models and data maps extract, transform and load analysis - ETL analysis of the data marts and feeder systems in the aggregation effort.
• Prepared and executed scenarios for the Regression testing on new ETL process builds.
• Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Prepared and executed scenarios for the Regression testing on new builds.
• Performed Regression testing by executing the scripts developed with QTP.
• Conducted User Acceptance Test UAT with users and customers and wrote issues log based on outcome of UAT.
• Adopted Data Driven Methodology to the test application with different sets of data.
• Extensively involved in performing Backend testing by using SQL.
• Performed Manual Testing of the application as well as identified the critical test scripts to be automated. Performed ETL testing to validate data is transformed correctly from OLTP to data ware house.
• Performed that all data is transformed correctly according to design spec.

Environment: Windows 7, NT, 2003, 98, UNIX, LINUX, Oracle 10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML,.Net, JIRA, SAP, VB Script, Crystal, SharePoint, XML, SSIS/ SSRS, ALM, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.

Confidential

Programmer/ Sr. QA Tester

Responsibilities:

• Involved in Functional and Regression testing of Epic Application.
• Developed detailed Testing Strategy for the entire application and developed various Test Cases.
• Developed Data flow Analysis and Modeling for Healthcare applications and categorized the applications according to HIPPA 4010, ICD 9.0 and Institutional Guidelines.
• Created test cases as per the requirement documents and stored the same in QC Quality Center .
• Responsible for Test Plans, Test Cases, Test Scripts and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Developed Schemas of EDI X12 Claims 837 and Eligibility forms in XML.
• Involved in Testing for System and EDI Changes for implementation.
• UAT support for EDI testing, including monitoring and troubleshooting of transmissions i.e. to help in understanding for the Business users.
• Interacted actively with Business Analysts/Users/Developers for collecting Requirement
• Testing of Citrix related builds and packages and reporting to engineering team for any bugs.
• Preparing of test cases and test plans for Citrix builds.
• Involved in Development of Test Plan and Test Cases for Integration, Functional, System and Regression Testing.
• Customer Service representative troubleshooting/resolving software and interface issues in high-volume call center for OE/OE Dpt, NMI, Nursing, PCI and HL7 interfaces.
• Automated the process for writing Epic data loads create clinically rich patient training data using data-driven testing principles.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Experience with Epic-Cadence for scheduling the patients information.
• Tested and worked with the RESOLUTE and PRELUDE modules of the Epic Suite.
• Tested the Resolute Hospital billing system extensively which is used for physician's billing.
• Tested the Resolute Professional Billing system extensively.
• Tested the Prelude module extensively which is used for Registration purpose.
• Tested Healthcare System which makes online order entry to its physicians. The aim of this system is to be paperless.
• Tested an Outpatient function which includes patient history, treatment guidelines, disease guidelines/information, automated health alerts and previous healthcare information.
• Maintain, backup and restore the Informatica ETL repositories for the entire QA team.
• Tested the system that makes extensive use of patient summary reports for reviewing information, such as the Nursing Kardex Transfusion Report and the Inpatient Facesheet.
• Tested the Electronic Medication Administration Record which works in concert with the EpicCare EHR, CPOE, and the EPICRX Pharmacy System to produce a dynamic and complete picture of a patient's medication status.
• Tested the MAR report that tracks all medications received in a simple and concise way.
• The ADT data as well as the clinical and billing information is shared between Epic, Medipac ADT Billing , Softlab/Tamtron LIS , Radnet RIS , cardiac graphic systems, Transcription System, PACS/EPF Imaging Systems , medication dispensing system, and many others via real time HL7 message exchange method and batch file transfers. Here, I have been involved testing the HL7 systems.
• Order Entry OE and OE Departmental Team lead responsible for data gathering and application build for multiple ancillary departments during market-wide conversion to MEDITECH.
• Conducted extensive backend testing to test that the value in the reports are accurate. Wrote SQL queries to get the data. Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Regression testing was performed for each new build.
• Tested New Features and their impact on existing functionality before each release.
• Gathered QA metrics from the team and Forwarded overall test metrics to the management using Quality Center.
• Created Parameterization, checkpoints, recovery scenarios and Sync Points.
• Developed test scripts for UAT and assisted the End Users in the UAT. Documented the defects and kept track of their trailing history, Test Execution result analysis, and modification requests.
• As part of QA team was involved in implementation of ETL best practices.
• Performed GUI Graphical User Interface testing for the application.
• Tested New Features and their impact on existing functionality before each release.
• Gathered QA metrics from the team and Forwarded overall test metrics to the management using Quality Center.
• Prepare Status Reports Every Week, which includes revision History, Test case status, metrics, Issues and Defects.
• Involved in User Acceptance Testing UAT .

Environment: Quality Center 9.5, HL7, EPIC Suite, SQL, EDI , SOAP, MS Project, MS Visio, Rational Clear Case, MS Excel, SQL,JAVA, HTML

Confidential

Sr. QA Analyst/Tester

Roles and Responsibilities:

• Involved in DMSuite Data Masking tool Server installation.
• Working with clients to improve their BI environment to improve the quality and availability of data to the end users.
• Manually written the SQL queries to test the back end database.
• Execute Quality Checkpoints pertaining to testing readiness for Integration System Test, User Acceptance Test, and Performance Test.
• Created SSIS packages to clean and load data to data warehouse
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
• Created SSIS packages to import data from MS Access, Excel to SQL.
• Creating test plan, Walk through, integration approach and strategy document, test cases, scenarios, conditions and scripts, generated system test scripts for Customer Relationship Management CRM .
• Building the data mining data base: tasks like data collection, data selection, data cleaning and solving data quality problems.
• Experience in conducting end user training on various SAP R/3 modules.
• Tested data models and data maps extract, transform and load analysis - ETL analysis of the data marts and feeder systems in the aggregation effort.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Ensured that UAT results are signed off by the right people in user community worked with several different levels of users in UAT such as floor agents to the VP level.
• Lead multi-persons QA team for the data migration and consolidation project to perform end-to-end test.
• As part of QA team was involved in implementation of ETL best practices.
• Responsible for managing the Data Warehouse and Business Intelligence functions at Burger King
• Responsible to resolve exceptions in UAT in a very expeditious way and re-UAT to ensure accurate and timely delivery.
• Responsible for creating UAT environment ensure that all the test case input sources are available test case output results were documented.
• Created UAT Test Cases to validate end-to-end business flows in Data Driven Testing environment.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing UAT and Data validation testing.
• Responsible for validation Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly Monthly Loading of Data.
• Used Agile testing methodology for achieving deadlines in UAT.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data Text files, XML files before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: Windows 7, NT, 2003, 98, UNIX, LINUX, Oracle 10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML,.Net, JavaScript, SAP, VB Script, Crystal, XML, SSIS/ SSRS, QC 10, QTP 9.5/10.0, Win Runner, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.

Confidential

Sr. QA Tester / Analyst

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing UAT and Data validation testing.
• Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Good experience is Data Masking Techniques. Executed Data masking POC successfully using DMSuite.
• Involved in data migration from legacy database Mainframe to Oracle database.
• Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Experience in Data Transfers using Batch input methods, Transferred master data from previous system using LSMW SAP Tool.
• Involved the DMSuite Data Masking tool Proof-of- Concept at CIT
• Managed enterprise wide systems, Integration, User Acceptance and end-to-end quality assurance testing including: test design, test strategy, development, enhancement, documentation, and test execution of projects using Automated and Manual Testing tools.
• Created test scenarios and test cases for Online CRM application based on the requirements and provided to the business analyst for review and Signoff.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Performed activities around testing such as developing test plans i.e., integration, stress, and UAT and schedules, test scripts, test data, use cases, and roles and responsibilities
• As a Senior QA Analyst/Team Leader worked on Loan IQ application that Covers the entire life cycle of a loan - from origination and deal tracking to administration and record maintenance.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Worked on Loan IQ 5.4, 5.5, 6.0 and 7.0 versions.
• Involved in Functional, Integration, System, Regression, Data migration Compatibility Testing.
• Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Executed and managed test cases and reported bugs in Quality Center.
• Used Clear Quest and Quality Center as the Defect management Reporting tools.
• Performed functional and load testing using SOAPUI.
• Used Clear Case as the Version Control tool.
• Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
• Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
• Hands on work experience working with offsite team model coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing UAT and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Environment: Windows 7, Vista, XP, UNIX, Oracle 11g, SQL Server 2008, TOAD, SQL, PL/SQL, Crystal Reports 14, Informatica Power Center 9.1, SAP, Misys Loan IQ, Erwin 8, QC 10.0, QTP 10.0, SOAPUI, HTML, XML, Java, Clear Case, Clear Quest, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, Firefox, IE, Chrome, Safari

Confidential

Sr. QA Analyst/ ETL Tester

Responsibilities:

• Responsible for reviewing Requirement Specifications and Design Documents.
• Involved in Test Case Design with respect to Test Plan.
• Involved as part of automation team using QTP, developed test scripts.
• Involved in implementation of ETL best practices and Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Login to Quality Center retrieved the data from Test Lab, strings, OQ/PQ dry run, OQ/PQ formal, Regression data and tested manually in SAP Portal.
• Prepared and executed scenarios for the Regression testing on new ETL process builds.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Worked on conversion of manual integration tests into automated tests using QTP.
• Performed tests for Functionality, GUI and Backend.
• Profiled the application database using DMSuite and prepared the data masking inventory.
• Executed automated as well as manual test scripts and validated Test conditions for Systems, Integration, Regression, and Conversion tests.
• Executing, Reporting and Tracking the defects using Quality Center.
• Executed regression tests at each new build in QTP
• Created and maintained Regression test suite to check the progress of the testing process by performing identical tests before and after fixing defects.
• Tested data models and data maps extract, transform and load analysis - ETL analysis of the data marts and feeder systems in the aggregation effort.
• Customized the scripts according to the requirements by using conditional statements and loops.
• Coordinate with manual tester and set up expectation on what will be handled by automation team.
• Designed and developed User defined functions, Generic functions with well versed VB scripting, Descriptive programming in Quick Test Professional 10.0.
• Reviewed the QTP Scripts developed by the team members.
• Ensure that all the test cases are updated in the Quality Center along with Master test plan.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Provided weekly status report to the Team lead and discuss issues related to quality and deadlines.

Environment: Windows 7, Vista, XP, 2003, UNIX, Oracle 10g, QTP 10.0, XML, HTML, UML, TOAD, PL/SQL, Crystal Reports 14, QC 10.0, Misys Loan IQ, Informatica Power Center 8.6/8.1, Erwin 7.2, JavaScript, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, VMware