sas developer
Resume:
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, ETL, and OLAP concepts. 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)
* SAS client-server Architecture
* Data Warehousing, ETL, and OLAP
* 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
COMSYS Rockville, MD, September 2010 to Present 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, March 2010 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, Feb 2009 to Jan 2010 (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, Jan 2007 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.
Capital One Financial Services. Richmond, VA, July 2006 to Dec 2006 (Consultant)
* Consulted with clients to determine requirements.
* Created SAS reports based on mailed solicitations and credit bureau data.
* Developed AF interface for viewing report results.
* Developed SAS applications for data analyst to extract data from the warehouse and use the result as input to the POLARIS system.
* Used SAS/ACCESS to extract data from Oracle database tables.
* Developed retro scoring models using SAS and statistical methods (e.g., regression, correlation, and descriptive statistics).
* Used Data Warehouse Administrator to create an ETL process for a Balanced Scorecard application.
* Used both mainframe and the PL/SQL developer to extract data from the TERADATA to see whether the solicitations from different IPODs are original or remains.
SRA International, Inc., Fairfax, VA, July 2005 to June 2006. (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.
Merck & Companies, Inc., Lebanon, NJ, November 2003 to June 2005. (Consultant)
* As a SAS Programmer, used SAS to perform auditing using the following technologies: SAS 9.1.3, SAS Enterprise Miner, SAS Macros, UNIX, Oracle, PL/SQL developer.
* Consulted with clients to determine requirements.
* Created SAS reports based on employees data.
* Used PL/SQL developer to extract data from Oracle database tables.
Freddie Mac., Mc Lean, VA, March 2002 to October 2003. (Consultant)
* As a SAS Programmer, used SAS to perform data extraction and analysis using the following technologies: SAS 8.2, IBM Mainframe, and SAS Macros.
* Consulted with clients to determine requirements.
* Created SAS reports based on financial data.
Blue Cross Blue Shield Association., Washington, DC, December 2001 to March 2002. (Consultant)
* As a SAS Programmer, used SAS to perform data extraction and statistical analysis using the following technologies: SAS 8.2, IBM Mainframe, and SAS Macros.
* Consulted with clients to determine requirements.
* Created SAS reports based on Medical Claim data.
FDIC. Fairfax, VA, January 1998 to December 2001. (Consultant)
* As a SAS Programmer, used SAS to perform data extraction and statistical analysis using the following technologies: SAS 8.2, IBM Mainframe, and SAS Macros.
* Consulted with clients to determine requirements.
* Created SAS reports from Mainframe Log Data.
* Assisted in other security program area on a need basis.
* Used QPR Process Guide, a comprehensive process-mapping tool that allows users to create multi-level process map with the ability to attach documents and metrics to process steps, run dynamic simulations, and collaborate by writing comments, action plans, and lessons. By seamlessly integrating QPR Scorecard and QPR process Guide into one convenient portal.
R.O.W. Sciences, Rockville, MD, October 1997 to January 1998. (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.1.3, 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.
---
Contact this candidate