Amber Mackenzie Email & Phone Number

Ann Arbor, Mi, Us

Ann Arbor, Michigan, United States

Ann Arbor, Mi

Design institutional data solutions for University of Michigan. Lead teams that deliver state of the art Business Intelligence reports and visualizations, training, and database services to support data-informed decision-making for business units and campus areas. Provide a robust, integrated data ecosystem for U-M enterprise data for analytics to predict student learning outcomes, enhance operational efficiencies, and increase grant proposals and innovative research.Program Director for Michigan Insights on Demand, delivering modern data solutions including data virtualization, data governance, enterprise data cataloging, voice-based applications, and augmented business intelligence solutions that use data science and machine learning to produce data insights.

Ann Arbor, Michigan

Information Quest (IQ) partners with campus and Michigan Medicine to drive business intelligence at U-M by delivering clear information that enables leaders to make strategic data-informed decisions. IQ assists the University by providing enterprise data (HR, Student Administration, Financials, and more) specialized teaching and learning analytics, and creative executive dashboard using tableau, business objects and other reporting tools.I am responsible for helping to set the strategic vision for Business Intelligence and Data Analytics. Ensure the vision is effectively communicated out to campus. Oversee team’s building of advanced analytics solutions through planning, design, execution, development and support.Duties & Responsibilities:• Lead teams who support data solutions using business intelligence, data science for statistical and predictive models, machine learning, and AI methods• Ensure the team leverages appropriate modeling techniques, produces high quality results, and meets timeline objectives• Manage business intelligence, data management, and development plans and staff to create and support priorities and road maps• Support Statistical, Machine Learning, and AI models• Transform complex data into compelling stories that are easy to understand and resonate with a variety of technical and non-technical audiences• Manage departmental budget• Promote data culture through communities of practice, data governance and data quality groups, campus events, partnerships, and data concierge service that strives to exceed customer expectations for data requests and tasks

Ann Arbor, Michigan

Delivered cost-effective, resilient database solutions. Led team in designing and supporting private and public cloud database-as-a-service (DBAAS) hosting thousands of databases for campus, utilizing DevOps and infrastructure as code. Developed and reached deliverables for strategic plan and road maps. Architected infrastructure solutions for high availability, geo-location failover, performance, security and instant data recovery. Managed high-performing teams of database and sql professionals (DBAs and developers) specialized in database administration and infrastructure architecture supporting 24/7 critical university systems on Oracle Exadata, Microsoft SQL, MySQL, MongoDB, and Hadoop.Agile Project ManagementStrategic PlanningCloud DatabasesProcess automation24/7 operationsDevOpsCosting models, Budget management, RFP, and purchase negotiationsService Level Agreements (SLAs) and Memorandums of Understanding (MOU)

Ann Arbor, Michigan, Usa

Primary responsibilities include support of PeopleSoft and other financial and administrative databases on Oracle and Microsoft SQL server.Monitor and address performance issues in Oracle databases, perform backups and recoveries, tune databases for optimal operation.Manage database security across enterprise.Administer SQL servers in clustered environment. Disaster Recovery PlanningArchitecture PlanningChange Management

Specialize in Oracle technology - RAC, Application Server, Dataguard. Certified Oracle DBA versions 8i, 9i, and 10g.Primary responsibilities include 24-hour support of Cerner Millennium patient care systemDevelop and implement high availability database designs across multiple data centersDesign and test failover and disaster recovery plansMonitor and tune systems for optimal performance and growth Replicate test environments from productionInstall, configure, and upgrade databases, operating systems, and storage arrays Train, mentor and supervise junior database administratorsCoordinate with other teams and vendors to develop strategic plans and budgetsBackup and restore databases using various technologiesDevelop and automate administration scripts for database maintenance and monitoring

Managed implementation project of enterprise-wide patient scheduling system in the medical center and 50 outpatient clinics Prepared and managed detailed project plans, resource estimates, and assignment of resources to specific tasksSupervised team of IT employees and consultantsDirected implementation of materials management and surgical systemsTrained and supported 400+ system users. Organized and led ongoing super user meetings to discuss problems, workarounds, and resolutions to system issuesPerformed database administration tasks and designed custom reportsCommunicated user requirements and enhancement requests to software engineers

Business Administration

Bachelor Of Science (B.S.), Psychology And English Language And Literature

Activities and Societies: Alpha Sigma Tau Vice President