Majeeduddin Ahmed

 MAJEEDUDDIN AHMED Mob:- Add: Dilsukhnagar E-mail: - POST APPLIED FOR: MIS EXECUTIVE / OFFICE MANAGER / ADMIN EXECUTIVE EDUCATIONAL QUALIFICATION: Bachelor of Commerce (Computers) TECHNICAL QUALIFICATION: Diploma in Tally-ERP9 from NGCC Institute. Diploma in Indian, Gulf & American Accounting Software from Institute of Practical & Computer Accounts. Post Graduate Diploma in Computer Application from R-TECH Computers – Hyderabad, India WORK EXPERIENCE: 6th Experience – 1yr (May 2022 – current working) MIS Executive – ZAMM Back office (Four US Clients – Boost Mobile) Skills  Working on V-lookup, Pivot Table, Dashboards, Slicers, data validation, Filter, Sort, Conditional Formatting, If, If error, Sum If, Average, Sum, Subtotal Functions in Excel Working on Google Sheets, Google Forms also as per requirement Responsibilities re Reporting Department re Prepare Annual Data Analysis report (Data Cleaning and Data Processing) of all stores in excel Cash & Card Reconciliation of 50 stores (four US Clients) daily in Google Sheet Prepare Daily Sales reports (Location wise and Employee wise) for (four US Clients) thrice a day in Excel Prepare Monthly Sales reports (Location wise and Employee wise) for (four US Clients) on bi-weekly basis in Excel Prepare Employee Competition Report if needed in Excel Check out Deposit amount shortages from the store employee on daily basis Prepare Device wise sales report for each store. Prepare Gp report for 50 stores on daily basis in Excel Check reporting emails Admin & Hr Department Daily Employee Timesheet & Attendance Check and prepare Late login sheet in Google Sheet Prepare Employees Payroll (monthly) and Commission (bi-weekly) Prepare Employee performance reports on daily basis in Excel Prepare New Employee Contracts Check Admin emails Inventory Department Need to do daily inventory Audit of all 50 stores Need to compare the inventory received at stores with the purchase order Process defective devices back to vendor Check inventory emails 5th Experience – 6yr (Apr 2016 – Apr 2022) Office Manager cum Purchase Executive – Sai Varshith Constructions (ISO-certified Company) - Worked on Eleven Completed Projects and three upcoming projects. Responsibilities re Handle all the Construction, Interiors, Electrical and Plumbing material purchases. Prepare Quotations, Price Comparisons, Approvals, Purchase Order preparation & releasing and getting supplier/vendor acceptance to company terms. Expediting the delivery of material to make sure the suppliers deliver the material at site within promised delivery time. Preparing the payment approval form and make sure the advances and/or part payments to be reached to suppliers/Vendors. Maintaining all purchase related data and creating reports on purchases as needed. Maintain a database of approved suppliers Prepare documents related to RERA Prepare Sale deeds, Agreement of Sales & other agreements Maintain database of Flat Customers of all projects Prepare Cost Sheet of Flat Sold to Customer Track amounts received from Customers Maintenance of Projects under our Company period and norms Responsible for cash – In & out Deposit cheque in bank and follow-up with bank till the cheque is cleared Record day-to-day accounts transactions in Tally & MS-XL Reconciliation of bank accounts Prepare list for TDS payment and submit to CA office Follow up for GST upload with CA office Check uploaded invoices by vendors in GST2B. Preparation of Vouchers – receipt & payment Prepare daily site expenses report Outstanding payments list Sending emails in matters related to the office jobs and related works Keeping the list of employee communication and contacts updated Prepare Payroll in Excel – Monthly salary, over-time & incentive payments 4TH Experience – 3.5 yrs (June 2011 – Dec 2015) Accountant cum travel agent – Happy Air Travels - Himayathnagar Responsibilities re Responsible for cash – In & out Daily deposit cash in bank Deposit cheque in bank and follow-up with bank till the cheque is cleared Record day-to-day accounts transactions in MS-XL Maintain accounts in books Preparation of Vouchers – receipt & payment Prepare weekly performance report of travel executives. Prepare daily outstanding report of travel executives. Prepare weekly profit report Prepare daily expenses report Outstanding payments follow-up To book flights tickets of regular clients. To provide train enquires to regular clients Holiday Package work-out based on client’s requirement Responsible for cash – In & out Sending emails in matters related to the office jobs and related works Keeping the list of employee communication and contacts updated Reconciliation of bank accounts Prepare Payroll in Excel – Monthly salary, over-time & incentive payments 3rd Experience – 1 yrs (May 2010 – May 2011) Accountant cum Office Assistant – Panaaya Pharma Pvt. Ltd. Responsibilities – (Daily accounts work – Export & Domestic, Export documentation, Excise related matters and FX banking transactions) re Record day-to-day transactions & inventories in Tally Maintain accounts in registers & MS-XL – cash book, bank book, purchase register, sale register & petty cash book Preparation of Vouchers – receipt, payment, purchase & sale Receivables & Payables follow-up Reconciliation of bank accounts Daily Expense Report in MS-XL to Manager Prepare Payroll in MS-XL – Monthly salary, over-time & incentive payments Monthly physical stock check. Prepare stock sheet in MS-XL Filing e-returns of VAT and CST online. Apply for H-forms and C-forms online. Filing of Purchase & Sales transaction against H-forms and C-forms to Sales Tax Department. Prepare documents for Fixed Deposits and keep track of maturity dates in MS-XL. Prepare all documents related to Export obtaining CT1 & Proof of Export from Central Excise department Follow-up with CHA for export. 2nd Experience – 1.5yrs (2009 –Apr 2010) Accountant cum Office Assistant – Unique Constructions Responsibilities To prepare accounts upto trial balance ( both in Excel & Tally) & forward to Sr. Accountant Maintain account books in Excel – cash book, bank book, construction items register, purchase register, petty cash book Preparation of Vouchers – Receipt, Payment, purchase invoice Record day-to-day transactions in Tally Daily cash deposit in bank Receivables & Payables follow-up Reconciliation of bank accounts Daily Expense Report to Manager Filling documents as per the requirement of the managers Sending emails in matters related to the office jobs and related works Making copies of the documents, as assigned by the office managers Distributing the incoming mails to the respective staff Keeping the list of employee communication and contacts updated 1st Experience – 3yrs (2005 – Dec 2008) Accountant / Store Incharge – Ideal Pvt Ltd. (FMCG company, Head Office located in Pune – Worked in Hyderabad Main Branch) Responsibilities Prepare accounts upto Trial balance Maintain account books in Excel – cash book, bank book, stock register, purchase register, petty cash book Preparation of Vouchers – Receipt, Payment, purchase invoice Maintain Sale records of all Sub- branches in Excel. Record transactions & inventory in Tally Record transfer of items to Branches in Tally Daily cash deposit in bank Reconciliation of bank accounts Daily Sales, Stock Query, Expense Reports of all sub-branches to Manager Prepare Payroll in Excel – Monthly salary, over-time & incentive payments *****************************************