SARAVANAN M

ab5595@r.postjobfree.com

962-***-****

Summary

. Around 2 year of experience in Data warehousing Solutions

. Have good understanding on Data warehousing concepts and Data

integration

. Good exposure in Implementing Projects using SQL Server Integration

Services

SQL Server Reporting Services

. Good Knowledge in SQL Server 2005,SQL Server 2008R2,PL\SQL,ORACLE 10g

. Good Client Interaction skills

. Ability to absorb new technologies quickly with high degree of

adaptation

. Excellent interpersonal, Organizational and communicational skills

PROFESSIONAL CERTIFICATIONS

. Certified Oracle Database SQL Expert,2013

Professional Experience

Support Engineer (Jan 2012 - August 2013)

Iterate India Pvt Ltd, Noida

Client Company : General Motors of India, Chennai

Skill Sets

Area Skills

BI tools MSBI, Reporting Tools(SSRS), Crystal Report

Database MS SQL Server 2008R2,

ETL Tools MS SQL Server Integration Services(SSIS)

Language SQL, PL\SQL, Oracle10g,C,C++, PL\SQL

Education

Examination School/College Board/University Year of Percentage

Passing

B.E (CSE) Maharaja Anna University, May-2010 70%

Prithvi Engg.,

College, Chennai

Coimbatore.

Examination School/College Board/University Year of Percentage

Passing

12th Vivekananda State Board March-2006 80.5%

Vidyalaya

Matric Hr Sec

school,

Tiruppur

10th Vivekananda Matriculation April-2004 76%

Vidyalaya

Matric Hr Sec

school,

Tiruppur

Professional Experience

Autoservewidms - Project - 1

ETL - QA Developer

Jan 2012- August 2013

General Motors India Private Limited is an American multinational automotive

corporation headquartered in Detroit, Michigan, and among the world's largest

automakers by vehicle unit sales. In India, it independently owned dealers to

sell, service and market vehicles that it produces. Chevrolet is among the more

recent auto brands, GMI managed the Chevrolet dealership network from its

headquarters in Gurgaon, and regional zone offices in Mumbai, Kolkata and

Chennai. GMIPL currently has 250 dealerships in 178 cities across India.

All the Chevrolet dealers of general motors using this software and our work is

to give them support online and by visiting the dealership. The objective was to

build a Data Mart, develop the Mappings, Packages in SSIS and to test whether

the data set in the Data Warehouse matches with the data set in the stage

database and source data set matches with the data set in the stage database by

writing relevant SQL Queries. The Mappings, Packages were also tested for their

functionality, performance and naming convention as per the requirement.

Roles:

Analyzing the problems that occurs while using applications.

Installation of application (AutoServeWIDMS) and training at all the dealers of

South zone.

Co-ordinating technical reviews, inspections, verification and validation

monitoring for ongoing projects.

To handle all the queries and problems of customer regarding software

technically.

Writing, reviewing & executing different test cases as well as tracking their

respective defects.

Forwarding defects into the Developer database.

Analyzed the data and identified the business process.

Help in Data Modeling (Logical and Physical Design of Databases), Normalization

and building Referential Integrity Constraints.

With backend skills in creating SQL objects like Tables, Stored Procedures,

Views, Indexes, Triggers, and functions.

Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands

Has good Experience in SQL Server Replication

Experience in Database backup and disaster recovery procedures.

Has very good experience in data analysis, database design, data mapping

and conversion and data load and also Fetch Report From the Query

Done Data Migration with our migration tool data migration from MS

SQL/Access/Excel Sheets to SQL Server 2005/2000/2008 R2

Helped the database developers on technical issues.

Project Environment: Microsoft SQL Server 2008 R2, SQL Server Integration

Services 2008 R2

PERSONAL DETAILS:

Father's Name : M.Murugesan

Date Of Birth : 26-05-1989

Marital Status : Single

Gender : Male

Permanent Address : S/o M.Murugesan,

98, Gurunatha Gounder Street,

Tiruppur-641604.

Contact Address : 5,Vaikunth Apartments,

VGP Avenue, Dr. Seethapathy Nagar,

Velachery,

Chennai - 600042

Passport No. : H7177417

Mobile No : 962-***-****

Email : ab5595@r.postjobfree.com

Contact this candidate