sql server developer Resume

Title
sql server developer

Primary Skills
sql server 2000,2005

Location
India-Bangalore (will consider relocating)

Posted
Aug-15-09


Objective

A position in the IT industry with major responsibilities that will effectively utilize my Database skills.


Precis

? A dynamic professional with 4 years of experience in Database Development.

? Presently working as a Consultant (BAND 4B) at GENPACT INDIA(Formerly known as GE Capital International) Bangalore, Since May 2008.

? Well versed with SQL SERVER 2000 , SQL SERVER 2005, and SQL SERVER 2008.

? An energetic, self-motivated individual contributor with exposure in programming skills & requirements gathering.


Technology

Skill Proficiency Awareness

Databases SQL SERVER 2000
SQL SERVER 2005
SQL SERVER 2008
Teradata 12.0
Ms Access


Area of Expertise

? Database Design,Stored Procedure, Triggers, Functions.
? Index Concepts,Performance Tuning,Distributed Concepts,Blocking.
? Mail Configure, SSIS, DTS,Replications,Scheduling Jobs.

Career Profile

Dates Organization Role
Nov -- 2007 to May - 2008 Collabera (CMMi Level 5 ) (Formerly known as GCI Solutions), Bangalore. Database Engineer
May - 2007 to Nov - 2007 Ramco Systems Corporation(Behalf of Focus Infotech),Chennai. SQL SERVER Developer
May - 2006 to April - 2007 Effulgent Technologies [P] Ltd(Ramco ERP Implementation Partner), Chennai. Technical Programmer
July -- 2005 to May - 2006 Cking Consultancy Services, Chennai. Programmer




Qualification

MCA from E.G.S.Pillay Engineering College Nagapattinam, affiliated to Anna University in 2005 with 70%.


Certificates/Training Programs Attended/ Achievements
? Attended training program for Teradata 12.0 at NIIT, Bangalore afford by GENPACT.
? Received certificate for Data Classification from GENPACT.
? Received certificate for Data Privacy from GENPACT.
? Attended training program for GB(Six sigma) from GENPACT.
? Attended training program for “ERP on Demand” from Effulgent Technologies, Chennai.
? Completed “Crime Records Systems” academic project at Microsoft, Bangalore .


Projects Handled

Project Name #1: Customer Loyalty Insight Program (CLIP) Duration : May 2008 to Till Date
Company : GENPACT INDIA
Client Name : Genworth NPS(GE Group)

Description: The feature of Web-based CLIP Product is Calculation of Net Promoter Score on a business. Reporting the customer by launching the survey and gather data from various clients involved in their business.Survey Builder - This functionality relieve the customer to create a survey in dynamic manner, where customer can select the number of questionnaire and its response type. Respondents -- On “Sampling” user can add the response data from various sources like Excel, FTP and from Oracle Databases dynamically to include query condition from response and de-dupe (remove duplicate) the responses.Email Survey - On “launch of the survey” the functionality should prompt the user by periodic data pull time from FTP or Database, email launch time and email subject with remainder mail information.Data gathering -- Gathering the responses from the client on launched Questionnaires of the survey.Analysis & Reporting - This functionality should provide various reports (charts) and dashboard on the gathered data.

Responsibilities:

? Database Design.
? Index Design.
? Fix the issue on security issues and recommendation given by KPMG (Genpact Internal Security Team).
? Wipro Penetration (3rd party by client) testing team.J -meter loan testing, J -Profiler, J -unit Testing and Integration testing.
? Create Stored Procedures, Functions, Triggers.
? Backup and Restore Database.
? Creating Packages for Data Transformations.
? Bug Fixing (Modifying StoredProcedures, DTS package).
? Scripts Creation (Create, Drop, Insert, Update, Alter, Delete) .
? Running SQL Profiler.
? Performance Tuning (StoredProcedures).
? Craft Job.

Environment : SQL SERVER 2000, SQL SERVER 2005, Java 1.5.


Project Name #2 : Move.COM Duration : Nov 2007 To May 2008
Company : COLLABERA (CMMi Level 5)
Client Name : Move.COM , USA

Description: REALTOR.com® (RDC) is the world's largest real estate database of homes for sale and the official site of the National Association of REALTORS. RDC provides online information for various property listings and realtors. Users can search for Real Estate Listings, Realtors, Lenders and Neighborhoods of their choices and types with number of options. Registered users can save their Property Listings, Searches, Realtors, and Neighborhoods and can get periodically alerts. Users can also get information on Apartments and Rentals, Home Finance, Moving, Mortgage Rates and Home Buying Help.
The resource.realtor.com is a website provides marketing information, product fulfillment, feature enhancement and account management capabilities. The website integrated with other applications such as MLS Dashboard, Marketing, Control Panel etc. and accessible to the control panel (Agents/Office) and MLS users.

Responsibilities:

? Database Design.
? Craft Stored Procedures, Functions, Triggers.
? Creating Packages for Data Transformations.
? Bug Fixing (Modifying StoredProcedures, DTS package).
? Scripts Creation (Create, Drop, Insert, Update, Alter, Delete) .
? Running SQL Profiler.
? Performance Tuning (StoredProcedures).
? Index Design.

Environment : SQL SERVER 2000 & SQL SERVER 2005

Project Name #3 : Preferred Meal Systems Duration : May 2007 To Nov 2007
Company : RAMCO SYSTEMS
Client Name : PMS , USA

Description: PMS project has brought out the complete ERP (finance, SCM, process production) package. Rest PO cycle all remains the same. The purchase cycle is request for quotation->purchase quotation ->purchase order->supplier order based invoice-release payment->print check. In process production they deal with the production related activities. Like formula builder .Nutrition rollup -- it deals with nutritional values in the food item that they produce and supply to schools in US. Our nutrition rollup calculate the nutrition values for the given input so that they can adhere to standards.

Responsibilities:

? Creating Reports using Decision works Technology
? Developing Screens using RVW Technology
? Database Design.
? Craft Stored Procedures, Functions, Triggers.
? Creating Packages for Data Transformations.
? Bug Fixing (Modifying StoredProcedures, DTS package).
? Scripts Creation (Create, Drop, Insert, Update, Alter, Delete) .
? Running SQL Profiler.

Environment : SQL SERVER 2000, SQL SERVER 2005, HTML, Dreamweaver, Ramco Virtual Works

Project Name #4 : Ramco ERP Duration : Nov 2006 To Apr 2007
Company : EFFULGENT TECHNOLOGIES
Client Name : Midas Telecommunications Ltd., Chennai

Description: Midas Telecommunication Pvt. Ltd., a company with a clear focus on telecommunication, we are reimplement our ERP 3x (finance, SCM, process production) without excise module . A lot of customization in that project in purchase module.

Responsibilities :

? Create the Customization Screen
? Create Reports using Ramco Report Writer
? Develop the Stored Procedure's for Customization
? Master Data Uploading
? Technical Training


Environment : SQL SERVER 2000, SQL SERVER 2005, Ramco Virtual Works, Ramco Report Writer.


Project Name #5 : Ramco ERP Duration : May 2006 To Oct 2006
Company : EFFULGENT TECHNOLOGIES
Client Name : Real Image Media Technologies Pvt. Ltd, Chennai

Description: Real Image Media Technologies Pvt. Ltd., a company with a clear focus on digital entertainment technology in the film, video, audio and animation industries, has been at the forefront of many technology revolutions in India. We implemented complete ERP like Finance, Sales, Shipping, Purchase and Inventory other than productions.

Responsibilities:

? Create the Customization Screen
? Create Reports using Ramco Report Writer
? Develop the Stored Procedure's for Customization
? Master Data Uploading
? Technical Training

Environment : SQL SERVER 2000, SQL SERVER 2005, Ramco Virtual Works, Ramco Report Writer.

Project Name #6 : Retail Duration : July 2005 To May 2006
Company : CKING CONSULTANCY SERVICES
Client Name : SMS DEEN , Malaysia

Description: It's is a Powerful Jewelry Small ERP with fast, easy affordable software for retail and wholesales jewelers, using this retail will ensure the entire business operation. This retail will perform the operations like inventory, customer, vendor, invoice, barcode, books of accounts, reports, graphics, sms alerts.

Responsibilities:
? Involved in the Database Design.
? Writing Stored Procedures and Triggers.
? Validating the Screens.
? Creating Reports
? Mail Configurations

Environment : SQL SERVER 2000, SQL SERVER 2005, .NET TECHNOLOGIES.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Bangalore, India | Resumes in India

View other sql server developer resumes, Database Administrator resumes