Michael Amos Email & Phone Number

Minneapolis, Mn, Us

Toronto, Ontario, Ca

* Develop and maintain and ecosystem of connected and interdependent Tableau Dashboards and SAS Jobs* Develop a process for analyzing transaction descriptions to quickly sort transaction to and from specific entities* Source and build processes for consistent ETL of novel data sources into our reporting environment* Create, document and train users for macros to improve data accuracy and quality* Lead the team in retooling from SAS and SQL to using python on Snowflake as our toolset.

Toronto, Ontario, Ca

- Design and Develop Tableau dashboards and visualizations for audiences that will use them to drive action daily.- Assist in migration from Tableau to SalesForce Einstein Analytics to support enterprise CRM migration.- Contribute to team infrastructure including reusable macro library and custom data elements to document data lineage from source system through final delivery.

Develop new customer in-take process to allow internal users to leverage Hadoop data lakeProvide input and validation of Hadoop Kerboros upgrade.

Develop Business processes for a new data analyst teamTrack down and secure access to disparate and distant data sourcesWork with SMEs to develop proper business rules to leverage new data sourcesCreate SQL queries to meet testing requirements for dataCreate Python scripts to automate data delivery for data from a variety of sources and using multiple formats.

South Jordan, Utah, Us

● Develop end user dashboards using Qlikview● Develop robust queries using Microsoft SQL Server● Train new Allina employees on SQL● Developed Enterprise level scorecard in Crystal

Minneapolis, Mn, Us

As the Lead BI Analyst for the pharmacy department I acted as the pharmacy industry and clinical SME to my BI partners and the BI SME to my merchandising and clinical partners. Among other duties I translated and informed requirements from the business to guide the reporting and analytics development process. I consulted on BI vendors engaged by pharmacy and participated in the vendor selection process. I was was the BI partner who was responsible for our population health management system initiative including developing and executing SQL to support the short-term project and coordinating with vendors in the long-term.

Us

Responsibility for six FTEs. Provide guidance to Business Analysts on algorithm development and presentation. Participate in algorithm ideation and prioritization. Develop department business document, policies and procedures.

• Develop and maintain pharmacy intranet webpages and applications • Write, maintain, schedule and run Crystal reports for the pharmacy clinical system, GE Centricity • Develop Access databases and applications on demand • Analyze and resolve any IT based issue that confronts Pharmacy at Johns Hopkins Hospital • Train and coach other applications team members• Manage pharmacy helpdesk account, triage issues to appropriate staff

Bs, Business

Education record