Gustavo S.

Data Analyst

BI Consultant
10/1/2021 - 3/1/2024

Gained extensive experience in migration projects, specifically transitioning Tableau Dashboards to Power BI, enhancing data visualization capabilities. Managed ETL processes using AWS S3 and provided support for databases including Athena, 9Cloud, EMR, and AirFlow. This role showcased strong technical expertise in handling and optimizing large-scale data migrations and ensuring seamless integration between different data visualization tools and databases.

ETL Consultant Oracle Cloud
3/1/2021 - 10/1/2021

Directed and managed ETL processes, ensuring precise and efficient data handling. Validated Oracle FBDI files across various domains including HCM, Receivables, Payables, Procurement, and Customer data. Developed technical expertise in ETL tools and processes, alongside significant experience with Oracle FBDI, enhancing data integration and validation capabilities within the project's scope. Achieved a streamlined and effective approach to managing and processing complex data sets.

Systems Analyst / BI
8/1/2019 - 2/1/2021

Developed proficiency in building dashboards with a focus on UI and UX in collaboration with dedicated teams. Executed multiple dashboard projects using Power BI, including Control Tower, Command Center, and Legal PPM. Designed and implemented a financial demo dashboard for pre-sale purposes in the pharmaceutical sector. Contributed to incident diagnosis for financial terminals, performing in-depth analysis of financial transaction logs using Splunk and Unix systems. Managed the historical data of terminals with SQL through regular updates, maintenance, and operating system incident resolutions. Created REDE indicator panels using Tableau and managed project stories with Jira, adopting a Kanban methodology after transitioning from Scrum.

BI Analyst
12/1/2018 - 6/1/2019

Analyzed the structure of existing databases, providing insights and recommendations for optimization. Documented the current state (As Is Mapping) and utilized SQL Server Integration Services (SSIS) for data extraction, transformation, and loading (ETL). Developed and maintained interactive dashboards for project monitoring and timesheet tracking, utilizing various BI tools. Handled extensive data processing tasks to ensure accurate and efficient data loading into existing reports, supporting ongoing data analysis and business intelligence initiatives.

Business Intelligence Consultant
11/1/2016 - 7/1/2017

Developed advanced proficiency in QlikView, leveraging its capabilities to create dynamic, interactive dashboards that significantly improved data visualization and business insights. Demonstrated expertise in SQL for querying and manipulating large datasets, facilitating better data analysis and reporting. Utilized scripting and data modeling skills to design and implement efficient data solutions. Showcased strong analytical abilities by interpreting complex datasets and providing actionable business recommendations. Employed data integration techniques using various ETL tools to streamline data workflows and enhance reporting accuracy. Maintained data integrity and consistency by implementing stringent data validation processes. Conducted performance tuning and optimization of QlikView applications to improve loading times and user experience. Ensured version control and collaborative code development through Git, promoting robust software development practices. Developed documentation and training materials to support end-users in utilizing the QlikView dashboards effectively.

Systems Analyst
6/1/2016 - 8/1/2016

Led and executed complex cloud migration projects using AWS and Azure, incorporating best practices for architecture and security. Designed and implemented scalable and robust microservices using Docker and Kubernetes, streamlining application deployment and management. Proficient in Python and Java, utilizing Spring Boot and Flask to develop and maintain high-performance APIs. Developed expertise in CI/CD pipelines with Jenkins and GitLab, enabling automated and seamless integration and delivery processes. Hands-on experience with relational and NoSQL databases, including MySQL, PostgreSQL, and MongoDB, ensuring efficient data management and storage solutions. Demonstrated strong analytical and problem-solving skills, adept at using Jira for project tracking and collaboration. Enhanced system performance and reliability through effective monitoring and alerting practices with Prometheus and Grafana. Implemented rigorous testing and quality assurance methodologies, leveraging Selenium and JUnit to ensure robust application functionality.

System Developer
5/1/2015 - 5/1/2016

Led the development of a Contact Rate and Data Clean Project focusing on the elaboration of technical specifications. Conducted in-depth analysis and development of extractors and converters. Performed rigorous testing and loading of data into tables, followed by homologation of these tables and data. Utilized the PL/SQL Developer tool extensively for procedures, functions, triggers, packages, data extraction, and report development.

System Analyst
9/1/2013 - 2/1/2015

Led a comprehensive STP migration project with a focus on PL/SQL and Power Center. Undertook requirement gathering directly with the client to ensure precise capture of functional and technical ETL specifications. Utilized PWC Designer for ETL mapping and generated workflows followed by rigorous testing protocols. Conducted detailed analysis and development of extractors and converters, ensuring accuracy and efficiency in data extraction and loading within tables. Oversaw the maintenance of extraction, import, and export files while validating tables and data integrity. Demonstrated high-level proficiency in PL/SQL Developer tool through development of procedures, functions, triggers, packages, data extraction, and report creation.

Systems Analyst
5/1/2013 - 9/1/2013

Developed proficiency in requirements gathering with clients and created both functional and technical ETL specifications. Gained extensive experience in mapping via PWC Designer/ETL, and performed workflow generation and testing. Conducted thorough validation of tables and data to ensure accuracy and reliability. Demonstrated expertise in development with the PL/SQL Developer tool, encompassing procedures, functions, triggers, packages, data extraction, and report development.