- CityFibreSenior Data MI Analyst/Application DeveloperTELECOMMUNICATIONSSeptember 2020 - April 2022 (1 year and 6 months)Milton Keynes, United KingdomImplemented 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
- TalkTalkSenior BI Developer/FTTP Network Data ManagerTELECOMMUNICATIONSAugust 2019 - September 2020 (1 year and 2 months)Manchester, United KingdomProducing periodic reports through automation using Excel VBA scripting, SSIS integration, Power BI and SSRSLead in data migration between various source systems SQL Server and PostgreSQLCreated 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
- CapitaSenior MI AnalystCONSULTING & AUDITSAugust 2018 - August 2019 (1 year)Manchester, United KingdomSupporting 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.
- MastersLiverpool John Moores University2018Computer Science
- BscOxford University2016Information Technology