Learn Data Skills
Beta
Phillip Palileo

Phillip Palileo

Financial Analyst

AVEVA Solutions Limited | Cambridge, UK

Technologies

My Portfolio Highlights

My New Track

Understanding Data Topics

My New Course

Introduction to Python

Finance Analyst in Tech | MBA & Msc Finance | BI & Financial Data Analysis | Unlocking Hidden Business Value Through Data-Driven Insights | Empowering and Inspiring Individuals to Achieve Their Full Potential

My Work

Take a look at my latest work.

course

Understanding Data Science

course

Introduction to SQL

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

365 Data Science Business Analyst Career Track

365 Data Science Data Analyst Career Track

Bloomberg Bloomberg Market Concepts

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

AVEVA | Jul 2023 - Present

Finance Analyst

• Leverage expertise in accounting, finance, and data warehousing to extract, upload, and reconcile financial data from legacy systems, ensuring data integrity and accuracy. • Seamlessly migrate legacy general ledger data to Oracle, guaranteeing integration and consistency across systems. • Resolve data movements and discrepancies by maintaining mapping tables, facilitating smooth data flow and accurate representation. • Utilize in-depth knowledge of Oracle Fusion and data structures to effectively troubleshoot Data Warehouse issues, ensuring reliable data, system stability, and optimal performance. • Conduct regular data quality assessments, promptly identifying and resolving anomalies and discrepancies, enhancing the accuracy and reliability of financial information. • Collaborate with cross-functional teams to align HFM with the Data Warehouse, streamlining financial reporting processes and ensuring data coherence. • Foster strong relationships with stakeholders, including FP&A, Finance, and IT teams, enabling effective communication, collaboration, and knowledge sharing. • Provide user support and comprehensive documentation, facilitating data access, troubleshooting, and adherence to data privacy and governance policies. • Contribute to data analysis activities such as M&A, year-end evaluations, data migration, and financial performance assessment, enabling informed decision-making.
Show More

AVEVA | Jun 2022 - Jul 2023

Finance Associate - Record to Report

• Accurately entered and classified financial transactions in the general ledger, including sales, purchases, payroll, and other expenses. • Reviewed and verified the accuracy of journal entries, including those related to intercompany transactions and transfer pricing. • Reconciled complex accounts, including inventory, payroll, and tax accounts, to ensure that they are properly reflected in the financial statements. • Reconciled balance sheet accounts, including fixed assets, accounts payable, and accounts receivable, to ensure their accuracy and completeness. • Monitored and reviewed the daily cash transactions to ensure the accuracy of the company's cash position and prepare related reports for management. • Was responsible for all month-end closing activities, in compliance with company accounting policies and the application of IFRS. • Communicated with internal and external stakeholders as needed.

AVEVA | Sep 2021 - Jun 2022

Finance Associate - Master Data Management

• Set-up and maintenance of supplier and customer records as well as regular reviews of data sets to identify gaps and inconsistencies for integration and de- duplication. • Liaised with accounts payable, accounts receivable, commercial operations, financial systems, and procurement teams regarding any system errors arising out of master data errors. • Reviewed data upload files before loading and post data load to ensure data has been correctly loaded and in accordance with local requirements • Worked with the data owner and the data stewards for other systems to ensure customer and supplier data is managed according to data standards agreed by the Data Governance Team • Liaised with local finance team and tax teams to ensure localizations are properly reflected in the master data.

JLL | Jun 2020 - Sep 2021

Data Coordinator

• Enhanced data quality and operational efficiency by orchestrating seamless onboarding of new clients, suppliers, and properties. • Conducted meticulous data analysis to proactively detect and rectify data quality discrepancies. • Diligently oversaw and maintained datasets, safeguarding the precision and integrity of property databases.

Cambridge University Hospitals NHS Foundation Trust | Dec 2018 - Jun 2020

Administrator

• Oversaw the smooth functioning of office operations encompassing filing, correspondence, and customer service. • Established and upheld comprehensive office policies, procedures, and streamlined workflow systems. • Maintained and generated detailed records and reports. • Efficiently managed incoming calls, emails, and inquiries. • Conducted precise data entry, organized filing systems, and managed office supplies procurement.

Amazon | Jun 2019 - Sep 2019

Data Analyst

• Analyzed large datasets using machine learning and computer vision techniques. • Conducted thorough quality checks and root cause analysis. • Adapted swiftly to evolving project specifications, collaborating with data specialists to enhance processes.

Travelodge Hotels Limited | Feb 2018 - Apr 2019

Night Auditor

• Ensured precision in room charge calculations and revenue postings. • Audited cash and credit card transactions, and balanced daily accounts. • Proactively investigated and rectified any financial discrepancies. • Collaborated with all team members to ensure exceptional guest experience from check-in through check-out.

The Peak Garden Restaurant | Oct 2016 - Dec 2017

Assistant Manager

• Led team-wide meetings, assigned tasks and workloads to employees • Supervised and managed a staff of 10-15 employees. • Developed and implemented systems to improve operational efficiency and customer service. • Developed and maintained a budget, ensuring cost control and profitability. • Conducted inventory audits to monitor shrinkage, product availability and generate insights into future purchasing decisions.

XLA General Merchandise | Aug 2012 - Sep 2016

Assistant Manager

• Managed communication and relationships between business, vendors, and customers. • Served as the point of contact and escalation point for the resolution of unresolved problems, complaints, and complex service requests or projects. • Built weekly sales reports and provided insights to leadership on high/mid/low performers, success drivers, and best practices. • Built work schedules, balancing tasks as per the current demand.

Wipro Limited | Feb 2012 - Jul 2012

Billing Associate

• Managed communication and relationship between business, vendors and the customer. • Served as the point of contact and escalation point for the resolution of unresolved problems, complaints, and complex service requests.

TeleTech Philippines | Jun 2011 - Dec 2011

Sales Architect

• Researched and analyzed customers’ needs to provide tailored solutions. • Collaborated with other departments to ensure customer satisfaction and successful completion of sale. • Assisted customers with inquiries or complaints and developed strategies to reduce customer attrition and increase customer retention.

Peak Up Wood Processing | Jan 2007 - Dec 2010

Bookkeeper

• Eliminated discrepancies in finances by expertly documenting expenses, monitoring income, managing deposits and managing statements. • Performed all financial operations for the business, including bank reconciliations, payroll and tax returns. • Prepared monthly forecast reports and performed variance analysis to provide visibility into performance.

My Education

Take a look at my formal education

Anglia Ruskin University
Master of Business Administration - MBA, Business Administration andAnglia Ruskin University
Notre Dame of Dadiangas University

About Me

Phillip Palileo

Finance Analyst in Tech | MBA & Msc Finance | BI & Financial Data Analysis | Unlocking Hidden Business Value Through Data-Driven Insights | Empowering and Inspiring Individuals to Achieve Their Full Potential

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free