Sql Server Project

RESUME

Gokul Puvvada

Senior Technical Consultant

Contact no: (+65)84549954

E-mail ID: ************@*****.*** [pic]

Objective:

Looking forward for a good career breakthrough in a professionally driven

esteemed organization that utilizes my software expertise and skills and

where i can be a member of a dynamic group, consistently refining my skill

set and prove my mettle in realizing the organization's goals.

Professional Summary:

. 6.8 years of overall experience in IT including Microsoft .Net

Technologies.

. 3.6 years of work experience on Microsoft Dynamics - CRM.

. Experience in object oriented design and development.

. Experience in managing databases.

. Possession of excellent analytical and problem solving skills.

Skill Profile:

Microsoft Dynamics : MSCRM 3.0, MSCRM 4.0

Dot Net Technologies : ASP.Net, C#.Net, VB.Net, ADO.Net.

Reporting Tools : SQL Server Reporting Services, Crystal Reports

9.0.

Scripting Languages : Java script, HTML, XML.

Operating System : Windows Environment.

Database : MS SQL Server 2005, MS SQL Server 2000, My

SQL 5.0.

Source Control Tools : Microsoft Visual SourceSafe 6.0, Visual SVN

Server 1.0

Certifications:

1. MB2-631:Microsoft Dynamics CRM 4.0 Customization and Configuration

2. MB2-633:Microsoft Dynamics CRM 4.0 Installation and Deployment

Microsoft Certified Professional ID: 6587124

Academic Qualification:

Bachelor of Technology from Jawaharlal Nehru Technological University,

Hyderabad, AP, India in the year 2003.

Professional Experience: 6.8 Years

Organization: MN Computer Systems (S) Pte. Ltd, Singapore.

Designation: Senior Technical Consultant.

Duration: August 2010 - Till Date

Organization: Arvato Systems Singapore Pte Ltd, Singapore.

Designation: Technical Consultant.

Duration: February 2009 - June 2010

Organization: Semanticspace Technologies, Hyderabad.

Designation: Sr. Software Engineer.

Duration: April 2007 - January 2009

Organization: Weston Solutions, Hyderabad.

Designation: Software Engineer.

Duration: May 2006 - February 2007.

Organization: Indus Networks Ltd, Hyderabad.

Designation: Software Engineer.

Duration: January 2004 - May 2006.

Project Experience

Employer: MN Computer Systems (S) Pte. Ltd., Singapore.

1. Project : Helpdesk and Service Request System

Client : National Kidney Foundation, Singapore (www.nkfs.org).

The NKF is a charitable organization that provides dialysis treatment and

rehabilitative care to kidney failure patients at affordable and subsidized

rates. The project aims to automate, track and maintain the day to day

activities carried out by the users across different dialysis centers in

Singapore pertaining to the requests raised in the helpdesk and service

request systems.

Duration: Sep 2010 - Till Date

1 Environment:

MSCRM 4.0, MSCRM SDK, ASP.net 2005, SQL Server 2005, SSRS

Reports, Windows Server 2003

Responsibilities:

> Involved in the technical design of the Helpdesk and Service Request

modules.

> Involved in the customization of MSCRM including the entity

customizations, ISV and Sitemap customizations, development of client

side scripts, plugins etc meeting complex business requirements of the

modules.

> Involved in the development of SSRS reports.

Employer: Arvato Systems Singapore Pte. Ltd., Singapore.

1. Project : Service Management Asia Pacific (SMAP)

Client : Panasonic Asia Pacific Pte. Ltd., Singapore.

Panasonic is into the manufacturing of AVC Networks, Home Appliances, Semi-

Conductor Components & devices, Panahome electronic products for a wide

range of consumer, business, and industrial needs. The project aims to

improve the customer service with faster turnaround time for servicing and

the post sales service to its customers while ensuring a standard CRM

application across the entire Asia Pacific region that meet the servicing,

warranty, inventory and customer retention requirements. The CRM needed to

be flexible to meet all the various needs of the Panasonic in-country

processes as well as adherence to its business rules. The current system

SMAP was developed using Microsoft Dynamic CRM 4.0. SMAP is a multinational

implementation of Panasonic in Asia Pacific region.

The project covers the following aspects:

Online part sales

Inventory management

Service management

Warranty management

Technician scheduling

Business reports generation

Warranty claims management

Outsource / ASC Job management

Call center management

Redemption management

Duration: Feb 2009 - June 2010

2 Environment:

MSCRM 4.0, MSCRM SDK, ASP.net 2005, SQL Server 2005, SSRS

Reports, Windows Server 2003

Responsibilities:

> Involved in the technical design of the Redemption, Service

Maintenance Contracts and Warranty management modules.

> Involved in the customization of MSCRM including the development of

client side scripts, plugins, batch jobs and web services meeting

complex business requirements of the module.

Employer: Semanticspace Technologies, Hyderabad, India.

1. Project : MSCRM for Publications

Client : American Marketing & Publishing L.L.C, USA

MSCRM for Publications provides a powerful sales tool for the client in

publication sector. Aimed to build on top of the Microsoft CRM platform,

the software's functionality is deeply extended to provide the benefits of

a CRM solution to the Publication industry for maintaining the publication

sales orders information including the advertisements, listings, pointers,

order commissions and day to day user activities performed in the process.

Duration: Oct 2008 - Jan 2009

3 Environment:

MSCRM 4.0, SQL Server 2005, Windows Server 2003

Responsibilities:

> Involved in the analysis of the client's business process and

requirements.

> Involved in the customization of MSCRM.

2. Project : SSTLMSCRM up gradation from 3.0 to 4.0

Client : Semanticspace Technologies, Hyderabad, India

The project handles the up gradation process of the internal implementation

of Microsoft Dynamics - CRM from 3.0 to 4.0 version.

Duration: Aug 2008 - Sep 2008

4 Environment:

MSCRM 3.0, MSCRM 4.0, SQL Server 2000, SQL Server 2005, Windows

Server 2003

Responsibilities:

> Involved in the pre-analysis and up gradation of database and MSCRM.

3. Project : BIAMP

Client : BIAMP Systems, U.S.A.

BIAMP electronics is one of the leading international provider of

professional audio electronics having exposure in delivering, managing and

enhancing the sound areas like airports, arenas, theaters and many more.

The business areas covered for this project is the Service module and the

level of customizations include that of creating custom entities,

attributes, accessing data from My SQL database and developing custom pages

for lookups and SSRS(SQL Server Reporting Services) reports.

Duration: May 2008 - July 2008

5 Environment:

MSCRM 3.0, SQL Server 2005, Windows Server 2003, SQL Server

Reporting

Services

Responsibilities:

> Involved in the analysis of requirements including the fit gap

analysis.

> Customization of MSCRM entities

> Creating callouts and implementation of client script as a part of

customization.

> Developing reports using SQL Server Reporting Services

4. Project : Promopeddler

Client : Promopeddler Inc., U.S.A.

Promopeddler is a promotional products organization which is into dealing

with the promotion of products from different clients. The project involves

the customization of Microsoft Dynamics - CRM to the extent that custom

forms have been developed for quotes and orders management so as to

facilitate the complex custom calculation logic involved with the products

that the client handles.

Duration: Nov 2007 - April 2008

6 Environment:

MSCRM 3.0, SQL Server 2000, Windows Server 2003

Responsibilities:

> Involved in the analysis of the business requirements of the client.

> Involved in the development of custom quote and order forms

implementing the custom calculation logic depending on the client

requirements.

5. Project : NWA Data Migration

Client : Northwest Analytical Inc., U.S.A.

NWA(Northwest Analytical) is a leading provider of Statistical Analysis and

Statistical Control Process software used to manage and improve

manufacturing processes, improve quality and reduce costs. Semantic Data

Migrator tool has been used for data migration for different entities like

Accounts, Primary Contacts, Additional Contacts, Pending and History

Activities. GoldMine CRM Database has been successfully migrated to MSCRM

database through robust SQL queries and data inconsistency verification

techniques.

Duration: Aug 2007 - Nov 2007

7

8 Environment:

MSCRM 3.0, SQL Server 2000, Windows Server 2000, Semantic

CRM Data

Integrator.

Responsibilities:

> Involved in the analysis of client database schema and data.

> Involved in building of queries for migration and cleaning of data.

6. Project : SSTLMSCRM

Client : Semanticspace Technologies

SSTLMSCRM is an internal implementation of Microsoft Dynamics CRM for the

sales team working for the organization both in India and USA. The

project mainly focuses on the customization of the application so as to

enhance the business process and for effective tracking. Several

customizations have been carried out as part of the implementation

ranging from different entity customizations and developing reports for

effectively tracking the day to day user activities and sales revenue

generated in the organization.

Duration: May 2007 -July 2007

9 Environment:

MSCRM 4.0, SQL Server 2005, Windows 2003 Server

Responsibilities:

> Involved in the analysis of business process requirements and

implementing the same.

> Involved in developing reports using SQL Server Reporting Services.

Employer: Weston Solutions (I) Pvt. Ltd, Hyderabad, India.

1. Project : EHS Track

Client : Weston Solutions Inc, PA, U.S.A.

EHS Track (Environmental Health and Safety Tracking System) is an intranet

application developed for Weston Solutions. The project handles different

Environmental Health and Safety courses designed for Weston employees,

class scheduling, adding and removing students to a class, managing

instructors, generation of certificates etc.

Duration: May 2006 - Feb 2007

10 Environment:

ASP.Net with C#, SQL Server 2000, Crystal Reports 9.0, Visual

SourceSafe,

Windows XP.

Responsibilities:

> Involved in the functional and technical design of online

generation and printing of training certificates.

> Involved in development of class scheduling, adding personnel to

the system.

> Involved in generation of reports using Crystal Reports.

> Involved in writing and executing unit test cases.

Employer: Indus Networks Ltd, Hyderabad, India.

1. Project : Cajent HR Manager.

Client : The Cajent Group, Tx, U.S.A.

Cajent HR Manager is an Intranet-based Human Resource Management System,

which has been designed and developed to serve the needs of the Human

Resource department of the client. This package covers all the functional

aspects of a HR department viz., Recruitments, Employee registrations,

Designation allotment, salary fixation, pay slip generations, Loans and

Bonus, Promotions, Leaves, Training and Services etc.

Duration: Sep 2005 - May 2006

Environment:

ASP.Net with C#, SQL Server 2000, Visual SourceSafe, Win

Xp.

2 Responsibilities:

> Involved in object oriented design and development.

> Involved in coding of forms.

> Involved in writing Test cases for the application.

2. Project : VINS CRM.

Client : VINS Bioproducts Ltd, Hyderabad, India.

This application facilitates the client for maintaining the customers'

information. Different branches of the customer, different contact persons

for the customer, products of the client etc can be maintained by this

application.

Duration: Jan 2005 - Aug 2005.

Environment:

ASP.Net with C#, My SQL, Windows 2000

Responsibilities:

> Involved in designing and coding of forms.

> Involved in writing and executing test cases for the application.

3. Project : Indus Impex(Online Shopping Portal).

Client : Indus Impex Inc, U.S.A

Indus Impex is an online trade portal targeted for U.S. people with Indian

products. Portal consists of product listing, member's login, and Admin

Control and International Search facility.

Duration: Apr 2004 - Dec 2004.

Environment:

ASP.Net, SQL Server 2000, Windows Server 2000

Responsibilities:

> Involved in the design and development of the functionality.

> Involved in writing and executing test cases for the

application.

Gokul Puvvada

Contact this candidate