Alejandro S.

Alejandro works as a Senior Data Engineer at GBM, the largest brokerage firm in Mexico with an active user base of over 4 million

Alejandro is responsible for designing, developing, and maintaining data pipelines, primarily in AWS, with some on-premise processes using Microsoft technologies.

Among his key projects, Alejandro plays a pivotal role in optimizing the user retention data generation process, ensuring more accurate and efficient reporting

He also develops a new process to calculate the total number of securities held by each client, improving client asset tracking

Alejandro participates in a project focused on monitoring customer operations to ensure regulatory compliance, a crucial aspect of the financial services sector.

Additionally, he leads training sessions on Git best practices, promoting proper version control within the development team.

He also champions the use of productivity and quality tools such as SQLFluff, SQLLineage, and Pydantic, encouraging the adoption of standards that improve data consistency and code quality.

Alejandro is also involved in prototyping and proof of concepts for new technologies.

He experiments with Snowflake and dbt to create data transformations, tests Dagster as an alternative process orchestrator, and explores Streamlit as a data visualization tool, contributing to the continuous innovation of data processing and reporting capabilities at GBM.

At Tauros, a company focused on providing Mexican users access to cryptocurrencies, Alejandro was responsible for designing the data analysis infrastructure and extracting and consolidating information from various cryptocurrency network providers.

His work also involved maintaining the backend of the Django application used to calculate trading operation profits.

One of Alejandro's key projects was the development of a platform prototype for data analysis, built using Redshift, Apache Airflow deployed with Docker, and Power BI.

This platform streamlined the process of analyzing and visualizing large volumes of data.

Alejandro also developed a dashboard to monitor user assets under custody, tracking the profits each user contributed to the company.

Additionally, he created a dashboard for analyzing portfolio balances of assets, distinguishing between hot and cold wallets, which was essential for balancing crypto holdings.

Alejandro also worked on reports consolidating portfolio balances across various exchange and trading providers, such as OSL and BitGo.

He contributed to the maintenance of compliance reports for the SAT (Mexico's tax authority), initially generated through a FastAPI and later migrated to Django management commands.

Furthermore, Alejandro developed REST APIs using Flask to simulate the APIs of third-party providers that could not be accessed in development environments due to regulatory constraints.

During his time at Konfio, a fintech startup focused on providing credit to Mexican SMEs, Alejandro created and maintained data structures and ETL processes that made information accessible to the credit analysis team.

He also played a key role in developing dashboards using Tableau for data analysis and reporting.

One of Alejandro's major projects was an end-to-end analysis of customer payment behavior

This involved creating the necessary tables, designing the ETL processes, and developing a Tableau dashboard to visualize customer payment days, which helped the credit analysis team make more informed decisions.

He also developed a Tableau dashboard to analyze customer debt and their historical behavior, providing valuable insights into financial trends.

Additionally, Alejandro worked on a customer segmentation project based on payment behavior, which allowed Konfio to better tailor its credit offerings to different customer profiles and optimize the loan approval process.

At BBP & IT, a consulting firm specializing in IT services, Alejandro was assigned to one of the company’s largest clients, Tupperware.

He was responsible for designing new data structures and ETL processes within the company’s on-premise infrastructure, preparing for the upcoming cloud migration.

Among his key projects, Alejandro developed ETL processes and data structures for sales data specific to Mexico, ensuring efficient data management and integration.

He also created data structures and ETL processes for product manufacturing information, which helped optimize operations.

Another significant project involved consolidating various production lines in Mexico and streamlining reporting and analysis.

Alejandro also provided advisory services to the team, assisting with creating "set analysis" expressions in Qlik Sense, which enhanced data analysis capabilities.

Additionally, he guided the migration of Qlik dashboards to Power BI, reworking "set analysis" expressions into DAX, ensuring a smooth transition and improved reporting functionalities.

At Innsol, Alejandro was responsible for developing several key web applications and platforms to support government projects.

One of his main projects involved creating a web application for conducting citizen surveys, with teams working across geographically distributed areas.

The application allowed for the visualization of indicators in geographic polygons within Google Maps.

Alejandro was responsible for the backend development and also contributed to some frontend aspects, which were written in TypeScript and Ionic.

He also developed a web application for managing government actions and projects organized by geographic zones.

The backend was built using Django, while the frontend was developed with Vuetify, ensuring a smooth and responsive user experience.

In addition, Alejandro created a data analysis platform featuring on-premise data.

This platform utilized Python to monitor directories and ingest files into a database, with process orchestration handled through Dragster. Data visualization was achieved using Streamlit and Power BI, allowing efficient insights into large datasets.

Another notable project Alejandro worked on was the development of a REST API for validating addresses by searching for neighborhoods using postal codes.

This API, built with Flask, utilized SEPOMEX data to provide accurate location information, supporting various government initiatives.

While at Grupo Pinsa, the largest tuna company in Latin America, Alejandro worked as a BI Developer, leading several business intelligence projects.

He was responsible for developing dashboards to track sales budgets, profit and loss, and accounting consolidation across different companies within the group.

Alejandro also developed web applications to support operational and financial processes, including a project tracking tool with a Gantt chart focus, a file importer to complement data for dashboards, and a service to manage cash flow for accounting departments.

Additionally, he extended and maintained ETL processes to integrate data with Microsoft and Oracle tools in both web and cloud environments.

Alejandro’s key projects included developing a dashboard to track monthly sales budgets across business units and creating a profit and loss dashboard for the canned goods business unit.

He also worked on a consolidated accounting dashboard that integrated data from all group companies, providing a unified financial overview.

He created a Django-based web application for ingesting support files to populate the accounting and budget dashboards, streamlining financial data updates.

Alejandro also developed a web application to manage projects and generate Gantt charts for Hotel Estrella del Mar, improving the tracking of various initiatives.

One of his notable projects was automating the downloading of reports from Oracle EBS Cloud and transferring them to on-premise databases, enhancing reporting efficiency.

He also maintained ETL processes to ensure the proper ingestion of data into the group’s Operational Data Store (ODS).

Lastly, Alejandro worked on projecting frozen tuna production costs, a critical task for optimizing the company’s production processes.

Alejandro’s career at Grupo Ceres began in IT support before he progressed to software development and ultimately became the IT coordinator.

As a developer, he led several critical projects, such as generating unit costs per ton of corn for the commercial division.

He also created a REST API in the .NET framework to connect the internal ERP with web technologies through DLL interoperability, and developed a web application for Human Resources based on Django.

He was responsible for building a customer operations monitoring system to ensure regulatory compliance with anti-money laundering laws for the financing and warehousing divisions.

Alejandro renewed the company’s web portal written in ASP.NET, improving performance and user experience. Additionally, he maintained internal processes across accounting, inventory, sales, and budgeting, optimizing reports by enhancing database efficiency.

Alejandro also developed a Django-based web app for visitor registration and ticket assignments for the ExpoCeres raffle and created a Flask API to generate freight quotations for external companies working with Grupo Ceres.

As IT coordinator, his key projects included implementing QlikView as a BI tool to replace IBM Cognos, improving analysis in Human Resources, accounting, and sales.

He created QlikView dashboards for consolidated accounting indicators and led the adoption of Git for version control.

He also evaluated and developed a BPMN application prototype using Bizagi Studio to collect client documentation for integration.

Alejandro worked on BPMN projects using Django and Viewflow to approve client loans, extend credit, and manage employee loans through the savings fund.

He also built a Django library to handle all CRUD operations through a viewset with class-based views.