PROFESSIONAL SUMMARY:

• Over 20 years’ experience in the IT industry, including application development, web development, data warehousing, business intelligence, data architecture, data modeling and ETLdevelopment.
• 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 platformand 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 inthe 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 IntelligenceArchitecture, 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

Confidential

Business Intelligence Consultant

Responsibilities:

• Implemented a paradigm shiftingdata 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) objectslayer.
• Microstrategy reporting objects development.
• Created dashboard documents and associated reporting objects and components.

Confidential

MicrostrategyArchitect

Responsibilities:

• Contributed to thedata architectureand data modelingdesignsof 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) objectslayer.
• Microstrategy schema objects development.
• Microstrategy reporting objects development.
• Created dozens of dashboard documents and hundreds of grid based reports and their associated reporting objects.
• CreatedMicrostrategymobiledashboards for use by corporate executives and store management.

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.

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.

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

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.
• Developedan 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 ReportingServices (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.

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.
• Developedan 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 Medicis personnel to design reports tailored to the data reporting requirements for each States regulatory agency.

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 anenterprise wide data warehouse.
• Designed several Microsoft Analytical Services data cubes sourced against the new data model.
• DevelopedSSIS 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 ReportingServices 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.

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 utilizedto 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 practicesin connection with any database development efforts.

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

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, incorporatingthe Microstrategy API, to deliver data-aware dashboards and detailed analytics.

Confidential

Business Intelligence Practice Manager

Responsibilities:

• Lead thedevelopment of a Microstrategy-based operational data warehouse for the Veteran's Health Administration Office of Quality and Performance.
• Lead the implementation of a Plumtree-based portalfor the Centers for Medicare andMedicaid Services.
• Led thedevelopment of a Microstrategy-based operational data warehouse for the Department of Agriculture Animal and Plant Health Inspection Service.

Confidential

Microstrategy Developer (Consultant)

Responsibilities:

• Led MicroStrategy Data Warehouse development for a Contract Management Evaluation & Tracking Business Intelligence (COMET/BI) system.
• Performed requirements gathering and translated requirements into systems design.
• Developed technical architecture for Microstrategy hardware and software platforms.
• Data architecture and data modeling for the Microstrategydata mart.
• PL/SQL ETL development for processing of source data from multiple internal and external data sources.
• Microstrategy metadata development and management.
• Microstrategy report development.
• Custom interface development using ASP, Javascript, and the Microstrategy 7 API, including extensive XSL style transformations to alter the standard cross tabulation report formats into more easily read and meaningful styles.