Alexi Ledesma

Currently working on enterprise data migration projects for CCMSI through JBK, helping onboard new clients by converting legacy data from multiple Third-Party Administrator (TPA) systems into the CCMSI platform.

My responsibilities include:
Performing reverse engineering of legacy databases and applications to understand data models, business rules, and relationships.

Designing data mappings and

Designed and optimized ETL pipelines data processing in AWS. Migrated business logic from MySQL stored procedures to Amazon Redshift

Developed SQL solutions for data transformation and reporting

Managed Amazon RDS MySQL and Amazon Redshift environments

Automated data workflows using AWS Glue, DMS, Step Functions, and Lambda.

Collaborated with software engineers, product teams, and a

Founded and led an independent data engineering consultancy delivering database, ETL, and data integration solutions for enterprise clients across Latin America.

Led multiple concurrent projects while coordinating a distributed team of engineers, providing technical leadership, mentoring, solution design, and end-to-end project delivery.

Key responsibilities:
Delivered database engineering, ETL,

Managed, defined, developed, and architected Business Intelligence (BI) and Business Analytics (BA) projects for BluePatagon until 5 clients at time , delivering solutions for enterprise clients including Electrolux, Telefe, Bayer, PAMI, FirstData, Turnner and AUSA.
Technologies: Tableau, SSIS, Oracle, Microsoft SQL Server.

Designed and developed ETL processes, Data Marts, OLAP cubes, and reporting solutions.
Technologies: SQL Server 2000/2008, DB2/JDE, DTS, SSIS, MicroStrategy.

Performed functional analysis, data modeling, and ETL development, designing Data Marts and OLAP cubes for enterprise reporting and business intelligence solutions.

Performed functional analysis, data modeling, and ETL development, designing Data Marts and business intelligence dashboards.

Provided on-site consulting services for Client , Prosegur AR, developing and maintaining ETL processes and Data Marts.

Technologies: Teradata, SQL, UNIX, BusinessObjects, Mainframe.

Designed, developed, and implemented ETL solutions using Talend.

Designed dimensional data models and implemented Business Intelligence reporting solutions.

Developed data integration solutions for both on-premises and cloud environments.

Project: Open English (Venezuela)

Technologies: MySQL, Salesforce, PostgreSQL, Talend (Java Engine), NetSuite, Google Analytics, AWS, Pentaho, GoodData.

building the planning execution, and design the flow of automated testing strategies and project quality audits for international clients, including AMS (SensorLogic/AT&T), Citi Bank, PopUp Insider, and GTROT.

Developed and maintained automated test suites for web and mobile applications.

Technologies: Selenium IDE, Selenium RC, Hudson, Quality Center (QC).

Performed business requirements analysis and validated Data Warehouse developments and reporting solutions for statistical analysis across MIS (Management Information Systems) and OLAP platforms.
Technologies: Teradata SQL, MicroStrategy.