Pranil khandelwal

Operations Associate

Bengaluru, Karnataka, India4 yrs 7 mos experience

Key Highlights

  • Proficient in SQL and data visualization tools.
  • Experienced in developing complex Excel models.
  • Strong ability to translate data into actionable insights.
Stackforce AI infers this person is a Data Analyst with expertise in E-commerce and operational efficiency.

Contact

Skills

Core Skills

Data AnalysisSqlStakeholder Management

Other Skills

PythonMicrosoft Power BIMicrosoft ExcelMySQLPower BIPython (Programming Language)

About

As a Transportation Analyst at Amazon, I leverage my skills in data analysis, SQL, and Power BI to gather and analyze business requirements, translate them into actionable insights, and present findings and recommendations to senior management. I have over 1.5 years of experience in this role, where I have developed complex Excel models for data analysis, forecasting, and trend identification, and created interactive dashboards and reports to visualize key metrics and KPIs. I am also proficient in Python programming, which I use to extract and manipulate data from databases, ensuring accuracy and completeness for analysis. Additionally, I have experience in developing and maintaining Excel-based reporting templates to track key performance indicators (KPIs), financial metrics, and operational data. My goal is to contribute to continuous improvement initiatives by identifying areas for process optimization and implementing data-driven solutions.

Experience

4 yrs 7 mos
Total Experience
2 yrs
Average Tenure
7 mos
Current Experience

Meesho

Operations Analyst

Sep 2025Present · 7 mos · Bengaluru, Karnataka, India

SQLPythonData AnalysisMicrosoft Power BIMicrosoft ExcelMySQL

Amazon

Transportation Analyst

Jul 2023Oct 2025 · 2 yrs 3 mos · Bengaluru, Karnataka, India · On-site

  • collaborated with cross-functional teams to gather and analyse business requirements, translating them into actionable insights
  • o Utilized SQL to extract and manipulate data from databases, ensuring accuracy and completeness for analysis.
  • o Developed complex Excel models to perform data analysis, forecasting, and trend identification,
  • o Created interactive dashboards and reports using Power BI, enabling stakeholders to visualize key metrics and KPIs.
  • o Conducted ad-hoc analysis to identify trends, patterns, and opportunities for process optimization.
  • o Presented findings and recommendations to senior management, facilitating data-driven decision-making.
  • o Contributed to continuous improvement initiatives by identifying areas for automation and efficiency enhancement.
  • o Developed ETL using Amazon Data net for faster data performance and publish the same to Tableau Server
  • o Optimized SQL scripts to improve the efficiency of the database and was involved in the performance tuning for Tableau Dashboards
  • o Building datasets and tables using Big Query and loading data from cloud storage.
  • o Worked on building dashboards with ODBC connections from sources like Big Query/presto SQL engine
Stakeholder ManagementData AnalysisMicrosoft Excel

Ultratech cement

Application Engineer

Jul 2021May 2023 · 1 yr 10 mos · Pune Division, Maharashtra, India · Remote

  • Onsite ApplicatioDeveloped and maintained Excel-based reporting templates to track key performance indicators (KPIs), financial metrics, and
  • operational data.
  • o Designed dynamic dashboards and visualizations in Excel to present complex data in a clear and intuitive manner.
  • o Compiled and analyzed data from multiple sources to generate weekly, monthly, and quarterly reports for management and stakeholders.
  • o Evaluated test results and ensured that construction met the required standards. Prepared and submitted progress reports of work in
  • progress, and modifications while meeting customer requirements. Optimized resources, costs and time to maximize efficiency
  • o Built pivot tables and interactive visualizations to summarize large datasets and highlight key trends for reporting.
  • o Developed Macros and VBA scripts to automate repetitive tasks, streamline workflows, and improve efficiency.
  • o Created professional, data-driven dashboards with slicers, conditional formatting, and charts for decision-making.n Engineer responsible for Quality Checks, Labor Management and Transport

Education

Sandip University

btech — Civil Engineering

Jan 2018Jan 2021

Stackforce found 100+ more professionals with Data Analysis & Sql

Explore similar profiles based on matching skills and experience