Samuel Jardine Email & Phone Number

Provo, Ut, Us

San Jose, Ca, Us

Worked with a highly talented team to accomplish accurate and timely commission calculations for over 5000 reps around the world.Designed SQL audit systems and leveraged Power BI tools, improving reporting accuracy by 2.5x for department-wide stakeholders.Created a desktop application for a mostly non-technical team, improving task efficiency for specific tasks by 10x and eliminating the need for technical training.Built a custom Excel Add-in that reduced manual Excel processing by 75%, streamlining complex tasks.

Orem, Ut, Us

Create, read, and edit complex SQL queries to automate pay for commission sales reps and technicians with a myriad of variables. Automate repetitive tasks using expert level VBA subroutines including: web scraping, running stored SQL procedures, sending emails, and much more.Work closely with many department heads (Sales, Fiel operations, Accounting, Finance) to ensure accuracy of current payroll while focusing on future changes to simplify processes while maintaining accuracy.Head major projects (such as end-of-year reconciliations and implementation of new company-wide Sales Rules) with little to no supervision while sticking to strict deadlines. These projects require expert SQL knowledge, intricate knowledge of the business, complex QA testing, and great intrapersonal skills.

Orem, Ut, Us

Ensure that all weekly employees (100+) are appropriately paid on time. Personally audit all technician submissions. Read and write complex sql queries. Develop custom excel add-ins with functions including: web crawling, connection to internal databases and a variety of others. Interact daily with President of Sales and President of Field Operations to resolve questions and improve processes. Hold weekly pay meeting with CEO.

Provo, Ut, Us

I held over 250 personal consultations with undergraduate and graduate students. I would provide a variety of services from explaining course information to trouble shooting code to helping with exam prep. The course covered pivot tables, customizing the Excel ribbon, user forms, web automation, and connections to databases.

Lindon, Utah, Us

Analyzed potential expansion sites for a firm that grows exclusively through word of mouth by creating new datasets from Census and other publicly available information. Created a database from scratch with every major CPA Association in the United States with information like number of members, contact info, membership requirements, etc. Developed an Excel sheet to record and analyze regional CPA firm data, such as industry job change, total number of firms, total revenue of firms, total population, cost of living, etc. Ran original financial models with information from custom datasets to make short-term and long-term suggestions which the company accepted and implemented.

Provo, Utah, Us

Helped hundred of diverse patrons with a wide variety of technical skills to work with many scanners and computers to preserve their family history. Additionally, I proactively replaced a tedious project with an automated process saving over 1,500 hours of labor and roughly $20,000 by developing a web scraper and implementing new work processes. I also simplified and automated Google Sheets through Google Apps Script, resulting in 75% fewer mistakes and overall better system.

Provo, Utah, Us

Researched potential improvements at the Provo-Springville border in a small group by canvasing, creating surveys, contacting local officials, and examining case studies. Elected by 30 BYU peers to present the classes' work to the Provo City Council. Compiled and organized 5 groups' distinct findings and created a cohesive and compelling presentation where several suggestions were accepted and implemented.

Salt Lake City, Utah, Us

Drafted and filed important documents with state and federal courts. Assisted the paralegals of the firm with research for Personal Injury cases. Fulfilled a variety of tasks assigned by the firms attorneys, including client relations, database development, and process improvement. Updated and maintained the firm's calendar, verifying appointments and court dates with clients and other court officials.

Master Of Business Administration - Mba

Bachelor'S Degree, English