Summary

• I am an IT professional with 9 years of experience working with a multinational IT service provider delivering multiple IT solutions for development and support projects for Investment Bank.
• I have worked as a Developer, Tech/Project Lead at ODC Offshore Development Center at India Pune and Client locations at UK Glasgow, London and US New York .
• My expertise lies in Sybase, MSSQL or other Database technology, implementing and supporting Tools, Banking and financial Services domain.

Technical and Domain Skills:

• Expert knowledge and extensive experience in
• Sybase 12.5/15.0 with 7 years of experience
• SQL server 2000 with 3 years of experience and familiar with the SQL Server 2008 architecture
• RDBMS concepts and Data Modeling for different types of Schema
• Moderate knowledge and experience on Unix, Shell Scripting, Perl Scripting, Autosys, TLM, Informatica and Oracle SQL
• Familiar with basic skills for VB6, .Net, Oracle PL/SQL, Cognos, Java
• Very good knowledge on Investment Banking concepts, Derivatives, Risk Management and Reconciliations
• Knowledge and experience to work on financial tools like Smartstream TLM Recon and ClusterSeven Spreadsheet compare.

Key Highlights on Experience:

• Extensive experience as Sybase Project Lead of various Investment Banking projects.
• Experience in IT SDLC phases like Requirement Gathering, Analysis, Design, Documentation, Technical development, Review, Testing Unit, System Integration and User Acceptance , Support and Release with excellent skills in Software quality processes.
• Experienced in Estimation techniques UCP, FP and CP , Project planning, Risk management, Change/Incident Management, Status tracking/reporting and presentations using Microsoft products like Excel, Word, PowerPoint, Project professional etc.
• Possess excellent skills of Communication and Coordination with multiple AD, Support, DBA, Operate, Audit etc. internal teams at various locations

Tools:

• Project based: SmartStream TLM Recon, ClusterSeven Spreadsheet Compare
• Technical RapidSQL, DBArtisan, Query Analyzer, PL/SQL developer, TOAD, Visual Studio
• Version Control SVN, Clearcase, VSS, RTC
• Testing and Projects: JIRA, RQM, Quality center
• Microsoft Word, Excel with VBA, Project, Visio, PowerPoint, MSAccess

Personal Skills:

• Quick Learner, excellent written/verbal communication, team player, committed to best performance and justice to assigned roles and responsibilities
• Ready to take challenging work and provide timely delivery of work

Relevant Project Experience:

• Development of SQL Server based solutions, ClusterSeven tool configuration setup and ad-hoc reporting of month end sign off process.
• Mondrian is a risk assessment and P L reporting tool used by the Middle Office of J.P.Morgan Chase Bank. The tool involves receiving feeds from various source systems, performing calculations, adjustments, reconciliations and reporting P L. Also, the P L reporting of financial instruments like Bonds, Asset Swaps and Credit Default Swaps is done with this tool.

Confidential

As an offshore/onsite UK developer/operate with a team size of 5 is involved in the following:

Requirement/Impact Analysis:

• Requirement gathering for the change or development request raised by business
• Analyzing impact and feasibility of change or enhancements on the existing system
• Functional requirements communication to offshore team

Analysis:

Analysis of changes required in existing system for implementing enhancement.

Estimation:

Estimation of efforts required for enhancements/changes

Design and Coding

• Designing database tables and stored procedures
• Coding of stored procedures
• Managing proper indexes on SQL tables and writing high performance Stored Procedures to achieve the NFRs

Testing

• Unit System Integration testing of code and functionality.
• Support to User acceptance testing.

Production Support

• Resolved the critical production issues by bug fixing emergency.
• Provided support in Earlies, Intraday and Lates / Overnight Shifts.

Production Release

• Released enhancements, changes to production following the thorough of documentation and SOX process.
• Documents and code maintenance with documents and code repository like Intraspect KM and Subversion, Clearcase.

Operate role

• Responsibility for application on-time availability.
• Capacity Headroom analysis.
• BPI Business Process Index and KPI Key Performance Indicator maintenance for project.
• Client interaction to resolve day to day issues coming as part of BAU processes.

Confidential

As a developer and Team Lead with a team size of 5 was involved in the following:

Analysis:

• Analyzing the requirements for the new functionalities for the project
• Involved in the functional/technical analysis of the different iterations f development.

Estimation:

Estimation of efforts required for development and testing of new functionalities

Design and Coding

• Designing database tables, stored procedures, views, triggers, Index, shell scripts etc
• Coding of the database objects and shell scripts
• Review of code and documentation

Performance Tuning

Managing proper indexes on Sybase tables and writing high performance Stored Procedures to achieve the NFRs

Testing

Unit System Integration testing of code and functionality.

Confidential

• Technology: Visual Basic 6.0 Sybase SQL Unix
• As a developer at offshore with a team size of 6 was involved in the following:

Impact Analysis:

Analyzing impact of change for enhancements on the existing system.

Analysis:

• Analysis of changes required in existing system for implementing enhancement.
• Involved in analysis of Transact change in Mondrian BASS.

Estimation:

Estimation of efforts required for enhancements.

Design and Coding

• Designing database tables and stored procedures.
• Coding of stored procedures.
• Review of code and documentation

Performance Tuning

Managing proper indexes on Sybase tables and writing high performance Stored Procedures

Testing

Unit System Integration testing of code and functionality.

Confidential

equirements Gathering, Analysis and Estimation

• Understanding and translating business needs to technical requirements and coordinating the same with external vendor.
• Effort Estimation based on detailed analysis for feasibility and scope.

esign, Development and Review Tasks

Reviewing the design and development efforts, day to day support activities from whole team.

nfrastructure Changes and Release Management

• Procuring or upgrading hardware, software packaging, vendor tool version upgrades, source control SVN , ticket management system JIRA configuration and maintenance.
• Performing periodic maintenance activities like, Server patching, Upgrades, DB archiving/purging/tuning, DR/BCP test activities.
• Raising change requests, release plans, managing approvals from impacted/targeted teams and supporting release with Operate, DBAs, SAs, Infrastructure teams.

Project Tracking and Management

• Coordination with Business stakeholders, client Managers, team members and other support teams like Level2 Operate, DBAs and Wintel SAs.
• Weekly, monthly status calls, preparing agenda and providing details
• Performing team goal setting, periodic feedback and Yearly appraisals along with time, cost and people management.

QA Activities and Process Management

• Overlooking the offshore based QA team to perform end to end unit testing, system testing and regression testing for the proposed and developed solutions
• User Acceptance Testing Support.
• Subversion Code Version control tool for tracking and sharepoint for document repository.

Tech Skills:

As a Sybase SME and Project Lead worked on the following:

Confidential

Requirements Gathering, Analysis and Estimation

• Requirement gathering and scope definition for the work.
• Analysis of changes required in existing system for implementing the segregation.
• Estimation of the efforts based on initial analysis and preparing project plan for the team.

esign and Coding

• Designing the approach and getting it approved by Client.
• Development to remove the existing non-compliant production database access as part of the regulatory requirement of the firm.
• To provide a solution to replace the existing user accounts with new database accounts created for each application module with encryption of the password.
• Development of code in various technologies like Sybase, Linux, Shell Scripting, C, C , C .
• Performing build and deployment activities on different Development, UAT and Production environments
• Coordination with Client Manager, existing team members and other support teams like Level1-Level2 Operate, DBAs and Unix SAs.

Testing

• Unit System Integration testing.
• Supporting the testing to be performed by the Quality Assurance group and resolving the issues reported by them.
• User Acceptance Testing Support

Process Management and Tracking

• RTC and Clear Case Code Version control tool for tracking and documentation.
• Providing the weekly and milestone based status reports to Client Manager.

Confidential

• As a Project Lead of the peak team size of 12 worked on the following:
• Learned and worked on a list of new specific tools and technologies.

Data Analysis

Detailed Data analysis performed for reconciliation design and bug fixing solutions using Excel Pivots and Database queries

stimation, Requirements Gathering and Design

• Analysis, coordination and review of the requirements
• Estimation based on UCP methodology
• Functional/Technical Design creation and review

Review and management

• Performed Code review
• Part of all SDLC phases along with delivery management

Coordination and Quality process

• Performed effective coordination between Onsite-Offshore counterparts and participated in communication with client
• Performed all essential Quality process setup/maintenance and version controlling with SVN
• Established and supported all quality processes for project internal tracking and auditing

Confidential

JPMC Indices Website:

As a Senior developer / Team Lead of the team size of 10 at offshore worked on the following:

Requirements Gathering and Design

• Analysis and documentation of the requirements
• Application Database and UI design

Coding and Testing

• Developed the Database objects and performed Unit Testing
• Code Review performed for other team members' development
• System Integration Testing for the Application functionalities

US Book Building for JPMC SIDM Website:

As a Project Lead with team size of 7 worked on the following:

Requirements Gathering and Design

• Analysis and documentation of the requirements
• Application Database and UI design

Review and management

• Performed Code review
• Part of System Integration testing and delivery management

Coordination and Quality process

• Performed effective coordination between Onsite-Offshore counterparts and participated in communication with client
• Performed all essential Quality process and version controlling with SVN
• Coordinated the UAT and warranty support for the application

Confidential

As a developer in the Offshore Team worked on the following:

Concorde System Understanding

• Understanding of different user level application details
• Concorde technical architecture understanding

Data Model Preparation for Concorde Processes

• Worked on preparing the Sybase Data Model for Concorde application
• The Data Model listed down the Sybase database objects used in different Concorde processes

Cruise Control Automation setup for Concorde Build Processes

• Worked individually to setup the Application release build process using Cruise Control tool.
• End to end SDLC followed with on-time delivery of the project.

Confidential

As a developer at offshore with a team size of 6 was involved in the following:

Design

• Designing the Test strategy for checking the version compatibility
• Preparation and review of the Testcases

Testing

• Sanity Check for proper Database load and correct server level settings availability
• System/Regression testing of database objects and application functionalities.

Confidential

As a Project Lead and Sybase Developer at offshore with a team size of 8 was involved in the following:

Impact Analysis:

Analyzing impact of change on the existing system.

Analysis:

• Analysis of changes required in existing system for implementing the segregation.
• Analysis of the development for new instance of application.

Design and Coding

• Designing database tables and stored procedures.
• Coding of stored procedures.
• Review of code and documentation.

Performance Tuning

Managing proper indexes on Sybase tables and writing high performance Stored Procedures to achieve the NFRs

Testing

• Unit System Integration testing.
• User Acceptance Testing Support from Offshore

Warranty Support

Support for any Post-Implementation Issues.

Quality and Process Management

• Visual Source Safe maintained for Code tracking and documentation
• Handled the Startup and Delivery Audits