07/2023 – Present Senior Consultant - Data and Business Intelligence at Assystem, London, UK
Assystem (previously LogiKal) is a global leader in project controls and digital solutions consultancy services.
Client: The Earls Court Development Company 11/2023 – Present. Role: Senior Data and Business Intelligence Analyst.
- Developed scheduled ETL processes sourcing data from multiple systems and updating the Data Warehouse.
- Developed automated Power BI reports and managed security roles, the Power BI App and admin of the Power BI service and workspaces.
- Overhauled an existing custom app (Budibase), greatly increasing performance and adding new features.
Internally:
- Spearheaded Assystem's internal digital initiatives through its digital taskforce, emphasizing data management, analysis, and reporting.
- Delivered internal Data Management training and mentored team members on Power BI and other tools.
- Undertook a Project Controls Maturity Assessment focused on the aspects of data, reporting, systems use and their integration for a large organisation, delivering actionable recommendations.
- Developed ETL processes for marketing, calling the LinkedIn and Google Analytics APIs and developed a Power BI report that enabled data-driven decision-making.
- Won second place in Logikal's (now Assystem) global Power BI competition.
- Authored industry-related articles, study cases, and bid proposals.
02/2022 – 07/2023 Consultant - Data and Business Intelligence at Assystem, London, UK
Client: The Earls Court Development Company – 3 months. Role: Digital PMO Solution Architect.
- Developed and implemented the project’s digital strategy, recommending the optimal hosting environment,
user directory, user workspaces, required systems and applications, database and data pipelines.
- Developed ETL processes and a Data Warehouse sourcing data from multiple systems.
- Developed automated Power BI reports, improving data quality and efficiency.
- Rapid application development of several custom apps, streamlining processes and increasing data accuracy.
Client: Network Rail Telecoms Portfolio Management Office – 11 months. Role: Data Analyst.
- Consulted on data management and reporting, identifying opportunities and applying best practices.
- Developed and managed several Power BI dataflows and live connections, combining multiple data sources into a Data Warehouse that was used as the single source of truth.
- Revamped several existing Power BI reports, significantly reducing required queries, increasing performance, and improving data visualisation.
- Developed and managed Power BI reports, improving data quality, data visualisation and reducing workload.
- Rapid application development of several custom apps (Power Apps) for various functions, optimizing processes and increasing data quality.
- Developed automated processes using Power Automate, significantly reducing manual workload.
Internally:
- Developed a standardised ETL processes and dashboard for project schedule data, deployable in any project.
- Pioneered a concept tool using GIS, Power BI, and integrated schedule data for project clash detection.
10/2021 – 02/2022 Information Manager at Mott MacDonald, Croydon, UK
Mott Macdonald is a global engineering, management, and development consulting firm.
- Proposed, developed and managed an SQL database and a Power BI report to visualize and interrogate the data for a project.
- Proposed and developed a comprehensive tool (Python) to automate complex engineering calculations (managed the associated project and budget).
- Developed a validated data input tool and Power BI report providing insights to project performance for a multi-billion NHS improvement project.
- Proposed and developed automation tools (Power Automate) to automate tasks and processes to increase efficiency.
The largest project in my organization was the design of Highspeed 2 (HS2). Within my role in the design joint venture:
- Trained project teams on processes, platforms and digital tools.
- Led the development of a process to automate data sourcing from multiple systems and produce client reports.
- Managed asset data and processes across the project and interfaced with external organisations.
- Ensured compliance with ISO 19650 standards and client information packaging requirements.
10/2019 – 10/2021 Graduate Information Manager and Civil Engineer at Mott MacDonald, Croydon, UK
- Primary contact for advice and guidance for all digital innovation and data compliance related matters.
- Undertook engineering design, calculations and production of detailed client ready reports.
Secondment: Balfour Beatty VINCI JV – one year. Role: Assistant Information Manager working on HS2:
- Led digital training activities, managed the Digital Training site and onboarding app (Power Apps).
- Producing digital communications across the organization and chaired frequent meetings with the Directors of IT, Innovation and Transformation and the Head of Information Management.
- Developed the onboarding process, digital training and document requirements for external sub-contractors.
- Upgraded and managed Power BI reports for data quality control.
09/2016 – 05/2017 Airman in Hellenic Air Force, GR (Completed military service)
07 – 08 / 2014 – 2016 Summer Intern in STIRIXIS TECHNIKI S.A. Construction Company, Rhodes, GR
- Collected and processed project and construction material data, which helped refine data management skills.
- Demonstrated high numeracy, diligence and excellent reporting skills while composing project progress reports.
- Collaborated with internal and external stakeholders to effectively complete all aspects of the projects on time.