PROFESSIONAL SUMMARY:

• 7 years of diversified experience as Quality Analyst in Healthcare, Banking/Mortgage & Insurance. Vast knowledge of Software Development Life Cycle & its methodologies, expert in Quality Assurance testing of Web Based. Client/Server, and BI applications.
• Strong understanding of Information Technology, process to develop web based & Client based (Internet & Intranet) applications.
• Expert in using the RUP, Agile/Scrum and Waterfall testing lifecycle Methodologies
• Experienced in developing, Reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script
• Experience in manual testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center.
• Expertise in test strategy design based on the various types of testing including unit, integration, function, system, usability (UI), End to End, security, load, stress, capacity and performance testing.
• Excellent in performing with in manual testing with the focus on Black Box testing, White Box testing smoke testing, system integration, regression, acceptance and usability testing of web applications.
• Performed manual and automated test procedures for functional and performance testing, load and stress testing, scalability and compatibility testing, and usability testing of GUI and Web based applications.
• Expertise in creating the test suite to perform regression testing across various releases and builds.
• Maintain the test environments (e.g., data loads, database backups, restarting the servers, requesting deployments, troubleshooting issues).
• Interact with clients for Quality discussions and responsible for the QA deliverables.
• Expertise in Microsoft office (Word, Excel, Power Point, Outlook, Project, Project, & Visio)
• Proficient in SQL query and testing RDBMS such as Oracle, MySql, SQL Server for data validation.
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for data base.
• Strong experience in testing ETL applications and BI reports.
• Strong testing experience in UNIX platform.
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email (outlook)
• Ability to learn and adapt to new tools and technologies very quickly
• Excellent Communication and interpersonal skills with clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS:

Industries: Finance, Banking, Insurance and Healthcare

Functional Testing Tool: QTP 8.0/8.2/9.2/9.5/10.0

Defect Tracking Tools: ALM/Quality Center 11/9.0/9.2/10, Clear Quest, Product Studio and BugZilla

Reporting Tools: Siebel Analytics, Business Objects, Crystal Reports, Cognos, Report NetOperating System: Windows 98/XP/2000/ME, UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML

RDBMS/ Database: Oracle 9i/10g, TOAD, SQL Server 2000/2005, Teradata

ETL Tools: Informatica, Ab Initio, DataStage

PROFESSIONAL EXPERIENCE:

Confidential, Paramus, NJ

ETL/BI Tester

Responsibilities:

• Analyzed the existing system and process gaps in context new requirements. Vs the existing system.
• Conducted JAD sessions with management, SME’s, Business users and other stakeholders for open and pending issues to develop specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Collaborated with team members on all documents and kept a central task location for assigning tasks to team members using SharePoint.
• Extensively used Informatica Workflow Manager to run the workflows.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Involved in testing the Cognos reports by writing complex SQL queries
• Written Test Cases for ETL to compare Source and Target database systems.
• Tested the loaded data to different databases using SQL scripts and maintained a repository for data loading scripts
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested Cognos reports for verifying and validating the data.
• Written SQL queries manually and also built SQL queries using TOAD to validate the Customers ' addresses and accounts level data .
• Used ALM to execute automation scripts in batch mode or unattended mode.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Ensured that migrated data is complete, accurate and correct from Oracle database.
• Performed manual back end testing while retrieving the data from the Oracle database to the target systems.
• Worked with business team to test the reports developed in Cognos.
• Wrote SQL scripts and queries for test case validation and database verification
• Extensively used MS Office and MS Word data sheets to import positive and negative results in ALM.
• Co-ordinate with business and technical people regarding test run results.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Exported test cases into Mercury ALM.
• Working on CICS (Customer Information Control System) region and extensively used Main frame.
• Weekly meeting with the Project Management team and share the Status Report on the weekly basis
• Coordinated efforts to using PL/SQL for testing
• Assigned critical performance Defects to the developer using ALM.
• Written PL/SQL to test Back end Oracle database using TOAD
• Written Oracle SQL to test backend database
• Used Bash Shell to execute the jobs in Unix

Environment: Share point, SQL, PL/SQL, MS SQL Server, TOAD 3.5, HP ALM, MS Office 2007, Windows XP/2003, Mainframe CICS region, Cognos, Oracle 10g, Informatica 9

Confidential, Buffalo, NY

ETL/BI Tester

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that were developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports developed using Business Objects.
• Perform both manual and automation testing and created various test results to track the testing results.
• Export requirement, test cases into the ALM, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Extensively tested the Business Objects reports by running the SQL queries on the database by reviewing the report requirement documentation.
• Validate report data in SQL server database during report migrations
• Have experience in validating the business transformations by writing complex SQL queries
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Tested several data validation graphs developed in Ab Initio environment.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Participated to create Test Analysis reports (TAR) and stored them into the ALM.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Tested all the ETL Ab initio graphs end to end (Data Warehouse Testing)
• Performed Functional Testing using ALM.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Defined the “Test Engagement Process” for new application launch and maintenance releases.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.
• Good knowledge of Unix Shell Scripting etc.

Environment: Quick Test Pro 9.5/10.0,HP ALM, Web Services/Web methods, XML, HTML Oracle, SQL, PL/SQL, MS SQL Server, TOAD, Business Objects, Windows 2003/2007, UNIX, Ab Initio

Confidential, Warren, NJ

Quality Assurance Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Validated all the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Validated all the session logs.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Enhanced the Ramp Up and Ramp Down time’s to simulate the real time scenarios.
• Generated Load Runner reports with Running Vusers, Hits per Second, Throughput, Average Response time and Total Transactions per Second graphs.
• Created a Performance Report for the end to end testing in comparison with the baseline and final values.
• Uploading the Performance Test Plan, Test Scripts, Scenarios and Final Reports in the Quality Center for every application.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Also worked closely with the developers for the Performance Tuning of a new application by gradual Scaling of the application.
• Weekly meeting with the management team and share the Status Report on the weekly basis.

Environment: Quick Test Pro (QTP) 9.5, Quality Center (QC) 9.0/9.2, VB script, SQL, PL/SQL, SQL Server, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle 10g, Informatica 8

Confidential, Jersey City, NJ

Quality Assurance Analyst

Responsibilities:

• Worked with Business analyst and QA manager in gathering technical and functional specification documents for reviews to understand the functionality.
• Worked with ETL group to understand mappings for dimensions and facts.
• Prepared test plan and determined testing approach and time slots for task completion.
• Coordinate with other test team, define the functionalities to be tested and assigned the tasks to other team members.
• Wrote Test Cases and design test steps according to the requirements specifications in Excel.
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Inserted Check Points to check for the broken links, Text and standard properties of an object using Quick Test Pro.
• Performed Synchronization and Tested Applications using Quick Test Pro with different sets of data.
• Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
• Used QTP to perform Regression Testing.
• Used Recovery Scenario Manager in QTP to handle exceptions.
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Get sign off after completion all the test scenarios have been tested successfully.
• Worked with Business Analyst in UAT testing and involved in testing in Production region.
• Extensively involved in Database testing by writing SQL queries.

Environment: IIS, ASP 2.0,Informatica, Test Director, SQL Server 2008, PL/SQL, Quality Center 8.0/8.2 and QTP 9.2,9.5 C#.Net, VB.Net Windows XP/2000/2003, Oracle Finance Application

Confidential, Arlington Heights, IL

QA Consultant

Responsibilities:

• Responsible for providing the testing team with the required business data, rules and logistics from the business, architecture and development teams and to inspect final scripts and confirm to laid down standards.
• Developed, modified and executed test cases and scripts using Test Director, VSS and Win Runner for Assembly, Functionality and Regression testing.
• Directly used backend servers, like AS400, Mainframes, DB2 and SQL Server for White Box and Backend Testing and other validations.
• Involved in designing and developing validation and test plan documentation.
• Prepared detailed reports of Bugs and Defects, pass/fail reports and comparison analysis, and interacted with the development teams, application and data architecture teams, migration and build teams and the DBA team to report and correct defects.
• Tested the application with different user profiles to simulate real time usage.
• Interacted with the Business Requirement and Client Advocate teams to understand, test and compare old and new business rules.

Environment: Java (J2EE), ASP.NET,SQL Server 2005, PL/SQL, Win Runner 8.0, Quick Test Pro 9.0, Load Runner 8.1, VB Script,Quality Center 8.2., MS Visio, MS Project, MS Windows 2003

Confidential

Quality Analyst/ Software Tester

Responsibilities:

• Created scenarios based on business conditions and functions.
• Comparing/analyzing mainframe test data with the front end.
• Running SQL queries on the mainframe servers to retrieve test data.
• Creating and running automated scripts through Mercury Win runner.
• Reviewed Functional and Integration requirements.
• Develop Functional and integration test cases and review Test Cases wrote by peers.
• Created Test Cases, and got reviewed those by peers
• Discuss issues/defects with the business and development teams.
• Testing/Verifying/logging defects.
• Performed application setup in test environment and enhancing the documentation.
• Worked with internal and external developers/quality assurance staff to understand and resolve issues.

Environment: Win Runner 7.5/7.6,Mercury suite QTP 6.5/8.0/8.2, Load Runner 7.8, Quality Center, Windows, Linux, Java, C, HTML, Oracle10g,SQL 2000/2005.