Antonio Marines
Data Engineer
Email:
Address:
Monterrey, N.L. Mexico
​
Date of Birth:
December 11th, 1970
​
Hello! I'm Antonio Marines
I am a Professional Data Engineer and Data Analyst with a wide expierence for data analysis, manipulation and transformation, data design, data architecture and data modeling, information visualization, experience in INFORMIX, SQL, SQL SERVER, SSAS (Tabular Models), SSIS, SSRS, Power BI desktop, Service and Report Server, DAX, Python (beginner)
EXPERIENCE
1997-2002
Data Analyst
TELMEX
Monterrey, Mexico.
* Design, creation, implementation and administration of informix and SQL Server 2003 databases for the analysis of Institutional information through SQL queries.
* They were achieved: implement the use of tools for massive loads, performance tunning and the use of ETL packages
* It was possible to reduce processing times significantly by up to 70%, so that it positively impacted decision making, mainly to direct future investments
​
​
2003-Currently
Senior Data Engineer
TELMEX
Monterrey, Mexico.
​
* I have been responsible for designing and implementing all database solutions in the IT department of the northern division of this company.
Design, creation and implementation of INFORMIX databases on UNIX, administration and optimization of SQL Queries, Store Procedures programming, performance tuning, etc.
* Implementation and configuration of SQL SERVER 2017, SSAS, SSRS, installation and configuration of Power BI Report Server, all of the above in Windows Server 2016
* Design, creation and implementation of SQL SERVER databases in Windows, administration of: users, logins, credentials, Job proxies through SSMS, programming of Store Procedures.
* Creation of ETLs using SSIS obtaining data from different sources such as: Informix, SQL Server, AS400 DB2, Excel, txt, csv, etc. and sending them to SQL SERVER databases as well as to SSAS tabular databases
* Architecture and implementation of SSAS tabular data models using Visual Studio, working with models with more than 150 tables and with more than 50 million records in some tables, including calculated columns and hundreds of measures implemented within the data models using DAX language.
* Query data from SSAS data models using DAX language and DAX Studio application.
* Development and implementation of reports using Reporting Services (SSRS) from different sources, SQL Server databases and mainly from SSAS tabular databases, which include summaries, graphs and record details.
* Development and implementation of reports using Power BI Report Server (PBIRS) from SSAS tabular database sources, including summaries, graphs and record details.
With all of the above, I have achieved very significant reductions in processing time to obtaining useful information for decision making by the general management of the company, generating a very positive impact by having very fast information. Mainly with the implementation of tabular models in SSAS, as an example, processes that consumed days and even weeks to complete, these have been reduced to only minutes and even seconds of processing time by executing DAX querys.
​
EDUCATION
1994-1997
​
1991-1993
UNIVERSIDAD AUTONOMA DE NUEVO LEON
Ing. Administrador y de Sistemas
TECNOLOGICO DE MONTERREY
Ing. en Sistemas Computacionales
MOST IMPORTANT SKILLS
* 20+ years of experience in SQL (informix, SQL Server, DB2)
* 20+ years of experience in UNIX shell programming
* 10+ years of experience in SSIS (latest version 2017)
* 6+ years of experience in SSRS (latest version 2017)
* 6+ years of experience in SSAS Tabular (latest version 2017)
* 6+ years of experience in the DAX language (DAX Querying)
* 4+ years of experience in Power BI desktop, Power BI Report Server (On Premises), Power BI Service
* 1+ yeas of experience in Azure: Analysis Services, SQL DataBase, Data Factory
* 1+ year of experience in Basic Python programming, mainly to develop scripts with the functionality of automating repetitive tasks when processing Excel files, using libraries: Pandas, win32com, etc.