AVANISH RAJ

Experience

• 

  Tata Steel

  Jan 2019 - Jan 2019

  Vacational Training Program

  Studied processes and defects of steel making and hot rolling.

• 

  SHRI BALAJI INDUSTRIAL PRODUCTS LIMITED

  Jan 2020 - Jan 2021

  Graduate Engineer Trainee

  ➢ Inter-departmental Coordination: Acted as a pivotal link between the marketing team and various production departments, ensuring seamless communication and understanding of marketing requirements. ➢ Timely Production & Order Fulfillment: Orchestrated daily production plans to meet marketing demands, emphasizing strict adherence to timelines and ensuring all production targets were achieved on schedule. ➢ Upper Management Excel Reporting: Leveraged Advanced Excel to prepare and presented daily production reports to upper management, providing transparent insights into production achievements, challenges, and adherence to planned schedules. ➢ Operational Efficiency Enhancement: Implemented streamlined processes in the production planning and control workflow, contributing to enhanced operational efficiency and improved responsiveness to dynamic market demands. ➢ Continuous Process Improvement and Automation: Proactively reviewed and updated the existing SOPs and reporting system. Voir moins

• 

  JSW

  Jan 2021 - now

  Business Analyst

  ➢ SQL Expertise and Data Management: Proficiently utilized SQL to extract and manipulate data from diverse sources, ensuring seamless integration for analysis and reporting, contributing to data-driven decision making processes. ➢ Power BI Dashboards: Designed interactive Power BI dashboards to orchestrate KPIs and business metrics, including operational & financial metrics tracking across multiple channels (Domestic, International, Corporate, and E-Commerce), facilitating real-time monitoring. ➢ Operational Modeling and Analysis: Leveraged Advanced Excel (Analysis Toolpak, Pivot Tables, Lookups, Functions, Filters, Power Query, Power Pivots) to develop & execute complex operational models for better control over the pelletizing process. ➢ Collaboration with clients: Engaging with clients for requirements gathering and understanding their specific business problems & delivering business solutions and make changes in the dashboards. ➢ Automation and Process Streamlining: Implemented automation solutions in Excel and Power BI, reducing manual effort in routine reporting tasks, ensuring data accuracy, and enhancing overall efficiency in reporting processes. ➢ Python (Pandas) : Data cleaning using Excel and Python (Pandas), Data Analysis and Problem solving Voir moins