Sql Server Project

Deepthi Vulchi

Email: ************.*@*****.***

Phone: 201-***-****

SUMMARY

Professional Summary:

. SQL Server Developer with 7 years of work experience in Requirements

gathering, analyzing, designing, development and various segments of

Software Development Life Cycle (SDLC) using Microsoft SQL Server

(2012/2008/2005/2000), TSQL, ETL Tool.

. Having 7 years of Financial Domain experience in Mortgages for U.S

market and Equities for Australian market

. Basic knowledge of SSIS packages

. Good experience in Batch processing and Jobs scheduler

. Having strong leadership skills and good communication skills.

. Extensive knowledge in ETL tools, Database design, Query optimization

and Performance tuning.

. Strong knowledge in creating Indexes, Views, Triggers, effective

Functions, and appropriate Stored Procedures to facilitate efficient

data manipulation and data consistency

. Worked as a site coordinator and took ownership of DR(Disaster

Recovery) testing, MOD (Manager On Duty) calls and BCP (Business

Continuity Plan)

. Actively participated in the server migration testing and fixing the

issues.

. Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail

. Researching and suggesting way outs to handle a performance issue,

redesign the solution as and when necessary etc there by contributing

to the overall enhancement of the product.

. Solid experience in production Support making sure all critical

milestones achieved during daily production run

. Expert in creating and formatting crystal reports

Employment history:

. Worked as Sr. Software engineer at Bank of America since March 2011 to

Sep 2013.

. Worked as Product Analyst at Broadridge Financial Solutions since

October 2007 to March 2011.

SKILLS

Technical Skills:

. Operating System: Windows 2000, Windows XP.

. Languages: C++, C.

. Database: Microsoft SQL Server 2000/2005/2008/2012, TSQL, SSIS

. Microsoft Technologies: C#, Visual Studio 2010, VSS, TFS, VB6

. Other Tools: ETL, Crystal Reports, Excel, Batch Processing, Scheduler

. Source Control: VSS, TFS

EXPERIENCE

Bank of America

In House project for Mortgage Data Technology [MDT]

Employment Type : Full Time

Duration : 3/2011-9/2013

Database : SQL Server 2008/2012

Team Size : 5

Project#5: Lynx

Lynx is an ETL Tool for processing loans from various sources and maintains

a central repository for its down streams. The data will be processed every

night using nightly conversion jobs. Lynx is the major database in the

secondary marketing and processes millions of new records every day. We

will be generating reports and send to down streams users, which helps them

to take actions of Hedging & Pricing.

. Took ownership of Production support and worked as an onsite

coordinator

. Make sure all core conversion jobs meet the critical milestones during

daily batch processing

. Analyze all the issues that occurs during production run and fix them

to make production run smooth

. Identify the long running queries and optimize them.

. On-call duty during major releases

. Actively participated in the server migration tasks and fix the issues

during testing or in production

Technologies used: Batch processing, Microsoft SQL server 2008, C++,

C#.NET, VS 2010

Broadridge Financial Solutions

Employment Type : Full Time

Duration : 10/2007-3/2011

Team Size : 5

Projects Handled :

Client: RBS

Duration: 6/2010-2/2011

Database: SQL Server 2005

Team Size: 4

Project#4: Collateral Management

Collateral Management is the system, mainly responsible for managing

collateral positions and movements associated with Stock Borrow. Some of

the other functions include

. Bulking functionality for Collateral repays

. Send settlement messages to CHESS

. EOD extracts

. Scheduled jobs

. CUM / EX swap during corporate action period

. Development of BLL for some modules

. Developed the back end stored procedures to support the functionality

. Reporting and Tracking Status of project.

. Unit and Full Test Plan for testing the Collateral Management cycle.

Technologies used: C#.Net, SQL Server 2005 & Crystal reports 11.0

Client: E*Trade

Duration: 2/2010-5/2010

Database: SQL Server 2005

Team Size: 3

Project#3: Authorization System

Windows workflow application which provides user an option to authorize the

records entered into system

o Design and Development of screens for authorizing and monitoring the

records to be authorized

o Authorization report to track the acceptance and rejection

o Developed a mailing module to generate an email to the user who last

touched the originating transaction in the event that their transaction

has been rejected.

Technologies used: C# & SQL Server 2005

Client: E*Trade

Duration: 3/2009- 1/2010

Database: SQL Server 2005

Team Size: 3

Project#2: Web Tool

Web Tool is a web application that provides greater access to view

information related to equity trading accounts through internet web page.

To support this

. A new Reporting Database

. New suite of reporting API's that can be called form a web server-

allowing client queries to be made.

. New web page / presentation layer to display the data.

. Development of API's that can be called form windows/web application

. Designed technical document and test plan.

. Jobs to upload the data to reporting data base in real time

Technologies used: C#.Net & SQL Server 2005 (RPC's)

Client: E*Trade, RBS and ABN

Duration: 10/2007-1/2009

Database: SQL Server 2000

Team Size: 4

Project#1: Summit and its components

SUMMIT is a broker client accounting system covering the complete trading

lifecycle from order to settlement processing of equity securities in the

Australian market. SUMMIT caters for Retail, Institutional and Principal

trading activities of a brokerage firm. SUMMIT connects the various

peripheral systems through interfacing products (adapters) to achieve the

STP solution.

CHESS Interface: CHESS (Clearing House Electronic Sub register System) is

the system provided by the ASX to facilitate settlement between

participants (Brokers, Institutions or custodians) of market transactions

(trades), on a delivery versus payment (DVP) basis.

ITS Interface: A single integrated trading platform that allows brokers to

trade equities warrants and fixed interest securities and derivatives on

the same platform.

. Owned the numerous enhancements as a developer

. Involved in resolving the critical bugs

. Production support at client site.

Technologies used VB6 & SQL Server 2000

EDUCATION & DEVELOPMENT

Academic Experience:

. Bachelors Degree (B.Tech) in Computer Science Engineering from the

year 2007.

Certifications:

. Certified Market Participants, Fixed Income Securities, Equities and

Brokerage Operations courses from NYIF.

Achievements:

. Received "GOLD AWARD" and "SILVER AWARD" for year 2012, in Bank of

America, for Taking ownership of the Production support and making

sure all critical milestones are met in the daily conversion process.

Contact this candidate