Mahendar Rawat

App # *, ****, Mayview Avenue, Ottawa, Ontario

Email: acfyhj@r.postjobfree.com ~ Mobile: 613-***-****

Objective

To carve a niche in the corporate world by contributing my best to achieve excellent results for the organization and in

the process enhance and expand, my skills and knowledge and prove to be an asset for the organization.

Scholastics

• Post Graduate Diploma in Market Research and Business Intelligence (Anticipated Completion: October 2015)

Algonquin College, Ottawa, ON

• Post Graduate Diploma in International Marketing (August 2011)

Delhi School of Economics, University of Delhi, New Delhi

• Bachelors in Business Administration (November 2009)

Birla Institute of Technology, Mesra, Noida

APPRENTICESHIP

Company: TAJ SATS Air Catering (Subsidiary of TAJ Group of Hotels) New Delhi

Duration: 8 WEEKS (June 2008 – August 2008)

Project: “Cost Control Strategies for outdoor catering”

Professional Synopsis

• A dynamic professional with close to 2.5 years of experience in the areas of HR Analytics, Employee Engagement

Studies, HRIS Management, Data Analysis, Market Research and Project Management

• Last working organization was Aon Hewitt, Gurgaon as Consulting Operations Analyst

• Hands on Experience on various tools and Databases – Advance Excel, MS PowerPoint, SPSS, Base SAS,

Confirm IT

• Expertise in HR Analytics, Data Analysis, Data Mining, Data Cleansing, Reporting.

• Adept at working and handling Indian Market Clients with the newly evolved concepts in HR consulting.

• Possess excellent communication, relationship management, team building / management and analytical skills

Professional Experience

Aon Hewitt, Center Court, Gurgaon, India

Consulting Operations Analyst Nov 2012 – May 2014

KEY RESPONSIBILITIES:

• Provides analytical and statistical support to draw insightful solutions for client needs and to expand the depth of

AON Hewitt offerings

• Accountable for providing support on project execution in-line with SLA requirements, timelines and quality

standards while ensuring high level of internal & external client satisfaction

• Extended value addition to the existing research models by exploratory research and analysis on the database

built over years, like YoY, trending, predictive analysis; successfully built a stronger knowledge base of the

standard product, benchmarking, updating and refining the standard methodologies, providing better value and

improved solutions for the clients.

• Leading a transformation initiative to a new online reporting tool within constrained timelines while ensuring seem

less transition from the existing system to the new system

Mahendar Rawat

email: acfyhj@r.postjobfree.com # mobile: 613-***-****

Aon Hewitt, Center Court, Gurgaon, India

Consulting Operations Analyst Nov 2012 – May 2014

KEY RESPONSIBILITIES:

• Process optimization, monitoring and improving efficiency & quality, process standardization.

• Implement various Quality, technology, automation and standardization initiatives to enhance operational

efficiency.

• Applying expertise with Process Knowledge and Training the new joinees towards achievement of company’s

objective.

• Lead kick-off meetings for large / complex assignments to ensure common and comprehensive understanding of

client requirements.

• Responsible for delivery of analytical solutions, synthesizing available data using Advanced MS Excel, SPSS and

SAS and bring out value-added insights to the client.

• Liaising with the Employee Engagement Team handling global assignments.

• Working closely with Consultants and providing them with all the analytical requirements.

Key Projects Handled

• Employee Engagement Studies - Kotak Mahindra, EXL, TATA Group, Kirloskar, Infotech

• HR Analyzer Studies – EXL, Dalmia

• Aon Hewitt Best Employer India Study 2013

Exevo India Pvt. Ltd., New Delhi, India

Qualitative Research Analyst Feb 2012 – Nov 2012

KEY RESPONSIBILITIES:

• Qualitative & In-Depth Research (Secondary Sources) while using Databases & other tools such as Hoovers, One

Source, Google, LinkedIn, Articles and Surveys etc.

• Conducting In Depth market research through Secondary sources to collect information for analyzing &

interpretation before submission to the client

• Preparation of reports, charts for the submission to client as per the required templates

• Working in different projects relating to IT, Sales, Industry Trends etc.

• Using Databases like Hoovers, One Source, LinkedIn and Google for gathering required information.

Quatrro Analytics and Management Services Pvt. Ltd.

Fraud Analyst Jan 2010 – Aug 2010

KEY RESPONSIBILITIES:

• Worked under the risk management department for providing services to the areas of fraud detection and

prevention and credit risk management.

• Managing the fraud prevention and monitoring function related to credit cards with a view to minimize exposure

and risk of loss on card procedures/workflows.

• Sharing and effective utilization of the best practices of credit card Fraud prevention tools.

Research Projects

• Analysis on viability of telemarketing for selling insurance, by analyzing different methods used by financial

institutions for selling insurance and cost effectiveness of those methods

• Prepared Project Feasibility Report for a fast-food restaurant business in Noida industrial area

Mahendar Rawat

email: acfyhj@r.postjobfree.com # mobile: 613-***-****

Technical Credentials

• Proficient with MS office- MS Word, MS Excel, MS PowerPoint

• Working knowledge of SPSS 19.0 statistical software

• Working knowledge of SAS 9.2

• Working Knowledge of VBA Macros and automations

• Working Knowledge of Confirm IT tool for reporting

Co-curricular Activities

• Member of cultural society of BIT, mesra

• Coordinated various blood donation camps organized in college

• Active participant in volunteering program of Common Wealth Games 2010, New Delhi

• Associated as a coordinator with Oxfam Australia youth awareness program in India, ‘Kaleidoscope’

Place : Ottawa (Mahendar Rawat)

Contact this candidate