Juan Pablo Suarez
West Islip,NY
Summary
Practical database engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering several-year background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.
Overview
9
9
years of professional experience
Work History
Data Engineer
Grupo Bancolombia
Medellin
05.2021 - Current
- Optimized existing queries to improve query performance by creating indexes on tables.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Developed and implemented data models, database designs, data access and table maintenance codes.
- Created stored procedures for automating periodic tasks in SQL Server.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Created dashboards, reports, charts and graphs in Power BI y QlikView to meet user needs.
Analytics Engineer
PersonalSoft
Medellin
05.2019 - 04.2021
- Built ETL jobs for extracting data from various sources such as databases, APIs, and flat files.
- Documented processes related to data collection, storage, transformation, analysis, reporting, and visualization.
- Created reports and dashboards for tracking customer engagement metrics.
- Collaborated with product teams to define requirements for new analytics features.
Information Systems Analyst
Bancoomeva
Cali
11.2015 - 05.2019
- Updated documentation related to system configurations, processes, standards.
- Conducted research on software products to determine compatibility with current systems.
- Implemented new technologies such as cloud computing platforms into existing IT infrastructures.
- Monitored server performance in order to identify potential problems before they occurred.
- Developed and implemented procedures to ensure the security of data and access privileges.
Education
Title of Specialist - Business Intelligence
Bolivarian Pontifical University
Colombia02-2021
Bachelor of Science - Information Technology
University Of Valle
Colombia04-2008
Associate of Science - Information Technology
University Of Valle
Colombia01-2003
Master of Science - Computer Systems Analysis
Bolivarian Pontifical University
ColombiaSkills
- SQL expert
- SQL transactional replications
- SQL reporting
- Dashboard creation (Power BI, Tableau, QlikView)
- Data Warehousing
- Programming Languages: Java, C#, Net, Python
- Business Intelligence
- SQL Server Integration Services (SSIS)
- Server Analysis Services (SSAS)
- SQL Server Reporting Services (SSRS)
- Data Analysis
- Data Migration
- Data Modeling
- Scripting Languages
- Source and Version Control: Git, GitHub, SVN
- Agile Methodology
Languages
Spanish
Native/ Bilingual
English
Professional
Timeline
Data Engineer
Grupo Bancolombia
05.2021 - Current
Analytics Engineer
PersonalSoft
05.2019 - 04.2021
Information Systems Analyst
Bancoomeva
11.2015 - 05.2019
Title of Specialist - Business Intelligence
Bolivarian Pontifical University
Bachelor of Science - Information Technology
University Of Valle
Associate of Science - Information Technology
University Of Valle
Master of Science - Computer Systems Analysis
Bolivarian Pontifical University
Similar Profiles
Derlys Yurley Ruiz TorresDerlys Yurley Ruiz Torres
Universal Banker at BancolombiaUniversal Banker at Bancolombia
CARLOS TRIANA RODRIGUEZCARLOS TRIANA RODRIGUEZ
Managing Director at BANCOLOMBIA S.A. BANKManaging Director at BANCOLOMBIA S.A. BANK
Freddy Jose Soto PirelaFreddy Jose Soto Pirela
Costumer Service at BancolombiaCostumer Service at Bancolombia