Piotr Łazarczyk Email and Phone Number

Used tools at work:Relational Databases MS SQL Server (T-SQL), Oracle HFM, SAP, SAP BI, Visual Basic for Applications (VBA)- Developing and implementing new analytical concepts and tools- Designing, developing and maintaining business intelligence solutions- Designing, creating, testing and implementing automations of financial & non-financial company processes- Identifying business processes for automation or improvement- Participating in management monthly reporting, in key company projects- Monitoring and analyzing current and past trends in key performance indicators, calculation of KPI indicators- Co-creating of sales and margin budgets, co-creating and controlling the implementation of annual budgets- Budgeting, forecasting, analyzing and interpreting of the Company's results, including comparison of actuals versus plan and budget- Sales reporting, including data analysis reporting and conclusions, recommendations to the organization- Controlling and analyzing of profitability of purchased goods, supervision over inventory and reserves- Monitoring brand, product, customer, supplier profitability and competitions, sales transaction controlling- Preparing calculations and assessment of business cases- Creating and controlling of investment activities- Performing ad hoc analyzes and summaries

Used tools at work:Relational Databases ORACLE (PL/SQL), QlikView, Qlik Sense, Visual Basic for Applications (VBA)- Analyzing large volumes of data, data mapping, data reconciliation- Designing and building complex BI reports, scorecards and dashboards, based on specifications as requested- Developing, generating, analyzing and interpreting complex reports, designing new reports and analysis- Monitoring the level of operating costs in individual areas- Profitability analysis of products, customers, suppliers, new projects- Monitoring, analysis and recommendation of changes in terms of cooperation with suppliers and customers- Co-creating and controlling the implementation of annual budgets- Preparing reports including forecasting, explaining budget deviations, analysis and trends- Cooperation with other company departments in the field of financial support in making business decisions

Used tools at work:Relational Databases MS SQL Server (T-SQL), Microsoft Power BI, Visual Basic for Applications (VBA)- Preparing analysis of P&L, balance sheet, sales, revenues, costs, products, branches, customers- Co-creating and controlling the implementation of annual budgets- Preparing financial and operational reports, calculations for tenders and investment projects- KPI analysis, data analysis and data visualization, optimization of business process- Designing new reports and analysis, building controlling tools

Used tools at work:Relational Databases MS SQL Server (T-SQL), Visual Basic for Applications (VBA)- Preparing monthly financial reports (production and commercial) as well as financial and operational analysis for internal needs- Preparing budgets and forecasts and execution control for the factory and commercial part of the company- Cost calculation of products, semi-finished products and raw materials- Analysis and control of costs and production indicators- Reporting and analysis of key company indicators- Monitoring transfer prices in intra-group transactions- Preparing transfer prices documentation

Used tools at work:Relational Databases MS SQL Server (T-SQL), Infor PM, QlikView, Visual Basic for Applications (VBA)- Preparing sales and business analysis, financial reports- P&L analysis- Co-creating and controlling the implementation of annual budgets, forecast and multi-annual plans of the company- Participation in building models of financial statements- Participation in projects related to the controlling area in the company- Verification of data in financial and accounting systems

Used tools at work:Relational Databases MS SQL Server (T-SQL), Targit BI, QlikView, Visual Basic for Applications (VBA)- Managing Price Policy in a nationwide loyalty program on the pharmaceutical market- Customer Relationship Management - CRM, customer analysis, mailing campaigns, segmentation and customer behaviour analysis, basket analysis, customer database management- Market analysis and monitoring - prices/competition- Preparing business analysis, effectiveness and quality analysis of business projects and reports for the Management Board of the Company

Winner of the competition „Program Kariera VIII edition” Polish Business Roundtablecase study a franchise project on the pharmaceutical market

Internship in Treasury Department - Department of Financial InstitutionsWinner of the competition „Grasz o staż XV edition”case study on the capital market - prospectus