PROFESSIONAL SUMMARY

• Over 7+ years of overall IT exposure in Quality Assurance using Manual Testing & Data Warehousing which involves ETL and Data modeling experience.
• Data testing experience with Data Mart applications, mainly transformation processes using Informatica & Teradata.
• Extensively written test plans, test cases, scripts and prepared test data and followed STLC extensively for DWH testing practices.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Extensively worked with large Databases in Test environments.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Extensive work in ETL testing using SQL, UNIX
• Strong SQL query skills using an enterprise wide RDBMS (Oracle & MS SQL Server) and familiar with concepts of SQL queries ranging from DML & DDL.
• Strong expertise in Relational data base systems like Oracle, SQL Server and MYSQL
• Extensive experience in tracking bugs using Bug tracking tool Quality Centre.
• Experienced in testing BI reports generated using BI tool like Business Objects
• Experienced in working in Agile Scrum, Waterfall and SDLC methodology environments.
• Excellent experience of managingBIenvironment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis andReportingtools.
• Experience in testing/validating the Source, Stage and Target (End - to-End).
• Experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing & User Acceptance Testing.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Power Center 8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) Teradata, Repository, DataMart, FACT & Dimensions tables

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Business Objects XIR3/XIR2/6.x, Cognos, Micro Strategy

Databases: Oracle 11g/10g/9i/8.0, MYSQL, SQL Server

Programming: SQL, PL/SQL, Unix, C, Java, HTML, C/C++,.NET, Android, J2ME, Windows Mobile

Tools: SQL*Plus, Sabre, Dream weaver

Environment: UNIX, Windows XP/Vista

Testing Tools: HP Quality Center 10, QTP, Test Director, Rally

WORK EXPERIENCE

Confidential, Indianapolis, IN

Sr.ETL Tester

Responsibilities:

• Extensively used ETL to load data from Oracle database, SQL Server, Flat files, DB2 to the DB2 Data warehouse.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Documentation: Data migration document for various metadata tools/ procedures/ functions/ shell scripts.
• Interacted with clients during Integration Testing. Participates in all different test phase as per the project needs.
• Contributed to the development of the test plans and project testing approach.
• Provided inputs to the development of project and Release Test Plan documents.
• Understands and contributed to the process of test estimates and project schedules.
• Participated in test planning, test case design and test script walkthroughs with QA Leads.
• Understands testing to be accomplished and suggests changes for efficiencies within or between projects.
• Assisted in the preparation of test estimates and project schedules.
• Adheres to established standards and methodologies.
• Developed and sustained appropriate relationship with peers and other project team members.
• Good experience in verification and validation techniques, defect management, quantitative methods, risk management and measurement programs.
• Strong SQL skills. Working knowledge of UNIX. Strong leadership capabilities, good judgment and the ability to work effectively with a diverse workforce.
• Hands-on experience on a defect management tool. Excellent verbal and written communication skills.
• Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system and updating the defect tracking list for with UAT feed backs
• Developed SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Conducted Data modeling training sessions for different user groups and facilitated common data models between different applications, participated in requirement sessions to identify logical entities.

Environment:SQL Server 2008, SQL, PL/SQL, Teradata, QC 10.0, QTP 11.0, Windows - 7, Vista, XP, UNIX, Oracle 11g, SQL, PL/SQL, MS Word, Excel, PowerPoint, ALM, Outlook, Informatica, Data stage 7.5.

Confidential, Richmond, VA

Sr.ETL Tester/QA Analyst

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules.
• Maintained Rally for Task allocation and tracking the tasks to closure.
• Extensive use of Rally Software to organize user stories, tasks, defects and tests plan and track iterations (sprints) and releases.
• Used Rally for making the development organization faster, leaner and more agile and to get on the track with the User stories and to improve iteration planning practices.
• Involved in manual testing, preparation of Business Process Test Cases and Test Execution.
• Involved in the review of test cases and test scenarios of the Policy module.
• Maintained all the documentation in Share point.
• Preparation of test scenario’s based on mapping documents.
• Extensively use SQL queries for data validation and back end testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents.
• Work closely with the software engineers to ensure successful, high quality releases.

Environment: Business Objects, SQL Server, Guidewire Policy Center, TOS, Agile Test Methodology, SQL Server Report Services.

Confidential, Philadelphia, PA

ETL Tester

Responsibilities:

• Developed the detail ETL Test Plan, Test Cases and execution of test cases.
• Tested Business Objects reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Created complex SQL queries for querying data against different data bases for data verification process.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Tested the extracted data from flat files and oracle database, and tested the applied business logic on the transformations.
• Tested mappings/Reusable Objects/Transformation/mapplets by using Informatica Power Center 8.6.0/8.6.1.
• Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.

Environment: HP Quality Center 10, Informatica Power Center 9.1, Business Objects, SQL Server, UNIX

Confidential, Greene, NY

ETL Tester/QA Analyst

Responsibilities:

• Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Conducted Operation readiness testing, deployment testing, negative testing, count testing and sampling testing on Mapplets
• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed Count Validation, Structural validation, Complete data validation, Null validation, Negative testing, Duplicate testing
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.
• Ensured Error logs and audit tables are generated and populated properly.
• Updated and maintained existing test Matrix and test cases based on code changes and enhancements to assigned applications.

Environment: Informatica Power Center 8.1, Oracle 11g, SQL Server, Teradata, DB2, Business Objects, Rational Rose, MS Office, QC

Confidential

ETL Data Warehouse Tester

Responsibilities:

• Developed and Designed Test Cases based on the Business requirements.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively tested the reports generated in Cognos by writing SQL queries to validate the data on the report and compare with the TPW data.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Used SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Involved in preparing test data for UAT and participated in UAT signoff
• Prepared strategies for analyzing the data for ETL Team
• Created and executed SQL queries in ORACLE and MS SQL server

Environment: Informatica 8.1/ 7.1.4 (Power Center Designer, workflow manager, workflow monitor), MS SQL Server 2008,Oracle 10g, PL/SQL, QTP,SQL, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

Confidential

BI Test Analyst

Responsibilities

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Designed the screens and layout using Visual Basic 6.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Oracle, SQL, Test Director, SQL Server 2000, Visual Basic 6.0, Java and UNIX Shell scripting