Bogdan P.

BUSINESS OBJECTS – ORACLE – PL/SQL Integration engineer

Outsourcing
Senior
Bucharest, ROMANIA
Contact us for this profile

My experience

More

Cellular telephone operator01.01.2007 - Present

Stream Leader / Business Intelligence / Data Warehouse Technical Architect within several projects:
- Project which involved multiple business areas: Commercial Expenses Program (Roaming Costs, Interconnect Costs), Interconnect Revenue, Value Based Reporting, Subscriptions & Options Parameterization Module, Number Portability, Change Requests, Fixed Services, Old DWH decommissioning etc. (August 2014 - now)
  • Stream Leader within the team:
- Coordination of the team (business analysis, design, implementation, test, UAT, deploy).
- Recruitment of new team members, training, coaching them as mentor.
- Participation in defining the project roadmap.
  • Design / validation of the business model that enabled the alignment of all KPIs related to Value Based Reporting (including revenue).
  • Technical Architecture: participation in the technical architecture design decisions.
  • Data Modeling: data model reengineering, design / extend the data model (both foundation and data mart).
  • Business Analysis: analyzing the business requirements and translating them into technical design decisions.
  • ETL process reengineering: defining standards and templates to reduce code complexity and speed up development process.
  • Tuning: providing guidance to the ETL team for Oracle performance tuning.
  • Business Intelligence: providing guidelines and design decisions to the BI team to develop/extend current Business Objects universes.
  • Collaboration within a 30-member team.

- Project focusing on the Subscriptions and Options module (January 2013 - July 2014).
  • Stream Leader within the team:
- Coordination of the team (business analysis, design, implementation, test, UAT, deploy).
- Recruitment of new team members, training, coaching them as mentor.
- Participation in defining the project roadmap.
  • Conducting the business/technical analysis phase (discovered many data sources issues that were translated into new business rules/technical design decisions).
  • Conducting the business UAT.
  • Technical Architecture: participation in the technical architecture design decisions.
  • Business Analysis: analyzing the business requirements and translating them into technical design decisions; successfully identified and documented/validated many business rules through in-depth data source analysis and reverse engineering of the old data warehouse ETL.
  • ETL process reengineering: defining standards and templates to reduce code complexity and speed up development process.
  • Tuning: providing guidance to the ETL team for Oracle performance tuning.
  • Business Intelligence: providing guidelines and design decisions to the BI team to develop/extend current Business Objects universes.
  • Collaboration within a 20-member team.

- Project aiming to develop a traffic module (January 2012 - January 2013).
  • Stream Leader within the team:
- Coordination of the development team (design, implementation, test, UAT) / coordination of the Change Requests team (for the already delivered modules).
- Recruitment of new team members, training, coaching them as mentor.
- Participation in defining the project roadmap.
  • Improvement of the performance of the ETL modules by more than 60%.
  • Successful management of the team to obtain the UAT in less than 3 weeks.
  • Technical Architecture: taking an influential role in the overall technical architecture of the data warehouse.
  • Business Analysis: analyzing the business requirements and translating them into technical design decisions.
  • Business Intelligence: responsible for the Full Life Cycle of the Business Objects XI 3.1 platform implementation (architecture, design, implementation, security, audit).
  • Design of the Business Objects Universes.
  • Providing training to Business Objects Power Users in using the related Business Objects Universes.
  • Collaboration within a 15-member team.

- Project focusing on the development of a Customers and Subscribers module (October 2010 - December 2011).
  • Stream Leader within the team:
- Coordination of both the ETL and BI teams to successfully deliver the phase 2 implementation of the data warehouse / coordination of the Change Request team (for the already delivered modules).
- Participation in defining the project roadmap.
  • Successful management of the team to deliver the Phase 2 of the data warehouse implementation.
  • Technical Architecture: taking an influential role in the overall technical architecture of the data warehouse.
  • Collaboration with the project manager to define the scope of the phase 2 implementation of the data warehouse.
  • Business Analysis: analyzing the business requirements and translating them into technical design decisions.
  • Participation in the definition of the overall technical architecture of the data warehouse.
  • Providing overall guidance to the ETL team for Oracle performance tuning (standards definition, performance monitoring, etc.).
  • Responsible for the Full Life Cycle of the Business Objects XI 3.1 platform implementation (architecture, design, implementation, security, audit).
  • Design of the Business Objects Universes.
  • Providing training to Business Objects Power Users in using the related Business Objects Universes.
  • Collaboration within a 15-member team.

Business Intelligence Consultant within a project concerning the development of the subscribers module (April 2010 - September 2010).
  • Analysis of the business requirements.
  • Participation in the Technical Architecture design decisions.
  • Design, implementation, testing and maintenance of the ETL packages (Oracle PL/SQL).
  • In charge of monitoring and tuning the Oracle PL/SQL packages.
  • Responsible for the Full Life Cycle of the Business Objects XI R2 platform implementation (architecture, installation, configuration, security setup, audit).
  • Creation, testing and maintenance of the Business Objects Universes.
  • Design, implementation, testing, publishing and schedule of Business Objects reports (Web Intelligence).
  • In charge of providing training to Business Objects Power Users in using the related Business Objects Universes.

Senior Software Developer (January 2007 - March 2010).
  • Participation in the project management, requirements definition, dimensional modelling, technical architecture design, data staging and deployment.
  • Development and maintenance of the current data warehouse.
  • Data quality monitoring to provide accurate financial figures.
  • Migration of the database from Oracle 9i to Oracle 10g.
  • Database performance tuning.
  • Design, implementation, testing, publishing and schedule of Business Objects reports (Desktop Intelligence).
  • In charge of providing training to Business Objects power users.
More

SITA01.01.2012 - Present

Business Objects Technician.
  • Communication with the client.
  • Analysis and identification of the problems signaled by the client.
  • Identification of the best solutions to solve the problems.
More

Vodafone Roumanie01.01.2006 - 01.12.2006

Senior BI Developer/Analyst.
  • Analysis of the business requirements.
  • Creation of Business Objects ad-hoc reports.
  • Tuning of the Business Objects reports.
  • In charge of providing training to Business Objects power users.
More

Electrical Energy and Gas Distribution Company01.09.2004 - 01.12.2005

Senior Software Developer.
  • Participation in the development of a management application in the field of electricity and gas distribution.
  • Development of the following modules: Negotiation, Contract Management, Billing, etc.
  • Maintenance of the applications.
More

Producer of appliances and equipment01.01.2004 - 01.08.2004

Senior Software Developer.
  • Maintenance of the Data Warehouse.
  • Creation, testing and deployment of Business Objects reports.
  • Administration of the Data Warehouse.
  • In charge of providing support in the decision-making process for the sales and stock control departments.

Participation in the development of the following projects:
- Damage Keying Tool – Software Application for filling replacement forms for the damaged parts of the products (development and maintenance);
- SimuBud - Budget simulation application (development and maintenance);
- Eliane - Portfolio and sales software application used by commercial agents, including as well several web pages for publishing internal news (maintenance);
- Management applications for different departments of the company such as Sales department, Stocks control department etc. (maintenance);
- Applications suite for Data Warehouse department (development and maintenance).
More

Producer of appliances and equipment01.06.2002 - 01.12.2003

Software Developer within a project concerning the development of a software solution for products management.
  • In charge of the following modules: Product Management, Inter Server Import, Data Export, etc.
  • Creation of an application for data import from Lotus Notes to SQL Server.
  • Development of web services for the security module of the application.
  • Development of several other applications such as: an internal web site for bills management, FTP Updater, Static Web Updater.
  • Responsible for application maintenance.
More

Bank01.09.2000 - 01.05.2002

Developer / System Administrator for a company in the banking field:
  • Development of Windows and Web applications.
  • Maintenance of the applications.
  • Network and system administration.
  • Installation and configuration of the computers and network equipment.
  • My stack

    Spoken languages

    FRENCH: Average
    ENGLISH: Advanced
    ROMANIAN: Native speaker

    Networks and systems

    Lotus Notes, MS-DOS, Novell Netware, RedHat, Windows

    Languages

    Delphi, PL/SQL, SQL, ASP, JavaScript, WML, XML

    Technologies

    ActiveX, COM, DCOM, ADO.NET, BDE

    Web technologies

    Applets, Web Services, ASP.NET, CGI, HTML, SOAP

    DBMS

    Oracle, Paradox, SQL Server, MS Access

    Business Intelligence / ETL

    Business Objects, Informatica

    Development Environment

    Visual Studio

    Application servers

    IIS

    My education and trainings

    Bachelor's Degree in Refrigeration and Air Conditioning (in English), Faculty of Mechanics - "Politehnica" University, Bucharest.1995-2000