Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Vinit Mehtalia

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, India
05-2023

Bachelor of Engineering - Electronic Engineering

Thakur College of Engineering And Technology
Mumbai, India
05-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
Vinit Mehtalia