Concepcion Ortiz

Concepcion Ortiz

Work experience

Work experience
Mar 2008 - Present



End Client:  Agencia EFE (A major International News Organization)

  • Currently working on implementing SAP BI for major media concern.
  • Wrote 20+ complex queries using query designer
  • Queries were for SD, MM, FI, CRM, HR
  • Conducted one on one end user training
  • Created numerous complex process chains
  • Created complex executive dashboard which display graphical information from SD, MM, FI, CRM, HR   SAP BW Dashboard
  • Collected user business requirements
  • Created communications structures and transfer structures and associated update rules.
  • Researched and activated Business Content.
  • Created data packages and performed daily data loads.
  • Analyzed and corrected bad data.
Jun 2010 - Present

BusinessObjects Consultant

  • Building xcelsius Dashboards and Crystal Reports for a Retail Grocery Chain.
  • Dashboards cover Sales, Inventory and MRP Subject Areas
  • System architecture includes xcelsius connected via LiveOffice to Crystal Reports and then to SAP BW Querys
Jan 2008 - Mar 2008

SAP BI Netweaver Consultant

  • Identified and prepared complete Sales Information BW based reporting system for GENPACT Client
  • Identified and activated all SAP Business Content including:
  • Extractors, Transformation and Communication Sturctures, Master Data and Queries.
  • Used BEX Analyzer and Web Application Designer to deliver final product to the client
  • Set up Standard BI-IP  Infocube
Apr 2007 - Oct 2007



End Client:Gonvarri, Steel Industry

  • Worked on implementing SAP BI for modules MM, SD, FI-CO, PP, PM & QM
Jun 2006 - Dec 2006



End  Client:Hewlett-Packard

  • Worked in the 2nd and 3rd level support for HP’s global SAP APO and BW implementation, which is being rolled-out in the USA, APAC, Europe and the Middle East
  • Recorded incoming incident reports, using the OVSD problem reporting tool.
  • Investigated and resolved problems including:
  • Entry into remote SAP APO and SAP BW systems as well as various FTP servers.
  • Management of dataloads using SAP BW Infopackages including loading, erasing and managing those Infopackages
  • Managed and executed and modified SAP BW Process Chains.Additionally, investigated and corrected errors in these same SAP BW Process Chains
  • Managed a large number of SAP BW InfoCubes, including dataloads, data deletes, and selective deletes.
  • Investigated and managed dataload issues with Persistant Staging Areas (PSA)s and Operation Data Stores (ODS).
  • Managed and updated Master Data, Text and Hierarchies in SAP InfoObjects
  • Managed Flat File uploads from UNIX servers
    • Updated Price Bands
    • Uploaded New Products
    • Uploaded Product Modifications
  • Executed Transports using Transport Management System
  • Used Tidal to manage jobs and process chains
  • Managed numerous SAP BEX Analyzer Reports
    • Users would report problems with either the Report or Report Contents
    • I investigated the complete data trail and resolved problems with these reports
    • Modified Querys,
    • Modified InfoObjects
  • Trained other SAP BW Support Consultants from Mexico and India
Mar 2005 - Jun 2006


End  Client:Hewlett-Packard

  • Worked in the 1st level support for HP’s global SAP APO and BW implementation, which is being rolled-out in the USA, APAC, Europe and the Middle East
  • Received incoming Problem Reports and analyzed them.
  • If possible, resolved them at Level 1.
  • Assigned problems to other consultants at levels 2 and 3
  • Track and reported problem resolution
  • Provided weekly and monthly statistical performance reports
Nov 2004 - Feb 2005

Helpdesk coordinator for the Go-live team


End Client: Cognis, Chemical Industry

  • Prepared daily summary for the Go-live status meeting,
  • Managed the monthly time sheet procedure,
  • Provided daily follow up of all issues in the issue database, solving issues and closing issues, attending status meetings, and lead the help desk team.
Mar 2002 - Mar 2004

SAP IS-U Support Consultant


End Client: AGBAR, Barcelona water utility

  • Help Desk support consultant for an SAP IS-U/CCS (Industry Solution-Utilities/Customer Communication System) implementation.
  • Specialized in the SAP IS-U Meter Reading module and device management module.
Apr 2000 - Apr 2001

SAP HR Consultant

SAP Arabia

End Client(s):Approximately 57 Middle East Clients, including ARAMCO

  • SAP R/3 HR Consultant providing Help Desk support for Level 1, 2, and sometimes Level 3
  • Responsible for processing and solving customer reported HR related messages using the HR Help Desk support system (CSN), SAP’s global Support System
  • Responsible for statistics and developing performance reports for SAP Arabia's local support.
  • Sole SAP HR Consultant in charge of responding to request for proposals (RFPs) and preparing SAP HR demonstrations


2007 - Present

SAP Academy
  • TABW10 Data Warehousing
  • TABW20 Business Information Warehouse – Reporting and analysis
  • TABW30 Business Information Warehouse - Data staging and Extraction
  • BW330 Business Information Warehouse – BW Modeling
  • BW370 Business Planning and Simulation BPS
2002 - Present

SAP Academy

SAP IS-U/CCS training on all IS-U modules (5 weeks)

Sep 1997 - Jun 1999

Associates Degree

University of Maryland