1. No category

Justas Mikelkevicius; 15/02/1979; e-post: jmikelkevicius@gmail.com ; tel: +47 94789924
I am Business intelligence consultant. Since 2007 I work for
consulting companies in Norway. Our clients are big finance,
insurance and telecommunications companies. My main
tasks are:
ETL, data warehousing, reporting and analysis. I took part at
different projects, such as Basel II project at Sandnes
Sparebank, where I was responsible for reports portal and
project that I am taking part right now, Solvency II
Compliance data warehouse at Sparebank1 Skadeforsikring.
Mainly I work with SAS software both ETL and BI platforms
and tools, but I do not have difficulties to learn new software
if there are needs. I have Master degree of Data mining
which was received at Vilnius Gediminas technical University.
BI/ETL Tools experience
SAS Data Integration Studio (ver. 4.7; 4.3; 4.21; 3.4)
SAS Management Console (ver. 9.4; 9.3; 9.2; 9.1.3)
SAS Information Map Studio (ver. 4.2; 3.1)
SAS OLAP Cube Studio (ver. 9.2; 9.1.3)
SAS Enterprise Guide
SAS Foundation (Base SAS)
SAS Macro
SAS Information Delivery Portal (ver. 4.2)
SAS WebReport Studio (ver. 4.3; 4.2)
SAS Visual Analytics (ver. 6.4; 7.1)
Tableau Desktop/Server (ver. 7; 8)
IBM Pure Data for Analytics (Netezza)
Data Modelling with ERWIN (ver.7)
Data Warehousing
TortoiseSVN
Platform LSF (Schedule tool)
SAS/IntrNet
64 (months experience)
64 (months experience)
52 (months experience)
52 (months experience)
73 (months experience)
73 (months experience)
54 (months experience)
52 (months experience)
52 (months experience)
8 (months experience)
8 (months experience)
6 (months experience)
8 (months experience)
34 (months experience)
34 (months experience)
53 (months experience)
4 (months experience)
EDUCATION
2004 – 2005
Oslo University, Norwegian language
2002 – 2004
Vilnius Gediminas technical university, Lithuania,
Information Technology Master
1998 – 2002
Vilnius Gediminas technical university, Lithuania,
Information Technology (Mathematics / Informatics) Bachelor
ADDITIONAL TRAININIG
2007
2007
2007
2011
2011
Base SAS Programming eLearning
Advanced SAS Programming eLearning
SAS Master Class
Data architecture with ERWIN
DI Studio Fasttrack
CERTIFICATIONS
WORK EXPERIENCE
01.10.2010 NextBridge AS
Brobygger / BI Consultant
Tasks/assignments:
SME(subject matter expert) for non-life insurance datawarehouse
department at SpareBank1 Forsikring. Contact with datawarehouse
business users, discuss issues and requirements. Developing, reporting
using SAS, Tableau and IBM Pure Data for Analytics
Main accomplishments: 2013 – Developing of Datamart for “Actuary data” project. It is part of
Solvency II reporting project. We use SAS DI Studio 4.7 for ETL.
2008.09 - Responsible for SpareBank1 Skadeforsikring datawarehouse
daily drift using SAS DI/ETL and creating monthly, weekly, ad-hoc
business reports using whole SAS 9.1.3, SAS 9.2 BI platform. From
2012 reporting using Tableau.
2012 PoC Netezza (Pure Data for Analytics) SAS datasets integration
with Netezza. Changing ETL processes of SAS datasets to write output
to Netezza for best performance of Tableau reports.
2008 – 2010
Brobygger / BI Consultant
Umoe Consulting AS
Tasks/assignments:
Development with SAS products and implementation. Main work with SAS
BI platform: SAS DI studio, SAS OLAP Cube Studio, SAS Information
Maps, SAS Portal, SAS WebReport Studio.
Main accomplishments: 2008.11-2010.05 SAS platform migration at SpareBank1 Skadeforsikring. I
use SAS DI Studio, SAS Management Console for moving whole system
from old base sas 8 to new platform SAS 9.1.3 . Creating metadata, data
management objects and creating scheduling tasks using LSF.
2008.9-2008.11 Reporting system for "Finn.no AS" finance department
using SAS OLAP cube studio, SAS Information delivery Portal and SAS
WebReportStudio.
2008.10 - 2008.12 Modifying of SAS Credit Risk Studio reports by changing
dashboards and portlets for Storebrand og BNBank: Similar task to what I
did at Sandnes Sparebank. Assignment via SAS Institute Norway.
2008.06 - 2008.12 Creating and publishing reports to SAS Information
Delivery Portal based on SAS Credit Risk Studio (Basel II) . Customer:
Sandnes Sparebank via SAS Institute Norway.
2007.11-2008.05 Additional development of SAS-application”
Konsernanskaffelse og Logistikk – Motorvogn” at “Gjensidige Forsikring”
(Oslo, Norway). Development with SAS Base and BI-platfrom(ETL) pluss
SCL (system).
2006 - 2006
Paspara
SAS Developer. Development using SAS Base.
2003-2004
Garsu Pasaulio Irasai
IT specialist and manager of theatrical distribution. Responsible
for technical side of theatrical distribution; managing company's
web site www.gpi.lt. Also responsible for computers, their software
and hardware and for company’s computer network.
Development of Lotus Notes based system “OnTime” using
2001-2002 (3months)
Informacinės Technologijos Lotus Notes scripts.
LANGUAGE SKILLS
Lithuanian
Speaking: native ; Writing: native ; Understanding: native
English
Speaking: good ; Writing: good ; Understanding: good
Russian
Speaking: good ; Writing: good ; Understanding: good
Norwegian
Speaking: good ; Writing: good ; Understanding: good
REFERENCES
Pål Steinar Schau , head of data warehouse department at Sparebank1 Oslo-Akerhus
E-mail: Paal.schau@sparebank1.no
Telephone: +47 958 38 990
Prof. Genadijus Kulvietis, IT cathedral Professor at VGTU Faculty of fundamental science
E-mail:gk@fm.vtu.lt
Telephone:+370 5 2698881