Marcelo R.

Data Scientist

335 dollar
Freelancer
9 ans
Londres, ROYAUME-UNI

Mon expérience

Voir plus

SMBC EuropeJune 2019 - Présent

* 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.
* Protecting the Bank's data assets according to the GDPR regulation.
Voir plus

Colorcon LtdDecember 2018 - March 2019

* 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.
Voir plus

ColorconDecember 2018 - March 2019

* 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.
* Automated manual process to generate periodic reports achieving speed, simplicity and mitigating risks.
Voir plus

Bank Itaú BBASeptember 2013 - May 2018

* 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.
Voir plus

-January 2015 - January 2018

C# - Object Oriented Programming

Excel VBA
Voir plus

Companhia Siderúrgica NacionalJune 2010 - May 2012

* Negotiated items for maintenance of industrial facilities and warehouse control using SAP.
* Negotiated supply contracts with key suppliers for the steel production.
* Created a business plan in purchases with the objective of keeping the steel operation in perfect working order.

Mes compétences

Other

middle office, analytical and constructive analysis, Data Governance Analyst, Python Programming, Total Cost of Ownership, GDPR, Data Analyst, industry~it, SAP Netweaver > SAP BW, industrial planning, Supply Chain Data Analyst, Operational Risk, Demand Analysis, Portuguese, Value at Risk, Microsoft Access, Multi-tasking, Microsoft C-SHARP, Minitab, Diploma > Diploma Production Engineering, Oracle ERP, Cost Reduction, maintenance of industrial facilities and warehouse control, Buyer, MS Excel VBA, Query, Visual Basic for Applications, English, Bachelors Degree > Bachelor of Science, Microsoft Outlook, Management Information System

Business Intelligence

Oracle BI, Tableau Software, Hyperion

Databases

Oracle

ERP&CRM

SAP

Languages

.NET Languages, SQL, Python, VBA

Technologies

SharePoint, Matplotlib, NumPy

Environment of Development

Visual Studio

Others

Analytics, Data Science, Data analysis, Problem Solving

Big Data

Data Mining

Computer Tools

Microsoft Office Pack, Microsoft Excel

Mes études et formations

Bachelor of Science Production Engineering - University Centre of FEI2009 - 2015