SUMMARY:

• Senior Consultant with 20 years as leadership of Information Management solutions
• Provide clients current state analysis, document business requirement and data gaps, provide strategy(tactical/strategic), build road maps, implementation plans, timelines, delivery milestones, skills & resource requirements, provide project plan and project cost
• Build Data Warehouses, Data Marts, ODS, from scratch to turn key completion
• Provide conceptual and logical models based on the business requirements
• Design solution architecture to meet needs of client using industry best practices and tools
• Provide management oversight of technical and client team staff
• Discovery data issues and work with business SME on Data remediation
• Work with business BI Reporting(static/dynamic) and Analytics to meet the client needs
• Excellent verbal and written communication
• Proven successful deliverables on time and on budget
• Exceled in project leadership for onsite and offshore teams

TECHNICAL SKILLS:

Techology and Tools: Informatica - IDQ 9.5 (Address Doctor 5.9.2, Analyst / Developer Tool), MDM, PowerCenter 9.5 (Standard and Advanced Edition), PowerExchange, Power Connect, Metadata Manager, Metadata Exchange, B2B Cognos - Report Manager, Decision Stream, EP Panning(Now Confidential TM1) Hyperion Planning Oracle - Warehouse Builder R2, Discoverer, Portal, Analysis Services, ERP/eBusiness Suite, PeopleSoft, OBIEE SAS - Data Miner, Predictive Analytics ( Confidential t Care, Fleet Management) Pattern Analysis, DI, BI (Dashboard, Score Cards, Cubes) Business Objects R3, Xcelsius, Flash Actuate Microsoft SSIS/SSRS, SharePoint Toad, Erwin, SQL Developer, Rapid SQL FirstLogic, Trillium, Global IDs, Informatica IDQ / IIR Operating Systems & System Utilities MS Windows, Unix, Linux, OS/VS Database Management Systems Oracle 10G/11G, SQL Server, DB2, IMS, VSAM, Adabas, Teradata, IDMS, EMC Greenplum Commercial Software MS Project, MS Word, MS Excel, MS Visio, MS Outlook

PROFESSIONAL EXPERIENCE:

ETL Architect Consultant

Confidential - Burbank CA

Responsibilities:

• ETL Architect data integration from SAP BW and external sources to Data Warehouse
• Built financial Data Warehouse for Confidential TM1 repository - Plan Forecast and Actuals
• Developed mappings specifications based on business requirements
• Identified data gaps and determine solutions
• Worked in war room setting with daily update to Kanban Board

Data Quality Consultant

Confidential - San Diego CA

Responsibilities:

• Informatica IDQ Analysis and Developer Tool to determine the data quality issues
• Informatica IDQ with Address Doctor for address validation and other critical fields

DQ/Solution Architect

Confidential - Sacramento CA

Responsibilities:

• Provided strategy, Best Practice and process for establishment of Data Quality for Enterprise Company Data
• Determined data available for support of Informatica MDM with (9) multiple domains
• Established Data Quality roadmap and provided IDQ
• Executed IDQ using Informatica Analysis Tool to determine the DQ issues
• Determine Remediation process for bad data with additional business rules or correction to source of Record

Data Quality Consultant

Confidential - Warren NJ

Responsibilities:

• Provided Data Quality strategy for consolidation of Wyndham Brands
• Determined data available for support of Informatica MDM Customer Hub
• Determined application inventory and priority of data to be profiled and loaded into MDM
• Determine Data Quality issues and Remediation process for bad data
• Determined requirement and infrastructure needs for Informatica IDQ with Address Doctor
• Coordinate the required installs of and postal tables required for international profiling

Data Quality Consultant

Confidential - Richmond VI

Responsibilities:

• Data Quality evaluation of Banks data needed for MDM
• Evaluation between Informatica IDQ and Global ID for profiling banks customer data
• Established the inventory of systems required for phase 1 along with KPI’s
• Outlined implementation plan for phase 1

Data Quality Consultant

Confidential - Nashville TN

Responsibilities:

• Team lead to provide strategy for Informatica IDQ Data Quality Implantation and deployment
• Completed Current State Assessment of existing Data Quality process (manual SQL)
• Determined the issues with current IDQ 8.6 and upgrade to 9.5 IDQ with Address Doctor
• Identified inventory of inputs both batch and real-time for Oracle MDM/UCM Customer Hub loads
• Monitored the installation of Informatica IDQ 9.5 with Address Doctor and JasperSoft
• UAT first international country (India) with IDQ 9,5 and Address Doctor mail formats
• Determine Remediation process for bad data
• Coordination Informatica Population (US/Canada/international), and file loads
• Worked with team on MDM data model based on data inventory

Data Architect / Team Lead

Confidential - Pittsburg PA

Responsibilities:

• Analysis of Credit Risk Current State Reporting
• Review of regulatory reporting requirements
• Provide recommendations for replacement of current manual SAS and Excel spreadsheets with ETL and BI tools for dashboards, scorecards and regulatory reports
• Provided roadmap timeline and resources for Data Warehouse Credit Risk Reporting

Data Architect

Confidential - Minneapolis MN

Responsibilities:

• Provided Marketing with strategy to use EDW for increase revenue
• Determined Current and Future State
• Researched buy vs. build enterprise banking model
• Determined how to o utilize existing 19 DW as sources for building new EDW Hub
• Completed inventory of banks existing tools and determined which tool would be used for building EDW and BI reporting
• Provided recommendation of conceptual model, bank existing tools, required staffing, phased timelines, cost and implementation plan
• Provided roadmap for execution of future state

Data Warehouse Architect / Team Lead

Confidential

Responsibilities:

• Team Lead to build a marketing EDW to determine usage of Pharmaceutical products
• Determined Platform, Modeling, ETL, BI tools to be used
• Led the analysis of Current State Architect, ETL process, BI tools and Home Portal
• Worked on tool recommendations for model, database, ETL and BI tools
• Worked with vendors on Japanese conversions to English for ETL and BI process
• Designed Dashboards with detail drill downs

Senior Consultant

Confidential -Minneapolis MN

Responsibilities:

• Confidential - EIM strategy for MDM, Data Quality, Data Governance, Self Service BI

Data Architect / Team Lead

Confidential

Responsibilities:

• Determined requirements for data migration
• Identify key KPI’s required and BI/Analytics needs
• Data Migration to MPP platform
• Provide roadmap for Sybase to MPP Greenplum conversion
• Establish criteria for ETL POC migration with Informatica
• Determine BI/Analytics Data Mart required and designed Home Portal page
• Developed Strategy for Cognos migration to Business Objects
• Completed prototypes for dashboards and scorecards

Data Architect Data Warehouse Evaluation

Confidential -Boston MA

Responsibilities:

• Host requirement JAD sessions and on SLA issues
• Analysis of Current State Architect
• Analysis of performance on ETL load process and work flow
• Review stored procedures vs. ETL capabilities
• Analysis of schedules and window for clients deployment across world
• Provided tool recommendations for ETL and BI tools
• Recommended changes to process flow and scheduling

Data Architect / Team Lead

Confidential

Responsibilities:

• Team Lead the analysis of Bank Fraud software vendors
• Determined from list of vendor Fraud software the top 5
• Utilizing COT execute a POC with same criteria for each vendor
• Made final recommendations based on POC results

Data Architect / Team Lead

Confidential

Responsibilities:

• Team Lead the analysis of Bank Mergers
• Developed from data mapping from purchased bank to Confidential
• Provided DQ on merged data
• Worked with vendors on mass issuance of check and credit cards

Program Manager

Confidential - Owens Mills MD

Responsibilities:

• Led team for building a Claims EDW across states
• Provided healthcare data models for claims EDW
• Responsible for building EDW for Member, Provider

Data Architect DW/BI/ETL

Confidential - Jacksonville FL

Responsibilities:

• Led Transportation (Railroad) projects providing the Call Center with real time and batch updates for improving service and performance to their customers
• Provided executive reporting on “Coal” top revenue product
• Provided “End of Train” motoring system for lost cars and engines
• Provided Equipment Utilization and Engineering statistics
• Drove ETL (Informatica) migration and BI Business Objects R3 using Xcelsius with Flash for dashboards

Data Architect

Confidential -Rock Leigh NJ

Responsibilities:

• Led Enterprise Data Warehouse (EDW) Assessment and built a Data Mart for Medical Lab executive reporting (hospitals, doctors, facilities and Confidential ts)

Data Architect Automotive Service / Warranty

Confidential - Irvine CA

Responsibilities:

• Built Data Warehouse for all service and warranty work done at dealers
• Designed BI reporting - Analytics

Data Architect

Confidential - Columbus GA

Responsibilities:

• Helped establish template for Bank Migrations

Data Architect

Confidential - Houston TX

Responsibilities:

• Designed and built Data Warehouse of Merchant inventory and transactions

Senior Data Architect Data Modeler

Confidential - Louisville KY

Responsibilities:

• Built logical model to reflect multiple Brands
• Archive applications at Carrier and Whirlpool to eliminate computer cost

Data Architect DW/BI/ETL

Confidential -Tallahassee FL

Responsibilities:

• Team lead for creation of Statewide Law Enforcement repository of all violations
• Worked with each police department to migrate their data into repository
• Worked with dispatch vendor to use arrest repository data to send to police cars
• Shared Hub data with FBI, Homeland Security and others

Architect / Team Lead

Confidential -Atlanta GA

Responsibilities:

• Provided EDW Assessment, for Arby’s to determine market share of company vs. Franchise stores
• Provided roadmap of data into providing “One Source of Truth” for all customer base regardless of brand
• Provided cross- and knowledge transfer for internal resources on best practices with ETL, EDW, Staging, ODS and Data Marts
• Supported selection of ETL and BI tools after providing specifications and monitoring the vendor POCs

Director Manager for DW/ BI

Confidential - Ft Lauderdale, FL

Responsibilities:

• Provided the DW/BI Strategy and implementation of Business Reporting (dashboards, drill downs) to companywide intra network for all regions, district and POS stores
• Provided current team with necessary as required
• Hired consultant services and supervised ETL and BI implementations
• Deployed first executive management Dashboards and Scorecards for measuring performance of stores within demographics
• Provided process for automated reconciliation of ODS and Data Marts Using First Logic Profile tool
• Provided roadmap for success in both future implementations and software needs

Senior EDW/BI/ETL Architect

Confidential - Miami, FL

Responsibilities:

• Led efforts of 12 internal resources to determine school requirements
• Provided the “blueprint” for building a central information repository for district-wide information, which would serve the critical needs of the students, teachers, administration, and management
• Provided recommendations for the EDW solution, which included Modeling tool, ETL tool, BI tool, platform and operating system
• Identified 80 legacy silo systems and their data elements used in new software packages
• Designed dashboards, reports for executive management, administration, teachers, students and parents

Project Manager

Confidential - Miami FL

Responsibilities:

• Hired consultant services and supervised implementations
• Provided IT solutions for selection, monitoring a 4.2 billion Facility /Capital Construction using Magellan, Primavera, Maximo, Informatica and Cognos
• Developed workflows with all new software packages for each department in Facilities

VP Director EDW/BI/ETL

Confidential - Winston Salem, NC

Responsibilities:

• Lead multiple teams comprised of 30 resources for a clinically focused health information management startup company dedicated to assisting employers, healthcare providers, research organizations, and healthcare payers to analyze, evaluate and track Confidential t outcomes, identify trends and benchmark best practices.
• Responsible for the architecture of Data Warehouse (HMO Claims and Clinical to 80 Hospitals)
• Determined the business requirements for the Claims and Clinical DW thru JAD sessions
• Established timelines, project plans, budgets, cost and resource estimates for implementation
• Developed logical models for both warehouse using Erwin (EDI formats used as guideline)
• Developed ETL mapping for Informatica for extraction and transformation rules
• Deployed Cognos Reporting across the company
• Developed household and name matching routines using FirstLogic
• Established and managed multiple vendor relationships during POC and application development
• Ensured product development was HIPAA Security Compliant
• Converted legacy claims and clinical data from and to EDI 5 / HL7 Formats
• Determined the IT requirements and managed the installation of the hardware, operating platforms, website, storage capacity, backup and recovery capabilities and Host location
• Negotiated contracts and purchased the Modeling, ETL, BI, and CRM systems and operation platform

Senior Architect Business Intelligence

Confidential - Ft Lauderdale, FL

Responsibilities:

• Lead on building EDW for all staffing needs

BI Mainframe Migration Actuate BI tool

Confidential - Ft Lauderdale, FL

Responsibilities:

• Migration from green bar reporting to Actuate BI

Data Integration to EDW

Confidential - West Palm Beach, FL

Responsibilities:

• Built EDW using Informatica ETL and Cognos BI

EDW Validation

Confidential - Hartford, CN

Responsibilities:

• Review of EDW Implementation plan with recommendations

EDW Strategy

Confidential - Columbus, OH

Responsibilities:

• Evaluation of Catalog sales vs. revenue by geographic areas

Senior Architect EDW

Confidential - Nashville, TN

Responsibilities:

• EDW of hotel and amusement park customers