Experience

• 

  Grupo AlEn

  • Sap Business Intelligence Consultant

    • Oct 2020 - Feb 2021

• 

  Secretaría de Coordinación General de Gobierno

  • Tegucigalpa, Honduras

  • SAP BusinessObjects Consultant

    • Aug 2018 - Feb 2020
    • Tegucigalpa, Honduras

    Actualizacion de la version de SAP BusinessObjects de 4.0 a 4.2. Migracion de todos los elementos de Inteligencia de Negocios. Capacitacion al usuario final sobre la nueva funcionalidad de la version 4.2

• 

  Grupo Diagnóstico Proa

  • Mexico City Area, Mexico

  • SAP BusinessObjects Consultant

    • Jul 2017 - Apr 2018
    • Mexico City Area, Mexico

    Implementación completa de SAP 4 HANA para Grupo Proa. Participación en el modulo de SAP BusinessObjects y desarrollo de los principales reportes de la compañía. System Environment:* SAP BusinessObjects 4.2 * SAP 4 HANA* HANA STUDIO & BW

• 

  FEMSA

  • Mexico City Area, Mexico

  • SAP Data Services Consultant

    • Nov 2016 - Apr 2017
    • Mexico City Area, Mexico

    Desarrollo de los programas de Migración de datos de SAP R3 a JDA. System Environment:* SAP Data Services 4.2 * Oracle 12c* JDA Supply Planning* SAP R/3El proyecto consistió en el desarrollo de los programas en Data Services para la migración de datos de R3 a JDA

• 

  Sigma

  • Monterrey Area, Mexico

  • SAP Data Services Consultant

    • May 2016 - Oct 2016
    • Monterrey Area, Mexico

    System Environment:* SAP Data Services 4.2 * SAP BusinessObjects 4.2* Oracle 12c* SQL Server 2018.* Hana Enterprise.* BW 7.5Sigma Alimentos parte de grupo ALFA, adquirió compañías de alimentos de US, Europe and LATAM. El proyecto consistió en la integración de los datos de las nuevas compañías usando como repositorio de datos SAP Hana Enterprise y visualizacion de datos en SAP BusinessObjects 4.2

• 

  Blue Shield of California

  • San Francisco Bay Area

  • Infosys - Blue Shield California - SAP BO Consultant

    • Jul 2015 - May 2016
    • San Francisco Bay Area

    Responsibility: Data Ware house developer / Report Writer.System Environment:* SAP Data Services XI* SAP BOXI* Facets Trizetto* IBM Netteza BSCA needed to move a data warehouse into IBM Netezza. It was necessary to recreate all the SAP Business Objects Reports pointing to the Legacy DWH to the new Data Source. As a part of the Infosys team I developed some of the BODS interfaces to move the data into Netezza and also re-writing the existing reports on WEBI.

• 

  California Steel Industries

  • Fontana CA

  • SBOP 4.0 Developer

    • Feb 2014 - 2015
    • Fontana CA

    Responsibility: Universe Designer, Report WriterSystem Environment:* SAP BusinessObjects 4.1* Oracle 11i, MS SQL and SAP BW 7* PSI MES * AS400 & RPGCSI migrated their AS400 Legacy Production System to PSI MES Metals Production Management. All existing reports were migrated from data source. Most of them were built on Web Intelligence, and some on Crystal Reports and Design Studio as well. I helped on the Universes design and maintenance, using multiple data sources. Some information was reorganized into new databases using Data Services. The data sources were MS SQL, Oracle 11i, BW 7 and AS400.

• 

  Soriana

  • Monterrey Area, Mexico

  • SAP Data Services Consultant

    • Nov 2013 - Jan 2014
    • Monterrey Area, Mexico

    Responsibility: SAP Data Services * Jobs Design for load the Master Data Materials into ECC from a Legacy System* Big Data Processing and Load using iDoc and RFC interface * Performance improvement for Data loads using Parallelism, Duplicate Control, Intermediate Tables, Table Partitioning, Round Robin etc.* Administration tasks like Scheduling Jobs, monitor them, troubleshooting failed jobs. As BODS Administrator I helped to create and maintain the repositories, and the central repository management and also troubleshooting and supporting failed Jobs on the SAP Data Management Console.The company migrated its Legacy ERP into SAP R3. This project was to develop the jobs for the data migration. The challenge of this project was to improve the Job’s time because as a Retailer, the company uses BIG DATA. The job took initially up to 8 hours to finish. Applying parallelism to the jobs, reduced the jobs time, between 3 and 4 hoursEnvironment: MS SQL 2008, SAP R/3 Industry: Retail

• 

  Gobierno del Estado de Guanajuato

  • Consultoria en SAP BusinessObjects 4.0

    • Jun 2013 - Jul 2013

    Responsibility: Team Leader.* SAP BusinessObjects Migration from XI to 4.0 * Server Sizing* Integration with SAP BW 7.0* Group configuration, User Rights, Access Levels and Folder Structure in CMC * Report Data Source UpdateThis project was the migration from SAP BusinessObjects XI 3.1 into SAP BusinessObjects 4.0 preserving all data like users, folder structure, reports and security rules. Connections were redirected also, and extensive testing to ensure the correct functionality of the new server.Environment: BW 7.X & SBOP4.0, SQL 2008, MySQLIndustry: Government

• 

  International Rectifier

  • El Segundo, CA

  • SAP Bi/BO consultant

    • Jun 2011 - Jan 2013
    • El Segundo, CA

    Responsibility: SAP BusinessObjects Developer* Development of Universes based in Bex queries.* Bex Queries development* WEBI Reports Writing* Crystal Reports 2011 Writing * Business Views for Crystal ReportsInternational Rectifier migrated its legacy ERP into SAP R/3. I helped on the creation of the reporting for the different business areas of the company extracting the information from SAP BW. Some of the team members were located offsite in India with whom I had constant communication. Environment: BW 7.X BOXI 3.1Industry: Electronics Industry.

• 

  Arca Continental

  • Monterrey Area, Mexico

  • SAP Data Services & SBOP4.0

    • May 2012 - Dec 2012
    • Monterrey Area, Mexico

    Responsibility: SAP BusinessObjects Data Services Project Leader  Integration of Legacy system information Extraction from BW, SQL Server & MySQL  DWH Development Report Writing in WEBI, Dashboards & CrystalArca-Continental is one of the biggest Coca-Cola bottlers on LATAM. After acquired another bottler company, they needed the integration of the Information of both companies into one single ERP, SAP R/3. This was achieved using the SAP Best Practices for Data Migration.About the data presentation layer, it was necessary to create Dashboards, and ad-hoc reports in Web Intelligence, and Crystal Reports. Results/Accomplishments: The correct integration of information into a new DWH.Environment: BW 7.X & SBOP4.0, SQL 2008, MySQLIndustry: Beverage

• 

  Monsanto

  • Business Intelliegence Consultant

    • Dec 2010 - Jun 2011

    Responsibility: SAP BusinessObjects Developer Development of Universes based in Bex queries. Bex Queries development WEBI Reports Writing Environment: BW & BOXI 3.1 Industry: Biotechnology and seeds.Separation Due: End of projectMonsanto had a specific need to create some ad-hoc reports from SAP BW. This was a short project basically to develop these reports.

• 

  Johnson Controls

  • Business Objects Consultant

    • Jan 2010 - Dec 2010

    Responsibility: SAP BusinessObjects Developer The migration of Cognos reports to WEBI in BOXI 3.1 Universe design based in Oracle 10 Data Base. RDBMS Dashboards Design This project was to re-write all the Company Reports from Cognos Impromtu to SAP BusinessObjects 4.0Most of the reports were built using WEB Intelligence, but also I built some dashboards. I consider Johnson Controls has the more complex reports I have worked in. Some with more than 10 tabs, multiple charts, and tables. JC has a huge operation around the world generating BIG DATA. With a strict development management, JC required a detailed documentation from the Technical Specification to the User acceptance test sign off. Environment: Oracle X, BOXI 3.1, Industry: Power and energy solutions.

• 

  Lexmark

  • Business Objects Consultant

    • May 2008 - Nov 2009

    Responsibility: SAP BusinessObjects Administrator BusinessObjects Administration. Crystal Reports and WEBI Report WritingThis was a full time position as SAP BusinessObjects System Administrator. My tasks were to create new reports for production support and inventory control of the Warehouse. Security Management, access control, folder structure, user maintenance, scheduling reports, and all related with the SAP BusinessObjects XI system. Results/Accomplishments: The correct administration of the system.Environment: BOXI 3.0, JDE, AS400Industry: Printing Solutions

• 

  The Coca-Cola Company

  • Business Intelligence Support

    • Nov 2004 - May 2008

    Responsibility: Business Intelligence Developer Crystal Reports X, Developer and administration. Oracle Explorer 8i Developer and Administration.  Advanced Excel report writer. ActaWoks ETL Processes This was a full time position. My first job as IT consultant. At the beginning I worked as help desk. But after that I was promoted to the Business Intelligence area. Here I began to learn all the concepts of business Intelligence. I receive training in Oracle Explorer, Crystal reports, Business Objects, Excel Macros and complex reports. Results/Accomplishments: The creation and maintenance of the BI Portal for IT LATAM.Environment: Crystal Enterprise X, Oracle 8iIndustry: Beverage Portfolio