Expert Data Engineer with 17+ Years Experience
Resume:
*************@*****.***
Phone number
linkedin.com/in/mario-andrés-
vergara-25b453a6
Address
Miami, 33144
Mario Vergara
Domínguez
Expert Data Engineer
Gender
Male
Date of birth
3/10/1981
Additional info
I am a Systems Engineer. With over 17 years of experience in data analysis, systems engineering, business intelligence projects, data migration, data modeling using Kimball methodology, ETL development with integration tools, 12+ years of experience with Informatica PowerCenter, over 16 years of experience with Teradata and Oracle databases, and a strong ability to analyze user requirements and build effective data models, I am excited to apply my skills and knowledge to contribute to your team's success. Contenido
Expert Engineer / Economic Information Center Office Aug 2019 - Jan 2026 Central Bank of Colombia
BOGOTÁ, D. C., COLOMBIA.
Main Assignments: Provide, design, develop, monitor and administer high quality solutions that help improve and simplify the economic information analysis processes from the Technical Management. Meet the economic information demands required by the Technical Management, by the bank and by the public in general. Supervise and follow up on the economic information exchange agreement with other institutions such as Superintendencia Financiera de Colombia, Direccion de Impuestos y Aduanas Nacionales (DIAN) and Departamento Administrativo Nacional de Estadística (DANE). Design and build data dimensional models in the corporate Serankua Data Warehouse. Design and implement ETLs
(extract, transform & load) Processes with Informatica PowerCenter and Teradata. Build weekly, biweekly and monthly reports of different economic indicators of the country to be consumed by bank users and for Colombian citizens. Monitor daily processes and flows that send information to different entities.
Tools:
Informatica PowerCenter 10.5.4 Informatica Developer 10.5.4 Informatica Analyst 10.5.4 Teradata.
Oracle Cloud Linux
Work experience
Thank you for viewing my resume *************@*****.*** Senior Consultant Jul 2018 - Aug 2019
CES Consultoría; Scotiabank
BOGOTÁ, D. C., COLOMBIA.
Goals: Consulting directed by Agile methodology in order to support the initiative of the Risk Vice-Presidency in the construction of the project Power Curve Acceleration (PCA). Main Assignments: Design of strategies in ETL processes. Definition of integration work plan through Informatica PowerCenter. Scope and time management in prooceocess implementation. Refinement and improvements too existing ETL processes. Tools: Informatica PowerCenter 9.6.1
Oracle.
PS Senior Consultant Jul 2017 - Jun 2018
Teradata Colombia
BOGOTÁ, D. C., COLOMBIA.
Goals: Consultancy based on Agile methodology - Scrum in order to provide Banco de la República with the Corporate Data WareHouse composed of the different modules of the different areas that make up DCIN, DSIF, DTE, DSP, DGT. Main Assignments: Identification of user histories and BackLog. Design of strategies in ETL processes. Scope, time and risk management. Tools:
Informatica PowerCenter 10.1.
Teradata 15.
Oracle.
Senior BI consultant Feb 2017 - Jun 2017
Indra Company
Colombia
Client: BBVA Colombia. Place: BOGOTÁ, D. C., COLOMBIA. Goals: Ongoing consulting is aimed to the improvement of the Information Platform (corporate DW of BBVA) with 160 indicators needed for the analysis of the loans of vehicles market sector. Tools: Informatica PowerCenter 9.6.1
Teradata 15
Oracle
Thank you for viewing my resume *************@*****.*** BI consultant Mar 2014 - Feb 2017
Indra Company
Colombia; BOGOTÁ, D. C., COLOMBIA.
Client: Central Bank of Colombia. Place: BOGOTÁ, D. C., COLOMBIA. Goals: This consulting is aimed at the creation and implementation of Business Intelligence procedures in the Banco de la República. Mainly on the basis of the needs of different areas owned by the Bank and thus build the business cases which will be used to design and implement three initial prototypes. This stage covers from the dimensional design to the implementation of processes and the layer of presentation. Role as Technical Leader for the International Exchange Area). Primary objectives: Leadership and design of models and BI solutions. Listing of requirements. Design of BI solutions. Management of scope, time, and risks. Tools: Informatica PowerCenter 9.6.1
Teradata 15
Oracle.
Bi Consultant May 2013 - Mar 2014
Indra Company
BOGOTÁ, D. C., COLOMBIA.
Telefónica Movistar Colombia / Certification of the Telefónica Moviles Data Warehouse. Goals: Secure the correct implementation of business intelligence models and strategies in order to have reliable information and achieve efficiency in the Data Warehouse of Telefonica Movistar Colombia. Creation of new models and strategies for effective use by the user. Tools: DataStage 8.1
Teradata 13
Oracle
Bi Consultant Dec 2012 - Apr 2013
Indra Company
BOGOTÁ, D. C., COLOMBIA.
Telefónica Movistar Colombia / Operative locking of stolen or misplaced terminal equipment used for the provision of mobile telecommunications services. Goals: Design and implement a centralized database with positive and negative mobile terminals info in order to report to the Communications Regulation Commission information contained on them. This design and implementation was developed conjoint with Movistar Colombia's own areas of Fraud and BI. Tools:
DataStage 8.1
Teradata 13
Oracle
Thank you for viewing my resume *************@*****.*** BI Consultant Dec 2011 - Mar 2012
Indra Company
BOGOTÁ, D. C., COLOMBIA.
Telefónica Movistar Colombia / Restriction of operation to terminal equipment stolen or lost used for the provision of mobile telecommunications Goals: Design and implement a centralized database (BDA) with information of positive and negative lists, on which there will be a set of well-defined rules for querying, inserting, deleting, or modifying of the information contained in them. The BDA will be used by mobile operators in the country in their business operations to enable the activation and use of mobile terminals. The Data Base Administrator must be administered by a third party. Tools: DataStage 8.1
Teradata 13
Oracle
Senior computer scientist Dec 2009 - Dec 2011
Indra Company
BOGOTÁ, D. C., COLOMBIA.
Goals: Design and development of database and ETL processes for Telefónica Movistar Colombia Business Intelligence Project from the transactional databases. Tools: DataStage 8.1
Teradata 12
Oracle
Senior computer scientist Nov 2009 - Dec 2009
Indra Company
BOGOTÁ, D. C., COLOMBIA.
Goals: Tuning and optimization of company billing reports. Tools: Oracle Senior computer scientist Aug 2009 - Oct 2009
Telefónica Movistar Colombia
BOGOTÁ, D. C., COLOMBIA.
Goals: Dimension the requirements defined by the client. Perform analysis and strategies to develop processes of extraction, transformation and loading of data. Making reports to the users of the application. Tools:
Oracle Data Integration.
Oracle
Thank you for viewing my resume *************@*****.*** Business Intelligence Consultant Feb 2008 - Aug 2009 Tata Consultancy Services
BOGOTÁ, D. C., COLOMBIA.
Goals: Merge the data from different information systems to an ODS system, this being the initial stage of the Telefónica Telecom Colombia data warehouse. Design and creation of different DataMarts such as Billing, Collections and different reports to the Superintendence of Utility Services. Tools:
Oracle Data Integration
Oracle data base 9i
Business Intelligence Analyst Sep 2007 - Dec 2007
Leasing de Occidente S.A
BOGOTÁ, D. C., COLOMBIA.
Goals: Perform the administration, communications and development plan duties of the company business intelligence project. Tools:
Cognos 7 Version 3 Business Intelligence.
AS 400
Junior Developer Mar 2007 - Sep 2007
Genome-IT
BOGOTÁ, D. C., COLOMBIA.
Client: Institute of Hydrology, Meteorology and Environmental Studies (IDEAM). Role: Designer and developer of methods for the retrieval, transformation and loading for information migration. Project: Inter-Administrative Convention 011 of 2006, National Agency of Hydrocarbons ANH and the Institute of Hydrology, Meteorology and Environmental Studies (IDEAM).
Goals: Development of a Geographical Information System. Tools:
Pentaho
Oracle 9
Junior developer Sep 2006 - Mar 2007
Genome-IT
BOGOTÁ, D. C., COLOMBIA.
Client: DANE (National Administrative Department of Statistics) Project: Generate a data warehouse based on the information of the 2005 Census. Role: Junior analyst, designer of ETL processes for the load of the data warehouse. Tools:
Pentaho
Oracle 9
Thank you for viewing my resume *************@*****.*** University intern Jun 2006 - Jul 2006
AGUAS DE CARTAGENA S.A. E.S.P.
Cartagena, Colombia
Role: professional practices / Designer and developer of strategies for the creation of the DataMart and reports. Goals: Implementation and development of a DataMart of the Commercial Portfolio area. Achievements:Design and implementation of the DataMart from the respective area and creation of web-based reports and in Microsoft Excel. Tools: MS SQL Server Business Intelligence Development Studio 2005. SQL Server Database
University intern Jan 2006 - Jun 2006
AGUAS DE CARTAGENA S.A. E.S.P.
Cartagena, Colombia
Role: professional practices Designer and analyst for the implementation of strategies for the creation of the data warehouse. Strategies and reports design. Goals: Implementation of a data warehouse (Business Intelligence). Achievements: Design and creation of an OLAP database. The company data warehouse is initially comprised of four DataMarts representing the significant areas of the organization. All the implementation was developed using MS SQL Server 2005. Tools: MS SQL Server Business Intelligence Development Studio 2005. Sep 2006
Cartagena, Colombia
Course
Languages English
spanish
Systems Engineering; Systems Engineer Jul 1999 - Jun 2006 Bolívar University of Technology
Cartagena, Colombia
systems engineering professional
Education
Specialization in management of information systems Jun 2009 - Jun 2010 Del Rosario University
BOGOTÁ, D. C., COLOMBIA.
Oracle database development; database development Jun 2006 - Oct 2007 Jorge Tadeo Lozano University
BOGOTÁ, Thank D. you C., COLOMBIA. for viewing my resume *************@*****.*** Feb 2005
Bolívar University of Technology. City: Cartagena, Colombia Cartagena
WO
MIT: No Code AI and Machine Learning: Building Data Science Solutions
202
4
Certificate
Thank you for viewing my resume *************@*****.***
Contact this candidate