DEEPTHI YAMMANI

Phone: 440-***-**** E-

Mail:abmfe3@r.postjobfree.com

SUMMARY

> 5+ years of experience with MS SQL Server as a back end developer.

> Proficient in creating Stored Procedures, Triggers and scheduling

Jobs.

> 5 years of experience in providing ETL functionality using Microsoft

Technologies like SSIS and SSRS.

> Good experience in banking industry specifically in BASEL.

> Extensive experience in Relational Database Management Systems.

> Highly self motivated and delivery focused person.

> Good team player and communicator with peers and management within and

outside the group.

SKILL SET

DATA WAREHOUSING TOOLS: SSIS, SSRS

DATABASES : MS SQL Server, Oracle, ADO .NET, MS-ACCESS

PROGRAMMING LANGUAGES: T-SQL, MDX, PL/SQL, VB.Net, Java, C, C++,

SOFTWARE : Visual Studio 2005, TFS, VSS, Office Suite

WEB TECHNOLOGIES : C#, ASP.Net, HTML, Java Script

OPERATING SYSTEMS : Windows 2K/XP/Vista, UNIX

EDUCATION

B.Tech, Computer Science & Engineering

Jawaharlal Nehru Technological University, India

PROFESSIONAL EXPERIENCE

Restaurant.com Chicago, IL Apr 2010 to Till Date

SSRS / ETL Developer

REPORTING SYSTEM:

Restaurant.com helps restaurant owners promote the new and unique

aspects of their restaurants while providing diners with great value in a

fun, new and cost effective way. The Reporting System project is

responsible for creation of various reports which are used by both

employees of Restaurant.com and the clients. The reports generated are sent

to the clients in the form of Excel and CSV spreadsheets.

Responsibilities:

. Responsible for the implementation of mappings/transformations based

on source-to-target specifications for packages.

. Create and maintain stored procedures to interpret complex business

rules and historical data.

. Generate the weekly, monthly, and quarterly reports using SSRS.

. Perform Unit testing.

Environment:

SQL Server Reporting Services (SSRS), MDX, MS SQL Server (T-SQL), SQL

Server Integration Services (SSIS)

Human Arc Cleveland, OH Nov 2009 to Mar 2010

Data Warehouse Report Writer

COMPASS DEVELOPMENT:

Compass is an application designed to serve as a business-wide

information management system for Human Arc. It ensures that the

information transfer between Human Arc and its customers is handled in a

more accurate and faster manner. Thus it improves staff productivity and

drives higher revenue potential. A set of reports were placed in this

website, out of which some were for internal usage within Human Arc while

some could be viewed by the customers.

Responsibilities:

. Analyzing the existing Stored Procedures which were written to

populate the reports.

. Creating several MDX queries according to business requirements.

. Generate reports using SSRS and the MDX queries.

. Making various structural and coding enhancements to the existing

reports.

. Using TFS for source control.

Environment:

SQL Server Reporting Services (SSRS), MDX, MS SQL Server (T-SQL), Team

Foundation Server (TFS)

Pfizer Inc. Groton, Connecticut May 2008 to Oct 2009

Data Warehouse Developer

GLOBAL FINANCE WAREHOUSE PROJECT:

This project was developed to maintain a continuous cover to monitor

the expenditures incurred in various departments at Pfizer. These

departments included Procurement, Expense Management and Capital Planning.

The project provided the facility to generate reports weekly, monthly,

quarterly and annually for its users. These reports could be generated for

different purposes based on requirements like department wise or item wise

etc. Pfizer uses these reports to predict future expense to earnings ratio

and to forecast/track budget allocations for various teams.

Responsibilities:

. Created SSIS packages to load the data into the data warehouse

environment.

. Scheduled SSIS packages by creating the corresponding jobs.

. Designed and modified the table structures and their relationships.

. Created interface stored procedures used in SSIS to load/transform

data.

. Created various reports depicting expenses.

. Created and verified batch files to ftp source files.

. Worked with the QA team to resolve bugs that were found.

Environment:

SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), MS SQL Server (T-SQL)

Shinsei Bank Chiyoda, Tokyo Jan 2007 to Apr 2008

Data Warehouse Developer

BASEL-STEP 4A:

The Basel II rules ensure that a bank maintains required amount of

minimum capital reserves. This is calculated based on the various risks a

bank faces. The overall objective of the Basel II IT Program is to

implement an IT system which will allow Shinsei Bank (based in Japan) to

meet these Basel II requirements. Step 4A is one of the numerous steps

taken to achieve this objective. To achieve this we extracted data from a

set of data sources, transformed it according to the requirements and

loaded it into the reports database which was used for further calculations

to create reports. The project team comprised of ten developers.

Responsibilities:

. Designed and implemented various Packages (SSIS) for performing the

Extract, Transform and Load functionality.

. Designed and implemented various FSA Reports (SSRS).

. Maintained SQL Server stored procedures and Jobs.

. Generated batch files to transfer source files.

. Worked with the testing team to fix any bugs that were found.

. Worked on various enhancements to include new changes.

. Was responsible for most of the coding required for this project.

. Used Microsoft Visual Source Safe to check in and checkout project

related data.

Environment:

SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), MS SQL Server (T-SQL), MS Visual SourceSafe (VSS)

Shinsei Bank Chiyoda, Tokyo May 2005 to Dec 2006

Database Developer

ACCOUNT RECONCILIATION:

Account Reconciliation is an intranet application implemented for

successful reconciliation process. This is a flexible, innovative solution

that helps reconciliation needs across multiple foreign and domestic

accounts. Using the application we compare accounting records against those

shown on a bank statement and create comparison reports. Using these

reports any possible discrepancies can be uncovered and can thus reduce the

number of errors in the accounting system. The project team comprised of 3

developers.

Responsibilities:

. Developed, modified, and optimized complex stored procedures,

. Designed and created various Reports (SSRS) depicting the comparisons.

. Monitored the scheduled jobs for proper functioning of the databases.

. Coordinated with the Onsite team during the project tenure.

. Created jobs to schedule SSIS packages.

Environment:

SQL Server Reporting Services (SSRS), MS SQL Server (T-SQL), SQL

Server Integration Services (SSIS), MS Visual SourceSafe (VSS)

Contact this candidate