SUMMARY

• Over 12 years of experience in Oracle e - Business Suite 11i, R12.1.3, R12.2.4 and Oracle Fusion HCM Cloud. Excellent working and conceptual knowledge of Oracle DB, PL/SQL, Developer Forms6i/10g and Reports6i/10g, Workflow, Discoverer Reports, OAF, XML Publisher Reports, WebADI Integrator, Oracle SOA 11g, and Oracle Cloud BI. Trained on Oracle ADF and Oracle Data Integrator 11g from Oracle University.
• Experience in leading the projects. Experience in Requirements gathering, Gap analysis, creating Functional requirement documents, Mapping legacy system data with EBS, creating Technical documents and Test case documents. Experience in designing and developing interactive Forms and Reports using Oracle Forms 6i/10g and Oracle Reports 6i/10g.
• Experience in developing and customizing the Extensions, Interfaces, Conversions and Loading data using Fusion FBL & HDL. Experience in XML technologies and SOAP/REST web services development. Working knowledge of UNIX Shell Scripting.
• Experience in ETL tool, worked on Trillium software for identifying suppliers and customers data quality issues of a big enterprise. Having very good functional exposure and working knowledge of Oracle Financials, Oracle Supply Chain Management, Pricing, Trade Management, iExpenses, Oracle Projects Accounting, Oracle Grants Accounting, Core HR and Fusion Cloud HCM.
• Having very good knowledge of process flows Oracle Order-to-Cash, Oracle Procure-to-Pay, Pricing Customizations, Project Billing, and Project Costing. Experience in supporting business on financials period closing activities. Experience in configuring and customizing AME approvals for the iExpenses, Purchasing and, other fusional areas.
• Experience in supporting the functional team in system configuration, planning CRP, UAT and cutover activities. Experience in Offshore-onsite model, coordinating with project teams, tracking process, reviewing technical challenges, tracking issue logs & change requests, reviewing efforts and mitigating schedule deviations.
• Good at self-learning capabilities and, Multi-Tasking. Experience in giving s and mentoring entry consultants. Excellent Logical and Analytical Skills, Enthusiastic, and good Interpersonal Skills.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 95/98, Windows 2000, XP and Win 7

Language: Pascal, COBOL, C, C++, Java and JSP

Tools: Forms 6i/10g, Reports 6i/10g, PL/SQL, SQL *LOADER, Workflow Builder, XML PUBLISHER, WebADI integrator, Discoverer Reports, JDeveloper 11g, XML, XSD, XPATH and XQUERY.

Fusion Middleware: Oracle SOA 11g, ADF, ODI 11g.

RDBMS: Oracle 8i/9i/11g

ERP: Oracle e-business Suite 11i/R12 - GL, AR, OM, PA, AP, PO, INV, BOM, GMS, QP, FA, OZF, TCA, SLA and Fusion Cloud HCM.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Fusion Cloud Consultant

Responsibilities:

• Worked on integrating the Fusion Cloud and R12.2.4 Shared HR to sync the employee information. Worked on integrating Oracle EBS and Service-now to auto create the service requests for initiating access provisioning & removal upon new employee hire and term actions respectively.
• Worked ACH Payments interface program. Assisted AD team and worked on integrating Oracle Cloud BI and AD using BI and HCM web services.
• Designed and developed HCM Payroll batch loader file transformation fast formulas to upload the ADP hours and other elements information into HCM. Worked on several OAF iExpense page customizations.
• Designed and developed the user auto-provisioning extension to add/update/disable/reinstate the application user login accounts along with set of responsibilities in the current R12.2.4 Financials system when the employee hire/rehire/termination event occurs.
• Coordinated with Oracle Fusion Support team on integrations connectivity for both cloud fusion inbound and outbound interfaces.
• Designed and developed Fusion Cloud BI Report for CIGNA integration. Designed and developed Fusion Cloud BI Report for BSwift integration. Designed and developed Fusion Cloud BI Report for Fidelity integration.
• Configured AME custom purchasing approval rules based on the job-level and override job-levels defined in hcm.

Confidential, Nashville, TN

Senior Technical Consultant

Responsibilities:

• Designed and developed Singapore Tax invoice XML Publisher report for print the tax invoice report for certain Singapore streams, this would be sent to customer along with contract booking documents.
• Designed and developed Credit Risk XML Publisher report, as required for the Bank of France. Designed and developed France Basil extract, which extracts contracts and assets information from OLFM system to update in Access database.
• Designed and developed contract reconciliation program to compare the original InfoLease system contract data with converted OLM data. The Column level comparisons excluding the financial related data would be reported.
• Customized the PO Approval Workflow to in corporate customer rules for approval notifications, submitting concurrent requests, and attaching the request outputs in the approval notifications.

Confidential, Tempe, AZ

Senior Techno Functional Consultant

Responsibilities:

• As an EBS techno-functional assisted the SMEs and OCS PeopleSoft implementation team. Mapped EBS data model to the PeopleSoft data model for converting Vendors, AP invoices, and GL Balances and Fixed Assets data.
• Provided the GL Balances data extract from EBS 11i system. Analyzed all the business scenarios of Assets data and provided the Assets data extraction as per the interface data structure in PeopleSoft system.

Confidential, Waukesha, WI

Tech Lead.

Responsibilities:

• Designed and developed approved suppliers list data extraction and conversion program. Designed and developed price lists data extraction and conversion program.
• Created suppliers and banks conversion functional document and defined the mapping with SFM legacy system.
• Worked on proof of concept for specific business requirement related to Oracle Configurator. Prepared Interface and Conversion Strategy documents.
• Prepared the system integration strategy document to integrate all the legacy systems with the new global instance.
• Reviewed design documents and code builds developed by offshore tech team. Coordinated with offshore management in finalizing the tech effort and getting the estimates for all the functional requirements.

Confidential, Philadelphia, PA

Tech Lead cum Developer.

Responsibilities:

• Worked on the forms personalization and OAF page personalizations to hide the POETA fields in AP, PO, REQ and GMS forms and pages.
• Designed and developed PennERA to GMS s, Installments and Budgets Interface programs.
• Designed and developed GMS s Events interface program.
• Prepared design documents for AR Invoice Print Reports and Dunning Letters
• Worked on custom form for tracking the Sponsors Report Logs.
• Worked on the custom form for the action history generated by custom grants approval workflow process.
• Designed and developed GL Cost Center - HR Org Sync program customization.
• Designed and developed the new custom program for defining HR Org hierarchy and adding the “Project Organization” as the org classification.
• Assisted business in first period closing activities after being live in new modules.

Confidential, El Paso, TX.

Tech Lead.

Responsibilities:

• Designed and developed Price Lists and Modifiers conversion program, excluding the Trade management promotional related price lists and modifiers which might otherwise duplicate the data by trade management conversions.
• Designed and developed 15 table TCA data extract and “as-it-is-all-column” conversion of customers, contacts, banks, relationships, and customer profiles data as per the target system business process rules. Managed the team of 7 technical resources and 2 functional resources.
• Developed the project plans for executing and controlling the project. Executing the project in compliance to CMMi level 5 Project Management processes.
• Estimating the offshore technical efforts based on requirements. Reviewed design documents and code builds. Prepared and shared the project status reports to Onsite PM and offshore PM.
• Closely monitor project activities for conformity to contract scope provisions and tracking the status of each CEMLI.

Confidential

Senior Consultant

Responsibilities:

• Worked on upgrading various Project Accounting custom reports to R12.
• Worked on upgrading custom Account Generators for Payables, Expenses and Project Accounting.
• Worked on upgrading several Discoverer reports.
• Assisted functional team in analyzing upgrade issues on several OAF Pages and Forms.
• Worked on several OAF Page personalizations.

Confidential

Senior Consultant

Responsibilities:

• Worked on WIP OSP Automation interfaces that automate Move Transactions, Assembly Completion, WIP Issue and PO Receipts Creation.
• Worked on Broker Commission BI Publisher Report which calculates the Broker’s commission based on the data gathered from different sources like Receivables, Order Management, Account Payables and Trade Management.
• Worked on TCA customer data conversion. Worked on AR Invoices and Receipts Conversion. Worked on SPIN Sales Orders Conversion, which includes creating Sales Orders, RMAs along with Modifiers which will identified by calling Pricing Engine APIs as per business logic.
• Worked on WIP OSP (Out Side Processing) interfaces, which includes three different programs for WIP Move Transactions, WIP Completion Transactions and OSP PO receipts loading. Created several SLA custom functions.

Confidential

Senior Consultant

Responsibilities:

• Designed and developed custom sync interface programs between EAM and FA
• Designed and developed custom sync interface programs between EAM and INV.
• Designed and developed Positive Pay interface.
• Designed and developed Inventory Item and Inventory on-hand conversions to load the legacy data.
• Designed and developed the EAM Asset Meter Sync program.
• Designed and developed the Pason (legacy) to OTL inbound interface program.
• Customized Projects labor Costing Extension to implement business specific cost derivation rules.
• Designed and Developed the XML Publisher Project Invoicing reports.
• Designed and Developed the XML Publisher EAM Asset reports.

Confidential

Senior Consultant

Responsibilities:

• Worked on the Project Contracts form customization for the tracking changes made to contract lines through the change management.
• Worked on the Cost plus project Billing Extension. This extension creates billing and revenue events and adjustment events when the Credit Draft invoice is created.
• Worked on Project Forecasting Revenue extension, to change the revenue Bill Rate of Resource Assignment based on custom logic.
• Worked on Labor Costing Extension. Worked on JSR (Job Summary Report) which extracts cost, burden cost, revenue, commitments and budget information of projects and produces six different reports on single run.
• Worked on 1034 & 1035 Project invoicing reports and Project Contract Briefing report. Worked on iExpense approval AME configuration.
• Worked on iRequisition approval AME configuration. Worked on two new custom forms.

Confidential

Senior Consultant

Responsibilities:

• Designed and developed VSOE (Vendor-Specific objective evidence), Custom Revenue Recognition Program for TEKELEC.
• Designed the creation of custom Deal Form. Designed and customized the Oracle standard Order line workflow to in corporate VSOE customization which creates deals and deal lines.
• Designed the Custom Auto Accounting program. Designed and developed 15 VSOE custom XML Publisher reports which show output in MS Excel.

Confidential

Senior Consultant

Responsibilities:

• Developed the Price List Update Extension (WebADI), which would be used in updating, creating and adding new price list lines (LINE PRICING, BREAK PRICING) to the existing price lists. This extension has following objects.
• OAF Page.
• Web ADI Upload Integrator with PL/SQL package to validate and load price list lines.

Confidential

Senior Consultant

Responsibilities:

• Developed Conversion Programs
• Inventory items Conversion.
• Items Category and Cost conversion.
• Items On-Hand quantity conversion.
• Service Contracts Conversion.
• Customized the Oracle Order Management Standard workflows to include custom processes which includes Sending Notification to the Order Creator and to all the Sales Persons of the Order upon booking the order with the attachment of Sales Order Acknowledgement report output which will also be triggered by the process just before sending the notification.
• Sending the Notification to Project Manager upon ship confirm of the order with the attachment of Packing Slip Report which would submitted by application after shipping confirmed. This notification also has the message body in which all the lines with Tracking Numbers of shipment.
• Sending Notification to the User on pass of RMA grace period over the related expected receipts from the customer and halt functionality to pause the order process until the related project’ revenue has been triggered. Developed and customized several HR ADP interfaces.

Confidential

Staff Consultant

Responsibilities:

• Worked on the Interface to create Blanket Sales Agreements in OM for the Projects created and approved in Oracle Projects.
• Worked on the interface to update Blanket Sales Agreements in OM for the updates to the projects which has already been interfaced to OM.
• Worked on the interface to create releases for the Blanket Sales Agreements based the updates in Project level and Task Level UDAs.
• Wrote a wrapper PL/SQL program to submit the Blanket Sales Agreement interface from the Projects HTML page for the UDA Action button.
• Worked on Creating the Invoice Events and Revenue Events for the lines in Sales order form. The workflow process “Order Flow - Generic” has been customized to accommodate this functionality to make it run before booking the order.
• Worked on the program to progress the task based on the user inputs to UDA field in Projects.