Summary
Overview
Work History
Education
Skills
Core Competencies
Notable Projects
Supplementary Information
References
Timeline
Generic

Ebe Mark

Dallas,TX

Summary

A results-driven Data Analyst with 5 years of experience turning complex data into actionable insights. Adept at leveraging advanced Excel functions, Python scripting, Power BI visualizations, and SQL database management to drive efficiency and support strategic decision-making. Proven ability to design end-to-end analytics solutions, automate reporting processes, and communicate data findings to both technical and non‑technical stakeholders.

Overview

4
4
years of professional experience

Work History

Data Analyst

TechForward
Lanham, MD
09.2020 - Current

• Data Extraction & Analysis: Utilize SQL to extract and analyze large datasets from multiple relational databases, ensuring data integrity and accuracy.

• Dashboard & Reporting: Design and maintain interactive Power BI dashboards that provide real‑time insights, improving decision-making speed by over 40%.

• Process Automation: Develop Python scripts to automate data cleaning and transformation tasks, reducing manual processing time by 15+ hours per week.

• Excel Modeling: Create complex Excel models and financial forecasts using advanced functions, pivot tables, and macros, which reduced forecasting errors by 20%.

• Collaboration & Communication: Work closely with stakeholders to define key performance indicators (KPIs), present findings, and recommend actionable business strategies.

• ETL Management: Oversee end‑to‑end ETL processes for consolidating data from various sources, leading to a more streamlined data warehouse environment.

• Query Development: Designed and executed complex SQL queries to retrieve and analyze business data, contributing to enhanced reporting accuracy.

• Predictive Modeling: Assisted in building predictive models using Python libraries to forecast trends, which informed targeted marketing strategies and increased revenue by 10%.

• Excel Reporting: Developed comprehensive Excel dashboards using macros and advanced formulas to support monthly performance reviews and financial planning.

• Power BI Solutions: Built and optimized Power BI reports to track sales, operational metrics, and customer behavior, resulting in actionable insights and operational improvements.

• Cross‑Department Projects: Collaborated with IT, marketing, and finance teams to standardize data collection methods and implement data quality improvement initiatives.

Education

Associate of Science - Science

Consumnes River College
Sacramento, CA
12-2016

Skills

Excel: Pivot tables, macros, advanced formulas, VBA, and data analysis toolpak

Python: Pandas, NumPy, Matplotlib, Scikit-learn, data visualization, and automation

Power BI: Dashboard design, DAX, data modeling, and interactive reports

SQL: query writing, stored procedures, T-SQL, data warehousing, ETL processes

Core Competencies

  • Data Analysis and Visualization: Dashboard development, KPI monitoring, and statistical analysis
    Excel expertise: advanced formulas, pivot tables, macros, VBA, and data modeling
  • Python Programming: Data cleaning, automation, libraries (Pandas, NumPy, Matplotlib, Scikit-learn)
    Business Intelligence: Power BI dashboard design, DAX, data modeling, real-time reporting
  • Database Management: SQL querying, ETL processes, stored procedures, and data warehousing
  • Project Management: Cross-functional collaboration, process optimization, documentation

Notable Projects

Sales Performance Dashboard:

• Developed an end‑to‑end Power BI dashboard integrating sales data from multiple sources.

• Enhanced reporting accuracy by 20% and provided real‑time insights that supported executive decision‑making.

 Automated Reporting System:

• Implemented Python scripts to automate routine data extraction and monthly reporting tasks.

• Reduced manual report generation time by 40 hours per month and improved overall data reliability.

 Market Trend Analysis:

• Conducted comprehensive data analysis using SQL and Excel to identify emerging market trends.

• Delivered insights that guided strategic marketing initiatives and resulted in a 10% increase in revenue.

Supplementary Information

  • Strong analytical, problem‑solving, and critical thinking skills
  • Excellent communication and presentation abilities, translating complex data insights for diverse audiences
  • Proven capacity to manage multiple projects simultaneously under tight deadlines
  • Passionate about continuous learning and leveraging data to drive business innovation

References

References available upon request.

Timeline

Data Analyst

TechForward
09.2020 - Current

Associate of Science - Science

Consumnes River College

Similar Profiles

CREATE PROFILE
Ebe Mark