John Seger Email and Phone Number

BI/DW Manager/Director Responsibilities • Managed the development of a new Core system BI/DW, using the Kimball methodology, and included the move to Azure SQL DB and incorporating PowerBI into Salesforce • Lead meetings with Company stakeholders to determine needs of certain data entities such as tables, columns, refresh rates, etc. • Primary presenter for all client demos and training sessions for BI and the online ordering portal, and all things technology • Created and maintaining Confluence BI/DW page, including best practices, related Jira issues and executive-level road map • Gather and analyze usage metrics for users, dashboards, reports to show increased BI adoption • Manage the BI relationship with Microsoft for Power BI and Azure DW needs, including pricing and evaluating best options • Manage all Power BI and SSRS software and server updates • Maintain excellent relationships with MedSpeed employees - meet to drive out requirements, handle issues, write new stories, add DW dimension and fact tables • Created and populating w/Ops the data dictionary including business definitions, column inclusions versus those not needed, and transformation logic • Created a Power BI Golden Dataset for true Self-service discovery Product/Project Owner/Manager Responsibilities • Maintain Data Warehouse backlog, epic, story, and bug writing using Jira • Creation, maintenance, security, documentation, communication, relationship management of the MedSpeed Lab Dashboard • Manage/develop Lab Dashboard/Reporting enhancements, mostly coming from client feedback ◦ Created Power BI Route Lifecycle Report, which improved efficiency in some case by over 50% • Route analysis around scanner sync failures ◦ Up to 90% improvement in scanner sync success by finding syncing deficiencies • Develop and communicate release content to internal and external clients • Acted as SCRUM Master, coordinating and facilitating meetings and managing the Agile process

Successfully led the development and implementation of a new global business intelligence solution to great fanfare, positioning the Firm at the top of the industry for business intelligence offerings. Built to be smart and actionable but also simple and intuitive to create a low barrier of acceptance, while still including contemporary features like various export options, responsive design, and multiple levels of security. Now acting as a product manager/technology ambassador for the Firm's business intelligence/analytics solution. Managed on-shore and off-shore consultants, as well as members of the BI team to ensure product excellence in the timeliest fashion. Also managed the transition of third party survey providers, which has resulted in faster survey updates, phone survey capabilities, a reduction of overall cost, and more robust analytic reporting.

A project manager and liaison between the business and IT units, an expert in business analysis, often called upon to provide direction for multiple business areas by simplifying disjointed information. Also frequently asked by corporate executives to present new technology to c-level executives of current and prospective customers. Major accomplishments include managing the developments of a custom, multi-customer B2B eCommerce solution, a complex and robust custom business intelligence solution which allowed the top customer to manage and report on the execution effort of over 250,000 retail stores, and a multi-platform custom business intelligence solution that provides extensive financial information.

Assured complete customer satisfaction with communication, education, and action, managed an Account Coordinator and multiple Customer Service Representatives, communicated with executives to provide insight and direction regarding customer accounts, performed monthly margin analysis and set pricing to ensure positive margin, provided actionable customer reporting.

Managed projects and communicated their status with the Director of Applications Development, communicated directly with the Executive Committee with regard to Business Intelligence initiatives and implementation strategy using Microsoft based BI products, coordinated and directed meetings between consultants, top management, and select end-users to stimulate project awareness and solve critical project concerns, developed and maintained excellent working rapport, with business end-users that made system change requests, while leading specific projects and analyzing user requirements, procedures, and problems to improve existing information systems, utilized excellent problem-solving skills to identify and resolve intra-company departmental issues.

Received programming assignments from project leader. Completed required tasks, tested and returned for approval. I received a 100% overall satisfactory rating for my work. Also led some projects - analyzing, assigning, and completing the projects from beginning to end.

Met with department managers to gather project requirements. Analyzed, programed, tested and documented all facets of the project.

Managed 5 employees in a retail and wholesale/installation environment. Maintained proper inventory levels, provided tech support for mobile telephones, provided facility analysis regarding sales and installations to management. Interacted with customers in a sales and customer service environment. Was location's top salesperson. Provided solutions for customer issues.