Customers and Projects

Falabella

Falabella is a retail store founded in 1889 by an italian family based in Chile. Owned by S.A.C.I.. Falabella has operations in Chile, Argentina, Perú, Colombia, Uruguay and Brasil. As of September 2015, the number of employees throughout the company reached 94,967 people.

Projects

• Maintenance of processes that change the history of the Retail system cubes: developed in perl language.

• Service architecture integration for the Siebel system upgrade.

• Development of integration between Retail SRX system with WMOS warehouse control system: developed in PL / SQL and XML.

• Excel report generator development: Developed in java with BD oracle, hibernate, AQ tails and Apache POI library

• Tuning of messaging process in TRL Logistics system developed with AQ and PL / SQL queues.

LATAM Airlines

LATAM Airlines is a Chilean airline formed by the South American airlines LAN, TAM and its subsidiaries. Based in Santiago, Chile, the airline operates passenger flights to countries in the Americas and the Caribbean, Europe, Africa and Oceania, reaching a total of 136 destinations in 24 countries. In cargo the airline serves more than 144 destinations in 26 countries. In terms of traffic and coverage, it is the largest airline in South America. LATAM was born as a merger of the LAN airline and the Brazilian airline TAM.

LATAM is made up of approximately 45 thousand employees and its fleet consists of 287 aircraft, not including some ships already ordered and not yet delivered.

Projects

• ILM based in load system database partitioning.

ABCDin

A Chilean chain of stores specialized in home appliances, funded in 1950 as a subsidiary of Empresas Copec. It was sold to Yaconi- Santa Cruz in 2005 who merged it with Din stores in 2008

Projects

• Web based application to maintain Database of clients associated with the new ABCVisa credit card: Developed in ADF Oracle framework

• Implementation of the Transparent Data Encription (TDE) Oracle database for the new Polaris card system of ABCDin. This was required for PCI certification.

• Totalpack operational system integration services: developed with Oracle Service Bus (OSB)

• Services for integration of applications developed in PL/SQL with recalling service to Previred: developed with OSB, AQ tails and AQ tail Adapters

• Payroll system integration with SuccessFActors cloud application: developed in ORacle Data INtegrator (ODI) and OSB

• Payroll system integration with HR (GoIntegro) POrtal: developed with ODI, OSB and java for the translation of messages to JSON

• Web application for control of payroll loads with records of auto insurances accrual: developed with ADF and Apache library POI for generation of reports.

• Credit card transaction capture services for mobile application: Developed in OSB, Aq tails and Aq tail queues.

• Tracking mechanism for OSB: developed in OSB, JMS queues, message driven bean MDB in java

• Selfservice credit card responsive Web Application: developed in JSP, java, javascript, bootsrap, JAS-WS, JAX-RS

Compañía de Cervecerías Unidas

The Compañia de Cervecerías Unidas, also known as CCU, is a chilean drink manufacturing company, founded on January 8, 1902. Is controlled by Inversiones y Rentas S.A., owned by the Quiñenco subsidiary of the Luksic Group and the Dutch Heineken International, which jointly own 60% of the company.

The company produces both alcoholic and non-alcoholic beverages, it also operates in food related businesses. It has operations in Chile, Argentina, Bolivia, Colombia, Paraguay and Uruguay. It is Chile`s main brewer, the second in Argentina, and the third producer of beverages in Chile, the second producer of wine, the main bottler of mineral water and nectar of Chile, and one of the main producers of pisco in the region.

Projects

• Tuning of TRUCK the dispatch and order control web application: detection of communication latency problems that due to poor development practices were responsible for performance issues, improvement in execution and parallelism plans.

• ILM information project of TRUCK order system : made in PL / SQL with process control repository. Implements daily and monthly processes to historical DB and deletions. The process control solves the parallelism control , dependencies and automatic returns.

• Automated procedure for non-productive environments (QA, training) creation: implemented with RMAN's duplicate database, automation scripts and environment configuration.

• Automated tests for the TRUCK system billing process: implemented with JMeter, PL / SQL and flashback database for regression tests.

Redbanc

Redbanc S.a., is a chilean company, in charge of handling the country`s interconected banking network, founded on September 9, 1987 as Bank Support Corporation. Redbanc also provides its clients with transaction processing service, which includes all those made at ATMs from 12 most important banks in the country.

All the ATMs in the country operate most of the Credit Cards and Debit Cards, such as: Visa, MasterCard, American Express, Diners Club, Visa Plus, Cirrus and Maestro.

Projects

• Geographic cluster on internal process portal: Disaster recovery configurations were implemented in the application developed with Oracle Portal, Weblogic, Identity Manager, Web Tier and Oracle DB.

Coordinador Eléctrico Nacional

The National Electric Coordinator is a technical and independent organism, in charge of coordinating the operation of the set of facilities in the Chilean National Electric System.

The National Electrical Coordinator operates the electrical installations that function interconnected with each other, in order to:

• Preserve the security of the service in the electrical system;

• Guarantee the most economical operation for all the installations of the electrical system; Y

• Guarantee open access to all transmission systems, in accordance with the law.

Projects

• Restoration of the disclosure and operation portal. This is a mission critical portal that supports the process of entry and exit of electric generators in the national network. The portal is developed with Oracle iAS Portal and BD Oracle. It required an emergency recovery after a disaster in the HW where it was installed and did not had a contingency plan.

• Implementation of portal platform contingency environment.

• Portal platform administration: ITIL-based administration processes are enabled with own tools and others in the cloud.