AJAT MOHANTY
Oracle Consultant
Hyderabad
Summary
Experienced with strategic consulting, delivering comprehensive business solutions that align with client objectives which includes various implementations, Rollouts, Upgrades and Production Support covering entire supply chain domain. Utilizes blend of analytical expertise and interpersonal skills to drive project success and operational improvements. Track record of fostering team collaboration and achieving impactful results through innovative problem-solving.
Overview
20
20
years of professional experience
Work History
Sr. Principal Consultant
Dell Technologies
08.2015 - Current
- Managed team comprising six experienced OTM consultants
- Requirement Gathering, Business Meetings and Sizing Estimates
- Onboarding processes for various OTM business objects
- OTM Upgrades 6.3.7, 6.4.3 & 6.5.3
- Created efficient shipping networks for Dell's European & Canada logistics
- EDI Manifestation (EDI 856/211/204/215/214)
- Solutioning online Customer Returns & Exchange
- FTL Shipment Consolidations & Tendering solutions
- Collaborated with Oracle on multiple service requests
- Engaged in workshops influencing various logistics programs
- Developed strategic test plans for SIT, UAT, and VIT
- Resolved production issues and implemented improvements
- Monitoring OTM deployment activities for Quarterly Block Release
- Collaborated with cross-functional teams to define accurate requirements and scope
Principal Consultant
Inspirage
10.2011 - 08.2015
- Clients: NOV, Houston TX, Sunrider, Torrance CA
- Module: Oracle ASCP, Demantra, GOP
- Implemented robust IHUB solution to design inbound interface for ASCP
- Created outbound interface for disseminating ASCP recommendations to JDE
- Used Planning/Release Hook for stamping Planned Orders
- Developed Shortage Pegging Report, comprehensive health check queries
- Involved in collection issue fix and testing
- Custom solution to reduce high PAB & regenerate Pegging Tree
- Design custom program for collection of Sales History, Item Hierarchy, Location hierarchy, Unit Price etc
- Assist the automation of the entire planning process starting from importing data from JDE, generation of forecast, collaboration and publishing the consensus forecast to ASCP
- Configured Worksheets to enter forecast overrides, review forecast accuracies
- Setting up workflows to monitor and control the forecast approval process within various stakeholders
- Developed Integration interfaces to load user forecast and publish final forecast to ASCP
- Deployed standard feature of rolling data using multiple profile to store historical snapshots of the Baseline, User Updated and Final Forecast
Principal Consultant
CSC
10.2004 - 10.2011
- Clients: Euronext, Amsterdam NL, Celgene Summit NJ, Belron, Surrey UK
- Module: AP, PO, OM, INV, Pricing, iProc, iExpense
- Setting up i-Expense, Payables, SOCGEN Payments QATAR, Mileage schedules policy for IP France and Holding, Month end inventory period closing
- Interfaces - AP Invoice, T&L, Supplier , GLCC, PO
- Report Development - PO Report, Packing Slip, Return Authorization, FR Quarterly Statutory Report
- Workflow customization - PO/REQ Account Generator, COGS account generator & Expense, PO Approval(Faxing)
- Custom Solution for Internal Return Process, Remedy Application integration, Belron Pick Release process with enhanced shipping calendar
Education
Master of Science - Computer Science
CET, OUAT
Bhubaneswar, Orissa 04.2001 - 01.1997
Skills
Oracle Suite: OTM, ASCP, Demantra, GOP, OPM, PO, INV, OM, AP, i-Proc and i-Expense
Programming Skills: SQL, PL/SQL, forms, reports, Interfaces, conversions, APIs, Workflow, Oracle Alerts, Self Service Personalization, Form Personalization, Oracle Extensions, XML/BI Publisher, OBIEE
Certification: Oracle Payables
Trainings: Oracle University - Demantra Boot Camp, OTM, OBIEE, BPEL & SOA
Timeline
Sr. Principal Consultant
Dell Technologies
08.2015 - Current
Principal Consultant
Inspirage
10.2011 - 08.2015
Principal Consultant
CSC
10.2004 - 10.2011
Master of Science - Computer Science
CET, OUAT
04.2001 - 01.1997
Similar Profiles
Reventh Raj YataReventh Raj Yata
SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)
Taarun RajBhalanTaarun RajBhalan
Principal Software Engineer – Performance Engg at Dell Technologies Inc, Dell International ServicesPrincipal Software Engineer – Performance Engg at Dell Technologies Inc, Dell International Services
M.Banu PrakashM.Banu Prakash
Senior Analyst, Sales at Dell International Services (Dell Technologies)Senior Analyst, Sales at Dell International Services (Dell Technologies)
Reginald WilkinsonReginald Wilkinson
Quality Engineer at DELL TECHNOLOGIES / DELL EMCQuality Engineer at DELL TECHNOLOGIES / DELL EMC
V V V SATYA NAVEENV V V SATYA NAVEEN
SAP Basis Consultant at Tata Consultancy ServicesSAP Basis Consultant at Tata Consultancy Services