Amardeep
Bangalore
Summary
Dynamic Business Analyst with expertise in Power BI and SQL, driving operational efficiency at Mphasis. Proven track record in data modeling and analysis, enhancing decision-making through insightful dashboards. Adept at client engagement and fostering collaboration across teams, resulting in significant improvements in business performance and strategic planning.
Overview
1
1
Certification
11
11
years of professional experience
Work History
Business Analyst
Mphasis : Client-Hewlett-Packard
Bangalore
04.2024 - Current
- Collaborated with business stakeholders to identify reporting needs and KPIs for strategic alignment.
- Analyzed business processes to pinpoint inefficiencies and recommend operational improvements.
- Employed advanced Excel functions, SQL, and Power BI to derive insights for business strategy.
- Utilized data modeling techniques to forecast future trends supporting long-term planning efforts.
- Engaged continuously in business strategy development, leveraging analytical expertise for informed decision-making.
- Created new metrics for tracking pricing performance and identifying market trends.
- Developed Power BI dashboards and macros to monitor pricing and margin trends across Asia markets.
- Coordinated with IT to enforce BI security protocols, ensuring data integrity and regulatory compliance.
Assistant Manager
Flipkart
Bangalore
10.2023 - 03.2024
- Developed performance reports and dashboards, increasing operational efficiency by 30%.
- Collaborated with cross-functional teams to identify data sources and streamline collection processes.
- Created a Power BI self-service dashboard to measure on-time deliveries, shipment returns, and RTO percentage.
- Implemented interactive visualizations in Power BI to enhance data accessibility for users.
- Analyzed customer behavior, sales trends, and market dynamics for strategic insights.
- Improvised ETL methodologies using SQL to improve data import reliability into Power BI.
Assistant Manager
Xpressbees
Bangalore
03.2022 - 09.2023
- Utilized Power BI to evaluate project data and present findings to stakeholders.
- Developed comprehensive dashboards in Excel and Power BI for immediate data insights.
- Designed interactive Power BI dashboards to track KPI metrics, including delivery and on-time shipment percentages.
- Assisted in migrating legacy BI reports to Power BI, improving report generation speed and reliability.
- Maintained Power BI dashboards for real-time data visualization supporting strategic decision-making.
- Analyzed business processes to identify inefficiencies and recommend operational improvements.
- Monitored key performance indicators to assess progress against strategic objectives.
- Prepared detailed monthly financial reports highlighting key performance indicators and variances.
Strategic Account Manager
Delhivery
Bangalore
12.2018 - 03.2022
- Managed daily operations to improve efficiency and reduce operational costs in fast-paced environment.
- Launched Amazon India AMXL 3P MPS fulfillment centers for furniture and white goods categories.
- Monitored shipped-to-deliver metrics by analyzing FC, FM, MM, and LM verticals.
- Achieved 95% forecasting accuracy and capacity planning for MPS and LA fulfillment centers.
- Fostered long-term relationships with key accounts through regular strategic communication.
- Collaborated with AMZ procurement team to revise commercial terms for EBITDA-positive sites.
- Targeted revenue of 15.6 crore for FY '21 across MPS and LA fulfillment centers.
- Spearheaded adoption of Power BI and SQL tools, providing stakeholders with real-time insights.
Supply Chain Associate
Vaxia
Bangalore
09.2017 - 11.2018
- Established processes for evaluating efficiency and effectiveness of delivery lead times.
- Analyzed courier and transport allocations to ensure fulfillment of committed delivery dates.
- Conducted regular reviews of open orders and dashboards to identify vendor-related delays.
- Developed strong communication channels with vendors and transporters regarding shipment readiness.
Warehouse Service Agent
Fedex
Bangalore
05.2015 - 07.2017
- Planned and allocated space for stock reception, enhancing accuracy and efficiency of unloading, checking, unpacking, repackaging, and quality control activities.
- Maintained inventory levels according to SKUs, customer SAP, and Sterling software, facilitating inward and outward operations.
- Conducted quality checks on boxes, models, and quantities during inbound and outbound activities.
- Generated daily DSR and space utilization reports to improve transaction tracking.
- Managed real-time escalations related to pickups, deliveries, and invoice issues.
- Completed quality-driven management training to implement continuous improvement tools in processes.
- Delivered exceptional customer service to foster client satisfaction and encourage repeat business.
- Cultivated strong client relationships to build trust and ensure loyalty.
Education
Master of Science - Industrial Engineering Management
R.V. College of Engineering
Bengaluru, KA2013
Skills
- Power BI expertise
- SQL proficiency
- Project oversight and coordination
- Client engagement strategies
- Data modeling and analysis
- Operations and Sales data insights
- Business planning
- Data analysis
- Financial modeling techniques
- BI tools expertise
Certification
- Certified Data Scientist from Datamites
Timeline
Business Analyst
Mphasis : Client-Hewlett-Packard
04.2024 - Current
Assistant Manager
Flipkart
10.2023 - 03.2024
Assistant Manager
Xpressbees
03.2022 - 09.2023
Strategic Account Manager
Delhivery
12.2018 - 03.2022
Supply Chain Associate
Vaxia
09.2017 - 11.2018
Warehouse Service Agent
Fedex
05.2015 - 07.2017
Master of Science - Industrial Engineering Management
R.V. College of Engineering