Data Marketing

Donna L. Moore

***********.****@*****.***

Telephone Number: 919-***-****

Professional Purpose:

To obtain a position using SAS, SQL and Microsoft Products to support Analytics and Research projects. Education:

University of Hartford, West Hartford, CT Bachelor’s Degree, Mathematics Professional Experience:

Data Consultant, Blue Cross Blue Shield NC, Durham, NC 09/2019 – Present

• Perform analysis, programming and creation of reports for the marketing department using SAS, SQL and Power BI. Calculate return on investment ratios for marketing initiatives and sales events.

• Provide analytical support which includes data collection, trending, reporting and forecasting to ensure data integrity and validity.

• Write SQL queries and use SAS tools to access, summarize, manipulate and capture member claim data.

• Develop new reports using SAS ODS to utilize various ETL analysis and data mining techniques.

• Participate in problem-solving investigations and analyses to make recommendations to business.

• Use SAS Graph software to create KM plot, forest plot, and line plot using existing SAS datasets. Medicare Data Analyst, Covent Bridge Group, Wilmington, DE 04/2016 – 09/2019

• Performed analysis, programming and ETL processing using Medicare and Medicaid data.

• Conducted data mining and statistical analysis to improve marketing strategies. Review contribution and grant reports to identify new product opportunities for sales department.

• Designed, coded, and tested SAS and T-SQL programs used for investment and portfolio reporting.

• Prepared daily and monthly reports using SAS ODS, SQL Assistant, SAS Enterprise Guide, and Power BI to present findings and recommendations to all levels of senior management. Marketing Consultant, TIAA-CREF (Collabera Contractor), New York, NY 03/2015 – 03/2016

• Used SAS software to perform cross channel and cross media marketing analysis and provided recommendations to Marketing managers on prospective marketing campaigns.

• Supported the design, testing and implementation of marketing campaigns using SAS software, T-SQL queries and MS Excel pivot tables.

• Used Teradata SQL Assistant and SQL Pass-Through Facility to extract data and build SQL.

• Published weekly and monthly web reports with a focus on Key Performance Indicators (KPI’) and trending analysis.

Healthcare Consultant, SCIO Health Analytics, West Hartford, CT 12/2014 to 02/2015

• Integrated Healthcare data sources into SAS data warehouses used. for statistical analysis.

• Interpreted and analyzed multi-dimensional data sources to identify key insights, key trends and prospective opportunities.

• Supported predictive modeling projects by selecting variables and applying feature normalization to the predictor variables.

• Used SAS to support clinical trial studies and create SDTM and ADAM datasets. Donna Moore

Page 2

Programmer, CVS Health (Kelly Mitchell Contractor) Warwick, RI 06/2014 to 11/2014

• Managed and analyzed digital marketing data to develop insights on Investigational New Drugs and existing drug treatments for current marketing campaigns.

• Modified statistical models to identify propensity scoring options that predict the customer's ability to manage medications and perform pharmaceutical adherence.

• Used SAS, T-SQL, and Teradata CRM tools to create, manipulate and implement campaign segmentation data and to create marketing list pull. Developer, Highmark Blue Cross Blue Shield, Camp Hill, PA 09/2011 - 05/2014

• Developed moderately complex programs, macros, and procedures used for analysis using SAS and SQL

• Performed analysis on health care costs, utilization trends, clinical conditions and quality measurements.

• Designed and developed applications for reporting and data management.

• Assisted divisional departments with automation of technical processes and provide recommendations to current analytical systems.

•

Consultant, Freedom Disability Advocator Group, Shelton, CT 04/2011 – 09/2011

• Supported marketing campaigns by using Base SAS and the SAS Stat to import demographic data including credit report history from credit bureaus.

• Performed data extraction, data transformation and load processes on call center data to evaluate customer eligibility and create retention standards.

• Installed system updates to internal marketing software including SAS Add-in for Microsoft Office.

• Used SQL to extract data from a central data warehouse using SQL Assistant that is used for reporting.

Applications Developer, CIGNA Corporation, Bloomfield, CT 12/2010 – 04/2011

• Designed reports to meet ad hoc reporting requests that require data extraction, data cleansing, and data transformation using SAS in a Windows and UNIX environment.

• Performed computer programming on health, medical and prescription data in support of the US Healthcare Reform Act to meet minimum loss ratio requirements.

• Created business requirements that describes and translates systems' scopes and objectives into useable programming specifications.

• Documented system scopes and objectives for desperate data sources that provide instructions to create the minimum loss ratio for each data source. Technical Skills

Base SAS Programming and SAS STAT Enterprise Guide SAS Web Report Studio MS SQL Server Querying and Reporting Data Warehousing SAS ETL Studio Mainframe Programming with JCL UNIX Shell Scripting MS Office Suite

Contact this candidate