Pedro Pinto Email & Phone Number

London, United Kingdom

Redress Project: provide accurate analytics to help put things right for customers; Validation and ETL processes on large data volumes, present findings in a concise and meaningful manner to both internal and external business partners; Identify customers impacted by banking errors or product issues and calculate refunds due, facilitate and support the fulfillment of redress activities. Acquire a comprehensive understanding of financial products, including, Overdrafts, Credit Cards, and Mortgages, through data analysis. Technologies utilised: SQL, SAS, Teradata, Big Query (GCP), Python.

Chester, United Kingdom

▪ Work as part of a team to deliver value-adding services and solutions to a group of clients. Technologies used: SQL, SAS Base, SAS EG, SAS DI, SAS VA, Teradata, Hadoop. ▪ Online Retailer: Impact analysis of major transformation programme; Remediation of impacted queries in SQL/Teradata, SAS Base, SAS EG and SAS DI; Engaging support from other cross functional representatives.▪ Financial Institution: Population Analysis for a major project to remediate existing customer data and create a single customer view – ETL, data sourcing, data consolidation, remediation and testing; Anti Money Laundering and Due Diligence project involving customer transactions analysis handling very high-volume data to flag high risk customers. Non-performing Exposures project; Arrears Mortgages Letters Mart.

Manchester, United Kingdom

▪ Deliver a range of finance systems, data & MI solutions; Engage with other cross functional representatives;▪ Migration from SAS Base and SAS EG to SAS DI Studio; Small Changes;▪ Projects (SAS EG/DI Studio): Core Prudential Programme (CPP), Liquidity Additional Monitoring Metrics (AMM), Customer Engagement; First Aider and Fire Warden.

Lisbon Area, Portugal

▪ Tranquilidade, Lisbon - Insurance/Finance: SAS jobs and macros development; Extract/Transform/Load (ETL); Data migration from GreenPlum/SQL Server to SAS Grid using SAS Base, SAS EG, PL/SQL, Excel and Unix Script. Detection and mitigation of errors in the daily, weekly and monthly SAS routines; Improvement and maintenance of the data warehouse. Projects: Website contact form; Claims and Reinsurance;

Zurich, Switzerland

▪ Software and hardware development/test, for interaction with scales by voice commands using Java, SQL Google APIs and android based systems.

Szczecin, Poland

▪ Measurement system development for NDT; Evaluation of materials using thermography and microwaves;▪ Software development to handle a thermal camera and a vector analyzer using LabView; Getting acquainted with thermography measurements regime.

Education record

Python Basics for Data Science; Analyzing Data with Python.

Sas Data Integration Studio: Fast Track

SAS DI Studio: Essentials SAS DI Studio: Additional Topics

Sas Base/Advance Programmer / Data Manager

SAS® Macros SAS® SQL SAS® Enterprise Guide 1: Querying and Reporting SAS® Enterprise Guide 2: Advanced Tasks and Querying SAS® Programming.

Bsc, Electrical And Computer Engineering, 2:1

Subjects of Mathematics, Physics, Computer Science and Electrical Engineering. Development of projects using C#, C, Java, HTML, SQL.

Msc, Electrical And Computer Engineering (Suspended), 1St (Expected)

Main areas: Digital Systems, Robotics and Business Intelligence. Use of prediction models using MatLab and Excel during the implementation.