Summary:

• 9 years experience in systems analysis and design of mission critical applications in capital markets.
• Well versed with all modules of settlements and reconciliation business functions.
• Working knowledge of Securities pricing, reference data and portfolio accounting.
• Expert programming skills in Sybase and SQL Server.
• Intermediate programming skills in Oracle.
• Comprehensive knowledge of the trading life cycle, settlements of equities and fixed income trades with brokers on Omgeo, foreign exchange transactions on Global link, and system notifications to custodians, investment managers and other interested parties.
• Expert in PERL for file handling, data manipulations, reports automation and system generated notifications to custodians.
• Expert in third party vendor products such as Transaction Lifecycle Management and Heliograph.
• Strong knowledge of SWIFT message types and administration. SWIFT is a global platform for secure, speedy and certain transmissions of financial messages between member banks.
• Project management experience managing critical projects with teams based in onshore and offshore locations.
• Well versed with all areas of Project management such as managing scope, time, resource, quality, and coordination with global teams.
• Team management experience of leading and managing teams at onshore and offshore locations.
• Production support expert of mission critical systems and taking full ownership of issues until resolution.
• Very strong knowledge of working with Excel for data analysis and completeness. Well versed with excel functions such as vlookup, concatenate, mathematical functions, pivot tables, macros, and charts.

Experience:

Senior Technical Architect / Team Manager - Consultant.

Project: Reconciliation Settlements Technology

Description: Application maintenance and system enhancements for reconciliation and settlements functions.

Responsibilities:

• Team Manager for the team of 6 resources located at onshore and offshore offices. The primary responsibilities of team include L3 support, user support, system enhancements, bug fixes, system upgrades and migrations.
• Implemented third party vendor product Transaction Lifecycle Management TLM . Develop business rules scope, pass, initiation , searches, search lists, match pass, pass lists, initiations, asset register, and message types in Recon Admin.
• Created workflow tools in TLM for new business functions such as auto casing of breaks.
• Created reports on Design Studio using charts, forms, and grids for TLM Web Connect.
• Customized TLM Smart Schema middleware for new business modules and attributes.
• Developed and optimized Sybase procedures for complex business modules and new business functions.
• Developed Perl/UNIX scripts to load raw data from files to database, generate reports in excel/comma separated format, auto mailer to recipients by querying from database the recipient's email addresses and report subject.
• Performed performance tuning of Sybase Procedures. Designed system database schema and developed business centric Sybase procedures and triggers.
• Developed Perl modules to ftp files to recipient server via firewall authentication.
• Migrated Sybase v12.5 to v15.7 as the product reached end of support phase.
• Coordinated with onshore and offshore teams, conducted weekly status updates meetings with client for tracking progress and prioritization, quality review of deliverables made by teams, testing with users and other teams, maintenance of test environment, and worked with system administers for upgrades and packages deployment.
• Production support of applications and batch processing. Setting up monitoring and preparation of resources weekly rotations for support.
• Root-cause analysis of production issues and solutions recommendation for permanent resolution.
• Yearly support for disaster recovery and business continuity organizational practices.
• Generated pivot tables and macros on excel to assist the client manager in budgeting and costs allocation.

Environment: Sybase 15, Rapid SQL, Linux, Perl, TLM Design Studio, TLM Recon Admin, TLM Smart Schema, TLM Configuration Input, TLM AAS, Control M, Windows 7

Confidential

Sybase Developer -

Description: The Investment Management Division maintains and supports the trading and reporting applications for investment management clients. The team undertakes maintenance and enhancements in the applications as requested by business users.

Responsibilities:

• Developed and Optimized Sybase procedures and triggers.
• Developed workflows and mappings in Informatica.
• Developed Perl/UNIX scripts to generate reports and load data from files to database.
• Coordinated with business users for requirements gathering, testing, post rollout issues, and new enhancements.

Environment: Sybase 12.5, Rapid SQL, DB Artisan, Windows XP, Sun Solaris, PERL, Informatica 8.1

Confidential

Module Leader

Project: International Private Banking IPB Technology.

Description: IPB Team owns and maintains the applications used by Business Users Front, Middle and Back Office Teams and resolves any issues/bugs/errors in the applications depending on the Priority and Impact of the incident. For long term resolutions defects are raised and resolved, tested and approved by the tester and rolled out in production.

Responsibilities:

• Developed Sybase Stored Procedures, Triggers, and Queries for Reports for JP Morgan Chase Suite of Products such as Client Position, Atlas, GRT, Head sheet.
• Module leader for trading applications used by Front Office, Middle Office and Back Office Business Users for trade initiations, verifications and reconciliation with the Balance Sheet.
• Involved in Production support for reporting, trading and interfaces applications of JP Morgan Chase.
• Worked with Incident managers and risk managers on day to- day basis for immediate resolutions with respect to trades getting blocked, account positions not refreshed, expired contracts still appearing in the system.
• Released new database objects into production for every weekly and schedule release.
• Developed new reports and enhanced existing reports for the Risk Evaluation System so that the Risk Team is aware of any discrepancies in the system by going through the report mailed to them every day after markets close across the geographies. Such risks can be short sale in some accounts accounts tax exemptions depending on the domicile of the account holder or financial institution.
• Developed Sybase Tables and views with proper access to these objects for various groups of business users with respect to their roles assigned.
• Did Performance tuning for better performance and reporting. This reduced the SLA Service Level Agreements timings that JP Morgan IPB LOB has with other LOB.
• Migrated TSQL scripts to ANSI SQL for many stand alone queries for better reading and business norms.

Environment: Sybase 12.5,15, DB Artisan, Windows XP, Sun Solaris, UNIX, PERL, AS400