Shekhar Gupta

Experience

• 

  MOTOROLA

  Sept 2006 - Dec 2007

  Associate Consultant

  • Intercompany payment Schedule, Forex Entry, Circulation of Accounts Payable Inquiry to project Associates, General Ledger Analyses, Inter-company Reconciliation (MINC, MCEL & ML), Trial Balance Variance Analysis, MIPL Sales Summery Local Sourcing Account Reconciliation MIPL sales summery, Inter Company Balances in Trial Balances VS Inter-company Books with final Trial Balances, Field Inventory / ICP Report, MIPL JV Console for the whole month, Trial Balances Summery in INR & USD, Compilation of Accounts Pack.• Processed all aspects of accounts receivable (billings) for a variety of government and commercial related to various kinds of contracts and customers and 95% revenue achieved as per the milestone mentioned in the contract. • Handle operations which have shifted from Singapore to UK involving tracking status of Purchases orders, material delivery, inbox & individual sales, daily inventory & pre alerts for Motorola & Bharti Teletech. • Make cost comparatives between UK prices and Singapore prices and negotiated terms on that basis.• Coordinated with the ad agencies and the promotional agency of Abhishek Bachchan (Brand Ambassador for Motorola).• Researched billing related issues as necessary to process billings to clients and Issue purchase indents, orders and customer invoices. • Prepare weekly MIS of sales and distribution for Head Office. Show less

• 

  STAR NEWS

  Jan 2008 - Apr 2010

  ASSISTANT MANAGER - FINANCE

  - Financial Accounting | Account Receivables & Payables1) Independently responsible for accounting process of payables management for one International Channel Star News and Two Regional Channels Star Majha (Marathi) & Star Ananda (Bangla) for North and South Regions. 2) Validation & Authorization of vendor invoice, documents and responsible for timely release the payments. 3) Comply with statutory compliances Deduction of TDS / Service Tax / WCT.4) Direct and support various Accounts Receivable related projects from a business owner perspective, including concept development, requirement identification, user acceptance testing, and production implementation from a process and operational standpoint.5) Manage all accounting and reconciliation related aspects of receivables and Responsible for conducting research and updating vendor file, activating individual files.6) Manage and approved the payments coding and monthly invoices.7) Reviewed aged receivables, prepared and submitted recommendations on write-off of bad debts to Financial Director.8) Handle Employee Queries on payments that escalate by Junior Management and if not solve process for Top Management. 9) Authorize Employee Travel Claim other reimbursement and Reconciliation of the Vendor Accounts - Month wise, Region wise.• - MIS (Maintaining all reports) :1) Prepare monthly details of payments to vendors & employee Account wise, region wise and product wise.2) Percentage Contribution - Product wise, Region wise, Account wise.3) Monthly Expenditure Reports – Product wise, Region wise, Account wise.4) Other miscellaneous reports and analysis (customized as per the requirements of seniors & functional area heads).Major Achievements1) Reconciled the issues more than a year old for major MR accounts. 2) Successful handle the operations of Head Office, Mumbai. Show less

• 

  Commonwealth Games Delhi 2010

  Apr 2010 - Mar 2011

  Project Officer Finance & Acounts

  Vendor (International & National) Management & Finanacial management

• 

  PARAMOUNT INTERNATIONAL (AHSAN GROUP)

  Apr 2011 - now

  CONSULTANT FINANCE (METAL & GLASS BUSINESS)

  Responsibilities:• Bill Passing Procedure, Payments to Suppliers, Debtors & Creditors Reconciliation, Advance Payment Recovery From Suppliers, Material Accounting and Reconciliation, Preparation of Stock Statements. • Reports Generation: Billing Status & Procurement Report .• Payment to vendors as well as employees including (a) payment /settlement of advances or security deposits to vendors, (b) settlement of employee claims in respect of travel and official expenses.• Regular monitoring, confirmation and settlement of imprest on periodic basis. • Co-ordinated with purchase dept. for organizing purchases. • Completed monetary transactions related to the procurement activities after due authorisation. • Coordinated with factory, Purchase Dept., & vendors for timely submission of invoices & required documents.• Liaison with government organizations for vendor registration. • Handled customer enquiries by email, letters & on phone.Major AchievementsSuccessfully handled the control over inventory through Class ‘A’ material reconciliation. Show less