Sol Mayra Lozano Ingeniera de Datos / Ingeniera de Software

Solution Consultant LVL 3

Snowflake

Oct 2024 - Current (1 year 7 months)

I am working as solutino consunalt for a migrarion process using snowconvert and python ocde for a banck client in the support of the ddls oriented to tables and views, validation in different levals and support ticketsSupport migration of large-scale data warehouse from Teradata to Snowflake, ensuring smooth transition of database objects and business logic.• Utilize SnowConvert and Python to convert and validate DDLs for tables and views, ensuring structural and functional parity between environments.• Perform multi-level validation of converted objects to guarantee data integrity, performance, and compliance with client standards.• Collaborate with Solution Architects and client stakeholders to resolve technical discrepancies, address NM

Sr Data Engineer

Globant

Dec 2023 - Oct 2024 (11 months)

Project: McCormick 1) Tech Lead Project: Tecpetrol 1) Sr Data Engineer - ETL development using ADF and Databricks for massive data processing from SQL, JSON, CSV databases. - Lakehouse architecture proposal for business optimization taking into account Data Governance factors on Azure / Databricks platform. - Team management and support to customer requirements.

Ssr Adv Data Engineer

Globant

Dec 2022 - Dec 2023 (1 year 1 month)

Project: GDM Seed 1) Data Engineer/MLOps Engineer - Design and implementation of ML model management oriented architecture using Azure as main cloud. - Use of databricks and mlFlow for model lifecycle development between environments. - Coordination with different development areas for the management of inputs and outputs of the model that is immersed in a business solution. - Communication and decision management with the customer.

SSr Data Architect

Globant

Apr 2022 - Dec 2022 (9 months)

Project: Disney Parks 1) Data Architect: - Development of data architecture using AWS as the main cloud for the migration of data pipelines made in AWS Glue in search of the use of Snowpipe (Snowflake feature) for the consumption of massive information from a S3 bucket and the realization of ETL using dBt for the storage of information in Snowflake tables with a previous development of data modeling between layers and finally, UC4 to orchestrate and invoke the work jobs. Project: GNB LuloBank - GNB Sudameris 1) Data Architect: - Support in the development and implementation of TO-BE architecture with AWS and CircleCI based on the extraction of information from Mambu API (core banking) with retry management, error notifications through ch

Tech Data Lead / Data Architect

Globant

Aug 2021 - Oct 2024 (3 years 3 months)

Led cross-functional data initiatives across multiple industries, combining technical leadership, data architecture, and governance expertise. Managed diverse teams and end-to-end data solutions across Azure, AWS, GCP, and Snowflake, driving data quality, automation, and performance optimization for enterprise clients.Key Achievements & Responsibilities:• Retail Client: Acted as Technical Lead for a multidisciplinary team of 10 engineers (DevOps, Data, BI) on Azure. Oversaw delivery of enterprise datasets, coordinated directly with client stakeholders, defined the Statement of Work (SOW), and managed backlog and task prioritization to align with business goals.• Salesforce Data Quality Project: Led a team of 4 in developing data quality pip

Jr Adv Data Architect

Globant

Aug 2021 - Apr 2022 (9 months)

Project: GNB LuloBank - GNB Sudameris Project: LATAM Airlines 1) Sr Data Engineer: - Development of dataflows using SQL datasources, NoSQL, Buckets and/or files with destination to a DataLake in BigQuery. - Query optimization within BigQuery. - Development of python-execution for automation and scheduling using Airflow. - Development of entity data modeling in conjunction with Data Governance. 2) Data Architect - Design of data model and architecture for an application to manage access of the company's users to the datasets within the BigQuery tool. - Development of the application based on python code, automation with Docker and Airflow within GCP Cloud Run.

Mid Data Engineer

Team International

Apr 2021 - Aug 2021 (5 months)

- Construction and maintenance of data structures and the necessary technological architectures for the ingestion, processing and implementation of large-scale applications. - SQL and NoSQL database management from query development to administration (Snowflake, Redshift, SQL Server, Azure SQL Server, Oracle DB). - Design and construction of datawarehouses. - ETL process management from different platforms (Azure Data Factory, SSIS, Talend). - Use of cloud platforms (AWS, Azure). - Service Desk support.

Senior Data Engineer

Experis

Apr 2021 - Jul 2021 (4 months)

Project: Anheuser-Busch InBev in MEXICO - SQL Database Management (Azure SQL Server, Azure Synapse) - Database architecture. - ETL process management from different platforms (Azure Data Factory, Azure Synapse). - Consulting, implementation of best practices for ETL construction, ETL deployment and consumption in reporting programs. - Dashboard construction using PowerBI

Data Engineer

Team International

Apr 2020 - Aug 2021 (1 year 5 months)

Developed and maintained data structures and technological architectures to support large-scale data ingestion, processing, and analytics applications.• Designed and implemented data warehouses and managed ETL processes across multiple platforms, including Azure Data Factory, SQL Server Integration Services (SSIS), and Talend.• Worked with SQL and NoSQL databases, optimizing queries and ensuring efficient data storage and retrieval.• Leveraged cloud BI platforms such as AWS and Azure to enable data visualization, reporting, and performance tracking.• Authored and maintained comprehensive technical and architectural documentation to support development and maintenance activities.• Provided Level 2-3 production and testing support, troublesho

Jr Data Engineer

Team International

Apr 2020 - Mar 2021 (1 year)

- Development and maintenance of data structures and the technological architectures necessary for the ingestion, processing and large-scale implementation of applications. - Handling of SQL and NoSQL databases from the development of queries as administration tasks (Snowflake, SQL Server, Oracle DB) - ETL process management from different platforms (Integration Services, Talend).

Application Development Analyst

Accenture Colombia

Sep 2019 - Apr 2020 (8 months)

- SOA architecture, integration services (ETL), Java development - Analysis, design and architecture of Middleware (SOAP,REST). - Handling of SQL databases. - Functional analysis and technical design of integration solutions for applications and legacy systems. - Definition of standards and development guidelines for REST services in the Oracle Fusion Middleware 12C platform. - Execution of estimates, approvals and work plans for software development projects. - Support to Help Desk Level 2 on Production and Testing environments.

Analyst - Developer

Accenture

Apr 2018 - Apr 2020 (2 years 1 month)

Designed and developed SOA and middleware architectures, implementing integration solutions using SOAP and REST services.• Built and maintained ETL processes through Integration Services, supporting data exchange across applications and legacy systems.• Conducted functional analysis, technical design, and documentation for integration solutions aligned with business and technical requirements.• Defined development standards and guidelines for RESTful services on the Oracle Fusion Middleware 12c platform, ensuring consistency and scalability.• Managed SQL database operations, including query optimization and data integration tasks.• Participated in effort estimation, approvals, and project planning for software development initiatives.• Prov

Application Development Associate

Accenture Colombia

Apr 2018 - Sep 2019 (1 year 6 months)

- SOA architecture, integration services (ETL), Java development - Analysis, design and architecture of Middleware (SOAP,REST). - Handling of SQL databases. - Definition of standards and development guidelines for REST services in the Oracle Fusion Middleware 12C platform.

Tutor - Developer

NativApps

Jul 2017 - Dec 2018 (1 year 6 months)

Support to projects with foreign clients in the management of PostgreSQL database using agile Scrum methodology.• Support for students on Android mobile development material through chat on the NextU platform.

Online Instructor

NativApps

Jul 2017 - Dec 2018 (1 year 6 months)

- Support to projects with foreign clients in the management of PostgreSQL database using agile Scrum methodology. - Support for students on Android mobile development material through chat on the NextU platform.

Promotor

Cabify

Jun 2017 - Aug 2017 (3 months)

- Support personnel and logistics in events. - Marketing and commercial negotiation at the Coastal level. - Management of social networks for promotions.

Stage Manager

Campus Party

Oct 2016

- Handling of exhibitors, stage equipment and organization of attendees. - Logistics of programming workshop in large masses.

Promotor

Uber

Jan 2016 - Oct 2016 (10 months)

- Support personnel and logistics in events. - Marketing and commercial negotiation at the Coastal level. - Management of social networks for promotions.

Operario CAD

MEJIA ASOCIADOS

Sep 2015 - Oct 2015 (2 months)

Encargada de la digitilizacion y alistamiento de votos en las Elecciones de Alcadia, Gobernacion, Asamblea, Consejo y Junta de Accion Comunal del 2015 en Barranquilla.

T

Tecnico en Sistemas

Jul 2015

Alistamiento, mantenimiento y monitoreo de equipos de computo usados durante la jornada de zonificacion del 2015

Research Seedbed

Universidad Autónoma del Caribe

Nov 2013 - Nov 2017 (4 years 1 month)

Sol Mayra Lozano

About

Detail

Timeline

Résumé