RATAN BHARTI

Key Result Areas:
ERP Implementation - Microsoft Dynamics 365 Business Central & NAV 2016:
• Leading ERP implementation initiatives, covering requirement analysis, system design, testing, user training, and post-go-live support.
• Facilitating process mapping, coordinating data migration, and enabling integration across financial and operational modules to
ensure seamless system adoption.
• 3 Years historical data recording and data migration from Tally ERP 9 to Business central D365 ERP

SOP Development & Process Optimization:
• Designing and implementing Standard Operating Procedures (SOPs) to standardize accounting, costing, and reporting processes
across departments.
• Strengthening internal controls, enhancing process transparency, and improving operational efficiency through structured workflows.

MIS Development & Financial Reporting:
• Developing and automating Management Information Systems (MIS) to support monthly performance reviews, financial
monitoring, and business reporting.
• Ensuring accuracy, consistency, and timely availability of key financial data for effective management decision-making.

Power BI Reporting & Data Visualization:
• Creating interactive Power BI dashboards highlighting revenue trends, cost structures, and key performance indicators for
leadership teams.
• Integrating data from multiple sources to generate real-time insights and support strategic decisions.

Advanced Excel & Financial Analytics:
• Utilizing advanced Excel tools including Pivot Tables, Power Query, Macros, and complex formulas to automate reporting and
enhance analytical capabilities.
• Developing financial models, cost sheets, and analytical dashboards to support business planning and operational decisions.

Analytical Review & Decision Support:
• Providing data-driven insights to support business planning, performance improvement, and strategic initiatives.
• Identifying trends, inefficiencies, and opportunities to strengthen financial performance and operational outcomes.

• Developed and implemented MIS for location-wise and cost-centre-wise profitability and expense reconciliation.
• Oversaw financial control in purchases, budgeting, and cost optimization.
• Monitored accounts payable and receivable, ensuring timely collections and payments.
• Followed up with customers on outstanding payments and resolved discrepancies.
• Handled ERP implementation projects, including master data creation and system configuration.
• Finalized accounts, including balance sheet preparation and financial reporting.
• Monitored cash flow, term loan repayments, CC limits, and other financial obligations.
• Verified supplier payments by age and amount, ensuring accuracy and compliance.
• Liaised with banks, financial institutions, and regulatory authorities including income tax, sales tax, and excise departments.
• Conducted regular bank and party reconciliations.
• Scrutinized salary and wages sheets for accuracy and compliance.
• Filed e-TDS, VAT, Entry Tax, CST, Income Tax, and Service Tax returns.
• Coordinated with auditors for account finalization and audits.
• Prepared and issued TDS certificates, managed stock statements, and coordinated site and godown stock inspections.

 * GSTR-2 and GSTR-2A Reconciliation and communication with parties for Input tax Related Issues for
Indian operations GSTR 3B return with consultants
 * Coordination with Bank for financial Issues
 * CC limit renewal lessoning’s
 * Bank Stock Audit and co ordinations.
 * Preparation of monthly Profit & loss Account and variance analysis
 * Budgeting and Finance data preparation for board meeting presentation
 * Supervision and management of accounts Team
 *Fixed Assets Register Management
 *Import Purchase Tracking and compliances for import process
 *Fixed assets Capitalization
 *Material Cost Variance Analysis
 * Cost Actualization analysis of all SKU
 * BOM Cost Analysis and Customer BOM V/S Actual BOM Cost Validation
 * Development of MIS as required
 *Preparation of Monthly Cash Flow and Actual V/S Projected Cash Flow Analysis
 *Monthly Profit and Loss and analysis
 *Cost controlling and budgetary tools
o Capex Project Funds Management
o Vendor Payments and Management of HYD Plant
o Capex Import Process handling with Import Agent
o Monthly Profit and loss accounts of Various PlantMonthly Cost Analysis Budget V/S Actual Analysis.
o Accounts Payable Reports
 ERP Implementation Projects Implementations
o making of SOP (system process )for Business operation
o making and review of Function requirement documents for ERP implementation
o MIS Report development for New ERP Implementation
o Printable Voucher like, cash, bank, sales, purchase voucher development
o Development of Approval flow and workflow
o Making of Chart of Accounts (General Ledger name and codes)
o set up for customization where we need as per business requirement
o Collection of master data for implementation
o Review and Finalization of Master Data
o Arranging ERP training for Accounts/Commercial/Production Team Team
o Set Up for Philippines Tax Related and Tax Return Report DevelopmenT

Key Result Areas:
• Orchestrated multi-country ERP deployment across India, Philippines, and Sri Lanka for Ice Cream plants, integrating Finance,
Costing, Inventory, Procurement, and Quality modules to streamline operations.
• Finalized financial accounts and ensured compliance with statutory and internal standards.
• Spearheaded financial responsibilities, including cash flow monitoring, CC limit management, term loan repayments & other obligations.
• Reviewed AR/AP reports, resolved discrepancies, and streamlined processes.
• Conducted vendor and customer reconciliations and documented MOMs with stakeholders.
• Followed up with customers on payments and resolved pending issues efficiently.
• Liaised with banks, financial institutions, and internal departments to address financial and operational matters.
• Filed VAT, EWT, and DST returns for Philippines operations monthly and quarterly in coordination with the PHP team.
• Reconciled GSTR-2 & GSTR-2A, communicated with parties on input tax issues, and coordinated GSTR 3B filing with consultants
for Indian operations.
• Managed bank coordination for financial matters, including CC limit renewals and bank stock audits.
• Prepared monthly Profit & Loss accounts, variance analyses, and financial reports for board presentations.
• Supervised and guided the accounts team to ensure accuracy and compliance.
• Maintained the Fixed Assets Register, capitalized assets, and ensured proper depreciation schedules.
• Tracked import purchases, ensured compliance, and managed the import process.
• Conducted material cost variance analyses and cost actualization for all SKUs.
• Validated BOM costs, comparing customer BOM versus actual BOM costs.
• Developed MIS reports and dashboards as per business requirements.
• Prepared monthly cash flow reports and analyzed actual vs. projected cash flow.
• Controlled costs and managed budgets for CAPEX projects, including fund allocation, vendor payments, and import processing.
• Prepared monthly Profit & Loss statements, cost analyses, and budget vs. actual comparisons for various plants.

ERP Implementation Projects:
• Developed SOPs and functional requirement documents for business operations.
• Created MIS reports, printable vouchers, approval workflows, and customized Chart of Accounts.
• Collected, reviewed, and finalized master data.
• Coordinated ERP training for Accounts, Commercial, and Production teams.
• Set up taxation modules for Philippines and India (GST, TDS, etc.), quality modules, fixed assets modules, and CAPEX project tracking.

• Finalized financial accounts and ensured accurate reporting.
• Supervised and managed the accounts team, driving efficiency and compliance.
• Reconciled and controlled material and overheads, identifying discrepancies and deviations in processes.
• Tracked customer sales prices and updated sales pricing records.
• Drafted AR/AP reports, investigated issues, and resolved discrepancies.
• Finalized vendor and customer reconciliations and conducted meetings of minutes (MOM) with stakeholders.
• Followed up with customers on payments and pending issues.
• Monitored daily production reports and material consumption for operational accuracy.
• Managed inflow and outflow of funds, including CC limits, term loan repayments, and other financial obligations.
• Liaised with banks, financial institutions, and regulatory authorities including income tax, sales tax, and excise departments.
• Conducted regular bank and party reconciliations.
• Filed GST returns, managed GST payments, and tracked/ reconciled EWB with accounting records.
• Coordinated sales tax assessments and statutory compliance matters.
• Collaborated with internal and statutory auditors for account finalization and audits.
• Managed preparation and submission of Sales Tax forms and other statutory documentation.
• Coordinated with government departments including DIC, Pollution Control, and others for compliance.
• Prepared monthly Profit & Loss accounts, variance analyses, and various MIS reports.
• Monitored cost centre and profit centre management, budgeting, and financial data preparation for board presentations.
• Managed LC procurement, BOE acceptance, and payment processing.

• Finalized financial accounts and ensured accurate reporting.
• Coordinated with customers to follow up on outstanding payments.
• Maintained excise records and submitted excise returns on schedule.
• Filed online excise returns and prepared for excise hearings.
• Monitored daily production reports and tracked material consumption.
• Supervised cash flow, including CC limits, term loan repayments, and other financial obligations.
• Liaised with banks, financial institutions, and regulatory authorities, including income tax, sales tax, and excise departments.
• Conducted regular bank and party reconciliations.
• Filed returns for Excise, e-TDS, VAT, Entry Tax, CST, Income Tax, and Service Tax.
• Collaborated with auditors for account finalization and audit processes.
• Prepared and issued TDS certificates, sales tax forms, and managed other statutory compliance matters.
• Sent stock statements to banks and facilitated stock inspections at sites and godowns.
• Prepared Income Tax, Sales Tax, and Excise assessment documentation.
• Coordinated with government departments including DIC, Pollution Control, and others for compliance.