Justin Rey Ledesma Email & Phone Number

Makati, Ncr, Ph

Makati, National Capital Region, Philippines

- Develop an End-to-End Data Warehousing Solution for an agriculture and food industry group, using Microsoft Azure Synapse Analytics that ingests data, ranging from Semi-Structured data i.e., XML, JSON and Structured Data i.e., CSV, MySQL.- Utilize integrated Azure Data Factory within the Synapse environment to facilitate XML and JSON parsing and Orchestration of General Data Pipeline workflow- Provision Microsoft Azure Resources such as Managed SQL Pool, Storage Account, Azure Synapse, while tailoring to the best fit for the business use-case.- Architected a streamlined and optimized a new data flow architecture into an existing manual-heavy pipeline.

Manila, National Capital Region, Philippines

- Provide Business Intelligence and Analytics Majors the background and knowledge in Industry Standard Toolsets and Practices to further enhance their skillset.

Makati, National Capital Region, Philippines

• Conduct Ingestion, Transformation, Extraction and Consumption of Data from different Data sources ranging from flat-files, external database sources, and Big Data Platforms to Cloud based systems (Databricks), by using custom frameworks tailored for the data. • Develop jobs and DAGs in Apache Airflow as part of orchestration and scheduling tasks to automate data orchestration.• Perform exploratory data analyses as part of validation efforts of data from source tables to target platforms.• Synthesize DDL scripts for the Physical Tables from Hive being Migrated to Databricks, by utilizing Azure DevOps Repository and CICD Pipelines, for seamless integrations.• Create jobs in Databricks for different tasks ranging from dumping data into the Azure Data Lake Services, Tests for Datasets for Data Validation, etc.,• Migrate Assets from the On-premises Big Data Platform (Hive) into the Cloud Unified Data Platform (Databricks) as part of the Assets Migration Project.• Implement a data warehouse structure following the Medallion architecture strategy to ensure robust data governance and validity

Houston, Texas, United States

• Developed Comprehensive and intricate SQL queries while collaborating with fellow data developers to extract targeted business data, enabling the extraction of actionable insights for informed, data-driven decision-making, as part of Data Analytics Initiatives.• Played a key role in reconfiguring the data warehouse middleware (ETL process) to rectify data discrepancies, by conducting Exploratory Data Analyses (EDA) on datasets, contributing to improved data flow and accuracy within the system.• Utilized Power BI for Reporting and Leveraged it to craft comprehensive reports and dynamic dashboards, seamlessly integrating them with SQL views and queries. These reports accommodated various business requirements and visualized key performance indicators (KPIs) to derive actionable insights.• Spearhead custom AI Model metrics validation efforts through creating baseline and tuned Supervised and Unsupervised models to methodically compare it to enhance the model's efficacy.• Lead a QA team to deploy unit tests and regression tests to a migrated Data warehouse from Azure Synapse to a more budget-optimized traditional SQL Data warehouse.• Wear different hats to cater multiple business units ranging from being a Data Analyst, a Data Engineer and Data Scientist, depending on project context.

Cagayan De Oro City, Northern Mindanao, Philippines

• Lead the team of Data Science Interns, to conduct Data Science-centric initiatives applicable for the business clients.• Conducted normalization of management system Database to optimize OLTP operations tailored for business operations.• Created graphical schema and Data Model of normalized tables (OLTP)• Extract Data from different Data sources (i.e., OLTP DB, Flat files (i.e., CSV)) to visualize and produce valuable insights.• Perform Exploratory Data Analysis using Python and SQL to transform and aggregate data, for Data Visualizations purposes using Matplotlib and Seaborn.