Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Silvio Grenzi

Avaré - São Paulo

Summary

Professional with over 20 years of experience in the technology field, working in consulting firms and in the service, telecommunications, financial, and insurance sectors.

Overview

27
27
years of professional experience

Work History

Senior PL/SQL Developer

Accenture
03.2023 - Current
  • Developed PL/SQL scripts for data loading and extraction for invoice analysis; Tuned queries to improve scripts execution performance on the database; Created pivot tables for invoices data analysis and managed updates of KPIs in PowerBI dashboards.

Senior PL/SQL Developer

Talent Four Consulting
09.2021 - 01.2023
  • Handled incidents for airfare invoice processes and payment requests using PL/SQL, Web Tool Kit, Javascript, and Jquery.

07.2022 - 12.2022
  • Participated in the VSI project, changing cost processes and analytical reports to include bonus operations; For the Conquistas project, created a commission retention calculation process for suppliers, adjusting management reports and screens.

11.2021 - 06.2022
  • Developed and automated PL/SQL processes for importing and exporting files related to Airfare invoice, enhancing company invoicing processes agile and reliability; Created a pipeline for extracting airfare reservations for consumption by fraud prevention APIs.

Business System Analyst - SQL Developer

IQVIA do Brasil
03.2020 - 09.2021
  • Analyzed Incentive Compensation demands, developed procedures, and prepared the prize and quota calculation flow; Read Excel parameters for loading into a Staging area for treatment, loading, and processing of Incentive Compensation activities; Used Microsoft TFS for document and procedure versioning; Created reports using Report Builder for prize and calculated quota extracts.

Data Analyst

Magna Sistemas
10.2017 - 03.2020
  • Data migration traffic tickets of cities in the State of São Paulo, performing analysis, extraction of legacy data, treatment, and loading of data into the PRODESP system; Created ETL (Extraction, Transformation, Loading) flows for migration data of different databases using the Pentaho Data Integration Spoon tool to load in our Oracle 12c database; Used Python to break lines of log files and extract some data for complete the traffic tickets missing informations; Used Git for versioning documentation and procedures
  • Assisted the development and support teams in creating PL/SQL Scripts to resolve incidents or meet project demands; Participated in the 'Pátio e Apreensão de Veículos' project, using the new PRODESP methodology based on SCRUM, where I carried out the database modeling for the development of the new system.

Developer Analyst

TATA Consultancy Service
07.2014 - 10.2017
  • Within this project, I validated the AIMS system integrations with other systems of the company, using PL / SQL and Java, and I participated in the production turnaround, which guaranteed performance gains in the main control application of the company LATAM.

07.2015 - 12.2016
  • I participated in the design phase of the project, being responsible for surveying the business requirements, technical and functional specifications in the areas involved until the approval of the Business Case; Managed the execution phase, controlling the activities of Infrastructure, Architecture, Quality Assurance (Chile) and development by the supplier
  • I was the point of reference for the technical and functional doubts of the project, ensuring that deadlines, costs and methodologies were met until the turn in production and control of the project.

10.2015 - 12.2015
  • I did the impact analysis of the arrival of the new aircraft in the system of Operational Flight Dispatch of the company
  • I have specified the technical and functional changes in the screens and reports, accompanying the development with the factory of improvements, homologation and turn in production.

07.2014 - 07.2015
  • Within the BCA project, I acted in front of improvements in the Flight Operational Dispatch system to adapt the system to the new aircraft seat classes, keeping the same pattern used in One World.

Suport Analyst

A5 Solutions
11.2013 - 07.2014
  • Responsible for support of Avaya systems deployed in clients, acting in the management and incident services.

System Analyst

Algren Confecções
06.2012 - 11.2013
  • Responsible for financial and billing control of the company
  • Analysis, development and maintenance of the financial management system of the company, inventory control and control applications developed in C# using MySQL database.

System Analyst

Porto Seguro
04.2007 - 05.2012
  • Responsible for systems’ support of Transport departments, Coinsurance and Reinsurance of the Company, working on projects and providing support and answering issues in Java and 4gl; Requirements gathering, development, testing, approval, implementation and monitoring of post-production package purchased for Reinsurance; With the Project Quality Control team: management of technical issues, Informix system releases, access and support, and support for new projects to improve the system of RE area.

Support Analyst

America Online (AOL)
10.2000 - 04.2006
  • Online technical support, email and phone assistance to subscribers in installation, configuration and Internet connection; Responsible for online safety service for subscribers of AOL; Participation in the senior support team providing advanced technical support to subscribers.

Computer Programmer

Instrumental Manutenção e Comércio de Instrumentos de Precisão Ltda.
06.1997 - 07.2000
  • Development of system management tools made in Delphi language, being responsible for support and maintenance
  • The system allowed instrument calibration contracts with customers; Responsible for the restructuring of the department to conform to the ISO 9002 certification in August 1998.

Education

Postgraduate - Data Science (Big Data Analytics)

Mackenzie
01.2021

ITIL Foundation V3 -

TATA Consultancy Service
07.2016

Programming C -

Escola SENAI de Informática
08.2012

SQL Server 2008 - Modules I and II -

CompuClass
05.2010

Java Academy -

GlobalCode
07.2009

Bachelor's degree - Business Information Technology

FATEC
01.2008

LINUX Systems Administration -

Escola SENAI A. Jacob Lafer – Santo André
02.2005

Technical degree - Data Processing

Colégio "Dr. Clóvis Bevilácqua"
01.1996

Skills

  • Relational Database: Oracle, MySQL, PostgreSQL, Informix, and MS SQL Server;
  • Programming Languages: Java, C#, Forms, Reports, PL/SQL, Python, R, 4gl, Delphi, and Visual Basic 60;
  • Case Tools: PowerDesign, Oracle Designer, and Rational Rose;
  • BI Tools: Pentaho Data Integration, PowerBI;
  • Business requirements gathering and preparation of Functional Specifications (documentation and prototypes);
  • Planning and execution of project testing strategies;
  • Modeling (Conceptual / Logical / Physical);
  • Service-Oriented Architecture (SOA);
  • Application design and development;
  • Project Management;
  • User support experience

Languages

English
Upper intermediate (B2)
Spanish
Elementary (A2)

Timeline

Senior PL/SQL Developer

Accenture
03.2023 - Current

07.2022 - 12.2022

11.2021 - 06.2022

Senior PL/SQL Developer

Talent Four Consulting
09.2021 - 01.2023

Business System Analyst - SQL Developer

IQVIA do Brasil
03.2020 - 09.2021

Data Analyst

Magna Sistemas
10.2017 - 03.2020

10.2015 - 12.2015

07.2015 - 12.2016

Developer Analyst

TATA Consultancy Service
07.2014 - 10.2017

07.2014 - 07.2015

Suport Analyst

A5 Solutions
11.2013 - 07.2014

System Analyst

Algren Confecções
06.2012 - 11.2013

System Analyst

Porto Seguro
04.2007 - 05.2012

Support Analyst

America Online (AOL)
10.2000 - 04.2006

Computer Programmer

Instrumental Manutenção e Comércio de Instrumentos de Precisão Ltda.
06.1997 - 07.2000

Postgraduate - Data Science (Big Data Analytics)

Mackenzie

ITIL Foundation V3 -

TATA Consultancy Service

Programming C -

Escola SENAI de Informática

SQL Server 2008 - Modules I and II -

CompuClass

Java Academy -

GlobalCode

Bachelor's degree - Business Information Technology

FATEC

LINUX Systems Administration -

Escola SENAI A. Jacob Lafer – Santo André

Technical degree - Data Processing

Colégio "Dr. Clóvis Bevilácqua"

Similar Profiles

CREATE PROFILE
Silvio Grenzi