Mayank Oberoi

• Providing strategic financial direction & leadership; performing due diligence of company/processes, steering processes transitions, reengineering existing process, reducing tasks involved & making process lean, resulting in significant savings in man hours & overall cost.
• Ensuring compliance with all financial closure activities such as provisional expenditure booking,Inventory valuation, overheads analysis and other month/quarter end closure activities.
• Reviewing and maintaining ledger accounts, financial statements, and regulatory reports.
• Gathering financial data for these reports from various sources; reviewing data from the general ledger, unit reports, and multiple financial systems to ensure accuracy.
• Employing Alteryx to automate manual reports, enhancing efficiency and reliability in the reporting process.
• Navigating complex regulatory environments and maintain compliance while fostering innovation and business growth.
• Built automated workflows using Alteryx Designer for extracting, transforming, loading of large volumes of data from multiple sources into a single repository.
• Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
• Performed code reviews, debugging, optimization and fine-tuning of SQL queries and PL and SQL programs.
• Created dashboards using Excel, Power BI, Tableau, or other visualization tools.
• Maintained records of inspections, tests and investigations for regulatory reporting purposes.
• Analyzed large datasets to identify trends, risks, and opportunities for improvement.
• Designed automated workflows to streamline report generation processes.

• Contributed to the attainment of the company’s goals, objectives, business growth and expansion by providing strategic financial models and developed necessary financial policies and procedures to ensure smooth financial management and controls of the business.
• Presented a true and fair view of the financial position of the company by way of timely preparation of annual reports and ensuring timely analysis of the expenditure on a monthly basis
  to control expenses.
• Conducted in-depth technical research and meticulously analyzed tax positions to deliver holistic tax solutions to clients.
• Provided valuable assistance in litigation and appeals presented to the Income Tax Department,Including appeals to the CIT(A) and the ITAT.
• Played a pivotal role in ensuring compliance with various tax regulations, including the preparation and filing of corporate tax returns, withholding tax returns for both foreign and Indian firms.
• Contributed significantly to the preparation and submission of applications to various tax authorities.
• Liaised with statutory/ internal auditors for timely completion of audits & implementation of audit observations.
• Formulated budgets and conducting variance analysis to determine difference between projected figures & actual expenditure and implementing corrective actions.

• Contributed to government sector projects at PwC, engaging in diverse areas and supporting the PwC team in executing project-related tasks.
• Developed comprehensive project reports, presentations, and other documentation.
• Produced project documentation focusing on Household Sanitation Technologies, Green Financing, Climate Resilience, and R&D in Waste Management.
• Authored sectoral reports summarizing sessions conducted during the Make in Odisha Conclave.
• Performed cost-benefit analysis to evaluate project feasibility.
• Created reports, presentations, and other documentation for stakeholders.
• Developed strategies to optimize operational efficiency and reduce costs.
• Prepared forecasts of future performance based on historical trends.

Led financial due diligence services, encompassing the analysis of Commercial Real Estate (CRE) transactions, taxation considerations, loan sizing evaluations, maintenance of cash flow models, underwriting assessments, preparation of investment summaries, secondary research initiatives, and compilation of lease summaries.

(Gold Medalist)