Jeffrey Nelson Email & Phone Number

Lindale, Us

Lindale, Us

• Utilized expertise in QlikSense to design interactive applications and dashboards, consolidating data from diverse sources such as Vista, HOLA, Sales Force, Survey Monkey, SQL Server, and Excel Files.• Implemented intuitive QlikSense dashboards, facilitating comprehensive data visualization and amplifying analytical capabilities within the organization.• Ensured data accuracy and integrity during the migration to Dayforce, demonstrating meticulous attention to detail and maintaining high standards for data quality.• Constructed pivotal reports using Power BI, ensuring a seamless transition, and providing immediate access to crucial insights post Dayforce implementation.Select Achievements• Spearheaded the transition of reporting services from an ad-hoc model to predictive analytics, overseeing the creation of comprehensive staffing and recruiting forecast reports, offering actionable insights for current and future staffing needs.• Orchestrated the successful implementation of the HRIS System, Dayforce, playing a pivotal role in the seamless data migration process and configuring the new organizational structure within Dayforce.

• Provide data analysis, reporting, insights, and forecasting in support of supply chain management for $260M food distribution company; oversee inventory control to ensure perishable food items from three production facilities reach three HUB warehouses and 19 external warehouses across U.S.• Influence strategic business decisions by extracting data, generating reports, and providing advanced ad hoc analysis to identify and clarify business analytical needs and deliver business insights to stakeholders.• Create and manage analytical tools/reports using Tableau, SQL, and Excel. Perform statistical analysis to derive insights and give visibility of key business data to senior leadership.• Formulate, manage, and manipulate data critical to decision-making for Supply Chain Manager, including ad hoc reports on inventory levels and materials cost/forecasting.• Design and develop automated visual analytics reporting, including high-impact dashboards, scorecards, and interactive reports, facilitating leadership’s ability to make strategic and informed business decisions.• Champion analytical process improvement to streamline and advance reports utilizing Tableau. Troubleshoot existing reports and advise on potential reporting solutions.Select Achievements• Reduced aging inventory 66%+ after taking over management of division in May 2021. o Streamlined data and created readable reports in clear, concise, and useful format.o Implemented notifications to inform sales team of inventory near sell by date to move items quickly.• Built demand planning forecast reports in Forecast Pro to increase accuracy of predicating product demand. o Assessed SQL data bases and transferred historical sales data to new program.o Utilize historical sales data to forecast sales and identify trends.

Houston, Texas, Us

• Hired as Compliance Specialist to coordinate business activities for exportation operations, including data analysis and reporting, freight communications, and compliance with laws, regulations, and policies globally.• Took on responsibilities as Logistics Specialist (2018). Utilized advanced Microsoft Excel skills to clean, filter, and manipulate large sets of data; created pivot and performed advanced functions, including VLOOKUP, SUM, and IF to analyze data and generate ad hoc reports.• Created financial tracking/reporting tools using Excel, Glovia, and Cognos to accurately forecast and manage monthly/quarterly projections. Verified KPI results and submitted results to warehouse managers.o Utilized advanced formulas/functions to manipulate data & build visualizations to better present data.• Tasked to developed efficient standard operating procedures for multiple warehouse segments divisions. Created job descriptions, established multibranch action plans, and eliminated risky or redundant activities.• Collaborated with eight department managers to review and update all departmental policies for compliance issues. Fielded and resolved up to 100 inquiries daily regarding trade compliance incidents.Select Achievements• Decreased ad hoc reporting time 83% by streamlining and optimizing data collection when generating daily, weekly, and quarterly warehouse financial metrics.• Reduced dangerous goods (DG) fines from $100K+ per month to zero in less than three months after serving as Project Manager to improve DG receiving, storage, and distribution processes.o Collaborated with Safety and HR teams to established/implemented best practices for handling DG.o Set company-wide standard and SOPs for receiving, storing, and shipping DGs.o Trained leadership, including C-level, middle management, and safety management from six distribution centers in DG SOPs to ensure successful implementation into facilities nationwide.

Richmond, Virginia, Us

Led buying efforts such as tracking purchases and purchasing up to $10M worth of vehicles annually, coordinating onsite auctions, and onsite vehicle appraisals.  Managed Buyer Assistant activities overseeing quality of current saleable vehicles and mentoring Buyers in the training program with the goal of passing the final skill assessment CDP program.  Contributed as a member of an offsite purchasing team by attending regional auctions purchasing up to $1.2M during an auction spending 10% less than forecasted cost due to car savvy and auctioning knowledge. Referred 30% of appraisal only customers to Sales Consultants with the goal of conversion to a buying customer.  Delivered exceptional customer service during the appraisal process and presented appraisal offers to customers addressing concerns and building the customer’s trust with the process achieving 58% conversion rate.

Richmond, Virginia, Us

Developed buyer skills as a trainee including onsite vehicle appraisals, coordination and oversight of onsite auctions, attendance at regional auctions, and vehicle purchasing for up to $10M annually. Utilized various resources to determine fair price for CarMax to pay for a used vehicle and further learned the dynamics of the used car wholesale industry. Conducted quality inspections and initiated the reconditioning process while tracking purchases and setting prices based on sales data and competitive analysis.

Richmond, Virginia, Us

Facilitated buying activities for 100+ vehicles per day including securing purchased vehicles, visual inspections, cross-functional collaboration to execute needs of the business.  Partnered with the purchasing team to assist Buyers with up to 1K+ weekly including staging and ordering vehicles, applying auction numbers, notifying of vehicle issues, and to supply buying documentation for purchasing bidders to sign. Executed due diligence ensuring that comprehensive inspections were complete for every vehicle confirming all options/specifications and confirming all images were of the highest quality to be submitted and displayed on the website.