SUMMARY:

• IT Director and Enterprise Data/Data Warehouse Architect focused on business intelligence and analytics, using cloud solutions, database, data visualization, data integration, and Big data technologies
• Insightful business analysis coupled with deep technical knowledge consistently produces teams, applications and systems that meet or exceed business expectations
• Entrusted with large - scale projects and global implementations

COMPETENCIES:

• Business Intelligence, Data Science, ETL, and Data Warehouse
• Cloud solutions (Azure)
• Agile (certified product owner)
• Database Design and Development
• Technical team management
• Vendor management
• Manufacturing
• Medical Devices
• Retail

TECHNOLOGIES:

• Azure services - SQL DB, Power BI (the service and embedded) ADF, Azure Analysis Service, etc.)
• Microsoft SQL Server 2014-17, SSRS, SSAS tabular, SharePoint,
• Salesforce
• IBM iSeries

EXPERIENCE:

Confidential

Director Commercial Digital Solutions

Technologies: Azure (SQL Database, Azure Data Factory, Power BI, Azure Analysis services, SQL Server 2014-17 SSRS, SSAS (Tabular), Power BI, event hubs, data lake) SSIS, SharePoint 2013, Salesforce.com, IBM iSeries

Responsibilities:

• Built team (from current, inherited, and staff additions) from 0 to 18 employees and multiple contractors
• My team built the BI and analytics portion of large global Azure service-based program that incorporated customer collected data (from a mobile application), field collected customer data, IOT data, health department data, and other Confidential divisional data and presented it through embedded dashboards in a portal using the customers hierarchy. This solution resulted in multiple year contract extension with the largest food retail customer (5k locations) and a contract extension with the largest Quick Service restaurant chain (14k+ locations). Both extensions are worth multiple millions per year to those divisions. The project was implemented using an agile methodology
• Worked with the Microsoft to develop the architecture and select a vendor for a global “bet the business” initiative (MG365) all built on Azure services.
• Produced advanced analytics solutions (predictive) on likelihood a location would fail an upcoming audit or would have pest activity. This was looked upon by our customers as a key initiative to protecting their brands
• Member of Power BI Champions Advisor group - Invite only group that gets early access to features and helps shape the direction of the product

Key projects include: MG365, Pest Elimination global data warehouse, Shift to Power BI vs SSRS for Dashboards, Operations Dashboards. Upgrade legacy DW (fixed unacceptable performance and moved to a completely new platform in 2 months)

Confidential

Manager Commercial Solutions

Technologies: SQL Server 2012-14 SSRS, SSAS (Tabular), Power BI, Microsoft APS, Azure, Power View, SSIS, Performance Point, SharePoint 2013, Salesforce.com, IBM iSeries

Responsibilities:

• Built team from two contractors to a team of six employees increasing capabilities while reducing cost
• Deployed customer, and field facing dashboards, and reports using the Microsoft BI Stack (SSRS embedded in Salesforce portal). All projects used an agile methodology
• First global division to deploy Microsoft BI in the organization to external customers
• Global Sector data steward for a MDM consolidation project sponsored by the CEO, CFO, and COO to consolidate corporate financial reporting
• Responsible for staffing, budget, and strategy in the DW/BI space

Confidential

Enterprise Data Architect

Technologies: SQL Server 2008, 2012, MicroStrategy, Informatica, Tibco, Salesforce.com, SAP BW BWA/Hana, SAP Business Objects, MPP technologies

Responsibilities:

• Created a global cross divisional service data model for the corporation. This was used as a foundation for cross divisional and geographical data sharing and combined customer facing applications.
• Data architect on a global re-factoring of a global division’s CRM and service platform
• Global analysis of the corporation’s multiple data integration platforms, to determine strengths/weaknesses, use cases, and a strategy moving forward
• Data architect on initiative to pull and analyze customer data from sensors in their continuous process manufacturing systems
• Worked with an industrial division to analyze customer sensor data (pulled every 10 minutes) with their data science group using MPP technologies

Confidential

Sr. Data Architect

Technologies: SQL Server 2000, 2005, Oracle, IBM WebSphere DataStage, and Information Analyzer, ER Studio, Business Objects and Xcelsius, QlikView, SAP BW, Siperian, Siebel, MFGPro, Concur, Windows 2003, Netapps

Responsibilities:

• Responsible for the corporate data warehouse architecture, requirements gathering, design, implementation, and support
• Data modeling, dimensional, logical, and physical data model design
• Database tuning/optimization
• Designed and developed ETL processes, tool architecture design and deployment strategy.
• Developed report creation, distribution, and implementation strategy

Confidential

Sr. Data Architect

Technologies: Oracle 9I RAC database, Oracle Warehouse Builder, Cognos PowerPlay, Cognos Impromptu, Siebel, JD Edwards

Responsibilities:

• Architected designed, developed, and Implemented the iterations of the corporate Data Warehouse.
• This environment was built using an Oracle 9I RAC database, Oracle Warehouse Builder, with Cognos PowerPlay and Impromptu.
• Day to day responsibility maintaining and managing the corporate reporting environment (Cognos PowerPlay and Impromptu Web Reports) that produced over 10,000 reports a month.
• Resolved user issues, managed user accounts, created PowerCubes, Impromptu Catalogs, reports, enhanced the e-mail reports system, and published reports and cubes to the Cognos web application.
• Managed and implemented the upgrade of the Cognos Powerplay and Impromptu environments from version 6 to version 7.1

Confidential

Project Manager and Business Analyst

Technologies: Oracle, MicroStrategy

Responsibilities:

• Provided technical and business analysis expertise for projects that focused on reducing inventory and streamlining shipping
• Produced savings of $25 million to $35 million in inventory reduction
• Gathered business requirements and developed project charters
• Determined EVA for each project
• Integrated data warehouse environment into StratMax, a strategic planning product
• Defined architecture, selected tools, then integrated all into StratMax environment
• Provided technical expertise for clients integrating StratMax into their business intelligence environment
• Extracted, transformed, and loaded information from multiple source systems and building interfaces to StratMax
• Managed project to develop an interface for a $60 million package integration system that included several Oracle components for a Japanese bank
• Developed architecture for a customer relationship management system at a telecommunications company that eventually allowed client to identify and capture customer information in a single repository and use it to target and retain clients
• Served as Technical Architect and Project Manager to develop an automotive diagnostics data warehouse that reduced data maintenance costs, improved data consistency, and shortened the product release cycle
• Led project to implement Oracle HR components for a Fortune 500 manufacturer, integrating this project with the rest of a global Oracle implementation after the original implementation scope had been developed
• Managed of a 15-member development team on a PeopleSoft Human Resources project that reduced costs and provided more accurate and timely information to the company’s business units
• Served as Business Analyst and DBA to develop a fully integrated telemarketing/order entry for an electronics components manufacturer
• Performed a variety of leadership and technical roles to enhance a computerized criminal history system for a state government office
• Served as Lead Technical Support Consultant to resolve technical issues and enhance a $100M distributed order-entry/order processing system for consumer Products Company