Contact

Mobile:(405) 564 4291

Email: pradnya18@gmail.com

mylinkedinhttp://www.linkedin.com/in/pradnyachavan/

Advertisements
Quote

Work Experience

Operation Support Analyst II Verisk Analytics March 2014-Present
  • Developed market profit sharing statistical model for each line of business on SAS IBM Mainframe.
  • Successfully implemented interactive User interface for viewing customer mapping at different levels.
  • Performed pricing analysis by co-coordinating with sales department.
  • Developed SAS macros, Excel Macros, SQL procedure to reduce regular manual tasks
  • Performed monthly revenue analysis and forecasted annual revenue growth.

ISO Risk Analyzer®: set of SAS predictive models to predict insurance risk.

  • Undertook ISO Risk Analyzer® to perform program restructuring  and analysis
  • Assisted while making program compatible with SAS Grid by reducing execution time by 95%.
  • Developed 1st version of official detailed process documentation of ISO Risk Analyzer®-
  • Performed quality checks on results by developing SAS Macros.

 

Data analytics Intern Airline reporting corporation June 2013-August 2013
  • Performed text mining and statistical analysis on large airline datasets-Bigdata
  • Strategically developed queries to retrieve data as quick as possible.
  • Developed data segmentation strategies to increase reporting tool speed by 60%
  • Led a team of 12 interns from different departments for a internship group project on business driving factors of social media
  • Single handedly worked on out of assigned department project of fraud analysis
  • Developed methods to identify to perform customer profiling and identify air fare trends and patterns.
  • Performed product related research and case analysis to develop business case scenarios and models.

 

Database administrator Oklahoma State University November 2012 – May 2013
  • Reduced no. of people required for manual work by 66%
  • Single handedly administered, managed and maintained MS Access databases and SharePoint
  • Edited master pages, page layouts and forms to make them more user-friendly.
  • Implemented automated reporting by developing SQL procedures integrated with SharePoint.
  • Analyzed data and built customized reports.

 

Data Analyst Eclerx Services Ltd September 2011- June 2012
  • Improved VBA web crawler’s performance by 78% to extract data from internet websites.
  • Successfully implemented several data cleaning programs integrated with statistical analysis
  • Developed SQL procedures to reduce overall manual queries writing process time.
  • Performed monthly product competition analysis and product performance on internet report.
  • Improved client online product sale by 1.7%.
  • Designed key strategies and quality check points to improve over all reporting process
  • Received appreciation from client for beneficial online sale consulting and making reporting process easier.
  • Received spot reward for excellent performance as a data analyst after 3 months of joining.

 

work exp

Projects

Flight Destination Analysis

 

SAS, Excel and Tableau Fall 2013
Developed predictive model to determine profitable destination from a particular origin. This poster was selected in SAS Conference 2013 held at Orlando, FL, USA

 

Profit Drivers of a  staffing company

 

SAS,JMP, Excel and Tableau Fall 2012
Developed predictive model to determine profitable customer for a staffing company

 

Project Atherton

 

SQL server, Excel and tableau Spring 2012
Developed an online reservation system along with its administrative features for the hotel Atherton. Our objective was to create back-end on sql server for database management and front end in asp.net for website

 

projects

Gallery

Technical Competencies

technical

  • Programming Languages………
C , C++, Base SAS, VBA, Advance SAS
  • Business Intelligence……………
SPSS IBM Modeler, Rapid-miner, SAS enterprise miner/Enterprise Guide 9.3, JMP 10, MS Excel, Tableau, MS Excel, Sales Force
  • Operating Systems & platform
Microsoft Windows 98/2000/XP/2010/7,  IBM Mainframe
  • Database Management……………
SQL server, Teradata 12, MS Access, SAS Grid
Aside

Education

Master of Science in Management of Information systems Oklahoma State University, Main Campus, OK, USA Fall 2012-Fall 2013
 

Course work: Business analytics, data mining, advance database management, project management, enterprise resource planning, advance systems analysis and design, business intelligence

 

Bachelor of Engineering in Computer Engineering University Of Mumbai, Mumbai, India Fall 2006-Fall 2011
 

Courses: Programming languages, Operating systems, Database management, Software engineering, Advance micro-processor, computer architecture, analysis of algorithms

education

Quote

EXTRA-CURRICULAR ACTIVITIES

  • Presented Analytics poster on Flight Destinations Analysis at SAS Analytics conference | Oct- 2013
  • Department representative of graduate professional student association | Spring-2013
  • Member of Education Committee (Social) of Kusum Memorial Social Program | Year -2006
  • Volunteered for during Thalassaemia awareness and Blood donation drive. | Year -2010
  • Volunteered for Lead Foundation, Mumbai, India |  Year -2011

exa