Abdul W. Email & Phone Number

United Kingdom

• Developed Tkinter and flask prototypes in early stages of cash tracker. SQL for data management. This solution streamlined cash flow analysis and reduced manual data entry by 90%.• Designed and implemented VBA macro book to automate group consolidation and SharePoint export• Constructed SQL stored procedures and views to optimize data retrieval and analysis, supporting the Python application and enhancing overall system performance.• Exported general ledger to our new azure data lake warehouse from old sql server using D365 functions• Led agile development efforts (general ledger) to successfully execute data migrations from development to user acceptance testing (UAT) and production environments. • Created a fully automated Excel-based Cash Forecast Reporting tool leveraging Power Query, VBA, and Office Script to provide historical and forecast reporting.• Contributed to legacy code modernization by migrating SQL code from bronze to silver stage, laying the groundwork for future enhancements.• Data modelled Kimball’s star schema for dimension tables and general ledger & other ledgers for cash tracker• Innovated with VBA data wrangling for Teletracker time sheets disparate data• Project management through IT self service ticketing system to resolve client issues and delegate

Slough, England, United Kingdom

• Designed and implemented a data streaming pipeline using Power Query, Excel, and API integration within Power BI to ensure timely and accurate data ingestion.• Developed a comprehensive Power BI temporal labour report, allocating labour costs to cost centres and enabling longitudinal analysis by period for enhanced decision-making.• Calculated and reported the TRS measure (line efficiency) by comparing lights-on hours to theoretical standards, providing valuable insights into operational performance.• Constructed a web scraper utilizing Python to extract log speed data from HTML tables on the Slough manufacturing site's website for 4-line and Maltesers production.• Created a customized periodic date table to facilitate accurate and flexible time-series analysis within Power BI reports, according to their financial year

Reading, England, United Kingdom

• Enhanced user experience for contract managers by developing VBA user forms and integrating APIs to streamline contract data upload processes.• Designed and implemented a Microsoft Access database utilizing SQL and star schema to improve data storage and migration from Excel, optimizing data accessibility and analysis.• Served as the primary point of contact for contracts and procurement teams, providing support and training on contract management tools and processes.• Pioneered data streaming by automating Power BI report generation through API integration, ensuring timely and accurate data delivery.• Updated contracts through the SAP module to update contract data e.g. deadline, live etc. and search via contract code. Also added categories to the contract and send approval to higher ups through the SAP ERP.• SAP analytics training course to familiarise ourselves with the new tool and built some equivalent visuals to PowerBI

Tamworth, England, United Kingdom

Worked under finance director to analyze product sales, build VBA automations, distribute reports, and reconcile errors.• Optimized data performance by designing and implementing a data model (fact and lookup tables) within the PowerPivot engine, leveraging star schema for efficient query processing. Normalised data from QlikView to aid in data analytics of products.• Developed and delivered key performance indicators (KPIs) for major retail clients, including outstanding orders and margin reports for Screwfix and B&Q.• Provided timely and accurate resolution of debits and EPOS requirement reporting issues for B&Q and Screwfix within agreed service level agreements (SLAs) using Salesforce.• Created custom VBA Excel add-ins to streamline regular reporting processes, resulting in a 90% reduction in manual effort and increased efficiency through one-click automation.• Used Qlikview to download CSV files that were then used to add it to the existing report's data model for sale analysis

Bristol, England, United Kingdom

Worked for sustainability company within ESG metrics and ad-hoc reporting capacity.• Developed a custom Excel add-in copying data from Enablon to Excel sheets, significantly enhancing efficiency and productivity through automated processes by 50%• Provided valuable insights and recommendations to clients, AvonFire (Excel) and Malvern Swimming Club, by leveraging Power BI and Excel for data-driven decision making e.g. regression analysis for CO2 emissions in Excel.• Contributed to diverse projects encompassing data visualization (as above), marketing (SWOT), demonstrating versatility and adaptability.Delivered impactful presentations to the CEO and employees on corporate sustainability and the EHS market, fostering awareness and engagement.• Executed rigorous software testing on a new Enablon version, meticulously identifying and documenting 1700 test/fail logs to ensure product quality.• Conducted in-depth SWOT analyses for the company and its competitors, providing strategic recommendations for competitive advantage.• Created informative electricity, gas, and CO2 dashboards, complemented by compelling data storytelling to drive client engagement.• Managed Jira to resolve customer queries and deliver issues within SLA

Msc, Accounting And Business Management

Activities and Societies: Group leader for debate on cryptocurrency, financial and management accounting with survey data analysis as part.

Beng, Mechanical Engineering

Activities and Societies: Won two mechanical design challenges: rover truss design, and MDP robot design challenge. Partook in IMeche.