WILLIAM MOLINA

Intro

Hello, I'm William. I'm a Data Analyst with strong soft-skills and critical thinking. My technical skills are in the following technologies: Excel, SQL (PostgreSQL), Python, Tableau, and advanced Excel skills that create actionable insights from presentations of consolidated data. I also have additional skills with data modeling & analysis, A/B testing, and storytelling with data. I would be a great fit with a company who is looking for a responsible, thourough, and passionate Data Analyst. Check out my work.

Projects

Walmart Sales/Unemployment Correlation Project
Walmart stakeholders have requested to see the relationship between historical store sales and historical socioeconomic factors to better understand how store sales are affected by those factors.
Skills: Python-Pandas-Numpy-Seaborn/SQL/Jupyter Notebooks/Powerpoint

HR Compensation Tool
Utilizing advanced Excel functions, takes three strategies and a combined strategy based on the insight gained from the raw data to help drive company profit.
Skills: Excel Analytics ToolPak/2 Sample T-Test/Powerpoint

EPA fuel analysis
This project explores the biggest questions between regular gasoline & E85 ethanol fuel. Through two sample t-tests we test hypotheses to see if there's any diffence in average MPG, annual fuel costs, and C02 emissions between both fuels.
Skills: Excel Analytics Toolpak/Powerpoint

Lariat Rental Fleet Profit Analysis
Case study that's focused on a national rental car company called Lariat. Company KPI's are explored with minimizing cost of fleet maintenance vs total annual revenue. This analysis has been conducted by keeping Lariat's objective to increase yearly revenue.
Skills: Excel Analytics Toolpak/Powerpoint

About Me

A bilingual (English, Spanish) professional with strong analytical/technical/problem-solving skills integrated with business acumen. Exceptional conceptual and strategic thinker with strong people and project capabilities. A career reflecting over 10 years of experience in technical aptitude and problem solving.

Contact

• LinkedIn
• GitHub
• Tableau

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';