Karolis Ausra partly available (2 Recommendations)

Karolis Ausra

Certified Senior CPM and BI-Expert (Jedox | Excel | Power BI)

partly available (2 Recommendations)
Profileimage by Karolis Ausra Zertifizierter Senior CPM- und BI-Entwickler (Jedox | Excel | Power BI) from Hannover
  • 30655 Hannover Freelancer in
  • Graduation: Diplom Economics + Informatics
  • Hourly-/Daily rates:
  • Languages: German (Full Professional) | English (Full Professional) | Russian (Elementary)
  • Last update: 28.01.2021
Profileimage by Karolis Ausra Zertifizierter Senior CPM- und BI-Entwickler (Jedox | Excel | Power BI) from Hannover
Internationally experienced CPM (Corporate Performance Management) and BI (Business Intelligence) developer with> 10 years of experience in the CPM / BI environment with a focus on technologies such as Jedox, Excel and / or Power BI.

Activities in the area of ​​CPM include: Conception and implementation of complex workflow-supported planning systems, process optimization and automation, modeling of multidimensional databases (OLAP), creation of complex business rules, design and development of ETL processes, connection of internal pre-systems, development of high-end Management reports, solving performance issues (rules, ETL, frontend), infrastructure-related tasks (server, installations, licences), etc.

Activities in the BI area include: conception and development of management reports, creation of dashboards, calculation of complex KPIs / measures, connection of various previous systems (e.g. SQL), data transformation (ETL), implementation of complex authorization concepts (e.g. RLS), performance optimization (e.g. DAX),  infrastructure-related tasks (server, installations, licences), etc.

I am an expert (lead role in projects) in the following CPM / BI technologies:
  • Jedox (all versions since Spreadsheet Server, Palo, Web, ETL, OLAP, Supervision Server, SSO, PHP, Connecting Active Directory etc.)
  • Excel (VBA, Office 365, Connecting Databases (e.g. SQL Server, Access, etc.), Power Pivot, Charts & Reports, etc.)
  • Power BI (Power BI Query, Data Transformation, M, DAX, Reports, RLS, Custom Visualizations, Power BI Service, Dashboards, Workspaces & Apps, Data Gateways etc.)

Furthermore, with the following CPM / BI and other technologies I had extensive project experience:
  • Infor BI (Modeller, Application Studio, Process Engine, SQL Server)
  • IBM TM1 (Web, Frontend, Excel, TI, OLAP)
  • Tableau
  • Qlikview
  • SAP Analytics Cloud
  • Power Automate (Flow)
  • Power Apps
  • MS BI Stack (SQL Server + SSAS + SSIS + Sharepoint)
  • Virtualization with Azure
  • TFS / Azure Devops / Jira

Programming languages ​​and other hard skills:
  • VBA (context: Excel)
  • PHP (context: Jedox)
  • Groovy (context: Jedox ETL)
  • MDX (context: SSAS)
  • M, DAX (context: Power BI)
  • SQL (context: SQL Server, Jedox, Excel, Access, Power BI)
  • UI / UX (Solution Design, User Experience)

Soft skills:
  • Project Management (Classic and Agile)
  • Ability to understand and structure most complex scenarios and processes
  • Analytical thinking
  • Hands-on mentality
  • Clear and proactive communication

Consulting experience:
  • > 30 consulted and implemented CPM / BI projects (since 2011), mostly with Jedox, Excel and Power BI. Some implemented projects can be described or demonstrated on request. See also under Recommenations for client feedback.
Mehr als 30 internationale und innländische Projekte erfolgreich durchgeführt. Für Referenzen / Projektberschreibung / Demos bitte kontaktieren.
Reisebereit mit Remote-Anteil.

ELPRO Global

Controller ( Christoph Rütsche )

We have implemented a Jedox project, which can be assigned mainly to the area of cost accounting. We calculated the entire article and customer structure with regard to profitability at the EBIT level. This project includes, in addition to the consolidated group presentation, also many allocation steps to achieve the result. Mr. Ausra recognized the individual intermediate steps in the project very well and was able to present very good solution approaches. Many thanks to Mr. Auzsra !



Projektmanager ( Frank Metz )

We got to know Mr. Ausra during our system implementation as a very competent and customer-oriented consultant and developer. His extensive specialist knowledge, especially with Jedox technology, was very valuable for our project work.