SUMMARY

• 8 Years experience in the Management, Development and Maintenance of Database-based Applications and Projects.
• 8 Years of extensive experience working in developing client/server applications using Sybase, T-SQL.
• Experienced in the development of Software requirements Specification SRS at the Design phase.
• Experience in developing and testing application in Sun Solaris/HP-UX and Windows 95/98/2000 and NT.
• Expertise in Data handling using UNIX Shell, Perl scripts with TSQL, Sybase 11.x, 12.x
• Strong in Autosys
• Knowledge of CPAN modules dealing with Packages and modules.
• Experienced Sybase developer with expertise in T-SQL as Stored Procedures, Triggers, Views, Cursors, Indexes and Tables and Strong in Sybase query optimization and tuning.
• Programmed extensively in PERL, PERL DBI/DBD and Unix Shell Scripting to handle Data consistency and Reporting System.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Well-acquainted with Production Support Environment with a proven ability to work in a fast-paced environment and meet the tight deadlines.
• Worked extensively in Production Support 24/7.
• Full Life Cycle Experience including Analysis, Design, Documentation, Development, Testing and Implementation.
• Excellent written and verbal communication skills including experience in proposal and presentation creation. Experienced programmer with financial related applications.

Software Skills

Professional Experience

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Developed Stored Procedures for generating reports in Business Objects.
• Worked extensively in the SDLC 2.3.0 format environment.
• Successfully played role of a System Analyst and coordinated with the Business to get a better understanding of the requirements. Used DOORS 8.1 extensively to write technical specifications.
• Used Microsoft Visio to modify the interfaces pertaining to 2.8 release in the System Context Diagram for ARDB.
• Worked with the data modeler to configure/update ARDB data model.
• Created all the documentation Change Impact Assessment, Solution Specification, Solution Specification Review Report, Detailed Design, Operations Document for ARDB 2.8.
• Worked extensively on Unix platform to create, update, or delete JIL files and monitored Autosys jobs.
• Worked on C platform to modify code according to the requirement.
• Familiar with creating reports in Business Objects.
• Wrote test cases for Unit testing in Quality Center 10.0.
• Unit tested end-to-end to ensure the feeds that come from various interfaces, are populating the appropriate tables.
• Mentored junior developer in creating stored procedures in Sybase, modifying C code, creating batch jobs in Unix.

Technologies :

T-SQL, Sybase 15.x, ISQL, DBArtisan 8.7.4, SQLDBX, C, Business Objects XI 3.1, ER Studio, Telelogic/IBM DOORS 8.1 , UNIX 5.8, Putty, Clear Case 7.0.1.1, Clear Quest 7.0.1, Microsoft Visio, Quality Center 10.0, Windows XP Professional, MS Office 2003 Excel, Word, Power Point Presentations .

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Developed Stored Procedures per Business requirements.
• Developed shell scripts to import data from TSV files to database.
• Created test data and unit tested the stored procedures.

Technologies :

T-SQL, Sybase 15.x, ISQL, DBArtisan 8.7.4, SQLDBX, UNIX 5.8, Putty, Clear Case 7.0.1.1, Clear Quest 7.0.1, Quality Center 10.0, Windows XP Professional, MS Office 2003 Excel, Word, Power Point Presentations .

Confidential

Job Title or Position : Sybase Developer

Responsibilities

• Developed and deployed Stored Procedures for each new ticket launched in the Workstation OTC Tool.
• Worked on SDI Self-Directed Investments Brokerage Program ensuring that all OTC Orders entered via OTC Tool in Workstation in 'Closed' status will reside in SDI Trade database via Batch process
• Developed Scripts to clone the existing trade orders and re-use those orders numbers.
• Used SQL Browser to develop, test and deploy stored procedures and SQL scripts in Sybase 12.5 database server, Tortoise Subversion client to check in modified stored procedures and SQL scripts source code into Subversion repository.
• Created CUSIP emails for the new tickets.
• Modified Data-model to incorporate new fields added for the new OTC Tool tickets introduced. Also updated the corresponding data objects impacted by the modifications.
• Performed Unit testing in DEV environment and end-to-end Regression testing in SIT environment to create, update/delete trades and process all the 'Closed' trades in SDI Batch by ensuring that all the trades move from OL Server to TZ Server.
• Partnered with Business Analysts and Clients to obtain project requirements
• Generated Prism Revenue reports of all the 'Closed' trades.
• Performed SQL Optimization on the stored procedures that were slowing down the performance of the Application.
• Prepared live document for the SDI Batch process that makes RPC calls between the Database Servers.

Technologies :

T-SQL, Sybase 12.x, Subversion, Quality Center 9.2, YART Yet Another Release Tool , SQL Browser,

UNIX-Putty, Windows XP Professional, MS Office 2003 Excel, Word, Power Point Presentations