SUMMARY

• 7 years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts for business applications with HealthCare, Financial.
• Four plus years of experience in using the HP Automated Tools like Win Runner, Quick Test Professional (QTP), Quality Center and Test Director.
• Good experience in working in industries like, Healthcare, Banking, Mortgage and Insurance.
• Strong command on Software Development Life Cycle (SDLC), RUP, Methodology, UML.
• Proficient at creating Test Plans and Strategies by following different QA Methodologies.
• Expert in Black Box testing, QA and QC Methodologies, Regression testing, Integration Testing, System Testing and User Acceptance Testing.
• Good Experience with Defect/Bug Reporting Tools (TestDirector, Quality Center, Rational ClearQuest).
• Front - end GUI testing of web and client-server based applications.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Extensive testing ETL experience using Informatica PowerCenter 9.0/8.x/7.x, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
• Worked in the Enterprise Data Warehousing environment with ETL Tools like Ab Initio and Informatica.
• Expertise in database technologies including Oracle11g, SQL, Triggers, Stored Procedures, TOAD and database connectivity for Back-end testing.
• Familiarity with Application Servers, Web Servers and Database Servers
• Expertise in verifying the behavior of GUI objects and windows by setting GUI Checkpoints along with creating Web, Database, Client/Server and multi-protocol in Quick Test Professional (QTP).
• Performed Data Driven Tests on the application using Win Runner.
• Setting up work flow and requirement management using Quality Center.
• Good knowledge of web technologies like Web Services, SOAP, XML, HTML5.0, Style Sheets, ASP, JSP, ASP.NET, .NET, JavaScript, VB Script, VB, Java1.6,J2EE,C, and C++.
• Good judgment skills while reporting and prioritizing software bugs in conjugation with the development and QA managers.
• Exceptional written/verbal communication skills, including the ability to effectively document procedures, processes and results

TECHNICAL SKILLS:

Test Management Tools: WinRunner9.2, LoadRunner11.52, TestDirector, Quick Test Professional11.0, Rational Quality Manger4.0, Rational Robot, Rational TestManager7.0, HP Quality Center11.5.

Bug Reporting Tools: Test Director, Quality Center, Rational Clear Quest8.0.

Programming Languages: C, SQL, PL/SQL, VB 6.0, VB Script, HTML5.0, JAVA1.6, SOAP Web services, .NET, XM

Operating System: Windows7/XP/ME/98, MAC, Windows 2000/NT Server, UNIX, LINUX, MS-DOS.

Microsoft Products: MS Office 2013, Word, Excel, PowerPoint.

Databases: MS Access, Oracle11g, DB2, Sybase, SQL Server 2012

Testing Methodologies: Agile, Waterfall, RUP, V-Model.

Other Technologies: Business Objects XI, Cognos, Microsoft SharePoint, Ab Initio, Informatica, TOAD for Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

ETL/QA/BI Tester

Responsibilities:

• Formulating detailed Test Plan, after analyzing business rationale and software requirement artifacts.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Advised process teams representing client needs regarding cross-functional considerations, workflow integration and coordination, and optimization of best practices
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Used SQL tools to run SQL queries and validate the data loaded in to the target table
• Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
• Analyzing the AS-IS system which loads the Monthly/Weekly/daily multi source data files for Data mart using PL/SQL procedures and convert them into informatica code.
• Back-end testing using SQL queries and Involved in writing PL/SQL quires
• Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
• Used SQL for Querying the DB2 database in UNIX environment
• Familiar with CMMI, the Rational Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum
• Testing (that includes unit, integrated, regression, and UAT) a new .NET application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology
• Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
• Worked with shell scripts to extract data from Oracle systems and set up FASTLOAD and MULTILOAD jobs to load extracted data into TERADATA Databases in QA environment.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Participated in entering, tracking system defects in Rational Clear quest
• Experience in Integrating Cognos 8 with SQL Server and Oracle.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Personalized Cognos Connection for specified display options for testing regional options and personal information
• Extensively test the reports for data accuracy and tested Cognos Report Net with other web applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Involved in automation of test cases using QTP
• Automated detailed test cases by using Quick Test Pro
• Involved in writing test case matrix, summary grids, summary reports.
• Defect Reporting & Defect Tracking using Quality Center.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Involved in identifying the unused test cases in the Test Plan in Quality Center and prepared a consolidated document to delete the test cases.
• Involved extensively in the Back end testing by creating and executing SQL Queries using TOAD.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Executed SQL Queries for testing integrity of data in the Oracle database.
• Creation of test scripts in SQL based on published design documents.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Full Life Cycle Testing (SDLC) and development of both claim submission and remittance retrievals.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Involved in automation of test cases using QTP.
• Automated detailed test cases by using Quick Test Pro.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Exported the results through SQL and documented the test results for test cases and suites executed.
• Used TOAD to run SQL queries and validate the data loaded in to the target tables.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Extensively Queried through SQL to check the database records.
• Updated, maintained, and promoted Test Plans and Scripts to Configuration Management for version control.
• Extensively conducted Back-End Testing using complex SQL Queries.
• Input tickets to track UAT test defects.
• Verifying reports using BO Info view.

Environment:: Informatica Power Center 9.0.1, DB2, Teradata, SQL Assistance, UNIX, TOAD, HP Quality Center, Cognos 8 B Report Studio, UNIX, QTP 10.0..

Confidential, IL

ETL/QA/BI Tester

Responsibilities:

• Involved in designing and developing high level test plans based on the Functional specifications and user requirements.
• Created test cases for different scenarios.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Manually tested and verified the new/upgraded Application by performing functional and regression testing.
• Tested the compatibility of the application to support different web browsers and supported versions on different platforms.
• Also involved in testing the functionality and usability of the system end user perspective.
• Strong testing Quality Assurance experience within agile environment
• Good understanding of agile software development lifecycle (iterative and incremental)
• Performed tests on various features of agile development process
• Submitted change requests and worked with change request records in Clear quest.
• Used Quick Test pro to write the automated test scripts by using various actions and reusable actions.
• Manually tested the application functionality and developed Automation test scripts to perform functional and regression testing and prepared automation test scripts, Methods and functions in QTP.
• Automated test cases, for data driven tests and linked test scripts using QTP to perform Regression testing of different application versions.
• Involved in the complete Software Development Life Cycle (SDLC).
• Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC)
• Assigned in creating various testing scenarios for performing Functional & Integration Testing.
• Strong technical expertise in Integration testing, Functional testing, GUI testing, Backend testing, Security testing
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Personalized Cognos Connection for specified display options for testing regional options and personal information.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance
• Utilized Cognos 7.3 Series for building the Reports.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used Software for Querying ORACLE.And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Automated the jobs using UNIX shell Scripts
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL querie
• Used SQL tools to run SQL queries and validate the data loaded in to the target table
• Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively Queried through SQL to check the database record
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Analyzing the AS-IS system which loads the Monthly/Weekly/daily multi source data files for Data mart using PL/SQL procedures and convert them into informatica code.
• Back-end testing using SQL queries and Involved in writing PL/SQL quires
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed traceability matrix between requirements and test cases.
• Conducted database testing by extensive use of SQL.
• Reviewed, analyzed, manually compared, documented and communicated test results.
• Participated in bug tracking and reporting.

Environment: Informatica Power Center 8, DB2, Teradata, SQL Assistance, UNIX, TOAD, HP Quality Center, Cognos 7.3, B Report Studio, UNIX, QTP 10.0.SOAP,Agile,XMLStrategic Payment Program (SPP)Jan 2010 - Feb 2011

Confidential, NYC, NY

ETL/QA/BI Tester

Responsibilities:

• Gathered the business requirements, managed them and finally assured that the requirements are met.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed
• Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Analyzing the AS-IS system which loads the Monthly/Weekly/daily multi source data files for Data mart using PL/SQL procedures and convert them into informatica code.
• Back-end testing using SQL queries and Involved in writing PL/SQL quires
• Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
• Worked Extensively with Inbound 837I and 837P, claims processing systems•
• Wrote test scripts for the Medical and Dental Modules and Claims/Adjudication of Claims processing
• Involved in processing claims and validated the full payment cycle process until it generates 835’s and EOP’
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed database integrity check using SQL and Unix Shell Scripts
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Involved in automation of test cases using QTP
• Automated detailed test cases by using Quick Test Pro
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Created, updated and maintained the Traceability Matrix mapping the requirements to test cases in Quality Center.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed database integrity check using SQL and Unix Shell Scripts
• Used Quality Center as test management tool and defect tracking tool to create the test requirements, manual test cases and defects.
• Pulled test data from Oracle database based on the test scenario and then created scripts.
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• 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.
• Analyzed and imported test data from spreadsheets into Quality Center using Excel.
• Created test scripts for modules Medical health plan and UHC and maintained them on SharePoint site.
• Performed smoke testing after each build release as and when required.
• Interacted with developers to report software bugs and re-tested the fixed issues on a daily basis.
• Performed various types of testing, such as Adhoc, System integration testing, Regression, Data Validation testing, User Interface testing, Database testing, positive and negative testing.
• Conducted defect status meetings everyday with the developing team and discussed about the defects priority and severity issues.
• Responsible for creating and reporting daily status reports regarding the progress of testing process.

Environment: Informatica Power Center 7.2.1, DB2, Teradata, SQL Assistance, UNIX, TOAD, HP Quality Center, Business Objects 6.5.1 B Report Studio, UNIX, QTP .SOAP,Agile,XMLDatabase,PL/SQL

Confidential, MI

QA Tester

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan for System Testing.
• Initially performed Manual Testing of the application using numerous Test Scripts.
• Conducted Functional, System and Regression testing during the various phases of the development using Win Runner.
• Responsible for weekly status updates showing the progress of the testing automation effort and open issues to be resolved.
• Involved in tracking, reviewing, analyzing and comparing bugs using Test Director.
• Preparing the Defect reports and interacted with developers for Debugging.
• Studied different web applications performance for varying Loads and Stress conditions using Load Runner 7.0/6.5. Planned and prepared test scenarios and test scripts, and enhanced them according to the requirements.
• Responsible for White Box Testing on Small Business module.

Environment: Win Runner 6.5, Load Runner 6.5, TestDirector 7.0, Java1.4, WebLogic8.1, EJB, Windows XP, Oracle, UNIX.

Confidential, Novato CA

QA Tester

Responsibilities:

• Applied Black box Testing Techniques.
• Responsible for Assembly testing.
• Defect tracking and reporting using Mercury Quality Center 8.2, Share point.
• Involved in executing the scripts manually as well as QTP automated scripts from Quality Center.
• Test status recording and reporting.
• Tested XML files using Test harness tool for web services testing.
• Conducted Regression testing, Adhoc testing, and UI testing.
• Assigning scripts and tracking status of the script on daily basis.
• Participated in the project calls regarding testing process on weekly basis.

Environment: Quality Center 8.2, QTP 9.0., ASP.Net, HTML, SQL Server 2005, VB.Net, DB2.