Engineer Software

Abhishek GUPTA

Mobile No.: +91-973*-***-***

E-mail: ************@*****.***

Experience Summary

Oracle Certified Associate (PL/SQL Developer track).

9.2 years, of total experience in OTM as OTM Techno Functional Consultant.

Having good knowledge of Oracle PL/SQL.

Self-Motivated, Decision making, Goal Driven & ability to work independently as well as within team.

PGDBA in Operations from Symbiosis (SCDL) and B.E in Electronic & Telecom from Pune University.

Skill Set

Applications: Oracle Transportation Management (6.4.2), Cut Rite, Cut Rite Reloaded.

Databases: Oracle 12c, Oracle 11g, MS-SQL server

Tools: SQL Developer, Toad 11.6, WinScp, Putty

OS: Linux (RHEL), Windows

Employment Summary

Employer

Client

Role

Project Type

Project Duration

Tech Mahindra

Team Lead

Implementation

November 2019 to Till now

Schlumberger

OTM Technical Expert

Implementation

August 2016 to October 2019

Tech Mahindra

Associate Team Lead

Enhancement

April 2016 to August 2016

Infosys

Senior Associate Consultant

Enhancement + Support

June 2014 to April 2016

Tieto India

Software Engineer

Enhancement + Support

Implementation

February 2011 to May 2014

Career Profile

Responsibilities:

oWorked on Global template to implement otm for 112 customers for MLEMEA.

oDomain Design and Creation for 112 customers.

oBuild Interfaces for Carrier and Finance system.

oAll Master data for all customers.

oImplemented Consolidated Invoice workflow for MLEMEA.

oImplemented self-billing concept for business.

oImplemented Match and Pay concept for business.

oConfigured GL Codes (General Ledger) as per finance requirement.

oVAT Configuration for Europe region.

Responsibilities:

oImplemented end to end EDI Solution for SLB starting from tendering till invoice.

oWorked and built new OTM interfaces for EDI.

oOTM Upgrade from 6.3.6 to 6.4.2.

oWorked with multiple 3rd party systems like SIMS, SAP, SPS etc.

oWorked with Continuous improvement team to fix the issues to make a stable system.

oWorked on tableau reports and help BI team to migrate reports to Power BI.

oHandling Vendor companies for support and implementation.

oAttending design sessions from business team.

oDesigning / Build new OTM system for SLB.

oSIT Testing cycles and UAT Testing cycles for all the releases.

oRegression testing cycles.

oPerformance testing of OTM using Load runner tool.

oTrainings to Users for the new changes coming into system or completely new system.

oPost go-live support – at user locations, Handling of tickets and new enhancements.

oAutomaton of OTM Scenarios with Automation team.

oWorked on Fleet and Finance Module.

Responsibilities:

oLeading team, client interaction to implement business and conduct OTM Trainings.

oConfiguration of Agents for enhancement.

oConfiguration changes in Screen sets, Menu, Saved queries / conditions.

oConfigured various new Actions for shipment / order and Configuring Action Checks.

oFixed Packages, Procedures and Functions not behaving as expected.

oFamiliar with OTM table structures.

oConfigured system for Purging of order/ shipments/ invoices.

Responsibilities:

oPurging of order / shipments /invoices several.

oMonitor Open Process and Object locks in OTM.

oPrepared Solution Design documents based on Business Requirement Specification.

oConfigured Batch processes.

oConfigured data queues.

oCustomized action as per customer’s requirement.

Responsibilities:

oWorked on Invoices under Finance module of OTM

oWorked on Rate management of OTM and issues related to Rates and Itinerary.

oRestrict visibility using VPD, Configured new Screen sets and Menu manager.

oWorked in developing Packages, Procedures and Functions using SQL and PL/SQL.

oFamiliar with OTM table structures.

oWorked extensively on Configuration of new Reports.

Responsibilities:

oCreation of I macro script for automation of replaying the transactions.

oMaster data creation like Cities, LSP’s, Location and Contact in OTM Application

oCreating new screen for OTM application

oWriting SQL/ RTF/XSL to generate various kinds of reports as per requirements

oConfiguring shell scripts for OTM application monitoring

oIntegration of OTM with Evolv a MevenWire Tool.

oEvolv application monitoring, database monitoring reports and application monitoring.

oWriting PL/SQL triggers on rates and Uploading New rates in OTM using Evolv application

oCreation of new evlov templates and applying validations on the rates using evolv

Responsibilities:

oUnderstanding file structure (No fixed pattern) and application behavior of CR / CRR.

oCreating data migration mappings from CR files to CRR tables

oDoing SSIS development work for implementing mappings

oIntegration of mappings from CR to CRR

oUnit testing for checking that whether implementation is right

oDemos to the customer for data migration from CR to CRR

Trainings and Certification

CERTIFICAATION NAME

Type

YEAR

Oracle Certified Associate (OCA) – Oracle 11g

Certification

Apr 2013

Oracle ADF 11g (11g Certified Implementation Specialist)

Certification

Dec 2011

C.S.I Certified

Certification

Oct 2010

ITIL v3 Foundation Certificate

Certification

Aug 2013

Software Testing Training from Persistent Systems

Training

2011

Advance Excel Workshop

Workshop

2011

Oracle ADF Workshop

Workshop

2012

Educational Profile

QUALIFICATION

COLLEGE/ UNIVERSITY

YEAR

AGGREGATE %

PGDBA (Operations)

Symbiosis (SCDL)

2014

64

B.E (EnTc)

D. Y. Patil College

2010

63.8

H.S.C

J&K State Board

2006

64

S.S.C

J&K State Board

2004

82

Personal Information

Type

Details

Present Address

Flat no C- 803 Costa Rica, Wakad, Pune, Maharashtra 411057

Permanent Address

H. N0 132, Sec -5, Channi Himmat, Jammu - 180011

Date of Birth

10th Dec 1988

Passport Number

S5400624

Passport Validity

November 2028

PAN Card

AQEPG4151E

Marital Status

Married

Professional Moto

There is a solution to every problem, so it’s better to spend your energy in finding solutions, not excuses.

Abhishek Gupta

Contact this candidate