Available for new opportunities

John Phillips

Result-driven Business Analyst with over 2 years of manufacturing experience, specializing in business intelligence and data visualization. Proven track record of leveraging SQL and Power BI to build intuitive dashboards that drove a 15% increase in operational efficiency.

Chicago, IL
2+ years experience
JP

John Phillips

Business Analyst

SQLPower BIPython

Washington University Graduate

About Me

Eager to apply expertise in data-driven decision making to solve complex business challenges through analytics and visualization.

📊

Data Analytics

Leveraging SQL, Python, and Power BI to transform complex data into actionable insights that drive business decisions and operational efficiency.

📈

Business Intelligence

Building intuitive dashboards and reports that provide stakeholders with real-time visibility into key performance metrics and trends.

🎯

Process Optimization

Identifying inefficiencies and implementing data-driven solutions that streamline operations and improve profitability across the organization.

Technical Skills & Certifications

📊 Data Analytics & Visualization

Advanced Excel95%
SQL90%
Power BI90%
Python (Pandas, Matplotlib)85%
Power Query85%

💼 Business Systems & Certifications

Business Systems & CRM

Salesforce, SAP, Oracle, Jira

Certified Associate Project Manager (CAPM)

Project Management Institute

Agile & Scrum Methodologies

Certified in Agile practices

Professional Experience

A track record of delivering data-driven insights and process improvements across multiple industries.

Business Analyst

General Plastics LLC

Chicago, IL
August 2023 – Present
  • •Executed a comprehensive product profitability analysis using Python (Pandas) to segment over 500 SKUs, providing insights that led to a strategic price restructuring and a 5% increase in average profit margin.
  • •Analyzed quarterly sales data using SQL and developed interactive dashboards in Power BI, which identified an underperforming region and led to a new sales strategy that increased lead conversion by 15%.
  • •Led a cross-functional initiative with the Sales and Marketing teams by executing a product profitability analysis in Python; the resulting data-driven insights informed a strategic price restructuring.
  • •Automated the manual weekly financial reporting process by developing a Python script that consolidated data from SQL and Excel, saving the finance team 10 hours per week.

Business Analyst Intern

Materials Drive

Dallas, TX
May 2022 – August 2022
  • •Evaluated 12 months of freight data using Excel pivot tables to compare carrier costs, identifying a regional logistics partner projected to save 7% on annual shipping expenditures.
  • •Developed a Power BI dashboard to monitor inventory turnover rates by pulling data with SQL, which helped the supply chain team identify $50,000 in slow-moving stock for liquidation.
  • •Collaborated with a senior analyst to research and synthesize competitor pricing data for a new polymer product line, contributing key analysis slides to a quarterly business review presentation.

Financial Analyst Intern

Finance Mutual LLC

New York, NY
May 2021 – August 2021
  • •Spearheaded the generation of monthly portfolio performance reports using VBA in Excel, reducing the time required for data aggregation by 4 hours per month and minimizing manual errors.
  • •Updated a 3-statement financial model and Discounted Cash Flow (DCF) valuation in Excel for a publicly traded retail company, performing sensitivity analysis used to refine the 12-month price target.

Education

Strong academic foundation in business and finance with honors recognition.

Washington University

Business Administration & Finance

GPA: 3.8/4.0

St. Louis, Missouri
May 2023

Dean's List & Presidential Merit Scholarship

Top 5% of Class

Vice President, Finance & Investment Club

Managed a $10,000 student portfolio

Relevant Projects

Hands-on experience with data analysis, financial modeling, and business intelligence projects.

📊
Financial Analysis

Equity Portfolio Analysis

Constructed a virtual $100K equity portfolio for WashU Investment club, using Python to analyze the performance against the S&P 500, achieving a 4% alpha over a one-year period.

PythonFinancial ModelingPortfolio Management
📈
Data Analytics

E-commerce Sales Analysis & Insights

Performed an end-to-end analysis of a public e-commerce dataset with over 100,000 records, using SQL for data cleaning and Tableau to build an interactive dashboard that identified customer segmentation and peak purchasing times as key drivers of revenue.

SQLTableauData Visualization

Let's Connect

Interested in discussing data analytics, business intelligence, or potential opportunities? I'd love to connect and explore how we can work together.

Email

john.phillips@gmail.com

Phone

(123) 456-789

LinkedIn

linkedin.com/in/your-name
Send EmailConnect on LinkedIn
Built with v0