Uploaded File
Aron
AronBSafran@gmail.com
516-423-2096
7 Moreland Court
Great Neck, NY 11024
Analyst
35 years experience W2
0
Recommendations
Average rating
6
Profile views
Summary

  • An analysis and operations professional with extensive business, inventory and supply chain experience developed internationally across multiple industries and with diverse teams.

  • Very strong information presentation and data visualization skills with a focus on highly advanced MS-Excel spreadsheet development and VBA automation in addition to MS-Access and the entire MS-Office suite, Tableau, Salesforce, and ERP systems.

  • Over 20 years of experience in a wide array of settings in terms of people, locations, industries, and customers.

Experience
Customer Service (Temporary)
Food/Beverage
Sep 2018 - Jan 2020
Great Neck, NY
  • Please see previous positions for more representative experience.
  • De-facto department manager during periods in which no manager on staff.
  • Preparation, packaging and logging of up to 120 rotisserie chickens a day.
  • Tracking and recording arrival and leftover disposal times, dates and weights of hot and cold prepared foods.
  • Order preparation ranging from individual customer purchases to large catering deliveries. Overseas
Customer Service
Remove Skill
Personal Travel
Transportation
Jan 2018 - Aug 2018

Overseas personal travel

Sales
Remove Skill
Sales Support Analyst & Salesforce Administrator
Information Technology
Aug 2016 - Dec 2017
Mount Joy, PA
  • Automation of near real-time data updates from company's ERP to Salesforce CRM, increasing visibility of customer activity to outside sales representatives.
  • Design and provide requested CRM (Salesforce) dashboards, metrics, and reports in support of sales organization objectives and executive reporting.
  • Maintain and organize product, market, and customer segmentation data.
  • Generate and analyze required data from the company ERP system.
  • Update, format, maintain, and analyze master pricing files.
  • Prepare and present data to the sales team and senior management as required.
  • Collect and quantify data obtained through internal/external surveys and opinion polls.
  • Support all marketing communication initiatives and campaigns within the Salesforce.com framework.
CRM ERP Sales Salesforce Salesforce Admin
Remove Skill
Business Analyst
Information Technology
Jun 2014 - Jul 2016
Lancaster, PA
  • Utilizing Excel, Access, Tableau as well as Visual Basic and other database skill sets, create standard reporting and ad-hoc information from different sources to include JD Edwards and SX.e ERP systems, data warehouse cubes, Salesforce CRM and internally provided sources in a manner consistent with reporting requirements.
  • Increase efficiency through automation of standard reports using VBA coding.
  • Procurement and Supply Chain analysis and feedback to all levels of Management regarding procurement patterns, inventory levels, rebate status, and excess and obsolete inventory.
  • Assist with the administration of the Salesforce system to include user maintenance and creating and generating a variety of reports and dashboards.
  • Establish, monitor, and drive Key Performance Indicators (KPI's) for inventory management.
  • Other ad-hoc, short
  • and long-term projects as requested.
Business Analysis Microsoft Excel Analysis CRM Data Warehousing ERP Inventory Management J.D. Edwards Procurement Salesforce Tableau VBA
Remove Skill
Senior Inventory Control Supervisor
Manufacturing
Jun 2011 - Nov 2013
York, PA
  • Provide leadership and direction in all stockroom and warehouse activities for over 30 direct reports on two shifts.
  • Create, implement and modify processes and procedures to accommodate existing business and new programs.
  • Lead team updating and documenting inventory procedures through the successful process of simultaneous ISO 9001 (Quality Control) and ISO 14001 (Environmental) certification.
  • Ensure accurate accounting and control of all material received, stored, issued to and returned from production, in addition to all finished goods and their associated accessories.
  • Ensure physical control and security of inventory within the 115,000 sq. ft. facility.
  • Supervise daily cycle counts in all inventory areas and related analysis, research, corrections and data reporting.
Analysis Inventory Control ISO 14001 ISO 9001
Remove Skill
Supply Chain Analyst
Information Technology
Aug 2010 - Feb 2011
New Holland, PA

Agricultural (Contractor)

  • Management of a multi-national, pull-based supply chain from order entry through production and direct-to-dealership delivery of 600 agricultural vehicles per month and their OEM supplemental components.
  • Identification of systemic errors in production plan and development of error-proofing techniques.
  • Redesign and development of a production planning and master tracking system from first point of input through confirmed delivery to reflect customer touch points.
  • Development and implementation of an MS-Excel based graphical dashboard displaying real-time status and KPI's for each monthly delivery cycle for 4 vehicle models with 32 variants.
Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Associate's in Mechanical Engineering
Mossenson, 1985 - 1986
Related Courses
SQL for Data Science, 2021 A
Introduction to Data Analytics, 2021 A
Finance for Non-Finance Professionals, 2021 A
Six Sigma Black Belt, 2011 A
Skills
Microsoft Excel
2021
20
Customer Service
2020
20
ERP
2017
20
VBA
2021
20
Inventory Control
2013
12
Inventory Management
2016
8
Analysis
2017
7
Business Analysis
2016
7
CRM
2017
5
Salesforce
2017
5
Salesforce Admin
2017
1
Data Warehousing
2016
2
ISO 14001
2013
2
ISO 9001
2013
2
J.D. Edwards
2016
2
Procurement
2016
2
Tableau
2016
2
Sales
2018
1
Data Visualization
0
1
FOCUS
0
1