Solution Architect

Posted on by kwitt

Sep 2002 – Mar 2006

Hyperion Solutions (acquired by Oracle in 2006)

Stamford, CT

As a Solution Architect at Hyperion Solutions, I played a pivotal role in designing, developing, and deploying enterprise-wide Business Intelligence (BI) and Enterprise Performance Management (EPM) solutions for Fortune 500 clients across multiple industries, including Northrop Grumman, Agilent, Baker Hughes, SAIC, and Toyota. I was responsible for leading end-to-end architecture, ensuring seamless integration of financial planning, data warehousing, and analytics into clients’ existing technology landscapes.

Key Contributions & Responsibilities:

  • Enterprise BI & EPM Solutions: Led the architecture and implementation of scalable Hyperion HFM, Planning, and Essbase solutions, enhancing financial consolidation, reporting, and strategic decision-making for major clients.
  • Client Engagement & Solution Delivery: Partnered with senior executives and business stakeholders at Northrop Grumman, Agilent, Baker Hughes, SAIC, and Toyota to assess requirements, define roadmaps, and implement high-impact data solutions tailored to industry-specific needs.
  • Data Modeling & Integration: Designed optimized data models and developed ETL workflows using Informatica, Oracle, and Microsoft SQL Server, ensuring seamless data movement and transformation.
  • ETL & Data Warehousing: Engineered robust data warehousing and ETL pipelines, improving data governance, accuracy, and integration across enterprise resource planning (ERP) and customer relationship management (CRM) systems.
  • Agile & SDLC Leadership: Championed Agile and Scrum methodologies to streamline solution delivery, foster collaboration, and accelerate go-to-market timelines.
  • Technology Stack Optimization: Implemented high-performance BI environments leveraging Oracle, WebLogic, SAP EIM, and Microsoft SQL Server, optimizing query performance and reporting efficiency.
  • Governance & Compliance: Established data governance frameworks, master data management (MDM) policies, and compliance strategies, ensuring adherence to financial and regulatory requirements.
  • Cross-Functional Collaboration: Worked closely with development teams, business analysts, and IT leadership to deliver best-in-class BI, EPM, and analytics solutions.

Key Clients & Industry Sectors:

  • Northrop Grumman (Defense & Aerospace) – Enhanced financial and operational reporting with Hyperion Planning & Essbase.
  • Agilent Technologies (Life Sciences & Manufacturing) – Implemented enterprise BI solutions to improve data-driven decision-making.
  • Baker Hughes (Oil & Gas) – Designed a unified data architecture for streamlined financial forecasting and performance analytics.
  • SAIC (Government & IT Services) – Developed secure BI solutions for federal and defense data analytics initiatives.
  • Toyota (Automotive) – Integrated Hyperion EPM with existing ERP systems for enhanced supply chain and financial reporting.

Key Skills & Technologies:

  • Data Warehousing & Data Modeling
  • Business Intelligence & Data Analytics
  • Enterprise Performance Management (EPM) & Data Governance
  • Hyperion HFM, Planning, Essbase
  • ETL & Data Integration (Informatica, Oracle, Microsoft SQL Server, SAP EIM)
  • Agile Leadership & SDLC
  • Enterprise Architecture & Solution Design
  • Stakeholder Management & Leadership
  • WebLogic, Visio, and Master Data Management (MDM)

This role was instrumental in shaping my expertise in BI, data integration, and enterprise performance management, providing a strong foundation for data architecture and business intelligence strategy leadership.

Leave a Reply