Dorina Hoxhaj

(248) 705-7082
dorinahsas@gmail.com
PROFESSIONAL SUMMARY:
SAS Programmer/Analyst with 6+ years of professional experience in working with SAS and SAS tools
with strong emphasis on SAS programming, modeling, and data analysis for risk management,
marketing, operations, financial departments of large enterprises and healthcare.

Experience in SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS,

SAS/ETL, SAS /Graph, SAS Enterprise Guide, SAS/MAP, SAS Enterprise Miner, SAS BI,
SASDI.
Thorough knowledge in SAS Programming, Merging SAS Data Sets, Macro Facility,
Preparing data, SAS Procedures, Producing Reports, SAS Formats, SAS Functions,
Storing and Managing data in SAS Files.
Experience in analysis of data for statistical analysis and reporting.
Experience working with different databases (RDBMS) like MS Excel, Oracle, SQL.
Experience in producing external files and reports employing various SAS procedures.
Organizing data in an optimized format to allow fast, easy access and to do analysis on that.
Experience on working with Excel, PowerPoint and ODS HTML formatted files to produce ad
hoc reports to the Users and Business Partners for Presentation and further Analysis.
Experience in developing different methods of extraction, transformation and loading (ETL)
Processes for various source systems
Experience in modeling linear and nonlinear regression and testing hypotheses and finding
confidence intervals for statistical value.
Experience in maximum likelihood estimation, rotatability, factorial experiments and designs.
Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
Extremely energetic, detail oriented, organized team player with strong communication skills,
interpersonal skills, and problem solving skill

Education:
M.S., Probability and Statistics, Oakland University, Rochester, MI
M.S., Mathematics, University of Vlora, Vlore, ALBANIA
B.S., Mathematics and Physics, University of Vlora, Vlore, ALBANIA
Technical Skills:
SAS Tools
SAS/Base, SAS/SQL, SAS/STAT, SAS/Access,
SAS/Macros, SAS Enterprise Guide, SAS/Graph,
SAS/ODS, SAS BI, SAS DI, SAS Web Report
Studio, SAS/Connect, SAS/Map, SAS Information
Map, SAS/ASSIST
Database

Oracle, SQL, Teradata, DB2

Software Tools

MS Access, MS Excel, Word, PowerPoint

Operating Systems

Windows , XP, Vista, Mac OS, UNIX

Language

C++, MatLab, Minitab, R

Work Experience:
CareSource, Dayton, OH
Jan 2014 - Present
SAS Developer/Analyst
CareSource is a leading non-profit public sector managed care company based in Dayton, Ohio.
CareSource has been meeting the needs of healthcare consumers for more than 24 years. In 2004, the
organization was ranked sixth-largest Medicaid managed care plan in the United States. CareSource
provides similar services that most Medicaid companies provide.
Responsibilities:
Prepared data sets on medical claims to statisticians and modelers from Oracle database.
Reviewed existing literature on Medicare, Medicaid.
Used PROC SQL to extract data from SAS Files and Oracle Database and manipulated them.
Created new datasets from raw data files using Import Techniques and modified existing datasets
using Set, Merge, Sort, Update, and conditional statements.
Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle
tables.
Worked with the statistician to analyze the results obtained from various statistical procedures like
Chi-Square, PROC ANOVA, GLM, and T-test.
Generated primary and derived secondary SAS datasets, identified inconsistencies and problems
in the database and reported the findings to the appropriate data management department
personnel.
Incorporated health care specific terms for Event reporting. Performed Ad-hoc Programming for
generating multiple reports in HTML and PDF formats.
Effectively and timely contacted Project Manager of the respective studies about the various
Data Issues and resolved the queries through meetings.
Conducted data investigation using SAS Enterprise Guide.
Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv
and excel data sets.
Created various Graphs using SAS/Graph, SAS/Gplot.
Analyzed data and then created reports in Web Report Studio and Informational Delivery Portal.
Worked with various data integrity issues, troubleshot various performances issues.
Validated data and created reports using different procedures like PROC REG,PROC FREQ,
PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC SQL, PROC
REPORT etc. and SAS ODS facility.
Environment: SAS/Base, SAS 9.3, SAS/STAT, SAS/SQL, Windows XP Professional, SAS/Macro,
SAS/Access, SAS/STAT, SAS ODS, SAS/GRAPH, Oracle 10g, Teradata, SAS Views, SAS Enterprise
Guide, MS Excel, Access.

SunTrust Bank, Nashville, TN

Apr 2013 Dec 2013
SAS Data analyst/Developer
SunTrust bank provides a comprehensive selection of premium financial products and services to
individuals, businesses, nonprofit organizations, institutions, and government entities. The project
included generation of statistical analysis of data using SAS, SAS/Stat, SAS/Access, SAS/SQL,
SAS/Macro, SAS/Graph, HTML and Oracle on UNIX and Windows NT for the e-Commerce and CRM
group. Convert and upload data to Oracle databases.
Responsibilities:
Understood the Business and its Requirements and gathered the requirements from the users
Attended project team meetings, worked with the Business analysts, Marketing Managers,
Statisticians and DBA Team as appropriate and submitted the final reports to the Project
manager
Run various queries using SAS/Base, SAS/SQL and SAS/MACRO for ad-hoc reports according
to the Users requirement.
Used SAS and SAS Tools for pre-processing data, data analysis, statistical analysis, and created
permanent formatted SAS data sets.
Did error handling and performance tuning in Teradata queries and utilities.
Developed datasets based on the marketing models using SAS to ensure high response rates to
the direct mailing campaign.
Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS
Tools SAS/Base, SAS/EG, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect,
SAS/Access.
Used sorting and merging techniques on the input data sets for Data Preparation, to get the
Required output and then writing the code using SAS tools.
Developed routine SAS macros to create tables, graphs and listings for inclusion in reports and
maintained existing ones. Prepared data listings and summaries for statistical analysis.
Developed reports using PROC REPORT, PROC TABULATE and DATA_NULL_ for analysis.
Conducted and generated the Regression, Correlation studies and Analysis of Variance (ANOVA)
using Proc REG, Proc CORR, Proc GLM, Proc ANOVA.
Extensively used the SAS/Macro facility to write weekly and monthly reports.
Environment: SAS 9.2, Base SAS, SAS/SQL, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ACCESS,
SAS/STAT, SAS/ODS, UNIX, Windows NT, MS Excel, SQL Server, Teradata.
Progressive Insurance, W Warwick, RI
Jul 2012 Mar 2013
SAS Developer
The Progressive Corporation is one of the largest providers of car insurance in the United States. The
company also insures bikes, boats, RVs and commercial vehicles, and provides home insurance through
select companies.
Responsibilities:
Developed and designed SAS programs/macros to analyze financial data and to create files,
tables, listings, and graphs.
Developed ad-hoc reports as per business requirements and created various reports like
summary reports, tabular reports
Cleaned existing data and converted them into useful SAS Datasets, merged datasets and
created reports based on Ad-hoc requirements
Developed applications for measuring financial performance of newly acquired accounts:

Forecast vs. Actual and developed SAS programs for generating reports on key financials,
Income statements, and balance sheet.
Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC
TABULATE AND PROC REPORT in order to understand and prepare the data
Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data
preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL
procedures and created SAS data sets.

Environment: SAS/Base, SAS Enterprise Guide, SAS Enterprise Miner, SAS BI, SAS Web Report
Studio, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, Oracle, PL/SQL, MS EXCEL,
MS ACCESS.
The Kroger Co., Cincinnati, OH
Oct 2011 Jun 2012
SAS Programmer/Analyst
The Kroger Co. is one of the worlds largest grocery retailers. Krogers family of stores spans many states
with store formats that include grocery and multi-department stores, discount, convenience stores and
jewelry stores.
Responsibilities:
Produced statistical reports for various business needs and expertise in data preparation, data
cleaning, analysis, and reporting.
Customizing the existing Macros according to need and requirement, testing and debugging the
Macros and creating more complex and reusable Macros.
Used Enterprise Guide (EG) query builder to run queries against the tables and subsetting the
data.
Importing all Reports from web report studio, Stored Process, BI Dashboard and Information
Map to Information Delivery Portal.
Developed SAS programs to create a customer mailing list for direct mailing and telemarketing.
Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS
data sets.
Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS
reports with the help of default procedures. Generated graphs using SAS Report and
SAS/Graph.
Involved in update and maintenance of data warehouse and generation of various sales and
marketing reports.
Exported SAS Reports to the Excel Sheet by using ODS to get the output in multi-sheets.
Developed loss prediction model using Enterprise miner modeling solutions and SAS
procedures.
Created and delivered reports and presentations with key findings and recommendations.
Provided technical support on SAS programming related to data manipulation and analysis.
Environment: SAS/Base, SAS/CONNECT, SAS Macros, SAS/ACCESS, SAS/GRAPH, SAS Enterprise
Guide, SAS/STAT, Oracle, Windows XP, MS Office, HTML.

Verizon, Irving, TX
SAS Marketing Consultant

Jan 2011

Sep 2011

Headquartered in Basking Ridge, New Jersey, the company was originally a joint venture of American
telecommunications firm Bell Atlantic, which would soon become Verizon Communications, and global
British TELECOMMUNICATIONS COMPANY Vodafone.
Responsibilities:
Developed SAS programs to create a customer mailing list for Direct Mailing and
Telemarketing.
Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS
data sets.
Work involved importing customer responses to phone, internet/email and postal campaigns,
performing customer behavior analysis on response information and publishing graphical
reports for review by management and subsequent decision support.
Automated generation of weekly reports for each campaign during its course like Channel/
Region Performance, Member Enrollment etc.
Performed data analysis, created reports with extensive use of BASE SAS, Macros and SAS
reports with the help of default procedures.
Created new programs and modified existing programs.
Generated graphs using SAS Report and SAS /GRAPH.
Created reports using SAS /ODS and SAS /Views from oracle database tables into different
formats like HTML and RTF.
Worked with large customer response and sales data sets.
Worked on creating SAS Data sets from flat files and merging data.
Maintained and enhanced existing SAS reporting programs for marketing campaigns.
Analyzed response and sale results and write up monthly summary on campaign performance.
Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC
TEMPLATE to generate output formats in HTML.
Restructured SAS datasets using PROC TRANSPOSE procedure.
Used PROC SQL Pass through Facility to work with ORACLE.
Environment: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS DDE, SAS ODS, SAS/GRAPH,
SAS/IML, Oracle 9i, DB2, SAS V 8.x, SAS Indexes, SAS Views, SAS MP-Connect, SAS Enterprise
Guide, Base SAS, SAS Management Console, OLAP Cube Studio, SAS Information Map Studio, SAS
Web Report Studio, SAS EBI, SAS Information Delivery Portal, Excel, Windows XP, UNIX.
VODAFONE, Albania
Nov 2008 Oct 2010
SAS Analyst
Vodafone Albania Sh.A. is a mobile telephone company, operating in Albania. Vodafone Albania Sh.A. is
a subsidiary of Vodafone Group Plc a global telecommunications leader.
Responsibilities:
Provided SAS programming Support and Maintenance to Statistics and Data Management
applications.
Involved in Extracting, Analyzing and Validating Finance data from Oracle Clinical/Life Science
Hub Data using SAS.
Developed Analysis-ready data sets and Reports using SAS/Macro programming.
Provided Support and Assistance to Internal Customers, Documented Customer Problems and
Resolution, Worked on Change requests for new enhancements or incident.
Created Ad hoc reports per requests by Statistics and Data Management teams to aid in the
analysis or review of clinical data.

Generated SAS reports in Excel for data analysis.

Created complex and reusable Macros and extensively used existing macros and Developed
SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and
debugged existing macros.

Environment: Base SAS, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Access, SAS Enterprise Miner, SAS
Enterprise Guide, Oracle, MS Access, Windows.