SUMMARY:

• Over 10 years of experience in Software Industry having expertise in Software Development, Manual Testing and Test Management.
• Deep proficiency in SDLC, STLC, QA process and concepts.
• Hands on experience in ETL tools like Pentaho, Informatica and Datastage.
• Excellent knowledge on Databases like Teradata, Oracle and MySQL and Data warehouse concepts.
• As a Developer, has an expert knowledge in Analyzing Requirements, creating Source to target mappings and design documents for various applications.
• Knowledge on all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) for building a data warehouse.
• Hands on experience in end - to-end of Data warehousing ETL routines, which includes developing ETL mappings/transformations, UNIX scripts, and data quality process.
• Experience in loading data from various data sources and legacy systems into Teradata warehouse using BTEQ, MULTI LOAD and FASTLOAD.
• Experience with scheduling tools like Control-M and Autosys .
• Extracted Data from multiple operational sources and loaded staging area, Data Warehouse and data marts using SCD (Type1/Type2/Type3) loads.
• Experience in UNIX Operating System and Shell scripting.
• Proficient in troubleshooting database issues and experience in using performance monitor/profiler to solve dead locks/ long running queries.
• As a Tester, has an expert knowledge in Analyzing Requirements, creating Test Scenarios, generating Test cases, Defect Tracking and Test Reporting for various applications.
• Experience in preparing test reports from Quality Center and daily test status reports.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Extensive experience in developing SQL scripts to validate the database tables and reports.
• Actively involved in User Acceptance Testing (UAT).
• Experience in Business Intelligence testing using Microstrategy.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent communication skills and experience working with business user’s community.

TECHNICAL SKILLS:

Tools: Test Management Tools: HP Quality Center 9.2, JIRA

ETL Tools: Penatho, Informatica, Datastage

Reporting Tools: Microstrategy

Utility Tools: Teradata SQL Assistant, MySQL Workbench, Rapid SQL

Version Control Tools: SVN, Github, Harvest

Scheduling Tools: ControlM 6.4.01, Autosys

Databases: Teradata, MySQL, Oracle

Operating System: UNIX, Windows XP, Windows 7

Project Methodologies: Waterfall, Agile

Languages: PL/SQL, Unix Shell

Packages: Microsoft Excel, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead/Manager

Responsibilities:

• Analyze and understand testing requirements from business requirement document and technical design document.
• Prepare test plan and work breakdown estimate.
• Co-ordinate meetings within the team to keep track of their work and review the test deliverable.
• Set up regular project status meetings and QA status meetings.
• Schedule and monitor the test cases execution.
• Prepare daily status reports with details of executed, passed, and failed test cases and defect status.
• Prepare the SIT summary document and UAT test Plan document.
• Co-ordinate with the business users for UAT testing and sign-off.
• Prepare test metrics for the projects.
• Schedule bi-weekly meetings with the application owners and project managers to update the test status.
• Effectively communicate testing activities and findings in oral and written formats to the client manager on a regular basis.

Tools: HP QC, Oracle, DB2, ICM, Requirement Analysis, Test Planning, Test Preparation, Test Execution, Defect reporting and Tracking

Confidential

ETL Lead

Responsibilities:

• Understanding business and functional requirements.
• Preparing mapping rule and Technical Design documents for ETL (Pentaho) process.
• Responsible for analyzing how the data is stored in MongoDB (unstructured database).
• Responsible for creating the kettle transformations and performing the unit testing.
• Assigning daily tasks to the offshore team.
• Co-ordinating with the offshore team to review their deliverables.
• Co-ordinate review meetings with the business owner
• Deployment of code in the test and production environments.
• Responsible for handling the production failures.
• Validating the Microstrategy reports to ensure that the data is accurate.
• Worked to set up Control-M jobs to schedule the jobs.

Tools: UNIX, Pentaho, RoboMongo, MySQL Workbench, SSIS, Microstrategy, Control-M

Confidential

ETL Lead

Responsibilities:

• Constant communication with the business team to understand the requirements.
• Creating the source to target mappings.
• Preparing design document.
• Responsible for providing the technical direction and guidance to the team members in understanding the NoSQL database.
• Creating ETL jobs in Pentaho.
• Schedule daily meetings with the team to keep track of their work and review the test deliverables.
• Schedule and monitor jobs in control-m.
• Construct test queries with multiple joins, temporary tables and subqueries to test the database tables and the report data.
• Co-ordinate review meetings with the business owner.
• Deployment of code in the test and production environments.
• Preparing the project hand-over documents to the support team.

Tools: MongoDB, JIRA, Pentaho, MySQL, Microstrategy

Confidential

Senior Developer

Responsibilities:

• Responsible for requirements gathering, planning and analysis.
• Involved in design and Data model.
• Preparing Source to target mappings.
• Creating High level Design documents for ETL process.
• Developed ETL processes to support the development and implementation of data warehouse projects using Datastage.
• Responsible for creating Fastload and Multiload scripts.
• Responsible for migrating the code from DEV to QA environment.
• Involved in scheduling the ETL jobs using control-m.
• Responsible for smooth transition between development and support team.
• Creating and providing knowledge transition sessions within the team to share the new ideas/techniques that have been implemented in the project.

Tools: UNIX, Datastage, Teradata, Microstrategy, Control-m

Confidential

Senior Developer

Responsibilities:

• Understanding business and functional requirements.
• Involved in design and Data model.
• Preparing Source to target mappings.
• Preparing High level Design documents for ETL process.
• Responsible for creating ETL scripts using Teradata BTEQ and Fast Load utilities.
• Assigning daily tasks to the offshore team.
• Co-ordinating with the offshore team to review their deliverables.
• Involved in testing the code developed by the offshore team.
• Co-ordinate review meetings with the business owner.
• Worked to set up control jobs to schedule the jobs.
• Worked on historic data loads.
• Responsible for deploying the code in production.
• Involved in preparing the transition documents.
• Conducted knowledge transfer sessions to the support team to turn over the project to support team.

Tools: UNIX, Teradata, Datastage, ControlM

Confidential

Developer

Responsibilities:

• Converting the scripts from Netezza to Teradata SQL.
• Changing the ETL logic in the Datastage jobs.
• Responsible for testing Teradata scripts.
• Execute the Test scripts to verify the data loaded in Teradata tables.
• Co-ordinate review meetings with offshore team members
• Responsible for creating the status report.
• Validating the competition data.
• Implementing performance improvement techniques.
• Preparing the Issue tracking document.

Tools: Unix, Windows 7, Teradata SQL Assistant, Datastage, Netezza

Confidential

Senior Tester/Tester

Responsibilities:

• Responsible for requirements gathering, planning and analysis.
• Created and designed test documents based on the specifications.
• Analyze and review Informatica (ETL) mappings to understand the technical implementation of business rules.
• Tested ETL processes using Informatica.
• Tested the Teradata BTEQs and Fastload scripts.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Extensive SQL querying on Staging and reporting tables.
• Ensured error logs and audit tables are generated and populated properly.
• Performed UAT and Regression Testing.
• Executing the test cases and creating the test reports in HP Quality Center.
• Involving in defect tracking and conducting the defect prevention meetings to reduce the number of defects.
• Contribute in the development of knowledge transfer documentation.

Tools: QC, Teradata, Informatica, Microstrategy, Requirement Analysis, Test Planning, Test Preparation, Test Execution, Defect reporting and Tracking