Dexian Consulting

Attendance Management System for Heavy Manufacturing
A Heavy Manufacturing Company based at Mumbai, is faced with difficulty in Tracking Employees Daily Attendance, Overtime and Managing Leaves Application

CHALLENGES
The company is faced with issues like inaccurate attendance records, as manual tracking is prone to errors like missed entries, incorrect data, or manipulation, resulting in employee being overpaid or underpaid. Inefficient leave and overtime tracking is another challenge, as managing employee leave balances and overtime manually can be time-consuming and prone to inconsistencies. Lack of real-time data also hampers the ability to monitor workforce productivity.

SOLUTIONS

• Understanding existing, Attendance system and timings and leaves logic
• Mapping Data Capturing Parameters with Required Databases and Masters
• Identification of System and IT requirement
• System Development, Testing and Go Live

BENEFITS

• Accurate Attendance Tracking: Automates clock-in and clock-out processes, reducing errors and ensuring precise time tracking.
• Streamlined Payroll Processing: Integrates attendance data with payroll systems, ensuring employees are paid accurately and on time.
• Improved Compliance: Ensures adherence to labor laws by accurately tracking work hours, overtime, and leaves.
• Enhanced Productivity Monitoring: Provides real-time data on employee attendance, helping managers address absenteeism and improve workforce efficiency.

Web Scraping RPA
A leading FMCG manufacturer, with a strong presence on various e-commerce platforms like Amazon, faced challenges in maintaining competitive pricing. Using web scrapping through power automate desktop we created automated tool to enhance competitive pricing.

CHALLENGES
The client was losing business to other vendors selling their products at lower prices. Manual monitoring of e-commerce platforms was time-consuming and inefficient. The lack of real-time insights into competitor pricing and stock availability hindered their ability to make informed pricing decisions.

SOLUTIONS

• Power Automate Desktop to scrape data from Amazon
• Extracted key information, such as list of competitors, their prices, stock availability etc.
• Google Sheets-based report to consolidate the extracted data
• Pricing recommendation engine for suggesting competitive prices

BENEFITS

• Real-Time Market Insights: Automated data extraction provided up-to-date information on competitor pricing and stock status, enabling timely action..
• Optimized Pricing Strategy: The recommendation engine ensured competitive pricing, reducing revenue loss and boosting market share.
• Operational Efficiency: Automation eliminated manual monitoring, saving time and reducing errors in data collection
• Improved Decision-Making: Consolidated reports allowed the client to identify trends and make informed pricing adjustments swiftly.

Pre-Dispatch Inspection Process Digitization
An excavator manufacturing company located in Kharagpur, West Bengal, is encountering challenges related to inspection documentation and optimizing resource productivity.

CHALLENGES
The current workflow for managing inspection records poses significant challenges. The reliance on printed paper check sheets for recording inspection data leads to inefficiencies and inaccuracies. Manual data entry is both time-consuming and prone to human error. Furthermore, the process requires two resources-one for conducting inspections and another for documenting the results-reducing overall productivity. The manual nature of this system also complicates and delays the generation of inspection reports, impacting decision-making and operational efficiency

SOLUTIONS

• DFT Meter with Keyboard Mode output functionality to enter Reading directly to Inspection Form
• Microsoft Form based Inspection Check sheet Development
• Automated remainder emails for daily inspection results
• Dashboard and Reports for the management

BENEFITS

• Improved Visibility and Decision-Making: The centralized tracking system and dashboards provided a clear view of PO status, enabling the management team to make informed decisions quickly.
• Enhanced Collaboration: Real-time updates in Google Sheets ensured consistency and accuracy, reducing the risk of errors due to manual data entry.
• Improved Operational Efficiency: The automated integration of PO, invoice, delivery, and GRN data streamlined processes and minimized manual intervention.
• Scalability and Flexibility: The cloud-based solution allowed for easy scalability and adaptability to evolving business requirements.

Business Diagnostic for Gear Manufacturing Company Operations
A gear manufacturing company based at Mumbai, is faced with multiple issues in the company operations. There is very little clarity on problems at hand.

CHALLENGES

The company is faced with multiple issues. There are no set processes to do things. Key technical knowledge is limited with a set of old staff. Everyone claims to be busy, but still major projects are delayed. Owners have to get involved in almost every task. CSAT is decreasing rapidly. Major business is coming from a few customers who arm twist the company for low prices. Margins are wafer thin.

SOLUTIONS

• Detailed process mapping of the operations
• Clarity on job –roles, KPI and KRA
• Process Gap Analysis to bring industry standard procedures
• Identification of profit leakages and process improvement opportunities

BENEFITS

• Process documentation: Detailed process flow diagram of As-Is state. Process gap analysis was done. A futuristic To-Be state of workflow was created. So, a new common goal was created
• Job role clarity: Job role clarity led to improved employee performance, increased job satisfaction, better team collaboration and overall higher organisational efficiency.
• Positive impact on balance sheet: As the organisation moved towards a common goal by solving bucket list of problems, its impact on company financials were extremely encouraging.
• Increased CSAT: Number of complaints were reduced. Number of repeat orders Increased significantly. NPS increased considerably.

Project Management for 3D Modelling and Printing
A 3D Modelling and Printing Company based at Chennai, is faced with difficulty in Project Planning & Tracking, Resource Allocation, Project Management & Performance Monitoring.

CHALLENGES

The company is faced with issues like poor organization and tracking of project tasks, which makes it difficult to monitor deadlines, dependencies, and overall progress resulting in missed deadlines and project delays. Struggle in assigning tasks properly, leads to either overworked staff or underutilized resources. Difficulty in collaboration and communication, causes miscommunication, unclear roles and project silos, where teams are not aligned on goals or progress.

SOLUTIONS

• Understanding Value Chain and Mapping Operations
• Mapping Data Capturing Parameters with Required Databases and Masters
• Identification of System and IT requirement
• System Development, Testing and Go Live

BENEFITS

• Improved Organization and Planning: Centralized task management, scheduling and resource allocation ensuring projects stay on track as per timelines.
• Enhanced Collaboration: Facilitated real-time communication and document sharing, promoted better teamwork and transparency
• Effective Risk Management: Identified potential risks and issues early, allowing for proactive mitigation and smoother project execution.
• Real-Time Monitoring and Reporting: Provided up-to-date performance data, enabling better decision-making, ensuring timely completion of project milestones.