Summary

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

Computer Skills

Windows, UNIX, and Linux Environments:

SAS v9, SAS Base, SAS Stat, SAS Macros, SAS ETS,SAS Enterprise Miner, SAS Enterprise Guide, SAS Graph, SAS Access, SAS Connect, SAS EBI, Tibco Spotfire Miner, SPSS, S , R, MYSQL, SQL, ORACLE, Stored Procedures, PL/SQL, SQL Server, UDB/DB2/SQL, Toad, 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, API, CHAID, CART,Neural Nets, MS Access, ODBC, MS Excel: Macros, Pivot Tables, Vlookups, PowerPoint, Erwin, Cognos, Actuate, MicroStrategy, Business Objects,MS Project,Visio, Crystal Reports, Foxpro, Mapinfo, Certified Web Master

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

Senior SAS Programmer / Statistical Data Analyst Developer Project Consultant

• Utilize SAS Enterprise Guide, SAS EBI, Korn Shell on UNIX Solaris to Develop Reports, Analyses, and Stored Procedures for Data Mining, Customer Segmentation, and Predictive Modelling.
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Use SAS Proc MI to Develop Algorithms to Impute Missing Values for Company Precision Project.
• Present All Findings to Major Retail Clients of Company Precision Project.
• Use SAS 9.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.
• Usage of FTP, SQL for the Creation of Adhoc and Dashboard Reports from Teradata Database.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

Senior SAS Reports and Analysis Developer Project Consultant

• Use SAS Enterprise Guide, UNIX, SAS EBI and SAS Data Integration Studio to Develop Reports, Analyses, and Stored Procedures for JPM Chase Financial/Credit Card Digital Marketing Products.
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Interface with SharePoint, Web Portal, Clear Case Change Control Software, MS Excel Pivot Tables.
• Usage of FTP, Ultra Edit, Toad, DB2, ORACLE, SQL Server 2008, and Teradata Databases.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.
• Present all Findings to JPM Chase Financial/Credit Card Digital Marketing Products Team.

Confidential

Mobility Database Marketing Analyst/Statistical Modeler/Software Developer Project Consultant

• Build Predictive Logistic Regression, Tree, and Neural Network B-to-B Analytic Churn Models with Enterprise Mobility Network Data, Corporate Revenue Data, and Corporate Market Research Data.
• Present All Findings to Client. Model Lift Gains Charts Consistently Exceeded Expectations.
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Usage of SAS, UNIX, Korn Shell Scripting, ORACLE 10G, Teradata, SQL, SAS Enterprise Miner, Tibco Spotfire Miner, FTP, R, S , Python, Awk, MS Excel Pivot Tables, PowerPoint, Irfanview.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

Confidential

Tax Technology Project Consultant

• 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

• Develop Sales and Marketing Contact Campaign Lists for B-to-B Sales Force Calls 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/Database Marketing/BI Statistical Modeling Contract Consultant

• Compile and Analyze IMS Xponent Prescription and Sample Data, Medco Prescription Data, IMS Physician Group Practice Data, Sales Force Call Data, IMS PlanTrak PBM Payer-Based Health
• Claims Data, IMS DDD Outlet Data, McKesson Voucher Data, ImpactRx Speaker Data, LASH
• Specialty Pharmacy Transactional Point of Sale Data Medicare Part D Data, Dendrite, SDI, NDC,
• and Genentech Time Series Longitudinal Patient Data.
• 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, Unique, and Innovative Methodology to Create a More Unbiased Control Group Selection Process for Physician Sampling.

Confidential

SAS Developer Project Consultant

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

Confidential

Statistical SAS Programming and Analysis / Database Marketing Project Consultant

• Developed and Presented Corporate DTC High Credit Risk Screening Models Customer Profiles.
• Credit Risk Model Applications Increase Corporate Profits Via More Selective Database and 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 / Marketing ROI Analytic Project Consultant

• 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

• 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 at the Channel Level, Analyzing both Customer Level and Transaction Level Point of Sale Data 50 MM Records .
• Supported Mortgage Retail Finance in Determining Trailer Commission at the Loan Officer Level. Presented Retail with Monthly Audit Reports of Chase to Chase Refinance Customers for Loan Officer Commission Tracking Purposes.
• 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-Chase Home Finance Customers working closely with Outside Data Vendors.
• Developed and Presented Marketing Profiles of Mortgage Union Customers to Direct Mail CRM Campaign Managers for DTC 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 DTC Campaigns.
• UNIX, Shell Scripting, ORACLE , UDB/DB2/SQL, SAS Base: SQL, SAS Stat, SAS Macros SAS Connect, CHAID, MS Excel Macros, Visual Basic, VB Scripting,VBA, Pivot Tables, Vlookups,
• MS Access, PowerPoint, MS Project, Visio.
• Hands-on Project Manager with a Staff of Three SAS Analyst/Programmers.

Confidential

Director of Programming

• 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.
• Gathered Requirements and Automated Client-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, Regular Expressions, Cron, Autosys, Python, APIs, MYSQL, PHP, and SAS in both Linux and Windows Environments.
• 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 DTC Credit Risk Order Screening and List Screening Scoring Programs.
• Wrote Object-Oriented Python Code and APIs to Trigger Alarm Once the Transmitted File Arrived at 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, 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 Third Party Vendor Address Standardization Software.
• As Director of Programming Additional Responsibilities Included Gathering Requirements, Hiring,
• Hands-on Training, and Staff Supervision. Hands-on Project Manager and Systems Developer.

Confidential

Assistant Vice President, Credit Risk Forecasting Analyst

• Developed Predictive Statistical Regression Model Scorecards using Time Series Credit Data for Delinquency, Contractual and Accelerated Write-Offs, and Bankruptcy Customer Segments.
• Forecasted Greatest Credit Risk in Credit Card Portfolio using Transaction-Level Point of Sale Data.
• Presented and Reconciled Credit Risk Forecasts with Collections and Audit Departments.
• Built MS Excel Macros for Automation of Forecast Reporting.
• SAS Base, SAS Stat, SAS Macros, UNIX, Shell Scripting, UDB/DB2/SQL, Stored Procedures , MS Excel Macros, Visual Basic, VB Scripting, VBA, Pivot Tables, Vlookups.

Confidential

Database Manager

• Managed Company Contact Database for 4MM Import/Export/Hazmat Government Compliance Firm Specializing in Business to Business CRM Direct Marketing/E-Marketing.
• Segmented Marketing Database Using In-House Transaction-Level Point of Sale Data as well as Dun Bradstreet SIC Data for Data Mining/Profiling of Customer Database. Customer Profiles led to More Profitable List Selects, More Lucrative Marketing Opportunities and More Profitable Sales Account Management.
• Analyzed Marketing Campaign Results to Improve Direct Marketing Response Rates.
• Managed List Brokers to Identify Most Lucrative B-to-B List Opportunities for Product Marketing.
• Implemented Market Research Surveys to Expand Company Knowledge of Customer Base and Customer Supply Chain/Logistics. Implemented Third Party Vendor Target Marketing Software.
• Member of Company Senior Management Team. Developed and Presented Marketing Analyses and Adhoc Reports to Top Management. Built MS Excel Macros for Database Reporting.
• Usage of SQL, Access, ODBC, Foxpro, Excel Macros, Visual Basic, VB Scripting, VBA, Vlookups, Crystal Reports, Stored Procedures, ONYX, PowerPoint. Usage of MapInfo to Target Market Company-Sponsored Import/Export and Hazmat Seminars held in Various Cities across the US.

Confidential

Senior SAS Programming Project Consultant

• Integrated Multiple Company Files from Various Data Sources as Part of Post Chase-Chemical Merger Effort to Consolidate Home Equity Line/Loan Data into a New Fully Integrated Database.
• Developed Business Processes and Automated Customized Adhoc Reports for Marketing Managers.
• SAS Base , SAS Macros, SYNCSORT, JCL/MVS/TSO/ISPF: IBM Mainframe Environment.

Confidential

Senior Marketing Analyst / Statistician

• Gathered Requirements, Developed, Validated, Maintained, Enhanced, and Presented Market
• Segmentation Promotion Response CRM Customer Retention and Customer Acquisition Logistic
• Regression Discrete Choice Models, CHAID, Neural Network and Discriminant Analysis Database
• Scoring Models. Utilized the In-House Mainframe-Based Corporate Database, US Census-Based
• Demographic Data, Claritas Prizm Cluster Data and Neilsen Ratings Data.
• Developed Customer Profiles and Presented them to Product Managers to Improve Direct Marketing Campaign Promotion Response Rates. Worked with Product Managers to Develop Test/Control Market Research Methodologies A/B Tests and Sample Sizing. Corporate Multivariate Models Consistently Increased Direct Marketing Response Rates for Publishing Magazine, Book, Catalog as well as Entertainment Products Music, Video for B-to-C and B-to-B Direct Marketing.
• Gathered Requirements and Created New US Census-Based Variables for Statistical Modeling using Factor/Cluster Analysis on IBM Mainframe Data. Segmented Data by Media Codes, as Required.
• Conducted all Data Mining Research and Developed Business Processes to Improve Modeling Methodologies and Quality of Database Information.
• Set up and Updated Department Geocoding Software. Translated COBOL Record Layouts to SAS.
• Used SAS Base Proc Tabulate, Proc Freq, Proc Means, Proc Univariate , SAS Stat Proc Reg/ Proc Logistic/Proc Factor/Proc Discrim/Proc Cluster ,SAS Macros, JCL/MVS/TSO/ISPF Mainframe.
• Utilized SYNCSORT and EASYTRIEVE Software to Read in and Process Files with 90 Million Plus Records. Used SI-CHAID and CART Software for Exploratory Data Research.
• As Senior Marketing Analyst, Additional Responsibilities Included Gathering Requirements, Hiring, Hands-On Training and Staff Supervision. Hands-on Project Manager and Systems Developer.

Confidential

Market Analyst

• Developed and Presented Direct Marketing CRM Segmentation Models and Customer Profiles.
• Utilized Discrete Choice Logistic Regression and Factor Analytic Scoring Models to Raise Direct Marketing CRM Campaign Promotion Response Rates for Financial, Travel, Publishing Products.
• Utilized SAS, JCL/MVS/TSO/ISPF on an IBM Mainframe to Extract Demographic and Company Product Data for Data Mining and to Build Predictive Segmentation Models.
• SAS Base, SAS Stat Proc Reg/Proc Logistic/Proc Factor/Proc Cluster , SAS Macros.

Confidential

Market Analyst and Forecaster

Developed, Maintained, and Enhanced VM/CMS Mainframe-Based Econometric/Statistical Time Series Demand Forecasting Models to Predict Company Revenue and Volume Market Share.

• Usage of Wharton Econometric Data and In-House Market Research Survey Data Analysis with SAS Base, SAS Stat Proc ANOVA , SAS Macros, SAS ETS Proc AUTOREG, Proc ARIMA ,
• SAS IML, S and Smalltalk for Data Mining and to Build Econometric and Time Series Statistical Regression Models for Forecasting Company Market Share and for Developing Adhoc Reports.
• Usage of EMS Software to Build Econometric Demand Forecasting Models and for Price Elasticity Estimation. Presented Quarterly Forecasts to Product Management.
• Developed Pricing and Competitive Intelligence Analyses for Tariff Filings and Strategic Planning.

Confidential

Statistician / Consultant

• Designed and Implemented Quality Control Models, Statistical Regression Models, and Market Research Survey Analysis designed to Monitor and Improve Pell Grant U.S. Department of Education Unemployment Insurance U.S. Department of Labor Child Support State of Massachusetts Welfare Department and Rural Hospital Programs Evaluation U.S. Dept of Health.
• Heavy Usage of SAS BASE, SAS STAT Proc ANOVA, Proc REG , SAS MACROS on a VM/CMS Mainframe. Used SPSS Software to Track and Analyze Market Research Survey Results.
• Utilized dBase to Build a Database for the Analysis of Massachusetts State Child Support Data.
• Co-authored and Presented Final Report to the U.S. Department of Labor on the Effectiveness of Various State Unemployment Insurance Programs.

Confidential

International Economist

• Prepared and Presented Policy Papers for Internal Government Use as Part of a Government/Private Sector Team as a member of the International Trade Administration.
• Research Focused on U.S. Industry Market Access Concerns in the European Telecommunications,
• Biotechnology, Manufacturing, and Agricultural Market Sectors.