Business Analyst Intern
CurrentImplemented a comprehensive MIS system, integrating data from various sources to generate accurate and timely reports, reducing reporting time by 30%.• Prepared regular and ad-hoc reports to provide management key performance indicators (KPIs) and insights, enabling data-driven decisions.• Utilized SQL Server to extract data from SAP HANA, for performing advanced queries, joins, and aggregations for in-depth analysis of Finance, Sales, and Insurance data.• Extensive SQL Querying for Data Analysis and wrote, executed, performance tuned SQL queries.• Created engaging data visualization reports such as Funnel Charts, Maps and Water Fall charts using Power BI, facilitating easier decision-making across departments.• Analyzed marketing campaigns, optimizing ad spend, and providing insights that led to a 15% increase in lead conversion rates and a 10% decrease in customer acquisition costs.• Analyzed retail store sales data and demographic information to determine the best locations for opening new stores and service centers.• Created heat maps to visualize areas with high foot traffic, income levels, and customer potential.
