Sql Server Project

DEBOPRIYO

BANERJEE

*** * ******

Street, Chicago, IL 60607

Email: ********.*********@*****.*** Ph. No. 917-***-****

SUMMARY

. Masters degree in Information Systems and 3 years of

experience in database development/administration/analysis,

ETL.

. Created database design on business requirements, T-SQL stored

procedures, functions, views, triggers.

. Strong knowledge in SQL Server 2005/2008, MySQL, Oracle 11G

. Performed database backup/restoration, performance tuning.

. A self-motivated, organized, responsible, and reliable team

player.

TECHNICAL SKILLS

. Databases: Oracle 9i, SQL Server 2008, MySQL 5.0, MS Access

2007, PL/SQL

. Programming Languages: T-SQL, PL/SQL, CSS, XML, PHP, ASP .Net,

C#, Java, VB, Unix Shell Scripting

. Packages: SSIS, SSRS, SSAS

. Methodologies: Software Development Life Cycle, Object Oriented

Analysis and Design, MVC,

Object Relation Mapping, Agile

. Tools: Visual Studio 2008, MS Project, SPSS Clementine, SAS, MS

Visio, Oracle 10g, SQL Server 2008

ACADEMICS

. Master of Science - Management Information Systems

University of Illinois at Chicago, Liautaud Graduate School

of Business, [GPA: 3.85/4.0], May 2010

. Bachelor of Science - Computer Science & Engineering

Visveswaraiah Technological University, India, 2007

CERTIFICATION

. Oracle Certified Associate(OCA)- Oracle 9i, Database Administration

. Microsoft Certified Technology Specialist(MCTS)- SQL Server 2008,

Database Development

PROFESSIONAL EXPOSURE

Database Analyst Intern, American Red Cross of Greater Chicago, Chicago, IL

(Jan 2010 - Present)

The project is MS SQL Server 2005 based database migration/integration in

which customer data has to be migrated from the accounting

application(Microsoft Great Plains) to CRM application(Saleslogix) in

batches(nightly, weekly, monthly) using Scribe Insight as an ETL(Extract,

Transform, Load) tool.

. Configured the source and the target adapters using the existing

business requirement document.

. Developed the DTS (Data Transformation Specification) scripts for data

mapping between the source and target.

. Currently performing User Acceptance Testing (UAT) on the target

application.

Web-Database Developer/Administrator, Jane Addams College of Social Work,

University of Illinois at Chicago

(Sept 2008 - Present)

This is an ongoing development and maintenance project in which the

department's internal and external web-based applications/databases have to

be enhanced and supported on time-to time basis.

. Developed/maintain various web based database applications using

ASP.NET, PHP, SQL Server 2005 and MySQL in a clustered environment.

. Performed database performance tuning, created stored procedures,

triggers, alert scripts, schedulers, and backup/recovery procedures on

2 production and 2 development servers of total size of 20GB.

. Generated reports using SQL Server Reporting Services on various

business requirements.

Database Developer Intern, Fina Interactive, Chicago, IL

(Aug 2009 - Dec 2009)

The project involved developing Fina Mobile, an SMS Texting Tool that will

allow businesses and school systems to send out text blasts to different

parties such as faculty, students, parents etc.

. Created business requirement specification along with functional and

technical requirements.

. Designed and implemented database schema using SQL Server 2008 in

collaboration with the programming team.

IT Consulting Service Team Member, Littelfuse, Chicago, IL

(Aug 2009 - Dec 2009)

The project involved working closely with Littelfuse's CIO to devise

strategy & policy for the IT department by benchmarking them with peers.

. Analyzed the existing IT infrastructure, IS Policies and technology

solutions being implemented to

develop key performance indicators(KPI).

. Benchmarked their IT operations, infrastructure and gaps against those

of competitors and provided recommendations.

. Collected industry standard Best Practices.

Assistant Database Administrator, Royal Group of Companies, India

(June 2007 -April 2008)

Royal Group is a railway equipment manufacturing company. The project

involved maintaining and enhancing the existing inventory tracking

application developed using Java EE and Oracle 9i.

. Assisted the senior DBA in providing Oracle database administrative

supports for the application.

. Created various PL/SQL stored procedures, monitoring and backup

scripts.

. Did major performance tuning on the production system.

ACADEMIC PROJECTS

Web-based Database Application for Selling Music and e-books online

Department of Information and Decision Science, University of

Illinois at Chicago

(Jan 2009-May 2009)

Role: Database Developer

Project Profile: This web-based database application developed in

ASP .Net and MS SQL Server 2008

facilitate users to purchase Music and e-books online.

Online Stock Predictor for Enterprise Application Infrastructure

Department of Information and Decision Science, University of

Illinois at Chicago

(Sept 2008-Dec 2008)

Role: Documentation and Business Analysis

Project Profile: This web application developed in J2EE and MYSQL

forecasts the stock values depending on

historical stock data using Time Series Analysis. The stock values

are displayed in tables as well as histograms.

Predictive model for indentifying potential donors for a Non-profit

organization

Department of Information and Decision Science, University of Illinois at

Chicago

Role: Predictive Modeler

Project Profile: The data-mining project which will facilitate a

non-profit organization to identify potential donors(Models

used: CHAID, Neural Networks)

RELATED COURSEWORK

. Advanced Database Management System, Business System Analysis and

Design, Data Mining for Business, Enterprise Application

Infrastructure IS Project & Program Management, Information Systems

Strategy & Policy.

Contact this candidate