Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Project Delivered
Timeline
Generic

SUMAN KHERA

New Delhi

Summary

A dynamic and results-driven professional with 6+ years of experience in strategy development, market analysis, and client relationship management. Skilled in problem-solving, independent decision-making, and team leadership. Known for enhancing performance through training, monitoring, and employee engagement initiatives.

Overview

8
8
years of professional experience

Work History

Assistant Manager - Data Analyst

WIPRO LIMITED
06.2024 - Current

• Built and maintained automated data pipelines to enable seamless data flow across multiple Google platforms.

• Designed and managed interactive dashboards using SQL, ensuring smooth data visualization and efficient reporting.
• Diagnosed and resolved workflow issues during pipeline failures, minimizing downtime and maintaining system integrity.
• Continuously monitored and updated dashboards to ensure data accuracy and real-time synchronization.
• Collaborated closely with cross-functional teams to streamline data workflows and enhance dashboard performance.
• Designed scalable datasets and developed optimized SQL queries to support data analysis, reporting, and dashboard creation.
• Improved dashboard performance by optimizing Sql scripts and applying best practices in data visualization and user experience.
• Developed and implemented ETL processes to clean, transform, and load data from various sources into Google SQL, ensuring data quality and consistency.
• Conducted root cause analyses for pipeline failures and implemented preventive measures to improve system reliability.

Assistant Manager

BROEKMAN LOGISTICS INDIA PVT LTD.
04.2023 - 05.2024
  • Spearheaded the analysis of historical sales data and market trends, enhancing business revenue by optimizing commodity-focused strategies.
  • Streamlined data operations by employing advanced MS Excel techniques and SQL organization, ensuring high data integrity and accessibility.
  • Delivered strategic insights on over 10 stakeholder projects through SWOT analysis, driving business growth with targeted strategies and KPI assessments.
  • Developed and presented actionable insights via Power BI dashboards, guiding management decisions on commodity focus and optimization.
  • Maintained and ensured the accuracy of import and export classification databases, complying with all regulatory standards.
  • Managed daily operations and fostered strong communication with overseas offices, ensuring seamless international collaboration.
  • Mastered international market dynamics and compliance regulations to enhance documentation processes.
  • Oversaw comprehensive import operations from order processing through customs clearance, coordinating effectively with overseas offices.

Ocean Freight Manager

STARTUP- FLYING SQUAD INTERNATIONAL COMPANY
03.2019 - 03.2023
  • Leveraged advanced MS Excel and SQL tools to enhance data-based reporting, delivering sophisticated data visualizations that informed critical business decisions.
  • Developed dynamic web dashboards and static content, improving stakeholder engagement and data accessibility across the organization.
  • Drove the generation of new business opportunities by analyzing historical data and identifying key trends and insights, significantly impacting company strategy and growth.

Relationship Manager

PKS FREIGHT AND LOGISTICS PVT LTD
12.2017 - 10.2018
  • Acquired and applied key skills in client requirement analysis and efficient delivery, enhancing project outcomes and customer satisfaction.
  • Executed data-based reporting and utilized diverse visualization tools to clarify complex data, supporting strategic decision-making.
  • Engineered dynamic web dashboards and curated static content that significantly improved data presentation and user engagement.

Assistant Manager- Corporate Sales

GRACE RELOCATIONS
04.2017 - 11.2017
  • Worked on creating dynamic web-dashboards and static data-driven content.

Education

B.Sc.(H) - Chemistry

Sri Venkateshwara College, Delhi University
06.2012

Class 12 - undefined

CBSE Board
01.2009

Class 10 - undefined

CBSE
01.2007

Skills

  • SQL
  • Power BI
  • Data Analysis
  • Google Sheets
  • MS-EXCEL
  • Advanced SQL
  • Data Storytelling & Reporting
  • Tableau
  • Python
  • Big Query
  • Looker Studio
  • VBA
  • Data Visualization

Personal Information

Date of Birth: 03/03/92

Project Delivered

IMPORTS DATA PREDICTION VIA COMMODITY/DATES/COUNTRIES (DATA VISUALIZATION)

  • Dataset involves Manufactures and Importers companies name, origin countries, commodities, IEC number, destination in India, Quantity, Cargo value, Customs duty.
  • Data cleaning and data transformation for further analysis.
  • Complex Sql queries with Aggregate functions, query optimization, analytical functions, triggers data integration, making relational database assist in analyzing Import data which provides valuable insights. can focus on top commodities and number of Imports.
  • By Pareto analysis, we have seen the trend of Imports of various commodities with 20:80 rule.
  • Data modelling, Dashboard development, DAX queries, report creation, interactive visualization, custom visualisation found valuable data insights.
  • Trends of largest exporters countries for the logistics company point of view using Map chart, KPI chart, Area chart, line chart.
  • The logistics company can focus on the analysis of data and maximize their revenues by more than 80%.
  • This business case has information of more than 100k Import details on YoY basis Imported in India.

Analytics Tool:  SQL and Power BI.


RETAIL SALES ANALYSIS (DATA VISUALIZATION)


  • Dataset involves, customers data, product category data and transaction data.
  • Leading Retail company would like to understand transaction and historical performance by the customers which will help them to screen the products, frequency of customers and inventory management.
  • Performed SQL complex queries, Relational databases, applying Joins, subqueries, aggregate functions, query optimization, stored procedure, analytical functions and common table expressions for analysis of top product categories, time range of the transactions, percentage revenues.
  • With Key Performance Indicators which can identify the revenue as per the products and budget planning.


Analytics Tools: : Advanced Excel, SQL and Power BI

Analytics Technique: Exploratory Data Analysis & Visualization

Timeline

Assistant Manager - Data Analyst

WIPRO LIMITED
06.2024 - Current

Assistant Manager

BROEKMAN LOGISTICS INDIA PVT LTD.
04.2023 - 05.2024

Ocean Freight Manager

STARTUP- FLYING SQUAD INTERNATIONAL COMPANY
03.2019 - 03.2023

Relationship Manager

PKS FREIGHT AND LOGISTICS PVT LTD
12.2017 - 10.2018

Assistant Manager- Corporate Sales

GRACE RELOCATIONS
04.2017 - 11.2017

Class 12 - undefined

CBSE Board

Class 10 - undefined

CBSE

B.Sc.(H) - Chemistry

Sri Venkateshwara College, Delhi University
SUMAN KHERA