Summary

Accomplished IT professional, MBA with successful track record in designing

and deploying end-to-end enterprise solutions, business and IT requirements

gathering and business process management. Architecting end-to-end data

analytics and business intelligence solution implementation along with

working experience in enterprise architecture, proof of concept, gap

analysis, system capacity planning, applications/system DR assessment and

planning. Dedicated individual and team player with a unique blend of

expertise in functional, technical, infrastructure planning and setup,

integration and project management. Specific expertise in:

Strategic IT Planning Enterprise Solution Architecture

Business Intelligence Certified Critical Thinking and Problem Solving

Data Warehouse Certified

Enterprise Architecture - TOGAF Project Management

Architecture Data Design & Modeling

Education

M.B.A - Strategic Management, Davenport University, Grand Rapids, Michigan

B.S. - Electronics Engineering, ITT Technical College, Denver, Colorado

Certifications: Training:

DW 2.0 Data Warehouse Architect TOGAF - Enterprise Architecture

Certified - Oracle OBIEE, Essbase, HFM

Bill Inman IT Planning and Problem Solving

Business Intelligence Certified ETL - Informatica PowerCenter

Professional

IT Project Management - Colorado State

University, Denver, Colorado

Technology

OS - Unix, Windows; Databases - Netezza, Oracle 11g and SQL database Server

BI Tools - OBIEE, HFM, Hyperion Essbase, Cognos, Tableau

Design Tool - Erwin data modeling, Enterprise Architect

ETL Tools - Informatica, Data Stage, AB Intio

Professional Experience

Optimum Data Analytics, Inc. (GE/Talers)

May 2013 - Present

Sr. Solutions IT Architect

Producing architecture designs for borad range of programs and leading

solution development and execution. Provides professional services as an

independent consultant for an organization that provides airlines carriers

around the world with services focused on improving operations by

leveraging aircraft performance data and performing predictive analytics to

reduce operational losses.

. Working effectively across organization boundaries and cross functional

teams to align project goals and providing solutions to deliver

analytical programs for the organization. Created solution architecture

and plans the development effort.

. Led Proof of Concept for different technology tools, provided

recommendation and project execution plan and cost. Developed reusable

assets such as solution architecture, both physical and logical.

. Provides strategic thinking and products technology solution roadmap

enhancements and establishing end-to-end multi-tenancy technology

solution and recommendation while working with GE Software Center of

Excellence.

. Leading Analytical project architecture design effort to standing-up

front-end business intelligence and back-end DW architecture design and

facilitating information architecture technology roadmap with the

organization CTO.

Invensys - Plano, Texas

Nov 2010 - May 2013

Senior Principal IT Architect

Participated in information-gathering sessions to determine and assess

project requirements, identify best-fit architecture and technology

solutions that are in line with architectural standards, business needs in

finance and business intelligence domains.

. Conducted Gap Fit Assessments and Business Process Reviews. Created,

reviewed and evaluated design requirements documentation and proof of

concept (POC) as they pertain to a client engagement

. Implemented technology roadmap, standards and processes for a DW/BI

enterprise reporting solution aggregating multiple divisional ERP

applications data for BI reporting. Generated corporate data models, data

dictionary and subject area BI reporting models for KIPs, dashboards and

metrics

. Defined security architecture, and applied enterprise standards, policies

and reference architectures to all solutions including disaster recovery

(DR), disaster simulation exercises, business continuity and fail over

processes

. Provided technical leadership and hands on design leading

solution/vendors evaluation and worked with 3rd party vendors to define

and deliver applications

. Supported vendor management concepts including SLA's, SOW, change

management, problem management and evaluated commercial-of-the-shelf

packaged solutions for BI and Finance

. Generated corporate data model, data dictionary and subject area

reporting models. And reviewed BW/BI vendor products (Oracle, SAP) for

functionality and compatibility in existing technical landscape

. Reviewed BW/BI vendor products (Oracle, SAP) for functionality and

compatibility in existing technical landscape. Supported vendor

management concepts including SLA's, SOW, change management and problem

management

. Managed HFM V11 environments design, configuration, disaster recovery

(DR), capacity planning, support and maintenance of 500+ users in a

global environment

Aleris International, Inc., Irving, Texas Apr 2005 - Sept 2009

Architect - Business Intelligence/Data Warehouse

Led end-to-end hands-on design and implementation of Aleris first Business

Intelligence (BI) and Data Warehousing (DW) project that resulted in

capturing Line Of Business (LOB) customer profitability by item in order to

increase revenue margins and drive down production cost.

. Captured business BI requirements and designed OBIEE BI dashboards,

reports, metrics, DW ERwin logical/physical data models, data marts

dimensional modeling (star/snowflake), slowly changing dimensions, ETL

Staging, Informatica mappings to outsource data from different

manufacturing systems, performance tuning, created DDLs, front-end

reports and conducted training

. Developed Hyperion Essbase cubes for finance BI reports and front-end

OBIEE enterprise reports, dashboards, architected back-end data

warehouse, ETL and data integration processes

. Collaborated with the business leaders and IT in developing shared vision

and roadmap for the Business Intelligence and Data Warehouse initiative

across the organization

. Managed the Data Warehouse/Business Intelligence production environment

which included vendors management, tools selections, capacity planning,

disaster recovery, and licensing control

. Devised and implemented a Business Intelligence technology roadmap for a

global organization, set-up BI environment utilizing Oracle OBIEE BI tool

on the front-end and Oracle 11g, and Informatica ETL tool on the back-end

. Facilitated JAD sessions, and provided data architecture and project

design reviews and technical direction for Analytical reporting, KPI,

dashboards, scorecard metrics, and ad hocs needs.

. Met with business leaders and assisted in designing custom end-user

training sessions to increase BI analytical visibility across the

organization and assisted in building BI standards for documentation

. Implemented company wide data standards and data dictionary to unify data

management across the organization

. Supported and maintained OBIEE and Oracle DW production environment for

100+ BI user community. Managed environment capacity planning, support

and disaster recovery expectation

Advanced Tech Solutions, Inc., Dallas, Texas Jan 2003 - Apr 2005

Lead -- Business Intelligence/Data Warehouse

Coordinated and participated in the consumer lending DW design for Capital

One to ensure the overall data warehouse architecture meets management

analytical needs

. Participated with business owners/partners to ensure initiatives were

implemented to promote EDW across the enterprise rather than departmental

. Analyzed business processes and identified functional and technical

system requirements and communicated project scope, deliverables, budget

and development needs to an off-shore team

. Implemented a full cycle DW project to meet the organization strategic

business initiative adhering to Ralph Kimball methodology and managed a

staff of seven employees

. Evaluated current technical architecture and backend design and worked

with off shore development team to resolve technical issues

. Coordinated with teams DW design review to ensure reliability,

performance, scalability, fail-over and backup and recovery

. Led technical architecture reviews in evaluating DW technologies, wrote

high level design documents and presented recommendation based on

business needs

Advanced Micro Devices (AMD) Inc., Austin, Texas Dec 2000 - Jan 2003

Data Warehouse Architect/Project Manager

Designed and implemented AMD first DW which captured manufacturing

processing lines granular data such as the electrical characteristics of

wafers during manufacturing processing in order to enhance future chip

design.

. Outlined the DW project life cycle implementation phases from inception

to delivery which included business need assessment, data source

definition, data source analysis, physical design, technical

architecture, data staging and loading, and end user acceptance testing

. Managed Data Warehousing project which included risk assessment, roadmap

planning, developing project time lines, budgeting, researching material,

writing specifications, locating suppliers, team management, analyzing

customer needs, and requirement gathering

. Participated in custom software package commercialization effort for the

semiconductor market segment. Researched and analyzed competitors' market

segment

Bosch Inc., Grand Rapids, Michigan Jul 1997 - Aug 2000

Manager, Information Systems

Managed Oracle manufacturing databases, network infrastructure operation

(LAN & WAN), helpdesk operation and a staff of seven employees.

. Coordinated global deployment initiatives with Bosch global IT team in

deploying IT infrastructure changes company wide and assisted in defining

and implementing IT procedures and guidelines

. Managed vendor's selection and installation of EMC Storage Area Network

(SAN) company wide

. Led the design and upgrade of company wide network infrastructure Fiber

Optic backbone and the upgrade of data center Cisco network switches

Previous Employment History

53 Bank, Grand Rapids, Michigan - Systems Engineer Mar 1995 - Jul 1997

JD Edwards, Inc., Denver, Colorado - Systems Analyst Apr 1994 - Mar 1995

Contact this candidate