We provide IT Staff Augmentation Services!

Project Manager / Solution Architect Resume

Naperville, IllinoiS

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

Hire Now