 Successfully leveraged Advanced Excel, Power BI, and SQL skills to drive data analysis initiatives. Created complex Excel models to analyze large datasets, transforming raw data into insightful reports. Developed VBA macros to automate manual tasks, resulting in significant time and cost savings. Utilized SQL to retrieve, manipulate, and aggregate data from relational databases for analysis. Designed and deployed Power BI reports and dashboards, providing data-driven insights to stakeholders. Collaborated closely with cross-functional teams to understand data requirements and business objectives. Conducted thorough data cleaning, validation, and transformation to ensure data accuracy. Implemented data visualization best practices, creating intuitive and informative visual reports. Mentored colleagues in Advanced Excel techniques, VBA scripting, and Power BI utilization. Delivered regular presentations to convey complex findings and insights to non-technical stakeholders. Connecting various data source to power BI (Folder, files, CSV and Excel). Work on Advance Excel & Power BI to carry out any type of Project analysis. Deployment of Dashboard and Maintenance of power BI Services for Various Client within workspace. Create Management reports in excel that became company standard for recording branch and financial information.  Every day Updating and circulating Multiple Dashboard among Branch and Management and also Analyze Business leak and losses.

 Extract Data from Tableau Server and create report and chart. Work with the KYC Team and Sales force team to follow up on data issues. Very Good in VBA programming for Excel. Developed VBA macros to automate manual tasks, resulting in significant time and cost savings. Created User-Friendly decision Excel templates and dashboards for data Visualization. Built Automation framework for report to reduce processing time. Analyze data and create information in the form of reports to provide proactive and preventative support models across the Program. Understand adhoc requirement basis on call logged. Creating Dashboard in power BI as per client Requirement. Deploy reports in Power BI services. Coordination with DVP and with counselor team for various analysis and requirement. Creating and updating agents productivity report in excel and Share MIS to the seniors. Sale’s team Growth Report, all sales report Monthly, Quarterly & yearly wise. Business Loss/leakage Analysis. Automate all possible Daily basis Report  Update and monitor tracker in daily basis or weekly basis  Weekly prepare the dashboard. Maintain Overall Growth KPI (Monthly Growth Rate). Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.

 Receiving and downloading data from different - different sources cleaning and formatting data using by EXCEL. Creating and updating agents productivity report in excel and Share MIS to the seniors. Maintain Overall Growth KPI (Monthly Growth Rate). Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data. Updating Data Tracker and MIS Reports on daily and weekly basis. Preparation of Automating Tools to other Teams using VBA & Excel. Data Visualization in Every Quarter and send it to Client. Ensure deliverables (Daily, Weekly & Monthly MIS Reports) are prepared to satisfy the project requirements cost and schedule. Coordination with Marketing, finance and with counselor team for various analysis and requirement.

 Possess good analytical and problem solving skills. Communicate effectively with the team. Very good in MS Excel (Hlookup, Vlookup , Index ,Match Pivot Table & Chart, data Validation & Conditional Formatting) Ensure deliverables (Daily Productivity Reports) are prepared to satisfy the project requirements cost and schedule