Sql Server Data

Madhuchhanda Kundu

**** ******** ****,

Charlotte NC – 28262,

Phone – 704-***-****

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

Profile

Senior DBA \ Data Warehouse Developer \ Application Developer & Analyst, with 14 years of

experience in Database Management systems, Application Development and Data warehousing

solutions in large corporations.

Involved in SQL SERVER ADMINISTRATION, monitoring, replication, and tuning experience

on a

24*7 mission critical production environment

Involved in N-Tier full development cycle including system design, development, unit/integration

test, user acceptance test, system document and implementation.

Capable in working under stress and tight project timeframe.

Extensive experience with DBA expertise, client-server programming, data warehousing and

various reporting technologies.

Technical Skill Summary

DBA Specific SQL SERVER Tools including Enterprise Manager / DEV STUDIO, DTS\SSIS,

SQL PROFILER, PERFORMANCE MONITOR, SQL SERVER Query

Analyzer, Analysis Services.

GUI Development: Visual Studio, INFORMATICA, EAGLE PACE DATA WAREHOUSE,

Autosys, SharePoint.

Programming Languages: Visual Basic (3.0, 4.0, 5.0, 6.0), VB.NET, SQL, Basic, HTML,

VBScripts, T-SQL/PLSQL, COM, DLL’s,, MTS, Classic ASP, ASP.NET, C#

Database Platforms: SQL SERVER 2005, SQL Server (2000, 7.0,6.5), ORACLE, Sybase, MS

Access.

Operating Systems: UNIX, NT, Win 3.1, Window 95, MS DOS,

Experience

Client: Round Point Financials, Charlotte NC.

Implementation: - SQL SERVER 2005, SSIS

Date: AUG 2008 – Now

Development:

• Designing and Implementing Datawarehouse Solution using SQL Server 2005 features like SSIS and

TSQL scripts and stored procedures.

• Configured SharePoint to be a SSIS Data Source .

• Rebuilding the indexes at regular intervals for better performance

• Created and modified Stored Procedures and Functions to generate reports.

• Dimensions and Facts were populated using SSIS packages.

• Fixed data issues and writing various SQL scripts and procedures for migration process.

• Monitored and modified Performance using execution plans and Index tuning.

• Maintaining the database consistency with DBCC, DMF and DMV’s at regular intervals.

• Generated Script files of the databases whenever changes are made to stored procedures or

views.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Discussions and meetings with web Hosting product development and sales teams based on

customer requirements.

Database Administration :

• Performed DBA duties such as capacity planning, monitoring disk space, performance tuning,

maintenance plans to monitor and create database backups and routine DBCC's.

• Performed daily tuning and Index planning, fragmentation and detection of bottleneck.

• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

• Involved in creation of tables, views, indexes, triggers, Stored Procedures Functions, Constraints,

Rules and Defaults.

• Generated Database snapshots for data archives and for creating reports.

• Exporting and Importing of databases using EXCEL/TXT FILES/DAT FILES.

• Scheduled and monitored all maintenance activities including database consistency check, index de-

fragmentation.

• Created and deployed packages using SSIS and automated the packages using SQL Server Agent.

• Implemented Linked Server between the servers for cross database transactions.

• Create, modify, maintain and trouble shoot scheduled jobs.

• Involved in stored procedures optimization, performance tuning and index tuning.

• Migrated DTS packages to SQL Server2005.

• Extensively created, automated and managed SSIS packages.

• Implemented security by creating users logins with appropriate roles, dropping and locking the logins,

monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

• Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular

basis.

• Data transfers between various servers using BCP and DTS/SSIS.

• Involved in troubleshooting and diagnosing database problems.

• Played a key-role in solving Critical SQL Server bugs and Issues.

• Estimating storage capacity and monitoring the growth of database objects for capacity planning.

• Involved in 24 x 7 production support.

Client: Price Waterhouse Coopers, Albany, NY

Implementation: - SQL SERVER 2005, SQL SERVER 2000, SSIS, Crystal

Reports 9,0, VB.NET, ERWIN, VISIO.

Date: 2007 – 2008

Development:

• Involved in the successful implementation of Healthcare Product called Smart20, MEDPAR,

MEDICARE and other Insurance data Systems.

• Responsible for the design of all customizations, rule development, and conversion validation for

Smart20, MEDPAR, MEDICARE Products.

• Automated self designed SSIS packages, stored procedures, SQL Scripts into Scheduled Jobs in SQL

SERVER.

• Used Crystal 9.0 Enterprise Reporting Solutions for Reporting needs (adhoc and Customized).

• Designed Smart 2,0 using tools like Erwin and Visio.

Database Administration :

• Analyzed existing database and redesigned databases for better performance.

• Work with development team in implementing business logic using Triggers, Views, Stored

procedures, and User Defined Functions for web applications.

• Created a scheduling process, which would extract and import data from text files using DTS

packages and BCP utility.

• Implemented various data transfers into Excel Sheets for reporting using DTS packages for Sales and

Marketing division.

• Scheduled regular Full, Transactional log backups as per business requirement.

• Closely worked with business analyst for capacity planning, storage and data archiving that would help

in load balancing of the present OLTP database running on SQL server 2000.

• Mentoring programmer’s team in development of stored procedures and triggers using T-SQL.

• Allocated resources, adding users and granting permissions. Closely worked with front-end

programmers, Developers to solve problems regarding databases and database objects.

• Assisted/advised development team in tuning exiting stored procedures and scripts.

• Extensively created, automated and managed SSIS packages and migrated DTS 2000 packages.

• Created and updated reports using Crystal Reports.

Client: Gevity – HR, Charlotte, NC

Implementation: - SQL SERVER 2005,VB.NET

Date: 2007

Development:

• Designed and worked on software systems to produce payroll, timesheets, benefit information.

• Responsible for the design of all customizations, rule development, and conversion validation for Time

and Labor implementation.

• Automated the process for payroll, timesheets Rollouts and eliminated the manual process of payroll,

timesheets .

• Reviewed and developed several benefit customizations and inbound/outbound interfaces for Benefits

Administration.

• Involved in designing, implementing, enhancing existing content management and workflows.

Database Administration :

• Worked as the primary resource in the conversion effort from legacy systems from SQL SERVER 200

to SQL Server 2005

• Designed and developed an approach for the GUI selection process for Benefit Information.

• Developed and automated different Client Info to produce month end reports using SSIS, vb.net and

SQL Jobs.

• Reviewed and Documented necessary modifications/enhancements for Interfaces, Reports and

Queries like a change in a Field or a Record definition etc.

• Identified all the Custom Fields, Records, Pages, Components for Benefit Systems and documented

them on a spreadsheet.

• Restored Client Specific databases on host systems and maintained necessary security items like

logins, permissions etc.

Client: TIAA-CREF, Charlotte, NC

Implementation: - Oracle (8.0, 9.0),Informatica(7.0),EAGLE PACE

- Crystal Reports(8.5), VB 6.0, VB.NET, SQL SERVER

2000, Autosys

Date: 2004-2007

• Used multi tier client - server technology to design, code, implement and deploy high-performing

Fund Accounting applications .

• Involved in system analysis with the business partners as to a viable business solution that can be

technically implemented using the suggested timeline.

• Used SQL Server 2000 and Oracle used for writing complex stored procedures and

TSQL/PLSQL scripts.

• VB 6.0 COM based code was written to interface the back end database.

• Worked intensively on Eagle Pace development to roll out Pace procedures in production.

• Data extraction techniques and ETL tools were used to interface Eagle Pace Data Warehousing

product.

• Used VB.NET to interface with date-feeds.

• Worked extensively with Informatica to work hand in hand with Eagle Pace Data Warehousing.

• Got familiar with Analysis Services of SQL SERVER 2000 as a part of training course.

• Extensive work in ETL process consisting of data transformation, data sourcing, mapping,

conversion and loading.

• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts,

Stored Procedures and execution for loading the data successfully into the targets.

• Expertise in developing SQL and PL/SQL codes through various procedures, functions, and

packages to implement the business logics of database in Oracle.

• A Team Player with excellent communication, analytical, verbal and writing skills.

Client: Bases Loaded INC, Charlotte, NC

Implementation: - VB6.0, SQL SERVER 2000, MS ACCESS, COM, DLL,

- DTS, Active X scripts,

- Crystal Reports

Date: 2003-2004

Used 3 tier client server architecture to design, code, implement and deploy software. SQL 2000

and VB 6.0 is intensively used for complex stored procedures, triggers, Transact-SQL Scripts,

DTS packages, Active X scripts, COM Objects and DLL’s.

Client: Wachovia Corporation Charlotte, NC

Implementation: SQL Servers 2000, 7.0, 6.5

Date: 1999 -2003

Database Administration :

• Performed installation and configuration of MS-SQL Server 2000 database and updated it with the

latest service packs .

• Upgraded SQL Server 6.5 to 7.0 and 7.0 to 2000 and resolved the issues.

• Involved in setting up a clustered environment .

• Responsible for Database Administration, System Analysis, Design, Development & Support of MS

SQL Servers 2000, 7.0, 6.5 in Production, QA, & in Development environments.

• Performed DBA duties such as capacity planning, monitoring disk space, performance tuning,

maintenance plans to monitor and create database backups and routine DBCC's.

• Performed daily tuning and Index planning, fragmentation and detection of bottleneck.

• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

• Scheduled and monitored all maintenance activities including database consistency check, index de-

fragmentation.

• Extensively used Snapshot and Transactional Replications to update databases in different

physical locations and resolved several issues between the servers in Replication

• Involved in creation of tables, views, indexes, triggers, Stored Procedures Functions, Constraints,

Rules and Defaults.

• Generated Database snapshots for data archives and for creating reports.

• Exporting and Importing of databases using EXCEL/TXT FILES/DAT FILES.

• Scheduled and monitored all maintenance activities including database consistency check, index de-

fragmentation.

• Worked on creating SQL traces using SQL Profiler and also efficiently used the Performance Monitor

utility to capture the hardware bottlenecks.

• Implemented Linked Server between the servers for cross database transactions.

• Create, modify, maintain and trouble shoot scheduled jobs.

• Involved in stored procedures optimization, performance tuning and index tuning.

• Created and maintained DTS packages to SQL Server2000.

• Maintenance of DBA jobsite using HTML and MS Frontpage. Occasionally assist developers in

VBSCRIPT to launch DTS Scripts. Expert using VB 6.0 using in relevance to SQL DMO and DTS

scripts.

• Implemented security by creating users logins with appropriate roles, dropping and locking the logins,

monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

• Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular

basis.

• Data transfers between various servers using BCP and DTS/SSIS.

• Implementing Log shipping on local/remote warm standby servers.

• Involved in troubleshooting and diagnosing database problems.

• Played a key-role in solving Critical SQL Server bugs and Issues.

• Create, modify, maintain and trouble shoot scheduled jobs.

• Used data warehousing using building cubes and other analysis services (OLAP) solutions.

• Maintained and monitored daily jobs scheduled through AUTOSYS running in an UNIX environment

• Estimating storage capacity and monitoring the growth of database objects for capacity planning.

• Involved in 24 x 7 production support.

Client: Allstate Insurance Company, Charlotte, N.C

Implementation: Visual Basic 5.0, Oracle 7.3, Crystal Reports 5.0, ASP, VISUAL INTERDEV

1.0 & 6.0 MICROSOFT FRONTPAGE, HTML, Visual Source Safe,

WINDOWS API,ACTIVEX,DHTML, MS Visual Interdev 1.0, MS FRONT

PAGE & Image Composer.

Date: April 1996 - April 1998

Developed web interface using VB 5.0, Microsoft Frontpage and HTML, ADO 2.5, Oracle 7.3 and

Crystal Reports 5.0, MTS servers. This was an object oriented COM based Solution compiled in

DLL’s.

Other Experience

Duke Power, Charlotte, NC-Application Consultant (1996-1997)

Designed, developed & implemented a system to track down all past, present and

future positions in IM, evaluating available resources & making proper

assignments. The system interacted with multi-databases and produced reports

using ODBC API calls, VB (4.0), Sybase, SQL Sombrero, Crystal Reports 5.0

Ciber INC(Advisor Technologies), Charlotte, NC- Consultant 1996

Developed a GUI interface using VB(4.0) interacting with business object library

as OLE automation objects developed in VC++. VB used these business objects to

develop & interact indirectly to the data file. This was a three tier COM based

design approach. Third party controls (Sheridian) & tools (VB Assist) were

comprehensively used.

Ciber INC (Mecklenburg County), Charlotte, NC – Consultant 1996

Used VB as the user interface & access as the backend database, Crystal Reports 4.5

to design, develop, code & implement a system to track down child fatality for the entire

Mecklenburg county.

Info Systems of NC, Charlotte, NC – Systems Engineer (1995-1996 )

Used Visual Basic 4.0 as a front end and SQLServer as the back end database to

design and develop applications like Fprice for the Spartan Stores. It queries the

entire MarketPlace database to find any changes in prices, products or vendors etc.

and uploads information on DOS files to host locations. Designed and developed

reports using Crystal Reports 4.5 for both Access and SQL Server.

American Heart Association, Dallas, TX- IT Consultant 1995

Ported VAX Applications to client-server technology using Visual Basic 3.0 and Access 2.0

Andersen Consulting, Dallas, TX – Consultant 1995

The project included design and implementation of an Access database system to track associate

productivity in different functional areas at Sea-Land Co.

ADIA Information Technologies, Dallas, TX – Consultant 1995

Worked with a GTE team to migrate the production scheduling and tracking systems (PSTS) off the

GTE mainframe onto a GTE designated (MS Windows) platform using MS Access and Visual

Basic.

TSG Inc., Dallas, TX – Consultant 1994

Worked with Microsoft Access, Visual Basic and Visual Basic Scripting Tools.

Education

M.S. in Computer Science

Texas A & M University, Commerce, TX May ‘94

Other Training

• DEVELOPING Microsoft ASP.NET Web Applications Using Visual

Studio.NET (M2310)- IKON Technology.

• PROGRAMMING With Microsoft Visual Basic.NET (M2373)– IKON Technology

• DEVELOPING Microsoft .NET technology using C#.

• Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000-

(M2074) – Ikon Technology

• SQL Admin 7.0 – IKON Training Services

• SQL Implementation – DBBasics.

• Attended a professional conference with SQL Connections at New Orleans

2000.

• Windows 2000 & networking –IKON Training Services.

• Corporate Training in Oracle

Designed and implemented a library information system using

ORACLE 6.0 & SQLFORMS 3.0.

Contact this candidate