Suresh Kumar Subramanian

Experience

• 

  Bitech International

  Jun 2005 - Jan 2006

  .Net Programmer

  Client Name: Citi Bank through Nucleus Software Solutions, SingaporePeriod: July 2005 to January 2006Supported Web Exceller application used by Citibank in 13 countries (Asia Pacific). Also did major enhancements to this application.Regional ReportsASP, SQL Server 2000 and Crystal Reports 9• Created five new local reports, which are used by each country separately, and five regional reports, which are all used commonly all countries. • Regional report will extract the data from 13 different databases and display the same in consolidated report.Role• Requirement gathering and finalized by coordinating with business.• Coding in ASP to integrate the new report• Created stored procedure in SQL Server 2000 for both local and regional reports.• Designed and created new reports template in Crystal Report 9 Show less

• 

  Nucleus Software Exports Limited

  Feb 2006 - Sept 2008

  Senior Software Engineer

  Client: Citi Bank Singapore App Name: Web ExcellerWeb Exceller used by CitiService department in Citibank for internal call tracking system with various MIS reports. I was primary support to this application, used by 13 countries (Asia Pacific). During this period did major enhancements to this application and got good feedback from the clients. CitiSafe Integration- CitiSafe is a Citibank’s internal security system. Integrated the application with CitiSafe application for user authentication without impacting the existing systems user profile management- Coordinated with business and gathered the requirements and prepared set of common user profiles for all 13 countries and 4 departmentsDatabase Maintenance - Scheduled automated job using Tivoli job scheduling and monitoring system for database backup and purging for 70+ databases. - Scheduled an Ad Hoc job, which eliminates the DBA involvement for executing the scripts in the database- Fine tuned a query which is used to generate a consolidated report by fetching information from 13 databases. The performance has been increased by 40% Application Name: RPS – Regional Pricing SystemThis is an application being used By Citibank for maintaining the pricing details based on customer’s tier.• Generated scripts to Migrate 200,000+ pricing details from Centura Gupta Databases to SQL server 2000 and migrated the same without any issues in a shot span of time• Prepared a script for Migrating 200+ users from Centura Gupta database by mapping the user details with all respective branch pricing details Application Name: MAFCI – Middleware AutoFax and COTS IntegrationThis is an application is being used by CitiService department in Citibank for sending faxed to the customer by receiving XML feed from another system. Dot Net MigrationDeveloped one of the main modules called UPLOADER, WHICH is used to parse the XML file and upload the data into the database by mapping the node name with the field name Show less

• 

  Barclays Capital

  Oct 2008 - Jul 2013

  Analyst

  Stockloan Application Management (Prime Services) Applications: Global1, Magics, Forecast, EquilendPrime Services IT is responsible for development and support of the Equity Finance groups internal (front, middle and back office) and client facing applications. Prime Services IT is comprised of Prime Brokerage, Stock Lending, and Synthetics & Clearing/Settlements IT. The primary responsibility is to ensure the continued availability, effectiveness and accuracy of production systems, and realize the maximum value from them through continual technical and business process improvement.Responsibilities:- Level II Production Support for all Stockloan applications.- Front office support to Equity Finance trading desk and Middle office operations team in Japan, Hong Kong and London by ensuring the applications (Global1/Equilend) are working as desired.- Managing Major Incident (Outages) and keeping the related parties updated on status.- Carry out bug fixes and/or report bugs back to the development team.- Conducted training and maintain the knowledge base of team.- Adhoc Reports to Business users related to portfolio availability and locates.- Developed various tools/scripts using UNIX scripting, Sybase/SQL SPs to lessen the manual efforts performed by the team.- Handled Incident/Problem Management to reduce the number of repetitive incidents Applications: HP Service Center, BO Reporting, Tracker2 (Project Management), BCM Tools, Unity.• Overall architect for production support related projects • Development of support tools• Worked extensively while Onboarding Tracker2 and help BTB team to resolve the issues during deployment which helped the deployment to complete on schedule and got good appreciation from both BTB Manager and RTB manager • Constantly created tools and dashboard on helping team to handle BAU tasks efficiently• Handling Capacity management and providing periodic update to the RTB Show less

• 

  Kelly Services

  Jan 2014 - Jun 2015

  Analyst
• 

  DBS Bank

  Jul 2015 - now

  • Senior Vice President

    Mar 2023 - now

  • Vice President

    Apr 2017 - now

  • Assistant Vice President

    Jul 2015 - Mar 2017