Mauri Esfandiari
Functional Responsibility: Statistical Analyst / SENIOR SAS DEVELOPER
(703) 825 - 2943 HOME
202-***-**** CELL
Mr. Esfandiari is an accomplished SAS Programmer and Statistical Analyst
with a background in advanced statistics and mathematics. He has a
demonstrated ability to work with upper level management for requirements
analysis, of translating business needs into technical requirements, and
leading technical projects to completion. He has a proven ability to learn
and apply new software skills quickly. Mr. Esfandiari has a strong
understanding of web-enabled reporting strategies, Data Warehousing and
ETL. He is a capable statistical analyst well versed in various tools,
including SPSS and SAS. He also possesses solid RDBMS skills.
SPECIALTIES
* Advanced Statistics and Mathematics
* Statistical Analyst using various tools (e.g. SAS)
* Data Warehousing and ETL
* RDBMS, including data driven web development
EDUCATION
M.S. (Mathematical Science), Lamar University, Beaumont, TX 1983
B.S. (Mathematical Science), Lamar University, Beaumont, TX 1981
EXPERIENCE
QSSI (Consulting with Center for Medicare and Medicate)
February 2014 -Present
As a SAS Developer and lead I am responsible for all aspects of the SAS
development for the Center for Program Integrity (CPI). CPI is responsible
to identify all aspects of Fraud, Waste and Abuse (FWA) for CMS.
Manage statistical data fraud analysis regarding physicians and pharmacies
claiming double billing for time and services
IBM Global Business Services (Consulting with United States Postal
Services)
May 2013 -Feb 2014
Managing consultant, provide SAS Programming (Development), Statistical
Analysis and provide strategic, tactical and operational decision making
support to USPS MEPT group.
Morgan Franklin Consulting (Consultant with Freddie Mac Single Family Model
and Analytics) April 2012 - April 2013
Credit Models is responsible for leading all credit model development
activities for the Models & Research Division. This includes measuring,
monitoring, and forecasting of house prices, as well as developing and
maintaining core credit risk models for predicting mortgage default rates
and loss severity.
The department's scope includes developing and maintaining the Default and
Capital Model (DEFCAP) and subprime credit models, collateral analysis and
change management, Neo and fundamental house price appreciation analysis,
and counterparty credit models.
In addition, the department produces Freddie Mac's own house price indexes,
Weighted Repeat Sales Index (WRSI) and Home Value Explorer (HVE), which
are widely used throughout the company.
As a SAS developer I am responsible for the development, maintenance and
monthly updating of the PDM model to make sure that the result from the PDM
emulator ties out with the Financial Engineering development that is a web
based system. I am additionally involved in the implementation of
Scorecards for the LP and AME that are mainframe SAS batch programs that is
called by the portstrat system.
COMSYS Rockville, MD (contract with Department of Health and Human
Services), April 2011 to April 2012 Team Lead Consultant
Early Retiree Reinsurance Program (ERRP) provides reimbursement to
participating employment-based plans for a portion of the costs of health
benefits for early retirees, early retirees' spouses, surviving spouses and
dependents. As a team lead and a SAS developer I am responsible for the
conversion of the medical, drug, and eligibility files and pre and post
aggregation of the claim data submitted by 87 vendors throughout United
States of America. I am also responsible for the calculation of
reimbursement.
Used SAS Business Intelligence (BI) tools; SAS Web Report Studio, SAS Cube
Studio and SAS Information Map Studio in a limited basis.
COMSYS Rockville, MD (Contract with Social Security Administration),
September 2010 to April 2011 Consultant
As a senior statistical analyst, I am tasked with modernizing the process
used by the SSA Office of Research, Evaluation, and Statistics (ORES) to
create a series of publication tables describing the SSI, SSDI, and OASDI
populations. SAS development, Statistical Analysis and Data Analysis using
Base SAS, SAS Macro. Enterprise Guide (EG).
TEK Systems Reston, VA (Contract with Department of Veteran Affairs),
September 2009 to August 2010 Consultant
The Military Health System (MHS) is a global medical network within the
Department of Defense that provides cutting-edge health care to all U.S.
military personnel worldwide. As a Senior Statistical Analyst and a SAS
developer consults for the United States Department of Veterans Affairs,
VHA-veterans Health Administration, performing SAS development, Statistical
Analysis and Data Analysis using Base SAS, SAS Macro. Enterprise Guide (EG)
is used to perform various statistical analyses. For the Epidemiology
Division, analyze data involving the Traumatic Brian Injuries (TBI) of the
Veterans of "Operation Enduring Freedom" (OEF) for the War in Afghanistan,
together with three small military actions, under the umbrella of the
Global War on Terror (GWOT). Currently taking MPMM tutorial and preparing
to take the MPMM exam in September of 2010.
Convergenz. McLean, VA (Contract with Fannie Mae), Feb 2009 to August 2009
(Consultant)
* Consulted with clients to determine requirements.
* Created SAS reports based on requests from various groups and managers.
* Developed Macros to create report from very large datasets.
* Used SAS/ACCESS to extract data from Oracle database tables.
* Developed financial models using SAS Enterprise Minor (EM) to perform
statistical methods (e.g., regression, correlation, and descriptive
statistics).
* Used both mainframe and the PL/SQL developer to extract data from the
various databases.
TFSG Inc. McLean, VA (Contract with Center for Medicare and Medicaid), Jan
2008 to December 2009 (Consultant)
As a Senior SAS developer / senior system analyst, performing management,
systems design, security, data analysis, application maintenance and
emerging claim processing technologies for the Centers for Medicare &
Medicaid Services (CMS). I created an on-line / batch processing system for
the Cancer Prevention and Treatment Demonstration. Developed and maintained
the software for the Municipal Health Services Program. I generated system
documentation, user manuals, HIPAA compliance procedures, interacted with
the public, CMS data center and demonstration personnel. I provide
technical advice to clinics, clearing houses, and demonstration researchers
attempting to meet HIPAA guidelines.
SRA International, Inc., Fairfax, VA, Dec 2006 to Nov 2007 (Consultant)
* As a Data Mining and Modeling specialist, used data mining software to
explore Medicare fraud and abuse using the following technologies: SAS
9.1.3, Enterprise Minor (EM), SAS Macros, UNIX, Oracle, PL/SQL developer,
SPSS Clementine, NT.
* Consulted with clients to determine requirements.
* Created SAS reports based on Medicare claims data.
* Developed AF interface for viewing report results.
* Used PL/SQL developer to extract data from Oracle database tables.
* Developed fraud detection programs using SAS and statistical methods
(e.g., regression, correlation, and descriptive statistics).
* Taught basic SAS programming and Statistics.
R.O.W. Sciences, Rockville, MD, October 1997 to Nov 2006. (Member of the
professional staff.)
As a member of the professional staff, used SAS to perform data extraction
and statistical analysis using the following technologies: SAS 6.8,
Mainframe and SAS/PC.
* Consulted with clients to determine requirements.
* Created SAS reports.
* Involved in the development of common data collection protocols and
computerized interviewing software and the design of the national database.
* Designed and implemented data quality control procedures for developing
the national database written in SAS and monitoring data quality control
procedures for the SAMHSA project.
* Coordinated the submission of outcome and service-delivery data to the
national database, monitored the data quality control program, and provided
technical assistance on evaluation research and data management to the
project staff.
MCI, Arlington, a, July 1997 to October 1997. (Member of the professional
staff.)
* Programmed and analyzed several different Local Exchange Carriers
performance over different intervals. Made significant contribution to the
department by improving the existing SAS programs that were primarily
written in basic SAS on MVS Mainframe. Over thirty programs, each
containing several hundred lines of codes were minimized by the significant
use of SAS/MACRO.
* Made significant contribution in debugging programs that contained
logical problems.
* Made significant contribution in debugging programs that contained
logical problems.
National Accident Sampling System, Washington, DC, September 1995 to July
1997. (Member of the professional staff.)
* Made significant contribution in debugging programs that contained
logical problems.
* Implemented imputation for quarterly and annual data file, prepared ad
hoc tabulation on various requests.
* Used Control Charting for Statistical QC, a scientific method of
analyzing data and using analysis to solve practical problems.
* Technical Environment: SAS, SAS/ACCESS, SAS/CONNECT.
National Institute on Drug Abuse, Washington, DC, June 1990 to September
1995. (Member of the professional staff.)
Made significant contribution in debugging programs that contained logical
problems.
* Produced DAWN Annual, Semiannual and Quarterly reports which presented
three years of drug data and regression analysis of trends in drug abuse
patterns in 26 metropolitan areas.
* Developed major statistical reports representing trends in drug abuse
treatment, client admissions/discharges based on a panel of consistently
reporting providers.
* Developed a trend report on cocaine related admissions on drug abuse
treatment; troubleshot and resolved data anomalies originating in data
files supplied to CRS by NIDA.
Crown Life Insurance Company, Washington, DC, June 1988 to June 1990.
(Member of the professional staff.)
* Made significant contribution in debugging programs that contained
logical problems.
* Performed statistical analyses and related functions to provide data to
determine premiums of small group health insurance programs.
* Analyzed hospital and physician fees of 42 PPO health care networks
throughout the United States.
* Determined region area factors that play a vital role in creation of plan-
wide costs and utilization trends to produce statistical reports used to
ascertain future rate changes.
Bureau of the Census, Washington, DC, June 1986 to June 1988. (Member of
the professional staff.)
* Made significant contribution in debugging programs that contained
logical problems.
* Conducted research for development and evaluation of telephone
interviews, development of estimation and weighing procedures to compensate
for interviewees who declined to respond to questions, and
* Development of techniques to measure sampling errors and pinpoint and
resolve curb stoning difficulties.
* Prepared and maintained source and reliability statements and liaised
with other Federal agencies to gather pertinent research data collected by
the Bureau of Labor Statistics.
HARDWARE AND SOFTWARE SKILLS
Operating Systems: UNIX, NT, OS/390
SAS: SAS v9.2, SAS/Macros, SAS/SQL, SAS/Base, SAS/Graphics, SAS/Stat, SAS
Access, SAS Data Warehouse Admin, SAS Appdev Studio, SAS EIS, SAS/Internet,
SAS MDDB, ODS, AF, SCL
RDBMS: SQL Server 7, Oracle 10G, Access, Sybase, DB2
Languages: SAS, VB, SQL, UNIX Shell Script, PL/SQL, HTML, SPSS, Java Script
HONORS AND AWARDS
PI MU EPSILON, Mathematics club,
SAS Users Group International.
---