Sybase Developer Resume
Journal Square, NJ
PROFESSIONAL SUMMARY
- 5 years of experience in Systems Analysis, Design, Development, Testing and Implementation and Support of various applications using Unix, Perl, Sybase and Java
- Extensively worked on stored procedures with high performance SQL’s
- Hands on experience in database design and writing Indexes, Views, and Triggers
- Good understanding of query plan and performance tuning
- Performed unit, integration, UAT and regression testing
- Worked on Source Code Control Systems - CVS
- Good understanding of Corporate Action processing
- Hands on experience in GLOSS – Trade processing system
- Strong understanding of IT concepts and fundamentals; desire and ability to quickly learn new technologies and work in fast-paced environments
- Excellent communication skills, self-starter and team player
Technical Skills
Database: Sybase 11.x/12.x, Oracle and DB2
Languages: SQL, Perl, Shell Script, Java, COBOL, C, C++, Java Script, HTML and CGI
Operating System: UNIX (Solaris) and Windows NT
Software Packages: GLOSS
IDE: JBuilder
Source code Version control: CVS ( Concurrent Versions System)
Professional Experience
Confidential – Journal Square, NJ
Role: Sybase Developer
Project Description: GLOSS is a real-time transaction processing system that automates trade processing life cycle from trade capture, through confirmation, reporting to clearing agency, settlements and postings. It also handles corporate action processing, where based on announcement type it will generate the entitlements using a set of pre-defined rules and posts to client accounts that are holding the underlying instrument.
Responsibilities
- Developed a new process to generate child transactions from a single transaction to support corporate action processing
- Implemented amendment process to amend single account transactions without impacting other account entitlements and re-linking all the transactions
- Enhanced the allocation processes to improve the throughput
- Fixed the performance bottlenecks in purging of data
- Involved in functional requirement analysis and design
- Prepared test plans and performed unit, integration and performance testing and supported UAT with functional teams
Environment: Sybase 12.5, Perl, Shell Script and C; UNIX SUN OS 5.5.1, GLOSS
Project: Confidential, New York, NY
Confidential
Role: Database Developer
Project Description: This project involved the development and implementation of Bank Account Accrual (BAA) functionality for Wachovia Capital Markets. A BAA is a class of savings account offered by banks and financial institutions that are directly equivalent to, and competitive with, money market mutual funds
Responsibilities
- Developed daily blended rate calculation module: the daily rate is calculated based on the aggregation of all the holdings in scope at a Top Account Level and then using the tiering as per the schedule assigned to the Top Account
- Implemented rate re-calculation for as-of changes to rate, schedule, and holdings
- Played a pivotal role in database design and functional requirement gathering
- Developed high performance stored procedures to calculate blended rate
- Performed intensive unit testing
Environment: Sybase 11.9, UNIX, Shell Scripts, SQL, T-SQL
Project: Confidential
Position Reconciliation System
Role: Member Technical
Project Description: PRS is centralized reconciliation system for the Bank. It is responsible to do the activity and position reconciliation and analysis for exceptions/breaks on a daily basis. It will display the position and activity exceptions to users. The activity and positions will be received as flat files from different units across the firm. The user interface will allow users to view breaks and activities.
Responsibilities:
- Involved in PRS system development starting from initial design phase
- Developed a dynamic loading module to format and load the activity and positions data into database from flat files
- Developed a dynamic reconciliation process to do the reconciliation based on entity, so that the reconciliation system can be used without many changes for any number of entities
- Involved in user support for analyzing the breaks
- Bug fixes and performance fixes
- Training new members to team and helping other teams in testing
Environment: Sybase 11, Perl5, Shell Script and Java; UNIX SUN OS
Confidential
Role: Software Engineer
Project Description: This utility had two types of users: administrator and the user/student attempting the paper. The administrator had the privilege of framing the questions, setting the topics, and sub-topics, setting the scores, time and evaluating a student’s performance. The question bank was grouped under topics and sub topics. The student can select a particular sub topic and answer the questions in it. All the questions are of objective type. At the end of the specified time, the student’s score and percentage were displayed.
Responsibilities:
- Responsible for system requirement gathering, analysis and design
- Involved in schema design and creating proper referential keys
- Developed a code to do validation checks and providing the access based on user role
- Writing the code for selecting random questions and validating the answers
Environment: HTML, CGI-Perl, Sybase