WORK SAMPLES

• Samples of my Oracle , DB2 and SQL Server Data Models
• SSIS / Informatica 9.2 ETL mappings
• Data Warehouse Architectures
• Data Integrity Analysis plus BI Analytics with reports / scoreboards

TECHNICAL SKILLS SUMMARY

Data Science/ Data Management / Enterprise Data Architecture/ Data Governance 20 years expertise in the following:

Computer Languages

Platforms

Development / Reporting Tools

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse and Business Intelligence Developer

• Healthcare Data Warehouse Platform Evaluation QlikView, Oralcle, HIT, IBM plus hybrids
• KMC Healthcare Data Mart development SQL Server2012 -SSIS
• Data Warehouse implementation Clinical and Financial healthcare data
• Data profiling , analysis and cleansing - Cerner, ShowCase, PBR, Lawson ,Kronos
• Data mapping, migration and conversion to Data Warehouse Platform - QlikView
• Data Dictionary development, data model development Visio and QlikView
• Reference File Conversion Master Data Management Berson / Dubov
• QlikView Expressor - ETL development
• BI Analytics development QlikView scorecards / reports plus SAP Business Objects

Confidential

Data Architect Data Analyst contract

• Data Profiling Worker's Compensation source systems 1,609 Tables
• Data analysis and cleansing
• Data mapping, migration and conversion from DB2 AS 400 to Oracle 11.0
• Data Dictionary development, data model development ERwin Data Modeler
• Reference File Conversion Master Data Management Berson / Dubov
• Data Extraction and Encryption.

Confidential

System and Data Architect Data Modeler Developer contract

• Drug Utilization Review and Rx Claims-Rebate Accounting System ETL Developer
• Data analysis, data profiling integration, Meta Data Management , data mapping
• Conceptual and technical system design shared visualization
• Financial BI Analytics - DB2, AQT Informatica ETL MicroStrategy Reports IBM iSeries
• Data Warehouse and Data Mart development and modification Kimball / Inmon
• Data Architecture using conformed dimensions and synonyms - Master Data Mgmt
• Data Modeling Conceptual, Logical and Physical using ERwin and ER/Studio 9,1,1
• DDL script and table generation Stored Procedures and Materialized Views

Confidential

System and Data Architect Data Modeler Developer contract

• Financial BI Solutions - SAP, Business Objects, Oracle, TOAD, PL/SQL Informatica Requirements V 9.1
• Data Architecture using Data Vault, Enterprise Data Warehouse and Data Marts
• Data Architecture using conformed dimensions and synonyms- max data integration.
• Logical and physical Data Modeling using Erwin and ER/Studio
• Data Analysis-Profiling-Cleansing, Master Data Management, DDL script generation
• Used Ragged de-normalized hierarchies to optimize BI analytics and reporting.

Confidential

System and Data Architect Data Modeler Developer contract

• Developed and simulated the Data Warehouse ETL using Informatica 8.6 and SSIS ETL
• Developed conceptual, logical, physical data models using Erwin r 7.3.
• Data architecture included flat files, relational, dimensional data structures.
• Dimensional tables included slowly changing Type 2 dimensions and conformed dimensions.
• Provided data analysis, data profiling and data cleansing for relational tables.
• Facilitated data and system requirement gathering and BI Analytics workshops with IT and Stakeholders.
• Developed predictive BI analytics using OLAP UDM Cubes using SSAS, SSIS and MDX expressions and MicroStrategy.

Confidential

System and Data Architect and Developer contract

• Used SQL Server 2005 Analysis Integration Reporting Services.
• Facilitated the gathering of user requirements and OLTP data analysis.
• Data analysis, data mapping, creating data dictionary, data modeling, Meta data development.
• Developed the conceptual, logical and physical dimensional data models - Erwin Data Modeler r7.2.
• Developed the entire data warehouse including the Fact and Dimensional tables.
• Developed, tested ETL using SSAS, SSIS Developed the reports using SSRS
• Populated and documented the Data Warehouse and placed it into production.
• Developed BI analytics using OLAP UDM Cubes using SSAS, SSIS and MDX expressions.
• Provided a strong advocacy for data integrity. Developed SQL scripts for data validation.

Confidential

Technical Project Manager / System and Data Architect / Principal Developer contract

Project: Outage Management System Upgrade Project

• Managed the simultaneous testing and deployment of 2 major power distribution systems with 300 tables.
• Established 2 dedicated test facilities and procured the test hardware.
• Developed the test scripts and the Implementation Plan.
• Acquired a detailed knowledge of the SCE Electrical Grid includes: Trans- mission lines, Switching Centers, Substations, Circuits, Structures, Equipment and Customers.
• ODRM tracks outages on the 52,000 sq mile electrical grid and 5 million customers residing in a very large database
• Conducted the triage sessions at the conclusion of the daily test sessions.
• Conducted the data integrity testing using PL/SQL test scripts Oracle tables.
• Participated in the testing and gathering the testing statistics.
• Reviewed literally thousands of outages and modified the cause definitions.
• Facilitated the gathering and documentation of user requirements.
• Provided the data analysis, data mapping, creating data dictionary, data models, and gap analysis. Used ERwin data modeling tool and templates from the DWH Lifecycle Tool Kit
• Developed the system architecture using graphic for a shared system visualization.
• Developed ODRM system from scratch using Visual Studio.Net Smart Client UI.
• Developed and tested the UNIX code to extract data from the OLTP tables.
• Developed Oracle stored procedures and triggers.
• Data analysis, data mapping, created data dictionary, data modeling, and gap analysis.
• As data architect - developed logical and physical data models.
• System architecture diagrams available on request.
• Managed the offshore contingent Chennai, India.
• Developed over 100 Metrics and KPI reports using MicroStrategy
• Used AllFusion ERwin Data Modeler r7.2, ER/Studio 8.5.3.
• Developed the ETL using Informatica v.7.4 migrated to Informatica 8.6.
• Implemented the data warehouse tables in DB2 for the mainframe.
• Generated reports and analytics using MicroStrategy.
• Developed SQL and PL/SQL scripts for data validation using TOAD and AQT.
• Developed the Data Architecture.
• Tested and deployed the system Visual Studio.Net SAS, DB2 MVS COBOL .
• Developed the Reports and Analytics using MicroStrategy and SAS.
• Developed Outage Metrics using SSIS and SSRS.
• Developed CRM Stats using SSIS and SSRS.

Confidential

System and Data Architect and Developer contract

• Developed the Outage data warehouse.
• Facilitated the gathering of the user requirements and OLTP data analysis.
• Developed data warehouse including fact and dimensional tables.
• Used Informatica for the ETL and MicroStrategy for the reporting and analytics
• Developed the logical and physical dimensional data models using ERwin v. r7.2

Confidential

Manager, Data Warehouse

• Managed a very large 200 tables retail data warehouse for Worldwide Shipping, Receiving and Distribution Data.
• Responsible for the development, maintenance and daily operation of the data warehouse.
• Performed continuous data cleansing and data validation.
• Informatica 3.0 to 6.0 ETL Oracle based with UNIX, MicroStrategy Analytics and Reporting.

Confidential

Data Analyst and Programmer contract

• Legacy System redesign and Y2K remediation of 6 major mainframe Systems
• Remediated Reviewed Modified Tested > 986,000 lines of legacy system code

Confidential

Architect / Developer contract

• Established the Data Administration processes and standards.
• Developed Lotus Notes groupware applications.
• Developed the data models and data warehouse architecture for the Loss and Premium data warehouses.
• Modeled relational and dimensional tables using ERwin.
• Implemented the Enterprise data architecture using MicroStrategy for analytics and reporting. Referenced IBM - IAA's Insurance Application Architecture.

Data Architect / Developer contract

• Facilitated the requirements gathering.
• Created logical / physical dimensional data models.
• Developed the architecture for Credit Profile data warehouse.
• Used MicroStrategy for reporting and analytics.
• Referenced the IBM Financial Services System Architecture included Fair Isaacs data.