Profileimage by Anonymous profile, Senior BI Consultant - BO/BW/ORACLE/SAS/PENTAHO/COGNOS

MARIA AVEIRO

available
Contact

Last update: 30.10.2018

Senior BI Consultant - BO/BW/ORACLE/SAS/PENTAHO/COGNOS

Graduation: Informatics Engineer
Hourly-/Daily rates: show
Languages: English (Full Professional) | French (Limited professional) | Portuguese (Full Professional) | Spanish (Native or Bilingual)

Keywords

SAP SAP BW SAS SSIS SQL SAP BI SAS Base Forecase Data Analyst Cognos Business Intelligence SQL Server Oracle MySQL SAP Business Objects Datawarehouse Data Integration Data generation Data Mining

Skills

Extract
Information Technologies Engineer (BAC+5) and Master on Business Administration (MBA), expert in Business Intelligence with 12 years of experience in BI platforms and data integration projects.
Portuguese national.

Academic Experience
•    Master Data Governance – in progress.
•    MBA - Master Business Administration (2015) – "Metropolitana" University.
•    Master IT Engineer (BAC+5) (2006) – "Alejandro de Humboldt" University.
Professional Experience
•    Senior SAP BI Consultant - May 2017 to Present at Sword Group, Luxembourg.
SAP BI ambassador in DG Energy, leading Data Integration and Data Governance strategies to guarantee data quality, availability, usability, consistency and security ensuring that the data can be used by the entire DG. Responsible for:
o    All the data integration between source systems (RRHH, MM, DM) and data warehouse to assure all the information is displayed by SAP Business Objects.
o    Manage all the projects, maintenance and requests about the BI infrastructure (Oracle ETLs, Business Objects and Tableau for reports and dashboards).
o    Being the link between the business and the technical area to understand the needs and the technical capacity to deliver the solution.
•    Senior SAP BI Consultant - Dec 2014 to Apr 2017 at Bayer Euroservices, Barcelona, Spain and Köln, Germany.
Worked with the BI global team, support our local and global internal customers in data analysis, regular incidences, and new developments in R&D Profit Projects and SAP COPA (Profitability Analysis). Responsible for:
o    Translate functional analysis into BI solutions.
o    Lead and track technical solutions in SAP Business Warehouse (BW) and SAP Business Objects (BO) with an our outsourced team in India.
o    Agile methodology

•    Senior SAP BI Consultant - Sep 2013 to Nov 2014 at NCG Network Consulting Group S.A., SAP partner, Caracas, Venezuela.
o    Client: "Excelsior Gama" (Fast-moving consumer goods and retail)
Project SAP BO 4.1 Implementation:
Design a new multidimensional model (universe) and Bex Queries from BW source and Microsoft SQL Server data sources. Create reports and dashboards as P&L, Product Hierarchies, Distributions, Stock control and inventory. Assist to Basis team in configuration and installation of SAP Business Objects in Windows Server 2008, Linux Red Hat and Linux Suse.

o    Client: "Ovejita" (Retail)
Project SAP BO 4.0 Implementation:
Build ETL process with BODS to BW and create a new multidimensional model (universe) from Microsoft SQL Server and BW sources. Create reports and dashboards as Scorecards Analysis, Commercial Management, Inflation adjustment, Marketing and Sales.

o    Client: Vepica (Engineering, Procurement and Construction)
SAP BO 4.0 Maintenance:
Create Balanced reports for forecasting, planning and identify areas to improve in BO reports and universe.
•    Data Mining Consultant - Sep 2010 to Sep 2013 at Telefonica Movistar, VP Marketing (International Telecom Company), Infosoft C.A., Caracas, Venezuela.
Responsible for tuning, execute and optimize data extraction process with Oracle PL/SQL and T-SQL queries, creation of Microsoft SQL Server DTS, SAS Data packages, ETLs on Datastage, extract and calculate relevant KPIs related with marketing and sales, finance information. Supported internal customers on the creation of Business Objects reports, analysis and relevant insights related to customer evolution, project costs structure, sales and marketing campaigns.

•    Business Intelligence Specialist - May 2006  to Sep 2010 at Movilnet, CANTV (National Telecom Company), Caracas, Venezuela.
Responsible for universes and ETL process in Oracle and MySQL, creation of basic and advanced BI reports and dashboards in Business Objects, Cognos, SAS and Pentaho with commercial, operative, marketing and cost KPIs. Also administrator of the SAP Business Objects Central Management Console (CMC), responsible for the content and security on folders, categories, connections, servers, groups and users. Technologies: Business Objects 11.5, SAP Business Objects 3.0, Cognos 8, SAS and Pentaho. Kimball DW and ITIL methodologies.

Trainings
•    Tableau - Euroservices Bayer, S.L. (2017)
•    SAP HANA Basic - Euroservices Bayer, S.L. (2016)
•    BW Bex Queries and AO Reporting – Euroservices Bayer, S.L. (2015)
•    BW Modeling – Euroservices Bayer, S.L. (2015)
•    ABAP Programming – Euroservices Bayer, S.L. (2015)
•    DataStage Advanced - Infosoft C.A. (2013)
•    Microsoft SSIS, SSAS and SSRS 2008 - Infosoft C.A. (2013)
•    SAS Enterprise Miner – Infosoft C.A. (2011)
•    SAS Enterprise Guide – Infosoft C.A. (2011)
•    SAS Basic Fundamentals – Infosoft C.A. (2011)
•    Crystal Reports – Softrain (2010)
•    SAP Business Objects Excelsius Enterprise 2008 - Corporación Cipher (2010)
•    SAP Business Objects for SAP NetWeaver BI – Entrus Consultores (2010)
•    ITIL Fundamentals – AITIL (2009)
•    MySQL Intermediate - EDA Consultores (2009)
•    Oracle Database 10g: SQL tunning - EDA Consultores (2009)
•    Reporting Solution Development with Pentaho – Matrix CPM Solutions (2008)
•    Cognos 8 Bi Content Administration – Latino BI (2008)
•    Cognos 8 Bi Metadata Modeling – Latino BI (2008)
•    Cognos 8 Bi Server Administration – Latino BI (2008)
•    Oracle Data warehouse Fundamentals - Dimensional models – EDA Consultores (2007)
•    Oracle Data warehouse Design - Dimensional models – EDA Consultores (2007)
•    Business Objects Dashboard Manager XI R2 – Consultores Aconte (2006)
•    Business Objects Web Intelligence XI R1/R2: Report Design – Consultores Aconte (2006)
•    BO XI R1/R2: Universe Design – Consultores Aconte (2006)
•    BO Enterprise XI R2 Administering Users and Content with CMC – Consultores Aconte (2006)
•    E-Business Development Program IBM ACE (2005 - 2007) – IBM / MCT
Languages
•    English - Advanced
•    Spanish - Native
•    Portuguese - Intermediate
•    French – B2.1 in progress
Certifications
•    International Business Management –"Metropolitana" University – (2010 - 2012)
•    Information Technologies Management – "Metropolitana" University – (2010 - 2012)
•    Production Management – "Metropolitana" University – (2010 - 2012)
•    Management Formation – "Metropolitana" University – (2010 - 2012)
•    Java Application Development – IBM ACE - Application Development Program: Object-Oriented, Database, and Web Programming, Enterprise Application Development – (2007)
•    Java Programming Fundamentals – IBM ACE - Application Development Program: IT fundamentals, Programming Essentials, Object Oriented, Java and DB Programming – (2006)



 

Project history

Projects
  • Upgrade BW to Business Objects 4.0 at Ovejita C.A. – NCG, 2013-2014.
Role: BO Developer, BO Administrator, Trainer. Technologies: SAP Business Objects 4.0 and BW 7.3
  • Support to Vepica in Business Objects 4.0 – NCG, 2013-2014.
Role: BO Developer, BO Administrator, Trainer. Technologies: SAP Business Objects 4.0 and BW 7.3
  • Upgrade Business Warehouse to Business Objects 4.1 at Excelsior Gama – NCG, 2013-2014.
Role: BO Developer, BO Administrator, Trainer. Technologies: SAP Business Objects 4.1 and BW 7.3
  • Simide Project - CANTV
Role: BO Developer, BO Administrator, ETL’s Developer. Technologies: Business Objects 11.5, SAP Business Objects 3.0, Pentaho Reporting, Pentaho Kettle, MySQL, PostgreSQL.
  • Datamart Project (2009) - CANTV
Role: SAS BI Developer, SAS BI Administrator. Technologies: SAS BI
  • Certus Project (2007 - 2008) - CANTV
Role: Cognos Developer, Cognos Consultant. Technologies: Cognos 8 BI: Data Manager, Analysis Studio, Report Studio, Query Studio.
  • Reta Project (2006 - 2008) - CANTV
Role: BO Developer, BO Administrator, ETL’s Developer. Technologies: Business Objects 11.5, Linux Red Hat, Oracle 9i, Data Integrator Business Objects 11.5

Time and spatial flexibility

Available for remote jobs.

Other

Training
  • SAP Hana Basis – Euroservices Bayer, S.L. (2016)
  • Big Data – Coursera (in progress)
  • BW Bex Queries and AO Reporting – Euroservices Bayer, S.L. (2015)
  • BW Modeling – Euroservices Bayer, S.L. (2015)
  • ABAP Programming – Euroservices Bayer, S.L. (2015)
  • DataStage Advanced - Infosoft C.A. (2013)
  • Microsoft SSIS, SSAS and SSRS 2008 - Infosoft C.A. (2013)
  • SAS Enterprise Miner – Infosoft C.A. (2011)
  • SAS Enterprise Guide – Infosoft C.A. (2011)
  • SAS Basic Fundamentals – Infosoft C.A. (2011)
  • Crystal Reports – Softrain (2010)
  • SAP Business Objects Excelsius Enterprise 2008 - Corporación Cipher (2010)
  • SAP Business Objects for SAP NetWeaver BI – Entrus Consultores (2010)
  • Fundamentos de ITIL – AITIL (2009)
  • MySQL Intermediate - EDA Consultores (2009)
  • Oracle Database 10g: Entonación de Comandos SQL - EDA Consultores (2009)
  • Reporting Solution Development with Pentaho – Matrix CPM Solutions (2008)
  • Cognos 8 Bi Content Administration – Latino BI (2008)
  • Cognos 8 Bi Metadata Modeling Part 1 – Latino BI (2008)
  • Cognos 8 Bi Server Administration – Latino BI (2008)
  • Data warehouse Fundamentals – EDA Consultores (2007)
  • Data warehouse Design – EDA Consultores (2007)
  • Business Objects Dashboard Manager XI R2 – Consultores Aconte (2006)
  • Business Objects Web Intelligence XI R1/R2: Report Design – Consultores Aconte (2006)
  • BO XI R1/R2: Universe Design – Consultores Aconte (2006)
  • BO Enterprise XI R2 Administering Users and Content with CMC – Consultores Aconte (2006)
  • E-Business Development Program IBM ACE (2005 - 2007) – IBM / MCT
Certifications
o    “Application Development - IBM Advanced Career Education e-business Application Development Program: Object-Oriented, Database, and Web Programming, Enterprise Application Development” – (2007)
o    “Programming Fundamentals - IBM Advanced Career Education e-business Application Development Program: IT fundamentals, Programming Essentials, Object Oriented, Java and DB Programming” – (2006)

Contact form

Contact details