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

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

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

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

Others

Problem Solving, Data Science, Data analysis, Analytics

Environment of Development

Visual Studio

Technologies

NumPy, Matplotlib, SharePoint

Languages

SQL, VBA, .NET Languages, Python

Big Data

Data Mining

ERP&CRM

SAP

Business Intelligence

Tableau Software, Oracle BI, Hyperion

Computer Tools

Microsoft Excel, Microsoft Office Pack

Other

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

Databases

Oracle

Mes études et formations

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