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

Uniform Loan Delivery Database ULDD is data store of all the data pertaining to Loans, Pools and Commitments.

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

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Developed and deployed Stored Procedures based on the functionality of the application.
• Proficient in loading data to staging, data sourced from excel and flat files.
• Handled Production Support issues such as reloading securities, loading classification files, loading Participant Group load files, removing redundant kickouts.
• Updated SQLs for deploying table/sp/sql commands appropriately.
• Worked in UAT, BUAT, and PRODUCTION environments to create, update, or delete JIL files.
• Worked extensively in Production Support for supporting the application.
• Created many batches using KSH for data retrieval and loading from other applications and databases.
• Monitored AutoSys Jobs and handling exceptions for day to day jobs.
• Error handling in AutoSys in different environments.

Technologies :

T-SQL, Sybase 12.x, ISQL, DBArtisan 8.1, ETL Data Stage , UNIX, Putty, Windows 2000, MS Office 2003 Excel, Word, Power Point Presentations

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Created multiple Tables as required for the process based on the Data Model designed and previous existing tables.
• Developed and deployed several indexes and Stored Procedures based on each functionality of the application. Manually loaded data into tables using Shell scripts.
• Developed Shell Scripts to set as Crontab jobs. Update or modified some other interrelated stored procedures.
• Developed Shell Scripts for Data Validation/Reporting System by retrieving data from database using Stored Procedure.
• Created PERL/CGI scripts with DBI/DBD to serve the front-end. Used DBI/DBD for Sybase connection.
• Manual Validation of the Data sent and received from other Systems.
• Testing and Bug Fixing in Workflow Bridge in Development and QA.
• Deployed enhanced error handling in stored procedures, shell scripts and PERL scripts.
• Was extensively involved with optimizing existing stored-procs for better performance
• Created different presentations and documentations for the formulated procedures to get it approved by manager before deploying.

Technologies :

T-SQL, Sybase 12.x, PERL, AIX UNIX KSH, Aqua Data Studio, Windows XP, MS Office 2007 Excel, Word, Power Point Presentations

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Created new tables in Sybase based on the Data Model.
• Worked extensively in Sybase using TSQL. Created many batches using KSH for data retrieval and loading from other applications and databases.
• Developed many Stored Procedures for different functionalities like searching, creating groups, etc
• Developed Unix Shell Scripts to handle whole process in backend as well backup process to the GUI Role Management Tools and reports.
• Data Validation/Verification and Monitoring Applications to monitor the exception for each tool and in case of any failure these applications will send automated mail to the group.
• Formatted data into required format and manipulated data using UNIX Shell Scripts, SED and AWK.
• Developed Perl/Shell Scripts to retrieve the data from different tables and also from the specific directories/Locations, format the data and to verify the data before loading into Tables.
• Data Load from flat files into tables using BCP in PERL and KSH.
• Worked extensively on PERL based database work using DBI/DBD.
• Created documentations for Scripts, stored procedures, tables, etc...

Technologies :

Sybase 12.x, T-SQL, ISQL, Putty UNIX, PERL, Windows XP, MS Office 2007 Excel, Word, Power Point Presentations

Confidential

Job Title or Position : Sybase Developer

Responsibilities :

• Involved in the design and development of the system from gathering requirements to development and maintenance of the system.
• Designed and developed many Tables, Stored Procedures and Triggers.
• Involved in the Business requirements meetings, coordinated with the Business Analysts and UAT Plan for the implementation of new features
• Troubleshooting the existing modules and expansion. Was involved in bug-fixing by tracking the root cause.
• Developed shell scripts for the data formatting and manipulating.
• Tremendous exposure to tuning SQL queries for optimization.
• Written many Perl/KSH scripts for data extraction and loading data into the database
• Was extensively involved with optimizing existing stored procedures for better performance
• Developed and scheduled many CRON jobs using Shell Scripts in Crontab.
• Testing new modules and created documentation and test cases.

Technologies :

TSQL, MySQL, UNIX, KSH, PERL, Sun Solaris 2.4, Html, MS-Office 2003, Window 2000 Professional.