Summary
Overview
Work history
Education
Skills
Additional Information
Languages
Timeline
Hi, I’m

Jaimik Bhatt

Dubai,UAE
Jaimik Bhatt

Summary

  • Oracle Cloud ERP Analyst with diversified experience in NTT DATA GDS Limited. Over 1.5 years of Oracle Integration Cloud expertise, coupled with 2 years in Oracle Agile PLM and 6 months in Oracle Hyperion.
  • Proficient in OIC/ICS-based cloud integration solutions and Oracle Commerce Cloud, consistently delivering high-quality results.
  • Skilled in SQL programming, specialising in seamless application integration using Oracle Integration Cloud, encompassing connection establishment, data conversion, and intricate mapping for on-premise EBS and Oracle SCM Cloud.
  • Accomplished in Oracle Financials and SCM module development, customisation, and implementation.
  • Demonstrates hands-on project experience in Java8, JavaScript, and Python3, contributing innovative solutions to software integration, compliance, standardisation, and optimisation challenges.
  • Collaborative team player with exceptional communication skills, fostering seamless interactions and driving cohesive project outcomes.

Overview

4
years of professional experience
4
years of post-secondary education

Work history

NTT DATA
Hyderabad, India

ERP Senior Analyst
02.2021 - Current

Job overview

Facility: NTT DATA – Medifast Inc.


Duration : Sept 2022 – Aug 2023


Position: ERP Consultant (OIC Developer)


Primary Responsibilities:


  • Developed, unit tested and optimised over 40 integrations in Oracle Integration Cloud thereby integrating Oracle Fusion and Korber WMS systems.
  • Developed integrations for critical processes such as Item Master, Receipt Request, Kit Transactions, Inventory Snapshot, and Audit and Balance Integrations.
  • Successfully upgraded and optimised integrations, enhancing the efficiency of Shipment Confirmation, Receipt Confirmation, and Inventory Transactions.
  • Created diverse integrations, including Outbound, Inbound, Error Handling mechanisms, and Email Notifications, streamlining business processes.
  • Led end-to-end integration processes, encompassing planning, development, testing, and maintenance.
  • Maintained proactive communication with clients, promptly addressing concerns and ensuring client satisfaction.
  • Implemented robust monitoring systems, leading to swift detection and resolution of bugs within 1-2 working days.
  • Innovated by developing custom JavaScript solutions, enabling the implementation of functionalities beyond standard Oracle Integration Cloud capabilities.
  • Engineered tailored BIP reports on Oracle Fusion, catering to the specific reporting needs of clients.
  • Maintained comprehensive documentation of all integrations, ensuring accuracy and accessibility.
  • Provided dedicated hyper-care support post go-live, addressing any operational concerns and ensuring a seamless transition.



Facility: NTT DATA – Integra Life Sciences


Duration: Oct 2020 – Oct 2022


Position: ERP Analyst (Agile PLM Consultant)


Primary Responsibilities:


  • Spearheaded client system administration and played a pivotal role in providing offshore Oracle Agile PLM support.
  • Delivered exceptional business consulting solutions by applying techno-functional expertise to address complex challenges.
  • Developed, tested, and delivered accurate data and reports, aligning with system functionality and industry best practices.
  • Created software tools for internal Oracle tool development, ensuring the enhancement of company resources.
  • Managed code repositories and streamlined ticket workflows using the ServiceNow platform.
  • Introduced innovative Java PX scripting automation, significantly reducing user time spent on role allocation tasks.
  • Engineered a comprehensive automation solution using Java PX scripting, successfully eliminating manual effort in report compilation.
  • Collaborated with cross-functional teams to ensure the seamless implementation of automation solutions and process improvements.




APPIT Software Solutions
Hyderabad, India

Associate Consultant to NTT Data
09.2019 - 01.2021

Job overview

Facility: NTT DATA - Sunpower Corp.


Duration : April 2020 – Sept 2020


Position: ERP Analyst (OIC Developer)


Primary Responsibilities:


  • Led Oracle Fusion PPM Cloud implementation, overseeing the successful integration of Project Costing & Project Billing modules.
  • Managed the configuration and modification of configuration files from Oracle Cloud's Financials and SCM modules.
  • Identified and harnessed REST APIs from Oracle SCM Cloud and Financials Cloud for diverse transactions, including Inventory Balances, Lots, Work Orders, and Invoices.
  • Built integrations within Oracle Integration Cloud (OIC) utilising JSON payloads, ensuring efficient data exchange and request-response workflows.
  • Developed intricate data mappings in OIC, enabling seamless data flow between Oracle SCM Cloud and on-premise EBS systems.
  • Established and configured integration connections and lookups to facilitate smooth data transitions and customised mappings.
  • Collaborated with cross-functional teams to enhance and modify Oracle PL/SQL APIs, optimising data transaction processes.
  • Played a crucial role in documenting application features to meet client compliance requirements, facilitating successful engagements with client compliance teams.



Facility: NTT DATA – MyLan Inc.


Duration: Sept 2019 – March 2020


Position: ERP Analyst (Jython Developer)


Primary Responsibilities:


  • Led the migration and upgrade of essential Oracle Hyperion applications, encompassing Planning, Essbase/Essbase Studio, HFM, FDM, and FDMEE.
  • Developed sophisticated Jython scripts, merging Java and Python, to optimize import processes, custom processes, and event processes, significantly enhancing efficiency and performance.
  • Conducted comprehensive unit tests and end-to-end tests for FDM locations, identifying and addressing potential issues proactively.
  • Provided valuable assistance in location mapping and validation testing, ensuring accurate data flow and system functionality.
  • Achieved a substantial reduction in system execution time, optimizing it from 40 minutes to under 8 minutes, leading to enhanced productivity and user satisfaction.

Education

Sardar Patel Institute of Technology, University of Mumbai
Mumbai, India

Bachelor of Engineering from Information Technology
08.2012 - 05.2016

University overview

  • Publication : Published the paper, "Improving the Diffie-Hellman Key Exchange Algorithm by Proposing the Multiplicative Key Exchange Algorithm" in the International Journal of Computer Applications (IJCA)

Skills

  • Additional skills include:
  • ERP Applications : Oracle Cloud Fusion
  • MiddleWare Automation : Oracle Integration Cloud (OIC), Make
  • Languages : Oracle SQL, Java 8, Python 3, JavaScript, XSL
  • Data Visualisation : Power BI, Knime
  • Payload Migration : JSON, XML
  • Data Migration : BIP Reports
  • Testing : Postman
  • Documentation : Apiary

Additional Information

  • ERP Senior Analyst Location :
  • NTT DATA, Inc.

Languages

English
Fluent
Hindi
Upper intermediate
Gujarati
Upper intermediate
Spanish
Beginner

Timeline

ERP Senior Analyst

NTT DATA
02.2021 - Current

Associate Consultant to NTT Data

APPIT Software Solutions
09.2019 - 01.2021

Sardar Patel Institute of Technology, University of Mumbai

Bachelor of Engineering from Information Technology
08.2012 - 05.2016
Jaimik Bhatt