EXECUTIVE SUMMARY:

• Data Architecture, Master Data and Data Quality professional.
• Published author with over 25 years of experience in Business Intelligence, Data Architecture, Data Warehouse Design, Data Modeling, Master Data Management, and Data Quality in Finance, Telecommunications, Automotive, ITIL Service Delivery industries using Microsoft BI Stack.
• Highlights include staff and consulting roles.
• As a published author wrote several books on data modeling, data integration and C++ programming. implementation, Master Data Management and Data Quality solutions.

SKILLS:

• Conceptual, Logic and Physical Data Modeling, UML, ERWIN, Sybase Power Designer, DeZign by Datanamics, Embarcadero)
• SQL Server (2005 thru 2016) BI Stack Development, Oracle 8i thru 11, PostgreSQL, mySQL, mongoDB, Cassendra, JSON
• Analysis Services Cube Development, Reporting Services reports & dashboards. PowerBI development
• SSIS ETL Development for large data integration projects
• Data Quality Architecture with MS SQL Master Data Services, DQ Services
• Data Warehouse STAR and SNOWFLAKE design for multi - terabytes warehouses
• Basic C#, Power Shell, Java Script, Python, R
• Microsoft TSQL, Oracle PL/SQL, Basic MDX, Basic DAX
• Complex data analysis

OBJECTIVES:

To deliver professional Data Architecture, Data Warehouse, Data Quality, and Master Data services and strategies across financial, banking, other business sectors.

EXPERIENCE:

Senior Data Architect

Confidential, New York City, NY

Responsibilities:

• In this 3 month contracting role performing data mart design for a donation reporting project using Microsoft 2016 BI stack .
• This data mart will be the prototype for a data warehouse including all aspects of non-profit charitable reporting including payments, pledges, revenue and expense and budget forecasting .

Confidential, New York City, NY

Senior Data Architect

Responsibilities:

• In this 4 month contracting role performing ETL design using Microsoft 2016 SSIS tool for data warehouse and historical archive databases.
• These databases are used to report on engagements, partner assignments and other management consulting data areas.
• Also performing role of technical lead coordinating resources for promoting projects through the development, QA and production life cycles.

Senior Consulting Architect

Confidential, Boston, MA

Responsibilities:

• Responsible for defining data architecture strategy and governance.
• Responsible for designing and creating a billing ODS and data warehouse together with associated master data and data quality processes utilizing MS BI Stack 2012.
• Set up SSRS reports for invoice generation. Set up MDS master data and reference data architecture to support billing engine and billing datamart.
• This project required interfacing with Confidential Data platforms such as MongoDB and Cassendra in order to retrieve and manipulate customer billing and usage data.

Senior Data Modeler/Architect

Confidential, Stamford, CT

Responsibilities:

• Data modeling contract assignment. Create data model governance process and various conceptual and logical data models related to reinsurance business using Power Designer.

Enterprise Master Data Architect

Confidential

Responsibilities:

• Utilizing the Microsoft 2008 and 2012 BI stack created a data integration ODS architecture for migrating source CMDB asset inventory databases to new ATRIUM CMDB architecture.
• Also created and supported a master data architecture and data governance framework to process customer master data for the global ITIL customer support architecture.
• This architecture utilized Microsoft’s database management system, Master Data Services (MDS), SQL Server Integration Services (SSIS) and Reporting Services (MSRS).
• Low level processes implement with complex TSQL scripts, stored procedures, PowerShell scripts and functions.
• This role also managed 2 resources and involved complex data analysis to resolve internal and customer data quality issues.

Senior BI Data Architect

Confidential, Norwalk, Connecticut

Responsibilities:

• Responsible for master data governance framework, data architecture, data modeling and implementation of data integration solutions based on an ODS architecture that supplies data for internal data warehouses, CMDB platforms and reporting services and also supported our internal SOA architecture team.
• In this capacity I was responsible for supporting the Business Intelligence Group ( Confidential ) that supplies reports and cubes using the Microsoft BI stack (SSAS, SSRS and SSIS) to internal and external clients.

Senior Data Modeler/Architect

Confidential, New York, New York

Responsibilities:

• Responsible for the design of logical and physical data models (using ERwin), database performance tuning and design, and partitioned table design for the various Options, Swaps, Compliance, Surveillance, Trading and Equity reporting and transactional databases implemented with SQL Server 2005 and 2008.
• Also responsible for developing a data naming standards process and performance tuning of multi-terabyte transaction and risk management systems.
• Lastly, designed and implemented a data warehouse and cubes for reporting Options daily transactions based on the Microsoft SQL Server BI stack (SSAS, SSRS and SSIS). (100% development and design)

Associate Director - DW Architect

Confidential, New York, New York

Responsibilities:

• Responsible for the design of logical and physical data models (with Sybase Power Designer) for the various Equity reporting databases based on oracle and Sybase.
• Responsible for performance tuning of Sybase and Oracle databases and stored procedures.
• Also responsible for physical database design based on partitioned tables and design of SAN logical storage LUN and file layout for large databases.
• Responsible for the design and implementation of an ODS and Data Warehouse architecture based on SQL Server, Oracle, Informatica and Cognos ETL and reporting tools.
• The data warehouse architecture extracted data from our Siebel CRM and SAP ERP platforms to manage the sales pipeline and deliver sales reports, cubes and scorecards.
• Responsible for all data modeling, data architecture, ETL and BI strategies and also managed a team of DBAs, SQL Developers and Cognos report and cube developers.
• Worked with the Data Quality Group to implement tools and strategies for guaranteeing that cleansed data was fed to the ODS and DW.

Director of Data Warehousing

Confidential, Danbury, Connecticut

Responsibilities:

• Responsible for the design and implementation of an ODS and Data Warehouse architecture based on SQL Server 2000, DTS and Cognos reporting tools.
• The data warehouse architecture extracted data from our JD Edwards and legacy transactional DB2 and Oracle platforms to deliver sales reporting.
• Responsible for all data modeling, data architecture, ETL and BI strategies and also managed a team of DBAs, SQL Developers and Cognos report and cube developers.