Project Sql Developer

RESUME

Jayant H Yadav

Rajiv nager jan,

Sewa society mulund,

Link road goregaon (E),

Mumbai 400063.

Email ID : acn4vl@r.postjobfree.com

Contact No : +91-982*******

_

Objective

To work and grow in a professionally driven enterprise where I can use all

my ability, intelligence and creativity to prove myself worthy and enhance

my knowledge, experience and skills to achieve such a position that offers

recognition, challenges and opportunities in a competitive environment.

Synopsis

. Currently working as SQL developer with Parekh Integrated Services

Pvt. Ltd.

. 2 Yr Experience on SQL server.

Extensive knowledge in Tuning SQL queries and improving the query

performance.

Experienced in Database Schema Design, and Table Design.

Experienced in Using multiple join statements to retrieve data from

multiple tables.

Maintain positive communications and working relationships at all business

levels.

Capable of working independently, manage small engagements, multi-tasking

and also a good team player.

. Ability to work in a team, withstand pressures.

. Interact with client and solve there problems.

.

Qualification

Course University Percentage Year of Passing

BSC(IT) SEM VI Mumbai University 66.37% APRIL 2012

BSC(IT) SEM V Mumbai University 57.46% NOVEMBER 2011

BSC(IT) SEM IV Mumbai University 67.60% APRIL 2011

BSC(IT) SEM III Mumbai University 70.40% NOVEMBER 2010

BSC(IT) SEM II Mumbai University 63.33% APRIL 2010

BSC(IT) SEM I Mumbai University 66.13% OCTOBER 2009

HSC Mumbai University 64.82% 2008-2009

SSC Mumbai University 51% 2006-2007

Work Experience

Currently Working with Parekh Integrated Services Pvt Ltd. since July 2014.

Company : Softgainz Technologies Pvt. Ltd.

Designation : SQL Developer.

Duration : July 2015 - Till date.

Previous Company : Softgainz Technologies Pvt. Ltd. since

February 2013 to Aug 2014.

Designation : SQL Developer.

Duration : February 2013 to Aug 2014

Project Details

Organization : Parekh Integrated Services Pvt. Ltd.

Project : ERP Project

Team Member : 4

Role : SQL Developer.

Responsibilities :

I work here to designing Procedures, Triggers, functions and Tables for

creating Module and reports for different Operations and activities Using

SQL 2008 as backend and Baseone Metadata Platform for Front End .

Developing Report as per client requirment using Crystal Report and in

build Baseone Reporting tool

I also work on performance tuning of the database to enhance database

performance.

I also contribute in Database creation, investigation, updation and

database performance tuning in SQL 2008)

I am also involved in providing the support to the end user for any kind of

error or issue face while using any of the module.

Technologies 1) Baseone (Metadata Platform for Front End

desining) .

2) Sql Server 2008 (Back end)

Crystal Report (Reporting Toll)

Organization : Softgainz Technologies Pvt. Ltd.

Client : Focus USA. NJ, USA.

Project : DataWarehousing Project

Description : The Project is mainly about providing a target audience from

the whole population with the company's product, and satisfying the

criteria and strategies of the company. These records are than provided to

clients, which is than deliver to respective customers, and also direct

mailing to the prospect target audience to the clients.

Team Member : 5

Role : SQL Developer.

Responsibilities :

Set up entire database as per client business rule.

Perform and execute data extraction, transformation and loading using ETL

tools. (DMExpress).

Creating and Debugging SQL Scripts.

Files Imports/Exports/Updates using BCP, Bulk Insert and DTS (Fixed

Length, Tab delimited, comma delimited formats,

etc.)

Normalize the database.

Analyzing Data as per client requirement

Creating / Altering Functions and Stored Procedure.

Work on Production server support

Design and develop T-SQL procedures, query performance tunings

Take Backup of db

Design, develop and implement complete life cycle of data warehouses.

Translate business requirements

Tools : 1) Melissa Data (Client licensed software used for

address correction)

2) Accuzip:- NCOA (Client licensed

Tool use for National Change of Address)

DMExpress (ETL Tool).

Software / Hardware - Skills

Operating Systems : Microsoft Windows XP, Windows 7, Windows

2000, Linux.

Languages : C,C++, C#,ASP.NET,XML

Databases : MS SQL Server 2000/2005/2008.

Web Technologies : HTML,CSS.

Other Information

Done GNIIT(Software Engineer)

Personal Details

Date of Birth : 14th Aug 1991

Father's Name : Mr. Harikesh Yadav

Permanent Address : Rajiv nager jan sewa society muliund link road

Goregaon(east), Mumbai 400063.

Nationality : Indian.

Sex : Male.

Marital Status : Unmarried.

Language Known : English,Marathi,Hindi,.

Contact this candidate