$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Analyst
Marcelo Gazzola Ribeiro
,
Salford, United Kingdom
Experience
Other titles
Skills
I'm offering
Innovative data analytics professional with experience in ETL, data mining, creation of KPI dashboard using tools like Power BI. Providing operational changes and suggesting automation whenever possible to mitigate risks and increase productivity. Proficient in writing Python scripts, VBA, SQL queries and gifted with analytical and constructive analysis.
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Portuguese
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2021 - ?
job
Business Intelligence Developer
I Saw It First.
Aid in the scalability, security and repeatability of data pipelines
Development of Data Models and ETL using Python, SQLAlchemy and AWS Lambda
Providing maintenance to MS SQL Server using T-SQL, SSIS and SSRS
Full-stack development of web applications using Python Flask, Bootstrap and JavaScript
Integration between e-commerce tools Shopify and NetSuite using REST and GraphQL APIs
Development of Data Models and ETL using Python, SQLAlchemy and AWS Lambda
Providing maintenance to MS SQL Server using T-SQL, SSIS and SSRS
Full-stack development of web applications using Python Flask, Bootstrap and JavaScript
Integration between e-commerce tools Shopify and NetSuite using REST and GraphQL APIs
Python, Sql, Ssis, AWS, Google analytics, Google Cloud Platform, Javascript, Flask, Git, Mysql, Graphql, REST API
2020 - 2021
freelance
Freelancer Data Analyst
Liberty Music PR.
Project: Web Scrapping social media and other websites, using reverse engineering and loading the data into
PostgreSQL database, also a Python Flask REST API exposes the scraped data used to build a Web Application.
This application was deployed in Heroku.
PostgreSQL database, also a Python Flask REST API exposes the scraped data used to build a Web Application.
This application was deployed in Heroku.
Excel and vba programming, Python, Sql, Mysql, REST API, Flask, Database, Data analysis and visualization, Data Analysis, Business Intelligence, Power BI
2019 - 2019
job
Data Governance Analyst
SMBC Europe.
Supporting the establishment of a Data Governance capability for the EMEA Region of the Bank.
Building of the Governance Framework which will establish data ownership rights and responsibilities across the organization.
Key Achievements
Used Microsoft Excel VBA to create the Information Asset Register allowing the information owner to keep control of their data and according to the GDPR regulation.
Building of the Governance Framework which will establish data ownership rights and responsibilities across the organization.
Key Achievements
Used Microsoft Excel VBA to create the Information Asset Register allowing the information owner to keep control of their data and according to the GDPR regulation.
Excel and VBA programming, Sql, Access
2018 - 2019
job
Supply Chain Data Analyst
Colorcon.
Provided data analysis to support the Supply Chain Team including Supply Chain Mapping, Value at Risk, Total Cost of Ownership, Demand Analysis, Sales Forecast and KPIs.
Key Achievements
Used Microsoft Power Query and VBA to deal with 5 million lines of data extracted from Oracle BI and Oracle Hyperion ERP to build a live sales forecast dashboard reducing the data extraction time in more than 80%.
Created automated report to control the vendors performance using VBA automation for Excel and Microsoft Outlook, eliminating 90% of manual process and mitigating risks.
Automated 50% of the MRP process using Excel VBA to produce the input CSV file used inside the Oracle BI respecting the layout and avoiding manual mistakes.
Key Achievements
Used Microsoft Power Query and VBA to deal with 5 million lines of data extracted from Oracle BI and Oracle Hyperion ERP to build a live sales forecast dashboard reducing the data extraction time in more than 80%.
Created automated report to control the vendors performance using VBA automation for Excel and Microsoft Outlook, eliminating 90% of manual process and mitigating risks.
Automated 50% of the MRP process using Excel VBA to produce the input CSV file used inside the Oracle BI respecting the layout and avoiding manual mistakes.
Excel and VBA programming, Access, Oracle database, Sql
2013 - 2018
job
Data Analyst
Itau BBA.
Devised a leaner and more scalable strategy for the middle office area, with a focus on being proactive, business focused and risk-aware (automating wherever viable (VBA/Access/SQL), reducing operational risk and improving efficiency).
Support the commercial team providing reports about product utilization and sales process, making capable to track all the workflow of their commercial portfolio.
Descriptive statistical analysis using MiniTab
Key Achievements
Used VBA and Python scripts to automate reports reducing the manual process in more than 80%.
Supported the commercial team to increase the ROE, reducing costs in more than 30% with the benefit of sales performance reports and product utilisation.
Support the commercial team providing reports about product utilization and sales process, making capable to track all the workflow of their commercial portfolio.
Descriptive statistical analysis using MiniTab
Key Achievements
Used VBA and Python scripts to automate reports reducing the manual process in more than 80%.
Supported the commercial team to increase the ROE, reducing costs in more than 30% with the benefit of sales performance reports and product utilisation.
Excel and VBA programming, C#, Access, Tableau, Python, Automation, Sql
My education
2009
-
2015
University Centre of FEI
BSc, Production Engineering
BSc, Production Engineering
Marcelo's reviews
Marcelo has not received any reviews on Worksome.
Contact Marcelo Gazzola Ribeiro
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Marcelo directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark