Carlo Contreras

Responsible and owner of more than 40 reports, developing new reports from end to end, streamline and automation of ETL processes.

Support migration from in-premise platforms to Snowflake.

• Power BI (Reports, Dashboards, Measures, DAX)
• Teradata (BTEQ, TPT, FastLoad)
• SQL Server (OLAP Cubes, SSIS Packages ETL)
• Vertica SQL
• Query tuning
• Report tracking
• Batch (.bat) processing (automation & streamline)
• Task Scheduler
• Excel (VBA,VBS, Macros, Power Pivot, Power Query)
• R (DPLYR, readR, RODBC, ggplot, Lubridate,)
• Palantir
• Python (Pandas, Matplotlib, NumPy, TensorFlow, Scikit-learn)
• A/B Testing
• Windows Server
• PowerShell
• Snowflake ( functions; data load; data share; file format).
• Databricks

• Project "Moving to R": Development, automatization and migration of all reports, metrics, KPI's and evaluation processes of the Collections department (from Excel, SQL and Access to R)
• Data visualization through different G suite as well as department dashboard update
• Project "Collectible Estimations": Through the bind of all month end reports, a timeseries was created to make various regression analysis, forecasting and plots in order to forecast how much cash would be collected on next months and weeks.

• Socioeconomic evaluation of framework investment projects based on the funds guidelines of Ramo Federal 23 (Fortalece, Proyectos de Desarrollo Regional)
• Database management; EXCEL Macro programming; writing; correspondence and direct negotiation with Federal Entities; teamwork.

• Data analysis and interpretation to prepare reports and recommendations
• Exhaustive research and estimates calculation on various topics regarding Mexican and global economy
• Making the equalization of economic activities between NAICS, NACE and ISIC catalogs
• Estimation of indices and variations in different bases
• Translation and response to several WMF, UN, CEPAL and OECD requirements
• Databases management, handling, backpolation and extrapolation of for the 2013 Base Year Change
• R, SQL and Excel Macro programming with VBA, pivot tables and nested functions.

• Certification in TestManager, a tester software for the Core Banking T24.

• Information research and data compilation on IT sector in CDMX through interviews, books and internet; making of documents summaries, worksheets, charts and time series.

• Data search; elaboration of reports on the progress of various employment support programs; spreadsheets; PPT presentations; and, management of the Ministry databases.