Microsoft Excel

Experienced Finance Specialist with a demonstrated history of working in the consumer electronics, Exports, Fashions & Apparel Industry. Enabler for bringing financial discipline by making sure that the flow of money is tracked and recorded. Work for end-to-end business finance responsibility with a focus on Business Impact, Compliance, Process Excellence, Investor decks, and Finance Reporting & Insights.
Strong support professional with a Chartered Accountancy background.
The role is overseeing financial control, reporting of financial & non-financial performances, fund & liquidity planning, banking relationship with Banks, NBFC's & Fintech and responsible for bringing financial discipline by making sure that the flow of money is tracked and recorded.
Key Duties & Responsibilities
1. Managing and reporting on Liquidity & Fund flow on daily basis based on Domestic & Exports debtors realization, Working Capital limits, Export Packing Credit limit with banks (Fund based & Non-fund based), Dealer financing, Reverse Factoring and Fintech Invoice & PO based discounting.
2. Preparation of Annual Budget, Monthly & Quarterly Forecast, Budget vs Actuals, Banks Data requirements, Query Resolution with Promoters & banks.
3. Ensuring timely sharing of the reporting requirements and adding value to business by presenting EBITDA levels, Buyer Level Profitability, Product Level Profitability along with recommendation of cost optimization across different process of production.
4. Circulating monthly MIS reports of factory performance comprising output analysis, efficiency and wage analysis, cost per pc analysis and analysis breakdown at process (Cutting, Stitching & Finishing) level.
5. Leading the accounting and taxation team, overseeing the compliances of Indirect & Direct taxation, RBI regulation, FEMA guidelines, & Companies Act 2013, ensuring accounting as per GAAP, review and recommendation on annual financial statements.
6.Assist the overall strategy for launching new business vertical "Advance Technical Textiles" including preparation of an overall business plan, working on target operating model & pricing model for the new business vertical.
7. Working with supply chain & commercial team to formalize documentation process, optimizing cost of carrying imports, seamless export process as per DGFT & Customs laws.
8. Repository of updated info on the Company – specifically Corporate Presentations, Company profile, etc.
Role of Managing various financial Budgets along with ownership of consumer finance management role at company level. Analysis of Profit and Loss account and recommendation for higher Profitability and Cost rationalization.
Key areas of responsibilities
1. Role of managing various financial budgets at category level, Product level and SKU level.
2. Reporting of Gross Profit Analysis on monthly basis at SKU Level.
3. Pricing of Consumer durable product and SSD product along with competition analysis.
4. Analysis of incentive given to FIS (Friends in Store) on extensive excel models.
5. Preparing Consumer finance models (EMI & Non-EMI) on various products and getting Banks and NBFC on board with best in industry subvention rates and affordability.
6. Approval of pricing for cloud tail and online sale of Sanyo products.
Key areas of Responsibilities
1.Performed financial modeling: Monthly/Quarterly/Annually (A.O.P) planning & forecasting of revenues & expenses, trend analysis and tracking of variances against actual.
2.Product-wise profitability Reporting, Analysis & its post-launch analysis.
3. Pre & & post-launch validation of new schemes & product costing.
4. Developing Pricing Strategies & Competition analysis: set base prices and develop discount programs, assist in creating promotional schemes, compare prices set by competitors and set target buying prices for purchase function.
5. Preparing and presenting a comprehensive MIS dashboard along with a CFO deck comprising all the financial and business information required to report at the board level.
6. Accounts Receivable Management and compliance of credit policy by distributors.
7. Review of all Balance Sheet (Microtek LED) schedules on monthly basis and get the open items resolved, ascertain & highlight the risk (if any) to FP&A head & CFO for appropriate action.
8. Handled the complete GST implementation process of Microtek applicable from July 2017 onwards
9. Ensuring the optimum utilization of ITC available of GST so as to minimize the cash payment of GST.
Key areas of Responsibilities
1. Ensuring the compliances of Reserve Bank of India & FEMA regarding remittances of foreign exchange for import purchase.
2. Opening of letter of credit with banks for the payment of import purchases.
3. Preparation of necessary legal documents required for making payment to foreign suppliers through telegraphic transfer.
4. Maintaining regular coordination with foreign vendors.
5. Appoint and coordinate with the forwarding agency.
6. Appoint and coordinate with the Custom House Agent (CHA) & Clearing Agency.
7. Handling & Managing working capital finance requirements through CC & OD limits.
8. Daily recording of transactions in Tally ERP.
9. Preparation of Annual & half-yearly Financial Statements.
Major Audit handled
1. Internal audits of Future group (Pantaloons stores Delhi Ncr)
2. Landmark Group (Lifestyle Stores Delhi Ncr)
3. CFA audit of MSD Pharmaceuticals
4. Concurrent audit of India’s Top banks (HDFC & Standard Chartered)
Financial Planning & Analysis
Budgetary Control
Bank & NBFC Partnering
Financial Modelling & MIS
Direct & Indirect Taxation
Business Finance
Leadership
People Management
Microsoft Excel
Microsoft Power Point
SAP
TALLY ERP
QLICK SENSE
GST CERTIFICATION PROGRAMME, CA BIMAL JAIN
STARTUP ECOSYSTEM
CAPITAL MARKET
MSME
Date of Birth : 29-Jan-1991
Passport : Available
Hobbies : Writing
SPECIAL COURSE ON CAPITAL MARKET, CA VIJAY MANTRI, FOUNDER JRL MONEY
GST CERTIFICATION PROGRAMME, CA BIMAL JAIN