Alexandru Ungureanu
Head of Data Management & Reporting Team
Member Since: 2014/04/22
Tech Certifications:
Provide a quick, creative biography in 140 characters or less.
More bio
Activity
Points this month0
Total points8,868
Professional Background
Head of Data Management & Reporting Team
Moldtelecom
February 2012 – Present
Responsible for building Data Warehouse, including analysis of business requirements, data sources profiling, ETL development and populating data marts into a multidimensional model.
Responsible for technical development, implementation, and support of the BI/Reporting solutions.
Experience with Oracle 10g,11g, MSSQL databases. Expertise in writing queries, stored procedures, triggers, views, materialized views (with query rewrite), query tuning and index creation, table partitioning and partition manipulation techniques.
Experience in managing teams up to 10 persons. Good understanding of telecom industry.
Tools and technology used: Oracle 10g, 11g, MSSQL 2008, SQL, PL/SQL, Pentaho ETL (PDI Kettle), Microstrategy Reporting Suite, Dimensional Modeling.
Responsible for technical development, implementation, and support of the BI/Reporting solutions.
Experience with Oracle 10g,11g, MSSQL databases. Expertise in writing queries, stored procedures, triggers, views, materialized views (with query rewrite), query tuning and index creation, table partitioning and partition manipulation techniques.
Experience in managing teams up to 10 persons. Good understanding of telecom industry.
Tools and technology used: Oracle 10g, 11g, MSSQL 2008, SQL, PL/SQL, Pentaho ETL (PDI Kettle), Microstrategy Reporting Suite, Dimensional Modeling.
Microsoft Office Excel Trainer
Moldtelecom
April 2013 – December 2013
Course Title: Advanced Techniques of Data Analysis using Microsoft Office Excel 2010
Course Objectives: Improve data analysis skills and increase performance in daily work of the company's employees.
Course Objectives: Improve data analysis skills and increase performance in daily work of the company's employees.
BI Specialist
Moldtelecom
October 2010 – January 2012
Gathering and analyzing business requirements for developing new reports or update existing ones. Developing Oracle database objects, stored procedures and packages, views, tables and triggers. Developing ETL flows using Pentaho Data Integration and monitoring execution of jobs for loading data into Operational Data Store. Responsible for creating and deploying reports using Microstrategy Reporting Suite, and Excel for ad-hoc reports.
Building small application for collecting data and populating facts and dimensions tables.
Tools and technology used: SQL, PL/SQL, Dimensional Modeling, Oracle 10g, Oracle APEX, ETL Pentaho Kettle Solution, Microstrategy, Power Designer.
Building small application for collecting data and populating facts and dimensions tables.
Tools and technology used: SQL, PL/SQL, Dimensional Modeling, Oracle 10g, Oracle APEX, ETL Pentaho Kettle Solution, Microstrategy, Power Designer.
Chief-Engineer
Neosuport Service SRL
December 2008 – August 2010
Lunch and expand the activity of the computer service center. Employ and build-up the team. Planning, organizing and evaluating the work of engineers. Implementation of software and hardware solutions to customers. Contact and maintain a feedback with customers.
Technology and tools used: Microsoft products, Linux-like environments, LAN/WLAN, financial and accounting applications.
Technology and tools used: Microsoft products, Linux-like environments, LAN/WLAN, financial and accounting applications.
Programmer
Moldcell
April 2007 – October 2008
Maintenance of billing soft, configuring tariffs and rate plans, upgrading and developing new features. Supporting billing procedures, answer complaints, online payments monitoring. Supporting customer service, deliver ad-hoc reports for all departments.
Tools and technology used: SQL, PL/SQL, Oracle 10g, Fast Report, Toad for Oracle, C++, Delphi, Java.
Tools and technology used: SQL, PL/SQL, Oracle 10g, Fast Report, Toad for Oracle, C++, Delphi, Java.
Programmer
Academy of Economic Studies of Moldova
July 2006 – April 2007
Developing, administrating and upgrading the application of applying and enrollment to universities. Developing the application of didactic workload and training end-users. Participating in the developing and exploiting of diverse applications of local use.
Tools and technology used: MySQL, C++Builder, Fast Report.
Tools and technology used: MySQL, C++Builder, Fast Report.
Education
Academy of Economic Studies of Moldova
Master
Information Technologies in Economics
2006 – 2007
Academy of Economic Studies of Moldova
Licentiate
Economic Cybernetics and Informatics
2002 – 2006
Full Biography
I'm a very dynamic person with great interpersonal skills. In my daily job, I'm trying to do my best by putting in front the slogan "no mission impossible".
Looking forward to reach and deal with great challenges in data warehouse field.
Languages
Romanian
Native or Bilingual Proficiency
Russian
Full Professional Proficiency
English
Professional Working Proficiency
French
Elementary Proficiency
Level Progress
-
Overall2
-
Microsoft Excel1
-
Oracle Database1
-
DB Reporting Tools1
-
Databases1
-
Microsoft SQL Server1