Andrew Geraci Email & Phone Number

Lisle, Illinois, United States

Led multiple projects through AsanaGenerated DocumentationDesigned new workflowsCollaborated across multiple teamsLearned Alteryx, SAP, and refined PBI skills

Chicago, Illinois, United States

○ Tracked progress on projects and tickets via Jira system○ Performed data analysis on email campaigns, customer web activity, and KPIs for CareerBuilder’s bottom line○ Generated time sensitive reporting to track and flag email campaign concerns○ Performed ETLs via Google Analytics, Big Query, Hive, and Microsoft Sql Server Management Studio○ Designed data dictionary for database documentation○ Generated new tableau dashboards and refined current pages to meet additional needs○ Identified UI problems based on user activity heatmaps on Career Builder’s site○ Created multiple Confluence process documentation pages

Chicago, Illinois, United States

○ Managed two direct reports○ Created 60+ pages of step by step documentation for various processes○ Created and maintain the Intranet site for my section■ Trained other teams in Google Sites○ Managed refrigerated container flows on the East Coast of the US○ Monitored thousands of equipment/assets across 50+ locations○ Created Google Sheets and Excel data tools for KPI review■ 3 existing processes consolidated into one and reduced required time from several hours to 20 minutes■ New process allowed data to identify trends easily and efficiently and direct future efforts○ Redesigned existing data systems for data usability and user consumption○ Suggested tweaks to current proprietary system (OPUS) for QoL/process improvements○ Through the use of tools I made and maintained, generated cost savings of $30k■ Identified erroneous container/equipment moves and successfully redirected them

Greater Chicago Area

Manage Metric and KPI tracking across the ITS ConGlobal numerous locations.Learned PowerBI and SQL in order to better "tell the story" and speed Business Analysis Process.Improved business analysis through process improvement projects.Generated presentations for VPs, COO, CEO, and Board on weekly/monthly basis.

Lombard, Il

Positionso Multiple promotions within MOL- July 2013 – Export Refrigerated (Reefer) Team Coordinator – Customer Service Team- Feb 2014 – Analyst, Support and Development – Customer Service Team - Dec 2014 – Senior Analyst, Service Recovery – Integrated Service Team - Sep 2015 – Cost Analyst, Equipment – Operations Team - Feb 2017 – Analyst, North America – Business Analysis & Planning - May 2017 – Manager, Equipment Forecasting and Control – Operations Team Experienceo Tracked accounting data expenses for North America empty equipment flows on monthly and weekly basis- Communicated results of monthly and weekly activity to stakeholders across company- Revamped reporting system for ease of use and tracking expenses efficiency- Managed forecasting of costs across 5 cost categories- Responsible for explaining differences between forecast, budget, and actual numbers- Worked across multiple teams to get and act on data in a timely fashiono On ad hoc basis, assisted equipment department with processes and project management- E.G. creating emergency reports to identify hot spots and aid in strategic decision makingo Took ownership of multiple processes, redesigned them for efficiency- Weekly Monitoring, Inventory, and Matchback processes redesigned - Reduced time spent from 3+ hours into <30 minuteso Designed Import Supply process- Created metric tracking and dashboard for official Key Performance Indicators for public consumption- Interfaced between the Integration Services team and the Equipment team to design process- Created SOP for future use and turning system over to Equipment teamo Created and designed the Space Management Tool (SMT) which revamped the Customer Service front end booking process using a combination of Excel documents and database data- Worked across multiple teams over a period of 2 months to get buy-in and meet user needs- Successfully transitioned process to Vessel Optimization Services for their use and upkeep

Assisted both internal and external clients in the complex and constantly changing world of Title IV aid and held multiple positions within the company to expand my knowledge of various aspects of financial aid processes.o Started with CEC shortly after college and was promoted multiple times within the company - Academic Year 1 (AY1) Financial Aid (FA) Advisor - AY2+ FA Advisor - Re-Entry FA Advisor - Quality Assurance (QA) Specialisto Throughout time with CEC I constantly worked to find more efficient methods of working - Created multiple Excel reports and Calculators that directly increased the efficiency of coworkerso Worked both the front end, AY1, AY2, and Re-Entry, and the back end, QA, of the Financial Aid processo Served as troubleshooter when coworkers became overloaded and needed assistance - As called upon by management, aided teams from both American Intercontinental University (AIU) and Colorado Technical University (CTU)

Peoria, Illinois Area

Worked predominantly as a Server and occasionally as a valet for the Country Club of Peoria while studying at Bradley University.