SUMMARY:

Highly Skilled M.S. - Economics with Over 32 Years of Experience as a SAS Developer, Statistician, Quantitative Demand Forecasting Analyst, Credit Risk Forecasting Analyst, Database Marketing Analyst, Market Research Analyst, Pricing Analyst, Response Modeler, Database Manager, Project Manager, Staff Manager/Trainer, Software/E-Commerce Developer, E-Marketing/Web Analyst Specializing in Data Science, Data Mining, Informatics, Business Intelligence, Predictive Modeling, Customer Segmentation.

COMPUTER SKILLS:

Windows, UNIX, and Linux Environments: SAS v9.4, SAS Base, SAS Macros, SAS Stat, SAS ETS, SAS Graph, SAS Enterprise Miner, SAS Enterprise Guide, SAS Access, SAS Connect, SAS EBI, Tableau, Tibco Spotfire Miner, SPSS, SPSS Modeler, S+, R, MYSQL, SQL, PL/SQL, Oracle 11g, Toad, Stored Procedures, SQL Server, UDB/DB2/SQL, Teradata, UNIX Shell Scripting, Awk, Cron, Autosys, vi, EMACS, OLAP, C, C++, Perl, Python, PHP, GUIs, HTML, XML, DHTML, Java, JavaScript,Visual Basic,VB Scripting, VBA, VB.Net, PGP, NDM, FTP, Putty, CHAID, CART, Decision Tree Modelling, Neural Nets, Access, Excel Macros, Pivot Tables, Vlookups, Power Point, Cognos, Erwin, Netezza, MicroStrategy Business Objects, MS Project,Visio, Alteryx, Mapinfo, Certified Web Master, Aladdin Portfolio Management System

Mainframe: SAS,SPSS,COBOL,EASYTRIEVE,SYNCSORT,GRP1,CLIST,FORTRAN,PLCS,PL1,EMS

Mainframe Operating Systems: JCL/MVS/TSO/ISPF/VSAM,VM/CMS,VSE,SMALLTALK,PROCOM

EXPERIENCE:

Confidential

Data Science Consultant

Responsibilities:

• Use R, SAS v9.4, Tableau, Matlab,Visual Analytics, SQL, MS Excel Pivot Tables and Spotfire to analyze Pharmaceutical Real World Evidence (RWE) Medical Outcome Patient Cohort Data.
• Utilize Statistical Modelling Methodologies to Maximize Revenues for Financial Industry Investment Bank Clients.

Confidential

Senior SAS Developer/Quantitative Market Data Analyst/Predictive Statistical Modelling Consultant

Responsibilities:

• Develop SAS Statistical programs to build hundreds of Econometric Forecasting Models and Simulations for Corporate Treasury’s Investment Bank Portfolio. Products include ABS, CMBS, RMBS, MUNIs and International. Econometric Time Series Models predict potential future business losses in response to the Federal Reserve’s Dodd-Frank CCAR Initiative for Investment Portfolio Stress Test Modelling.
• Statistical Model Predictions and In-Sample Back-Testing Model Validations include various Financial Credit Risk and Compliance Stress-Testing Scenarios given by the Federal Reserve. These scenarios include Baseline Bank Holding Company Market Forecasts, Adverse Scenario Market Forecasts, and Severely Adverse Scenario Market Forecasts.
• SAS v9.4, SAS Enterprise Guide, SAS Base, SAS Macros, SAS STAT, SAS ETS and SAS Graph.
• Heavy Usage of SAS Proc SQL, MS Excel: Hlookups, Vlookups, and Pivot Tables, MS Excel VBA.
• LGD Model Documentation Editor. Usage of Black Rock Aladdin Portfolio Management System.

Confidential

Senior SAS Developer/Quantitative Market Data Analyst/Predictive Statistical Modelling Consultant

Responsibilities:

• Use Hadoop Hive SQL to Extract and Summarize Device Performance Transactional Data for Predictive Modelling of Device Technology Data. Develop Predictive Modelling Equations in SPSS Modeler.
• Usage of Tableau, Visio, and Microsoft Excel for Developing Graphs, Data Presentation, and Building Report Requirements.
• Develop Graphs and Charts and Present to Top Management regarding Human Resource Market Trends. Usage of Oracle 11g PL/SQL, Toad, Cognos, and Endeca for Report Production.
• Use Oracle 11g SQL Developer Data Miner to Develop Predictive Attrition Models and Scoring Equations for Human Resource Data Warehouse Variable Reduction and Scoring.
• Usage of Regression Analysis and Decision Tree Modelling, Cluster Analysis and Factor Analysis.
• Use SAS Enterprise Guide, SAS EBI, Putty, Korn Shell on UNIX Solaris to Develop Analyses and Stored Procedures for Data and Text Mining,Customer Segmentation, and Predictive Churn Models.
• Usage of FTP, SQL for the Creation of Adhoc and Dashboard Reports from Teradata Database.
• Use ETL to Integrate Millions of Records from Numerous Databases into One Main Database.
• Use SAS Proc MI to Develop Algorithms to Impute Missing Values for Company Precision Project.
• Develop Customer and Prospect Profiles using Company Cell Phone Data and Acxiom Infobase Personicx Cluster Data. Present all findings to Retail Clients for E-Commerce Direct Marketing.
• Use SAS v9.3, Factor/Cluster Analysis, Logistic/Linear Regression, Tree Models, SAS Enterprise Miner, SPSS Modeler, SQL, R, Hadoop, Alteryx, MS Excel Pivot Tables, MS Access, Ultra Edit.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

Senior SAS Reports Developer and Quantitative Market Analyst Project Consultant

Responsibilities:

• Use ETL to Integrate Millions of Records from Numerous Databases into One Main Database.
• Interface with SharePoint, Web Portal, Clear Case Change Control Software, MS Excel Pivot Tables.
• Usage of FTP, Ultra Edit, Putty, Toad, DB2, PL/SQL,ORACLE, SQL Server and Teradata.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.
• Present all Findings to JPM Chase Financial/ Confidential Digital Marketing/E-Commerce Team.

Confidential

Quantitative Mobility Database Market Analyst/Statistical Modeler/Software Developer Consultant

Responsibilities:

• Build Predictive Logistic Regression, Tree, and Neural Network B-to-B Direct Mail Churn Models using Enterprise Mobility Network Data, Corporate Revenue Data, and Market Research Data.
• Present All Findings to Client. Model Lift Gains Charts Consistently Exceeded Expectations.
• Use ETL to Integrate Millions of Records from Numerous Databases into One Main Database.
• Use SAS, UNIX, Putty, Korn Shell Scripting, PL/SQL,ORACLE, Teradata, SQL, SAS Enterprise Miner, Tibco Spotfire Miner, FTP, R, S+, Python, AWK, Excel Pivot Tables, PowerPoint, Irfanview.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

Tax Technology Project Consultant

Responsibilities:

• Utilize COBOL and SAS Programming for Corporate Tax Technology Department Data Warehouse Extraction, Transformation and Loading (ETL) of Tax Audit Data.
• Convert Millions of Records of Business and Residential Point of Sale Tax Register Data from Mainframe Files to MS SQL Server 2005/2008 Database for Tax Audit Purposes.
• Conduct System/Unit Testing. Build Excel VBA Macros to Automate Tax Register Data Retrieval.
• Heavy Usage of COBOL, SAS Base, SAS Macros, JCL/MVS /TSO/ISPF, DB2, SQL, SYNCSORT, NDM, FTP, MS Excel, MS Access, SharePoint.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

Database Marketing Project Consultant

Responsibilities:

• Develop Sales/Marketing Direct Mail CRM Campaign Lists for B-to-B Sales and E-Commerce.
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Segment Marketing and Sales Contacts by SIC Codes and Transaction-Level Point of Sale Data.
• Build MS Excel Macros for Automation of Management Dashboards and Adhoc Reports.
• Extract Data from Corporate Database. Strong Usage of SQL Server; ODBC; MS Access: SQL, Macros, Queries; MS Excel: Macros, Visual Basic, VB Scripting, VBA, Pivot Tables, Vlookups.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

SAS Programming & Analysis/Quantitative Database Marketing/BI Statistical Modeling Consultant

Responsibilities:

• Analyze Market Research and WebMD Data and Present Best Target Physicians to Field Sales for Sales and E-Commerce Promotions. Develop Targeted Direct Mail and E-Commerce Contact Lists.
• Utilize Data Mining and Statistical Multivariate Modeling Mix Methodologies to Evaluate Company ROI and Promotion Response for Various Web/E-Commerce and Speaker Direct Marketing CRM Campaigns Targeted to Specialized Physicians. Segment Data using Cluster Analysis as Required.
• Build Scorecards and Increase Market Share in the Oncology, Hematology, Respiratory, Dermatology, Cardiovascular, Metabolic and Neuroscience Therapeutic Areas.
• Build Test/Control Samples (A/B Tests), Design and Build Databases using Patient-Level Transactional Point of Sale Data, Physician-Level Prescription Data and Outlet-Level Data.
• Conduct and Present Multivariate Statistical Analyses and Market Segmentation/Optimization Studies to Support Product Marketing/Sales. Design Sales Force Sizing/Structuring Analyses.
• Develop Competitive Intelligence Market Share, Pricing, and Forecasting Models.
• Track Patient Compliance, Persistence, Adherence, and Dosing Levels. Usage of ICD-9 Codes.
• Build MS Excel Macros to Automate Management Dashboards and Adhoc PowerPoint Reports.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.
• UNIX, SAS v9 Base: SQL, ODS, DDE, Freq, Means, Univariate; SAS Stat: TTest, GLM, ANOVA, ANCOVA, Cluster Analysis; SAS Macros, SAS Enterprise Miner, SAS Connect, MS Excel: Macros, Visual Basic,VB Scripting, VBA, Pivot Tables, Vlookups; MS Access, PowerPoint, MicroStrategy.
• Received an “Above and Beyond” Recognition Award for Developing a New Innovative Methodology to Create a More Unbiased Control Group Selection Process for Physician Sampling.

Confidential

SAS Developer Project Consultant

Responsibilities:

• Used SAS Programming for Company Data Warehouse Extraction, Transformation, Loading (ETL).
• Developed Business Processes and Stored Procedures.
• Tested Algorithms to Track Market Surveillance and Support Audit Regulations for AML Brokerage Point of Sale Transactions. Conducted System/Unit Testing.
• Usage of SAS Enterprise Guide, SAS Base,SAS Macros,UNIX,UDB/DB2/SQL,ORACLE, PL/SQL.

Confidential

Statistical SAS Programming and Analysis / Quantitative Database Marketing Project Consultant

Responsibilities:

• Developed and Presented Corporate Confidential High Credit Risk Screening Models & Customer Profiles.
• Credit Risk Models Increased Profits Via More Selective Database/E-Commerce Marketing.
• Utilized SQL, EDA, Linear and Logistic Discrete Choice Regression Modeling Mining In-House Transaction-Level Point of Sale Credit Data on IBM Mainframe.
• Built MS Excel Macros to Automate Graphing/Adhoc Reporting.
• SAS Base, SAS Stat, SAS Macros; JCL/MVS/TSO/ISPF

Confidential

Statistical SAS Programming and Analysis / Quantitative Database Marketing ROI Consultant

Responsibilities:

• Designed and Implemented Analytic and Statistical Multivariate Modeling Solutions for Market Research CRM Brand Panel Studies for the Pharmaceutical and Retail Consumer Goods Industries.
• Quantified Advertising Dollars and Web/E-Commerce Sales Relationship using Time Series Data. Estimated ROI for Retail Consumer Goods Chain (Circuit City). Presented All Findings to Client.
• Analyzed Market Research Survey Data to Increase Client Market Share by Quantifying Relationship Between Brand Awareness and Brand Consideration to Product Purchase Intent for Business to Business Pharmaceutical (Cardinal Health) Customers. Presented All Findings to Client.
• Statistical Modeling Methodologies Included Estimating Polynomial Distributed Lag Models, Ad Stock Models, and other Non-Linear Regression Models. Strong Usage of Cohort Data.
• Built MS Excel Macros to Automate Graphing/Adhoc Reporting.
• Utilized PC SAS, SAS Base (Proc Freq, Proc Means, Proc Univariate), SAS Macros, and SAS Stat (Proc Anova, Proc PLS, Proc Reg) to Automate Analyses, for Adhoc Time Series Reporting, for Data Mining, and for Statistical Modeling. Segmented Data by Media Codes, as Required.
• SPSS, MS Excel Macros, Visual Basic, VB Scripting, VBA, Vlookups; PowerPoint, Curve Expert.

Confidential

Vice President, Project Manager

Responsibilities:

• Gathered Requirements and Provided Analytic Support to Top Management via the Publication and Presentation of Monthly Business MIS Audit Reports with Analytic Highlights on Payoffs, Recaptures, Streamline, and Home Equity Utilization for Mortgage and Home Equity Products.
• Tracked, Monitored, and Re-Priced Home Equity Line of Credit Revenue Confidential the Channel Level, Analyzing both Customer Level and Transaction Level Point of Sale Data (50 MM+ Records).
• Built and Presented Monthly Audit Reports to the Mortgage Retail Finance Department to Track Trailer Commissions Confidential the Loan Officer Level for Chase Refinance Customers.
• Responsible for the Programming of an Automated Report Process for Loan Officers to Track their Accounts via the usage of Actuate, Business Objects and Cognos. Analyzed Call Center Market Research Survey Data to Optimize Call Center Performance.
• Built MS Excel Macros for Automation of Management Dashboards and Adhoc PowerPoint Reports.
• Gathered Requirements and Managed Mortgage Recapture Data Mining Study of Refi vs. Purchase Behavior of ex- Confidential Customers working closely with Outside Data Vendors.
• Developed and Presented Marketing Profiles of Mortgage Union Customers to Direct Mail CRM Campaign Managers for Confidential Target Marketing Purposes.
• Managed the Analysis of Mortgage/Home Equity Share Accounts and the Building of a Home Equity Line of Credit Utilization Forecasting Model. Produced and Presented In-Depth Analyses of Mortgage Recaptures to Campaign Managers using Infobase and Microvision Data (similar to Claritas Prizm Clusters) to Segment Chase Mortgage Customers by Financial Behavior Categories.
• Developed Scorecards and Segmented New Chase Home Equity Customers by SPP Score. Evaluated SPP Scoring Model Efficacy for Home Equity Direct To Consumer Mailings.
• Gathered Requirements, Developed, and Managed File Scoring Business Process of Internal and Outside Vendor Discriminant Analysis Scoring Models. Discriminant Analysis Models consisted of a Set of Equations where Each Equation Identified a Financial Customer Type (similar to Claritas Prizm Clusters). Segmentation Models Increased Response Rates to Confidential Campaigns.
• UNIX Shell Scripting, ORACLE,PL/SQL, UDB/DB2/SQL, SAS Base: SQL, SAS Stat, SAS Macros;CHAID, Excel Macros,VBA,Pivot Tables,Vlookups,Access,PowerPoint, MS Project, Visio.
• Hands-on Project Manager with a Staff of Three SAS Analyst/Programmers.

Confidential

Director of Programming

Responsibilities:

• Gathered Requirements, Designed, and Deployed Customer Specific Programming Systems, Business Processes, and ETL to Support Company Operations in the Implementation of Bad Pay/High Credit Risk Scoring Solutions for Direct Marketing/E-Commerce CRM Clientele.
• Gathered Requirements, Developed and Maintained Company Real-Time Automated Client-Customized E-Commerce Confidential Credit Risk Order Screening and List Screening Scoring Programs.
• Gathered Requirements and Automated Customized E-Commerce Order and List Credit Risk Scoring Solutions for Direct Marketing Clients using Perl, Java, JavaScript, XML, HTML, FTP, PGP Encryption, Unix Shell Scripting, Cron, Autosys, Python, MYSQL, PHP, and SAS on Linux.
• Wrote Object-Oriented Python Code and APIs to Trigger Alarm Once the Transmitted File Arrived Confidential the Company Website via Ftp, De-Crypted the Encrypted Data, Cleansed and Address Standardized the Data, Loaded the Cleansed Data from a Flat File into MYSQL, Overlaid the File with Credit Risk Screening Data, Scored the File, Re-Encrypted the File and Transmitted the Scored File via Ftp to the Client Tcp/Ip E-CommerceWeb Address in Real Time.
• Designed and Produced All In-House and Third Party Databases including InfoUSA US HH Database - 90 MM+ Records and Axciom Infobase Data (similar to Claritas Prizm Clusters).
• Loaded, Audited, Cleansed, Built Data Models, and Standardized Raw Data to Ensure Data Quality/Integrity throughout Data Warehouse. Re-Coded Database Production from Mainframe Platform to Red Hat Linux using MYSQL/Python. Implemented Address Standardization Software.
• Designed and Enhanced PC-Based File Tracking Systems using C and C++. Developed GUIs using PHP and MYSQL. Automated VSE Mainframe Jobs using Easytrieve, Syncsort, Group1, COBOL, JCL/MVS/TSO/ISPF; SAS Base: SQL, ODS; SAS Stat: Proc Reg, Proc Logistic; SAS Macros.
• As Director of Programming Additional Responsibilities Included Gathering Requirements, Hiring, Hands-on Training, and Staff Supervision. Hands-on Project Manager and Systems Developer.