SUMMARY:

• I am skilled in Big Data, Data Modeling, DBMS, PM and specialize in development efforts that integrate data and design data lakes and warehouses. Data models with enterprise level conformed dimensions and taxonomy and grain specifications are only part of my capabilities. I can help you id and integrate unstructured and semi structured data lakes with structured RDBMS systems and BI reporting or data linage, master data management and meta data management. I act as or provide support for designer, administrator and some coding all in support of a data owner, SME or steward. I also have a data management strategy for mixing unstructured data with semi and fully structured data. Confidential that I can support the generation of specifications for near real time ODS, departmental governance and business rules needed for an ESB. I am fully versed in DB2 tuning including bind options, explains, correlated sub selects and the like
• . I also performed DB2 sysplex tuning for the Social security administration as part of a Lockheed Martin contract
• I am versed in Cassendra DB, HSQL and Agile development. Data Base Management Systems Utility DDL and DML supported including; Oracle, DB2/UDB, SAS and SQL Server. Data modeling support includes; Star for OLAP and Snow flake third normal form for OLTP for both dimensional modeling and Data Mart design with ETL support while using Erwin, Sybase SAP Power Designer, IBM Rational System Architect and Sparx Enterprise Architect systems. Please note Erwin now supports Big Data cloud systems like AWS as well as Casendria. In the past as an infrastructure engineer, I have set up and run an R&D Lab to facilitate on site benchmarking of various configurations. I have integrated many COTS packages.

PROFESSIONAL EXPERIENCE:

Datawarehouse Architect

Confidential

Responsibilities:

• Installed SAP Power Designer, created as is and to be OLTP and OLAP models, created swimlane process documentation, created Share Point directory design and created data warehouse documentation, established ODBC connections, worked on Hana/SQL server linked servers, encapsulated existing BO feeds in new design, business and surrogate key reviews and tuning of existing systems and queries, created operations support DB, created best practices white papers.

Consultant

Confidential

Responsibilities:

• Provided Oracle GL general ledger data linage analysis tracing external feeds through Oracle and into a Big Data repository. Provided multi jump source to target data mappings complete with processing notations. Provided analysis of Oracle and Big data structures and made recommendations on Structure MDM and work flows. I worked with Impala on a set of Hive Clouderia Hadoop data marts. I reverse engineered unique and primary keys and identified data organization issues for both the Oracle and Big Data systems.

Data Architecture/ Modeling Support

Confidential

Responsibilities:

• I did data modeling manager work for the data analytics group. The company is the credit union for Microsoft employees. I designed and implemented a conformed dimensional enterprise data warehouse using a Kimball Zachman approach. The environment was an Erwin OLAP setting for relationally linked indexed tables in MS SQL Server. Designed landing interrogation and semantic layer structures for the Big data BI reporting. Additionally, the work included the development and enhancement of procedures for managing table and attribute definitions as well as data linage and a proposed MDM data security interface.
• I design a data integration layer, ODS, Data Warehouse and data lakes for RDBMS and Big data systems. Support for a data warehouse by departmental feed the views with source to target mappings for ETL specification. The work included access path analysis and performance tuning and maintenance with other root cause analysis. Identification of PII data for SME governance analysis and design and generation of data structures to support ETL automation was also included. The modification of the work flow between the business analysts, data modelers and ETL dev - ops group was performed and accompanied by naming standard punch ups and industry best practice implementation.

IT Support

Confidential

Responsibilities:

• I assisted with Master Data Management and governance issues. I investigated and proposed rule and threshold changes as well as up and down stream programming fixes to generate a final disposition proposal based on root cause analysis.
• The work included generation of business process model documentation and data linage analysis as well as data score card line item processing for the management of Material Non-Public Information and its impact on surveillance assessments. The work included coordination of efforts with DQP PM’s BA’s and Coders.

Confidential, Pennington NJ

Responsibilities:

• As a contractor via Diversant I provide metadata management support, data linage support for the "COMPLIANCE CONSENT ORDER TECH" group at BOA. Evaluating and establishing Sybase SAP Power Designer procedures for enterprise data modeling efforts in support of data linage reporting is my current work. Ensuring power designer ramp up uses industry standard practices for ODS and DW structures definitions and work flow models and assisting in BI reporting of meta data and data quality enhancement requests is also part of my current work.

Data Architect

Confidential, NewPort News, VA

Responsibilities:

• I was an SSI Consultant for Wolsely-Furguson a premier wholesale supplier of commercial and residential goods. On this contract I aided with generation of a data architecture road map. Additional responsibilities included establishing and maintaining Enterprise Data Model subject area maps data modeling conventions by target environment, naming conventions and class prime and modifier word glossary. Generation of Erwin reports for ETL mapping support and reverse engineering Oracle and Excel data structures for reengineering into OLTP tables and OLAP designs. Project workflow analysis help formalizing the BA DA interface for scope entities and attributes as well as performance tuning and data security data design issues were all addressed. Installed Cassandra prototype for bench marking.
• Evaluation of metadata products and creation of a SharePoint wiki that leveraged the enterprise subject area taxonomy while integrating with updated change control procedures and documentation made for a lot of fun.

Data Architect

Confidential, Bronx NY

Responsibilities:

• Health care data modeling of member plan case assessment and community health data into an OLTP ODS. I am implementing a generalized party model that will support application archiving and a future roll up to an OLAP DW, while in Agile. SQL server and Erwin v9 and 32 bit Excel for current model ODBC connection support are the technical issues. We upgraded to SQL Server 64 bit. A conceptual and logical data model as well as a foundation Data Dictionary import into Erwin and model comparisons are all part of the past sprint and the physical ERD and DDL gen are finished. Windows Security group creation planning, and DBMS level schema level grant work followed. I Taught self-extracting/ updating Excel ODBC queries and dashboard creation.

Consultant Data Modeler

Confidential, N.Y.,N.Y

Responsibilities:

• Consulting support for data centric projects. Attivio and LavaStorm tools are being added to the Erwin and DBMS DBA skill set.

Data Modeler

Confidential, CT

Responsibilities:

• As a data modeler consultant, I supported; generation of custom coded option set files for Erwin forward engineering of models. I debugged and customized Erwin Fet files used in the generation of DB2 v9 and V10 DDL, I updated and analyzed various glossary files for convergence into a common enterprise taxonomy and introduced a new way of reusing logical constructs for improved standardization. Generation of structured to big data interface tables as part of a new DB2 customer product data warehouse. Model mart updates for new and maintenance updates of DB2, Oracle and Teradata DDL generation.

Data Modeler

Confidential, NJ

Responsibilities:

• As a data modeler consultant, I supported; reverse engineering of existing DB structures analysis of naming conventions and comments and mapping to a new proposed SAS marketing system, while helping to generate an enterprise level model template. Additionally, I was involved with the generation of the staging tables and work flows for use with the SAS marketing system.

Information Architect

Confidential, Nashville TN

Responsibilities:

• Agile team data architect, Erwin and Toad data modeling, SA Enterprise Architect Process modeling, Big data design reviews, Oracle tuning and data quality work. Conversion of waterfall artifacts to agile models. EDM advocacy and cross sprint data coordination efforts.

Architect - Principal

Confidential, Bethpage NY

Responsibilities:

• Installation and testing of Data virtualization products. Additional tasks included development of a data strategy and a data project plan template. Work flow and data warehouse modeling and data etymology mapping in support of DB rehosting and redesign effort targeting Netezza. Generation of specifications for near real time ODS, enterprise and departmental governance and business rules as well as an ESB SOA road map. Support for engineering and design IT and industry research as well as project management groups. Data model consolidation and harmonization support.