Summary:

• Total of 10 years of IT experience in various RDBMS like Sybase ASE /IQ 15.x, 12.x, Oracle 9g and scripting languages like Perl and UNIX SHELL Scripts.
• Proven ability in system analysis, design, development, testing, documentation, implementation and production support of financial software applications using industries best practices and methodologies.
• Excellent experience in database development with some DBA activities, handling and maintaining large databases and applications, Autosys, Batch processes.
• Excellent experience in performance tuning and optimization of Stored Procedure, and Triggers.
• Very good experience in PERL, UNIX, Shell scripting.
• Excellent financial/Investment banking knowledge of trade processing, transaction classification, securities, equities trading, compliance regulations applications, wealth management, Account performance and MIS Management Information system
• Excellent interpersonal, written and oral communication skills. Ability to multi-task, meet deadlines and translate business requirements into functional products.
• Ability to interact with direct business users for various technical and non-technical discussions during the complete software life cycle.
• Strong analytical skill for cracking problems and analyzing data.

Technical Skills:

• RDBMS: Sybase ASE/IQ 15.x, 12.x, SQL server, Oracle 9g
• DB Tools/Language: T-SQL, I-SQL, PL/SQL, SYTS, DB Artisan
• Languages: PERL 5.0 / Unix Shell script
• Operating System: UNIX, Linux and Windows
• Others: CVS, Perforce, MS-Office, Internet, Intranet, Shell scripts, Exceed
• Specialization:
• As a SYBASE /SQL Developer with PERL:
• Extensive Data oriented development
• Development of Triggers, Stored Procedures, and Views for Sybase to use the best execution plan, validation and maintain database integrity and consistency.
• Tuning and optimization of Stored Procedures, Triggers for performance gains.
• T-SQL, I-SQL, W-ISQL, Linux, Unix Shell scripts , Windows 95/98/NT/2000/XP.

Experience:

Confidential

Senior Database Developer/Lead

• Working for various PWM Private Wealth Management Technology applications like Account Performance and MIS Management information system
• Extensive database design and development in coordination with global team
• Involved in Functional/Technical specs following complete SDLC for various projects within Account Performance and MIS system
• Excellent knowledge of SQL and reporting
• Creating/Altering Triggers on database tables for data consistency/integrity.
• Tuning and Optimizing the Triggers, Stored Procedures, SQL to achieve best performance using SHOWPLAN and Statistics IO.
• Writing Unix batch jobs for transferring/updating data from other data sources.
• Handling time critical and sensitive data related queries from firm wide Controllers.
• Extensive work in scripting language like Perl and Unix shell script
• Ability to understand the system with minimum guidance
• Good analytical skill and ability to follow up the various task till completion

Confidential

Senior Sybase / SQL Developer

• Database batch design for BNP Prime brokerage's daily and monthly option expiration process
• Involved in the design and implementation of converting the domestic prime brokerage to international prime brokerage from batch and reporting perspective.
• Designing and developing the complete batch systems for the Arrange Finance process.
• Working with the business analyst for understanding and doing analysis and design for the development of transaction, position and balance batch processing system.
• Involved with the business end users during the testing and implementation phase.
• Involved in writing efficient migration scripts involving huge amount of data
• Creating/Altering Tables, Indexes, and Stored Procedures for data processing, retrieval, updating, inserting, deleting from the Sybase database.
• Writing PERL scripts to import, export, BCP data between servers.
• Writing Unix batch jobs to check for data integrity at scheduled time between database servers.
• Maintain and provide data to the users as and when requested.
• Writing Unix Shell scripts to read application logs create statistical application usage reports.
• Providing useful tips and techniques of data access to the application development team.
• Defining various autosys jobs for processing of huge volume of data in batch process.
• Involved in support in case of emergency attention.

Environment: Sybase ASE 12.x, PERL, T-SQL, I-SQL, W-ISQL, Aqua data studio, Erwin, UNIX/Linux, Autosys

Experience:

Confidential

Senior Sybase Developer/Architect

• Designing and developing the complete batch systems for the GRRS and GMARRS applications for huge volumes of data.
• Defining interfaces for data access layer.
• Working with the business analyst for understanding and doing analysis and design for the development of the batch processing system.
• Involved with the business end users during the testing and implementation phase.
• Setting standards for data access between application layer written in JAVA and data layer.
• Creating/Altering Tables, Indexes, Stored Procedures for data processing, retrieval, updating, inserting, deleting from the Sybase database.
• Creating/Altering Triggers on database tables for data consistency/integrity.
• Tuning and Optimizing the Triggers, Stored Procedures, SQL to achieve best performance using SHOWPLAN and Statistics IO.
• Writing Unix batch jobs for transferring/updating data from other data sources.
• Writing PERL scripts to import, export, BCP data between servers.
• Writing Unix batch jobs to check for data integrity at scheduled time between database servers.
• Maintain and provide data to the users as and when requested.
• Writing Unix Shell scripts to read application logs create statistical application usage reports.
• Providing useful tips and techniques of data access to the application development team.
• Defining various autosys jobs for processing of huge volume of data in batch process.

Environment: Sybase ASE 12.x, PERL, T-SQL, I-SQL, W-ISQL, Exceed, DbArtisan, Erwin and UNIX/Linux,Autosys, IBM eServerBlade LS20 - OS Red Hat Linux Pentium clients running Windows XP

Experience:

Confidential

Database Developer

• Developing, maintaining and supporting of an Equities Prime Brokerage system as a backend developer using Sybase 12.5/ Unix Shell Script / Transact Sql / Perl / Performance Tuning / Crystal Report.
• Extensive UNIX and Perl scripting in developing and maintaining Trade processing system.
• This project helped me gain good domain knowledge in the Prime Brokerage Business Equities / FI / FX
• Tuning of existing Stored Procedure for better application performance. Developing and changing new Sybase 12.5 Stored procedure as per business requirement
• Development of Java Classes for Swift Messaging. The Java Classes I developed were for swift message MT541, MT542, MT 535 Inbound/Outbound messages. Developed a Java class tool to read / write and generate Microsoft Excel file. This was very helpful in automation of extract generation in excel format and mailed to business user.
• Running, supporting and developing jobs scheduled on Autosys.
• Upgraded Sybase version from Sybase 11.9 to Sybase 12.5. Sybase 12.5 has many new features like extended cache memory up to 4 GB and supports 64 bit processors. This project helped in huge performance improvement in the execution timings for stored procedures and Jobs.
• High level design and detailed design for various enhancements and change request. I was actively involved in taking Business Requirement for the Business users for new development projects.
• Reviewing Unit testing of code changes and test plan design. Actively involved in the various Stages of the project starting from Requirement Analysis, development, Testing and finally migrating to production.

Environment: Sybase ASE 12.x, PERL, T-SQL, I-SQL, W-ISQL, Exceed, DbArtisan, Erwin, JAVA and UNIX/Linux,Autosys