Curriculum Vitae

SUDIPTO ROY

Permanent Address:

Triton Apartments, 2nd Floor

Bata More

West Jagtala

Maheshtala

BBT Road

Kolkata 700141

Mobile: 629*******

Objective

Seeking an opportunity to utilize and enhance my skills by facing challenges in the industry, thus achieving overall development and bringing best results to my employer and myself.

Skills

Data Management and Analysis, Excel Reporting, Dashboard, Word, PPT creation and presentation

MIS, Advanced Excel and VBA (Basic)

Excellent written and verbal communication skills

Interpersonal and Man Management skills

Hands on experience in Capital Market, Derivatives, Mutual Funds

Writing, e Books, Advertisement

Advanced Excel Functions and Formulas, Sumif/s, Countif/s, Vlookup, Hlookup, Lookup, Pivots, Text Functions (Len, Left, Right, Mid), Search and Replace, Find, Rank, Conditional Formatting with formulas, Data Validation, Index Match Match, Advanced Charts etc.

Certificate in Data Analytics Using Excel and Power BI course from Digital Vidya.

Certificate in Advanced Data Analytics and Story Telling Techniques from Udemy.

Certificate if Microsoft Excel Data Analysis and Dashboard Reporting from Udemy.

Certificate Program in Advanced MS Excel from Udemy.

Certificate in Microsoft Excel – Advanced Excel Formulas and Functions form Udemy

Certificate in Microsoft PowerPoint – PowerPoint from Beginner to Advanced from Udemy

Certificate in Master Microsoft Word Beginner to Advanced from Udemy

Certificate in Advanced Excel and VBA for MIS Reporting for IVY Professional School, Camac St Kolkata.

Certificate in Tally ERP 9: Step by Step Guide to Accounting with Tally from Udemy

Certificate in Microsoft Complete Beginner to Advanced from Udemy

Certificate in Tally ERP 9 with GST Complete Advance Course from Udemy

Educational Qualification:

Examination

Institute/University

% of Marks

M.COM (1998)

UTKAL UNIVERSITY

62

Post Graduate Diploma in Business Management (One Year Intensive Course) (1998)

Institute of Modern Management, Loudon St. Kolkata

64

Graduation (B.COM) (1993)

J.B. COLLEGE, JORHAT ASSAM

57

10+2 AISSCE CBSE (1990)

Kendriaya Vidyalaya, Jorhat, Assam (CBSE)

59

10th ICSE (1988)

Carmel School, Jorhat Assam

76

Certification:

ITILv3 Certification

Passed NCMF certification in Derivatives, Capital Market and Mutual Funds

Cleared SLET (State Level Eligibility Test conducted by UGC) for appointment of Lecturers and Research Scholars in India.

Work Experience

Whole9Yards Private Limited: April 2021 to Jan 12, 2024.

A Start Up Ecommerce Company

Worked in the Pricing department as a Sr. Pricing Specialist.

Tutorial Hub (Dec 15, 2019 – March 25, 2020)

Bought 25% share in Foundation Academy and Tutorial Hub a School and Tutorial Center at Batanagar.

English, Accountancy, Business Studies and Excel, Computer fundamentals.

For all Boards and University.

Foundation Academy School (Dec 15, 2019 – March 25, 2020)

Teaching all subjects to students of Foundation Academy (Class 1 to IV)

In charge of overall administration.

Andul Annapurna Estate Trustee (June 2019 to Dec 15 2019)

Worked as a trustee of our Ancestral Family Estate.

Looking after the overall development of the Estate along with other Trustees, maximizing profit of the Estate.

Land and Property Development.

Keeping accounts of payables and receivables.

Adi Mohini Mohan Kanjilal Mkt Pvt. LTD. (Nov 2018 to May 2019)

Worked as Accounts Supervisor using Tally ERP 9.

Overall responsibility of accounts and compliance.

GST, TDS, Reporting, Staff Supervision, Sales Reporting, MIS among other things.

Overall charge of the Show Room, Staffing, Salary Disbursement.

Excel Training.

Atos India Pvt Ltd. (June 2015 to Oct 5, 2018)

Worked as an Associate Consultant dealing with various types Time Card (Payroll) related approval and reports using SAP front end. Preparation of time booking reconciliation and reporting metric reporting. Extensive use of Advanced Excel and VBA. Daily and Weekly and Monthly reports for offshore client (Airbus - France). MIS, Data Visualation.

Experience in preparation of Dashboard, Charts.

Coordination with different departments, gathering raw data to prepare Reports

Price Waterhouse and Coopers (January 2011 to May 2015)

Worked as a Sr. Associate under the Ethics and Compliance Department

Key work areas

Auditor’s independence standards – PCAOB, SEC, AICPA

Personal Independence Audits Quality review of Team’s work

Preparation of Desktop procedure, AS IS and TO BE, Process and Procedural Flowchart

Data management and feasibility analysis.

Training Teams in Excel and Macros and VBA for process specific reports

Interaction with client regarding interpretation of US Auditors Independence policy

Involvement in process improvement of the Back Office Reporting through Macro deployment in reporting.

Initiation and implementation of change management.

Identification of VA and NVA activities in a process and implementing changes accordingly.

FTE calculation and planning for peak and lean periods.

WIPRO (December 2007 – December 2010)

Had been associated with Wipro BPO from 30.12.2007 to 30.12.2010

Had joined Wipro as an Associate. Took calls in the front line from April ‘2008 to August 2008 and thereafter moved to Hardware Dispatch (Second Level Technical Support) and took calls till May 2009.

Joined the Wipro BPO Training Department in May 2009 and continuing till December 2010. Strong customer orientation and training skills

Forte – Communication (Verbal and Non-Verbal)

Key areas worked as a Product and Process Trainer

Responsibilities:

Taking up New Hire Batches and Providing them Technical and Process Related Training

Looking after Trainee ID creation and all other Requirements.

Conducting Online Assessment

Attrition Management

Supporting the Trainees on the Production Floor

To motivate, develop and mentor team members in a dynamically changing environment

Monitor transactions & calls and provide qualitative/constructive feedback to the team members

Timely receipt and action on customer feedback.

Ensures team performance as per agreed standards (TAT).

Keeps a check on the attendance of the team

Responsible for Production Management, Crisis Management and Time

Management for the team

Identifies development needs. (TNI and Recursive Training)

Planning and implementing curriculum, module development as per TNI.

Training MIS

Auditing Calls and checking process compliance, providing feedback on improvement areas, planning AHT reduction methods.

Apex Investments (Franchise of a Reputed NSE Broker)

Proprietor – Apr 2002 to Sep 2007

Investment in Stock Market on behalf of clients in Shares, Derivatives like Future, Options (Call/Put).

Making clients aware of the Risk and Rewards of investing in Stock market

Part Time Lecturer in Commerce with Bon Hooghly College of Commerce

Aug 2001 to Feb 2002.

Subjects Taught:

1.Costing

2.Accountancy

3.Economics

4.Business Organization and Management

The Park Hotel, Kolkata (May ’95 to Mar 2001)

Joined as an Accounts Assistant in May ’95 and left the organization as a Jr. Accounts Officer in Apr’ 2001.

While with the Park Hotel dealt with the following:

Accounts payable and coordination with accounts receivable

Accounts Payable MIS

Vendor Management and reporting

Cash and Bank Management

Profit and Loss Account, General Ledger and Balance Sheet

Branch Accounting, Preparation of Cash Flow Statement, Budgeting

Import Documentation, Bank Guarantee and LOC

Foreign Currency and Foreign Currency Remittances

Compliance reporting to RBI (foreign currency section)

Bank Reconciliation of EEFC A/C, Cash Credit Account

MIS, Daily Sales Reporting in Excel, Cash Flow Statement preparation

Personal details:

Name : Sudipto Roy

Date of Birth : 28.07.1972

Gender : Male

Marital status : Married

Nationality : Indian

Father’s name : Late. Dr. Monoj Kanti Roy

Mother’s name : Krishna Roy

I believe that I have a balanced mix of aptitude and attitude. I enjoy taking responsibilities and thrive working in a group. I am a disciplined, hard worker, avid and a fast learner. Have the ability to work under pressure and meet deadlines.

Languages known:

English, Hindi, Bengali, Assamese.

Interests and Activities:

Music, Fiction, Mythology, Technology

Declaration:

Hereby declare that the above-mentioned particulars are true to the best of my knowledge and belief.

Sudipto Roy

(M): 629*******

Contact this candidate