Nilesh Jagtap

Nilesh jagtap

bookmark on deepenrich
location of Nilesh JagtapPune, Maharashtra, India
Followers of Nilesh Jagtap543 followers
  • Timeline

  • About me

    Finance Professional | Automation Expert | RPA & SAP Specialist | Power BI Enthusiast

  • Education

    • Savitribai phule pune university

      2009 - 2009
      Diploma in taxation law taxation
    • Savitribai phule pune university

      2006 - 2008
      Bachelor of commerce (b.com.) accounting and finance
    • Sikkim manipal university - distance education

      2012 - 2014
      Master of business administration (mba) accounting and finance
  • Experience

    • United metachem pvt ltd

      Mar 2009 - Nov 2009
      Internal auditor
    • Bekaert industries pvt. ltd.

      Dec 2009 - Jan 2018
      Finance officer

      Accounts Payable:- • Responsible for all accounts payable processes.• Ensured input and timely payment of all vendor invoices & employee expenses reports.• Resolves invoice & employee expenses report discrepancy matters.• Assisted in month end, quarter end and year end closing.• Work closely with auditors during yearly audit, tax audit & internal audit.• Suggested process improvements to secure prompt and regular receipts for the organization.• Foreign currency payment import payments (A1), service payment (A2).• Vendor master data updation.• Project (RA Bill) Accounting & its payment tracking.Accounts Receivable:- • Ensure correct accounting of all customer invoices payments in the SAP system• Respond to customer inquiries.• Issuing debit note to customer.General Ledger:- • Perform month-end account closing activities and reconciliations• Support Auditor in conducting internal and external audits.• Perform accounting analyses and reporting to support decision-making purposes.• Prepare GL schedules for audit purpose• Knocking of unadjusted entries.Taxation:- • Monthly E-payment of TDS, GST• Provide information and solve queries during the tax audit.• Preparation and filing of TDS returns. • Ensure timely generation and issuance of Form 16A to supplier.• Support in implement GST.Treasury:-• Liaison with Bank for availing short / long-term loan, Buyer’s credit & ECB loans.• Interest rate negotiation on renewal of existing loans or for new loans. • Funds management. • Fixing foreign exchange rate for import payments & Inward Remittance.• ECB Loan related activity e.g. Form 83 Submission, Monthly ECB Return, Drawdown instruction• Handling all import payment & Export documents(IDPMS) (EDPMS).• Implementation of new product of banker.• Close follow-up with banker for eBRC upload, closure of outstanding BOE, Export Bills, GR waiver• Vendor & Customer LC• Compiling/Review of the daily Financial Position report. Show less

    • Tetra pak

      Jan 2018 - now

      • Design and test automation workflows utilizing tools such as UiPath RPA, VBA Macros, Power Query, Advanced Excel, Power Automate, Power BI, and SAP Gui Scripting.• Implement automation solutions including RPA bots, Excel tools, templates, Power BI dashboards, and MIS reports.• Generate comprehensive process documentation for both processes and end-users.• Supervise the performance of automation project rollouts.• Resolve any issues that arise during project troubleshooting.Monitor project costs, ensuring smooth month-end closure procedures, addressing any issues, and escalating matters to database administrators as necessary.• Take ownership of various robotic processes and automation projects, addressing exceptions and resolving issues as they arise.• Collaborate with cross-functional teams to identify opportunities for streamlining and automating finance processes.• Conduct regular assessments of automation workflows, fine-tuning and optimizing them for maximum efficiency.• Stay updated with the latest advancements in automation technology and continuously seek innovative ways to enhance process automation.• Provide training and support to end users on utilizing automated tools and processes effectively.• Ensure data accuracy and integrity throughout the automation process, performing thorough data validation and quality checks.• Participate in the development and enhancement of company-wide automation standards and best practices.• Engage in regular communication with stakeholders to gather feedback and make necessary adjustments to automation solutions.• Act as a subject matter expert on automation, providing insights and recommendations to leadership for strategic decision-making.• Participate in continuous improvement initiatives to enhance overall business processes beyond automation efforts.• Regularly share insights and success stories related to automation to promote a culture of innovation and process improvement within the organization. Show less Banking Relationship Management:• Establish and maintain productive relationships with banking partners.• Coordinate banking activities, transactions, and inquiries.• Negotiate terms, fees, and services with banks.• Set up and manage online banking portals for seamless transactions.Financial Documentation and Compliance:• Prepare, review, and submit banking-related documentation.• Ensure compliance with RBI regulations, FEMA requirements, and other relevant financial regulations.• Manage statutory audits, internal audits, and group audits.Cash and Liquidity Management:• Monitor daily cash positions and prepare cash forecasts.• Optimize liquidity and working capital management.• Execute forward contracts to manage foreign exchange exposure.Financial Instruments and Transactions:• Handle complex financial instruments such as Cross Currency Swaps, Letters of Credit, and Bank Guarantees.• Manage External Commercial Borrowings and associated return filings.• Execute exchange rate bookings and negotiate interest rates and bank charges.Import and Export Activities:• Oversee Import (IDPMS) and Export (EDPMS) processes and documentation.• Ensure compliance with import and export regulations.Process Improvement and Efficiency:• Identify opportunities for process improvement and automation.• Drive continuous improvement initiatives to enhance controls and eliminate inefficiencies.Financial Analysis and Reporting:• Provide timely responses to queries from internal and external stakeholders.• Prepare and present financial reports related to treasury activities.Investment and Loan Management:• Manage short-term and long-term investments and loans.• Evaluate and execute forward contract bookings.Cross-Functional Collaboration:• Collaborate with internal teams to ensure accurate cash flow forecasting and reporting.• Coordinate with external auditors and regulatory authorities for compliance matters. Show less

      • Senior Finance Operations Information and Automation Expert

        May 2020 - now
      • Treasury Executive

        Jan 2018 - May 2020
  • Licenses & Certifications