PROFESSIONAL SUMMARY

• Certified SAS programmer wif over 7 years of experience in analysis, design, development, and validating SAS applications.
• Extensive experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS.
• Strong experience in coding using SQL, SAS Procedures/Functions, SAS macros.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
• Performed PROC SQL joins and worked wif PROC SQL set operators to combine tables horizontally and vertically.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS - EXCEL using ODS (output Delivery System).
• Good analytical skills pertaining understanding a business domain coupled wif excellent teamwork and strong communication skills.
• Proven skills in ad-hoc reporting and coding utilizing SAS.
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS MACRO to improve ease and speed of modifications as well as consistency of results.
• Excellent organizational, teamwork, presentation, problem solving, decision making and interpersonal skills.

TECHNICAL SKILLS:

SAS tools: SAS/BASE, SAS/GRAPH, SAS/ODS, SAS/MACROSSAS/STAT, SAS/SQL, SAS/ACCESSSAS/CONNECT, SAS/REPORTS, SAS/EBI, PL/SQL

SAS Procedures: Print, Freq, Sort, Means, Univariate, Report, Correlation, SQLTranspose, Import, Export, Summary, Format.

Database: SQL e Sybase IQ, Oracle, Teradata

Operating Systems: Windows XP, MS DOS, UNIX

Other skills: MS Office tools like MS Access, MS word, MS PowerPointMS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

SAS Analyst/Programmer

Responsibilities:

• Develop and implement SAS jobs in UNIX environment to generate required reports for the business through SAS/BASE.
• Independently handled responsibilities for extracting internal/external data, data cleaning, and validation, analysis and report generation.
• Generated Weekly, Monthly and yearly health care data reports
• Extensively utilized SAS/SQL and SAS/MACRO.
• Support multiple projects simultaneously and adhere to the software development lifecycle (SDLC), operational procedures and development and security standards by following the required processes.
• Formulated procedures for data extraction, transformation and integration of Pharmacy Claims data.
• Create and modify the SAS formats for sending and receiving Patient claims files of the available extracts to third party developers.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modification as well as consistency of results.
• Perform transformations like Merge, Sort and Update to get the data in required format.
• Develop reports and custom analysis using SAS, SQL, Excel and other tools based on specifications provided by the client or the client analytical lead.
• Modify the existing the korn shell scripts to incorporate the upgraded codes and jobs for ensuring appropriate flow of data across the various layers of Enterprise Data Warehouse.
• Involved in project review meetings wif respective Business SMEs.

Environment: UNIX, SAS 9.2 (BASE, SQL, MACROS), Windows.

Confidential, Manchester, CT

SAS Programmer /Analyst

Responsibilities:

• Developed, tested and maintained daily/monthly/quarterly report packages for quantitative data analysis wif health care, biometric and survey data.
• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Develop SAS code and validate data of different portfolios.
• Generate Reports in user required format by using ODS and PROC Report.
• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps.
• Created HTML outputs wif table of contents using ODS HTML.
• Used SAS PROC SQL Pass through Facility to work wif Teradata database.
• Analyzed and implemented the code and table changes to improve performance and enhance data quality.
• Created and revised the common macros.
• Reading data from different sources like .csv, excel, tab delimited files.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Compare the source data wif historical data to get some statistical analysis.
• Extensively used procedures such as PROC APPEND PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.

Environment: Teradata, SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS.

Confidential, Indianapolis, IN

SAS Programmer

Responsibilities:

• Accessed multiple databases using SAS and provided ongoing reporting dat supported information-based decision making, measured the execution of company strategy, and identified opportunities for improving existing processes.
• Coordinated wif technical teams for research and evaluation of healthcare and operational problems.
• Developed and designed SAS Programs / Macros to access and analyze financial data.
• Generated Statistical analysis files, tables, listings, and graphs.
• Extracted data from Oracle using SQL Pass through facility and generated reports.
• Involved in writing code using Base SAS & SAS/Macros to extract data from oracle tables. Worked wif statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.
• Met regularly wif Support Services management and analysts to determine, interpret and program solutions to the information needs of the branches and Contact Center.
• UsingSAS/SQL for extract, transfer and load ("ETL") methodology and processes
• Developed reports according to SOP’s by using PROC TABULATE, Proc REPORT, Proc SUMMARY, Proc SQL and also provided descriptive statistics using PROC Means, Proc Freq.
• Documented policies and procedures required for supporting system enhancements.
• Quality control and assurance including running datasets/files through programs.

Environment: Base SAS, SAS/Macro, SAS/SQL, SAS/Connect, SAS/Graph, SAS/Access, SAS/Stat, Oracle.

Confidential

SAS programmer

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems wif the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analysis.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000, Oracle.