PROFESSIONAL SUMMARY

• Over 8 years of overall IT exposure in Quality Assurance using Manual Automation testing with Data Warehousing which involves ETL, Reporting and Data modeling experience.
• Data testing experience with Data Mart applications, mainly transformation processes using Informatica SSIS, Cognos.
• 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 Center.
• Experienced in testing BI reports generated using BI tool like Cognos.
• Experienced in working in Agile Scrum, Waterfall and SDLC methodology environments.
• 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.
• Good Knowledge in Data Modeling.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL DEVELOPER

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules.
• Manage product and release backlogs that reflect the priorities of the business using Rally.
• Involved in daily scrum meetings for agile methodology project.
• 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.
• Performed report testing for both SSRS Reports and BI Reports via Cognos.
• Maintained all the documentation in Share point.
• Involved in frond end testing of TOS for policies and NOTUS for claims.
• 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: Agile Test Methodology, Cognos BI, SQL Server, Rally Software

Confidential

ETL Tester

Responsibilities:

• Developed the detail ETL Test Plan, Test Cases and execution of test cases.
• Tested Cognos reports for Report layout, Attributes/Metrics, positions, Totals Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Writing complex SQL queries for data validation for verifying the business Rules
• 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.
• Used SSIS for extraction, loading and transformation ETL of data in the data warehouse.
• Designing and creating new reports, SQL reports in Cognos.
• Validated the data on Front end applications to reflect the data on the back end using SQL queries
• Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.
• Creation and execution of manual test cases in Quality Center
• Tested various mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator Update Strategy.
• Worked in AGILE Methodology.
• Developed Oracle Structured Query Language SQL test scripts from test procedures and executed them Used SQL queries to retrieve data from tables and to perform back end testing thru SQL server.
• Written test cases and executed them.

Environment: HP Quality Center 10, SSIS,COGNOS, SQL

Confidential

Data warehouse QA Tester

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Tested the extracted data from sources like Excel file, flat files, etc.
• Created and implemented Cognos reports by creating projects, schema objects, attributes, metrics, filters and templates.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures for Functional and Regression Testing
• Worked in an Agile methodology and attended Scrum meetings.
• Tested all the reports by running queries against data warehouse. Also compared those queries with the Cognos SQL engine generated queries.
• Used standard testing techniques to test the data validity before deploying the Business Objects Reports to Users.
• Tested several SSIS ETL mappings for loading purpose and checking the log files
• Expertise in MYSQL Database.
• Used SQL functions, clauses, wildcards etc for extensive testing of the warehouse
• Tested slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Used SQL Queries to validate the data on daily basis
• Running SQL Query for counting the no of rows from the tables
• Monitoring the ETL jobs and coordinating the Bug fixes.
• Participated in the review and maintenance of data security standards to protect information assets.
• Tracked the defects to closure.
• Involved in meetings with the Project Manager and provided updates of the testing team.

Environment: SSIS, Oracle 10g/9i, Cognos, MYSQL, Windows

Confidential

Sr. ETL DEVELOPER

Responsibilities:

• Involved in analyzing Business Requirement Documents.
• Analyzed the Test plan documentation.
• Developed Test Cases to cover overall quality assurance testing.
• Written test cases and executed them manually.
• Tested the business functionality, navigation and validation of the application.
• Validated all the user requirements specified for UAT
• User Acceptance Testing should ensure that the application performs at an acceptable level for the Customer.
• Bugs were identified and reported to the development team using Bugzilla
• Participated in the meetings to walk through the defect reports periodically.
• Responsible for Weekly Status reports showing the progress of the testing effort.
• Regular meetings and updates are made to the Management team of the ongoing QA process.
• Enhanced and modified the scripts according to the test scenarios cases.
• Reported and tracked defects using Bugzilla and discussing about the defects in the weekly status meetings.
• Worked with developers to resolve and fix the defects.
• Interacted with users by conducting User Acceptance Test to ensure that the total functionality of the application was met by complying with all the business requirements.
• Interacted with Development, System Admin, Team manager, Team Members to resolve the issues expediently.

Environment: Windows, SQL, Manual Testing Bugzilla