Archana Kumari

Project: Live Staffing Tool (LST)

• Led the modernization of the Live Staffing Tool (LST), a global platform for managing junior bankers’ allocations on client pitches.
• Revamped the outdated system to enhance performance, visibility, and Qlik-based reporting.

Key contributions:

• Migrated the application from Liberty to Tomcat for better performance.
• Upgraded Java to Spring Boot 3.4.1 for improved compatibility and maintainability.
• Led the database migration from Oracle to Postgres, ensuring scalability and reliability.
• Designed and implemented scalable backend solutions, and integrated data from multiple golden sources for reporting.
• Ensured seamless migration with minimal downtime, while maintaining data integrity.
• Provided technical leadership, conducted code reviews, and collaborated with cross-functional teams for smooth execution.

Project: Equities and Syndicate Underwriting Manager (ESUM)

• Developed and maintained ECM Deal Tracking System, an internal HSBC application for tracking and reporting Equity Capital Markets (ECM) deals.
• Automated Management Information (MI) reporting to streamline regulatory and management compliance, replacing manual processes to improve efficiency.

Key contributions:

• Built and optimized backend services using Java, Spring Boot, and microservices.
• Designed and optimized Oracle database queries for efficient transaction tracking.
• Integrated data from multiple golden sources to ensure accurate reporting.
• Automated MI reporting to meet compliance and business requirements.
• Collaborated with business analysts, product owners, and stakeholders to gather and implement business needs.
• Managed CI/CD pipelines using Jenkins, GitHub, and Nexus for smooth deployments.
• Assisted in deployments, production support, and troubleshooting to ensure system reliability.
  

Project: Leverage and Acquisitions Finance Syndicate Underwriting Manager (LSUM).

• Developed and maintained the LAF Syndicate Underwriting Manager, an internal HSBC Java application used by the Leverage and Acquisition Finance business.
• Automated and enhanced manual processes, enabling efficient global transaction tracking, and accurate reporting.

Key contributions:

• Built and maintained backend services using Java, Spring Boot, and microservices.
• Designed and optimized Oracle database queries for efficient transaction tracking.
• Developed and integrated APIs to ensure seamless data flow across systems.
• Worked closely with business analysts and senior developers to implement business requirements.
• Conducted unit testing, debugging, and performance tuning to optimize application efficiency.
• Assisted in deployments, production support, and troubleshooting to maintain system stability.