Data Cleaing
Ivan Ballinas Zayas
ING. DE SOFTWARE
Huejotzingo,PUE
Summary
Business intelligence professional with solid experience in data analysis, reporting, and visualization. Adept at utilizing tools such as SQL, Python, and Power BI to drive business insights and strategic decision-making. Strong focus on team collaboration and achieving results, adaptable to changing needs, and reliable in delivering high-quality outputs. Proven ability to translate complex data into actionable solutions, enhancing operational efficiency and business performance.
Overview
13
13
years of professional experience
16170
16170
years of post-secondary education
1
1
Language
Work History
Bussines Intelligence Developer
MCON
Remote
06.2020 - 04.2025
- Improved data gathering, analysis, and visualization procedures with strategic optimizations.
- Developed and managed dashboards using AWS Glue, Quicksight
- Monitored and optimized SQL server performance.
- Collected data from wide-ranging sources.
- Optimized data processing for faster insights by designing efficient ETL processes and data models.
- Planned, designed, and implemented diverse business intelligence solutions.
- Oversaw database upgrade, backup, recovery and migration.
Data Base Developer
E-CONTACT
Puebla, Mexico City, Mexico (Remote)
12.2016 - 06.2020
- Oversaw day-to-day activities of five employees in Data Base area establishment.
- Developed custom reports using SQL queries to provide valuable insights for management decision-making processes.
- Enhanced end-user experience by optimizing front-end queries in applications using SQL Server as the backend database solution.
- Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
- Optimized complex SQL queries for faster report execution times and reduced server load.
- Improved database efficiency by optimizing SQL queries and implementing performance tuning techniques.
.NET Software Developer, Full Stack
E-CONTACT
Puebla City, Puebla, Mexico
12.2013 - 12.2016
- System maintenance in ASP.NET and VB.NET
- Migration of systems using ASP.NET technologies to MVC 4 .NET
- Development of bussines applications with .NET, C#, and VB.NET
- Requirements gathering, use case generation, and UML diagrams.
- SQL Database management for Server (2005, 2008, 2014)
Full Stack PHP Developer
Mangoo Software
Puebla City, Puebla, Mexico
10.2012 - 12.2013
- Designed responsive websites using HTML, CSS, and JavaScript, ensuring optimal viewing experience across devices.
- Developed custom WordPress themes and plugins for clients'' specific needs, enhancing their online presence.
- Integrated third-party APIs into web applications, expanding functionality for users.
- Worked closely with UI/UX designers to implement pixel-perfect designs that met client expectations.
- Planned, coded and deployed web-based applications using PHP, MySQL and JavaScript.
Education
Unfinished Master's Degree - BUSSINES INTELLIGENCE
UNITEC
Mexico City, Mexico 05.2001 - 11.2019
Software Engineer - Software Engineering
UPAM
Puebla, Mexico City, Mexico01-2012
ITIL IT Service Management -
People Cert
Intermediated Android Studio Developer -
It University
Advanced Android Studio Developer -
It University
SQL Server Optimizacion & Performance -
Educacion It Argentina
Administering Microsoft SQL Server 2014 Databases (20462) -
Educacion It Argentina
Basics Mongo DB -
Educacion It Argentina
Advanced Mongo DB -
Educacion It Argentina
Data Analitycs And Visualization -
Educacion It Argentina
English Learing -
GLISH
05.2001 -
Skills
Python programming
ETL development
SQL programming
Data dashboard design
Database management
Requirements gathering
Performance tuning
Data warehousing
Proficient in AWS
Business intelligence tools
Problem-solving
Microsoft Bussines Intelligence Suit
Interests
Artifiicial Intelligence
Data Analisys
Timeline
Bussines Intelligence Developer
MCON
06.2020 - 04.2025
Data Base Developer
E-CONTACT
12.2016 - 06.2020
.NET Software Developer, Full Stack
E-CONTACT
12.2013 - 12.2016
Full Stack PHP Developer
Mangoo Software
10.2012 - 12.2013
Unfinished Master's Degree - BUSSINES INTELLIGENCE
UNITEC
05.2001 - 11.2019
English Learing -
GLISH
05.2001 -
Software Engineer - Software Engineering
UPAM
ITIL IT Service Management -
People Cert
Intermediated Android Studio Developer -
It University
Advanced Android Studio Developer -
It University
SQL Server Optimizacion & Performance -
Educacion It Argentina
Administering Microsoft SQL Server 2014 Databases (20462) -
Educacion It Argentina
Basics Mongo DB -
Educacion It Argentina
Advanced Mongo DB -
Educacion It Argentina
Data Analitycs And Visualization -
Educacion It Argentina