Sql Server Developer

NANDAKUMAR L

Mobile: +91-996******* Email: *********@*****.**.**

PROFESSIONAL SUMMARY

8+ years of experience in Database Development of MS SQL Server 2008/2008R2/2012/2014/2016

9+ years of experience in IT and Non-IT field

Proficient in Relational Database Management Systems (RDBMS).

Microsoft certified technology Professional -SQL server 2012.

Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures, User defined functions.

Sybase to SQL Server Migration using SSMA(Sql Server Migration Assistant)

Experience in Basic SSIS (Integration Service) package design, constructing, and deployment.

Experience with Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

Supported team in resolving T-SQL related issues.

Analysis of Sql Server upgradation and implementation.

Performance tuning using SQL Profiler and Query optimization techniques.

Experience in monitoring SQL Server Performance using DMV’s and DMF’s

Highly proficient in the use of T-SQL for developing and debugging complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS

Database Utilities : SSMS

Data tools : SSIS, SSRS

Version Control : TFS

Operating Systems : Windows XP, Windows 7

MS office : 2003/2007/2010

CAREER PROGRESSION

Senior Database Developer –Cognizant technology Solutions Pvt. Ltd (July 2014 to till Date)

Sql Developer -Sulekha.com Media (P) Ltd, Chennai (Apr 2012 to July 2014)

Junior Database Developer, IC&SR IIT Madras, Chennai (May 2009 to Mar 2012)

Process trainee Engineer, Grasim Industries Ltd. Ariyalur (Feb 2007 to Aug 2007)

Project Associate at CCE IIT Madras, Chennai (Sep 2004 to Jan 2007

ACADEMIC QUALIFICATION

Master of Technology, Anna University, 2009 - 65.6 CGPA

Bachelor of Technology, Anna University, 2004 – 67.7 CGPA

Higher Secondary, Vana Vani Matriculation Hr. Sec School, 2000 – 83.4%

SSLC K V IIT Madras Chennai, 2000 – 63.4%

WORK EXPERIENCE IN DETAIL

1.Cognizant Technology Solution Pvt. Ltd- Chennai

Project Title #1 : Cambia Sybase Migration to SQL Server (Jan 2018-Till Date)

Environment : MS SQL Server 2014/2016, Windows 7, .net, Sybase, SSMA,T-SQL

Role : Senior Sql Developer (Team Member)

Responsibilities :

Requirement Gathering and Analysis.

Design documentation preparation

Migration DB objects from Sybase to SQL server using SSMA

Code refactoring of database objects such as stored procedures, Udf and triggers.

Unit Testing of Migrated DB objects.

Mentoring junior team members on the troubleshooting of stored procs, etc.

Deployed DB Changes in Production and other lower environments databases during various releases.

Project Title #2 : Aetna-Medicity (Jan 2015-Feb 2015)

Environment : MS SQL Server 2008 R2, Windows 7, SSRS

Role : Application Developer (Database)

Responsibilities :

Responsible for creating and modifications to SSSRS reports based on business requirements.

Performance tuning of SQL queries, Stored Procedures and User defined Functions used in SSRS reports

Deployment of SSRS report in Various environments using RSCM (Reporting Services Configuration Manager)

Design documentation preparation for all reports

Project Title #3 : Aetna-AHM Active Advice (Feb 2015-Dec 2017)

Environment : MS SQL Server 2008 R2, Windows 7, SSRS, SSIS, .net

Role : Application Developer (Database)

Responsibilities :

Developed stored procedures to implement business logic as required with optimization.

Troubleshooting the Stored procedures, Adhoc queries, script deployment exceptions whenever occurred.

Applied Agile method to better adapt to the business requirements changes; quickly designed and coded/implemented the following applications with scrum teams

Design documentation preparation of every implementation.

Performing SQL tuning, implemented Sql Server technologies such as partitioning, indexing, query rewriting etc.

Mentoring junior team members on the troubleshooting of stored procs, etc.

Extensive experience in validating SQL scripts, doing pre-deployment performance review and deploying the changes (CM) in the Production environment and post deployment analysis

Worked on developing DB admin related scripts, setting up administrator jobs like data purge, index rebuild, database consistency checks, and database data file shrink jobs.

Project Title #4 : Aetna-AHM Consumer Business (Oct 2015-Dec 2017)

Environment : MS SQL Server 2008 R2, Windows 7, SSRS, SSIS, .net

Role : Application Developer

Responsibilities :

Gather requirements from customer & analyze same and discuss with business user to get to know proper requirements, then make functional specifications.

Exposure to develop an application from scratch through analyzing requirements, documenting - designing, coding, debugging and testing.

Generated DDL scripts for new clients from existing database.

Data Configuration for more than 250+ tables via SSIS packages and DML scripts for Various Environments.

Evaluate existing database and recommend improvements.

Use of SQL profiler (SQL Server) for database performance monitoring

Involved in optimizing T-SQL code and improving efficiency in databases including indexing and Performance tuning T-SQL queries

Design documentation preparation for each and every implementation and features.

Code Refactoring of Databases objects such as stored procedures, user defined functions and triggers.

Sql Server Upgradation 2012 Analysis and lower environment implementation.

Project Title #5 : Comcast SE Apex Performance Implementation (July 2014-Dec 2014)

Environment : MS SQL Server 2008/2012, Windows 7, SSRS, .net

Role : Senior Sql Developer (Team Lead)

Responsibilities :

Performance tuning of SQL queries, Stored Procedures and User defined Functions

Database Installation, Creation, Backup and Recovery policies design and implementation

Involved in Data Migration Using Sql scripts.

Implementing Table Partition in many Large Tables to hence Query performance.

Design documentation preparation

Use of SQL profiler (SQL Server) for database performance monitoring

Database fine-tuning, Indexing modification, SQL query normalization

Upgraded SQL server databases from 2000/2005 to 2008R2/2012

Code refactoring of database objects such as Stored procedures, Udf and triggers

Mentoring junior team members on the troubleshooting of stored procs, etc.

Deployed DB Changes in Production and other lower environments databases during various releases.

2.Sql Server Developer: Sulekha.com New Media (P) Ltd- Chennai

Project Title #1 : Sulekha Property (April 2012 – July 2014)

Environment : MS SQL Server 2008, Windows 7, SSRS, .net

Role : Sql Developer

Responsibilities :

Created Database Objects - Tables, Stored Procedures, Views, Triggers, User Defined functions.

Implemented complex business requirement in backend using efficient stored procedures and flexible functions

Performance tuning of SQL queries and Stored procedures using execution plan, DMFs and DMV’s

Involved in data transformation from excel to Sql server using Import Wizard

Generated the Reports Weekly and Monthly basis as per the business Requirements.

Project Title #2 : Classifieds (April 2012 – July 2014)

Environment : MS SQL Server 2008, Windows 7, .net

Role : Sql Developer

Responsibilities :

Created database objects such as procedures, functions and triggers.

Implemented complex business requirement in backend using efficient stored procedures and flexible functions

Performance tuning of SQL queries and Stored procedures using execution plan, DMFs and DMV’s

Extraction of data from xml format.

Troubleshooting exceptions or issues related to database.

Project Title #3 : Sulekha used cars/bikes (Oct 2012 – Mar 2013)

Environment : MS SQL Server 2008, Windows 7, .net

Role : Sql Developer

Responsibilities :

Created Database Objects - Tables, Stored Procedures, Views, Triggers, User Defined functions.

Implemented complex business requirement in backend using efficient stored procedures and flexible functions

Performance tuning of SQL queries and Stored procedures using execution plan, DMFs and DMV’s

Extraction of data from xml formats.

Involved in data transformation from excel to Sql server using Import Wizard

Developed Adhoc Queries for the reports required for various teams.

3. Junior Database Developer-IC&SR, IIT Madras – Chennai

Project Title #1 : NPTEL Phase II & III (June 2009 – March 2012)

Client : MHRD

Environment : MS SQL Server 2005, Windows xp

Role : Database Developer

Responsibilities :

Created Database Objects such as Tables, Stored Procedures, Views, Triggers, Constraints, User Defined functions.

Analyzing the client requirements and implement the business logic

Interacted with application developers for database related issues.

Writing SQL queries involving joins, sub queries, aggregate fns

Project Title #2 : KJI (Kuruvilla Jacob Initiative) (June 2009 – March 2011)

Client : KJI & IIT Madras

Environment : MS SQL Server 2005, Windows xp, .net

Role : Database Developer

Responsibilities :

Created Database Objects such as Tables, Stored Procedures, Views, Triggers, Constraints, User Defined functions.

Interacted with application developers for database related issues.

Writing SQL queries involving joins, sub queries, aggregate fns

Optimize queries to improve response time and throughput

PERSONAL DETAILS

Father’s Name : LAKSHMANAN K

Mother’s Name : BANU L

Gender : Male

Marital Status : Married

Passport Number : Z3363155

Contact this candidate