JA

John Avendano

available

Last update: 11.05.2017

SAP BI / BO / BW / SSM / Data Services Consultant

Graduation: Systems and Computing Engineer with ITIL Foundations certification and Business Intelligence experiencie
Hourly-/Daily rates: show
Languages: English (Full Professional) | French (Elementary) | Spanish (Native or Bilingual)

Attachments

curriculum-vitae-john-avenda-o--latest-version-2017-.docx

Skills

EXPERIENCE

  • Administration of SAP BusinessObjects Business Intelligence Platform tools such as Web Applications (BI Launch Pad), SAP BusinessObjects Explorer and Analysis Edition for OLAP.
  • Functional design and development of items from SAP BusinessObjects Business Intelligence Platform suite such as universes (using Information Design Tool), reports (using Web Intelligence and SAP Lumira) and dashboards (using SAP BusinessObjects Dashboards and SAP BusinessObjects Design Studio).
  • Administration of key performance indicators, dashboards and balanced scorecard using SAP BusinessObjects Strategy Management.
  • Installation and configuration of SAP BusinessObjects Business Intelligence Platform under AIX and Windows operating systems.
  • Creation and activation of extractors, infosites, infocubes, business contents, process chains, data transfer processes, Data Source Objects and composites, as also the development and validation of queries and reports using SAP BI / BW and SAP HANA.
  • Definition of extracting, transformation and data loading (ETL) processes using SAP Data Services, IBM Datastage and Microsoft SQL Server Integration Services.
  • Analysis, Design, Development, Deployment and Administration around Data Warehouses.
  • Database administration using IBM DB2, Microsoft SQL Server, Oracle, SAP Sybase and MySQL.
  • Analysis and Data mining using SAS Enterprise Guide.
KNOWLEDGEMENT
  • Functional validation applied to SAP ERP modules like Advanced Planning and Optimization (APO), accounting and financial management (FI), procurement management (MM), cost management (CO) and project management (PS).
  • Functional and technical validation of profitability and costing models using SAP BusinessObjects Profitability and Cost Management (PCM).
  • System configuration and operation to correct and detect found errors into SAP ERP, BI, BW, BusinessObjects and Data Services components using SAP Solution Manager.
  • Enterprise Architectures definition using TOGAF Version 9 and Zachman frameworks.

CERTIFICATIONS
  • SAP CERTIFIED TECHNOLOGY ASSOCIATE CONFIGURATION AND OPERATION FOR SAP SOLUTION MANAGER. LICENSE S00141236567.  SAP.  2015.
  • ITIL FOUNDATIONS V. 3 CERTIFIED. APM Group. 2010.
POSTGRADUATED AND UNIVERSITY EDUCATION
  • INFORMATION SYSTEMS AT ORGANIZATION SPECIALIST.  Universidad de Los Andes. Bogotá D.C Colombia. 2008.
  • SYSTEMS AND COMPUTING ENGINEER. Escuela Colombiana de Ingeniería. Bogotá D.C Colombia.  2002.
LANGUAGES
  • ENGLISH
    • Dudley College. Dudley, West Midlands, England, United Kingdom. January 2002-June 2002.
    • Wall Street Institute. Bogotá D.C Colombia. December 1997 - June 2000.
OTHER COURSES
  • DEVELOPMENT PROJECT MANAGEMENT. Inter-American Development Bank. July 2015-August 2015.
  • SM100 SAP SOLUTION MANAGER CONFIGURATION FOR OPERATIONS. SAP Colombia. April 2015.
  • SAP BI BW DEVELOPER BEGINNERS LEVEL.  CVOSOFT IT Academy Argentina.  January 2013-March 2013.
  • BOW320 SAP BUSINESSOBJECTS WEBINTELLIGENCE ADVANCED REPORT DESIGN /SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM. SAP Academy Colombia. October 2012.
  • BOID10 SAP BUSINESSOBJECTS INFORMATION DESIGN TOOL / SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM. SAP Academy Colombia. October 2012.
  • BOE320 SAP BUSINESSOBJECTS BUSINESS ENTERPRISE ADMINISTERING SERVERS / SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM. SAP Academy Colombia.  September 2012.
  • BOE310 SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM: ADMINISTRATION AND SECURITY. SAP Academy Colombia. September 2012.
  • BOW300 SAP BUSINESSOBJECTS WEBINTELLIGENCE REPORT DESIGN I / SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM. SAP Academy Colombia. September 2012.
  • TALENT STRATEGY MANAGEMENT FOR ORGANISATIONAL TRANSFORMATION. Universidad EAN. June 2012-August 2012.
  • SSM310 SAP BUSINESSOBJECTS STRATEGY MANAGEMENT / SAP BUSINESSOBJECTS ENTERPRISE PERFORMANCE MANAGEMENT. SAP Colombia. July 2012-August 2012.
  • BOI300 SAP BUSINESSOBJECTS DATA SERVICES / SAP BUSINESSOBJECTS ENTERPRISE INFORMATION MANAGEMENT. SAP Colombia. June 2012.
  • ENTERPRISE ARCHITECTURE COURSE. Escuela Colombiana de Ingeniería. April 2011-May 2011.
  • ITIL FOUNDATIONS V.3. Fundación de Egresados de la Universidad Distrital Francisco José de Caldas. November 2009-December 2009.

Project history

SOPHOS SOLUTIONS SAS.  TECHNICAL CONSULTANT
Technical Consultant for banking sector using extraction, transformation and data loading tools using IBM Datastage, as also the design of reports and dashboards using SAP BusinessObjects portfolio tools.
CONSULTORIA ORGANIZACIONAL S.A.  SAP BI / BO / BW CONSULTANT.
Business Intelligence Consultant in charge of SAP BW functional and technical administration for CAFAM.
Data Source Objects and Composites building into SAP BW and SAP HANA environments, that use like information source SAP APO module and BEx queries development, which are used to build dashboards using SAP BusinessObjects Dashboards and Design Studio for Ecopetrol.
IBM.  IT SPECIALIST.
Technical consultant of Business Intelligence tools (SAP and non-SAP), which are implemented either new or existent customers. Executor of Incident Management and standard requirements that affect SAP BusinessObjects tools functionality, which has been implemented into several clients from the organisation.
PERCEPTIO S.A.S.  BASIS SAP BUSINESSOBJECTS CONSULTANT.
Technical and Functional consultant of tools that conform SAP BusinessObjects portfolio.  Linux, AIX and Windows servers management for IBM Colombia, where are deployed SAP BusinessObjects portfolio products like Data Services (BODS), Business Intelligence Platform (BIP) and Profitability and Cost Management (PCM).
ACTUALISAP CONSULTORES (IN BANKRUPT).  SAP BUSINESS INTELLIGENCE CONSULTANT.
Responsible of consulting and project implementation using SAP BusinessObjects Business Intelligence Platform and SAP Business Warehouse.
BANCO AGRARIO DE COLOMBIA.  BUSINESS INTELLIGENCE ARCHITECTURE PROFESSIONAL.
Responsible of SAP BusinessObjects BI Platform and SAP BusinessObjects Strategy Management architecture, together to its interaction with several information systems, which provide data for Production Data Warehouse. It is leaded and executed by Planning and Corporate Development Vicepresidence.

Local Availability

Only available in these countries: Colombia
I am available to work either European Union or Canada.
Profileimage by John Avendano SAP BI / BO / BW / SSM / Data Services Consultant from SAP BI / BO / BW / SSM / Data Services Consultant
Register