Deepanker Srivastava, Oracle Business Systems Analyst

Deepanker Srivastava

Oracle Business Systems Analyst

Rackspace India Pvt Ltd

Location
India - Gurgaon
Education
Bachelor's degree, Computer Science & Engineering
Experience
11 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :11 years, 10 Months

Oracle Business Systems Analyst at Rackspace India Pvt Ltd
  • India - Gurgaon
  • My current job since November 2017

● Implemented purchasing interfaces for purchase receipt reconciliations with third party data.
● Developed payables interfaces for AP invoices.
● Performed conversions of AP Suppliers, Sites with legacy data.
● Implemented complex reporting for SLA date calculations based on business requirements. It helped users in prioritizing work as SLA dates are computed in programmatic manner so that shipments are sent on time and escalations due to delays can be minimized.
● Independently Designed and Developed HRMS interface that creates/updates/terminates employee, assignment and address details bases on data provided in flat file.
● Developed interface for COGS recognition Revenue and COGS Recognition
● Configured AME for iExpense Approval
● Modified custom MSCA functionality to achieve business needs.
● Created/modified multiple small reports on Report builder/XML with bursting and other RICE components.
● Developed shell script with complex requirement for taking out PO data from existing Flat file and create new file for import. This automation saved manual effort of users of opening each file and taking data into new flat file.

Oracle EBS Technical Consultant at Fujitsu Consulting India Pvt Ltd
  • India - Noida
  • July 2015 to November 2017

EBS Support for a US Client (Automobile Manufacturing Company)
A is leading automobile parts manufacturer headquartered in Tokyo and having major market presence in United States and all over world.
● Extensively worked on Accounts Payables/Receivables Retro billing enhancements.
● Customized Purchasing Workflow for project-based Approval.
● Done implementation on Business Events for concurrent processes.
● Redesigned custom Interface for PO requisition/receiving for efficient functioning.
● Development of new reports using Report Builder and XML Publisher (used rtf and excel template to generate multiple tab excel report).

Responsibilities
● Quick resolution of incidents from various modules (Purchasing, Order Management, Inventory, Manufacturing, AP, AR)
● On time resolution of incidents related to SLA (Sub Ledger Accounting) and Month-end closing.
● End-to-end deliveries of Change requests.
● Providing estimations of development tasks.
● Ticket monitoring over JIRA/Service Now.

EBS Implementation for a US Client (Automobile Manufacturing Company)
● Implemented Approval Management Engine (AME) for Purchase Requisition and iExpense approval.
● Implemented custom XML reports using multiple data sources on order management and purchasing.
● Coded complex logics under EDI shell scripts.

Oracle Apps Technical Consultant at Sopra India Pvt Ltd
  • India - Noida
  • July 2012 to July 2015

It is a France-based international industrial company specialized in generating and manufacturing high performance semiconductor materials. The company operates on three main markets: electronics, solar energy and lighting.
It is a project involving customization of Oracle EBS R12 software according to business needs.
● Implementation of new interface flow (Inter-org transfer, Ship-Confirm) for EDI Interface (used APIs to perform transactions for creation of transactions in OA to sync information between systems).
● Total Inventory Report implementation (Includes customization of standard inventory and WIP reports and development of new reports to generate final report).
● Worked on Custom Interfaces (Promis, Si-View, and Corsica). Managing interface events those are blocked. Resolution and causal analysis.
● Pending transaction and Open Transaction Interface (Inventory) monitoring and resolution.
● Created and updated AME approval hierarchy (PO/PR Approval, Invoice Approval).

Education

Bachelor's degree, Computer Science & Engineering
  • at Gautam Buddha Technical University
  • January 2012

,

High school or equivalent, Mathematics
  • at Uttar Pradesh Board
  • January 2008

,

High school or equivalent, Mathematics
  • at Uttar Pradesh Board
  • January 2006

(

Specialties & Skills

XML Publisher
Oracle Reports
Oracle ERP
Oracle Forms & Reports
XML Publisher
Oracle Workflow
Oracle EBS
AUTOMATION
CUSTOMER SUPPORT

Languages

English
Expert
Hindi
Expert

Training and Certifications

OCI Foundatons Associate (Certificate)
Date Attended:
July 2020
Oracle Financial Cloud using OTBI (Training)
Training Institute:
Oracle University
Date Attended:
August 2019
Oracle Financial Cloud using BI Publisher (Training)
Training Institute:
Oracle University
Date Attended:
July 2019
Introduction to Oracle Financials Cloud (Training)
Training Institute:
Oracle University
Date Attended:
July 2019

Hobbies

  • Yoga / Science and Technology
    Top performer award in Fujitsu Start Performer Award in Sopra Appreciation from various Institutions for securing highest marks in 10th and 12th