Alec Robertson Email & Phone Number

Dublin, Oh, Us

Middleburg Heights, Ohio, United States

• Alteryx Workflow Designing: Working and Managing up to 80 Alteryx workflows in theETL Pipeline• Design to import data from SQL, DB2, Smoothie, and other company utilized databases while cleaning, analyzing, and modifying the data • Build models on large datasets and publish data to Tableau Server. Tableau Server and Dashboards help to create and manage around 100 user-friendly dashboards using Tableau Desktop and Tableau Server.• Reflect Tableau Dashboards to the TV Screens located at the office, as well as warehouses in Braselton, Georgia, Brook Park/Snow Road, Ohio, and Reno, Nevada. Provides real-time KPIs to end-to-end users.• Supply Chain and operations Key Projects, KPIs, and Dashboards: Excess and Obsolete Inventory Tracking, Forecast Accuracy and demand Master Analysis, Container Booking Prioritization, Backorder/ Backlog Tracking, PO Push Outs, Inventory Health - Months on Hand, Data Cleanup, Supply Chain At-Risk Items Analysis, DC Transfers, Inventory Turns, Safety Stock Calculations • Alteryx Workflows and Tableau Dashboards refresh at a frequency on Hourly, Daily, and Weekly Basis• Warehouse Operations Projects, KPIs, and Dashboards: Disappointed Customers Tracking, Receiving and Put Away Analysis, Picking Efficiency, Picks Remaining - Orders by Ship Date Inventory Accuracy, Item Receiving, Cycle Count Reconciliations, Inventory Transactions, Inventory Replenishments• DC Revenue & Create new analytics working with the Supply Chain and Operations departments building dashboards, Excel reporting, and other ad hoc analysis needs• Developing the ability to investigate a problem, determine the root cause, and work with end users to solve issues• Building Tableau Animated visualizations to track Profit and Loss KPIs at various levels such as SKU, Customer, Product Family, Brand, Territory, Sales Team, etc. KPIs included are Sales, Net Sales, Gross Margin, COGS, Average Price, and Contribution Margin.

Logan, Utah, United States

• Information Systems Apprentice participating and involved in various projects that support the needs of the department/facility• Position works with the team members to identify solutions and perform tasks that accomplish individual and team goals• Gained knowledge of the department's/facility's functions shadowed various roles within the department in order to understand their role in the organization and worked with other members of the department/facility to accomplish assigned tasks• Responsible for project assistance and was assigned more than one specific project(s) during the Apprenticeship• They will be expected to demonstrate an understanding of the process and have accountability for the results/outcomes, working independently or as a member of a team to accomplish the tasks necessary to successfully complete the project at hand • Involving others when needed in a timely manner and working to meet project timelines. Position also provided staff operational/clerical support to the department/facility as needed.• Candidate having the opportunity to be part of exciting areas such as TeleHealth, Provider Digital Experience, Consumer Digital Front Door, Clinical System Engineering, Master Data Management, Security, and others while gaining valuable experience in healthcare information technology• Created and helped verify correct client billing and routing for inpatient and outpatient care, ensuring the needs of patients and caregivers were met• Reviewed documentation for accuracy errors, and mitigated misconfiguration of design and security which led to saved time, increased trust among team members, and the recognition of correctness among management • Designed and validated build documents, allowing our CORE organization to pass patient and caregiver safety audits with 100% accuracy for new build designs submitted

On Campus

• Utilized Tableau to create 15+ annual data reports for the college Dean, helping to visually conceptualize the Engineering Design Lab’s total sales and profit margins, while allowing leadership to make financially informed decisions• Launched an innovative method to integrate 5+ years of data from 3D prints into PowerBI/RapidMiner leading to a more efficiently managed database

Columbus, Ohio, United States

• Managed all Amazon orders, with many of them exceeding a $1 million threshold with no penalties or damages ever reported to the Supply Chain and Operations Management team(s).• Helped lead in all categories for picking, packing, and shipping orders for the first quarter of 2020 where I was recognized weekly for generating the most revenue from purchases made on existing inventory

Bachelor'S Degree, Management Information Systems, Data Engineering, Cybersecurity

Activities and Societies: VP of Data Engineering AIS Club Data Analytics and Information Systems Club Entrepreneurship Club Finance.

Education record