SUMMARY:

• A versatile, full life cycle, enterprise wide, Business Intelligence, Data Warehouse and Data Integration consultant, with equally strong hands - on hybrid competencies as Data Architect, Business Analyst, Project Manager and Developer.
• Exclusive focus on Data Warehouses and Information Integration since 1994 was preceded by equal time as a Business Manager, including CFO/CIO. Dave’s consulting competencies include Data Governance, Data Modeling, Project Management, Standards and Methodology, Business Rules, Requirements, Profiling, Patterns, Extract\Transformation\Load (ETL), Data Quality, Testing and Master Data Management for a variety of clients.
• As a Technical MBA/CPA Dave has been successful leveraging these diverse skills to multiply the effectiveness of project teams, to enable clients to capitalize on their ability to coordinate data, people and technology to implement Analytics, Business Intelligence, Data Warehouses, Application Integration, B2B Integration, Merger Consolidations, Balanced Scorecards, Activity Base Costing, Pricing Dashboards and other strategic solutions dependent on data, in all functional areas of business. Industry Specialties are Utilities, Financial Services, HealthCare, Distribution and Manufacturing.

TECHNICAL SKILLS:

Data Modeling: Erwin Model Mart v9, ADW, IEF, Visual Analyst, VISIO, Excelerator

ETL: INFORMATICA PowerCenter 9.6.1, INFORMATICA Data Quality Developer 9.5, PeopleSoft EPM Data Loader, MS SQL-Server Data Transformation Services

Database: ORACLE 11g, DB2, Netezza 7, SQL SERVER 2012, Progress, MS-Access, SQL/DS, RDB, DBASE

Project Management: MS-Project, Instaplan, ABT Project Management Workbench, Primavera (P3)

Business Intelligence OLAP: Cognos 10, Hyperion, Business Objects, Power Analyzer, HOLOS, MS-Excel

Automated Testing: HP Quality Center, Informatica, SIS-G Automated Testing Tool

Query: SQL-Developer, IBM Data Studio, Toad, SQL-Navigator, MS Query Analyzer, DB Artisan, MS-Access, SQL-PLUS, ISQL, SPUFI, PROEDIT

ERP: PeopleSoft, SAP, Oracle Applications, QAD, Tetra, Siebel, Salesforce

Application Development: Visual Basic, Powerbuilder, MS-Access, Cool Gen, DBASE, FOCUS

Web Services: SoapUI, Informatica

Methodology: Informatica Velocity, IBM RUP, Agile, SIS-G RAID, Kimball Data Mart, Catalyst, Summit, Information Engineering, IDEF1X

PROFESSIONAL EXPERIENCE:

Confidential, Northbrook, IL

Data Warehouse and Data Integration Architect, Project Manager

Responsibilities:

• As Team Lead of a team of up to 10 consultants, delivered a long series of overlapping Data Integration, Data Warehouse and Business Intelligence project releases to implement Smart Grid Analytics, energy regulatory compliance operational reporting and cost reduction objectives for the Customer Data Warehouse.
• Analyzed existing applications, profiled data, defined requirements, modeled data, defined ETL standards, specified coding logic, directed testing automation and supervised implementations.
• Major accomplishments included a Customer Data Warehouse Roadmap followed by construction of a 10 terabyte enterprise Customer Data Warehouse (CDW), implementing a Corporate Information Factory architecture, sourcing two 3 billion row fully atomic fact tables from the billing system, tying to general ledger daily, and feeding 14 downstream Data Marts.
• Deployed Team Based Development, Version Control, Test Documentation reviews and other structured development methodologies.
• Managed the installation of Informatica’s mainframe change capture software to eliminate expensive COBOL extracts by reading DB logs to replicate Customer ERP system tables in the Operational Data Store.
• Significantly reduced testing time, reduced incremental release impact risk and improved data and process quality by directing a custom VB-Script coding extension of HP Quality Center to iteratively implement a fully automated, regression testing environment for all data warehouse and data integration processes related to CDW.
• Executed all test scripts for all releases from the automated test environment, so that a robust set of over 700 automated test scripts were accumulated for execution prior to each major release.
• Designed and implemented a comprehensive Inter-Database Data Quality Scorecard that reported customer bill level variances between six integrated systems including CDW, billing and Retail Office energy market settlement.
• Managed the information lifecycle and analyzed the impact of sun-setting job schedules, UNIX scripts, Informatica sessions, Hyperion reports and Oracle database objects replaced by the enterprise wide Customer Data Warehouse.
• Prepared detailed plan for phased decommission of legacy data mart and related integration.

Confidential

Data Warehouse Performance Tuning Architect

• Re-architected critical Informatica PowerCenter 9.6.1 ETL maps, sessions and workflows and Oracle 11g components to modernize the Healthcare Provider Master Data Repository for significant data volume increases.
• Introduced Informatica Key Range, Pass Through and Hash Key Partitioning architecture to improve performance by 40% with parallel processing.
• Implemented modifications to Informatica ETL architecture by modeling temporary table structures, bulk loading and introducing Oracle table MERGE functionality to eliminate slow running update statements.
• Iteratively analyzed sessions prioritized by runtime, to accommodate growing data volume.
• Trained client staff on performance enhancement methodologies, data profiling, template solutions, design standards and architectures, enabling staff to later implement specific performance enhancement initiatives defined in in a detailed recommendation deliverable.

Confidential

Enterprise Data Warehouse Architect

• On a full life cycle basis, independently and agilely built major integration components of an Enterprise Data Warehouse supporting over 600 users. Consolidated, standardized, cleansed and conformed data from three business units and supported their phased system consolidation.
• Defined business rules, wrote requirement use cases, profiled source data, scoped sprints, estimated effort, modeled tables, specified transformations, enforced data standards, coded over 300 ETL maps, coded UNIX shell scripts, coded Excel macros, integrated web services, resolved issues, automated testing and scored data quality.
• Sources included SAP Financials, Mainframe Billing, Siebel CRM, PROS Pricing Analytics, Ignite Acorn Activity Based Costing, ADI Time Management, Pick-To-Voice, custom web services, flat files and hundreds of spreadsheets.
• Major accomplishments included agile implementation of star schemas for analysis of Enterprise Sales, Credits, Profitability, Operations, Pricing and Activity Based Costing. Other deliverables were Data Governance procedures, a highly collaborative methodology, agile translation of requirements to working ETL, high velocity development iterations, automated Data Quality Scorecard and early delivery to aggressive timelines.
• Analyzed and coded Master Data Management merge maps to build enterprise product and customer hierarchies that identified and consolidated same customers and products from multiple business acquisitions.
• Technical architecture was Informatica PowerCenter 9.5, Oracle 11, AIX UNIX and SQL-Server 2012.

Confidential

Data Integration Architect

• Collaborated in the design, documentation and webinar demonstration of SIS-G’s Advanced Testing Automation software product, integrating Informatica with HP Quality center to automate Data Warehouse test cases.
• Co-presented to the Microsoft Project Users Group at the IBM Innovation Center, SIS-G’s integration of software from multiple vendors (IBM Rational, Microsoft Project, Informatica) to provide extreme automation of data warehouse project management from Requirements to Work Breakdown Structure to Project Planning to Collaborative Workflow to Automated Testing of ETL Maps and back to Collaborative Workflow for defect resolution.

Confidential

Financial System Consolidation and Integration Architect

• As the senior member of a SIS-G team of six, analyzed existing applications and defined requirements and coding specifications required to consolidate Data Warehouse systems to complete the merger of two large banks.
• Defined data warehouse data and processes required to integrate new source systems and create consolidated business intelligence extracts to the new corporate parent from 8 source systems including 5 lines of business.
• Converted and retired many processes and data structures. Trained client analysts to data model for Data Warehouses. Created and executed test plans and scripts to ensure compliance and smooth production implementation.

Confidential

Packaged Data Warehouse Configuration Architect

• Advanced to the next level of productivity in Data Warehousing, by extracting, integrating and reporting metrics for a diverse, multinational business, implementing a pre-built DW package in 90 days.
• Led a team of technical resources to configure analytic requirements, including currency conversion, into the Informatica Applications data warehouse package.
• Designed PowerCenter ETL specifications to load SQL Server stars from 15 sources, including QAD and Tetra ERP systems, at newly acquired companies around the world.
• Coded 12 PowerAnalyzer reports and facilitated data warehouse acceptance testing by coding Informatica testing maps. Co- designed a short and long term Information Strategy Roadmap with the newly hired CIO.

Confidential

Data Warehouse Architect

• Directed a team of 10 technical and business resources to define, prioritize and document requirements and detail specifications, for real time integration (SeeBeyond and Data Propogator) to an Enterprise Data Warehouse, using the Joint Requirements Planning facilitation techniques.
• Drove the project from the data modeling role by modeling enterprise wide conceptual, logical and physical ODS, warehouse and mart data models and EAI for 20 stars using conforming dimensions.
• Managed the specification, coding and testing of high volume EAI/ETL from Siebel, PeopleSoft, transaction processing and custom billing source systems, producing 2 million transactions per day.
• Analyzed and compared ETL, Reporting and Packaged Data Warehouse tool functionality. Consulted in the tool selection process for a zero client footprint, web based reporting extranet portal for up to 25,000 customers, merchants and partners.

Data Architect

• As a senior member of the Technical Architecture team, led 40 developers in the design and generation of 200 tables and associated Informatica extract, transformation and load (ETL) mappings, for a large Oracle Operational Data Store and Data Mart.
• Facilitated quality control walkthroughs of over 100 detail designs and subsequent program code. Formally trained 17 developers in Informatica PowerMart and 10 DBAs in logical/dimensional data modeling with ERwin.
• Modeled data and processing requirements in star schemas for decision support Cognos cubes, ad-hoc queries and an Internet web site for customers and partners to download billing and metering history.
• Modeled an operational data store for e-commerce EDI and operational package interfaces. Sources included Oracle Financials, Peoplesoft and a variety of custom packages, accessed in Oracle, DB2, SQL-Server and flat files. Established and enforced standards for database, ETL, object migration and version control.

Confidential

Data Warehouse Architect

• Led a Data Warehouse project from tool selection (Holos, Business Objects, Analytics, Erwin Model Mart, Oracle) through a long series of monthly production releases of Marketing, Finance, HR and Cable Operation balanced scorecards.
• Defined user requirements, release scope, required resources, data models, OLAP/ad-hoc browsing strategies, extracts, transformations, loads and test cases.
• Integrated data snapshots from DB2, VSAM at a remote timesharing vendor, Oracle, Foxpro, Btrieve, MS-Excel, MS-Access and Peoplesoft.
• Data models included all source systems, stage, ODS, fact, dimension, customer relationship management and data mining tables.
• Developed an application to stratify customers based on their overall value for use in a Reward Program.
• Created development methodology, metadata, prototypes, and database sizing models.
• Transformation designs included cleansing, integration, aggregation, audit and control.
• Conducted formal JRP, JAD and data warehouse training sessions. Managed migration to an upgraded server.

Confidential

Data Architect and Lead Information Engineer

• Conducted work flow and labor full time equivalent (FTE) analysis, decomposed existing business processes into data flow diagrams, and issued replacement system cost/benefit analysis.
• Planned and facilitated complex multimedia Joint Application Development sessions with user, management and MIS personnel.
• Modeled complex Entity Relationship Diagrams (95 entity types) in IEF CASE tool, prototyped screen navigation and layout (80 screens) and decomposed logical business process hierarchies to depict essential re-engineered business operations.
• Established and enforced analysis and design methodology standards across business systems.
• Conducted on-site formal CASE training sessions and 'boot strapped’ the client staff into an Information Engineering team.
• Programmed and installed Customer and Order Entry business systems. Managed the CASE central encyclopedia for project team sub-setting.
• Coordinated unit, integration and acceptance testing environments. Specified data mapping and processing logic for interfaces to legacy systems and EDI vendors