Oracle Techno Functional

Santosh

Summary:

• Over *+ years of professional experience in Analysis, Design, Development,

Testing and Implementation of Applications using Oracle Applications and Oracle

Development tools.

• Expert in customization, implementation, maintenance and support of Enterprise

Business Applications using Oracle R12/11.5.10/11.5.8/11.0.6 e-Business Suite.

• Conversant in implementing Oracle Financials, Supply Chain and Manufacturing

modules like Oracle (GL, AR, AP, FA, PO, OM, INV, BOM, AOL).

• Sound functional knowledge of the OTC and P2P cycles of Oracle Applications e-

Business Suite, with experience in the analysis, design, and development of

business, Oracle Financials and Oracle Distribution environments.

• Worked with Open Interfaces in all Financial and Supply Chain Modules and also

used standard Oracle API’s for Interfaces and conversion procedures. Developed

Interface programs for data transfer between modules OM, INV, PO, GL, AR, AP.

• Expertise in Oracle Application EBS Customization, Enhancements, Reports,

Interfaces, Conversion, Workflow (RICEW) components.

• Proficient in writing stored Procedures/Packages, Functions, Cursors & Database

Triggers using PL/SQL

• Expert in developing programs using SQL*loader, Toad and PL/SQL procedures to

transfer data from legacy systems with knowledge in Unix Shell Scripting.

• Experienced in analyzing index, quality assurance, Performance Tuning of Oracle

SQL and PL/SQL applications using- TKPROF Explain Plan.

• Expert in developing applications using Oracle RDBMS 10g/9i, Oracle Forms 6i /

10g and Oracle Reports 6i /10g, Oracle Discoverer.

• Expert in developing custom reports in XML Publisher.

• Knowledge in extending self-service applications using OA Framework.

• Knowledge and Experience of TCA (Trading Community Architecture).

• Good knowledge on Release 12 (R12).

• Good Knowledge of Multi organization Access control (MOAC) architecture and

understanding of MOAC Impact on custom programs development like report,

forms, and workflow PL/SQL packages.

• Extensively worked in developing Functional Design Documents (MD50),

Technical Design Documents (MD70) using Application Implementation

Methodology (AIM).

• Proficiency in understanding clients needs and generate, modify reports existing in

Oracle Applications according to the requirements and specifications.

• Expert in SYSADMIN and in Oracle Applications activities like managing

concurrent managers, application user setup, defining responsibilities, values sets,

flex fields, registering menus, forms, reports, concurrent programs, providing

support to apps users for any technical or functional issues

• Excellent team player with immense ability to grasp new concepts and apply them

as per business requirements. Well organized with interpersonal and developmental

skills, strong work ethics and willingness to work hard to achieve employer goals

and targets.

Technical Skills:

ERP: Oracle E-Business Suite 12i/11.5.10/11.0.3 (OM, INV, NV, BOM, AR, PO, FA,

AP, GL, CE, work flow, AOL)

Tools: Toad, SQL * Loader, PL/SQL Developer

Databases: Oracle 10g/9i, Access 2000

Languages: C, C++, Core java, SQL, PL/SQL, Shell Programming

Operating Systems: Windows 2000/NT/98, Linux, UNIX (Solaris, HP-UX).

Developer Tools: Forms 10g/6i/4.5, Reports 10g/6i/4.5/2.5, Discoverer

10g/4i/3i, XML Publisher, Workflow Builder 2.6, OA

Framework

Web Technologies: HTML, XML, Java-Script

Professional Experience:

Cannon, NJ Jun 2011 - till date

Techno - Functional Consultant

Environment:

Oracle Applications 11.5.9 (PO, INV, OM, GL, AP, AR, CM), Procure To Pay(P2P),

Order To Cash(O2C), TCA, BI Publisher, Discoverer, Oracle 10g, Reports 10g, Forms

10g, Custom.pll, Forms Personalization, Unix, TOAD, SQL*Loader, and PL/SQL,

PVCS, PPM(ITG)

Responsibilities:

• Designed and developed interface programs to extract orders from Hasler

JDEdwards system and converts only CLOSED or CANCELLED orders from

JDEdwards to Oracle.

• Setup Order Import Source, DFF’s necessary for the conversion.

• The Oracle conversion program imports Order Headers, Order Details into Oracle

Order Interface Table. Records that fail in this process are re-examined and

corrected and the process is re-run to import the failed records. This process is

repeated until all records are successfully imported into Oracle Order Interface

tables.

• The conversion program creates an account relationship between the ship-to and

bill-to customer accounts.

• Created Staging tables to load the records from JDEdwards and upload the flat files

using SQL Loader.

• Developed Migration Request Documents and interacted with DBA team in order

to move an object to other environments. Proficiency in using the tool PVCS as

part of migration to other environments.

• Involved in design of AIM (Application Implementation Methodology) documents

(CV40, CV60, MD50, MD70) for all conversion. The conversion document has a

detail mapping of Order Headers and Orders Details from the source Hasler

JDEdwards system to the Oracle Order Management

Xerox Corporation (Webster, NY) Nov 2010 – May

2011Technical-Consultant

Environment:

Oracle EBS R12, SCM(OM, INV, PO, WMS), PL/SQL Developer, SQL*Plus, TOAD,

PL/SQL, SQL*Loader, Reports 10g, Forms 10g, Workflow Builder.

Responsibilities:

• Designed and developed interface programs to extract orders from custom web

application objects, populate to staging table, validate the data in staging table and

send to interface tables.

• Importing Orders from Legacy EMP to Oracle includes the following interface

programs

• Xerox EMP Interface Control

• Xerox Order defaults and substitution

• Xerox Order Import

• Xerox Change Order Import

• Used standard Oracle OE_ORDER_PUB API to create a new sales order and

update/cancel an existing sales order in Oracle Apps System.

• Used standard Oracle OE_HOLDS_PUB API to apply/release holds on the sales

order created.

• Developed the below Custom reports using Reports 10g as per the client

requirements in OM module

• Xerox Consolidated Pick Slip

• Xerox Packing Slip

• Daily Inventory Report

• Xerox Shipping Exception Report

• Item Label Report

• Bill of Ladding Report

• Form Personalization Tasks

• Pick Release Form: Not allow selection/insert/update of the organization

field.

• Copy flags when copying sales orders: Allows to pick and choose which

sales order elements are copied along with the order.

• Customized the existing forms as per the client requirement.

• Workflow Customization

• Seeded OM Workflows are copied and customized to create Ship only

Workflow.

• Workflow notification for Sales Order will be triggered at the launch of

Sales Order “Book” event and an email notification is sent to the

concerned.

• Dealt with registering / defining of custom applications, tables, concurrent requests,

standard report submission etc and also with profile options, defining of application

users and responsibilities.

• Created and used stored procedures, packages, cursors and functions to do the

validations on the legacy data.

• Modified the existing code to meet the new business requirements. Interact with the

Business users and analyze new business requirements or enhancements or change

requests and prepared Functional/Technical Design documents.

• Involved in design of functional setups in Order Management.

• Responsible for Functional testing and Process setup.

• Created indexes to enhance the performance of the applications.

• Involved in recoding some of the existing custom interfaces in PL/SQL to reduce

the turnaround time of execution and completion of concurrent processes.

• Involved in design of AIM (Application Implementation Methodology) documents

(MD-70) for all conversion and reports.

Motorola Inc (Schaumburg, IL) Jan 2010 – Oct 2010

Techno-Functional Consultant

Environment:

Oracle EBS R12 Financials (GL, FA, AP, AR), PL/SQL Developer, SQL*Plus, TOAD,

Reports 10g,PL/SQL, SQL*Loader

Responsibilities:

• Developed new format for Federal P/L full line which gives information about

cost and revenue for Federal activities.

• Prepared SQL queries to identify federal transactions from the transactions posted

to General Ledger using GL_JE_HEADERS, GL_JE_LINES, and

GL_JE_BATCHES tables.

• Traced the linked Sales Order and Customer Information by using the Invoice

Number in Account Receivables (AR).

• Motorola Customers are maintained using the Trading Community Architecture

(TCA).

• Created flat files using UTL_FILE, DBMS utility package which displays federal

GL entries grouped by code combinations.

• Developed the UNIX shell scripting programs to upload flat files to FSS GL

System.

• Created Staging tables and inserted the GL entries for OBIEE reporting purpose.

• Developed custom interfaces for each system i.e., AR, COGS.

• For these systems, developed a process which loads general entries to the custom

table and then created flat files. Created custom package which validates the data

before loading.

• Debugged Issues related to flat file formats for different systems to be

successfully received by GL system.

• Debugged production issues related to profit and loss matches.

• Loaded data using SQL*Loader.

• Developed FL Entries Custom report using Reports 10g.

• Involved in Analysis of Requirements document.

• Designed Technical Design documents and specifications.

• Created PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables with

Bulk Collections to trace back the source orders responsible for Federal GL

Transactions.

• Registered the PL/SQL scripts using Concurrent Programs and attached the

programs to existing Request Sets.

• Worked on documentation using Application Implementation Methodology (AIM)

Standards.

• Created Design, Test Plan and Unit Test documentation.

• Worked on performance tuning for queries using Explain plan and analyzing

indexes for standard oracle tables by running gather index statistics

• Worked closely with third party users while sending the files to GL system.

• Responsible for Unit and Integrating testing.

• Used the tool Kintana to move the above developed procedures to the other

environments.

• Supporting the User Acceptance testing and Post Production support.

Carnival Cruise Lines (San Jose, CA) Sep 2008– Dec 2009

Technical Consultant

Environment:

Oracle EBS 11.5.10.2 (OM, INV, PO, AR, AP), Workflow Builder, Reports 10g, PL/SQL

Developer, SQL*Plus, TOAD, PL/SQL, SQL*Loader

Responsibilities:

• Implemented Order Management Workflow extension for RMA Finance approvals

for various financial validations which Carnival requires during Order to Cash

process.

• RMA email notifications to AR collector taking place within the order processing

flow used globally for all 3 regions – EMEA, Americas, APac.

• In the collector setup the collector email address was configured in consistent

format.

• Seeded OM Workflows are copied and customized to achieve this requirement.

• RMA Approval workflow notification for Sales Order will be triggered at the

launch of Sales Order “Book” event.

• RMA amount was set up in a value set on Operating Unit Level.

• An Email Notification to the AR Collector is sent immediately after the RMA order

is approved by finance in R12 OM.

• Developed the custom programs for the below conversions.

• OM Item Substitution Conversion

• OM Item Conditioning Conversion

• Developed RMA Receipt Report using Reports 10g.

• Reviewed Business requirements, IT Design documents and prepared Technical

Design Documents for this release.

• Responsible for unit and integrating testing.

• Responsible for Functional testing and Process setup.

• Extensively involved in designing the project and coordinating a highly

professional team.

Lanco ( Hyderabd) Jan 2007– Aug 2008

Technical Consultant

Environment:

Oracle Applications 11.5.10.2, AP, AR, GL, OM, PO PL/SQL, TOAD, Forms 6i and

Reports 6i, SQL*Loader, SQL*Plus, UNIX, Shell scripts.

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50),

Technical (MD70) design document and Conversion Mapping Document (CV40)

to extract data from legacy system into Oracle Applications open interface tables.

• Designed, documented and developed staging tables, conversion routines, Custom

PL/SQL API’s for converting data from legacy system (Mainframe) to Oracle

Applications.

• Purchase Orders,

• AP Invoices,

• AR Invoices,

• Bank Branches and Bank Accounts

• Designed and developed an interface between third party billing system (INTUIT)

and Oracle Receivables (AR) to load external invoices data on daily basis. Used

SQL*Loader for import INTUIT invoices into Staging tables, and developed

PL/SQL API for complete validation of data and inserting into Interface tables

• Run the Invoice Inbound Program (INI), an E-Commerce interface program to

import supplier invoices into Oracle Payables for manual and or electronic

payments

• Designed, documented and developed an Interface between web based Order

Management systems ODYSSEY to Oracle Order Management for Creation of

Sales Order. Where I developed an UNIX shell script, which calls SQL Loader

program to load data into custom staging tables and checks for uniqueness of the

files in UNIX directory to avoid duplicates.

• Did Analysis and fixed Accounting issues using Account Reconciliation Reports -

Verification of GL Balances report in regard with Fixed Assets, Payables and

Receivables.

• Designed and developed Fixed Assets Conversion by running Mass Additions

Concurrent Program to transfer the data from interface to base tables in Fixed

Assets (FA).

• Reports

• Developed Dunning Letters using Reports builder and emailed to

customer. Created Data Definitions and Data Templates.

• Customized the Journal Entries Report in AR which is used to review the

details that make up the general ledger journal entries.

• Developed PO and AP Analysis Report.

• AR All Invoice aging report By Date

• Customized existing reports and developed new reports in different

responsibilities like receivables, purchasing and successfully completed

migration of reports from Discoverer 4i to Discoverer 10g.

• Forms

• Created Read Only version of Customer Standard form.

• Modified Invoices form in AP and Transactions form in AR to restrict

data access.

Barath sanchar nigam (Hyderabad) Feb 2006-Jan 2007

Technical Consultant

Environment:

Oracle Apps 11i, UNIX, Oracle 9i, Reports 6i, TOAD, SQL*Loader, PL/SQL, SQL*Plus,

AR, AP, PO, INV, HR

Responsibilities:

• Developed Custom Program for Vendor Conversion (Include Vendor, Sites,

Contacts) in AP Module.

• Developed Custom Program for Conversion of Customers in AR Module from the

Legacy System.

• Developed Custom Program for Employees Conversion

• Developed various outbound process to send flat file from Oracle Applications to

external system using UTL file package, FTP.

• Developed custom outbound interface for New Hire Report to report

Georgia state Government by-weekly by FTP in HRMS Module.

• Developed Material On-hand Quantity Interface to transfer the Material

Transactions information into Legacy Flat file.

• Developed Custom outbound Interface to send the Invoices file to third

party system in AP Module.

•Developed Custom outbound Interface to send the Payments file to third

party system in AP Module.

• Developed various Inbound process.

• Developed Custom Item create Interface program to populate the Items,

revisions, categories, cross-references information.

• Developed Purchase order Interface to upload the STANDARD Purchase

order transactions into the Oracle apps Base tables.

• Developed Requisitions Open Interface to upload the Requisitions

transactions into the Oracle apps Base tables.

• Developing Reports, Customization of Reports

• Reconciliation Report for Item Interface

• Reconciliation Report for Requisitions Interface

• Reconciliation Report for Invoice Interface

• Reconciliation Report for Payments Interface.

• Testing the resolved objects and supported in writing quality documents.

• Created indexes to enhance the performance of the applications.

• Involved in recoding some of the existing custom interfaces in PL/SQL to reduce

the turnaround time of execution and completion of concurrent processes.

British Telecom, India Apr 2004 – Jan 2006

Pl/SQL Developer

Environment:

Developer 2000, SQL, PL/SQL, Oracle 9i, UNIX, Windows 2000

Responsibilities:

• Extensively involved in coding of the Business Rules through PL/SQL using the

Functions, Cursors, Triggers, Stored Procedure, and Packages in the server side.

• Participated actively in the technical and functional discussions.

• Extensively involved in designing the project and coordinating a highly

professional team.

• Interacted with the user group on a regular basis to discuss requirements and

updates.

• Designed ER diagrams and normalization of database.

• Developed scripts to create tables, views, procedures and functions and executed

them using SQL*Plus.

• Migrated the data from external files into Database tables using SQL *Loader.

• Extensively involved in performance and tuning of all SQL and PL/SQL code.

• Used Built-in Packages provided by oracle for debugging.

• Reviewing / Testing Procedures & Functions developed by the team members.

• Wrote triggers to handle user-generated events.

• Developed UNIX shell scripts to schedule the cron jobs.

• Used Developer 2000 to generate reports of statements for users.

EDUCATION

• Bachelor in Computer Science.

REFERENCES

Neopost USA

Nagaraj Renukunta

*.*********@*******.***

Motorola

Sujata Upalla

******@*****************.***

Xerox

Satya Tarangini

*****.*********@*****.***

Contact this candidate