Sachin Gupta
Faridabad
Summary
- Possess 18 years of professional experience in software industry with comprehensive knowledge through all phases of software development lifecycle from requirement analysis to maintenance of a project. Technically proficient in RICE (Reports, Interfaces, Conversions, Extensions) implementation, conversion, data migration, and AOL. Expertise in developing packages, procedures, functions, database triggers, interfaces and data conversion using PL/ SQL, TOAD and SQL
Overview
17
17
years of professional experience
Work History
Programmer Analyst L-5
Ultimate Kronos Group
08.2015 - Current
- Worked on XML Publisher reports to print Service Contracts in multiple languages i.e. French, English, Spanish etc.
- Worked on Optio reports to generate output in PDF format which will be saved as repository for Customers in Ecompresent (3rd Party System).
- Worked in customization of Oracle RMA workflow to send notification to service contract team once all lines are received in inventory.
- Worked in Pillar -3 project for integrating Oracle AR invoices into D365 system.
- Developed invoice presentment for AR invoices in D365 system which is used as customer facing document for invoicing.
- Engaged with Finance business users globally to facilitate the gathering of requirements and ensure adherence to industry best practices, enhancing efficiency of financial systems and processes and suggested some bright ideas which can save them lot of effort.
- Implemented automation of Oracle receipts removing manual intervention saving lot of manual effort.
- Good exposure in functional modules (AP, AR, OM, PO and Inventory).
- Part of core team for service now implementation and did user testing when service now was implemented in UKG.
- Providing support to business users and BA's for month end closing activity
Associate Lead
United Health Group
04.2011 - 08.2015
- Worked on Oracle Scripting to create Oracle tasks in Telesales.
- Customized and developed various Forms and reports to support the daily business including the Sales Order form.
- Open AR Invoice & Receipts Migration: Wrote procedure for loading AR invoices & receipts and done validation before transferring it into Interface table.
- Developed various PLSQL Packages based on different business requirement.
- Customized and developed various Forms to support the daily business needs.
- Part of Code review Panel (Offshore) for all the components delivered.
- Developed a module for automating all Adhoc queries which will send email to business users specified or ftp the output to desired location on shared directory. This module resulted in huge dollar saving.
- Identified manual work done by business and automated lot of manual reports which business used to make manually which resulted in lot of dollar savings in the project.
- Good hands on knowledge in SVN for checking in code and creating manifest for porting of code to other instances.
- Co-ordinating with onshore and business for functional clarifications required.
- Providing Knowledge transition to new joinees in team of various processes followed in the project.
- Worked on locking mechanism by using Advance Queues Concept in PLSQL.
- Developed Hold management module by putting basic validations so that holds can be released through program without any interference from user and it also resulted in lot of dollar savings.
- SPOC for arranging war rooms to interact with different applications whenever there is P1 and P2 incident is raised.
- Automated process of releasing Hold by putting various validations and removed manual intervention.
Apps Techno Functional Consultant
Tata Consultancy Services
11.2009 - 04.2011
- Developed Move Order Detailed Status Report in Oracle Inventory.
- Developed a Quality Inspection form for checking the Received Quantity & Inspection Quantity on basis of Receipt Date where User gets detailed information of Receipt Number, Vendor Code & Vendor Name, Item Code.
- Developed a unix shell script for reading the data file from a particular location and after reading to process into another directory.
- Worked on Personalization on AR Open Period/Close Forms So that user can only open two Consecutive periods prior to last Closed period for NON AIX Countries and only one period for AIX Countries.
- Developed a program to update customer profile & Credit Limit for the Customers provided in the data file.
- Worked on assigning Item Categories to Items in Oracle inventory.
- Worked on Customer Conversion for uploading Customer information from a company acquired by Agilent.
Apps Techno Functional Consultant
Fujitsu Consulting India Pvt. Ltd.
09.2008 - 01.2009
- Conversion of Item Category: Worked on conversion of Item Categories assignment attached with the Items with the help of API INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY.
- Extension of Item Attributes: Worked on Extension of Updating Item Attribute update based on the transaction type on daily Basis.
- Requisition upload: Loaded Requisitions in PO by using SQL
- Loader to transfer data from flat file to staging table and wrote PL/SQL procedure to valid and load data into interface table.
Education
PGDBM (P/T) -
IMT
Ghaziabad12.2007
B.E. - Comp.Sc.
BMIET
Sonepat08.2004
XIIth -
D.A.V Public School
Faridabad05.2000
Xth -
D.A.V Public School
Faridabad05.1997
Skills
- UNIX
- SQL
- PL/SQL
- X D365 F&O
- XML Publisher Reports
- Optio reporting
- Oracle Applications R12
- D365 F&O
- Service now
- PL/SQL development
- Oracle customization
- Business process automation
- User acceptance testing
- Data integration
Courses Certifications
- Oracle SCM R12 1Z0-520 eCertificate
- ITIL V4
- D365 F&O Technical Training
- MB 300: Microsoft Dynamics 365 F&O
Timeline
Programmer Analyst L-5
Ultimate Kronos Group
08.2015 - Current
Associate Lead
United Health Group
04.2011 - 08.2015
Apps Techno Functional Consultant
Tata Consultancy Services
11.2009 - 04.2011
Apps Techno Functional Consultant
Fujitsu Consulting India Pvt. Ltd.
09.2008 - 01.2009
PGDBM (P/T) -
IMT
B.E. - Comp.Sc.
BMIET
XIIth -
D.A.V Public School
Xth -
D.A.V Public School
Similar Profiles
Lynne HendersonLynne Henderson
Senior Manager, Product Management at ULTIMATE KRONOS GROUP (formerly kronos, inc.)Senior Manager, Product Management at ULTIMATE KRONOS GROUP (formerly kronos, inc.)
Aaron JohnsonAaron Johnson
People Success Manager/SKL at Ultimate Kronos Group/ Ultimate SoftwarePeople Success Manager/SKL at Ultimate Kronos Group/ Ultimate Software
Kuldeep ShuklaKuldeep Shukla
Senior Software Engineer at Ultimate Kronos GroupSenior Software Engineer at Ultimate Kronos Group
HOLLY REYNOLDSHOLLY REYNOLDS
Director, Customer Marketing at UKG (Ultimate Kronos Group)Director, Customer Marketing at UKG (Ultimate Kronos Group)
HARSH BHARDWAJHARSH BHARDWAJ
Relationship Manager at Vipul Motors Pvt. Ltd.Relationship Manager at Vipul Motors Pvt. Ltd.