Sql Server Project

SHRUTI KULKARNI

***** **** *******, 571-***-****

South Riding, VA 20152 Email ID: abnue1@r.postjobfree.com

Key Strengths

Strong Database Designing and Development skills.

Extensive experience in ETL using DTS and SSIS.

Experience in SQL Server 2005 Integration services (SSIS) and Reporting services (SSRS).

Experience working with terabyte-sized databases in multi server environment.

Experience in DBA activities, like database backup and recovery, replication, performance

monitoring/tuning.

Excellent self-learning capability.

Technical Skills

SQL Server 2005, SQL Server 2000, Oracle7.x, MS Access 2000

Database:

VB.NET, VB 6.0, VBScript, C, SQL, PL/SQL

Programming Languages:

Window 2003 Terminal Server, Windows 2000, Windows XP, Windows NT 4.0,

Operating System:

Windows 98/95

Visual Studio 2005, VB.NET, VB 6.0, Developer 2000, Crystal Report 8.0

GUI:

Visual Source Safe, Visio, Erwin, ArcGIS, MapObjects 2.0, ADO, SOAP, XML 2.0

Others:

Education/Training

B.E (Computer Science), INDIA.

Successfully completed GIS Database Development training by ProximityOne. Learned about Census Data and

used GIS tools to plot the data on the Map.

Professional Experience

Close to 7 yrs of extensive software development experience.

Currently working at Sprint Nextel Corp in Reston VA as Database Developer / Admin I. Involved in automating

the data warehouse system by converting DTS to SSIS, writing stored procedures and batch scripts, support

various client requests for analyzing customer data and generating reports which help in business growth.

Worked as Sr. Consultant with FTI Consulting; Washington D.C. FTI is a leader in areas such as investigations,

litigation, mergers, acquisitions, regulatory issues and reputation management. As a Sr. Consultant, I was

responsible for developing various data load SSIS packages as per the client requirements into document

management and review software such as Ringtail, Summation, Concordance and IPRO. I was also involved in

developing various database objects to stream line the Ringtail data load processes and development of large

reporting project for their Forensic and Litigation Consulting division using SQL 2005 reporting services where

clients can view Ringtail document review progress and status reports.

Worked as Database Developer with Exmplar, Fairfax, VA where I was responsible for requirement gathering

and analysis, designing database, creating database objects, managing ETL activities by creating and scheduling

DTS/ SSIS packages. I was also responsible for managing the conversion of SQL 2000 to SQL 2005 with offshore

team in Russia.

Worked as Project Lead from February 2003 to August 2007, Managed and developed enterprise level software

for real estate and commercial builders like Comstock Homes using SQL Server 2000, VB 6.0, VB.NET, ADO,

SOAP, and XML on Windows 2003 Terminal Server.

Worked as Database Specialist/ Database Analyst Intern in American Red Cross Developed GIS application

using ArcGIS 8.1, SQL Server, Crystal Reports, Visual Basic 6.0, MapObjects 2.0.

Projects at Sprint Nextel Corp, Reston VA (TEKSystems Consultant):

Since Feb 2009 Till Date

Project Name: Data Warehouse Automation / Report Management

Project Description: Currently working writing and managing stored procedures and SSIS packages and batch

scripts to automate large data into the data warehouse systems. Generate reports based on customer request

using SSRS. Assist in creating and managing Meta data by adding extended propertied to database objects and

assist in DBA activities. Implemented various automations like email alert for failed jobs, reports for objects

missing Meta data and auto zipping process.

Environment: SQL Server 2005 (SSIS and SSRS), SSMS, Batch scripts, MS Visual Studio 2005

Role: Manage, create and maintain various SSIS packages, SSRS report, stored procedures, UDFs, batch scripts

required for large data warehouse servers. Automate all manual processes to the maximum extend.

Projects at FTI Consulting, Washington D.C:

From Oct 2008 To Feb 2009

Project Name: Ringtail Data Load Automation and Analysis

Project Description: Worked on implementing data load and analyze project where large data will be loaded

based on various client requirements by identifying the specific coding in legal documents after it was reviewed

by the client. Various complex algorithms are created to for text search on large volumes of legal document to

identify the privileged and non privileged documents. Also various statistical reports are generated such as

number of documents reviewed and rate of documents reviewed.

Environment: SQL Server 2005 (SSIS and SSRS), Ringtail

Role: Worked closely with clients and legal consultants for developing various stored procedures, triggers and

automated DTS /SSIS packages for data load processes. Also involved in developing various reports using SQL

sever reporting services.

Projects at Exmplar, Fairfax VA:

Since Sept 2007 To Oct 2008

Project Name: Brand Personalization Campaigns

Project Description: Successfully completed multiple complex business processes for creating personalized

emails based on client specific data and requirements. These processes are typically called as “Replenishment

Customization”, “Product Affinity”, “Category Affinity” etc, where customer’s order history is analyzed to

determine what rewards can be offered. Created various bulk load scripts and optimization plans to work with

the large size of the data.

Environment: SQL Server 2005, SSIS, SSRS, SQL Server 2000, DTS.

Role: Worked closely with clients for gathering the business requirement and created plans and strategies to

design the database. Developed various stored procedures, developed and automated DTS /SSIS packages.

Project Name: Customized email Campaign Analysis

Project Description: Successfully implemented complex business logic to analyze the outcome of customized

campaign with multiple parameters and numerous reports are generated. These reports are then used by client to

plan future marketing strategies. The process is also used to understand the customer behaviors to a specific

reward or coupons offered. Various stored procedures and functions are developed to implement the complex

algorithms to use historical order data and user’s email click information.

Environment: SQL Server 2000.

Role: Was involved in understanding of client’s requests and converting them in technical requirements.

Designing database schema and developing database objects. Developed complex DTS and SSIS packages and

scheduling of those packages. Designed and deployed reports in SQL Server.

Projects at IConnect, Reston VA:

Feb 2003 To Aug 2007

Worked with IConnect as Project Lead for development of “Construction Management System” enterprise level

software for real estate and commercial builders. Lead a team of 7 developers.

Project Name: JD Edwards Enterprise One Integration

Project Description: Worked on Integration of “Construction Management System” with JD Edwards ERP

(Home Building Module). I was involved in extracting pre construction cost related data from JD Edwards and

then processing this data to be used by the Construction Management System. As part of post construction

process, it also sends supplier payment information back to JD Edwards.

This is achieved by multiple DTS packages scheduled daily. The DTS package generates reports for the processed

data and also sends error reports and alerts to the users via emails. Additionally it also archives data for historical

purposes.

Environment: JD Edwards (Home Building module) 8.12, SQL Server 2000/2005.

Role: Solely responsible for requirement gathering and analysis, creating and maintaining batch jobs and stored

procedures, creating and scheduling DTS packages, creating and managing alter subsystems.

Project Name: Construction Management System

Project Description: This is Enterprise level Software for Real Estate and Commercial Builders comprising of

various modules like Contact Management, Land Development & Contract, Entity & Finance Management,

Estimating & Scheduling, Production Management and Sales & Marketing.

Environment: Windows 2003 Server, SQL Server 2000/2005, Visual Basic 6.0,VB.NET, ADO, XML 2.0, ILOG,

TValue Engine, InterFax, ASPQmail

Role: Leading team of 7 developers and responsible for requirement gathering and analysis, creating and

maintaining database, creating and scheduling DTS, backup and restoring database, development and

maintaining Construction Management System, configuration management, managing releases, data conversion

from new client’s legacy system and package & deployment,

Project Name: Cost Analysis Software (Financial)

Project Description: This application is developed in Visual Basic 6, VB.NET to provide a user interface, which

enables the client to map and convert the financial data from their legacy system stored in MS Access database

into Copilot Financials SQL Server 2000 database.

Created multiple DTS packages for Data Conversion and Data Massaging. Worked on many Stored Procedures

and Function to generate Financial Reports like, WIP Analysis, Flux Analysis and GL and Job Cost Reporting etc.

This data is also used by IConnect’s ‘SOX’ application to verify the financial data based on ‘SOX’ compliance rules

for quarterly financial reporting.

Environment: Windows 2003 Server, SQL Server 2000/2005, VB.NET, Visual Basic 6.0, XML 2.0, MS Access.

Role: Solely designed and developed the database and the application. Developed multiple DTS for data

conversion.

Project Name: Prospect Management System

Project Description: The ‘Prospect Management System’ is developed to manage prospective homebuyer’s data.

The prospective buyer’s information can be captured either through ‘Walk-In’ enquiry at the sales office or by

uploading from builder’s web site or from prospect list provided by organizations like New Homes Guide,

BeHomeWise, etc. Based on the prospect data loaded, numerous traffic reports can be generated to help develop

marketing strategies. The ‘E-Card’ feature of the application to inform about upcoming communities and

promotions can contact prospects.

Environment: Windows 2003 Server, SQL Server 2000, Visual Basic 6.0, XML 2.0, ASPQmail 2.6

Role: Designed and developed the database and the application. Integrating ASPQmail for the ‘E-Card’ feature.

Project Name: Fax Interface

Project Description: Developed automated Fax System using Interfax web service. The application is developed

to initiate fax request and generate automated email to inform user regarding fax status.

Various system reports are generated to provide statistics of faxes sent over period of time.

Environment: Windows 2003 Server, SQL Server 2000, VB.NET, ADO, SOAP, Visual Basic 6.0, InterFax

Role: Integrated Interfax web service with Copilot Application. Designed Database and UI for the application.

Assignments at American Red Cross, Washington D.C:

Oct 2002 to Jan 2003

Worked with American Red Cross as Database Analyst Intern. Developing Database for GIS Application.

Creating User Interface using Visual Basic and MapObject 2.0, creating Tables, Triggers and writing SQL queries

for application using SQL, PL/SQL.

Project Name: Disaster Recovery System

Project Description: Worked on GIS Applications using ArcGIS 8.1 for Developing Disaster Recovery System.

Developed database for Geo coding. Created different Reports using Pl/SQL code for GIS application. System

helps Red Cross Organization to study the locations in Fairfax County and Washington D.C, which are more

sensitive to Fire, Flood and other such incidents.

Environment: SQL, PL/SQL, Visual Basic 6.0, Crystal reports, ArcGIS 8.1, MapObjects 2.0, SQL Server 2000

Role: Requirement Analysis. Created database for the application. Involved in Geo coding the database, plotting

data on Maps using ArcView 8.1, creating Crystal reports, developing user interface using Visual Basic 6.0 and

MapObjects (ActiveX control) for interactive GIS application.

Project Name: Disaster Volunteer Program

Project Description: Developed Database and Reports for Disaster Volunteer Program. Multiple Reports are

designed and developed using Crystal Reports. These reports are the part of Disaster Service by Red Cross. These

Reports are generated by the data entered by Volunteers at the disaster site or after disaster while helping

victims.

Environment: SQL, PL/SQL, Crystal reports 8.0

Role: Developed Database, Converted all manual Reports into Crystal reports. Created and tested reports.

Integrated Reports with the Disaster Volunteer Program Application.

Summary of Projects done in Zee Interactive Learning Systems India

Oct 1998 to Feb 2001

Project Name: Hospital Management System

Client: Ghati Civil Hospital, Aurangabad, India

Project Description: This software is intended to carter to hospitals. It consists of various modules to automate

the different aspects of hospital management such as patient registration, room & bed allotment, bill processing

based on the different services provided, case history reporting, generating laboratory test reports & maintaining

inventory of clinical products. This was developed in Visual Basic 6.0 as GUI and Oracle as the database.

Environment: Oracle 7.X, PL/SQL, SQL, Visual Basic 6.0

Role: Was involved in designing tables for the different modules and also creating stored procedure and triggers

to handle different business logic. Also created different interfaces and various reports for this application.

Project Name: Sales Tracking Software

Client: Lupin Pharmaceuticals, Pune, India

Project Description: This software is developed for a pharmaceutical company. It is develop to manage

information about company representatives in various regions. Database is divided into three basic parts i.e. Sales

Representative data, Company Product data and Sales data. More that 60 reports are generated. Also some charts

and graphs are generated using Visual Basic 6.0 for analysis.

Environment: Oracle 7.3, PL/SQL, SQL, Crystal Report, Visual Basic 6.0

Role: Was involved in database designing, writing stored procedures and triggers and creating reports.

Project Name: Course Management

Client: ZEE Learning Group, Mumbai, India

Project Description: This software is developed for ZILS and its branches all over the state. It basically handles

student information for those enrolled for different short-term and long-term software courses. It includes

modules such as course details, certificate examinations (theory and practical), fees structure, and small library

transaction. It also includes maintaining partner company information for the student placement after completion

of software course. It is designed to develop different reports such as monthly fees reports, student examination

reports, and library transaction reports. This was developed in Visual Basic 6.0 as GUI and Oracle as back-end.

Environment: Oracle 7.3, PL-SQL, SQL, Visual Basic 6.0

Role: Was involved in creating triggers, developing user interfaces and reports.

Summary of Projects done at Center for Electronic Design and Technology of India

Mar 1998 to Aug 1998

Project Name: Store Automation

Project Description: Store Automation software is developed to manage the CEDTI stores. It stores item and

supplier information. Depending upon the stock, order is generated and is send to the suppliers. When product

and bill from the supplier is received the product database is updated. It also maintains information about items

distributed in CEDTI staff. It also maintains dead stock database. Forms such as supplier information, product

information, order processing and reports such as monthly stock, product category wise report and dead stock

reports are generated.

Environment: Oracle 7.3, PL-SQL, SQL, Developer 2000 Forms 4.5 and Reports 2.5

Role: Was involved in creating triggers, developing forms and reports.

Contact this candidate