Experience Summary:

Techinal Summery:

• 10 years of experience in the field of Software Design, Development and Implementation life cycle SDLC including analysis, design, architecture, development, testing, implementation, maintenance and production support of application software.
• Been an active team member and has worked on developing utilities using C C, SYBASE ,ORACLE PL/SQL ,with UNIX PERL, ,UNIX Shell Scripting
• Involved in supporting applications running in Production environment and providing on time help to the application users..
• Operating Systems HP-UNIX 11i, Solaris 5.8, AIX UNIX, windows.
• Strong knowledge in Sybase ASE database programming using T-SQL Stored Procedures, Buit in Functions, Triggers, Cursors etc.
• Good exposer to Oracle PL/SQL database programming using PL/SQL Packages ,Functions,Stored Procedures, Buit in Functions, Triggers, Cursors etc..
• Expert in RDBMS logical and physical Database Designs with excellent Normalization and De-normalization techniques for efficient data storage and retrieval
• Analysis, Design, Coding, Testing, Implementation, Documentation, Post Implementation Production and Application Support
• Experienced in Query Optimization, Debugging, Performance Tuning Using MDA tables and Improvising performance of applications using SQL Trace and Explain Plan to analyze queries for efficient data retrieval.
• Very good understanding of Partition, Indexing and Optimization Goals of Sybase 15x.
• Designed, Developed/Wrote and altered/enhanced/modified various database objects such as Tables, Stored Procedures, Views, Triggers, Indexes, Rules, and Defaults ,Functions, Packages etc..
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures.
• Solid knowledge of Object Oriented Programming concepts ..
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures.
• Writing scripts that perform optimizations and automation of daily batch jobs
• Domain And Functional Summery:
• Out of my total 10 yr experience I have worked around 8 years in Equity/Derivative trading, clearance and settlement
• Have worked on real time low latency high frequency trading engine for 2 years..
• Having Very good expose to Trading, clearance and settlement..
• Involved in New Development/Maintenance/Modification/Enhancement of software application in Capital market, Equity, Derivatives, Bonds, Features and options.
• Worked extensively on market Risk of products Like Government security Division GSD , Mortgage backed security division MBSD and portfolio clearing and settlement..
• Woked extensively on Equity trading and understanding of Trade Life Cycle..
• Involved in designing Trade repository ware house..

Technical Skills:

Confidential

Role: Senior Sybase Developer

Roles:

• Responsible for creating database object like Procedure, Function, Trigger and Cursor.
• Responsible for code optimization and database performance tuning.
• Database designing ,TSQL Programming and identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Requirement gathering and putting in technical frame work.
• Involved in writing Functional Spec and Technical Spec
• Supporting existing application of DTCC RISK engine ex- Risk Surveillance ,FIR, IMM etc ..
• Used Perl scripting for data validation..
• Worked on UNIX Shell scripting for scheduling and automation of application..

Environnent: AIX UNIX, Sybase 15.0 ,T-SQL ,PERL Scripting ,Shell Scripting

Confidential

Role: Senior Sybase Developer

Responsibility:

• Technical Design for DB.
• Supporting existing application of DTCC RISK engine ex- FIR, IMM,NYPC VAR,SPAN etc ..
• Development and maintenance of database procedures, reports and automated jobs Ongoing maintenance of assigned and unassigned database projects
• Responsible for database performance tuning and working as a subject matter expert SME of this application.
• Responsible for creating database object like Procedure, Function, Trigger and Cursor.
• Data cleanup data movement between various environments i.e. Development, Staging and production.

Environment: AIX UNIX, Sybase 15.0 ,T-SQL PERL ,Shell Scripting

Confidential

Role: Sybase Developer

Roles:

• Responsible for creating database object like Procedure, Function, Trigger and Cursor.
• Responsible for code optimization and database performance tuning.
• TSQL Programming and identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Additonally this will write code for database access, modifications, and constructions including stored procedures.
• Requirement gathering and putting in technical frame work.
• Supporting existing application of DTCC RISK engine ex- FIR, IMM,NYPC VAR,SPAN etc ..
• Used Perl scripting for data validation
• Involved in designing and development of of trade warehouse. By extracting and loading data from distributed database to warehouse database.

Environment: AIX UNIX, Sybase 15.0 ,PERL , Unix Shell Scripting

Confidential

Role: Sybase Developer

Roles:

• Written perl and shell scripts for the automation of the system.
• Database Design TSQL Programming.
• Technical Design for DB.
• Involved in debugging and troubleshooting.
• Responsible for database performance tuning.
• Client Interaction for Requirement analysis and monitoring the project.
• Data cleanup data movement between various environments i.e. Development, Staging and production.

Environnement: Sybase 15.0, T-SQL, C ,AIX UNIX, PERL Scripting ,Shell Scripting

Confidential

Role: Sybase Developer

Roles:

• Database Design TSQL Programming.
• Technical Design for DB.
• Responsible for database performance tuning.
• Responsible for creating database object like Procedure, Function, Trigger and Cursor.
• Data cleanup data movement between various environments i.e. Development, Staging and production.
• Development and maintenance of database procedures, reports and automated jobs Ongoing maintenance of assigned and unassigned database projects
• Enhancement of existing database functions based on new/changing business requirements
• Report, research, correct, and test defects in reports, stored procedures and other database related functions
• Involved in designing and development of of trade warehouse..

Environnement: Sybase 15.0, T-SQL, C ,AIX UNIX, Shell Scripting , PERL Scripting

Confidential

Role: Sybase developer

Roles:

• Conducted system study and gathered requirements
• Involved in the process of database design for the entire application
• Modified, maintained and developed the TSQL codes to develop new enhancements
• Performance tune the existing long running stored procedures.
• Client Interaction for Requirement analysis and monitoring the project.

Environnement: Sybase 15.0, T-SQL, C ,AIX UNIX, Shell Scripting,