Vinit Mehtalia
KANDIVALI (W)
Summary
Vinit is a Technical Consultant with an overall 7+ years of experience in OFSAA and ETL technologies with passion for continuous learning. He has a deep understanding in all phases of analysis, design, development, implementation, testing and support for data warehousing applications using various ETL tools. He is a quick learner and a hard worker always ready to take up challenges
Overview
7
7
years of professional experience
1
1
Certification
Work History
SENIOR CONSULTANT - OFSAA
Deloitte Touche Tohmatsu India LLP
11.2022 - Current
- Creating FTP product hierarchy by doing current system analysis and ensuring lowest level granular data is present.
- Creating PFT hierarchy for Cost Centers and Profit Centers and creating custom dimensions.
- Analyzing FTP BRD and setting up transfer pricing curves in OFSAA and creating FTP rules, Adjustment rules and FTP process.
- Studying DL-specs of new version and giving data requirement to bank it team for seamless implementation.
- Creating DQ checks at the staging layer and configuring T2Ts for transferring data into FSI layer.
- Develop multiple reports keeping business requirements in mind to give appropriate business solutions to users.
- Developed custom solutions based upon clients' strict requirements.
- Prioritized projects and project tasks depending upon key milestones and deadline dates.
- Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
Associate Consultant
KPMG India LLP
09.2021 - 11.2022
- Involved in gathering and analyzing business requirements and detail technical design to implement the same in Sas .
- Created Libraries in Sas Management Console to establish connectivity between SAS and Oracle Database.
- Preparing technical specifications based on the functional specifications and provide estimates for the same.
- Designing file structures, tables and mappings/jobs in Sas Data Integration Studio.
- Created workflows for corresponding Jobs using Sas Scheduler Manager through Sas Management Console.
- Guided project during User Acceptance Testing i.e. taking feedbacks from client and implementation of bug fixes.
Application Development Analyst
Accenture Solutions Pvt.Ltd
12.2017 - 09.2021
- Involved in gathering and analyzing business requirements and preparing detail technical design to implement the same in ODI.
- Rebuilding mappings, variables, packages and procedure on ODI with exact functionality as of OWB.
- Build several Customized Knowledge modules to meet the business logic and also improved the performance of the current flow.
- Experience in performing analysis for production issues and capable of providing detailed root cause and solution-oriented approach for the same.
- Guided project during UAT phase by taking feedback from clients and implementation of the bug fixes.
- Performed admin related activities in ODI i.e. creating user, configuring .
- Created file structures, tables, mapping, several ODI scenarios, packages and load plans and performed unit testing, system testing and user acceptance testing on it.
- Migrating Oracle Warehouse Builder objects to ODI Work Repository.
Education
MBA - Information Technology And Project Management
Bharati Vidyapeeth (Deemed To Be University)
Pune, India05-2023
Bachelor of Engineering - Electronic Engineering
Thakur College of Engineering And Technology
Mumbai, India05-2017
Skills
- Consulting
- Strong leadership skills
- Oracle Data Integrator
- Sas Data Integration Studio
- PL/SQL
- SQL
- Oracle Warehouse Builder
- Informatica
- OFSAA(FTP/PFT/LLFP)
- OBIEE
Certification
- Oracle Data Integrator 12c Certified Implementation Specialist (1Z0-448)
- Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
Languages
English
Advanced (C1)
Hindi
Intermediate (B1)
Marathi
Elementary (A2)
Gujarati
Bilingual or Proficient (C2)
Timeline
SENIOR CONSULTANT - OFSAA
Deloitte Touche Tohmatsu India LLP
11.2022 - Current
Associate Consultant
KPMG India LLP
09.2021 - 11.2022
Application Development Analyst
Accenture Solutions Pvt.Ltd
12.2017 - 09.2021
MBA - Information Technology And Project Management
Bharati Vidyapeeth (Deemed To Be University)
Bachelor of Engineering - Electronic Engineering
Thakur College of Engineering And Technology
Similar Profiles
Suneel MishraSuneel Mishra
Assistant Manager at Deloitte Touche Tohmatsu India LLP, DeloitteAssistant Manager at Deloitte Touche Tohmatsu India LLP, Deloitte
Abhinav SharmaAbhinav Sharma
Senior Consultant at Deloitte Touche Tohmatsu India LLPSenior Consultant at Deloitte Touche Tohmatsu India LLP
Veenu JoshiVeenu Joshi
Consultant -ET&P Finance and Performance at Deloitte Touche Tohmatsu India LLPConsultant -ET&P Finance and Performance at Deloitte Touche Tohmatsu India LLP