SUMMARY

• Sr. SAS Programmer / Analyst with 8+ years of experience in Information Technology with solid expertise in the data analysis arena.
• Experience in handling CMS claims (Medicare and Medicaid Claims) through an MCO point of view and KDMS. Understanding HIPPA regulations and obtaining data from EMR and EHR forms and updating the database.
• Calculating HEDIS measures based on Diagnosis codes and Procedure codes.
• Experience in business intelligence reporting, data mining, data analysis and statistical analysis. Experience working with data mining, data discovery, and/or modeling tools.
• Experience analyzing and interpreting data; maintaining and managing large datasets, including ability to ensure the integrity of data.
• Strong analytical skills and ability to use a variety software such as SAS, Python, R, SQL, data visualization software, other related statistical programs, MS Excel, and MS Access.
• Proficiency in Microsoft Word and PowerPoint presentation development.
• Strong analytic thought process and ability to interpret findings.
• Acute attention to detail (QA/QC) and experience working with various quality teams.
• Effective organization and time management skills.
• Understanding of the SAS 9.x Intelligence platform architecture metadata server, application server, web server, web application server, workspace server, stored process server in a multi - tiered environment.
• Strong skills in Data Analysis, Data Requirement Analysis, Data Mapping and creating DataMart for ETL process
• Used Python for Data Manipulation and Data Visualization
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing
• Extracting multi-million record file, data mining and analysis, creating marketing incentive reports
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio
• Strong ability to write SQL queries using PROC SQL
• Knowledge of SAS Metadata Management console and all components including Server management, User Management, Library management.
• Familiar with SAS BI tools and Enterprise Guide. Good Windows system administration knowledge, Linux knowledge.
• Experience in campaign management and marketing analytics.
• Proficiency with Microsoft Excel as a reporting tool, including experience creating VBA macros, creating pivot tables, linking to external data.
• Experience in generating KPI and executive dashboards.
• Strong analytical, communication, teamwork, and interpersonal skills. Ability to work on multiple assignments concurrently. Excellent verbal and written communication skills. Highly motivated and collaborative team player with strong interpersonal skills
• Proficiency in MACRO programming in SAS, using macro loops, macro variables, conditional macro execution, distinguishing global and local macro variables, and creating or referencing macro variables from within the regular DATA STEP.
• Experience debugging Code and SAS Error Diagnostics.
• Experience with SAS Clients: SAS Enterprise Guide, SAS Enterprise Miner, Base SAS, SAS Microsoft Add-in Client Installation & Troubleshooting.
• Experience in change control management and code version control procedures.

TECHNICAL SKILLS

SAS Tools: SAS/STAT, SAS/GRAPH, SAS/ETS, SAS/FSP, SAS/OR, SAS/IML, SAS/QC, SAS/SHARE, SAS/CONNECT, SAS/INSIGHT, SAS/SHARE*NET, SAS/ACCESS Interface to ORACLE, SAS/ACCESS Interface to PC Files, SAS/ACCESS Interface to ODBC, SAS Stat Studio, SAS Enterprise Guide

Languages: C, C++, PL/SQL, SQL, HTML, Minitab

RDBMS: SQL Server, DB2, MS ACCESS 2007/2010, Oracle 9i/10g/11g

Operating System: Windows 8, 7,Vista,XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Sr. SAS Application Programmer

Responsibilities:

• Working with Provider healthcare market data (such as physicians, hospitals, labs data);
• Experience with Medicare, Medicaid and HIX claims
• Generating reports for MCO to KDMS
• EPSDT reports and multiple authorizations reports are generated.
• Identifying the claims based on Diagnosis ICD10 codes and Procedure codes IPCD to distinguish the disease and update the report
• Experience working with Membership files;
• Understanding the Provider Rate Setting to gain knowledge and report accordingly.
• Was a part of UM reporting, and generating the claims data from claims forms provided by facilities
• Experience with Provider files and Health Care Provider Taxonomy Codes
• Updating the provider Information and maintaining the database in order to get in touch with the team.

Confidential, Jacksonville, FL

SAS Programmer / Analyst

Responsibilities:

• Involved in Administration, Maintenance and tuning for SAS Platform and SAS GRID.
• Performed installation, upgrade and configuration of SAS technology products on all supported server environments.
• Used Python for data manipulation and data integration.
• Installed and administered any required supporting products.
• Provided customer-focused support for all levels of technical and application support including incident management (Level 1, 2 and 3)
• Created and maintained SDLC documentation and ensured alignment to overall SDLC and Change Management processes and meet compliance requirements
• Provided reliable delivery of targeted project results through role as expert in the application of specific SAS methodologies, projects and technologies.
• Developed standard Meta data dictionary using SAS/MACRO and PROC FORMAT.
• Collaborated with storage, server, LDAP, database and other IT administrators to support ongoing operations for meeting the business needs via the SAS environment.
• Executed recurring and adhoc direct marketing list pulls with minimal supervision.
• Generated adhoc and recurring reports, analyzed results.
• Pulled, consolidated, and analyzed data from large datasets.
• Partnered with internal customers on developing list pulls and reports including gathering, analyzing, and documenting requirements.
• Involved in manipulation of large datasets by performing calculations, summarizations and creating output.
• Assisted in preparation of analytic deliverables, combining multiple programming outputs to create cohesive reports in Excel.
• Created and maintained weekly, monthly reports.

Environment: SAS/BASE9.2, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/STAT, Oracle, WINDOWS NT, 2000 and UNIX.

Confidential, Frankfort, KY

SAS Programmer / Analyst

Responsibilities:

• Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all teams.
• According to the data mapping, selected and extracted samples from a list of raw dataset, eliminated duplicates, created a one-subject-per-row dataset with PROC SQL.
• Conducted Business Analysis, project assessment and feasibility determination. Analyses of data feed requirements for Risk Management, Customer Information Management and Analytic Support
• Strategized project scoping and specifications documents, to clearly communicate the project roadmap.
• Manage communications with data-mining software providers. Coordinate work with the IT team in regard with proprietary server maintenance and system support.
• Used Python for generating visualization and data modelling.
• Lead the team that supports ad-hoc, standard reporting and production projects.
• Conducted appropriate training sessions for team members to assure knowledge transfer of methodologies, statistical models and other data analysis
• Compiled Risk department with sales production and market penetration data for executive management. Data included employee activity, client coverage and territory alignment analysis.
• Developed sales analysis using Proc Summary, Proc Freq, Proc Reg, Proc Mean, Proc ANOVA, Proc SQL, Proc Univariate, etc for forecast, time-series, and discriminant analysis, etc.
• Built predictive models in risk analysis.
• Improved financial performance by reducing losses, improving capital management and building a risk aware.
• Reported offshore progress to management with the use of Excel Templates, Excel macros, Pivot tables and functions, as well as creating daily, monthly, quarterly and yearly reports activity onsite through the creation of SQL Server, Teradata and MS Access databases.
• Created Graphs and summary reports for risk analysis reports in production using SAS.
• Served as liaison between sales, compensation and accounting organizations to ensure consistency in metrics and reporting standards
• Designed, built and tested a series of SAS programs for the transfer and validation of reports.
• Reduced the time significantly by publishing SAS Financial Management reports.

Environment: s: SAS/ACCESS, SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/STAT, SAS Business Intelligence, SAS Management Console, SAS Enterprise Guide, SAS Enterprise Miner, Sun Solaris, SAS/SQL, SPSS, Oracle, PL/SQL, MS Access, MS Excel, MS Excel Macros, Windows.