We provide IT Staff Augmentation Services!

Solution Architect And Lead Techno-functional Consultant Resume

Henderson, KY

SUMMARY:

Oracle Techno - Functional consultant with 21 years of experience in Oracle Applications including EBS, HCM, and Financials. His expertise includes the analysis, design, architect, configuration, application development, and implementation of Oracle Applications. Performing in a variety of businesses dominated by retail, utilities and healthcare, he has gained much experience in ERP solutions.

SKILL:

  • Oracle Cloud implementation (R12, R13) (2 year)
  • Oracle E-Business suite implementations (10.7, R11, R12) (10 years)
  • Oracle EBS Production support/Enhancements (10 years)

PROFESSIONAL WORK EXPERIENCE:

Confidential, Henderson, KY

Solution Architect and Lead Techno-functional Consultant

Responsibilities:

  • Defined and documented overall conversion and integration strategies for the project
  • Responsible for design, development and implementation of conversion of 30+ conversion objects and 60 interfaces
  • Designed and developed multiple integrations
  • Trained and mentored junior resources as needed
  • Defined coding standards and ensured team adhered to defined standards
  • Designed and developed integrations between HCM and internal systems like Taleo and Service MarketPlace
  • Designed and developed integrations between HCM and vendors
  • Integration design involved multiple methodologies depending on the requirement:
  • Creating flat files using HCM Extract
  • Creating extracts using BI Publisher
  • Calling HCM REST API to query live data
  • Calling HCM Soap Services to automate extract execution
  • Calling Taleo/SMP web services to query/update Taleo data
  • Developing reports for detailed execution error report
  • Using HDL files to load transactions including new-hires, rehires, personnel changes, salary changes and loading element entries
  • Calling Web Content Server web services to upload and download files
  • Designed and developed multiple reports to identify issues/errors during conversion and for daily use
  • Developed design documentation for conversions and interfaces and detailed recovery/rerun procedures for ongoing production support
  • Designed and developed scripts and programs to aid in automated testing with a test employee population covering all scenarios

Confidential, San Francisco, CA

Oracle Applications Lead Techno-functional Consultant

Responsibilities:

  • Designed and developed custom forms for capturing labor distribution to enhance data entry in Confidential
  • Setup validations for Confidential time entry validation, to minimize errors.
  • Design and develop custom sales tax interface.
  • Develop custom report to show sub-ledger accounting details by account, source and period.
  • Setup project auto-accounting rules and implemented pre-processing packages for accurate financial accounting
  • Designed and developed sales tax interface that calculates sales tax that need to be paid to Kentucky state monthly
  • Implemented Reports Manager for Confidential and several other standard reports line Account Analysis, Trial Balance for user friendly Excel reporting
  • Implemented custom PO approval workflow to take care of business requirements
  • Developed multiple ADF personalizations in eAM and Confidential for accurate time recording and element entries in HCM.
  • Developed and implemented interface between Laserfiche and Oracle EBS
  • Designed and developed Oracle Applications alert that checks and responds to any Oracle Applications issue. Ex. Mandatory services down, DB failure, long running jobs
  • Developed and implemented new Inter-Org transfer screen in eAM self-service using ADF
  • Implemented AP positive pay, cash management interfaces and integrated with Bank
  • Designed and developed Active Directory interface to integrate MS Active Directory and MS Outlook with Oracle
  • Designed and developed Projects budget interface for automatic loading of budgets from Hyperion
  • Responsible for fixed assets conversion and custom forms/reports to implement Fixed Assets
  • Responsible for all HRMS, Purchasing, Inventory and Financial modules during database and application upgrade projects
  • Designed and implemented Oracle Projects integration with ComTrac Fuel Management System
  • Designed and developed multiple custom interfaces between HCM and Projects/General Ledger for accruals and actual accounting

Confidential, Henderson, KY

Oracle Applications Techno-functional Consultant

Responsibilities:

  • Designed and developed solution for AR customer conversion and AP open invoice conversion using API.
  • Developed complex AR invoice report using XML publisher and bursting to separate invoices into different files by customer number.
  • Developed lockbox receipts interface to auto-import AR receipts file from bank in BAI format.
  • Developed conversion programs to create customers and open invoices from Mainframe.
  • Designed and developed AP check printing solution
  • Document all setups and issues for knowledge transfer and future .
  • Developed custom extract program to extract sub-ledger details for data-warehousing.

Confidential, Dallas, TX

Oracle Applications Techno-functional Consultant

Responsibilities:

  • Developed AP invoice interface to integrate 3rd party systems with Oracle Applications.
  • Developed GL interface to load history and also integrate 3rd party systems with Oracle Applications.
  • Designed and developed conversion program to convert Projects, Tasks and Transactions.
  • Developed SunGard Outbound interface to send payment disbursements to SunGard in specific format using e-text.
  • Developed invoice interface report and error report using XML data definitions and BI publisher.
  • Developed check printing report using BI publisher
  • Developed several adhoc queries on sub-ledger accounting tables, to ensure accounting is correct.
  • Developed common routines for use in all interfaces. Common routines include:
  • Update supplier address using API
  • Bursting to send supplier e-mails
  • Execute import programs
  • Validate invoice information
  • Validate GL account
  • Set application environment
  • Log messages
  • Handle exceptions
  • Gathered business requirements for Oracle Projects integration with HCM/Payroll and Confidential .
  • Designed and developed Custom interface to Oracle Projects from HCM/Payroll for expenditure items import. This is an enhanced process that replaced standard Oracle process.
  • Designed and developed Custom interface to Oracle GL from Payroll for month-end accrual of labor expense.
  • Developed Discoverer reports for AP invoices with PO information.
  • Designed and developed custom solution for blanket purchase orders with incorrect expenditure-type and expenditure-org.
  • Designed and developed trigger and forms personalization to make projects and task information mandatory for work orders in eAM.
  • Document all setups and issues for knowledge transfer and future .

Confidential, Philadelphia, PA

Oracle Financials Techno-functional consultant

Responsibilities:

  • Gathered Project requirements for Softscape integration with Oracle Applications.
  • Developed custom interfaces to extract division and market financials information from GL for initial data load and on-going changes for Softscape.
  • Developed custom interfaces to extract employee information from HR for initial data load and on-going changes for Softscape.
  • Developed BEE interface to send element entries from Softscape to HCM
  • Developed custom interface to process inbound bonus compensation files to create accrual and actual entries in Oracle GL.
  • Design and developed interface to integrate MS Active Directory with Oracle E-Business Suite for SSO support.
  • Designed and implemented table definitions, DFF’s, global values as required.
  • Developed multiple OAF personalizations in iProcurement as needed
  • Conducted Unit Test, Integration Test and Go-Live parallels
  • Provided detailed documentation including MD50, MD70 for interfaces and CV60, CV40 for data conversions.
  • Documented all setups and issues for knowledge transfer and future .

Confidential, Dallas, TX

Oracle Techno-functional consultant

Responsibilities:

  • Identified performance issues with Oracle interfaces nightly batch programs.
  • Troubleshoot performance issues during annual benefits enrollment period.
  • Performance tuning of payroll programs to improve performance.
  • Troubleshoot and improve application code, for quicker online response.
  • Analyzed index usage and removed redundant indexes.
  • Document all changes done.

Confidential, Boston, MA

Oracle Financials Techno-functional Consultant

Responsibilities:

  • Gathered requirements for Confidential customer integration with Oracle AR.
  • Designed and developed customer interface using TCA API in Release 12.
  • Designed and developed extract programs to extract Confidential data and load them to staging tables.
  • Developed extract programs for other interfaces and created cross tables as required by other tracks.
  • Designed and developed OM orders interface to load open Confidential orders.
  • Developed enhancements for CDH (Customer Data Hub) in Release 12 using OAF/ADF.
  • Customized seeded PO approval workflow to implement custom application iRemedy.
  • Developed MD50/MD70 documents to document functional/technical requirements.

Confidential, San Francisco, CA

Oracle AR Consultant

Responsibilities:

  • Gathered requirements for MetaVance integration with Oracle AR.
  • Designed and developed interface to load customers using APIs.
  • Designed and developed interfaces to load invoices, credit memos and adjustments into AR to replicate transactions in MetaVance.
  • Designed and developed interface controller as a master programs to orchestrate all other custom programs in appropriate sequence.
  • Designed and developed custom reports using Report Manager and BI publisher.
  • Designed and developed data warehouse tables to hold AR data de-normalized for easy reporting.
  • Developed MD50/MD70 documents to document functional/technical requirements.
  • Designed and developed production monitoring alerts to report on progress and failures in nightly cycles.

Confidential, Dallas, TX

Oracle Financials Lead Consultant

Responsibilities:

  • Gathered Project requirements for new Multi-Org Implementation
  • Analyzed the impact on custom programs and documented change procedures to in corporate multi-org.
  • Developed a list of objects requiring changes for multi-org and delegated work to off-shore resources.
  • Ensured changes from off-shore team worked correctly before migrating for UAT.
  • Modified procedures, packages, reports etc to ensure new changes comply with multi-org implementation.
  • Helped users test multi-org changes during UAT.
  • Updated existing MD50/MD70 documents to reflect new changes.

Confidential, Salt Lake City, UT

Oracle Financials Lead Consultant

Responsibilities:

  • Designed and developed positive pay interface custom interface to send files to banks.
  • Designed and developed XML invoice interface to load invoices in Oracle AP.
  • Customized PO account generator to derive cost center using custom logic.
  • Designed and developed to AP custom trial balance report.
  • Designed and developed encryption and decryption programs for exchanging files with third parties.
  • Designed and developed custom interface to load Payroll journals to Oracle GL.
  • Designed and developed custom interface to load AR customers.
  • Designed and developed custom interface to load Bill Back invoices from store system to Oracle AR.
  • Designed and developed item import interface using API for item conversion load from store systems.
  • Modified existing programs to remove SSN column from HCM interface extracts for audit compliance.
  • Designed and developed a master program that can execute specified HCM/payroll reports for each GRE
  • Developed audit extract programs to provide files to external auditors.
  • Modified custom programs and reports to implement multi-currency.
  • 24/7 on-call production support.
  • Improved performance for several custom programs to meet SLAs.
  • Developed several scripts to implement Autosys for job scheduling.
  • Ensured custom objects work in new environment as per requirements.
  • Modified customized programs to ensure they work in new environment.
  • Performed several system administration setups to facilitate testing.
  • Responsible for executing all test cases for GL and AP and log defects during unit and integration testing.
  • Designed and developed LogicalApps rules to implement data security and user security.
  • Replaced LogicalApps with forms and OAF personalization during 11.5.10 upgrade.

Confidential, Jacksonville, FL

Oracle Financials Technical Consultant

Responsibilities:

  • Gathered requirements for GL, AP and AR conversions.
  • Designed and developed interfaces to convert legacy data for initial load for GL and AP.
  • Designed several ongoing interfaces for GL and AP to integrate with third party systems.
  • Gathered requirements to implement Bill Backs and Vendor Coupon Billing in AR.
  • Designed and developed interfaces to implement Bill Backs and Vendor Coupon Billing.
  • Designed and developed depreciation report for FA.
  • Designed and developed custom payment format program to integrate Wes Corp check printing software with AP.
  • Designed and developed retail ledgers application using custom forms and integrated with Oracle GL.
  • Designed and developed credit card application using custom forms and reports and integrated with Oracle GL.
  • Designed and developed web applications to view transactions (invoices, receivables etc.) and publish store performance reports on intranet.
  • Designed and developed interfaces to integrate Cyborg systems HRMS with Oracle GL.
  • Modified several custom programs to implement production fixes.

Hire Now