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.
• 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.
• 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.
• 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.
• 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.

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.
• 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.
• 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.
• 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.
• 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.
• 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'.
• 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.
• 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.
• 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.

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.
• 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.

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