Sql Server Data
Resume:
Godwin V
***********@*****.***
Professional Summary
. Over 7+ years of Information Technology Experience in requirement
analysis, design, development, testing of client/server, web and n-
tier architecture applications.
. 6+ years of experience with Object Oriented Programming (OOP) concepts
like Abstraction, Encapsulation, Polymorphism and Inheritance.
. Expertise on RDBMS concepts as well as Data Modeling Concepts.
. Extensive experience in implementing High availability solutions like
different Replication models (Snapshot and Transactional), Log
shipping, clustering and mirroring on physical and virtual machines.
. Extensively worked on Active-Active and Active-Passive Clustering.
. Strong in standard Software Development Life Cycle (SDLC) and software
development methodologies.
. Experienced in different phases of Software Development Life Cycle
(SDLC) including Strategic Systems Planning, Designing, Object
Oriented Programming (OOP) concepts, Programming, Testing,
Documentation, and Presentation to clients and preparing customer
specifications as part of software technical requirements and Customer
support.
. Having good experience of Microsoft SQL Server 2008, Microsoft SQL
Server Reporting Services (SSRS), SQL Server Integration Services
(SSIS) using Business Intelligence Development Studio (BIDS) and
Crystal Reports 7.0/8.0.
. Good at SQL Server 2008 new features like Policy Based Management,
Data Compression, Resource Governor, Performance Data Collector and
Transparent Data Encryption (TDE).
. Experience in Data Modeling, Normalization, and Building Referential
Integrity Constraints.
. Developed complex Stored Procedures, Triggers, Views, Functions,
Indexes, Normalization, Data types using MS SQL Server 2000, 2005 &
2008.
. Experience in analyzing Locks, Dead Locks and Handling the Isolation
Level and Concurrency Effects.
. Experience in Query Optimization and Performance Tuning.
. Experience in Data Base backup and disaster recovery procedure.
. Experience in Replication - Snapshot, Merge and Transactional.
. Has very good experience in complete ETL cycle including data
analysis, database design, data mapping and conversion and data load.
. Worked in OLTP & OLAP environment that includes Production (24x7), QA
and development databases in SQL Server.
. Experience in Dimensional Modeling, ER Modeling, Star Schema /
Snowflake Schema, FACT, Dimensional tables and Operational Data Store
(ODS).
. Handled multiple SQL Instances on Cluster environment for Server
Consolidation projects built on SAN using RAID levels.
. Strong Business and Application analysis skills with excellent
communication & professional skills.
. A self -motivated Individual with exemplary analytical and problem
solving skills.
Technical Skills
SQL Server Tools SQL Server Management Studio, SQL Server Business
Intelligence Development Studio
Languages C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++,
CSS, DHTML, Java Script
Operating Systems Windows, UNIX (Sun Solar), LINUX
Databases MS-SQL Server 2012, 2008R2/2005/2000
ETL Tools Data Transformation Services(DTS), SQL Server
Integration Services (SSIS)
Scripting Shell Scripting
Reporting Tools SSRS, SSIS
DB Utilities SQL Server Management Utility, Query Analyzer
Application Visual Studio 2005/2008/2010, Visual Source Safe, TFS,
Software MS Office Suite
Data Modeling Tools Erwin, Red gate, Lite Speed, Embarcadero
Professional Experience
Techie Index Inc., Alexandria, VA
May 13 - August 14
MS SQL Server DBA/ETL developer
Description: Techie Index is the largest knowledge resource on Information
Technology. The portal is a knowledge resource on all leading tools and
technologies from within the IT world and contains a host of sections that
aim at providing the global developer community a one source stop for all
information within the IT domain.
Responsibilities:
. Installation and Maintenance of SQL Server 2008 R2 on Test,
Development and Production Environments.
. Usage of new compression Techniques in SQL Server 2008 R2 for backup
and restore jobs.
. Implemented Database Mirroring and Transactional Replication as a part
of DR plan.
. Disaster Recovery Planning, Testing and Analyzing, continuous update
of documentation.
. Creating Logins and Roles with appropriate permissions.
. Creating and Maintaining Database Maintenance Plans.
. Modify Stored Procedures and complex T-SQL Queries to improve query
execution process.
. Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
. Tune slow running queries using SQL Server Profiler.
. Import data across multiple instances using BULK INSERT and BCP
Utility.
. Extract, Transform, and Load data from heterogeneous data sources to
SQL Server using SQL Server Integration Services (SSIS) Packages.
. Create and manage database objects that include Tables, Views, User-
defined Functions, Stored Procedures, Constraints and Triggers to
implement Business Logic.
. Create Clustered and Non-Clustered Indexes to improve the performance
of database access.
. Create and manage databases across Development and Production
instances using SQL Server Management Studio.
. Involved in Capacity Planning, Database Normalization and De-
normalization process.
. Involved in Logical and Physical Data Modeling process using MS Visio.
. Use MS Visual Source Safe as a Version Control System.
. Involved in Change Data Capture process.
. Monitoring Event Viewer, SQL Error logs and Log File Viewer for
Software and hardware related errors.
Environment : Microsoft Windows 2008 Server, Microsoft SQL Server
2012,Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL
Server 2000, Windows 2007 Server, Windows 2003 Server .
Grainger, Chicago, IL
Nov 12 - Apr 13
MS SQL Server DBA/ Analyst Programmer
Description: Worked on the project NSFOD (Nonsufficient Funds Overdraft)
used for bankers/managers who can help customers if they have any overdrawn
in account.
Responsibilities:
. Upgrading SQL Server 2000 to SQL Server 2005.
. Developing stored procedures, triggers, views and adding/changing
tables for data load and transformation, and data extraction.
. Working on Client/Server tools like SQL Server Enterprise Manager and
Query Analyzer to Administer SQL Server.
. Configuring, tuning, and optimizing SQL 2005.
. Performance testing on stored procedures, indexes, and triggers.
. Creating DTS Packages for data import, export, scrubbing and scheduled
jobs for backups.
. Data migration using bulk copy program and DTS.
. Helping the front-end application developers with their queries.
. Job Monitoring and making sure all jobs run successfully every night.
. Performing low-level scripting, fixing of codes and software
enhancement process.
. Administrator tasks like managing users, roles, and profiles
. Performed Database backups with tools like lite speed.
. Used SSRS to generate all daily, weekly, monthly and quarterly Reports
including current status.
. Development of various reports and reporting interfaces utilizing
Microsoft SQL Reporting Services.
. Suggest Replication techniques to meet business needs.
. Setting MAX DOP (Max degree of parallelism) to 8 for 28 GB memory.
. Scheduled and monitored all maintenance activities including database
consistency check and index fragmentation.
. Analyzed execution plans, and tuned queries and databases for better
optimal performance.
. Fixing Missing Indexes and Excess indexes
. Generated script files when changes applied to stored procedures and
functions.
. Managed schema objects like Triggers, cursors, indexes, procedures.
Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server
2003, IIS 6.0, T-SQL, Microsoft Reporting Service.
Health Management Systems, Atlanta, GA
May 10 - Sept 12
MS SQL Server DBA/Analyst Programmer
Description: Worked on the project Meaningful use, it is set of standards
defined by centers for Medicare and Medicaid services (CMS) incentive
programs that govern the use of electronic health records and allows
eligible providers and hospitals to earn incentive payments by meeting
specific criteria.
Responsibilities:
. Responsible for configuration of Microsoft Server/Client Products and
implementation.
. Created Database and Database Objects like Tables, Stored Procedures,
Views, Triggers, Rules, Defaults, user defined data types and
functions.
. Defined relationship between tables and enforced the referential
integrity constraints. Created Clustered and Non-Clustered Indexes.
. Responsible for General Database Administration and Performance
tuning.
. Experienced in resolving deadlock and blocking issues for concurrent
users
. Worked with DTS packages to load the massaged data into Data
warehousing system.
. Data Migration from legacy to master tables using DTS-Import and
Export wizard.
. Performance tuning of HMS e apps ERP on SQL Server 7.0 and 2000.
. Developed Database Backup Scripts and automated this process
. Used MS Visual Source Safe 6.0 as a Version Control System.
. Partly Participated in system study and analysis of software
applications.
. Experienced in support, applications and software development
Environment: MS SQL Server 2000/7.0, T-SQL, DTS, Visual Basic 6.0, Visual
Source Safe 6.0, Windows 2003 Server, Compuware QA Load test and HMS report
Writer.
First National Bank, Omaha, NE
Apr 09 - Apr 10
MS SQL Server DBA/Analyst Programmer
Description: First National Bank collections package is a complete web
based, flexible, scalable, parameter driven, configurable and user friendly
browser based application used for keeping track of customers, return
checks and payment against the checks. Application is automated to handle
multiple branches at a time. Daily reports or reports for specified time
duration were developed for management review.
Responsibilities:
. Worked on Agile Methodology (Scrum) to meet timelines with quality
deliverables
. Involved in gathering and preparing the requirements from clients for
product design and enhancements.
. Communicated with client for daily updates, reviews and demos.
Involved in user training programs.
. Managed 17 databases at the headquarters running on 10 servers
. Database version control using VSS.
. Developed SQL scripts for maintaining administration tasks.
. Created DTS packages to maintain central repository. Extensively used
different SQL2005 DTS tasks.
. Backup and Recovery plans Involved in installation and configuration
of SQL server 2005.
. Applied patches and service packs to keep the database at current
patch level.
. Responsible for configuration of Microsoft Server/Client Products and
implementation.
. Created Database and Database Objects like Tables, Stored Procedures,
Views, Triggers, Rules, Defaults, user defined data types and
functions.
. Involved in Analysis and Design Documentation, User requirements and
maintained good documentation.
. Designed and implement database logical and physical Schemas using
Erwin 3.5.2./4.0
. Supported production and development databases.
. Implemented SQL standards in writing stored procedures, Triggers,
Views, Sql functions and locking issues.
. Maintained 6000 tables, or Field office and Headquarters database
servers
. Maintained the field office database backups through SQL mail Scripts.
. Converted the legacy data from mainframes and dbase by using DTS
packages
. Interacting with the users and troubleshooting the problems involved
with the development of stored procedures.
. Created and maintained users and user groups
. Involved in Extraction transformation and loading of data using SSIS
to create packages
. Involved in user trainings and implementation.
. Implemented application variables for application level reports.
. Involved in creating, deploying and managing reports using SSRS.
Environment: MS SQL Server 2005/7.0, Microsoft VC++, T-SQL, DTS, Windows
2003 Server, Compuware QA Load test, SQL Server Integration Services 2008,
SQL Server Reporting Services 2008.
Humana Insurance Company (TCS), Bangalore, India
Dec 07 - Feb 09 SQL Developer
Description: Humana Insurance Company is one of the biggest companies that
provide insurance with dental and vision plans. It has also policies for
disabled, children, students etc. Humana Veterans project provides the
insurance policies, discounts to the veterans and their dependents.
Benefits are provided for the people who enroll with particular vision plan
Responsibilities:
. Involved in Analysis, designing and development of UI & ASP.Net pages
(Web Forms) after interacting with users for requirements.
. Used .NET AJAX controls to dynamically render the content on web pages
using C#.
. Used Team Foundation Server for the whole System which can be utilized
as a Reporting System, Source Control, and Data Collection.
. Designed web pages for Veterans project for enrollment process,
registration, login, collecting payment information, FAQ's.
. Excellent understanding of WPF, WCF services.
. Implemented Data access layer (DAL) using SQL server 2005 by creating
Functions, Triggers and Store Procedures in PL/SQL
. Used MVC design architecture and Validation controls to check the
validation of the controls that are used in this project.
. Developed User Control for Step plan individual process to add,
delete, and find number of dependents of a particular family member
and utilized this control as modal pop up.
. Utilized Web services to figure out the Step Plans in particular state
using Web services Studio tool.
. Created Unit test cases for the web pages to test the functionality
that has been created for the classes and was able to debug them.
. Used VM Ware Client to test the cross browser compatibility for the
projects.
. Utilized IIS Pro and Internet information systems for starting the
website and creating virtual directories.
. Implemented Agile Scrum methodology for the System and used Version
one tool for creating back log items and the duration of the issue
that needs to be resolved.
. Gathered user requirements by interacting with users and prepared
Software Requirements Specification (SRS) and other supporting
documents.
. Involved in deploying the project and testing it on the test servers.
Environment: : SQL server 2005, .Net Framework 3.0, Visual Studio 2005,
Version one, Secure FX, Web services, Agile scrum, Java Script, PL/SQL,
JQuery, CSS, VM Ware Client, Ajax Controls, ASP.Net MVC, IIS, IIS Pro,
TFS.
Dwise Solutions Pvt. Ltd., India
Nov 06 - Oct 07
SQL Developer
Description: Dwise solution private limited is the owner and service
provider of the one of India's largest Electronic Health Record software
including in North America. More than a decade years of experience in
Health and Medical software.
Responsibilities:
. Prepared architectural designs for the components that were assigned
for development.
. Designed and implemented various modules such as login module,
checkout module, search module and transaction module.
. Responsible for designing, developing and testing the Due Date Module
using ASP.NET, HTML, CSS, JavaScript and SQL Server 2005 as database.
. Vacation Services Module was designed developed and tested using
C#.NET, HTML, CSS, VBScript, JavaScript and SQL Server 2005 as
database.
. Product Report tool was designed and developed using ASP.NET, XHTML,
HTML, JavaScript and SQL Server 2005 as database.
. Most of the internal structure uses XML for generating input/output.
. Implemented the Session Management, Serialization, Single Sign-on,
Caching, Security, Cryptography etc. features using ASP.NET.
. Communicated with so many groups in order to integrate the new
enhancement into the regular flow.
. Reengineered the entire schema of the database and implemented new
schema.
. Designed and developed rich User interfaces using ASP.Net.
. Designed and developed web user controls in .NET using C#.
. Wrote complex JavaScript functions for the client side operation.
. Unit testing of all developed pages and modules.
Environment: SQL Server 2005, C#.Net, ASP.NET, Microsoft Visual Studio,
VB.Net, HTML, CSS, JavaScript, VBScript, XML, Microsoft Visual Source Safe.
Education:
. Bachelor Engineering in Computer Science from Anna University.
Contact this candidate