Deepak Gauri
Phoenix,AZ
Summary
Currently working as a Team Lead at FedEx Logistics, leading a cross-functional team to streamline operations using SQL and Excel-based analytics. Recognized for exceptional communication skills, hands-on leadership, and ability to bridge technical and business teams. Experienced Oracle Techno-Functional Consultant with 5+ years of expertise in Oracle EBS (R12 & Cloud), specializing in SCM, Order to Cash, Procure to Pay, and HCM modules. Adept in PL/SQL, RICEW, BI reporting, and workflow development. Proven success integrating systems with Workday, ENOVIA, and ServiceNow. Strong communication skills and experience supporting global enterprise systems. Skilled in building Tableau dashboards, automating business reports, and optimizing business workflows.
Overview
5
5
years of professional experience
Work History
Team Lead
FedEx Logistics
Phoenix, AZ
08.2024 - Current
- Supervise day-to-day logistics operations and manage a cross-functional team.
- Use SQL and Excel for shipment tracking and performance reporting.
- Streamline workflows to meet delivery SLAs and improve customer satisfaction.
- Train and mentor new team members to boost productivity.
- Lead regular team meetings, set performance goals, and provide feedback to ensure individual and team accountability.
- Manage escalations and troubleshoot operational challenges, liaising with higher management and external partners as needed.
- Ensure compliance with safety, quality, and regulatory standards throughout logistics operations.
- Support workforce planning, scheduling, and resource allocation to meet fluctuating demand.
Oracle Cloud Techno-Functional Consultant
Freddie Mac
McLean, VA
07.2023 - 08.2024
- Supported Oracle Fusion SCM and HCM Cloud modules including Payroll and T&L.
- Developed integrations using Oracle Integration Cloud (OIC).
- Designed BI Publisher reports and OTBI dashboards.
- Managed Workday-Oracle payroll integrations and quarterly patch validations.
- Authored BR100 and MD050 documentation; led UAT and CRP sessions.
- Lead the design and deployment of Oracle Integration Cloud (OIC) interfaces, streamlining integrations between Oracle and third-party systems (e.g., Workday, ServiceNow).
- Provide hands-on support for quarterly patch testing, regression validation, and resolution of SRs with Oracle support.
- Author BR100 and MD050 documents, SOPs, and test cases to ensure audit-compliant system documentation and traceability.
- Drive user acceptance testing (UAT), conduct end-user training sessions, and manage go-live cutover planning and hypercare support.
- Build custom workflows using BPM for procurement approvals and expense policies, reducing turnaround time and improving compliance.
Oracle Techno-Functional Consultant
Symbiotic
Boston, MA
09.2021 - 11.2022
- Customized Price Lists, enhanced P2P and OTL processes.
- Developed Tableau dashboards for field service and predictive analytics.
- Integrated Oracle ERP with ENOVIA PLM for supplier collaboration.
- Conducted UAT, coordinated offshore deliverables, and resolved post-go-live issues.
- Collaborate with business users to gather requirements, perform fit-gap analysis, and configure Oracle Cloud solutions aligned with industry best practices.
- Develop custom reports and dashboards using BI Publisher and OTBI for real-time tracking of procurement, payroll, and order data.
Oracle Application Developer
Kantar
Hyderabad, India
12.2020 - 08.2021
- Configured Oracle WMS to support business unit separations.
- Customized PO workflows and developed PL/SQL scripts.
- Authored BR100 and MD050 for SCM modules; led SIT and UAT.
- Optimized SQL queries and delivered KPI-based Oracle reports.
- Developed and optimized PL/SQL packages, stored procedures, triggers, and views to support real-time transaction validation, automation, and reporting.
- Created and modified Oracle Forms and Reports to support user-specific customizations including PO printing formats, inventory transaction history, and supplier performance metrics.
- Played a key role in the testing lifecycle by designing and executing unit tests, system integration tests (SIT), and user acceptance testing (UAT).
- Designed dashboards for procurement performance and WMS KPIs, integrating SQL queries into OBIEE and Excel-based reporting tools.
Education
Master of Science - Engineering Management
Trine University
01.2023
Bachelor of Science - Engineering
Kurukshetra University
01.2020
Diploma -
Civil Engineering
01.2016
Skills
- SQL
- PL/SQL
- Oracle EBS (R12, 11i)
- Oracle Fusion Cloud (SCM, HCM)
- OM
- PO
- INV
- WMS
- Field Service
- HR
- Payroll
- OTL
- Oracle Forms
- Reports
- XML Publisher
- Workflow
- RICEW
- Workday PECI/PICOF
- Dell Boomi
- Informatica
- OBIEE
- Tableau
- Workday Reporting
- ServiceNow
- BR100
- MD050
- SOPs
- UAT
- Functional Testing
- Microsoft Excel
- PowerPoint
- Visio
Core Modules Expertise
Development Tools & Components
Timeline
Team Lead
FedEx Logistics
08.2024 - Current
Oracle Cloud Techno-Functional Consultant
Freddie Mac
07.2023 - 08.2024
Oracle Techno-Functional Consultant
Symbiotic
09.2021 - 11.2022
Oracle Application Developer
Kantar
12.2020 - 08.2021
Master of Science - Engineering Management
Trine University
Bachelor of Science - Engineering
Kurukshetra University
Diploma -
Civil Engineering