Ethan Sheehy Email & Phone Number

Oakville, Ontario, Canada

•Performing ongoing predictive and prescriptive analytics related to compensation and benefits•Creating strategic compensation plans and pay matrices for organization-wide initiatives•Designing, building, and maintaining a wide range of data and visualization tools utilized by c-suite and senior management•Acting as the subject matter expert in all matters related to compensation and employee data

Oakville, Ontario, Canada

•Promoted to Senior Total Rewards Analyst to reflect performance as an analyst & expanded responsibilities with acquisition of the benefits team•Created & managed a database housing compensation & performance management data for over 3,000 employees•Built the primary compensation tools used by the compensation committee, board members, and other senior leaders•Created interactive dashboards, giving senior leaders access to clean, live data & the ability to manipulate it (UI/UX)•Played a key role in the organization’s annual mid-year and year-end compensation review cycles (cleaning & presenting data, creating easy-to-use interactive spreadsheets, analyzing the data & creating visuals for the board, etc.)•Acted as the data expert in all matters related to compensation and performance management

Guelph, Ontario, Canada

•Managed all aspects of clients’ data: reporting, analytics, troubleshooting, updating, importing/exporting, and transforming•Ran full-cycle ETL processes on client data: extracted and loaded via FTPs/SharePoint, transformed via SSMS, Access, Excel, etc.•Created infrastructure in SSMS and Access to input data from a wide variety of inputs to be transformed into clean, uniform outputs, based on individual clients’ needs•Lead a substantial data standardization project (collected information from past appeals and developed standards for incoming/outgoing data for within- and between-client consistency) •Served as the link between the project managers and the print vendors (compiled client needs with print requirements and created data outputs that satisfied both)•Performed ad hoc data transformations outside normal routines as requested by project managers

Kitchener, On

•Taught courses in the Business Computing department, including Excel (Data Analysis & Advanced Functions), PowerPoint, Publisher, & Word•Developed a deep enough understanding of the materials to be capable of teaching them to groups of students with varied skill levels•Troubleshot problems as they occurred both in a classroom setting & via email•Employed self-directed learning for any new materials in the curriculum using integrated help functions & external learning tools as needed•Lead weekly class meetings, held office hours, and interacted with students and faculty through various means (email, LMS platform, Microsoft Teams, etc.)

Cambridge, On

•Developed & managed the Salesforce (CRM) account of 1000+ clients•Imported data from multiple sources (e.g. Excel & Sheets), created reports & dashboards, & performed troubleshooting as needed within the CRM system•Acted as the first point of contact for matters related to database management•Created job aids for a variety of processes within the system•Held weekly meetings to update employees on changes to the system

Guelph, On

•Utilized Excel to collect, clean, & analyze data for research purposes•Created grade books in Excel to record marks & calculate totals/subtotals•Prepared and delivered lectures to students on topics including analytical problem solving and professional development•Provided routine instruction, feedback, and support to students, as well as guidance for individual and group projects•Improved ability to learn/teach new skills through ongoing self-directed learning

Pittsfield, Ma

• Provided recommendations for growth strategies based on marketing tactics, media utilization, and active participation within the community• Initiated community outreach to establish long-term business partnerships• Developed e-commerce product affiliations with like-minded organizations• Researched and writing blog series regarding the impact of technology on wellness

Master’S Degree, 4.0

Bachelor’S Degree