Scripting in python for outlier detection in the consumption of kilowatt per hour in different municipalities and regions in Colombia, also create tabulars model for dashboards in PowerBI using Dax for data visualization for differents requirements in energy consumption in Colombia.

Main tasks executed in the project:

− Dax Scripting

− Scripting in Python Using Matplotlib the major contribution for the client in this project, was the outlier detection method using matplotlib, applying standard deviation as effective method for the project.

Technologies: Python, Jupyter Notebook, Power BI, Visual Studio

Development of a Python Script for Data Wrangling, preparation and Transformation of 30 million registers for financial data, that involved the recalculation of annual and monthly paid rates for mortgage payments

Main tasks executed in the project:

− Create SQL Complex Queries in Cloudera Impala

− Scripting in Python Using Pandas the major contribution for the client in this project, was detecting insights of empty data and Wrong data that was impacting negatively in all recalculation of pay rates, the solution was to generate the correct data, for the recalculation.

Technologies: Python, Jupyter Notebook, Cloudera Impala

Development of Power Bi dashboards, using Informatica PowerCenter and Azure SQL to show insights about occupational diseases and accidents at work

Main tasks executed in the project:

- Performance Tuning in Azure SQL Tables

- Dax Scripting for Data visualization

- Create ETL Flows the major contribution was to this project was the index maintenance for the tables.

Technologies: PowerBI, Informatica PowerCenter, Sql Server Management Studio, Azure SQL

Using SQL Server and Power BI for cleaning, processing, and classifying Risk Diseases for predict the level of covid-19 contagion for the inmate population in Colombia.

Main tasks executed in the project: Create SQL Complex Queries Write measures in Power BI Create Dashboards in Power BI for show insights Migrate the Data using Pandas and NumPy Libraries in Python for automate the process The major contribution for the client was show the insights for take the best decision in the covering treatments for the risk mitigation in the COVID-19 contagion for the inmate population

Technologies: SQL Server, Python, Power BI, Excel

Development of the Quora application: Systems Log Module and Requisitions Module

Main tasks executed in the project:

− Database design

− Design of Triggers, Stored Procedures, and Complex T-SQL queries.

− Design relations between tables

− Create functions in Java to process the information between tables.

− Create functions in Java to validate and control de input and output of information This application development was an achievement for the IT area, migrating the entire requisition process that was manual to the application, was a total achievement, the general manager followed up on the application development at each stage, which was approved. It was a great success in my career.

Technologies: SQL Server, Java

Implementation of two ubiquity Wireless antennas to improve the Wi-Fi network

Main tasks executed in the project:

− Dns and Dhcp Configurations.

− Subnetting and broadcasting configurations. The main contribution was to improve the quality of Wi-Fi traffic, avoiding the loss of connections.

Technologies: Networking, Ubiquiti

Generation of Backups of the databases and information of the servers through the Cobian Backup tool.

Main tasks executed in the project: SQL Jobs for the Backup Plan SQL Queries for the Database restoration The major achievement was ensuring and securing the database copies in the server through the Cobian backup tool using a QNAP NAS solution.

Technologies: SQL SERVER, QNAP, Cobian Backup Tool.

Development of stored procedures and complex Queries for the delivery of KPIS for the Intensive Care Unit for the measurement and monitoring of critical patients admissions.

Main tasks executed in the project:

− Development of complex SQL Queries

− Create reports in the main healthcare application

− Deliver reports for the monitoring of critical patients to the medical staff the major achievement was the data constructed through the SQL queries for the BI Report was helpful to the medical staff for the determination of best treatment for the recovery of the critical patients in the minor time possibly.

Technologies: SQL SERVER, Python

Design, create and implement the Software Development program to train students with high school degrees in computer science using Java and database programming with SQL SERVER.

Main tasks executed in the project:

− Training in the basics of T-SQL

− Training in the basics of Java

− Training in the basics of Microsoft access, Word and Excel.

− Training in the basics of Windows the major achievement was that all students graduated in their technical skills, and learned the fundamentals of programming using java, SQL Server and Access during the program

Data Orchestration with Apache Airflow

Data Orchestration With Docker

Data transformation with Python for the development of a PowerBI Dashboard

Data transformation and cleaning with Pyspark

Matplotlib transformations with python

WebCrapping with Python