Lakshmi Sairam
Woodbridge,NJ
Summary
Accomplished Senior Java Developer with extensive experience at Citicorp, adept in Java, SQL, and microservices. Proven track record in successful data migration projects and leading teams to enhance application performance. Strong analytical skills and a commitment to delivering high-quality solutions that meet business needs. Driven Programmer Analyst with keen analytical problem solving and troubleshooting abilities. Thrives in challenging, fast-paced environments through multi-tasking and organization skills. Motivated Programmer Analyst with career successfully spent designing and developing software and writing code. Diligent individual with extensive knowledge of latest computer trends and various technological developments.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Java Intermediate Programmer Analyst/Senior Developer
Citicorp
Chennai, India
08.2022 - 11.2024
- Company Overview: Citicorp Services provides solutions for all your banking needs, such as Personal Banking, Commercial Banking, Private Banking, Mortgage, Equity, Lending, and much more across the world.
- Treasury and Trade Services (TTS) is one of its important units that handles the commercial card business.
- Worked as a Senior Java Programmer Analyst for the DATA team, which is the Global Data Repository (GDR) team.
- GDR is the main database repository that maintains all the information acquired through the commercial card business, which includes card details, cardholder details, transactions made, associations, addendum details of the transaction, and much more that happens in the card life cycle across the globe.
- This information was maintained in the DB2 database initially and later moved to Oracle as a huge initiative.
- Extensively worked on data migration from the DB2 database to the Oracle database.
- This involved an in-depth understanding of the SQL queries in the DB2 database, and the business requirements involved in the data and prepared an equivalent SQL query in Oracle DB.
- Data handling in Java, due to this migration, had a big impact.
- Faced many challenges during the migration from DB2 to Oracle, such as blank values not being accepted in Oracle, double-byte data storage, Oracle keywords being used in DB2 as column names, and much more.
- This resulted in a major performance issue, which was handled effectively using Java data structures.
- Worked primarily on the India Data Localization (IDL) project, which was a huge effort to replicate the entire process on servers maintained in India.
- I learned many details right from procuring multiple servers for the process, making sure all the compliance details are met, and delivering the entire process on time.
- Making sure the COB servers are working as per the expectations.
- Worked on the IDL project from start to end with the team to bring it to a big success.
- I worked on upgrading from RHEL 7 to RHEL 8 with the infrastructure team.
- Worked on all the key areas, like loading the data into the system and generating reports using technologies such as Java, Perl script, Shell script, Oracle, Oracle SQL Developer, AngularJS, MySQL Database, and Java Web services.
- Worked with a team of developers, providing them with technical guidance, and helping them in different areas to complete their tasks.
Senior Java Developer
Verizon Wireless
Warren, USA
06.2011 - 05.2013
- Company Overview: Verizon Wireless is a wireless service provider.
- Point of Sale (POS) is the department through which sales are made on wireless and accessory products for Verizon Wireless.
- POS maintains a lot of applications as the channel of sales.
- Contributed for the enhancements of ICONIC, DOTCOM, NETACE, ONEPOS, SFAOM and EROES applications based on the requirement
- Worked on critical modules like MTN Reassign, ISIS Mobile Wallet, Customer Research, Payments, Generation of SPOC email for Iconic Pre-Orders, and Displaying Iconic Order details.
- Contributed to the ICONIC development for the changes regarding SPOC email, review screen, and ISIS feature validations.
- Designed and developed the Order Details Preview screen for ICONIC pre-orders based on the confirmation number.
- Migrated the MTN Reassign from the old DVS API to the new.
- One new DVS API replaced two old APIs.
- Worked on Phase 2 of the ISIS Mobile Wallet requirement.
- During this phase, I contributed to adding the Payment Feature and Payment Block for an MTN, and presenting a warning message to the reps and the customers in the Customer Lookup (InfoDesk) module, SHOPP, and ICONIC when an ESN change or Equipment Upgrade is initiated, and upon the removal of Wallet/Payment features.
- Created 7 web services for the Customer Care (ACSS) team for the Customer Research RT.
- Customer Research RT had some data issues, for which I contributed to figuring out the actual issue and escalated it to the correct team in order to successfully complete the RT.
- Worked on the Payment module to capture and store the Merchant Order Number/Transaction ID generated by GPS/PaymentTech, depending upon the card used for credit card transactions.
Senior Java Developer
Department of Health and Mental Hygiene
New York, USA
02.2008 - 08.2010
- Company Overview: DOHMH NYC is a government agency that works to provide good physical and mental health for New Yorkers.
- They have lots of programs and responsibilities to achieve their goal.
- They are slowly computerizing all their programs that are done manually.
- Designed and developed the PCTD (Pest Control Tracking Database), which is an internet application developed to automate the entire life cycle of tracking the rodents found anywhere in New York City until they are cleaned up, along with the follow-up of that case.
- Provided a web-based solution with a centralized database that will accommodate the daily business operations for the Veterinary and Pest Control Service.
- Developed using the Spring framework, with Spring IOC, and Spring JDBC, and Hibernate for communicating with the SQL Server 2005 database.
- The application uses a map component known as ArcGIS for plotting any address in NYC on the map.
- SPARK (Sports Play and Active Recreation for Kids) is a web-based solution to keep track of all the schools, daycares, and other programs that record coach visits, pre-surveys, and initial interviews for the teachers.
- ILITracker (Influenza-like illness) is a web-based application to record the shots, nasal sprays given every day in public and private schools in NYC for the consents related to influenza-like illness.
- Was solely responsible for requirements gathering, analysis, database design, software design, development, and testing for the entire application.
Java Developer
Saksoft Private Ltd
Chennai, India
05.2002 - 05.2005
- Company Overview: Verisens is a web-based application designed and developed by SakSoft.
- This application takes the feed files (delimited or fixed length) as input and uses an in-house tool to extract this data and store it in a data table, which is a one-to-one mapping with the data structure.
- These data are then transformed into report-level tables, which are then presented in the form of reports.
- These reports are also presented in a dashboard for easy analysis at a glance.
- Redesigned the presentation layer and business layer using J2EE design patterns to make the application portable, more stable, and to reuse components effectively.
- Developed JSP, servlet, and EJB components for developing the front-end of the application.
- Used MVC2 architecture (Struts framework) for developing the web tier using Eclipse.
- Developed service (EJB) components for the middle tier and implementation of business logic using J2EE design patterns on WebLogic App Server.
- Used EJB for creating user groups, setting up user privileges, and storing the user preferences.
- Developed the Controller servlet, a class for handling exceptions and logging.
- Generated the Key Performance Indicator report, which is a more challenging report that involves a lot of complexities in building the business logic, along with other standard reports.
- Worked extensively on packaging Java web applications using WAR files and deployment configuration using web.xml files.
- Worked extensively in XML for the generation of the user interfaces.
- Used a property file for storing data, like the number of lines to be displayed in a report, logging set to true or false, etc.
- Used JFreeChart to generate graphs and charts.
- I wrote queries using JDBC/SQL to retrieve data from the database, insert data into the database, and update data in the database.
- Participated in code reviews, performed unit testing, and integration testing using JUnit.
- Implemented a JavaScript library and tested the application for cross-browser functionality.
- I wrote deployment scripts using Ant on UNIX, and I wrote various utility scripts for the application using Unix shell script.
Education
Masters of Computer Applications - Computer Applications Development
Bharathidasan University
Tiruchirappalli, TN05.2002
Bachelor of Science - Mathematics
University of Madras
Chennai, India05.1999
Skills
- Java
- SQL
- AngularJS
- JavaScript
- Perl Script
- Struts
- Spring Boot
- Hibernate
- Eclipse
- IntelliJ
- Github Copilot
- Oracle 19c
- DB2
- MS SQL Server
- Apache Tomcat
- Weblogic 1221
- Websphere 80
- JSP
- Servlets
- Web services
- JDBC
- JNDI
- RestAPI
- Microservices
- Business Objects 51
- Informatica Powercenter
- HTML
- XML
- SOAP
- WSDL
- J2EE Design Patterns
- BitBucket
- ClearCase
- WinCVS
- Ant
- Maven
- TeamCity
- UrbanCodeDeploy
- Junit
Certification
2007, Sun Certified Java Programmer from Sun Microsystems
Timeline
Java Intermediate Programmer Analyst/Senior Developer
Citicorp
08.2022 - 11.2024
Senior Java Developer
Verizon Wireless
06.2011 - 05.2013
Senior Java Developer
Department of Health and Mental Hygiene
02.2008 - 08.2010
Java Developer
Saksoft Private Ltd
05.2002 - 05.2005
Masters of Computer Applications - Computer Applications Development
Bharathidasan University
Bachelor of Science - Mathematics
University of Madras
Similar Profiles
Renata Amber Muthersbaugh KentRenata Amber Muthersbaugh Kent
Manager at CiticorpManager at Citicorp
Nandan SubramanianNandan Subramanian
Full Stack Technical Lead at CitiCorpFull Stack Technical Lead at CitiCorp
SWAPNIL KOTHALESWAPNIL KOTHALE
Senior Data Engineer at CITICORPSenior Data Engineer at CITICORP