Ricardo R.

Ricardo R.

,

Experience: Year

Ricardo

43200 USD / Year

  • Notice Period: 4 Days

Year

Now you can Instantly Chat with Ricardo!

About Me

System Engineer with 8 years of experience as a Back-end Developer, developing functions, stored procedures, cursors, triggers and complex queries using mostly SQL SERVER for treatment of data. In my role as Data Engineer a contribute developing s...

Show More

Portfolio Projects

Energy Sector Project

Company

Energy Sector Project

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 Less

Financial Sector Project

Company

Financial Sector Project

Description

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 Less

Assurance Sector Project

Company

Assurance Sector Project

Description

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 Less

PPL Project

Company

PPL Project

Description

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 Less

Quora APP

Company

Quora APP

Description

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 Less

Improve Wireless Network with Two Ubiquitis antennas

Company

Improve Wireless Network with Two Ubiquitis antennas

Description

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 Less

Skills

Networking

Creating a Backup plan for SQL Server Databases

Company

Creating a Backup plan for SQL Server Databases

Description

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 Less

KPI’S for the Intensive Care Unit

Company

KPI’S for the Intensive Care Unit

Description

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 Less

Design and Implementation for the Software Development Program

Company

Design and Implementation for the Software Development Program

Description

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
Share:

Verifications

  • Phone Verified