Statistician

AKANKSHA AGARWAL

*** ******* ******, *******, ******

Email: ***.********@*****.*** Phone: 416-***-****

PROFILE: More than three years’ experience as a dedicated and highly motivated Research Officer and Statistical Advisor in Government setting. Have proven ability to develop research documents based on complex quantitative analysis for important policy decisions. Possess precise analytical and statistical ability to make the numbers meaningful. Looking forward to start a new career path in Canada with an interesting opportunity to unleash the acquired skills and experience towards a worthy output

Technical Skills

Expert in conducting quantitative statistical analysis using SPSS, Stata, Minitab, Statistica.

Experienced in regression modelling and other statistical analysis in R and considerate experience of conducting statistical analysis in SAS and Matlab.

Experience in handling large databases in SQL. Have developed a meaningful data retriever from Metadata using SQL and VB.

Expert in managing projects in MS Access and MS Excel in varied subject matters and different kind of datasets.

Working knowledge of Qlikview

Knowledge of Big data, Hadoop, MS Visio, Google Analytics and Tableau.

Key Achievements

Best presentation “what factors drive the sale of online deals” that aimed at the analysis of marketing and sales strategy of various online retailers at Indian Institute of Management, Lucknow.

Developed and supervised survey methodology for family living survey including questionnaire design, sample size estimation and preparation of tabulation plans.

Reviewed the financial impact of delay in updating the base of consumer price index on Government of India, leading to an important policy decision of launching the new base with curtailed deadlines.

Best Policy evaluation Award for “Bachat Lamp” policy of India at Administrative Staff College of India that included detailed assessment of the policy including the proposed research strategy to implement the proposed assessment steps.

Detailed evaluation of tribal policy as a team member as part of the project in foundation course for All India training of civil servants.

Best project on developing a data retriever application from metadata using MS Access and VBA among coworkers.

Awarded Second prize and Third prize in essay competition for all India post graduate students held by ministry of statistics and planning implementation held in 2009 and 2008 respectively on “Indicator of Domestic Violence” and “Use of Statistics in Economic development”

Paper on “Child labour in India” and “Data gaps in International Labour Organization in context of India” got published in Indian labour Journal.

PROFESSIONAL EXPERIENCE

Data Analyst

Greenwich Associates : July, 2015 to Present

Automation of report generation using perl and excel macros

Creating deliveries reports of the outputs generated through the surveys for various US and Canadian banks in the Customer Engagement Management Department in Qlikview, SPSS and Excel.

Data warehousing, portals and dashboard creation.

Training in Perl and online/CATI survey Softwares.

Tools used: Perl, SPSS, MS Excel, DASH, Confirmit, Qlikview

Research Specialist (Volunteer)

Self Help Resource Center : June 2015 to Present

Establishing suitable research methodology for assessing the effectiveness of peer support programs.

Conducting research on varied dimensions of wellness programs as per need.

Research Officer/ Assistant Director Indian Statistical Services, Government of India

December 19, 2011 to June, 2015

Supervision of research methodology incorporating the best international practices in the methodologies.

Time series modelling of the price index resulting in predicting the index leading to various important policy decisions.

Meta data analysis of various data sets for developing insights into various aspects.

Modelling of price data collected from various markets from the historic data to predict any future missing prices for the computation of the index.

Analysis of historic index data for assessing possible upward bias in the index and possibility of replacing arithmetic mean with the geometric mean.

Time to time analysis and modelling of varied data sets according to the demand from inter or intra ministry.

Representing the ministry and providing the support documents in in favour of the conclusions derived from various analysis.

Conducting research on different facets of varied projects and preparations of the communication materials and agenda papers to be presented at the meetings held at various levels comprising of stakeholders, academicians, policy makers.

Staff management including recruitment of staff for various levels, training of interns, newcomers and team members.

Monitoring of monthly performance reports, budget and correspondence with the ministry.

Responsibilities as a Chairperson or member of various internal committees like sexual harassment committee, Stock verification committee.

EDUCATION AND TRAINING

Masters of Philosophy in Statistics, University of Jammu, India. (2012)

Built an algorithm based on a model from a published paper for Prediction of stock price using a developed model as a part of M.Phil. Statistics curriculum in MATLAB.

Master Degree in Statistics, Panjab University, Chandigarh, India. (2010)

Bachelor Degree in Maths, Statistics, and Psychology, Jammu University, India. (2008).

Multimedia specialist program (two and a half years) that included new media and digital advertising.(2008)

Attended training at Indian Agricultural and Scientific research institute, New Delhi, India on advanced data analysis and predictive modelling using R, SAS, SPSS, Stata.(2012)

Training in Digital Marketing at Indian Institute of management, Lucknow, India as part of advanced management training (2011). Best presentation “what factors drive the sale of online deals” that aimed at the analysis of marketing and sales strategy of various online retailers using logistic regression at Indian Institute of Management, Lucknow in R.

Training in analysis of GIS data at Survey of India, New Delhi, India. (2012)

SAS (basic module) from DNA Research Institute, Hyderabad, India. (2009).

Training in Econometrics covering analysis of econometric models and variance estimation techniques from Institute of Economic and Social Change, Bangalore, India. (2012).

Training in MS Excel, FoxPro, C, C++, MS Access, SQL and VB.net at National Statistical Systems training academy (2012).

Meritorious Academic record.

.

Contact this candidate