Alan Hepple

  • Oracle EBusiness Suite Techno-Functional Consultant
  • Oakland, California 94602
  • Oct 18, 2017
Full time Information Technology

Personal Summary

Detail-oriented, solutions-focused, and innovative professional, with extensive experience in the customization and integration of Oracle E-Business Suite applications. Armed with proficiency in Oracle PL/SQL and database development as well as software design and application development, implementation, and maintenance. Skilled at resolving technical issues as well as designing and developing components and common services based on development models, languages, and tools. Accustomed to managing multiple projects and accomplishing tasks in a timely manner.

Work Experience

Independent Oracle E-Business Suite (EBS) Techno-Functional Consultant
Self-employed
  • Capitalize on technical and functional expertise in assisting clients in improving business functionality and end-user experience of their Oracle E-Business Suite implementation

  • Successfully drove initiatives that enhanced end user’s experience with Oracle EBS

Google (Sep 2016–Aug 2017)
  • Contributed to the development activities of Google for the upgrade of Oracle EBS from 11i to R12.2.5, such as verifying the configuration, extension, modification, localization, and integration (CEMLI) of custom code and database objects to ensure adherence to online patching (OLP) standards

  • Supported the execution of R12 development with the following highlights:

    • CEMLI Tracking: Generated scripts to identify custom code violating R12 Online Patching standards

    • CEMLI Solutions: Created scripts to resolve grants and synonyms for APPS and custom schema database objects

    • FND Tracking: Developed scripts to verify the migration of FND objects against those tested in the UAT system.

    • GL Validation Reports: Drafted several reports to accurately compare general ledger accounts, balances, and foreign exchange (FX) rates before and after R12 upgrade for business validation

    • Home Page Personalization: Incorporated various helpful web links to the EBS home page using personalization.

    • Scheduled Concurrent Requests: Established concurrent programs to cancel and hold scheduled requests prior its upgrade and release held requests after

Salesforce (Jan 2016–Apr 2016)
  • Functioned as a business systems analyst in a Scrum environment, responsible for defining the functional requirements for new and existing reports

  • Administered quality analysis and user acceptance testing for the integration of Aravo supplier master data to and from Oracle EBS R12

dotSolved Solutions (Aug 2014–Oct 2015)
  • Worked with SunEdison and dotSolved Solutions as a technical lead, in charge of developing conversion programs for an Oracle EBS R12.2 implementation project for the benefit of employees, customers, inventory items, legal entities, as well as open accounts receivable (AR) invoices and inventory on-hand quantities

  • Created baseline code for suppliers and open AP invoices for the project’s additional resources

  • Formulated and implemented standard functions and procedures for all conversion programs for mapping source data to Oracle EBS data as well as for reporting results of the validation and conversion process

  • Directly collaborated with functional, business, and information technology (IT) staff in generating processes to retrieve and cleanse data

  • Assisted in resolving diverse issues throughout the project

OAC Services (Oct 2013–Aug 2014)
  • Worked with Power Integrations on OAC Services to create an effective solution to email AR invoices to customer contacts; as well as to provide Oracle EBS support to investigate service desk incidents to identify the cause and solution and resolve technical and functional issues

  • Worked with Linear Technology on OAC Services to update the purchase order (PO) approval workflow and gather new data for the approval notifications using PL/SQL and Workflow Builder

Nestle Dreyer’s Ice Cream (May 2010–Nov 2012)
  • Assisted the Master Data Management Team in conducting customer and vendor mass data uploads and updates through APIs and open interfaces in Oracle AR and AP Release 12

  • Used PL/SQL, SQL, UNIX Shell Scripts, and Oracle Designer 10g for forms and database objects to generate and maintain custom applications and interfaces

  • Capitalize on industry expertise in providing strategic technical designs for custom solutions, code reviews for colleagues’ development, and support for resolving helpdesk incidents

OAC Services (Nov 2008–Dec 2009)
  • Worked for Xilinx with OAC Services in creating a custom process to upload standard and blanket purchasing documents from Excel spreadsheets through the use of UNIX script, PL/SQL, and the standard open interfaces into Oracle Purchasing Release 12.

  • Took charge of updating existing custom reports, such as blanket PO and release information

  • Generated a scalable process through the use of PL/SQL and Oracle Alerts to accurately track and report errors from custom processes creating requisitions and releases

dotSolved Solutions (Sep 2007–Aug 2008)
  • Worked for SunPower with dotSolved Solutions, with responsibilities for developing conversion scripts for a Release 12 implementation of Oracle EBS, including; complete employee history, customers, suppliers, open AP invoices, open AR invoices, open purchase orders, inventory items and quantities on hand from multiple sources

  • Served as the developer’s mentor, in charge of providing requirements, baseline code and resolution to issues found during testing in coordination with business processes

Cisco WebEx (Feb 2007–Aug 2007)
  • Oversaw the Oracle Advanced Collections (R11i) implementation project in coordination with the business to determine requirements, gaps, and potential performance issues

  • Implemented various initiatives for enhancements, which included a process to map WebEx’s chart of accounts to Cisco’s chart of accounts for the upload of trial balances; as well as other custom programs and reports

Education

Higher National Diploma in Computer Science (equivalent to Associate’s Degree)
De Montfort University