Kelsie Torczynski
Longmont,CO
Overview
8
8
years of professional experience
1
1
Certification
Work History
Business Intelligence Specialist
Adams 12 Five Star Schools
07.2023 - Current
- Partner with customers and architect team to define business and technical requirements for dashboard deployment across school district
- Audit data metrics using SQL to compare against internal systems information
- Built relationships with Project Director and Lead to understand dashboard requirements communicated by stakeholders and designed and developed visual analytic solutions that aligned with the product roadmap
Data and Operations Analyst
Affordable American Insurance
03.2018 - 07.2023
- Developed custom PowerBI dashboards for departments, executives, and clients while partnering and researching with executives to design and implement an awards system and report; develop annual incentive progress report; built KPI performance metrics using DAX
- Optimized data model to improve efficiency and sustainability leveraging data relationships; redistributed reports using test groups and maintained row-level security permissions
- Collaborated with top clients to redesign existing dashboard to enhance user experience and story-telling
- Integrated CRM data and cross referenced with sales data to measure progress and areas of improvement
Administration Coordinator
Affordable American Insurance
03.2017 - 03.2018
- Maintained monthly PowerBI data reporting and distribution of dashboards company wide; imported data into SQL server and used a series of SQL queries in SSMS to audit/change data before publication
- Collaborated and built internal management system using Power Apps for internal company use incorporating automation triggers streamlining client onboarding and provide daily follow-up reminders for administration and operations departments
Commission Specialist
Affordable American Insurance
05.2016 - 03.2017
- Collected monthly data and audited using Excel and data visualization techniques before importing to central server
- Distributed quarterly bonuses to qualified clients determined by sales metrics obtained from dashboard reporting.
Education
Bachelor of Arts in Statistics and Data Science -
University of Colorado Boulder
Boulder, CO05.2023
Associate of Science -
Front Range Community College
Westminster, CO12.2019
Skills
- PowerBI Desktop/Reporting Services Power Query
- Languages: R SQL DAX
- (SSMS) SQL Server Import and Export Wizard
- Microsoft Excel PowerAutomate
- Snowflake
Certification
Lean Six Sigma Black Belt
Timeline
Business Intelligence Specialist
Adams 12 Five Star Schools
07.2023 - Current
Data and Operations Analyst
Affordable American Insurance
03.2018 - 07.2023
Administration Coordinator
Affordable American Insurance
03.2017 - 03.2018
Commission Specialist
Affordable American Insurance
05.2016 - 03.2017
Bachelor of Arts in Statistics and Data Science -
University of Colorado Boulder
Associate of Science -
Front Range Community College
Similar Profiles
AMY PIERRE-JOHNSONAMY PIERRE-JOHNSON
Structured Learning Services (SLS) Para K-5 at Adams 12 Five Star SchoolsStructured Learning Services (SLS) Para K-5 at Adams 12 Five Star Schools
Wendy HendricksWendy Hendricks
Classroom Teacher at Adams 12 5 Star SchoolsClassroom Teacher at Adams 12 5 Star Schools
AnnMarie MartinezAnnMarie Martinez
Kitchen Manager at Adams 12 5 Star SchoolsKitchen Manager at Adams 12 5 Star Schools
Colleen Gardner ShannonColleen Gardner Shannon
Mathematics Teacher at Adams 12 5 Star SchoolsMathematics Teacher at Adams 12 5 Star Schools
RACHEL WEBERRACHEL WEBER
Program Manager at Regenerative Arts Sanctuary of CreationProgram Manager at Regenerative Arts Sanctuary of Creation