SUMMARY

• 7+ years of experience in SAS Clinical Programmer / SAS BI Application Developer as analysis, design, development, testing, and implementation of various applications like HealthCare, Consulting and Technology services, Banking, Finance and Pharmaceutical companies.
• Extensive experience in Base SAS (Macros), SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS - ODS and SAS-SQL.
• Solid knowledge in data management and processing techniques like merging, appending, concatenating, interleaving of SAS datasets and data validation.
• Strong experience in various SAS procedures like Utility Procedures, Report Procedures, Statistical Procedures.
• Good experience in using SAS functions like Date functions, Character functions and very good knowledge in using Formats and Informats with data and proc steps.
• Good command in importing and exporting complex data sets using PROC IMPORT & EXPORT.
• Experience on working with Enterprise guide.
• Excellent skills in SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS OLAP CUBE Studio, SAS BI Dashboard, SAS Management Console.
• SAS Management Console used to create the metadata libraries and also for password administration.
• Strong experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.
• Thorough experience in extracting data from data sources and sorting from various databases like Oracle, SQL Server, MS Access and DB2.
• Excellent command in producing Reports employing various SAS Procedures, strong working experience in modifying existing SAS programs and creating new SAS programs using Macros.
• Good ability to work either individually with minimal supervision or as a member of a large team and a quick learner with Strong analytical, debugging and problem solving skills.
• Converting existingSSRS reportsto SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports usingSAS Web Report Studio.

TECHNICAL SKILLS

SAS Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH.

SAS Procedures: Means, Summary, Freq, Sort, Print, Append, Import, Export, Format, Tabulate, Chart, Compare, Content, SQL, Transpose

Databases: SQL Server, MS Access, Oracle 9i/10g, DB2.

Operating Systems: Windows Family, Unix and Linux

Languages: SAS, ASP.Net, HTML, VBScript.

PROFESSIONAL EXPERIENCE

Confidential, TX

SAS Programmer

Responsibilities:

• Worked closely with Business System Analyst in gathering requirements from end users and developed report layouts.
• Understanding File Layouts required for State.
• Understanding the relationships in tables for MEDICARE and MEDICAID Claims and involved in identifying DUAL Claims.
• Extracted data from ORACLE database through SAS/ACCESS for ORACLE and extensively used PROC SQL to manipulate data and performed joins on datasets.
• Extensively used the SET, UPDATE and MERGE statements on SAS datasets to read and manipulate claims data.
• Used different SAS Functions like LENGTH, TRIM, PUT, INPUT, STRIP and COMPRESS.
• Accessed External files and created permanent SAS data sets.
• Extensively used SAS MACROS for code reusability and used different options like SYMBOLGEN, MPRINT, MLOGIC, SOURCE, SOURCE2, and SAS TRACE for debugging.
• Used SAS Array temporarily for processing group of variables within a data step.
• Analyzed data using PROC FREQ and PROC SUMMARY.
• Used ODS features for outputting SAS data into XLS, TXT and PDF formats.
• Fine tuning the code prior to moving into production and implementing the code in production.

Environment: UNIX, SAS 9.3, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS Macros, SAS ODS, ORACLE, Lync2013, MS Office.

Confidential, Baltimore, MD

SAS Programmer Analyst

Responsibilities:

• Performed statistical analysis, wrote SAS code for data management and reporting and performed validation, including testing SAS code.
• Prepared clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
• Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL .
• Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
• Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphs and statistical analyses.
• Accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.
• Downloaded data from Oracle using SQL in to SAS to be analyzed and then exported to Excel for further analysis.
• Involved in clinical trials programming of data tables and listings for reporting on safety & efficacy.
• Produced customized reports by using PROC TABULATE, REPORT and also provided descriptive statistics using PROC Means, Frequency.

Environment: SAS9.1, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, Oracle.

Confidential, Mattawan, IL

SAS programmer analyst

Responsibilities:

• Created highly accurate predictive and descriptive models using Enterprise miner based on analysis of vast amounts of data.
• Worked on ECONOMETRIC MODELS --(step-by-step approach used to derive the statistical models)
• Applied many statistical techniques like Decision trees, artificial neural net works and logistic regression.
• Used the SAS Enterprise Miner Interactive Grouping node to select the predictive variables using Information Value and calculating Weight of Evidence values used the SAS Enterprise Miner Scorecard node to build a preliminary scorecard using the appropriate scaling methodology
• Performed the reject inference techniques such as hard cut-off augmentation, parceling, and fuzzy augmentation using the SAS Enterprise Miner.
• Copied SAS datasets using PROC COPY utilities.
• Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Used SAS/Access and SAS SQL procedures to create and maintain SAS Data Sets that are extracted from DB2 and Sybase Databases.
• Modified the existing programs according to the new business rules.
• Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc.
• Ran the monthly and quarterly maintenance jobs on the mainframe.
• Documented the run instructions for two different processes in a project.
• Developed SAS programs to run the ad hoc jobs
• Developed JCL code on mainframe (MVS) for processing batch jobs.
• Used SAS technical skill to provide greater consistency in decision making by delivering standard data and analysis capabilities to more users in the organization
• Developed Macros and performed statistical analysis working with large volume of data for supporting Market Operation Department in order for acquisition of Credit Card new customers
• Uploaded and downloaded the datasets from and to UNIX platform to MVS system and PC also.
• Documented the code for one whole module, which includes the process flow, dataflow diagrams and the Meta data dictionary.
• Modified the code to reduce the processing time from 8 hrs to 3.5 hrs for a SAS job on the Mainframe.
• Written and Modified the Shell scripts, to create tar files and ftp them to the desired location
• Automated the manual process of extracting specific data from files on a Solaris box and backing the same on Mainframe.

Environment: Base SAS 9.2, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/Macros, DB2Sybase, UNIX, IBM Main Frame.

Confidential, PA

SAS Analyst

Responsibilities:

• Provided SAS programming support for pre-processing data, data analysis, data manipulation and report generation for phase I and phase II clinical trials.
• Involved in creating standard and value-added datasets as per statistical analysis plan and programming plan specifications to reflect company data standards.
• Perform additional/ad-hoc SAS programming of data listings, summary tables and statistical analysis as required for clinical team review and data management staff.
• Program standard SAS macros for validation of data listings and tables which can be used across different studies and protocols.
• Modified SAS Macro programs to generate and validate reports, tables and listings for Bio statistical and team review.
• Created ISS and ISE datasets.
• Code with SAS/Base, SAS/Access, SAS/SQL and SAS/Macros to extract, clean and validate data from database.
• Worked on Clinical Trials data like Demographic data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), ECG, ECOG, Physical, Vital Signs and Audit trials.

Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/ODS, OracleSAS/AF, SAS/ACCESS, MS Excel, Windows and UNIX

Confidential

SAS Programmer /Oracle Developer

Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
• Extensively used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listings, EXCEL and RTF reports for presenting the findings of various statistical procedures using procedures like PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS.

Environment: SAS 9.1 (BASE, STAT, GRAPH, MACRO, ETS and ODS), Oracle, PL/SQL.