Sergio Filho, AAIA
Retailer’s Revenue Accountant at ESW- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Portuguese Native or bilingual proficiency
-
English Full professional proficiency
Topline Score
Bio
LinkedIn User
Sergio is very dedicated and engaged to the commitments and objectives required by his function. He learns fast and is always open to share his knowledge among colleagues. He is also result oriented. It was a pleasure working with him.
Juliana Galhardo
Sérgio é ótimo profissional, focado e dinâmico.
LinkedIn User
Sergio is very dedicated and engaged to the commitments and objectives required by his function. He learns fast and is always open to share his knowledge among colleagues. He is also result oriented. It was a pleasure working with him.
Juliana Galhardo
Sérgio é ótimo profissional, focado e dinâmico.
LinkedIn User
Sergio is very dedicated and engaged to the commitments and objectives required by his function. He learns fast and is always open to share his knowledge among colleagues. He is also result oriented. It was a pleasure working with him.
Juliana Galhardo
Sérgio é ótimo profissional, focado e dinâmico.
LinkedIn User
Sergio is very dedicated and engaged to the commitments and objectives required by his function. He learns fast and is always open to share his knowledge among colleagues. He is also result oriented. It was a pleasure working with him.
Juliana Galhardo
Sérgio é ótimo profissional, focado e dinâmico.
Credentials
-
Excel Business Intelligence Power Query
LinkedInJan, 2021- Oct, 2024 -
Excel Business Intelligence: Data Modeling 101
LinkedInJan, 2021- Oct, 2024 -
Excel Business Intelligence: Power Pivot and DAX
LinkedInJan, 2021- Oct, 2024 -
Excel: Power Pivot for Beginners
LinkedInJan, 2021- Oct, 2024 -
Learning Power BI Desktop
LinkedInJan, 2021- Oct, 2024 -
Learning Power BI Service for Consumers
LinkedInJan, 2021- Oct, 2024 -
Power BI Data Methods
LinkedInJan, 2021- Oct, 2024 -
Power BI Data Modeling with DAX
LinkedInJan, 2021- Oct, 2024 -
Power BI Essential Training
LinkedInJan, 2021- Oct, 2024 -
Microsoft Power BI - Power BI Week
Aprenda Power BI - Leonardo KarpinskiNov, 2020- Oct, 2024 -
Excel: Introduction to Macros and VBA
LinkedInOct, 2020- Oct, 2024 -
SQL Essential Training (2018)
LinkedInJun, 2020- Oct, 2024 -
Analyzing and Visualizing Data with Microsoft Power BI
AccentureApr, 2020- Oct, 2024 -
International Accountant/Certified Public Accountant
Association of International Accountants (AIA)Nov, 2019- Oct, 2024 -
Certified Public Accountant - Chartered Accountants Brazil
Conselho Federal de Contabilidade (CFC)Oct, 2019- Oct, 2024 -
What is Data Science?
IBMJul, 2019- Oct, 2024 -
IELTS - Overall Score 6.0
IELTS OfficialJan, 2019- Oct, 2024
Experience
-
ESW
-
Ireland
-
Internet Publishing
-
200 - 300 Employee
-
Retailer’s Revenue Accountant
-
Dec 2022 - Present
• Ownership of a portfolio of retailers from a revenue and margin perspective with a deep understanding of the retailer and revenue / margin streams. • Ensuring open communication with retailer, including weekly finance to finance meetings, with a key objective that all open issues are communicated and dealt with in a timely manner. • Developing relationship with the Commercial finance and Taxation teams that forms a key part of understanding the retailer mechanics. • Weekly reporting and financial reconciliation with these retailers. • Balance sheet reconciliations and investigations. • Analysis and commentary on customer performance on a monthly basis. • Monthly reviews of Balance Sheet and Income Statement including commentary against budget and forecast P&L reporting on a monthly basis to tight deadlines. • Business partnering with cross-functional stakeholders to implement new and efficient processes and effective controls. • Participating in process improvement initiatives and implementation of best practices to ensure the finance team is consistently pushing the boundaries in terms of efficiency and accuracy. • Ensuring the Revenue Manager is kept up to date on any open issues including proposed resolution and target timeline. • Key business partner to the finance transformation team. • Key point of contact to both internal and external stakeholders for all finance related information on customer portfolio.
-
-
-
ION
-
United Kingdom
-
Advertising Services
-
1 - 100 Employee
-
Senior Revenue Accountant
-
Dec 2020 - Dec 2022
• Responsible for revenue management including closing and adjusting month-end. • Prepared the monthly revenue report with supporting explanations and calculations for the variance. • Reviewed inputs/data from order processors (off-shore team, working with people based in different countries), working cross-functionally with internal departments to resolve and clarify potential contractual issues. • Revenue contract review, performing reconciliations of contracts, and revenue recognition. • Forecasting revenue recognition. • Reviewed, prepared, and posted of Journals in NetSuite, deferred revenue reconciliations, and month-end commentary. • Ensured revenue recognition is in accordance with company policy and the appropriate accounting treatment under IFRS 15. • Assisted in implementing new controls environment and ongoing monitoring of these controls. • Worked across a multitude of teams (billing, credit control, and legal) in assisting with annual invoicing projects, liaising with the billing and the commercial team regarding unbilled revenue balances – invoice schedule. • Ad-hoc revenue request for senior management / other stakeholders. • Assisted in year-end audit, including reconciliations, support documentation, and communication with external auditors.
-
-
-
Accenture Song
-
United States
-
Marketing Services
-
700 & Above Employee
-
Senior Revenue Analyst for Rothco
-
Oct 2019 - Oct 2020
• Managed all Revenue aspects for assigned clients in the Rothco Group.• Ensured revenue recognition is in accordance with company policy and the appropriate accounting treatment under IFRS 15/ASC606.• Assisted in collecting and appraising the near-term revenue forecast for the same assigned clients.• Achieved monthly, quarterly, and yearly targets as a result of timely reconciliations, billing, and communication with the client team (Account Management).• Provided training for new joiners in the company in financial aspects (Account Management and Revenue Team).• Prepared, documented, and kept processes up to date for the accounting role.• Assisted with financial audits including reconciliations, support documentation, and communication with external auditors• Supported and participated in revenue accounting as well as order to cash cycle-related projects.• Proactive Key-User: Paprika and Workbook implementation.
-
-
Revenue Analyst for Rothco
-
Nov 2018 - Sep 2019
• Managed all Revenue aspects for assigned clients in the Rothco Group.• Raised all invoices for assigned clients, ensuring timings and cash flow obligations were fulfilled. • Achieved monthly, quarterly, and yearly targets as a result of timely reconciliations, billing, and communication with the client team (Account Management).• Assisted in collecting and appraising the near-term revenue forecast for the same assigned clients.• Maintained the minimum number of Jobs (Projects) at active status.• Overviewed assigned client Debt level & payment terms. • Developed and presented monthly status reports to the Account and Project Management team, regarding revenue recognition, earned value analysis, forecasting, and contract status utilizing MS Excel.• Developed and improved processes to drive efficiency regarding invoicing timelines and revenue recognition.• Compiled job costing for projects after completion.• Interacted with firm leadership to review the financial status of selected projects.• Maintained all financial records including budgets, forecasts, costs to complete; analyzed, and reported variances.
-
-
-
BKRM
-
Retail Apparel and Fashion
-
1 - 100 Employee
-
Trainee Accountant
-
Aug 2018 - Nov 2018
• Provided weekly and Monthly Payroll, bookkeeping, and general administrative duties using Relate, ROS online/offline, excel, or other systems to bring clients bookkeeping up to date and reconciling creditors. • Prepared and filed VAT returns. • Created worksheets in excel for corporate tax, VAT, and Income Tax. Furthermore, reconciled and ensured the accuracy of the bank and control accounts of the clients and generated and posted company accounts to an account’s software package. • Planned and performed audit assignments and compiled audit files along with results for review by senior managers/partners. • Prepared sole trader and company accounts. Dealt with Revenue and client queries. • Prepared monthly Financial Accounts such as Bank Reconciliation, Accounts Receivable, Accounts Payable, and Payroll. • Prepared and generated Financial Statements on Relate Accounts. • Managed the accounts of the clients - Prepared combined quarterly and year-end financial statements for multiple entities. • Calculated salaries, rate changes, retroactive adjustments overtime, bonuses, vacations, terminations, & garnishments. • Entered financial data into the company accounting database to be verified and reconciled (bookkeeping).
-
-
-
Galway Cultural Institute
-
Ireland
-
Education Administration Programs
-
1 - 100 Employee
-
Part-Time English Student
-
Mar 2018 - Aug 2018
• Career break to improve my English skills in an Irish English school for 6 months before starting my international career • Career break to improve my English skills in an Irish English school for 6 months before starting my international career
-
-
-
Valeo
-
France
-
Motor Vehicle Parts Manufacturing
-
700 & Above Employee
-
Cost Accountant
-
Aug 2015 - Feb 2018
• Developed industrial costs on actual, forecast, budget, and business plan. • Reviewed Monthly Standard cost (standard costs released every month).• Provided hourly rate calculation and inventories controlling (scrap, adjustments, throughput time, stock in transit, cycle and general inventory, slow-moving, and others).• Analyzed and checked accounting entries and responsible for the requests of monthly journal entry reclassifications.• Provided reconciliation of fixed assets and depreciation account.• Fixed Asset reporting and administration (CAPEX). • Attended internal (local and business group) and external audits.• Provided PL cost change information within established deadlines. Calculated cost and determined Sales Price vs. Purchasing Price.• Performed variance analysis between actual and standard costs; also forecasted analysis reporting for validation of monthly/quarterly cost, month-end close.• Analyzed cost and confirmed BOM accuracy and consistency.• Ensured standard cost accuracy and completion by performing root cause analysis, item master, bill of materials, and labor routing audits.• Assisted the Controller in budget revision for various projects each year. Provided ad-hoc reports and analysis on various projects.• Supervised and reconciled 3 cycle counts per month for each business plant and 3 annual inventories per semester.• Developed and wrote a manual for inventory procedures covering operational processes for returns, organization, and storage of inventory. Implementation reduced shrinkage by half.• Implemented and revised internal controls, audits, and procedures, in different areas like Quality, Industrial, AR and AP, Inventory department as part of Business Audit Group.• Proactive Key-User: Controlling Module – SAP.
-
-
Trainee Accountant
-
Sep 2014 - Aug 2015
• Managed and analyzed administrative expenses and investments of R&D.• Developed fixed assets on actual, forecast, budget, and business plan.• Provided tooling control for third parties, reconciliation of fixed assets, and depreciation accounts.• Managed and controlled millions in company assets. Duties included: reconciling fixed asset sub-ledger to the general ledger on a monthly basis, recorded and accounted for disposals, transferred, and adjusted any assets.• Recognized for successfully analyzing newly acquired assets and capital expenditures (CAPEX) for the Valeo acquisition to merge financial records and reporting.• Developed a reporting system for project managers and plant managers ensuring that all asset additions, transfers, and retirements activity in the plant were accounted for.• Monitored capital spending against approved budgets and purchase orders.• Provided analysis on monthly variances, forecasting, and budgeting for cost center budgets.• Coordinated and conducted a companywide internal fixed asset audit, provided recommendations for proper handling of obsolete assets resulting in a more accurate picture of the effect fixed assets were having on the financials.• Implemented process and policy improvements relating to the fixed asset process.• Software used: ERP: SAP – FI e CO.
-
-
-
GE
-
Brazil
-
Engineering Services
-
1 - 100 Employee
-
Trainee Accountant
-
Nov 2013 - Jun 2014
• Reconciled Cash in Transit and Fixed Asset account. • Created and started depreciation of Fixed Assets, provided fixed Asset reporting and administration. • Managed purchase requisition to fixed assets, reconciled intercompany suppliers. • Performed fixed asset accounting transactions and period-end close activities. • Managed the physical inventory process and identified improvements that increased efficiencies and alignment with financial ledgers. • Responsible for depreciation analysis, asset transfers, disposal, and new entries, in addition to onsite inventory control. • Recorded the cost of acquiring new fixed assets, tracked and recorded the disposition of fixed assets, documented fixed asset acquisitions, and transfers in the accounting system. • Software used: ERP Oracle, Finance, and Controlling - SAP, Mastersaf (Brazil Legal Tax).
-
-
-
Artivinco
-
Brazil
-
Packaging and Containers Manufacturing
-
200 - 300 Employee
-
Tax Assistant
-
Feb 2011 - Aug 2011
• Provided reliable tax advice to upper management; • Organized and recorded tax preparation documents throughout the year; • Supervised bookkeeping in preparation for internal and external auditing; • Responsible for maintaining accurate records according to up-to-date tax legislation; • Reviewed data input and totals on tax forms to ensure no errors in arithmetic; • Provided tax consulting and practical solution to maximize the tax benefits; • Organized all physical and electronic archiving of documentation;
-
-
Education
-
2020 - 2022
Universidade de São Paulo
Master of Business Administration - MBA, Data Science and Analytics -
2019 - 2019
Association of International Accountants (AIA)
Professional Qualification, Accounting and Finance -
2012 - 2015
Pontifícia Universidade Católica de Campinas
Bachelor's degree, Accounting
Community
