SUMMARY:

• Experienced SAS Analyst with 6 years of experience in SAS Programming, Merging SAS Datasets, and Developing SAS procedures, Macros, Preparing Data, Producing Reports, SAS Formats, SAS Functions, SAS Informats, Storing and Managing Data in SAS Files.
• Extensive experience in SAS/Base, SAS/Stat, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Graph, SAS/Connect, SAS/Access, SAS/EG.
• Experienced with Proc Sql, Proc Datasets, Proc Format, Proc Print, Proc Append, Proc Tabulate, Proc Gplot, Proc Gchart, Proc Compare, Proc Import, Proc Export, Proc Transpose, SAS/Stat procedures such as Proc Freq, Proc Means etc.
• Experience in Data extraction from several databases including Oracle, SQL Server and other external files using SAS/Access, SAS/SQL pass through facility, Libname statements, and Proc Import procedure and also via SAS Data steps.
• Good experience in Proc SQL joins and Proc SQL set operators to combine tables horizontally and vertically and proficient in Integration of various Data Sources like MS-Access, Flat and CSV Files.
• Skilled in data manipulation and generating customized reports with SAS data steps and procedures and have experience in handling large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Extensive experience in SAS/Report generating procedures like Proc Summary, Proc Freq, Proc Means, Proc Univariate, Proc Transpose, Proc Format, Proc Report, Proc Tabulate, Data Null etc.
• Experienced in producing RTF, Excel, PDF, HTML formatted files using SAS ODS facility.
• Expertise in generating Graphs by employing SAS procedures like Proc Gplot, Proc Gchart.
• Proficient in writing, editing and debugging code using SAS/Base and SAS/Macro.
• Proficient in creating new Macros and Updating existing Macros for daily, weekly and Monthly report.
• Good skills in statistical parametric analysis methods such as Correlation, Regression, Analysis of variance and general linear models using SAS/Stat procedures such as Proc ANOVA, Proc GLM, Proc CORR, and Proc REG.
• Experienced in building BI/EIS applications using OLAP tools.
• Good understanding of study related Statistical Analysis Plan SAP and produced Tables, Listings and Graphs based on the specifications in SAP.
• Extensively worked with Business Partners, Statisticians, and key stakeholders to provide SAS programming for analyzing data as well as generating reports, tables and listings.
• Good ability to work on multiple tasks and strong interpersonal, analytical, presentation skills, communication and problem solving skills and work independently as well as in a team.

TECHNICAL SKILLS:

• SAS Tools SAS 9.3/9.2/9.1.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS,
• SAS/STAT, SAS/ODS, SAS/CONNECT, SAS/GRAPH,
• SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO,
• SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY
• PORTAL Databases Oracle 10g/11g, MS SQL Server 2008/2012, Teradata 12/13, DB2,
• MS Access, Informix
• GUI Tools MS Office, MS Project, MS Visio Commercial Tools Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion,
• ERWin, Roscoe, RCS
• Operating System WINDOWS XP/Vista/7/8, UNIX Reporting tools Crystal Report, Hyperion, MS SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Confidential

SAS Data Analyst

• Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS datasets for Analysis using SAS/Stat procedures.
• Wrote various queries using SAS/Base, SAS/SQL and SAS/Macro for creating reports according to the Users requirement.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Defined and documented business logic and system processes.
• Performed programming of data listings using SAS. Converted MS-Word documents and Excel tables into SAS datasets.
• Involved in development and enhancements of SAS Programs.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance ANOVA using Proc REG, Proc CORR, Proc GLM, Proc ANOVA.
• Successfully generated permanent and temporary SAS datasets.
• Involved in writing code using Base SAS and SAS/Macros to extract clean and validate data from oracle tables.
• Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficiency to the company as a whole and achieved these tasks by serving as member in data management team.
• Created SAS Customized Reports using the Data Null technique, Proc report and proc tabulate.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Developed routine SAS Macros to create tables, graphs and listings.
• Created SAS Macros for data cleaning and Reporting and to support routing processing.
• Extensively used the SAS/ Macro facility for automation process and to write weekly and monthly reports.
• Produced RTF, PDF and HTML formatted files using SAS/ODS to produce ADHOC reports for presentation and further analysis.

Project Environment: SAS 9.3, SAS/BASE, SAS/SQL, SAS/ODS, SAS/Graph, SAS/Macro, SAS/Access, SAS/Stat, SAS/Add-in, SAS/EG, Oracle database 11g, SQL server 2012, MS Excel, MS Access etc.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Accessed Analytics Data Mart using SAS/Access facility, SAS SQL procedures
• Reviewed company's churn reports and churn operations procedures for business understanding and reducing ADHOC report delivery time
• Extensively used SAS/Base procedures and functions for data manipulation and creating summaries data values
• Maintained and enhanced existing SAS reporting procedures for churn reporting and marketing campaigns
• Involved in creating mail list for customer satisfaction survey and follow up surveys on retention initiatives
• Acted as liaison between various Survey/Research providers to meet specific data needs and providing quick support in the form of data appends and Ad hoc reports.
• Created standalone Macros to check data quality and generate summary statistics for score datasets
• Performed Data de-duplication on working with several millions of records and data points.
• Used SAS Enterprise Guide for SAS for data access and Ad hoc reporting.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Worked with large customer response and sales datasets and generated graphs using SAS Report and SAS /GRAPH.
• Formatted data using SAS defined and user defined formats using Proc Format. Scheduling daily, weekly and monthly reports using SAS/Macros.

Project Environment: SAS 9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Enterprise Guide, Teradata 13, Oracle 11g, MS Office.

Confidential

SAS Data Analyst

Responsibilities:

• Extracted, transformed and loaded ETL datasets with basic modeling variables for each segment type using Proc Import and SQL queries, imported data from Oracle database into SAS files.
• Extracted data from the Oracle database using SAS/Base, SAS/Access, and wrote SQL queries using Proc SQL procedures and created SAS datasets.
• Involved in data manipulations and stored the updated data into corresponding data marts in Oracle warehouse.
• Acquired raw data from Oracle tables and loaded the data into SAS datasets for further analysis and reporting.
• Manipulated and updated the tables as per specifications.
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using Proc Freq, Proc Comp, Proc Univariate, and Macros in SAS.
• Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank.
• Maintained consistency of SAS variables formats and sorted various datasets using Proc Sort and merged them using Merge
• Used regression techniques ANOVA, CORR, Proc Means and Proc Freq to analyze the data.
• Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.

Project Environment: SAS 9.3, SAS/Base, SAS/Connect, SAS/ODS, SAS/Stat, SAS/SQL, SAS/Graph, SAS/Access, Oracle 11g.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Worked extensively with Health care data hospital, lab and physician , which includes various claims, membership details and demographics of the members.
• Built an analytical data mart for the predictive analysis team for predicting future utilization measures.
• Coded, modified and automated existing programs writing Macros for improving efficiency.
• Created reports based on the claims Medical and Pharmacy pulled using CPT, ICD-9 and NDC codes for various Diseases.
• Used procedures like Proc Import for getting data into SAS from different formatted files like Excel, CSV file, .txt files
• Presented statistical results with the help of pie diagrams and bar graphs using SAS/Stat.
• Extensively used SAS/Macros, Proc SQL, Proc Transpose, Arrays and Microsoft Excel.
• Worked on creating Membership files writing a logic that brings in only continuously enrolled members.
• Good knowledge on Claims processing forms such as CMS-1500 and CMS-1450 UB-04 .
• Extracted data from various databases DB2, Oracle into SAS using SQL pass-through facility for creating various reports required based on the requirements.
• Coded for Metabolic-Syndrome project for predictive analysis team, where members with different risk factors of the disease were identified with their respective Diagnosis, Procedure and NDC codes.
• Worked with huge data for pre-diabetes project, where based on past data future occurrence of the diabetes is predicted.
• Validated a pre-sales package created by another SAS programmer.
• Ran some reports for compliance rates of the members with particular rules given by the Business user.
• Leveraging the exciting codes that can be used in processing, developing, maintaining and analyzing data more efficiently
• Produced statistical reports for various business needs and expertise in data preparations, data cleaning and analysis.
• Worked on the post campaign response reports along with other programmer.
• Created summary tables and listed outputs.
• Worked with presentation and reporting procedures like Format, Report, Print, Sort

Project Environment: SAS 9.2, SAS/Macros, SAS/Base, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Graph, SAS Enterprise Guide, Windows, Oracle 11g, MS Office and DB2.

Confidential

SAS Programmer/SAS Data Analyst

Responsibilities:

• Created new Macros and implemented them in SAS programs to produce the reports.
• Converted Oracle data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into Oracle tables using SAS Dbload procedure.
• Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS datasets for Analysis using SAS/Stat procedures.
• Performed quality check and validation of data as well as Report.
• Wrote SAS and SQL code for querying data from large datasets and extracted data from Oracle DB.
• Used Dynamic Libname, Proc SQL, Proc Sort, Proc Export, Proc Compare, Proc Import, Proc Append, Proc Report And Proc Format.
• Performed basic SAS analysis on existing customer's data, and database segmentation using Proc Means, Freq, and Summary and Tabulate.
• Developed reports using Proc Report, Proc Tabulate and Data Null for analysis.
• Work with the model reviewers to review business needs and strategies and assess the implications to the information/data architecture.
• Utilized SAS Enterprise Guide for Data Management and increased data consistency that enabled data-driven decisions
• Performed Data de-duplication on working with several millions of records and data points.
• Involved in development and enhancement of SAS programs.
• Performed data step manipulations for data quality assurance/validation of table, listing and summaries.
• Formatted data using SAS defined and user defined formats using Proc Format. Scheduling daily, weekly and monthly reports using SAS/Macros.

Project Environment: SAS 9.2, SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Access, SAS/Stat, SAS/ODS, SAS/EG MS Excel, MS Access, Windows XP/07, SQL Server 2008, Oracle 11g.

Confidential

SAS Programmer/Analyst

• Responsible for SAS programming for statistical analysis, documentation, and reporting.
• Designed statistical summary tables, graphs, and patient data lists.
• Developed SAS datasets for the drugs under development.
• Created Randomization Numbers by using Ranuni Function.
• Wrote SAS programs using Macros for developing a concise and reusable code.
• Generated graphs using SAS/Graph and SAS Graphics Editor.
• Documentation of design, code and reports for handing over the project
• Created reports using SAS/ODS
• Designed flowcharts indicating the input data and the techniques that would be used to get the desired output.
• Responsible to investigate data discrepancies and make corrections in the process of data checking and cleaning Convert data from outside sources into formats used in-house e.g., ASCII, Oracle or Excel into SAS .
• Interacted with data management personnel as necessary to ensure that datasets are in usable format and lock the datasets
• Worked with clinicians in study design and results interpretation.
• Serve as a liaison between Biostatisticians, researchers and clinical trial managers.
• Worked as a project coordinator to provide critical solutions in various projects and follow up with project managers on budget needs.
• Participated and supported different objectives through daily meetings and weekly introspect initiatives.