TECHNICAL SKILLS:

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

Database: Oracle 11g, 10g, 9i, 8i, 7.3, SQL 6.5 and Access.

Tools: ets Jdeveloper 10g, 11g., OA Framework, (OAF), Developer/2000 - Forms 4.5,6i, Reports 2.5,6i and 10g, (BI Publisher) XML Publisher, Discoverer 9i,10g, Informatica 6.2, 7.1, 8.1 SQL*Loader, Workflow 2.6, Confidential, Oracle Support.

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

Middleware: Oracle Fusion Middleware 10g and 11g. SOA, OSB, Mediator, WSDL,BPEL and BAM.

Environment: Unix, AIX, Linux RHEL 4.0, Mac OSX, Windows NT, Windows XP, Vista and DOS

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 Office, Open Office, Subversion,Git, Ant, PVCS, Kintana, Stat, TOAD, SQL-Developer.

EXPERIENCE:

Confidential, CA

Sr.Oracle Developer

Responsibilities:

• Wellness assessment for new support as well as for R12Upgrade.
• Documentation of current processes as well interface, customization and custom object.
• Discussing with client their existing process, and recommending best practices and showing tools which are not currently used for time saving.

Confidential, Sunnyvale, CA

Sr Oracle Developer

Responsibilities:

• Customizing Oracle Ebusiness Suite, using CEMLI framework, and Oracle Tool sets.
• Extracting data from AP and Purchasing module to Anaplan for creating dashboard.
• Involve in Procure to Pay (P2P) upgrade project. Modifying Purchasing, Payables, and Inventory RICEW elements.
• Creating Positive Cash and Check Printing programs and file, according to new Payment Profile.
• Creating Purchase Order reports and customization.
• Upgrading Oracle Ebusiness Suite Financial and Supply chain application from 11.5.10 to 12.2.5
• Remediation of invalid object after upgrade.
• Migrating rdf reports to OBIEE report.
• Creating new reports with Sub Ledger Modules, for reconciliation.
• Creating custom table to MOAC enabled.
• Created sql queries to csv and Excel reports, with multi tab report.
• Migrating Discoverer reports to OBIEE reports.

Environment: Oracle Applications 12.2.5, 11.5.10.2 Oracle Modules (GL, SLA,FA, AP,PO,PA and AR).

Confidential, Aliso Vijeo, CA

Sr Oracle Developer

Responsibilities:

• Integration of Oracle Ebusiness Application with Salesforce (SFDC), Zuora, Siebel and Licensing application using Oracle Fusion Middleware
• Integrating Oracle Ebusiess Receivable module Invoice and Receipts using api, for Salesforce (query and update Customer and Invoice Objects )and Zuora and Database call to Oracle and Siebel system using BPEL and Weblogic components.

Environment: Oracle Applications 12.1.3 Oracle Modules (GL, SLA,FA, AP,PO,PAand AR). Oracle Fusion Middleware Weblogic 11g.

Confidential, Los Angeles, CA

Oracle Financial Developer

Responsibilities:

• Procure to Pay (P2P) Customization., Positive Pay and EFT payments.
• Customizing Oracle Ebusiness Suite, using CEMLI framework, and Oracle Tool sets.
• Developing AP related custom design and development for Checks, Positive Pay and EFT payments.
• Creating Accounts Payable Invoice Upload Process, with validation, launching Invoice import process.
• Upgrading existing custom objects, Forms and Reports to R12.2.4.
• OAF
• Personalized/Customized OAF pages in Project Expenditure implemented PPR,
• Substituted/extended the seeded regions, COs & VOs and extending LOV's.
• Calling Packaged Stored Procedure and BI publisher report

Environment: Oracle Applications 12.2.4 Oracle Modules (GL, SLA, FA, AP, PO, PA, GMS)

Confidential, Los Angeles, CA

Oracle Financial Developer

Responsibilities:

• Developing report for GL and Sub Ledger (SLA) Reconciliation with sub ledgers like, AP, AR, PA and Grants.
• Development of various report related to Grants Accounting and Project Accounting using Oracle Discoverer.
• Developing custom Forms 11g for Grants and Project Accounting along with personalization.
• Developing custom WebADI solution for AP Invoices and AR Invoices.
• Creation of Check printing and AR/Grants Invoice using BI Publisher.
• Development for Capital and Operational Baseline Budget uploading and submission using API.

Environment: Oracle Applications 12.1.3 Oracle Modules (GL, SLA, FA, AP,PO,PA,GMS)

Confidential, Sacramento, CA

Oracle Financial Developer

Responsibilities:

• Customizing Oracle Ebusiness Suite, using CEMLI framework, and Oracle Tool sets.
• Conversion from Legacy system to Oracle Items, Item cross reference, Items Attachment, Bill of Materials, Enterprise Asset Management, Asset Number, Migration, Asset Groups, and Asset Attribute Values.
• Involved in total integration of Procure to Pay, from Project Accounting to Payables, Purchasing to Payables.
• Developed interface components to support other systems such as Hyperion, MPM
• Development of interfaces for Freight, Labor Hours, GL Stat Journal entries and interface with 3rd parties for Temp Labor Dollar and Hours in Project Accounting.
• Custom WebADI integrator for AP Invoices, with validation and running concurrent program.
• Created Oracle Alerts for Enterprise Asset Notification and changing EAM attributes.
• Customizing Account Generator for Accounts Payable with POET validation.
• Synchronizing Oracle Items with TeamCenter application.
• Customizing Check Printing and Positive Pay program to accommodate US and Canadian Standards.
• OAF
• Developed on Demand Label for WIP jobs and Receiving Transactions screens using OA Framework, creating EO, VO and PPR for validation.

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

Confidential, El Segundo, CA

Oracle SOA-Application Financial Developer

Responsibilities:

• Oracle SOA Suite 11g, EBiz. 12.1.3, DB 11g
• Interface with FTP and file adapters with clients Data 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 customized Template 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 Data Template, Package and Layout Template.

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

Confidential, Irvine, CA

Oracle Techno-Functional Analyst

Responsibilities:

• EBiz. 11.5.10.2, DB 10.2.0.4
• Project Billing/Costing with Order management.
• Implemented Project Accounting Billing and Costing, with customization from Order Management.
• Implemented profiles, setups from the requirement done
• Developed custom program to gather information from Order and creating Project, Task, Agreement, Funding, Budget and Events.
• Personalized the Order form to create Purchase Order from Order Management.
• Customized the Workflow to enable various customizations.
• Created custom packages and common utility, to enhance modularity for above customization.
• Created BI Publisher reports and Form Personalization, calling custom Forms and procedures.
• Confidential Intelligence.
• Implemented Confidential Intelligence, requirement gathering and implement with 5 dashboards.
• Training Users in CRP, and rolling out in Production.
• Developed Fast Formula for Life Insurance and defining skip rules, specifying rules for PTO Plans, accrual rates for New hire, Coverage date rule
• Creating EIT, created custom tables to store values and error messages.
• Invoking Fast Formulas using PL/SQL
• Creating Fast formula for validating OTL Weekly and Daily Hours.

Environment: Oracle Applications 11.5.10.2 Oracle Modules (GL,HRMS, OAB, PA,OTL)

Confidential, Seattle, WA

Oracle SOA-Application Developer

Responsibilities:

• SOA 11gR3 Oracle EBiz 12.1.3
• Interface Development
• Conversion of Project, Task and Expenditure from Legacy using API’s.
• Creating necessary report for conversion records for Project Accounting related entities.
• Developing Project Accounting, Budgeting and Expenses Interface using flat file form Legacy system using BPEL, XML and XPath functions.
• Expertise in developing and deploying BPEL Processes using technology adapters (Oracle Applications, DB Adapter, File Adapter, FTP Adapter), Fault handling (catch and catchall), Messaging and Alerts and Transformations.
• Based on file pattern and user criteria for CSV, Web Service or Flat file and on ad hoc basis, or scheduled basis.
• Creating security policies in BPEL.
• Created Error Handling Standard Framework across the board to be consistent with all development.
• Using subversion for Versioning.
• Using Ant Deployment script for Migration for full SDLC cycle.
• Performance tuning to Weblogic server, maintaining instances based on business rules, un deploying older instances and BPEL processes.
• Creating SOA standards for file naming, and activities naming.
• Creating conversion using api for creating POETA (Projects, Org, Expenditure, Tasks, Awards, Installment and Project Funding)
• Conversion also using API’s for Budget Baseline

Environment: Oracle Applications 12.1.2 Oracle Modules (GL,HRMS,OAB, PA)

Confidential, Irvine, CA

Oracle SOA-Application Developer

Responsibilities:

• 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 database 11g and Microsoft SQL database in order to transfer data.
• 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 Data 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
• 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 interfaces,
• Develop and implement inbound and outbound interfaces using Oracle XML Gateway,
• Oracle 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
• XML Gateway Maps.
• Created Orders in Ebusiness using API’s, and booking it.
• Applying payment to the relevant order based on payload.
• Created various reports for Order and Accounts Receivable.
• Creating web pages using PL/SQL Web Toolkit. Web pages to monitor Order to Cash flow from different warehouses, also across other heterogeneous services.
• Customizing the Oracle reports and Forms with Financials, Distributions and Process Manufacturing.
• Created various custom forms and report in Confidential, replacing oracle forms and reports to substitute Excel and Access based reporting.
• Creating and Maintaining Discoverer reports for Data warehouse as well as for Oracle applications.
• Created labels using Loftware software.
• Synchronize OPM Items with Discrete Items using API, UPS Integration with WMS.

Confidential

Oracle Application Developer

Responsibilities:

• Oracle 12.0.4, Database 10g
• Creating Tax related reports for filing Sales Tax Return purpose, US and Canada.
• Conversion and Validation of Customers and AR Invoices using API’s and Interface tables, for US and Canada Org.
• Conversion and Validation of Item Master and Categories,

Confidential

Oracle Application Developer

Responsibilities:

• Created Fast formula for various Payroll balance calculation, table to store first year hire by month.
• Creating rules for Advanced Benefits Eligibility, coverage starting after 30 days of first month.
• Debugging using Confidential variables. Registering custom functions.