You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Malt welcome

Welcome to Benedict's freelance profile!

Malt gives you access to the best freelancers for your projects. Contact Benedict to discuss your project or search for other freelancer profiles on Malt.

Benedict A.

Data Engineer, Data Automation, Excel VBA, Python
  • Suggested rate
    £500 / day
  • Experience8-15 years
  • Response rate100%
  • Response time1 hour
The project will begin once you accept Benedict's quote.
Location and workplace preferences
Location
London, United Kingdom
Remote only
Primarily works remotely
Verifications

Freelancer code of conduct signed

Read the Malt code of conduct
Verified email
Languages
Categories
These freelancer profiles also match your search criteria
Agatha FrydrychAF

Agatha Frydrych

Backend Java Software Engineer

Baptiste DuhenBD

Baptiste Duhen

Fullstack developer

Amed HamouAH

Amed Hamou

Senior Lead Developer

Audrey ChampionAC

Audrey Champion

Web developer

Skill set (25)
Industry fields of expertise
Benedict in a few words
I am a highly seasoned data engineer and developer, with a robust and diverse skill set honed over more than a decade. My expertise encompasses a wide spectrum of data engineering tools and technologies, making me proficient in delivering top-tier solutions for a variety of data-related challenges.

I have a deep understanding of database management, employing tools such as SQL and T-SQL to craft efficient data storage and retrieval systems. My experience extends to designing and optimizing ETL (Extract, Transform, Load) processes, leveraging Microsoft technologies like SSIS (SQL Server Integration Services) for seamless data integration and transformation. I am equally proficient in using SSRS (SQL Server Reporting Services) to create insightful, visually appealing reports that empower data-driven decision-making.

My toolkit extends beyond Microsoft's ecosystem, encompassing Excel VBA for automating data manipulation tasks and Python for versatile data analysis, scripting, and automation. I harness the power of tools like Power BI to develop interactive and dynamic data visualizations, enabling stakeholders to derive meaningful insights from complex datasets.

Moreover, my cloud expertise extends to AWS and Azure, where I architect data solutions that are scalable, secure, and cost-effective. In my role as a data engineer and developer, I have consistently demonstrated the ability to select and apply the right tools for each project, ensuring optimal outcomes for organizations seeking to unlock the true potential of their data assets.

With over a decade of experience and a comprehensive skill set, I am committed to delivering data solutions that drive business growth and innovation. My track record reflects a deep passion for data engineering and development, making me a valuable asset in the ever-evolving world of data-driven decision-making.
Experience
  • CityFibre
    Senior Data MI Analyst/Application Developer
    TELECOMMUNICATIONS
    September 2020 - April 2022 (1 year and 6 months)
    Milton Keynes, United Kingdom
    Implemented dynamic real-time Power BI dashboard reports, automated excel report and ad-hoc KPI reports for senior stakeholder using Excel VBA, Power BI DAX and SSRS to visualise stock movements in various location and manage network asset inventory.

    Extracted large volume of data with ETL process from various sources into target destination (AWS and Microsoft Azure) using SQL Integration Services (SSIS)

    Developed, maintain and managing Inventory Management System backend and frontend using Django framework, REST API and React JS.

    Developed several dashboard reports using Power BI and SSRS to track capacity shortfall based on growth and customer forecasting.

    Developed and managing network asset inventory data warehouse holding active and passive components for UK’s ultra-fast fibre optic broadband being rolled out to business and residential customers across UK cities.

    Lead in data migration between various source systems SQL Server and PostgreSQL
    SQL SQL Server SSIS Excel VBA SSRS Power BI Python Django REST API React.js ETL Transact-SQL
  • TalkTalk
    Senior BI Developer/FTTP Network Data Manager
    TELECOMMUNICATIONS
    August 2019 - September 2020 (1 year and 2 months)
    Manchester, United Kingdom
    Producing periodic reports through automation using Excel VBA scripting, SSIS integration, Power BI and SSRS

    Lead in data migration between various source systems SQL Server and PostgreSQL

    Created complex SSIS/SSDT packages for uploading various 3le formats into network inventory data warehouse and GIS systems (QGIS) for real-time asset information.

    Continuously innovating and driving changes in systems to improve customer services, cost of network deployment and speed of rollout.

    Developed and implement Stored Procedures, User Defined Functions, Triggers, Views and T-SQL scripting for complex business and inventory logics
    SQL SQL Server Excel VBA SSIS SSRS QGIS Power BI Microsoft Azure ETL Transact-SQL
  • Capita
    Senior MI Analyst
    CONSULTING & AUDITS
    August 2018 - August 2019 (1 year)
    Manchester, United Kingdom
    Supporting Electronic Monitoring System (EMS) contract for Ministry of Justice (MoJ) through the delivery of timely, accurate and robust QA assured Management Information that: Assists management and client to drive performance.

    Positively contributing to the bottom line achievement of SLAs/CDI’s and Supports measurement and evaluation of alternate strategies.

    Developed Management Information reports/dashboards including KPI's and trends using SSAS cubes.

    Developed Operational and Management data model for Real-Time tracker and establishment analysis for business productivity reporting using T-SQL, BI Stack, Excel VBA and Power BI. This project saved the business £65,000 development and implementation cost.

    Creating, modifying and deploying Power BI/SSRS reports in line with Business Requirements.

    Automating and maintaining reports using Excel VBA.

    Performed data cleansing, mapping and transformation using ETL process SQL BI tool (SSIS) as required.

    Responding to ad-hoc data requests in a timely manner using multiple data sources.

    Ensuring the accuracy of data and report presentation is quality assured.

    Working with customers to define and support their needs providing guidance to the best solution.

    Troubleshooting and investigating report anomalies.

    Coaching and mentoring MI Analysts in Report Development and T-SQL as part of their continuous development.

    Maintain good working relationships with all levels of the business e.g. Chief Operating Officer, Senior Operational Managers, Shift Managers, Field Service Managers and Operational Support Officers.

    Exploring innovative ways of providing reporting solutions to the business when required.

    Ensuring any Data Warehouse changes have minimal or no impact to the Business and the Client.
    Transact-SQL SSIS Excel VBA SSRS ETL Microsoft Power BI SQL Server SQL
Recommendations
Education
  • Masters
    Liverpool John Moores University
    2018
    Computer Science
  • Bsc
    Oxford University
    2016
    Information Technology