SUMMARY:

• Project Management - Enterprise Business Solutions, Solution & Data Architecture, Business Intelligence
• Confidential has managed many large-scale full-life-cycle Enterprise Business Solution implementations over his 30+ years of consulting experience.
• Additionally, he has configured many of Oracle’s core business functions such as Requisition to Pay, Forecast to Manufacture, Order to Cash, Financials (GL/AP/AR/FA), CRM Field Service, Sales and Marketing, Project Manufacturing/Costing and Oracle Cloud HCM.
• Confidential is also proficient in Business Intelligence solutions, including data sourcing, architecting and end-solution report / dashboard design/development.
• Confidential has managed projects for Fortune 50 companies leveraging a variety of methodologies and tools.

AREAS OF EXPERTISE:

• Project Management / Project Delivery Lead
• OBIEE (Oracle Business Intelligence Enterprise Edition)
• OBIEE Applications
• Oracle E-Business Suite Project (P2P, OTC, Finance)
• Management and Configuration
• Data Discovery / Analysis
• Solution Architecture
• Data Architecture / Modeling
• Data Quality / MDM
• Metadata Management
• ETL/ELT Design / Validation
• Data Visualization Design / Build / Test
• Oracle Discoverer
• Tableau
• Software Development Life Cycle
• Agile / SCRUM Project Delivery
• Business Process Design
• AWS S3/Data Pipeline
• Oracle Cloud Applications
• Media & Entertainment
• Confidential
• Retail
• Manufacturing
• Paint / Specialty Chemicals
• Metals (Steel / Brass / Copper Mills)
• Consumer-packaged Goods
• Food Service
• Defense
• Apparel
• Confidential Systems
• Distribution / Supply Chain Services
• Confidential
• (Research)
• Publishing

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, Illinois

Project Manager / Solution Architect

Environment: Oracle NetSuite, Oracle HCM (Human Capital Management), Oracle PDH (Product Data Hub), OBIEE 12c

Responsibilities:

• Overall project management for HCM (Cloud) implementation (Workforce, Workforce Deployment, Absence and Performance Management)
• Future state visioning (with process flow mapping)
• Custom headcount report design and development review
• SSO (single sign on) design and management
• Active Directory / HCM integration design

Project Manager

Confidential

Environment: Oracle EBS upgrade from 11. .2.6, OBIEE 12C, Card Connect, Custom WMS applications

Responsibilities:

• Overall project management for Oracle EBS upgrade
• Requirements gathering and setup of Oracle iProcurement (including Mobile iProcurement)
• Requirements gathering and setup of Oracle iExpense (including Mobile iExpense) documentation and videos for iProcurement and iExpense
• Development of UAT (user acceptance test) test scripts and associated execution plan for iProcurement and iExpense
• Reconciling / Validation of AP invoicing, payment and account distributions
• Reconciling of Accounts Receivable distributions as part of regression testing for Order to Cash functionality changes.

Project Manager

Confidential

Environment: Oracle EBS - R12 - Financials, Supply Chain, Manufacturing, CRM

Responsibilities:

• Miscellaneous project management for this long-time client
• Responsible for overall planning, tracking to milestones, budget and status reporting.
• Subject matter expert input for all workstreams

Project Manager

Confidential

Environment: Oracle EBS Implementation - original 11.5.10 implementation and recent upgrade to R12.2.6

Responsibilities:

• Overall project management for Oracle EBS implementation and upgrade - Financials, Supply Chain, Manufacturing, CRM (Sales, Marketing, Field Service)
• Responsible for overall planning, tracking to milestones, budget and status reporting.
• Subject matter expert input for all workstreams

Confidential, Atlanta, Ga

Project Manager / Solution Architect

Environment: Oracle BI 11g, Netezza, SSIS, Omniture, Uplynk, Sales Contract System (SCS), Nielson, Rentrak, Hadoop - (Custom Analytics) Linear and Digital Content Analytics

Responsibilities:

• Current state assessment and recommendations for existing Oracle BI implementation
• Roadmap/Strategy for re-implementation of Oracle BI
• Lead execution of a new Oracle BI roadmap
• Led requirements sessions with the client IT and Logistics group to identify key metrics, dashboard, answers requirements.
• Designed the Star Schemas based on the desired functionality. This resulted in 27 dimensions and 6 facts to support cross platform linear (TV) and digital analytics.
• Detailed design for all Informatica ETL source/target mappings to support load of custom dimensions and facts
• Design, configure, and document logical and physical data models, OBI Presentation Layer including administrator functionality. 70+ new metrics defined.
• Design and development of 20+ analytic reports and 4 dashboards to analyze linear and digital content.
• Provided production support for end-users of the system including, responding to questions, resolving problems and providing ad-hoc reporting.

Development Tools: OBI, Oracle BI Answers, BI Administrator, Informatica for Netezza

Project Manager / Solution Architect

Confidential

Environment: Cerner, McKesson, Crimson, Lawson (BI Assessment and Strategy)

Responsibilities:

• Performed current state assessment with requiring requirements sessions with client IT and 57 medical professionals to identify requirements and gaps in current landscape
• Documented current state architecture
• Performed gap analysis between client requirements and existing software capabilities
• Developed future state architecture based on client requirements and recommendations from the current state assessment
• Developed and presented detailed BI Strategy/Roadmap

Confidential, Naperville, IL

Project Manager / Solution Architect

Environment: Oracle BI 11g, Oracle BI Analytics 7.9.6, Oracle BI Applications and Custom Analytics

Responsibilities:

• Executed successful upgrade of OBIEE components from10g to 11g in concert with Oracle E-Business upgrade
• Regression testing and modifications for gaps in upgrade process
• Functional and Technical Design Documents in support the implementation of Oracle’s Retail Store Clustering.
• Requirements, Design, Build for BI Applications requiring customization. Business areas included Order to Cash views with data validation and reconciliation of account distributions (finance) supporting sales reporting.
• ETL validation and OBIEE Admin configuration to facilitate ad-hoc analytics for Store Clustering

Development Tools: OBIEE 11.1.1.6, Oracle BI Answers 7.6.2, BI Administrator, Power Center Informatica 9.01, DAC

Project Manager, Senior BI Solution Architect

Confidential

Environment: Oracle BI 11g, Oracle BI Analytics 7.9.6, (Custom Analytics) National School Bus Route GPS Analytics

Responsibilities:

• Executed successful upgrade of OBIEE components from10g to 11g
• Led requirements sessions with the client IT and Logistics group to identify key metrics, dashboard, answers requirements.
• Designed the Star Schemas based on the desired functionality. This resulted in 7 dimensions and 2 facts to support national school bus route performance analytics based on external GPS transaction sourcing.
• Design and development of all Informatica mappings, transformations to support load of all custom dimensions and facts
• Design, configure, and document logical and Physical Data Models, Presentation Layer including administrator functionality.
• Performed query performance tuning to achieve maximum performance while retrieving data from database structures.
• Design and development of 10 analytic reports and 4 dashboards to analyze bus route efficiency along with child and safety check adherence.
• Provide production support for end-users of the system, including, responding to questions, resolving problems and providing ad-hoc reporting.

Development Tools: OBIEE 11.1.1.6, Oracle BI Answers 7.6.2, BI Administrator, Power Center Informatica 9.01, DAC

Project Manager / Solution Architect

Confidential

Environment: Oracle BI Applications 7.9.6 Analytics for Oracle EBS system. Integration with non-EBS source systems. Integration with Oracle DRM/MDM to provide multi-hierarchical drill-downs for key Financials related data.

Responsibilities:

• Definition and execution of revised implementation approach. This approach undertook a top-down role focus (CEO, CFO, Business Units, Operations Sites, Functional IT, etc) with a custom build methodology utilizing Agile and Scrum.
• Establishment of new governance
• Detailed project planning
• Managing co-located resources
• Revised communication methods for executive management
• Resource to task allocation
• Revised scope and cost/timeline management
• Solution architecture review/approval

Development Tools: OBIEE 11.1.1.6, Oracle BI Answers 7.6.2, BI Administrator, Power Center Informatica 9.01, DAC

Project Manager / Solution Architect

Confidential

Environment: Oracle BI Applications 7.9.6.1 (Financials, Projects, Procurement) Analytics for Oracle EBS system

Responsibilities:

• Providing much needed EBS functional knowledge to the BI Project Team, especially the BI Developers
• Realigning of expecations for the client of what could be achieved by the looming go-live date
• Assessment of where all pending work stood and what it would take to move that work to a state of customer acceptance
• Providing general EBS knowledge to ETL developers
• Development of technical design and SQL code to facilitate custom ETL development
• BI Administration including data import, modeling, presentation
• BI Dashboards/Analysis development, testing,
• Helped develop and support migration processes for client infrastructure team to move BI RPD and Web Catalog across environments (DEV, TEST, UAT, PROD)
• Production Support for all BI Applications components
• Diagnosing and resolving all ETL issues with Production environment
• Assited client internal teams with proper BI Applications development and implementation methodologies

Development Tools: OBIEE 11.1.1.6, Oracle BI Answers 7.6.2, BI Administrator, Power Center Informatica 9.01, DAC

Project Manager / Senior BI Solution Architect

Confidential

Environment: Oracle BI Applications 7.9.6.2 (Financials, HR, Benefits, Compensation) Analytics for Oracle EBS system

Responsibilities:

• Led requirements sessions with Human Resource and Finance groups to identify key metrics, dashboard, answers requirements.
• Designed and developed dimension hierarchies to achieve the drill down functionality, interactive dashboard.
• Designed and developed complex stored procedure, view and materialized view for performance BI Publisher reports.
• Implementing, configuration, deploying Oracle Business Intelligence Enterprise Edition 10g (OBIEE) components in a stand-alone configuration or as part of the Enterprise.
• Involved in BI server and database tuning. Involved in data modeling and query performance tuning to achieve maximum performance while retrieving data from database structures.
• Built the Star Schemas based on the functionality. Design, configure, and document logical and Physical Data Models, Presentation Layer including administrator functionality. Involved in data modeling, including multi-dimensional modeling & Data Warehousing
• Provide production support for end-users of the system, including, responding to questions, resolving problems and providing ad-hoc reporting.

Development Tools: OBIEE 11.1.1.3.0 , Oracle BI Answers 7.9.6.2, BI Administrator and Oracle BI Publisher, Linux 10, Windows NT, Oracle 11, Power Center Informatica 8.6.1, DAC