Data Sql Server

P.Vijayaraj

**/** * ********** **** *th street

Tiruvannamalai-606601

Cell Phone: 875-***-****

Email: addi32@r.postjobfree.com

CAREER OBJECTIVE

To be part of an innovative company that provides a challenging, competitive environment and utilize my skills & abilities to add value to the organization and apply the knowledge thus acquired, with an eye on quality.

PROFESSIONAL SUMMARY

Having Experience in dbforge studio for mysql.

Having Experience in Microsoft sql server management studio.

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

Experience in MongoDB to SQL migration.

Experience in Talend Open Studio for Big Data.

Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, MS SQL Server by using SSIS.

Have been into all phases of project life cycle - Analysis, Design, Development, Testing and Implementation.

Domain knowledge in Banking, Financial services, and Insurance (BFSI) sector and Sports.

Hands on experience in both Development and Maintenance projects.

CERTIFICATION

I have Completed Microsoft certification Exam in 70-462 Administering Microsoft sql server 2012/14 (Microsoft certification for sql DBA)

TECHNICAL PROFICIENCY

Query language : T-SQL, No SQL

Architecture : Relational DBMS

Database : Microsoft sql server management studio, dbforge studio for mysql, Mongo DB - Studio 3T

ETL Tools : SSIS (SQL Server Integration Services),Talend open studio for big data.

BI Tool : Tableau

EDUCATIONAL QUALIFICATION

DEGREE/ CLASS

SCHOOL/ COLLEGE

UNIVERSITY/ BOARD

YEAR OF PASSING

PERCENTAGE/CGPA

Undergraduate

B.E MECHANICAL

Rajalakshmi Engineering College, Thandalam.

Anna University, Chennai

2012-2016

7.75(cgpa)

CLASS 10

Krishna Vidhya Mandhir Matriculation school, Tiruvannamalai.

Matriculation

2010

82.80

CLASS 12

Kurinji Matric Hr.secondary school, Nammakal.

TamilNadu - State Board

2012

88.83

Experience Summary

Sportsmechanics india (p) Ltd

Projects Name : Reliance Foundation Youth Sports, (BCCI), TNCA, KSCA.

Duration : August 2019 to till Date

Client : Reliance, Board of control for cricket in India, TNCA, KSCA.

RESPONSIBILITIES

Involved in Extracting reports as per the Client needs on Daily Basis.

Processing cricket Data in Website.

Involved in Development activities and Enhancement works.

Worked in stored Procedures, Functions, Linked servers and Index.

Involved in Data fixes for the Live application.

Worked in SSIS packages for Data processing.

Worked in Complex queries.

Tata Consultancy Services Ltd

Project Name : Now Pensions

Duration : January 2017 to August 2019

Client : Now Pension Ltd. BFSI UK 2.0

NOW: Pensions is a trust-based defined contribution workplace pension fund for non-associated employers.

RESPONSIBILITIES

Involved in maintaining the Data integrity.

Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target for Mongo to SQL Migration.

Involved in the sequence of methods for migration are Data Mapping, Data Extraction, Data cleansing, Data Transformation, Reconciliation

Involved in automation of the process which consumes more time using SSIS, SSMS JOBS.

Involved in Data fixes for the application bugs.

Coordinating with Development and testing team for proper Database optimization.

Worked in stored Procedures, Functions and Index.

DECLARATION

I declare that the information and facts stated herein above are true and correct to the best of my knowledge and belief.

DATE: Yours Truly,

P.vijayaraj

Contact this candidate