Adam Dirks Email & Phone Number

American Fork, Utah, Us

West Jordan, Utah, Us

- Designed and built dynamic, interactive dashboards in Domo for use across multiple business units- Developed an item performance indexing process leveraging advanced SQL and data visualization to identify and boost sales of underperforming items- Pioneered competitive intelligence reporting by leveraging web scraped data to provide insights into our on-site positioning (pricing, page ranking, review count, ratings, etc.)- Developed and managed complex SQL queries (window functions, multiple joins, subqueries, CTEs, recursion) and ETL pipelines to combine and prepare data for visualization and analysis- Collaborated with sales, finance, and data science teams to automate sales goal setting process - Analyzed sales and profit margin impacts of increasing prices by 19% across SKU catalog- Mentored junior analysts on our business intelligence platform, writing SQL, and managing projects- Managed all sales, marketing, and customer service related datasets, dashboards, scheduled reports, stakeholder relationships and project requirements/timelines

- Successfully planned and executed a 2000 mile, 5 month hike on the Pacific Crest Trail (San Diego, CA to Portland, OR)- Extensively researched gear, logistics, resupply strategies, and past hiking data to ensure success

Round Rock, Texas, Us

- Leveraged Service Now, Active Directory, and ETL principles to collate new-hire IT incident data - Discovered that 90% of all new-hire IT tickets corresponded to only 4 incident categories - Improved new-hire day 1 IT readiness from 58% to 96% via weekly Excel readiness reports- Developed an automated macro-driven Excel dashboard to track and visualize IT readiness- Ensured accurate deployment and tracking of over 6000 systems to remote account executives using Active Directory, PowerShell scripting, and Excel lookups- Created ad hoc pivot tables, lookups, and visualizations for onsite IT support teams to explain incident data and better manage large scale end-user asset deployments- Developed and managed new spare parts inventory system for onsite IT hardware support team

Austin, Tx, Us

- Hosted additional weekly office hours to provide assistance on advanced Excel usage (Lookups, Pivot Tables/Charts, Macros) and SQL queries to first-time learners- Collaborated with professor to develop new assignments and assist over 300 students

Round Rock, Texas, Us

- Designed and developed process for Dell North America technology asset reclamation.- Developed database to identify users and match them with active systems. - Wrote necessary SQL queries and statements in order to match users and systems.- Developed Access form application to easily run queries and manage the database.- Created process documentation for Dell North America remote Windows 10 upgrade roll out.- Created tracking system for loaned systems across Dell North America.- General hardware troubleshooting and repairs, including motherboard replacements.- Data backup and transfer for end user systems.

Bethesda, Md, Us

- Created documentation base for Oracle database issues and solutions. - Documented ERP support transition process from contractors to in house control.- Generated automated monthly reports for currently active tickets.- Hosted remote server upgrade sessions with our Montreal facility and third party tech support.- Updated and redesigned a Microsoft SharePoint sub-site.- Designed a batch script to ping, report, and export to Excel the status of 35 servers.

San Antonio, Texas, Us

- Updated and customized security related HIPPA policies and procedures- Integrated roughly 100 existing physical contracts into digital contract database- Reviewed and inputted contract data into contract management system- Coordinated meetings with department leaders in order to gain insight into the healthcare IT industry