Marsel Shamgunov
Hi, I'm Marsel! I'm an avid learner and adventurer. Learn more about me below!
Career
Education
• M.S, Information Systems: University of Colorado [2018]
• B.S, Business Administration: University of Colorado [2017]Experience
Kaiser Permanente
• Data Reporting and Analytics Consultant IV [2022 - Present]
Banner Health
• Sr. Business Intelligence Developer (Contracted via AP Professionals) [2021 - 2022]
Kaiser Permanente
• Strategy Consultant [2020 - 2021]
• Sr. Analyst [2019 - 2020]
• Analyst [2017 - 2019]
• Intern [2015 - 2017]Certifications [Earned - Expiring]
Business Intelligence Tools
• Microsoft Certified Data Analyst Associate (Power BI) [2021 - 2025]
• Tableau Desktop Certified Associate [2019 - 2021]
• Tableau Desktop Specialist [2019 - present]
Causal Analytics / Statistics
• Kellogg Executive Education @ Northwestern: Business Analytics: Decision Making with Data [2022]
IT Foundations
• CompTIA Security+ [2020 - 2023]
Contact
If you'd like to reach out, please fill out the form below.
Thank you
I'll get back to you shortly!
About Me
Hi, I'm Marsel! I'm a first generation immigrant and self-motivated learner. I love trying new things.I love staying active in a wide variety of ways:
• Skiing
• Outdoor rock climbing (sport)
• Golf (still learning!)
• Scuba diving (PADI Open Water certified)
• Hiking the Colorado 14ers (18 down!)
• Running (current goal: sub-2hr half marathon)I stay up-to-date on consumer tech and enjoy the following:
• 3D printing
• Photography
• Drone flight (FAA 107 certified for commercial drone flight)In addition to this, below are links to some of my projects:
Climbing, running, snowshowing, and skiing - just some of my hobbies!
3D Printed Violin
I made this project as a gift. The CAD files were obtained from the Hovalin project, and everything was printed on my PowerSpec Ultra.Step 1: Printing all 7 pieces took 1-2 weeks. Printing with special woodfill filament required tuning printer settings until perfected. The largest part took over 25 hours to print. The neck printed warped, requiring some post-print adjustments.Step 2: Lots of sanding, using drywall putty to fill in gaps. Test-assembly of the additional items, such as the chin rest (printed) and the tuning knobs (purchased).Step 3: The body is coated in a dark wood stain. Chin rest is glued on, carbon fiber rod is inserted, strings installed and tuned.End result: a 3D-printed violin! While quieter than a traditional wood violin due to less resonance, it plays wonderfully.
Analytics Portfolio
Links to live Tableau dashboardsAs someone who loves data, I love using it to guide my own decision making! I've built a number of dashboards to help myself track my goals across various hobbies. Below are some links to some of my public dashboards on Tableau Public.
Python for ETLTo extract, transform, and load data for my various projects, I use Python. Below are some links to my code, hosted on Github.
Screenshots of past Tableau reportsIn past roles as a BI developer, I developed Business Intelligence reports and dashboards to inform decisions and summarize data to executives. Below are a few examples of this work, which focused on visualizing geographic data and sales pipelines.(Data has been replaced with placeholders and/or blurred to protect sensitive information. All reports/dashboards below were built using Tableau.)
