Ivar-Illimar Ots Email and Phone Number
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.
Berrybi
View- Website:
- berrybi.ee
- Employees:
- 3
-
Data Warehouse Enthusiast | Bridging Business And Technology | Certified ScrummasterBerrybiEstonia -
Business Intelligence Consultant / Ceo&OwnerBerrybi Jul 2013 - PresentEstoniaI 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. -
Area Manager Dw And ReportingAs Tallink Group Jul 2007 - Jul 2013Responsible 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 -
Business ControllerSeb Apr 2005 - Jul 2007Reporting, 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 Warehouse AnalystSeb Mar 2001 - Apr 2005Data 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. -
Project ManagerIsku Eesti Oü Jan 1998 - Mar 2001Office 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
Ivar-Illimar Ots Education Details
-
Bachelor'S Degree -
Tallinna MajanduskoolVocational Education
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial