Piyush Pujari

Motivated finance enthusiast with foundational knowledge in financial modeling and hands-on experience using tools like Excel and Power BI. Eager to contribute analytical thinking and problem-solving skills in an entry-level finance role. Committed to continuous learning and driving data-backed decision-making. Strong team player with a proven ability to work effectively in both collaborative and self-driven academic and project environments.

1. AI-powered financial modeling at HDFC Bank:

Utilized generative AI to enhance forecasting accuracy and predict financial trends, designed and implemented interactive Power BI dashboards to automate and streamline financial workflows, developed dynamic financial models using VBA macros for scalability and efficiency, optimized financial decision-making processes through the advanced integration of AI, Power BI, and VBA 

2.Tata Motors financial model:

Built a financial model for Tata Motors, linking income, balance, and cash flow statements; used scenario analysis, conditional formatting, and pivot tables for forecasting; visualized financial performance and growth opportunities through dynamic analysis; provided actionable insights on potential financial outcomes

3. Larsen & Toubro (L&T) financial model:

Built a detailed 3-statement financial model (income statement, balance sheet, and cash flow statement) for Larsen & Toubro (L&T) Incorporated historical financial data to ensure accuracy and relevance in the model, conducted strategic analysis by projecting future performance based on revenue, cost, and capital expenditure assumptions, and showcased expertise in financial modeling, scenario analysis, and decision-making.

4. Hindustan Unilever financial statement analysis

Analyzed Hindustan Unilever's financial statements, including the income statement, balance sheet, and cash flow; evaluated profitability, liquidity, and cash flow trends using key financial metrics, identified insights into financial performance to support strategic decision-making, and assessed the company's fiscal health through detailed trend analysis.

5. Research report – behavioral finance: 

prepared how psychological biases impact investor decisions and market outcomes, analyzed real-world cases to link behavior with financial performance.

6. Ultratech Cement financial model:

Created a dynamic financial dashboard in Excel tailored for Ultratech Cement's financial analysis needs, utilized tools like Pivot Tables, Charts, Sparklines, and Slicers for interactive data visualization, and summarized critical financial metrics to provide actionable insights for decision-making, enhanced the bank's ability to make data-driven decisions with user-friendly and dynamic reporting.

1. Financial Modeling – Internshala (86%)

 • Foundations of Accounting & Finance (82%) 

 • Excel Mastery for Financial Modelling (Score: 88%)

 • Basics of Financial Modelling Unleashed  

 • Deep Dive into Financial Statements & Data Analysis

 • Advanced Financial Modelling Techniques   

 • Mastering Data Visualisation and Dashboard Creation 

 • AI in Financial Modelling

2. Power BI – Indian Institute of Computer Education 

3. Advanced Excel – Indian Institute of Computer Education 

4. Foundation of Accounting & Finance – Internshala (Score: 82%)

• Strong analytical and quantitative reasoning skills
• Detail-oriented and highly organized
• Comfortable working under deadlines and managing multiple tasks
• Financial markets and investment trends
• Behavioral finance and economic psychology

• Member of Daksham Society, Graphic Era Hill University, helped organize university fests and led a cultural handicraft stall promoting local art
• Led the organization of the Student Exchange Program, facilitating cross-cultural collaboration