SAMUEL OJO
Rivervale
Summary
Business Intelligence Developer with a proven track record in applying data modeling, structuring, and analytics to achieve business objectives. Experienced with leading BI tools such as Power BI and Tableau, and well-versed in cloud environments. Possesses a strong background in accounting, excellent analytical abilities, and is highly organized, self-motivated, and adept at working independently. Excels in adapting to diverse teams and projects, with strong verbal and written communication skills.
Overview
8
8
years of professional experience
Work History
Solution Developer
Kinetic IT
09.2023 - Current
- As a Power Business Intelligence Developer, the role encompasses delivering business solutions, automations, and reports to team members and clients. This involves creating BI dashboards for internal and external users, streamlining internal business processes through automation, developing internal business solutions, and designing and mapping database architectures.
- Tasks included:
- Integration of data from multiple corporate applications and external sources.
- Develop and maintenance of key corporate data models, datasets, dataflows, and solutions.
- Create interactive and visually appealing dashboards and reports to meet business requirements.
- Management of data refresh schedules, ensuring data integrity and availability, while maintaining optimal performance.
- Focus on information security and testing to ensure solutions are secure, fully documented, and up to date, maintaining security models.
- Engage and collaborate with diverse business and IT stakeholders to deliver data and analytic solutions.
- Apply business and commercial acumen, understanding business value drivers to deliver comprehensive and insightful solutions.
- Develop and maintain financial reports and dashboards. This includes balance sheet, statement of profit or Loss, and Statement of cashflow.
- Develop and maintain custom applications using Microsoft Power Apps to meet business needs and requirements.
- Integrate Power Apps with various data sources and services, including SharePoint, SQL Server, and other external APIs.
- Automate business processes by creating workflows and business logic using Power Automate.
Business Intelligence Analyst
Cushman and Wakefield
03.2022 - 08.2023
- Working as a Power Business Intelligence Analyst, delivering business solutions, automations and reporting delivery to team members and clients by creating BI dashboards for internal and external users, automating internal business processes, creating internal business solutions, database architectural design and mapping.
- Tasks included:
- Assess and analyze various data sources to develop reporting dashboards.
- Participate in business analysis activities to gather required reporting and dashboard requirements.
- Translate business requirements into specifications that will be used to implement the and dashboards, potentially from multiple data sources.
- Provide support to ensure the availability and performance of developed reports and dashboards for both external and internal users.
- Transition developed reports and dashboards to the teams and clients.
- Provide training in the use of dashboards where required.
- Plotting out the end goal for reporting and architectural designing how we will reach that goal.
- Establish measurable performance indicators for reporting. Support the Project and Workplace Solutions team providing reporting assistance and direction when required.
- Design and implement technology best practices and guidelines.
- Resolve and debug reporting issues.
- Create innovative solutions to meet business needs.
- Design alternative solutions.
- Keep users informed, engaged and busy within the program reporting.
- Contribute to the development and delivery of communication strategies for the area involved.
Power BI Developer
DMS Accounting Services
03.2019 - 02.2022
- Company Overview: DMS Accounting Services is a medium-sized professional service firm providing high level business and accounting advice.
- As a Business Services Accountant, I work tirelessly to ensure exemplary standards of customer support and legislative compliance.
- KEY RESPONSIBILITIES
- Automation of client’s report via Microsoft Power BI
- Assess and analyze various data sources to develop reporting dashboards.
- End to end Reporting Automation
- Simplifying data compilation using Microsoft PowerApps.
- Automation of workflow using Microsoft Flow.
- Identify data variances and anomalies via data visualization.
- Work with relevant stakeholders to identify opportunities for consistent data capture.
- Engage stakeholders to determine when and the best possible way to receive data for reporting purposes.
- Power BI report optimization and development
- Developing customer centric reports and analysis using other business intelligence tools.
- Drawing out relevant insights and identifying opportunities to meet targets and recommending corrective measures.
Financial Accountant
DMS ASSOCIATE
02.2017 - 03.2019
- Prepare monthly, quarterly, and annual financial statements in compliance with AASB and company policies.
- Maintain general ledger and ensure integrity of financial data.
- Prepare BAS, PAYG, FBT, and other statutory lodgements with the ATO.
- Coordinate with external auditors and support audit processes.
- Reconcile bank accounts, intercompany balances, and key ledger accounts.
- Perform month-end and year-end closing activities.
- Monitor cash flow and support treasury operations.
- Ensure compliance with internal controls and accounting procedures.
- Provide financial insights and variance analysis to senior management.
- Assist in budget preparation, forecasting, and financial planning processes
- Analyzed financial data to identify trends and provided actionable insights for management, leading to improved business performance.
- Reduced month-end closing time by optimizing the reconciliation process for bank and credit card accounts.
- Identified cost-saving opportunities through thorough budget analysis and expense tracking.
Education
Graduate Certificate - Data Engineering
Australian National University
Business Analytics with Python and SQL
RMIT
01.2022
Analyzing and Visualizing Data with Microsoft Power BI
EDX
01.2020
Master - Professional Accounting
University of Canberra
01.2018
Graduate Certificate - Accounting
University of Newcastle
01.2017
Skills
- Business Intelligence Tools
- Power BI
- Automation Tools
- Power Automate, Power Apps, Dataverse
- Languages
- Python, SQL Postgre SQL, DAX, M Langage, Power Query
- IDE
- PyCharm, Jupyter notebook, Microsoft Visual Studio, DAX Studio, Microsoft Fabric
- OS
- Windows
- Business analysis
- API integration
- Requirements gathering
- Performance optimization
Affiliations
- Member of Certified Practicing Accountant (CPA) 2020
- Association of Chartered Accountants Membership 2013
PROFESSIONAL CHARACTERISTICS
- Committed to working within organizational codes of practice and conduct.
- Positive, friendly personality with the aim of creating a welcoming, inclusive environment for all.
- Dedicated to increasing skills and knowledge, accepting feedback and striving to improve.
- High work ethic, with a focus on punctuality, ethical conduct, reliability, and efficiency
- Strong analytical and problem-solving capabilities.
- Ability to research, develop, and implement solutions to issues that arise.
- Highly flexible, with demonstrated ability to adapt to new roles as required.
Timeline
Solution Developer
Kinetic IT
09.2023 - Current
Business Intelligence Analyst
Cushman and Wakefield
03.2022 - 08.2023
Power BI Developer
DMS Accounting Services
03.2019 - 02.2022
Financial Accountant
DMS ASSOCIATE
02.2017 - 03.2019
Business Analytics with Python and SQL
RMIT
Analyzing and Visualizing Data with Microsoft Power BI
EDX
Master - Professional Accounting
University of Canberra
Graduate Certificate - Accounting
University of Newcastle
Graduate Certificate - Data Engineering
Australian National University
Similar Profiles
Jayaprakash Vishwanath HegdeJayaprakash Vishwanath Hegde
ServiceNow Solution Senior Developer/Architectural Engineer at Kinetic ITServiceNow Solution Senior Developer/Architectural Engineer at Kinetic IT
ANTONY PULLINOANTONY PULLINO
Senior Service Desk Technician at Kinetic ITSenior Service Desk Technician at Kinetic IT
Sukhveer Kaur DhaliwalSukhveer Kaur Dhaliwal
IT Service Desk Analyst at Kinetic ITIT Service Desk Analyst at Kinetic IT
Nathan Edward OkleNathan Edward Okle
Caregiver at Family CaregiverCaregiver at Family Caregiver
Will GrayWill Gray
Crew Member at McDonald'sCrew Member at McDonald's