Sumithra

E-Freight Suite (ERP)

Clients handled : FSL (Freight Systems Logistics) and SAAS (Third party clients)

• Led all phases of the Software Development Life Cycle (SDLC), encompassing analysis, design, development, testing, and successful implementation.
• Provided essential support for the existing Oracle database (version 19c) while also implementing new client requirements.
• Employed advanced database concepts, including Collections, pipelined functions, and dynamic SQL, to optimize database performance.
• Successfully maintained intricate SQL queries, views, and stored procedures in a multi-database environment, often proposing innovative, long-term solutions to prevent recurring issues.
• Exhibited self-reliance in workload management while collaborating with distributed teams, pioneering solutions and workflow optimizations that accelerated deployment timelines.

Maersk Line (Integration)

• Automated data interchange (XML, JSON) between the Oracle database and web applications, streamlining integration with third-party systems.
• Developed Programs using advanced PL/SQL coding techniques to implement complex business logic effectively.

WhatsApp Integration

• Developed automated Triggers to extract data from ERP, ensuring timely and accurate retrieval for integration into database tables.
• Facilitated seamless transmission of data to third-party systems through JSON files, optimizing processes for WhatsApp notification delivery and enhancing system interoperability.

• Diligently identified and resolved bugs in data collection and reporting, conducting thorough investigations to determine root causes.
• Skillfully analyzed user concerns, requirements, and requests for system features and functionalities.
• Carried out routine tasks under direct supervision, adhering to established procedures and guidelines to maintain operational efficiency.
• Conducted comprehensive data cleaning and validation for existing spreadsheets, enhancing the data management platform's robustness. This effort led to improved accuracy in data analysis and entry