Summary

Accomplished software architect, senior manager, and consultant. Technical, managerial and business development experience. Worked for a number of top-rated companies - including Cargill, Oracle, PeopleSoft, and PriceWaterhouseCoopers. Experience across several industries worked in a number of countries.

Specialties

Project team leadership technical pre-sales requirements definition database design dimensional and entity-relationship data modeling data integration / extract, transform, load ETL design cube, dashboard, report layer creation business intelligence SaaS BI in the data cloud. Education, health care, insurance, manufacturing, finance, public sector, recruiting, renewable energy, software, telecommunications, and web retail experience.

Experience

Managing Partner / Data Warehouse Architect

• Work iteratively with business IT professionals to develop blended, data-centric solutions using open source/proprietary hybrid technology stacks.
• Model, extract, transform, load, and present data from a multitude of sources - PeopleSoft, SAP, JDE, custom RDBMS, flat files Big Data: Hadoop - HDFS, Hive, HBase , Cassandra, NoSQL, etc.
• Manage multiple, concurrent high-performance teams, clients, and projects.
• Perform pre-sales tasks to close business intelligence deals.
• Developed affordable, incrementally deployed business intelligence modules that integrate data from heterogeneous sources.
• Created a business intelligence data cloud solution that utilizes Amazon EC2 and S3.

Recent Projects

• Built an ETL solution for a global insurance company that interfaced multiple OLTP sources with the IBM InfoSphere Master Data Management MDM Server product Informatica .
• Architected an ETL solution for an online gaming client Pentaho, Vertica, Cognos .
• Designed ETL, database, reports, cubes for major Miami-based global food produce company Pentaho, PostgreSQL .
• Developed ETL, database, cubes, reports for a Boston-based media company Pentaho, PostgreSQL .
• Created an ETL solution for a major financial institution Pentaho .
• Provided an architecture review and ETL training to technical resources at an online travel company Pentaho, Oracle .
• Delivered complex, dynamic ETL, database, cubes, reports to a NYC-based survey company Pentaho, SQLServer .
• Designed and built a business intelligence solution for a service industry client using Oracle, Pentaho.
• Designed and built a business intelligence add-on product for a power industry client using Oracle, Pentaho.
• Delivered an order 2 cash data warehouse for large consumer products manufacturer using SAP R3, Informatica, Oracle, Cognos.
• Architected a web analytics business intelligence solution for large volume commercial web site using MySQL, Pentaho.

• Delivered a Marketing Analytics Solution for Medical Marketing Company using MySQL, Pentaho.

Technical Environment: Amazon EC2 Data Cloud, Cognos, MySQL, Pentaho Business Intelligence Suite Pentaho Data Integration, Pentaho Analysis, Pentaho Reporting, Pentaho Dashboards, Pentaho Server , Informatica PowerCenter, Oracle 10g R2 / 11 Database, SAP R3, Toad Data Modeler.

Architect / Director

• Led multi-cultural reporting and new system development teams for leading software-as-a-service SaaS company.
• Created BI layer object requirements.
• Designed ETL requirements, develop ETL maps.
• Led legacy reporting and new system development teams.
• Worked closely with marketing, product strategy, production dba, development dba and other Technical Environment: All Fusion ERwin, Oracle 10g R2 Database streams, partitioning , Oracle

Warehouse Builder OWB , Business Objects XI R2, Sybase Power Designer.

Architect / Project Manager,

• Developed a real-time, message-based, DW prototype using Oracle Warehouse Builder OWB and Oracle Discoverer.
• Developed an ETL transformation matrix web application prototype to coordinate work between ETL developers and designers.
• Designed ETL transformation matrices.
• Led the Enterprise Warehouse EW ESA and Customer Relationship Management CRM teams.
• Designed and built BI layer objects using MicroStrategy, Business Objects, and Discoverer tool sets.
• Automation ESA and Human Capital Management HCM pillars.
• Designed and built dimensional data models to support PeopleSoft Enterprise Services
• Developed prototype ETL maps using the latest beta version of OWB.

Technical Environment: All Fusion ERwin, Ascential DataStage, Ascential MetaStage, Business

• Objects, JDE, Microstrategy, Oracle 10g Database, Oracle Warehouse Builder OWB , Oracle
• Discoverer, Oracle jdeveloper, PeopleSoft, SQL Server.

Architect / Project Manager,

• Architected an enterprise, multi-terabyte data warehouse EDW system - source system
• analysis database and extract, transform, load ETL system designs tool selections.
• Optimized performance of existing data warehouse objects e.g., introduction of materialized views, query rewrite, bitmap indexes, etc. .

Software Engineering Methodology: Ralph Kimball's Business Dimensional Lifecycle, David

• Marco's Meta Data Repository Lifecycle.
• Technical Environment: Allfusion ERwin, MicroStrategy, Oracle 8i/9i, Rational Rose.

Architect / Project Manager,

• Worked with senior decision-makers to define the requirements for a global eight country data warehouse GDW system.
• Designed and built the GDW including data staging areas, the ETL system, the relational star
• schemas and OLAP multi-dimensional cubes.
• Redesigned and built the data extract and transformation system for an existing Operational
• Data Store ODS .
• Responsible for enhancements, tuning, and administration of the GDW and ODS systems
• databases, ETL, OLAP .
• Designed and implemented a meta data model for the enterprise.
• Software Engineering Methodology: Informatica Velocity, Ralph Kimball's Business Dimensional
• Lifecycle.

Technical Environment: Cognos BI PowerPlay, Impromptu , ERwin, Informatica PowerMart,Oracle 8i, Oracle PL/SQL.

• Worked with senior decision-makers to establish and refine business areas and OLAP cubes.
• Led a team of developers in the analysis, design and construction of a complex, multi-source
• Data Warehouse Consultant, Intermedia Communications, November 1999 to January 2001.
• data extract and transformation system.
• Responsible for enhancements, tuning, and administration of the ETL and OLAP cube

Software Engineering Methodology: Informatica Velocity Intermedia System Development Life

• Designed normalized enterprise data models to support large data integration efforts led a
• Led a team of developers in the design and construction of a complex DW data extract and
• Cycle SDLC .
• Technical Environment: ERwin, Informatica Power Center, Oracle 8i, Oracle Discoverer 3.1,
• Oracle Express 6.3, Oracle PL/SQL, Microsoft SQL Server 6.5/7.0.
• transformation system contributed to the design of the DW stage and presentation databases
• defined a DW metadata management strategy and DW object naming standards.
• team of full-time equivalents in the development of enterprise logical data models LDM planned and led joint application development JAD sessions.

Software Engineering Methodology: Price Waterhouse System Management SMM

• Participated in all testing phases of Prosper 2.0 - a financial planning software package. As a
• Analyzed and documented business processes and information systems for a local telephone
• Documented various E Y's National Tax Practice business processes and associated data to
• PriceWaterhouseCoopers Ascendant methodologies.
• Technical Environment: BPwin, Business Objects, Composer CoolGen , ERwin, Informatica
• PowerMart, Sybase Adaptive Server Enterprise 11.5, Sybase TransactSQL.
• Confidential
• develop a fully attributed LDM.
• service provider. Coordinated the work of various groups to implement key business rule and system changes.
• result of the comprehensive testing effort, the package received Microsoft Windows 95/NT
• certification.
• Software Engineering Methodology: Ernst Young Navigator.

Technical Environment: BPwin, ERwin, Visual C .

Business Analyst,

• Led a team of analysts dedicated to Polish projects at a U.S. Agency for International
• Development USAID contractor.
• Analyzed more than 50 Polish companies' business strategies and operations and provided
• substantial improvement suggestions.
• Designed and built an OLTP database to support the operations of the organization.