Andrzej Głowiński Email & Phone Number

Kąty Wrocławskie, Woj. Dolnośląskie, Polska

- Design and development of Power BI dashboards, reports and analyses- Design and development of Excel autometed solutions using Power Query and VBA- Data sourcing and analysis for imrproving the day-to-day operations of the procurement and manufacturing teams- Adminitration over analysis tools and systems used in global procurement and manufacturing of rigs and spare parts- Writing Python and VB scripts for data management and automation of processes- Providing live/zoom trainings and support on Excel, Oracle BI reporting, Qlikview

Katy Wroclawskie

- Designing and developing custom analyses, reports and dashboards for the team and for the management- Introducing automation solutions to the SSC (MS Office, UiPath)- Processes reviews, standardization, and optimization- Design and development of :––– Cash Flow reporting and forecasting templates for the EMEA region (Excel/VBA)––– Oracle bank statements reconciliation automation for the region (Power Query/UiPath)––– Automated GL accounts reconciliation system within the SCC (Excel/Power BI)––– Automated AP and AR invoices controlling reports and dashboards (Excel/Power BI/VBA)––– Automated, detailed GL reports and analyses (Excel/Power BI)––– VBA Excel templates for transforming old Oracle txt reports into usable, tabular workbook formats––– VBA app working with a USB barcode scanner for quickening and improvment of the yearly warehouse inventory count––– Template for recording and tracking audit-related requests with automated attaching and sorting of the required documents and messages ––– And multiple other finance reports, calculations, templates, dashboards etc., either planned or ad hoc––– Various Power Point templates for the SSC- Advanced Excel and MS Office (with Power Query and VBA)/Oracle EBS/Oracle BI Reporting support and training for the SSC- Preparation and organization of training courses in Excel, Power Query, and VBA locally and for other branches from the EMEA region (most recently, a 10 hours online Excel training course in English for 25 participants from 6 different countries)

SPECIAL PROJECTS```````````````````````````````````````Automation- EMEA Cash Flow forecasting automated multi-level analysis creation- Development of automatic AP/AR Team KPI dashboard- Standardized automatic payroll, cash, and advances reconciliation creation- Automation of month-end closing intercompany processes- Automatic sales reports creation: revenue and orders backlog analyses- Creation of standardized automatic petty cash register for the African region- Development of automatic timeline and scheduling tool for project managers- Automatic email reminders distribution system creation for the SSC- BI platforms (Oracle, QlikView) reports creation, scheduling, distributionOther- Intern and staff accountants training- Training sessions, for other departments, of:* Excel* Power Query & Power Pivot* VBA* UiPath (RPA development tool)* QlikView```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````GENERAL LEDGER```````````````````````````````````````- Intercompany AP/AR and loan reconciliation- Intercompany settlements accounting and reconciliation- Month-end and Year-end intercompany processes coordination- Employees/vendors advances reconciliation- General ledger journal entries- Internal and external audits support- Ad hoc analyses for other departments- Corporate reporting```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````CASH MANAGEMENT```````````````````````````````````````- Automated Team KPI creation and reporting- Cash Flow forecasting for the EMEA region- Cash accounts reconciliation- Banks communication```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

GENERAL LEDGER```````````````````````````````````````- Intercompany AP/AR and loan reconciliation- Intercompany settlements accounting and reconciliation- Month-end and Year-end intercompany processes coordination- Employees/vendors advances reconciliation- General ledger journal entries- Internal and external audits support- Ad hoc analyses for other departments- Corporate reporting```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````CASH MANAGEMENT```````````````````````````````````````- Automated Team KPI creation and reporting- Cash Flow forecasting for the EMEA region- Cash accounts reconciliation- Banks communication```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

CASH MANAGEMENT```````````````````````````````````````- Automated Team KPI creation and reporting- Cash Flow forecasting for the EMEA region- Intercompany bank statements reporting automation- Cash accounts reconciliation- Employees/vendors advances reconciliation- General ledger journal entries- Internal and external audits support- Ad hoc analyses for other departments- Corporate reporting- Banks communication```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````ACCOUNTS RECEIVABLE```````````````````````````````````````- Cash receipts accounting- Customer accounts reconciliation- AR accounts reconciliation```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

CASH MANAGEMENT```````````````````````````````````````- Cash Flow forecasting for the EMEA region- Cash accounts reconciliation- Employees/vendors advances reconciliation- General ledger journal entries- Corporate reporting- Banks communication- Bank statements archiving```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````ACCOUNTS RECEIVABLE```````````````````````````````````````- Cash receipts accounting- Customer accounts reconciliation- AR accounts reconciliation```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

CASH MANAGEMENT```````````````````````````````````````- Bank accounts reconciliation- General ledger journal entries accounting- Corporate reporting- Bank statements archiving```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````PAYMENTS```````````````````````````````````````- Liquidity control and reporting- Payment requests processing- Employees/vendors advances reconciliation- AP invoices archiving- AP analyses reporting```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

Magister (Mgr), Finanse I Rachunkowość

Licencjat (Lic.), Finanse I Rachunkowość