SUMMARY

• Sanjay has successful 16+ years of Oracle Application implementation experience with small and large size projects.
• A hands - on implementation background in the areas of the financial as well inventory and purchasing modules gives his the ability to understand and be understood by users, stakeholders, functional, development, and technical support.
• Because of his under-standing of business and technical issues, as well as soft skills, Sanjay keeps the implementation project moving ahead by winning the support of the user community, and leveraging the capabilities of the system.

TECHNICAL SKILLS

ERP: Oracle Financials 10.7 Char, 10.7NCA, 11.03NCA, R11i, R12i, ebusiness suite.

D Confidential base: Oracle 11g,10g, 9i,8i,7.3, SQL 6.5 and Access.

Tools: ets Jdeveloper 10g, 11g., Forms 10g, Reports 10g, (BI Publisher) XML Publisher, Discoverer 9i,10g, SQL*Loader, Workflow 2.6, OBIEE, APEX, Oracle Support.

Languages: SQL, PL/SQL, XML, Java Scripting.

Oracle Modules: Oracle R11i and R12i, GL, AR, CM, CRM, AP, FA, EAM, HRMS, PY, PO, INV, OPM, WIP, BOM, OE, PA, GMS, OTL, AOL and Sys Admin.

Other Software: MS Office2007, Open Office, Subversion, Serena Version Manager (PVCS), Kintana, TOAD, SQL-Developer.

PROFESSIONAL EXPERIENCE

Confidential

Oracle SOA-Application Financial Developer

Responsibilities:

• Interface with FTP and file adapters with clients D Confidential Warehouse and Oracle Project Accounting and General ledger, for Inbound and Outbound interfaces.
• Created connection for DB adapter, as well as for FTP adapters.
• Created and customizedTemplate for WebADI and documentation for end users, to upload Project Accounting Transactions.
• Created web service using bpel, to be consumed by .net Framework.
• End point creation for item description, manufacturer name changes, not handled by Agile.
• Created BOM Departments, Resources, Routing overhead, UOM, UOM Class conversions by Org using api’s.
• Projects and Task Conversions from Legacy to Oracle.
• Project Extensions for revenue recognition, Billing and Costing.
• Creating BI Publisher Report. Converting Report 6i to BI Publisher, with D Confidential Template, Package and Layout Template.

Environment: Oracle Applications 12.1.3 Oracle Modules (GL, FA, AP,PO,PA,BOM,WIP,ONT)

Confidential

Oracle SOA-Application Developer

Responsibilities:

• BPEL, OSB and Fusion Middleware.
• Created web service from pl/sql packages and deploying them to SOA server, to be consumed by BPEL process orchestration.
• Used OSB to route the Order based on different countries.
• Used DB Adapters to integrate between Oracle d Confidential base 11g and Microsoft SQL d Confidential base in order to transfer d Confidential
• Expertise in using PL/SQL API’s, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter
• Developing XML Schema, Extracting XML from Oracle DB, Parsing and creation of xml document in db to store Order and Customer related information.
• Creation of xsd file and consuming WSDL to be used by BPEL process
• Embedding simple java program to call Microsoft SQL Server procedures.
• Point to point integration between Oracle Ebusiness 11.5.10.2 and web for Customer Creation and Order Creation and Booking..
• BAM reports creation along with D Confidential objects. Creating sensors in bpel process to create alert and resubmission of failed report in BAM.
• Created Error Handling Standard Framework across the board to be consistent with all development
• B2B Integration for Outbound Orders.
• Analyze and understand Business Unit Requirements and processes; Perform gap analysis.
• Develop implementation strategies and recommendations; configure and document interface file definitions and transaction layout definitions;
• Develop mapping specifications for all inbound and outbound interfacesDevelop and implement inbound and outbound interfaces using Oracle XML GatewayOracle XML Gateway, and client translator software;
• Understood full cycle workflows and interfaces; mapping, troubleshooting, testing, scripting and configuring
• Created B2B integration using XML Gateway using OAG72 Standard.
• Created Workflow Message Designer, and mapping source to target, codes conversion for UOM.
• Uploading map file xgm and dtd files
• Resolving issue related to errors.
• XML Gateway Setups for Trading Partners. Created Business events subscription on custom objects.
• Creating BPEL Process for Oracle Application adapters for Outbound

Confidential

Oracle Application Developer

Responsibilities:

• Creating MD50 and MD70 for Project Accounting related Reports as follow:
• Project Accounting to GL Reconciliation.
• Project Accounting Events Reconciliation.
• Project Accounting Revenue by Order.
• Created XML Publisher Reports with Dynamic Columns and totals.

Confidential

Oracle Application Developer

Responsibilities:

• Conversion of Charts of Accounts Value from People Soft to Oracle Financials.
• Conversion of PeopleSoft 25,000 Cross Validation Rule to Oracle Cross Validation Rule.
• Creating Daily Interface for Chart of Accounts and Cross Validation Rule from PeopleSoft.

Confidential

Oracle Application Developer

Responsibilities:

• Created Customized reports using FSG, for internal as well as External requirement using ADI toolset.
• Created Reports using Reports 6i for Accounts Payable, Accounts Receivable and General Ledger for customize Trial Balance with 7 buckets, with dynamic sort order.
• Design and Administered Discoverer for developing views and function to be used by end users.
• Creating TAR and fixing month end closing issues, as well as for daily problems.
• Created Project Accounting Oracle 11.5.9 following Client Extensions
• Conversion of Agreement and Funding from Legacy system using API’s and transforming d Confidential as per specification.
• Billing Cost Rate Override Extension, Capped Hourly rate by Contract.
• Commitment Transactions and its views, excluding Requisition from view.
• Fee Schedule Extension to calculate fee as a dollar cost per charge hour by
• Task, expenditure type and expenditure organization. Calculate fee as percent complete of a total project or total billing times total available not to exceed fee amount.
• Multiple Revenue Recognition & Invoicing Method on a Project.
• Exempt Employee Rate and Distribution of Labor Extension
• Creating following task for HRMS and OTL.
• Creating Customized Fast Formula for OTL validations for NCA, E40 and Salaried Employee.
• Creating custom library for Timekeeper screen for Validation of Employee.
• Conversion of Employee and Advance Benefits using API with various validations.
• Creation of following task for Workflow .
• Enhancing workflow for AP Invoice, Purchase Requisition, Purchase Order, Receipts, Expense Reports and OTL Notification with POET and Description fields using document type.
• Customizing Reports and Forms for Project Usage according to Business Requirements.
• Creating custom queries for Sarbanes Oxley Act from FND tables for the audit report
• For Accounts Payable, Accounts Receivable and General Ledger.
• Created Materialized Views for creating reports, which show Draft InvoiceExpenditure, Purchase Order, Line, Location and Distribution, Requisition Header and
• Lines, and Events related columns for ease of reporting.

Confidential

Oracle Application Developer

Responsibilities:

• Performance tuning support for post upgrade support for Oracle related Reports and programs and Custom Library.
• Conversion for Calgary Operation from JD Edwards to Oracle Financials for
• Project Accounting, Accounts Receivable, Accounts Payable and General Ledger.