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
Amazon Redshift
Python Programming
Excel Functions
Statistical Analysis
Data Mining
ETL Processes
Data Analysis
Data Visualization
Data Reporting
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 -