SUMMARY

• Around 12 years of total IT experience in client server architectures relational databases.
• Extensive Hands-on experience with Sybase Systems 12.5/11.9.2, Perl, SQL DBArtisan
• Extensive experience in backend perl Shell Programming.
• Experience in DB designing , performance tuning , schema designing that includes creating Tables, Primary Keys, Foreign Keys, and Constraint Statements, Triggers for creating new and customized databases.
• Extensive experience working with Financial, Brokerage Companies and Banking Systems.
• Excellent communication and interpersonal skills, strong personality and self motivator.

TECHNICAL SKILLS

• Operating Systems: SUN Solaris, HP-UX, Windows 2000/NT
• RDBMS: Sybase System 12.9.5/12.5/11.9.2/11.5.01/11, Uniface
• GUI Languages: Apt Workbench, SQR, Convoy, SQL and ERWIN , DBArtisan , Exceed
• Others: Shell Scripting Ksh and Csh Perl 5-8-5

EXPERIENCE

Confidential

Sr. Sybase Developer Tech lead

Worked with the research group to create a new single platform for JPM research distribution that would cater to EQ , CR . FI/FO research analyst and provide a single platform for distribution to clients . The project was a full life cycle project starting from requirement gathering . Worked as onsite tech lead and responsible for all backend

Resposibilities.

• Worked as a part of 10 person initial team and later took on the role of team lead
• Designed the database for the new application
• Was involved in Designing the workflow of the application
• Involved in creation of tables, rules, indexes etc
• Created documentation during the development life cycle.
• Writing Sybase stored procedures and scripts to migrate the data from 5 diff systems into JDS RX / CRD / Aus Email / ERDM / MAC and for pulling data from different feeds for JDS.
• Responsible for co-ordination with DBA team and other teams .
• Incharge of release management across QA , UAT , PROd env
• Worked with users and business analysts to understand the requirements and create techincal specs
• Working with offshore team to guide them and help them through issues.
• Setting up the cron jobs for nightly feeds
• Writing perl scripts to manipulate ,extract format data from flat files to feed into JDS
• Also was involved in random query generations for reports and maintenance DB
• Performance tuning
• Trouble Shooting and providing L3 support to users and operate

Environment: Sybase System 12.5.0.3/, PERL, Shell Scripts, DBArtisan, Sun Solaris, HP-UX OS v5.8 Windows NT

Confidential

Sr. Sybase Developer

Confidential Worked as a part of 3-member team to help in maintenance and data migration of CRD database. The CRD database 12 G currently holds all client information along with the sponsoring information for all publication and web entitlements. It was decided that this functionality would be migrated to a new developing system called RX.

Resposibilities.

• Writing Sybase stored procedures and scripts to migrate the data from CRD to RX.
• Wrote stored procedures to extract data from the database and store them in files.
• Wrote perl scripts for notifications and to format the file as per the business and functional requirement
• Also was involved in random query generations for reports and maintenance of current CRD database.
• Worked with users and business analysts to understand the requirements and create migrations specs

Environment: Sybase System 12.5.0.3/, PERL, Shell Scripts, DBArtisan, Sun Solaris, HP-UX OS v5.8 Windows NT

Confidential

Sr. Sybase Developer

Confidential a company dealing in property and casualty insurance for automobile industry. The project involved building of a new web site where people could view their services, notices and get quotes for their services online. It involved designing the database and writing codes to populate database using GUI front end for generating reports and notifications.

Responsibilities

• Worked as a part of back end team whose main responsibility was to build the new database.
• Involved in creation of tables, rules, indexes etc
• Involved in writing SQL for Stored Procedures Triggers.
• Involved in writing of Unix shell and PERL scripts for batch jobs and notifications.
• Performed Query optimization.
• Generated Sybase SQL scripts that includes creating tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Involved in testing and performance tuning
• Involved in daily maintenance and support of the application
• Created documentation during the development life cycle.

Environment: Sybase System 12.0/11.9.2, PERL, Shell Scripts, DBArtisan, Sun Solaris, HP-Confidential

Sr. Sybase Developer

Worked with Investment Research Group of Goldman Sachs where an Institutional Portal System was developed. It provided a common platform for publishing and viewing. The main aim was to design a database - PORTAL that could be used to store researches, publications of all departments. The Portal database was populated through GUI, conversion scripts and other web-based tools where various checks and processing were done and then data was replicated to different premises.

Responsibilities

• Involved in creation of tables, rules, indexes and building of a new PORTAL database.
• Involved in writing SQL for Stored Procedures Triggers.
• Involved in writing of Unix Shell and PERL Scripts for batch jobs and transferring data from old to new system
• Performed Query optimization.
• Generated Sybase SQL scripts that includes creating tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Worked on CVS for version control
• Involved in testing and performance tuning
• Created documentation during the development life cycle.

Environment: Sybase System 12.0/11.9.2, PERL, Shell Scripts, DBArtisan, Sun Solaris, HP-UX OS v5.5.1, Windows NT

Confidential

Sr. Sybase Developer

Confidential It was decided to float a common index, as there were discrepancies in the two indexes. A team at both ends changed these discrepancies manually and it was time consuming. It was decided to automate this process.The system mainly used Sybase as the backend database. It downloaded files from S P site, backed it up into the database and then loaded the MSCI file into the database. The two reports were then compared for any discrepancies if any, and after rectifying were finally loaded on to the MSCI file to the ftp site.

Responsibilities

• Involved in database designing using Visio.
• Involved in extensive writing of stored procedures, triggers.
• Generated Sybase SQL scripts that includes Creating Tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Query optimization
• Responsible for maintaining MS Access database
• Involved in writing of Shell Scripts for to be used for file downloading and comparison
• Involved in transferring data from old database to new Sybase database.
• Worked with business analysts to ensure proper testing and delivery of applications
• Involved in generating reports

Environment: Sybase 11.9.2.3, Access, Visio, DBArtisan, Sun OS 5.5.1 Unix

Confidential

Sr. Sybase Developer

Confidential is the second largest trading firm in US. It started the Custody Technology division with the dream of implementing its dotcom site. This would convert its existing legacy trading system on mainframe to online trading on the Internet. The main aim was to design a database - CPDB that would be the source for all other functionality and was build around the existing sub-ledger system. The CPDB source database was populated through GUI, conversion scripts, and other web base tools. The data was then replicated tables in GLOSS in target CPDB. Here all checks and processing was done and then data was replicated to different premises.

Responsibilities

• Involved in gathering user information and specification writing
• Involved in creating and maintaining the new database
• Involved in writing of SQL for stored procedure triggers
• Generated Sybase SQL scripts that includes Creating Tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Query optimization
• Involved in Shell Perl Scripting
• Worked on CVS for version control
• Involved in testing and performance tuning
• Involved in documentation.

Environment: Sybase System 11.9.2, PERL, Shell Scripts, Sun Solaris, HP-UX OS v5.5.1 Windows NT

Confidential

Sr. Sybase Developer

Confidential gets new monthly loads of data from all its vendors/ATM machines. This data is very critical as it is available only for a limited time and further future management decisions are based on this data.

Responsibilities

• Interacting with Client reps to get the information and specification writing
• Involved in writing of stored procedures, triggers
• Query optimization
• Involved in Shell Perl Scripting
• Involved in generating reports to be submitted to client reps.

Environment: Sybase 11.5.1, T-SQL, MS Access, Visual FoxPro, Sun Solaris, HP-UX Windows 98

Confidential

Sr. Sybase Developer

Project I

Confidential is an existing application under the Financial Services group of JP Morgan, NY. The Financial Services group of JP Morgan in Confidential was in a production support migration phase of the Confidential application from JP Confidential to its offshore development facilities at Barbados. Confidential is a client/server application designed for the sole purpose of capturing journal entries. Basic Genie data is used in the DBS-GL batch processing to update the DBS Journal History file. The debit and credit balances are accumulated into the appropriate DBS Master File record. This GENIE application is currently being used globally in Confidential.

Responsibilities

• Involved in maintenance of application
• Involved in writing of stored procedures triggers as part of maintenance
• Involved in migration of application
• Involved in Production Support
• Involved in testing of application

Environment: Sybase 11.0.3, Power Builder 6.0/5.0, SQL, SQR, CONVOY 2.2.0.18, Sun Solaris, HP-UX Windows NT

Confidential package as part of their HR strategy. Anderson Consulting AC was the primary program managers for PeopleSoft implementation. This HRSS PeopleSoft interface/migration was a complete development project dealing with developing interfaces units and migration of Legacy data form platforms like COBOL, DB2, etc to a Sybase System 11 PeopleSoft HRMS Database.The Project was divided in mainly two parts - Development of PeopleSoft interfaces and Migration of Current System Data to PeopleSoft HR Database.

Responsibilities

• Involved in interacting with client to gather information
• Involved in specification writing
• Involved in writing of stored procedures, triggers.
• Involved in data transfer from old database to new database
• Involved in creating reports using SQR
• Involved in interface support

Environment: Sybase 11.0, PeopleSoft Interface/Migration, SQL, SQR, CONVOY 2.2.0.18, SQL HRSS, Sun Solaris v3.5 Windows NT

Confidential

Sybase Developer

• Confidential project forms a sub-system of Majestic, a system being implemented to support the Global Trust and Agency Services GTAS business area. The SM application is concerned with the physical receipt and delivery of custody items into and out of the GTAS vault.
• The largest client by volumes on whose behalf GTAS stores and manages custody items is Euro clear. The GTAS utilizes the Bond Numbering System BNS of Euro clear in order to record receipts and deliveries of notes into and out of the GTAS vault. Additionally, the existing ISS computer system of GTAS enables Common Depository holdings to be recorded - these are items that are held jointly on behalf of Euro clear and Cedel, another clearinghouse.
• Power builder v5.0 was used as a front-end GUI for capturing data. The main access to the backend database i.e. Sybase 11.0 was through Stored Procedures and Triggers which required extensive coding in Sybase.

Responsibilities

• Involved in specification writing
• Involved in creation of tables, rules and database objects for the database.
• Involved in writing of stored procedures, triggers cursors
• Involved in creating reports using SQR
• Involved in interface support

Environment: Sybase 11.0, Power Builder 5.0, C-DBLib, SQL UNIX 5.5.1

Confidential

Sybase Developer

This project was to make a user-friendly communication interface between different departments and sites. It included modules to send, receive, forward and replies to messages.

Responsibilities

• Involved in database design and specification writing
• Involved in database creation
• Involved in an writing of stored procedures, cursors triggers
• Query optimization
• Generated Sybase SQL scripts that includes Creating tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Involved in testing

Environment: Sybase 11.0, APT Workbench, HP 9000 Windows NT

Confidential system had two main modules - Employee module and Company module. The Employee module consists of information on the employees like their Educational background, current salary, total work experience, future nominations, etc. The Company module consists of information about the company and its sister concerns, addresses and locations, pay scale ranges, and grade categorizations. Power Builder 5.0 Graphs were extensively used for graphical representations on the front end with Sybase on the backend.

Responsibilities

• Involved in database design, database creation and specification writing
• Query optimization
• Generated Sybase SQL scripts that includes Creating tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Involved in creating front-end interactive windows using Power Builder
• Involved in maintaining the database
• Involved in testing

Environment: Sybase 11.0, Power Builder 4.0, APT Workbench

• Confidential system consisted of the following modules -
• Appraisal module - This module was used to computerize the annual appraisal of the employees and had features like Annual Task Sheet, Self Appraisal, and Review by first and second HOD and review by HRD. The system was based on a 360-degree feedback.
• Training Module - The module captures on-line monthly rolling plan, on-line nominations for internal, external and foreign training programs, on-line class booking and confirmations, etc.

Responsibilities

• Involved in database design, database creation and specification writing
• Involved in writing of stored procedures, triggers cursors.
• Query optimization
• Generated Sybase SQL scripts that includes Creating tables, Primary Keys, Foreign Keys, Constraint statements, triggers for creating new and customized databases.
• Involved in creating front-end interactive windows using Power Builder
• Involved in maintaining the database
• Involved in testing

Environment: Sybase, Power Builder 4.0