Michelle Gore Email and Phone Number

Consulting services specializing in enterprise information management (EIM), Master Data Management (MDM), and data strategy - including data mining, data quality, linking disparate data sources, data analysis, and reporting.

Engaged to lead the RFP process for selection of an enterprise data warehousing solution for city-wide analytics.

• Establishing the vision and drafting the first Enterprise Data Policy, Data Governance Board Charter, and Data Management Framework to align with the Governor’s strategic plan for data management.• Drafting an enterprise Reference Data Architecture to include both relational and big data technologies for operational data stores, state-services analytics, and business intelligence reporting.• Identifying authoritative trusted data sources in preparation for master data management (MDM) activities across the agencies and unifying into a Conceptual Data Model (CDM)/Logical Data Model (LDM).• Managing data architects analyzing marijuana and other health and human services data life-cycle and creating Data Life Cycle Diagrams (DLD) to demonstrate duplicative data stores, manual data re-entry, and information gaps through the process.• Designing methodologies for change data capture (CDC) techniques across operational data stores (ODS).• All designs have security and confidentiality at the core. Extensive knowledge of FERPA, HIPAA, CIIJS, PII, Treasury, PHI and other security and privacy regulations and requirements.

•Establish relationships with key business constituencies and serve as an advocate for business intelligence deliverables across multiple departments; liaison between business and other technical areas.•Analyze, define, and document business and functional requirements for ongoing enhancement of BI system, with orientation toward phased approach based on rapidly evolving needs •Confer with business users to understand business processes and project requirements, and translate them into functional specifications for BI reports, integration and applications•Understand the business rules and processes of the company and inform project teams about how business rules and transformations are applied to data.•Develop fundamental understanding of multiple business functions, related operational production system(s) and data warehouse structures to drive BI/DW strategy.•Working with the business, help to define measure and report Key Performance Indicators (KPI) and Metrics around the BI/DW environment.•Establish and help enforce best practices and guiding principles around Data Acquisition and Data Quality.•Analyze data and/or processes for anomalies or data quality issues; identify & resolve issues; coordinate with operational owners regarding source data.•Design ad-hoc queries and reports as requested and provide on-going analytical support.•Hire, coach/develop the team in addition to prioritizing work

Increased business transparency with near-immediate integrated business activity monitoring including dashboards, analytics, ad-hoc reporting, data manipulation and decision and financial modeling.Implemented Performance Management by internally creating industry metrics and performance standards.Greatly Enhanced Data Integrity with other business units to ensure process and reporting consistency and cleansing of data to improve integrity and consistency.Created business intelligence for the "Traffic Pumping" scheme and actively implemented cross-departmental business strategy.Enabled Local Least Cost routing and costing resulting in 2009 savings of $1,434,500.Enabled Metro Termination Area (MTA) routing resulting in 2009 netex reduction of $1,399,000.Enabled Enhanced Least Cost routing and costing with realized 2009 netex reduction of $285,000.Created a process by which Level 3 can monitor how the local voice traffic is actually terminating and tied in current costing data and various Lerg data as well as internal business data to provide a complete view of the Local routing prior to enabling the Local Least Cost routing capabilities. This system allowed manual routing changes to be effected and cost savings to be realized in a more-immediate manner than previously available. (PATENT PENDING - "System and Method for Creating a Routing Matrix for Routing Local Calls", Application No. 12/544,179, Filed 19 August 2009).Created a process by which Level 3 can monitor how the long distance voice traffic is actually terminating and calculated penalty cost. (PATENT PENDING - "Call Setup Penalty Cost Categorization", Application No. 12/500,533, Filed 9 July 2009).Created a methodology to collect and view routing data that allows Level 3 to better analyze traffic patterns, costs, and hone in on vendor management opportunities. (PATENT PENDING - "Call Detail Record Data Refinement and Reporting", Application No. 12/467,028 , Filed on May 15, 2009).

Develop mediation of Local Exchange Routing Guide (LERG), that enabled voice traffic to be appropriately least cost routed resulting in a monthly savings over 10kAutomate international least cost routing program and created DMOPRO files for the direct upload into all five of the international gateway switches.Develop routing reports depicting all vendor choices currently in routing by destination, as well as the cost differential between the various routing choices to help assist the purchasing department with a focus on large variances Manage existing data sources and work with departments generating data to drive data content and format needed to report cost of service. Report COS accrual to Broadwing accounting team on a monthly basis. Accrual was supported by obtaining current data for both usage and fixed network components of cost. Manage critical steps in the product development & implementation process ensuring that the cost/price relationship for service offerings was correct, the product structure was fully understood by the sales team, and that the billing system was able to support the service offering.Interface with product marketing organization and with pricing teams to drive cost-based pricing on a product-by-product basis. Report on product profitability for all products in the voice portfolio.Manage cross-functional cost of service initiatives intended to increase the profitability of the voice services organization. These initiatives were designed to generate monthly profitability growth of over $1 million. Example: Managed the Percent Interstate Usage/ Calling Party Number Identification initiative involving multiple departments and consultants.

Analyze traffic patterns and costs to determine prioritization of cost savings efforts.Enhance international gross margins and quantity of traffic for both wholesale and retail business units with efficient routing and aggressive sales initiatives resulting in a 105% growth in Gross Margin Dollars from $105k in January 2006 to $217k in September 2006 and a 60% growth in monthly international Minutes from 15M in January 2006 to 24M in September 2006.Create software application to emulate Nortel DMS250 & DMS 500 switch commands/translations for various trunk group validation reports that insure appropriate jurisdictional routing of customer and network voice traffic - Annual Cost Savings: $4.5 Million.Gather technical business requirements of manual internal operational processes and procedures and properly translate this information to a scope of work to assist I.T.department in the creation and implementation of automated systems.Analyze merging infrastructures to facilitate the integration of Focal Communications' voice network with Broadwing's infrastructure to effect a resultant annualized savings of $5,760,000 over Focal's existing voice costs.Project manage inter-company / inter-departmental initiative to move FGD infrastructure off of the decommissioned DEX switches to DMS switch sites that ultimately resulted in an annualized Cost Savings of $3.9 Million.Mergers / Acquisitions - Prepare Broadwing for acquisition from Corvis / Cequel III - cost reduction activities included to:Develop and implement cost studies and reporting formats to provide real-time visibility into the cost components of voice services.Work with outsourced accounts payable vendor to monitor vendor bills, trend access expenses by LEC and by WATS vendor, and monitor bill dispute generation and resolution.

Health and Human Services agencies administered certain health and human services programs including the Texas Medicaid Program, Children's Health Insurance Program (CHIP), and Medicaid waste, fraud, and abuse investigations as well as Federal Emergency Management Agency (FEMA) programs. Facilitate Business Requirement Definitions, CRM processes, the managing of customer expectations via team meetings with business and technical staff, the developing of business and systems requirements (systems analysis and design), technical documentation, data modeling, technology changes, and project tracking and reporting utilizing PMI standards for production-system changes as mandated by legislative sessions and internal customers. Change and enhance the official accounting system for the State of Texas Department of Human Services, which included the General Ledger, Accounts Payable, Cost Allocation and Comptroller Interface / Document Tracking. Experience also involved Project Recovery, initiative, and ingenuity.Deliver projects on schedule and within budget, while satisfying agreed-upon customer requirements and specifications within the scope of the project. Proactively manage risks, issues, and scope throughout the project life cycle, prepare/present project plans/status reports to organizational leadership, project teams and client/customer groups.Manage multiple projects and groups simultaneously. Lead teams for inter-agency program changes and implementations. Interact and present to all levels of personnel within the organization. Manage the production of project estimates, develop project schedules, and establish measures and milestones, track ongoing project progress, develop process models.Plan and perform user acceptance testing and facilitate knowledge transfer to end-users.Maintain and update existing business unit programs including development of new or ad-hoc reports using SQL against the SQL Server database.