Lauren Detheridge Email & Phone Number

Sherwood Park, Ab, Ca

Edmonton, Alberta, Canada

• Quote tool. Developed an automated tool that accurately calculates sell prices and product margins to allow for quick pricing adjustments and quote approvals. • Competitive database. Developed a database to capture competitor sell prices and linked this data to internal item codes to efficiently pull data into other spreadsheets. This data is utilized to analyze our current sell prices and adjust to fair market value.• Inventory forecasting. Working with procurement and finance to determine which items should be stocked and which items should be manufactured. Currently working on safety stock, minimum order quantity, and order multiple numbers. • Marketing. Creating and modifying brochures, datasheets, and flyers that utilize a standard template and branding.• Win rate analysis. Reviewing quotes to determine key customers and determine where efforts are best focused.• Excel analysis. Linear regression analysis, forecasting, budgeting, pivot tables, charting, trendlines, conditional formatting, and creating visuals to represent data in concise ways.

Edmonton, Alberta, Canada

• Troubleshooting and diagnosing problems. Makeup air, rooftop units, walk-in coolers & freezers, air conditioners, furnaces, ductless mini splits, exhaust fans, air compressors, hot water tanks, and ice machines.• Installing and replacing various components. Compressors, thermostats, defrost timers, bearings, blower wheels, shafts, enthalpy controls, capacitors, contactors, filter driers, condensate drain float switch, and pressure switches.• New construction installations. Rooftop units, walk in coolers and freezers, furnaces, and air conditioners. • Maintaining equipment. Filter and belts replacement, condenser cleaning, testing heating & cooling functions, flame sensor cleaning, and ice machine cleaning.

Edmonton, Alberta, Canada

• Carpentry, welding, plumbing, electrical, steamfitting/pipefitting, and sheet metal.• Seven safety certificates, basic rigging course, and drawing and blueprint reading.• Two weeks of onsite work experience with an electrician.

Edmonton, Alberta, Canada

• Corporate and personal tax planning. Arranging financial matters to minimize the amount of tax paid. Challenges in this involved progressive tax, interest and dividend income taxation percentages, and loopholes within the Taxation Act.• Auditing. Working directly with client’s on site to ensure financial compliance. Auditing included random sample testing, asset depreciation accuracy, checklist completion, and account reconciliation.• Bookkeeping. Performing journal entries, account reconciliation, financial statement development and finalization.

Edmonton, Alberta, Canada

• Custom, automated, and fit-for-purpose reporting. Developing tools and reports to summarize data in a meaningful and efficient way. The Weekly Workshare Report has proven to be of significant value, and one of the most challenging to develop. I utilized VLOOKUP, IF Statements, SUMIFS, COUNTIFS, and array formulas to bring together four databases of information. This report takes approximately 15 minutes to run.• Rate development, commercial completion, and profitability analysis for large, complex proposals. Rate development includes calculations for salary, hourly, contractor and agency personnel and marking up for overheads, burdens, global service unit charges, technology fee and profit margins. Rates are used to price out jobs based on the hours estimated and the scope of work for a project.