SUMMARY

• 8 years experience in design, development, enhancement and support of large scale, critical applications
• Possess strong business knowledge in Investment banking and Capital markets
• 2+ years experience in managing global software development teams spread across India, London and Hong Kong
• Expertise in the entire Software Development Life Cycle (SDLC)
• Working knowledge in designing and defining non - functional requirements
• Hands on experience in database programming (MS SQL & Oracle) and UNIX
• Proficient in using DDL (data definition) and DML (data manipulation) statements in MS SQL Server 2000/2005/2008
• Extensive experience in creating database objects such as tables, constraints, indexes, views, indexed views, stored procedures, triggers and cursors on MS SQL Server
• Good knowledge on SQL server concepts like database backup, replication, recovery, restoration, and linked servers
• Proficient in using T-SQL for developing relational database models and data integrity
• Good experience in integration services SSIS (SQL Server integration services) and DTS (Data Transformation Services)
• Expertise in generating reports using SSRS (SQL Server Reporting Services) and MS Excel spreadsheets
• Programming experience as an Oracle PL/SQL developer of applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL and SQL*Loader
• Expertise in creating and using table/analytical functions, indexes and materialized views
• Hands on experience in Oracle Data Integration (ODI)
• Working knowledge of C#, Visual Basic and MS Access
• Experienced in configuring applications on IIS application servers (6.0 and 7.0)
• Good knowledge in using ADO.NET objects such as SQL Connection Object and Oledb Connection Object, Data Command Object, Data Reader Object, Data Set Object and Data Adapter Object to design data access layer
• Working knowledge of CA workload automation tool - Autosys
• Hands on experience in creating Geneos workspace for monitoring incidents
• Experienced in release/change/incident management
• Working knowledge of functional, performance and integration testing
• Worked as a business/technical analyst on a banking project with regulatory reporting
• Good team player with excellent communication and interpersonal skills, with ability to work individually or as a team and a quick learner of new technologies

TECHNICAL SKILLS

Languages: C#, C, Oracle PL/SQL, Visual Basic

Database: MS SQL Server ( 2000/2005/2008 ), Oracle (9i, 10g & 11g), MS Access

Scripting languages: Windows Batch Scripting, UNIX shell scripting, Perl

Web servers: IIS 6.0, 7.0

Operating systems: Windows, UNIX

Monitoring tools: Geneos and Autosys

Version Control tools: Microsoft Visual SourceSafe, Tortoise SVN

IDE: SQL Server Management Studio, Toad, MS Visual Studio

Programming paradigms: OOPS, RDBMS

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Senior Database Analyst & Developer

Responsibilities:

• Drafted and maintained database procedures and documentation to ensure process integrity and consistency
• Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirements using MS SQL server 2005/2008
• Worked on development of SSIS packages for various inbound/outbound data and report functionalities in SQL Server 2005/2008
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations
• Developed SQL queries and stored procedures to fetch complex data from different tables in remote databases by using joins, database links and formatted the results into reports
• Created SSIS/DTS packages for loading from different data sources (flat files, excel source files, XML files etc.) and into destination tables by performing different kinds of transformations
• Developed SSIS packages with checkpoints for monitoring and logging audit information
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing
• Created data sources, connection strings and defined the datasets for generating the reports using SSRS
• Created of database objects like tables, views, materialized views, procedures and packages using tools like Toad, PL/SQL Developer and SQL* plus on Oracle 11g
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Involved in bulk data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Oracle 11g, PL/SQL, SQL* PLUS, SQL*Loader

Confidential

Application Enhancement & Release management Lead

Responsibilities:

• Contributed and provided technical assistance for major project enhancements, while managing a team of 4 software developers
• Migrated key production applications using Autosys v4.5 to the latest version r11.3
• Migrated the back-end database for a third party payment system from MS SQL to Oracle 10g using ODI (Oracle Data Integration)
• Modified and re-wrote existing stored procedures and queries in SQL Server 2000/2005/2008 and Oracle 11g based on business enhancement requests
• Created Perl and UNIX shell scripts to automate redundant manual tasks which greatly improved system performance and reduced the manual errors
• Rewrote PL/SQL queries to improve the production run time of queries involving views, stored procedures and user defined functions in Oracle 11g
• Participated in the end-to-end system testing of deliverables for a smooth transition to production environment
• Ensured Service Transition/Acceptance and the transition documents are presented for all enhancements and new applications to be deployed in UAT and production environment
• Ensured resource management for testing and related activities
• Used Tortoise SVN tool for configuration management
• Provided knowledge transition for junior engineers in the team and trained them for the challenges.

Environment: MS SQL server 2000/2005/2008 , Oracle 10g/11g, Oracle ODI, Perl scripts, Shell scripting, PL/SQL, UNIX, Autosys, Toad, Tortoise SVN.

Confidential

Business Analyst & Application Support Lead

Responsibilities:

• Provided technical consultation and business solutions to clients
• Managed a cross-cultural team of 6 software developers based in Hong Kong and India
• Involved in requirements gathering & analysis phase, and established proof of concepts for various modules
• Worked on business requirements and prepared technical design documents using MS Visio followed with sign-off from users
• Worked as a business and technical analyst on a regulatory reporting project with SEBI for the new trading system
• Ensured smooth running of the production system and provide continued support to users
• Critical issues were investigated and worked on code-fixes on the go for production severe incidents
• Responsible for collating bug fixes from vendor and ensuring proper and timely execution before roll-out to production
• Worked extensively on Incident Management - maintained and recorded production incidents and liaised with different teams as necessary based on the deadlines defined in SLA
• Worked extensively on Change Management - identified and collated the required changes to be implemented on production environment, assessed the phase level testing, obtained necessary approvals for the implementation, performed necessary post-checks to ensure the production system is up and ready-to-use
• Implemented system-monitoring tool Geneos for early detection of issues that may arise in Production environment

Environment: MS SQL server 2000/2005, Oracle 11g, Perl scripts, Shell scripting, PL/SQL, UNIX, Autosys, Geneos, Toad, Microsoft Visio.

Confidential

Database Developer

Responsibilities:

• Designed and developed a major reporting application “Matrix” for reporting and maintaining everyday business transactions
• Wrote PL-SQL queries with joins on multiple tables, stored procedures, functions, triggers, and indexes in Oracle 11g
• Worked on SQL*Loader to load bulk data from flat files and implemented the same logic for the new application
• Used Autosys to create batch jobs for weekly data backup of the application’s back-end Oracle 11g database.
• Developed T-SQL functions and stored procedures for data loading
• Developed SSIS packages in SQL Server 2005 to automate maintenance and back-up jobs for databases, update statistics, re-build indexes and create error log for events during data load in development and UAT environment.
• Designed enterprise reports using SQL Server Reporting Services (SSRS 2005)
• Liaised with various teams across India and London and performed integration and regression testing of all technical components of the application
• Managed reporting applications hosted on development and UAT environments, oversaw system performance and pro-actively worked on maintenance activities
• Functioned as the configuration controller for the project - used Microsoft Visual SourceSafe and Tortoise SVN for maintaining code base

Environment: SQL server 2005, PL/SQL, Oracle 11g, UNIX, Autosys, SSIS, SSRS, Microsoft VSS, Tortoise SVN

Confidential

Application Design and development

• Worked in analysis, design and development of primary modules of most of the reporting applications
• Developed various components in the applications using Visual Basic / MS Access and hosted them on IIS 7.0 server
• Involved in architectural design of the reporting applications and prepared architecture documents using Microsoft Visio
• Designed and developed front-end modules in the application using C#
• Designed and developed the back-end using SQL server 2005
• Analyzed the existing functionality of applications using older version of Data Transformation Services (DTS) in SQL server 2000 and proposed a migration plan to upgrade to SQL server 2005
• Created SQL Server 2005 database tables and wrote stored procedures, functions, packages and views as required by the application
• Developed packages and created snapshots using SQL Server Integration Services (SSIS).
• Extensively Used ADO.NET to access database objects tables, stored procedures.
• Added new functionalities and modules in the application using C#
• Created new windows scheduled jobs using Windows batch scripts for monitoring system performance and send out error logs to a common share-point in case of any incident
• Involved in end-to-end system testing of the deliverables for a smooth transition to Production environment
• Used Microsoft Visual Source Safe (VSS) for Source control (configuration management)

Environment: C#, SQL Server 2000/2005, ADO .Net, PL/SQL, DTS, SSIS, Visual Studio, MS Access, Visual Basic, ISS 7.0, Microsoft VSS, Microsoft Visio, Windows batch scripting

Confidential

Application Development and Testing

Responsibilities:

• Lead engineer responsible for system configuration, development, integration testing and release of project modules
• Delivered customer and connection module and various front-end screens for CRM application using Visual Basic and MS Access and hosted them on IIS 6.0 server
• Developed triggers, packages, functions and stored procedures in Oracle 9i for data fetching and PL/SQL procedures to create database objects dynamically based on user inputs
• Wrote down test cases for functional, performance and integration testing and performed the testing as well
• Worked on testing in SIT phase and fixed major defects before delivering to quality assurance team
• Prepared regression and load test cases and executed them in development environment
• Used Microsoft Visual Source Safe (VSS) for Source control (configuration management)

Environment: Visual Basic, MS Access, ISS 6.0, Oracle 9i, PL/SQL, Microsoft VSS