Scroll To View More
Hire the top 3% of freelance developers
Paul W Evans

Paul W Evans

Cape Town, Western Cape, South Africa
Member since September 12, 2017
Paul has spent all ten years of his career in data. Data automation, process, warehousing, analytics, and business intelligence are just some of the many roles Paul has filled to help companies improve and even get to the cutting edge. Want to reduce your reliance on Excel? Paul is your guy. Most jobs he has held has been very outward customer-facing, so he's always looking out for clients' best interests and is conscientious of their needs.
Paul is now available for hire
Portfolio
Experience
  • Analytics, 10 years
  • Microsoft Excel, 10 years
  • SQL, 8 years
  • Visual Basic for Applications (VBA), 7 years
  • Logistics, 6 years
  • Business Intelligence (BI), 4 years
  • Strategy, 3 years
  • Data Warehouse, 3 years
Cape Town, Western Cape, South Africa
Availability
Full-time
Preferred Environment
Windows, SSMS, pgAdmin, Eclipse, Tableau
The most amazing...
...project I've worked on was a complete supply chain overhaul for a Fortune 50 company where I was given a team with full creative control to build from scratch.
Employment
  • Senior Analyst, Business Intelligence and Marketing Analytics
    2015 - 2017
    Conisus LLC
    • Consulted leadership of a large pharmaceutical firm to design custom, mobile analytics solutions in Tableau and SQL Server.
    • Collaborated with internal senior leadership to flesh out new business intelligence line-up, adding additional company revenue streams.
    • Orchestrated formation of visual-based analytics department to increase marketing efficacy, positive cash flow within first year.
    • Designed and facilitated implementation of cutting-edge IT systems using SQL and SSIS, reducing average analysis time 60%.
    • Studied and created new company processes to structure program coordination and reduce touch points by 30%.
    • Designed accounting process and dashboard to track expenses and missing items, supplanting hours spent per day creating and reconciling spreadsheets.
    • Managed a Tableau Server, using tabadmin, tabcmd, REST API, local authentication, and trusted ticket authentication to create unique functionality for end users.
    Technologies: SQL, SSIS, Tableau
  • Senior Analyst, Inventory and Supply Chain Decisions
    2012 - 2015
    The Home Depot
    • Designed Order and Truckload economic decision model and process saving 25% of transportation costs for $80 billion supply chain.
    • Forecasted sales and least-cost options to reduce lead times by 50% and more using Poisson, Exponential, and Monte Carlo simulations.
    • Built data model and tables for 25-person supply chain analytics teams, bringing together many disparate systems.
    • Reduced emergency process by 50%, led UAT team, trained 45 associates, design and implemented enterprise-wide web app while serving on the Emergency Visibility Taskforce.
    • Developed Assortment Tracking software project with Excel front-end and Access back-end to report daily and monthly trends and issues to senior leadership.
    • Rewrote store Informix code to monitor and call out changes in high-velocity seasonal SKUs and changed ordering algorithms saving tens of thousands per store per year.
    Technologies: DB2, Teradata, VBA, SQL Server, Hadoop, Informix, Tableau
  • Analyst, Holiday Inventory
    2011 - 2012
    The Home Depot
    • Coordinated and executed $360 million inventory transfer from vendors to distribution centers to stores.
    • Exceeded all program metrics: turns of 5.21 vs. 4.72, sell through 82.8% vs. 81%, DC in-stock 99.6% vs. 99.17%.
    • Helped create lost-sales algorithm and template to forecast future needs.
    • Created Store-SKU allocation database to coordinate inbound orders, initial sets, and replenishment.
    • Automated process for tracking and reporting products on ads.
    • Distribution-Center-to-Store product receipt lookup.
    Technologies: VBA, Excel, Access
  • Senior Analyst
    2010 - 2011
    BirdDog Solutions, Inc.
    • Led project to bring parcel, LTL, Truckload, and Ocean data-entry in-house.
    • Supported development and maintenance of Microsoft Access SQL database for data entry and analysis.
    • Managed and trained eight temporary employees in data-entry processes.
    • Reduced receipt-to-delivery entry times by 70%.
    • Vastly increased breadth and depth of analysis and consultation capabilities.
    • Lead analyst on full-network optimization/reorganization for national retail supplier.
    • Supported the consolidation of parcel shipping and distribution centers by utilizing current and future package distribution strategies using Excel and SQL analysis techniques.
    • Introduced new transportation management systems to facilitate shipment times and method.
    • Updated warehousing strategies and layouts to accommodate expedited order process and trailer utilization.
    Technologies: Excel, Access, VBA
  • Analyst
    2008 - 2010
    BirdDog Solutions, Inc.
    • Supported consulting process for over 200 middle-market and national companies.
    • Analyzed shipment and load-level data and contracts to create and present cost avoidance and reduction strategies through utilization of advanced Excel techniques (pivot tables, vlookups, etc.) and SQL.
    • Supported the cost savings of over 30% of transportation spend for clients.
    • Responsible for set-up of small parcel clients for invoicing and oversight of initial carrier implementation compliance.
    Technologies: Excel
  • Intern, Technical Support
    2007 - 2007
    Wandering Wifi, Inc.
    • Provided client support for wireless internet and computer and hardware configurations.
    • Managed group of eight employees in project to improve processes and process management.
    • Wrote foundation documents for training of new employees to cut time necessary by 33%.
    • Managed daily operations and technical proficiency of 15 employees.
    Technologies: Networking, WiFi standards, AirWatch
Experience
  • Operational Dashboard Example (Development)
    https://path.blue/portfolio-1-superstore

    This is a sales dashboard put together as an example of some things can be done to bring visibility to operational data. It was done in Tableau using their SuperStore sample dataset

  • BI Web Connections (Development)
    https://path.blue/portfolio-2-web

    This project was creating to showcase some of the many methods you can use to connect data you have to data and other info you can find on the web

  • Take Every Marketing Chance (Development)

    This was a fun side project that I wanted to create to show how you can utilize every bit of space as a marketing opportunity. Here, we have a 404 page (normally annoying because it means you landed on a URL that didn't exist) that was turned into a map that showcases some of what we can do: https://path.blue/404-2

Skills
  • Languages
    SQL, Visual Basic for Applications (VBA), CSS, HTML, SCSS
  • Tools
    Tableau, Microsoft PowerPoint, Microsoft Access, Microsoft Excel, pgAdmin, MS PowerBI, Microsoft Power BI
  • Paradigms
    Database Design, Data Science, UX Design, Agile Product Management, Agile Software Development
  • Other
    Process Improvement, Strategy, Logistics, Business Intelligence (BI), Data, Data Warehouse, Big Data, Analytics, Marketing Analytics, Business Strategy, Tableau Server, Predictive Analytics, Product Management, Marketing, Lean Development, Agile Software Testing, Pricing Models, APIs, Strategic Brand Implementation, Regression Testing, Regression, Business, Brand Strategy, Product Strategy, Brand Management, Project Management
  • Platforms
    Windows, WordPress
  • Storage
    Databases, Teradata, SQL Server Management Studio, Microsoft SQL Server, PostgreSQL, SQL Server Integration Services (SSIS), DB2, JSON, IBM Informix
  • Frameworks
    ADO.NET
  • Libraries/APIs
    REST API, jQuery
Education
  • Master of Business Administration degree in Entrepreneurship and Strategy
    2012 - 2015
    Georgia Institute of Technology, Scheller College of Business - Atlanta, GA
  • Bachelor of Science degree in Industrial and Systems Engineering
    2003 - 2007
    Georgia Institute of Technology - Atlanta, GA
  • High School diploma in Environmental Research
    1999 - 2003
    Jupiter High School - Jupiter, FL
Hire the top 3% of freelance developers
I really like this profile
Share it with others