SUMMARY:

• Custom Solutions and Processes Development, Data Analysis and Modeling, Functional and Technical Design SpecificationBusiness Requirements Analysis, Full Software Development Life Cycle, User Acceptance Testing & Training
• System Administration, Systems Integration and Customization, Application Development
• Oracle E - Business Suite, General Ledger, Fixed Assets, Payables, Purchasing, Receivables, Cash Management
• 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.

TECHNICAL SKILLS:

SQL and PL/SQL: SQL*Loader, UNIX Scripts, Oracle API’s and Open Interfaces Oracle Alerts,Oracle Discoverer

Oracle Workflow: Builder, XML/BI Publisher, Oracle Reports, FSG Reports, RXi Reports,Toad and SQL Developer, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Independent Oracle Consultant

Responsibilities:

• 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

Confidential

Responsibilities:

• Contributed to the development activities of Confidential 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:
• Generated scripts to identify custom code violating R12 Online Patching standards
• Created scripts to resolve grants and synonyms for APPS and custom schema database objects
• Developed scripts to verify the migration of FND objects against those tested in the UAT system.
• Drafted several reports to accurately compare general ledger accounts, balances, and foreign exchange (FX) rates before and after R12 upgrade for business validation
• Incorporated various helpful web links to the EBS home page using personalization.
• Established concurrent programs to cancel and hold scheduled requests prior its upgrade and release held requests after

Confidential

Responsibilities:

• 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

Confidential

• Worked with Confidential and Confidential 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

Confidential

Responsibilities:

• Worked with Power Integrations on Confidential 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 Confidential to update the purchase order (PO) approval workflow and gather new data for the approval notifications using PL/SQL and Workflow Builder

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• Worked for Confidential with Confidential 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

Confidential

Responsibilities:

• Worked for Confidential with Confidential, 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

Confidential

Responsibilities:

• 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