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*******