CAREER OBJECTIVES
To seek a better opportunity in your esteemed organization and to make my career under your directional approach and enthusiastic guidance of your organizational team, This will make me a part of your management. I wish to continually learn and attain the job satisfaction by the optimum utilization of my qualifications and experience or contribute towards the objective and growth of the organization.
ANKUR RAY
4/3 Lane, Anandanagar, Parbangla
Nungi, Batabagar, Maheshtala,
Kolkata-700140
PROFILE
I am driven in all my endeavors by a commitment to excellence. I have the attitude to learn and work in teams. Facing challenges and meeting deadlines are my strengths. Looking forward to work in creative, challenging and learning atmosphere, which provides ample opportunities for growth in the all field
AREA OF INTEREST
MIS Executive
Office Administrator
Office Assistance
Database Executive (Access, SAP)
PROFFESIONAL & OTHER QUALIFICATION
Diploma In Computer Application.
Bachelor in Art (B.A.) from Calcutta University. (Not Complete)
ACADEMIC QUALIFICATION
Intermediate (12th) Passed.
Matriculation (10th) Passed.
COMPUTER PROGRAMING SKILLS
Office Package: Microsoft Word, Microsoft Excel, Advance Excel, Microsoft PowerPoint, Microsoft Outlook Express
Accounts tools: Tally (Learning), Excel
Operating Systems: Winows9X, Windows2000, Windows ME, Windows XP, Windows Vista, MS DOS
Hardware tools: software Installation, operating system Installation
Internet : well knowledge of Internet and webmaster (web, directory, search engine and portal sites)
Typing Speed: 40 words/minute, Accuracy 99%
Presently Working At:
Organization Name: AstraZeneca Pharma India Ltd
Designation : MIS Executive, Office Administrator
Time period:- Aug 2007 to Feb 2016
Role and Responsibilities
Receiving and downloading data from different - different sources, Cleaning and formatting data using by EXCEL.
Downloading data from CRM on date and priority basis. Sharing all data disposition with centers heads.
Removing duplicate numbers from Data through Excel (Tools and formula).
Downloading Sales related data from SAP/ERP & preparing various type of Sales data
Creating and updating Sales productivity report in Dashboard and Share MIS Dashboard to the seniors.
Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.
Extracting report from CRM report on daily basis sharing MIS to the seniors.
Updating Data Tracker and MIS Dashboard on daily and weekly basis.
Interacting with Company employee directly through scheduled daily / weekly Business Conversation (Email)
Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) as per Division wise
Excellent in Advance MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation)
Help SFE(Sales force Effective) Team for their requirement.
Making advanced presentation in Ms PowerPoint to present MIS & other related important reports.
Preparing Central Review Dash Board for All division using VBA, Excel formulas.
Preparing Call report for filed staff (invalid /Valid Call), using & download data from A360-Viva (reporting Software)
Updating DCR (Daily Call Report) for filed Staff on daily basis.
Maintains Office Admin work like (Incoming/Outgoing documents, filing, arrange Meeting, Hotel Booking, Flight Booking, etc.
Organization Name: Iressia Life Sciences Pvt. Ltd.
Designation: - Assistance Brunch Manager cum MIS Assistance.
Time period:- From 2004 to Jul. 2007
Role and Responsibilities
Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.
Updating Data Tracker and MIS Dashboard on daily and weekly basis.
Interacting with Company employee directly through scheduled daily / weekly Business Conversation (Email)
Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) as per Division wise
Excellent in Advance MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation)
Preparing Credit Note, Brakeage & Expiry report for Stockiest.
Updating DCR (Daily Call Report) for filed Staff on daily basis.
Maintains Office Admin work like (Incoming/Outgoing documents, filing, arrange Meeting, Hotel Booking, Flight Booking, etc.
Preparing & Checking Field Expense report & send it to Finance department.
Preparing Stock Allocation Report for distribution department.
Preparing Secondary Sales Report Using Excel for Manager.
Organization Name: Ranbaxy Rexter Divission (DSO)
Designation: - Admin. Assistance cum Data operator.
Time period:- April 2001 to Feb 2004.
Role and Responsibilities
Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.
Updating Data Tracker and MIS Dashboard on daily and weekly basis.
Interacting with Company employee directly through scheduled daily / weekly Business Conversation (Email)
Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) as per Division wise
Excellent in Advance MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation)
Preparing Credit Note, Brakeage & Expiry report for Stockiest.
Updating DCR (Daily Call Report) for filed Staff on daily basis.
Maintains Office Admin work like (Incoming/Outgoing documents, filing, arrange Meeting, Hotel Booking, Flight Booking, etc.
Preparing & Checking Field Expense report & send it to Finance department.
Preparing Stock Allocation Report for distribution department.
Preparing Secondary Sales Report Using Excel for Manager.
PERSONAL PROFILE
Father’s Name
Late Santosh Kumar Roy
Date of Birth
21st Dec 1977
Address
4/3 Lane, Anandanagar, Parbangla
Nungi, Batabagar, Maheshtala,
Kolkata-700140
Contact Number
**********@**********.***
Sex
Male
Marital Status
Marred
Nationality
Indian
Language Known
English, Hindi & Bengali
Hobbies
Listing music & Making friends
I hereby declare that all the above-furnished information is correct to the best of my knowledge
Place: Kolkata
Date: __/__/ [Ankur Ray]
Curriculum Vitae
Contact No: -+91-905*******
**********@**********.***
WORKING EXPERIENCE