Dipanjan Bhattacharya

CURRICULUM VITAE NAME: - DIPANJAN BHATTACHARYA CAREER OBJECTIVE:1) ACQUIRE MAXIMUM KNOWLEDGE. 2) EXPLORE MYSELF FULLY AND REALIZE MY POTENTIAL. 3) WANT TO MAKE MY CAREER IN SCHOOLS/COLLEGES/EDUCATIONAL INSTITUTIONS/CORPORATE SECTOR/GOVERNMENT ORGANISATION/AADHAR ENROLLMENT/BANKING SECTOR/EDUCATION SECTOR/KPO/ECOMMERCE/SHARE MARKET/STOCKMARKET. ACADEMIC QUALIFICATION:YEAR BOARD/UNIVERSITY SCHOOL/COLLEGE 2003 ICSE ST. JOSEPH & MARY’S SCHOOL ICSE 58 2005 ICSE ST. JOSEPH & MARY’S SCHOOL ISC 70 B.COM (HONS. IN ACCOUNTING & FINANCE) 50 2008 CALCUTTA VIVEKANANDA COLLEGE (THAKURPUKUR) EXAMINATION PERCENTAGE PROFESSIONAL QUALIFICATION:YEAR 2010 INSTITUTE ICMAI (INSTITUTE OF COST AND MANAGEMENT ACCOUNTANTS OF INDIA) EXAMINATION CMA (INTER) PERCENTAGE PERCENTAGE OBTAINED 52 WORK EXPERIENCE:1) WORKED IN I.G. MINT, A WEST BENGAL GOVT. ORGANISATION, KOLKATA AS AN ADMINISTRATIVE EXECUTIVE. (MAY 2012 TO DEC 2012 - CONTRACTUAL). Professional Skill: 1. Preparing office notes. 2. Preparing minutes. 3. Sending mails for various official purposes. 4. Drafting of forwarding letters. 5. Maintaining stationery items, medals and identity cards and distributing them to various departments as per their requirement. 6. Making phone calls and attending phone calls for various purposes. 7. Arranging and scheduling meetings of higher authorities for various purposes. 8. Ticket booking for travelling purposes. 9. Various other data entry works. REASON BEHIND JOB CHANGE:  It was a contractual job and the tenure of the contract was over. 2) WORKED IN MECON LTD, A CENTRAL GOVT. UNDERTAKING, KOLKATA AS A TRAINEE ACCOUNTANT. (DEC 2013 TO DEC 2015 – CONTRACTUAL). Professional Skill: 1. Daily accounting 2. Making Inter Office Memos in respect of Tour Advance and Medical Bills. 3. Voucher Entry 4. Monthly TDS Statement, TDS Certificate 5. V Lookup, H Lookup, Conditional formatting, Sorting & Filtering applications 6. Basic Excel formula applications like sum, difference, multiplication, division and percentage calculations. 7. Cash Certificate 8. Monthly Service Tax Statement 9. Monthly LIP recovery schedule of H.O. and B.O. 10. Cash Book Entry 11. Disbursing Tour Advance, Medical Bill Processing & Contingent Advance. 12. Preparing ISD Invoice. 13. Assisting senior accountants in filing returns. 14. Sending Mails for various official purposes REASON BEHIND JOB CHANGE:  It was articleship training on a fixed contract of 2 years. 3) WORKED IN TURTLE EYE, AN APPS MAKING PROPRIETORSHIP FIRM, AS A DATA ENTRY OPERATOR. (APR 2016 TO AUG 2018). Professional Skill: 1) Data entry works in Ms. Excel (using applications for both Normal Excel as well as Advanced Excel). 2) Editing works of data’s in databases in MS Excel. 3) V Lookup, H Lookup, Conditional formatting, Sorting & Filtering applications. 4) Various functions applications IF, COUNTIF, SUMIF, DATEDIF, AVERAGEIF, COUNTA. 5) Removing Duplicate values/entries and keeping Unique values/entries. 6) Surfing nets for data mining and data collection activities and searching nets for getting suitable images of schools, colleges, and universities for apps making activities. 7) All types of copy paste works in MS Excel and MS Word. REASON BEHIND JOB CHANGE:  4) Left the organisation as no valid documents have been provided to me and salary transactions were made in cash and also for the reason that I got a very good opportunity to work in Bose Institute which is a renowned Government Organisation and offered remuneration was good as well. WORKED IN BOSE INSTITUTE, A PREMIER RESEARCH INSTITUTE FOUNDED BY AJC BOSE AND FUNDED BY GOVT. OF INDIA, DEPARTMENT OF SCIENCE AND TECHNOLOGY, MINISTRY OF SCIENCE AND TECHNOLOGY, NEW DELHI AS AN OFFICE EXECUTIVE (GRADE-1) AS CONTRACTUAL EMPLOYEE. (FROM AUG 2018 TO FEB 2019). Professional Skill: 1) Preparing Office Notes under Note Sheet and Office Orders 2) Preparing Draft Letters and Final Letter under Letterhead 3) Typing and Data Entry Works as given from time to time as per the requirement of the company 4) Sending Mails for various official purposes REASON BEHIND JOB CHANGE:  Initially it was a contract of 6 months and after end of contract there will be option for renewal of the contract further if manpower in required but unfortunately there was no requirement of manpower at that time and the contract was not renewed further. 5) WORKED IN VERIFACTS SERVICES PVT LTD, KOLKATA, BACKGROUND VERIFICATION BASED PRIVATE COMPANY AS DATA ENTRY ANALYST. (FROM JUL 2019 TO OCT 2019). Professional Skill: 1) Doing case entries of different companies and submitting the same after uploading their documents. REASON BEHIND JOB CHANGE:  Left the organisation after completion of probation period and after getting confirmation from the company’s end because of the reason that I was not comfortable with the sudden change of shift timing from 3 PM to 12 AM at night without any option of drop facility which I was not aware of before because their timings uptill my probation period was from 9.30 AM to 6.30 PM (Fixed General Shift Timing). 6) PRESENTLY WORKED IN EXTRA COVER INSURANCE BROKERS PVT LTD, KOLKATA, AN INSURANCE COMPANY AS BACK OFFICE EXECUTIVE. (FROM FEB 2020 TO JULY 2020). 1) Doing data entry works of various insurance datas. 2) Managing huge database 3) Doing follow up mails for premium money due as well as doing mails for payment to parties. 4) Document verification of both the insurer as well as the insured along with checking the legal agreement papers of the same. 5) Sending Mails for various official purposes REASON BEHIND JOB CHANGE:  The organisation has provided work from home facility due to COVID-19 situation from the end of February, but in the beginning of the month of August 2020, company has told me that they will right now terminate all their existing employees and they will hire new employee in their place due to this pandemic for safety and security reasons. Regarding documents I have the offer mail of this company but no offer letter because I have been told by the company that offer letter will be provided after successful completion of six months of service in this company. 7) DONE ONLINE PRIVATE TUTIONS AND WORKED IN A PRIVATE TUTORIAL ALONG WITH SOME ADMINISTRATION AND DATA ENTRY WORKS (WORK FROM HOME) LIKE MAINTAINING RECORDS OF ADMITTED AND ENROLLED STUDENTS, MAINTAINING THE ATTENDANCE OF STUDENTS, TELECALLING, SOLVING STUDENT’S AND GUARDIAN’S QUERIES, UPDATNG RULES AND REGULATIONS OF THE TUTORIAL REGARDING TIMINGS, FEE STRUCTURE AND INTIMATING THE UPDATIONS (IF ANY) TO THE STUDENTS AND GUARDIANS REGARDING THE SAME, E.T.C. (FROM JULY 2020 TO JAN 2021) REASON BEHIND JOB CHANGE:  My friend has opened this tutorial and fortunately he got a government job and permanently closed this tutorial because he will not able to give time anymore for this tutorial and unfortunately I have to discontinue my job also in this tutorial. 8) PRESENTLY WORKED AS A DATA ENTRY OPERATOR IN ISMAIL STORES SUPPLY, A SHIPPING COMPANY (WORK FROM HOME). (FROM FEB 2021 TO MAY 2021) Professional Skill:-) Preparing Tax Invoices Preparing Quotations Maintaining large databases in MS Excel Composing Mails Taking Quotation Rates from Vendors Drafting Official Letters in MS Word Telecalling Documentation REASON BEHIND JOB CHANGE:  The Organization will now operate from office and there will be no work from home from now onwards and keeping in mind this pandemic situation of COVID -19, I can’t agree with them regarding work from office. So, I have discontinued with this company. COMPUTER PROFICIENCY:1) DONE 100 HOURS COMPULSORY COMPUTER TRAINING FROM ICMAI DURING ICMAI (INTER). 2) DONE COURSE ON FINANCIAL ACCOUNTING (CFA) FROM YOUTH LABWEB COMPUTER CENTRE. 3) DONE ADVANCED EXCEL COURSE FROM CMC (APTECH) COMPUTER ACADEMY. 4) KNOW MS WORD, MS EXCEL, VLOOKUP, HLOOKUP, PIVOT TABLE & PIVOT CHART APPLICATIONS, CONDITIONAL FORMATTING, DATA VALIDATION, MAX, MIN, LEN, CONCATENATE, IF, SUMIF, COUNTIF, AVARAGEIF, DATEDIF, COUNTA, MACROS APPLICATIONS, CONSOLIDATION OF TABLES, MS POWERPOINT, SENDING EMAILS, CHECKING MAILS, DOCUMENT VERIFICATION, DOCUMENT UPLOADING, TALLY (BASIC ENTRY KNOWLEDGE ONLY), MS POWERPOINT AND INTERNET BROWSING. 5) HAVE CERTIFICATE IN DATA ENTRY OPERATOR FROM E Skill India CURRENT SALARY: - Rs.8,000/- PER MONTH LANGUAGES KNOWN:1) ENGLISH. 2) BENGALI. 3) HINDI. PROMINENT ATTITUDE:1) HARD WORKING. 2) COMMITTED TO WORK & POSITIVE THINKING. 3) POSITIVE ATTITUDE. 4) ABILITY TO TAKE PRESSURE AND ABILITY TO MEET DEADLINES WITHIN PRESCRIBED TIME LIMIT. PERSONAL DETAIL: ADDRESS: - P-47, SHYAMA CHARAN SMRITI TIRTHA ROAD P.O. - NEW ALIPORE KOLKATA-700053 MOB: -/-(WHATSAPP NUMBER) E-MAIL ID--PERSONAL INFORMATION:DATE OF BIRTH: - 23RD MAY 1987. SEX: - MALE RELIGION: - HINDUISM (BRAHMIN) NATIONALITY: - INDIAN. MARITAL STATUS: - MARRIED. CIVIL STATUS: - GENERAL. FATHER’S NAME: - DIPAK KANTI BHATTACHARYA. MOTHER’S NAME: - DOLLY BHATTACHARYA. I HEREBY DECLARE THAT THE INFORMATIONS PROVIDED ABOVE ARE TRUE AND FAIR TO THE BEST OF MY KNOWLEDGE AND BELIEF. DATE: - PLACE: - KOLKATA (DIPANJAN BHATTACHARYA) SIGNATURE:-