MAYANK NAUTIYAL
Apt ***
***************@*****.*** Raleigh, NC 27606
PROFESSIONAL OVERVIEW
Performance-driven, insightful SAS Certified Base Programmer seeking an
opportunity in Statistical Analysis, Quantitative modeling and Programming
. Quantitative Skills: Model Development and Testing, SAS programming
experience of 2+ years
. Management Skills: Project Management, Documentation and Reporting,
Leadership and Group skills
EDUCATION
Master of Science in Biological and Agricultural Engineering (GPA:
3.09/4.0)
North Carolina State University, Raleigh, NC
Expected Aug 10
Relevant Courses:
Applied Least Squares Statistics for Biological Sciences I
Statistics for Biological Sciences Watershed Monitoring and Assessment
II
Hydrologic/Water Quality Modeling Programming in FORTRAN and C
Bachelor of Technology in Agricultural Engineering (GPA: 7.30/10.00)
G.B. Pant University of Agriculture and Technology (G.B.P.U.A.T),
Pantnagar, India 2004-2008
CERTIFICATES
. SAS Certified Base Programmer for SAS 9 Credential
. Design and Analysis of Environmental Systems: Watershed Assessment and
Restoration
PROFESSIONAL EXPERIENCE
Department of Biological and Agricultural Engineering, NCSU
Research Assistant
Municipality, Cary, NC
Jan 09-Present
. Prepared new datasets from raw dataset files using PROC SQL and modified
existing datasets using Set, Merge, Sort, Update, Format, and various SAS
Functions
. Used PROC REG, GLM and MIXED to compare different treatments and
developed illustrative graphs using Proc Gchart, Boxplot and Gbarline
. Devised a season dependent algorithm to define the amount of irrigation
water use and achieved 14% water savings
Municipality, Cary, NC
Aug 08-Dec 09
. Designed and implemented data analysis and worked with extensively large
datasets
. Designed statistical summary tables, graphs and customer data listings
. Extensively used Data _Null_, Univariate, Summary, Means, Freq, and
Gchart procedures
Teaching Assistant
Aug 08-Dec 08
. Course: Introductory Geomatics [GIS]
. Aided the course instructor in laboratory and field exercises
International Tractors Limited, Punjab, India
Industrial Trainee
Jun 07-Aug 07
. Analyzed consumer profile, purchase drivers, and usage patterns of
tractors
. Conducted a survey to identify potential customers and gave
recommendations for improving the product sales in India
PROJECTS
Field Application of the Bioremediation Technology
Dec 07-May 08
. Installed a biofilter and data acquisition system to determine the
efficiency of biomaterials for bioremediation of agricultural chemicals
. Performed data validation using PROC FORMAT and TRANSPOSE
Effect of Air Pollution on Human Mortality
Aug 10-Dec 10
. Worked with a large demographic dataset and investigated the relationship
between mortality rates in major metropolitan areas and air pollution
. Performed detailed regression diagnostics and conducted stepwise
regression for model validation.
COMPUTER SKILLS
Statistical Packages : SAS (SQL, MACROS, STAT, GRAPH), JMP, R, Microsoft
Excel
Operating Systems : Windows 98/2000/XP/Vista, Mac OS X
Languages : C, C++, FORTRAN77, HTML
ACTIVITIES
. Member of American Society of Agricultural and Biological Engineers
(ASABE)
. Presented a paper at international conference of ASABE - 2010
. Delivered a workshop - Water wise Landscaping organized by Town of Cary
. Captain of the University Squash team at G.B.P.U.A.T