Flavio D.

Data Entry Specialist

Database Specialist
7/1/2020 - Present

Developed proficiency in AWS, PL/SQL, and Shell Script, ensuring effective data management and automation. Engaged extensively with version control tools such as Git and Bitbucket for collaborative coding and project management. Utilized JIRA for tracking project progress and managing tasks efficiently. Executed big data processing tasks using EMR (MobaXterm) while leveraging Amazon Redshift (DBEAVER) for high-performance data warehousing solutions. Demonstrated expertise in managing data workflows using tools like Airflow and Data Lake, while conducting data analysis in a sandbox environment facilitated by HUE. Managed documentation, planning, and issue tracking with tools such as GERA, Checklist, Planner, and Confluence to maintain project coherence and streamline communication across teams.

SQL Server Consultant
3/1/2019 - 4/1/2020

Provided SQL and PL/SQL Oracle consulting services for internal applications, focusing on ERP AGE and the NFe System. Developed extensive expertise in database management and optimization. Conducted database performance tuning and ensured efficient query processing. Designed stored procedures, triggers, and packages to meet business requirements. Ensured the stability and reliability of applications through rigorous testing and debugging. Collaborated with cross-functional teams to integrate database solutions with existing systems, enhancing overall operational efficiency and facilitating seamless data management.

Systems Analyst
9/1/2017 - 2/1/2018

IT Consultant: Conducted comprehensive user needs analysis and requirements gathering. Excelled in strategic planning and innovation of solution processes. Managed robust customer relationships. Leveraged extensive expertise in tools such as GITEC, a management integration suite for time, scope, and cost. Applied FIC/MAXIMO for system integration and commissioning. Utilized SIGEM for integrated enterprise management and SISPEN for managing requests and pending issues. Demonstrated proficiency in SST for handling technical service requests.

professor
9/1/2016 - 12/1/2016

Taught Business Intelligence (BI) subject as part of a postgraduate BI course curriculum. Delivered proficient instruction and practical insights into various BI tools, ensuring students developed a high level of expertise in data analysis and reporting. Utilized advanced BI platforms such as Tableau, Power BI, and QlikView to demonstrate data visualization, data mining, and dashboard creation techniques. Focused on enhancing students’ skills in SQL for database management, ETL processes, and understanding the architecture of data warehouses. Facilitated a rigorous learning environment that incorporated the use of real-world datasets and case studies to solidify the understanding of business analytics and decision-making processes.

Project Coordinator/Leader
2/1/2015 - 10/1/2015

Successfully led cross-functional teams and developed strategic plans to optimize project workflows and meet deliverable deadlines. Conducted comprehensive training sessions and capacity-building initiatives, ensuring that team members were equipped with the necessary skills to perform efficiently. Spearheaded client management planning efforts, fostering positive relationships and ensuring client satisfaction through timely communications and tailored service delivery. Implemented rigorous risk planning methodologies to identify, assess, and mitigate potential project risks, safeguarding project integrity and continuity. Through these efforts, gained expertise in project management tools and frameworks, including Agile and Scrum methodologies, as well as proficiency in utilizing data analysis tools for project monitoring and performance evaluation.

Oracle Database and Business Intelligence
5/1/2014 - 2/1/2015

Cultivated extensive expertise in Oracle Database management, including advanced SQL scripting, PL/SQL development and Oracle performance tuning. Demonstrated proficiency in database administration tasks such as backup and recovery, database cloning, patching, and upgrading. Engaged in comprehensive Business Intelligence (BI) initiatives, harnessing tools like Oracle BI Publisher, Tableau, and Power BI to develop insightful reports and dashboards. Deployed ETL processes utilizing Informatica PowerCenter and Oracle Data Integrator (ODI) to ensure seamless data integration and migration. Facilitated data warehouse architecture design, ensuring efficient data retrieval and analytics. Demonstrated the ability to use advanced analytics tools, contributing to data-driven decision-making processes. Acted as a liaison between technical teams and business stakeholders to achieve project objectives and fostered collaborative work in agile environments.

professor
3/1/2012 - 1/1/2014

Designed and delivered comprehensive undergraduate courses in Information Systems, Networks, and Administration. Developed expertise in curriculum design and pedagogical strategies tailored to technical subjects. Utilized advanced tools and frameworks including MySQL, Oracle, and Cisco networking solutions to provide hands-on learning experiences. Demonstrated proficiency in network configuration and system administration using Linux and Windows Server environments. Integrated the latest industry standards and practices, and employed collaborative tools such as Moodle and Blackboard for effective student engagement and assessment. Enhanced students’ understanding of information security, virtualization, and cloud computing through practical projects and case studies. Fostered a collaborative learning environment promoting critical thinking, problem-solving, and innovation in the field of information technology.

Oracle Database and Business Intelligence
6/1/2011 - 5/1/2014

Successfully coordinated and managed Oracle Database systems, ensuring optimal performance, security, and reliability. Developed and streamlined data processes to enhance database efficiency and accuracy. Utilized Oracle SQL, PL/SQL, and Oracle Enterprise Manager for effective database management. In the Business Intelligence domain, designed, developed, and implemented BI solutions leveraging tools such as Tableau, Power BI, and Cognos. Conducted data analysis and reporting, facilitating data-driven decision-making. Ensured integration and consistency of business data across multiple platforms and maintained data integrity. Worked extensively with ETL processes using Informatica and Talend, optimizing data extraction, transformation, and loading. Demonstrated expertise in data warehousing concepts and implementation. Collaborated with cross-functional teams to address business requirements and provide insightful BI solutions, enhancing organizational performance and strategic planning. Maintained collaborative version control using Git.

BI Analyst
4/1/2011 - 6/1/2011

Developed and incorporated a Business Intelligence (BI) tool within the Pyramid platform. Created and deployed BI projects tailored for new clients using technologies and tools such as Qlikview, Oracle, and Crystal Reports. Gained substantial expertise in designing and implementing BI solutions, enabling insightful data analysis and visualization.

professor
9/1/2009 - 10/1/2009

Taught the course Business Intelligence - BI as part of a postgraduate program in Oracle databases. Developed proficiency in BI tools and frameworks including Oracle BI Suite, Oracle Data Integrator (ODI), and Oracle Warehouse Builder (OWB). Demonstrated expertise in designing and implementing data warehouses, developing ETL processes, and using OLAP systems to generate comprehensive business reports. Extensively worked with data visualization tools to present actionable insights. Utilized SQL and PL/SQL for advanced data manipulation and analysis. Conducted lectures and hands-on lab sessions to facilitate practical understanding of BI concepts and tools. Ensured curriculum alignment with industry best practices and emerging trends in data analytics and business intelligence strategies.

Oracle and Business Intelligence Consultant
8/1/2008 - 4/1/2011

Oracle Database Consultant and Business Intelligence Consultant with three years of market experience. Developed expertise in Oracle Database, including extensive use of Oracle Data Integrator (ODI), Goldengate, RMAN (Recovery Manager), and Data Guard. Proficient in performing backup and restore operations, ensuring data integrity and optimal system performance. Acquired skills in generating insightful reports using Crystal Reports, contributing to informed business decision-making processes.

DBA Oracle
8/1/2008 - 4/1/2011

Developed extensive expertise in Oracle databases across various versions and operating system platforms. Played a key role in creating and maintaining client projects and database structures. Demonstrated a deep understanding of system architecture and database management, ensuring robust and scalable database solutions tailored to client needs.

Systems Analyst
6/1/2006 - 7/1/2008

Gained extensive experience as a System Analyst, overseeing the company's systems and databases. Played a pivotal role in developing and planning new systems, ensuring continuous operation 24/7. Demonstrated proficiency in system maintenance and optimization, database management, and troubleshooting. Utilized various tools and frameworks to support system infrastructure, maintain robust security protocols, and ensure seamless integration with other IT components. Excelled in a high-availability environment, ensuring minimal downtime and maximum system efficiency.

Software Engineer
6/1/2005 - 5/1/2006

Developed and maintained systems on both Windows and Linux platforms with a focus on C#, ASP.NET, JavaScript, Java, SQL, and PL/SQL. Designed and generated sophisticated reports utilizing Crystal Reports and optimized various software development processes using UML and RUP methodologies. Demonstrated technical expertise in full-stack development and database management, ensuring efficient and scalable solutions. Additionally, implemented and adhered to best practices in software development, contributing to high-quality system deployments and seamless integration across platforms.

Programmer
4/1/2004 - 5/1/2005

Position: Systems Developer.

Developed proficiency in using VB.Net, VB 6.0, and C#. Extensively worked with ASP.net for creating dynamic web applications and employed JavaScript to enhance user interactivity and interface design. Demonstrated strong skills in database management with SQL and PL/SQL, effectively utilizing both Oracle and SQL Server for data storage, retrieval, and manipulation. Conducted comprehensive system analysis, design, and implementation to meet specific project requirements, ensuring robust and scalable solutions. Efficient in integrating various modules and troubleshooting system issues to maintain seamless operation.

Bachelor in Information Systems at Integrated College of Recife - FIR
2000 - 2005

Oracle Database at Integrated College Barros Lima - AESO
2007 - 2008