Suseela Chandran

As a Senior Tech Lead, I work on implementing the banking product

• Requirement gathering related to Retail Lending module related APIs.
• Solution designing for Customization or Change Request for product.
• Logical and Physical design of database for projects on basis of user requirement.
• Working on issues associated with these APIs and fixing them.
• Improved database server performance using Performance monitor after analyzing CPU, I/O and Memory usage.
• Monitored server level and DB level log events using SQL Server Audit
• Technologies involved in current project are Java, JIRA, GIT, Oracle DB, Linux, HTTP.
• Using REST APIs for various operations like opening accounts, modifying accounts, updating customer details, making payments, etc.
• Established efficient workflows through integration of automated tools and technologies into daily operations.
• Performing validations on data received and populating other details as per custom requirements and formatting object.
• Code movement to production is done using GIT, Jenkins and images are AWS ECR
• Enhanced system efficiency by designing and implementing new software solutions.
• Collaborated with stakeholders to define requirements, set expectations, and deliver projects on time and within budget constraints.
• Delivered high-quality products by conducting thorough testing procedures to identify defects before release to market.
• Mentored junior team members to improve their technical skills and enhance overall team performance.
• Maintained 100% SLA for banking product support and implementation to sustain continued operations.

• Reduced system downtime by implementing proactive monitoring and maintenance procedures.
• Enhanced application performance for increased user satisfaction by optimizing code and database queries.
• Streamlined software development process with introduction of Agile methodologies, resulting in faster project completion times.
• Increased team productivity through effective collaboration, clear communication, and regular progress updates.
• Collaborated with stakeholders to define technical requirements, ensuring alignment with business objectives.
• Troubleshot complex issues impacting systems performance, applying root cause analysis techniques to prevent future occurrences.
• Enhanced interfaces to promote better functionality for users.
• Supporting and developing SQL queries for various databases.
• Experience in building adhoc reports, parameterized reports, toggle reports, reports with sub reports using Crystal reports for weekly and monthly reporting
• Gathering client requirements on customizing their E-Banking requests coming to Core Banking module for Retail lending operations like payment posting and account inquiry
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Tracking of regular patches shared to banks are promoted to production and ensuring banks to deploy regular patches in bank’s area using APDM tool.

• ·Major responsibility is involved developing reports in various requirements of bank using IReports and Jasper
• ·Customized product to meet bank’s requirement, solutioning and approaches shared as high level, low level design documents.
• Problem Definition: Analysis of issues to identify problems and provide suitable solution.
• Solution Evaluation and Recommendation: Provide solution for observed issues, recommend it to clients.
• Status meeting participation: Conduct regular status meeting to provide project progress, update and analyze risk to handle any critical paths
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security, logins, roles and schemas.
• · Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Database backups (operating system, flat file backups & export/import).
• ·Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Implement Replication for Reference Data across different Instances of application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.

• Optimized module development processes, leading to increased efficiency and better quality outcomes.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Major responsibility is involved in leading a team with core customization for all inquiry custom menus and integration of third-party system with product in data fetch for processing
• Identified gaps in existing system to map it with product and come up with approaches in terms of configurations, customization and data conversions to address banks requirement.
• Used Data Mapper Tool to do mapping of third party fields with product business fields for business requirements

• Spearheaded successful development of e-publishing portal's web application using JavaScript, enhancing user experience and functionality.
• Streamlined data flow by bridging system gaps, enhancing efficiency and performance.
• Leveraged tech benefits for portal users via seamless integration in host server.