Highlights:

Skills:12+ EXPERIENCE IN Oracle and PL/SQL Development, Unix Shell Scripting, DB EXP & IMP, FINANCIAL DOMAIN, APPLICATION PERFORMANCE TUNING, PRODUCTION SUPPORT

Tech Analyst 08/2012 - current
ANZ BANKING GROUP, SINGAPORE, Singapore
Industry: BANK
• Currently working in ANZ BANKING GROUP LTD, Singapore, as a Tech Analyst since Aug’12, with responsibility of development of Payments and Transactions system.
- Design, development Payment Transactions System which includes transforming the feed from the various core banking systems. Loading the feed with respect to business requirement and loaded transactions will be shown in online as a reporting channel platform for corporate and institutional banking. - Developing PL/SQL Programs, shell scripts, SQL Loaders. - Involved in the design and development Multi Channel Platform (MCP) which includes to load retail customer transactions with strategy of MiAM (Million in A Minute). Various core banking system will generate high volume of retail transactions (including card transactions) as a feed file, once the feed received, it will be transformed with required format as well as aligned with business requirements. After the successful transformation the feed will be loaded into oracle tables with locally managed partitions. Currently the volume of retail transactions is 20 Million per day. The 20 Million transactions will be loaded into the system in 20 mins which includes transformation. Loaded data will be available for reporting with required performance defined in Non Functional Requirement. - Involved in the complete cycle of SDLC. - Involved in performance tuning of Global Cash Plus application which is managed by vendor.--
Senior Application Consultant 05/2006 - 07/2012
National Computer Systems, Singapore, SINGAPORE, Singapore
Industry: IT SOLUTION PROVIDER
• Worked in National Computer Systems, Singapore, as a Senior Application Consultant since May’06, with responsibility of development and supporting Transactor Operational Data Store system.- Design, development and maintenance of Transactor system for Citibank. - Developing PL/SQL Programs, shell scripts, SQL Loaders for new requirement and enhancement of existing system. Also involved in performance tuning of the system.- Involved in the complete cycle of SDLC.
Transactor: Citibank downstream Operational Data Store system under Global Functions Technology Services for financial, MIS and local regulatory reporting, where it receives the various handoffs from the different Product Processors on daily basis. Received handoffs will be loaded to Staging Area via SQL*Loader, Prod*C, PL/SQL and Unix shell script. Once the data files successfully loaded, the core process will be done by using PL/SQL, Pro*C and Unix shell script. After the completion of core processing for data massaging, the output handoffs and reports will be generated and will be placed in ROD (Report on Demand) system for the various departments to retrieve the report. The report generation by using Datamanager, PL/SQL, Pro*C, Business Objects (BO XIR2) and Unix shell scripting. This application implemented 16 countries across Asia Pacific Region. Software : Oracle 11G, PL/SQL, Pro*C, Business Objects (BO XIR2), Unix Shell Script, HP,SQL Loader, Informatica 7.1.3. Period : May’06 to Jul’12 Role : Design, Development and Implementation.--
Senior Database Application Engineer 07/2002 - 05/2006
Standard Chartered Bank (Thru Ness Global Services), Singapore, SINGAPORE, Singapore
Industry: BANKING
• Worked in Standard Chartered Bank (Thru Ness Global Services), Singapore, as a Senior Database Application Engineer since Jul’02, with responsibility of development and enhancement of Webbank Application.
- Interact with Business Users and Business Analysts to study the requirements. Identifying the Business objectives. - Writing the technical specification documents for the business needs. - Preparing specifications and designing physical/logical models of DB. - Developing and testing the application. - Preparing the documentation for internal unit testing. - Performing the load testing on application with different scenarios and no. of expected users. - Ensuring the performance of the applications by tuning them. - Other responsibility includes automating the processes as much as possible and implementing new features in the applications.--
Database Application Engineer 05/2000 - 07/2002
Pacific Internet Limited, Singapore, SINGAPORE, Singapore
Industry: Internet Service Provider
Usage Processing For Billing System Collecting the customer’s various usage from various parties and loading to Oracle for billing system. Developing interface to view the different usage for customers. Administrating the hourly/daily cron jobs while transferring the usage files from various servers.
Gric (Global Roaming Internet Connection) and iPass Roaming Usage Process Project Description: Gric: This is automated job which will connect to GRIC FTP Server everyday and looking for the daily usage file. This usage file contains the PI customer roaming usage information, whoever roamed around the world. Once the file captured and it will be loaded to Oracle. This system detects the customer high usage and sending the alert email to customers in order to confirm the roaming usage. PI customers are able to view their roaming usage via web interface. Loading of data is developed by using pro*c language and the cron job implemented by using korn shell scripts, view the usage interface developed by using PL/SQL. If any failure detected during the execution of cron, the automated job will send the alert message to respective team mailing list for the related problem in order to take the action.--

B.Sc (Computer Science) from Bharathidasan University 01/1991 - 07/1994
THANJAVUR, , India
Degree: Bachelor's Degree
Major:Computer Science
Degree in Computer Science.

Guru Resume