Sujit C.

JOB PROFILE :-E-commerce:- Amazon, Flipkart ,indiamart,Snapdeal :- Products cataloging & A+ Listing(Amazon) on AllMarketplaces. Good Knowledge of Pricing/ price compare on All Marketplaces. Making all MIS reports per company requirement ( Daily ,weekly ,Monthly). Commission, shipping Fee, Fixed Fee , collection Feereconciliation. Reimbursement/protection fund received Reconciliations onAmazon ,Flipkart. Manage SAFE-T Claims ,SPF Claims on Amazon, Flipkart. Returns product & refund amount reconciliation. Logistic(shipping) Reconciliation of All Marketplaces. Making Brand store on Amazon portal. Good knowledge of campaigning, advertisement(ROI,CPC),Promotions. Stock/inventory Management & Reconciliation of AllMarketplaces. Payment reconciliation of All Marketplaces. Sales Reconciliation of All Marketplaces. Order Processing of All Marketplaces. Good Knowledge TDS And Tax Reports of Amazon, Flipkart,Snapdeal. Good knowledge of Amazon Vendor Central . Good knowledge of GST Reconciliation ( State & HSN wise) Good knowledge of E-Commerce portal (Amazon , Flipkart,Snapdeal, indiamart ).Management Information System(MIS):- Working knowledge of Management reporting with good analytical /skills. V-lookup, sum if, count if ,Data Validation, if, and ,or ,Len ,Right ,Left ,Mid, Dashboard Multiple V-lookup, Multiple , Reverse v- lookup, Text to Columns,sub total, Data Table  Reverse v- lookup ,Index, Match, Pivot table, Table, Getpiovt.,what if analysis, Goal Seek, Good Knowledge of Macro. Basic knowledge of VBA( use internet) & POWER POINT.Accounting :- Sale and purchase entry passing in tally/Quicbook/Logic. Payment and Receipts entry passing in tally. reconciliations of Debtor & Creditors. Bank reconciliations. GST & TCS Reconciliation of Amazon , Flipkart , Snapdealetc. Good knowledge of E-commerce Accounting. Basic knowledge of Balance sheet & P/L, Google sheet , Excel Dasborad Top Skills Accounting E-commerce MIS reporting Google Sheet