Nikhar Jajoo

- - www.linkedin.com/in/nikhar-jajoo MANAGEMENT CONSULTANT Gurugram,IN Data-driven Management Consultant | MBA & Mechanical Engineer with 6+ years of experience in client-facing roles, process optimization, and technical problem-solving. Expertise in Power BI, Advanced Excel (VBA, Power Query), Gen AI tools, and statistical analysis to optimize processes, automation solutions, and deliver actionable insights. Proven success in crossfunctional collaboration, stakeholder engagement, and business analysis to drive client satisfaction and enhance efficiency. WORK EXPERIENCE Gurugram, IN | June 2019 - Feb 2025 Deloitte USI | Consultant Achieved a 40% improvement in compliance accuracy that mitigated risks & an 80% reduction in supplier onboarding time by implementing advanced Excel & automation in process audits. Developed robust automated reporting systems in Excel (VBA, Power Query) to effectively track requisition costs & KPIs, saving over 30 hrs/month for senior leadership. Engineered an Excel VBA chatbot that resolves 70% of FAQs with 90% accuracy, cutting resolution time by 45% & saving 8 hrs/week. Delivered impactful quarterly performance reports that optimized resource allocation & workload distribution. Successfully deployed SAP Ariba Guided Buying, accelerating requisition approvals by ~30%. Collaborated with senior stakeholders to design digital transformation roadmaps, including AI-driven tools for operations optimization. Created dynamic, multi-tiered approval flows that shortened lead times by 30%, ensuring timely payments. Developed an automated contract migration process for 7,000+ legacy contracts, saved 2,500+ manual hours & ensured compliance. Generated a data visualization dashboard that provided actionable insights, reducing decision-making time by 50%. Engineered custom reports in SAP Ariba-tracking multiple key performance indicators (e.g., cycle times, invoice reconciliation, vendor compliance)- that drove a 25% to 35% boost in overall process efficiency and empowered robust, data-driven decision-making. Dazzling Usha Brass Products | Assistant Operation Manager Jamnagar, IN | June 2016 - May 2017 Negotiated partnership with 3 manufacturers, to outsource parts production, reducing in-house production costs by 25% and achieving significant cost savings. Orchestrated supply chain transformation for industrial components, reducing production costs by 25%. SKILLS Core Competencies: Process Optimization | Risk Mitigation | Operations Management Technical Proficiencies: Advanced Excel (VBA, Power Query) | Power BI | SAP Ariba | Gen AI tools Soft Skills: Cross-Functional Collaboration | Stakeholder Engagement | Team Management | Agile Methodologies CERTIFICATIONS Advanced Excel: Skilled in data analysis, pivot tables, and complex formula development Power BI: Proficient in creating interactive dashboards and visualizing data insights. Advanced PowerPoint Presentation: Experienced in creating impactful presentations focusing on design, infogra,phics and clarity. Tableau (In Progress), SQL (In Progress) ACHIEVEMENTS Deloitte USI Awarded annually -) for excellence in project execution, recognized for consistency, efficiency, and accuracy by senior leadership. Formula Student (FSAE) | Leadership | Innovat4ion Cross-Functional Collaboration: Directed a 33-member team to deliver a competition-ready prototype, coordinating timelines, resources, and technical specifications to meet strict quality and schedule KPIs. Statistical Analysis & Design Optimization: Analyzed chassis performance data using regression models, reducing weight by 26% (38kg to 28kg) to enhance vehicle efficiency, aligning with cost and performance metrics. Cost Reporting and Analysis: Designed and managed the cost report, securing 3rd place in the competition. Operational Agility: Designed the car's outer body for quick assembly, reducing reassembly time to just ~15 minutes. EDUCATION MBA | Operations & Marketing | CGPA: 8.11/10 Bennett University (TIMES Group) | -) Organisational Behaviour and Consumer Behaviour Cornell University | (Exchange program 2018) B.Tech | Mechanical Engineering | CGPA: 8.26/10 Vellore Institute of Techonology | -)