TECHNICAL SKILLS SUMMARY:

Data Science/ Data Management / Enterprise Data Architecture/ Data Governance - 20+ years

EXPERTISE IN THE FOLLOWING:

Data Architecture: Relational, Fact, Dimensional, Hierarchies, Aggregates, Master Data tables. plus QlikView, Flat files, Hierarchical files (IMS), DDL, Views, Materialized Views and JAD

Data Modeling: Canonical, Conceptual, Logical, Physical and Star Schema Models - ERwin, ER/Studio

Data Analysis: Data Profiling, Data Cleansing, Data Mapping, Data Mining, Data Rationalization

Data Management: Metadata Repository. Data Dictionary, Master Data Management, Data Lineage

Data Warehouse: Development, Implementation, Operation - Kimball / Inmon and Linstedt Data Vault

Data Movement: Data Migration, Integration, Conversion - ETL using QlikView, Informatica, SSIS.

Data Analytics / BI: QlikView, OLAP Cubes, SQL, SSAS, MDX, Big Data, Deterministic and Stochastic models.

Data Governance: Policies, Standards, Procedures and Best Practices - Data Management Manager

COMPUTER LANGUAGES:

Development: Visual Basic, C++, C#, Java, XML, XSD, COBOL, JCL, DL-1, UNIX, Stored ProceduresFunctions and Triggers

Query: SQL, SQL *Plus, T- SQL, PL/SQL, My SQL, MDXPlatforms

QlikView: Expressor, Dimensions, BI Expressions - Scoreboards and Reports

IBM Mainframe: DB2 AS 400, IMS, MVS

Oracle: Oracle 11g

MS SQL Server: SQL Server 2005, 2008, 2012 SSIS, SSAS, SSRS

Development / Reporting Tools Development: QlikView, TOAD, AQT, iSeries Navigator, SSIS, SSAS, Sparx Enterprise Architecture

Reporting: QlikView, MicroStrategy, SSRS, BI Objects, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Data Warehouse and Business Intelligence Developer, Data Architect

Responsibilities:

• 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

Responsibilities:

• Data Profiling - Worker’s Compensation source systems
• 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, Santa Ana, CA

System and Data Architect - Data Modeler - Developer

Responsibilities:

• Drug Utilization Review and Rx Claims-Rebate Accounting System ETL Developer
• Financial BI Analytics - DB2, AQT Informatica ETL MicroStrategy Reports IBM iSeries Navigator
• Conceptual and technical system design - shared visualization
• Data analysis, data profiling integration, Meta Data Management, data mapping
• 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, Tucson, AZ

System and Data Architect - Data Modeler - Developer

Responsibilities:

• 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, Roswell, NM

System and Data Architect - Data Modeler - Developer

Responsibilities:

• 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, Santa Monica, CA

System and Data Architect and Developer

Responsibilities:

• Used SQL Server 2005 – Analysis – Integration – Reporting Services.
• Facilitated the gathering of user requirements and OLTP data analysis.
• Data analysis, data mapping, creatingdata 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, Rosemead, CA

Technical Project Manager / System and Data Architect / Principal Developer

Responsibilities:

• 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.
• Participated in the testing and gathering the testing statistics.
• Conducted the data integrity testing using PL/SQL test scripts – Oracle tables.
• Conducted the triage sessions at the conclusion of the daily test sessions.
• ODRM tracks outages on the 52,000 sq mile electrical grid and 5 million customers residing in a very large database
• Acquired a detailed knowledge of the SCE Electrical Grid –includes: Trans- mission lines, Switching Centers, Substations, Circuits, Structures, Equipment and Customers.
• Reviewed literally thousands of outages and modified the cause definitions.
• Facilitated the gathering and documentation of user requirements.
• Provided the data analysis, data mapping, creatingdata 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.
• Developed over 100 Metrics and KPI reports using MicroStrategy
• System architecture diagrams available on request.
• As data architect - developed logical and physical data models.
• Data analysis, data mapping, created data dictionary, data modeling, and gap analysis.
• 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, Columbus, OH

System and Data Architect and Developer

Responsibilities:

• 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, Burbank, CA

Manager, Data Warehouse

Responsibilities:

• 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, Los Angeles, CA

Data Analyst and Programmer

Responsibilities:

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

Confidential, San Antonio, TX

Data Analyst and Architect / Developer

Responsibilities:

• 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.