Now you can Instantly Chat with RICARDO!
About Me
Implemented a Tabular model for Data consumption in Several Power Bi Dashboards Improved and designed the main Data model for the Power Bi Dashboards Developed Dax Scripting for showing and project insight about the annually, monthly and weekly power...Developed Dax Scripting for showing and project insight about the annually, monthly and weekly power consumption for several fuels (Gasoline, jet fuel, petroleum and Diesel) on the Power BI dashboards Implemented an Outlier detection model using matplotlib on Power Bi dashboard to determine the most increasing production monthly and weekly for Gasoline, jet fuel, petroleum and Diesel Developed Pipelines with Azure Data Factory for Azure SQL tables Development for consumption of data, related to the production and cost of several fuels (Gasoline, jet fuel, petroleum, etc. Key skills: Dax, Python, Matplotlib, Pandas, Power BI, Analysis Services.
Show MoreSkills
-
-
-
-
- 2 Years
Intermediate
-
-
-
- 3 Years
Advanced
-
-
-
-
-
-
- 6 Years
Advanced
-
-
-
-
-
- 1 Years
Beginner
-
-
- 2 Years
Advanced
-
-
-
-
- 2 Years
Advanced
-
-
- 8 Years
Expert
-
- 1 Years
Beginner
-
- 1 Years
Beginner
-
-
- 1 Years
Beginner
-
-
- 5 Years
Advanced
-
-
- 5 Years
Advanced
-
- 2 Years
Intermediate
-
-
-
- 1 Years
Advanced
-
- 1 Years
Advanced
-
-
-
-
-
-
-
-
- 2 Years
Advanced
-
- 2 Years
Advanced
-
- 8 Years
Expert
-
-
- 2 Years
Advanced
-
-
-
-
- 1 Years
Intermediate
-
-
- 8 Years
Advanced
-
- 2 Years
Intermediate
-
-
-
-
-
-
- 8 Years
Advanced
-
-
-
-
-
-
-
Positions
Portfolio Projects
Description
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
Show More Show LessDescription
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
Show More Show LessDescription
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
Show More Show LessDescription
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
Show More Show LessDescription
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
Show More Show LessDescription
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
Show More Show LessDescription
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.
Show More Show LessDescription
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
Show More Show LessDescription
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
Show More Show Less