Alfie Lee Email & Phone Number

San Francisco, CA, US

Oakland, California, United States

• Designed Excel dashboards and reporting tools for analyzing absence data by staff and department.
• Established a standard process to implement reporting tools by identifying key departments to assist,doing case by case analysis and then training sectional managers how to use the tools that would beregularly.
• Executed queries on PeopleSoft to gather relevant HR data.
• Proactively identified opportunities for process improvement, one example automating steps to produce aregular FML report cutting down an hour long process to a 5 minute report turnaround time.
• Demonstrated exceptional problem-solving skills by resolving complex data discrepancies and ensuring data integrity

London, England, United Kingdom

• As part of a newly set up Analysis and Insights team within the Decision Intelligence department I:
• Partnered with key management stakeholders about operational business requirements to establish KPIs and produce reports and dashboards in Power BI (using SQL), QlikView and Excel.
• Used DevOps to manage and prioritize both a management project pipeline and a ticket queue of requests for new reports or changes to existing reports from SAP Crystal.
• Acted as the main point of contact to manage and own report requests between internal customers and the Report System team.
• Collaborated with the Data Science team to ensure database was maintained, updated and produced accurate reporting.
• Operational site visits to gather business knowledge and identify areas of improvement.

Milton Keynes, England, United Kingdom

• Creating excel solutions to automate reports, streamline processes and manipulate data. Including Power Query, Power Pivot, VBA and Crystal Scheduler.
• Producing regular scheduled reports and ad hoc analysis for customers.
• Setting up and regularly running a bonus pay calculation matrix for temp and perm staff on payroll.
• Maintaining a ticket queue (Helpdesk) and project pipeline (DevOps) to manage internal report requests.
• Manage the existing platform for delivering reports and improving security around sensitive data.

Milton Keynes, United Kingdom

• Creating dashboards, using SQL coding to power live graphs (or java widgets) and reports
• Creating reporting tools, presentations and analysis for regional management.
• Ensure Quality Assurance of all outgoing reports to deliver reliable reporting that were used as a base for significant business decisions.
• Running and maintenance of a live risk management system – tickets, inbox and workload for the team.
• Being the main contact point for Business Colleagues and IRM team members from the region who have requirements for information and data.
• Regular meetings with System Support (USA) to implement developments and find solutions to errors.

Milton Keynes, United Kingdom

• Produce regular and ad hoc market insight analysis against competitors for the company.
• Create various daily and weekly reports for management such as:Customer Profile Reports, Registrations to date, Total Marketplace overview, Competitor Analysis, Accessory Sales, Pricing/Promotion Incentives, Industry.
• Provide weekly reports on new and existing leads that show how the dealerships progress these numbers into profitable sales.
• Accessory sales monthly reports – one showing a breakdown of sales for each model by month, then another showing comparative sales performance for each dealer/region/averages.
• Customer profile reports using survey data for reports that tell us who buys our cars and how models/Suzuki compares to the rest of the industry.
• Generate month-end market competitor data for the UK and Ireland.

Milton Keynes, United Kingdom

Analyse, report and data manage commercial supply tenders and current supplier performance for a large European car parts distributor. Producing ad-hoc product and pricing analysis using Access, Excel and SQL. Project managing the implementation of a new BI interface and developing systems to assist with supplier reviews

Milton Keynes, United Kingdom

Temping - After returning from two months traveling I took on a support function in the Planning and Strategy team for Vans at MBHQ. Here I ran reports on sales and registration performance over multiple systems.

Milton Keynes, United Kingdom

FTC - I played a pivotal role in the VW Tactical (bonus) team managing the payment of some 40,000 plus loyalty offers – following the emissions crisis this tactical offer was introduced to encourage previous customers to reorder a VW and stay with the brand – I was responsible for developing and implementing a new system to process and audit the campaign.

Milton Keynes, United Kingdom

(Fleet contract hire) - Liaising with car dealers and a logistics agent (SMH) to ensure a smooth delivery process on orders taking over an average lead time of 6 months from build to delivery – Managing customer expectations, acquiring factory build dates to the delivery and handover.

Milton Keynes, United Kingdom

Temping - MK council education department – Initially I supported the data management of exclusions and produced structured reports on recent school performance statistics. I went on further to assist the team’s Data Analyst with ongoing projects such as The School DFE Census, FFT Aspire and tracking the progress of children looked after by the Council and.

Milton Keynes, United Kingdom

• Temping
• At the NHBC I assisted the Procurement manager to develop a central contact database that helped manage all departments spending, reduce risk, hold supplier information and flag up contract renewals. Worked closely.
• We put new and existing suppliers through a tender process for the supply of personal protective equipment and branded clothing, a solution for an expense management system (software & service), travel management, a.
• I purchased goods for internal customers, sourcing new and bespoke products and services from both preferred suppliers and new ones.
• I stepped in to a financial purchase ledger role when an employee left the accounts department unexpectedly, while still managing my procurement work load.

Temping - From specialist Porsche sales to Wilsons auctions held in Ireland, at VW Financial Services I assisted the remarketing of vehicles after they were returned from customers hire agreements. This involved innovative problem solving and working as a team to meet deadlines and sale targets. I would look at price trends in the markets, prepare the.

Bachelor Of Arts (Ba), Film/Cinema/Video Studies, 2:1

Activities and Societies: Music event societies‘Alfie proved himself to be a student of ability. He was an engaged contributor to the.

Education record