Mahendar Rawat
App # *, ****, Mayview Avenue, Ottawa, Ontario
Email: *****.********@*****.*** ~ 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: *****.********@*****.*** # 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: *****.********@*****.*** # 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)