SUMMARY:

• More than 7.7 years of strong technical/functional experience in financial services in the areas of Private banking, Trading applications,Asset and wealth management Working with Confidential technology solutions in the Banking and Financial services as a Senior Database Developer with primary role as a Sybase ASE developer for more than 7.7 + years
• Successfully, acting as key member in role Database owner for applications projects created from scratch successfully developed, enhanced project, database and reporting part using Sybase 12.5/Sybase 15,migrating from Sybase Upper versions from Sybase 12.5 to Sybase 15.7, had hands on experience in building crystal reports with integration to Business Objects for crystal reports deployment, during my initial 2.5 years start of career with major project worked on for migrating all reports in legacy ACTUATE reporting technology to Crystal reports XI with database Stored Procedures/SQL s required to integrate with reporting tool.
• Successfully developed, enhanced and maintained trading and Business applications
• Expertise Strong Development/Support experience in SQL/TSQL programming in Sybase ASE 12.5/15, UNIX (Shell Scripting) and Perl, Crystal Reports, VB 6.0 technology
• Insightful exposure to Banking related applications, Instruments, as well operation and finance reconciliations in an Investment bank.
• An effective communicator with good written & verbal communication skills. Flexible to adapt to new environments.
• Performance & Tunings of Databases for Queries, Stored Procedures and Trigger optimization.
• Good knowledge of Sybase architecture; memory model, transaction processing, storage concepts, security/account setup and backup/recovery procedure.
• Good experience in Shell scripting on Linux 2.24, HP - UX11i/SUN Solaris.
• Report development using Crystal Reports XI.
• Writing, debugging and troubleshooting complex queries and stored procedures in Sybase ASE environment (12.5/15.7)
• Development and Enhancements of Stored Procedures, Views and Unix scripts to implement the business logic.
• Batch job scheduler with integration of unix and Sybase framework for Business validation and other trading related validations and control reporting.
• Software Development
• Client interaction for system study, requirements gathering and analysis.
• Designing, Developing and Coding.
• Debugging and troubleshoot the application.
• Extending post go-live and application maintenance support to the users.
• SDLC Planning & Management
• Actively Involved in Solution Design Phase for the clients requirements.
• Identify business core / critical system / processes and priorities.
• Resolve support/operational issues in liaison with project managers & business group.
• Develop, implement & provide all kinds of support for business application software for clients
• Achieve customer satisfaction by ensuring service quality norms and building the brand image by exceeding customer expectations.
• Handle testing phase of the project. Ensure all necessary data and matrix is generated and maintained.

ORGANIZATIONAL EXPERIENCE:

Confidential

Database Developer /Systems Analyst/Onsite DB lead

Responsibilities:

• Users have the ability to review all components of the fees for any account and request concessions.
• Fees to be fully transparent to Front Office and simplistic to instruct at account opening.
• Understand the Fee Billing infrastructure and business content within the Fee Setup automation will be conceived and evolved.
• Ensure efficiency goals align to business goals.
• There are a numerous benefits such as Fees setup systematically at time of account opening, Fee Schedule systematically derived based of account attributes, Transparency into real-time fees from Fee Portal (including current setup AND pending/historical fees),Users can now request fee maintenance updated through Fee Portal, Automated approval routing confirming to concession guidelines, Enables faster processing of changes Immediate fee updates appear (change from 5 day SLA to 30 seconds ),and so increases transparency and Bridge the gap to Standardize Fees and reduce errors.
• Work closely with application development team to develop, enhance and tune Database Objects and components in Sybase ASE 12.5/15.7

Environment: Sybase ASE 12.5,15 + versions, Windows 7, i-space, PERL, UNIX, Batch Schedulers, ERWIN Data modelling

Confidential

Database Developer /Systems Analyst/Onsite DB lead

Responsibilities:

• Work closely with application development team to develop, enhance and tune Database Objects and components in Sybase ASE 12.5/15.7

Environment: Sybase ASE 12.5,15 + versions, Windows 7, i-space, PERL, UNIX, Batch Schedulers, ERWIN Data modelling

Confidential

Database Developer /Systems Analyst/Onsite DB lead

Responsibilities:

• Work closely with application development team to develop, enhance and tune Database Objects and components in Sybase ASE 12.5/15.7

Environment: Sybase ASE 12.5,15 + versions, Windows 7, i-space, PERL, UNIX, Batch Schedulers, ERWIN Data modelling

Confidential

Database Developer

Responsibilities:

• Team Member (analysis, coding, testing) and reviewing and coordinating with onsite
• Responsibilities included analysis, design, construction, & Implementation and analyses requirement specifications and creates technical specifications.
• Prepares analysis documents, prepares and reviews the test cases and validates the approach.
• Worked actively into coding and code review and carries out data validation. Also logs defects and verifies the defects after fix.
• Also assists during user acceptance testing and works as Primary on-call person for Application Development related issues.
• Played a pivotal role in establishing Database migration, which includes migration of existing TIMS database.

Environment: Sybase ASE 12.5,15 + versions, Windows 7, PERL, UNIX, Batch Schedulers, ERWIN Data modelling

Confidential

Developer

Responsibilities:

• In this project as a team member, participated in the maintenance of critical banking applications like ICR and ITM and also new Enhancements Aware of private banking critical trading cycle worked a lot with Client Performance, Trading etc.
• Which is one of the very critical part of private bank Experienced working on Reporting solutions using Crystal Reports by creating new reports as per the FSD and deploying them in Business Objects and scheduling them too.
• Interface with Reporting and Database team with regards to understanding and resolving Issues.
• Experience in handling databases, query optimization, performance tuning and normalization by utilizing tools like SQL Browser
• Involved in New Enhancements and maintenance of existing front office applications.
• In all the above cases coordinated with onsite leads and to take care of the questionnaires and run the initiatives smoothly.

Environment: VB 6.0, Sybase Perl and Crystal reports with Business objects Central management Console.