Viji Karthika.S

Contact: 759-***-****

Email: adijcm@r.postjobfree.com

CAREER OBJECTIVE:

To work in a globally competitive environment on challenging assignments that will help me to explore myself and to fully realize my potential which will yield a steady paced professional growth.

EXPERIENCE SUMMARY

Over all 3+ Years of Professional IT Experience in Software Analysis, Design and Development.

Having good Working Experience in MS SQL Developer, Ramco Decision Works (Reporting Tool) SQL Server Reporting Services (SSRS).

Excellent problem solving skills with an ability to identify problems and implement connective solutions.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Effective experience in Writing Stored procedures, View, Trigger and SQL complex queries, subqueries and joins.

Coordinated with the front end design team to provide them with the necessary stored procedures and the necessary insight into the data.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Identify columns for Primary Keys in all the tables at the design time and create them.

Create stored procedures to process staging database as per the client requirement

Create functions to provide custom functionality as per the requirements.

Created indexes on the tables for faster retrieval of the data to enhance database performance

TECHNICAL SKILLS

Database : SQL Server 2012, SQL Server 2008

BI Tools : SSRS

MS Office Tools : Excel, Word, PowerPoint

EMPLOYEMENT SUMMARY (Current)

Employer : Mindtree Limited

Designation : Software Engineer

Duration : Sep 2019 To Till

Total Experience : 1 Year

Technical Stream : SQL Server 2008/ 2012, SSRS

PROJECT:

1.Reporting Uplift [September 2019 – Till]

EMPLOYEMENT SUMMARY (Previous)

Employer : Ramco Systems

Designation : Programmer

Duration : July 2017 To Aug 2019

Total Experience : 2 Year 1 Month

Technical Stream : SQL Server 2008/ 2012

PROJECTS:

1.DB Schenker – New Zealand [August 2017 – November 2017]

2.Panasonic – Malaysia [November 2017 - June 2018]

3.KLK – Malaysia [July 2018 – August 2019]

RESPONSIBILITIES

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Requirement gathering from the Business Team and analysis the Requirement.

Technical support for various modules in HCM Modules (Leave Management, Workflow Management, Reimbursement, etc).

Prepared test cases as per the functionality of the

Support the onsite team

Prepared the technical document

Worked as per the requirement Raised from the end user.

Analyze the Existing code and do the impact analysis.

Created Database Objects like tables, Views, Stored Procedures, functions, Packages and Triggers as per the Business requirements.

Involved in modifying various existing Procedures, functions, triggers according to the new business needs.

Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.

Validated execution time and plan for each and every SQL Queries and optimized the Query to improve the Performance

Test the result of the procedures with excel sheet sent by the client and fix the defects if any.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Creating reports using SSRS for visualizing the data

EDUCATIONAL QUALIFICATION:

Course

Institution

University/Board of examination

Year

Percentage / CGPA

BE – CSE

SCAD Engineering College - Tirunelveli

Anna university, Chennai

2017

72.1%

Diploma

Sankar Polytechnic College - Tirunelveli

State board

2014

82.6%

SSLC

Govt Girls Hr Sec School - Tirunelveli

State board

2011

90.1%

PERSONAL PROFILE:

Name : Viji Karthika S

Father's Name : Sekar E

Mother's Name : Sivagami. S

Address : 6, Vallakottai Murugan St, Keelkattalai, Chennai – 600117.

Date of Birth : 13-05-1996

Nationality : Indian

Languages Known: Tamil, English.

Hobbies : Reading Newspaper, Listening Music.

DECLARATION

I hereby declare that the above information's are true to best of my knowledge.

PLACE: Chennai SIGNATURE

DATE: (Viji Karthika S)

Contact this candidate