MS Excel
Anuron Sarma
Business Analyst
Bokaro Steel City,JH
Summary
Dedicated and results-driven Business Analyst with a proven track record of leveraging analytical tools such as SQL, Tableau, and MS Excel to extract actionable insights from complex datasets. Proficient in data visualization techniques, adept at translating findings into strategic recommendations to drive business growth and operational efficiency. Effective communicator and collaborative team player, committed to delivering high-quality solutions that align with organizational objectives.
Overview
3
3
years of professional experience
3
3
Languages
Work History
Business Analyst
Vedanta
09.2021 - Current
- Identified patterns and trends in large data sets and provided actionable insights to improve efficiency and reliability of equipment.
- Improved business processes by analyzing current practices and recommending optimization strategies that resulted in a significant reduction of specific power consumption by 3 units per ton of production, yielding monthly cost savings of 32 lakhs.
- Acted as a team leader in group projects, delegating tasks and providing feedback. Thereby got awarded the Director's award for successful completion of cost-saving project.
- Skilled at working independently and collaboratively in a team environment.
- Resolved problems, improved operations and provided exceptional service.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Increased efficiency in resource allocation by conducting detailed business requirements analysis.
- Enhanced company-wide decision-making by developing comprehensive reports on key performance indicators.
- Analyzed data to identify root causes of problems and recommend corrective actions on both equipment maintenance and production unit.
- Performed gap analysis to identify areas of improvement.
- Enabled data-driven decision making with advanced analytics tools, generating valuable insights for the organization.
- Reduced operational costs through thorough data analysis and implementing cost-effective solutions by implementing alternative raw material in production line.
- Executed analysis of risks and identified risk mitigation strategies mainly in the field of plant safety and safety KPIs.
- Optimized workflow processes to enhance overall productivity and achieve operational excellence.
Education
B.Tech - Electrical Engineering
04.2001 -
Intermediate - Science
04.2001 -
HSLC - High School
04.2001 -
Skills
Team building
Trend Data Analysis
Forecasting and planning
Workflow Analysis
Microsoft Excel Mastery
Database Management
Problem-solving aptitude
Project Management
Process Improvement
Data Analysis
Interpersonal Communication
Accomplishments
- Awarded the Director's Award for commissioning cost-cutting project, saving around 32 lakhs per month.
- Earned the Champions club Award for documenting, redesigning and improving business processes dealing with SOP/SMP, JSA and SI.
Software
SQL
Tableau
Python
Timeline
Business Analyst - Vedanta
09.2021 - Current
Assam Engineering College - B.Tech, Electrical Engineering
04.2001 -
Jagannath Barooah College - Intermediate , Science
04.2001 -
Don Bosco Higher Secondary School - HSLC, High School
04.2001 -