George O.

Bi/Etl Developer

525 dollar

My experience

More

EXE SoftwareMarch 2014 - Present

The job is essential a consultant job, in here I took care of a couple of projects for different clients.
The projects consists of a couple BI solutions that consists of implementing a complete BI Solution,
using the Microsoft BI solutions(SSIS,SSMS,SSRS,SSAS), from the ETL stage, creating the Data
Warehouse architecture, creating the dimensions and facts tables according to the client needs in
order to the creation of the SSRS Reports, OLAP Cubes and Power BI reports.


The job also have a big part that consists of interacting to the clients by Skype, Mail or at the client
headquarters. In this regard I was involved with multiple cultures like European, American, Asian and Latin America.
More

VaubanOctober 2010 - March 2014

Project: reporting for CRM internal application



Technical environment: Jasper report, PostGreSQL database, BIRT, SpagoBI server.
Project: For financial and IT departments, develop several reports (costs and revenues, taxes, duties)
Technical environment: C# and telerik Bi tool reporting design, SharePoint 2010, database SQL Server 2012
•    Create connection to data source;
•    Update views in database model;
•    Create parameters;
•    Create buttons for view reports application;
•    Publish reports in SharePoint in intranet;
•    Export reports in PowerPoint and create Presentation.

Maintain and develop BIsolutions in accordance with defined objectives;
- importing data from external files and inserting them into the DW (SQL)
- implementing DW architecture using ETL (SSIS packages)
- create SSAS Cubes;
- create reports, Dashboards, KPI (SSRS);
- deployment (SharePoint, Report Manager).
The main tools I used were: SQL SERVER 2008, SQL SERVER 2010, SSIS,SSAS, SSRS, SSMS, T SQL, SharePoint, ReportManager, Postgres Database, Jasper iReport, BIRT, SpagoBI;
I worked at Romanian Bank for Develpment ( BRD ), in the BI department.
Responsibilities:
-deliver reports from Data Warehouse using SAS language;
-maintain the Data Warehouse by updating the tables' structures and ETL processes;
-analyse Business and Technical Specifications and develop small and medium projects;
-code testing;
-write Technical Specifications

The main SAS tools I used were: SAS/base language ( data steps + proc steps ), SAS/SQL, SAS/Macros.
OS Environment : AIX
SAS Programming training and exercises:
•    Creating SAS Data Sets;
•    Data Step Programming (Creating variables, Drop\Keep variables, Controlling Input and Output, Processing Data Iteratively);
•    Combining SAS Data Sets (Concatenating SAS Data Sets, Merging SAS Data Sets);
•    Producing List Reports and Summary Reports (Print Procedure, Report Procedure, HTML Reports);


More

Hornbach Baumarkt AGFebruary 2010 - October 2010

Main responsibilities:
•    SAP reports;
•    Accounting for suppliers;
•    VAT-returns;
•    Monthly statements
•    Reconciliation of accounts;
•    Various reports and statistics;
•    Registration of creditors and debtors company operations, banking operations and other current operations.

My stack

Business Intelligence

ETL, Data Warehouse, Business Intelligence

Databases

Oracle, Microsoft SQL Server, PostGreSQL

Languages

PL/SQL

Others

Business Analysis

My education and trainings

Master BDSA, IT - Bucharest Academy of Economic Studies2010 - 2012

CSIE, IT - Bucharest Academy of Economic Studies2007 - 2009