Rinku Gautam
: -
Email:-
Introduction
Completed B.E. in Electronics and Telecommunication and currently working in a reputed IT company for close to 6 years as Technology Analyst.
My objective is to seek association with an established organization that provides opportunities in creativity to contribute towards the growth of the organization and to benefit personally in terms of overall development.
Summary
+/- 6 years of extensive experience as an Oracle Application Technical Consultant in implementation, upgrade, customization, production support of Oracle E-Business Suite Applications (R12). This includes system study, design, development, post implementation support maintenance and support of Oracle EBS. Also, possess expertise on Fusion Cloud Implementation (Release 11 and Release 12).
Dexterous in developing Interfaces, data conversion, data migration and report generation.
Developed new concurrent programs, XML Publisher reports, BI Publisher Report (Fusion), Oracle Alerts and Lookups.
Adroit in customizing Oracle Workflows according to business needs.
Expertise in File Based Data Import (FBDI) and Spreadsheet upload in Fusion Cloud Environment.
Well versed in implementing personalization using Sandbox and Page Composer.
Experience with OTBI and custom ESS Job definition in Fusion application.
Proficient in requirement analysis, system design, data flow designs, development, testing documentation and design reviews.
Expert in developing Technical design documents (MD070), Solution Design document (SD060), Migration document (MD0120) and Test Plan Document (TE020).
Fair knowledge in UNIX shell scripting.
Interacted with Business users, fixed the bugs, developed test plans, provided daily production support and troubleshoot issues, including creation/follow-up Oracle Service Request (SR).
Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) and Software Development Life Cycle (SDLC).
Familiar with versioning tool Tortoise SVN and ticketing tools like JIRA, Remedy etc.
Professional Experience
Organization: Infosys Limited.
Designation : Technology Analyst
Period: Since March 2012 to Present.
Projects and Responsibilities
Project: VAT Template changes for GCC countries
Period: September 2017 to Present
Role: Fusion Developer
Responsibilities:
Customized the seeded reports “Invoice Print” and “Credit Memo Print”. This includes the modification of seeded data model as well as creation of new rtf layout for new business requirements.
Invoice and Credit memo Report template changed as per requirements.
Worked with Oracle Support to fix issues with standard components.
Project: Ariba Integration
Period: January 2017 – August 2017
Role: Oracle Applications Techno-Functional Consultant
Responsibilities:
Information of newly created PO or modified existing PO or cancelled existing entire PO or lines of existing PO in Ariba cloud-based B2B market place by the Buyers, is sent to Oracle in the form of files, which are then used to create identical PO in Oracle system.
Only Standard Purchase Orders are created in Oracle.
One XML file will contain information of a single PO only.
Oracle to receive PO information in the form of XML file. Oracle will also send its response either Success or error with details in the form of XML file.
Converted migration from file-based to XML-file to create corresponding Oracle PO in real time.
Modified all existing data base objects and created new database objects to meet above requirements.
Worked with intermediate EI team (between Oracle System and Ariba) for integration testing.
Project: AME for PO Requisition Approval Workflow
Period: October 2016 - December 2016
Role: Oracle Application Technical Consultant
Responsibilities:
For a specific Charge Account combination (of Location, Cost Center and Brand) in a Purchase requisition, the PR should be routed for review and approval depending on the Total Purchase Requisition Amount to specific employee(s).
Assigned responsibilities to all users needing access to AME setup.
Setup AME rules/conditions/Approval groups/Actions/Attributes.
Created automation scripts to automate creation of AME attributes, conditions, approver groups and approver rule setups in negligible time which had tremendously helped to save production downtime.
Project : Region Realignment for North America Region of a reputed client
Period: February 2016 – September 2016
Role: Oracle Application Technical Consultant
Responsibilities:
Realigning branches from current regions to future areas.
Created multiple concurrent programs to automate realignment to new areas.
Newly created programs for realigning regions, which took just 12 seconds, whereas, it takes around 12 hour when performed manually, which was earlier planned.
Project : Re-implementation to change accounting year and accounting period
using Oracle ERP Cloud system
Period: August 2015 - January 2016
Role: Fusion Developer
Responsibilities:
Worked on creating new Business Unit and Legal Entities using FBDI, OTBI and Data Model.
Conversion of accounting calendar from 4-5-4 to Gregorian calendar.
Modules include Account Payables, Account Receivables, General Ledger, Fixed Assets and Cash Management.
Conversion of master and transactional data from the existing ledger/BU to the new ledger/BU
Project: Fusion Cloud Implementation – Fusion Procurement
Period: January 2015 - July 2015
Role: Fusion Developer
Responsibilities:
Conversion of Supplier Data including their bank account details from legacy system to fusion environment through rapid implementation spreadsheet using ADFdi.
Updated DFF information related to customer using FBDI Template.
Conversion of Open AP invoices from legacy system into fusion environment using spreadsheet upload. Additionally, reconciled the invoices created to make sure that no data was missed during conversion.
Created custom BIP report to extract all open AP invoices in the system, segregated based in BU.
Project : Enhancement for copying address and contact person when modify/update
customer
Period: July 2014 - December 2014
Role: Oracle Applications Techno-Functional Consultant
Responsibilities:
Undertook requirements from Client, provided solution, built design, developed required codes and took it to production with zero defects.
As Shift + F5 copy function is not available in oracle R12 webpage framework, thus when modifying/updating customer, we cannot use copy function to copy the needed address and also use existing contact person to add to other branches.
To overcome above challenge, developed a new concurrent program to modify/update customer address, the change should be copied onto all branches containing the same customer account address.
For newly created/updated contact person for a customer site, the same change should be progressed to all the branches containing the same customer account.
Worked to business users to perform SIT testing with zero defects.
Project : Enhancement for Branch Customer clone
Period: January 2014 – June 2014
Role: Oracle Applications Techno-Functional Consultant
Responsibilities:
Undertook requirements from Client, provided solution, built design, developed required codes and took it to production with zero defects.
In R12, customer screens are using OAF web based technology, compared to 11i forms. It is not possible in R12 to copy-paste (Shift + F5 copy function not available in R12 webpage framework) full address field to new address. Moreover, when defining contact details for a new customer or branch address, it’s not possible anymore to choose from an existing contact.
To overcome above challenge in R12, developed a new concurrent program for quick creation of a new branch customer, based on an existing branch customer, which would automatically copy or clone the existing information to a new branch customer.
The Clone program will copy and recreate below branch customer information:
Site Details
Business Purposes
Communication
Profile
Profile Amounts
Took end-to-end responsibility for this implementation to take it to closure.
Project: Oracle Upgrade from 11i to R12.2.5
Period: April 2013 – December 2013
Role: Oracle Applications Techno-Functional Consultant
Responsibilities:
Retrofitted custom objects to make them compatible with R12 – PLSQL packages, procedures, functions, triggers, UNIX shell scripts, workflow files etc.
Modified shell scripts to reflect the data center changes.
Enhanced custom objects to align with MOAC in R12.
Replaced obsolete objects in the custom components.
Tested standard as well as custom concurrent programs in Order Management and Purchasing Module.
Involved in End-To-End testing of OM and PO Module as part of SIT.
Worked with Oracle Support team to fix issues with standard components.
Worked in version control software to check-in codes.
Work on the development activities as part of issue resolution. Performed Unit Testing, Migration to R12 environment using Hudson, assist user testing and quick resolution of tickets.
To remediate 11i RICE components for R12.2.5 version.
Developed Technical Test documents for migrated objects in Order Management (OM), Inventory (INV) and Purchasing (PO) Modules.
Used Hudson tool for migration of all objects to R12.2.5 environment.
Created users, responsibilities, Values Sets and Request sets in System Administrator responsibility.
Developed UNIX Shell to FTP flat file from External Server System to Oracle UNIX Server Location.
Creation of new process for cloning Branch Customers in R12.
Creation of new updating program to Update Account Site address and Create/Update Account Site contact information.
Project : Migration of CEMLI objects from one R12 instance to another
Period: January 2013 – March 2013
Role: Oracle Application Technical Consultant
Responsibilities:
To resolve gaps encountered when migrating CEMLI objects.
Migration of PL/SQL, HOST files and XML Publisher Reports
Created multiple transactions for Order-to-Cash (O2C) Cycle and Procure-to-Pay (P2P) Cycle.
Also worked on following transactions:
(a) Drop Ship Sales Order for a standalone item.
(b) Internal Requisition – Internal Sales Order (IR-ISO).
(c) Drop Ship Transaction for ATO Buy Items.
(d) O2C transaction for ATO Make Items.
Auditing of all migrated objects placed at LAN path on weekly basis.
Project : To develop interfaces to merge technology from Oracle 11i to Oracle
R12 for a Japanese company
Period: June 2012 – December 2012
Role: Oracle Application Technical Consultant
Responsibilities:
To develop multiple interfaces to support Business integration between different client organizations and implement all the business processes in Oracle R12.
Customized standard Inbound Purchase Order (850/ORDERS),Outbound Purchase Order (850/ORDERS) , IN: Invoice (810/INVOIC) and
OUT: Invoice (810/INVOIC) as per client requirement.
The developed components for Baxter which are as follows:
(a) Material Master
(b) Daily Inventory Transactions
(c) Detailed Inventory Balance
Project : To develop interfaces to merge technology from SAP to Oracle for a Japanese
Company
Period: October 2012 – May 2012
Role: Oracle Application Technical Consultant
Responsibilities:
To develop multiple interfaces to support Business integration between different client orgs and implement all the business processes in Oracle R12.
Developed Technical design documents (MD070), Technical Test Documents (TE020) and Migration documents (MD070).
Developed validation packages to load data into interface tables (oe_headers_iface_all, oe_lines_iface_all, mtl_transactions_interface)
Developed PL/SQL packages, procedures, functions, UNIX shell script to validate the data for Cebu, TechData and SPS Commerce for the following components:
(d) Sales Order Information
(e) Inventory Adjustment
(f) Ship confirmation
Project : To develop enhanced reports for a Japanese company
Period: April 2012 – September 2012
Role: Oracle Application Technical Consultant
Responsibilities:
To create a consolidated Order status report that combines information from multiple sources and provides a singular repository for sales with the help of PL/SQL and OAF in Order management domain.
Weekly review of newly created objects for all standards followed as required.
Project : To develop a reusable deployment tool
Period: October 2012 – March 2012
Role: Oracle Application Technical Consultant
Responsibilities:
To develop an OAF based reusable tool which uploads fmb files onto the server and compiles them.
To develop an OAF based reusable tool which deploys rdf files onto the server.
Scholastic Record:
School/College/University
Examination Passed
Year of Passing
Percentage Obtained
Watumull Institute of Electronics Engineering & Computer Technology
(Mumbai University)
Final Year
Third Year
Second Year
First Year
May 2011
May 2010
May 2009
May-
K.V.2,Colaba
H.S.C.(CBSE)
Mar-
K.V.2,Colaba
S.S.C.(CBSE)
Mar 2005
77.80
Technical Skills:
ERP : Oracle Fusion Cloud (R11 &R12) and Oracle Application R12
Languages : SQL, PL/SQL, UNIX ,Java, C, C++
Database : Oracle 10g
Others : MS-Word, MS-Excel, MS-PowerPoint
Tools/IDE : Toad 10/11,SQL Developer, PuTTy, Oracle Workflow Builder,
XML Publisher, Eclipse, Oracle JDeveloper, SVN, WinSCP.
Certifications completed:
External:
Microsoft Certification: – Programming in HTML5 with JavaScript and CSS3 (70-480).
Internal:
Domain certification – Retail Store Management module.
Domain certification – Basics of CPG Retailing.
R12 Inventory Management
Supply Chain Purchasing
Final Year Engineering Project
Successfully designed and developed an Eye-Controlled Wheelchair for special people
using Head-mounted camera system.
Hobbies and Interests
Playing Chess, tennis, swimming and watching infotainment channels.
Strengths:
Strong technical skills.
Honest
Hardworking.
Leadership qualities.
Problem solving skills.
Personal Details:
Father's Name: Krishan Lal
Mother’s Name: Santosh Devi
Date of Birth: 26th December 1989
Gender : Male
Marital Status : Unmarried
Languages Known: Hindi and English
Address : Flat No. 102/B Wing, Harikrupa Building, Hendrepada,
Badlapur (West), Thane-421503, Maharashtra
Other Details:
Current Location: Jaipur, Rajasthan
Preferred Location: Bangalore/Mumbai,Pune,Gurgaon
Notice Period: 3 Months (Negotiable)
Date :
Place: Mumbai Rinku Gautam
