OBJECTIVE:

A proactive and fast learning individual seeking a chance to work as a part of a dynamic team, where I could make a significant contribution while developing my skills yet further.

PROFESSIONAL SUMMARY:

• Total 9 + years of experience in IT, 8 years into ETL Testing
• Working as Test Lead, good Experience into investment banking and insurance domain
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Extensive ETL testing experience using Informatica 8.1/9.1 (Power Center/ Power Mart) (Designer, Workflow Manager and Workflow Monitor).
• Excellent Knowledge of Database Systems - Oracle 11g and Data ware house concepts
• Good command over unix commands
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Involved in complete Testing Life Cycle (Test Planning, Test Design, Execution and Publish Test Results)
• Skilled in giving training to the new team members in the Project and assigning tasks to them
• Excellent Knowledge in MS-Office (Word, Excel, PowerPoint), MS-Access, MS Visio.
• A very good team player with excellent Communication (Verbal and Technical), Presentation, reporting skills, problem-solving skills and great coordination skills.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.0/11.0 (ALM), JIRA, vsts

Databases: Oracle 9i/10g/11g, Teradata SQL Assistant, MS Access, SQl Server

Utility Tools: PL-SQL Developer, Squirrel, Putty, Tectia, SQL assistant, sqlplus

ETL Tools: Informatica 8.1/9.1

Reporting Tools: Cognos reports

Operation Systems: Windows XP/2000/2007, Linux and UNIX

Microsoft Office: Word, PPT, Excel and Visio

WORK EXPERIENCE:

Test Lead

Confidential

Responsibilities:

• Migration testing of various applications as legacy application getting merged into one new application writing source minus target queries and validating data record by record
• Tracking the bugs and test cases and tasks in vsts
• Identifying and analysing scenarios for testing

Confidential

Responsibilities:

• Creating test plan, test scenarios, RTM, test cases (both functional and ETL) and TCR
• Interaction with client for demo and walkthrough
• Interaction with developers for resolving issues and bugs
• Guiding & mentoring team members as team lead
• Giving daily status reports to client
• Writing complex sql queries for reports

Confidential

Responsibilities:

• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Performed UAT and Regression Testing.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting the issues to project team and management during test cycles.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute in the development of knowledge transfer documentation.
• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data
• Testing configuration changes based on ETL mappings

Confidential

Team Lead

Responsibilities:

• Created stage 0 and stage 1 test estimates and presented the effort required to the management
• Developed Test Plans, test scenarios and test cases for the project
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings and executed them
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.

Confidential

System Analyst

Platform: Teradata, Informatica 8.6

Responsibilities:

• Performed low level technical design documents and participated in build/review of bteq scripts,fastexport, multiload and fast load scripts, reviewed unit test plans and test cases
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Worked on optimizing and tuning the Teradata views and sql to improve the performance of batch and response time of data for users
• Responsible for collect stats on fact tables
• Performed tuning and optimization of complex SQL queries using Teradata explain
• Extensive SQL querying on Staging, Data-warehouse and Data-Marts.
• Created tables, views and macros in Teradata according requirement
• Performance tuning, bug fixing and error handling
• Ensured Error logs and audit tables are generated and populated properly aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

Confidential

Software Engineer

Platform: Informatica 8.6, Oracle 10g

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Extracted data from various sources like Oracle, flat files and SQL Server
• 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
• Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system, performance test and updating the defect tracking list for with UAT feed backs.

Confidential

Software Engineer

Platform: Oracle 10g

Responsibilities:

• Designing and executing test cases according the Functional specifications.
• Participated in the Test case review meetings.
• Performed Functionality Testing, involved in build installation, Sanity Testing, Smoke Testing.
• Interact with developers and discussed technical problems, Bugs Tracking and Generating Reports.
• Reporting the Regular status to the higher authorities in a timely manner.
• Verification of data entered by the users through application at back end.
• Worked closely with application development teams to ensure adherence to design specifications, proposed procedures, practices and standards.
• Designed, created and tested reports to meet business requirements.