Summary
Overview
Work History
Education
Skills
Personal Summary
Timeline
Certification
Accomplishments
Work Availability
Work Preference
Software
Quote
StoreManager
Shannon Clem

Shannon Clem

Analyst
Denver,CO

Summary

As a seasoned Business Intelligence Analyst with a robust background in data-driven decision-making and process improvement, I bring a strategic mindset and analytical rigor to drive organizational success. With a proven track record in identifying business opportunities, optimizing workflows, and implementing effective solutions, I am adept at translating complex data into actionable insights. My experience spans across various organizations (sales operations, strategy, marketing operations, business operations and finance), where I have consistently delivered projects and solutions on time and within budget, collaborating closely with stakeholders to align goals and maximize operational efficiency. With a commitment to continuous improvement and a passion for leveraging technology to streamline operations, I am prepared to contribute effectively to your team, driving innovation and achieving measurable business outcomes using high-value data insights for decision making.

Overview

12
12

Years of business intelligence practices.

14
14

Years of consistent Tableau usage.

4
4
Certificates

Work History

Sr. Lead Marketing Analyst

Lumen Technology
3 2022 - 5 2023
  • Conducted in-depth analysis of monthly customer acquisition data and campaign performance, delivering actionable recommendations that increased customer acquisition efficiency by 15%.
  • Initiated and analyzed market research studies, resulting in a 20% increase in customer retention and generating $1.5 million in additional revenue.
  • Cultivated robust cross-functional team relationships, significantly enhancing collaboration and improving project delivery timelines by 20%.
  • Analyzed key performance indicators (KPIs) and recommended strategic performance improvements, leading to a 33% increase in sales performance and generating $450K in new revenue.
  • Performed comprehensive trend forecasting and analysis, optimizing annual budget planning and resource allocation, resulting in a 10% reduction in budget variance.
  • Monitored user behavior and lead generation, identifying root causes of low lead adoption rates such as inadequate training, and implemented solutions to improve lead utilization by 20%.
  • Boosted lead adoption by 25% through the consistent delivery of actionable insights on low and high lead adopters, facilitating targeted intervention strategies.
  • Developed and launched a Tableau warm lead dashboard, doubling reporting efficiency and enhancing data-driven decision-making processes.

Lead Business Intelligence Analyst

Lumen Technology
01.2019 - 03.2022
  • Optimized and developed data extraction scripts and queries, improving query and performance by 5% and enhancing data analysis efficiency.
  • Created customized reports with visually appealing formats in Tableau, increasing trackable KPIs by 10% and enhancing leadership visibility into performance metrics by 10%.
  • Engineered data pipelines with SQL and Visual Studio for data acquisition, cleaning, and processing. Migrated to Apache Hadoop, reducing nightly processing times by 5 hours and achieving a 20% increase in processing efficiency.
  • Created detailed customer profiles and analyzed net promoter scores and churn rates, identifying that customers with 3 or fewer products had a 50% higher churn rate. Launched upsell initiatives that generated $1 million in new product sales and reduced churn.
  • Developed data models for product penetration reporting and customer account analyses, identifying high-performer qualities. Coaching initiatives based on these models increased sales by 2%, adding $10K in monthly revenue.
  • Developed automated Tableau dashboards to replace manual Salesforce reports, achieving 100% efficiency gains and streamlining KPI tracking through database automation.
  • Designed automated Tableau and Power BI reporting packages, creating a marketing reporting portal that increased time efficiency by 50%, allowing marketing staff to focus more on analysis than data gathering.
  • Led cross-functional data governance initiatives, standardizing data fields and calculations for the marketing reporting portal, ensuring a single source of truth for program results.
  • Applied advanced Tableau and Power BI data visualization techniques to present and clarify complex data insights for stakeholders.
  • Implemented predictive analytics models to accurately forecast sales, revenue, and marketing initiative outcomes, enhancing strategic planning.
  • Conducted root cause analysis on multiple data sources to address challenges in lead usage and opportunity creation within Salesforce.
  • Collaborated cross-functionally to proactively meet with stakeholders, documenting business requirements and identifying process and tool obstructions.
  • Created data mining algorithms to uncover and classify performance patterns, driving data-driven decision-making and employee development.
  • Designed advanced dashboards and reporting tools in Tableau, Power BI, and Excel to monitor marketing metrics and create accurate forecast budgets.

Lead Sales Operations Consultant

Lumen Technology
04.2014 - 01.2019
  • Supported the Mid-Market VP of Sales as chief of staff, streamlining operations and enhancing executive decision-making processes.
  • Delivered ad-hoc business analyses, built business cases, conducted cost vs. ROI analyses, developed training documentation, and performed data modeling to support client needs.
  • Created and delivered presentations detailing revisions, enhancements, and process improvements to organizational systems and programs, facilitating clear communication with stakeholders.
  • Developed monthly sales forecasts in Microsoft Excel, incorporating trends, seasonality, and funnel opportunities, achieving a 95% accuracy rate.
  • Designed a custom pipeline algorithm in Tableau, distinguishing healthy from non-healthy sales opportunities, increasing forecast accuracy by 20% by excluding unreliable opportunities.
  • Coordinated and managed projects using Microsoft Tasks, ensuring scope, deliverables, and deadlines were met across multiple business units.
  • Developed detailed financial models for valuing potential acquisition targets, based on product penetration per account. Insights from these models increased strategic product sales by 10%, adding $100,000 in revenue.
  • Formulated improvement plans aligned with organizational goals, creating a bespoke performance tracker from benchmarks and KPIs. This facilitated performance reviews, resulting in a 5% monthly productivity increase per rep, adding $45,000 in monthly revenue.
  • Compiled detailed reports on sales performance, sales activity, compensation, revenue, and employee performance, presenting findings and recommendations at monthly leadership review meetings.
  • Administered a $15,000 ($5K for each sales branch) monthly budget for sales incentives, contributing 7% to monthly performance and generating approximately $63,000 in sales revenue.
  • Regularly reviewed operations, identifying opportunities to enhance revenue and employee productivity, implementing improvements to optimize performance.
  • Recommended and implemented improvements to business systems and procedures, including Salesforce updates and marketing campaign optimizations, enhancing employee productivity and transparency.
  • Led monthly meetings with Sales Compensation to ensure the accuracy of compensation payments and address any discrepancies.
  • Developed and delivered presentations on process revisions, enhancements, and improvements to training, systems, reports, dashboards, and other programs.
  • Collaborated with management and sales teams to understand customer needs and recommend solutions, serving as the primary contact for reporting requests, sales incentives, and revenue calculations.
  • Advised stakeholders on developing operational strategies and processes, identifying risk areas and opportunities to enhance revenue targets.
  • Played a key role in the annual planning process, reviewing performance, identifying anomalies, and establishing budgets for sales target management.
  • Designed and managed operational data warehouses to store and track data, maintaining up-to-date information on projects, performance, and initiatives. Implemented a primary data warehouse summarizing performance into a 13-month rolling average, saving managers 30% of their time previously spent on manual processes.
  • Utilized Microsoft Excel for data modeling and trend forecasting, covering performance targets, benchmark improvements, compensation payouts, and campaign performance.
  • Analyzed data to streamline sales operations and improve customer satisfaction. Developed an organization-wide retention tool to identify customers with expiring contracts, aiding employees in prioritizing high-value contract renewals.
  • Created reporting algorithms to enhance and optimize operational processes, including sales performance tracking, KPI monitoring, and pipeline analysis.
  • Developed training documents to support the launch of new systems, tools and dashboards.
  • Performed SOX audits each month to ensure sales reps kept accurate records and priced their solutions correctly.
  • Coached and developed junior analysts that moved in and out of Mid-Market Sales Operations roles.

Sr. Business Analyst (Sales Operations)

Integra Telecom
03.2013 - 04.2014
  • Was the primary analyst assigned to sales operations, acting as the sole dashboard and report producer, cross-functional team contact, Salesforce SME, and liaison to help the compensation team process monthly payments.
  • Successfully managed and delivered multiple projects within tight deadlines, consistently maintaining high-quality standards and ensuring project goals were met.
  • Enhanced interdepartmental communication, facilitating the seamless flow of information and accelerating decision-making processes by 15%.
  • Led process automation initiatives, reducing manual efforts in daily operations by 30% and improving overall efficiency.
  • Boosted team productivity by 20% through the implementation of effective workflow strategies and time management techniques.
  • Contributed to the development of operational policies and procedures, ensuring alignment with organizational goals and objectives.
  • Identified system inefficiencies and recommended adjustments, resulting in a 25% increase in productivity.
  • Applied strong analytical skills to review financial reports, providing insights that informed budget allocation decisions and optimized resource use.
  • Designed and managed operational databases, ensuring accurate data storage and tracking, which improved data integrity by 20%.
  • Facilitated business growth by delivering insightful recommendations derived from comprehensive market research and competitor analysis.
  • Enhanced operational efficiency by analyzing and streamlining processes, reducing cycle times by 15%.
  • Conducted performance assessments to identify areas for improvement, implementing solutions that enhanced operational effectiveness by 10%.

Sr. Analyst - Finance Revenue Operations

Comcast
01.2012 - 03.2013
  • Enabled cross-functional collaboration by sharing financial analysis insights with key stakeholders, driving strategic initiatives and business growth.
  • Established centralized revenue information repositories, promoting data-driven decision-making and ensuring seamless access for all stakeholders.
  • Delivered timely ad hoc reports tailored to stakeholder needs, enabling informed decision-making and strategic planning.
  • Conducted competitive benchmarking studies, expanding market share analysis capabilities and providing valuable intelligence to inform strategic business decisions.
  • Analyzed key performance indicators and trends to support strategic decision-making, enhancing business planning and performance evaluation.
  • Retrieved and organized data into standardized reporting formats, providing a reliable basis for comparison and performance evaluation.
  • Streamlined financial reporting by automating data extraction and consolidation, reducing manual efforts and increasing efficiency by 25%.
  • Maintained accurate financial records and documentation, ensuring compliance with accounting standards and regulations.
  • Enhanced budgeting efficiency by standardizing departmental input collection processes, reducing time spent on budget preparation by 15%.
  • Developed robust financial models and scenario analyses, improving forecast reliability and aiding in strategic decision-making.
  • Implemented automation tools for routine FP&A tasks, reducing manual workloads and increasing productivity by 20%.
  • Assisted in annual budget planning, optimizing resource allocation and identifying improvement areas, contributing to a more efficient budgeting process.
  • Conducted special studies and analyses, providing recommendations on budgets, forecasts, financial plans, and statistical reports to support executive decision-making.
  • Improved financial accuracy by performing monthly reviews and analyses of budget variances, identifying key drivers and corrective actions.
  • Analyzed historical operational records, trends, and costs to accurately project future revenues and expenses, supporting long-term financial planning.
  • Developed and maintained accurate financial models, charts, and reports, ensuring precision in financial analysis and reporting.
  • Assisted in creating presentations, data tables, and visualizations for annual budget planning, enhancing the clarity and impact of financial data.
  • Identified revenue predictors and drivers on P&L reports, achieving a 99.7% accuracy rate in monthly forecasts.
  • Presented monthly revenue forecasts and results to the regional CFO and Operations Director, facilitating informed decision-making.
  • Conducted monthly Rate/Volume analysis for the West Division, effectively communicating results to the Corporate NAO team.
  • Delivered detailed explanations for month-over-month changes, variances to forecast, and budget deviations, enhancing financial transparency and accountability.
  • Accurately planned and forecasted rate increases for major business lines, ensuring alignment with revenue targets and strategic goals.
  • Allocated revenue for each product based on package analysis, optimizing revenue distribution and financial reporting accuracy.
  • Analyzed revenue data to account for rate increase impacts, effectively communicating analysis results to the leadership team.
  • Created financial models for forecasting, ad-hoc reporting, and executive presentations, supporting divisional and corporate leadership reviews with actionable insights.

Education

Bachelor of Science - Computer Information Systems

Regis University
Denver, CO
08.2007 - 2026.05

Skills

Salesforce - Proficient

Personal Summary

"I'm a motivated individual with a passion for data. Whether it's building new report pipelines, gathering business requirements or doing deep dive analyses, I am always curious what trends or patterns will emerge to tell a story. I have thrived in many different business units utilizing my developed skillset and have always been a high performer. I'm comfortable performing routine individual tasks, but also enjoy working on team projects.


I have always been a leader on my teams and have mentored numerous individuals that were just beginning their careers as an analyst. I'm known for advocating for the automation of processes, reports and anything else that can be made to be more efficient and easier to use by all levels of audiences.


To keep my technical skillset up to date, I often enroll in online certification classes to learn new systems. I remain updated with the most relevant information regarding the BI industry, by subscribing to several BI groups on LinkedIn that provide in-depth knowledge of industry trends and newly available BI tools. I also follow key contributors (people and companies) of the BI industry on LinkedIn as well. By engaging with the BI community on LinkedIn, I learn something new every day, while gaining new perspectives that have assisted me growing and enhancing my technical skillset.


My strength as a data analyst is being able to understand complex processes and extrapolate relevant data and provide eventful and reliable insights for identifying the drivers of business and associated initiatives to deliver summarized results that are easily understood by leadership empowering them to make crucial decisions as needed.  From working in many different business units, I possess a solid foundation of business acumen that I apply to every aspect of my job.


I've been fortunate to have excellent business mentors over the years, who have helped me achieve operational excellence which has contributed time savings, cost reductions and revenue growth to each company that I have had the pleasure of working for.

I'm adept at working remotely and in fast-paced environments. I am a quick learner, active communicator/listener and can perform at peak levels working independently or with cross-functional teams. I strive to exceed goals and enjoy being challenged with new opportunities for growth and change. I have an unwavering drive and commitment to support my team and company to the best of my abilities. My mission is to provide insightful data via reports, dashboards, presentations and verbal communication to my leaders to help mitigate risk, identify opportunities for growth and provide explanations for potential impacts to performance on a regular schedule.


I hope you find my skills and focus to be in alignment with the goals and culture of Comcast. I'm eager to share my values, skills and working experience with you on a more personal level, and hope you find my experience to be a match for what you are seeking in a skilled candidate."


Regards,

Shannon Clem

Timeline

Data Analyst Full Stack Certification - Waiting for Class to Begin

10-2024

Python Programming Certificate - Currently Enrolled 2024

05-2024

Lead Business Intelligence Analyst

Lumen Technology
01.2019 - 03.2022

Lead Sales Operations Consultant

Lumen Technology
04.2014 - 01.2019

Sr. Business Analyst (Sales Operations)

Integra Telecom
03.2013 - 04.2014

Sr. Analyst - Finance Revenue Operations

Comcast
01.2012 - 03.2013

Bachelor of Science - Computer Information Systems

Regis University
08.2007 - 2026.05

Technical Writing Certificate - 1999

01-1999

Sr. Lead Marketing Analyst

Lumen Technology
3 2022 - 5 2023

Certification

Technical Writing Certificate - 1999

Accomplishments

Multiple winner of the "prestigous" Bravo award by consistently providing operational excellence for producing high-value data driven KPIs and reports to my Director so he had information to make decisions about our sales branch. Also provided him with ad-hoc analyses that would explain anomalies in our sales performance.

Participated in many projects as the reporting SME and was responsible to report revenue gains and losses using the waterfall technique to visualize the trends of revenue performance.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full Time

Work Location

RemoteHybrid

Software

Tableau

Salesforce

SQL

Power Bi

Visual Studio Code

Apache Hadoop

Microsoft Power Apps

Microsoft Excel

Microsoft Office 365

Open AI

Learning- JavaScript

Learning - Python

Learning - Github

Learning - dbt

Quote

"Be the reason someone feels included, welcomed, valued, seen, heard, listened to, supported and loved."
Unknown
Shannon ClemAnalyst