SUMMARY:

• Over nineteen years of experience as a Software Professional in the field of Information Systems, with an emphasis on Client - Server/Internet Application Development and programming, relational database design, development and implementation.
• Extensive experience as Senior Techno Functional Consultant st in Oracle Fusion HCM, Financials and CRM/Sales Cloud Applications of recent versions and R13 EBS Application modules HRMS/HCM, Account Payables, Account Receivables, Cash Management, General Ledger, Order Management, Shipping Execution, Purchasing, Project Accounting, Service Contracts, Install Base, Sales and wide use of SQL, SQLPLUS, PL/SQL, Packages, Procedures and functions.
• Very Strong technical skills and expertise in all Oracle Tools such as SQLPLUS, PL/SQL, Forms 10G, Reports 10G, Workflow, BI Publisher, SQL*Loader, Java, SOA, OAF and ADF. Familiar with Oracle database, Architecture and its Security concepts.
• Strong interpersonal skills, ability to interact with people at all levels, good communication and presentation skills. Certified Oracle OCP.

SOFTWARE SKILLS:

RDBMS: Oracle7.x to 11G, MSSQL6.5, 7.0.

Software: Oracle EBS Apps, Fusion Apps, Oracle DBA, SQL, PL/SQL, Java, JSP, Clarify CRM.

Front End Tools (GUI): Forms 10g Reports 10g BI/XML Publisher, Workflow Builder, JDeveloper, OAF, ADF, SOA, SoapUI

ERP: Oracle Applications (Financials, HRMS, CRM, SCM, WMS, OPM and Manufacturing)

Operating Systems: Windows Server, HP Unix, Sun Solaris, Linux, AIX UNIX

EXPERIENCE:

Confidential, Simi Valley, CA

Oracle Fusion HCM Cloud Consultant

Responsibilities:

• Working on Taleo - HCM integration design to develop the interfaces OIC, REST APIs and custom hybrid cloud solutions.
• Developed the HR and Benefits interfaces to send the enrollments data to the vendors using the HCM Extracts, Fast Formulas, eText templates and BI Reports.
• Worked on new Benefits Fast Formulas for AV Benefit plan requirements.
• Worked on the customization of the seeded Talent Profile reports.
• Worked on development of new Audit reports and Analysis reports in OTBI
• Worked on the customizing Approval/Email notification processes.
• Worked Personalizations using the Page Composer.

Confidential, Pleasanton, CA

Oracle Fusion HCM Cloud Senior Techno Functional SME

Responsibilities:

• Working on interfacing the HCM data using HCM Extract tool and BI Publisher E-Text templates, to Hadoop Datawarehouse systems from where HR foundation, HR Demographics, Benefits, Payroll, Time & Labor and other data will be sent to the Kaiser’s internal applications and to the external vendors.
• Working on the HCM Data Loader (HDL) tool to load various objects like Jobs, Employees, Contingent Workers, Talent profiles, Payroll Assignments, Element Entries (Sign-on Bonus, Union Deductions).
• Working on Taleo TCC configurations for interfacing the Foundation data, Requisitions, and New Hire/Rehires onboarding data to HCM using the HCM Extracts and HDL tools.
• Worked the HR, Benefits interfaces to send the employee demographics, enrollments, total compensation data to the vendors using the HCM Extracts, eText templates, BI and OTBI Reports.
• Worked on Fast Formulas for HR, Benefits, Payroll and HCM Extracts Rules per the Kaiser’s requirements.
• Working on interfacing the vendors, Payroll GL Costing, Garnishments, invoices, and other payments to AP with Kaiser’s financials application.
• Working on the HCM REST APIs and ATOM feeds for the real-time interfaces with applications like Taleo onboarding management tool and Kaba Time keeping application.
• Worked on Proof of Concepts (POC) using various tools HCM Extracts, HDL Loader, BI Report web services, REST and ATOM feeds for interfaces like HR Demographics, Benefits, Taleo and other application integrations.
• Worked on configuring the KFFs, DFFs, UDTs, Fast Formulas to use in HCM extracts as part of the POCs.
• Worked on Proof of Concepts (POC) on extensions like Payroll Audit using the PaaS JCS, DBCS, ADF pages, ADF BC services and BI Reports.
• Worked on customizing the pages using the Page Composer tool to display the Payroll messages and to add the web links to the ADF pages in the above POC.
• Worked on configuring the Fusion BI Publisher delivery options like email, SFTP.
• Worked smoke tests on the newly provided/upgraded PODs to verify any functionality breakages, navigations and basic configurations in all the HR modules.

Confidential, El Segundo, CA

Oracle Fusion Cloud Applications Senior Consultant

Responsibilities:

• Custom Interfaces and processes development using PL/SQL and Oracle APIs.
• Data Conversion and data validation programs development using SQL Loader, PL/SQL.
• Development of data fix scripts for Production issues using SQL and PL/SQL.
• Complex custom forms, OAF and ADF pages development, customization for standard forms using Oracle Forms 10g and JDeveloper tool.
• Custom report development for internal use and customer facing documents using Oracle Reports 10g and BI/XML Publisher
• Customization of Workflow processes for modifying the business process flow and for complex business documents approval process.
• Inbound and Outbound EDI Processes, mappings and other required customizations.
• Integration of client applications with Oracle EBS using JAVA packages and Integrated SOA Gateway web services.
• Integration of 3PLs and 3rd Party Shipping applications like Nexxio, Kewill by consuming their Web services using Java and PL/SQL packages.
• Working on redesigning the EBS inbound and outbound interfaces to the Fusion Financials using the standard File Based Data Import(FBDI), ADF Web Services and other Utilities.
• Working on redesigning the EBS inbound and outbound interfaces using the custom programs in PaaS DB Cloud Service (DBCS) and Java Cloud Service (JCS).
• Working on migrating and redesigning the Fortis EBS custom application (HCPCS) to ADF Pages in Java Cloud Service (JCS) and PL/SQL programs in PaaS DB Cloud Service (DBCS).
• Working on data conversions from EBS to Fusion Financials and HCM using the standard FBDI templates.
• Working on the interfaces from Fortis’s in house ADP/EV5 application to load the employees, direct deposit information and bank accounts using the HCM data loaders and Payroll batch loader.
• Worked on integration of Fusion Applications with PaaS(DBCS/JCS) cloud services using the Java, Web Services, PL/SQL Packages.
• Worked on defining the custom objects, forms using Application Composer, ADF Pages.
• Worked on automatic creation of Contracts from Opportunity from Sales Cloud into Enterprise Contract Management using the Groovy code and Application composer objects.
• Worked on custom triggers for enforcing the business logic on the standard and custom forms using the Groovy
• Designed and developed the generic custom Java Utility program in Window environment for automating the FBDI data file imports to the UCM/Fusion by using Financial Utilities Webservice.
• Worked on the Legacy data conversion like Sales Accounts, Customer data, Contracts, Employees and other data.
• Worked on AP Suppliers Import to create the supplier records for the Contingent Workers onboarded in HCM and Taleo.
• Worked on AP and AR Invoice interfaces to create the invoices for their customers and Independent Contracts extracting the Customer/Supplier records from Fusion to PaaS Database and developed custom invoice creation process using the PL/SQL program.
• Customized AP Check print, PO print and other customer facing documents.
• Developed BI/OTBI custom reports to send the output files using SFTP and Email delivery configuration.
• Worked on the Transmission setup, payment profiles in Fusion Payments to automatically transmit the files to Bank of America’s SFTP server.
• Worked on establishing and automating the processes for the AR Lockbox, Positive Pay, Bank Reconciliation statement and Visa Expense cards transactions feed VCF4.0 format using SFTP and HTTPS servers.
• Designed and developed the generic custom Java Utility program in UNIX environment for automating the FBDI data file imports to the UCM/Fusion by using Financial Utilities Webservice.
• Worked on the Legacy data conversion like Customers, Vendors, Open AR and AP Invoices.
• Worked on integrating Gander’s edge systems like RMS, Auditworks with Fusion Financials Applications using the BI Reports and FBDI/custom Java Utility.
• Customized AP Check print, PO print and other customer facing documents.
• Developed BI/OTBI custom reports to send the output files using SFTP and Email delivery configuration.
• Worked on the Transmission setup, payment profiles in Fusion Payments to automatically transmit the files to Wells Fargo Bank’s SFTP server.
• Worked on Fusion HCM and Paychex Interfaces, conversion, and extracting the detailed employee data from HCM and sending it to Paychex periodically.
• Worked on the upgrade and re-implementation of 11i CEMLI objects to R12.2.3.
• Worked on AP Invoice interface to import EDI 210 transactions.
• Worked PO Line Item Description update process to update it when it is update Agile/PIM using the Item Update Business Event.
• Worked on O2C process for EDI 850 Orders, customizing the interface processes, handling the discounts coming ChRM.
• Developed AR Receipt Import process using the Receipts APIs to import the customer receipts.
• Worked on setups in R12.2.3 EDI e-Commerce gateway module like setting up site level profiles and Trading Partners for EDI transactions POI/850, POCI/860 and INO/810, and on other EDI transaction 852, 856, 940 and 945.
• Worked on Custom Migration/MD120 tool, custom process to upload Menus/Responsibilities using Java, OAF pages and PL/SQL.
• Worked on redesigning the custom POS module using the Web Logic/SOA process.
• Worked on custom module for managing EDI 852/POS data, which is being used by ETL/sales analytical tools like OBIEE and Cognos.
• Worked on developing the custom processes and design documents in all the modules.
• Worked on the customers, AR Invoice, Vendors and AP Invoice interfaces.
• Worked on the customer reports in AR, AP, FA and GL.
• Managed the offshore technical team by allocating them the tasks along with the design documents and delivering the customizations to Cronos IT team.
• Created custom reports based on standard GL Trail Balance Report to provide the output in CSV files to the Hyperion team. Developed these reports using XML Publisher and e-Text utilities.
• Developed conversion programs for converting the legacy data from Great Plains (Microsoft Dynamics) ERP application.
• Integrated Nexxio X-Carrier Application with Supply Chain/shipping modules to get the Carriers Shipping Quotes using Java/PLSQL APIs.
• Developed custom reports in OM, Shipping, AP and AR modules.
• Worked on XML Publisher Bursting for sending the emails and generating the output files in file system.
• Worked on Form Personalizations to add the functionality for printing the reports and calling Nexxio X-Carrier Web Services.

Confidential, Oklahoma City, OK

Lead Techno functional consultant

Responsibilities:

• Implemented Integrated SOA Gateway to develop the interfaces using the Web.
• Designed and developed custom Sales Order interface using the Web Service in Integrated SOA Gateway for interfacing the customer orders created in QuiBids e-Commerce.
• Designed and developed EDI and other custom interfaces using the Web Service in Integrated SOA Gateway.
• Developed custom process for selecting the Lowest Cost Vendors for Drop Ship orders.
• Integrated Kewill Flagship Application with Supply Chain/shipping modules to get the Carriers Shipping Costs using Java/PLSQL APIs.

Confidential, Hebron, KY

Lead Technical consultant

Responsibilities:

• Developed Cross-ship and Warranty Labor extension for Field Service and Depot Repair modules for the Service Request created for Repair/Replacement of OEM parts.
• Developed custom AP Aging Report to have feature of running the report with “As of Date”.
• Worked OA Framework Personalization to personalize Item Instance pages in Install Base.
• Worked on PA Transaction Control Extension to restrict the charging of time and expense transactions to individual Confidential projects.
• Designed and developed custom interface framework for interfacing the daily EDI feeds coming through Confidential ’s Cast Iron Application, including inbound EDI feeds 810, 832, 846, 850, 855, 870 and outbound EDI feeds 810, 850, 855, and 856.

Confidential, Wilmington, CA

Senior Technical Consultant

Responsibilities:

• Worked on upgrading custom extensions to implement the Service Contracts, Financials modules(GL, AR, PO, AP, FA and Subledger Accounting)
• Worked on integrating with their new MIS (Student Information System).
• Worked on upgrading the customer forms and Reports to R12.
• Customized Account Analysis report in Subledger Accounting module to generate the output in Excel file.

Confidential, San Fernando, CA

Oracle Technical Consultant

Responsibilities:

• Working on the development of XML publisher reports for 3D Systems to generate the output in PDF forms in English, German, French and Italian languages for their Business Units in US and Europe.
• Developed outbound interfaces to send the data to Lawson ERP systems from PO, INV module, to extract the item data such as items, on hand quantities, material transactions, vendors, sourcing rules, purchase orders, requisitions, Landed Cost and Container information.

Confidential, Irvine, CA

Techno Functional consultant

Responsibilities:

• Working on the AP Small balances write-off process to write off variances on AP and PO amounts in the shipping and receiving containers. This customization involved a Form and audit reports.
• Worked on Performance tuning to improve the performance of the AP Custom reports.
• Working on the development of custom reports, Forms for GL, AP, INV transactions reconciliation and matching reports.
• Working on development of new reports and customizing the standard reports in AR and FA module.