Mohamed Bahir Hussain

• Led the development of the Colombo Mail Logistics Website using Java, Spring Boot, Hibernate, and
Microservices, delivering real-time shipment tracking, rate calculators, and online booking features.
• Engineered and automated end-to-end ETL pipelines in Python (Pandas, NumPy) to integrate MySQL,
CSV/Excel, and third-party courier APIs, reducing operational data processing time by 60%.
• Designed and optimized MySQL databases with indexing, partitioning, and stored procedures, achieving up to
70% faster query execution for high-volume logistics and e-commerce transactions.
• Built a secure OTP-based parcel verification system using Spring Boot, MySQL, and Twilio API, increasing
last-mile delivery accuracy and reducing support tickets by 40%.
• Developed the Internal Workflow & Parcel Management System with automated task assignment, role-based
access control, and staff activity tracking, replacing manual processes and improving team productivity by 45%.
• Integrated RESTful APIs for courier partners (UPS, USPS, Aramex, DHL, FedEx) and payment gateways (Stripe,
PayPal), enabling automated shipment updates and secure online payments.
• Created advanced analytics and KPI dashboards in Power BI and Tableau, generating real-time reports for sales
trends, delivery performance, and customer insights.
• Deployed and maintained applications on AWS (EC2, S3, RDS), implementing CI/CD pipelines with Git,
Jenkins, and automated backups for secure and scalable operations.

• Designed, optimized, and maintained high-performance MySQL databases through advanced indexing,
normalization, partitioning, and stored procedures, improving query response times by up to 65% and ensuring
data accuracy for logistics and e-commerce systems.
• Created robust data preprocessing workflows in Python, handling missing data, deduplication, and
normalization to deliver clean, analytics-ready datasets used for business reporting and decision-making.
• Built the Workflow and Parcel Tracking System leveraging Java, Spring Boot, MySQL, and Twilio API to
implement OTP-based delivery verification and real-time parcel status updates, improving customer satisfaction
and reducing delivery disputes.
• Integrated multiple courier APIs (UPS, USPS, Aramex, DHL, FedEx) to automate waybill generation, shipment
tracking, and dynamic courier selection based on cost and delivery time, streamlining logistics operations.

Website Administration
• eCommerce Operations
◦ Financial Systems
◦ API Development
◦ Database
Management
• Hardware Support
◦ Reporting & Analysis
• Managed end-to-end website and eCommerce operations (Amazon, eBay, Colombo Mall), ensuring 99.9% uptime,
streamlined order workflows, and enhanced customer experience.
• Designed and implemented a bill payment and data management system with API integration, automating financial
processes by 80% and improving accuracy by 95%.
• Administered internal databases with secure backup and recovery protocols, performed data quality checks, and optimized
performance for consistent data integrity.
• Provided cross-functional support through hardware maintenance, system troubleshooting, and generation of analytical
reports to guide business strategy and operational improvements.