Adit Jain

Roles & Responsibilities: ● Worked closely with stakeholder to understand their requirements and design solutions using Excel. ● Used Excel's built-in features and formulas like VLOOKUP, Sum if, Average, concatenate, Pivot tables to create user-friendly spreadsheets that automate calculations, data analysis, reporting, and other tasks. ● Ensure data integrity, accuracy, and consistency by developing robust data validation formulas. ● Created interactive dashboards, forms, and user interfaces using Excel's features like data validation, conditional formatting, and user input controls.

Roles & Responsibilities: ● Analyzed complex excel files, understood business requirements, and identified key insights and trends using Power BI. ● Worked on Power BI objects like Reports, Dashboards, Power Views, Creating Workspaces, Sharing dashboards, Row Level Security (RLS). ● Created Data Models using Data Warehousing concepts such as Dimensions, Fact, Star schema and Snowflake schema. ● Used DAX queries to implement the stakeholder’s requirements ● Monthly Salary, MIS Report, Student Data Report in Excel & Power BI, Banking Work and Reconciliation.