Summary:

• Over 7.5 years of professional experience in software industry with comprehensive knowledge through all phases of software development lifecycle right from requirement analysis to maintenance of a project.
• Extensive experience as Sybase Developer in ASE server 12.5 and 15.1

1. Have written basic SQL's to retrieve, insert, update and delete data while working in production support to complicated SQL's for generating reports

2. Have done performance tuning for many report SQL's

3. Prepared stored procedures, indexes, views and triggers

• Extensive experience as Sybase Developer in Sybase IQ 12.7

1. Prepared stored procedures, indexes, views and triggers

2. Have done performance tuning for many SQL's

Have very good knowledge in UNIX Shell scripting

1. Written shell scripts that deal more with isql'ing DB and BCP'ing data

2. Also worked on shell scripts that deal with file data editing

3. Developed a script that will copy the table's data from one DB server to another DB server and also written shell script for sync the same data between two servers.

Technically good in PowerBuilder

1. Worked in many enhancements which involve creating user objects, windows, menus and data windows.

2. prepared build and made install shields application exe's

• Have hands on experience on TIBCO spot fire programming.
• Have good knowledge on third-party tool Control-M job scheduling manager .
• Have worked in Patch management for Sybase server upgrade from 12.5 to 15.1 versions. As a part of this, worked on making .mak files for re-compiling c programs and also updated many config files. Also done crontab file setup in UNIX to schedule jobs during patch management.
• Have worked on data migration projects across Sybase server.
• Good knowledge in SQL, Oracle 9i and version control tools like PVCS, Serena and Dimensions and database tools like DB Visualizer and Rapid SQL.
• Have done many estimations on enhancement work effort that requires skill set Sybase, Unix shell scripting and PowerBuilder
• Worked on technical aspects and feasibility of the functional requirements with the requirement gathering team.
• Preparation of Weekly Status Report for the client and involved in Weekly Status calls with the onsite and client.
• Have a good knowledge on IPMS Integrated Project Management System which is one of the TCS Process where we generate metrics, reports and log IQA, EQA and FI related work.
• Received many Client/Onsite Appreciations and Recognitions for the good work done within the team and across the Units.
• Experience in all phases of the Application Development cycle - Design, Coding, Testing Unit testing and Integration testing , Maintenance and Documentation.
• Very keen to involve in process improvements and job automations in shell scripting for other teams too.
• Experience in working as an offshore implementation track coordinator.
• Demonstrated a great deal of initiative, teamwork and excellent communications skills
• Good Experience in working under tight deadlines.
• Excellent analytical and programming skills. Capacity for Work - Meeting Deadlines. Diagnostic ability to go to the core of the problem.
• Willing to learn and adapt to new challenges.
• Have lead production support team and development teams successfully for 3 years and executed many projects successfully.
• Have a very good experience working with US clients directly for the last 2 years and was very successful at onshore lead representing a team of 20 people at offshore.

TECHINICAL SKILLS:

Professional Experience:

Confidential

Role: Sr Sybase Developer/Lead

Responsibilities:

• Gathering requirement from client and analyzing them. Preparing design documents and flow diagrams to understand the requirements and share the same with offshore team.
• Estimation: once a change is deemed fit for construction, the total cost in terms of efforts and schedule is calculated using MAP Agile tool. This takes into consideration the nature of change, number of impacted components and the skills/availability of resources.
• Project coding: The activities include planning and writing code based on current work assigned. We follow ETVX methodology and iterative approach of s/w development for the same.
• Technical and functional knowledge sharing: To supervise the work done by new team members and provide any technical or business process related help to get the work done in a way that suits the user's needs.
• Application Production Support: Attending customer calls and resolving their queries by making quick backend changes or providing them instructions to use the application.
• Analyze and fix production issues. Such fix must be done immediately else the business will get impacted. On some cases there may be a need of immediate code fix and such fix can be done only with the sound knowledge of the application as well as the technology used in the application.
• Quality compliance: Ensuring that while coding/making data changes we have followed TCS quality standards. Regular code reviews and testing is involved to ensure the same using CA tool, APT and IPMS. DPCA methodology was used for defect prevention.
• Code review: Review any code changes UI or database done by offshore team to ensure they are fulfilling the user requirements. Check the code for correctness and provide input to developers to update the same in case something is missing using Assent.
• Unit testing, Smoke testing and sanity test: Performing unit testing for the completed work items and last minute sanity checks for work done by offshore to ensure the fitness of the new product.
• Production Deployment: Deploying the QA approved and wellness certified product into production to be used by actual users.
• Certification: Attending meeting with all necessary document related to any release to get a wellness certification from the internal quality board.
• Co-ordinate with the with various stake holders which includes app dev managers from other applications, business group and user group for the release works.
• Interact with the client on daily basis to know their concerns, address all issues faced by them, update the progress of each task and gather information for the issues faced by off-shore team. The discussion will be at the very low level and will deal with every minute aspects of the task.

Environment: Sybase ASE 12.5, 15.1, Sybase ASA ,Sybase IQ, DB-Visualizer 5.1, Rapid SQL 7.5, Tibco MFT, Control-M, ws ftp32, telnet, Putty, UNIX/LINUX Shell Scripting, TSQL, WINDOWS XP

Confidential

Role: Sr Sybase Developer

Responsibilities:

• Generate install, monthly and final checks for the panelists who participate in the Nielsen TV rating.
• Identify the areas where the manual intervention can be reduced by automating the processes and also areas where the processing times can be minimized.
• Gathering requirement from client and analyzing them. Preparing design documents and flow diagrams to understand the requirements and share the same with offshore team.
• Estimation: once a change is deemed fit for construction, the total cost in terms of efforts and schedule is calculated using MAP Agile tool. This takes into consideration the nature of change, number of impacted components and the skills/availability of resources.
• Project coding: The activities include planning and writing code based on current work assigned. We follow ETVX methodology and iterative approach of s/w development for the same.
• Technical and functional knowledge sharing: To supervise the work done by new team members and provide any technical or business process related help to get the work done in a way that suits the user's needs.
• Application Production Support: Attending customer calls and resolving their queries by making quick backend changes or providing them instructions to use the application.
• Analyze and fix production issues. Such fix must be done immediately else the business will get impacted. On some cases there may be a need of immediate code fix and such fix can be done only with the sound knowledge of the application as well as the technology used in the application.
• Quality compliance: Ensuring that while coding/making data changes we have followed TCS quality standards. Regular code reviews and testing is involved to ensure the same using CA tool, APT and IPMS. DPCA methodology was used for defect prevention.
• Code review: Review any code changes UI or database done by offshore team to ensure they are fulfilling the user requirements. Check the code for correctness and provide input to developers to update the same in case something is missing using Assent.
• Unit testing, Smoke testing and sanity test: Performing unit testing for the completed work items and last minute sanity checks for work done by offshore to ensure the fitness of the new product.
• Production Deployment: Deploying the QA approved and wellness certified product into production to be used by actual users.
• Certification: Attending meeting with all necessary document related to any release to get a wellness certification from the internal quality board.
• Co-ordinate with the with various stake holders which includes app dev managers from other applications, business group and user group for the release works.
• Interact with the client on daily basis to know their concerns, address all issues faced by them, update the progress of each task and gather information for the issues faced by off-shore team. The discussion will be at the very low level and will deal with every minute aspects of the task.

Environment: Sybase ASE 12.5, 15.1, Sybase ASA, Sybase IQ, DB-Visualizer 5.1, Rapid SQL 7.5, Tibco, Control-M, ws ftp32, telnet, Putty, UNIX/LINUX Shell Scripting, TSQL, WINDOWS XP

:

Confidential

Role: Software Engineer

Responsibilities:

• Performing bug fixes for the various ASM applications.
• Performing Break fixes and resolving Production Problems prescribed within the given SLA.
• Performing Business sustaining tasks as per the requirements of the ASM Applications.
• Performing regular scheduled maintenance activities.
• Analyzing some new issues in the Application
• Handling requests from applications interfacing with CSDS applications
• Preparing documents for the enhancement programs

Environment:PentiumPro Servers and Pentium Clients, Visual Basic 6.0,SQL Server 7.0 / 2000, MS Access, SAP Campbell For Staff works, SAP Campbell For Campbell Time and Attendance.