SUMMARY

• Over 8+ years of diversified experience in Quality assurance testing. Skills include Manual & Automated Testing on Client/ Server & Web applications and Business Analysis maintaining applications in Data Warehouse using ETL tools Informatica and Data Stage.
• Possess excellent skills in Automation Testing using Mercury (Win Runner, Load Runner, QTP, Quality Center and Test Director) and Rational Robot tools along with Manual Testing that involves the whole Software Development Life Cycle (SDLC).
• Possess excellent verbal and written communication skills, organizational skills, energetic, flexible, a team player.
• Extensive experience in writing Stored Procedures, Packages, Database Triggers using SQL.
• Strong Database (Oracle, SQL Server) testing skills using advanced SQL, PL/SQL.
• Extensive experience in Functional testing, Unit testing, Usability Testing, Integration testing, Regression testing, GUI testing, Back - end testing, User Interface (UI) Testing, Ad-hoc testing, White Box Testing, Gray Testing, Black Box Testing, System Testing, baseline, Installation, Performance and Build Verification Testing.
• Experienced in analyzing Functional Requirement Specifications (FRS) and System Design Specifications (SDS).
• Tested Web Services call for their working and functioning and parsing XML documents.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Developed ETL Mapping Document based on Data profiling and source system analysis.
• Extensively used Load Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario
• Extensively used Test Director to write Test Cases and for reporting. All the Scripts are maintained using Test Director
• Experienced in RTM (Requirement Traceability Matrix) to know the status of the project.
• Experience on Win runner and TSL Scripting.
• Worked extensively on testing manually the client/server and web based applications developed using different technology.
• Responsible for Test cases, Test Plans, Test Reports, Executing Test Cases, Scripts
• Experience in Structured testing methodology
• Preparing, documenting and implementing of test procedures, test requirements and test cases for full life cycle (SDLC) testing methodology.
• Extensive experience in writing Stored Procedures, Packages, Database Triggers using SQL.
• Possess excellent verbal and written communication skills, organizational skills, energetic, flexible, a team player.

TECHNICAL SKILLS

Software Q/A &Testing: Standard & Procedures Development, SDLC, Testing, Test Plan Design and DevelopmentWeb Development

ETL: Active Server Pages, Java Script., VB Script, HTML, DHTML, ASP, .NET and XML,AjaxInformatica 8.1, Datastage, Data Mining, OLTP,OLAP

Database: Oracle, SQL, SQL Server 2000, MS Access, MS Office, MS Word, Power Point,Crystal Reports, Cognos, BO

Scripting: Shell Script (Make, build script), Perl, HTML, XML

GUI: Visual Basic 4.0/5.0/6.0

Testing Tools: Rational Requisite Pro, Win runner, Load Runner, Test Director 8.0, Silk, Quality Center, QTP,Junit

Other: Rational Rose, VSS, PVCS, UML, SCCS(Source Code Control System),Clearquest, Remedy

Servers: IIS, Web Logic, Web Sphere, IIS

PROFESSIONAL EXPERIENCE

Confidential, CT

Data warehouse EDW Lead QA Analyst

Responsibilities:

• Gathered business scope and technical requirements ODS and EDW testing.
• As a QA Lead, responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
• Involved in working on several E-commerce applications within the project environment.
• Prepared Test data for positive and negative test scenarios for Manual testing as Documented in the Test plan.
• Wrote Use Cases, Test scripts, Business process flows as per the URS and FRS
• Developed and delivering business requirements (BR) documentation.
• Delivered business systems design (BSD) documentation.
• Validated ODS data and EDW data after loading into the Data warehouse.
• Created Risk Management Plans that included documenting contingency plans, risk mitigation and transference of secondary risks.
• Performed Data analysis and generating Datasets for quantitative analysis.
• Drafted the Remediation Plan for the Project Management approval after Gap Analysis.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Validating the Target data based on the test cases.
• Preparing the test process flow diagram for ODS Cigna EDW ETL Jobs.
• Coordinated with Upstream and Downstream partners for files and defects status.
• Tested request and response using soap UI for claims processing.
• Creation of jobs sequences and job schedules to automate the ETL process.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary Used Quality Center as central repository for all test activities.
• Closely monitored and escalated on Critical and High defects and logged in Quality Center.

Environment: DataStage, QTP 10.0, QC, Jira, Windows XP, Toad, Ms-Excel, PL/SQL, Toad MS-SharePoint

Confidential

Lead QA Analyst - ETL/Data warehouse Tester

Responsibilities:

• Actively involved in Plans for integrating and testing the System Development Life Cycle (SDLC) in the "real world" environments for which it is intended are developed.
• Performed the scope analysis of the user requirements and translated the functional details into technical details.
• Identified Facts, Dimensions, and grain of the Dimensional modeling in Informatica.
• Identified the source tables, source columns, and referential joins using Data stage Tools.
• Communicated user requirements to the development team relational and dimensional data modeling, meta-data repository and data dictionary, full lifecycle design and application development, SQL server Backend testing.
• Provided required technical instructions to the development team to enhance the development process and ETL mapping Spreadsheets, MDX queries and functions.
• Preparation ofTraceability Matrix.
• Performed Unit testing, Integration testing, Functional testing, performance testing, user acceptance testing (UAT) and preproduction testing to validate report, mapping.
• Analyzed and validated the business model in SQL developer by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Debugged reports and Dashboards visibility with respect to users responsibility and web groups in an integrated environment, OLAP cubes testing.
• Tested Informatica Mappings worked with Staging area to validate the data with SQL Queries.
• Debugged failed DAC jobs/workflow tasks by reviewing the Informatica session logs and, if required, by running Informatica debugger for the associated mappings.
• Coordinated Informatica ETL Mappings & workflows migration from Dev environment to QA environment and validate the data with SQL Queries and Adhoc Reports.
• Involved in reviewing and updating Design and Requirement docs.
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• DesignedTest plansandTest casesfor testing the application.
• Performed front end as well as back end testing for various production Issues.
• Involved in several meetings to solve the Critical Issues with Developers and Business Team.
• Managing allQArelated projects, and ensuring the all QA & development deliverable are delivered in the most timely and efficient manner possible
• Tailoring,implementing, andutilizing enterprise ISQA processesand tools.
• Managing allverification and validation(V&V) activities for all Production modifications including projects, releases, and changes.
• Coordinating with otherQA Leads, the Project Manager, Development Manager, andSQA.
• Createdtest strategiesthat increase testcoverage,validate scalability,failoverand recovery and improves quality
• Maintained real time log of executed tests, results and environment history and review with cross functional team.
• Involved in preparingDefectSummary report.
• Extensively worked on Onsite and Offshore models.
• Ability to develop and execute effectiveTest strategyplans for quality management.
• UsedQuality center’s web defect manager to report defects found during testing Cycle.
• UsedQuality Centerfor development, execution, and maintenance of Test plans, Test cases, Test scripts, Test specifications and Test scenarios for both manual and automated tests.
• UsedQuality Centerfor the entire defect lifecycle- from initial problem detection through fixing the defect and verifying the defect.
• Participated inagile/scrumprocess - scrum team meetings with developer
• PerformedRegression TestingandUser Acceptance Testing(UAT)
• UsedTSYSto post amount on Accounts.

Environment: DataStage 7.5.2, Mercury Quality centre, and ClearQuest, Informatica 6.1, Cognos7.0,ORACLE, SQL, T- SQL, PL/SQL, Oracle 9i,TestDirector 8.0, SQL Server, DB2, JSP, Web Logic, XML,DB2, MS SQL Server2000, Erwin 4.0, Adhoc Reports, Visio, MS Excel, MS Access, UNIX-HP, SHELL, Teradata, SDLC, Sybase, perl/python.

Confidential, NJ

Senior QA Analyst

Responsibilities:

• As a Quality Analyst, responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
• Worked to ensure CMM Level 3 compliance.
• Involved in working on several E-commerce applications within the project environment.
• Wrote Test Plans / Test Approach documents in Microsoft Excel for projects
• Used Rational Unified Process (RUP)/UML to make an Object Oriented model for the application and used UML/Rational Rose for creating the Use Cases, Activity Diagrams, Class diagrams, Sequence diagrams, Process Flows etc.
• Wrote Use Cases, Test scripts, Business process flows as per the URS and FRS
• Managed product requirements using Rational Requisite Pro. Traced Requirements to High Level Design, Test Cases and Product Requirements.
• Developed System Design documents, facilitating and coordinating the gathering of business requirement (BR).
• Developed and delivering business requirements (BR) documentation.
• Delivered business systems design (BSD) documentation.
• Obtained internal and end user sign-off of Business Requirements (BR) and Business
• Created Use case scenarios and use cases as per the specifications and requirements Analysis.
• SQL queries (using MS-Query) were used to access the database for Back-end Testing.
• Created Risk Management Plans that included documenting contingency plans, risk mitigation and transference of secondary risks.
• Performed Data analysis and generating Datasets for quantitative analysis.
• Drafted the Remediation Plan for the Project Management approval after Gap Analysis.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Validating the Target data based on the test cases.
• Coordinated Informatica ETL Mappings & workflows migration from Dev environment to QA environment and validate the data with SQL Queries and Adhoc Reports.
• Preparing the process flow diagram for ETL Jobs.
• Validated all the applications and successfully executed and unit tested the jobs with Data Stage director.
• Creation of jobs sequences and job schedules to automate the ETL process.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Involved in Developing and executing the automation scripts using QTP.
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• Preparation of Traceability Matrix.
• Used the MS Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio etc for various documentation and analysis reports.
• Created business flow diagrams and charts for E-commerce applications for all phases of the SDLC.
• Involved in developing Project Plan and Test Plan for the system
• Performed Regression Testing and User Acceptance Testing (UAT)
• Maintained the Requirements Tractability Matrix (RTM).
• Wrote SQL queries to test the Oracle database.

Environment: Visual Basic, XML, Data Stage 7.5-Designer, DTS, Cognos ReportNet8.0, Microsoft Excel, Oracle, SQL, Toad, AS 400, RUP, QTP, Clear Case, VB Script, Crystal Report 8.5, WinRunner, Load Runner, Test Director, Windows NT,Unix and Windows 95/98/NT/2000.

Confidential, NJ

Senior Performance QA

Responsibilities:

• Assisted the team with writing and executing load and Performance tests using Mercury Load Runner. Analyzed and communicated the test results, and suggested the improvements to the AD team.
• Determined the testing needs for new and existing products, and developed an overall testing strategy for the group. Allocated the responsibilities and coordinated the load testing efforts for all new releases.
• Identified the performance related problems and recommended the solutions and improvements for complex, high risk and critical transactions.
• Analyzed transaction response times under load and introduced rendezvous point in highly critical transactions using start and end transactions and developed reports for management and analyzed graphs using Load Runner Analysis.
• Involved in planning, designing, testing and analyzing phase of performance testing. Coordinated with AD team, PM, Network engineers, DBA and WID engineers to help resolve and tune applications/systems.
• Maintained a historical record of test results and identified the problematic trends. Ensured the Performance test objectives are met in a timely and cost effective manner. Worked with external teams to create a strategy to manage test data and then help to implement it.
• Worked with other QA teams to ensure all quality related issues are being addressed. Identified the activities, dependencies, and critical success factors where appropriate. Contributed to project delivery including project progress reporting and other governance processes. Communicated the test results and worked with other teams responsible for supporting Performance Test issue resolution.
• Developed TSL scripts, used various check points and developed reusable functions using WinRunner / Quick Test Pro (QTP) and Junit.
• During the test runs observed the Memory usage, CPU utilization of the middle tier and asked to check the database connections, running thread count by DBA of the test boxes calculate response times from App server.
• Mentored other engineering team members in how to instrument automated tests in established frameworks, and integrating it in the overall software development process
• Assessed and estimated detailed test requirements based on discussions, use cases, agile user stories, functional specifications, or other sources of requirements information.
• Generated test reports including results of testing and product stability, including prioritization of issues and recommendations concerning release of product.
• Proactively provided informal and formal status reports on a daily and weekly basis as necessary
• Build strong working relationship and trust with other QA engineers, software engineers, technical publications, engineering management, product management, customer support, sales consultants, etc.
• Effectively participate in project communication, clearly articulate project risk, raise issues, and provide recommendations and input as part of a cross-functional agile team.

Environment: QTP 8.0, Load Runner 8.0, Quality Center 8.0,SQL, PL/SQL, Java, .NET 2.0SQL Server 2000, Windows XP, VB Script.

Confidential, PA

QA Analyst

Responsibilities:

• Reviewed test plan and designed test cases using Mercury Test Director.
• Involved in Functional testing, System testing, Installation testing, Integration testing and User Acceptance testing.
• Performed Manual Testing of all the credit card transactions prior to automated testing of the application using Mercury’s Functionality testing tool WinRunner.
• Provided support to application developers and performed query tuning to improve response time of the application.
• Gathered requirements using Use Case analysis and modeled component based system using the UML (Functional models, Object Models, Dynamic models).
• Analyzed system requirements and Involved in preparation of Test Plans for different modules and documented test cases for various screens of the application.
• Gathered the information from the competitor’s websites. Performed the requirement analysis and documented the requirements.
• Performed load testing of the application by creating virtual users using LoadRunner.
• Executed Regression Testing by repeated execution of recorded test procedures to identify errors in each modified build in the process of testing.
• Inserted check points to verify the correct behavior of GUI objects.
• Involved in Back end testing such as validating data sets, importing data sets for different customers.
• Responsible for identifying the functional test cases for Regression Testing and automated these scripts using Win Runner.
• Used Win Runner to conduct Data Driven Testing by pulling data from a table.
• Checked for data integrity in back end by executing SQL queries to the database.
• Performed configuration testing of web pages with different browser versions of Internet Explorer and different operating systems such as Windows 95/98/2000/NT.
• Worked closely with the application developers who created databases, Tables, Indexes, Sequences, Views and involved in loading Data using SQL.
• Assisted in the maintenance of the company’s Local Area Network.

Environment: Test Director, WinRunner, LoadRunner, WinRunner, SQL Server, PL/SQL, Oracle, UNIX, Windows 95/98/NT/2000, J2EE.