SUMMARY

• Senior Oracle techno - functional consultant with more than fourteen years of experience developing, extending and customizing Oracle applications.
• Techno - Functional Skills (HCM Fusion, HRMS, OM, PO,AP,PA,AR, GLCE,FA, Trade Management, iExpenses, eBTax, Advance Collections, AME)
• Experience in extending and personalizing self-service applications using OA Framework
• Experience in developing/Consuming web services.
• Extensive Oracle Applications development and implementation experience.
• Strong technical and functional knowledge of Oracle Financial suites and HRMS.
• Experience with integrating various legacy applications with Oracle Apps
• Strong product development experience. Extensive experience in Oracle Forms, Oracle Reports and PL/SQL, Workflow, XML publisher, OAF.
• Familiar with AIM methodology

TECHNICAL SKILLS

Oracle Applications: 11.5.7, 11.5.9, 11.5.10, R12 Modules OM, AP, GL, PO, AR, QP,HR,OZF, eBTax, iExpense.

Oracle Related: Developer 2000 Rel 1.0 and 2.1; Forms 5.0, Forms 3.x; Designer 2000 1.3.2, 2.1; Pro*C; Oracle 6, 7.x, 8.0.x; 9.x, SQL Loader; SQL*Plus; PL/SQL, TOAD, WRQ Reflection, PVCS, Jdeveloper OAF.

Operating Systems: Windows NT, Unix, Windows Vista, XP, 98, 95, AS/400, and VSM

Applications: MS Excel, MS Words, Fox Pro, MS Access, Great Plains, Crystal Report.

Network: Telnet, Novel

Communication: TCP/IP, NETBEUI, IPX/SPX

Cloud Applications: Salesforce,Taleo.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Manager/Technical Lead of HCM Fusion / EBS Financial Systems

Responsibilities:

• Lead HCM Fusion Cloud upgrade from EBS R12 that include Core HR, Payroll, Talent Management and Advance Benefits.
• Employee Migration EBS R12-> HCM fusion using FBL, HCL
• New hires coexistence integration Taleo -> HCM Fusion -> EBS R12 -> Taleo using web services and PBL (Payroll Batch Loader)
• Documentation Setup -> RD10s, BR100s, MD50s
• Integrated HCM Fusion -> EBS R12 using OBIIE, HCM Extract, Web Services and PBL
• Provide technical leadership for development team members for Oracle EBS R12 applications.
• Support CRM Salesforce Application for the Company Customer Perks Program.
• Consumed Salesforce Web services to download Customer Perks related data into Oracle.
• Work with Oracle Support to resolve issues.
• Support GL, AR, AP, PA, CE and FA, iExp, PO Users with daily production support and end of month closing issues.
• Support Trade Management, Advance Collections Users with daily production support.
• Implemented Project Costing module.
• Collaborate with developers and business users on system analysis, design and implementation of new features and systems
• Implemented Credit Card payment process by integrating Oracle EBS with Authorize.net through web services
• Developed Personalization and customization for Project Costing module implementation
• Developed an interface using Web Services to Load New Hires employee into Oracle HR module from Taleo Cloud Application.
• Developed an interface to upload/download customers, Invoices, Sales Orders and settlement file Into Third Party application using web services.
• Implemented modules eBTax, IExpenses, PO and AP for UK business segment.
• Migrated Suppliers and invoices for UK from legacy to AP
• Support HRMS users with day to day requirements.
• Developed a few custom modules using OAF, Oracle workflow builder and AME.
• Lead and support Development team with day-to-day technical and functional issues.
• Review code before going into production to make sure standard and documentation is properly followed.
• Developed Interface to migrate AR invoices from legacy system.
• Apply AIM methodology making sure MD-50 and MD-70 are properly created.
• Substituted forms and workflows developed by a third party application with seeded oracle technologies (OAF, Oracle workflow and AME).
• Setup dunning letters in Advance collections R12.
• Setup and customize Check printing in AP using XML Publisher.
• Deploy OAF applications in development and testing environment.
• Create and follow-up on new Oracle SR’s and escalate them if necessary.
• Developed HR Pay slip screen using OAF R12 to substitute seeded Oracle screen with option to print pay slip as Pdf report using BI Publisher.
• Developed an eLearning Module using OAF R12 sending enrollment appointment using Ics file.
• Create a mass update and approve process for claims, under Oracle Trade Management R12
• Apply personalization to OAF forms.
• Customized AME used by AP approval workflow to validate account distribution and change approval rule base on invoice amount.
• Developed an auto credit memo approval process to be able to settle claims under Trade Management R12.
• Register concurrent programs, request sets, Menus, functions, responsibilities
• Created interface to bring customer from TP application into oracle
• Worked in R12 upgrade implementation from 11i creating Setup for GL, AP, AR, PO, Advance collections and Trade Management Modules

Confidential, Doral, FL

Oracle Techno-Functional Consultant

Responsibilities:

• Developed wrapper in PL/SQL for Java developers to be able to communicate with Order Management API’s to process Sales Orders, Quotes and BSA (Blanquet Sales Agreement).
• Developed Pre and Post AR interfaces for AR Auto Invoice program
• Developed coding for GL migration from Oracle Application version 11.0.3 to version 11.0.10
• Maintain Master Move docs from all Developers team using WinCVS making sure coding is properly updated, documented and meet company standards.
• Register executables, concurrent programs, functions, menus, forms, Request set, value sets, fnd lookup type in Oracle Applications..
• Developed Costing solutions end of month reports.
• Developed reports for Pattern Of Service (POS) Aviation solutions
• Developed scripts to load daily CSV pricing files from Suppliers.
• Migrated Oracle Applications Seed data using FNDLOAD utility.
• Created PL/SQL program to insert record into oracle AP and AR interfaces table to be processed in a request set by the AR and AP Auto Invoice concurrent program resulting in the creation of invoices for both AR and AP.

Confidential, Sunrise, FL

Senior Programmer Analyst

Responsibilities:

• Involved in a SOA project providing business services for our enrollment and claim application., creating XML schema and WSDL for these two applications as well as back end business processes developed in PL/SQL and Java store procedures.
• Developed a Coupon automation process using AP module interfaces
• Developed interfaces and extension forms for PO, AR INV and AP modules in Oracle Financial 11i.
• Migrated vendors, customers, payments, notes to Oracle Apps from our PeopleSoft legacy system.
• Assisted in solving issues related to invoices stuck in the Oracle Apps interface tables, such as invoices stuck due to Oracle delivered errors, invoices stuck to due to PO matching issues, period not open, vendor or vendor sites not valid, GL code combinations not valid or custom workflow errors. Involved in running Payables Accounting Process and Transfer to GL monthly or periodically.
• Involved in solving issues related to clearing the purchase orders stuck in the approval process, purchase orders stuck in the interface due to Oracle delivered errors, such as period not open, invalid suppliers etc.
• Involved in the setups for check printing, setting up banks, payment documents, financial information, setting up payment formats, payment lookups, and resolving check run issues.
• Created custom sub-ledger and program to load data from custom claims module to GL.
• Resolved errors encountered in loading data from custom sub-ledger to GL interface. Executed Journal Import Program from GL menu.
• Support and lead others developers in technical issues found during the development cycle.
• Developed a form base security system creating a scanning process that reads the object list report generated by Form Builder and then set up security for the forms through Roles at menu, form, block and item level.
• Cloned some Oracle Apps forms to apply custom code to fit business needs.
• Involved in the development of a Claim Application using Oracle Application 11i standards
• Involved in Registration of Forms, Functions, Concurrent Programs, Menus, etc.
• Apply form personalization.
• Support and lead others developers in technical issues found during the development cycle.
• Trained Developers in PL/SQL new features for 10g.
• Involved in the analysis, design and coding for a SCM System (Service Contract Management)
• Processed out bounce and in bounce file using PL/SQL
• Developed form templates, object libraries and PL/SQL libraries to be used with Designer 6.0.
• Loaded Third Party files using PL/SQL.
• Tuned complex SQL statement using Oracle trace file.
• Generated forms using Designer 6.0.
• Migrated PL/SQL packages, procedures and functions from Designer 6.0 to 6i to be able to apply versioning control features
• Configured forms server to deploy web forms application.
• Developed forms to deploy on the web server using Designer 6i.
• Migrated all forms from Designer 6.0 to 6i

Confidential, Fort Lauderdale, FL

Oracle Consultant

Responsibilities:

• Maintained and enhanced store procedures and triggers used by a financial application. Get a good understanding of the stored procedure and triggers used by the application and develop the re-engineering process to create documentation about their logic.
• Involved in the creation of Unix script along with SQL*LOADER to get data from different source file that come from external system into the Financial System.
• Support the conversion and migration process of data from Mainframe into Oracle Server, using SQL*LOADER scripts.
• Created background interface using store procedure to create output file for PeopleSoft.
• Created a few crystal Reports for End-users.

Confidential

Senior Programmer Analyst

Responsibilities:

• Developed a data warehouse for a messaging system using Designer 2000 and Developer 2000.
• Developed query application using Discoverer 3.1. for financial and operation departments.
• Installed the Oracle Web Server 3.0 and developed some web applications using Designer 2000.
• Customized the installation of the Messaging System using Oracle Installer.
• Performance and tuning in a data warehouse environment.
• Produced installation scripts for the Developer 2000 forms application using the Oracle file packager for use with the Oracle Installer.
• Developed and implemented a deployment strategy for the messaging system.