We provide IT Staff Augmentation Services!

Technical/functional Consultant Resume

EXECUTIVE SUMMARY:

  • Over 18+ years of Oracle EBS techno/functional expertise
  • Primarily responsible for the development, customizations and production support of the Oracle Financials EBS suite
  • Completed three Oracle EBS R12 full life cycle implementations
  • Ability to generate end - to-end complete solutions from business requirements gathering, detailed functional/technical specifications and technical delivery of proposed solution.
  • Excellent analytical and problem solving abilities.
  • Able to exhibit judgment and realistic understanding of issues by prioritizing work and use time more efficiently.

PROGRAMMING / SKILLS:

Oracle Tools: SQL, SQL*Plus, SQL*Forms 6i/10g, PL/SQL, AOL, Pro*C, SQL*Net, Sybase SQL, Oracle Application Server, PL/SQL Web Toolkit, Developer 2000, Oracle Workflow, Reports 6i/10g, XML/BI Publisher

Languages: C, C++, Assembly (80x86), Pascal

Platforms: UNIX, IBM, Macintosh, HP

PROFESSIONAL EXPERIENCE:

Confidential

Technical/Functional Consultant

Responsibilities:

  • Responsible for Oracle EBS financials upgrade/remediation project from 12.1.3 to 12.2.7

Confidential

Technical/Functional Consultant

Responsibilities:

  • Responsible for application support and advisory services for Oracle customers with an emphasis on the Oracle EBS Financials.

Confidential

Technical/Functional Consultant

Responsibilities:

  • Provide primary Oracle support to Confidential Federal DoD client for standard Oracle (DEAMS application) and client’s customizations across all EBS modules (Finance, P2P, etc.)
  • Created custom program to load AR adjustments from Excel file
  • Created custom AR invoice print report to migrate off of JetForms

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Reimplementation project from R12.1.3 to R12.2 for Oracle Financials

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Worked on Oracle CLM module for PDF printing related issues

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Created customer interface from an Confidential acquisition company using open interface and standard Oracle Customer Import
  • Worked on PA (Projects) interface as well as additional enhancements

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Created XML outbound interfaces for supplier creation and updates on Oracle Federal Financials.
  • Create XML outbound interface for invoice status
  • Loaded US Bank file into Oracle for create card processing in AP
  • Created program to load inbound XML file for invoice import
  • Used BPA (Bill Presentment) to create printed AR invoice
  • Created custom program to take payroll file and create employees in Oracle HR 12.1.3

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Responsible for new chart of accounts conversion (COA) project. Setup new Ledger, OUs for AP, AR, GL, FA, CE and all the necessary configurations.
  • Migrated open AP, FA, and AR transactions from old COA to new COA.
  • Migrated open GL balances from old COA to new COA
  • Developed scripts to create new supplier sites and customer sites in newly created OUs for AP and AR.

Confidential

Technical/ Functional Consultant

Responsibilities:

  • Created GL balances program to convert YTD balances from 11i to new R12 re-implementation.
  • Created GL interface program to transfer Receivables and RevRec GL journal details lines from 11i to new.
  • Developed reconciliation report to tie 11i GL and R12 GL
  • Modified Oracle requisitions workflow (IProcurement) to derive custom approval routing
  • Modified Oracle FA account generator
  • Conversion of banks, branches and suppliers banks from 11i to R12
  • Created extract from Oracle GL to Hyperion reporting
  • Created other various one time scripts for conversion (create new application users, load expense account rules, load GL elim sets, etc.)

Confidential

Technical/Functional Consultant

Responsibilities:

  • Provide primary Oracle (11i/R12) support to Confidential clients for standard Oracle and client’s customizations across all EBS modules (Finance, Manufacturing, etc.)

Confidential

Technical/Functional Consultant

Responsibilities:

  • Developed custom program to automatically approve requisitions that are in existing workflow
  • Developed custom program to automate requisition to approved purchase order
  • Developed custom alert to notify requestors when goods are received.
  • Created custom program to automate AP invoices uploaded from flat file from suppliers
  • Various bug fixes to existing EBtax reports

Confidential

Technical/Functional Consultant

Responsibilities:

  • Lead developer on the 11i to R12 (12.1.3) migration upgrade for complete Oracle financials (AP, GL, FA, SLA, PO, PA costing and billing)
  • Created AR/PA invoice print (with multiple templates) that combined both AR related information as well as Projects related information for customer presentation. Created several new project/task setups for testing purposes and user data.
  • Generate WRICEP list and analysis of custom components for 11i to R12 migration
  • Created new AP check payment template using BI publisher for R12
  • Utilized forms personalization to create zoom form from Asset Workbench screen
  • Developed a custom GL consolidation process to map an old 11.03 chart of accounts structure to an 12.1.3 chart of accounts. Built several custom forms to maintain the mappings between the different segments of each respective COA.
  • Create custom package to derive the mappings and create the respective GL journals in the interface
  • Worked on 11. .1.3 new implementation project. Responsible conversions for FA, AP, CE, PO, SLA and suppliers from 11i to R12
  • Created two new AP check printing templates
  • Create new AR invoice print template using Oracle BPA

Confidential

Technical/Functional Consultant

Responsibilities:

  • Migrate existing customizations during upgrade from 11.0.3 to 11.5.10
  • Implement Oracle R12 Advance Collections
  • Using Oracle BPA (Bill Presentment Architecture) to create print AR invoice template
  • Working with Oracle AIM methodology to gather requirements and create BR100, MD070, MD050.
  • Generate WRICEP list and analysis of custom components for upgrade from 11i to R12 migration
  • Worked with users to gather business requirements for custom enhancements
  • Enhancement and support of custom revenue recognition engine
  • Implemented R12 lockbox functionality
  • Develop custom credit-memo monthly write off process
  • Developed custom process and reconciliation report to load data files from Paymentech (Chase)
  • Using receipt API to upload bank checks to automatically create receipts
  • Team lead for the procure to pay side
  • Automated R12 credit card refund and chargeback process
  • Positive Pay with Cash Management bank reconciliation
  • Developed and automated custom AR to GL accruals for month end
  • Migrate custom objects from existing 11i instance to new R12 instance
  • Test and modify customizations for new COA (Chart of Accounts) conversion project
  • Implement Positive Pay customization between Confidential and Comerica bank for A/P
  • Developed custom program to sync items between Master org and 8 other inventory organizations within Confidential
  • Implemented Oracle’s GL journal approval with customizations
  • Implemented Oracle’s invoice approval workflow with customizations using AME
  • Provide ad-hoc reports in Excel for SOX compliance and auditors
  • Work with auditors (internal/external) SOX (404) team to make sure all processes are compliant
  • Design and implementation of IProcurement all US based Confidential employees
  • Provide general day to day production support for PO, AR, AP, FA, GL, IExpenses as well as month end / quarter end support

Confidential

Technical/Functional Consultant

Responsibilities:

  • Worked on integration merger with Veritas.
  • Primarily responsible for fixed assets conversion, bank and vendor conversions.

Confidential

Technical/Functional Consultant

Responsibilities:

  • Sole developer for migrating all customizations in 11.0.3 (reports, forms, interfaces, etc.) to 11.5.9
  • Created new Order line workflows for BlueCoat order types
  • Modifyed standard Oracle workflow for FA Account Generator and OM COGS Generator.
  • Lead developer for outsourcing manufacturing/shipping (i.e. drop shipments).
  • Implemented Export Compliance for standard Oracle order workflow.
  • Continually working with users to gather requirements for new enhancements and customizations.
  • Worked on implementation of Oracle EPB.
  • Provide general day to day production support for OM, AR, PO, AP, FA, GL, INV, WSH

Confidential

Technical/Functional Consultant

Responsibilities:

  • Responsible for upgrading current Oracle financials applications 10.7 system to Oracle 11i. Evaluated current 10.7 customizations to determine whether or not any new 11i features could replace existing business functionality. Solely responsible for technical implementation of many finance related customizations within AP, PO, FA and GL.
  • Worked on several modifications made to standard Oracle workflow within Oracle 11i applications. Implemented new workflow definition types to meet the users business needs.
  • Worked extensively on customizations and enhancements to Oracle Self Service Expenses (SSE) and Oracle Self Service Requisitions (iProcurement SSP5)
  • Provide guidance and recommendations to users as to how to enhance customizations, current and new business processes.
  • Gather requirements from users and prepare documentation to clarify and explain custom business processes.
  • Implemented Oracle catalog functionality withing the Iprocurement module.
  • Designed and developed an interface to send electronic purchase orders to CDW (supplier).
  • Involved in the upgrade project of 11.5.3 to 11.5.6
  • Involved in the upgrade project of 11.5.6 to 11.5.9

Confidential

Senior Solutions Engineer

Responsibilities:

  • Focused on developing packaged integrations for CRM/ERP integration. Using the Confidential EAI toolset I was responsible for Oracle ERP development of the following processes: customer sync, employee sync, quote to order, order status, install base and product sync. These processes were real time synchronizations between Siebel/Clarify front-end systems and Oracle back-end systems.
  • Developed integrations for supply chain management for B2B. Using the Confidential B2B infrastructure I worked on creating PO/SO, Order acknowledgment and ASN processes.

Confidential

Project Lead/Senior Software Engineer

Responsibilities:

  • Worked on several key components of our production based system, ProjectNet, for the AEC industry.
  • Responsible for the design and implementation of several new features and enhancement to our web based framework of e-commerce and collaboration services.
  • Primarily developing using Oracle PL/SQL and Oracle PL/SQL web toolkit to generate dynamic web pages and forms.
  • Worked as a lead for four other developers responsible for developing and maintaining our PrintNet service, which offers a comprehensive set of secure online services for the reprographics and print shop marketplace.
  • Responsible for scheduling, prioritization, and proper allocation of resources in order to meet all critical deadlines.
  • Responsible for all I18N of our PrintNet product.
  • Defined an XML schema to generate a Print Work Order for our PrintNet system.
  • Responsible for Oracle 10.7 multi-organization upgrade of AP, GL, and FA including all customizations.
  • Developed an external vendor web site that allowed any Confidential vendor (via authentication) to view their respective invoicing and payment history. Responsible for all configuration and setup of the Oracle Application Server.
  • Developed an application using Developer 2000 and Oracle Web Server to track the life cycle of a software product. Generated reports using the Web PL/SQL toolkit.
  • Created program for AP that allows users to automate the process of creating invoices with the capability of matching to Purchase Orders and prorating tax and freight.
  • Worked as lead with users for all customizations (reports, shell scripts, SQL scripts, etc.) of AP, GL, and FA. Responsible for implementing all customizations in those respective modules.

Confidential

Software Engineer

Responsibilities:

  • Working on gathering requirements for AP to upgrade to Oracle version 10.7 character mode.
  • Created EDI810 (inbound invoices) custom program to handle invoices received from SunService vendors. Responsible for the analysis and design of the EDI requirements for AP implementation. Gathered all requirements from user community.
  • Responsible for the development, implementation and testing of all interfaces between EDI, Oracle AP, and Sun’s Information Highway application.
  • Developed program for Sun’s Tax Department for tax auditing purposes.
  • Created a routine that would run out of each Oracle AP instance as part of Sun’s month end close procedures.
  • Created a HR extract program for Oracle AP. Program will load employees as vendors into Oracle Payables.
  • This is necessary for Sun to pay expense requests, so employees are actually setup as vendors.
  • Created a custom program to transfer created journals in our “skeleton” GL to Sun’s own production GL system.
  • This was necessary since Sun has several different Oracle AP instances, each with its own skeleton GL, but only one corporate wide GL instance.
  • Created a custom program to output all checks issued for a given bank branch, bank account and period. Created a flat file of checks for a given period that was used to send to the bank for reconciliation purposes. The flat file is then sent as an email attachment to the users and that file is sent to the bank. The bank would then call and list any exceptions via the banks own reporting system.
  • Responsible for various support issued related questions as well as AP business requirements. Also, handled month end close support for the AP user community.
  • Responsible for new development / enhancements for the Athena application.
  • A tool used for quoting and creating new schedules for SunService business.
  • Worked with support of the Sun Education group. Supported and worked on requests for the SunEds application. Implemented a new tool to allow users to fax or email confirmation / cancellation letters to students.
  • Used Business Objects to create a reporting universe to query off of Athena database (SYBASE)
  • Created several different SQL reports for different groups within SunService.

Hire Now