
Traffic and Dwh Leader at Telmex
Colombia

Traffic and Dwh Leader at Telmex
Colombia
Open source, mysql, business intelligence, pentaho, linux, web development, software architecture, telecommunications network management software, cdrs
(Public Company; 10,001 or more employees; TMX; Telecommunications industry)
May 2008 — Present (1 year 8 months)
Technical project management for technical dwh and traffic analysis applications for QOS and GOS.
(Telecommunications industry)
January 2005 — April 2008 (3 years 4 months)
Design, development and maintenance of information systems for the mobile network management. Administration and maintenance of Linux servers and the network management data warehouse. Main projects:
-Midas: Mining Data System. Design, administration, operation and maintenance of the billing records data warehouse. The data warehouse is composed by a cluster of servers with a SAN storage system which size is 9 TB.
The ETL layer is built in Bash, Perl and C. Bash is used for controlling the process, move files, call sqls etc. Perl an C are used for the billing records ASN1 parsing,
The database management system is MySQL. The cluster operating system is Cent OS 5.
-MidasWeb: Design and Develop of a web front end access to the data marts and raw data of Midas information system. The application is composed of these modules: ad-hoc query, reporting, performance scorecard and OLAP cubes.
(Telecommunications industry)
2004 — 2005 (1 year )
(Telecommunications industry)
2002 — 2003 (1 year )
1997 — 2003
Databases, MySQL, Open Source, Squash