Kelly Sayre Email & Phone Number

United States

Burlington, Vermont Area

• Consultancy that advises and assists in the development of cloud-enabled analytics for small company growth. Custom designs Projects and Solutions using industry-leading technologies to best meet client needs.
• Led the redesign of an existing SQLServer warehouse to accept larger data volumes and new data sources using Kimball methodology.
• Built a custom, cloud-based data warehouse leveraging Snowflake to aggregate multiple information sources into a single location. Deployed PowerBI for visualizations.
• Worked with a marketing consulting firm to build an analytics platform for each of their clients.

• Promoted to Enterprise Data and Information Architect to ensure information and reporting integrity in support of a multi-year, multi-million-dollar SAP implementation.
• Responsible and accountable for data standardization and normalization across the enterprise landscape (115 applications)
• Provided guidance to and acted as the point of escalation for BI design and reporting issues
• Shepherded report testing and troubleshooting ensuring information accuracy, data integrity and quality
• Worked closely with and provided guidance to the newly formed Data Management and Data Governance organizations - Interacted frequently with key business leaders to provide clarity and a level of understanding

Vermont

• Recognized expert on business data whose knowledge and leadership enabled delivery of new and necessary solutions across the business. Performed full life cycle data warehouse and business intelligence analysis and.
• Lead architect for project that created a daily, Kimball-based data mart combining data from 3 different ERP systems.
• Primary designer and developer on business critical SSAS cube that was used for ELT reporting and decision support throughout the organization.
• Business analyst, architect, and SSAS developer on an enterprise initiative to collapse two sales channels across different business units into a single organization. Challenges included designing a method for.
• Developed SSRS reports using both MDX and SQL.
• Developed initial strategy for implementing SAP BW and BusinessObjects in conjunction with experts from SAP, IBM, and Keurig. Strategy included technical / architectural recommendations as well as establishing a BI.

Provided as-needed data modeling and MySQL database administration for PIEmatrix's web-based application.

for a North Carolina based health-care company performing updates to the corporate data warehouse's logical model as well as maintaining the data dictionary and related meta data.

• One of two information architects responsible for design of company's corporate data warehouse.
• Logical and physical design of new sources for warehouse using the Inmon methodology.
• Analyzed impact of federal Health Insurance Portability and Accountability Act (HIPAA) and led a cross-functional team to design the repository to decode / recode standard HIPAA transaction sets
• Introduced Snowflake data marts to the warehouse including summary tables and dimensions with embedded hierarchies.
• Key member of team's meta data efforts, determined department needs, evaluated meta data repository vendors, and designed physical structures to store various pieces of meta data required by the organization.

specializing in data warehousing. Specific projects were as follows: · Global Sales Reporting Application: Member of team of consultants that implemented global sales reporting application for pharmaceutical client using Oracle Sales Analyzer with Oracle RAA/RAM. End product was web-enabled. Duties included analysis of existing systems, design of.

Supervised a team of contracted professionals in providing support and development for all decision support systems used by several different business areas. General responsibilities included project planning and prioritization, resource allocation, software package analysis, and end user communication. Specific projects were as follows: · Financial.

· Financial Planning Application Development and Support: Provided incremental development for Oracle Personal Express databases and related OLAP tools including Financial Analyzer, Express Analyzer, Express EIS, and Express Objects. Planned and directed various system upgrades and ports. Instituted numerous enhancements to existing corporate financial.

Master'S

Bachelor Of Arts

Education record