Wallace D.

Back-end and Systems Engineer

Business Specialist (temporary staff)
8/1/2023 - Present

Developed and improved business data models using Power Query (M Language) and SAP Hana. Analyzed data from SAP partners, creating detailed reports and dashboards using Power Pivot (DAX Language). Automated various processes employing VBA and HTML. Reported findings directly to management and directors while contributing to the definition of business rules. Operated in an English-speaking environment, participating in meetings and generating reports. Demonstrated strong skills in data analysis, report generation, strategic planning, and proficient use of Microsoft Excel, Power Query, and Power Pivot.

Financial Analyst
5/1/2021 - Present

Developed predictive models for mitigating financial risk exposure, including fraud and operational risks, through advanced data extraction techniques and implementation. Utilized regression analysis, clustering methodologies, statistical methods, and data visualization to enhance predictive accuracy. Manipulated large and tabular datasets to analyze operational indicators and assess profitability and GMV (Gross Merchandise Value). Managed payment releases and blocks, provided financial insights for legal provisioning, and analyzed financial losses to recommend business recovery actions. Demonstrated expertise in creating dashboards and crafting SQL queries for comprehensive data analysis. Efficiently transformed data to track OKRs and KPIs, continuously improving processes with tools such as Excel and Power BI. Leveraged Google Cloud Platform services including Big Query and Google Cloud Storage for data handling and analysis. Developed and established detailed rules and matrices for financial and operational risk analysis, ensuring alignment with internal policies and enhancing seller training. Collaborated extensively with cross-functional teams like Logistics, Sales, IT, Legal, Credit, Fraud, Items, and Customer Service to improve processes and ensure seamless operations.

Skills: Data Analysis, Financial Planning, Dashboards, Strategic Planning, Big Data, Microsoft Excel, SQL

Sr FP&A Analyst
10/1/2019 - 4/1/2021

Developed proficiency in preparing and monitoring departmental budgets, specifically Capex and Opex, using Zero-Based Budgeting techniques. Utilized SAP modules FI, CO, and MM for financial and material management tasks. Created comprehensive financial, operational, and inventory reports, and specialized in producing managerial reports such as Gain and Energy Incorporation Reports and Billing Reports (KPIs). Advanced skills in managing material purchases and tracking their logistics, conducting thorough economic and financial feasibility studies for projects. Leveraged Excel and Power BI to create detailed dashboards and enhance data visualization capabilities. Demonstrated expertise in financial planning, controlling, and report generation.

FP&A Analyst
1/1/2017 - 1/1/2018

Monitored and analyzed the cost structure of asset platforms, comparing actual versus budgeted expenditures, and carried out comprehensive monitoring and revision. Tracked key financial and production KPIs, including CAPEX, OPEX, barrels produced, oil losses, and accident rates. Implemented the PDCA cycle to drive process improvement and mitigate operational costs. Presented key performance indicators to assist the management team in strategic decision-making. Developed skills in data analysis, financial planning, dashboard creation, strategic planning, Microsoft Excel, management, and controlling.

Revenue Management Analyst - Billing
7/1/2015 - 9/1/2016

Analyzed projected revenues in shopping malls by comparing actual figures against budgeted values and monitored the Company's Net Delinquency along with its regional breakdown. Developed and implemented debt renegotiation campaigns for aging debts starting from one month onwards, including specific campaigns for Provision for Doubtful Debts (PDD). Successfully negotiated debt settlements with Key Account store owners through direct meetings, managing various elements such as due date extensions, financial discounts, and interest rates. Oversaw judicial and extrajudicial debt collection processes, including contract management and debt confession preparation, as well as drafting and finalizing court agreements. Created comprehensive managerial reports and key performance indicators (KPIs) for the department using advanced functionalities in Microsoft Excel and PowerPoint. Collaborated effectively with Legal, Sales, Marketing, and Operations teams within shopping malls to ensure cohesive strategies and operations. Developed strategic planning and financial planning skills, with a strong proficiency in creating insightful dashboards.

Treasury Intern
10/1/2012 - 10/1/2014

Analyzed contracts and credit inquiries, utilizing SCORE for approval and payment release, and formalized contracts for approved agreements. Processed contract payments through the IBM Host on Demand System, ensuring accuracy and timeliness. Monitored the flow of released payments, ensuring smooth financial operations. Created productivity, indicator, and goal spreadsheets using Microsoft Excel, facilitating performance tracking and goal achievement. Supported the Commercial Manager and Commercial Operators in the Rio de Janeiro branch, contributing to team efficiency. Recorded checks and issued invoices, maintaining financial records. Provided customer service to both internal and external stakeholders, ensuring high satisfaction levels. Developed expertise in data and financial analysis within the role.

Business Administration at Rio de Janeiro State University
2011 - 2016

Data Science at Fluminense Federal University
2021 - 2024

Finance, Controllership, Audit and Compliance at Getulio Vargas Foundation
2018 - 2020