Aravinthraj Panneerselvam

Sam's Club, Replenishment Team - Global Replenishment System (GRS) & Order Management System (OMS)

• Developed and maintained Global Replenishment System (GRS) and Order Management System (OMS) for demand forecasting, inventory replenishment, and supply chain management using Java and Mainframe technologies
• Led the modernization of legacy applications by migrating key functionalities to microservices architecture and cloud-based solutions, significantly improving system performance and reducing operational costs
• Collaborated closely with clients and cross-functional teams to gather business requirements and convert them into technical solutions
• Created design documents, infrastructure diagrams, and programming specifications, ensuring alignment with business goals and technical standards
• Designed and developed backend applications, introducing new features and functionalities to improve the GRS and OMS systems' efficiency and streamline business processes
• Automated real-time alerts and monitoring systems to proactively detect issues and failures, ensuring rapid response times and minimizing operational disruptions
• Leveraged problem-solving, critical thinking, and creativity to meet tight project deadlines and quickly adapt to evolving organizational needs
• Ensured compliance with architecture, design, and coding standards to deliver high-quality, maintainable software
• Utilized Agile methodologies and JIRA for efficient project tracking, collaboration, and management in a fast-paced development environment
• Developed scalable and maintainable code, ensuring long-term stability of the software.
• Integrated new technologies into existing systems, increasing capabilities and improving overall performance.

Client: AIG VALIC, Houston

Project: Plan Account Number Project

• VALIC, a subsidiary of AIG, provides tax-qualified retirement and investment services
• This project aimed to help VALIC process transactions at the Plan Account level
• Key responsibilities included:
• Introduced a new Plan Account Database linked to the existing Participant & Account Database
• Updated the system to handle Plan-level transactions
• Mapped accounts with the same group/plan to a single Plan Account number
• Modified online screens to display the Plan Account number in the Participant Summary
• Followed Agile methodology throughout the project
• Mentored junior developers, providing guidance on best practices and coding techniques for improved productivity.
• Delivered high-quality code on time by effectively managing project timelines and prioritizing tasks accordingly.

Client: AIG VALIC, Houston

Project: Employee Retirement Income Security Act (ERISA) Project

• VALIC, a subsidiary of AIG, offers tax-qualified retirement and investment services
• The ERISA project focused on handling abandoned property funds for accounts with no activity within a specific timeframe
• Key responsibilities included:
• Developed a system to manage abandoned property funds in the Forfeiture database
• Supported the business needs related to processing and tracking unclaimed funds
• Followed Agile methodology throughout the project for timely delivery
• Mentored junior developers, providing guidance on best practices and coding techniques for improved productivity.
• Delivered high-quality code on time by effectively managing project timelines and prioritizing tasks accordingly.

Client: AIG VALIC, Houston

Project: DOL Project (Department of Labor)

• VALIC, a subsidiary of AIG, provides tax-qualified retirement and investment services
• The DOL project focused on implementing changes to Agent Commissions as per U.S
• Regulatory requirements
• Key responsibilities included:
• Modified batch programs to calculate agent commissions based on the money brought into VALIC
• Designed and introduced a new DB2 table to store calculated commissions at the transactional level, used during chargeback and reversal transactions
• Followed Waterfall methodology for project development and delivery
• Improved software efficiency by troubleshooting and resolving coding issues.
• Saved time and resources by identifying and fixing bugs before product deployment.

Client: AIG VALIC, Houston

Project: Fee Enhancements Project

• VALIC, a subsidiary of AIG, offers tax-qualified retirement and investment services
• The Fee Enhancements Project aimed to automate the calculation of fees for groups and eliminate manual processing
• Key responsibilities included:
• Introduced a new automated GL process to handle fee calculations
• Integrated Payee feed from Lighthouse interface to store group payee information in a new DB2 table for downstream use
• Modified fee transaction processing batch programs to call the new DB2 subprogram for retrieving payee data
• Grouped account-level fee transactions and facilitated check printing via the SAP interface
• Followed Waterfall methodology for project delivery

Client: AIG VALIC, Houston

Project: Account Number Expansion and PII Masking Project

• VALIC, a subsidiary of AIG, provides tax-qualified retirement and investment services
• The Account Number Expansion and PII Masking Project aimed to improve customer enrollment and enhance privacy protection
• Key responsibilities included:
• Expanded the account number field from 4 bytes (Comp-3) to 7 bytes (Alphanumeric) to accommodate more customers
• Implemented PII (Personal Identifiable Information) masking in mainframe screens and reports to protect sensitive data
• Modified system batch and online programs, SPA area changes, copybooks, and handled one-time file corrections for PII masking
• Followed Waterfall methodology for project delivery
• Wrote clear, clean code for various projects.
• Collaborated with cross-functional teams for seamless integration of new features and functionalities.