Senior Data Architect Resume

SUMMARY:

Hands - on experience in driving strategic decisions and governance relating to BI, including EPMA.
Distinguished professional with strong background in BI operation, architecture, infrastructure, design and modeling, as well as whole enterprise data warehouse (EDW).
Proven track record of success in implementing large data warehouse cross-functional projects.
Comprehensive understanding of Extract Transforms and Load (ETL) and Business Intelligence (BI), such as Microsoft, Cognos, and Oracle.
Talented project manager with a focus on developing processes and data warehousing.
Excellent ability to leverage insights from large data to propose strategies and recommendations.
Successfully delivers complex technical matters in a clear, concise manner within tight timelines while maintaining open communication with stakeholders and senior management.

TECHNICAL SKILLS:

BI Tools: IBM/Cognos series 7/8/10, crystal reports, Oracle EPM 11.1.2. OBIEE, OBIA, Essbase

ETL Tools: SQL DTS, Cognos Decision Stream 6.5, 7.0, 8.1, Stored procedures, Microsoft SSIS, HyperionFDQM,ODI, Informatica

Data Modeling Tools: Erwin, Toad, Completed Ralph Kimball Data warehouse in depth course

Databases: Oracle 11,10, 9.x/8.x/7.x/6.x, 11G, MS SQL Server 2008, 2005, 2000/7.0/6.5 , DB2, Microsoft Access

Operating Systems: Windows, UNIX, Open MVS, Mainframe, Linux

ERP: JDE, SAP, E-Business

New Tech: Exadata, Exalytics

Project Management Tools: Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect

Responsibilities:

Oversaw the successful completion of all projects and provided continuous support for Praxair in areas of project management, infrastructure, DBA, modeling, ETL and business analysis.
Rigorously evaluated and estimated global data warehouse projects.
Set strategies, governance, and change control process for BI.
Effectively managed internal team of 10+ and utilized on and offshore consultants for projects.
Partnered with Corporate Accounting and Finance on various initiatives.
Implemented $1M project for pricing incentive in Hyperion, utilizing KPIP vendor (escalation and attainment), which went live in third quarter of 2015.
Set direction and guidance for moving from Cognos to OBIEE, supporting corporate decision to move BI from Cognos to Oracle and working to make goal achievable.
Conducted reviews of Kimball technology (bottom up approach) vs. Bill Inmon top down approach.
Implemented Informatica using Oracle consultants for the BI Apps as a POC, ensuring proper configuration and adherence to best practices and standards.

Confidential

Manager: Global Data Warehouse Projects & EPM

Responsibilities:

Led team of ETL, BI, and data architects, both offshore and onshore model, including contractors.
Effectively managed all phases of the project including analysis, design, build, test and go live.
Supported corporate consolidation and planning, including support, patching, administration, and upgrades and enhancements.
Served as IT Project Manager, replacing corporate consolidation and planning application with Hyperion (including HFM, HP, FDM, ODI, and Essbase) successfully with FP&A group.
Guided consultant firm Cap Gemini during replacement of Global Data Warehouse (GDW) for distribution and operations work, ensuring best practices and standards (data modeling, ETL, and reporting) were followed and signing off on milestones.
Built data warehouse for Global Employee Management System (GMS) from ground up.
Replaced global consolidation and planning application with Hyperion and Oracle Exadata.
Converted Cognos over to OBIEE, and lead external Oracle team and internal team.
Migrated package system from CU (Alpha) to JDE and created and maintained data warehouse for purchase-to-pay and recording-to-reporting modules.

Confidential

ETL Manager

Responsibilities:

Oversaw all ETL changes or enhancements to support new and ongoing projects.
Managed group of ETL experts, and design and modeling personnel, including contractors.
Created and supported operational data store (ODS).
Conducted comprehensive system performance review and tuning.
Served as project manager and ETL developer for PHS, logistics, and global procurement, and GDW projects, achieving success.
Provided application support as IT focal point for Worldwide Consolidation Application, performing as liaison between business and IT.

Confidential

Data Warehouse Architect

Responsibilities:

Provided knowledgeable input for many strategic decisions as lead architect.
Created DTS and stored procedures for ETL.
Worked with Oracle to acquire hardware and implement system, supporting and buying Exalytics.
Brought in Cognos as BI tool, installing software during initial stages.
Led team for converting legacy data into JDE (ERP) systems, including data conversions, historical reporting, and sun setting systems.
Created and supported operational data store (ODS), i.e. following Inmon methodology, using atomic data to move large amounts of data and cleanse.