Data Analytics Portfolio
Projects & Work Experience
May 2022 - Feb 2024
Sr. Manager, Data & Analytics
Engineered a cutting-edge data warehouse using Snowflake, integrating systems like Salesforce and Podio into a seamless, real-time data pipeline. This innovation significantly enhanced data accessibility, reducing refresh times from hourly to near real-time.
Directed the creation of an all-encompassing metric dashboard, providing streamlined access to critical data for our Sales & Operations departments, and C-suite executives. This dashboard achieved inter-departmental alignment and boosted operational efficiency.
Oct 2012 - May 2022
Sr. Supply Chain Data Analyst
Pioneered an advanced inventory model using SQL, Domo, and Excel, leveraging APICS methodologies to optimize inventory levels. By automating production schedules, we unlocked new manufacturing capacity, resulting in millions of dollars in operational savings and waste reduction across 16 manufacturing plants.
Education
2003 - 2007
Bachelor of Science in Business Administration
Studies included organizational leadership, business & statistical analysis, and global supply chain management.
Skills & Expertise
- SQL (Microsoft SQL Server, MySQL, PostgresSQL)
- Python (Pandas, MatPlotLib, SciKit-Learn, NumPy, Seaborn)
- Data Visualization (Tableau, Domo BI, Power BI)
- Data Warehousing (Snowflake, BigQuery)
- ETL (FIvetran, DBT)
- Microsoft Excel (Vlookup, Xlookup, Pivot Tables, Power Query)
- Visual Basic (Excel, Access, Word)
- Data Acquisition
- Data Preparation & Cleaning