Sunil Mali

As a Sales Program Executive at DHL Express, I am responsible for driving programmatic initiatives to enhance sales efficiency, streamline processes, and optimize overall performance. My role encompasses a diverse set of responsibilities, including but not limited to:

Data Analysis and Reporting:

• Developed and implemented dynamic reports leveraging advanced data analysis techniques to provide actionable insights to the Sales team, contributing to enhanced decision-making processes.
  Utilized statistical analysis methods to identify trends, patterns, and anomalies within sales data, enabling proactive adjustments to sales strategies and tactics.

Projects Delivered: -

1. Sales Performance Tracker:

Designed and implemented a comprehensive reporting system encompassing revenue, shipment, and kilos tracking, incorporating key performance indicators such as RPD, SPD, and KPD to provide a holistic view of portfolio performance. Demonstrated strong analytical skills in developing an active sites tracker to monitor and evaluate the performance of operational sites, enabling prompt identification of areas for optimization and improvement.

2. FTB Tracker:

Developed a sophisticated tracker to analyze monthly new and regained customers, featuring a waterfall view to visualize retention trends over time, demonstrating proficiency in data visualization and trend analysis techniques.

Implemented advanced data modeling techniques to accurately assess customer retention metrics and identify factors influencing customer churn and acquisition.

3. Customer Management Tracker:

Spearheaded the development of a customer management tracker focusing on top 20 customers based on loyalty, showcasing expertise in customer segmentation and relationship management strategies.

Demonstrated strong project management skills in overseeing the implementation of an activity tracker to ensure timely and effective customer engagement, optimizing sales portfolio performance based on channel revenue banding.

4. Opportunity Tracker:

Designed and deployed a comprehensive opportunity tracker to monitor pipeline stages, acquisition, and development closing ratios, showcasing proficiency in sales pipeline management and optimization.

Leveraged data-driven insights to identify and prioritize high-potential opportunities, enabling the sales team to allocate resources effectively and maximize revenue generation.

5. Sales Forecasting

Implemented system for sending weekly sales forecasts to sales team, facilitating proactive decision-making and continuous improvement strategies.

6. Big Fish Pipeline:

Implemented a strategic project aimed at boosting revenue by targeting the top 10 opportunities for each Area Sales Manager (ASM), optimizing sales efforts and maximizing revenue generation.

Automation and Process Optimization:

1. Access Queries Automation: Led automation of existing Access Macros/ Excel Tasks / Manual Reports, transforming them into efficient SQL stored procedures, resulting in remarkable reduction in processing time from 13 business days to a single day with an scheduled Tasks. (Technologies Used: SQL/ C#.Net )

2. RPA Automation: Built a tool that can split the document basis the type of document using OCR (Optical Character Recognition) (Technologies Used: Python & Googles Tesseract Engine).

3. Converted Existing ASP based internal Sales Reporting Website to Power BI

4. Tool To Data Import: Tool that can automatically push data from various sources to SQL (Technologies Used: C#.net / SQL / Python)

Sales Forecasting:

• Implemented a system for sending weekly sales forecasts to the sales team, facilitating proactive decision-making and continuous improvement strategies.

Project Leadership:

• Acted as a lead in a team of two, successfully automating key macros, contributing to increased team efficiency and productivity.
• Played a pivotal role in the migration of an ASP-based website to Power BI, enhancing data visualization capabilities and enabling more informed decision-making.

Collaboration and Communication:

• Collaborated cross-functionally with sales teams, providing valuable insights and recommendations for performance improvement.
• Facilitated effective communication and coordination between different departments to ensure the seamless execution of sales programs.

Technological Proficiency:

• Demonstrated proficiency in Python, Machine Learning, Data Science, Excel, SQL, and C#.net, leveraging these skills to drive automation and data-driven decision-making.

Achievements:

• Received acknowledgment for outstanding performance and leadership in the automation of critical macros.

• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
• .Consistently met project milestones while maintaining rigorous quality control standards throughout all stages of the development life cycle.
• Designed intuitive graphical user interfaces to improve user experience.
• .Expanded client offerings by staying current with industry trends, learning new programming languages, frameworks, and technologies as needed.
• Contributed to the successful completion of projects aimed at enhancing web scanning and document storage solutions, earning recognition within the organization.

Project Name : ePM (e- Payables Manager)

Clients : (Pearson, KOEL, Zion Bank)

Programming Language : Asp.net 4.0, C#, SQL 2008, WCF

Description : End-to-end automation of invoice processing including Electronic & mobile-invoicing. The application processes each invoice that the vendor generates & sends the information to the company core system in real time.

• Developed databases, programs and processes for integration and implementation across enterprise.
• Provided technical support using knowledge of complex technology to solve problems and support new projects.
• Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
• Met with stakeholders to provide detailed project reports and milestone updates.
• Coordinated efficient large-scale software deployments.
• Contributed to the successful completion of projects aimed at enhancing web scanning and document storage solutions, earning recognition within the organization.
• Led the development and implementation of cutting-edge audio, image (TIF, JPG, PNG), and PDF compression tools, showcasing expertise in optimizing file sizes and enhancing data storage efficiency, earning the organization multiple CIO Choice Awards

Projects Delivered :

Project Name : LTI BOSS

Client : LNT Insurance

Languages: ASP.net 4.0, C#, SQL 2008

Description: Web based tool that can scan documents LTI BOSS is a live application used by LNT Insurance. This application allows seamless flow of documents from Scanning on the Web by Scanner, Directing these documents to Data Entry team, Quality checkup to check the quality of data entered, Internal Approvals(IT, UW etc.), generating final Insurance copy which is then given to the customer.

Project Name : eAsset

Client : Product Made by Sudesi

Languages: ASP.net 4.0, C#, SQL 2008

Description: E-Asset is an Innovative process of operating, maintaining, upgrading and disposing of assets in a cost-effective manner. This application helps in manual reconciliation by capturing the physical asset inventory images.

Project Name : adStringo Web, Desktop Version

Client : Product Made by Adstringo

Languages: ASP.net 4.0, C#, SQL 2008

Description: A comprehensive document capture solution enabling seamless extraction of meaningful insights from various data sources including paper, emails, forms, and office documents. Key features include JPEG, TIFF, multiage TIFF, PDF, PNG and GIF compression. Ideal for businesses seeking efficient, cost-effective digitization solutions to enhance productivity and decision-making processes.

Major Achievements

1. Jpeg Compression

2. Tiff Compression

3. Multipage Tiff Compression

4. PDF Compression

5. PNG Compression.

Other Projects Delivered:

1. mobePay : ( Invoice Processing Tool)

2. eAsset : ( E-Asset is an Innovative process of operating, maintaining, upgrading and disposing of assets in a cost-effective manner. This application helps in manual reconciliation by capturing the physical asset inventory images)