profile image

Eddie Flores

About Me

Experienced in analytics, business intelligence, data management, and Financial Analysis having hands-on expertise with SQL, Tableau, Power BI, SSRS, SSIS, advanced Excel, and more.

I have worked on all aspects of the data lifecycle, from data extraction and transformation to visualization and reporting, utilizing Waterfall, Scrum, and Agile methodologies.

I have a passion for deriving actionable insights, improving processes, and continuously learning new technologies. I thrive in environments where I can make a lasting impact and learn new, cutting-edge technologies to deliver innovative solutions.

Professional Experience

Business Planning & Analysis Manager

Spectrum (Oct 2018 - July 2024)

  • Used EDA and descriptive stats in Excel and Tableau to analyze invoicing data, ensuring data quality. Identified overbilling discrepancies, saving up to $500K annually.
  • Developed financial models in Excel (pivot tables, macros, time series) and integrated scenario planning in Tableau, automating tasks and improving forecast accuracy by 25%.
  • Created automated milestone progress reports using Tableau and SSIS to spot delays early and cut down on project slippage. Bumping SLA up by 10%.
  • Regularly delivered performance reports to leadership, giving a clearer view of operational metrics and trends. Improving insights and understanding.
  • Championed the adoption of new analytical tools and reporting techniques, including Tableau, improving reporting and analytical capabilities.
  • Managed budgeting, forecasting, data analysis, and financial oversight of approximately $150M in annual capital and operating expenses.

Analytics & Development Manager

Bright House Networks (Dec 2017 - Oct 2018)

  • Leveraged clustering and segmentation with SSIS, SSAS, and Visual Studio to analyze customer payment patterns, leading to $40M in bad debt reduction.
  • Designed new collection schemes using Tableau for data visualization and Excel for predictive analytics, improving customer communication and reducing operational costs by $4.3M annually.
  • Used Excel and Tableau for correlation analysis, identifying service disconnect patterns that reduced truck rolls and saved $3.2M annually.
  • Worked in a team oriented setting on executive steering committee, providing in-depth analysis that contributed to a reduction in trouble calls.
  • Managed a team of analysts, enhancing their advanced analytics and data visualization skills to deliver insights that influenced strategic decisions.
  • Developed full-stack IT ticketing website to optimize workflows and allow real-time tracking and management, increasing productivity 15%.

Business Intelligence Analyst

Bright House Networks (Aug 2014 - Dec 2017)

  • Led database management efforts by optimizing ETL processes, improving indexing strategies, and enhancing query performance, resulting in a 40% reduction in load times for an analytics platform.
  • Streamlined reporting processes via automated ETL workflows using T-SQL and SSIS for efficient data integration, reducing preparation time by 30%.
  • Led cross-functional teams to develop a paperless Field Collections process using Excel and SSRS, saving $5M annually through data analysis and gap identification.
  • Applied time-series analysis and predictive analytics to optimize Field Collections contact rates, contributing to an $8.5M positive cash flow annually.
  • Used SQL and Excel for correlation and variance analysis to standardize late fees and optimize pricing, boosting annual revenue by $4M.
  • Leveraged reporting tools like SSRS to automate report distribution and streamline BI processes, ensuring timely delivery of insights to senior leaders.

Web Developer / Database Administrator

Bright House Networks (Mar 2010 - Aug 2014)

  • Developed a real-time monitoring website to track field tagging, using ETL from the billing system to a SQL Server backend, boosting field contact rate by 12%.
  • Introduced a web-based ticketing system that improved IT efficiency, streamlined workflows, and boosted productivity and internal customer satisfaction.
  • Developed Robotic Process Automation, SQL data models, and performance monitoring websites for the Tap Audit department, boosting performance and reducing service theft.
  • Collaborated with cross-functional teams to gather project requirements and design web solutions, reducing completion time and delivering exceptional results.
  • Researched and selected SQL Server for its scalability and ease of use, boosting data processing speed by 20%.
  • Developed, tested, and deployed automated reporting solutions, enabling data-driven decisions and improving financial process accuracy and productivity.

Education

MS, Data Science (Enrolled)

Regis University

  • Machine Learning

  • Python

  • Generative AI

  • LLM

  • NLP

  • Tableau

  • SQL

  • Pandas

  • NumPy

  • Hadoop

  • Spark

MBA, Information Security

Saint Leo University

  • Analysis

  • Data Management

  • Visualization

  • Data Mining

  • ETL

  • KPIs

  • Management

  • Leadership

BS, Computer Information Systems

Saint Leo University

  • HTML

  • JavaScript

  • SQL

  • DBMS

  • C++

  • Systems Analysis

  • Networking

  • Security

  • Operating Systems

Certificates

Data Science with SQL and Tableau

Cornell University

  • SQL

  • Tableau

  • Data Cleansing

  • DBMS

  • Iteration

  • Data Wrangling

  • Data Analysis

  • User Stories

Google Data Analytics Professional Certificate

Coursera

  • Data Analysis

  • Data Visualization

  • SQL

  • Tableau

  • Rstudio

  • Data Collection

  • Spreadsheets

  • Data Integrity

Lean Six Sigma Yellow Belt

COPC Inc

  • Data Collection

  • Data Analysis

  • Root Cause Analysis

  • Process Mapping

  • Lean Principles

  • Team Dynamics