SUMMARY

• A proven leader with diverse industry experience and a proven track record of leadership, concise communications, technology management and implementations, global planning, IT governance, capacity/cost management, business continuity and Business Intelligence solutions.
• Pharmaceutical || Manufacturing || Software & Services || Cable Communications || Global Education || Casino Gaming ||Systems Integration || Health Care || Telecommunications || Retail || Consulting || Real Estate || Finance || Sales & Marketing
• S QL Server Business Intelligence || MS - Office Applications || Cloud Services Azure || Big Data Implementation || Power BI || Cognos || QlikView || SSIS || TSQL || SSAS || SSRS || Tableau |and more….

PROFESSIONAL EXPERIENCE

Business Intelligence

Confidential

Responsibilities:

• Reduced previous data warehouse loading operations from 2 - 3 days to 3 - 4 hours.
• Migrated Oracle Business Intelligence systems (OBIEE) to MS-SQL platform.
• Integrated legacy ERP and CRM systems with new cloud-based Dynamics 365 ERP and CRM applications.
• Architected EDW data, application and report-level security models for on-premise and cloud-based data sources.
• Architected a reporting Infrastructure tailored to the demands of all corporate business units with support for multiple platforms and tools such as Power BI Desktop, Power BI Embedded, Power BI Service, Azure SQL Databases, On-Premise and Cloud-based VM’s, MS-Excel, QlikView and Tableau. The resulting infrastructure supports over 50 Power BI Premium Workspaces and hosts over 1,000 independent reporting solutions.
• Managed customization requirements and processes for AX-based SSRS reporting solutions and Release Cycles.

Senior Business Intelligence Consultant

Confidential - Phoenix, AZ

Responsibilities:

• Architect ETL processes to acquire, stage, process and integrate information from 16 Oracle-based data sources, Dynamics AX, and legacy systems into an MS-SQL Server based data warehouse.
• Design data warehouse operational architecture for managing load processes and dependencies, error handling and notification.
• Develop the architecture and processes to extract information from a new Poker Room application (Bravo)
• Design ETL using SSIS and Custom Procedures
• Design database infrastructure to support the ODS and Data Warehouse destination
• Develop Multidimensional Style Cubes as a storage option to support new visualizations
• Migrate previous Poker Room application data into new environment
• Develop several visualization options using SSRS, MS-Excel and Power BI
• Coordinate meetings with Casino management and business users to establish requirements, understand expectations and establish communications channels
• Provide group and individual presentations to management and development personnel on virtues of various reporting tools (Power BI, Tableau, SSRS and QlikView).
• Migrate on premise databases to Azure SQL Data Warehouse
• Design SQL procedures to support the information delivery to internal business applications.
• Provide insights and recommendations towards application and architecture upgrades.
• Architect and refine ETL processes to acquire, stage, process and integrate POS data sourced from over 400 restaurant locations.
• Redesign payroll processes to comply with North American state-level overtime rules.
• Architect processes to analyze “HotSchedules” data.
• Refine processes to manage credit cards, promotions, discounts and other business dimensions.
• Perform database system upgrades from SQL Server 2005 Standard to SQL Server 2012 Enterprise.
• Architect Business Intelligence solution implementing SSIS, TSQL, SSRS, QlikView 11, MS-Excel 2013, Power BI and PowerPivot visualizations
• Manage the MAS500 to AX 2012 R2 ERP system data migration and integration processes.
• Manage the RFP preparations and process for AX financial reporting solution selections (Atlas, BI360).
• Provide recommendations, reviews and oversee the implementation of business systems performance optimizations on MS-SQL Server 2008 R2 (TSQL).
• Reduced the execution time of the least performant but most critical processes down from over 48 minutes to under 30 seconds
• SQL Server 2012 Enterprise BI Architecture development and implementation using SSIS, TSQL, SSAS and SSRS.
• Develop reporting architecture for Program Management personnel to analyze resource usage, project progressions, effort overlaps and more across the entire enterprise with information sourced from MS-Project Server 2010.
• Architect an Enterprise Data Warehouse and Business Intelligence solution with business data primarily sourced from AS-400 leveraging SQL Server 2008 and 2008 R2, SSIS, TSQL, SSAS, and SSRS.
• Business Intelligence Architect for a multi-casino gaming enterprise using MS-SQL Server 2008 R2 (SSIS, TSQL, SSAS and SSRS). Architecture included implementation across all areas such as Player Management, Table Games, Slots, Food and Beverage, and Hotel/Resort Management.

Confidential - REDMOND, WA

Lead Program Manager, Exchange Customer Experience and Sustained Engineering

Responsibilities:

• Collaborate with external executives from major corporations (Universal Studios, Nationwide, State Farm and others) to address product concerns, customizations and/or implement large scale Exchange deployments
• Product servicing, design and customer engagement decisions
• Product servicing-readiness and security management
• Partner and customer relations and communications
• Product integrations across Microsoft Office Division (Exchange, Lync, SharePoint, FOPE, others)
• Recruit, lead, mentor, manage and motivate a diverse group of multi-discipline teams consisting of Program Management, Development, QA and Test personnel.
• Direct communications with highest level executive management

Confidential

Group Manager - Global Mission Control and Business Operations

Responsibilities:

• Oversee the development of the infrastructure, processes and personnel necessary to build the support structure from a 12/5 operation to 24/7 within the first year
• Management of globally located regionally focused Business Continuity Processes
• Establish and Manage Service Interruption and Event Coordination Processes
• Coordination of cross group collaboration and executive communications
• FTE and Contractor Personnel Management
• Strategic planning and process definitions
• Management of global profit centers, budgeting and forecasting activities

Confidential, REDMOND, WA

Group Manager, MSN Global Operations and Enterprise Tools

Responsibilities:

• Microsoft, Gold Star Award Winner for innovation and leadership in driving an 80% productivity improvement through cost effective solution implementations and resource management activities.
• Microsoft, Industry Career Achievement Award finalist for Epsilon Award for leading Business Intelligence initiatives through the development of a multi-petabyte Data warehouse while also reducing implementation costs by over $500k
• Define product vision, feature requirements and overall strategy across the multiple product lines and Datacenter Operations.
• Manage offshore operations and development initiatives in Tokyo, Hong Kong, Shanghai, London, Silicon Valley, Redmond, and India
• Recruit, lead, mentor, manage and motivate a diverse group of multi-discipline teams.

Confidential

Principal Consultant/Architect, Business Systems Integration

Responsibilities:

• ETL Processing using DTS from BAAN and MFG/PRO ERP Systems
• Migration process from/to Oracle, Progress, and MS-SQL Database
• Cognos Impromptu and PowerPlay Architecture, Development, and Integration