Leonardo Rodríguez
ETL Developer leonardo_rodriguez.01@hotmail.com
Ecatepec De Morelos / +52 55 4193 7020,Estado De México
Summary
Dependable ETL Developer with 7 years creating reliable and accurate data transformation. Strong knowledge in technologies such as SSIS, SQL Server and known for automate and optimize areas process.
Overview
9
9
years of professional experience
2
2
years of post-secondary education
Work History
Proyect Manager
Sync Up Technologies
CDMX, CDMX
03.2017 - 11.2021
- Oversaw large portfolio of projects to support teams, report progress and influence positive outcomes for key stakeholders.
- Led and assisted technical upgrade projects for clients by working and coordinating with consultants and developers for integrations.
- Led and managed staff of eight team members engaged in administering complex banking software.
- Worked with banks and department store like Banorte, PROSA, Banco Popular Colombia and Palacio de Hierro.
- Banorte was the principal client, we developed changes in transactional core named B24 Classic and B24 eps, ATM load, device handler and ATM's images flow and NIP by IVR.
- In PROSA, we implemented Mandates from Visa and Master Card, for that, we changed many CSM on B24 Classic and ATM's device handler because grew up the token´s number and impacted all transactions and bank clearing.
Senior ETL Developer
Edenred
CDMX, CDMX
08.2015 - 03.2017
- Designed integration tools to combine data from multiple, varied data sources such as SQL Server, Oracle, Excel, Web Services and plugins like AS/400.
- Trained in coding Data Warehousing, my principal experience was in star schema data model (the company chose this because it's denormalized and don´t consume big resources when you need to do inner join of many tables).
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
- Created rules for "credit card". Final user, through web platform, create rules about how would be use the credit card and all process was designed through ETLs for fill database and finally sent to PROSA.
DBA
Zéndere
CDMX, CDMX
11.2014 - 08.2015
- Designed table structures to client parameters, integrating business goals and data set characteristics to streamline data entry and processing.
- Performed data integrity inspections, referring exceptions and discrepancies to manager for amelioration.
- Created Standard Operating Procedures (SOPs) for Extract, Transform, Load operations (ETL).
- Designed data models for complex analysis needs. I designed Snowflake schema database because proposed to company use ETL and multidimensional cubes for functional areas.
- Encode stored procedures, views, triggers and querys for developer area.
- Developed an app for legal area to identify, when visited accredited people, the owner Infonavit credit.
Analyst Programmer
Infonavit
CDMX, CDMX
05.2013 - 11.2014
- Infonavit manages about 7 million housing loans. Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks in SQL Server database.
- Designed desktop user interface for CESIs (Infonavit Service Center) using .Net and SQL for design, today company still use the program nationally.
- Researched, designed and implemented, for first time, ETLs and achieve enhance critical process.
- Had an approach with several areas and I analyzed their business to automate their processes through ETLs and .Net solutions.
- Designed and coded DWH using star schema.
- Built and modeled database information with reporting services.
- Had an approach with the collection offices, help in business solutions focused on information management.
Education
Bachelor's Degree in IT Administration - Technology Education
UNITEC
CDMX 01.2014 - 04.2016
Skills
Net
C#
SSIS
SSAS
Scrum
TFS (Kanban Board)
Jira
Javascript
SQL Programming
Data Warehousing
Excellent Communication
Timeline
Proyect Manager
Sync Up Technologies
03.2017 - 11.2021
Senior ETL Developer
Edenred
08.2015 - 03.2017
DBA
Zéndere
11.2014 - 08.2015
Bachelor's Degree in IT Administration - Technology Education
UNITEC
01.2014 - 04.2016
Analyst Programmer
Infonavit
05.2013 - 11.2014