SUMMARY:

• Thirty years as a Data Strategist bringing passion and commitment to designing and delivering strategic corporate data integration solutions and transforming corporate data assets into corporate information assets. Significant understanding of complex data and enterprise architectures ranging across a broad spectrum of industries including Life Sciences, Health Care Payer, Medical Risk Management, Banking, Investments, P&C Insurance, Manufacturing and Telecommunications. Strong analytical, technical, presentation and interpersonal skills along with solid organizational skills.
• Expert level of understanding and adherence to the tenets of Ralph Kimball in construction of data integration solutions, data warehouse and business intelligence infrastructures.
• Extensive delivery of flexible, sustainable and effective data integration and information system solutions to clients. Extensive knowledge of transactional, operational and decision support systems spanning multiple platforms, applications and technologies. Broad experience with a variety of host data systems and expert abilities in data warehousing, data modeling, SDLC processes, business intelligence and reporting, operational data stores (ODS), capacity planning, data strategy, disaster recovery and performance tuning. Extensive experience with Enterprise Application Integration (EAI) technologies and services, Enterprise Information Integration (EII) technologies, Corporate Metadata Strategy and the use of Extract Transform and Load (ETL) processes in support of corporate data integration requirements. Solid understanding of business process workflow and methodologies. Excellent Troubleshooting techniques, a highly pro - active team player with excellent verbal and written communication skills placing emphasis on schedule, delivery and teamwork. Expert at risk identification, developing QA and test plans. Driven to succeed and to make clients successful.

TECHNICAL SKILLS:

Operating System: Windows 95/98/XP/NT/2003 Server, AIX, Linux, z/OS, MVS

Database: SQL Server 2005, Oracle, Teradata, DB2 Connect, DB2 z/OS, DB2 Linux, DB2 Windows, IMS, High Speed DB2 Utilities, Oracle 9,10,11

Business Intelligence Tools: Hyperion, COGNOS, SQL Server Analysis Services 2005, HANA, Business Objects, Tableau Dashboards. Tableau.

ETL Tools: Informatica, SQL Server Integration Services, MS SSIS, ODI, Data Services

Reporting Tools: Cognos, Hyperion, Business Objects, Crystal Reports, SQL Server Reporting Services, QMF, SPUFI, BIRT, Brio, Tableau

Related: Tivoli Decision Support, Eclipse, Erwin, Informatica Metadata Manager, Microsoft Project/Visio/Office/SharePoint, UML, Popkin s System Architect, EA, Camtasia, Putty

Published and Presented: IBM USA & Europe

PROFESSIONAL EXPERIENCE:

Confidential

Technical Project Manager/Lead Solution Architect

Responsibilities:

• Implemented the Global Business Metrics data warehouse as Technical Project Manager and Lead Solution Architect using the SAP HANA database appliance, BO dashboards and WEBI reports.
• Integration of European Cognos DW with North American DW. Reporting on 25 Enterprise Clients, 750M in annual revenue. Delivered CAB KPI Tableau Dashboard Reporting in support of 400M in annual revenue reporting.
• Realigned and Re-Architect Confidential ’s tactical EDW and disparate Data Marts into a cohesive, responsive BI platform capable of responding to world-wide initiatives around sales, performance and revenue. Evaluate data repositories, analytical software, applications and tools.
• Reduced data redundancy and provide oversight and input into Confidential ’s data management goals, systems, policies, standards, practices, and processes. Socialized a cohesive data management/business intelligence architectural framework. Very significant experience in data management, business intelligence, data governance and quality and master data management (Talend).
• Responsible for Cloud based application integration (SFDC) and Predictive Analytics application integration designed to prevent customer attrition. Proficient in Agile methodology using JIRA and Confluence tools.
• Delivered CAB KPI Dashboards using Tableau & Spotfire for Operational and Financial reporting for 25 Enterprise accounts and 500M in annual revenue.

Confidential

Service Delivery Manager - Data Warehouse

Responsibilities:

• Managing the activities and workload for the Corporate Data Management Data Warehouse team. Driving Solutions Architecture and Development for Energy Efficiency, Revenue Assurance and Safety Analytics as the Service Delivery Manager. Technology Platforms include Oracle & OBIEE, SQL Server, SharePoint & SSRS as well as Ventyx & FocalPoint. Currently managing six vendor and employee resources. Responsible for building and maintaining the corporate Enterprise Data Warehouse, MDM and data governance initiatives.

Confidential

Principal Consultant - Business Intelligence

Responsibilities:

• Designed and built 1600 attribute Enterprise Data Warehouse for Hospital owned health plan. Developed Enterprise Data Warehouse Strategy and Roadmap, Database Standards guide, and drove comprehensive data profiling effort. Conducted numerous business interviews with executives and departmental heads and delivered complete Logical Data Model and data definition. Crafted RFP and SOW materials as required. Created Enterprise data strategy and MS project management deliverables.

Confidential

Data Integration Lead

Responsibilities:

• Provided data analysis and profiling, mapping modeling and strategic support to 15 project teamsspanning full SDLC for all releases. Assessed source, target, and business rule application to all Interface data discovery. Applied standard and best practices and procedures, as well as formal documentation and modeling Techniques. Final project authority on disposition of data mappings, models, design, logically and physically. Worked with
• ETL product and the ETL lead on approach. Determine most effective approach for each functional area's data. Responsible for the final disposition of data models, mappings, dictionaries, and final approval of source and target data analysis as well as data design and production impact Extensive knowledge and understanding of MetaVance data model. Experienced data modeler, analyst, and architect. Experienced application developer. Experienced with HP client support of a MetaVance implementation from inception to implementation. Team leadership experience in an architecture, development, and data management groups.

Confidential

Data Strategist and Capacity Planner

Responsibilities:

• Built 20 terabyte capacity planning data warehouse for z/OS Engineering group. Installed DB2 V910 and Tivoli Decision Support 1.8. Customized the Tivoli Decision Support product using DB2 partitioning to enhance parallel processing and concurrency, achieving a batch cycle reduction from 2.5 hours to 25 minutes. Coded business intelligence queries against TDS data using WinSQL, BIRT and QMF. Exported SMF, RMF and other performance level data into EXCEL pivot tables and charts for dashboard reports. Provided information reducing overhead of 25M in IBM leasing arrangements. Project delivered three months ahead of schedule.

Confidential

Data Strategist Bank of America

Responsibilities:

• Developed and delivered the CMDI - Columbia Management Data Integration dimensional model for Bank of America, including star schema data model, metadata dictionary, and ETL strategy, allowing CMDI to perform real-time sales pipeline analysis using KPI s. Conducted extensive process analysis meetings in conjunction with the business, wrote the Bank of America - Columbia Management Data Integration corporate data strategy promoting integration of disparate sales channel data including CRM, AUM (assets under management) and sales attribution data. Evaluated private cloud based BI & Informatics solutions including salesforce.com, cloud9, SharePoint and Netezza. Evaluated Microsoft s CRM strategy.

Confidential

Enterprise Data Architect

Responsibilities:

• Core member of the BCBSMA data standards committee, authoring the BCBSMA data strategy and master data management roadmap, including data governance, data quality, and metadata management tools & strategies. Responsible for ETL creation of data warehouse feeds as part of core system replacement. Promoted in corporation of UML based Use Cases and spearheaded data warehouse delivery of the Common Information Model (CIM) as the corporate - wide enterprise Metadata strategy and solution. Managed a matrixed team of technical staff in porting legacy mapping repositories to the Common Information Model as the enterprise-wide Metadata repository. Presented Master Data Management principles and updates on a weekly basis to senior management. Lead definition of canonical data models to facilitate SOA based application implementation as basis for major claim and system replacement. Established stewardship for technology governance and data architecture focusing on control procedures and data security.