Argenis Vieira

Consultant working at client site: Leroy Merlin Spain Responsibilities included: • Designed, created, updated and validating ETL processes in SAS Data Integration Studio • Solved and answered constant Ad-hoc request from the Marketing management team • Took and documented requirements of new data processes • Updated & Manipulated Reports in SAS Visual Analytics • Redeveloped the Marketing Attribution Model of Leroy Merlin Spain using SAS EG

Main projects: Implemented changes into the Direct Mail Reporting process and Statement channel analysis. • Created Report that analysed and tested marketing campaigns (A/B groups) • Analysed the feasibility of adding Statement and SMS Marketing campaigns into the Bank’s Marketing Attribution Process using Teradata-SQL and Tableau • Supported the production of weekly and monthly marketing reports. • Managed, prepared and presented projects & tasks results to stakeholders

Main Project: Creation of Co-op Bank Customer Segmentation Tool • Analysed Credit Cards Fees, Minimum Payments, and Loan Re-Sell to build up a better strategy to contact customers using SAS • Collaborated in reformulating Credit Card and Unsecured Loan Forecasting Processes. • Analysed the Customer Base to create a new Customer Segmentation for cross-selling • Liaised with external company to build a Customer Segment Algorithm.

Project: New Debt Management system • Engaged with Stakeholders to gather Data Requirements across different departments • Analysed data and Produced detailed data integration requirements specs. • Performed data profiling and segmentation of collection data. Created a set of new variables based on historical data to analyse customer behaviour and generate insights.

Responsibilities included: • Analysed the Guarantor Loan data, presented results, and gave recommendations to stakeholders. • Analysed the impact of changes in affordability, to be implemented in Satsuma loans. • Investigated and implemented alternatives to the existing affordability methodology using SQL and SAS • Created an Expenditure Model using SAS, that was embedded in the application process of Home Credit. • Created a fuzzy address match process, used to measure Marketing Campaign Responses.

Responsibilities included: • Created a set of new variables based on historical data to analyse customer behaviour and generate insights. • Engaged with Stakeholders to gather Data Requirements across different departments • Assembled requirements specifications to drive automated data migration processes • Imported Data into the new Database using SAS DI Studio • Performed Data Testing. • Created a Data Dictionary to help users with the new Marketing Database.

Responsibilities Included: • Provided solutions for ad hoc requests related to sales, store performance and Marketing Campaigns effectiveness on the Asda-Walmart database • Created and Delivered the RFM Report (Recency, frequency and Value) for Online shopping • Developed a cluster analysis of product consumption by regions.

Responsibilities included: • Developed a SAS Base training guide, and trained 4 new Data Analysts. • Received, verified, and cleansed financial and insurance data from Clients. • Built an application scorecard for the mobile company O2. • Assisted in Building the Single Customer View Summary Tool • Creation of a Decision Tree model for AgeUK Marketing Campaign. • Assisted in Creation of a Deceased Match process. • Won the Employee of the month award twice.