Jhonatan Espitia

Work History

Alexandra Lozano Immigration Law PLLC

06.2024 - 04.2025

Designed and implemented ETL pipelines integrating data from multiple sources, including Salesforce, Facebook Marketing API, and internal databases, leveraging Python, Airflow, Docker and Git Actions.
Led and optimized three large-scale data migration initiatives in Salesforce. Collaborated in the planning phase using spreadsheets to map data transformation rules across complex combinations. Developed automation scripts in Python using requests and simple_salesforce, efficiently combining SOSL/SOQL for extraction and Bulk/Bulk 2.0 APIs for high-volume inserts and updates.
Developed 5 Power BI dashboards focused on marketing analysis and actionable insights.
Engineered a scoring system to calculate optimal city routing based on custom parameters, utilizing Google Maps and Open Route Service APIs.
Developed strategies to enhance collaboration and version control for Power BI dashboards by utilizing Git, Python, and PBI-tools, leveraging TMDL and TOM features.
Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.

Optum

04.2021 - 05.2023

Created over 15 dashboards to monitor and track key performance indicators in Power BI.
Identified, analyzed and interpreted trends or patterns in complex data sets.
Automation of recurring tasks using Python and Power Automate.
Created ETLs using airflow and dbt to extract data from different sources (APIS, Internal forms, external sources) and load it into Snowflake warehouses (using star and snowflake schemas).
Financial and payroll reports.
Database maintenance in SQL (Security and control).
Produced monthly reports using advanced Excel spreadsheet functions.
Reduced operating costs by automating manual data processes using scripting languages such as Python or R and Power Automate.
Advanced data analysis for decision-making with machine learning projects using R Studio.
Reports in Excel (Pivot Tables, OLAP queries, VBA).
Developed 5 apps in Power Apps to enhance user experience and data collection.

11.2020 - 04.2021

Provide assistance and resolve inquiries from patients and clients via phone, email, and chat.
Handle and resolve complaints and complex issues efficiently and professionally.
Train and support new customer service representatives.
Oversee and manage patient cases from start to resolution.
Collaborate with other departments such as billing, clinical, and technical to resolve patient issues.

Teleperformance

09.2019 - 11.2020

Provide assistance and resolve customer inquiries via phone, email, and chat across various campaigns.
Handle and resolve complaints and complex issues efficiently and professionally in different contexts.
Quickly adapt to the specific procedures and policies of each campaign.
Collaborate with different departments to ensure effective resolution of customer issues.
Maintain accurate and detailed records of all customer interactions in the CRM system.
Participate in training and update sessions to improve customer service and adapt to new campaigns.