SUMMARY:

• Around 7 + years of professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client - Server applications
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC).Experience in Agile, Scrum and Waterfall models of SDLC.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.
• Worked with Business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.
• Extensive use of defect tracking tools like Quality Center and Test Director. Experience in functional testing tools such as SOAP UI testing & QTP Automation testing
• Wrote complex SQL and PL/SQL queries to validate DataMart and Data warehouse Backend Testing
• In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
• Experienced in Integrating and coordinating testing activities into software development activities
• Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client’s requirements and related technical documents.
• Worked with different RDBMS Oracle, SQL Server, Teradata, MySQL, IBM DB2 and their GUI utilities like SQL Loader, Oracle SQL developer, Teradata SQL Assistant, WinSQL to do transaction of data
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, DataStage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, Cognos, Microstrategy, OBIEE, SSRS and Crystal Reports .
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using Oracle, SQL Server and DB2.
• Working knowledge on various types of data feeds like: XML, DB2, Oracle and Flat files.
• Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing
• Coordinated the testing efforts for: QAT, SIT, UAT, Regression, Smoke, Integration, Migration, Performance, Stress and Data Driven
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data. Used Quality Center for defect tracking.
• Strong working experience in the Data Centric Testing, Data Analysis, Design and Development
• Supporting multiple projects, while maintaining strong quality and ability to meet deadlines
• Proficiency using Rational Clear Case for Documentation and used Clear Quest for Defect tracking.
• Excellent analytical skills, documentation skills and presentation skills
• Self-starter and ability to present ideas in a concise, logical and well organized format

TECHNICAL SKILLS:

Bug Tracking/Test Management: HP ALM/Quality Center/ Clear Quest/Clear Case/ Load Runner

Data warehouse ETL Tools: Informatica 9.6, Data Stage, AbInitio, SSIS

Reports Business Intelligence: Business Objects, Cognos, SSRS, Microstrategy, Crystal Reports, Hyperion, SAS

Relational Database (RDBMS): SQL Server, Oracle, Teradata, MS Access, MySQL, IBM DB2

Operating Systems: Windows, Vista, UNIX, Linux

Methodologies: Scrum, Agile, Spiral, Waterfall and Kunban

Business Tools: SQL, PL/SQL, TOAD, QTP, SOAP UI, web services

Programming Languages: Java, .Net, XML, HTML, C/C++, VB & Java Script

Microsoft Tools: Microsoft Excel, Word, Power point, MS Project, Visio

PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr.QA Tester/Validation Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Designed and executed various Test scripts for Regression tests
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Have programming skills in SQL and PL/SQL and experience in SQL Server and Oracle databases on UNIX and Windows platforms.
• Work closely with EDI to ensure accuracy in data transmissions and shared processes.
• Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every release and check the configurations
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Business Objects.
• Used BO Info View for testing the scheduled reports and viewing the history.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of ETL Informatica Power center code and UNIX from UAT to Production.
• Worked on issues with migration from development to testing.

Environment: Data warehouse ETL Informatica 9.6.1, Business Objects, Oracle 11g/10g, Quality Center 11.0, XML, XSLT, Win SQL, EDI, DTS, SSIS, T-SQL, SQL, TOAD, SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2,UNIX, PERL,, MS Access, Flat Files.

Confidential

ETL QA Analyst/Backend Tester

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Created Data warehouse ETL test data for all ETL mapping rules to test the functionality.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing on UNIX and Windows platforms.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Worked with Data warehouse ETL group for understating mappings for dimensions and facts.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects.

Environment: Data warehouse ETL Informatica 8.6, Business Objects, SQL, PL/SQL, HP Quality Center 9.2, XML, Oracle 10g, QTP, ALM, SOAP UI, JavaScript and TOAD for Oracle

Confidential, Rochester, MN

QA Analyst/Validation Tester

Responsibilities:

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Comparing/analyzing mainframe test data with the front end.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• 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
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
• Discuss issues/defects with the business and development teams.
• Testing/Verifying/logging defects.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Developed UNIX Shell scripts to automate repetitive database processes
• 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: DWH ETL Informatica, SQL, PL/SQL, Quality Center, SOAP UI, Java, J2EE, SQL Server /Oracle 8i, TOAD, windows XP.

Confidential, Hartford, CT

QA Analyst

Responsibilities:

• Assist entry-level tester(s) on reviewing requirement, preparing and executing test cases and report software defects. Performed black box, Functional, Integration, Stress and Regression testing of the Website.
• Performed Regression Testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system.
• Created and executed SQL queries to validate the data and used data manipulation language.
• (DML) to update the data in the database and verify with front end that application handles the changes correctly.
• Initiated defects and assigned to Development teams with appropriate severity levels.
• Actively participated to setup the test environment for the application(s) needs to be deployed on test environment.
• Used Quality Center to maintain Test Case and Reports Repository.
• Executed the Test cases using Test Director Tool for Web based application and checked the functionality of the application for every release.
• Prioritized and reported defects using QC to present documents and reports in weekly team meetings.
• Participated in weekly status meetings, conducted walkthroughs, documented proceedings. Modified and maintained test cases with changes in application interface and navigation flow. Conducted weekly batch testing to in corporate changes in new builds.
• Provided the management with test metrics, reports and schedules.

Environment: Test Director 7.5, Oracle 9i, SQL, T-SQL, SSIS, SQL Server 2005, MS Excel 2003, Shell scripting, UNIX, Windows NT