RAJ KUMAR.R

Mobile No: +91 8050995271

Email id: [email protected]

 
Objective:

Capable to work in a challenging environment independently or as a TEAM, Take up initiatives, meet deadlines in a highly demanding environment and excel in my profession.

Professional Strength:

v  6 years’ experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2008 R2 in OLTP/OLAP/BI environment.

v
As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

v
Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.

v
Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2005/2008  using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

v
Experience in Database Backup, Recovery and Disaster Recovery procedures.

v
Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

v
Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Technical Skills:

v  RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000

v  Performance Tuning

v  Hands on experience in DBA Activities

v  Programming Languages: T-SQL, PL/SQL

v  Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, T-SQL, DBCC, Performance monitor

v  Operating Systems: Windows NT/ Windows Server 2003/Windows XP/ Windows 2007/      Windows 2008

Academic Strength:

v  Bachelor of Engineering in Computer Science and Engineering from S.K.P Engineering College, Thiruvannamali with first class [70.0%] in April 2010.

v  HSC passed in I class [70%] from Government Higher Secondary School, Perperiyankuppam in April 2006.

v  SSLC passed in I class [84%] from Government high school, Kudieruppu in April 2004.

Experience Summary:

v  Worked as Software Engineer at BTS, Chennai from May‘10-May‘11.

v  Worked for Ram co Systems as a client employee of Magna InfoTech PVT LTD with a designation of Programmer June 2011 to Nov 2012 and Worked for Ram co Systems, Chennai as Permanent employee with designation of Analyst Programmer from Dec 2012 to Aug 2014.

v  Working for Cenduit (India) Services PVT LTD, Bangalore, as Permanent employee with designation of Senior Software engineer from Sep 2014 till date.

Health Care Project:

We are doing clinical trials for the patients. The patient entered into the site the first visit has been captured by the patient screening. If the patient is eligible then they allowed for randomization.

Randomization means to assign the treatment group for the patients.

After the randomization the visit plan will be created. Then the patient will be allocated for each visit.

While randomize the patient we are supplying the materials for the patient based on treatment group. Material will supply from the depot to site using automated task that is resupply task. Once task reached in the site it will be confirmed by site shipment confirmation form.

Client Name     :  Novartis                                                     From 01 Jun 2015 To Till Date

Technologies    :  SQL Server 2008

Roles                 :  MS SQL Database Developer

Responsibilities:

v  Involved in gathering the user requirements.

v  Involved in physical and logical data modeling using Erwin along with the architects.

v  Created stored procedures, triggers, Joins, functions and views.

v   Created SQL server Reports using Crystal reports and SAP.

v  Identified the data source and defining them to build the data source views.

v   Debugging reports and deploying reports.

v  Scheduled the reports to run automatically.

v  Created schedules and subscriptions.

v  Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.

v  Creating Stored Procedures for reports generation.

v  Involved in database backup, recovery procedures

v  Planned back up strategy for disaster recovery

v  Responsible for log backups and restoration

v  Worked with Dynamic Management Views (DMV) for improving query performance.

v  Analyzed the existing application programs and tuned SQL queries using Execution plan,

v  Query Analyzer, SQL Profiler and database Engine tuning Advisor.

v  Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning
Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables

v  Designed and implemented stored procedures and triggers for automating tasks.

v  Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

v  Tested applications for performance, data integrity and validation issues.

Client Name     :  Novartis                                                     From 01 Jan 2015 To 30 May 2015

Technologies    :  SQL Server 2008

Roles                 :  MS SQL Database Developer

Responsibilities:

v  Involved in database development using stored procedures, triggers, views and cursors.

v  Involved in creating Indexes for faster retrieval of data.

v  Maintained data integrity by performing validation checks.

v  Involved in running the SQL Profiler for better execution Plans.

v  Scheduled automated jobs using SQL Server Agent.

v  Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of users.

v  Identified the database tables for defining the queries for the reports.

v  Assisted in migrating de-normalized report DB into a Star Schema design
Responsible for creating the reports basing on the requirements using SSRS2005.

v  Deployed the generated reports on to the server.

v  Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Client Name     :  CHI                                                From 01 Jan 2014 To 30 Jul 2014

Technologies    :  SQL Server 2008

Roles                 :  Performance Tunning

Responsibilities:

v  Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

v  Rebuilding / monitoring the indexes at regular intervals for better performance.

v  Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

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

v  Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

v  Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

v  Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

v  To analyze long running slow queries and tune the same to optimize application and system performance.

v  Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

v  Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.

v  Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

ERP Modules:

I have mainly involved Inventory setup and Procurement management, Scrap management, Line     maintenance, Repair order management in ERP cycles and then back end supported by MS SQL server.

My Role of the responsibility is building the stored procedures and Triggers. After development the unit testing completed by the developer and released to system testing.

The screen will be tested by the Functional people defect raised in DTS. The Developer should take and give the fix

Client: AMGH

AIR METHODS, AIR INDIA, GMR                                       From 01 Jun 2013 To 31 Dec 2013

Script Based Data Migration:

Roles                    :  MS SQL Database Developer

Responsibilities   :  Covered stored procedures, Trigger, Execution Script, Synonym, Index

In AMGH, the customer moved into old version to new version. This data size is

200 GB. We have done a big achievement of migrate a bulk volume of data one version to another version.  Here we have done performance tuning to migrate the huge volume of data in a short period.

Here we implemented three level databases to minimize the workload. We were split master tables and transaction tables separately and handled the migration.

For master and transaction table we prepared separate script to move another database.

Data migration through Excel:

Roles                   :  Database Developer

Responsibilities   :  Prepared excel template and script, data moved to SQL server through script

Customer keep all the data in excel for specific screens like Part master cycles, Sales setup, EO document, Part configuration.

So for migrating data I prepared one mapping template, master requirement template and scripts for each and every screen.

Client Name     :  Air India                                         From 01 Jan 2013 To 31 Aug 2013 date

Technologies     :  SQL Server 2008

Scrap Note (New component Development)

Description:

The Part is removed from the Aircraft it recorded in Inventory and forward to the Repair Shop. The repair Shop quoted the part repair cost .The repair cost is above BER Range the part scraped under the scrap management.

The Scrap note number is generated depends upon types of scrap note i.e. Regular and Miscellaneous. The Source component called from many integration services.

Major Achievements:

Create a new component Scrap in Base module.

Multiple Work Flow Activity Approval both in Part Level and Document Level

Quality Audit Management:

The Auditor has to prepare the document before visiting the Audit. They Prepare check list, and Schedule, and that schedule associate with Auditor.

Personal Profile:

Date of Birth                      :  05thJun 1988.

Nationality                                       :  Indian.

Languages Known                 : English, Tamil

Marital Status                       :  Single

Address                               :   582, North Street,

Athirikuppam,

Perperiyankuppam (post),

Panruti (T.K),

Cuddalore (D.t)

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Place: Bangalore.                                                                                       Yours sincerely

Date:                                                                                                          R. Rajkumar.