Andre Castellanos
Data Analyst | SQL, Python, Tableau | E-commerce and Healthcare
andre.castellanos@example.com · (614) 555-0187 · Columbus, OH
Summary
Data analyst with 5 years of experience in e-commerce and healthcare, turning sales, returns and scheduling data into dashboards and decisions. Daily user of SQL (Snowflake, SQL Server), Excel and Python (pandas), with Tableau and Power BI for reporting. Found the 3 product lines behind 38% of online returns, and helped cut their return rate by 15%.
Experience
Data Analyst, E-commerce
Mar 2023 - Present
Northfield Home Goods · Columbus, OH · Full-time
- Built and maintain 7 Tableau dashboards on orders, returns and inventory, used every week by 25 merchandising and supply chain managers.
- Wrote SQL queries in Snowflake that replaced a manual Excel report, saving the finance team about 6 hours a week.
- Analyzed 2 years of returns data in Python (pandas): 3 product lines drove 38% of returns; a new size guide cut their returns by 15%.
- Set up and read A/B tests of checkout emails with marketing; the winning version raised repeat orders by 4% in a quarter.
Junior Data Analyst, Operations
Jun 2021 - Feb 2023
Riverbend Clinics Network · Dublin, OH · Full-time
- Cleaned and merged scheduling data from 12 clinics in SQL Server and Excel (Power Query) into one weekly report.
- Built a Power BI dashboard of missed appointments; with the scheduling team, no-shows fell from 14% to 10% in 6 months after reminder texts.
- Answered about 20 ad hoc data requests a month from clinic managers, with a written summary for each.
Education
B.A. in Economics, minor in Statistics
Aug 2017 - May 2021
Lakeshore State University · Columbus, OH
Microsoft Certified: Power BI Data Analyst Associate
Sep 2022
Microsoft · Online
Skills
- SQL (Snowflake, PostgreSQL, SQL Server)
- Excel (pivot tables, Power Query, XLOOKUP)
- Python (pandas, matplotlib, Jupyter)
- Tableau and Power BI
- A/B testing and basic statistics
- Data cleaning and data modeling
- Presenting findings to managers
Languages
- English native speaker
- Spanish B1
Interests
Volunteer data analyst for a local food bank · Chess club


