Data Analyst

CHRISTOPHER E. CARLETON *** W. Grant Street *******************@*****.*** Lebanon, OR 97355

Phone: 719-***-****

Objective: To obtain a data-driven position in which I can provide analytical support to my colleagues.

SUMMARY OF QUALIFICATIONS

●5+ years of progressively complex reporting development

●Mastery of Excel formulas

● Strong competency in SQL

●Ability to identify and address root problems

● Work well both independently and in a team environment

●Highly adaptable and able to perform under pressure

●Very dependable and goal oriented

PROFESSIONAL EXPERIENCE

Data Analyst March 2024 – February 2025

H&S Energy Group, Grants Pass, OR

Integrated Andretti Group Oracle HR Data into H&S Energy Group ADP HRIS utilizing excel templates to allow for accurate, secure, and automated translation of all employee information between the two systems.

Coordinated onboarding 800+ employees to new H&S Energy Group business environment.

Assisted with the PDI implementation of 80+ retail fuel locations within the H&S Energy Group PDI Environment.

Created paginated “Combined Operations” SSRS report, providing executives with daily, weekly, and monthly insights into business health within the Retail, Fuel, Carwash, and Wholesale lines of business.

Developed imports to translate Andretti Group PDI information into H&S Energy Group PDI configurations, enabling import of Site-Profiles, Site Level On-Hand quantities, and Pricebook.

Business Analyst August 2023 – March 2024

The Andretti Group, Grants Pass, OR

Created “Daily Fuel” Power BI dashboard, providing the Operations team with the live, data-driven tools needed to set fuel prices for 80+ retail fuel stations throughout the state of Oregon.

Implemented and trained personnel how to utilize PDI’s Rebates Module, saving the retail team an estimated 30+ man hours per month in rebate reconciliation time.

Designed and implemented multiple PDI System Import profiles, allowing for fully automated entry of required accounting information. Including but not limited to: Credit Card Reconciliation, Fuel Reconciliation, Vendor Invoices, and Loyalty Program Reconciliations.

Created SQL Queries and Stored Procedures in order to either answer ad-hoc business questions, or to support Power BI and SSRS business reporting development.

Served as resident “Excel Wizard”, providing assistance with and enhancements to employee spreadsheets across all departments, including: Wholesale, Retail, Human Resources, MIS, Logistics, and Accounting.

Human Resources System Administrator (Oracle) December 2020 - January 2023

The Andretti Group, Remote, OR

●Implemented automated onboarding process, compliant with both California and Oregon guidelines.

●Redesigned Job Posting philosophy to ensure both greater visibility of key positions and higher retention of quality candidates

●Built, maintained, and updated Oregon Fuel Survey program to allow for real-time receipt of all data on all relevant fuel stations, both internal and identified competitors.

●Built and maintained HR reports for everything from Turnover, to hours worked, to vacation trends, ect.

●Built and presented first monthly and then quarterly company health and turnover reports

●Coordinated, and voiced, a full rework of The Andretti Group’s phone tree, providing a streamlined experience to all customers.

●Assisted in the acquisition of two additional companies, coordinating all human resources files and integrating them with the existing Oracle HCM

●Reworked sick-leave and vacation policies to refresh on a yearly, rather than anniversary basis.

●Assisted Payroll with the generation and verification of yearly generation of W-2’s and 1095’s

●Built and maintained excel system to track Key Performance Indicators for the Logistics branch of The Andretti Group.

●Assisted the Wholesale department with the automation of their KPI’s and commission calculation.

●Various ad-hoc reporting as needed.

Recruiting Analyst April 2019 - December 2020

First Call Resolution, Eugene, OR

●Built and maintained all currently utilized recruiting reports and dashboards, allowing the team to transition to data driven decision making.

●Assisted in the coordination and onboarding of 900+ new customer service agents over a three month span and across 7 locations.

●Combined ATS and HRIS system reports into a unified source of truth to enable complete end-to-end or application-to-termination level reporting for all colleagues.

●Built and maintained HR reports and dashboards to provide actionable data on Termination and Corrective Action trends.

●Built and maintained executive reports to provide high level status of new hires, terminations, productive headcount and upcoming recruiting needs.

●Coordinated the direct integration of the Work Opportunity Tax Credit with FCR’s new hire application, driving completion rates from below 30% to over 80%, gaining the company a significant tax credit.

●Relied upon by the executive team for ad hoc reporting needs, ensuring that they had what data they needed, when they needed it.

●Assisted in the creation and documentation of current recruiting and onboarding workflows.

Real Time Analyst April 2018 - April 2019

First Call Resolution, Veneta, OR

●Assisted in the coordination of coverage needs for a program of 100+ across multiple channels including email, chat and phone coverage.

●Built and maintained reports on attendance metrics, training completion rates, and coverage levels.

●Coordinated mandatory training sessions to ensure universal completion within the designated time frame with minimal impact to coverage.

●Created a variety of one-off tools and reports using Google Sheets, Excel, Zendesk, Assembled, Teleopti and various other systems as needed.

Technical Service Representative July 2017 - April 2018

First Call Resolution, Veneta, OR

●Interpreted client needs in order to assist with the design and integration of digital payment processing systems.

●Assisted in the tracking of known system issues.

Medical Warehouse Technician 2011 - 2012

U.S. Army, Camp Dwyer, AFG

●Requisitioned, received and disbursed medical supplies.

●Coordinated a rapid resupply initiative with the medical evacuation units within the Helmand province resulting in the efficient resupply of critical medical components.

●Organized a 50% decrease in stock inventory without impacting the medical mission.

●Organized a 75% decrease in required warehouse footprint.

Medical Logistician 2012 - 2013

U.S. Army, Fort Carson, CO

●Requisitioned, received and disbursed medical supplies and equipment

●Supervised the transfer of medical equipment in excess of $1,000,000.

EDUCATION AND TRAINING

●Military: 12 Credit hours recommended by the American Council on Education, Washington, D.C. 2013

●Linn Benton Community College: 16 Credit hours

AWARDS AND DECORATIONS

Army Commendation Medal OEF Campaign Medal

Army Achievement Medal NATO Ribbon

Contact this candidate