À propos de Stephen
- Data | SQL, Visual Studio Code, SQL Server Management Studio
- Visualization | Tableau, Power BI, Advanced Excel (Power Query/Pivot, VBA)
- Automation | Excel VBA, SQL to Excel integration, Tableau Data Source publication
Anglais
Bilingue ou natif
Français
Notions
Expériences
- Irwin Mitchell LLPData & Insights AnalystDROITmai 2021 - août 2024 (3 ans et 3 mois)Sheffield, Royaume-UniReporting AutomationI used SQL and Visual Studio Code to modernise our monthly reporting. I built direct data links that pull information straight into Excel, which removed the need for manual exportsInsight DevelopmentI used SQL and our complex data sources to develop new, meaningful metrics for the business. A key project was creating a way to accurately measure our pricing and discount levels, which gave visibility of our potential vs realised marginsInteractive VisualisationI developed and published interactive Tableau dashboards to provide stakeholders with live self-service visibility into KPIs and metrics, including profitability, staffing levels, and pricing analysisAdvanced ForecastingI built a forecasting model by embedding SQL queries directly into Excel to help the business budget. This tool allowed us to predict future client volumes and the potential value of each client, which gave the management team a much clearer picture of our projected turnover
- Irwin Mitchell LLPPI Billing Team LeaderDROIToctobre 2009 - mai 2021 (11 ans et 7 mois)Sheffield, Royaume-UniLeadershipI was promoted to Team Leader in 2017 to manage a team of five. My focus was on making sure we processed billing accurately whilst supporting the team's professional developmentDriving EfficiencyI used VBA and SQL to build processes and automate several manual tasks. This saved time, allowing the team to focus on accuracy, making our billing process much more reliableProcess ImprovementI introduced a new billing instruction framework that ensured our team had the right information from the start, which made life much easier for the team and improved the service we providedKnowledge SharingI acted as a regional subject matter expert, travelling to various offices to deliver presentations and training on Finance department protocols and best practices
- RAC Auto WindscreensSales Ledger ClerkAUTOMOBILEmai 2007 - octobre 2009 (2 ans et 5 mois)Chesterfield, Royaume-UniFocused on high volume query resolution and dispute management using Oracle. Communicating with local offices and processing invoice amendments onto the accounting system
Recommandations
Soyez le premier à recommander Stephen
Contribuez à la réussite de ce freelance en partageant votre expérience de collaboration avec lui.
Ces profils de freelance correspondent également à vos critères
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Formations
- BA (hons) Accounting and Financial ManagementThe University of Sheffield2006
- A Levels - Business Studies (B), Mathematics (C), ICT (C), General Studies (B)The Dronfield School2003