A D Bhavani

• Perform advanced data cleaning and transformation processes to ensure accuracy, consistency, and readiness for analysis.
• Design and develop interactive dashboards and reports in Power BI tailored to each client's specific requirements.
• Create actionable visualizations to provide insights into operational performance, audit scores, and process improvements for diverse clients.
• Work closely with cross-functional teams to understand client objectives and translate them into meaningful data insights.

LOGISTICS ANALYST

• Streamlined logistics operations, leading to a 15% reduction in transportation costs and a 20% improvement in delivery times.
• Analyzed logistics data using SQL and Excel to identify inefficiencies, resulting in a 25% increase in overall supply chain efficiency.
• Managed vendor relationships and optimized inventory levels, reducing stockouts by 30% while maintaining service level agreements.
• Led cross-functional projects aimed at improving logistics processes, contributing to a 10% reduction in lead times and enhanced customer satisfaction.

LOGISTICS OPERATION

• Streamlined domestic dispatch for South India, evaluating logistics changes in routing, shipping modes, volumes, and carriers.
• Utilized data analytics to identify and resolve supply chain issues, improving overall performance.
• Ensured timely dispatch of completed orders and monitored product quality during transportation.
• Improved shipment efficiency by 48% by designing a freight load demand estimation process, reducing waiting time.
• Coordinated with the sales and plant teams to ensure zero back orders and managed PDI reports.
• Submitted timely management reports, including sales reports, KPI charts, and operations summaries, maintaining a 90% DDS truck fill ratio through optimized planning.
• Simulated shipping solutions to reduce shipment costs and maximize budget expenditure.
  

CUSTOMER RELATIONSHIP MANAGEMENT

• Managed a high volume of inbound and outbound phone calls.
• Resolved customer discrepancies and submitted spare parts claims while maintaining detailed interaction records.
• Used data analytics tools to monitor performance trends, identifying areas for improvement and implementing changes.
• Improved communication by facilitating interdepartmental meetings to address common customer experience issues.

PERSONAL DOMAIN PROJECTS

1.Lean Six Sigma Project: Reducing Transportation Costs

• Applied Lean Six Sigma (DMAIC) methodology to reduce transportation costs by 15%.Conducted descriptive analysis, paired t-tests, and regression analysis to identify key cost drivers. Improved load utilization by 10% and reduced delivery time by 3 days. Utilized tools like the Fishbone diagram, hypothesis testing, and statistical modeling to optimize transportation efficiency.

Tools and Technologies:

• DMAIC Methodology: For process improvement and problem-solving.
• Excel: For data analysis and statistical modeling.
• PowerPoint: For presenting insights and project findings.
• Statistical Tools: Paired t-test, Regression Analysis for hypothesis testing and identifying key drivers.

2. E-COMMERCE (using RFM-Approach):

• The RFM (Recency, Frequency, Monetary) approach helps e-commerce business to segment their customer and tailor their marketing efforts to different customer segments, thereby maximizing customer satisfaction and revenue.

Tools and Technologies:

• Python: For data processing, model development, and integration.
• Pandas, NumPy: For data manipulation and analysis.
• Matplotlib, Seaborn: For data visualization.

3. RETAIL SALE ANALYSIS :

• The primary goal of this project was to analyze retail sales data to uncover key insights that could drive business decisions, optimize inventory, and enhance profitability. The analysis was designed to provide a comprehensive view of sales performance across different products, categories, and time periods.

Tools and Technologies

• SQL: Conducted in-depth retail data analysis.
• Power BI: Created a dynamic dashboard to visualize key insights.
• PowerPoint: Compiled and presented the findings in a professional presentation.