NIRANJAN KASIRAJAN

Associate Consultant

Hash Management Services LLP

Jun 2024 - Present

Analyzed sales, financial, and operational data using MS Excel and SQL to support data-driven decision-making across client projects (SAB TECH, TVS Mobility, Minister White). Developed and maintained structured reports to track key performance indicators (KPIs) and business metrics. Performed data cleaning, validation, and transformation to ensure accuracy and consistency of datasets for analysis. Identified trends, patterns, and inefficiencies in business data, providing actionable insights to improve performance and operations. Automated routine reporting processes in Excel to reduce manual effort and improve efficiency. Analyzed year-over-year (YoY) sales and operational data to identify growth trends, performance gaps, and improvement opportunities. Compared previous year vs current year performance to support strategic planning and business decision-making. Developed detailed sales performance reports to track revenue, volume, and customer trends across business units. Monitored and analyzed machine uptime and downtime data to improve operational efficiency and reduce production losses. Evaluated purchase and procurement data to optimize cost, supplier performance, and inventory levels. Analyzed quality metrics (rejections, defects, rework) to identify root causes and support continuous improvement initiatives. Tracked and reported maintenance performance, including preventive and breakdown activities, to improve equipment reliability. Assessed transport and logistics data to improve delivery timelines, reduce delays, and enhance supply chain efficiency. Performed data cleaning, validation, and transformation to ensure accuracy and reliability of business reports. Automated recurring reports using MS Excel to improve reporting efficiency and reduce manual effort. Designed and developed interactive Power BI dashboards to visualize sales, financial, and operational performance. Integrated data from multiple sources to create real-time and dynamic reports for stakeholders. Enabled business users to make informed decisions through clear data visualization and KPI tracking. Collaborated with cross-functional teams to understand business requirements and translate them into data-driven solutions. Provided insightful analysis and recommendations to support strategic and operational decision-making. Ensured data accuracy and reliability through regular validation and quality checks. Applied Pareto analysis (80/20 principle) to identify major causes of defects, downtime, and performance issues. Utilized 7 QC tools (Pareto chart, cause & effect diagram, histogram, control chart, check sheet, scatter diagram, flowchart) for root cause analysis and problem-solving. Implemented 5S methodology to improve workplace organization, safety, and operational efficiency. Identified improvement opportunities leading to cost reduction through process optimization, waste elimination, and better resource utilization.