OBJECTIVE
Seeking ETL Technical Lead position and promoting my skills in Data warehousing concepts and tools and additionally bringing expertise in collaborating with project team members, utilizing proficiency in coordinating activities of a team and facilitating project-team related meetings to execute assigned work.
PRIMARY SKILLS
ETL: Teradata 16.x, Informatica Power Center, Redwood Cronacle(Job Scheduler), Autosys (Job Scheduler),IDR(Data Replication Tool), Oracle, PL/SQL
DBMS: Teradata, Oracle, Query Optimization
Management Skills: Scrum Management, Agile Methodology, Leadership, Strong Communication Skills, Team Management, Ability to handle client and stakeholders SECONDARY SKILLS
Reporting: Basics of Spotfire 7.14, OBIEE, Boxi, Domo Others: SVN, Wincp, Unix, Putty,ServiceNow, Snowflake Cloud CERTIFICATIONS & LEARNINGS
Teradata Vantage Associate 2.3 Certified
SQL Essential Training.
SQL For Data Analysis
Scrum Master – Basics & Advanced Certification
Agile Project Management Certification.
Advanced Agile Team’s Mindset Training.
Teradata Advanced SQL Training
Snowflake Fundamentals & Hands On Training.
Introduction To Data Science
Teradata Vantage Essential Training 2021
RISHI DAVE
Email ID: adxqvq@r.postjobfree.com
Ph Primary: +1-945-***-****
Ph Secondary: +91-800*******
Oct 2022 – May 2023
ETL LEAD & SR ASSOCIATE PROJECT’S, COGNIZANT CLIENT – Chubb Insurance
Lead the technical planning and requirements gathering phases including estimate, develop, test, manage project.
Strong SQL skills.
Serve as a technical lead and mentor. Provide technical support or leadership in development and continual improvement of service.
Tune and optimize ETL processes and framework.
Develop and maintain effective working relationship with team members.
Breadth of experience with ETL tools including but not limited to Informatica, Oracle, Teradata.
By analyzing customer data, we used to identify patterns in behavior and preferences that allows us to group customers into segments.
Analyzes various data sources, such as customer feedback, claims history, and online interactions, to identify patterns and behaviors that indicate a higher risk of churn. Sept 2021 – Sept
2022
ETL LEAD & SENIOR DATA ENGINEER, TERADATA PVT LTD CLIENT: SC Johnson
Develop solution in highly demanding environment and provide hands on guidance to other team members.
Implement an Informatica based ETL solution fulfilling stringent performance requirements.
Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
Track & identify sales & orders per region/ per product/ orders in pipeline/future predictions etc
Identify sales & orders metrics, revenue to show the increase/decrease over a specific period of time for overall products.
Apr 2020 – Aug 2021
ETL LEAD & TECHNICAL PROJECT MANAGER, TATA CONSULTANCY SERVICES CLIENT: GE Healthcare
Provide technical leadership and manage all aspects of SDLC process- requirement, analysis, design, development, testing, and support/maintenance.
Perform code reviews and support code promotion process through development, QA, production.
Apply different optimization techniques to enhance performance at various levels which includes SQL tuning, transformation, optimization etc mainly using tool like teradata, Informatica, Snowflake cloud.
Brainstorming, planning the project and collaborating with department heads to achieve a common goal.
Hold regular technical team meetings to determine progress and address any questions or challenges regarding projects.
Processing/Managing all the healthcare data like Imaging, Ultrasound, Healthcare IT, Contrast media etc, and analyzing all its Sales/Orders/backlog dataset. May 2016 – Jan 2017
SENIOR ETL DEVELOPER, TATA CONSULTANCY SERVICES CLIENT: GE HEALTHCARE
Provide process improvement analysis using process modeling and simulation techniques to understand the impact of process changes.
Attend technology design meetings and recommend security and data improvements and will be empowered to work on those prioritized changes
Provide inputs to develop project plans
Self- motivated with critical attention to details, deadlines and reporting.
Help develop test cases and plans to complete the unit testing and support system testing FEB 2015–APRIL 2016
ETL Developer, TATA CONSULTANCY SERVICES CLIENT: GE HEALTHCARE
Understand the data requirements and transform the data in the required format as per the business rules using tools like Teradata, Informatica, Cronacle
Work with IT team to follow full development life cycle with other technical operations.
Work with other team members in establishing and sharing design and development techniques of the ETL processes.
JULY 2018
MASTER IN COMPUTER APPLICATIONS, SASTRA UNIVERSITY
● First class with CGPA of 6.8
MARCH 2014
BACHELOR IN COMPUTER APPLICATIONS, SAURASHTRA UNIVERSITY
● Distinction with Percentage of 74
APRIL 2011
HSC, CENTRAL BOARD OF SECONDARY EDUCATION, 74.6%
MAY 2009
SSC,CENTRAL BOARD OF SECONDARY EDUCATION,70.02%
EDUCATION
ACHIEVEMENTS & CERTIFICATIONS
● Outstanding Performance Award for Handling Critical Project - TATA Consultancy Services FEB 2018
● Six Sigma Green Belt - TATA Consultancy Services June 2016
● Customer appreciation for handling critical quarter closes consistently for 11 straight quarters.
● Udemy Certification: Snowflake Cloud, Agile Scrum Training, Python Bootcamp.