Ivar-Illimar Ots

Ivar-Illimar Ots Email and Phone Number

Data Warehouse Enthusiast | Bridging Business and Technology | Certified ScrumMaster @ BerryBI
Estonia
Ivar-Illimar Ots's Location
Estonia, Estonia
About Ivar-Illimar Ots

Self-driven, goal-oriented and responsible Business Intelligence and Data Warehousing professional with more then 20 years of experience in the information technology and finance area. The various specialties of analytics, data warehousing, data modelling, data quality, controlling, finance, project and people management, business development and management has developed of me an exceptional professional who relishes the opportunity to communicate with business specialist, leaders and customers.Endurance sport activities keeps head clear, energized and strong-minded.***BI makes companies smarter. BI is here to stay.

Ivar-Illimar Ots's Current Company Details
BerryBI

Berrybi

View
Data Warehouse Enthusiast | Bridging Business and Technology | Certified ScrumMaster
Estonia
Website:
berrybi.ee
Employees:
3
Ivar-Illimar Ots Work Experience Details
  • Berrybi
    Data Warehouse Enthusiast | Bridging Business And Technology | Certified Scrummaster
    Berrybi
    Estonia
  • Berrybi
    Business Intelligence Consultant / Ceo&Owner
    Berrybi Jul 2013 - Present
    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.
  • As Tallink Group
    Area Manager Dw And Reporting
    As Tallink Group Jul 2007 - Jul 2013
    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
  • Seb
    Business Controller
    Seb Apr 2005 - Jul 2007
    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.
  • Seb
    Data Warehouse Analyst
    Seb Mar 2001 - Apr 2005
    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.
  • Isku Eesti Oü
    Project Manager
    Isku Eesti Oü Jan 1998 - Mar 2001
    Office furniture project sale. SONET accounting and warehouse program administration and maintenance. Purchase and sale documentation management. Reporting, instruction of sales and warehouse employees.

Ivar-Illimar Ots Skills

Business Intelligence Data Warehousing Business Analysis Project Management Business Objects Management Consulting Business Development Cognos Team Management Webfocus Budget Process Financial Reporting Forecasting Etl Sql Business Control Pl/sql Oracle Sybase Iq Data Integration Microsoft Office Ms Reporting Services Microsoft Sql Server Jira Confluence Analysis Data Modeling Data Quality Data Management Financial Analysis Business Planning

Ivar-Illimar Ots Education Details

Frequently Asked Questions about Ivar-Illimar Ots

What company does Ivar-Illimar Ots work for?

Ivar-Illimar Ots works for Berrybi

What is Ivar-Illimar Ots's role at the current company?

Ivar-Illimar Ots's current role is Data Warehouse Enthusiast | Bridging Business and Technology | Certified ScrumMaster.

What schools did Ivar-Illimar Ots attend?

Ivar-Illimar Ots attended Tartu Ülikool, Tallinna Majanduskool.

What skills is Ivar-Illimar Ots known for?

Ivar-Illimar Ots has skills like Business Intelligence, Data Warehousing, Business Analysis, Project Management, Business Objects, Management Consulting, Business Development, Cognos, Team Management, Webfocus, Budget Process, Financial Reporting.

Who are Ivar-Illimar Ots's colleagues?

Ivar-Illimar Ots's colleagues are Karin Aguraijuja, Silja Ostrov.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.