Lead Software Engineer
Currently working in the development, enhancement and maintenance of Visa's loyalty backend applications as a technical team lead and architect.
Worked on following projects as technical lead and architect:
Hadoop - Proof Of Concept
Proof of concept using Hadoop framework and technologies to understand the following: 1) Feasibility of moving existing heavy-duty batch processes to Hadoop 2) If feasible, compare the performance between current process and Hadoop process. One of the existing batch processes that were running in AIX using Ab Initio was selected and converted to Hive. Feasibility study was completed and performance comparison report was produced.
Data quality program was initiated to enforce high quality of data in various loyalty application systems and data repositories. Loyalty data quality process framework was designed to do two things: 1) generate value census data and feed data quality platform 2) generate custom alerts for various loyalty applications. Data quality platform will store value census data and develop a pattern based on the historical information. Alerts will be generated when a spike or dip is detected based on the historical trend.
Card/Account Number Encryption Service (CES)
CES is a service that enables various loyalty backend applications to encrypt/decrypt card account numbers in files using 3DES algorithm. This is primarily used by applications when there is a need to exchange files with organizations outside of Visa.
Visa Mobile Applications
Visa Mobile distribution strategy was to launch Visa mobile applications on the following prioritized platforms: Android, BlackBerry & iPhone. Consistent with this strategy Visa commercialized its first set of applications (alerts, offers & locator) on Android in Dec 2008. Following service components were developed to support Visa Offers and Visa Locator services:
- Web service to do real-time cardholder enrollment
- Merchant address geo-coding to support locator service
- Offer creation through file interface
Cardholder Information Repository (CIR)
CIR is the information repository that stores details of Visa reward cardholders. This information is used by many different applications within Visa. Visa receives cardholder details from Visa card issuers and processors using fixed format files, securely transferred to CIR backend ETL server on a daily basis. ETL application receives, validates and loads this information into CIR database. This application was running in Visa’s mainframe computer system using DB2 database. As the incoming data volume increased and business logic used to validate and transform the data became more and more complex, it was getting very expensive to run this application in mainframe systems; both from an elapsed time and cost of ownership perspective. So this application was re-engineered and moved to UNIX platform with a 300% performance improvement and significant reduction in total cost of ownership.
Visa Incentive Network (VIN)
Visa Incentive Network provides select merchants with greater and more targeted access to select Visa cardholders. Cardholders will receive valuable, relevant offers from these merchants; increased spending will result as will cardholder loyalty to our Issuers and Visa.
Visa Incentive Network is composed of three major functional components, each with its own processes, participants, systems and requirements. These are:
- Promotional offer creation
- Cardholder and Transaction database
- Promotional offer execution