PROFESSIONAL SUMMARY:

• Over 20 years’ experience in the IT industry, including application development, web development, data warehousing, business intelligence, data architecture, data modeling and ETL development.
• Highly proficient in the full Data Warehousing/Business Intelligence SDLC at all levels (Analysis & Requirement, Architecture, Data Integration & ETL, Metadata, Reporting, Visualization and Dashboards).
• Highly proficient with SQL Server database platform and tools (T - SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS)).
• Experienced with Oracle database platform and tools (SQL Developer/Data Modeler, PL/SQL, Scheduler, Toad, SQL Navigator).
• Experienced with Teradata database platform and tools (Teradata SQL, BTEQ, SQL Assistant).
• Experienced with NoSQL Bigdata methodologies and Cloudant / CouchDB Platforms.
• Highly proficient with the Microstrategy suite of Business Intelligence software.
• Highly proficient with the Microsoft Business Intelligence stack.
• Highly proficient in data architecture, logical/physical data modeling for enterprise scale transactional databases, data warehouses and data marts.
• Highly experienced in the development of large-scale ETL processes, data migration and data profiling/analysis.
• Highly experienced with SSIS, Informatica PowerCenter, Ab-Initio GDE, InfoSphere Datastage and Talend ETL Tools.
• Experienced in Microsoft server platforms and .NET architecture.
• Experienced in .NET software development languages and tools.
• Highly proficient in Statement of Work development, project estimating and proposal writing.

TECHNICAL SKILLS:

Development Tools Profile: .NET (VB, C#, Team Foundation Server, Visual Studio), ASP, Cold Fusion, HTML, Javascript, PL/SQL, SQL Server SSIS, T-SQL, XML/XSL, XML Spy

Data Warehouse / Business Intelligence Tools Profile: AB Initio GDE, InfoSphere DataStage, ER/Studio, ERWin, Microstrategy Desktop/Developer, Microstrategy Cloud, Microstrategy Mobile, MySQL Workbench, Informatica PowerCenter, Oracle SQL Developer, SQL Server SSIS / SSAS / SSRS, SharePoint Performance Point / Sharepoint 2010, Talend Open Studio, Toad, Visio Enterprise Modeling

Database Platforms: Cloudant NoSQL, Oracle, Microsoft SQL Server, MySql, Teradata (12/13), Informix

Methodologies: Business Intelligence Architecture, Data Architecture, Data Migration, Data Modeling, Data Warehousing, ETL, OLTP, OLAP, ROLAP

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Consultant

Responsibilities:

• Data architecture and modeling of data warehouse and data marts
• ETL processes (SSIS and script based) used to populate data sources
• Microstrategy Architecture
• Microstrategy Reporting
• Personnel and skillsets
• Provided a report to senior IT management on the state of their systems, processes and support & development staff with specific recommendations as to how to stabilize their environment and move forward with their enterprise BI reporting.

Confidential

Business Intelligence Consultant

Responsibilities:

• Implemented a paradigm shifting data architecture and ETL process moving Liberty Mutual to a NoSQL database architecture and an RESTful API Endpoint based source system ETL process for near real time data collection.
• Developed Talend jobs for RESTful Endpoint API data collection processes.
• Developed Talend ETL to process JSON documents collect by the Endpoints into a Cloudant NoSQL Cloud Database.
• Developed Talend ETL to generate data marts for use by Microstrategy reporting environments based on documents stored in the Cloudant NoSql Cloud Database.
• Develop custom mapreduction queries and indexes for Cloudant.
• Developed Microstrategy technical architecture and created the metadata (schema) objects layer.
• Microstrategy reporting objects development.
• Created dashboard documents and associated reporting objects and components.

Platforms: MySQL, Cloudant / CouchDB NoSQL Bigdata, Microstrategy 9.4, Talend ESB

Confidential

Microstrategy Architect

Responsibilities:

• Contributed to the data architecture and data modeling designs of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and Microstrategy specific data modeling best practices.
• Developed Microstrategy technical architecture and created the metadata (schema) objects layer.
• Microstrategy schema objects development.
• Microstrategy reporting objects development.
• Created dozens of dashboard documents and hundreds of grid based reports and their associated reporting objects.
• Created Microstrategy mobile dashboards for use by corporate executives and store management.

Platforms: Teradata 14.10, Microstrategy 9.4, Informatica PowerCenter, Microsoft SSIS

Confidential

Business Intelligence Lead Consultant

Responsibilities:

• Contributed to the data architecture and data modeling designs of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and Microstrategy specific data modeling best practices.
• Developed Microstrategy technical architecture and created the metadata (schema) objects layer.
• Microstrategy schema objects development.
• Microstrategy reporting objects development.
• Created dozens of dashboard documents and hundreds of grid based reports and their associated reporting objects.
• Created mobile reports and associated reporting objects to provide executive level ‘state of the business’ dashboards.

Platforms: Oracle 11.2, Microstrategy 9.3, Informatica PowerCenter

Confidential

Business Intelligence Consultant

Responsibilities:

• Assisted in the data architecture and data modeling of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and Microstrategy specific data modeling.
• Developed SSIS packages to source and transform data from production systems into the vault, stage and warehouse data models.
• Developed Microstrategy technical architecture and created the metadata (schema) objects layer including installation and configuration of multiple iServers (in an iServer clustered environment)/Web Universal environments.
• Microstrategy schema objects development.
• Microstrategy reporting objects development.
• Created dozens of grid based reports and associated reporting objects to replace existing source systems reporting.
• Created a series of dashboards to visually present Credit/Loans data.
• Created mobile reports and associated reporting objects for Credit/Loans data including a 'sandbox' environment for loan officers to produce 'what if' scenarios.

Platforms: SQL Server 2010/2012, Microstrategy 9.2, Microsoft SSIS

Confidential

Business Intelligence Consultant

Responsibilities:

• Conducted detailed requirements gathering with Confidential 's stakeholders and SME's.
• Assisted Confidential leadership in crafting their standardized KPI metrics.
• Developed technical architecture for Microstrategy metadata layer.
• Designed and developed the logical and physical OLAP data models.
• Developed a hybrid Teradata/Ab Initio ETL processes to collect data from several data sources, scrub the raw data, handle data restatement/errors/duplication, and transform the data into a dimensional data model.
• Microstrategy schema objects development.
• Microstrategy reporting objects development.
• Created a series of Microstrategy dashboards and associated reporting objects.

Platforms: Teradata 13, Microstrategy 9.2, Ab Initio, Microsoft SSIS

Confidential

Business Intelligence Consultant

Responsibilities:

• Conducted detailed requirements gathering with Confidential stakeholders and SME's.
• Developed technical architecture for Microsoft hardware and software platforms.
• Designed and developed the logical and physical data model.
• Developed an SSIS ETL processes to collect data from several data sources, sanitized and scrubed the raw data, transform the data into a dimensional data model.
• Microsoft Reporting Services (SSRS) report development.
• Created Microsoft Analysis Services (SSAS) cube design.
• Deployed the solution in two paradigms; an SSRS crosstab solution for field personnel and an SSAS based SharePoint PerformancePoint solution for management dashboard reporting.

Platforms: Oracle 10g, SQL Server 2008, Microsoft SSIS, SSAS, SSRS, SharePoint 2010 PerformancePoint

Confidential

Business Intelligence Consultant

Responsibilities:

• Conducted detailed requirements gathering with Medicis’ stakeholders, SME's and external vendors.
• Created an SOW, requirements document and system design document.
• Developed technical architecture for Microsoft hardware and software platforms.
• Designed and developed the logical and physical data model.
• Developed an SSIS ETL processes to collect data from multiple internal and external data sources, sanitized and scrubbed the raw data and loaded it into a dimensional data model.
• Developed a custom .net application that allows direct manipulation of the data warehouse data in order to make manual corrections to physician allocation data.
• Developed a custom .net reporting template system designed to allow Confidential personnel to design reports tailored to the data reporting requirements for each States regulatory agency.

Platforms: SQL Server 2005/2008, Microsoft SSIS, SSAS, SSRS, .net C#

Confidential

Business Intelligence Consultant

Responsibilities:

• Primary role involves reengineering AMEX's PPM BI system to utilize Clarity's data structure and to convert their BI platform from Microstrategy to Microsoft.
• Conducted detailed requirements gathering with AMEX stakeholders and SME's.
• Developed technical architecture for Microsoft hardware and software platforms
• Designed the data architecture and developed the data model (logical/physical) for an enterprise wide data warehouse.
• Designed several Microsoft Analytical Services data cubes sourced against the new data model.
• Developed SSIS ETL processes to both migrate existing data warehouse data to the new data model design as well as the process to update the data model from the new Clarity data source.
• Microsoft Reporting Services report development.
• Developed a custom .NET front end that provided filter prompting and selection of attributes and metrics using a technique to generate custom MDX queries on-the-fly.

Platforms: SQL Server 2005, MicroStrategy 8, Microsoft SSIS, SSAS, SSRS, .net C#

Confidential

Data Architect (Consultant)

Responsibilities:

• Architected comprehensive enterprise OLTP data models in support of company-wide initiatives to replace all legacy applications and data repositories.
• Architected an enterprise OLAP data warehouse for operational and financial data warehousing.
• Created logical and physical models for all databases used at the enterprise level.
• Developed functional specifications for data extraction, transformation and loading processes from source legacy systems into new data structures.
• Developed ETL processes and procedures used to migrate legacy data into new data architecture and enterprise data warehouse.
• Developed ETL process utilized to populate an enterprise-wide data warehouse.
• Microstrategy project architecture.
• Microstrategy metadata development and management.
• Microstrategy report development.
• Responsible for creating, and ensued compliance with, data standards and best practices in connection with any database development efforts.

Platforms: Oracle 10i, SQL Server 2005, Microsoft CRM, MicroStrategy 8, Microsoft SSIS, SSAS, SSRS, Informatica

Confidential

Manager, Data Warehousing

Responsibilities:

• Requirements gathering and compilation from regulatory and operational sources.
• Developed technical architecture for Microstrategy hardware and software platforms.
• Data architecture and data modeling for an enterprise wide data warehouse and numerous data marts.
• Datastage and custom PL/SQL ETL development for processing of source data from multiple implementations of Diamond, Careplanner and various outside sources of DRG and other healthcare related data.
• Microstrategy project architecture.
• Microstrategy metadata development and management.
• Microstrategy report development.
• Customization of Microstrategy Web Universal product.

Platforms: Oracle 9i, Microstrategy 8, SQL Server 2000, Informatica

Confidential

Data Warehouse Architect (Consultant)

Responsibilities:

• Detailed requirements gathering from executive management and retail management.
• Microstrategy architecture, metadata creation and report design.
• Contributor on the team performing data modeling for the enterprise warehouse and several reporting data marts.
• Developed technical architecture for Microstrategy hardware and software platforms.
• Designed and created Microstrategy metadata, Microstrategy reports and Narrowcaster triggers.
• Development of custom web applications, incorporating the Microstrategy API, to deliver data-aware dashboards and detailed analytics.

Platforms: Teradata, Microstrategy 7.5, SQL Server 2000