Data Engineer with 20+ years in Data Warehousing and ETL

Zoleida Morales

Orlando +1-689-***-**** ********@*****.*** Data Engineer linkedin.com/in/zoleida-moralesa/ SUMMARY

Accomplished Data Integration Engineer with 20+ years of experience in Business Intelligence, Data Warehousing, Big Data processing, and ETL development. I am an expert in Snowflake, Python, Azure, Fabric, AWS and Spark, with deep expertise in cloud-based data solutions and modern data architecture. Proficient in both SQL and No-SQL databases, with a strong track record of designing and optimizing Snowflake data warehouses to enhance performance, scalability, and cost efficiency. Demonstrated success in maintaining operational reliability and delivering efficient, scalable solutions for a global clientele. Proven ability to lead cross- functional teams and manage projects using Agile methodologies such as Scrum, ensuring data consistency and accessibility for business insights. Highly skilled in system enhancements to drive enterprise analytics dashboards and reporting, leveraging BI tools like Power BI, Tableau and Snowflake’s advanced features such as data sharing, secure data exchange, and performance tuning. EXPERIENCE

Data Integration Engineer Perficient – Optum U.S. 10/2021 to Present CLIENT: Optum – Triple S

Leading and largest health insurance company in Puerto Rico, for more than 60 years. Responsibilities:

Designed and implemented ETL processes (including joins, transformations, normalizations, and aggregations) to support reporting and dashboard creation for Triple S.

Built data pipelines aimed at cleansing, normalizing, and integrating data to ensure consistency and provide a unified source for reporting and analytics. Utilized SQL, SSIS, Python and Azure Data Factory to streamline workflows and optimize data processing for accurate business insights. Designed and implemented end-to-end data engineering solutions using Microsoft Fabric and Azure Synapse, optimizing SQL-based transformations and queries for high-performance analytics. Handled incident reporting, testing, debugging, monitoring, and auditing of data infrastructure. Designed a cloud-native ETL process using Azure Data Factory (ADF) to orchestrate data ingestion, transformation, and load from flat files in Azure Blob Storage into Snowflake.

Hands-on experience designing and implementing dashboards using Power BI, Tableau, and Sigma to support strategic decision-making across Finance, Accounting, and Operations teams.

Configured Azure Role-Based Access Control (RBAC) and Managed Identities to ensure secure, role-based access to Blob Storage, Azure Functions, and ADF in a production environment.

Automated monitoring and alerting using Azure Monitor and Application Insights for pipeline and Azure Functions executions. Created technical documentation and run books to support the maintenance and support of daily operations. CLIENT: SOE360

SOE 360, or Soluciones Empresariales 360 S.A.S., is a Colombian company founded on December 31, 2014, following the spin-off of GECOLSA. It serves as a strategic partner for Caterpillar distributors in Colombia and the Caribbean region, centralizing support tasks in areas such as finance, supply chain, and information technology. Its goal is to enhance the operational efficiency of its clients, allowing them to focus on their core activities. Responsibilities:

Analyzed data from multiple sources in Snowflake to generate insights and support decision-making. Designed and developed an optimized data model in Python to improve data structure and efficiency. Created and implemented a chatbot using Cortex Analyst to enhance user interaction and automation. Performed data transformations and validations to ensure data quality and consistency. Collaborated with cross-functional teams to integrate data solutions with business processes. Business/Technology Value

Developed a PoC for a Snowflake-based data lake, demonstrating a 50% reduction in query times and a scalable solution for future data growth.

Senior Data Engineer KOMET SALES – Colombia 01/2023 to 02/2024 Managed tools such as Snowflake, Python, Fivetran, Mozart Data, and DBT. Administered and optimized multiple Fivetran Standard Connectors to ensure reliable, secure, and efficient data ingestion across various platforms. Enforced an Infrastructure as Python code process to ensure efficient deployment and maintenance of data infrastructure. Developed and maintained custom connectors using the Fivetran Connector SDK to integrate non-standard or proprietary data sources. Curated, tested, and documented the data model.

Set up alerting systems to monitor the health of our data infrastructure. Monitored connector performance and implemented proactive alerting to minimize data latency and downtime.

Led or supported the migration of data cubes from Sinse to Sigma, which significantly improved data visualization and analysis for end-users. User and Role Administration: Was responsible for the complete administration of users and roles within Sigma, including creating, modifying, and managing permissions to ensure data security and proper access control. Designed, developed, and maintained a product that provides external access to data warehouse. Stayed up to date with industry trends and continuously improving our infrastructure management processes. Developed and maintained predictive models, dashboard extracts, and machine-learning algorithms using DataRobot and Azure Machine Learning Studio. Big data and analytics specialist TIGO Colombia 04/2011 to 10/2021 Managed, analyzed, and designed BI, Big Data, and Analytics projects involving data warehouses, reports, cubes, KPIs, dashboards, and data models. Executed end-to-end migration of Tableau reports and BI dashboards from on-premises servers to cloud platforms, ensuring performance optimization and data integrity.

Developed and optimized ETL processes (joins, transformations, normalizations, and aggregations) for key reports and dashboards for the internal users, ensuring data pipelines delivered cleansed, normalized, and consistent data for reporting and analytics. Collaborated with cross-functional teams to define and manage project scopes, overseeing vendor relationships and progress using Scrum methodology. Worked extensively with SQL, SSIS, SSRS, SSAS, Oracle, PySpark, Python, Tableau, Sigma, Cloudera Big Data platform, AWS and Azure to drive data- driven solutions and insights.

Managed customer engagement projects, modeling data flows, and ensuring the reliability and maintenance of model data flows. Handled large volumes of data integration, cleansing, and production support concepts, ensuring reliability. Business Intelligence Developer Intergrupo S.A. - Colombia 10/2009 to 04/2011 Designed and developed ETL processes (including joins, transformations, normalizations, and aggregations) to support the creation of reports, analytics software applications, and dashboards for EPM (Medellin Public Services Company). Built data pipelines to cleanse, normalize, and ensure consistency, providing a unified data source for reporting and analytics functions. Utilized SQL, SSIS, SSRS, SSAS and Azure to streamline data processing and improve the efficiency of reporting systems. Conducted incident reporting, testing, debugging, and monitoring of data systems to maintain operational reliability. Created run books and technical documentation to support operational readiness and maintenance. Data Team Coordinator Arkix S.A.S. - Colombia 06/2007 to 10/2009 Led the database team by gathering requirements, analyzing them, and assigning tasks to the team for development, ensuring quality assurance throughout the process and delivering the final product to clients. Performed detailed analyses of database processes to support relational marketing for clients such as Sofasa, EMI, and Totto, managing CRM relationship programs and loyalty campaigns tailored to each client's needs. Managed multiple projects, overseeing their organization, timelines, and budget compliance by following detailed project management plans. Directed the database department, managing client requirements and requests. Analyzed and delegated tasks to the team, reviewed their work, and delivered high-quality results to clients. Conducted database process analyses to support relational marketing for clients like Sofasa, EMI, Totto, and Codensa, managing CRM programs and campaigns based on client-specific needs.

Aligned projects with client strategies, managed resources and task assignments, set project costs, handled scope, ensured quality and timeliness, managed risks, coordinated contracts, and oversaw communication and project closure. Developed predictive models and used data mining techniques to support marketing strategies and CRM implementations. Designed decision trees, logistic regression, and random forest models to support business analytics and operational decisions. Business Intelligence Consultant Igerencia S.A. - Colombia 09/2003 to 06/2007 Collaborated with stakeholders to analyze business requirements and translate them into technical specifications, designing improvements and developing new application modules tailored to client needs.

Programmed enhancements and new modules for Sofasa using SQL, SSIS, and ASP.NET, ensuring seamless integration with existing systems and improving overall application functionality.

Developed and optimized SQL queries and implemented SSIS packages to streamline data integration, automate workflows, and improve data processing for various projects.

Contributed to the BIC Familia Project, focusing on the certification, assembly, and management of distributors by utilizing SQL and SSIS to ensure accurate data flow and process automation.

articipated in testing new modules and improvements to ensure high performance, accuracy, and compliance with client requirements before deployment. EDUCATION

Master of Science in Big Data and Data Science Universidad Internacional de Valencia 2023 to Present Master’s degree in general management with emphasis on project management Universidad Europea de Monterrey 2020 to 2021 Master's degree MBA specializing in Project Management Instituto Europeo de posgrados 2017 to 2018 Specialist’s degree in Software Development Universidad EAFIT 2005 to 2007 Bachelor’s degree on System Engineer Universidad de Medellín 1997 to 2004 SKILLS

**Languages & Tools**: Python, JavaScript, SQL, DBT, SSIS, SSRS, SSAS, Informatica PowerCenter, Fivetran, Git, GitLab, Snowflake, Oracle DB, Sigma, Power BI, Tableau

**Cloud & DevOps**: Azure Data Factory, Azure Cosmos DB, Azure Synapse Analytics, Fabric, AWS S3, AWS Lambda, AWS MWAA (Managed Airflow), IAM, Azure Machine Learning Studio

**Data & Modeling**: Data Warehousing, Big Data, Data Integration, ETL/ELT, Predictive Modeling, Data Lake, Airflow DAGs, Data Governance

**Methodologies**: Scrum, Agile, CI/CD, Project Management

Contact this candidate