SUMMARY

• 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• 4+ years of experience in Data Warehouse applications testing using Informatica Power Center and Data Stage on multiple platforms.
• Possess excellent skills in Automation Testing using Mercury´s Quick Test Pro (QTP), Win Runner, Quality Center and Selenium.
• Good knowledge on Business intelligence, OLAP, OLTP, Data marts, data warehousing, Dimensional data modeling, modeling using analysis services.
• Extensive knowledge and experience on data warehouse using ETL tools like Informatica, SSIS, Data Stage, Import-Export data, Bulk Copy.
• Experienced in testing with Web services in J2EE, .NET environments.
• Experience in preparing Test Plans, Test Cases with the help of SQA teams and conducting Unit, Integration and System testing according to BRD for smooth execution throughout the systems..
• Experience with QA methodology and QA validations to ensure the Quality Assurance Control.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Experience in manual and automated testing using rational tools like QTP, Win runner, Load Runner and Selenium for validation and verification of WEB Application and for performance testing.
• Extensively used SQL and PL/SQL for data Integrity testing at the backend.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in performing Functional, Integration/ System, Regression, Security, User acceptance tests and also perform the duties of Facilitator.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Experience in testing Business Report developed in Cognos, Business Object and OBIEE
• Extensive experience in working with all phases of Software Development Life Cycle (SDLC) in Water Fall and Agile/Scrum methodology.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

RDBMS: MSSQL Server 7.0/2000/2005/2008 , MS Access, IBMDB2, Oracle 8.1/9i/10g/11g,Toad.

Data Modeling: Star-Schema, Snowflake-Schema, FACT and Dimensions tables, pivot tables,ERwin

ETL Tools: DTS, Data Stage 8.x/9.1, Informatica 7.1/8.1/8.6, SSIS, Bulk Copy, Import/Export.

Testing Tools: HP ALM 11, Quality Center 10, Test Director7.5, Win Runner, QTP 8/9/10, Load Runner7.5/10/11, Selenium IDE/RC, SOAP UI.

BI Tools: OBIEE 10g, Cognos 8.0 Suite, Business Object 6.5,SSRS, SSA and Crystal ReportsMicro Strategy 8.x

Programming: SQL, PL/SQL, ASP.NET, C, C#, UNIX Shell Scripting, VB Script.

Web Technologies: JavaScript, HTML4.0, .NET, XML, J2EE.

Operating System: UNIX, HP-Unix, Windows 95/98/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Rosemont, IL

ETL/BI Tester / Sr. Quality Assurance Analyst

Responsibilities:

• Executed test scripts for Functional and Performance testing of GUI based applications GUI-less web services, also validate screen flow and layouts data validations and full coverage of requirements.
• Experience in handling different types of file system such as Flat Files, CSV, Relational, VSAM, COBOL,XML.
• Worked on validating data from data warehouse using Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using Informatica.
• Worked on multi-tire and large scale projects.
• Used SQL Developer for validating calculation logic and data validation
• Performed data validations by using SQL Developer, writing complex SQL queries using joins, set operations, group by, having claws, sub queries and correlated sub queries
• Worked on testing .NET, Java and Web applications under UNIX and Windows Platform.
• Performed Black box, White box, Ad-Hoc, Smoke testing for validation and verification.
• Worked on testing of Web services and J2EE application services.
• Wrote .NET coding and testing of the code as a part of project requirements.
• Work directly with project managers, corporate users, developers, architect, systems analysts and end users to determine system requirements, analysis, and for preparing test plan.
• Work directly with project requestors and end users in support of User Acceptance Testing.
• Participate and represent QA team in meetings and discuss any concerns and issues regarding testing
• Consult and collaborate with data warehouse developers, BI developers, System Architect
• Develop and execute Test strategies, Test plans and Requirement Traceability matrices.
• Utilize Quality Center 10 and ALM - HP 11 for test management, development, execution, documentation and defect management activities.
• Used Quality Center (QC) 10, HP ALM - QC 11 as defect management tool and also wrote manual test cases in Quality Center.
• Expert in using HP Load Runner 10 and 11 for performance testing, load testing, Endurance test, spike test and stress testing.
• Expert in using QTP, generating scripts for automation and manual for functional test, regression test
• Integrated QTP with Load Runner for Load testing and Performance Testing.
• Trained beginners and intermediate QA testers on QTP and on Bug reporting tool.
• Set up dashboard to generate the analysis reports and also working on different management reports such as (Daily Defects Daily Metrics test plan vs. test lab and combination of Requirements).
• Involved in developing and defining the role of QA team in entire SDLC process to reduce the overall cost of developing an application.
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Responsible for System Integration Testing signoff of product before Business users can use it
• Track and report testing activities, including test results, test case coverage, required resources, defects discovered and their status, performance baseline
• Assign task to each testing team member and monitor testing progress as well as provide timely feedback to Department manager and Project Manger
• Set up dashboard to generate the analysis reports and also working on different management reports such as (Daily Defects Daily Metrics test plan vs. test lab and combination of Requirements).
• Validate and generate BI report developed in OBIEE, also used different functionalities such as Drill Down, Drill Up, Cross tab, generate Graphs and Pie Chart and checked for cosmetic error for reporting.
• Worked closely with users and program developers to ensure application development meets user expectations.
• Coordinated the testing activity for positive & negative testing, data validation, and GUI testing.
• Used Agile Scrum and Water Fall Model for building the application.
• Developed XML test files based on XML schema.
• Interacted with programmers to identify and resolve technical issues.
• Worked on onsite-offshore model, rum them through documentation to keep them up to date.

Environment: HP-ALM 11, Quality Center 9.0/10, QTP 10, Load Runner 11, Oracle 10g, Informatica 8.6.1, Flat Files, .Net, SQL, MSSQL Server, Agile and Water Fall, OBIEE, AutoSys, Control-M, HP-Unix, Toad, Windows XP/2000

Confidential, Windsor, CT

Quality Assurance Analyst/ ETL Tester

Responsibilities:

• Analyzed the business requirements and use cases to understand best about the application.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle, and DB2.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Developed detailed test plan for two iterations and test cases and executed them.
• Worked on testing of Web services and J2EE application services.
• Worked with data validation and testing in DB2 databases using ETL Tools.
• Identified the test cases that are to be automated and those that are to be manually done.
• Managed requirements in Mercury Test Director.
• Conduct progress meetings and solving the issues in Test Director as a part of day to day activity.
• Maintained and controlled the Test Director and Users.
• Providing detailed structure in test plan tree and providing access to the test case developers to write their test plans.
• Worked on testing and validating of data from data warehouse and sending it to SQL Server 2005.
• Tested data warehouse migrated data between different heterogeneous sources such as Flat file, Excel and SQL Server 2005 using BCP and Bulk Insert.
• Worked on developed SSIS packages for loading data from text files, CSV files to SQL Server databases using SSIS from data warehouse.
• Involved in Automated and Manual testing Applications using QTP (Quick test Professional), Selenium IDE, SOAP UI.
• Optimized and maintained existing developed new automation framework using QTP 8.0 and Selenium.
• Created Automated frameworks using Selenium RC configured under Eclipse JUnit environment.
• Developed test case, recorded the script, edited manually to provide autocompleting support in Selenium IDE
• Created automation suite for the Regression and Functional testing using QTP, Selenium.
• Executed test scripts Performance testing, Load Testing of GUI based applications, GUI-less Web application using Load Runner.
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Worked on testing .NET, Java and Web applications under UNIX and Windows environments.
• Developed Defect Summary Report and Test Summary Report once the testing is done.
• Involved in the complete Software Development Life Cycle (SDLC) in Water Fall methodology.
• Created test plan, test cases, test script as per the business requirements and executed them.
• Involved in writing and implementation of the various test cases and test scripts.
• Extensively used SQL and PL/SQL for data Integrity testing at the backend.
• Wrote UNIX shell scripts to perform Batch tests.
• Developed SQL queries to extract data from the source tables.
• Version control and configuration management was done using PVCS
• Extensively worked on Test Director for bug reporting/tracking.
• Involved in bug review meetings

Environment: Quality Center 8.2, Load Runner7.5, Quick Test Pro 8.0, Selenium IDE/RC, SOAP UI, Oracle 9i, Informatica 7.1, Web Logic, .Net, Web Methods Broker JDBC, Windows XP, 2000/03 Server, SSIS, MS- SQL Server 2000/2005, DB2, SQL, UNIX.

Confidential, Birmingham, AL

QA Analyst / ETL Tester

Responsibilities:

• Reviewing Business requirements, Complete SDLC, Application Design, Technical and Business Writing, and testing methodologies.
• Developed test plans for Functional and Regression testing, documented test cases corresponding to Business rules.
• Used Test Director to prepare test cases with the complete description of requirements of client.
• Responsible for developing test cases and test scripts using Win Runner testing tool, Software validation and verification.
• Identifying project requirement and testing product functionality and performance.
• Requirements test cases, test execution and Defect tracking Using Test Director.
• Developed and executed test scripts like System and User Acceptance test cases.
• Execute the test cases using inputs and ensure that the final outcomes of the tests are satisfactory.
• Developed and Implemented Back-End testing process like test plans and test scripts for Oracle based databases.
• Performed Integration, System, Regression, Security, Performance and User Acceptance testing.
• Administered & Developed test plans using Test Director to ensure that test cases reflect user needs for the Functional, User Interface, Performance, and Security requirements.
• Created test input data requirements and prepared the test data for data driven testing.
• Created and executed test scripts to verify complex system requirements.
• Developed TSL scripts in Win Runner to perform end-to-end testing and created a set of re-usable scripts.
• Worked on Baseline of the application and then performed the actual load test using Load Runner.
• Responsible for monitoring the server by running the scripts under load conditions and to identify the bottlenecks.
• Found out the Response time information and through put information through the Performance explorer of the Load Runner.
• Used Test Director to log defects and generate defect reports and graphs.
• Actively participated in enhancement meetings focused at making the application more reliable.

Environment: Win Runner 7.5, Quick Test Pro 6.0, LoadRunner7.5 and TestDirector7.5, Informatica 6.2 Business Objects 6.1, Oracle 8.1.7/9i, SQL, PL/SQL, SQL Loader, UNIX, VB Script, XML, HTML, MS Office, Clear Case, Clear Quest and Windows 2000/XP

Confidential

Quality Analyst

Responsibilities:

• Mapped Mortgage Brokerage Module (MBM) Use Cases by analyzing Mortgage Banking Group’s Business Logic and Process Flows to the USB’s URD.
• Validated test scripts to ensure that all the test scenarios are complete and in compliance with the NACHA Standards.
• Conducted Functionality testing, System testing, and Integration testing, on Customer Information, Credit & Fico Score Extractor, Qualifier & Rate Calculator, Product Finder and LTV Generator Modules.
• Performed Database testing using SQL Queries for data validation, and also conducted User Acceptance testing (UAT) for the AUT.
• Played a major role in Project Review Meetings and updated the Bug Status Reports.
• Performed Requirements Analysis and Use Case Analysis for LMAI.
• Prepared a detailed test plan, Smoke test cases and Functional test cases.
• Created, executed and automated test scripts / test procedures using Win Runner based on the Use case scenarios.
• Conducted Graphical User Interface (GUI) testing, Functional testing, System testing, and data driven testing through Win Runner to validate the Premium against the Quote.
• Tracked and Reported bugs in Clear Quest.
• Participated in weekly status meetings and updated the testing progress.

Environment: HTML, Java, J2EE, Java Script, IIS, Web Sphere, Oracle 8i, Mainframes, DB2 and IE 5.0. Win Runner 7.0 and Test Director 7.0.