Data Professional Experience

Shashi R

ac17rf@r.postjobfree.com

Summary:

SAS programmer with 9+ years of experience in analysis, design, development, and validating the applications.

Experience in proficient use of procedures like proc freq, proc means, proc report, proc contents, proc export, and proc print.

Expertise in storing and managing data in SAS files, merging SAS data sets, using ARRAYS and MACROS, SAS procedures (PROCs), PROC SQL, SAS Formats and in-formats

Experience in using various MS office tools for analyzing, arranging and presenting data

Extensive experience in preparation of reports, tables, listings and graphs

Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.

Using SAS Enterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, Summarization, statistical analysis and finally generates summarization SAS datasets.

Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts

Extensive experience in processing large datasets with millions of records for data transformation including data cleaning, data scrubbing, data profiling and applying business logic rules to incoming data.

Excellent programming skills in SQL and understanding of data definition principles, joining data sets, data manipulation and sub setting using PROC SQL.

Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.

Experience in Data Cleansing, Data Archival, ad-hoc reporting and coding utilizing SAS on UNIX and Windows environments.

Technical Skills:

Hardware

Pentium PCs

Operating System

Windows 95/98/2000/XP

Programming Languages

SQL, BASE & Advanced SAS, Unix

Tools

MS Excel,Power Point

Databases

MS –Access, Teradata

Other Utilities

WS_FTP32,WPS,window SAS, SAS Enterprise Guide

Certifications:

Base SAS certification

Professional Experience:

Company: Abbott Labs, Abbott Park, IL July 2015- Present

Job Title: Lead.SAS Programmer Analyst

Responsibilities:

Responsible for data collection, management and manipulation of datasets.

Provided statistical and analytical support to Consumer Economics, Planned and performed load research studies and analysis.

Prepared statistical summaries and reports on customer load usage surveys for use in regulatory hearings.

Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses.

Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.

Maintained database, accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.

Also identified problems with 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.

Supported the research staff for technical and programming help. Worked with Bio statistician to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM, TTEST.

Involved in analytical programming of data tables and listings for reporting on product performance.

Job Title: Sr.SAS Data Analyst Mar 2013- July 2015

Responsibilities:

Worked on in-house project handling the responsibilities of SAS programming and QA analysis/testing

Performed data and QA analysis, tested/completed the deliverables and presented the analyzed/output data based on the requirements understanding of business process, the data and the user.

Transformed the statistical data in various formats (excel, access) into SAS data sheets. Provided statistical programming expertise in the production of QA analyses, tabulations, reports and listings.

Derived from specifications of survey regarding editing, coding, reports, debugging etc

Accompanied in various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing.

Developed programs for cleaning, transforming and modifying the data daily.

Updated documentation during the life cycle of QA testing like design processes, business specs, comments in the code, record the issues/problems and record the inputs/outputs

Actively participated in internal QA peer reviews and managing the project folders on project shared drive and SharePoint site

Used PROC compare to compare the data before and after editing

Developed various SAS reports for project and involved in code reviews for all the developed reports

Job Title: SAS Programmer Nov 2011- Mar 2013

Responsibilities:

Imported data from external sources in various formats into SAS datasets.

Wrote edit checks for monitoring raw data for ongoing studies, identifying data issues and reporting back to data management team.

Involved in generating and validating summary Tables, Data Listings for internal data reviews.

Reviewed Statistical Analysis Plan and developed analysis dataset specifications.

Performed qualitative validation by reviewing titles, footnotes, indentations, page breaks and eyeball for consistency and also performed quantitative validation of results using PROC COMPARE

Responsible for proper documentation and validation of programs/macros/procedures to produce the standardized data displays.

Accessed various databases to gather data, performed a table lookup and translated data values for meaning and readability.

Involved in gathering requirements from client and prepared an understanding document to create the analysis/technical document.

Job Title: SAS Programmer May 2008- Oct 2011

Generate reports, graphs and charts to enable the leadership team to visualize goals and objectives.

Develop and drive decisional revenue management solutions

Consulted with clients to determine requirements.

Create SAS Macros to help simplify and streamline repetitious and routine operations

Used PROC SUMMARY and PROC REPORT to document the results and presented them using MS PowerPoint.

Produced weekly and monthly-customized reports by using PROC REPORT, DATA _NULL_ and PROC REPORT.

Prolifically generated SQL queries for the reports.

Maintained the daily error log for cleaning the data.

Contact this candidate