Management Data
Resume:
[pic]
Mayuri Valvekar
**************@*****.***
Morrisville, NC 27560 Tel. No.608-***-****
Professional Experience
Vigdor Measurement and Evaluation LLC, NC,USA
Data Analyst April 2013 - September
2013
. Gathered the data needed for the research projects based on the
research objectives.
. Worked with very large datasets and job involved data manipulations
like merging and appending hundreds of datasets.
. Used economic and statistical modeling techniques
. Worked on large cross-sectional and panel datasets using Stata and MS
Excel.
. Wrote reports and published articles based on the research findings.
Harker Research, NC,USA
Data Analyst,
January, 2013 - February, 2013
. Statistical data analysis, database processing and market operations
. Quantitative and qualitative market research.
. Use of SPSS and SAS, MS Excel macros, pivot tables etc.
University of Wisconsin, Madison, WI, USA
Research Assistant Volunteer 2010-
2012
. Researched on revenue and price risk management strategies for dairies
across USA.
. Made an extensive use of statistical and econometric techniques like
regression and
time-series analysis and mathematical optimization models in my
research.
. Used spreadsheet modeling techniques using advanced MS-Excel analysis
tools like
pivot tables, solver and macros.
. Produced summaries and statistics using SAS.
. Used tools in R to identify outliers and perform simple statistics.
University of Wisconsin, Madison, WI, USA
Graduate Research Assistant
2008 - 2010
. Research involved developing on-farm financial risk management and
return on investment (ROI) strategies using statistical and
econometric techniques and optimization.
. Developed forecasting models for commodity prices and trading
strategies, considering futures and options prices.
. Performed Statistical and econometric data analysis on huge datasets
with more than 150,000 data points using MS-Excel, SAS/BASE, SAS/STAT
and R.
. Produced summaries and statistics using PROC MEANS, PROC SUMMARY, PROC
FREQ, PROC ANNOVA and PROC UNIVARIATE.
. Built decision tools for revenue risk management, using macros and
pivot tables in MS Excel.
. Co-authored and presented my research findings at various conferences
and meetings.
National Spot Exchange Ltd, Mumbai, India
Executive - Market Operations 2005 -
2006
. Monitored the commodity price movements on the exchange on weekly
basis.
. Developed operational procedures and workflow charts for the
warehouses and the exchange.
. Conducted qualitative and exploratory research to develop new spot
contracts using focus groups and in-depth interviews.
. Conducted quantitative data analysis using statistical tools and
econometrics.
. Was responsible was developing questionnaires for the traders as a
part of market research studies on spot contracts.
Tinna Oils and Chemicals Ltd, New Delhi, India
Trading Officer (Market Operations)
2005
. Monitored the market operations like trades, inventory and demand on a
daily basis.
. Developed strategic production and marketing plan based on forecasted
demand estimates.
. Used questionnaires and focus group methods to understand market
dynamics in edible oil sector in Maharashtra.
. Generated commodity charts and daily price reports using MS Excel.
. Conducted strategic market research (competitor analysis and market
intelligence) in the refined oil sector.
. Market share modeling using regressions and conjoint analysis in SPSS.
. Devised business expansion strategy for bio-fuel market.
. Supervised and mentored a group of four field coordinators.
ITC-IBD, Bhopal, India
Summer Intern 2004
. Performed trend analysis on sales, procurement revenues and overall
financial performance of 1600 procurement centers established by the
international business division.
. Conducted market research studies for business expansion of
procurement centers using questionnaires and in-depth interviews of
the farmers and field coordinators.
. Imputed missing data and cleaned the data obtained from surveys and
other sources.
. Used quantitative data analysis techniques like factor analysis and
regression models in SPSS to gain meaningful insights on the best
performing profiles of field coordinators.
. Trained field coordinators to disseminate crop, weather and price
information via ITC's e-choupal web-portals.
. Results of my project helped ITC in devising new selection procedure
for the field coordinators and new business expansion strategy for
the procurement centers across the state of Madhya Pradesh.
RESEARCH PUBLICATIONS, REPORTS AND ARTICLES
Publications:
. Valvekar,M, V.E Cabrera, and B.W Gould, "Identifying Cost Minimizing
Strategies for Guaranteeing Target Dairy Income over Feed Cost via Use
of the LGM-Dairy Insurance Program", Journal of Dairy Science, Volume
93, Issue 7, July 2010, Pages 3350-3357.
(http://www.sciencedirect.com/science/article/pii/S0022030210003449)
. Valvekar,M, J.P Chavas, B.W Gould and V.E Cabrera, "Revenue Risk
Management, Risk Aversion, and the Use of Livestock Gross Margin for
Dairy Cattle Insurance", 2011, Agricultural Systems, Volume 104, Issue
9, November 2011, Pages 671-678.
(http://www.sciencedirect.com/science/article/pii/S0308521X11001235)
. Valvekar, M., Cabrera, V.E., Gould, B. 2009. Analysis of program
performance and cost under alternative policy configurations and
market conditions. Journal of Dairy Science 92, American Dairy Science
Association Annual Meeting, Montreal, Cananda, July 2009.
http://dairymgt.info/publications/LGM.pdf
. Jacob Vigdor,Gretchen Calcagni and Mayuri Valvekar, September 2013,
Immigration and Revival of American Cities.
http://www.renewoureconomy.org/issues/american-cities/
EDUCATION AND TRAINING
University of Wisconsin, Madison, WI, USA
Master of Science, Dairy management and Agri-business Economics
National Institute of Agricultural Marketing, Jaipur, India
Post-Graduate Diploma in Agri-business Management
TECHNICAL EXPERTISE, SOFTWARES AND APPLICATIONS
. Certified SAS Base Programmer ( December, 2012)
. Proficient in MS Office suite
. Proficient in EndNote bibliographic software
. Proficient in using advanced data analysis tools in MS-Excel and
experienced in statistical programming using STATA, SAS/BASE,
SAS/STAT, R and SPSS.
. Experienced in using @RISK and Crystal Ball simulation softwares.
. Proficient in Visual analytics software, TABLEAU.
REFERENCES AVAILABLE ON REQUEST
Contact this candidate