Matthew Mcnulty Email & Phone Number

London, Gb

London, England, United Kingdom

• Collaborated in an Agile SDLC with a diverse team on the UFC-WWE merger (TKO), converting 30+ legacy scripts into DBT models for Snowflake, migrating ~100TB of financial data to streamline YouTube revenue reporting.• Supported ELT pipelines by scheduling Databricks notebooks with Airflow DAGs to efficiently ingest data from 300+ social media accounts via APIs and developing modular notebooks to persist data in Azure Data Lake Storage Gen 2.• Enhanced DBT models for Snowflake to analyse performance metrics (e.g., reach, impressions) by developing fact and dimension tables with comprehensive DBT tests and custom DBT macros to ensure data accuracy and integrity.• Engineered a data pipeline to aggregate cloud infrastructure costs across Azure, Databricks, and Snowflake, creating a data mart with automated monthly insights for senior leadership, enhancing cost transparency and decision-making.• Contributed to UFC data marts in SQL Server using SSIS for ETL processes, such as optimising the active subscriptions table to reduce refresh times by 70% and implementing custom logic for managing sponsorships for athletes.• Automated weekly UFC merchandise sales data exports to client-side SFTP, replacing manual Excel reports and enhancing efficiency in data workflows, while ensuring secure data transmission and reducing preparation time by 95%.

Raipur, Chhattisgarh, India

• Engineered an ETL pipeline by scheduling Selenium scripts with CRON to scrape 15 years of agricultural commodity prices and integrate real-time weather data via an API, enhancing the training dataset for predictive models.• Architected dimensional models using the Kimball approach in PostgreSQL to organise agricultural and crop-related data across data marts containing 200M+ rows and implemented stored procedures to automate data manipulation.• Trained an LSTM model using TensorFlow/Keras for time series forecasting of prices across 10+ agricultural commodities, providing insights for stakeholders, especially marginal farmers, and optimising futures market strategies.• Hosted the price prediction model on Google App Engine with GitHub Actions for CI/CD, achieving MAPE of 15%-20% for short-term predictions, after triggering manual retraining due to data drift and external economic changes.• Implemented a blockchain-based supply chain app on Hyperledger Fabric, leveraging Golang smart contracts and a Node.js backend to optimise data integrity, traceability, and transparency throughout the agricultural value chain.• Deployed the scalable, high-availability supply chain app on Google Kubernetes Engine (GKE), securing user data in CouchDB and protecting asset documents in Google Storage using SHA-256 hashing for tamper prevention.

County Donegal, Ireland

• Utilised Tableau to craft captivating infographics and conduct in-depth analysis, highlighting the unique selling points of Derry-Londonderry and showcasing the advantages of relocating to the area as part of clients' marketing strategies.• Investigated the location of the county's diaspora around the globe using demographic data and mapping tools, resulting in a focused marketing approach that boosted engagement and interest from individuals with ties to the county.• Participated in the Ambition pre-accelerator run by Local Enterprise Office Donegal in partnership with NDRC, designed to support female entrepreneurs in developing globally scalable ventures, attracting investment, and creating jobs.• Participated in the New Frontiers entrepreneurship program, leveraging its resources to transform a business concept into a revenue-generating and investor-ready startup through mentoring, training, incubation space, and access to R&D facilities.

Letterkenny, County Donegal, Ireland

• Systematically analysed procurement costs and competition across 20K+ rows by employing Excel's data sorting, filtering, and pivot table functions, resulting in optimised pricing for competitive advantage and maximum profitability.• Streamlined data tasks through custom Excel formulas with VLOOKUP and INDEX MATCH, such as calculating conversion rates and generating automated invoices, delivering a weekly team time savings of approximately 10 hours.• Crafted Power BI and Google Analytics dashboards for the sales team and management, facilitating real-time access to KPIs and data-driven decision-making by visualising sales data, website conversion rates, and other critical metrics.

Raipur, Chhattisgarh, India

Msc (Comp), Big Data Analytics, First Class Honours

Business Intelligence • Talend Data Integration for ETL • Tableau for Data Visualisation • Data Warehousing Machine Learning • Linear &.

Bsc (Hons), Physics And Astrophysics, Second Class Honours

Foundation Physics Mathematics for Physics Computational Methods Computation Modelling in Physics Modern Physics Physics of the Solid.

Leaving Certificate, 500/625