Kevin Ilama Portuguez
Data Engineer
Dedicated and meticulous professional with experience across diverse fields such as customer service, collecting requirements based on the client's specifications and deliver solutions. Technology enthusiast in a continuous improvement development path.
About Me
I'm a Data Engineer with expertise in designing and implementing data solutions that drive business insights and decision-making. My experience spans across financial institutions and technical consulting, where I've developed robust ETL processes, optimized database performance, and created impactful reporting solutions.
I specialize in SQL development, Power BI reporting, and data integration, with a strong focus on data quality and performance optimization. My approach combines technical expertise with a deep understanding of business needs to deliver solutions that make a real impact.
Professional Experience
Data Engineer
Financial institution Coopelianza
Electronic Channels Management (Payment Methods, Credit & Debit Cards, Electronic Channels, Supplementary Services)
Power BI Development: Engineered reporting solutions utilizing PL/SQL, Oracle, and Alteryx, incorporating subqueries, CTEs, and complex joins to meet organizational objectives.
ETL Optimization: Streamlined data extraction, transformation, and loading (ETL) processes with Azure Synapse, ensuring high data quality for Power BI visualization.
Data Integration: Migrated tables from Oracle PL SQL to Azure Synapse, converting data to Parquet format and creating views to enhance performance, focused on Data Lake star schema method, and bronze, landing and silver to manage data.
Process Improvement: Developed differential loading processes via pipelines and procedures, significantly boosting data integration efficiency.
Technical Consulting Engineer
CCS Globaltech
SQL Development & Reporting
SQL Expertise: Applied advanced SQL techniques, including CTEs, window functions, and procedures, to meet diverse reporting needs.
SSRS Reporting: Designed visually impactful report templates using SQL Server Reporting Services (SSRS).
Database Design: Created a staging database for data conversion, supporting smooth implementation in SQL Server.
Data Mapping: Conducted precise data mapping and loading into production databases, maintaining data accuracy and system integrity.
Seller Partner Support
Amazon
Customer Service for Vendors Support
Vendor Assistance: Provided high-level support to Amazon sellers, managing tasks such as spreadsheet uploads, chargeback disputes, and transportation coordination via phone and email.
Process Enhancement: Improved service procedures while maintaining exceptional customer service standards.
Technical Skills
Education & Certifications
Education
Bachelor's degree in Systems Engineering
Universidad Latina de Costa Rica
Pérez Zeledón, San José
Expected Graduation: April 24 2025
Talent Development Program
CCS Globaltech
Pérez Zeledón, San José
Certifications
Prolaw SQL Certification
Issued by Thomson Reuters
Alteryx Designer Specialist Certification
Issued by Panda Analytics
Power BI Participation Certificates
Issued by Panda Analytics
Power BI Service, Business Cubes, Data Exploration, Cubes with DAX
Featured Projects
Get In Touch
Contact Information
Reach out through any channel