PROFESSIONAL EXPERIENCE:

Confidential

Team Lead & Architect

Responsibilities:

• Led the recovery of a distressed enterprise data warehouse project and established proper process and organization to support on - going development.
• Educated the organization on key elements of success with specific attention paid to managing expectations, understanding requirements and their value, and the importance of data quality through controls and reconciliation.
• Led the data integration development for loading the enterprise data warehouse
• Served as scrum master for the development team.

Confidential

Enterprise BI Lead & Architect

Responsibilities:

• Implemented several significant internal IT solutions for international PR firm located in Chicago.
• Lead the design, development, and delivery of complete analytic reporting solution as extension to existing DW. Solution deployed globally on SQL Server, SSRS, & SSIS consisted of data modeling, physical table builds, 12 report & dashboards and complete ETL.
• Lead the design and implementation Microsoft Master Data Services (MDS) for customer master file. Solution includes the automated loading of data from Oracle, SQL, and SOAP Web Services (C#) using SSIS integrated to MDS framework for loading data.

Confidential, NYC

Project Manager

Responsibilities:

• Managed cross functional teams in the design, development, and implementation of accelerated BI platform for health care using agile project management.
• Performed the planning and required for cross subject area implementation Worked with team to define the plan required for the implementation of a healthcare industry packaged BI model.
• Introduced the importance and value of clearly defined business requirements in the clear definition of expectations and change control.

Confidential, Chicago, IL

Responsibilities:

• Conducted a BI Strategy that considered various opportunities for BI solutions and measured them across effort, cost, risk, and return. The work product for this effort included a BI strategy and accompanying BI portfolio matrix.

Architect & Project Manager

Confidential

Responsibilities:

• Led the design and development of the ETL pipeline using SSIS that collected data from several hundred POS locations with various back end formats which required a modular and flexible input process that standardized data feeds.
• Responsible for the data modeling required to implement a custom analytic solution for a leading point of sale vendor
• Developed end-user BI reports via SSRS and deployed them to a portal available to users across the United States.

Project Manager / Architect

Confidential

Responsibilities:

• Led the design and development of the ETL pipeline using SSIS that collected data from 6 continents across 8 languages and currencies
• Responsible for the multi-dimensional data modeling of the daily sales subject area
• Designed SSAS Cube with extensive and time variant calculated measures and multiple currencies to support pivot analysis
• Supported the production roll-out of the solution.

Cloud Infrastructure Admin

Confidential

Responsibilities:

• Responsible for the management of all server interoperability, security, and certificate management including the origination with CA and deployments
• Responsible for the provisioning of new servers and integration into existing co-located data center at Peer1 which includes significant scripting of admin tasks in C# and PowerShell

Confidential

Project Manager / Architect

Responsibilities:

• Led the architecture and product management of the Managed BI cloud offering designed to consolidate customer information for strategic and operational analysis of business operations through dashboards, scorecards, and targeted reporting.
• Extensive and hands-on development experience utilizing Microsoft BI technology which includes SQL Server, Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).
• Personally responsible for the oversight of all client delivery facets including the methodical process of planning, design, development, implementation, and on-going production support of the Managed BI platform.

Account Manager / Lead Architect

Confidential

Responsibilities:

• Oversaw the architecture for an enterprise data warehouse that consisted of Oracle, Confidential, and Cognos.
• Provided guidance and leadership in the creation of a multi-dimensional data model that collected client bill information for analytics
• Reviewed and provided QA for the ETL design and development and provided account management and oversight

Account Manager / QA Lead

Confidential

Responsibilities:

• Led the requirements and modeling effort to create the conceptual model for enterprise comprehensive data model that included ODS and DW containing all revenue, fixed costs, and variable costs
• Provided close oversight to project team of 6 in the design, development, testing, and implementation of custom built solution.
• Received client and acquiring company (via due diligence) accolades for the best in class analytics provided from the data warehouse platform we deployed.

Project Manager / Lead Architect

Confidential

Responsibilities:

• Managed our development team in CA and client in NYC in the development of an online user behavior tracking solution that integrated views, clicks, user information, and Acxiom data.

Project Manager / Lead Architect

Confidential

Responsibilities:

• Engaged by client after prior consulting firm fell far behind schedule and project was in distress. Performed project assessment to determine issues causing delay and established plan.
• Led the architecture of a solution on technology in which I had no experience and created a highly efficient method for developing code and managing the version control via XML.
• Led team of 5 including report developers and ETL developers and business analyst.

Program Manager

Confidential

Responsibilities:

• Served as program manager for an international market research customer and led IT program designed to replace the infrastructure (ETL and data delivery) supporting over 30,000 internationally licensed users.
• My role involved oversight of disparate team; architecture in the UK, development in Canada, US, and UK, and steering committee from several continents

Project Manager

Confidential

Responsibilities:

• Took over the management of the desktop application for Category Business Planner that was in distress and successfully managed expectations with global steering committee and development team in Canada and architecture team in Oxford, England.

Project Manager / Deployment Manager

Confidential

Responsibilities:

• Managed the development of 20 developers in the creation of the web application Category Business Planner 2.0
• Identified bottlenecks in the project team process and optimized the workflow of developing the ETL and front-end reports.
• Scripted a streamlined process for synchronously deploying actuate code with its accompanying stored procedures via CVS and subsequently managed the code release

ETL Architect / Developer

Confidential

Responsibilities:

• Engaged as expert architect on project building out large ETL infrastructure platform for leading insurance company.
• Led the architecture and definition of ETL pipeline for their center of excellence (COE).

ETL Developer

Confidential

Responsibilities:

• Engaged as Confidential consultant to ramp up on-site team by training them and defining best practices for ETL development within toolset.

Business Analyst

Confidential

Responsibilities:

• Worked on a very large initiative called Project Innovate on the data steward team and was responsible for the collection and standardization of metadata.
• Utilized requirement gathering, interviewing, and documentation skills.

ETL Architect 

Confidential

Responsibilities:

• Conducted interviews with executives, lines of business heads, technologists and created an enterprise strategy and a tactical findings and recommendation deliverable.
• As part of strategy, I created an enterprise architecture to support the BI Strategy an utilized Oracle and Confidential .

ETL Developer

Confidential

Responsibilities:

• Created a standards guide for creating ETL mappings
• Developed source to target mappings in Confidential utilizing complex transformations

Confidential

Account Manager

Responsibilities:

• Responsible for new business development of the Confidential ETL software product which required the presentation of capabilities to all corporate levels
• During the first year of work, achieved 110% of sales goal by leveraging my industry reputation and implementation experience with the largest strategic accounts in the region

Confidential, WI

DW Architect / Developer

Responsibilities:

• Engaged to lead a client team in the creation of a profitability data mart using full lifecycle development methodology
• Drove requirements, data model, ETL design, and front-end cube design in Brio.
• Created a process and convention for writing Confidential mappings in a streamlined and managed process.

Confidential

DW Architect / Developer

Responsibilities:

• Led the architecture, design, and development for an inventory out of stock data mart using Oracle and Ab Initio
• Conducted user requirement gathering meetings and created data model, database objects, and supporting ab initio code.

Confidential

Business Analyst, Data Modeler

Responsibilities:

• Worked as a BI developer on a unit level data mart
• Defined metadata solution, collected business requirements, defined the data model
• Responsible for production implementation and training