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.
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
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
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
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
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
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
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
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
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