SUMMARY:

• More than 14 Years of diverse experience in Information Technology with emphasis on Quality Assurance for the implementation of User/Business/Functional requirements to enable the product as a defect free product. Expertise in Manual Testing of Client/Server, ETL, Business Intelligence, Mainframe, Middleware and Web based applications as well as ETL automation for database related testing.
• Strong background in QA/ETL with analysis, coding, development and execution of Test Cases and Test Scripts.
• Strong experience in performing Data Migration Testing.
• Experienced with Test Plan, Test Case, Test Script, Change Request and Defect Request.
• 7+ years of experience in RDBMS technologies like Oracle 8.x/9.x/10g/11g, Teradata V2R5/V2R6, DB 2 8.0/7.0/6.0, MS SQL Server 2000/7.0/6.5, Sybase and MYSQL.
• 6+ years of working experience in data warehouse concepts and technologies like OLTP, Normalization/Denormalization, ETL, OLAP, Data Models (Star/ Snow Flake Schemas), DataMart (Dimensions and Facts) and Reporting.
• Extensive Experience with Utility Tools like TOAD DataPoint, SQL Server Management Studio, SQL Developer, SQL* Plus, SQL*Loader and Rapid SQL, SQL Query Analyzer, SQL Assistant
• Familiar with managing the defects and change requests through Testing Tools like Quality Center/Test Director, Clear Quest and StarTeam.
• Experienced with ETL tools like Informatica, SSIS, and Datastage .
• Extensive experience with Reporting Tools like OBIEE, Microstrategy and Siebel Analytics.
• Familiar with Excel for developing Requirements Traceability Matrix (RTM ) and Capturing and Updating Change Requests.
• Experienced in GUI testing of the web based applications.
• Proficient in Oracle tools and utilities such as SQL*Loader, Import/Export, UTL FILE.
• Worked on Teradata tools such as MLoad and FastLoad.
• Expertise in importing millions of records from data feeds using external tables or SQL* Loader.
• Experienced with System, Integration, Regression and User Acceptance Testing.
• Familiarity in various software systems and platforms with good understanding of Object Oriented Programming (OOP) and ERD.
• Excellent problem solving, interpersonal, and communication skills.
• Have strong analytical, problem solving and communication skills, extremely goal - oriented and driven by strong work ethic.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 12.01, Mercury Test Director, Borland StarTeam, Clear Quest, Test Partner, Selenium IDE

Databases: Oracle 8i/9i/10g/11g, DB 2 8.0/7.0/6.0, SQL Server 2000/2005, MySQL, MS Access, MS Excel, Sybase, Teradata V2R5/V2R6

Utility Tools: TOAD 10.6 SQL Server Management Studio, Rapid SQL, SQL*Loader, SQL Developer, TOAD Data Point, WinSCP

IDE/Tools: SQL *Plus, PL/SQL Developer, Sql Navigator, Toad, Oracle SQL Developer, SQL *Loader, Visual SourceSafe, Win CVS, Hyperion 8.7, Informatica, Pentaho, AUTOSYS, EMTEX, Datastage Director, Microstrategy, Fusion Middleware, Tuxedo, SOA Websphere

Database Designer Tools: Erwin, Microsoft Visio, Schemester, Embarcadero

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon

ETL/UAT Test Engineer

Responsibilities:

• Created complex SQL scripts for source and target following the mapping document guidelines.
• Prepared the Testing Document and the Test Data for performing data validation covering multiple scenarios for all the tables using Toad DataPoint .
• Performed thorough validations (data correctness, datatypes, constraints, historical, data counts, integrity etc.) required both from the data point of view as well as the business point of view.
• Created validation scripts for complex logic of FDIC in the banking domain.
• Created testing scripts to validate all the data columns for all the dimensions, facts as well as standalone tables in their respective data loading format.
• Created a series of testing scripts with the typical format of count validation followed by data columns validation and finally null column checks and primary, foreign and surrogate key validations of all the dimension and fact tables.
• Automated the testing of the whole script by passing on cycle date parameters and generate test results in excel sheet format.
• Attended daily interactive sessions with the QA and development team to keep track of the changes.
• Created the Test Plan and Test Cases in QC
• Identified issues and followed bug life cycle in HP ALM to resolve those.
• Involved in client meetings to understand the data flow and business requirements.
• Provided daily updates regarding the progress of the project to the Testing Manager.
• Created the documents to track the testing progress in SharePoint.

Environment: Oracle 12c, TOAD DataPoint 3.5.0, HP Quality Center, MS Sharepoint, VB Script 3.15

Confidential, SF

Data Migration Test Engineer

Responsibilities:

• Written complex SQL queries to create source and target views following the mapping document guidelines.
• Created user defined functions for data extraction in uniform format.
• Created the Testing Document for all the involved tables by identifying the unique data for performing data validation using Toad DataPoint .
• Attended daily interactive sessions with the development team to keep track of the changes
• Created the Test Plan and Test Cases in QC
• Identified issues and created defects in HP ALM
• Involved in client meetings to understand the data flow and business requirements.
• Have active interaction with DBAs’ related to the schema, dblink creation, data refresh for multiple rounds of testing and other tasks.
• Had One to One meetings with the data modelers to understand the structure of the database.
• Provided daily updates regarding the project to the Testing Manager.
• Performed thorough validations (data correctness, datatypes, constraints, historical, data counts backout etc.) required for the data migration project.
• Performed automation testing of the Web UI using Selenium IDE.
• Performed ETL automatic script execution using the framework created in Toad DataPoint.

Environment: Microsoft SQL Server 2008, Oracle 11i, TOAD DataPoint 3.5.0, HP Quality Center

Confidential, DE

Web UI/DWH Testing Team Lead

Responsibilities:

• Attended meetings with business users, product owners and business analysts to understand requirements for the new web UI
• Reviewed the requirements document created by the BA and prepared a thorough test plan.
• Involved in rigorous meetings with the product owner and DWH Lead to prepare a roadmap for implementing the test plan on a sprint basis as part of the agile model.
• Reviewed test cases, validation steps and test scripts prepared by the testing engineer with the product owner.
• Attend sprint planning meetings to determine the acceptable stories based on the resource availability.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Queried databases using SQL queries in TOAD to validate the data loaded into target tables.
• Worked with the IT Help Desk in preparing the testing environment such as virtual machine allocation, browser installations, internal and vendor user access etc.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Interacted with the configuration management team for Firewall port allocation, DNS changes, middleware, APACHE layer creation for the test URL in all QA environments.
• Co-ordinated with the DBAs' to allocate user access with respective privileges for performing the database testing.
• Create QC tickets and defects for the respective testing stories in QC.
• Worked with developers on unit test coverage using SOAP UI.
• Also involved with info security and penetration testing team in taking measures to prevent hacking using SQL injection etc.
• Overseeing the creation of automation UI test cases using selenium and pass them on to the regression team.

Environment: Oracle 11i, Datastage Director 8.1, Flat Files, SOAP UI 5.1, TOAD 11.0, Fusion Middleware, Control M, HP Quality Center, UNIX, Test Case, Test Script, Microstrategy, Contact Center Desktop, Selenium

Confidential, NJ

Data Analyst/ETL Test Lead - IBM DB2, SQL Server

Responsibilities:

• Analyzed the mapping documents for the migration from CWS in SQL Server to STREAM in IBM DB2.
• Created the data dictionary based on the mapping documents for all the daily and monthly tables involved.
• Prepared system Test plan; defined the test criteria, test schedules, and base lined the Test Plan with the help of project meetings & walkthroughs, both for the migration as well as for the data work flow from GUI to STREAM database and eventually to DWH.
• Reviewed Test cases, Scenarios and modifications done to the test cases against the internal reviews and upgrades in the build.
• Queried databases using SQL queries in WIN SQL to validate the data in SQL Server and DB2 databases based on the mapping documents created.
• Used Microsoft Excel, Word, Visio to document the test status reports and the Test Data.
• Interacted with business users to understand the bugs in data loads and report back to the developers.
• Coordinated with Functional team on the application clarifications w.r.t business functionality implémentations.
• Attended weekly conference call & review meetings with weekly reports.
• Prepared Regression Scenarios, Load Test scenarios and involved in the process of automating and executing using QTP
• Informed and get the DBAs’ involved in creating the new tables or adding additional columns to the existing ones to cater the data loads during migration.
• Had good coordination with the team in other activities such as motivation, weekly meetings with agenda, trainings, responsibilities, Quality process & problem solving.

Environment: Microsoft SQL Server 2008, IBM DB2, Pentaho Kettle 4.2.1, Flat Files, Mapping Document, WIN SQL Professional 9.0, HP Quality Center, Bugzilla 3.0, Microsoft Office Excel 2007

Confidential, DE

Datawarehouse/ETL Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes
• Validated that the design specifications meet the requirements and data flow.
• Written test cases developed the validation steps and reviewed them with testing team manager.
• Reviewed test cases, validation steps and test scripts with business users.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Communicated with Oracle DBAs to backup the data and discuss the query performance.
• Written complex Oracle SQL queries and executed them to validate incremental ETL Loads
• Used Synonyms and DB Links to validate the data from different schemas and databases.
• Experienced with data models Start Schema and Snow-Flake Schema
• Analyzed Data Marts and tested several Dimension and Fact tables.
• Interacted with Users to understand the bugs in Business Reports generated from Microstrategy

Environment: Oracle 10g, Datastage Director 8.1, Flat Files, Mapping Document, TOAD for Data Analysts 10.2, Oracle Fusion Middleware, Control M, HP Quality Center, Unix, Test Case, Test Script, Microstrategy, Contact Center Desktop.

Confidential, CT

Senior Test Analyst - Oracle Database

Responsibilities:

• Prepared the Test Plan document for the Oracle Upgradation project.
• Attended meetings with architects, developers and business analysts to understand data model, data flow and enhancements made to create test cases relatively.
• Involved in rigorous meetings with the developers and the Oracle DBA to plan and implement the testing efforts.
• Wrote VB scripts to validate the Oracle installation which involves creation of folders, files, registry entries etc. on the WINDOWS servers.
• Reviewed test cases, validation steps and test scripts with business users.
• Participated in conference calls with Oracle Support to efficiently implement the process of Oracle Upgradation.
• Performed testing on front end DFWorks application servers (Websphere), Middleware WebLogic (Tuxedo) Request, Responses, Web Services (SOA) and Back-end data base.
• Performed the functionality and report validation testing of the DFWorks application both manually and using Test Partner.
• Performed database schema comparisons using TOAD and generates reports to inform the DBA.
• Maintained the test logs, test reports, test issues, defect tracking using Emtex software.

Environment: Oracle 11g and 9i, DFWorks 2.10.13, TOAD for Data Analysts 10.6, Test Partner, HP Quality Center, WebSphere, Middleware WebLogic, SOA Web Services, WINDOWS 2008 Server, 2003 Server and XP, Test Case, Test Script, VB script, Emtex

Confidential, CO

Senior Test Analyst

Responsibilities:

• Attended meetings with architects, developers and business analysts to understand data model, data flow and warehouse design.
• Reviewed the Mapping Document thoroughly and analyzed the mappings, mappings and design specifications.
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts
• Validated that the design specifications meet the requirements and data flow.
• Written test cases developed the validation steps and reviewed them with testing team manager.
• Participated in Oracle 9i to Oracle 10g upgrade.
• Reviewed test cases, validation steps and test scripts with business users.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Worked with Users to develop Test cases for user acceptance testing.
• Attended Daily Release Planning Meeting with Developers and QA Team to discuss Software changes and configuration management.
• Used Microsoft Excel to test small amount of data imported from different database management systems.
• Written complex Oracle SQL queries and executed them to validate the incremental ETL Loads.
• Tested and implemented the tuned BTEQ scripts of Teradata as part of the report generation
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE and Hyperion.

Environment: Oracle 10g and 9i, Borland StarTeam, Informatica Power Center 8.1 (Workflow Manager, Workflow Monitor), Teradata, Flat Files, Mapping Document, TOAD for Data Analysts 8.5, Mercury Test Director, HP Quality Center, Unix, Test Case, Test Script, OBIEE,Autosys

Confidential

PL/SQL Developer

Responsibilities:

• Written stored procedures and functions using PL/SQL.
• Involved in requirement analysis and planning.
• Created Cardinalities, Joins and Aliases for resolving Loops
• Designed complex reports using Business Objects functionalities; Queries, Functions,
• Cross Tab, Master Detail, Formula, Ranking, Breaks, etc. using MS Access & Reports 6i
• Created user defined objects.
• Used ERWIN, a database validation tool for systematically scanning thousands of lines of SQL/DDL code to identify design inconsistencies.
• Involved in datawarehousing implementation of the data received using Informatica.
• Tables design and creation for new clients, on call problems solving and providing Solutions.
• Involved in end user support and documentation.

Environment: : Oracle 8.x/9i, PL/SQL, MS Access, PL/SQL Developer, Forms 6i & Reports 6i, Informatica, AIX 5.0, WinNT, HP servers and Pentiums

Confidential

Database Tester

Responsibilities:

• Collected data from clients through front-end screens and uploaded the data into the DB
• Created tables, views and indexes.
• Worked with stored procedures, functions and packages.
• Retrieved data using Cursors.
• Responsible for the back end database related operations.
• Involved in Installation of oracle 8i/9i on windows 2000 Server/NT and supporting.
• Created Logins, Users, and permissions and managed Security issues of the Server and Databases.
• Designed and maintain the Network infrastructure for OLTP application.
• Verified the client financial statements, holding their policy and financial details using SQL.
• Provide day-to-day maintenance/support for application software.
• Preparing daily and weekly reports to the top management.

Environment: Oracle 7/8.x, SQL, XML, Windows 2000 server, MS-Excel, MS Office, TCP/IP

Confidential

Oracle Programmer/System Administrator

Responsibilities:

• Designed the structures of various migration related tables.
• Developed PL/SQL procedures and packages used for the application.

Environment: Oracle 7i, SQL, PL/SQL