PROFESSIONAL SUMMARY:

• Over 7 years of Oracle EBS functional, Order to Cash, Procure to Pay, Oracle EBS technical, database administration, data warehousing, UNIX, Oracle implementations, upgrades, patches and Oracle applications architecture experience.
• Accounting experience in general ledger reconciliations, cost accounting, and forecast preparation and analysis.

PROFESSIONAL EXPERIENCE:

Confidential, Sandy Springs, GA

Oracle Functional Consultant

• Acted as the Lead Business Analyst (BA) in an implementation of Oracle Cloud 12c.
• Created technical and functional solutions and setups, in addition to user and administrator documentation for Oracle Cloud 12c in Procurement (PO), Order Management (OM), Financials, Enterprise Planning and Budgeting Cloud Service (EPBCS).
• Gathered requirements, then used that information to document the as - is processes, to-be processes, gap analyses, test scripts, requirements traceability matrices, and functional and technical documents.
• Coordinated and led UAT with business users to ensure an on-time Go-Live.
• Created a cook book for PO approval and AP approval hierarchy to help the administrators during setups.
• Documented allocation setups for the administrators to aid them in future setups and configurations.
• Assisted in the creation of an Excel PO upload template to aid users in loading Purchase Orders to the Cloud.
• Acted as the Lead BA for the implementation of an Oracle Cloud interface with the Data Warehouse.

Confidential, Atlanta, GA

Oracle Techno Functional Consultant

• Acted as the sole Oracle resource at the client responsible for providing functional and technical solutions in Oracle EBS R12 using the GL, AP, AR, CM, PO, INV, eAM, OM, FA, BOM, WIP, QA, OTL, Field Service, Projects, Advanced Pricing, iProcurement, and iSupplier modules including Procure to Pay (P2P) and Order to Cash (O2C or OTC) solutions.
• Gathered requirements, created documentation, determined gaps, designed and executed testing, and provided training and support during and after client implementations.
• Learned the client’s proprietary Oracle-Interfacing Mobile Applications within 8 weeks at a level where the VP requested me to provide solo on-site support to their customers.
• Requested by client to be lead resource for new implementation project due to success during on-site support.
• Lead the QA / BA Team and mentored a new hire in Oracle r12 Functional and Technical, Agile and Scrum, documentation, and many other skills, until the new hire became self-sufficient.
• Created documentation directly for Oracle to be used in the Oracle Cloud Marketplace to support our application’s compatibility with Oracle Cloud SCM.

Confidential, Atlanta, GA

Oracle Functional Analyst

• Created functional solutions in Oracle EBS R12 using the GL, AP, AR, CM, PO, CRM and INV modules including Procure to Pay (P2P) and Order to Cash (O2C or OTC) solutions.
• Lead multiple integration projects to integrate Oracle with various external systems.
• Acted as the lead functional resource during an implementation of Oracle Service-Oriented Architecture (SOA) Cloud Service version 12.1.3 and Oracle Database upgrade to version 12c Release 2.
• Performed functional tasks during Oracle EBS application upgrade from version 12.1.3 to 12.2.5.
• Led the implementation of Oracle for acquired companies. Setup AGIS for intercompany transactions, merged the acquired company’s assets into fixed assets, and coordinated testing, documentation and issue resolution.
• Assisted production support (PS) in multiple projects at the request of PS management after receiving accolades in prior PS projects from users and management. Used ServiceNow.
• Awarded the Star Award by management for “going above and beyond to prevent a customer relations disaster” during multiple critical releases.
• Resolved an issue with the AP Record to Reporting Cycle (R2R) by using a process improvement solution rather than user requested development effort.
• Identified the need for specific Oracle patches to solve AR and CM issues. Opened and resolved an Oracle service request (SR) when testing with the bank identified defects introduced by the new patches.
• Documented all phases for multiple projects involving Oracle R12, Discoverer and Java (implementations, upgrades, patches, releases/deployments, etc.) (see: documentation section under technical summary below).
• Implemented the enterprise-wide, HP Quality Center Application Lifecycle Management (HP QC ALM) System. Selected by management to act as the department lead for all ALM tasks during and after implementation.

Confidential, Suwanee, GA

Oracle Technical Consultant

• Acted as the sole Oracle resource at the client responsible for providing functional and technical solutions.
• Performed development, upgrade and maintenance tasks in an Oracle data warehouse for Habitat for Humanity.
• Managed and executed multiple full lifecycle projects (SDLC) in both Agile and Lifecycle environments while documenting all phases (see: documentation section below).
• Created PL/SQL procedures for Informatica to identify and correct corrupted financial data in the data warehouse. Designed new ETL PL/SQL procedures to prevent further corruption of financial data.
• Implemented an Oracle database to automate client intake and management using Toad Data Modeler. Used SQL and Pl/SQL to create custom reports from the database.

Confidential

Oracle Techno Functional Consultant

• Performed functional and developmental duties for GL, FA, AP, PO, AR, OM, BOM, WIP, INV and WMS Oracle modules for external clients.
• Led the implementation of a custom Order to Cash (OTC) solution while performing all functional and significant developmental responsibilities.
• Gathered requirements and developed custom forms, reports, packages, triggers and procedures to automate manual processes and provide quality checks for manufacturing, quality, accounting, sales and other departments.
• Managed upgrade of Oracle EBS to version R12. Updated, compiled and tested custom reports, forms and packages. Created documentation for all phases (see: documentation section below).
• Provided 24/7 on-call production support for a 300+ person organization including accounting, manufacturing, warehouse, purchasing, sales and executive teams. Efforts included: database administration support, production analysis and troubleshooting.

Confidential, Norcross, GA

Inventory Accountant/Inventory Manager/Oracle Techno Functional Consultant

• Hired without prior business, accounting or inventory experience. Promoted to Inventory Manager to supervise the inventory department including 2 employees after 10 months.
• Performed functional and developmental tasks on a junior level for these Oracle modules: GL, FA, AP, PO, AR, OM, BOM, WIP, INV and WMS.
• Functioned as an accountant, business analyst and developer to all other functional areas of Confidential including the manufacturing, sales and executive teams.
• Learned SQL, PL/SQL, Oracle reports, Oracle forms, packages, triggers and procedures from Confidential ’s Oracle architect (President of Confidential ).
• Developed process improvements. Worked with IT to identify the requirements, define the tables, write the code, then develop, implement and test the processes. Trained users on custom reports, processes and forms.
• Provided production support for accounting, manufacturing, warehouse, purchasing, sales and executive teams.
• Designed variable costing models that allowed users to calculate gross margins using manufacturing costs, shipping costs and commissions.

Confidential, Atlanta, GA

Medical Consultant

• Served as the medical expert to the 3-D animation, sales and executive teams.
• Analyzed current FDA drug trials and predicted the commercial success of new pharmaceuticals to help the sales team focus their efforts on the most promising new business opportunities.

Confidential, Lexington, KY

Research Team Lead

• Led a 4-member team on an 18-month project to map the precise location of muscle attachments to the elbow using the FARO 3D Digitizer and Geomagic 12 software. The goal was to create a 3-D computer model to assist orthopedic surgeons in repairing elbows and restoring pre-injury functionality. Worked under Srinath Kamineni, M.D., Dir. of the Orthopedic/Sports Medicine Research Centre.
• Coauthored two journal articles: one on the triceps brachii and one on the elbow capsule.
• Presented poster, “Creating a 3-D Model of the Distal Footprints of the Biceps Brachii, Triceps Brachii, and Brachialis Muscle,” at Alpha Omega Alpha Groves Memorial MD/PHD Program Research Day, 2/3/11.

Confidential, Atlanta, GA

Honors Thesis Candidate

• Researched the use of a dirhodium catalyst used to streamline manufacture of pharmaceuticals, such as Ritalin.
• Earned an honors degree in Chemistry for my written thesis and oral presentation to a panel of experts.

Confidential, Atlanta, GA

Research Assistant

• Researched the Human Dopamine Transporter Protein (hDAT) and its binding to cocaine analogs.
• Led research using model to block cocaine’s binding site to eliminate cocaine’s harmful effects for addicts attempting to recover. Nominated by faculty to enter the Honors Program in Chemistry for my research.

TECHNICAL SKILLS

Oracle E-Business Suite Modules: GL, AP, AR, CM, PO, CRM, INV, FA, OM, BOM, WIP, WMS, EAM, OFS, QA, iProcurement, iSupplier, Projects, Advanced Pricing, and Time and Labor.

Oracle E-Business Suite Processes: Procure to Pay (P2P or PTP), Order to Cash (O2C or OTC), Record to Reporting Cycle (R2R or RTR), Advanced Global Intercompany System (AGIS)

Documentation: Project Management Documents Project Kickoff, Statement of Work, Project Charter, Project Plan (i.e. Scope, Schedule and Budget), etc.; Business Analysis Documents As-Is and To-Be Flowcharts, Scope Document, Business Requirements Document, Gap Analysis, Traceability Matrix, etc.; Oracle Documents Functional Designs (MD50), Technical Designs (MD70), Setup Documents (BR100), Test Scripts (TE40), Release Documents (MTP), etc.

Reporting Tools: Oracle Discoverer, Oracle Hyperion, Business Objects, XML Publisher/ BI Publisher, Oracle Forms, Oracle Reports, Crystal Reports, Informatica, Application Lifecycle Management (ALM)

Languages: SQL, PL/SQL, UNIX, Macros with VBA

Methods: Relational and Dimensional Modeling, ETL Design, DW Lifecycle, Software Development Lifecycle (Agile and Scrum (Scrum Master) and Waterfall)

Training: Informatica, Scrum, Waterfall, SQL (Oracle University), PL/SQL (Oracle University), JAVA (self-taught)

Industries: financial, manufacturing, medical, advertising, energy, nonprofit, retail, restaurant