Fujitsu Consulting

 

Responsibilities as Project Manager includes planning and project management issues, validates solution design, quality assurance and client satisfaction.

Accountable for the overall progress of projects at the following clients:  Progressive Group of Insurance Companies, Stage Stores, GES Exposition Services, Inc, Kinetic Concepts, Inc, GE Global Research Center and SASCO Electrical Construction & Data Systems.

 Key roles, project size, complexity, duration and solution architecture:  Project experience ranged from small to large complex ERP implementations with the scope including Oracle Financials 11i (General Ledger, Purchasing, iProcurement, Payables, iExpenses, Receivables, & Assets) as well as Oracle Projects (Costing, Billing, Project Management, Collaboration and Resource Management).  Key roles as Project Manager and Lead Solution Architect with responsibilities to define and map business requirements, identify gaps, design-build custom solutions, legacy conversions and application upgrades.

 

Responsibilities as Project Manager includes planning and project management issues, validates solution design, quality assurance and client satisfaction.

Accountable for the overall progress of projects at the following clients:  Progressive Group of Insurance Companies, Stage Stores, GES Exposition Services, Inc, Kinetic Concepts, Inc, GE Global Research Center and SASCO Electrical Construction & Data Systems.

 Key roles, project size, complexity, duration and solution architecture:  Project experience ranged from small to large complex ERP implementations with the scope including Oracle Financials 11i (General Ledger, Purchasing, iProcurement, Payables, iExpenses, Receivables, & Assets) as well as Oracle Projects (Costing, Billing, Project Management, Collaboration and Resource Management).  Key roles as Project Manager and Lead Solution Architect with responsibilities to define and map business requirements, identify gaps, design-build custom solutions, legacy conversions and application upgrades.

Stage Stores, brings nationally recognized brand name apparel, accessories, cosmetics and footwear for the entire family to small and mid-size towns and communities with over 735 stores in 38 states.

-  Functional Analyst lead responsible for developing solution designs for project and asset lifecycles.  This effort, aimed at implementing multiple Oracle Projects Modules (Project Costing and Project Foundation) and integrating them with Fixed Assets, Account Payables and Purchasing.

-   The Stage Stores solution was implemented and designed for the purpose of controlling costs associated with new and existing store development.

Key requirements from Stage Store include:

  • Add new projects and tasks in Oracle Projects module for new stores, remodeled stores etc.
  • Associate project information on the supplier payable invoices in Oracle Accounts Payable module.
  • Interface project supplier invoices from Oracle Accounts Payable to Oracle Projects and track capital and CIP costs.
  • Interface associate non-CIP related assets directly from Oracle Accounts Payables to Oracle Fixed Assets.
  • Create assets in Oracle Projects module and relate them to project or task or sub-task levels based on business requirements (WBS).
  • Capitalize projects as they complete and interface assets to Oracle Fixed Assets.
  • Split an asset line and allocate costs to multiple assets based on projects by GL account (asset category)
  • Track, sort, report, projects by cost center and department.
  • Track projects by Capital vs. Expensed.
  • Track projects by the year they are added.
  • Setup existing projects for reference to the converted fixed assets.
  • Enter additional projects costs manually and distribute expenses to GL directly (includes Labor, Usage and Miscellaneous etc.).
  • Capitalizing Interest.

 

Rosendin Electric, Inc., consistently ranks in the top ten electrical contractors in the United States, which has over 80 years of proven experience & performance.

-  PM for this project-centric Oracle 11i (11.5.10) ERP implementation with the scope including the following applications: Oracle Projects(Costing, Billing & Project Management), Payroll, Human Resources, General Ledger, Purchasing, Payables, Receivables & Assets

-  The Rosendin solution includes custom extensions to meet specific labor costing, purchasing, billing & union benefit deduction business requirements applicable to REI’s industry.

Key requirements from Rosendin include:

  • Integrated project costing with payroll processing (actual payroll costs with associated fringes)
  • Project set-up and invoicing to comply with the American Institute of Architects (AIA) standards
  • Trade Services database and vendor pricing updates in purchasing module
  • Automatic intelligent PO numbering within each project number
  • Tracking of unbilled receivables & unearned revenue
  • Equipment usage & small tool management integrated with project costing
  • Accounts Payable to hold retention amounts on subcontractor invoices as required

 

GES Exposition Services, Inc, provides exhibition and event services in every major convention market across North America. They produce many of the world’s most recognized trade shows including IMTS, CONEXPO/CONAGG, Consumer Electronics Show, National Association of Broadcasters, MAGIC, World Shoe Associates, National Restaurant Association, E3 and COMDEX.

- Key positions as Project Manager and Lead Solution Architect for this Oracle 11i Project-centric/Financials implementation with the scope including Oracle General Ledger, Oracle Payables, Oracle I-Expenses, Oracle Purchasing, Oracle I-Procurement, Oracle Fixed Assets, Oracle Project Costing, Oracle Project Billing, Oracle Internal Control Manager.

- The GES total solution involved integrating 12 highly industry-specific legacy systems key to the corporations operations. The solution incorporated 60 RICE (reports, interfaces, customizations and extensions) objects with the Oracle E-Business Suite.

- Key Functional Requirements from GES:

  • Two-way interface between Hyperion budget tool and Oracle Projects/GL
  • Journalize payroll entry from Highline/P2K (legacy) to Oracle GL
  • Interface Highline/P2K labor costs and corresponding benefits to Oracle Projects
  • Workflow notification to buyers when the PO’s are about to expire
  • Gateway to interface Tradeshows from operational systems (legacy) to Oracle Projects
  • Automate the reversal of project revenue accruals (reverse event in future period)
  • Set-up Project Status Inquiry (PSI) for expense tracking and budget to actual analysis
  • Configure Requisition, PO and AP workflow to automatically create Accounting FlexField combination from project attributes.
  • Customize process to accrue project-based PO’s in GL which have not been received
  • Build Discoverer reports to leverage Oracle Business Intelligence and Noetix Project and Financial views.
  • Integrate Oracle Internal Control Manger to comply with section 404 of Sarbanes-Oxley

 

Kinetic Concepts, Inc. (KCI), San Antonio, TX, is a global corporation providing leading edge innovation in Wound Care, Pulmonary Care, Bariatric Care, and circulatory improvement to patients in all care settings.

- PM and Oracle Projects Subject Matter Expert for this 11.5.8 Oracle Projects Costing implementation.

- The KCI solution includes implementing both capital and indirect projects. Indirect projects to track KCI R&D projects and capital projects to track IT infrastructure projects.

- Key Functional Requirements from KCI:

  • Track purchasing commitments in Project Accounting
  • Track all project related payables
  • Track employee time and cost in Project Accounting
  • Track inventory cost in Project Accounting
  • Allocating engineering cost from the ledger to projects
  • Allocate cost from –one project to multiple target projects
  • Utilize Project Status Inquiry for expense tracking and budget to actual analysis
  • Utilize Expenditure Inquiry Review for making adjustments and fixes
  • Utilize transaction controls and hard limits to prohibit unauthorized spending
  • Automate GL accounting via auto-allocation rules
  • Automate FAS 121 capitalization rules utilizing standard Oracle task based capitalization functionality

 

SASCO Electrical Construction & Data Systems, the largest privately held electrical and data contractor in the United States (ENR), with 8 offices on the West Coast extending from Southern California to the Northwest

- PM for this project-centric Oracle 11i ERP implementation with the scope including the following applications: Oracle Financials (General Ledger, Purchasing, Payables, Receivables & Assets), Oracle Projects(Costing, Billing & Project Management), Payroll & Human Resources

- The SASCO solution includes integration with several proprietary legacy systems for job budgeting, costing & revenue recognition & commodities purchasing.

- Key requirements from SASCO include:

  • Reporting of non-diminishing project commitments
  • Tracking of under and over billings (unbilled receivables & unearned revenue)
  • Integrated project costing with payroll processing
  • Detailed costing of payroll-related burdens for line items on cost-plus invoices
  • Project set-up and invoicing to comply with the American Institute of Architects (AIA) standards

Variation of revenue recognition based on the % spent of cost budget method

Stage Stores, brings nationally recognized brand name apparel, accessories, cosmetics and footwear for the entire family to small and mid-size towns and communities with over 735 stores in 38 states.

-  Functional Analyst lead responsible for developing solution designs for project and asset lifecycles.  This effort, aimed at implementing multiple Oracle Projects Modules (Project Costing and Project Foundation) and integrating them with Fixed Assets, Account Payables and Purchasing.

-   The Stage Stores solution was implemented and designed for the purpose of controlling costs associated with new and existing store development.

Key requirements from Stage Store include:

  • Add new projects and tasks in Oracle Projects module for new stores, remodeled stores etc.
  • Associate project information on the supplier payable invoices in Oracle Accounts Payable module.
  • Interface project supplier invoices from Oracle Accounts Payable to Oracle Projects and track capital and CIP costs.
  • Interface associate non-CIP related assets directly from Oracle Accounts Payables to Oracle Fixed Assets.
  • Create assets in Oracle Projects module and relate them to project or task or sub-task levels based on business requirements (WBS).
  • Capitalize projects as they complete and interface assets to Oracle Fixed Assets.
  • Split an asset line and allocate costs to multiple assets based on projects by GL account (asset category)
  • Track, sort, report, projects by cost center and department.
  • Track projects by Capital vs. Expensed.
  • Track projects by the year they are added.
  • Setup existing projects for reference to the converted fixed assets.
  • Enter additional projects costs manually and distribute expenses to GL directly (includes Labor, Usage and Miscellaneous etc.).
  • Capitalizing Interest.

 

Rosendin Electric, Inc., consistently ranks in the top ten electrical contractors in the United States, which has over 80 years of proven experience & performance.

-  PM for this project-centric Oracle 11i (11.5.10) ERP implementation with the scope including the following applications: Oracle Projects(Costing, Billing & Project Management), Payroll, Human Resources, General Ledger, Purchasing, Payables, Receivables & Assets

-  The Rosendin solution includes custom extensions to meet specific labor costing, purchasing, billing & union benefit deduction business requirements applicable to REI’s industry.

Key requirements from Rosendin include:

  • Integrated project costing with payroll processing (actual payroll costs with associated fringes)
  • Project set-up and invoicing to comply with the American Institute of Architects (AIA) standards
  • Trade Services database and vendor pricing updates in purchasing module
  • Automatic intelligent PO numbering within each project number
  • Tracking of unbilled receivables & unearned revenue
  • Equipment usage & small tool management integrated with project costing
  • Accounts Payable to hold retention amounts on subcontractor invoices as required

 

GES Exposition Services, Inc, provides exhibition and event services in every major convention market across North America. They produce many of the world’s most recognized trade shows including IMTS, CONEXPO/CONAGG, Consumer Electronics Show, National Association of Broadcasters, MAGIC, World Shoe Associates, National Restaurant Association, E3 and COMDEX.

- Key positions as Project Manager and Lead Solution Architect for this Oracle 11i Project-centric/Financials implementation with the scope including Oracle General Ledger, Oracle Payables, Oracle I-Expenses, Oracle Purchasing, Oracle I-Procurement, Oracle Fixed Assets, Oracle Project Costing, Oracle Project Billing, Oracle Internal Control Manager.

- The GES total solution involved integrating 12 highly industry-specific legacy systems key to the corporations operations. The solution incorporated 60 RICE (reports, interfaces, customizations and extensions) objects with the Oracle E-Business Suite.

- Key Functional Requirements from GES:

  • Two-way interface between Hyperion budget tool and Oracle Projects/GL
  • Journalize payroll entry from Highline/P2K (legacy) to Oracle GL
  • Interface Highline/P2K labor costs and corresponding benefits to Oracle Projects
  • Workflow notification to buyers when the PO’s are about to expire
  • Gateway to interface Tradeshows from operational systems (legacy) to Oracle Projects
  • Automate the reversal of project revenue accruals (reverse event in future period)
  • Set-up Project Status Inquiry (PSI) for expense tracking and budget to actual analysis
  • Configure Requisition, PO and AP workflow to automatically create Accounting FlexField combination from project attributes.
  • Customize process to accrue project-based PO’s in GL which have not been received
  • Build Discoverer reports to leverage Oracle Business Intelligence and Noetix Project and Financial views.
  • Integrate Oracle Internal Control Manger to comply with section 404 of Sarbanes-Oxley

 

Kinetic Concepts, Inc. (KCI), San Antonio, TX, is a global corporation providing leading edge innovation in Wound Care, Pulmonary Care, Bariatric Care, and circulatory improvement to patients in all care settings.

- PM and Oracle Projects Subject Matter Expert for this 11.5.8 Oracle Projects Costing implementation.

- The KCI solution includes implementing both capital and indirect projects. Indirect projects to track KCI R&D projects and capital projects to track IT infrastructure projects.

- Key Functional Requirements from KCI:

  • Track purchasing commitments in Project Accounting
  • Track all project related payables
  • Track employee time and cost in Project Accounting
  • Track inventory cost in Project Accounting
  • Allocating engineering cost from the ledger to projects
  • Allocate cost from –one project to multiple target projects
  • Utilize Project Status Inquiry for expense tracking and budget to actual analysis
  • Utilize Expenditure Inquiry Review for making adjustments and fixes
  • Utilize transaction controls and hard limits to prohibit unauthorized spending
  • Automate GL accounting via auto-allocation rules
  • Automate FAS 121 capitalization rules utilizing standard Oracle task based capitalization functionality

 

SASCO Electrical Construction & Data Systems, the largest privately held electrical and data contractor in the United States (ENR), with 8 offices on the West Coast extending from Southern California to the Northwest

- PM for this project-centric Oracle 11i ERP implementation with the scope including the following applications: Oracle Financials (General Ledger, Purchasing, Payables, Receivables & Assets), Oracle Projects(Costing, Billing & Project Management), Payroll & Human Resources

- The SASCO solution includes integration with several proprietary legacy systems for job budgeting, costing & revenue recognition & commodities purchasing.

- Key requirements from SASCO include:

  • Reporting of non-diminishing project commitments
  • Tracking of under and over billings (unbilled receivables & unearned revenue)
  • Integrated project costing with payroll processing
  • Detailed costing of payroll-related burdens for line items on cost-plus invoices
  • Project set-up and invoicing to comply with the American Institute of Architects (AIA) standards

Variation of revenue recognition based on the % spent of cost budget method