Ivar-Illimar Ots Email & Phone Number

Estonia

Estonia

I deliver business intelligence, data warehouse and data quality solutions. Leading the BI projects is my passion. The data management, BI-strategy consultation and data analyses are the core services.I have clients within the field of banking, transportation and public sector. I'm involved in cooperation in joint projects with leading IT and audit companies.The Core Strengths are understanding the critical issues specific to your business, selecting best practices from an array of industry proven solutions and speaking the truth about opportunities and risks.I'm committed to clients success.

Responsible for all Tallink Group reporting solutions, reporting development and operational maintenance. Supporting reporting requirements globally for all Tallink market areas.Projects:- migration of reporting team and responsibilities from Finland to Estonia (2007- 2008)- hiring employees and building a new team (2007-2009)- developing a new data warehouse (MS SQL Server) and reporting system (Cognos) based for new sales and ticketing system;- designing data needs, data modelling- ad-hoc reporting- working with external consultants (2007-2009);- developing operational reporting environment (MS Reporting Server, Visual Studio, Oracle procedures/packages; 2007-2011)- migration of financial planning reports and process into SAP PBU (supporting Financial department)- based on business new pricing model and other significantly grown needs writing the new project for procurement of new complete set of DWH, ETL and BI solution (2010)- Implementation and development of new reporting environment: SAP Sybase IQ (DWH), SAP Sybase real-time loader/Information Builders iWay Data Integration (ETL), Information Builders Webfocus and InfoAssist (2011-2013) - real-time (latency 3-4 minutes) reporting portal for revenue management and operational reporting (2012)- data warehouse and reporting portal for Tallink Hotels (2013)- new financial portal with budgeting process and consolidation solution (2013)Other activities:- IT management support in strategic development- Data quality consultation- Strategic reporting development- Sales, country and top management support- Training internal customers- Presentations

Reporting, forecasting, accounting, middle and top management support, corporate & institutions division support (financial analysis, benchmark, overviews in MS PowerPoint), managing different projectsAdditional information: Expert skills with Business ObjectAccomplishments: My knowledge of bank fundamental structure and business model was deeply increased. Forecasting of funding company and capital market revenue and assets, RWA, capital adequacy, treasury NII and treasury products was improved. I was training my coworkers.

Data analyses and reporting with Business Object, design and modelling with BO Designer, programming (Sybase IQ, BO freehand SQL), reporting development for leasing (subsidiary of bank) company; bank DWH development and testing; participation in BASEL II project; supervisor of a trainee. Additional information: working daily with Business Object, Designer, InfoView, SQL, MS Excel, MS Word, MS Access etc.Accomplishments: My knowledge of data warehousing, business intelligence, data analysis and modelling improved remarkably.

Office furniture project sale. SONET accounting and warehouse program administration and maintenance. Purchase and sale documentation management. Reporting, instruction of sales and warehouse employees.

Bachelor'S Degree

Vocational Education