Summary
Overview
Work History
Education
Skills
GitHub Portfolio
Timeline
Generic
Miguel Cerna

Miguel Cerna

Data Analyst
Edinburg,TX

Summary

A self-motivated mathematician and educator with a strong background in computer science, well-versed in machine learning techniques, exploratory data analysis (EDA), cross-validation methodologies, and proficient in implementing classification tasks, particularly using logistic regression, all while utilizing the Python programming language. Additionally, possesses extensive knowledge of SQL for data manipulation and reporting, as well as expertise in data visualization using Tableau and Power BI, including hands-on experience in building interactive and insightful dashboards. Demonstrates excellent communication skills, meticulous attention to detail, and a natural aptitude for technology. Proven ability to acquire new skills autonomously and execute tasks with precision while adhering to instructions. A dedicated problem solver with a diligent work ethic.

Overview

6
6
years of professional experience

Work History

Business Analyst

ITC Management Group
Houston, TX
05.2018 - 11.2023

- Supported the company's reporting needs by providing analytic support to operational and executive teams.
- Extracted, modeled, analyzed, and reported on client data to develop data reporting solutions that supported business performance metrics.
- Played a significant role in the UI design of Tableau dashboards, ensuring effective visualization of key metrics.
- Utilized Integration Services (SSIS) for data integration, with over 2 years of experience in SSIS development.
- Developed complex dashboards and reports in Tableau, SSRS, and Excel, leveraging 5+ years of Tableau development experience.
- Analyzed data for trends and prepared concise summaries for key findings, demonstrating strong analytical and communication skills.
- Wrote TSQL queries to extract data from various systems, ensuring accurate and timely data retrieval.
- Collaborated with company executives, management, end users, and technical teams to align data warehouse and applications with business requirements.
- Provided subject matter expertise for multiple projects concurrently through all phases of the development lifecycle.
- Designed and built queries, reports, and dashboards adhering to established frameworks and standards, ensuring consistency and usability.
- Adapted to fast-paced, ever-changing environments with multiple priorities/projects, demonstrating strong time management and problem-solving skills.
- Brought structure to ambiguous business problems and recommended visualization solutions for easy interpretation by users.
- Maintained documentation and procedures for report design and production, ensuring consistency and accuracy across reporting processes.

Mathematics Instructor

Big Bend Community College
09.2017 - 05.2018
  • Developed and implemented rigorous mathematics curriculum aligned with community college standards, integrating real-world applications to enhance practical problem-solving skills.
    Utilized innovative teaching methods and technology to create inclusive learning environments, resulting in consistently positive student and peer evaluations.

Education

Master of Science - Mathematics With Statistics Concentration

The University of Texas Rio Grande Valley
05.2017

Bachelor of Science - Applied Mathematics

University of Texas Pan American
04.2014

Skills

  • Applied Statistics/Mathematics
  • Machine Learning Techniques
  • Exploratory Data Analysis (EDA)
  • Cross-Validation Methodologies
  • Classification Tasks (Logistic Regression)
  • Python Programming (NumPy, pandas, scikit-learn)
  • SQL (Data Manipulation and Reporting)
  • Data Visualization (Tableau, Power BI)
  • Dashboard Design and Creation
  • Statistical Modeling
  • Data Mining
  • Predictive Modeling
  • Time Series Analysis
  • Hypothesis Testing
  • Data Preprocessing and Cleaning
  • Feature Engineering
  • Model Evaluation and Optimization

GitHub Portfolio

Retail and Warehouse Sales Clustering

  • Utilized clustering techniques to segment customers and products for improved marketing strategies and inventory management.

https://github.com/MichaelCerna/Retail-and-Warehouse-Sales-Clustering.git

Analysis of Elevated Cancellation Rates among Hotel Booking Data

  • Conducted in-depth analysis to identify factors leading to high booking cancellation rates, enabling data-driven decisions for the hospitality industry.

https://github.com/MichaelCerna/Analysis-of-Elevated-Cancellation-Rates-among-Hotel-booking-data.git

NBFI Vehicle Loan Default Prediction

  • Developed a predictive model to assess the likelihood of vehicle loan defaults for a non-banking financial institution, aiding risk assessment and loan approval processes.

https://github.com/MichaelCerna/NBFI_Vehicle_Loan_Default_Prediction.git

Anomaly Removal and Minimization of RMSE

  • Implemented advanced techniques to remove anomalies and minimize Root Mean Square Error (RMSE) in data, enhancing data quality and model accuracy.

https://github.com/MichaelCerna/Anomaly-removal-and-minimization-of-RMSE.git

Ukraine-Russia War Twitter Sentiment Analysis

  • Analyzed Twitter data to gauge public sentiment during the Ukraine-Russia conflict, providing valuable insights into public opinion and sentiment trends.

https://github.com/MichaelCerna/Ukraine-Russia-War-Twitter-Sentiment-Analysis.git

Timeline

Business Analyst

ITC Management Group
05.2018 - 11.2023

Mathematics Instructor

Big Bend Community College
09.2017 - 05.2018

Master of Science - Mathematics With Statistics Concentration

The University of Texas Rio Grande Valley

Bachelor of Science - Applied Mathematics

University of Texas Pan American

Similar Profiles

CREATE PROFILE
Miguel CernaData Analyst