Data Consultant

Resume posted by gheran.alin in IT.

Desired position type: Any
Location: București Municipiul București, Romania

Contact gheran.alin

Summary

Strengths:
• Oracle Business Intelligence 11 Certified;
• Enterprise DW (Data Warehousing) & Data Marts – Kimball’s methodology;
• Relational databases: Oracle SQL Expert Certified;
• Other technologies: SQL (Certified), PL/SQL , Progress4GL, APEX;
• Big Data & Data Science: R programming language, Hadoop with Hive, Statistics
• Multi-cultural and cross-countries team mentoring and leading;

Education

Master / Postuniversitary degree
Master: Databases – Business support
University: Bucharest Academy of Economic Studies
(2010 – 2012), Bucharest

University degree
Faculty: Cybernetics, Statistics and Economic Informatics, specialization Economic Informatics
University: Bucharest Academy of Economic Studies
(2007 – 2010), Bucharest

High School / Vocational School
National College of Informatics “Matei Basarab” – specialization Mathematics-Informatics
(2003 – 2007), Ramnicu Valcea

Experience

Senior Data Scientist (Permanent)

Period: 2015.06 – 01.2016

Company and location: KING , Bucharest & Berlin

Focus on proactivity for monetization and customer behavior for AlphaBetty game.

Working directly with the leadership.

Conduct analysis and make recommendations for leadership based on data patterns discovered and data analytics from player’s database.

BigData Hadoop (Hive, Hue) + R programming language + Statistics (T test, bootstrapping)

 

Business Intelligence Consultant (Permanent)

Period: 2014.09 – 2015.06

Company and location: Sofrecom-ORANGE Group, Bucharest

Technical lead on classical BI and BigData solutions.

Projects:

* POC TopUp for Orange Poland:

– Part of the multinational consultancy team;

– Creating predictions algorithm for customer behavior in R language: determine who and when will reach his data allowance based on his tariff plan;

* POC BigData Analytics:

– Build Telco data analytics application in R language: data extraction + data processing + data visualization;

– R Shiny application to visualize the dashboard for KPIs;

* Linear regression and predictability:

– using statistical methods as simple linear regression, I’ve showed trends in data consumption for specific scenarios;

* Social Media Profiling blueprint:

– using R language: created Twitter sentiment analysis;

– identified most likely KPIs for candidate screening and scoring;

 

Business Intelligence Consultant (Permanent)

Period: 2011.09 – 2014.10

Company and location: ORACLE, Bucharest

Part of the Oracle Global Business Operations department, Sales Intelligence team.

Report to business owners/stakeholders.

Projects delivered – all global enterprise OBIEE 11g implementations:

  • Sales Consulting Individuals (over 1000 users);
  • Sales Consulting Managers (over 200 users);
  • Global Client Advisors Blueprints (over 250 users).

Daily activity:

  • OBIEE & DWH development;
  • Coordination and continuous dialog with the stakeholders and team project members;
  • Requirements gathering, prioritization;
  • Team leading: planning, assistance, prioritization, evaluation;

Technical activity – I am working with full BI stack:

DW (Data Warehousing): using PL/SQL packages & jobs

  • ETL routines , sourcing data from Oracle Fusion CRM & APEX-built user-applications;
  • De-normalize source data to a Star schema, available for OBIEE repository;

OBI EE 11g (Oracle Business Intelligence Enterprise Edition):

  • OBIEE Repository layers: Physical, BMM, Presentation;
  • Security: catalog security & row/data-level security;
  • Dashboards, analysis & KPIs’s;
  • Migrations, followed by data testing and validation;
  • Requirements gathering from stakeholders;

Performance Tuning:

  • Build indexes on objects- UNIQUE,BITMAP;
  • Fragmentation of facts;
  • Query cost analyze & data modeling in RPD (n:n implementation);

The whole reporting system started as EMEA only and being successful, we made it global, by integrating data sources from all regions and redefining architecture to answer to all regions business requirements.

I’ve worked in a mixed team, consist of ETL & BI specialists, that build and deliver our

internal BI reporting and analysis sales solution for Oracle top management (CEO and VPs).

On all projects I was involved in, I’ve acted as a subject area matter and the liaison point between stakeholders and technical team.

Team mentoring in Presales Project: 7 multi-cultural team member.

I’m also responsible of mentoring, training and integrating interns in our team.

 

Business System Analyst (Permanent)

Period: 2010-09 <> 2011-09

Company and location: Tuborg Romania, Bucharest

Business perspective:

Focus on production area.

Working with production end-users for gathering detailed information and also with financial top management to present required summarized information.

Technical perspective:

I’ve worked with the company’s ERP : MFG/PRO for Inventory &Production

*Analysis& Planning:

– data analysis to verify data in the system;

– coordinate with other areas of company, third party product vendors for product release planning and testing purposes.

*Programming

– SQL: direct database queries in company’s relational database;

– Progress 4GL (OpenEdge): scripts, procedures for building and implementing reports in character-interface and integrate them in MFG/PRO ERP menu;

*Support & troubleshooting

– Handle escalated customer issues and interdepartmental issues.

 

Skills

  • SQL – more than 5 years experience
  • PL/SQL – 3-4 years experience
  • R language – 2 years experience
  • Hadoop&Hive&Hue – 1-2 years experience
  • ETL & BI – more than 4 years
  • Analytics – more than 5 years
  • ERP – 1 year
  • Progress4GL – 1 year