Marta Laats Email & Phone Number

Bergen, Hordaland, Norway

Helping companies of various industries (incl. Oil and Gas, Insurance, Marine) build and develop their BI solutions to optimize decision-making and business development. Responsibilities include :Requirements gatheringResource planningData cleaning, preparation, modeling, query optimization (MS SQL, Oracle)DWH development (MS SQL server)Creating semantic layers with SSAS /AASGovernance and Security (inc dynamic row level security)Building PowerBI reports and dashboards (DAX)Data analysis, interpretation Creating Data FlowsDeveloping Qlik Sense apps with various sources (inc REST APIs)Training user baseETL with Xpert BIBI migration from QlikView to PowerBIConducting PowerBI trainings

Lucerne, Switzerland

• End-to-end dashboard developing with Qlikview and PowerBI:- aligning expectations with business stakeholders- specifying requirements - writing SQL queries/stored procedures- developing clearly visualized dashboards for business users to access up-to-date data- QA, scheduling reload tasks (QMC, PowerBI scheduler and Windows Task Scheduler)- access management (incl. row level section access)• Fixing, maintaining and optimizing existing dashboards• Participate in DW re-structuring (inc. developing datamarts)• Automation (VBA, SharePoint workflow) - mostly supporting finance teams• Creating self-sustainable SRSS/Power BI etc. reports, SQL stored procedures, T-SQL, ad-Hoc queries

• Analysis and presentation of data in order to help making business critical decisions • Data gathering and joining from various data sources (Cosmos, Greenplum, DataRV) - BIG DATA experience• Writing sustainable SQL and Hive scripts to assess product success, creating funnel charts to detect user flows (Skype on Outlook.com, Android and iOS apps)• Active participation in weekly meetings with stakeholders to review current statuses and decide on further actions • Evaluating A/B test results and presenting it to stakeholders in a clearly visualized format• Participating in telemetry formation• Creating self-serving regular reports with Power BI

• Mapping and executing monthly data collection and its automation (via VBA, PowerShell, Task Scheduler)• Creating tables, views, procedures, reports with SQL and MS Excel• Managing existing and creating new internal websites in Sharepoint 2013• Composing Learning Path for Power BI• Planning and developing e- environment for new engineers (Sharepoint sites)• Global Boot Camp program end-to-end planning and execution

Financial analyst in corporate excellence team. Responsibilities included: • Supporting Business Intelligence management• Planning budget• Composing periodical cost reports in SAP R3• Cost allocation• Regular BI reporting, managing doc libraries in Sharepoint

Bachelor Of Applied Science (B.A.Sc.), Analysis Of Information Systems

Bachelor'S Degree (Bsc) - Exchange Student, Information Technology

Bachelor'S Degree, Economics

Bachelors Degree - Exchange Student, Economics