Kārlis Kronbergs

Key Responsibilities

• Preparation of regular and ad-hoc financial and management reports for senior management, business units, and the parent company.
• Preparation of annual budgets, forecasts, and variance analysis (Budget vs. Actual, Forecast vs. Actual), including recommendations for cost optimization.
• Monitoring and controlling OPEX/CAPEX, accrual calculations, commission calculations, and participation in the monthly financial closing process.
• Financial analysis, profitability analysis, and development of Business Cases and financial models to support business decision-making.
• Preparation of management presentations on financial performance, budgets, forecasts, and strategic initiatives.
• Development and improvement of KPI reporting, financial reporting processes, and data quality.
• Continuous process improvement, reporting automation, and preparation of process documentation and work instructions.
• Delivery of ad-hoc financial analyses, data preparation, and analytical support for business units and management.

Tools & Technologies

• Advanced Microsoft Excel (financial models, reporting automation, and data analysis).
• QlikView report development, maintenance, and enhancement.
• SQL and DBeaver for data extraction, transformation, and analysis.
• Business Objects for data retrieval from internal database.
• Data extraction and reporting from Horizon and D-Nav accounting systems.
• Microsoft PowerPoint for executive management and other presentations.
• Working knowledge of Power BI reports and dashboards, including data visualisation, data model analysis, and relationship management.
• Exposure to R and WPS scripts, primarily focused on running and understanding existing code.

Key Responsibilities

• Preparation and maintenance of daily, weekly, monthly, and ad-hoc sales, financial, and management reports.
• Data validation, reconciliation, and correction to ensure reporting accuracy and consistency.
• Participation in monthly, quarterly, and annual financial closing processes.
• Preparation of sales budgets, quarterly forecasts, and sales performance analysis in cooperation with Sales Management.
• Calculation and reconciliation of customer turnover and logistics bonuses, reserves, and monthly MIX effect analysis.
• Maintenance of sales prices, product assortment, and master data in ERP systems.
• Data extraction, processing, analysis, and interpretation to support business decisions.
• Development of Power BI dashboards and support for reporting improvements across departments.

Tools & Technologies

• Advanced Microsoft Excel (reporting, data analysis, PivotTables, formulas, and Business Warehouse Add-in).
• SAP ERP (data maintenance, pricing, sales planning, and accounting data processing).
• SAP Business Warehouse (BW) for reporting and data extraction.
• Microsoft Power BI for dashboard development and data visualisation.
• Directo, Tildes Jumis, and Zalktis accounting systems for data extraction and reporting.

• Performed audit procedures on balance sheet and profit & loss accounts based on identified audit risks.
• Tested accounting transactions and account balances using sampling techniques and supporting documentation.
• Collaborated with client finance teams to obtain requested documentation and information.
• Participated in inventory observations and cash counts, documenting findings and resolving discrepancies.
• Prepared audit working papers in accordance with audit methodology and documentation standards.
• Reviewed general ledger transactions and verified supporting evidence.
• Confirmed accounts receivable, accounts payable, bank balances, and legal confirmations.
• Assisted in preparing audit reports and deliverables for senior auditors and managers.

• Maintained and updated customer databases, ensuring accuracy and completeness of client information in Excel.
• Processed and allocated incoming payments to the appropriate customer accounts.
• Monitored and maintained key performance indicators (KPIs) and prepared regular management reports.
• Prepared ad-hoc reports and data analyses in various formats to support business needs.
• Prepared and issued monthly invoices to clients.
• Prepared and submitted information regarding overdue loan accounts to the Credit Information Bureau.