|
Cooper City, Florida |
|
|
Senior Principal Consultant, November 2009 – Present |
|
|
- The ADT Oracle Project Accounting (OPA) implementation was completed in two phases consisting of the Phase I Field Launch deployed in December 2011 and Phase II Finance Launch in April 2013. The scope of OPA was to replace the legacy Construction Work-in-Process (CWP) cost repository system with Oracle Project Costing to seamlessly integrate with the existing Oracle Financial modules. The Finance Launch phase involved the configuration of key AutoAccounting (AA) functions developing complex SQL-based AA rules to interface project costs to Oracle General Ledger. It also included two major customizations to manage the “Cost Clearance” of WIP costs when security system installations are completed and creation of assets for ADT Owned installations when placed in service for interface to Oracle Fixed Assets. |
|
- Doug served as the Lead Senior Business Analyst for both the OPA Field & Finance Launches, including requirements gathering, preparation of MD50’s, facilitate design sessions, assist with coordination of testing resources and deployment. The custom programs were developed using the agile SCRUM methodology. |
|
||
|
- The goal of the DRS SSI Oracle upgrade project was to upgrade the Oracle EBS environment for SSI from Oracle EBS version 11.5.9 to version 12.1.3. The scope also included implementing new R12 enhancements to improve business processes and replace CEMLI’s where possible. |
|
-
Doug was
responsible for the upgrade of the Oracle Project Costing, Billing and
Contracts modules including the testing and retrofitting of 25 existing
CEMLI’s to be R12 compliant & OP3 Third Party Interface with
Primavera. |
|
|
- The scope of this highly visible 2-pronged project was comprised of delivering a project-centric Oracle E-business implementation that met U.S. Government Cost Accounting Standards (CAS). The CAS compliance was achieved with a project-based solution that managed commitments and costs consequently ensuring accurate billing to governmental agencies. The Oracle Purchasing, Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets and Projects applications were leveraged in this deployment. |
|
- Doug contributed to this project as the subject matter expert in the project cost accounting, revenue recognition and billing areas. |
|
|
- This essential initiative was a compliance project to meet SOX requirement gaps. The total scope consisted of 4 major tracks including Accruals and Deferrals (A&D), Level of Effort (LOE) tracking, Time Card Integrity (TCI) control and PULSE (EMEA-based Project Management, Collaboration & Resourcing application tool) bi-directional integration with Oracle Projects. |
|
- Doug was the PULSE track lead with responsibility for the overall design, development and deployment of this key project component for the EMEA operations. |
|
|
- This project was the implementation of a solution to automate the sales order and invoicing integration between the MasTec NSORO division and its customers using EDI technology. The scope also consisted of streamlining the professional installation services billing process to AT&T of sales order lines on an “at completion” basis. |
|
- Doug acted as the solution architect and functional consultant during this engagement. |