Learn Data Skills
Beta
Paul Lymburner

Paul Lymburner

analyst

n/a

Technologies

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Intermediate Python
Understanding Data Science
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

Albemarle Corporation | May 2023 - Present

Business Process Mining Analyst

N/A

Lowe's Companies, Inc. | Jul 2020 - Apr 2023

Supply Chain Analytics Senior Analyst

Responsible for creating reporting reflecting different aspects of distribution, warehouse, and transportation management systems, with minor work with e-commerce systems to create reports, scorecards, and dashboards for different audiences. To create the reports, I use Alteryx, KNIME, SQL queries of multiple different databases, Power BI (Desktop, Service and Paginated) and Power Automate to manipulate and model the data into analytical projects. • Created and maintained node level scorecards that are used across the supply chain hierarchy • Developed an interim solution for the Summary Scorecard sources from other scorecards while a permanent solution was built • Wrote daily stats reporting that replaced multiple daily reports • Designed a Safety Dashboard that’s used as the main source for OSHA Reportable Incidents and days safe • Produced reporting that demonstrated the relationship between trailer cube utilization with store sales and in-stocks • Made standardized tables for use across the team for regularly used reporting to help normalize reporting
Show More

Lowe's Companies, Inc. | Nov 2018 - Jul 2020

Senior Analyst, Transportation

Responsible for gathering requirements for analysis projects from different stakeholders; determining the best approach to pull the needed data from Oracle, Teradata and Hadoop databases, Web or API sources and/or tabular data warehouse; modeled transportation systems to evaluate different strategies on the basis of resource efficiency and cost using JDA’s Transportation Modeler tool; and presenting the data or analysis results in Power BI for stakeholder consumption. • Modeled multiple scenarios for store deliveries to help determine the viability of frequency of service changes • Developed API and web data sources and their automated refresh cycle in Power BI Dataflows • Developed API functions for the purpose of standardizing and cleaning up geolocation data • Wrote monthly market analysis report on the direction of the transportation industry for distribution throughout the department • Align multiple data sources to create analysis tools that saved time in assigning outbound loads to inbound backhauls

Red Classic Transportation Services, LLC | Aug 2017 - Nov 2018

Senior Business System Analyst

Responsible for documenting, maintaining and creating solutions for both the Transportation Management Systems (TMW and Mercury Gate) and Asset Maintenance System (TMT); working with different stakeholders to develop solutions to business challenges; enabling changes to both the front- end applications as well as backend database solutions; and suggest and implement solutions that increase data consistency and accuracy. • Led the process to evaluate and update data as part of an implementation of a new accounting system • Took ownership of the fleet maintenance system and worked with stakeholders to improve functionality and data quality • Lead the technical portion of implementing a standardized master data plan including writing, testing and implementing scripts • Led the development, testing and implementation of a custom pay process for Owner-Operators • Created the test scripts and development process for handling multi-stop loads using legacy in-truck electronic systems

Cardinal Logistics Management | Jun 2013 - Aug 2017

Business Systems Analyst II

needs including: integrating operations from the merger with GreatWide as well as new business; unifying data from different data sources into usable SQL tables for TMW, TMT, Omnitracs and other providers; writing stored procedures in SQL; report development in SSRS; work closely with internal and external developers ensure solutions fit business needs; manage projects from inception to completion and provide technical support. • Automated the fuel allocation and reporting process that reduced processing time three fold and increased accuracy over 99% • Saved over $75,000 during the merger by creating audit reports to verify payroll deductions versus fuel card transactions • Lessened bad debt write offs from $15,000 - $20,000 per month to less than $5,000 by creating a credit worthiness analysis • Transitioned between fuel tax providers on-time and on budget, while increasing data accuracy and timeliness • Integrated actual federal and state fuel tax amounts to fuel cost reporting for cost allocation to individual cost centers • Established a process by which actual Highway Use and State Fuel Taxes (IFTA) costs are charged to individual cost centers • Lead development, testing and implementation of time clock process for compliance to California state law • Implemented a hotel program that saved 10% over direct bill accounts, and unified payment and cost allocation processes • Created an integration process for electronic scale tickets into the trip’s invoice, which lessens the need for manual entries • Standardized driver fuel card accounts by unifying the accounts, which provided consistent purchase limits and product access

Family Dollar | Apr 2010 - May 2013

Assistant Transportation Manager

Responsible for the inbound and outbound shipments of goods on a dedicated fleet of between 80 and 120 drivers to more than 750 stores in eight states, overseeing $25M annual transportation spend; building and maintaining relationships with DC and Store Operations; creating delivery schedules that emphasize equipment utilization and service; and monitor service to the stores and resolving issues. Ensuring a team of coordinators planned, tendered and verified information in OTM to ensure accurate reporting. • Reduced inbound transportation cost by $43,500 by suggesting an alternate sourcing point. • Saved 3% on the payroll budget in fiscal year 2011 through cross training and work flow improvements • Increased revenue share 190% in fiscal year 2011 over the previous year • Lessened inbound cost by $500 per load by overseeing an intermodal inbound/outbound program • Cut $12,000 in inbound LTL by implementing a LTL consolidated freight program • Arranged a flawless loading and delivery plan for entry into a new high profile market in California • Maintained 100% backhaul acceptance for two fiscal years (2010, 2011) • Lead the design of two successful delivery schedule re-designs resulted in maintaining tractor utilization at 2,000 miles per truck

Primerica | Jan 2009 - Jul 2009

District Team Leader

Responsible for recruiting team members, team building and developing team members to build a financial services sales organization specializing in various forms of insurance, loans and brokerage accounts. • Recruited and developed five team members within the first three months by recruiting driven entrepreneurs

Dua-Hobbs Associates, LLC | Mar 2008 - Jan 2009

Office Supervisor

Responsible for operations of the Atlanta office by delegating cases to paralegals and duties to hourly employees; overseeing payroll; finance and accounting duties; prepare legal filings; and create/maintain business support processes • Prevented the loss of $50,000 of revenue by creating a network accessible billing tracking system to replace a paper driven system • Saved $5,000 by creating an accounts payable reconciliation system

Cardinal Logistics Management | Dec 2005 - Mar 2008

Operations Manager

Provide regional freight services for a window and door manufacturer, specialty retailer and vendor consolidation for a big box retailer; manage the driver operations, financial analysis, including P&L responsibility, maintain tractor and trailer fleet as large as 40 tractors and 200 trailers; driver recruitment; driver training; order entry, billing and payroll; and develop and implement cost savings and/or service enhancement initiatives • Reduced outbound transportation cost by $150,000 in 2007 through finding third party freight to fill previously empty trailers • Reduced outbound transportation cost by 5% in 2008 through consolidating freight and reducing the number of stops • Saved two hours per day by leading the automation of the customer’s delivery file into our transportation management system • Integrated an additional product line into the delivery system without creating any additional transportation costs • Hold the account record for the number of loads picked up in one day 225 loads (250 stops)

Cardinal Logistics Management | Nov 2004 - Dec 2005

Operations Manager

Managed the local area deliveries for a large corrugated container manufacturer; managed all aspects of the operation from order entry to invoicing and pay roll as well as equipment maintenance (8 tractors and 45 trailers); and accountable for the account’s financial results (P&L) • Won the 10% Club Award for exceeding revenue goals by more than ten percent in fiscal year 2005 • Grew revenue by more than 10% through leveraging idle equipment and balancing customer delivery schedules • Reduced tire related failures by 20% through working with a local tire vendor to do proactive checks on the fleet

Cardinal Logistics Management | Sep 2004 - Nov 2004

Operations Supervisor

Provide operations support to driver management; recruit drivers; order entry; communicate exceptions to internal customers; and maintain driver log and equipment files. • Recruited ten drivers in two months

Cardinal Logistics Management | May 2004 - Sep 2004

Management Trainee

Learn and master operational processes (dispatch & payroll), driver recruiting, transportation regulations and company policies to support daily operations.

My Education

Take a look at my formal education

MBA, Business AdministrationUniversity of Phoenix | 2008
BBA, Business Management & MarketingUniversity of Georgia - Terry College of Business | 2004

Powered by

  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free