Data Marketing

SUMMARY:

Senior SAS developer with vast experience in different industries and a proven track record of applying appropriate technology to achieve business needs while maximizing my technical knowledge of business intelligence tools.

Eager to support the information, analytical, and reporting initiatives for your organization

Strong interpersonal, written and verbal, communicator who can deliver effective presentations, consult on analytical projects and maintain collaborative relationships with all stakeholders.

Exceptional problem-solver with keen ability to analyze and develop complex reports from multi-million record data sources that measures key performance indicators and other metrics.

TECHNICAL SKILLS:

Statistical software: (SAS V9.2) on PC, UNIX and mainframe platforms, SAS Enterprise Guide V4.2, SAS Enterprise Business

Intelligence, SAS Add-in for Microsoft Excel and Teradata, Tableau

Operating systems: UNIX (Solaris), Windows 98/2000/XP, Novell, and SQL Server Operating Systems.

Microsoft Office Suite: Word, Access, Excel, PowerPoint, Project, Power BI

Scripting: UNIX Shell and PERL

RDBMS: SQL, SQL Assistant, SQL Server, MS Access

Big Data: Amazon Web Services, Azure

EXPERTISE:

SAS/Graph to control graphs appearance

Accessing and Creating Tables in SAS using SQL Pass-Through

Proficient in SAS procedures and Macros

SAS Output Delivery System (ODS) tag sets for creating HTML, Excel and PDF documents

SAS/ACCESS for Sybase SQL Server

Data Mining and ETL processes

Expertise in Microsoft Excel and Access/VBA

Ad hoc Business Intelligence reporting

Customer retention and profiling

Summarize and present complex data

Performance Metrics Dashboards

Business Intelligence Tools

Data Visualization Tools

EXPERIENCE:

04/16 -06/16

UNIVERSITY OF CHICAGO HOSPITALS, Chicago, Illinois

Manager – Marketing Analytics

Use of Power BI tools to develop executive-level reports and presentation materials to communicate analysis results.

Analyze data profiling reports and evaluates quality, identifying issues and gaps in data with regard to supporting business processes.

Lead, design and perform analyses to report meaningful ROI metrics at the executive-level.

Create and maintain SQL database to capture and integrate data from multiple sources, including Evariant PRM, CRM, Contact Center, EPIC, eSimon and HCI financial system.

Work regularly with the Marketing & Communications team (including Executive Directors, Directors and Managers), Network Development and Director of Business Analytics.

05/15 -09/15

Health Care Services Corporation, Chicago, Illinois

Senior SAS/Database Consultant

Developed SAS and SQL code for the purpose of analysis and reporting to validate and measure business objectives

Database consultant for the Information Management data tables.

Analyzed data to support physician compensation and network optimization.

Interacted with business customers and Information Technology Group contacts.

Performed analysis and database queries to gather information for a better understanding of the business.

Requirements gathering from business units to resolve business issues.

06/14 - 05/15

State Of Illinois, Chicago, Illinois

Department of Insurance Senior Data Analyst

Created reports, charts and dashboards using Excel and Power BI tools,

Performed data analytics to assist in determining the significance and impact of various activities/organizations.

Maintained data dictionary for data tables created by enrollment activities and in the data warehouse repository.

Analyzed the responses to Call Center through the Interactive Voice Response (IVR) system.

Reported findings to help recognize program effectiveness and influence future planning.

Produced reports and information using data visualization practices.

Identified trends suggested by empirical data and evidence.

10/11 - 01/15 – (Worked onsite from 10/2011 – 05/2014. Worked remote/Part time from 6/2014 – 1/2015)

CDW, Vernon Hills, Illinois

SAS Administrator/Developer Consultant

Wrote and Modified SAS code via SAS Enterprise Guide 4.2 and 9.1 to create SAS data warehouse tables.

Subject matter expert for any technical issues involving data accuracy.

Interpreted client needs and data requirements for the building of ad hoc reports.

Executed and monitored the daily and monthly process of refreshing of SAS Data Mart tables.

Automate and recode SAS code for increase efficiencies and reduce data input errors.

Audited SAS Data Mart tables for accuracy and recency.

Managed and resolved data issues as a liaison between the analysts and technical support.

Created new Excel and HTML reporting via SAS Output Delivery System (ODS) to reduce input error and expedite report generation and the decision making process for the account managers.

08/11 - 10/11

NPD GROUP, Rosemont, Illinois

Senior SAS Consultant

Worked with Global Products Group to help with process improvement proprietary application MarketMap, by setting up and running of the Accessories and Footwear categories within MarketMap.

Modified SAS code via SAS Enterprise Guide 4.2 to create Access database tables.

Automated the lookup page in the Excel module to populate dynamically from SAS.

Worked with the GPG team to complete any necessary adjustments to the existing SAS code to MarketMap for transfer to the IT/Ops department.

05/10 - 07/11

Bank of America, Charlotte, North Carolina

Senior SAS Analyst (Consultant)

Traditional analysis and reporting for direct marketing campaigns for deposits and small-business accounts.

Performed statistical significance testing on both Test and Control groups within the campaigns.

Provided monthly dashboard reporting on analysis to better understand the population of customers that are “right-fitted” in terms of changing their accounts post-sale.

Provided analytical insight of how to engage and deepen the bank’s relationship with its customers by measuring Cross Sell/Upsell opportunities, card activation, and online banking suite of products.

Worked with internal Business Partners to develop methodology and scope of direct marketing campaigns.

Reported on retention, attrition and acquisition metrics for direct marketing campaigns by Email (EM), Direct Mail (DM) and other channels.

Used SAS to solve complex calculations and queries across different data sources to build cross channel marketing campaigns.

Performed complex data merges and joins using SQL and SAS on large multi-million record datasets.

Utilized SAS macros to perform repetitive sections of code.

Designed and programmed Excel applications with VBA to automate spreadsheet execution and analysis.

11/09 - 05/10

Wells Fargo, Charlotte, North Carolina

Senior SAS Consultant (Credit Risk – Mortgages)

Monthly and adhoc reporting and analysis of the consumer and small business portfolios.

Provided analytical insight from data analysis for Senior Management to make quality decisions.

Developed and modified SAS code working with TSYS and FDR financial data from Teradata databases.

Monthly analysis and reporting for Home Loan portfolios for strategic initiatives and portfolio performance updates.

Performed ad-hoc analysis on consumer and commercial portfolios for Credit Risk Managers to mitigate credit risk.

Designed and programmed in VBA an Excel reporting and data mapping application for credit risk analyst.

01/08 - 08/09

Chicago Public Schools, Chicago, Illinois

SAS Consultant

SAS development and analysis for the District, school and student level reporting.

Compiled data and managed relationships with internal and external research partners in order to perform independent studies and reporting of test scores.

Extracted, transformed and load data for the District’s report portal.

Expedited the delivery and viewing of HTML and XML reports using Proc Report for the state tests and performance level scores of students, schools and areas by posting them onto website.

Served as liaison between data management and private/public research groups gathering, compiling and manipulating data for conducting research studies.

Created dashboard reports allowing senior-level management to step back from the details and see the key trends and relationships that driving student performance.

Performed all functions related to data gathering, analysis, and reporting.

10/05 – 09/07

Citi Cards, Elk Grove Village, Illinois

SAS Consultant

(12/06 - 09/07)

Senior SAS Analyst (Reporting TSYS to SAS Conversion)

Performed data mapping and continually resourced the metadata and data dictionary in order to map data variables from new data source in order to replicate reports.

Performed business analysis testing, debugging and documenting SAS code.

Executed data analysis utilizing Citibank’s multi-million records consumer and commercial oil First Data Resources (FDR) data files.

SAS programming and report replication for First Data Resources data convergence from old legacy system.

(10/05 - 11/06)

Senior Credit Risk Analyst (Private Label Credit Cards)

Managed accounts and credit line strategies for existing card members (ECM) on a variety of Private Label and Co-brand/Bankcard portfolios. Performed complex data analyses for the functionality of assisting senior management in the decision making of high risk accounts.

Conducted studies of customer groups and product types, and develops computer-based models for projections, e.g. delinquency and charge-off, cost and profitability, new account acquisition, credit limit setting, and account management.

Established credit limits for corporate oil customers private label accounts based on the volatility of the oil market and customers’ transaction history. Performed risk analysis for co-brand portfolios to reduce the company’s exposure to risk, defaults and delinquencies.

Utilized credit bureau, First Data Resources (FDR) and other secondary data sources in the analysis of customer portfolios.

Utilized Perl and UNIX Shell scripting to run batch processes.

11/02 - 09/05

Discover Financial Services, Riverwoods, Illinois

SAS Analyst (Credit Card Marketing Analytics)

Performed the analysis and performance reporting of the monthly direct mail and telemarketing campaigns. Utilized Mintel Comperemedia data to perform competitor offers analysis.

Provide analytics to support strategies for accelerated direct mail campaigns.

Delivered post-booking results for accelerated campaigns compared to pre-approve.

Performed geographical analysis to increase merchant penetration, card activation and utilization while reducing charge-offs and bolstering cardholder retention.

Programmed and developed Excel applications using Visual Basic and SQL coding for the Marketing Department to perform competitive analysis.

07/99 - 08/02

Sears Holding Hoffman Estates, Illinois

SAS Analyst

Measured the effectiveness of advertisements on the pre-print sales circulars by analyzing the size of the ad and the placement (page location) of the ad to determine the profitability and effectiveness of the ad for the Advertising Effectiveness department.

Performed back-end analysis for national lines direct marketing programs using SAS and Sears methodology. Analyzing the response rates of the household files for mailed vs. non-mailed groups by customer segments for each marketing program. Then reporting return on investment (ROI) and profits for each program period.

Created an Excel reporting system to produce the monthly reports generated from the different direct marketing programs and back-end analyses determining the lift of response/non-response and mailed/non-mailed classifications.

EDUCATION:

Bachelor of Arts Northeastern Illinois University, Chicago, Illinois.

Mathematics l Minor: Economics.

Contact this candidate