SAP BODS, BW, BOBJ, Information Steward

Diego Alejandro Bedoya Salazar

SAP Senior BODS Information Steward DQM Data Specialist Consultant

Phone: +57 4 5708876

Mobile: +57-300-***-****

E-mail: ***********@*****.***

Medellin – Colombia

Profile

SAP EIM professional consultant with 10 + years of total experience, 5+ years in SAP DataServices, 1+ years in SAP Information Steward, +3 years in data governance and data quality, with exposure in data migration with toolset like SAP Data Services, SAP BW, Pentaho and Teradata, experiencie using both SAP Data Services and SAP Information Steward for Data Quality and Data Profiling. Also versed in SAP MDM used like master data repository.

Installation, configuration, administration and upgrading on both SAP DataServices (BODS) and SAP Information Steward (BOIS) servers.

SAP BO Admin servers using CMC and console utilities.

Worked developing, configuring and maintaining, in both SAP BODS and SAP BOIS, data quality rules, data profiling rules and dashboard setup, for one or multiple information systems.

Good understanding in SAP BOIS Data Insight module along with other modules like metapedia, metadata management & cleansing package builder.

Worked developing, configuring and maintaining, in SAP BODS, data extraction, transformation and loading for different databases like Oracle, Teradata, DB2, Sybase ASE and MSSQL, and different applications like JD Edwards, SAP R/3, SAP CRM, SAP SRM, SAP BW and SAP MDM.

Experience using all kind of SAP BODS transformations like Data Integrator, Data Quality and Basic Transforms.

Experience in performance optimization on both SAP BODS batch and real time jobs.

Experience using SAP BODS and NON SAP job schedulers (Like Tivoli, Windows task manager and Unix Schedulers)

Data Architect experience.

ETL Architect experience.

Team lead experience.

Experience defining, designing and setup on SAP BO data visualization tools like WEBI, Analysis for Office, Analysis for OLAP, Xcelsius (Dash Board Design), Lumira and Explorer. Also experience in SAP Predictive Analysis.

Experience in SAP SYBASE tools like SRS and Power Designer. Also in SAP Sybase ASE database.

Experience as a data governance consultant in explaining, defining and enhancement DG initiatives.

Experience on implementing Data Governance initiatives on both SAP BODS and SAP BOIS.

SAP Knowledge Base: SAP EIM-Information Steward Solution 4.0 & SAP EIM- SAP Data; SAP BOBJ Solution, SAP BO Reporting Solutions; SAP BO Reporting, Universe Design, SAP BO Admin work for roles and user creation

Services V 3.2, 4.0, 4.1 & 4.2, Migration/DQ/DI, SAP BO/DS Admin Activities.

Expert in managing Data Quality, Data Migration Concept and used SAP Data Services as ETL Tool for Conversion Process using BAPI, IDOCs, and LSMW/ISMW techniques.

SAP BODS, BOIS and BOBJ installation exposure.

Experience in MDM Server, Data Manager, Import Manager and Syndicator; good understanding in Data profiling, Matapedia, Data quality dashboards, etc.

Experience on training in both SAP BODS and SAP BOIS tools.

Experience on training in data visualization concept and best practices.

Experience on pre-sales SAP Solutions (Technical specialist)

Practical experience on DI, DQ & Platform Transforms like Query, Case, Merge, Validate, Table Comparison, History Preservation, Match and Merge, Row Generation, Key Generation, Address Cleansing, so on Languages, DB & Software: SQL/PL SQL, Sybase IQ, Oracle, MS SQL Server, MS- Office Suite

Areas of Interest: SAP Lumira, Predictive analysis & SAP HANA, Admin Activities, Business Consulting

Great willingness for self studying initiatives. Project Experience – Detail

Customer Grupo SURA

Duration Jun of 2016 – now (3 Months)

Industry Insurance

Project Description POC Integration BODS – SFDC – PostgreSQL – Oracle - Teradata Function SAP BODS / BODI Information Steward Consultant Responsibilities/

Deliverables

- Actually as a BODS/BOIS consultant includes labors in POC for integration between SalesForce.com, Teradata and PostgreSQL using BODS.

- Configuration of BODS/BOIS server adapter REST services for a 3d part company integration in order to make adress validation and enrichment.

- Help on different BODS issues on demand.

- Responsible of guide the basis team for instalation in development environments the Teratada tools and utilityes for SAP BODS/BOIS server.

- Responsible of guide the basis team for configurtation in development environments the Teratada tools and utilityes and ODBC for SAP BODS/BOIS server.

- Responsible of guide the basis team for configuration in development environments the PostgreSQL ODBC driver and connection for SAP BODS/BOIS server.

- Responsible of setup the BODS JOB test scenarios for integrate SFDC, PostgreSQL, Oracle and Teradata.

- Responsible to setup SAP BODS/BOIS data connection.

- Responsible to setup and documented SAP Information steward connection with PostgreSQL and Teradata.

Customer Comfama

Duration May of 2015 - now. (17 Months)

Industry PUBLIC SECTOR, CONSTRUCTION, EDUCATIONAL, HEALTH, TOURISM, ETC Project Description Mantaining SAP BW structures and configurations. Function SAP BW Consultant.

Responsibilities/

Deliverables

- Actually as Professional Services Consultant in SAP BW includes labors like configuration, development and maintenance for existing and new implementations.

- Actually my rol includes manteinance of BI solution for subsidy program, includes review of SAP ABAP code in SAP R/3 for customized extraction of data, SAP BW structures and SAP BO webi reports.

- Actually my rol includes re-engineering of BI solution for financials, includes review of extractors, and replacement of SAP BW structures. Finally create new SAP BO webi and analysis reports.

- Strong knowledge and experiencie on FI and PSCD extractors on ERP and modeling in BW for Leading and non-leading ledger.

Customer PREMEX

Duration July 2015 – November 2015. (5 months)

Industry Health and Nutrition

Project Description Data integration

Function Business Intelligence specialist

Responsibilities/

Deliverables

Responsible of define Business Intelligence Process road map to be implemented in company, capturing requirement, defining infrastructure, defining data architecture, project plan.

Architecture was proposed using SAP BODS and SAP BO Webi and Dashboard Design as whole solution. Also Data integrator solution using SAP BODS.

Responsible of define data integration and visualization steps and path using SCRUM methodology.

Responsible of coordinate meetings wiith client leads and managers to negotiate and definitions on initial requirements.

Customer Municipio de Medellín

Duration March of 2015 – April 2015. (2 months)

Industry Government

Project Description Health KPI

Function SAP BO – BW Consultant

Responsibilities/

Deliverables

- POC for display Health KPI using SAP BW and SAP BO Crystal Dashboard Design. My responsabilityes includes define extraction routines from Oracle for a sample set of data and stablish SAP BW connectivity with the source, creation of SAP BW structures and SAP BO Crystal Dashboard for visualize the KPI. Also define the economical propose, project plan, meeting wiith client leads to negotiate and definitions on initial requirements.

Customer Almacenes Olimpica

Duration Feabruary 2015 – March 2015. (2 months)

Industry Retail

Project Description Security roles integration

Function SAP Data Consultant

Responsibilities/

Deliverables

- As a presales engineer I was responsible on creating a offer for data integrator solution between SAP R/3 and a customized solution using SAP BODS.

- I was data Integration architect to define strategy to integrate the data.

- Also conduct meetings with client leads to define initial requirements and define project plan.

Customer San Vicente Fundación

Duration January 2015 – March 2015. (4 months)

Industry Health

Project Description Data governance pilot

Function SAP Data governance specialist

Responsibilities/

Deliverables

- POC using Pentaho Data Integrator for data quality evaluation of data in SAP R/3.

- Responsible of Socialization on data governance terms and benefits.

- I helped client on defining data governance structures, team skills for each level.

- I helped client on defining critical fields and information and data quality rules.

- Responsible of install Pentaho Data Integration and Pentaho BI Server, setup connection to SAP R/3.

- I was responsible on setup generic estractor in SAP R/3, extract and load data in MySQL DB, setup and execute data quality rules.

- Responsible of setup data quality dashboard.

Customer Industrias HACEB

Duration February 2015. (1 month)

Industry Manufacturing

Project Description Data quality evaluation

Function SAP Data Governance Consultant

Responsibilities/

Deliverables

- Responsible of data quality evaluation master data before migrating data to SAP R/3, using Pentaho Data Integrator.

- Responsible of socialization on data governance terms and benefits.

- Responsible of configure a solution to extract and load data in MySQL DB, setup and execute data quality rules.

Customer Policía Nacional de Colombia – Grupo Aeronautico Duration January 2015. (1 month)

Industry Aeronautical

Project Description KPI aeronautical manteinance initiative Function Business Intelligence Consultant

Responsibilities/

Deliverables

- As a Presales engineer I was responsible on offer a solution for Aeronautical Group of National Police using SAP BW, include a brief POC for SAP MM. Includes define standar extractors between SAP R/3 and SAP BW, test extractor and creation of SAP BW structures.

- Responsible of Socialization on business intelligence terms and benefits.

- Also I was responsible on define the economical propose, project plan, meeting wiith client leads to negotiate and definitions on initial requirements. Customer Metro de Medellín

Duration December 2014. (1 month)

Industry Transport

Project Description Data quality evaluation

Function SAP Data Governance Consultant

Responsibilities/

Deliverables

- Responsible of Data quality evaluation of MM module data in SAP R/3, using Pentaho Data Integrator.

- Responsible of Socialization on data governance terms and benefits.

- Responsible of Setup generic extractor in SAP R/3, extract and load data in MySQL DB, setup and execute data quality rules.

- Responsible of Setup data quality dashboard.

Customer Grupo SURA

Duration November 2014 – December 2014. (2 Months) Industry Insurance

Project Description Master Data Management capacitation Function SAP BODS / BODI Information Steward Instructor Responsibilities/

Deliverables

- Instructor on S.A.P. Business Objects Data Services, S.A.P. Business Objects Information Steward, Principles on Data Warehouse, ETLs, DataProfiling and DataQuality, includes Basic, Data Integration and Data Quality transforms, Data Insight module, Data Profiling, Data Quality rules, Dashboard creation and actualization, Job scheduling, etc.

- Also the course was following the official SAP certification manuals for both SAP BODS and SAP BOIS.

- I teached SAP DataServices for 8 people group.

Customer Perceptio

Duration November 2014. (1 Month)

Industry Consulting

Project Description SAP BODS / BOIS Academy

Function SAP BODS / BOIS Information Steward Instructor Responsibilities/

Deliverables

- I was Instructor on S.A.P. Business Objects Data Services, S.A.P. Business Objects Information Steward, Principles on Data Warehouse, ETLs, DataProfiling and DataQuality, includes Basic, Data Integration and Data Quality transforms, Data Insight module, Data Profiling, Data Quality rules, Dashboard creation and actualization, Job scheduling, etc. Also the course was following the official SAP certification manuals for both SAP BODS and SAP BOIS.

- I teached SAP DataServices for 3 people group.

Customer Grupo Crystal

Duration November 2014. (1 Month)

Industry Manufacturing and selling

Project Description SAP BODS Capacitation

Function SAP BODS Instructor

Responsibilities/

Deliverables

- I was Instructor on S.A.P. Business Objects Data Services tool, includes Basic, Data Integration and Data Quality transforms, Data Profiling, Data Quality rules, Job scheduling, etc. Also the course was following the official SAP certification manuals for SAP BODS.

- I teached SAP DataServices for 6 people group.

Customer Grupo SURA

Duration October 2013 – October 2014. (13 Months)

Industry Insurance

Project Description Master Data Information Steward Management Function SAP DataServices senior consultant, SAP Information Steward senior consultant, SAP Information Steward / Data Services Team Lead, SAP BODS Information Steward Consultant & SAP Information Steward Admin Activities, Data Governance Consultant.

Responsibilities/

Deliverables

- Responsible of SAP DataServices instalation in development, quality and production environments.

- Coodination of SAP BODS / BOIS onsite – offshore team.

- Led 5 Junior and 2 semi-senior offshore team

- Responsible to setup SAP BODS data connection.

- Responsible of SAP Information Steward instalation in development, quality and production environments, solution on current landscape for data profiling activities

- Responsible to setup and documented SAP Information steward connection with SAP R/3, DB.

- Formed matrix for basic colum level profiling rules. Also non basic profiling as well like Uniqueness, Address, etc.

- Worked to create business rules in “Data Insight” module of SAP information steward and these rules were quality check rules for business users

- Worked to creating the DQ rules and binding them with views in order to generate the dashboard

- Performed some comparison analysis for global fields across various systems with the help of SAP IS tool. Worked closely with business users

- Responsible for designing documents which includes configurations, technical specification & testing document and updating them time to time.

- Played various roles during this whole Information governance initiative for client

- Technical environment – SAP DS 3.2, SAP Info Steward 4.0, SAP ECC, SAP CRM etc.

- Responsible of implementation of the Master Data Management pilot process for master customer management using SAP Business Objets Data Services (Data Quality and Data Integrator) and SAP Business Objects Information Steward in SURA Business Group. Setup of BODS and Information Steward server on development, quality and production Environments, using cluster in production.

- Responsible of SAP BODS 4.2, SAP MiniBOE 4.0, SAP BODI 4.0 and Oracle DB Installation under unix based OS. Also configuration and monitoring server resources.

- Responsible of SAP Information Steward administration using CMC.

- Responsible of SAP DataServices administration using CMC and SAP BODS Management Console.

- Responsible of SAP BODS developing real time and batch jobs Using Basic, Data Integrator and Data Quality transformations.

- Responsible of SAP Information Steward data sources configuration to SAP and Non SAP sources like Oracle DB 11g and 12g, MSSQL Server 2008R2, MySQL server 5.2, SAP R/3, SAP SRM, SAP CRM, SAP Sybase ASE DB.

- Responsible of SAP DataServices data sources configuration to SAP and Non SAP sources/destinations like Oracle DB 11g and 12g, MSSQL Server 2008R2, MySQL server 5.2, SAP R/3, SAP MDM, SAP SRM, SAP CRM, SAP Sybase ASE DB, SAP Sybase Replication Server, SalesForce, IBM Integration Bus (ESB), IBM Business Process Manager, SAP Process Integrator.

- Responsible of SAP Information Steward Data Insight configuration like basic Data Quality rules configuration or advanced rules creation, also execution and automatization; Data Profiling, Data Cleanse, Scorecard Setup. Also Metapedia, Metadata Management and Cleansing Package Builder.

- Played part in installation of SAP Sybase ASE DB, SAP Sybase Replication Server and SAP MDM.

- Responsible of coordinate meetings with client leaders to define the diferent stages of Data Governance Process in detail.

Customer Grupo Crystal

Duration March 2013 – October 2013. (8 months)

Industry Manufacturing and sales

Project Description Data governance program

Function SAP Data quality consultant

Responsibilities/

Deliverables

- Responsible for implementation of the Data Governance pilot process for Parts Area using SAP Business Objets Data Services (Data Quality and Data Integrator) and MSSQL Server Reporting Tools.

- Responsible of SAP BODS 4.1 server installation on development and production Environments.

- Responsible of SAP BODS 4.2, SAP MiniBOE 4.0 and DB2 10 DB Installation under unix based OS. Also configuration and monitoring server resources.

- Responsible of SAP BODS management using CMC and SAP BODS Management Console.

- Responsible of SAP BODS developing batch jobs Using Basic, Data Integrator and Data Quality transformations.

- Responsible of SAP BODS data sources configuration to SAP and Non SAP sources/destinations like Oracle DB 11g and 12g, MSSQL Server 2008R2, MySQL server 5.2, SAP R/3, SAP Process Integrator and Informix DB.

- Responsible of coordinate with client leaders to define the diferent stages of Data Governance Process in detail.

Customer Satrack

Duration January 2013 – March 2013. (3 Months)

Industry Satellital Monitoring

Project Description Business Intelligence

Function SAP Profesional Services Consultant

Responsibilities/

Deliverables

- Responsible of defining Business Intelligence Process road map to be implemented in company, capturing requirement, defining infrastructure, defining data architecture, project plan.

- Responsible of define architecture, as well architecture was proposed using SAP BODS and SAP BO Webi and Dashboard Design as whole solution.

- Responsible of defining data integration and visualization steps and path using SCRUM methodology.

- Responsible on coordinate meeting with high level client leaders and managers to define the diferent stages of Business Intelligence Process in detail. Customer Novaventa

Duration June 2011 – December 2012. (19 Months)

Industry Direct sales

Project Description Business Intelligence

Function SAP BODS Lead

Responsibilities/

Deliverables

- Led 3 junior staff team

- Developers lead for Implementation of data warehouse, data modeling, ETL’s and Instructor on SAP BODS 3.XI.

- Responsible of Data Architect of Data Warehouse solution.

- Responsible of develops on SAP Data Services, using batch jobs with Basic, Data Integrator and Data Quality transformations.

- Responsible of SAP DataServices data sources configuration to Non SAP sources/destinations like DB2 DB.

- Responsible on coordinate meeting with client leaders to define the diferent stages of Business Intelligence Process in detail.

Customer Servicios Nutresa

Duration March 2012. (1 Month)

Industry Direct sales

Project Description SAP BODS Capacitation

Function SAP BODS Instructor

Responsibilities/

Deliverables

- I was Instructor on S.A.P. Business Objects Data Services tool, includes Basic, Data Integration and Data Quality transforms, Data Profiling, Data Quality rules, Job scheduling, etc. Also the course was following the official SAP certification manuals for SAP BODS.

- I teached SAP DataServices for 8 people group.

Other Related Experience

Undestanding on: MDM process syndication, MDM server installation, import manager. Data governance process.

Data visualization.

Instructor.

Professional Experience & Certification – Detail

- Teradata 12 Certified Professional 2010-Nov-26 LRYPY7TKKN11YH3D General Information

Education - BOBJ/SAP Business Objects: WEBI, Crystal Reports, Dashboard Design, Business Explorer, Analysis. Comfama (2016). Medellin – Colombia.

- Magister in Technologies of Information and Communication. Universidad Pontificia Bolivariana (2016). Medellin – Colombia.

- SAP BW (TBW10-30-50-55-60-65, BW360). Self study 2015.

- Second Colombian Congress of Business Inteligence. Universidad Pontificia Bolivariana (2014). Medellín – Colombia.

- First Colombian Congress of Business Inteligence. Universidad Pontificia Bolivariana (2013). Bogotá – Colombia.

- Business Intelligence Specialization. Universidad Pontificia Bolivariana (2013). Medellin – Colombia.

- BODS10-20-30/SAP Data Services: Fundamentals, Data Integrator Transforms, Data Quality Transforms. Perceptio (2011). Medellin – Colombia.

- TEO121-122-123/Teradata 12 Basics, SQL, Physical Design and Implementation. Teradata Colombia (2009). Medellin – Colombia.

- Systems Engeneering. Universidad de Antioquia (2008). Medellin – Colombia. Graduated with honors.

Citizenship Colombian

Languages Spanish (Native)

English (Fluent)

Contact this candidate