Kunal Narula

Technical Advisor

Mckinsey & Company

5 2022 - Current

Analyzing of Data, Strong skills in SQL, Root Cause analysis, Data Sanitization, Troubleshooting Skills, Access management, GitHub scripting
Acted as the primary point of contact for analytics-related support across departments.
Resolved complex issues in Advanced Excel, including pivot tables, VLOOKUPs, data modeling, conditional formatting, and automation using formulas and macros.
Created, modified, and optimized Power BI dashboards to visualize key business metrics, KPIs, and operational trends.
Supported Tableau users with dashboard development, troubleshooting, visual best practices, and performance optimization.
Wrote and optimized SQL queries for data extraction, transformation, cleaning, and reporting across multiple databases.
Provided one-on-one and group training sessions to enhance employee proficiency in analytics tools and self-service BI.
Collaborated with cross-functional teams to interpret data requirements and deliver actionable business insights.
Contributed to the creation of standardized reporting templates and automation scripts to reduce manual work and improve accuracy.
Diagnosed and resolved data integrity and consistency issues, ensuring reliable and high-quality data outputs.
Promoted a data-driven culture by empowering employees to make informed decisions using analytical tools and dashboards.
Conducted ad-hoc data analysis to support business units in strategic planning and operational improvements.
Implemented version control and documentation best practices for analytical assets, including SQL scripts and dashboard designs.
Participated in data governance initiatives, ensuring compliance with internal standards and data security protocols.
Led knowledge-sharing sessions and internal workshops on advanced analytics techniques and new BI tool features.
Worked with API integrations and data connectors to pull real-time data into reporting platforms.
Assisted with data migration and transformation during tool upgrades or organizational transitions.
Evaluated and recommended new BI tools or add-ins to improve reporting efficiency and analytical capabilities.
Responsible for access provisioning for Jira,
Confluence and Salesforce tools
Created detailed reports/Decks for Clients and
McKinsey Leadership for effective stakeholder
management
Supporting 80+ Solutions with technical
competencies in Tableau, Snowflake. Power-BI and Data Analytics,
Leading solution governance activity within
team for firm provided solutions and ensuring
to resolve anomalies related to access and
configuration management
Standardised IT procedures and protocols, streamlining workflows for greater efficiency and ease of use across organization.
Championed continuous improvement initiatives, regularly evaluating existing systems to identify areas for optimization or enhancement.
Enhanced system performance by conducting thorough technical assessments and providing expert recommendations.
Collaborated closely with cross-functional teams, ensuring optimal integration of new technologies and systems.
Facilitated seamless migrations from legacy systems to cutting-edge platforms with minimal disruption to day-to-day operations.
Enhanced team's analytical capabilities with training on latest data analysis tools and techniques.
Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
Improved data governance practices, ensuring compliance with regulatory standards and internal policies.
Produced monthly reports using advanced Excel spreadsheet functions.
Utilized data visualization tools to effectively communicate business insights.
Monitored technology infrastructure against core standards to provide technical assessment and advisory services.