Experience Summary

• Sybase professional having 12 years of Programming experience in development Support Client Server Architecture applications using Sybase ASE 15.x, SQL Server 2008, Perl5, UNIX, PowerBuilder 12.1, Shell / VB scripting, C , Java, Oracle, ASP.
• Sybase ASE SQL Developer 12.5 Certified Professional.
• ITIL Foundation Certified in IT Service Management.
• Strong RDBMS Skills coupled with excellent troubleshooting and analytical skills.
• PowerBuilder 9.0 Certified by Brainbench.
• Has substantial domain experience in banking industry Business Financial process.
• Innovative, Creative, results-oriented Business Professional.
• Excellent communicator capable of developing professional relationships.
• Key strengths includes systematic thinking, problem-solving capability, ability to learn new technologies quickly and could easily adapted to new environments.

Summary of Current Roles / Responsibilities

• Lead Development / Support for the Trade Finance applications in the Investment banking Division supports Back office / Middle Office Operations.
• Involve in gathering requirements from the Business and create documentation for Functional / Technical specifications. Supporting developers / QA's to understand the Requirement for the new development and enhancement and ensuring the functionality expected.
• Involve in the Development / Database Performance Tuning / Database Architect / Performance Improvement to the existing process and DB Migration.
• Level 3 Supports for Support Issues, Solving Critical Business User Queries / Production Issues / QMW / BCP/DR Activities.
• Manage offshore Support/development resources.

Software Exposure

Languages : Perl, Java, C , SQL

Application Software : PowerBuilder 12.1, 10.0, 9.0.1, Visual Basic 6.0

Operating Systems : Solaris, HP-UNIX, IBM AIX 5.2, SCO-UNIX,

Windows 2K NT

Databases : Sybase ASE 12.5.x, MSSQL Server 2008, Oracle

Domain : Finance Investment Banking systems.

Web : .Net / ASP.net / VB Scripting

Scripting : Shell / batch scripting

Source safe : Tortoise SVN, Clearcase PVCS

Work Experience

• Worked as a Programmer/Analyst in Nuyu India P Ltd., Chennai from May 2002 to June 2003
• Worked as a Senior Programmer in Sterling Holiday Resorts I Ltd., Chennai from June 2003 to June2005
• Worked as a Sr. Program Analyst in Scope International - Standard Chartered Bank Consultant: Synetairous Technologies Ltd., Chennai from July 2005 to Mar 2006.
• Worked as a Team Leader-Project in CSC India Pvt Ltd., for CITI Bank, Japan from Mar2006 to Dec 2007.
• Worked as Technical Lead in Credit Suisse Bank, Singapore Consultancy: Encora Technologies Pte Ltd., Singapore from Dec 2007 to Apr 2013
• Working as Deputy Manager Project Lead in Societe Generale Investment Corporate Bank, Singapore from Apr 2013 to till date

Professional Experience

Confidential

Role: Lead Development / Support

Supported products

Commercial Letters of Credit - Letter of Credit for commercial goods in transit between an Importer and an Exporter. Includes Import Letter of Credit, Export Letter of Credit, Export Credit Bills, Shipping Guarantees and Reimbursements

Collections - Collection of payments for goods shipped without a letter of credit typically between known parties . Includes Outgoing and Incoming Collections.

Guarantees - Guarantee for non-commercial goods transactions includes Outgoing Guarantees, and Incoming Guarantees.

Standby Letters of Credit - Similar to Guarantees but may also be used for commercial goods. Generally used in the USD market where Guarantees are not allowed. Includes Outgoing and Incoming Standby.

Financing - Provides financing for payments due at a future date. Includes Acceptances, Deferred Payments and Loans

Miscellaneous Products More generic transactions for supplemental processing in the department. Includes clean Payments and Correspondence.

Environment:

Java, PowerBuilder 12.1, Sybase 15.1, SQL Server 2008, Perl, Unix, Windows Batch Script, C , Solaris, Windows 2008 R2 Server, HP-UNIX SVN.

Confidential

Role: Technical Lead

• Main Functionalities of the module:
• Trades Entry for various products such as Equities /FX/ MM/ Fixed Income /Prime Trading/ SBL / Repo etc
• Amendment / Reversing trade details flow to the downstream
• Trade / figuration Details Calculation / other Calculation specific to region.
• Various report for the Operation users
• Trade Pre confirmation / Settlement Confirmation's
• Pre matching

Confidential

1. CnS Module: Clearance Settlement Module

• Main Functionalities of the module:
• Query trades Equities /FX/ MM/ Fixed Income /Prime Trading/ SBL / Repo etc
• Amend SSI Instructions
• Authorize changes
• Settle / Status Changes
• SSI Instructions Refresh

2. Cash Record Module: Cash Journal

• Main Functionalities of the module:
• Query journals
• Entry by Reason
• Entry by Account
• Receipt / Payment Entry
• Cancel Entry
• Fund Transfer

Confidential

Society for Worldwide Interbank Financial Telecommunication SWIFT is a shared worldwide data processing and communications link and is a common language for international financial transactions.

SWARM stands for 'Swift Authorization and Release Module'. SWARM module is capable of generating various SWIFT messages i.e. MT210, MT202, MT515, MT54x, MT199, MT299, MT4XX series, MT535, MT536, MT544, MT545, MT546, MT547, MT548, MT599, MT940, MT950, MT999 etc., and it provides an interface to send out SWIFT messages to clients. It also processes incoming messages from clients/custodians and in turn provides settlement related inputs to Clearance Settlements. SWARM also publishes messages to Intellimatch for reconciliation done in Intellimatch .

The SWARM UI is used by two sets of users Maker and checker. The maker picks up each trade from the UI and creates a SWIFT message. The checker authorizes and releases the message out.

Interact with Clearing Agents like MAS / Euroclear / Clear Stream / Austroclear.

Confidential

• Client Preferences Module
• Market Charges Module
• Commission Maintenance Module
• Statement maintenance Module
• Delivery Instruction SSI
• Confirmation
• Core Customer Information
• SIMBA modules

Confidential

Environment:

Perl5, PowerBuilder 9.0.1, Sybase ASE 12.5.3, Java, .Net / ASP, Oracle, C , Solaris, HP-UNIX, SVN/Clearcase

Confidential

Role: Team leader - Projects

• 1. Project: BAFFA
• Bonds and Futures Product Processor BFPP provides the complete financial solutions for Bonds, Futures and ETO which are being bought sold by Citibank Tokyo in the open market.
• Deal/position maintenance query facility to front office. Deal enrichment / maintenance facility to back office. Since the front office back office requirements are integrated in the same system, both will use the same deal information thus avoiding reconciliation issues. This will be Static data maintenance for bonds, futures and ETO. Generate accounting entries. Provide reports queries on the deal accounting data.
• 2. Project: FSViewer
• Factor Sensitivity Viewer is a system to monitor the effects of movements of different market parameters like interest rate, spot rate etc. for all the derivatives and foreign exchange products. Both Front Office and Back Office use this system.
• This is system is a Complete Tokyo Market Risk Database.
• Generate all Limit monitoring and Market Risk Management Reporting Capability in one place.
• Provide Flexible inquiry and report generation utility by end users Risk Management or Trading Room .
• Provide appropriate functions for manual adjustment entries to input test market transactions exposures or other cases where automated feed is not possible or economic. However provide appropriate audit trail and controls to keep track of such adjustments.
• Create an environment and infrastructure for on-line FS monitoring in future, when more flexible technical connectivity will be possible between product processors and risk management database/system.

Responsibilities:

• Preparing Impact Analysis, Effort Estimation, Functional/Technical Specification.
• Involved Enhancement in the Back End Sybase Front End PB
• Writing Shell Scripts
• Troubleshooting user problems in programming related activities.
• Preparing SDLC/Process Documentation. includes MDD, ISQ, UATP, UATR, SITP, SITR
• Involve Testing, preparing Test Cases Test Condition
• Raise a Change through Infoman, Track the Production Problem through Virtual Ticket
• Directly Interacting with Client Manager, Business Users, Change management Team, and Implementation Team.
• Support to user to conduct UAT.

Environment:

Perl, PowerBuilder 9.0.1, Sybase ASE 12.5.2, C , HP-UX, Windows 2003 Server, PVCS.