Leonardo Santos
Cabreuva, Sao Paulo
Summary
Dynamic and results-driven professional with extensive experience in data analysis, visualization, and decision support across diverse industries. Proven track record of leveraging advanced analytics tools and techniques, including Python with key frameworks such as Pandas, NumPy, and others, to drive actionable insights and strategic decision-making. Skilled in diagnosing operational issues, automating reporting processes, and optimizing data workflows to enhance organizational efficiency and effectiveness. Proficient in SQL query development, ETL processes, and dashboard creation using leading platforms such as Microsoft Power BI and Excel. Adept at developing compelling presentations and communicating complex findings to stakeholders at all levels. Committed to continuous improvement and driving productivity and service quality through data-driven approaches.
Overview
10
10
years of professional experience
Work History
Senior IT Consultant
Deloitte
04.2022 - Current
- Conducted ETL processes for csv/xlsm files to populate SQL Server databases.
- Developed database Views to facilitate connections with Tableau for reporting and visualization purposes.
- Designed and developed Dashboards utilizing Tableau and Excel BI across various industries including Retail, Chemical, and Commerce.
- Enhanced VBA macros to streamline processes and improve efficiency.
- Utilized Python scripting for automating routine tasks such as file importing and data manipulation.
- Actively participated in daily brainstorming sessions to generate ideas and implement new products and software solutions.
Data Analyst
Movile Pay
11.2021 - 04.2022
- Developed queries in PostgreSQL to establish tables and views essential for report generation.
- Designed and implemented dashboards tailored for the accounting team, facilitating comparison of payable accounts.
- Monitored payment transactions to ensure accuracy and timeliness.
- Utilized SQL language on Databricks platform to curate datasets, optimizing data management and analysis.
- Spearheaded the creation of operational and financial dashboards using Metabase, enhancing data visualization capabilities for cross-functional teams.
Data Analyst
FIS
06.2021 - 11.2021
- Led the seamless migration of QlikView data visualization tools to Power BI, ensuring continuity and enhanced functionality.
- Developed complex DAX measurements to provide actionable insights and drive decision-making processes.
- Executed ETL processes using Power Query and M Language to streamline dataflow file management.
- Designed and implemented interactive dashboards tailored for both operational teams and clients within the banking sector, including Bradesco, Safra, among others.
- Engineered a comprehensive dashboard for the training team to assess performance metrics such as NPS score and service quality, enabling targeted improvements in customer service for credit card products.
- Leveraged data analysis techniques to extract valuable insights crucial for informed decision-making across operational functions.
- Automated Excel reports to increase efficiency and accuracy in reporting processes.
Junior Data Analyst
Telefonica Sao Paulo
02.2014 - 06.2021
- Spearheaded the development of insightful analyses and reports essential for informed decision-making in customer service initiatives.
- Conducted comprehensive diagnostics to identify root causes of operational issues and inconsistencies in performance indicators.
- Prepared and delivered compelling PowerPoint presentations for high-level management meetings, effectively communicating key insights and recommendations.
- Utilized SQL queries to automate Excel reports, streamlining data processing and reporting workflows.
- Designed and implemented interactive dashboards using Microsoft Power BI and Excel, providing stakeholders with intuitive data visualization tools.
- Managed end-to-end ETL processes, extracting, processing, and loading data into XML and CSV databases using Power BI to inform strategic decision-making.
- Conducted in-depth studies aimed at enhancing productivity and service quality, driving continuous improvement initiatives.
Education
Bachelor of Science - Eletrical Engineering
Anhanguera University
Jundiaí, Sao Paulo, Brazil06.2020
Skills
- IT Asset Management
- IT Compliance
- Application support
- Business Analysis
- Data Analytics
- DevOps Practices
- Software Development
- Agile Methodology
Timeline
Senior IT Consultant
Deloitte
04.2022 - Current
Data Analyst
Movile Pay
11.2021 - 04.2022
Data Analyst
FIS
06.2021 - 11.2021
Junior Data Analyst
Telefonica Sao Paulo
02.2014 - 06.2021
Bachelor of Science - Eletrical Engineering
Anhanguera University
Similar Profiles
Albert Laurentiu IonAlbert Laurentiu Ion
Junior Information Technology Consultant at DeloitteJunior Information Technology Consultant at Deloitte
Sai Rekha SuradaSai Rekha Surada
Solution Advisor - Manager FCC Investigations Team at DeloitteSolution Advisor - Manager FCC Investigations Team at Deloitte
Sai Ramesh VattiSai Ramesh Vatti
Sr. UIUX Consultant at DeloitteSr. UIUX Consultant at Deloitte