SUMMARY:

A thought leader with over 20 years of progressive IT experience spanning management consulting, department leadership, project management, data integration, data solution architecture and hands - on technical delivery. I have demonstrated a breadth of technical skills as well as a diverse set of architectural and leadership experience that has allowed me to be successful in a plethora of roles delivering data integration, data warehousing, master data management and business intelligence solutions across industries.

TECHNICAL SKILLS:

Oracle 10G

Microstrategy DSS Agent / Architect (ROLAP)

SQL Server 2005

IBM DataStage (ETL)

IMS

Constellar Hub (ETL)

IDMS

DataMirror (ETL)

MySQL

Prism Warehouse Executive (ETL)

DB2

Borland C++ Builder (Development)

PostgreSQL

Tibco (Messaging Integration)

MyEclipse (JEE IDE)

Pentaho Data Integration Hub (ETL)

Kalido (Master Data Management)

MQ Series (Enterprise messaging)

E/Rwin

C, C++

Oracle Designer

COBOL

Sybase PowerDesigner

Java

Embarcadero E/R Studio

SQL

Enterprise Architect

PL/SQL

Mondrian OLAP Schema Designer

T-SQL

Dezign

XML

MDX

IT Solution Architecture

Oracle Performance Tuning

Business Intelligence / Data Warehousing

Master Data Management

Logical / Physical Modeling of both OLTP and dimensional models

Project Management / Leadership

Data Architecture

Enterprise Data Integration

Client Relationship Management

Agile, RUP and BI Methodologies

PROFESSIONAL EXPERIENCE:

Enterprise Architect

Confidential

Responsibilities:

• Leading a team to develop a master data management solution to integrate data across several systems and platforms to create a holistic view of customer data across the enterprise
• Canonical modeling enterprise objects into a unified database design and XML schema
• Instituting data governance, business process reengineering, data quality tracking, web service data access layer and auditing
• Custom-development of MDM solution using industry tools and technologies

Solution Competencies: Master Data Management, enterprise data integration, enterprise modeling, data architecture, data management, project planning, SOA, ESB

Technologies: XML Spy, DataStage, PowerDesigner, Oracle, SQL Server

Data Warehouse Architect

Confidential

Responsibilities:

• Responsible for creating a flexible data warehouse solution to deliver bio-analytics focusing on the occurrence, identification and drug interactions for bacterial organisms
• Designed star schema with various subject areas per the information requirements for detailed analysis across all subject areas
• Tuning database to support volumetric and response-time requirements for canned reporting using indexing, partitioning, materialized views, summary structures, block size adjustments, disk allocation and multi-threaded queries
• Engaged in evaluation of MOLAP solution vs SQL-based solution based on performance, long-term flexibility and ease of development / maintenance
• Created complex SQL queries against data model to deliver various reports across multiple fact tables

Solution Competencies:Data warehouse data modeling, performance tuning, SQL development, Agile, SOA

Technologies: Postgresql, Agile, MDX

Master Data Architect

Confidential

Responsibilities:

• Worked as a master data architect delivering an MDM solution for SAP using Kalido
• Responsible for requirements gathering, enterprise data modeling, business process analysis to support master data business workflows that integrate with SAP
• Worked with international team across Argentina, Brazil, Canada and US to standardize global definition of business data model and universal workflows
• Responsible for training all users as well as extensive technical documentation, FAQ and help documents
• Coordinated technical team to implement a closed-loop interface to from Kalido MDM solution to SAP via MQ Series to generate IDOCs

Solution Competencies: Master data management, technical writing, enterprise modeling, business process reengineering, requirements gathering, testing

Technologies: Oracle, SAP, Kalido, MQ Series

Data Architect

Confidential

Responsibilities:

• Worked as a data architect delivering OLTP and BI solutions for the agriculture and biotech industry to support predictive analysis and information-based decision-making
• Responsible for full-lifecycle requirements, design and deployment of physical data models using Agile methodology to iteratively deliver DW and OLTP solutions in SOA environment
• Performance tuning Oracle instance, object, ETL job streams and SQL queries for optimal performance against SLAs
• Introduced and implemented formal BI methodology supporting information requirements traceability, metadata capture and iterative delivery
• Conducted source system analysis and created technical specs for ETL development and data migrations
• Created PL/SQL packages to support change-data-capture (CDC) and ETL functions

Solution Competencies: Data warehouse and OLTP data modeling, performance tuning, SQL development, data migration, BI methodologies, Agile methodology, data integration, ETL development, database deployment, data architecture, SOA

Technologies: Oracle, PowerDesigner, Pentaho ETL, PL/SQL

Data Integration Architect

Confidential

Responsibilities:

• Served as the data architect for enterprise data integration project involving exchanging data with external trading partners via EDI as well as sharing data with ERPs and custom applications via event-driven-architecture on ESB
• Decomposed a plethora of individual point to point feeds into an integrated model of shared data. We then translated this into a message tree to determine the consumers for the standardized data messages
• Created common information models of all shared business objects and business events and implemented via data models and XML schemas
• Created temporal data store to persist data from COTS package until it was transformed into XML message and placed on ESB via Tibco
• Created T-SQL scripts to trigger the capture of business events in COTS package to translate them into messages for downstream consumers

Solution Competencies: Enterprise data integration, canonical modeling, XML modeling, Agile, SOA, ESB

Technologies: Oracle, SQL Server, Tibco BusinessWorks, DataStage, XML Spy, T-SQL

Lead Data Architect

Confidential

Responsibilities:

• Led five data architects in establishment of data architecture discipline and the implementation of healthcare data warehouse (HR, finance, supply chain, revenue, health management and various ‘spread marts’)
• Served as member of BI Architecture and Enterprise Architecture Teams
• Leading database efforts to improve performance including adjusting block size, reallocating tablespaces and partitioning to improve database performance
• Worked with Business Objects developers in the creation of Universes that aligned our information requirements, security requirements and delivery requirements with the subject area mappings in the data warehouse

Solution Competencies: Data warehouse data modeling, performance tuning, data architecture

Technologies: DataStage, Oracle, PowerDesigner, Business Objects

Lead Data Architect

Confidential, St. Louis

Responsibilities:

• Responsible for all aspects of database design and data architecture for enterprise-class solution to support the collection, dissemination and analytics of financial transactions between hundreds of parties and over 600 federal agencies
• Designed a hybrid architecture comprised of a transaction broker and data warehouse
• Translated JAD notes and use cases into data requirements
• Participated in technical infrastructure design for network architecture, data architecture, security architecture and capacity planning
• Authored data management plan to support high-availability, data retention and performance requirements

Solution Competencies: Data warehouse data modeling, OLTP data modeling, data architecture, enterprise architecture, requirements analysis, canonical modeling

Technologies: Erwin, DataStage, Oracle, Business Objects, Crystal Reports

Team Leader / Data Integration Architect

Confidential

Responsibilities:

• Responsible for all aspects of database design, data architecture and data migration for reengineering of legacy OLTP system supporting loan making and loan servicing
• Participation in JAD sessions to reengineer business process and derive business and data requirements
• Created logical and physical model to support over 100 use cases
• Lead a remote development team of DataStage developers to execute data migration plan to seed database with historical data and other interfaces. I created all transformation rules and technical specs
• Created interface plan to integrate new system into new master data stores and web interfaces for centralized data

Solution Competencies: Data integration, OLTP data modeling, requirements analysis, business process analysis, data architecture

Technologies: DataStage, PowerDesigner, IDMS, DB2, SQL Server, J2EE

Team Leader; Data Architect

Confidential

Responsibilities:

• Responsible for data architecture, database design and ETL for data warehouse to measure the performance and effectiveness of service centers using 75 KPI across three subject areas
• Translated JAD notes, reviewed historical reporting and interviewed SMEs to create inventory of KPIs, the mathematical formulas and the raw data required to provide exception-based reporting as well as ranking across statistical metrics
• Performed logical and physical dimensional modeling for star schema
• Performed source system analysis to determine sources for data and the required transformation rules to homogenize the data into integrated data warehouse
• Created SQL for development team to derive the calculations from the star schema to support the reporting requirmements

Solution Competencies: Data warehouse data modeling, data architecture, requirements analysis, information architecture, SQL

Technologies: PowerDesigner, DataStage

Team Leader / Department Leader

Confidential

Responsibilities:

• Served as the Departments Leader of Database Applications with responsibility for over 30 associates that included DBAs, data architects and project managers
• Created database technology strategies and procedures.
• Supported all disaster recovery processes including real-time data replication to second data center and database failover procedures for 24/7 availability for four database platforms

Solution Competencies: Leadership, data architecture, disaster recovery

Technologies: Oracle, Erwin, DB2, IDMS, SQL Server

Project Manager / E-Commerce Team Leader

Confidential

Responsibilities:

• Served as project manager, data architect and technical lead of n-tier e-commerce extranet
• Re-platforming the order fulfillment business process from AS/400 legacy system including online custom configuration
• Architected topology and architecture for fault-tolerant solution for redundant hardware, load-balanced web balanced web servers and application servers with database failover
• Managed project plan, daily tasks, scope management, risk management, cost and communication plan
• Designed logical and physical models per business process and data integration requirements
• Facilitated and participated in several JAD sessions to drive out data requirements as well as interface requirements between Oracle ODS and MACPAC legacy system

Solution Competencies: Project leadership, data integrations, data architecture, data modeling, technical architecture, business process requirements

Technologies: Oracle, Erwin, AS/400, DataMirror, Selectica