Giovanny Vizcaya

Bachelor of Systems Enginnering (BE)

2007 - 2012

Universidad Nacional Experimental Politécnica de las Fuerzas Armadas, Caracas - Barquisimeto, Venezuela

Database Management Specialist

Data Analyst (Volunteer Hybrid)

2022 - 2023

La Bodeguita - Barquisimeto, Venezuela.

• Just a work used to help a friend to organize his store inventory and increase sales revenues.
• Collected data from existing products in the store and registered in MS Excel.
• Created dashboard in Power Bi to analyze the current distribution of the liquor store's products.
• Reorganized products in stored based in product quantities, it means, more product, more sales.
• Increased 5% in store sales revenues after reorganizing products in store.

Data Analyst / Data Engineer (Remote)

2022 - 2023

Pyxis Uriguay / Idatha Colombia

• Conducted the design and implementation of Azure Data Factory (ADF) pipelines for data ingestion, transformation, and loading. Successfully orchestrated complex ETL workflows to move and process data from on-premises sources to Azure Data Lake Storage and Azure SQL Data Warehouse.
• Extracted and analyzed human resources and sales data from PostgreSQL database source, then exported to MS Excel for data analytics in MS Power BI.
• Designed data visualization dashboards with MS Power BI in collaboration with sales and human resources departments.

Python Developer / Data Analyst (Hybrid)

2022 - 2023

Adriana Hoyos Corporación - Quito, Ecuador

• Integrated data from PostgreSQL databases sources, using REST APIs developed with Python. Also wrote custom Python scripts and SQL queries for data extraction, transformation and load into other database sources.
• Developed interactive and insightful dashboards using Power BI and Tableau, enabling business stakeholders to visualize data trends, make informed decisions, and track KPIs. Reduced reporting time by 40% by automating routine reporting processes.
• Utilized Python for data extraction, transformation, and analysis. Implemented statistical models to uncover actionable insights from complex datasets, resulting in a 20% increase in sales revenue.

Python Developer / Data Analyst (Remote)

2022-2022

ConsultIT - Costa Rica

• Collaborated with Odoo developers to customize the Stock Module to meet specific client requirements. Automated routine tasks and notifications for stock replenishment and order processing.
• Conducted data cleanup activities to eliminate duplicate records and inconsistencies in the Odoo Stock Module. Implemented data validation checks to maintain data accuracy.
• Extracted, transformed, and loaded (ETL) data from clients' existing systems into the Odoo Stock Module.
• Implemented seamless integration with other Odoo modules to ensure data consistency across the entire ERP system.

Database Administrator (Remote)

2021 - 2022

Confidential Client from Spain

• Conducted database administration, providing timely support and maintenance for clients located globally.
• Led data migration projects, assisting clients in migrating data from legacy database systems to PostgreSQL.
• Ensured data consistency and minimized downtime during migration processes.
• Successfully planned and executed PostgreSQL version upgrades for clients, ensuring data compatibility and minimal service disruption. Also, automated routine maintenance tasks, including vacuuming and analyzing, to optimize database performance and reduce manual intervention.

Special Services Engineer (On-Site)

2018 - 2020

Telefónica Ingeniería de Seguridad – Quito, Ecuador

• Managed Windows Server, Linux (Red Hat, CentOS, Ubuntu), and Unix-based server environments, implementing best practices for system administration.
• Created and maintained detailed documentation for server configurations, network topologies, cybersecurity guides and disaster recovery procedures, facilitating knowledge transfer and compliance.
• Successfully planned and executed database upgrades and migrations, ensuring minimal downtime and data consistency during the transition to newer Oracle versions.
• Collaborated with development teams to ensure the availability and performance of applications and database queries.

Database Engineer (On-Site)

2016 - 2018

Inter - Barquisimeto - Venezuela

• Managed and maintained multiple Oracle database instances, such as Oracle 11g and Oracle 12c, for clients across diverse industries, ensuring optimal performance, reliability, and data integrity.
• Collaborated closely with system administrators, network engineers, application developers, and business analysts to ensure seamless integration of Oracle databases with the overall IT ecosystem.
• Utilized Oracle Enterprise Manager (OEM) monitoring tools to proactively monitor database performance, identify anomalies, and take preventive actions to ensure uninterrupted operations.
• Developed and maintained automated database administration scripts and jobs using PL/SQL and shell scripting, streamlining routine tasks, and reducing manual intervention.

Systems Analyst / Python Developer / Project Leader (On-Site)

2014 - 2015

Apis Consultores C.A. - Barquisimeto - Venezuela

• Successfully led and managed Odoo ERP recruitment module implementation project for client. Oversaw project lifecycle and post-implementation support.
• Administered PostgreSQL databases supporting Odoo implementations. Managed database installation, configuration, optimization, and maintenance to ensure high performance and data integrity.
• Conducted training sessions for clients' teams to enable them to effectively use and manage their Odoo systems. Facilitated knowledge transfer to ensure clients' self-sufficiency post-implementation.