PROFESSIONAL SUMMARY:

• Have more than 7.5 years of experience in various phases of Software Development Life Cycle including requirement gathering analysis, design, development, testing, implementation and maintenance
• Worked primarily in Wealth management domain and Retail Banking for leading financial services firms
• Intensive hands-on experience in developing Stored procedures, triggers, views etc. in various Database Languages
• Expertise in Performance monitoring and Query optimization
• Experience in Database Modeling and Designing
• Worked on various Data migration activities between application DBs, DB versions and DB management systems
• Proficient with UNIX Shell Scripting and Autosys jobs scheduling
• Experience in Sybase ASE 12.5/15.5, MS SQL 2005/2008, Oracle 9i/11g and IBM DB2
• Sound Knowledge of Unix and Perl Scripting
• Hands on experience in quality control, delivery, support/maintenance, identifying and fixing root cause problems and process adherence
• Good Analytical, Problem Solving and Interpersonal skills
• Exceptional ability t grasp concepts and infer abstract principles
• Exposure t international work environments

TECHNICAL SKILLS:

• Databases : Sybase ASE 12.5/15.5, MS SQL Server2005/2008, Oracle9i/11g, IBM DB2
• Languages : SQL, T-SQL, PL-SQL, DB2 Native SQL
• Database Tools : SqlDbx, DB Artisan, SQL Advantage 12.5, Microsoft SQL Server Management Studio, DataStage 7.5,TOAD, iSQL Plus, IBM Data Studio
• UNIX Tools : Exceed Connection Manager, Humming Bird FTP, Putty, Autosys
• Design Tools : Microsoft Visual Studi 2010, Microsoft Visi 2007, MS Office
• Source control Tools : PVCS, VSS, TFS
• Operating Systems : Windows 2000, Windows XP/ 2003/2008, Sun-Solaris/Linux/ UNIX-IBM AIX Version , Sun Solaris 5.9, RHEL 2.6, X86-64
• Shell Scripting Languages : Unix, Perl
• Defect Management Tools : HP Quality Center, Clear Quest, DCMS
• Functional Domain : Wealth Management System, Retail Banking

PROJECTS UNDERTAKEN:

Confidential

Role: Sybase Lead Developer

• The current MSG infrastructure is running on Sybase 12.5.4 software which has reached an 'End-of-Life' state as a result vendor support from Sybase is n longer available. If a production environment issue relating t the Sybase v.12 software were t arise, immediate support from Sybase would not be available. The enterprise would need t contract out a custom support solution which would cause service delays and require funding.
• Upgrading the Sybase infrastructure t version 15.5 puts the enterprise back ont a vendor support solution that accompanies the software license. The project seeks t acquire new server hardware with more efficient processors, increased CPU power, and enough capacity t support future growth.

Responsibilities:

• Prepare Impact Analysis and Design document for changes required in the code on migrating t v.15.5. Remediate the identified issues in stored procedures and batch jobs
• Migrated operating system from Sun Solaris 5.9 t RHEL 2.6, X86-84
• Develop, test and Identify Stored procedures, triggers, complex queries and other DB objects with post-migration/upgrade issues in test environments
• Modify SQL.ini files and interface files t change server connection settings and verify database connectivity from SQL server tools and applications through ODBC connections
• Check environment variables, configuration parameters after migration t identify any compatibility issues
• Prepare test scripts, data validation scripts and Test Cases t perform Unit testing and System Testing from Development t Testing, UAT and Production
• Compare performance statistics for critical SQL's/Stored procedures t against 12.5 and 15 servers t identify any performance issues and tune them. Check the I/ statistics, query plan and time statistics with the new optimizer
• Perform load testing by running stored procedures/SQL queries in parallel t identify resource issues, blockings and deadlocks situations
• Validate all Perl and Unix Shell Scripts t verify database connectivity, SQL/SP performance and any execution errors
• Monitor the database performance regularly t identify slow running queries and optimize them

Confidential

• Tools: Sql Advantage 12.5, DB Artisan, SqlDbx, Query Planner, Precise, Exceed
• Connection Manager, Autosys
• The Single Experience is an initiative t migrate the Managed Solutions Group from a program centric platform t a client-centric experience t reduce redundancy and increase Financial Advisor and Client adoption. The current processes and tools are program specific and thus the Financial Advisors and Clients wh use more than one of the programs as investment vehicles must g through repetitive and redundant paperwork, enroll steps and billing for each program. These repetitive and redundant steps have become barriers t higher adoption levels. Delivering the Single Experience project will position MSG as leaders in the industry for creating an FA / Client experience that is streamlined and simple t understand and adopt while als providing increased visibility and transparency int the fees relating t the platform.
• As part of the infrastructural readiness for the 'Single Workflow' requirements, an effort is under way t migrate the Workflow DB MSG WF from Sybase t DB2 as most of the firm's DBs are on DB2 once migrated, the APIs and access routines could leverage a lot of the data available on other DB2 systems

Responsibilities:

• Analyze the scope and business requirement and map t Architectural, Structural Behavioral Requirements
• Involved in Data Architecture and Data model designing and preparing Entity relationship diagrams
• Perform POC proof of concept testing for the defined Business Use cases
• Stored Procedure and Batch Jobs designing t meet the application and business needs
• Map support for Legacy pre single-experience Products int Architectural, Structural Behavioral Requirements
• High Level Design with below perspectives -
• Develop Application Architecture
• Security
• Workflow processing
• Application performance
• Deployment and coordination with Provider team, API team and testing team in QA and production environment

Confidential

• As part of this initiative 17,000 accounts in tw existing UST products, Selects and Portfoli Foundations were combined int a new product called Select Portfoli Solutions SPS . The new product enhances efficiencies, benefiting both UST and the client's Legacy application through streamlined enrollment, servicing and cost saves.
• Assets in the new product, SPS, will remain on the source platform, but leverage some of the efficiencies available in new System specific benefits will include an access t an Overlay Portfoli Manager via Managed Account Advisors MAA t implement manager models trading, enrollments, account servicing .

Responsibilities:

• Analyze business requirement and map t Architectural, Structural Behavioral Requirements
• Write one time migration scripts t migrate the UST Accounts int client's Legacy system
• Create Perl batch job scripts t read incoming feeds for one-time migration and perform data migration tasks
• Design and develop scripts in Perl t execute daily feeds for migrating new accounts from host system in new system
• Schedule the jobs in Autosys and monitor t identify issues in case of any job failures
• Deployment and coordination with testing team, other business partners in UAT and production environment
• Generating pre and post migration statistical reports t be shared among all stake holders t compare against sender and receiver systems and t be recorded for audit purposes
• Provide post migration support

Confidential

• Managed Asset Advisor Dashboard MAA Dashboard is a program developed t be used by Bank's in house overlay managers. This application offers of approval/rejection new enrollments, manager change, restriction updates, tax selling, Contributions, Withdrawal requests submitted by FA site within MAA workflows. This application is integrated with UMA program Financial Advisors can see the status of their requests with overlay managers.
• Mass approval is a Web Based UI application used by overlay managers t assign, approve, and reject requests submitted by FA or by their Client's Associate in bulk. From user interface overlay managers can schedule a mass action and that is processed by mass approval windows service, this service automatically picks the scheduled mass action request and process in background.

Responsibilities:

• Gathering requirements, communication with various stake holders, providing solutions t business workflow problems.
• Responsible for design, development, enhancement, and maintenance
• Identify existing slow running stored procedures and resolve performance issues t increase overall user experience by tuning the existing procedures, re-writing the stored procedure or replacing existing stored procedure with new stored one with optimized business logic.
• Replaced generic stored procedures with application specific requirement by limiting the parameters and implementing business logic. This helped in generating a new query plan for the stored procedure and increased application performance manifold.
• Writing queries t generate adhoc reports for business purpose.
• Creating UNIX batch jobs t generate outgoing feeds, daily reports t be executed in non-production hours t meet business needs.
• Defect tracking Work in investigation, correction of defects and verification of defect fixes and quality related activities.

Confidential

• PIA Personal Investment Advisory is one of the products which fall under Discretionary category.
• PIA is comprised of tw major modules FA portal and Account Enrollment.
• Account Enrollment This module involves enrolling new clients int the PIA system. It has various features and checks for enrolling new clients.
• FA Portal This module involves FA information. Various categories of Financial Advisors are Portfoli Advisor, Portfoli Manager and Senior Portfoli Senior Manager.
• This project involved re-engineering of PIA product involving significant architectural decisions designs. Some old products were decommissioned and enrolled int PIA program based on business decisions.

Responsibilities Undertaken:

• Design new data model t meet the existing and new business requirements.
• Documentation involving impact analysis, design documents, element mapping from old t new data model
• Create sync up and sync down jobs between old and new databases.
• Designing Stored procedures t implement new business requirements and retain some of the existing features and functionalities.
• Prepare one-time migration scripts t migrate accounts from old t new system.
• Developed Perl scripts t execute Sybase migration stored procedures and SQL scripts
• Enhancement and maintenance of the new system.
• Defect tracking Work in investigation, correction of defects and verification of defect fixes and quality related activities
• Database: Sybase 12.5
• SQL Languages: T-SQL, Perl programming
• Operating Systems: Windows XP, Sun-Solaris
• Tools: Sql Advantage, DB Artisan, SqlDbx, Query Planner, Precise, Autosys, Exceed Connection Manager

Confidential

• Design and development for customization of product Bancs 24 Retail Banking: Back- End , a Core banking product provided by TCS FNS, Australia.
• This is one of the core banking solutions project in India led by Primary Vendor TATA Consultancy Services for Customization, System Integration and Implementation at pilot sites of a Core Banking Solution package t deploy a high-performance, 24x7 availability state-of the art anywhere banking Core Banking Solution that interfaces with different banking channels. This comprehensive solution will ensure the realization of a fully functional Centralized Core banking solution for ALB involving 900 branches approx. across the country.

Responsibilities:

• Analysis and Design of business requirements
• Documenting the requirements and prepared Technical Specification, Release Notes, Incident Resolution Report etc.
• Performance and Functional Enhancements t Existing System for next Version Release.
• Development and Maintenance
• Involved in optimization of SQL stored procedures and functions which are frequently used for taking reports. This was done by revisiting the procedures, functions and recoding them for better performance.
• Preparation of Unit Test Plans and testing built application
• Provided branch support t end user on client request and production support activities.
• Involved in other project management activities like Weekly Status Reporting, Prepare/Review Impact Analysis Report, Preparation of TSD, UTP and ITP, Review of code and documents of other modules.
• Language: SQL, PL/SQL, UNIX Shell Scripting
• Database: Oracle 9i
• Operating System: Windows 2000 Server, Windows XP, AIX UNIX
• Source control Tool: PVCS, VSS, IPMS Integrated Project Management System
• Design Tool: iSql Plus, TOAD, DCMS Defect and Change Management System