ORACLE APPS TECHNICAL CONSULTANT

Sandeep

Email:-adgxm4@r.postjobfree.com

Mobile: - +91-880*******

Total Exp.-4.5+ Years

OBJECTIVE:

To enhance my knowledge and skill, I would like to work in an innovative and challenging environment where I can utilizes my efficiency plus efforts to fulfill organizations requirement.

PROFESSIONAL SUMMARY:

Having Total 4.5+Years of experience in Oracle technologies.

Worked on experience in PO, INV, AP, OM, WIP, BOM, AR and Application Object Library (AOL) Modules.

Good Work Experience on XML/BI Publisher Reports, Interfaces, Oracle Forms & Reports.

Good Technical working experience in Procure to Pay (P2P) &Order to Cash (O2C) cycles.

Sound Knowledge in writing SQL Queries using (Tables, Views, Synonyms, Indexes, SQL Functions, Joins, Sub-Queries etc...)

PL/SQL – Procedures, Functions, Triggers, Exception Handling, Cursors.

WORK EXPERIENCE:

Currently Working as Associate Application Developer with Fujitsu India Pvt. Ltd. from 01-Nov-2018 to till now and currently working with the Denso –Ten Upgrade Project.

Former Oracle Technical Consultant with RST Global Technologies from 15-Dec-2016 to 15-Oct-2018.

Former Software Engineer in Gen-x Info Tech Pvt. Ltd. from 12-Oct-2015 to 12-Dec-2016.

Technical skills:

ERP Applications : Oracle Applications R12.

Oracle modules :INV, Engineering, PO,WIP, AP,AR, BOM and AOL

Database : Oracle9i/10g

Languages : SQL, PL/SQL, HTML.

Tools : TOAD, Data Loader PLSQL Developer, SQL*Plus, XML publisher, Oracle APEX, Informatics-ETL, Putty, Win-Scp, Report Builder and Form Builder.

Operating Systems : UNIX, Windows.

WORK EXPERIENCE:

1. Project: Denso-Ten Upgradation (12.0.4 to 12.2.9).

Client : Fujitsu America (USA).

Role : Technical Consultant.

Project : S&S Upgradation.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Created script to get the Invalid data objects extraction.

Created Custom objects (Database and Application) data extraction SQL script.

Worked on the retro fitment of their custom and invalid objects.

Created Process documents and test case documents.

2. Project: S&S (Stewart & Stevenson) Implementation (JDE Edwards to EBS 12.2.8).

Client : Kirby Corporation (USA).

Role : Technical Consultant.

Project : S&S Implementation.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project.

Created Customer Master Conversion Program.

Created Customer sites, Profile, Amounts and Contacts Conversion Program.

Created Item relationships Conversion Program.

Created Item cross reference Conversion Program.

Created Items Conversion and assignment Conversion Program.

Created Sourcing Rule and Assignment Conversion Program.

Created Warranty Claim AP/AR Interface Credit Program.

Created MD-70 and Test case documents for all the Conversion Programs.

Created Migrations scripts for all the Conversion Programs.

Created MD-120 documents for Conversion Programs.

3. Project: S&S (Stewart & Stevenson) Upgradation (12.2.4 to 12.2.8).

Client : Kirby Corporation (USA).

Role : Technical Consultant.

Project : S&S Upgradation.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Created script to get the Invalid data objects extraction.

Created Custom objects (Database and Application) data extraction SQL script.

Worked on the retro fitment of their custom and invalid objects.

Created Process documents and test case documents.

4. Project: ATC LE Merger and Vodafone Conversion.

Client : ATC India.

Role : Technical Consultant.

Project : LE Merger and Vodafone Migration Implementation.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Created Open PO Conversion Program.

Created Open PR Conversion Program.

Created Move Order Conversion.

Created Item Upload and category assignment and GSN Upload Details Interface.

Created ASL Conversion Program.

Created Open GRN Conversion Program.

5. Project: GST Implementation.

Client : Ceragon Networks India Limited.

Role : Technical Consultant.

Project : GST Implementation.

Description:

Ceragon designs and manufactures high-capacity communication systems for wireless backhaul – addressing the segment of the cellular market that connects a typical cell tower or towers to an operator’s core network. Ceragon provides wireless devices based on microwave with speeds ranging from 5 Mbit/s up to 2 Gbit/s per radio channel.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Created Purchase Input India GST Register Report.

Created Purchase GST Summary/Detail Report.

Created Sales Order Summary GST Detail Report.

Created Sales Input India GST Register report.

Created AR Tax Invoice Print Report as per GST.

Modification in PO Print India Report as per GST.

Modification in TDS Payable Report as per GST.

Created Credit Memo and Debit Memo GST report.

Modification in Purchase and Sales Register report of Oracle Discoverer Report.

6. Project: Manufacturing Support.

Client : Carrier Midea India Limited.

Role : Consultant.

Project : EBS Support.

Description:

Carrier Midea India Private Limited (CMI) was set up in 2012 to combining the strengths of two global giants in air-conditioning, Carrier and Midea. The joint venture was undertaken to combine Midea’s world-class design and manufacturing expertise in residential air conditioning and Carrier India’s strong pan-India distribution network.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Worked on BOM, WIP and INV Modules.

Provide daily Support Activities in Manufacturing Modules.

Resolved the Issue of Gate Entry, Receipt Creation, On-Hand Stock, Closing Production Order, And Material Transfer.

Worked on Engineering Manufacturing.

Support on Manufacturing Functionally as well technically.

Provide daily Ad-hoc reports as per Requirements.

Design and Development of Customization of RICE Component.

Worked on XML/BI Publisher Reports and Developed PLSQL Programs according to the Requirement.

Development of Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.

Responsible for preparing the technical specification from the functional requirements document, designing the program, programming, unit testing.

Developed Packages to extract the data from base tables into flat files by using UTL_FILE package.

Worked in P2P and O2C Flow Cycles.

7. Project: GNPOC (SUDAN).

Client : GNPOC.

Role : Developer.

Project : R12 Implementation and Oracle APEX.

Description:

The Greater Nile Petroleum Operating Company (GNPOC) is a petroleum exploration and production company operating in Sudan. It was incorporated on 18 June 1997 and undertook construction of the Greater Nile Oil Pipeline which links Sudan's inland oil fields with refineries at Khartoum and Port Sudan.

Roles and Responsibilities:

Interaction and follow up with client and consultants to understand the scope of Project

Design and Development of Customization of RICE Component.

Worked on XML/BI Publisher Reports and Developed PLSQL Programs according to the Requirement.

Development of Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.

Responsible for preparing the technical specification from the functional requirements document, designing the program, programming, unit testing.

Developed Packages to extract the data from base tables into flat files by using UTL_FILE package.

Worked in P2P and O2C Flow Cycles.

Creation of PLSQL script to send mails, in Oracle APEX.

Developed Support Portal In Oracle APEX.

8. Project: SSAL

Client : Maruti Suzuki India Limited

Role : Developer.

Project Type : Development Support and Implementation.

Description:

Maruti Suzuki India Limited, formerly known as Maruti Udyog Limited, is an automobile manufacturer in India. It is a subsidiary of Japanese automobile and motorcycle manufacturer Suzuki Motor Corporation. As of January 2016, it had a market share of 47% of the Indian passenger car market. Maruti Suzuki manufactures and sells popular cars such as the Ciaz, Ertiga, Alto, Swift, Celerio, Swift Dzire and Omni. The company is headquartered at New Delhi In February 2012, the company sold its ten millionth vehicle

In India.

Responsibilities:

Developed XML/BI Publisher Reports and Concurrent Programs, Parameters, Value Sets, Personalization's.

Developed PL SQL Procedures, Function and Packages.

Responsible for Creation of Custom Forms and Reports.

Developed Pending PO Report, Purchase Order Reports, Order Booking Report and Pending Order Report.

Created Workflow Jobs in Informatics.

Scheduling and Monitoring of Workflow job in Informatics.

9. Project: -Recover2000 (Loan Accounting System).

Client : HUDCO, Delhi

Role : Developer

Project : Support and Development

Description:

The Ministry of Housing and Urban Poverty Alleviation is an agency of the Government of India responsible for urban poverty, housing, and employment programs. It is involved in national policy decisions and coordinates with Indian central ministries, state governments, and central sponsor programs.

Roles & Responsibilities

Worked on Custom ERP Loan Accounting System.

Developed New Forms in Existing Custom ERP System.

Developed Daily, Weekly, Monthly Transaction Reports.

Developed Valuation Form, Agency Master Report and Housing Loan Reports.

Developed Custom Forms and Reports as per Requirement.

10. Project: -ERPro (ERP System).

Client : Avon TubetechPvt. Ltd., Farīdābād

Role : Developer

Project : Support and Development

Description:

Avon TubetechPvt Ltd. made a humble beginning in 1997 and now it’s one of India’s fastest growing business houses in tubes industry. Company has the capacity to produce 24,000 MT ERW Tubes, 15000 MT CDW and 6000 MT CDS Tubes per annum.

Roles & Responsibilities

Worked on Modules Gate Entry, Purchase, Inventory and HRMS Modules.

Developed New Forms in Existing Custom ERP System.

Provide Support to Existing ERP System.

Developed Custom Forms as per User Requirement.

Developed Custom Reports as per Requirement.

Developed Database Objects, Function, Procedures and Triggers.

PERSONAL DETAILS:

Date of Birth : 05/03/1991

Marital Status : Married

Nationality : Indian

EDUCATION:

B.Tech (CSE) from GSMVN IET, MDU University, Aurangabad, in 2012.

Contact this candidate