Cesar G.

Bi/Etl Developer

435 dollar
Freelancer
10 years
Mexico City, MEXICO

My experience

More

The Store IntelligenceJanuary 2020 - Present

 Analysis of data and Dashboards creation.
●Used tools: Power BI
●Excel
●TSQL

More

BICMay 2019 - December 2019

Develop, update and maintenance of SSIS packages for extraction, transformation and load of data for DWH implementation
● Used tools: Data Tools 2017 
● SQL SERVER 2017
● TSQL


More

SODIMACNovember 2018 - May 2019

Develop, update and maintenance of SSIS packages for extraction, transformation and load of data from SQL Server databases and flat files to SQL Server databases and flat files.
● Used tools: Data Tools 2015 
● SQL Server 2014
● SQL Server 2016
● TSQL


More

Grupo ADO, Proyecto GlobalSeptember 2018 - November 2018

Develop, update and maintenance of SSIS packages for extraction, transformation and load of data for DWH implementation 
● Used tools: Data Tools 2014 
● SQL Server 2014
● TSQL
● Oracle 
● Postgress


More

Wal Mart MexicoSeptember 2017 - August 2018

Develop, update and maintenance of SSIS packages for extraction, transformation and load of data for DataMart and Datawarehouse. Within SSIS packages creation and reading of XML and JSON files, email sending, flat files manipulation and few other .Net Framework usage  
● Used tools: Data Tools 2014 
● SQL Server 2014
● TSQL


More

Grupo ADO, Innovación y Desarrollo TecnológicoNovember 2013 - August 2017

● Generation, maintenance, update and optimization of queries, views, SP, functions, agent jobs 
● Creation and maintenance of tables with constraints to ensure the integrity of the information.
● Migration of data structures between database engines (upgrade & downgrade SQL Server). 
● Database Normalization. 
● Best practices implementation. 


More

Grupo ADO, Empresas ComercialesMay 2011 - October 2013

● Develop, update and maintenance of SSIS packages for extraction, transformation and load of data for Oracle DWH using SQL Server and postgress sources
● TSQL

Used tools: Business and Intelligence Development Studio 2008 


My stack

Business Intelligence

Power BI, SSIS, SQL Server Integration Services

Others

Data Migration

Technologies

.NET Framework

Computer Tools

MS Office, MS Excel, Microsoft Excel

Environment of Development

SQL Developer

Protocols

JSON

Databases

Microsoft SQL Server 2005, PostGreSQL, SQL Server CE, SQL Server 2014, MySQL, Oracle, Database Administration, Microsoft SQL Server, SQL Server 2000/2005/2008, SQL Server 2008 R2, SQL Server 2017, SQL Server 2012

Languages

VB.NET, T-SQL, XML, ASP.NET, C#

My education and trainings

- Courses

Computer Engineering - The National Autonomous University of Mexico2006 - 2011