ANAND.G E-mail: adf8l7@r.postjobfree.com

Contact No: +91-967*******

Database Developer

Over 8 years and 8 months of experience in analysis the requirements, research the technical platform, design the structure, development the procedure and function, deploy the build and unit test of web applications and web service in SQL Server 2016,2014,2008 R2 by using Agile Technics and methodology.

Professional Experience

Database Developer at Ennore Cargo Container Terminal Pvt Ltd, Chennai.

(12-10-2011 to 31-10-2015)

Database Team Lead at Ennore Cargo Container Terminal Pvt Ltd, Chennai.

(01-11-2015 to 31-07-2020)

Professional Summary

Work with the database developer, software support and database development lead, to architect and implement new features and solutions for customers.

Respond to technical and non-technical queries from all areas of the business.

Implement complex business logic in SQL Server.

Work with development and IT teams to troubleshoot data or performance problems.

Collaborate with developers, project managers and business analysts in conceptualizing and developing new software applications and enhancements.

Review, discuss and work within agreed timescales and feedback to project managers any variances arising as tasks are performed.

Good and in-depth of understanding the project life cycle, deadline requirements. Software skills

Development Tool: SQL Server 2019, 2016, 2014, 2008 R2, Microsoft Visual Studio 2013.

Technical Knowledge: Stored Procedure, Functions, Trigger, Migration, Partition, Constraints, Views, Architecture design.

Script: Batch, shell.

Programming Languages: T- SQL, PL/SQL.

RDBMS: MS- SQL Server 2016, 2014, 2008 R2.

Reporting Tool: Crystal Report.

Academic Credentials

MCA., - JJ College of Arts and Science, Pudukkottai- (78.3%) 2011

B COM., (CA) - Sree Sevugan Annamalai College. Devakottai (64.5%)-2008 Project Experience

Freight Forwarding :

Technical Environment: SQL Server 2019, Data Migration SP, Function, XML & Scheduler. Organization : Genid Shipping & logistics Pvt Ltd. Modules : Sea Import, Air Import, Sea Export, Air Export. Role : Team Lead -Database Development.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database on requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

• Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

• Conducting code review and team meeting along with team recording development and delivery of projects.

Operation flow can be analyze, build and deploy without affect the BUSINNES flow in each stage of operation.

Sources Deployment and Maintenance of Code Quality. Centralized Documentation Cell :

Technical Environment: SQL Server 2016, Data Migration, SP, Function, XML & Replication, Scheduler.

Organization : Kerry Indev Logistics Pvt Ltd.

Modules : Sea Import, Air Import, Sea Export, Air Export & ICEGate Filing. Role : Team Lead -Database Development.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database on requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

• Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

• Conducting code review and team meeting along with team recording development and delivery of projects.

Sources Deployment and Maintenance of Code Quality. Warehouse Management :

Technical Environment: SQL Server 2008, Data Migration, SP, Function, Scheduler & XML. Organization : Renault Nissan Automotive India Private Limited. Modules : Cargo In & Out, Stock, Delivery & Cargo Locking. Role : Team Lead -Database Development.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database on requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

• Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

• Conducting code review and team meeting along with team recording development and delivery of projects.

Operation flow can be analyze, build and deploy without affect the BUSINNES flow in each stage of operation.

Sources Deployment and Maintenance of Code Quality. Empty Yard:

Technical Environment: SQL Server 2016, Data Migration, SP, Function, XML & Scheduler. Organization : Ennore Cargo Container Terminal Pvt Ltd. Modules : Empty Container In & Out, Loading Unloading Operation, Yard Management, Liner Codeco File updation & Liner Report. Role : Team Lead -Database Development.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database on requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

• Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

• Conducting code review and team meeting along with team recording development and delivery of projects.

Operation flow can be analyze, build and deploy without affect the BUSINNES flow in each stage of operation.

Sources Deployment and Maintenance of Code Quality. Finance :

Technical Environment: SQL Server 2008, Data Migration, SP, Function, Schedule & XML. Organization : Kerry Indev Logistics Pvt Ltd & Ennore Cargo Container Terminal Pvt Ltd. Modules : Sales, Purchase, Receipt, Payment, Journal Entry, Debit & Credit Note, Contra Entry, BRS & Finance Report.

Role : Database Developer.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database on requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

• Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

• Conducting code review and team meeting along with team recording development and delivery of projects.

Operation flow can be analyze, build and deploy without affect the BUSINNES flow in each stage of operation.

Sources Deployment and Maintenance of Code Quality. Enterprise Resource Planning [Container Management System] : Technical Environment: SQL Server 2008, Data Migration, SP, Function, Scheduler & XML. Organization : Kerry Indev Logistics Pvt Ltd & Ennore Cargo Container Terminal Pvt Ltd. Modules : Import-FCL, Import-LCL, Export, Bonding, Yard Management, Warehouse Management.

Role : Database Developer.

Responsibilities:

Analyzing the requirements and assigning tasks to team members.

Design the Database in all project based on the requests. (Table with index and constraints, Views of required columns, Functions in a Protocol Structure and Stored procedure).

Data Migrations done with Live Server Inter linked with LAN Linked Server.

Profiler to find the slow running query and Performance Tuning of Stored Procedure to execute the query faster in Procedure and Functions for Over All Applications

Conducting code review and team meeting along with team recording development and delivery of projects.

Personal Profile

Father’s Name : S. Gaspar

Date of Birth : 24-05-1987

Gender : Male

Marital Status : Married

Nationality : Indian

Address for communication : No: 104A, Saraswathi Nagar 3nd street, Adambakkam, Chennai – 600 088.

DECLARATION:

I do hereby declare that the above-furnished particulars are true to be the best of my knowledge and belief. I assure that if an opportunity is provided, I will devote myself with full involvement to the duties interested to me and discharge my duties to the entire satisfaction of superiors.

Place: Chennai.

Date: (ANAND.G)

Contact this candidate