Sandeep

C*C

acq0nf@r.postjobfree.com

713-***-****

Oracle Apps Techno-Functional Consultant

Summary:

Over 7+ years of extensive experience asOracle Application Techno Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of .

Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO),Project Accounting (PA),Oracle Incentive Compensation(OIC).

Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.

Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).

Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.

Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).

Expertise on designing and implementing Oracle Alerts and Lookups.

Fair Knowledge in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions.

Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).

Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.

Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specification.

Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Interacted with users, fixed the bugs, developed test plans and provides daily production support.

Excel in team collaboration, quick adaptation and problem solving with good communication skills.

Well Versed in Oracle Coding Standards and use of oracle tools.

Technical skills:

ERP:

Oracle E-Business suite R12/11i General Ledger GL, Accounts Receivables AR, Accounts Payables AP, Fixed Assets FA, Order Management OM, InventoryINV, Shipping WSH, Project Accounting PA, Cash Management CM, OIC, Purchasing PO, iExpense, AOL, System Administrator.

Application Tools:

Reports 6i/9i/10g, Discoverer 4i/9i/10g, XML Publisher 5.6.3/5.6.2, Oracle Forms 6i/9i/10g, Workflow Builder, Oracle Enterprise Manager (2.1.0) and OA Framework.

Databases & Tools:

Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer

OperatingSystems:

Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages:

SQL, PL/SQL, C, Java, HTML, XML

Scripting Languages:

Unix Shell scripting

Professional Experience:

CISCO (Invoice 2 Cash), San Jose, IL(Oct’14 to Till Date)

Role: Oracle Apps Techno Functional Consultant

Contribution:

Responsible for requirement gathering for the reports and custom programsdevelopment through meetings with functional team and business users.

Developed Interface for invoice import in AR after actively participating in the preparation of the conversion mapping documents.

Developed various interfaces, both inbound and outbound, which are run on periodic basis.

Involved in customization of several standard reports to serve important business processes very specific to the client. Reports included Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustmentreports in AR using Reports 10g..

Scheduled various concurrent programs and reports to run on a specified time daily without interfacing other standard programs using System Admin Responsibilities.

Created an Oracle Alert that triggers whenever a new responsibility is added or there is a change in existing responsibility for the user accounts.

Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.

Establish data conversion routines and executed scripts to convert GL, AP and FA data from legacy systems

Involved in the iExpense implementation, designing and performing a major modification to the daily inbound interface to handle multiple files on the same day. Also generated scripts to encrypt and archive the inbound data file which consists of confidential information.

Established new procedures for AP, PO, GL and FA modules.

Developed PL/SQL scripts to load data from external system to Account Receivables ra_Interface_lines_all interface tables and developed invoice interface

Debugged the custom interface between Project Accounting PA and Receivables AR.

Develop a Program for the Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables AR.

Customized the standard Inventory INV In-Transit Value Report using Reports 10g/XML/BI publisher

Developed Supplier Audit Report and Bank Audit Report in Accounts Payable (AP) and Rental Order Report in Order Management(OM) using XML/BI Publisher.

Created business areas, user views, custom folders and joins for reporting using Oracle Discoverer 9i in Administrative edition as per the user requirements.

Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40).

Tata Consultancy Services Ltd

Cell C OIC Implementation &Change Chart of Accounts, India (Jan’13 to Sep’14)

Role: Oracle Apps Techno Functional Consultant

Contribution:

Designed the solution for paying compensation using oracle Incentive compensation module.

Developed In-bound interface to createinvoice for rebate transactions in oracle incentive compensation

Involved in the Functional setup of Oracle Incentive Compensation (OIC) module.

Developed compensation plans which involves creation of rate dimensions, rate tables, expressions, formulas, plan elements, payment batch.

Involved in the setup of incentive compensation configuration workbench, creation and enabling of custom tables as per the project requirement, column mapping for calculating the compensation, creation of sales person, assigning roles

Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executables, registering applications.

Involved in the setup of chart of accounts,creation of security rules, creation of cross validation rules and roll up groups.

Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance Report. And changed the output format to XMLand created new templates for XML Publisher to display in pdf or Excel Format.

Generated Order submission summary and Detail reports by email Report using BI Publisher.

Designed and developed extension to create move orders using oracle seeded API.

Customized existing forms appearance and incorporated new functionalities. Developed new forms using Template.fmb (AU_TOP/forms/US).

Imported compensation data from Legacy system to Oracle. This process includes loading data from flat file to temporary table using the SQL * Loader, validated the temporary table data and moved to the Interface table.

Develop and Review of project documents MD50,MD70,TE20.

Analyzing all the account setups and custom components to identify impact with CoA upgrade.

Developing mapping files between old CoA and new CoA, as input to EprentiseFlexfield software.

Reconciliation of standards reports pre and post CoA upgrade.

Complete end to end functional testing to check system functionality pre and post CoA upgrade.

Letshego Holdings Limited Oracle Apps Implementation, India(Apr’12 to Jan’13)

Role: Oracle Apps Technical Consultant

Contribution:

Organization wide Consolidate General Ledger across seven countries

Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to BI/XML publisher.

Developed Orders/Parts with Shortages Report in manufacturing and materials using BI/XML Publisher.

Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into GL Interface tables.

Created the necessary objects (Interface table, Control file and concurrent program) for Service contract SC interface.

Developed Tax Benefit Recipient Interface and report, Credit Card Transactions interface in Internet Expenses/iExpenses module using Reports 6i, BI/XML Publisher and Discoverer.

Customized existing Dunning report in Account Receivables using BI/XML Publisher.

Customized the standard workflow to send notification to the customer before invoicing.

Automated the process of migrating Data Definitions and Templates from Instance to Instance.

Developed several Unix Shell Scripts to Transfer files from one server to another server, UNIX to mainframes etc. during interfaces and conversions and used them as wrapper programs.

Involved in various Bug fixing issues and immediate Defect resolving issues in Account Payables, General Ledger, PO, and iExpenses Modules.

Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using HP/Kintana Migration tool and through FNDLOAD scripts.

Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.

Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.

Developed a program to load external data from legacy system into PO_HEADERS_INTERFACEand PO_LINES_INTERFACE.

Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

Developed a program to inactivate the vendors.

Worked with Sales Order Open Interface in Order Management module to import Sales Orders from flat files.

Responsible for Order import using Order Management OE_ORDER_PUB API to update sales order into respective base tables.

Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Motorola Solutions Inc., Supply Chain Program Transformation,India (Aug’11 to Apr’12)

Role: Oracle Apps Technical Consultant

Contribution:

Customized the seeded reports and created the new reports which suited the business requirements.

Registered the new BI/XML Publisher report as concurrent program.Conversion of Oracle Discoverer Reports to BI/XML Publisher Reports like 5 Year Sales Order Report, Gross Sales Analysis Report and Sales by Category Report.

Create SQL Purge Scripts to clean out outdated and erroneous data based on business rules

Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance, and ECO Report. And changed the output format to XMLand created new templates for XML Publisher to display in pdf or Excel Format.

Developed Custom BI / XML Publisher reports for On-Hand-Quantity available for all the items in every Sub-Inventory which belonged to a particular Organization in the Inventory module.

Developed Supplier Audit Report and Bank Audit Report using the Audit Trail functionality in Accounts Payable (AP) and using XML/BI Publisher.

Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.

Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.

Develop Test Scripts based on the understanding of the Customer Requirements from development requirements

Interact with the Developers to understand the functionality and perform quality testing on the components.

Review the Test Scripts of the other Team members and post review comments.

Resolving issues raised by customers, doing root cause analysis whenever necessary and preparation of user training docs.

Mahindra Satyam Computer Services Limited

GENERAL ELECTRIC, GAMS Enhancement and Support, India (Mar’10 to Jul’11)

Role: Oracle Apps Developer

Contribution:

Understanding the report functionality, analysis and review of High Level Documents mainly MD 200s.

Oracle Apps Technical Consultant for enhancement and support project.

Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR and GL.

Involved in the analysis of the assigned support tickets including replicating the issue, analysing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.

Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.

Closely worked with users to understand business needs and objectives.

Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.

Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).

Expertise in implementation of procures to pay life cycle.

In user edition, developed various crucial financial analysis reports (for all modules) forAP/GL/OM/PO/AR using Oracle Discoverer 10g.

Developed validation packages to Load data to interface tables (OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_CUSTOMER_INFO_IFACE_ALL)

Customized forms using custom.pll to change the functionally of the standard forms.

Customized Sales Order form to add customer fax, email and phone number contacts.

Customized the existing forms with descriptive flex fields.

Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software.

Developed AP Positive pay Extract Reportin Oracle Payables which will extract the Canadian transactions from source systems and sent to bank.

Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher.

Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.

Customized Vendor Minority Custom Report, AP Check print report, Standard Packing Slip report.

Developed a Custom Invoice Duplicate Report (PL/SQL package) for the AP Payables Manager to verify the INVOICE Duplicates from Vendors and Validate against the checks paid for the INVOICES. Used UTL_FILE utility to generate PIPE-delimited format outputs for AP Team.

Worked on the Email notification program to notify the users on recent customer creation failure in Accounts Receivables using Workflow Builder.

Worked on Form Personalization in Order Management.

Developed customer conversion program to load the customers from legacy system into Oracle EBS System by using the TCA APIs.

Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.

World Health Organization, Apps Implementation, India(Aug2008-Mar2010)

Role: Oracle Apps Developer

Contribution:

Understanding the report functionality, analysis and review of High Level Documents mainly MD 050s.

Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP, GL.

Implemented AP Invoice import through Payables Open Interface Import Program.

Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR_PAYMENTS_INTERFACE_ALL), from interface table to the Base Interim tables and finally to the base table.

Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.

Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).

Implemented several custom logics for Form Personalization using ZOOM Functionality.

Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to$AU_TOP on forms server of client.

Developed Cash flow summary report, Cash flow detail report, PA_rev_monthly report, PA_rev_monthly_budget report, and Inventory aging report and Asset register report.

Customized AR-CE Bank Reconciliation Batch Info Report.

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. Its displays the discount amount calculated for that order basing on the payment terms of the order.

Developed custom templates for the invoice reports by calling sub templates in XML/BIPublisher.

Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.

Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.

Education:

Computer Science and Engeering(B Tech Jawaharlal Nehru Technological University

Contact this candidate