David Cloonan Email & Phone Number

Philadelphia, PA, US

New Britain, CT, US

• Maintaining artist and customer relations
• End to End product management: Design promotional materials, ads, j-cards, tape labels, t-shirt designs, and stickers; Material sourcing (blank cassettes, cases, label paper, sticker paper(s), inks, shirts).
• Mange all expenses, income, charity donation, and other misc. data in Google Sheets for easy reporting

Harvey, IL, US

• Laid Off
• Created reports and dashboards in Tableau utilizing Tableau Prep and SQL to provide business insights to key stakeholders, such as an E and O report and a Broken Pack Report
• Created presentations for my reporting on operational activities, to get key stakeholders on board with proposed process changes and providing direction to achieve process optimization.
• Used the ERP, JDE (Oracle), to validate all data, as well as research data areas in question
• Applied critical thinking (Lean Management) to root cause analysis to continuously develop process improvements.
• Built productive cross-functional relationships (Operations, Transportation, Sales), mentoring distribution leaders on KPIs, and contributing to informed decision-making.

Blue Bell, Pennsylvania, US

• (Laid off)
• Developed complex Power BI Dashboards for marketing teams and executives, analyzing KPIs and internal business processes using data from CRMs Salesforce and HubSpot, our master data, Google Analytics and Excel. This.
• Performed ETL (Extract Transform Load) using programs such as Alteryx, SQL, R, Python and Power Query.
• Built a sophisticated tool to identify the company’s target demographic based on geographic sales and socio-economic factors from census data. It was used for targeted sales initiatives and right-sizing our marketing.
• Created a comprehensive dashboard visualizing the business pipeline, showcasing the value flow of jobs across various stages on a month-to-month basis. (see portfolio)

Jenkintown, PA, US

• Led our international sales expansion initiatives into Canada, and proposal for EU Conducted market research to develop assortments and forecasts Researched and created relationships with business partners (3PL and.
• Refined product pricing by analyzing cost of goods and competitor research. Expanded product line offerings and created new product lines based on market demand and gaps in our assortment.
• Performing ETL (Extract Transform Load) with data from Google Analytics, Google Tag Manager, HubSpot, Facebook, Amazon and Zendesk via data modeling and data mapping using R, Python, and SQL.
• Maintained and automated daily, weekly, and monthly P and L reports (Production and Loss) for use by C-Level executives
• Created and maintained operations reporting, marketing production, and customer service insights dashboards in Tableau to monitor KPIs and track the effectiveness of new initiatives.

Bala-Cynwyd, Pennsylvania, US

• Ran Missed Opportunity analysis on a weekly basis to support store merchandising and allocation in order to drive sales. This was done by analyzing company data, KPIs, and proven leadership-defined metrics.
• Developed analysis processes to report on product assortment suggestions from the individual store level up through the distribution center level. Using Brio, SQL, Excel and AS400.
• Collaborated with category managers and vendors to implement strategies for store-specific through company-wide assortment enhancements.
• Successfully managed return-to-vendor analysis of sending back dead inventory to vendors for a refund. ~$13MM removed from our inventory annually.

Jenkintown, PA, US

• Reviewed and analyzed returns data using SQL and Excel to report problem areas and negative trends on a monthly basis. Developed and proposed solutions directly to the CEO, CFO and president based on my data and.
• Oversaw all aspects of the customer returns process Creating employee procedures, created the returns policy, hiring and training representatives, and handling escalated customer issues.
• Maintained and updated our master data warehouse of product sizing data using MySQL and Excel on a quarterly basis. Also maintained our data on 3rd party sites using Aces and Pies formatting on a bi-annual basis.

• Creating reports using Excel, AS400 and SQL for various department managers; including daily inventory reports, daily consumption reports, monthly shortage reports, as well as other various requested reports.
• Maintaining up to date part-to-vehicle assignments in our allocation system, while also creating all new assignment for part allocations.
• Developing new methods to track parts from arrival in warehouse to installation on cars to decrease our total net costs caused by lost and damage parts.
• Managed the warehouse with a staff of five associates.
• Ordering and receiving parts for all allocated vehicles that were arriving within the coming 30 day period.