Jagarati Dadhich

Proficiently work on data visualization tools like Tableau & PowerBI to analyze client's performance & generate reports with actionable insights

Collaborate with cross-functional teams to gather data requirements from various sources

Data transformation and cleansing using Alteryx and Power Query

Download the data from various sources including SAP BW through Alteryx using DVW, Theobald and various connectors

Create analytic apps & macros to automate process and create dynamic modules

Create complex measures using DAX or Tableau LOD formulas

Support data privacy by applying Row Level Security (RLS)

• Developed interactive dashboards, and data visualization using Tableau for COO desk to depict and analyze League Tables, Clients ranking, Fees and performance metrics
• Providing debt overview including detailed debt profile and financials
• Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
• Downloaded data from MySQL server through ODBC connectors to consolidate data regarding each debt instruments
• Developed customized reports, summarizing and presenting data in visually appealing format.

• Effectively managed complete project cycle by understanding the client requirements and preparing the insightful and actionable visualization, using data analytics tools like Tableau and Alteryx, based on the company background and client sector
• Deliverable presentation with actionable insights from the analysis to clients/ insurance bankers
• Used transactional level detail to identify the EBITDA adjustments by using Analytical tools for handling large datasets and creating informative visualizations, like cash waterfall, churn/ retention analysis, to assist M&A team
• Increased client satisfaction through thorough analysis of project requirements and delivering high-quality results.
• Mentored junior associates, fostering professional growth and helping them reach their full potential.
• Streamlined operational efficiency in Transaction Services by identifying areas for improvement and proposing actionable solutions under data analytics initiative.

• As a part of Project Advisory team, Research on Changes and their impact on tariff rates in Renewable Power Sector
• Develop renewable energy sector outlook report - SWOT analysis, Porter's 5 forces analysis, Future perspective of current tariff model
• Sensitivity analysis using financial model

• Trained as Database Administrator in Enterprise Solution Unit
• Worked on PL/SQL
• Trained on Oracle Form Builder, Oracle Report Builder and OAF