Jairo Arturo Moran Burgos

Data Engineer

Bancolombia

Nov 2023 - Current (1 year 10 months)

data enegineer

Enersinc

Aug 2022 - Current (3 years 1 month)

Advanced consultant

Enersinc

Jan 2021 - Jan 2022 (1 year 1 month)

• Build ETL for the massive information consumption in the SAM project. Consuming API and storing the information directly in the data lake in Azure using Blobs Storage. • Orchestra ted data flow with Apache Airflow eficiently through the consumption and elaboration of APIs developed with FASTAPI and deployed with Docker. • Elaborate design of the star data model type for the integration of the serverless data warehouse. • Build a mathematical optimization model for the thermal pre-dispatch (unit commitment) of the SIEMENS client. In this, a stochastic approximat ion model written in Pyomo was developed, with eficient techniques for data consumption. • Design automatic learning model for dispatch prediction. This is done by compar ing d

Data Analyst

Enersinc

Jan 2021 - Jan 2022 (1 year 1 month)

• Perform consulting on generator cycling problems, using integer-mixed optimization in Python and data management with postgresql. • Lead back-front-end development for a new functionality in the client module. I el aborated in the back the functions with postgresql and they were integrated with django from Python, in the front I specified the technical needs. • Perform activities as a data analyst for the automation of the processes of power generation supply. Where the tools used are the optimization module built in Python with cplex and postgresql functions.

X

Operation Engineer

XM Filial de ISA

Jan 2019 - Jan 2021 (2 years 1 month)

• Proficiently coordinate and control in real time the Colombia's power system and its international connections. • Plan and execute maneuvers in the power system control center. • Evaluate o perating rules through regulatory impact analysis. • Utilize D IgSILENT language to automate critical tasks, including simulations of 'blackouts' in electrical network models and the analysis of 'non-convergent contingencies by conventional load flow' in the PowerFacto ry model. These automation programs enhance the productivity and efectiveness of electrical analysts.

X

Analyst/

XM Filial de ISA

Aug 2018 - Jan 2019 (6 months)

• Played a pivotal role in systematizing the data model for the 'D EO' (Operator's Economic Dispatch) project, ensuring streamlined d ata management and improved decision-making processes. • Developed a robust Python program to forecast demand accuratel y, enabling the project to make data-driven decisions and optimize resource all ocation efectively. • Designed and implemented a script to export the Colombian electricity model from DIgSILENT PowerFactory to PSS/E raw format, facilitating seamless data migration and compatibility between critical systems.

X

Engineering intern/

XM Filial de ISA

Jan 2018 - Jul 2018 (7 months)

• Developed a Python + DPL tool, this under the project 'DIgTNA': Real-time integration of PowerFactory with the SCADA system.

X

Engineering assistant/

XM Filial de ISA

Jan 2018 - Jan 2019 (1 year 1 month)

• Orchestrated the DIgTNA's version II, where new functionalities were developed: estimated data, historical data and area model. This template • Participated in training activities against 'blackouts' with the operators was created by Slidesgo of the XM control center, using the SCADA system.

Jairo Arturo Moran Burgos

About

Detail

Timeline

Résumé