EXECUTIVE SUMMARY

Over 7 years of overall IT experience, specifically in Data Analysis/Validation, QA Testing, Database and Business Analysis. Extensively worked with Data Testing, back-end testing, functional testing, end-to-end testing, integration testing, regression testing, data-driven testing, UAT, and Performance Testing using both manual and automation tools. Vast experience in Informatica, ETL, Database, HIPPA, EDI and develop SQL scripts for back-end testing and adhoc reports. Possess extensive experience in System Requirement Specification and User Requirement Specifications. Possess strong knowledge in writing test plans and test cases, and test executions for client/server and web applications. Good knowledge in Software Development Life Cycle (SDLC) and Quality Assurance Methodologies. Written numerous Business Requirement Documents, Business Process Documents, User Acceptance Test Documents, End to End test matrix, System test status report, and Defect tracking reports. Team player, positive attitude, self-motivated, focused on continuous learning, and significant contribution to the organization.

PROFESSIONAL EXPERTISE

• Over 7 years of experience in Quality Assurance and Software Testing in various industries such as Pharmaceutical, Healthcare, Insurance, Telecom and Banking/Finance
• 4 years of experience in Data Warehouse applications testing using Informatica Power Center
• Experience in Software Development Life Cycle (SDLC) methodology, Agile methodologies such as Rational Unified Process (RUP) and Scrum, Joint Application Development (JAD), Joint Resource Planning (JRP) and Project management life cycle
• Strong knowledge of Data warehouse and mapping documents
• Skills in data warehouse methodology; data analysis, modeling and design; and ETL testing
• Proficient in Manual Testing and Automated Testing with Mercury interactive tools Win Runner, Load Runner, Quick Test Pro [QTP ] and Test Director.
• Actively participated in the team involving test plan analysis, go/no-go decisions based on the QTP test scripts results.
• Experienced in various kinds of testing like System, Integration, Graphical Interface – Web based testing, Functional, Regression, User Acceptance [UAT] , End to End Testing, Load testing, Stress testing, Black Box testing [Manual Testing], Back-End testing and Volume testing of Client Server and Web based application.
• Involved in QA Life Cycle, which include analyzing the requirements, defining use cases, designing, developing and execution of the QA Process and Documentation.
• Experience in working with Java, VBScript, XML, HTML/DHTML, C, and C++, Visual Basic, Oracle, SQL, ability to prioritize tasks well and work on multiple test projects at the same time.
• Performed regression testing for fixes using QTP and closed the defects in Test Manager.
• Extensively used check points in QTP for testing purposes and also performed batch testing.
• Familiar with Software Development Life Cycle [SDLC], Test Methodologies, Test Matrices, Traceability Matrix.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Investigating software bugs and reporting to the developers using Quality Center Defect Module
• SOLID understanding of ANSI X12 4010 version 837/835
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets. Working Knowledge of HIPAA
• Expertise in Problem solving and Bug Reports using Defect Tracking Tools. Strong knowledge of MS Office products like Word and Excel.
• Great experience of the Testing Lifecycle and various kinds of testing which include Black Box, Grey Box, White box, Unit, Performance, Load and Stress testing including User Acceptance Testing (UAT)
• Understanding of Test Cases and Test Scenarios to meet the business requirements
• Excellent understanding of Relational Database Management System (RDBMS)
• Extensively involved in Database testing using SQL Queries to view the transactions for Client/Server testing.
• Knowledge of data modeling, ERDs and process modeling, DFDs and Object Oriented modeling
• Proficient in writing SQL queries to manage customer database, good knowledge of Data ware housing
• Good knowledge in modifying and maneuvering of data in MS Access and Oracle
• Experienced with SQL queries. Knowledge of checking the data flow through the front end to back end and used the SQL queries to extract the data from the database to validate it at the back end
• Good team leader, Player and can work alone with minimal or no supervision
• Ability to multi-task, prioritize and work with time constraints while paying attention to details
• Good problem-solving, judgment, and decision-making skill

TECHNICAL SKILLS

­­­­­­­Operating Systems: Linux, UNIX, Windows XP, NT, 7, 2000/2003 Server, Symbian, Android
Testing Procedures Unit, Functional, Black Box, System, Integration, User Acceptance Testing (UAT), Regression Testing
Internet Technologies HTML, XML, VB Script, ASP, Java Script
Software: Informartica 8.6/9.1
Operating Systems Windows XP/2000/NT/98, MS-DOS, AIX, UNIX
Programming Languages C, C++, Core Java, VB 6.0
RDBMS SQL Server, Oracle, MS Access
Business Tools MS Word, MS Excel, MS Power point and MS Visio
Testing tools QTP, MQC, Selenium, Load runner, iTKO
Defect Tracking Systems Test Director, Quality Center, Clear Quest
Browsers Internet Explorer 6/7, Netscape Navigator4.x/4.5,Opera, Firefox, Safari

PROFESSIONAL EXPERIENCE

Data Validation Engineer Confidential,
NC Nov 2011 – Aug. 2012
Quintiles is the only fully integrated biopharmaceutical services company offering clinical, commercial, consulting and capital solutions worldwide. Quintiles help biopharmaceutical companies develop and commercialize products to improve and lengthen patients’ lives while demonstrating value to stakeholders.

RESPONSIBILITIES

• Communicate with the Data Services Team (Business Analysts, Data Architects, Developers and SVT) to review and analyze the business requirements. Actively participated in Requirements and Functional Specification Reviews (FRS)
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Apply knowledge of data analytics and business intelligence models to interpret technical solutions being implemented and design test cases that address functional and regulatory requirements.
• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements
• Assisted in creating the Test Strategies (TS) and methods and Test Plans (TP)
• Assisted the lead and the SVT manager in creating the MRVPs (Major/Minor Release Validation Pack) documents and participated in sign-off meetings
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing
• Actively involved in the go/no-go and deferred defect meetings
• Conducted end-to-end data validation of data flow between source, staging, ODS(Operational Data Store), and DM (Data Mart) layer
• Analyzed the EDW mapping documents, Dimension tables and fact tables
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Tested various ETL transformation rules based on log files, data movement and with help of SQL
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Prepared Test Cases based on business requirements and business rules Performed Positive and Negative Testing Manually. Created SQL statements to validate the data tables.
• Communicate with the team - status, issues and risks on a timely basis to mitigate and drive project issues to resolution. Assisted the team in executing the ETL workflows to its completion and monitor the results. Actively involved in the Defect Triage meeting between the Development team and the SVT (System Validation and Testing)
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Involved in the Informatica 9.1 up-gradation testing to make sure that the existing, updated and new workflows are working as expected when migrated to Informatica 9.1 from Informatica 8.6. Created and documented the test plan for the same

ENVIRONMENT: HP Quality Center 9.0, Informatica 8.6, Informatica 9.1, Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP, Internet Explorer, SQL, TOP Team, JIRA, Analytix, OBIEE, SPOTFIRE, ETL

QA Analyst Confidential,
TX Mar.2011 – Oct. 2011
Nortel engages in the Wireless/Wireline infrastructure design, development, assembly installation, servicing, and support of networking solutions worldwide. The Global Services segment offers network implementation services, including network integration, installation, fault management, optimization, and security services; network support services, network managed services, & network application services, such as applications development, integration, and Web services. The project focused on online customer using ecosystem for Mobile Billing. The QA team was involved in providing operational support ensuring the accuracy of selected bills for mobile customers. Work involved extensive functional, regression, and load testing of the assigned application. Testing included new features, upgrades, enhancements and/or production fixes among various other projects.

RESPONSIBILITIES:

• Worked with existing and migrated customers to gatherer/analyze cross platform requirements, procedures, and problems to improve the User Interface and provisioning interface for Customer Trails
• Testing of WAP technologies with the wireless services. Install Account Apps builds in Android, Win7, Symbian and Blackberry operation systems for preparation of mobile testing in Native and HTML.
• Test mobile application functionality in Native and HTML that includes Login, Forgot password, Bill payment, usage, features, Paperless billing, Wi-Fi and Forum
• Worked with OffShore/OnSite teams to develop the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.
• Arrange the Hardware and software requirement for the Test Setup. Performed Sanity Testing and Smoke Testing. Tested the interface between database and the application
• Participated in requirement walkthroughs and creation of test plan. Maintained various versions of Test Scripts
• Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.
• Ensure content and structure of all Testing documents / artifacts is documented and maintained.
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization. Developed and maintained automated (Selenium IDE) regression test
• Keep track of the new requirements / change in requirements of the Project.
• Involved with Business Unit for Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements. Executed SQL Queries to check the data table updates after test executions.
• Performance testing of some client deliveries for performance requirements using Load Runner.
• Generate, analyze, and publish Load Runner test results and document the testing process.

ENVIRONMENT: Windows, SQL, Load Runner, MQC, iTKO, Selenium IDE, Android, Symbian, Linux

QA Data warehouse Confidential,
FL Nov.2010 – Mar.2011
Wellcare Health Plans, Inc. provides managed care services exclusively for government-sponsored health care programs, focusing on Medicaid and Medicare. It offers a variety of health plans for families, children, and the aged, blind and disabled, as well as prescription drug plans. The project was creating the data for all the members and providers that were already there in their existing database focusing on providing a single source of data for Member Enrollment analytics and reporting. I was involved in testing the data warehouse application for both the initial load and the incremental load. My responsibility was to test the EDW (Enterprise Data Warehouse) database dimension and fact tables.

RESPONSIBILITIES:

• Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Analyzed the EDW mapping documents, Dimension tables and fact tables
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Tested various ETL transformation rules based on log files, data movement and with help of SQL
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Developed several hundred of test cases to cover the data movement between sources to target
• Developed test scripts in SQL to check the data integrity from the databases
• Importedpreexisting Microsoft Word and Excel-basedrequirements and testsfor analysis in MQC.
• Prepared Test Cases based on business requirements and business rules Performed Positive and Negative Testing Manually. Created SQL statements to validate the data tables.
• Actively participated in walkthroughs and enhancement meetings
• Maintained Test Matrix and Requirement Traceability Matrix. Performed Gap Analysis
• Created requirement/test case relationship using Quality Center (traceability).
• Contributed to and assist in implementing improvements in test methods and strategies.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Mercury Quality Center.
• Assisted the automation team to automate the test cases for the next iteration
• Customized Quality Center to suit the requirements of testing effort
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC

EVNIRONMENT: Oracle, HIPPA EDI, Mercury Quality Center, SQL, ETL.

QA EDI Tester Confidential,
Vienna, VA Sep 2009 – Aug 2010
AmeriChoice, a business unit of UnitedHealth Group. is one of the leading providers of medical, dental and life insurance services. Company provides solutions to both individual and groups by providing broadest selection of leading health insurance plans. The project was creating the application where customers can compare individual health insurance plans by providing zip code, date of birth and gender. I was involved in testing the application that was used for checking the eligibilities, claim processing and claim status. My responsibility was to test the EDI (Electronic Data Interchange) database.

Responsibilities:

• Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements.
• Wrote SQL queries to verify that data are extracted according to the mapping documents into the Dimension and Fact tables from the source table
• Involved in the testing the target tables for all the members and providers (EDI 834) after the tables are being populated from the source after ETL transformation
• Tested various ETL transformation rules based on log files, data movement and with help of SQL
• Tested that all the legitimate existing records in the source tables are being pulled and being populated in the right fields of the DIM and FACT tables
• Performed SQL queries in the SQL Developer and ensured Correct Data Retrieval
• Developed several hundred of test cases to cover the data movement between sources to target
• Developed test scripts in SQL to check the data integrity from the databases
• Importedpreexisting Microsoft Word and Excel-basedrequirements and testsfor analysis in MQC.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 276/277, 270/271, 837/835.
• Performed Positive and Negative Testing Manually. Actively participated in walkthroughs and enhancement meetings. Created SQL statements to validate the data tables
• Maintained Test Matrix and Requirement Traceability Matrix
• Performed Gap Analysis. Validate the date from EDI transaction
• Experiences working in ANSI x12 837-835 EDI Transaction
• Tested the HIPPA 837/835 transactions according to test scenarios and verify the data on different modules.
• Authored test case scenarios in Excel spread sheet and export them into Mercury Quality Center.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Mercury Quality Center.
• Responsible for Performing Integration Testing, UAT testing. Conducted Back-End Testing Using SQL Commands. Customized Quality Center to suit the requirements of testing effort
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC

ENVIRONMENT: Oracle, HIPPA EDI, XML, QTP, Mercury Quality Center.

Test Engineer, ePricer, Confidential,
Boston, MA Oct.2008 –Sept.2009
IBM is the world\'s largest information technology company. It has more than 3 lakhs employees in 75 countries across the globe. Measured by revenue, IBM is the biggest provider of IT services, hardware and financing, and second in software. IBM Global Services is the world\'s largest information technology services and consulting provider.

RESPONSIBILITIES:

• Worked on ePricer (A web based application) Generating and editing Test scripts using, Rational Functional Tester (RFT)
• Bug Reporting in UVAT and Manage Now. Worked on Functional, Regression & Retesting
• Performed functional testing, UI testing and end to end testing
• Performed regression testing and End to End Testing on application builds and analyzed the test results
• Writing JUnit test cases and testing the modules in development and QA environment
• Created test cases in Java using Selenium RC, Junit and TestNG
• Created Selenium infrastructure for UI testing of all the websites. Created test plans, test scenarios and wrote test cases for testing various services. Tested web based applications utilizing WebPro.
• Performed functional testing to identify various critical points in the application and automated it by using Selenium RC
• Created Selenium based scripts using Java & Junit. Understanding the functionalities of the modules
• Check all the new modified endpoints and field and performed automation testing using Java, JUnit and Selenium. Created and maintained SQL Queries for back-end testing
• Worked on Unix Platform and experienced in back end testing by executing SQL Queries.
• Checked the data flow through the frontend to backend and used SQL Queries to extract the data from the database. Verified and validated the SQL scripts written by other Testers
• Involved in writing extensive SQL Queries for back end testing oracle database.
• Retrieved files using SQL statements and UNIX commands. Maintained Traceability matrix and Test Matrix
• Performed manual back-end testing using PL/SQL to connect to an Oracle 9i database on a UNIX server
• Solely responsible for Test Cases generation and execution, Modifying Test Cases for change request, Reviewing the Test Cases

ENVIRONMENT: Automation Tools, Selenium, Rational Functional Tester (RFT), JUNIT, JAVA
Automation Tester Confidential,
, Dallas TX Aug.2007 – Sept.2008
Carlson Wagonlit Travel (CWT) is a global leader focusing in business travel management. CWT Symphonie (SBT) is a web-based travel services platform that is an overlay of 3 different Global Distribution Systems (GDS): Apollo, Sabre, and World span - used to book travel. A GDS, also known as a computer reservation system, is an industry standard computer system the airlines use to post their flight schedules and accept reservations.

RESPONSIBILITIES:

• Preparing automation estimates based on the existing manual test cases for Regression Cycles.
• Used Quality Center to prepare Test cases, Requirements Traceability Matrix and managing the Defects as per the Business requirements.
• Performed different types of testing like Functional, Integration, System, Compatibility, User Acceptance Test (UAT), Regression, Web Services and Web methods testing’s.
• Designed and developed automation test scripts using HP Quick test Professional and managed testing activities using HP Quality Center
• Generated Test data using VBScript as a Utility function and conducted Data Driven testing using parameterization in Quick Test Pro to test the application with different sets of data.
• Used VBScript file to load all the function libraries using Library Functions in Quick Test Professional (QTP) utilities. Reviewing automation scripts based on the automation review process using QTP.
• Extensively used Quality Center for managing automation scripts and defect-tracking tool to report defects.
• Responsible for regression, UAT and smoke testing for all builds. Performing Manual Testing process to ensure the quality of the software. Daily attending status meetings to discuss the requirements and automation status.

ENVIRONMENT: C#.NET, iTKO, VB.NET, QTP 9.5, QC
Business Analyst/QA Analyst, Confidential,
Jan. 2005- Jul. 2007
KIST provides banking and financial services. The project was to implement a credit card issuing and processing system. My major role was to assist the project manager and his team starting from requirement gathering through to implementation and testing

RESPONSIBILITIES:

• Conducted individual and JAD sessions with the stakeholders and the technical units
• Studied and assessed the client systems and the business process
• Assisted in data analysis and worked with the design team in the designing of the databases with extensive use of ERDs. Worked with MS Access for the arrangement of the customer data
• Designed and developed Use case, Activity diagrams, Sequence Diagrams using UML tools with MS Visio
• Provided key inputs in defining the projects and system requirements
• Assisted the team members in writing the test cases and executed the test plans for the User Acceptance Testing. Worked extensively with SQL queries
• Assisted the team members with documentations like Requirement Traceability Matrix, Business Requirement documents and Use case specification documents
• Analyzed user/business requirements to develop a Test Plan and Test Scripts which would cover all the functional specifications
• Wrote scripts to perform positive and negative testing manually to verify actual results with the expected results
• Created Defect Status Document for bug tracking and reporting and also followed up with the development team to verify bug fixes and update bug status
• Conducted database testing for the application by writing and executing SQL queries
• Checked the data flow through the front end to back end and used the SQL queries to extract the data from the database. Performed extensive manual testing for each module of the AUT
• Created Requirement Traceability Matrix (RTM) to make sure that test cases were written for all the requirements

EDUCATION

• Master of Business Administration.
• Bachelor in Computer Engineering.