Michael Dores, Mba Email and Phone Number

•Create automated views/reports using SQL code.•Develop stored procedures and custom queries to cleanse and unify data from sources.•Utilize Azure Data Factory to build new data pipelines, as well as maintain and modify existing data pipelines.•Monitor Azure Data Factory pipeline runs and address/troubleshoot errors.•Meet/consult with internal stakeholders to assist with data requirements, initiatives, and processes.•Exercise ETL procedures on a daily basis to ensure data quality and availability are maintained.•Manage refresh of data from manual sources when API setups are unavailable.•Mentor new employees during onboarding.

•Conduct thorough analysis of various databases in order to provide ad-hoc reporting through the use of various software programs such as SQL, Snowflake, and Microsoft Power BI. •Utilize analytics tools and develop descriptive reports for customers displaying pertinent healthcare information.•Troubleshoot, identify, and modify operational approaches to analytics services; design and test standards and solutions. •Aided in the design, creation, and testing of new pharmaceutical analytics tool.

•Analyzed data within web-based system. •Provided ad-hoc reporting to customers based on various product offerings•Maintained databases allowing dashboards and tools to run efficiently and effectively.Acquired by McKesson in Jan '17

•Organized and analyzed company inventory on a daily basis.•Managed the purchasing and receiving of components and machinery as warranted by specific projects.•Drafted original motors, engines, and parts using AutoCAD and Solidworks.