Giovanny V
Ecuador
Data engineer
$ 2,700/month
2 yrs exp
Skills
- Microsoft Excel
- Microsoft SQL Server Reporting Services (SSRS)
- Microsoft SQL Server Integration Services (SSIS)
- Python
- SQL
- Tableau
- Transact-SQL
- Power BI
- Systems Analyst
Giovanny V
Ecuador
Data engineer
$ 2,700 /month
2 yrs exp
Skills
Data engineer
• Prepared server for MS Azure Data Factory and Synapse, Azure SQL to handle data. • Installed azure SQL and loaded adata for dashboards to every department in the enterprises (ecosystem of enterprises that works with each other and other clients) • Made SQL query optimizations, data aggregations an ETL with SSIS for data improvements.
Data Analyst
• Dashboards in Power BI for human resources department and sales department. • Extracted data from Azure SQL (The one from Idatha in next experience), transformed and loaded data for dashboards with python and power query. • Made SQL server queries optimizations.
Odoo Remote Consultant
- Developed backup scripts, automatic updates for the PostgreSQL database, as well as CRUD operations that were required to be performed directly on the database. • Done PostgreSQL queries optimizations for better data management. • Reports with Tableau but using data exported from PostgreSQL to Excel.
Database Engineer
• Managed the different Oracle 11g database servers. • Made backups in HP Data Protector, PL/SQ script development, query operations, updating and/or data deletion. • Performed ETL processes with Pentaho Data Integrator and Monitoring with Oracle Enterprise Manager. • Created Dashboards with Tableau using sql server and oracle database 11g.
Smart Scores
Smart Skills