AVANISH RAJ

Business Analyst

Mumbai, Maharashtra, India5 yrs 10 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Proven expertise in data analysis and business intelligence.
Designed interactive dashboards for real-time business insights.
Implemented automation solutions to enhance reporting efficiency.

Stackforce AI infers this person is a Data Analytics professional with a focus on Manufacturing and Business Intelligence.

Contact

rajavanish68@gmail.com LinkedIn

Skills

Core Skills

Data AnalysisBusiness IntelligenceProduction Management

Other Skills

Advanced ExcelArtificial Intelligence (AI)DashboardData AnalyticsData ManagementData ScienceData VisualizationDecision TreesExploratory Data AnalysisFeature ScalingHypothesis TestingIndustry 4.0Inter-departmental CoordinationInterpersonal CommunicationLeadership

About

Results-driven and detail-oriented Analytics professional with a proven track record of leveraging data & analytical skills to transform complex data sets into actionable business insights. Seeking a challenging role to apply my expertise in data analysis & business intelligence, to drive informed decision-making and contribute to the success of company.

Experience

5 yrs 10 mos

Total Experience

2 yrs 11 mos

Average Tenure

5 yrs 2 mos

Current Experience

Jsw

Business Analyst

Apr 2021 – Present · 5 yrs 2 mos · Mumbai, Maharashtra, India · On-site

➢ 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

SQLPower BIAdvanced ExcelPythonData ManagementData Analysis+1

Shri balaji industrial products limited

Graduate Engineer Trainee

Aug 2020 – Apr 2021 · 8 mos · Rajasthan, India · On-site

➢ 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.