MS Excel

S A N D E E P M E H T A

S/O- Sushil Mehta, Sadar Bazaar, opp. Post Office, Kherwara Dist- Udaipur, (Raj.)

Pin Code- 313803, Mob. No.- 097********

E-mail- *****.**********@*****.***

C A R R I E R O B J E C T I V E S

To prove myself in the field of Business Analytics with an organization that provides excellent work culture and paves the way for handling of responsibilities.

E D U C A T I O N

Institutions/Universities

Qualification

Sikkim Mani pal Universities

MBA Finance

IIMT, Usmanpura, Ahmedabad (Guj.)

Year-2012

ICA

Certified Industrial Accountant

Durga Nursery Road, Udaipur

March – 2010

PIN Code. 313001

Mohan Lal Sukhadiya University

Bachelor of Arts

Udaipur (Raj.)

2005 – 2006

Govt. Senior Secondary School

12th Class

Kherwara, Udaipur (Raj.)

2002 – 2003

(RBSE)

Govt. Senior Secondary School

10th Class

Kherwara, Udaipur (Raj.)

2000 – 2001

(RBSE)

W O R K E X P E R I E N C E

Sr. No.

Name of the Organization

Designation

Period of Employment

From

To

1

Motif Info Tech Ltd. Ahmedabad

MIS Executive

3rd Apr’12

15th Mar’15

2

Landmark Insurance Broker Pvt. Ltd., A’bad

MIS Executive

16th Mar’15

10th Oct'15

3

Adarsh Credit Co-Operative Society

MIS Executive

24th Nov'15

Continue

Motif Info Tech Ltd., Ahmedabad :

Make My Trip Process(MMT)

Daily, weekly, monthly sales report.

MIS reporting by using MS Excel & VBA (Macro) at Operational and Client level.

Generating timely and accurate reports for analysis and creating MIS Reports/ Dashboard and presenting it to the concern Department.

Implementing and analyzing data to create daily, weekly, monthly, and quarterly reports.

Generating & maintaining day to day MIS Data and updating the management.

WBR(Weekly Business Review),MBR (Monthly Business Review),

QBR (Quarterly Business Review)

Usage of Excel (Lookup, Count if, Sum if, Pivots, Get Pivot,Charts, conditional formatting)

Usage of PowerPoint (WBR,MBR,QBR Presentation)

Making Sales Incentive Reports based on parameters given by clients.

Usage of Macro(Data appending,data split, data clean)

Landmark Insurance Broker Pvt. Ltd. :

Handling daily, weekly, monthly Reconciliation reports.

Maintaining day to day MIS Data and updating the management

Usage of Excel and Macro(Lookup, Count if, Sum if, Pivots, Get Pivot,Charts, conditional formatting, data append)

Adarsh Credit Co-Operative Society Ltd. :

Handling daily, weekly, monthly reports.

Maintaining day to day financial business Report MIS Data and updating the management.

Monthly and Quarterly Business review reports

Working knowledge :

Knowledge of making new templates in Excel, Daily,Weekly, Monthly MIS Reports, Incentive Report, New Dashboard, count if, sum if etc. formulae

Knowledge of Data Analysis

Visual Basic Application Programming (Pursuing VBA Macro classes)

C O M P U T E R P R O F I C I E N C Y

Software package: Microsoft Office 2003, 2007, 2010 Advance Excel knowledge and formulae

Tally 9.0, 9.2,Power Point, Tally ERP, VBA Macro

P E R S O N A L D E T A I L S

Father’s name Mr. Sushil Mehta

Mother’s Name Mrs. Vidhya Devi Mehta

Marital status Married

Nationality Indian

Linguistic proficiency English, Hindi & Gujarati

I hereby declare that the above mentioned information is correct to my knowledge and belief.

Place:

Date: SANDEEP MEHTA

Contact this candidate