WORK EXPERIENCE:

SAS Data Analyst

Confidential

• Develop moderately complex programs, macros, and procedures used for analysis using SAS and SQL.
• Perform analysis on health care costs, utilization trends, clinical conditions and quality measurements.
• Design and develop applications for reporting and data management.
• Use SSIS to create ETL processes that migrate data from different data sources while performing data transformations.
• Submit SQL queries against Teradata using Teradata SQL Assistant and SQL pass-through facility.
• Provide application support and consult with end users regarding software and programming procedures.
• Use Tableau to perform data migration, visual analytics and report on medical diagnostic data.
• Assist divisional departments with automation of technical processes and provide recommendations to current analytical systems.
• 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 SAS software including SAS Add-in for Microsoft Office.
• Used SQL pass-through factility to extract data from a Teradata data warehouse. Also used Teradata SQL Assistant for expedited reporting.

SAS Developer / Data Analyst,

• Designed reports to meet ad hoc reporting requests that require data extraction, data cleansing, and data transformation using SAS in a Windows against both Teradata and UNIX servers.
• 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 systems' scopes and objectives for desperate data sources that provide instructions on how to create the minimum loss ratio for each data source.
• Used UNIX shell scripts and Microsoft Task Scheduler to schedule jobs to run on a weekly and monthly basis. This process included ensuring programs run efficiently and uses minimum CPU time.

Senior Marketing Consultant,

• Created programs to manipulate data using Base SAS and SAS Macros to support marketing campaigns.
• Conducted statistical analysis such as multivariate regression using SAS STAT software and other statistical packages in a Unix platform.
• Supported campaign initiatives by producing reports, identifying customer segmentation, and creating presentations that drive better decision making using SAS and SQL software.
• Evaluated the reliability of marketing resources to increase effective information delivery.
• Designed reports using SAS software to meet- ad hoc requests. Preliminary steps included data extraction and data cleansing methodologies.

Page 2

Donna Moore

• Marketed IT products to government entities seeking SAS and SQL software development, web based applications, and interactive training software.
• Monitored performance of government contracts and created initiatives to achieve government sales through customer follow-through and sales promotions.
• Promoted visibility of company products using the US government's GSA Marketing resources.
• Used MS Excel and MS Access to prepare reports for expense and revenue data. Used several software to research data and create reports that help identify areas of profitability.
• Worked in IT organization to aid in the development of automation tools for monitoring human resource demographics for off-shore and US workers.
• Used compliance data and Statement of Work contracts to report outsourcing needs for 2009 and 2010 budgetary requirements.
• Used MS Office and internal reporting tools to create metric reports for expense data, budgetary information, and employee salary data. Reported to higher management on employee resource allocations for projects.
• Assisted pricing actuaries with predictive modeling projects in support of scoring models and regulatory rate filings. All reports used MS Office and other mainframe programs.
• Submitted SQL queries and loaded tables to Teradata using SQL pass-through facility within SAS software.
• Performed data mining using SAS Enterprise Miner to explore marketing opportunities within Travelers legacy data and create time series datasets.
• Translated business requirements into useable reports for financial projects. All reports used Web based software and the Microsoft Office Suite.
• Aided in the development of predictive models for Auto, Property and WC lines of business by extracting data from the mainframe and importing the data onto a UNIX Solaris server.
• external data like MVR data to report changes in motor vehicle history, credit reports and financial data.
• Performed financial reporting to support marketing activities by regional office.
• Assisted the UNIX administrator with creating user ids using SAS Metadata Server and testing SAS BI software like ETL Studio and WebDav .
• Submitted SQL queries and loaded tables to Teradata using SQL pass-through facility within SAS software.
• Created SAS reports for product managers to monitor regional sales and customer retention rates.