Karl Friedriech Stahlke

Karl Friedriech Stahlke

$20/hr
Finance Professional with strong habilities in Excel, VBA, Power BI and system integration
Reply rate:
-
Availability:
Part-time (20 hrs/wk)
Age:
55 years old
Location:
Campinas, São Paulo, Brazil
Experience:
27 years
KARL FRIEDRIECH STAHLKE LinkedIn: http://www.linkedin.com/in/karlstahlke FINANCIAL PLANNING - CONTROLLERSHIP - CORPORATE FINANCE QUALIFICATIONS: Career developed in the Finance Area, with 15 years' experience in managing Accounting, Tax, Accounts Payable, Accounts Receivable, Treasury, Systems and Human Resources departments. Strong background in financial and budget planning, risk management, modeling of financial and statistical scenarios, accounting closing, cash flow and Income Statement. Experience with FP&A, Business Intelligence, and practice with USGAAP, IFRS and BRGAAP. Experience with Big Four audit firms. Experience with ERP system implementation (Protheus TOTVS) and development of financial controls using advanced MS Excel; VBA tools and Power BI. Management of multidisciplinary teams with a focus on people development through training and positive motivation. Systems and tools: advanced Excel; VBA for Excel; Power BI; advanced Access; complete Microsoft365; systems integration. International working experiences in the USA (2 years during MBA-BYU and 10 one-week international conferences, by Embraer) and China (one week in Peking and Tianjin). EDUCATION: MBA full time - Sep 2003 - Apr 2005 Brigham Young University - BYU, Marriott School, Provo, UT, USA Mechanical Engineering - Jan 1988 - Dec 1995 São Paulo University (USP), POLI, São Paulo, SP, Brazil LANGUAGES: Fluent English; Basic Spanish; Native Portuguese. PROFESSIONAL EXPERIENCE: RESTAURANTE E CHURRASCARIA JANGADA – Mogi-Guaçu, SP - Aug/24 - current Family-owned company, fast growing restaurant chain specialized in sea food – annual revenue BRL 114MM. • Finance Manager & Controller – Reports to CFO/Founding Partner • Responsible for managing the Finance, Accounting, Tax, Treasury and Systems departments. • Creation and implementation of Company policies to align Finance & Tax requirements to other departments like Supply Chain & Purchasing, Facilities, Marketing, Factory, HR, among others. • Development of accounting reclassification suit to create managerial Income Statement and Cash Flow Statement, using Power BI (language “DAX”) & Power Query (language “M”) integrated with Protheus (TOTVS). • Served as boards’ delegate to interview, select and hire other Supervisors and Coordinators (Facilities, Supply Chain, Customer Services, among others). Main results: • Selected and implemented a new bank manager system (FINNET) that allows Treasury to work in a centralized way, using one single platform, instead of accessing numerous banks and bank accounts. • Brought new options of POS (point of sales) and drove the implementation. • Selected new Credit Card Company to replace the old one with a 12% decrease in rates and Smart POS rental. ORION S.A. - São José dos Campos, SP – Mar/24 - Jun/24 Privately held company in the rubber high voltage IPE (individual protection equipment) • BPO - Finance Manager - Reported to CEO • Led the Finance department: Accounts Payable & Receivable and Treasury. Main results: • Cultural and structural changes to prevent cash flow mismatches. • Created Managerial P&L in Power BI. • Implanted new payments’ calendar and concentration of suppliers’ payments twice a week • Implemented the first Budget (Zero Based Budget) process. TERAPÊUTICA FARMÁCIA DE MANIPULAÇÃO - São José dos Campos, SP, BR - Aug/23 - Jan/24 Family-owned company in the compounding pharmacy business • BPO - Finance Director - Reported to CEO • Led the Finance and HR departments, encompassing the following areas: Accounts Payable & Receivable, Treasury, Tax and Accounting, Payroll & Budgeting. • Reported to CEO and Board every two weeks presenting the Income statement and Cash Flow. Main results: • Prepared and oversaw the monthly Financial Statements. • Automated the Financial Statements preparation and the HR processes. ELEVADORES ATLAS SCHINDLER - Londrina, PR, BR - May/21 - Dec/22 Multinational Swiss Company in the Elevators & Escalators sector • Finance Manager (Shared Services Center with 125 employees) - Reported to General Manager • Responsible for Finance in Brazil and for managing five supervisors in the following areas: Accounts Payable, Accounts Receivable, Treasury, Tax and Accounting. • Management of the annual budget and six-month forecast, reporting monthly to the Board of Directors and Head Office. • Financial management of projects and investments in Brazil. • Prepared and sent management report with business indicators for Brazil to Head Office. Main results: • Reduced processing time for tax reconciliations, as well as the regularization of 12 months of arrears, through an advanced MS Excel formulas solution. • Development of a centralized spreadsheet with advanced formulas and intelligence to receive information directly from the SAP system for the projects’ report, enabling the assertive management of more than 40 projects in Brazil, reducing the time taken to extract information from 1 day to 30 minutes. • Supervised the creation of a Power BI solution to read data from the e-mail system, making it possible to categorize information on customer service. With the management information in hand, the company was able to measure times, results and, above all, identify the main needs of customers to focus on the solution and add value to the business. • Integration and engagement of the finance teams (Accounts Payable, Accounts Receivable, Treasury, Tax and Accounting) through weekly 30-minute meetings with the Depts. Supervisors to deal with interdepartmental issues and weekly 30-minute individual meetings with each Supervisor to deal with specific issues. ABIJCSUD - São Paulo, SP - Apr/20 - May/21 Multinational Non-profit Company with 2,600 business units in Brazil – Annual Operational Budget – BRL 80MM • Finance and Records Manager - Reported to Brazil Controller • Financial and budget management for 2,600 business units. • Responsible for special audits and supervised business units annual and semiannual auditing. • Participated actively in Auditing, Expenses Analysis and Communication Internal Committees. • Supervised the creations and programming of business units’ financial analysis and automatic e-mailing BOTs. • Guardian of confidential information accesses, according to LGPD (Data Protection General Law). Main results: • Managed the training of 2,600 units on the use of company’s systems, other finance related matters, and statistical record keeping. These actions helped to reduce the number of calls to the financial call center. • Created a risks map based on the top 5 main financial problems and supervised the implementation of artificial intelligence to evaluate each business unit and to send automatic communications to each of the 2,600 units, minimizing analysis time and avoiding waste of resources at each unit. RESTAURANTE E CHURRASCARIA JANGADA - Campinas, SP - Feb/19 - Mar/20 Family-owned company, fast growing restaurant chain specialized in sea food – annual revenue BRL 70MM. • Controller – Reported to CFO/Founding Partner • Responsible for managing the Finance, Accounting, Tax, Treasury and Systems departments. • Definition of procedures to ensure monthly accounting closure. • Restructured the Finance Department and the team, which lacked the necessary qualifications for the job. • Creation of a financial system (Cash Flow and Income Statement) using advanced MS Excel and VBA tools. • Development of a system in MS Excel for calculating daily and monthly commercial targets, monthly and annual awards. Main results: • Implemented a report with advanced Excel formulas, making it possible to parameterize commercial targets associated with the company's financial targets and budget. Systematization made it easier to see the figures and contributed to the effective alignment of commercial bonus planning. • Led the Definition and implementation of the new Protheus ERP system (TOTVS), promoting agility in banking transactions, tax bookkeeping and the veracity and accuracy of management information. ALOHA LIFE INTERNATIONAL LTDA - Campinas, SP - Feb/18 - Feb/19 Start-up – Sforza Group – family-owned Network Marketing company – annual revenue BRL 72MM. • Administrative & Finance Director - Reported to CEO • Head of the Finance, Human Resources and Physical Infrastructure departments. • Responsible for implementing the Business Plan, ZBB (Zero Based Budgeting) and restructuring the Finance Department. • Implementation of HR routines for hiring and firing, contributing to the organizational climate. Main results: • Managed the creation of a Network Marketing Financial Management System, using the knowledge of market specialists to define the system's parameters, to promote assertiveness in the network's associates’ reward payments. URBAN LASER SERVIÇOS ESTÉTICOS LTDA - Campinas, SP - Jun/17 - Jan/18 Small corporation owning 13 commercial points from Espaço Laser Franchising – annual revenue BRL 26MM. • Finance Director & Controller – Reported to CFO/Founding Partner • Responsible for Accounts Payable, Accounts Receivable, Cash Flow, Financial Planning, Bank Relations, Investments, Payroll Administration, Company Administration and Reports to the Board of Directors. • Responsible for gathering and evaluating information for Due Diligence and Audits. Main results: • Created a system using Excel and VBA to extract information from the LINX system and calculate all the figures used to support the business. • Prepared the group's 13 franchises to be acquired by the franchisor, organizing financial data, interfacing with accounting and external auditing to adjust the trial balance and cash flow to have auditable financial statements. MUNDO VERDE FRANQUEADORA – GRUPO SFORZA - Campinas, SP - Sep/14 - Jul/16 Family-owned Company acquired by Carlos Wizard Martins. Food retail market - annual revenue BRL 66MM • Finance Director /CFO - Reported to CEO/Founding Partner • Responsible for the post-acquisition transition, carrying out short- to long-term strategic and budget planning and creating and maintaining company and IT policies. • Financial management of the franchisor and distributor. • Led teams in the following areas: Accounts Payable, Accounts Receivable, Treasury, Financial Planning, Budgeting and Accounting, IT, BI and Market Intelligence. • Presentation of monthly, quarterly, and annual results to the company's board, and interaction with Big Four audit firms. Main results: • Creation of the company's annual budgeting process (Zero Based Budgeting) promoting a 30% reduction in spending in the first year of implementation and 15% in the following year. • Implementation of standards and metrics for measuring departmental targets as well as those of franchised stores, facilitating the budget monitoring process. PEARSON - Multi Brasil Franchising - Campinas, SP - Feb/10 - Apr/14 Family-owned Company, acquired in 2014 by the British PEARSON, the global leader in education. With annual income of R$ 370 MM, created the largest language education franchising net: Wizard. Grupo Multi was also the owner of brands like Microlins, SOS and Yázigi. • Controller & Finance Planning Director - Reported to CFO/Founding Partner • Managed short- & long-term Planning, Budgeting, Investor Relationship, Risk Management, Internal Auditing, Processes & Systems implementation, Company Policies creation & maintenance. • Managed financial information gathering and organization for management and decision-making purposes. • Prepared the company for new businesses acquisitions. • Recommended actions to high management related to expansion of the franchisee network, to students' enrollment maximization at the franchisee level and to new strategies and approaches to "sell in" and "sell out". • Led a team of qualified professionals in gathering data from inside the company, from the market and from competitors and transforming it into knowledge and applied intelligence (B.I.). • Spread the best practices for conducting projects among Directors and Managers of the company. Main results: • Financial restructuring of the company, contributing to business expansion and the future sale of the business after 3 years, valued at 8.5 times EBITDA. • Created the company's first parameterized and measurable budget, with a 35% reduction in G&A in the first year. • Promoted the systemic integration of 54 CNPJs, unifying 5 different ERPs into one, and supervised the creation and maintenance of an Intelligence and Finance database, to support all strategic analysis. • Restructured the following back-office departments: Accounting, Accounts Payable and Receivable, Treasury, IT, Legal, Franchising Contracts, Government Relations, and Facilities, bringing fastest response to shareholders' demands, more agility and efficacy in supporting customers. • Created the Internal Controls area and built the first internal policies, and processes and their controls. • Created the Projects Dept. with the following main strategic projects developed: Branding and Repositioning, Digital conversion of Teaching Material, CRM implantation, among others. • Supervised statistical analysis in market and competition research and created a calculation process to identify consumption potentials and brand penetration, for each Brazilian city, resulting in an identification and mapping of 150 business points for expansion in Brazil and other 30 points in Colombia. EMBRAER - São José dos Campos, SP - Aug/05 - Feb/10 Multinational Brazilian Company • Senior Financial Risks & Internal Controls Analyst - Reported to Financial Planning Manager • Improved the financial risks calculation process for aircraft insurance, from 20 minutes to 20 seconds, turning the process 600% faster and allowing multiple scenarios creation that were not done due to time restrictions. • Managed U$ 300 MM of Embraer's assets as self-insurance for a US$ 3 Bi financial risk portfolio, for 3.5 years. • Established investment limits for the companies' U$ 2 Bi cash, based on market indicators for bank and companies' solvencies (Bloomberg, MOODY'S, S&P, FITCH, etc.). • Actively participated as editor and idealizer of customer credit and cash investment policies. • Supported Sales by minimizing the mismatch between price indexes, protecting the Gross Margins; also, by evaluating buyers' risks and risks of future residual values of aircraft. • Led a Processes' Automation Project for the Finance Department, and its integration with SAP; performed the scope definition and all phases until the contracting of IT support. • Participated actively in 12 one-week congresses in the USA related to Aircraft Financial Valuation. LDS PRINTING DIVISION - Salt Lake City, UT, USA – May/04 - Dec/04 Multinational Non-profit Company • Trainee - Reported to Controller • Implementation of budgeting software (PROPHIX) based on OLAP CUBE technology. • Implementation of Activity Based Costing (ABC) of products sold. • Creation of financial reports and support for the Controller's Office and Production Managers. • Carrying out financial analysis to assess the depreciation of production machinery.
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.