Data Assistant

Divya Reddy Parapati

**************@*****.***

Experience in analysis, design, development, testing and implementation of Statistical

models.

Skills on manipulating, summarizing, analyzing and presenting data using SAS PROCS

like SQL, FREQ, MEANS, SUMMARY, REPORT, TABULATE, COMPARE,

FORMATS, IMPORT, EXPORT, APPEND, PRINT, CONTENTS, SORT and

DATASETS.

Good command in inputting complex internal data sets, using import/export wizard, Proc

Import and Export, SAS/Access, SAS/SQL to import different types of external data files

(text, csv etc.) into SAS library and export SAS data sets into different types of external data

files.

Experienced in producing Excel, Word Document, HTML and PDF formatted files using

SAS /ODS, to produce ad hoc reports for presentation and further analysis.

Expertise in BASE SAS programming, SAS/Macros programming and debugging,

experience in the skills in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH,

SAS/ACCESS, SAS/ODS.

Expertise in using SAS ODS to create HTML, RTF and PDF output files

Experience in producing external files and reports employing various SAS procedures,

like Proc Print, Proc Report, Proc Summary, ProcFreq, Proc Mean, Proc SQL.

Experience in using SAS to read, Import and Export to another data file formats,

including Delimited files.

Experience in developing SAS Procedures, Macros, and application for data updates, data

cleansing, documentation and reporting.

Performed data extraction, analysis and published results using SAS ENTERPRISE

GUIDE

Generated Listings, Reports, and Tables, Graphs and summaries for Integrated

Summaries, Good organizational, time management and multi-tasking skills

Capable of working independently while being a good team player who enjoys delivering

high quality work.

Excellent technical, interpersonal and communication skills

Technical Expertise

SAS Tools SAS 9.1, SAS 9.3, SAS 9.4 (BASE, STAT, GRAPH, SQL,

ACCESS, CONNECT, ODS)

SAS Procs Print, Means, Freq, Univariate, Correlation, SQL, Tabulate,

Summary, Format, Import, Export,

Languages: SAS, SAS/SQL, SAS/MACRO

Database: MS Access

Operating System: MS Windows XP/Vista, MS 2003 server

Other Technologies: Visio, Microsoft Office (Word, Excel, Powerpoint, Outlook)

EDUCATION

Ph.D. Sustainable Bioproducts (2010-2014) – Mississippi State University, Mississippi

M.S. Chemistry (2007-2009) - Western Illinois University, Illinois

M.Sc Organic Synthesis (2004-2006) - Osmania University, Hyderabad, India

B.S.C Major: Computer Applications & Chemistry (2000-2003) - Osmania University,

Hyderabad, India

WORK EXPERIENCE

Department of Sustainable Bioproducts, Mississippi State University, Mississippi, MS

Research Assistant, (Sustainable Energy Research Center (SERC) Project

June 2014 – Aug 2014

Pretreating bio-oil in a lab scale parr batch reactor followed by upgrading pretreated bio-

oil in a pilot scale continuous packed-bed reactor to produce hydrocarbon fuel

Analyzing products using chromatographic methods: GC, GC-MS, spectroscopic

techniques: FTIR, Thermogravimetric analysis (TGA), Detailed hydrocarbon analysis

(DHA), Simulated distillation (SIMDIS) thermal technique: Bomb calorimetry and wet

analytical techniques: Karl-Fischer titration, viscosity and pH (ASTM test methods)

Statistical experimental design, Statistical analysis performed using SAS software version

9.3

Hands on experience in performing SAS programming, data management, quality

control, and reporting for research projects

Involved with key departments to analyze areas and discuss the primary model

requirements for the project

Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC

UNIVARIATE and PROC ANOVA.

Created reports in the style format (RTF, PDF and HTML) using ODS statements

Producing Excel, RTF, HTML and PDF formatted files using SAS/ODS to produce

reports for presentation and further analysis.

Developed SAS programs and Macros to produce reports including tables, listings and

graphs summarizing descriptive and inferential statistical analysis of study result.

Excellent knowledge of SAS programming and associated features and their applications

in analyzing research data

Used SAS/ODS for generating different output formats as requested.

Converted MS-Excel files to SAS Datasets.

Strong understanding of research data and extremely hands on in data manipulations,

analysis and reporting of analysis results.

Track record of generating new ideas and solutions to data analysis

Environment: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS,

SAS/ODS, SQL, Excel

University of Wisconsin, Wisconsin, WI

Assistant Researcher (Biofuels Project) Sept 2009 - August 2010

Extract and analyze oils from various plant sources as well as convert the oils to various alkyl

esters

Purify the alkyl esters using column chromatography and analyze them by using HPLC and

GC-MS instruments and help to evaluate various physical and chemical properties of these

ester mixtures

Teaching and organizing labs for undergraduate students in organic chemistry

Idenifying the best high-yield oil seed that can be grown at Northern Wisconsin

Develop a efficient chemical catalyst that can convert vegetable oil into a high energy-

density biofuel

Use SAS to analyze data, statistical tables, produce listings and graphs for reports and

Formatted HTML, PDF and RTF reports, using SAS - output delivery system ODS

Developed complex SAS Macros to simplify SAS code and effectively reduce coding time

Report generation using many SAS proc statements and SAS/Macros

Develop SAS coding and table templates for preparing, processing and analyzing data

Generate and QC summary tables, data listings and graphs using SAS standard coding

practices

Performed statistical analysis, generate reports, listings and graphs using SAS/Base,

SAS/Macro and SAS/SQL, SAS/Report.

Effectively utilized PROC SQL, PROC FREQ and PROC MEANS for data analysis and

generating reports.

Responsible for accurate and timely data analysis and submissions

Environment: SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, Excel, HTML

Contact this candidate