Business Intelligence Analyst

Mehak Dhawan

*****.*********@*****.*** 469-***-**** linkedin.com/in/mehakdhawan1/

Results-driven analyst with expertise in data modeling, automation, and business intelligence, committed to optimizing processes and delivering actionable insights. Skilled in utilizing advanced tools to enhance operational efficiency and drive impactful outcomes. EXPERIENCE

CAREINGTON INTERNATIONAL, Business Intelligence Analyst Intern Summer 2023, Spring 2024

• Achieved a 90% reduction in report generation time by automating ETL processes and applying optimized data modeling techniques.

• Analyzed sprint performance metrics in collaboration with Scrum Master and team members, identifying areas for improvement and implementing strategies to enhance team productivity and delivery velocity.

• Developed custom Power BI dashboards and reports using DAX to visualize key performance indicators (KPIs), delivering actionable insights to stakeholders and improving project deliverable efficiency by 10%.

• Gained in-depth knowledge of healthcare and insurance industry processes, regulations, and challenges, significantly enhancing the quality and relevance of my data analysis and reporting WEBER SHANDWICK, Junior Associate, Client Experience Nov 2021 – Jun 2022

• Orchestrated product launch logistics in 6 Indian cities, leading 80 media professionals and generating KPI reports for client impact.

• Coordinated with creative, digital, and client servicing teams to ensure seamless execution of PR campaigns, enhancing brand visibility and securing 30% increased media coverage for client launches. TEACH FOR INDIA, Project Manager Jun 2019 – May 2021

• Founded and spearheaded an educational advocacy club, sensitizing over 40 families to the challenges of learning disabilities and the significance of early intervention, showcasing impactful leadership and persuasive public speaking abilities.

• Designed and implemented progress tracking systems, analyzing student performance data to refine teaching strategies, resulting in a 15% improvement in overall class performance.

ERNST AND YOUNG, Analyst Intern Summer 2018

• Leveraged advanced Excel skills to proficiently consolidate intricate data sets, ensuring accuracy and efficiency in the creation of detailed reports for informed financial analysis.

SKILLS

• Certifications: Certified Scrum Product Owner (CSPO), Project Management by Google, Business intelligence & Data mining- University of Texas at Dallas, Alteryx Foundation Micro-Credentials, RPA Business Analyst Foundation – Ui Path, Advanced Power Bi and Advanced SQL certifications on DataCamp, Climate and sustainability project by BCG

• Tools: JIRA, Power BI, MS Azure Cloud, MS Excel, MS PowerPoint, Tableau, AWS Cloud, Alteryx, Appian, UiPath, Accelq, Power Query, Visio, Snowflake, SQL Server, Databricks, Solver, SAP/HANA, Eclipse, Figma, Mural, LMS, salesforce, SAP ERP, MS Dynamics, Snowflake,, Kinesis, Sagemaker, Redshift.

• Programming Languages: Python, SQL, R, SAS, VBA, DAX, LangChain, MongoDB, Lasso

• Framework and libraries : Splink, Hadoop, HDFS, Hive, Spark, scikit-learn, TensorFlow, PyTorch, Pandas, DuckDB, NumPy, PySpark

• AI Agents: Multi-On, AgentOps, Wordware, Mem0, AWS, Groq, Llama Lounge, Arize AI, Anon

• Knowledge: Neural Networks, Supervised & Un-Supervised Learning, Automation, Predictive & prescriptive Modeling, Agile Development, Scrum, A/B Testing, Statistical Analysis, Data Warehousing, ETL, Requirements Analysis, Operations & logistics analytics. PROJECTS

Enhancing Semiconductor Wafer Data Management and Visualization, Database Engineer

• Supporting the development of a semiconductor wafer database and assisting in the architecture of the database to include a visual GUI. The project focuses on creating an efficient and user-friendly system for managing and visualizing semiconductor wafer data. Individualized Lesson Plans LLM- AI Model

• Engineered an AI model to forecast tailored lesson plans, demonstrating substantial potential for cost reduction (approximately $2000 per month per educator) thereby enhancing the quality of individualized study. EDUCATION AND LEADERSHIP

The University of Texas at Dallas (Nash Leader) – MS, Management Science GPA: 3.7, May 2024 XIM University – BS, Finance and accounts April 2019

Contact this candidate