Sql Server Data

Rahul Goparapu

Microsoft SQL specialist

Professional Experience Summary

. Over 6 years of Experience in Development, Reporting, Data Modeling,

support for MS SQL SERVER 2008/2005/2000/7.0 in development and

Production environment.

. Development experience

. Expertise in ETL- Data Extraction, Transformation and Loading from

various heterogeneous sources like SQL Server, Oracle, Access,

Excel.

. Created SSIS Packages to support business processes and data

transformation.

. Developed packages using some of the transformations like OLE DB,

Derived Column, Script Task, Flat file, Conditional Split,

Aggregate, Lookup, Execute SQL Task, Merge, Condition Split, OLE-DB

command, slowly changing dimension and some other transformations.

. Using Checkpoints, Breakpoints and Data Viewers in debugging

packages.

. Knowledge about Surrogate keys, Slowly Changing Dimensions, Star

and Snowflake schema, Dimension and Fact tables.

. Experience with DTS packages, migration and testing of DTS to SSIS

packages

. Experience in implementing business logics using stored procedures,

functions and triggers.

. Experience in writing batch and T-SQL scripts.

. Experience in using tools like SSMS(SQL Server Management Studio),

BIDS(Business Intelligence Development Studio)

. Involved in SDLC life cycle of the project and also have an

experience from collecting data from the end user to production

environment.

. Monitored Indexes, File Growths and analyzed Blocking Locking

issues to remove the performance bottlenecks.

. Experience in migration of data using BCP utility, Import/Export

Wizard and Bulk Insert.

. Knowledge of SSRS in creating and working with some of the some

standard reports.

. Created Drill-down, Sub-Reports, Parameterized and Multi-valued

parameter reports.

. MS SQL Database administration experience

. Logical modeling and physical database configuration in a clustered

Windows environment

. Data migration, upgrade and cutovers

. Disaster Recovery planning

. Replication design and implementation, Mirroring setup

. Operational DBA - Performance tuning, disaster recovery, log

monitoring/shipping, Level 1, Level 2 production support, applying

patches, service packs and DB hot fixes.

. Experience in Troubleshooting and resolving databases and server

issues.

. A Team Player with excellent communication, analytical, verbal and

writing skills. A quick learner, organized, resilient and self-

motivated.

Education: Bachelor in Electronics and Communication Engineering

Skills / Tools:

Databases: MS SQL Server 7.0/2000, 2005 & 2008, MS Access, FoxPro 2.6,

Clipper

SQL Server 2000 Tools: Enterprise Manager, DTS, Query Analyzer, Client

Network Utility, Server Network Utility, Profiler, Index Tuning Wizard

SQL Server 2005 Tools: Query Editor, SQL Profiler, Database Engine Tuning

Advisor, SSMS, SSIS, SSCM, SQL Server Surface Area Configuration.

SQL Server Third Party Tools: Veritas 4.5, 5.0 and Quest SQL LiteSpeed 4.0,

Erwin 3.5, 4.1

Reporting tools: SSRS, Crystal Reports 7.0

.Net Technologies: ASP.NET, XML, HTML

Programming Languages: SQL, Perl, VBScript, and VB 6.0

Front End Tools: MS Office 2000/2003/2007, MS Visio, MS Project, Business

Objects.

Servers: Windows Computer Cluster Server, Microsoft Virtual Server, VM Ware

Operating Systems: MS Windows Server 2000/2003 Standard/Enterprise Edition,

Windows NT 4.0 Work Station/ Enterprise Edition, Windows XP Professional.

Professional Experience:

RR Donnelley, Glen Mills, PA November 2009 to

Till Date

MS SQL/BI Developer for FundSuite ARC (for N-MFP) and FundSuite ARC

Reporting at RR Donnelley (formerly Bowne GCOM2 Solutions).

Client provides financial, marketing and business communications services

around the world.

It also provides integrated solutions for Investment managers and third

party fund administrators to streamline the document processes and produce

high quality communications for their shareholders.

MS SQL/BI DEVELOPER

. Created new database objects like tables, views, indexes, stored

procedures, user defined functions and triggers on Production database

in SQL Server 2008.

. Performed ETL process for Data Extraction, Data Transformation like

data cleansing, data manipulation, data consistency and loaded the

data to the Production Databases using standard SSIS control flow and

data flow tasks.

. Large scale ETL experience within SQL Server.

. Developed SSIS Packages to Import data from the user and load it to

the database.

. Performed various Data Transformation tasks in order to meet the

business requirements.

. Designed complex Stored Procedures to migrate data from Staging to

Production environment.

. Migrated old legacy SQL Server 2000 DTS Packages to SQL Server 2005

and SQL Server 2008 SSIS Packages

. Optimizing SQL Queries and troubleshooting for best performances

. Install SQL Server databases, services, patches, and/or hot fixes.

. Worked on DTS Packages, DTS Import/Export for transferring data from

Heterogeneous Databases.

. Configured SSIS logging for logging the detailed information.

. Migrated data from old legacy databases to new database using SSIS

. Performed Performance Tuning and Query Optimization by studying the

execution plan and using the profiler to locate long running queries.

. Performed Performance tuning by having Indexes on the Tables.

. Analyzed the bottlenecks in the Stored Procedures, SQL queries and

tuned them for better performance of Data Migration, also created new

Stored Procedures and scripts for enhancements of the existing

application.

. Respond to production and/or mission-critical issues and needs support

on 24x7 basis

. Enforced referential integrity via creation of constraints on database

objects

. Working in SQL Server Reporting services (SSRS) for Reports.

. Created and tested various reports depending on the business

requirement using controls like Table, Chart, Matrix and Image to

create reports with Drill-down, sub-reports, Parameterized and Multi-

valued parameter reports using SSRS

Environment: MS SQL 2008/2005 Servers, SQL Cluster Servers, MS Windows

Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS,

SSMS,C# .Net.

Wilmington Trust Corp, Wilmington DE July 2008 to

October 2009

Client is a leading personal and business investment planning and banking

service provider.

The business portfolio database contains sensitive customer information

including fixed assets, expansion and expense portfolio.

MS SQL DEVELOPER/DBA

Interact with the clients to determine the requirements.

. Created new database objects like tables, views, indexes, stored

procedures, user defined functions and triggers on user databases in

SQL Server 2005.

. Created and deployed SSIS packages on development, QA and Production

servers.

. Developed some of the SSIS packages to load the data from the data

warehouse.

. Used various transformations like Execute SQL Task, Merge, Condition

Split, OLE-DB command, slowly changing dimension and some other

transformations.

. Modified some of the existing packages to increase the performance by

adding new logic.

. Designed and developed STAR schema data marts.

. Worked on DTS Packages, DTS Import/Export for transferring data from

Heterogeneous Databases.

. Handled conditional data and data conversion using Integration

services.

. Installed and configured SQL Server 2000/2005 Enterprise Edition.

. Provided maintenance support to existing SQL Server 2005 installations

and new SQL Server 2008 installations.

. Granted, updated and revoked privileges to database users on database

objects in SQL Server 2005.

. Populated user databases in SQL Server 2000 via DTS and BCP command

line utility.

. Configured database backups via Full, Differential and Transactional

Log database backup in VERITAS backup tool.

. Configured and worked on database replication, log shipping, database

snapshots and database mirroring.

. Monitored lock Escalation, Dead Locks, resources utilization by

sessions, capturing long running SQL queries.

. Created Database Maintenance Plans for Performance of SQL Server which

covers Database Integrity Checks, Update Database Statistics and Re-

indexing.

Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows

Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, SSIS,

SSMS, VERITAS 4.5/5.0.

Pitney Bowes, Stamford CT May

2007 - June 2008.

Client is a global leader in office automation, management and security

products and solutions. The databases I worked on supported their global

logistics operations. The BI suite on MS SQL helps the client to manage and

optimize shipping and fulfillment costs.

SQL SERVER DEVELOPER /DBA

. Objects moving between Development, Staging, Pre Production and

Production.

. Design and development of new packages and Data flows depending on the

user requirement.

. Configured SSIS objects including Dimensions, Measures and Cubes using

UDM and BIDS

. Checked the source data quality against a standard data set using a

Multicast.

. Assisted clients with integration and data conversion activities using

SSIS.

. Automation of packages using SQL Server Jobs and creating tables to

keep track of Audit.

. Maintained SQL Script for creation of Database Objects.

. Enforced referential integrity via creation of constraints on database

objects.

. Populated user databases in SQL Server 2000 via DTS utility.

. Writing Stored Procedures & Functions based upon request.

. Created SQL Server traces using SQL Server Profiler for optimal

performance monitoring.

. Created new user databases, database files, database files groups in

SQL Server 2005 via SSMS and T-SQL.

. Created reports based on data selected such as Drop-down.

. Used variety of controls such as Table, Matrix, Chart and Image for

the reports.

. Upgraded SQL Server 2000 Enterprise Edition to SQL Server 2005

Enterprise Edition.

. Granted, updated and revoked privileges to database users on database

objects in SQL Server 2005.

. Scheduled backups configured database mail profiles for sending

automatic mails to respective users upon failure of a database task.

. Configured and worked on log shipping, database snapshots and database

mirroring.

Environment: MS SQL 2005/2000 Servers, SQL Cluster Servers, MS Windows

Server 2000/2003 Enterprise Edition, Query Analyzer, SQL Profiler, Business

Intelligence Development Studio, SSMS

Mednax Inc., Sunrise, FL

April 2006 -April 2007

Client is a national medical group that comprises the nation's leading

provider of neonatal, maternal-fetal and pediatric physician subspecialty

services as well as anesthesia services. I worked on and managed their main

in-patient databases, and assisted in development of BI layers for disease

analysis.

SQL SERVER - Production & Application Support

. Developed and designed SSIS packages using SQL Server Integration

Services for loading data into SQL Server tables.

. Transformed stored procedures into a SSIS package using relevant

transformations like Dataflow Task, Execute SQL Task, For Each Loop

Container.

. Used Log Providers to keep track of the Log History.

. Using XML Configurations to make dynamic changes to packages.

. Deployed the SSIS Packages to the MSDB as well as File System

depending on the requirements

. Automation of Packages using SQL server jobs.

. Designed, implemented, and administrated databases in SQL Server 2000.

. Maintained databases, configured permissions, and conducted backup and

recovery.

. Developed stored procedures, advanced queries, trigger, views, and

indexes by using T-SQL.

. Performed daily administration, monitoring, and documentation of SQL

Servers.

. Automated and enhanced daily administrative tasks, including space

management, backup & recovery and performance monitoring.

. Used SQL Profiler and Performance Monitor for troubleshooting,

monitoring, tuning of SQL Server and SQL code. .

. Generated analysis reports using SSRS.

. Created Entity Relationship Diagrams (ERD) to successfully design a

flexible database. Maintaining online documentations for entire source

code

. Created Analysis reports in Crystal Reports in 7.0.

. Wrote application in VB 6.0

. Performed scheduled data uploads to database using nested queries and

joins.

. Scheduled and managed jobs for data transfer using DTS packages.

Environment: MS SQL 7.0/2000 Server, MS Windows Server 2000 Enterprise

Edition, Query Analyzer, SQL Profiler, SSEM, Crystal Reports 7.0, VB 6.0,

Wipro, Hyderabad, India December 2004 -

March 2006

Worked as a member of corporate data group supported MS SQL, Oracle and DB2

databases for global clients, including data modeling, performance and

security. Also involved in reporting applications.

Senior Software Engineer

. Designed, implemented, and administrated databases in SQL Server 2000.

. Involved in database design (Logical and Physical).

. Developed stored procedures, advanced queries, trigger, views, and

indexes by using T-SQL in MS SQL 2000 and Oracle 8i.

. Performed daily administration, monitoring, and documentation of SQL

Servers.

. Automated and enhanced daily administrative tasks, including space

management, backup & recovery and performance monitoring.

. Installed, maintained and upgraded application software tools, on

servers and client computers.

. Wrote code and creating jobs to automate repetitive tasks.

. Performed Application implementation on Client site.

. Did Visual Basic Programming and Report Designing in Crystal Reports

7.0

. Handled End user Training and software maintenance.

Environment: MS SQL 7.0/2000 Servers, Windows 2000/NT servers, Crystal

Reports 7.0, Visual Basic 6.0.

InfoSystem Pvt. Ltd, Coimbatore, India August

2003 - November 2004

Worked with data modeling, database development and support of several SME

client database applications.

Software Engineer

. Developed stored procedures, advanced queries, trigger, views, and

indexes by using T-SQL in MS SQL 7.0.

. Writing code and creating jobs to automate repetitive tasks.

. Designed and Developed applications in VB 6.0 and FoxPro 2.6

. Involved in User Interaction, Requirement Analysis.

. Involved in Visual Basic Programming and Report Designing in Crystal

Reports 7.0

. Performed daily administration, monitoring, and documentation of SQL

Servers.

Environment: MS SQL 7.0, Crystal Reports 7.0, VB 6.0, FoxPro 2.6

Contact this candidate