Shobanbabu Duthi Venugopal
Alpharetta,GA
Summary
Results-driven Business Systems Analyst with strong expertise in MercuryGate TMS, Softeon WMS, and logistics EDI (204, 210, 214, 940, 945) for UPS SCS across the USA, Canada, and India.
Led end-to-end rating design, carrier integrations, and automation, delivering a 40–60% reduction in shipment/EDI errors.
Skilled in turning complex transportation workflows into scalable, production-ready solutions, with strong customer communication.
Experienced in cross-functional delivery, UAT, and production support, ensuring high-quality execution for enterprise logistics programs.
Overview
9
9
years of professional experience
2
2
Certifications
Work History
Business Systems Analyst
Tech Mahindra Americas
Alpharetta, Georgia
02.2019 - Current
- Led end-to-end solution design and execution for UPS SCS Transportation and Warehousing operations, covering MercuryGate TMS and Softeon WMS integrations.
- Analyzed logistics workflows—linehaul, parcel, LTL, FTL, inbound/outbound, consolidation, returns—and translated operational processes into system configurations.
- Delivered enhancements for rating, routing, execution, and settlement with high accuracy and a quick turnaround.
- Configured and maintained rate bases, rate tiers, accessorials, uplift %, linear-foot/cubic weight rules, and fuel surcharge logic in MG rate files.
- Designed advanced MG components, including: ✔ Rate Record Files ✔ Break Types (Qty, Weight, Pallet, % charges, Min/Max charges) ✔ Cost Items & Rate Actions ✔ Carrier profiles, equipment types, and service levels.
- Performed end-to-end testing of tendering, planning, audit, and settlement flows inside MercuryGate.
- End-to-end responsibility for designing and troubleshooting EDI flows between UPS systems, MercuryGate TMS, Softeon WMS, and carrier/shipper systems.
- Hands-on mapping and validation of: EDI 204 – Load Tender, EDI 210 – Freight Invoice, EDI 214 – Shipment Status, EDI 990 – Acceptance/Rejection, EDI 940/945 – Warehouse Shipping Order/Advice.
- Ensured seamless data transformation via IBM ITX, resolving mapping and translation issues, and improving EDI accuracy.
- Worked with UPS APIs (UTMS, PRISM, Helix) for real-time rating, tendering, tracking, and visibility.
- Troubleshot API failures using header-level logs, XML/JSON payload analysis, and end-to-end test harness setup.
- Built automation scripts using PowerShell, Excel macros, Power Automate, and Jasper report tuning, significantly reducing manual effort.
- Extracted data from TMS/WMS and generated dashboards for: Carrier performance, on-time pickup/delivery metrics, rate accuracy validation, and exceptions and SLA monitoring.
- Designed EDI-to-Excel converters for audit and QA teams.
- Acted as a bridge between business stakeholders, operations leaders, onsite UPS managers, offshore development teams, and product vendors (MG/Softeon).
- Led requirement workshops, gap analysis sessions, sprint planning, and end-user demo walkthroughs.
- Managed change requests and production releases following Agile/Scrum methodology.
- Owned L2/L3 production support for MG TMS, and Softeon WMS flows.
- Performed RCA for: ✔ API failures ✔ Missing EDI transactions ✔ Rate mismatches ✔ Load tender failures ✔ WMS-TMS sync issues.
- Published impact analysis, workaround steps, permanent fixes, and preventive measures.
- Created BRDs, FSDs, mapping documents, integration guides, rate setup SOPs, and test scripts.
- Communicated complex technical issues to non-technical UPS stakeholders in a simple, action-focused manner.
- Maintained extremely clean documentation for audits and solution handovers.
- Deep domain knowledge of global supply chain operations (air, ocean, ground).
- Experience with carrier contracting, rating engines, dimensional rules, NMFC classes, pallet logic, etc.
- Very strong troubleshooting, data analysis, and cross-team coordination abilities.
- The ability to understand both technical integrations and business logistics processes is rare and highly valued.
Product Specialist
Ramco Systems
Chennai, TN
12.2016 - 12.2018
- Supported implementation of Ramco Transportation Management, Customer Relation Management, and Portals in all the project phases.
- Coordinated with onsite and offshore resources throughout all the project phases.
- Reviewed the As-Is and To-Be process and performed the fit-gap analysis partially.
- Worked with the project manager to manage solution deliverables on time and within budget.
- Worked with the business team to complete requirement gathering and functional documents.
- Worked with the business team to complete requirement gathering and functional documents.
- Documented and reviewed detailed design documents with the stakeholders.
- Supported business during User Acceptance Testing, End User Testing, and Go-live.
- Managed business acceptance testing and defect resolution under strict timelines.
Education
Bachelor Of Technology (BTech) - Electrical, Electronics And Communications Engineering
SRM University
Chennai06-2016
Skills
- EDI flow design
- Data analytics
- EDI mapping
- XML and JSON
- ETL processes
- Transportation management systems
- Freight forwarding
- Logistics process integration
- Supply chain operations
- Visualization tools
- Logistics optimization
- SQL development
- API management
- Data warehousing
- Web services
Certification
MercuryGate TMS Implementation Certified
Accomplishments
'BRAVO’ award for analysis and ability to provide a root cause and a solution was appreciated by
Customer on multiple occasions
Customer on multiple occasions
Timeline
Business Systems Analyst
Tech Mahindra Americas
02.2019 - Current
Product Specialist
Ramco Systems
12.2016 - 12.2018
Bachelor Of Technology (BTech) - Electrical, Electronics And Communications Engineering
SRM University