Professional-Experience
1) Research:
Published 1 article in Economic Times on Macro Economics in India , and 2 Articles on [login to view URL] .
Reports on country analysis, PESTLE analysis of countries in the form of research reports.
Developed extensive scorecards for Political Risk Analysis of Countries and Macro Economic Investment of Countries using PEST framework.
Written research products like What are the top 15 Macro Economic Trends for 2008.
2) Analytics
Worked on Time Series Forecasting using SPSS Trends, SAS ETS and Excel VBA applications including solver add-in for optimized exponential smoothening for forecasts.
Creation of Regression Modules and Framework for Forecasting Automotive Sales in Europe.
Worked extensively and intensively on data driven analytics. Proven record on starting up analytics as a domain (for WNS) , leading teams and transitioning projects (onsite from US and offsite from Europe) across international geographies.
Built multiple business development activities including RFI,RFP Response, Proposals,Kick Off calls,client visits -the whole value chain of analytics projects from beginning to invoicing.
Technical experience -
VBA Dashboards (Excel and Access) ,
SAS ETS (Time Series Models),
SAS STAT (Logistic Models,Linear Regression Models),
SPSS (Data Manipulation,Factor Analysis),
KXEN (Model building),
SAS BASE (Data and Text Mining) ,
SAS CONNECT
SPSS TRENDS (Building Time Series ARIMA Models)-
a seperate add on module to SPSS , lesser expensive than SAS
Some Exposure to Oracle SQL,
PL SQL,
Decision Trees ,
SPSS Reproting,
Cognos Reports ,
Crystal Reports,
Business Objects,
SAS Enterprise,
Unix.
Project Management for all the above domains and exposorue to JAVA, ASP Projects.
3) Websites-
Drupal
Joomla
Wordpress
Online Analytics
E procurement and
Marketing Scoring and Invetory Optimization Projects
Ajay Ohri’s Specialties:
Developing processes for nascent analytics teams,Data Driven analytics,Offshoring and Transitioning Data Driven Analytics, SAS,SPSS,Economics Research,Online Startups,Wordpress websites,Online Analytics,Alumni Associations,Relationship Management,Drupal,joomla,VBA,Time Series Models,Regression Models,Scoring,Optimization, Green Belt Quality, Process Management