Senior Effectiveness specialist | Adamed consumer healthcare | march 2015 toCURRENT |

DEPARTMENT:Operational Effectiveness Team, Finance Department

ROLES AND RESPONSIBILITIES: Responsible of Design and Implementation of Analytics solutions:

·         Dashboards for Top Management in Power BI technology;

·         Support Sales Department inDesigning &Implementing automatic reports regarding:Personal sales, IMS sales, realization of qualitative and quantitative targets, assessment of representative effectiveness, distributing sales targets among Sales Force, quarterly calculation of bonuses for Sales Force;

·         KPIs definition;

·         Creating automatic solutions for reporting customer orders into the CRM system;

·         Contribution in key strategic projects (Senior 75+, new market opportunities, wholesaler discount control)

Senior business intelligence specialist | novartis poland sp. z. o.o. | march 2012 to february 2015 |

DEPARTMENT: Sales Department, Warsaw

ABOUT COMPANY:Global Switzerland company distributing top products for flu like Theraflu, Otrivin, Orofar, & top muscles pain killer: Voltaren

ROLES AND RESPONSIBILITIES: Implementing international projects in polish market regarding boosting effectiveness in sales force (Wining at Pharmacy , Gross to Net Efficiency Projects), taking active role in numerous internal processes such as Pharmacy Targetisation, A&P revision, setting KPI for Sales Force, market analysis (IMS data : sell in , sell out data), creating solutions/models for representatives as a good support in negotiating process with customers, control of strategic assumptions, creating and maintaining customer database, collecting and revision of plans & contracts per customer in each quarter.

BUSINESS ANALYST – SALES DEPARTMENT – [MARCH 2012 TO JANUARY 2013] :Reporting of sales results for representatives, calculating quarterly bonuses, calculating quantitative targets for Sales Force, wholesaler stocks reports, delivering dashboards for monthly sales meeting for regional managers, supporting demand & forecasts for IMS and ex factory level, administrating CRM system (Farmaprom).

DEMAND PLANNER | nESTLE poland sp. z. o.o. | AUGUST 2011 to february 2012

DEPARTMENT: Nestle Purina, Supply Chain, Warsaw

ABOUT COMPANY:Global Switzerland company distributing pet’s food such as Purina Pro plan, Purina ONE, Purina Friskies, Dog Chow, Felix

ROLES AND RESPONSIBILITIES: Preparing and submitting for board acceptance 18 months plan of sales for animal products, support for sales department creating sales reports incl promotional plans, product accessibility, reporting main KPI in weekly and monthly cycles

Reporting specialist | INFOVIDE | january 2010 to july 2011 |

DEPARTMENT: Matrix S.A., Project Department, Warsaw

ABOUT COMPANY:Leading polish company delivering & consulting IT solutions for public & private company in various sector of economy (Telecommunication, Banking, Insurance, Public Administration, Energy, Media)

ROLES AND RESPONSIBILITIES: Reporting of financial results, benchmark groups & sectors (sales teams), cost effectiveness reports for projects, reporting plans and man allocations for projects, testing implementation of technical solutions together with IT .

financial analyst | pkt centertel sp. z. o.o. (known as orange) | march 2008 to december 2009 |

DEPARTMENT:Finance / Sales Department, Warsaw

ABOUT COMPANY:Global Telecommunication company employing 3500 employees in Poland

ROLES AND RESPONSIBILITIES: Budget processes coordination (Budget, Budget update, NSFP, Forecast processes), preparing short and long term plans, control of budget realization, preparing monthly comments for variances, taking part in closing month in financial books.

BUDGET AND PLANNING SPECIALIST – [MARCH 2008- DECEMBER 2008]:Designing structure for budget databases in current budget processes, maintain alliances within budget and actual database structures, form appropriatempk, kod H in Magnitude system.

Education

2002 – 2007         Nicolas Copernicus University, Torun, Poland

Economics & Management, Majoring in International Finance

·         Thesis titled “Decision Support Systems in Enterprises”

Passed with grade: 5 out of 5

2004 – 2007         Nicolas Copernicus University, Torun, Poland

                                European Studies

·         Thesis titled “Green Evolution in Agricultural Policy in EU”

Passed with grade: 4 out of 5

1998 – 2002         WładysławJagiełło High School, Płock, Poland

·         Majoring in Mathematics & Physics

Skills & Abilities

Computer SKills

·    Business Intelligence/Big Data Analytics Tools: Microsoft Power BI – Power Pivot (incl Dax formulas), Power Query, Power View, Pivot Queries, Fuzzy Look Up. MS Access

·    Microsoft Office: MS Excel, MS Power Point, MS Outlook,MS Word

·    Microsoft Programming Tool: Visual Basic (basics of SQL)

·    Financial- Reporting Software – CRM- Farmaprom, IMS Sales Analyzer, IMS Data View, Omnibus, IFS 2000, Hyperion Essbase, Hyperion Planning, Axapta, OLAP

language known

·    Polish – Mother tongue

·    English – Fluent (Spoken English for Industry and Commerce Certificate – Level 4 granted by LCCI IQ)

·    Italian – Upper Intermediate

·    German – Good (Certificate Deutsch granted by Goethe Institute)

Analytical Abilities

·    Models Design and Implementation (through automated applications – i.e. Microsoft Business Intelligence applications) helping to increase ability to predict customer’s needs, expand market opportunities and increase operational efficiency;

·    Broad collaboration with internal & external customers/ Effective team member with good interaction with others;

soft skills

·    Result Oriented Approach– highly dedicated to business goals, strongly involved to accomplish tasks in line with expectations & in time. Full sense of responsibility. Ability to manage multitasking assignments;

·    Innovative and Creative- Constantly look for new opportunities creating IT solutions/models that can deliver better understanding of current situation. I was appointed for Innovation Contest in Adamed by Finance Department; Spirit Award in Novartis 2013 (Passion to Win, Courage to Lead, Work in Integrity, Broad Collaboration);

·    Competent-I believe that in-depth understanding of domain is utmost important in the field of analytics, which requires regular learning of subject. This approach has helped me and I demonstrated deep technical and functional knowledge that enables to perform on my position professionally;

·    Up to Date:I acquire the latest knowledge on BI market launched by Microsoft concerning the newest Business Intelligence Application: Power BI (incl. Power Pivot (Dax Language), Power Query (M language), Power Desktop). I master my skills in Excel environment during 10 years of my career as Analytic in various sectors of economy.