Developer Sql Server

________________________________________

AAYUSH GUPTA

________________________________________

*** ******* **** **, *******, WI - 53717

Email:*************@*****.*** Contact: 405-***-****

http://www.linkedin.com/in/aayush007

________________________________________

EDUCATION

________________________________________

Oklahoma State University Aug 2010 – May 2012

Master of Science in Management Information Systems 3.4 /4.0

Hindustan Institute of Technology, India Aug 2006 - May 2010

Bachelor of Engineering in Information Technology 3.6/4.0

________________________________________

CERTIFICATION

________________________________________

• SAS Certified Base Programmer for SAS 9

• SAS OSU Data Mining Certificate

• JMP Data Exploration from SAS Institute.

• SAS Business Data Mining Certificate

• J2SE, J2EE from Aptech Ltd.(India)

• Future Certification: SAS Predictive Modeling Certification for Enterprise Miner

________________________________________

PROFESSIONAL EXPERIENCE

________________________________________

Oklahoma State University Jan 2011 – May 2012

Analyst

• Developing website for the department and using Google analytics for further improvement.

• Analyzed the impact of FTTH Broadband on local business based on census data. Performed data cleaning and transformation technique with various tests and modeling techniques.

• Used Cross Tab, Chi-Square Test & Correlation Coefficient, etc. for in-depth analysis.

• Created SAS datasets using join, update, insert, and delete data from various tables. Statistical analysis includes calculation of one-way and multi-way frequencies and table analysis using Proc Freq, Proc Means.

• Reporting: Extensive use of Proc Tabulate, Proc Print and output the reports via ODS HTML to website and Proc Tabulate to create analysis tables.

• Provided summarized SAS datasets to UI team to generate dynamic graphs.

• Used SAS Macros, PROC SQL to extract, sort & match test accounts.

Multi-Resort Company Jan 2012 – May 2012

Predictive Modeler

• Developed a predictive model for a premier multi-resort company to predict the multiproduct customers.

• Performed data cleaning, data manipulation and data transformation on a huge dataset using Base SAS and SAS Enterprise Guide 5.1.

• Built Models like Regression, Neural Network and Decision Trees using SAS Enterprise Miner 6.1.

• Used Model Comparison nodes to find the best model by looking onto ROC Charts.

• Achieved Cumulative Lift of 1.54%, Low Misclassification Rate discovered useful patterns to identify key driver for being a multiproduct customer.

Online Ordering System (Oklahoma state) Aug 2011 – Dec 2011

Software Developer

• Developed an Online Order Processing for Bio-Chem. department system.

Front end in .Net

Backend Using SQL Server

http://courses.msis.okstate.edu/fall2011/msis5643/team13/

Path InfoTech, India June 2009 – Aug 2009

Junior Developer

• Developed software Corporate Training Management System which help companies, institutions, universities & school to manage education and training system right from the pre-registration to final reports and assessment.

Technology: JSP, Struts, Oracle 10 g, Jdeveloper.

CSPL, India Dec 2008 – Feb 2009

Junior Developer

• Developed a portal which would help job seeking applicants to get in touch with companies looking for respective profiles. The portal was meant to act as a mediator between the candidates and prospective industries

Technology: JSP, Action Servlets, Oracle, Web logic.

Brain Technosys Pvt. Ltd, India June 2008 – Aug 2008

Web Developer

• Created an website of hotel Khans deli: - http://www.kahnsdeli.com/

________________________________________

TECHNICAL PROFICIENCIES

________________________________________

• SAS Applications: Base SAS 9.2, SAS Enterprise Guide, Sas Enterprise Miner

• DBMS: Oracle 10g XE, SQL Server, My SQL, MS Access

• SAS Tools: SASV9, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS, SAS/PROC REPORT.

• Web Technologies: HTML, DHTML, Java Script,JSP,Asp.Net

• Computer Languages: Java, C, C++

• Applications: JMP,IBM SPSS Modeler,CART,Rapid Miner, Micro Strategy, Tableau,Visio, Expression web, Macromedia Flash, Corel draw CS3,Adobe Suite, Jdeveloper 10.1.3, Web Logic,Dreamweaver CS3, Microsoft Office Suite .

________________________________________

ACADEMIC AND PROFESSIONAL ACHIEVEMENTS

________________________________________

• Attended Sas Analytics Conference 2011.

• Unpublished paper for predicting Grain yield.

• PGA-U (Play Golf America University) 8-Week Non-Credit Course, Oklahoma State University.

Contact this candidate