Reporting Analyst

MAGDALENA INDROVA

Toronto, Ontario, 6-47-606-****

*****.*******@*****.***, h ttps://www.linkedin.com/in/magdaindrova CORE COMPETENCIES & QUALIFICATIONS

● Highly experienced Data and Reporting Analyst with a demonstrated history of working with relational databases and performing complex querying utilizing SQL

● Experiences with developing comprehensive reports and dashboards using large amounts of data from localized data marts and several external data sources

● Proven skills in researching, analyzing and visualizing data using SQL, SAS, ORACLE SQL Developer,MS Excel (VBA macros, V-look ups, Pivot tables), MS Access, BI Visualisation tools,Oracle DB

● Professional communication skills including fluency in English and professional working knowledge of French

PROFESSIONAL EXPERIENCES

Data analyst 2016-2017

Ceska sporitelna, a.s., Prague, Czech Republic

The biggest bank in Czech Republic in terms of number of clients. It is a part of the Erste Group, Austria

● Responsible for preparing developing and designing daily, weekly, monthly, quarterly and yearly reports for internal customers and provided data to the business partners about bank’s quarterly results

● Ensured data from internal and external databases and provided data support to the business partners and project managers

● Liaised between business clients, and internal and external IT developers

● Assisted with developing a new business platform for internal usage within the bank

● Worked with SAS, SQL, SQL Developer, Oracle DB, Excel, Microsoft Access, VBA Product Manager 2012-2015

Central European Data Agency, a.s., Prague, Czech Republic Local Czech company creating and selling digital maps

● Responsible for preparing weekly, monthly, quarterly and yearly reports for internal purposes and prepared quarterly and annual financial business plan

● Created the winning projects proposals

● Prepared quotes and proforma invoices

● Worked with GIS technologies, Excel

1

Research Worker 2012-2014

Charles University in Prague, Faculty of Science, Prague, Czech Republic

● Responsible for teaching the GIS I and GIS II courses (ESRI, GEOMATICA,QGIS)

● Participated in the project about Land use and Land cover change using GIS technologies Remote Sensing & GIS Specialist 2009-2012

Gisat, s.r.o., Prague, Czech Republic

Local Czech company providing geoinformation services based on the Earth Observation technology

● Participated in remote sensing control of agricultural subsidies in the Czech Republic

● Participated in a project providing the satellite images and derived thematic mapping products to support national and European humanitarian and development aid activities in African countries

● Worked with GIS and Remote Sensing Control technologies EDUCATION

Master of Cartography and Geoinformatics 2012

Charles University in Prague, Faculty of Science, Prague, Czech Republic Bachelor of Financial Mathematics 2012

Charles University in Prague, Faculty of Mathematics and Physics Erasmus Program - Geography 2011

Université Paris-Sorbonne IV, Paris, France

OTHER KNOWLEDGE, COURSES AND CERTIFICATES

● SAS Macro Language I, SAS, Prague, Czech Republic, 2016

● SAS Programming I&II, SAS, Prague, Czech Republic, 2016

● SAS Visual Analytics: Fast Track, SAS, Prague, Czech Republic, 2016

● Programming for Everybody (Python), Coursera, University of Michigan, 2014

● Google Maps for Work Sales Engineer, Google, online course, Prague, Czech Republic, 2014

● IELTS, Toronto, Canada, 2018

● Cambridge English: Advanced (CAE), Liberec, Czech Republic, 2016

● Diplôme d'études en langue française (DELF - B2), Prague, Czech Republic, 2011 2

Contact this candidate