SERO is now business partner ORACLE one of the most important software companies worldwide. Always supporting our business partners for the implementation and execution of their projects. For 9 years ORACLE Consulting is depositing its commitment SERO, commitment and leadership. Sero positioning as a reliable and responsible company.


 

AEROMÉXICO (2013)
BI Publisher 11g, OBIEE 11g, BI Apps 7.9.6.3, EBS R12i

OBJECTIVES

Set security settings in BI Publisher and OBIEE.

Creating different types of reports, optimizing response times on activities in various areas.

The realization of receipts for the Payroll department.

 

ARCHITECTURE PROJECT

 

 RESULTS

  • Implementation of 26 reports (News and receipts) and 8 with text output reports using BI Publisher 11g as data source EBS R12i to the modules.
  • Deploying module BIApps
  • Training staff on the use Aeromexico Tool BI Publisher 11g
  • Development of Interfaces for Fiscal Repository
  • Customizing BIApps to finance also consider subaccount for the classification of financial accounts.
  • SOA Project

 

METALSA
Proyecto de BI

 

Metalsa is a global company that is located within the automotive and commercial vehicle industry, with operations and technology centers strategically located around the world.

Sero developed the BI project Metalsa that meets the needs of resource control of the company.

OBJECTIVES

Implementation of an analytical application covering needs to be presented and expedite the delivery of analytical information for decision - making.

ARCHITECTURE PROJECT

The diagram show the process flow was implemented in the project is displayed.

RESULTS

  • Generating information boards with high performance with accurate and high user value
  • Creating reports and dashboards, which are published in Oracle BI Interactive Dashboards for all users consume the created application.
  •  Information in different currencies.
  • Daily updating of information.
  • Desired response times.

 

GRUPO FÁRMACOS NACIONALES S.A. DE CV (2009-2008)
Oralce Data Integrator 11g, Oracle Business Intellinge 11g y Apex

OBJECTIVES

The project aims to show EVA indicator reports classified by various categories.

The information is presented to directors and executives Farmacos Especializados S.A. C.V is done through reports, which contain sensitive information, which helps them to have a comprehensive picture for decision making, so the information must be accurate and reliable.

 ARCHITECTURE PROJECT

 

RESULTS

  • Creating various reports that display information in a clear, accurate and reliable.
  • Friendlier to the end user that allows more easy data management environment.
  • Completion status notification process through email.
  • Improved results on time reports.
 

OBIEE:

  • 41 reports were created
  • 15 graphics

APEX:

  • Screens were performed 11 

ODI:

  • 37 packets.
  • 12 cases.

 


 

MEXICANA DE AVIACIÓN (2009-2007)
EBS R12

  • Configuring modules DBI for Procurement
  • Software Development for BI tables update module for the MRO
  • Software Development for Project Billing module.
  • Creating Vista for the OTA module.
  • EBS R12
  • Development AP reports to module
  • Development of custom view for the OTA module.
  • Development AP reports to module

 


 

BEPENSA MOTRIZ (2008)
EBS R12

Configuring Modules DBI Finance , Sales, Quotes and Purchasing.


 

NEXTEL DE MÉXICO (2007)
EBS R11

  • Initial Development of procedures for loading modules AR, FA
  • Development of interfaces between legacy systems and Oracle application modules for AR, CE, INV, GL, OM .
  • Managing and Customizing Workflow Modules OM, FA, PA, PO and GL.
  • Customization Development Modules PA, OM.

 


 

DISH (2013)
ODI 11g, EBS R12, SIEBEL 8.1

Analyst for the development of the interface between the module SIEBEL Incentive in EBS.


 

GANADEROS PRODUCTORES DE LECHE PURA (2007 - 2008)
EBS R12

Development Purchase Order format for PO module.
Development Report for the module OPM Financials


 

OPORTUNIDADES - SEDESOL (2009)
OBIEE 10g

Development Mappings Using OWB 10g.
Report creation using 10g OBIEE


 

VINOTECA (2008)
OBIEE, Oracle Warehouse Builder, Workflow Builder

  • Maintaining WF, OWB mappings and improving Performance of BI application Vinoteca
  • Report creation using 10g OBIEE

 


 

Powered by Joomlamaster.org.uatogether with Joomstudio.com.ua