Analytics Lead for Retail Banking Fraud

• Created advanced SQL views for enterprise-wide data visualization dashboards demonstrating all divisions, regions and teams progress towards critical corporate goal of achieving targeted net promoter score• Developed statistical linear regression model reports in R identifying the relationship between customer interactions and product satisfaction metrics • Transitioned essential SQL views across different servers and environments while building example service and customer survey queries to showcase best practices for the user community

• Chosen for SQL expertise among 10 analysts to spearhead the writing and development of company’s most complex tests and queries for new Hadoop platform, identifying, diagnosing and correcting data inconsistencies and errors • Built heat maps for all 50 states by zip code using visual analytics and ArcGIS o Collaborated with Regional Sales VPs customizing metrics per region, measuring impact of prior marketing campaigns and developing growth-focused customer strategy o Partnered with Risk Group using database of all US customers identifying geographic areas of high level insurance coverage correlated with risks of natural disasters and claim levels• Lead and executed project replacing older expensive predictive models driving growth and revenue o Identified models requiring replacement through testing and recommended replacement solutions o Implemented highly effective models to achieve marketing annual strategic goals • Identified clear patterns in suspected fraudulent customer data to prevent further fraud. Built charts, graphs and heat maps using Tableau, displaying results for presentations• Gathered data and developed and implemented predictive models o Utilized SAS for statistical modeling and executed Impala SQL queries on Hadoop o Identified 401(k) customer targets including those likely to make early withdrawals or roll- over large balances

• Created standardization and quality control process for major new 3rd party consumer big data sources o Integrated new data sources of over 100M records into the data production warehouseo Optimized the load and integration of new data using parallel processing on legacy systems, enabling company-wide access to vital information• Adapted and streamlined existing domestic and international consumer segmentation processes permitting quick and effective identification of targeted customers to marketing teams • Identified and implemented solutions for improvement in the existing data production reducing time by 1/3 • Supported company-wide, mission-critical, time-sensitive unclaimed property identification project insuring compliance with new government regulations averting significant fines and penalties

• Process Optimization. Transitioned the build of multiple market growth, wealth, risk and performance management products from costly custom R&D stage to a standardized production process reducing time and costs by more than 1/2• Project Management. Led cross-functional team for high-profile, large-scale analytical projects through all stages of development on short production deadlineso Project manager for unique “Big Grid” data platform which comprised the economic, demographic and financial characteristics of all US residents, serving as the foundation upon which all future products would be basedo Directed production of predictive wealth and income modeling products by combining client network retail assets with 3rd party economic data, generating over 15M in annual revenueo Led implementation of production processes and environments for new sophisticated products• Organized, Analytical, Methodical and Accurate with ability to fit details into big pictureo Enhanced overall product accuracy, finding and correcting suspicious data by identifying statistical outliers and backtracking through the process to determine origination of errorso Recognized for strong analytical, critical thinking and problem solving skills by successive promotions to key newly restructured position reporting directly to executive management• Collaborative Team Player-Independent Worker with ability to prioritize in a fast-paced environment o Resolved data issues through interaction with product managers and clients• Skilled Communicator. Clearly conveyed results of complex concepts and analysis across departments o Utilized Cognos, Excel pivot tables and macros to create graphs and tables visually communicating product results and changes to sales managerso Prepared written proposals for executive management identifying product enhancements and providing estimates for required personnel time and potential risks/rewards

Designed and executed quality control for financial predictive products.

Built and validated the quarterly mutual funds sales database.

Built and validated the quarterly annuities contract sales database.