Joao Flor

Use Unix SAS, PC SAS, and SQL to conduct ad-hoc exploratory data analysis based on statistical techniques, and provide quantitative data support to ensure answers are based on sound analytics. Profile clients to better understand of client base. Evaluate campaigns to assess their impact on sales. Generate regular reports, as needed, in order to detect trends and insights. Generate random sample client lists for marketing strategies.

Create and maintain business baseline segmentations to support all portfolio marketing initiatives. Change and validate the processes, conduct swap analysis, and compare estimates. Build new more dynamic segmentations to help business units in their strategies, perform stability analysis, and analyze performance. Periodically validate existing models as well as validate the performance of new models vs their replacement tools. Investigate new data sources to identify value added potential variables.

Responsible for the conceptualization and enhancement of predictive and other analytically derived models, by using Cluster Analysis and Logistic Regression, to produce the highest level of fraud detection and prevention. Use Base SAS, Proc SQL, and SAS Macros to extract, transform and load (ETL) datasets from various sources to assess their value. Perform exploratory data analysis (EDA) and statistical analysis tasks (clustering, sampling, segmentation, and significance testing).

Build statistical response models, using SAS, Proc SQL, Cluster Analysis, Logistic Regression and other statistical techniques, to segment customers for targeting marketing and sales strategies. Build robust statistical processes, explore and analyze the database to measure the effectiveness of business initiatives, and to discover meaningful patterns and rules about our customers. Provide data analyses and develop management reports that identify selling opportunities and sales trends.

Build and validate scorecards, segmentation and classification schemes, and other types of predictive models for risk evaluation, marketing and other non-credit related functions. Provide analytic support for predictive models’ implementation, monitoring and performance tracking.

Responsible for producing end of month sales/revenue analysis and commentary, sales/revenue analysis for budget and forecasts, and general statistics reports.

Research, monitor, review and analyze financial securities data to support the company’s analytical and database software related to the fixed income markets of Portugal, Brazil, Guatemala and Brady Bonds. Evaluate material on financial securities to determine optimal data for client base.