SUMMARY

• Over 7 pulse years of experience in IT services, Auto and Financial/Banking.
• Currently working as a Sr. ETL Tester using Ab Initio, UNIX and Teradata.
• 4+ years in Quality Assurance including Integration, Functional, Regression, System Testing, UAT Testing, Black Box and GUI testing.
• Extensive experience in ETL and Data Warehouse testing and Data Analysis.
• Experience in EME, Source, Target Databases and testing Strategies for Extraction, Transformation & Loading (ETL) mechanism using Ab Initio.
• Strong knowledge of SQL.
• Experience in preparing Test Strategy, Business Assurance Strategy (BAS), Requirement Traceability Matrix (RTM), Test Plan, detailed Test Cases, Test Scripts and Test Scenarios.
• Experience in using HP ALM and HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in Waterfall and Agile methodologies.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Well-developed interpersonal skills, excellent analytical skills coupled with outstanding verbal and written communication skills.
• Proactive & solution oriented approach.
• Expert at managing multiple projects simultaneously.
• Effective at balancing technical knowledge with managerial acumen.
• Highly organized and adept at providing direction and operational strategies critical to organizational success with proven ability to thrive in busy environment with positive results.

TECHNICAL SKILLS

Databases: Oracle, SQL, DB2, TeradataTechnology Ab-Intio Testing, ETL, Data Warehousing

RDBMS: Teradata, DBVisualizer, SQL Developer, SQL Server Management Studio

GUI/Tools: MS Word, Excel, Visio; Version One;

Platforms: Unix, Windows XP

Defect Tracking: Application Lifecycle Management (ALM), Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Tester

Responsibilities:

• Liaise with the Business and the project team to understand the scope and the objective of project.
• Analyze project requirements and recommend Strategies and Approaches to ensure quality
• Analyze ETL, reporting requirements for data movement from files/ Operational databases to data warehouses and identifying issues with the data movement.
• Perform thorough requirement reviews to identify and recommend effective use cases for early defect capture and reducing cost to market
• Analyze data stored in the data warehouse to validate the data integrity and flow into the respective entities using complex SQL scripts.
• Analyze different source systems and interfaces that interact with the Data Distribution Environment.
• Execute scripts in UNIX and validate the data to make sure data has been transformed as expected.
• Test the source to target mapping by writing SQLs and using UNIX commands.
• Perform defect analysis to ascertain any non-compliance with the set procedures/ guidelines; troubleshooting and resolving various production issues.
• Compare the output data of optimized code with the old version to make sure the functionality and the Business rules have not been affected by the code changes.
• Participate in daily project Scrum sessions with team to update and track project milestones
• Conducted a series of UNIX based validations on high volume data
• Participated in multiple rounds of integration testing using a subset of production data to simulate variety of test scenarios & ensure that all functionalities adhere to the business needs.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Unix (korn shell), Teradata, SQL, FTP, SFTP, ALM, HP Quality Center 9.2, Windows XP

Confidential

ETL Test Manager

Responsibilities:

• Suggest use cases to assist better understanding and provide problem solving approaches.
• Align business objectives with employees and management in designated business units
• Providing Level of Effort (LOE) estimates for upcoming projects.
• Ensure optimum allocation of resources based on skills and availability while avoiding manpower shortage or surplus.
• Liaise with the Department heads & Zonal managers and establish proactive communication with Business in addressing performance bottlenecks.
• Create and present monthly reports to stakeholders employing complex Excel and PowerPoint skills.
• Participated in multiple rounds of integration testing using a subset of production data to simulate variety of test scenarios & ensure that all functionalities adhere to the business needs.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Unix (korn shell), Teradata, SQL, HP Quality Center 9.2, Windows XP

Confidential

Software Engineer in Test

Responsibilities:

• Study the business intent for developing wealth management system and Syndicated Loans system modules for Finacle, a core Banking software package from Infosys.
• Play a vital role throughout the project SDLC stages, starting from preparing the High level Design document to the Go-Live & post production phase.
• Strategize project scoping and specifications documents, to clearly communicate the project roadmap.
• Conduct daily reviews with project team and fortnightly reviews with project stake holders on the progress of the module development and issues, thus ensuring early defect capture.
• Performed thorough unit testing on the modules being delivered.
• Briefly worked with the QS team and was engaged in front end functional testing.