Marcelo Ferreira

Marcelo Ferreira Email and Phone Number

Data Analyst | Business Analyst | AWS | Python | Fabric | Data Factory | Lakehouse | Power BI | Databricks | SQL I MySQL I Docker I @ Looplex
brazil
Marcelo Ferreira's Location
Cosmópolis, São Paulo, Brazil, Brazil
About Marcelo Ferreira

With a degree in Philosophy and currently pursuing a postgraduate degree in Data Science and Analytics at USP/Esalq, I've had a 22-year journey within Banco do Brasil, with the last six years spent as a Senior Data Analyst and Engineer. I specialize in analyzing large volumes of data to extract insights and make strategic decisions to achieve the best results for the company, always crafting thorough technical documentation.My responsibilities include gathering data from various sources such as databases, file storage systems, and APIs. I conduct in-depth analysis of the collected information to understand its structure, identify patterns and trends, and explore possible relationships between variables, developing statistical models and machine learning algorithms to predict future outcomes and classify data. To communicate insights clearly and comprehensibly to stakeholders, I produce documentation such as graphs, dashboards, and weekly/monthly/semi-annual reports.In developing robust documentation and solutions, I have utilized technologies such as Java, JavaScript, MySQL, SQL, HTML, CSS, Docker, DB2, Tableau, Power BI, Hadoop, Spark, data streaming analysis with Python and Spark, as well as R and Azure Machine Learning.Problem-solving, adaptability, teamwork, strategic thinking, active listening, and communication are fundamental pillars for me. I dissect complex challenges and develop innovative solutions, whether unraveling intricate data issues or navigating business dilemmas, approaching each obstacle with tenacity to uncover its core. Adaptability is my compass in a constantly evolving landscape. I embrace change as an opportunity for growth, promptly adjusting strategies and perspectives to meet new demands and seize emerging opportunities.

Marcelo Ferreira's Current Company Details
Looplex

Looplex

View
Data Analyst | Business Analyst | AWS | Python | Fabric | Data Factory | Lakehouse | Power BI | Databricks | SQL I MySQL I Docker I
brazil
Website:
looplex.com.br
Employees:
23
Marcelo Ferreira Work Experience Details
  • Looplex
    Data Engineer
    Looplex Sep 2024 - Present
    São Paulo, Brasil
    Creation of scalable data pipelines using Microsoft Fabric Dataflows and PySpark, ensuring efficiency and high performance in processing large volumes of data.Development of ETL and ELT processes with SQL and PySpark, performing data transformation, cleansing, and integration from multiple sources.Automation of pipelines for batch processing, integrating Lakehouse features for raw data ingestion and storage.Design and implementation of a Lakehouse to centralize the storage of structured and unstructured data, using best practices for partitioning and versioning.Dimensional and relational data modeling to support Power BI analyses, optimizing performance and ensuring consistency in the data presented.Creation of data layers (raw, refined, and consumable) to standardize the information flow from ingestion to consumption.Development of interactive and responsive reports and dashboards using Power BI, generating strategic insights for decision-making.Configuration of calculated measures (DAX) to add intelligence to the data, simplifying advanced analyses.Optimization of Power BI reports, including performance improvements by reducing cardinality and utilizing efficient aggregations.Monitoring data quality and consistency.Development of solutions in collaboration with business analysts and the CEO, ensuring data deliveries align with the organization's strategic needs.Participation in code reviews and continuous process monitoring to identify improvement and innovation opportunities.Integration of notifications and automatic alerts to monitor pipeline failures and data usage.
  • Aina
    Founder
    Aina Jul 2022 - Present
    São Paulo, Brazil
    As the Founder and sole operator of my early-stage startup, I am leveraging my expertise in business analysis and strategic decision-making based on data to carve a niche in the IT market. My responsibilities encompass a broad range of activities essential for laying the foundation and guiding the strategic direction of the company, including:Conducting comprehensive market analyses to identify viable pathways for the company, aligning with my areas of expertise.Crafting the company's vision, mission, and core values to ensure a cohesive and purpose-driven organizational culture.Developing a detailed business plan with short, medium, and long-term objectives to guide the company's growth and development.Designing a distinctive visual identity that reflects the company's values and the services it will offer, ensuring brand consistency across all touchpoints.Formulating a product development strategy, prioritizing the release of products tailored to meet the needs of our target clientele.Creating the company’s website from the ground up, encompassing both front-end and back-end development, to offer an intuitive and informative user experience.Planning strategic partnerships to bolster the company's market presence and enhance its service offerings.Establishing a continuous learning plan to keep abreast of industry trends and technologies, ensuring my skills remain relevant to successfully steer the company through its critical formation phase.Setting realistic deadlines that balance the demands of developing the company with personal employment needs, ensuring financial stability to invest in the business's growth.Designing a scalable infrastructure to meet the company's immediate operational requirements while also accommodating future expansion.Through these efforts, I aim to build a robust foundation for my startup, demonstrating my commitment to innovation, strategic growth, and excellence in the IT sector.
  • Banco Do Brasil
    Senior Advisor | Data Scientist | Data Engineer
    Banco Do Brasil May 2020 - Apr 2022
    Brasilia
    Acting as an integral part of a highly specialized technical team, focusing on innovations related to cash management, self-service terminals and cash terminal applications; responsible for covering a variety of areas, from planning to the implementation of dashboards for various departments; end-to-end project leadership, from conception to quality assurance in final delivery; assistance in promoting a data-driven culture for more than eleven thousand employees in different departments; construction of automations in Python, using specific libraries for each task; maintenance of Java tools, ensuring their efficiency and reliability; maintenance of DB2 and MySQL databases and supervision of ETL processes, ensuring the integrity and effectiveness of operations.
  • Banco Do Brasil
    Senior Advisor | Data Analyst | Data Engineer | Business Analyst | Risk Analyst
    Banco Do Brasil Mar 2018 - Apr 2020
    Brasilia
    • Key person for data sources related to cash, self-service terminals and cash due to my in-depth knowledge; projection of KPIs, development of data visualization panels using Tibco Spotfire for monitoring and automation of extraction tasks; processing and loading data (ETL) from different sources; preparation and review of internal regulations, ensuring internal compliance and alignment with legislation; implementing improvements in cash balance management for the bank, covering domestic and foreign currency and resolving long-standing discrepancies between physical and accounting balances, creating a local data infrastructure, including capture and reconciliation.
  • Banco Do Brasil
    Senior Advisor | Data Analyst | Data Engineer | Business Analyst
    Banco Do Brasil Dec 2015 - Feb 2018
    Brasília, Federal District, Brazil
    Responsible for mapping and reviewing implementations of improvements in cash transactions until negotiating with stakeholders to ensure efficiency and strategic alignment; mapping, reviewing and monitoring implementations of improvements in transactions, gathering technical and operational requirements; preparation of detailed documentation regarding transactions and weekly reports for the team and management; data collection from various sources, including DB2, MySQL, and development of robots for screen scraping and webscraping and use of tools such as Excel, Access and SAS Enterprise Guide for data analysis and process optimization.Success Case: After two years allocated to the project, I managed to reduce the costs of monthly cash transactions, allowing us to go from spending 74 million/month to spending 45 million/month, representing a cost reduction of more than 39.18%.
  • Banco Do Brasil
    Intermediate Advisor | Data Analyst | Business Analyst
    Banco Do Brasil Nov 2014 - Nov 2015
    Brasília, Federal District, Brazil
    Monitoring and migrating the entire Banco do Brasil's cash system management from Clients Unit to the Operations Unit; in-depth study on the daily operation of cashiers, including reading current regulations, understanding the functioning of cashier terminals aiming at user and customer experience; designing and planning cash operations for post-migration functionality, including prioritizing improvements, simulating changes, and analyzing the cost and benefit for each proposed improvement; mapping actions to reduce service time and prioritize cost reduction in cashier operations; creating reports, charts, and presentations to track the impact of implemented actions and display them to management.Success Story: After a year of the project, we saved more than 10 million/month in transactions at the agency's internal cash terminals, resulting in a monthly saving of approximately R$ 30 million/month. After achieving such success, I was promoted to Senior Advisor.
  • Banco Do Brasil
    Full Advisor | Data Analyst | Process Improvement Specialist | Project Coordinator
    Banco Do Brasil Jul 2013 - Oct 2014
    Brasília, Federal District, Brazil
    Developed and led continuous improvement mapping and identified new business and product opportunities related to the cash system; negotiated directly with executives and directors from other company areas to achieve joint goals or establish strategic partnerships; planned risk mitigation actions for migration projects; implemented continuous improvements in the cash system, resulting in increased operational efficiency and customer satisfaction; established strategic partnerships that expanded business opportunities and strengthened the company's market position.
  • Banco Do Brasil
    Junior Advisor | Data Analyst
    Banco Do Brasil Jan 2011 - Jun 2013
    Brasília, Federal District, Brazil
    Developed and implemented strategies to ensure ATM availability, focusing on equipment maintenance. Managed Service Level Agreements to retain maintenance contracts for ATMs nationwide, including suggesting standards and contractual clauses, and negotiating directly with service providers for risk mitigation and service improvement. Automated operational tasks using VBA for Access and Excel, freeing up time for more strategic and essential activities. Conducted statistical studies, developed simulators, and implemented standardized procedures to reduce processing time, enhance ATM efficiency, and lower transportation costs.
  • Banco Do Brasil
    Data Analyst | Supply Chain Logistics Analyst
    Banco Do Brasil May 2007 - Dec 2010
    São Paulo, São Paulo, Brazil
    Responsible for managing the cash supply schedule for ATMs, including controlling cash demand and negotiating with stakeholders to prioritize service; automating tasks using Excel and VBA, including report generation; developing bots for data capture, automating charts, tables, and other decision-making reports; monitoring goals and results for ATM availability across the state of São Paulo, and sending daily reports detailing potential malfunctions to all regional superintendencies in the state.
  • Banco Do Brasil
    Maintenance Planner
    Banco Do Brasil Nov 2006 - Apr 2007
    São Paulo, São Paulo, Brazil
    Remote monitoring of over 400 ATMs, ensuring continuous operation and prompt resolution of any issues; in-depth investigation of ATM failures to prevent future occurrences; continuous contact with partners to ensure timely maintenance, including scheduling and negotiating appointment times; assisting in managing cash shortages in ATMs, coordinating with key personnel as needed to ensure quick adjustments.
  • Banco Do Brasil
    Administrative Manager
    Banco Do Brasil Feb 2004 - Oct 2006
    São Paulo, São Paulo, Brazil
    Participation in the strategic decision-making of the branch committee; responsible for building documentation, such as the operating license and its renewal, resolving fines and debts, ensuring the effective operation of the bank branch; in charge of controlling and paying all bills such as water, electricity, and telephone; managing legal processes, appearing as a representative in court hearings on behalf of the bank; negotiating with lawyers and providing legal documentation to mitigate judicial risks, and overseeing the branch's accounting management, ensuring internal compliance of all accounts and balances.
  • Banco Do Brasil
    Cashier
    Banco Do Brasil Jan 2001 - Jul 2004
    São Paulo, São Paulo, Brazil
    Responsible for cashier services, handling the receipt and payment of salaries and other bills, as well as providing checkbooks; personalized service for exclusive clients, offering effective support to resolve their issues; in charge of replenishing ATMs, ensuring they are always operational; processing all high-value deposits for the branch, ensuring the security and integrity of transactions while adhering to the bank's established procedures.
  • Banco Do Brasil
    Account Manager
    Banco Do Brasil Nov 2002 - Jun 2003
    São Paulo, São Paulo, Brazil
    Responsible for approving credit limits for clients, carefully evaluating requests and ensuring compliance with established policies and procedures; managing a team of seven people, conducting performance evaluations, organizing vacation schedules, and assisting in resolving any conflicts with clients; managing the client portfolio, setting product and action targets to achieve the organization's goals; designing relationship strategies to enhance customer contact, ensuring satisfaction and loyalty, and identifying upselling opportunities.
  • Banco Do Brasil
    Bank Clerk
    Banco Do Brasil Apr 2000 - Dec 2000
    São Paulo, São Paulo, Brazil
    Customer service for opening and closing checking and savings accounts, conducting customer profile updates, providing information about social and government programs, and selling banking products such as insurance, capitalization bonds, loans, and private pensions based on each client's needs. Responsible for selling foreign currencies, including the daily registration of currency exchange operations in the Central Bank's internal systems, ensuring compliance with foreign exchange regulations. Additionally, responsible for negotiating various debts, customizing contracts, and actively contacting clients for both debt collection and negotiation.Success story: Within two weeks, I managed to recover over R$ 250,000 in debts through active contract negotiation, significantly contributing to the bank's financial results.

Marcelo Ferreira Education Details

Frequently Asked Questions about Marcelo Ferreira

What company does Marcelo Ferreira work for?

Marcelo Ferreira works for Looplex

What is Marcelo Ferreira's role at the current company?

Marcelo Ferreira's current role is Data Analyst | Business Analyst | AWS | Python | Fabric | Data Factory | Lakehouse | Power BI | Databricks | SQL I MySQL I Docker I.

What schools did Marcelo Ferreira attend?

Marcelo Ferreira attended Mba Usp/esalq, Universidade Do Sul De Santa Catarina.

Who are Marcelo Ferreira's colleagues?

Marcelo Ferreira's colleagues are Jenifer Maciel, Diego Arruda, Gisleine Campos Batista, Andrew Oliveira Silva, Rodrigo Urias, Isabelle Padilha, Camila Neves.

Not the Marcelo Ferreira you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.