Profileimage by Zsolt Lendvai Oracle/Business Objects ETL DWH BI Developer from Budapest

Zsolt Lendvai

available
Contact

Last update: 25.01.2018

Oracle/Business Objects ETL DWH BI Developer

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | Hungarian (Native or Bilingual)

Keywords

Oracle SQL PL/SQL Developer Business Objects OBIEE Oracle warehouse builder Oracle Data Integrator 12c ETL Consultant

Attachments

cvenglzs.pdf

Skills

2017. Feb -                      BI Specialist - UPC Austria


            As an integral member of the Liberty Global Data Management Team, I am responsible for the design, development, implementation, management and support of mission critical enterprise BI reports, processes and environments. Working with cross-functional teams, I am required to gather, document, and translate business requirements for data analysis and reporting projects, as well as use reporting and ETL tools to develop reporting solutions to meet business needs.
Responsibilities:
  • Business analysis to gather required BI system requirements
  • Develop reports in OBIEE
  • Transition developed BI systems to the Operations & Support team
  • Provide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users
  • Provide technical assistance and cross training to other team members
  • Design and implement technology best practices, guidelines and repeatable processes
Used Technologies: OBIEE 11g, PL/SQL, SQL
2016. Aug – 2017. Feb    Oracle BI Developer Consultant – Mortoff IT Services Ltd


Support the customer migration at T-Systems.


Responsibilities:
  • writing PL/SQL loading procedures,
  • creating ad-hoc SQL queries
  • reverse engineering Informatica ETL mappings
2015. July – 2016. Aug   Oracle DWH Developer – Ulyssys Ltd., Budapest
Responsibilities:
  • developing ODI mappings
  • creating ODI scenarios and load plans
  • creating OBIEE Dashboards and Analysis
  • creating and designing RPD (physical layer, business model mapping layer, presentation layer)
Used Technologies: SQL, PL/SQL, Oracle Data Integrator 12.1.3, OBIEE 11g
2015. March – 2015. July External Developer for OTP Bank (3 months project)
Responsibilities:
  • create ad-hoc SQL queries
  • tuning of existing SQL queries
Used Technologies: SQL, PL/SQL
2012. Aug – 2015. Febr             Reporting Analyst – Vodafone Hungary, Budapest
Responsibilities:
  • developing business reports in the tool Business Objects
  • translating business definitions into datawarehousing developing
  • defining ETL processes for reporting
  • creating ad-hoc queries from datawarehouse tables
Used Technologies: Business Objects 3, SQL, PL/SQL
2007. March – 2012. June  Software Developer – CP Consulting Ltd, Budapest
Responsibilities:
  • taking part in the migration of Generali Insurance Company’s datawarehouse from SAS to Oracle
  • incremental developments of MKB Bank’s Oracle-based datawarehouse
  • incremental developments of Vodafone Hungary’s Oracle-based datawarehouse
  • Budapest Bank: taking part in the developing of
OPEX Reporting datamart: 48 reports and a universe created
Used Technologies: PL/SQL, SQL, Oracle Warehouse
Builder 10g (10.2.4), TCL, Oracle Application
Express, Business Objects XI R2/3.1
       2005. Aug – 2007. March Software Developer – General Electric Hungary, Budapest
Responsibilities:
  • datawarehouse designing and developing
  • developing Business Objects reports and universes
Used Technologies: Oracle SQL, PL/SQL, Business Objects Reporter, Business Objects Data Integrator
     
       2000. July – 2005. Aug Software Developer – Siemens PSE Ltd
Responsibilities:
  • Budapest: developing forms and reports for European Space Agency
  • Vienna: developing Oracle-based datawarehouse for European Space Agency
Used Technologies: PL/SQL, Business Objects DESKI, Oracle Forms/Reports 6i
 
        
        1998. Feb – 2000. July Software Developer – Eurotrend Informatics Ltd., Budapest
                                               Responsibilities:
  • design Oracle Forms and Reports integrated into a financial and inventory system

Project history

2017. Feb -                      BI Specialist - UPC Austria


            As an integral member of the Liberty Global Data Management Team, I am responsible for the design, development, implementation, management and support of mission critical enterprise BI reports, processes and environments. Working with cross-functional teams, I am required to gather, document, and translate business requirements for data analysis and reporting projects, as well as use reporting and ETL tools to develop reporting solutions to meet business needs.
Responsibilities:
  • Business analysis to gather required BI system requirements
  • Develop reports in OBIEE
  • Transition developed BI systems to the Operations & Support team
  • Provide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users
  • Provide technical assistance and cross training to other team members
  • Design and implement technology best practices, guidelines and repeatable processes
Used Technologies: OBIEE 11g, PL/SQL, SQL
2016. Aug – 2017. Feb    Oracle BI Developer Consultant – Mortoff IT Services Ltd


Support the customer migration at T-Systems.


Responsibilities:
  • writing PL/SQL loading procedures,
  • creating ad-hoc SQL queries
  • reverse engineering Informatica ETL mappings
2015. July – 2016. Aug   Oracle DWH Developer – Ulyssys Ltd., Budapest
Responsibilities:
  • developing ODI mappings
  • creating ODI scenarios and load plans
  • creating OBIEE Dashboards and Analysis
  • creating and designing RPD (physical layer, business model mapping layer, presentation layer)
Used Technologies: SQL, PL/SQL, Oracle Data Integrator 12.1.3, OBIEE 11g
2015. March – 2015. July External Developer for OTP Bank (3 months project)
Responsibilities:
  • create ad-hoc SQL queries
  • tuning of existing SQL queries
Used Technologies: SQL, PL/SQL
2012. Aug – 2015. Febr             Reporting Analyst – Vodafone Hungary, Budapest
Responsibilities:
  • developing business reports in the tool Business Objects
  • translating business definitions into datawarehousing developing
  • defining ETL processes for reporting
  • creating ad-hoc queries from datawarehouse tables
Used Technologies: Business Objects 3, SQL, PL/SQL
2007. March – 2012. June  Software Developer – CP Consulting Ltd, Budapest
Responsibilities:
  • taking part in the migration of Generali Insurance Company’s datawarehouse from SAS to Oracle
  • incremental developments of MKB Bank’s Oracle-based datawarehouse
  • incremental developments of Vodafone Hungary’s Oracle-based datawarehouse
  • Budapest Bank: taking part in the developing of
OPEX Reporting datamart: 48 reports and a universe created
Used Technologies: PL/SQL, SQL, Oracle Warehouse
Builder 10g (10.2.4), TCL, Oracle Application
Express, Business Objects XI R2/3.1
       2005. Aug – 2007. March Software Developer – General Electric Hungary, Budapest
Responsibilities:
  • datawarehouse designing and developing
  • developing Business Objects reports and universes
Used Technologies: Oracle SQL, PL/SQL, Business Objects Reporter, Business Objects Data Integrator
     
       2000. July – 2005. Aug Software Developer – Siemens PSE Ltd
Responsibilities:
  • Budapest: developing forms and reports for European Space Agency
  • Vienna: developing Oracle-based datawarehouse for European Space Agency
Used Technologies: PL/SQL, Business Objects DESKI, Oracle Forms/Reports 6i
 
        
        1998. Feb – 2000. July Software Developer – Eurotrend Informatics Ltd., Budapest
                                               Responsibilities:
  • design Oracle Forms and Reports integrated into a financial and inventory system

Contact form

Contact details