SUMMARY

• SAS Programmer/Analyst with 7+ years of professional experience with pharmacy working with SAS and SAS tools with strong emphasis on SAS programming and data analysis for Health Care, Insurance industries and financial departments.
• Strong experience in SAS/Base, SAS/Macro, SAS/STAT, SAS/Connect, SAS/ODS, SAS/ETL, SAS /Graph, SAS BI, and SAS DI Studio, SAS Enterprise Guide
• Experience in analysis of data for statistical analysis and reporting.
• Expert in using PROC SQL, PROC TABULATE, PROC GCHART, PROC REPORT, PROC FORMAT, DATA MERGE, PORC SORT to generate ad - hoc and customized reports.
• Strong experience in using SAS/ACCESS (LIBNAME Engine, SQL Pass-Through Facility) to extract large volume data from databases.
• 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.
• Developed and executed PREDICTIVE MODELS such as LINEAR REGRESSION, LOGISTIC REGRESSION, and TIME SERIES to forecast revenue, customer retention and volumes of package transacted under the various products.
• Extensive experience in developing routine SAS Macros to create tables and graphs.
• Experience in design, writing and debugging the macro routines and applying macro variables in a SAS program.
• 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.
• Extremely energetic, detail oriented, organized team player with strong analytic abilities, communication skills, interpersonal skills, and problem-solving skills.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SPLUS,SAS/ETL, SAS /Graph, SAS Enterprise Guide, SAS/MAP, SAS BI, SAS DI Studio

Language: SAS, SQL

Operation System: Windows, UNIX

Database: MS-Access, Oracle, SQL server

Other Technologies: Microsoft Office (Word, Excel, PowerPoint, Outlook), JIRA

PROFESSIONAL EXPERIENCE

Confidential -Jefferson City, MO

Research Data Analyst

Responsibilities:

• Provide birth listing for the client.
• Create dataset for research purposes-mainly maternal and child health data.
• Run monthly samples on Pregnancy Risk assessment.
• Generate a new dataset by modifying previous SAS code versions
• Prepare finalized Birth and Infant Death data to be loaded on cube and the Website.
• Test data in Prod and Test environment
• Link various database to create the intended dataset.
• Run bi-weekly report for National Violent Death registry.
• Work on data request such as Certificate of Need, Parents as Teachers etc.
• Work involves, Data manipulation, data management and query writing in SAS.

Confidential - Columbia, MO

Business Data Analyst

Responsibilities:

• Matched Confidential ts from Health Systems to facilitate information exchange.
• New Account creation for new users of HIE.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Facilitated annual goal creation for the entity.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs
• Created reports for online and batch applications for various servers
• Validated Social Security and Date of Birth for the matched Confidential ts.
• Updated Dashboards for Quarterly Operating Committee Review.
• Updated Usage Summary weekly
• Reviewed “as is” state for the business process and followed up with the clients to increase usage.
• Published newsletter highlighting the progress made in the quarter.
• Involved in the outreach discussion for the HIO.
• Reviewed business process to close the loopholes and/or optimize results for the benefits of the institution.

Confidential - New York, NY

SAS Programmer

Responsibilities:

• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the MEMBERS data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs
• Created reports for online and batch applications for various servers
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs
• Run reporting programs and download the results into EXCEL and build pivot tables
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements
• 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
• Attended project team meetings, worked with, Data Managers, Business Users and offshore team as appropriate
• Involved in extracting, analysing data from the data-warehouse using SAS.
• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT.
• Used ULTRA EDIT and VSS features to connect to multiple databases for comparing views and checking syntax errors for performance tuning and quality control
• Worked with Financial departments to develop required applications for performing complicated analysis
• Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for business user, preplanning and doing ad hoc joining of multiple Oracle views.
• Created and maintained the project documentation like functional and technical specifications

Confidential - Atlanta, GA

SAS Analyst

Responsibilities:

• Worked with users developing and documenting specifications and involved in developing several SAS programs based on campaign specifications.
• Customized reports using PROC SQL, PROC FREQ, and PROC MEANS for creating a preferred list of customers as per the given requirements.
• Defined new SAS Macros and modified existing macros as well as worked on pre-existing macros for data validation.
• Involved with data cleansing by analysing and eliminating duplicates and inaccurate data.
• Generated SAS/ MACROS for reusability and to minimize data processing.
• Used ODS statements to create reports in excel and html formats.
• Write out flat files according to vendor specifications and transferred then through sftp.
• Worked with SharePoint to collaborate with team members, assigning of tasks sharing of reports.