Aron Safran Email & Phone Number

Port Washington, NY

• Maintaining data integrity during standard and ad hoc data updates (ETL).
• Setting new prices, reviewing existing prices and generating profitability reports.
• Gathering cost information for products in order to calculate retail pricing.
• Recommend price adjustments to maintain profitability at desired levels.
• Prepare profitability reports to share with customers and management.
• Responsible for data entry for all pricing in system and/or any related technology system.

Great Neck, NY

• Direct daily activities in deli department of gourmet, kosher retail market.
• De-facto department manager for six months during period 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 dates and weights of hot and cold prepared foods.
• Order preparation ranging from individual customer purchases to large catering deliveries.

Mount Joy, PA

• Automation of near real-time data updates from company's Sage Pro 2011 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.
• Development of Excel based, VBA automated Market Intelligence presentation tool for sales representatives, allowing them to independently generate data-based charts and… Show more
• Development of Excel based, VBA automated Market Intelligence presentation tool for sales representatives, allowing them to independently generate data-based charts and infographics tailored to a specific customer’s.
• Conducting of market research, data analysis and reporting with recommendations towards planned company expansion into the Iron and Stainless-Steel railing market in the continental USA for C-Suite executive management.
• Maintain and organize product, market, and customer segmentation data.

Lancaster, PA

• Utilizing Excel, Access, Tableau as well as Visual Basic and other database skill sets, create standard and ad-hoc reports from different sources to include the company’s JD Edwards and SX.e ERP systems, data warehouse.
• Increasing efficiency through automation of Excel-based standard reports using VBA coding to include data extraction from the company’s data cubes and ERP systems… Show more
• Increasing efficiency through automation of Excel-based standard reports using VBA coding to include data extraction from the company’s data cubes and ERP systems, data transformation, loading (ETL process), processing.
• 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 in addition to creating and generating a variety of reports and dashboards.
• Establish, monitor, and drive Key Performance Indicators (KPI's) for inventory management focused on turnover rates and excess and obsolete inventory control and dispositioning

York, PA

• Provide leadership and direction in all stockroom and warehouse activities for 30 direct reports across two shifts.
• Create and document processes and procedures to accommodate existing business and new programs to ISO standards.
• Lead team updating and documenting inventory processes and procedures through successful simultaneous ISO 9001 (Quality Control) and ISO 14001 (Environmental) certifications.
• Ensure accurate accounting and control of all material received, stored… Show more
• 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.

New Holland, PA

• 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 pre-existing systemic errors in production plan, error correcting and implementation of QA techniques.
• Redesign and further development of the Excel-based production planning and master tracking systems from first point of order input through confirmed dealership… Show more
• Redesign and further development of the Excel-based production planning and master tracking systems from first point of order input through confirmed dealership delivery to reflect customer touch points.
• Development and implementation of an MS-Excel based graphical dashboard displaying real-time status and KPI's of each monthly delivery cycle for 4 vehicle models with 32 variants. Show less

York, PA

• Management of the disposal process for 20,000 SKUs in excess inventory valued above $ 100 million.
• Operational oversight and supervision of the commercial sale of excess and obsolete parts valued at $ 1.3 million, acting as customer's primary point of contact across all related functions.
• Participation in Kaizen event delivering recommendations to Executive Management for companywide project management related improvements including enhancing communication and implementation of… Show more
• Participation in Kaizen event delivering recommendations to Executive Management for companywide project management related improvements including enhancing communication and implementation of Lessons Learned and.
• Collaborating with the Engineering Department in designing, developing and distributing sets of illustrated Engineering Change quick-reference guides to standardize implementation by Field Service Representatives.
• Translation of mechanical drawings and metallurgical specifications for Merkava tank based Heavy Armored Personnel Carrier hull from Hebrew to English by overwriting existing text on Israeli Tank Authority RFP provided.

Israel

Israel Defense Forces (IDF), NCO, Ordnance CorpsManually scheduled, coordinated, and documented maintenance of over 1,000 combat vehicles ranging from jeeps to mobile artillery pieces. Acted as Brigade Ordnance Liaison to Division Headquarters and Central Command. Honorably discharged with rank of First Sergeant.

Asociates Degree, Mechanical Engineering

Activities and Societies: Volunteer Police Officer with the Civil Guard Majored in Mechanical Engineering, finally obtaining an Asoociate.

Lssbb, Lean Six Sigma Black Belt

Successfully completed Lean Six Sigma Black Belt online training. Final Grade: 98.7%

Course, Sql For Data Science

Course, Introduction To Data Analytics

Course, Finance For Non-Finance Professionals