Summary
Overview
Work History
Education
Skills
Accomplishments
Technical Profile
Timeline
OperationsManager
Nishant

Nishant

Business Analyst I
Bengaluru

Summary

Results-driven Business/Data Analyst with 7 years of experience in data analysis, business intelligence, and project management. Utilizes data to drive strategic decision-making and improve business outcomes. Designs and implements data models, manages complex projects, and optimizes processes for enhanced performance. Strong communication skills and adept at stakeholder management. Dedication to leveraging data-driven insights to support organizational goals and foster growth. Seeking a senior role to apply extensive experience and analytical skills in contributing to the success of a dynamic organization.

Overview

7
7
years of professional experience

Work History

Business Analyst I - Stores Finance

Amazon
06.2022 - Current
  • Financial Management and Reporting: Oversee P&L creation, controllership, and financial reporting; drive initiatives to improve profitability and identify areas for enhancement within P&L line items.
  • Data Analytics and Forecasting: Develop and maintain financial models for forecasting, analysis, and reporting on key metrics, providing actionable insights to guide strategic decisions.
  • SQL Query Optimization and Data Management: Write and optimize complex SQL queries for data manipulation, transformation, and aggregation to enhance performance and efficiency. Design and manage ETL processes for accurate data integration.
  • Consulting and Cross-Functional Collaboration: Act as an analytics consultant for cross-functional teams, working closely with Business Analysts (BA), Business Intelligence Engineers (BIE), and partners to translate data needs into robust solutions and drive business strategy.
  • Data Warehouse and Visualization: Architect, build, and maintain scalable data warehouse solutions; create and automate visual dashboards and reports using QuickSight, Redshift, Athena, and Spark. Developed a data model to optimize Shipcost through Unit Per Box (UPB) metrics, improving cost efficiency.

Business Analyst - Category Management

Amazon
01.2020 - 05.2022
  • Directed weekly, monthly and ad-hoc reporting to inform 30+ business stakeholders in decision-making, built automated dashboards which helped save ~60 man-hour/week
  • Have handled end to end data and business performance reporting during Amazon India's sale events like Great India Festival (Diwali Sale) for Home Improvement and Sports retail category
  • Contributed programs like BxGy offers and Essentials SSD coverage improvement, by collaborating with the OpEx team, conducted pre- and post-launch analysis, providing key insights to leadership for strategic decision-making.

Subject Matter Expert

Amazon
08.2017 - 12.2019


  • Analyzed business problems, identifying root causes and developing robust solutions, collaborated with business and technology teams to build insightful analytical solutions
  • Identified areas where operational efficiency can be improved through automation and implemented those enhancements
  • Executed standard, small-scale projects or assigned components of a larger project to improve processes, using tools for reporting to achieve quality metrics

Education

B. Tech - Computer Science

Institute of Engineering And Industrial Technology
Durgapur, India
04.2001 -

Skills

SQL/PostgreSQL

Accomplishments

  • Received CFO-level appreciation for innovation, recognized in Amazon India's celebration of Finance Excellence awards for H1 2024.
  • Achieved top-tier grades in annual reviews for the past 7 years, consistently surpassing Amazon's high-performance standards for the role and exceeding expectations.
  • Honored with multiple "Star of the Month" and "Extra Mile" awards for exceptional performance, demonstrating a strong commitment to delivering results and a proactive approach to challenges.
  • Conducted technical interviews for Business Analyst hiring at Amazon, playing a key role in evaluating and selecting top talent and contributing to the team’s overall success.

Technical Profile

  • SQL (MySQL, Oracle, PostgreSQL)
  • Microsoft Excel
  • Tableau
  • Power BI
  • Python

Timeline

Business Analyst I - Stores Finance

Amazon
06.2022 - Current

Business Analyst - Category Management

Amazon
01.2020 - 05.2022

Subject Matter Expert

Amazon
08.2017 - 12.2019

B. Tech - Computer Science

Institute of Engineering And Industrial Technology
04.2001 -
Nishant Business Analyst I