Pratik Lahoti Email & Phone Number

Pune, Mh, In

Hyderabad, Telangana

Senior Consultant @ Yavica, leading the functional consulting team to deploy Microsoft D365FOE, for large corporations. Responsibilities include taking a lead role in Project and resource planning, Requirement’s definition, Fit Gap Analysis, Design, Configuration, Data migration, Testing and Training through the full cycle of a project for Flex Property ISV. After sales support for European and Australian client.Solution Design inputs for ISV's development team. CRM and back office ERP integration.Business Development for niche software products.

India

Role: LEC Controller LEC controller deals with financial reporting for the Malls. Currently managing 3rd party mall The Pavillion Mall.• Monthly income and Balance-sheet reporting.• Commentary on cost/revenue deviation based on budgets and forecast.• New projects revenue/cost predictions based on consumer demographics.• Reporting to fund manager for long term projects viability based on DCF techniques.• Validation of Revenue Numbers Month on Month basis based on external reporting factors.• Analysis of various key indicators to ascertain Revenue of the stores.• Oversee MIS function with PE investors and Internal management.• Oversee of month end closure functions.• GST returns.• Formulation of internal controls.• Expense budgeting and Profit forecasting.• Aid in Statutory Audit.• Aid in Internal Audit.• Three-way analysis for brands performance.Role: SDLC expert Lakeshore India is pre-dominantly into Owning, Operating and Managing Retail Malls across India.• Requirement analysis  Understanding business practice and working with the development team based on Agile Methodology • Oversee implementation processes for Business CRM, Revenue calculation, MIS reporting, Quant reporting.• Integration of banking systems with ERP.• Integration of Whatsapp for business and ERP.• Workflow setup for Expense-side tracking based on budgets.• Creation of a new budgetary approval matrix within the ERP for complex scenarios involving Sub GL and Group GL’s value.• Implementation of mobile apps for better control of transactions approval.

Pune, Maharashtra

Working on requirement gathering, gap analysis.Implementing and suggesting changes to existing business processes based on industrywide best business practices.Data manipulation and validation as required by system for migrating transactions from legacy ERP.GL migration for Personal and General Ledgers.Post go live support for clients ranging from Training gaps, data issues and reporting requirement.To liaise between developers and users for data fixes and testing of add on utilities provided to client.Intensive working knowledge of AR, Property Management, Inventory management, Asset Management, Procure 2 Pay, Budgeting and forecasting. Facilities Management. Yardi Mobile Apps.Functional expertise of interfaces between Oracle and Yardi Voyager (ERP based on MSSQL)Product enhancement guidance and testing for the same.Proactive issue resolution.Working with development team on newer functionalities based on client requirement.Effective escalation management.Projects🡺 Emaar Properties, Better Homes, Majid Al Futtaim, ADNP (Abu Dhabi National Properties), Mall of Qatar.

Hong Kong, Hong Kong Sar

Internal Audit officer for rough diamond business heading audits and inventory control for different branch offices across South East Asia.Designed one stop solution for intercompany transaction, accounting and goods movement considering 13 different data points. This web based solution provided different centres with realtime information about procurement cost from group affiliates working in Japanese Keiretsu style setup.Core team member for initialization, setup and execution of tailored ERP solution from Mphasis.

Core team member for the implementation of SAP FI module for the firm. Providing suggestion on design of BRD based on existing processes in place from Legal entity controller’s point of view.Identifying relevant data set to be used in new system, drawing comparatives from other regions usage.Blackbox testing to check the accuracy of the data extracted from reporting tool.GL migration from Regional SAP toolset to Corporate books.Providing coverage during critical business days namely for the following: -Unnatural analysisSpot v/s ABS analysisCorporate org monitoringFails and sensitive’s analysisP & L analysis based on accepted level of variance identifying and obtaining commentaries from LOB and reporting to onshore counterparts.Obtaining projected revenue and expense numbers @ LOB level on monthly basis and drawing three-way comparison between estimate, pre-close and post close. Understanding reason for change and reporting the same.Capital hedging for LE based on their exposure.Specific LOB FX trade-out based on PL exposure.General Ledger certification and substantiation (forms basis for SOX audit)Monthly and quarterly returns namelyFFIEC09 - Countrywide exposure reports for US banksFR2314 – Financial information such as Balance-sheet, Revenue statement, Change in Equity etcME03 – Foreign currency exposure with third party for 10Q reportsFC02 – Unnatural balances for 5 major currencies.FATCA – Reporting of balances for LE for accounts/investments held in foreign currency/foreign regions incorporation. Equity Pick upAccrual bookingConsolidations of financial statement of key entities based on ownership pattern, Elimination of intercompany transaction, ascertaining minority stake value.Analysing reference data requirement of business using BO (business objects-SAP based reporting interface)

Mumbai, Maharashtra, India

AuditTaxationPersonal income tax.Presentation on behalf of client for Tax plenaries.

Chartered Accountant, Taxation And Audit

Bachelor Of Commerce (Bcom), Accounting And Finance