Global data project at PepsiCo. Worked on this project for 3.5 years under the same management. The time working there can be split into two phases: when I first joined the team and when my manager moved to another role and invited me to join the new team.For the past 1.5 year, I have worked as platform administrator for Informatica Data Governance team on Informatica Data Quality (IDQ), EDC, Axon and PowerCenter. Daily activities included system monitoring/configuration, object… Show more Global data project at PepsiCo. Worked on this project for 3.5 years under the same management. The time working there can be split into two phases: when I first joined the team and when my manager moved to another role and invited me to join the new team.For the past 1.5 year, I have worked as platform administrator for Informatica Data Governance team on Informatica Data Quality (IDQ), EDC, Axon and PowerCenter. Daily activities included system monitoring/configuration, object migration (workflows, mappings, profiles, scorecards, application deployment), user/connection creation. Also acting as an interface between business analysts and Informatica Global Customer Support. Previously, I was part of the publication sustain team for PepsiCo Data Distribution Hub, leveraging Informatica Data Integration Hub as the backbone for global data standardization and data sharing between systems. This system can be defined as a publication/subscription system based on Topics, that uses Informatica PowerCenter for data processing. One of my responsibilities was to ensure the accuracy and performance of end-to-end dataflow.Within those teams, I was working on rotation (24/7) with the global team. That expanded my understanding of the complexity and value of data speed on a global scale in one of the largest companies in the world.On both roles I had relevant participation in reducing server loads by analyzing existing scripts to achieve better performance and stability, which lead to cost reduction. Show less

Same role and team from "Infrastructure analyst for Analytics systems at SICOOB - Oct 2016 - May 2018" since I was invited to replace temporarily a person that was on leave on the period for 6 months.

Acting as data engineer, data steward and database administrator part-time at EGL Company on two projects related to city mapping having the main objective to calculate the taxation based on property sizes using geo-referential data for cities with total population near to one hundred thousand inhabitants each. Also helped improve processes and communication inside the company.

Infrastructure analyst on the analytics team of SICOOB (Financial Institution). The objective was to monitor and maintain the systems up-to-date, fast, stable. Install/administer IBM Cognos/DataStage/Netezza, PostgreSQL. Plan server typology to cope with high number of concurrent users, while providing HA-DR for servers running virtualized on IBM Mainframe. Deep dive on Cognos configuration for performance tuning. Troubleshoot and contact vendor when software issues were detected. Create… Show more Infrastructure analyst on the analytics team of SICOOB (Financial Institution). The objective was to monitor and maintain the systems up-to-date, fast, stable. Install/administer IBM Cognos/DataStage/Netezza, PostgreSQL. Plan server typology to cope with high number of concurrent users, while providing HA-DR for servers running virtualized on IBM Mainframe. Deep dive on Cognos configuration for performance tuning. Troubleshoot and contact vendor when software issues were detected. Create resource usage reports to support decision on hardware acquisition. Worked for CTS company most of the time. On Indra I was invited to temporarily replace one person on the same team. Show less

Working as data engineer, data steward and database administrator for Brazil’s capitol water distribution company on a Business Intelligence project using data warehouse. Responsible for dimensional data modelling, data loads, administer Teradata database, dashboard creation on Microstrategy. Relevant participation in derive data to provide information to decision makers on the definition of which buildings the water meters should be replaced in a city with 3 million inhabitants.

Government company that supports financially all public educational institutions of Brazil. Working as data steward, data modeler and report creation generating information for decision making for better money distribution. Responsible for loading annual data on corporative database that were being used on the country`s educational policies. Helped developers on how to retrieve data due to the high volume of objects on databases

Working on the Brazil's government lawyer agency (AGU - Advocacia Geral da Uniao).One of my responsabilities was design relational data models and maintain legacy databases inside this institution. The database in use was Oracle 11g. One relevant project was to create a enterprise database. Later, another project that I have participate consisted in transfer around 40 existing SQL Server databases to Oracle database, including converting T-SQL to PL/SQL. After that, another challenge… Show more Working on the Brazil's government lawyer agency (AGU - Advocacia Geral da Uniao).One of my responsabilities was design relational data models and maintain legacy databases inside this institution. The database in use was Oracle 11g. One relevant project was to create a enterprise database. Later, another project that I have participate consisted in transfer around 40 existing SQL Server databases to Oracle database, including converting T-SQL to PL/SQL. After that, another challenge consisted in remodeling the Human Resource data model, originally in Cachè database, and copy all data to the new data model, inside Oracle, using the enterprise database. Moreover, I used to maintain data and objects on development, test and production environment. Furthermore, assisted developers on programming in PL/SQL and how to use the existing data models. Tuning SQL and routines aiming performance.Technologies: Oracle 11g, Microsoft DTS 2005, Power designer, PL/SQL Developer, SQL Navigator, Toad for Oracle Show less

Working at Advocacia Geral da Uniao (AGU).My role was to maintain existing and create web-based systems in ASP. Creation of packages and procedures using PL/SQL where routine. After few months working there, I focused in developing reports to those systems using complex queries to meet user's needs. Then I was invited to change my position from developer to data steward.Technologies: ASP 3.0, Java script, ASP.NET C#, Microsoft Visual Studio 2005 and 2008, MS Visual SourceSafe, SQL… Show more Working at Advocacia Geral da Uniao (AGU).My role was to maintain existing and create web-based systems in ASP. Creation of packages and procedures using PL/SQL where routine. After few months working there, I focused in developing reports to those systems using complex queries to meet user's needs. Then I was invited to change my position from developer to data steward.Technologies: ASP 3.0, Java script, ASP.NET C#, Microsoft Visual Studio 2005 and 2008, MS Visual SourceSafe, SQL Navigator 5.5, PL/SQL Developer, Oracle, SQL Server. Show less