Lukasz Lewicki

Experience

• 

  Sandoz

  Jul 2006 - Feb 2008

  • creation and administration of application in MS Access for managing production orders• providing training and consulting of MS Access for company employees • margin and gross-to-net calculation, monthly sales reporting by products and brands• prepare actual costs vs. budget report (OPEX)• participation in budget planning (gathering and consolidate data from business)• development of new applications in Excel and an Access (using VBA and SQL)

  • Specialists in Logistics Department

    Oct 2007 - Feb 2008

  • Junior Financial Analyst

    Jul 2006 - Sept 2007
• 

  ORLEN S.A.

  Feb 2008 - May 2008

  Investment Efficiency Establishing Analyst

  Creation of various applications and database in MS Access for analysis of investments in petrol stations

• 

  Sandoz

  May 2008 - Jun 2015

  • IFRS reporting for Sandoz Poland (process accelerated by start using BI upload tool)• Implementation of model for loading budget data into FCRS• Accruals calculation (OPEX, A&P), journal entries checking• Credit risk and treasury analysis (aging, bad debt, DSO, credit limits)• SAP super user, FICO setting (GL, cost element, cost center, internal order) • SPMR reporting• KPIs implementation for accounting department• Revenue Deductions (accruals, settlements with wholesalers) – shortening month-end by 1 day• inventory analysis and provisions calculation• preparing and performing presentations regarding inventory and slow movers on S&OP meetings• SAP BW super user • participation in SAP implementation (SHAPE Project) as Business Support (Jun-Dec 2008) -cooperation with consultants, testing new functionalities, data migration, filling test specification, preparing instructions and provide training• SPMR reporting - standard cost, inventories and sales reporting by products (actuals, budgets)• costs reconciliation within Sandoz Group suppliers• implement model for slow movers provision & NRV calculation

  • Finance Controller

    Jan 2013 - Jun 2015

  • Senior Financial Analyst

    Apr 2010 - Dec 2013

  • Financial Analyst

    May 2008 - Mar 2010
• 

  Novartis

  Jul 2015 - Mar 2021

  • Revenue deductions activities: accruals calculations, settlements with wholesalers• Coordinate implementation enhancements in SAP for revenue deduction area (accruals automation)• Harmonization postings between divisions, processes simplification • Manage month-end IFRS close for Sandoz Poland, Lek S.A., Alcon• Accruals calculation (OPEX, A&P), postings checking, Balance Sheet Review, AR/AP ICO reconciliation• Allocation posting (cycles, assessment and distribution)• Cash forecasting (netting)• Participate in Blue Project– implementation in SAP new reporting rules

  • Revenue Deduction Lead/Expert (O2C, R2R)

    Nov 2017 - Mar 2021

  • Reporting Expert (R2R)

    Jul 2015 - Oct 2017
• 

  Sandoz

  Apr 2021 - now

  Business Planning & Analysis Manager