RYAN CASTILLO
Summary
Experienced Data and Reporting Analyst with 6+ years across diverse industries. Expert in streamlining business processes, implementing digital solutions, analyzing data, and translating it into actionable insights. Seeking roles in data analytics, Business Process Automation, and AI integration.
Overview
13
13
years of professional experience
Work History
Procurement Data Analyst | D365 FinOps System Administrator
2Degrees under Commercial Division
11.2023 - 03.2025
- Systems: D365 FinOps, PowerApps, PowerBI, SharePoint, Dataverse, Azure DevOps
- Develop, maintain, and improve Procurement spending and Commercial reports using Microsoft Power BI utilising multiple data sources e.g. Excel, SQL, SharePoint, Dataverse, Azure blob, etc.
- Identify data requirements, collaborate with relevant stakeholders, and build suitable BI apps to serve the data requirements.
- Conduct data gathering and cleansing to ensure the integrity and accuracy of data for analysis
- Provide periodical and ad hoc Spend, Commercial and Finance data analysis requirements to business stakeholders (from ELT members to Operational employees), facilitating discussions with technical and non-technical audiences.
- System administrator (SME) for Dynamics 365 Procurement – Finance and Operations module
- Vendor master administration: Onboard suppliers as vendors in D365 and conduct due diligence and background checks when creating and amending vendor records.
- Utilized data visualization tools to effectively communicate business insights.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Analyzed data to identify root causes of problems and recommend corrective actions. Created dashboards to monitor and track key performance indicators.
- Utilized data visualization techniques to present and explain complex data sets.
- Provided technical support for troubleshooting analytics and reporting issues.
- Collaborated with stakeholders to identify business needs and data sources.
Procurement Advisor – Excellence | Data and Insights Analyst
Auckland Transport under Finance Division
04.2018 - 11.2023
- Systems: SAP FICO, Power BI, ServiceNow, SharePoint Portal, Azure DevOps
- Develop, maintain, and improve Procurement and Finance Power BI reports with multiple data sources, e.g. SQL server, SharePoint, API
- Perform data investigation, cleansing, aggregation, analysis, develop data model and BI visualisations to support day-to-day operations and strategic business decision making.
- Communicate with stakeholders with varying data analytics literacy to understand business data requirements and deliver data solutions.
- Lead and participate in Agile Projects and initiatives—PBI report development/SAP integration and other procurement process improvement initiatives.
- Identify opportunities for data quality improvement. Lead automation initiatives to enhance data accuracy and consistency
- Generated reports detailing findings and recommendations to Senior Leaders, GM, and Executive Management
- Conduct Power BI onboarding process to new users - providing access & training to procurement members & wider business.
- Scrutinized purchasing, spending, and other financial data to identify areas for improvement and cost savings.
- Developed and tracked metrics to measure c supplier performance, cost savings, contract lifecycle, GHG emissions, etc.
- Tracked contract performance metrics and reported issues or non-compliance with appropriate stakeholders.
- Maintained database systems to track/analyze operational data and identified areas for improvement.
- Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
Procurement Advisor – Excellence | Capability & Process Analyst
Auckland Transport
09.2019 - 08.2021
- Systems: SAP FICO, Power BI, ServiceNow, SharePoint, Microsoft Office 365
- Identify, analyse, and drive strategic initiatives to enhance internal processes and enable the procurement team to bring value for money.
- Lead process improvement initiatives to enhance the Procurement team's engagement with the business and suppliers.
- Manage relationships and maintain excellent communication with business stakeholders and suppliers.
- Process owner: Procurement digital systems, vendor master data, Procurement digital SharePoint library co-owner.
- Reviewed and enhanced policies to align with company standards and regulatory requirements.
- Streamlined processes by reducing lead times, standardising templates, and implementing digital solutions to boost quality and efficiency.
- Analyzed and documented company processes and suggested areas for improvement.
- Created process improvement documentation and led walk-throughs of proposed changes.
- Increased efficiency and team performance by implementing actionable process improvements.
Procurement Administrator/ Contracts Coordinator
Auckland Transport
04.2018 - 09.2019
- Systems: SAP FICO, Adobe Pro Suites, FlexiPurchase, SharePoint, Microsoft Office 365
- SAP Vendor Master Administrator—Create, maintain, and block AT vendor master in the system.
- FlexiPurchase Administrator—maintains the database, resolves queries, leads CI initiatives, etc.
- Purchasing Card Administrator Auckland Transport liaises with external and internal customers.
- Analyse data to support Procurement specialist in procurement planning and category management and contribute to business process improvement initiative
- Organized meetings for executives and coordinated availability of conference rooms for participants.
- Improved office operations by automating client correspondence, record tracking and data communications.
Supply Planner/Analyst
Nokia Solutions and Networks
03.2015 - 01.2017
Inventory Controller/ Analyst
Toyota
03.2013 - 01.2014
Quality Engineer
Fujitsu Ten Solutions Philippines
04.2012 - 01.2013
Education
Masters - Analytics
Auckland University of Technology
PGDip – Business Administration - undefined
Auckland Institute of Studies
11.2017
Bachelor of Science - Industrial Engineering
Technological Institute of the Philippines
05.2012
Skills
- Business data analysis, analytical problem solving and visualisation
- Expertise in Dynamics 365 for procurement processes
- Data modelling expertise - Data profiling, aggregation, validation, testing and maintenance
- Creating business requirements - definition, process mapping, documenting data elements, data sources owners and stakeholders
- Experienced in SQL, DAX and Python applications
- Proficient in data analysis and developing reports/dashboards using Excel and Power BI
- Skilled in utilising AI applications
- Business process automation using Microsoft Power Platform
- Advanced Excel skills- Macro,VBA Power Pivot and Power Query
- Build interactive SharePoint team sites, create forms using MS Forms and MS List
Accomplishments
Developed Vendor Relationship Management PBI Dashboard for 2Degrees Procurement – October 2024
Developed a Power BI dashboard for the Commercial/Procurement team, integrating spend data and risk insights from business relationship owners to identify strategic suppliers. The report highlighted high-spend, high-risk suppliers, influencing key business decisions. As a result, 98% of identified suppliers committed to the 2degrees Code of Conduct and supported the company's sustainability and clean supply chain goals.
Procurement Power BI report data automation – for Auckland Transport Procurement - 2022
Collaborated with analytics teams to automate Power BI data refreshes for procurement reports, saving 0.25 FTE weekly and enabling daily updates. This improvement boosted report usage by 40% and empowered the procurement team to confidently use real-time insights for contract negotiations, spend consolidation, and strategic planning.
Affiliations
- Chartered Institute of Procurement and Supply (CIPS) - Member since 2020 to 2023
- Ma Runga Waka Toastmaster Club - Member 2020; Club Secretary 2021
Timeline
Procurement Data Analyst | D365 FinOps System Administrator
2Degrees under Commercial Division
11.2023 - 03.2025
Procurement Advisor – Excellence | Capability & Process Analyst
Auckland Transport
09.2019 - 08.2021
Procurement Advisor – Excellence | Data and Insights Analyst
Auckland Transport under Finance Division
04.2018 - 11.2023
Procurement Administrator/ Contracts Coordinator
Auckland Transport
04.2018 - 09.2019
Supply Planner/Analyst
Nokia Solutions and Networks
03.2015 - 01.2017
Inventory Controller/ Analyst
Toyota
03.2013 - 01.2014
Quality Engineer
Fujitsu Ten Solutions Philippines
04.2012 - 01.2013
PGDip – Business Administration - undefined
Auckland Institute of Studies
Bachelor of Science - Industrial Engineering
Technological Institute of the Philippines
Masters - Analytics
Auckland University of Technology
Similar Profiles
Michael D. SnyderMichael D. Snyder
Trial Attorney at U.S. Department of Justice, Civil Division - Commercial Litigation BranchTrial Attorney at U.S. Department of Justice, Civil Division - Commercial Litigation Branch
DOUGLAS GUIDODOUGLAS GUIDO
FIELD SUPERVISOR at THE WOLF INC. (Commercial Landscape Division)FIELD SUPERVISOR at THE WOLF INC. (Commercial Landscape Division)
Lani GannonLani Gannon
Business Development Manager at COIT National Corporate Commercial DivisionBusiness Development Manager at COIT National Corporate Commercial Division
HAZEEL ZAFARHAZEEL ZAFAR
System Administrator/IT Business Partner (ERP) – D365 FinOps Finance, Procurement & CRM Systems at Dubai World Central Corporation, DWCC (U.A.E)System Administrator/IT Business Partner (ERP) – D365 FinOps Finance, Procurement & CRM Systems at Dubai World Central Corporation, DWCC (U.A.E)
Pratapa SushmitaPratapa Sushmita
System Administrator Microsoft Dynamics D365 at ACCENTURE to LANTMANN as clientSystem Administrator Microsoft Dynamics D365 at ACCENTURE to LANTMANN as client