Power Bi Fp A

Ankush Pruthi

New Delhi, ****** • **************@*****.*** • 997******* • https://www.linkedin.com/in/ankushpruthi13 Available Immediately Post Notice Period (Ending September 22, 2025) Profile Summary:

Results-driven Finance Professional with 2 years 4 months of experience in Financial Planning & Analysis (FP&A), Budgeting, Forecasting, Variance Analysis, Power BI Dashboard Creation, and Month-End/Year-End Closings. Expert in leveraging AI applications, including ChatGPT for predictive analysis and automation, to deliver actionable insights and optimize financial processes. Successfully managed €120M+ marketing budgets, delivering 100% on-time financial reports and achieving a 50% reduction in reporting time. Proficient in SAP, Power BI, Hyperion, and Advanced Excel, with proven expertise in financial modeling, automation, identifying risks & opportunities, Financial Reporting, Financial Due Diligence, and delivering data-driven business insights. Recognized for operational process improvements and stakeholder management in the FMCG Manufacturing Industry.

Key Achievements:

Awarded “Coke Super Star FY 2024” for delivering financial excellence and operational process improvements.

Reduced reporting time by 50% for Actual Variance Analysis and MIS reports, significantly improving team productivity and data accuracy.

Prepared and delivered quarterly financial performance reports, driving 10% faster decision-making.

Supported senior management on ad-hoc financial analysis projects, for high-impact leadership decisions.

Utilized AI tools for predictive financial modeling, reducing forecasting errors and enhancing due diligence processes for high-stakes decisions.

Professional Experience:

Genpact India Pvt. Ltd. Assistant Manager Finance and Team Leader 05/2023 – 09/2025 Marketing Finance: Financial Planning & Analysis (FP&A) [Serving Notice Period]

● Served as DME Controller for Iberia (Spain & Portugal), managing €120M+ marketing budgets, budgeting, forecasting Rolling Estimates (Flash RE & Full RE), and FP&A for a global beverage brand, ensuring 100% on-time deliverables.

● Implemented financial strategies and daily budget management controls, driving sustainable growth, improving accuracy, and achieving 10% faster decision-making through timely AI-driven financial insights.

● Directed finance operations, enhancing accounting, budgeting (Annual Business Plan), and internal controls, achieving a 15% faster reporting cycle and increased audit readiness and managed the end-to-end financial reporting process.

● Automated reporting processes, reducing month-end closing time by 40% and improving reporting accuracy and speed using Power BI Automation and AI Integration.

● Conducted variance analysis (Actual vs Forecast) with actionable financial narratives and fallout commentary at YTD/FY levels (EUR & USD), leading month/year-end closings and comparative analysis (flux / Actuals Monitoring).

● Designed and deployed interactive Power BI dashboards and advanced MIS reports, enhancing real-time financial visibility for leadership and enabling agile decision-making with predictive analysis.

● Collaborated with 30+ budget owners to control marketing spending, optimize budgets, and enhance operational efficiency.

● Developed and implemented budgeting models using both Bottom-Up (Zero-Based Budgeting) and Top-Down

(Incremental Budgeting) approaches, enhancing financial control and resource allocation efficiency, reducing unnecessary expenses by 12% and strengthening financial governance through Financial Due Diligence Reviews.

● Managed purchase orders and vendor invoices, eliminating 100% approval errors by introducing a comprehensive PO mapping system.

● Developed and presented budget review decks, aligning financial plans with business objectives in collaboration with Finance Managers (FM) and Finance Directors (FD).

● Managed Accounts Payable & Receivable, including Prior Year (PY) adjustments and five-way reconciliations using SAP, BEX, Power BI, Hyperion, and Advanced Excel tools (Power Query, Macros, Lookups, PivotTables) with 100% accuracy.

● Processed and posted Journal Vouchers (JVs) including inter-company transactions across multiple General Ledgers

(GL), ensuring accurate recording of accruals, revenues, expenses, fallouts, and credit entries in Profit & Loss (P&L) and Balance Sheet (B/S).

● Led and mentored a team of 2 finance professionals, improving team performance, cross-functional alignment, and stakeholder management. Managed 3 Annual Operating Plans (AOP) estimated & finalized Budget.

● Streamlined audit support processes, optimizing data collection, reducing auditor follow-ups by 20%, and standardizing documentation adopted by 5+ team members.

● Delivered ad-hoc financial analyses, supporting management with actionable insights for data-driven decisions and post- adjustment entries in Income Statement and Balance Sheet, incorporating Financial Due Diligence for risk assessment. Skills:

Finance & Accounting Skills: Financial Planning, Reporting & Analysis, Financial Forecasting, Cash Flow Forecasting, Risk Analysis, Budgeting, Actual vs Variance Analysis, Income Statement & Balance Sheet Management, MIS Reporting, Month-End & Year-End Closing, Financial Modelling, Financial Due Diligence, Revenue Recognition (IND-AS 115 / IFRS 15)

Data Analysis, Automation & Visualization Tools & Software’s: PowerBI Dashboard Creation, Advanced Excel, PowerPoint & Automation, Accrual Engine, Salesforce, SAP FICO, S/4 HANA, Fiori, Power BI, Hyperion, Blackline, Evolve, QuickBooks, ODDO, Data Visualizations, ETL Processes

AI, Chat GPT & Automation Tools: AI Applications in Finance, ChatGPT for Predictive Analysis, SaaS, DAX, Grok, Gamma, Napkin.AI, Merlin, Julius, Notebook LM, Machine Learning for finance, GenSpark.AI

Soft Skills: Stakeholder Management, Team Motivation, Leadership, Team Player, Communication, Public Speaking, Detail Orientation, Planning, Coordination & Organizing Education:

Lal Bahadur Shastri Institute of Management Delhi

MBA/PGDM: Financial Management [GPA 7.19/10] 2021-2023 Delhi University Delhi

Bachelor of Commerce: Commerce [GPA 6.10/10] 2017-2020 Certifications:

BE10x AI & Automation Training Program — BE10X 2025

Advanced Excel — Coursera 2025

Power Query Fundamentals — Udemy 2025

Excel Professional Dashboard Creation — LinkedIn Learning 2024

Financial Reporting & Valuation — Udemy 2023

INTEGRATED COURSE ON INFORMATION TECHNOLOGY AND SOFT SKILLS (ICITSS) – INFORMATION TECHNOLOGY — ICAI 2019

ORIENTATION COURSE — ICAI 2019

(ANKUSH PRUTHI)

Contact this candidate