We provide IT Staff Augmentation Services!

Senior Sybase Developer,resume Profile

3.00/5 (Submit Your Rating)

Professional Summary: -

  • Around 8 Years of extensive experience in the database development working in Sybase 12.5 and SQL Server 2005/2008 with an emphasis on concepts, design, development, enhancement and performance tuning.
  • Experience working in different stages in software development life cycle SDLC and with Agile methodology.
  • Expertise in developing stored procedures, functions, triggers, views.
  • Experience in Performance Tuning and Query Optimization.
  • Experience in Data Modeling tools such as Erwin and MS Visio.
  • Experience in the Data Migration from legacy systems to newly developed systems.
  • Extensive experience in Unit Testing, Integration Testing, System Testing and Production Support of large-scale enterprise applications and products.
  • Knowledge and experience of configuration and release management of large-scale projects.
  • Extensive Exposure on three domains - Insurance, Telecomm and Publishing.
  • Experience in Support Documentation, debugging, fixing defects, operation and maintenance of end-to-end systems.
  • Quick learner and excellent team player, ability to meet deadlines, work under pressure and adaptable to any situation.
  • Excellent problem solving skills with a strong technical background and good interpersonal skills. Excellent verbal and written communication skills.
  • Effective working relationships, using independent judgment and initiative, and the ability to work in a team environment to produce quality information delivery systems.
  • Experience in managing Onsite/Offshore work and have the ability to get/understand the holistic view/perspective at Enterprise level. Have good client interaction skills.

TECHNICAL SKILLS

Languages

C, C , Delphi

Version Control Tools

VSS, MKSI, SVN, TFS

Databases

MS SQL Server, Sybase

Tools

MS Visio, DB Artisan, Erwin, Bugzilla, JIRA

Operating Systems

Windows 9X/ 2000/XP, Linux

Domain Knowledge

Insurance, Telecomm, Publishing

Professional Summary: -

Confidential

Role: Senior Sybase Developer

Project Description: This project is one of the biggest initiatives taken from Pearson to develop the interface between the various systems with the PCS application to effectively reduce the lifecycle of publishing the book and simultaneously reducing the cost of its production. Currently Pearson Education North America - US Higher Education and Pearson Canada Production and Editorial were part of this initiative and each of these groups function with different workflow processes. Hence the objective of this project is to facilitate a streamlined process and modeling it along the lines so that they all can come under one head.

Responsibilities:

  • Responsible for managing the overall database operations for this project.
  • Involved in creating effective database design based on the new requirements and existing system functionalities.
  • Created new database objects like tables, views, indexes, stored procedures and triggers based on the requirement to enhance the existing system.
  • Developing unit test cases based on the development done to test the new functionality developed in the system.
  • Developing the integration test cases to unit test the workflow interface being developed across the applications.
  • Involved in the data migration activity in which the whole US Higher Ed and Canada Higher Ed data was migrated over from legacy systems to the PCS application.
  • Creation of the new roles in the system based on the business requirements to meet the customer needs.
  • Handling the support operations which include troubleshooting of the issues encountered and providing the effective solutions to the business users.
  • Involved in creating the value added solutions to help the business users doing its regular operations more efficiently and quickly.
  • Interacting with the business users to help them understand the business functions developed in the system in order to perform the daily operations.
  • Creation of the code review and other related support documents.
  • Doing the peer code review for the team members.
  • Played a Subject Matter Expert role for the overall workflow developed in PCS system to interact with other interfacing systems using the concept of Web services.

Environment: - Sybase, SVN, Erwin, JIRA, DB Artisan

Confidential

Role: Sybase Developer

Project Description: This project was undertaken to develop the interface between PCS and 3Sixty application so that product information can flow between these two application based on the custom opportunity identified by the custom editor. The information was exchanged in the form of the XML between the two applications and new custom titles were created based on the XML data coming from 3Sixty application and then updates were sent back to 3Sixty from PCS system.

Responsibilities:

  • Responsible for managing the database operations for the application.
  • Work includes the designing of the database model to develop the interface between the two systems.
  • Work involved creation of new database objects Tables, stored procedure, triggers etc to read the data coming in XML files and process the data to create the new custom titles based on the information sent across.
  • Preparation of code review, unit test plan documents for the piece of code developed.
  • Handling the support operations which include troubleshooting of the issues encountered and providing the effective solutions to the business users.
  • Involved in creating the value added solutions to help the business users doing its regular operations more efficiently and quickly.
  • Interacting with the business users to help them understand the business functions developed in the system in order to perform the daily operations.
  • Developing the integration test cases to unit test the workflow interface being developed across the applications.
  • Creation of the new roles in the system based on the business requirements to meet the customer needs.

Environment: - Sybase, SVN, Erwin, JIRA, DB Artisan

Confidential

Role: Sybase Developer

Project Description: The objective of SSO was to allow users access all applications in PCS space using just one logon. It provides a unified mechanism to manage the authentication of users and implement business rules determining user access to applications and data. This project provides the creation of a single-sign-on SSO mechanism for PCS suite of Applications.

Responsibilities:

  • Primarily responsible for the managing the users login credentials on various application and develop the mechanism to authenticate the user based on its details present in Active Directory AD .
  • Involved in the merging of the duplicate user accounts on various applications under the PCS Space and finally having a single login per user per application.
  • Involved in a generating a unique SSOID for every user which is in sync with the Active Directory and finally associating this unique id to user's login in various application.
  • Developing the integration test cases to unit test the workflow interface being developed across the applications.
  • Creation of the new roles in the system based on the business requirements to meet the customer needs.

Environment: - Sybase, SQL Server 2005, SVN.

Confidential

Role: Senior SQL Developer

Project: Subscribe 2000

Project Description: - Subscribe is a modular, multi-currency insurance and reinsurance policy administration platform designed to support the full lifecycle of policies and associated reinsurance. This solution includes comprehensive audit and compliance functionality, the loss manager and EDI modules facilitate an end-to-end business process. It's highly configurable system ensures that it can be deployed consistently in all the markets and geographic regions. This also allows various functions to be kept separate from the underwriting functions of the main Subscribe application and restricts access to the administrative modules.

Responsibilities:

  • Worked in both development and support phase of this product.
  • Responsible for development of small modules integrated with the current system to enhance the current capabilities of the application.
  • Preparation of code review, unit test plan documents for the piece of code developed.
  • Responsible for providing an end to end solution to issues faced by the customer in their daily business operations.
  • Investigation on the issues or concerns raised in the product functional lifecycle and providing a proper clarification of the functionality working in the system.
  • Preparation and implementation of the data fixes script to resolve any potential data issues rising in the system.
  • Fixing the frontend Delphi code or back end SQL code to eradicate the system issues.
  • Responsible for ensuring a smooth financial data flow from Subscribe system to CODA Financial system keeping in view all the business rules set up in the system.
  • Responsibilities also include optimization of the system by doing fine tuning performance improvement in critical areas of the application.
  • Involved in continuous service improvement to the customer by providing them generic quick fix wizard solutions to resolve their daily issues on their own.
  • Responsible for smooth monthly financial closing of the business operations.
  • Enhancing the current Subscribe system based on additional work requests raised by the client facilitating them with more options to work on with current system.
  • Mentoring the team members on the critical issues and doing the peer code reviews for the data fix scripts or code fixes done by team members.

Environment: Delphi, Sybase, SQL Server 2005, MKSI.

Confidential

Role: SQL Developer

Project: Pipex Internet and Pipex Business Services

Responsibilities: -

  • Responsible to support the existing systems of the Pipex and dealing with the various problems faced while placing a new order, upgrading the product on the current service, the billing issues, mypipex login issues etc.
  • Work includes investigation on the issues raised through the Remedy System Defect Tracker System and preparing the data fix scripts to resolve them.
  • Monitoring set of predefined services/queues such as billing etc at regular time intervals and taking necessary actions based on their current status if required.
  • Creation of the generic reusable data fixes scripts.
  • Mentoring the team members on the issues raised and doing the peer code reviews for the data fix scripts or code fixes done by team members.
  • Preparation of support plan on monthly basis and weekly reports for the work done by the whole team.
  • Worked as a backup SQL Server DBA in the project and performed activities such as investigation on the daily SQL jobs failures and fixing the issue, backup and restoration of the important databases, managing permissions of access logins and daily report creation of the various issues encountered on all the servers.

Environment: Sybase, SQL Server 2005.

We'd love your feedback!