​ ​ ​ linkedin.com/in/ishantraghav/ Technical Skills Languages &amp; Databases: Python, SQL, MySQL, Data Analytics &amp; Visualization: Power BI, Advanced Excel, Business Analysis Business &amp; Data Insights: Data Analysis, Strategic Decision-Making Experiences Management Information System Executive​ October, &ndash; Present Paydash Noida, Uttar Pradesh ●​Managed and organized company data, ensuring accuracy and accessibility ●​Built and maintained dashboards using MS Excel and Power BI for real-time insights ●​Generated daily reports, streamlining data flow and reducing operational inefficiencies ●​Enhanced data visualization, Excel skills, and overall reporting processes for improved decision-making Projects HR Analytics Dashboard | PowerBI, Data Modelling and Cleaning ​ ​ September, ●​Created an interactive HR dashboard to analyze employee attrition, demographics, and performance trends ●​Utilized Excel and Power Query for data cleaning and transformation ●​Developed insightful visualizations to aid HR decision-making and track diversity goals ●​Automated report refreshes and enabled sharing via Power BI service E-Commerce Sales Analysis Dashboard | PowerBI, Data Modelling and Cleaning ​ ​ ​ August, ●​Developed an interactive sales dashboard to track key metrics such as total sales, profit, customer trends, and product performance ●​Used Excel and Power Query for data cleaning and transformation of sales data ●​Created dynamic visualizations with charts and graphs to analyze sales by region, product category, and sales channels ●​Provided insights for strategic decision-making by identifying high-performing products and sales trends ●​Automated report refreshes and enabled sharing with stakeholders via Power BI service Retail Store Sales Analysis Dashboard | Microsoft Excel, Data Modelling and Cleaning ​ ​ ​ August, ●​Developed a comprehensive sales dashboard to track store performance, product sales, and revenue trends ●​Utilized Excel for data cleaning, processing, and creating pivot tables for in-depth analysis ●​Analyzed sales by product category, sales periods, and seasonal trends to identify performance patterns ●​Generated interactive visualizations using charts and graphs to present insights on profit margins and inventory turnover ●​Provided actionable insights to optimize inventory management and improve sales strategies Awards &amp; Achievements SQL (Intermediate) Certificate | HackerRank​ ​ ​ ​ ​ ​ ​ ​ September, ●​Proficient in complex queries, data manipulation (INSERT, UPDATE, DELETE), and optimization ●​Skilled with joins, aggregate/window functions, and handling large datasets SQL (Basic) Certificate | HackerRank​ ​ ​ ​ ​ ​ ​ ​ ​ September, ●​Proficient in SQL fundamentals (SELECT, WHERE, filtering) and basic data manipulation ●​Familiar with aggregate functions, GROUP BY, simple joins, and subqueries Certificate in Advanced Excel | Amity University Online​​ ​ ​ ​ ​ ​ ​ August, ●​Proficient in advanced Excel functions (VLOOKUP, INDEX-MATCH, Pivot Tables) and data analysis ●​Skilled in data cleaning, visualization, automation (macros), and building dynamic dashboards Education Master of Business Administration​ ​ July, &ndash; Present Amity University Online Noida, Uttar Pradesh Bachelor of Computer Application August, &ndash; June, Chaudhary Charan Singh University Ghaziabad, Uttar Pradesh