Godwin V

acf5f9@r.postjobfree.com

201-***-****

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