Sruthy Vijayakumar

• Serve as the first point of contact for all IT-related incidents and service requests across corporate offices and retail branches, supporting both technical and non-technical users. • Provide end-to-end support for ERP systems (Microsoft Dynamics AX & 365), including insurance processing, VAT workflows, access control, and POS-related transactions. • Utilize MS SQL Server to query ERP and POS databases to investigate billing discrepancies, stock mismatches, payment failures, and user activity logs. • Develop and execute custom SQL queries and stored procedures for data validation, reporting, and issue resolution. • Collaborate with ERP and development teams to analyze logs and identify root causes of transactional or integration issues. • Create reusable SQL scripts and generate ad hoc reports for credit notes, pricing issues, VAT claims, and billing adjustments. • Troubleshoot hardware, software, network, POS systems, barcode/receipt printers, and provide VNC-based remote and onsite support. • Conduct POS training for non-technical staff such as pharmacists and store employees, simplifying complex processes and ensuring smooth adoption through tailored one-on-one guidance. • Prepare user-friendly training materials and offer support during onboarding, new store rollouts, and process updates. • Manage Active Directory tasks including user provisioning, password resets, and access policy updates. • Configure and support Microsoft Outlook, Teams, and iOS devices in compliance with IT policies. • Oversee IT asset tracking, ticket management, service desk reporting, and coordinate with internal teams for escalations and enhancements. • Documented standard operating procedures (SOPs) for recurring POS and ERP support scenarios, reducing resolution time for junior IT staff. • Actively participated in UAT (User Acceptance Testing) for ERP system upgrades and POS feature rollouts, providing feedback and identifying bugs. • Coordinated IT onboarding for new employees, including account setup, device configuration, and POS system familiarization.

• Configured and customized Odoo modules (CRM, Sales, Inventory, HR) based on specific business requirements, improving operational efficiency. • Conducted requirement gathering sessions and designed optimized business workflows aligned with client processes. • Developed custom fields, reports, and approval workflows using Odoo Studio and XML/QWeb, and integrated them with external systems where necessary. • Collaborated with Java developers to integrate Odoo with external Java-based ERP, CRM, or reporting systems via REST APIs, ensuring smooth data exchange between platforms. • Provided functional specifications and worked alongside Java backend developers to enhance module performance and resolve integration issues. • Applied core programming concepts (OOP, exception handling, data structures) to analyse and debug complex business logic in Odoo and connected systems. • Trained end-users, delivered user manuals, and supported clients through the post-implementation phase, ensuring smooth system adoption.

• Developed and maintained scalable web applications and enterprise systems using Java, Spring Boot, ASP.NET Core, and Angular. • Designed and developed full stack enterprise web applications for travel, healthcare, and ERP domains using Java, Spring Boot, Hibernate, and MySQL for the backend and Angular, JavaScript, AJAX, and jQuery for the frontend. • Built and secured RESTful APIs with Spring Boot, handling client- server communication and enabling integration with third-party platforms like Google Maps and payment gateways. • Utilized Hibernate ORM for mapping Java objects to database tables, managing relationships, and reducing boilerplate SQL code while maintaining transaction safety and integrity. • Structured complex MySQL schemas, wrote optimized SQL queries, created indexes, and implemented stored procedures to enhance query performance and data handling in large datasets. • Developed responsive and interactive UIs using Angular, HTML5, CSS3, Bootstrap, and dynamic scripting with JavaScript, AJAX, and jQuery to provide a smooth user experience. • Integrated JWT-based authentication and role-based access control for securing APIs and frontend routes, ensuring compliance with enterprise security policies. • Followed Agile/Scrum methodology with sprint planning, daily stand-ups, retrospectives, and close collaboration with QA, UI/UX, and product teams. • Used Eclipse IDE for daily development and SVN for version control, ensuring effective source code management and team collaboration. • Deployed and managed applications on Apache Tomcat, configuring WAR files, server ports, and application contexts for staging and production environments. • Modernized legacy Java applications by replacing monolithic components with Spring Boot microservices, improving modularity and reducing response times by 20%.

• Developed two Java-based Load Control & Monitoring systems from the ground up using Spring Boot, Hibernate, and MySQL, enabling real-time data acquisition and system monitoring in industrial environments. • Created backend logic using Spring Boot for RESTful web services, integrated with Hibernate ORM for efficient database interaction and reduced boilerplate code. • Designed normalized relational schemas and managed complex queries in MySQL, optimizing data retrieval and storage for high- volume sensor logs. • Built dynamic and responsive dashboards using JavaScript, AJAX, jQuery, and HTML5/CSS, allowing real-time visualization and user interaction with industrial data. • Integrated asynchronous communication between frontend and backend using AJAX calls for real-time alerts, device status updates, and logs without full-page reloads. • Deployed applications on Apache Tomcat servers and configured environment settings for seamless integration between development and production. • Used Eclipse IDE for development and version-controlled the codebase using SVN, ensuring collaborative, stable, and trackable development workflows. • Implemented role-based access control, user session management, and exception handling across application layers to ensure system security and reliability. • Conducted performance profiling, database tuning, and Java garbage collection optimizations to improve system throughput by 30%. • Authored detailed technical documentation, user guides, and configuration manuals for both internal stakeholders and client- facing training. • Provided post-deployment support including bug resolution, change request handling, patch deployments, and collaboration with QA for test validation.

Part-Time • Delivered classroom and one-on-one training sessions on Java programming, SQL, and core computer science concepts to students from non-IT backgrounds. • Designed structured lesson plans, exercises, and mini-projects to support hands-on learning and real-world application development. • Simplified complex topics such as OOP principles, database querying, and basic front-end integration, improving learner confidence and technical competence.