RESUME
DINESH KUMAR S
Mobile: +91-994*******
Email:adc63c@r.postjobfree.com
Career Objective:
To keep myself updated with the latest advents in the field of Information Technology through the work assigned to me and to make myself valuable to the organization I would be associated with. Profile Summary
Having 3.2 years experience in SQL Development using Ms-SQL Server 2012 &2015
Good experience in Bulk Insert Analyzing SQL Queries to improve the performance and Minimizing execution time
Good experience in database objects like tables, views, procedures for a project.
Good Experienced in writing SQL Queries, DML to implement the business logic and also created clustered and non-clustered indexes.
Having experience on creating Database and tables
Extensively Used joins, sub queries, and Worked in CTE, Global and temp table etc. Skills Summary
Operating Systems : Windows XP, 7 & 8.1
Languages : C, C++
Databases : MS-SQL server 2005 & 2012 (Workbench)
Reporting Tools : SQL server 2005 & 2012, Ramco ERP Reports : Crystal Reports
Other Tools : MS-EXCEL, MS-ACCESS
PROFESSIONAL EXPERIENCE:
Process Associate First Source Solutions Ltd (22-July -2016 to 31 st
-July-2017)
Chennai, Tamilnadu.
Analyst Hcl Technologies Services Ltd (12-Dec -2017 to 05-Aug-2019) Chennai, Tamilnadu.
Sql Developer Portmytech – (TVS Logistics Services Limited)
(06-Aug -2019 to Till Date) Chennai, Tamilnadu.
Project Details:
Project Name : Eapps
Software : C#.NET, SQL Server
ERP Tools : Ramco ERP
Client : TVS Logistics Services Limited
Project Description:
Eapps offers a complete portfolio of solutions including Transport and logistics, Finance module and HR Module. I was handled Finance module. This module includes Account Receivables (AR), Account Payable (AP) Reports, Direct Supplier Operations (DSO) Report, Management Information System (MIS) Support and GST Reports. In MIS Part we are dealing finance related process like company level operation, vertical level operations (sub divisions) based on sale contracts. MIS zone wise report based on Branch, Depot with Level of Business (LOB) and Cost center. In GST reports we are handled inward supplies and outward payments based on GST amount with states wise reports and GST reconciliation system as provided by customers. Functions are handled based on operation Units
Responsibilities:
• Requirement Analysis
• Developing Query and stored procedure.
• Plan, design, and implement application database code objects, such as stored procedures and views and T-SQL statements.
• Improving the process by identifying new automations and reduce cycle time of reports.
• Build and maintain indexes, and complex queries for data analysis and extraction.
• Involved in Trigger Mail generation from Database to business people Academic Performance:
B.E (EEE) with 62% from SSN College of Engineering, Chennai in May 2015.
HSC Passed with 59.4% in Sri Vani Matriculation School, Namakkal in April 2009.
Diplomo (ECE) with 91% in Muthayammal Polytechnic College, Rasipuram in April 2012.
Personal Details
Name : Dinesh Kumar S
Date of Birth : 05-May-1994
Gender : Male
Nationality : Indian
Languages Known : Tamil, English (Read,Write and Speak). Declaration
I hereby declare that, the above furnished information is true to the best of my knowledge and belief.
Date :
Place : Chennai (DINESH KUMAR S)