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.
• 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