Post Job Free

Resume

Sign in

Sql Server Project

Location:
Hyderabad, Telangana, 500004, India
Posted:
October 15, 2014

Contact this candidate

Resume:

MANI KUMAR REDDY CHINNAM

(acgdrs@r.postjobfree.com

+919*********

Summary of Experience:

> Having 9.3 years of experience in analysis, design and development of

client/server, web based and n-tier applications.

> Expert in developing web applications and windows applications in

Microsoft Visual Studio .Net IDE using ASP.Net, C#.Net, VB.Net,

ADO.Net, and SQL Server.

> Proficient in WCF, Web Services, XML, HTML, Java script, and CSS.

> Extensive experience in database design, database maintenance,

developing T-SQL queries, stored procedures, and triggers using SQL

Server.

> Effective in developing reports using SSRS, Active Reports .Net,

Crystal Reports.Net and OWC (Charts).

> Effective in working independently and collaboratively in teams.

> Flexible committed individual with excellent communication and

troubleshooting skills, aiming to specialise in developing and design

the IT solutions for various domains.

Professional Experience:

> Working as Senior Consultant in Alliance Global Services, Hyderabad

from Apr 2011 to till date.

> Worked as Module Lead in MindTree Limited, Hyderabad from Jul 2010 to

Apr 2011.

> Worked as Senior Software Engineer in MindTree Limited, Bangalore from

Nov 2008 to Jul 2010.

> Worked as a Software Engineer in Tricon Infotech Pvt. Ltd., Bangalore

from July 2005 to Nov 2008.

Academic Qualification:

> M.Sc. (Computer Science) from Andhra University in the year 2003.

> B.Sc. (Computer Science) from Andhra University in the year 2000.

Technical Skills:

Primary Skills : ASP.NET, C#.NET, VB.NET, SQL Server and WCF.

Programming Languages : C#.NET, VB.NET, T-SQL.

Technologies : ASP.NET, ADO.NET, ASP, ADO, Web Services,

WPF, WCF and SSIS.

Frameworks : .Net Framework 2.0/3.5/4.0 and DotNetNuke.

RDBMS/Database : SQL Server 2008/2005/2000.

Web Server : IIS 6.0/7.0.

IDE : Visual Studio 2010/2008/2005.

Scripting Languages : Java Script and VB Script.

Markup Languages : HTML and XML.

Configuration Tools : VSS 6, VSS 2005 and StarTeam.

Reporting Tools : SSRS, Crystal Reports, Active Reports 6 and

OWC (Charts).

Operating Systems : Windows 95/98/2000/XP/Vista/7/8/2008.

Domain Knowledge:

> Mortgage Insurance.

> Project Management & Metrics (Worked on Project Dashboard & CES tool

and implemented the various metric reports)

Achievements:

Got PAT ON BACK award two times (Jan 2013 and Oct 2013) in Alliance

Global Services.

Got 10/10 (Ten on Ten) award in MindTree on Mar 2010 for

implementation of Reflexions - CES Tool.

> Completed MCSE (MindTree Certified Senior Engineer) certification in

MindTree on March 2010.

> Got individual Spot award in MindTree on April 2009 for implementation

of Test Metrics Charts in Project Dashboard.

Soft Skills:

> Problem solving skills and quick learning attitude.

> Good Team player.

> High Integrity.

> Good communication, analytical and presentation skills.

> Process oriented.

Experience on projects:

# MI Online

Client : Radian Guaranty Inc.

Employer : Alliance Global Services.

Duration : April 2011 to till date.

Technologies : ASP.Net, VB.Net, C#, WCF, SQL Server 2008, Star Team,

Java script, VMS (COBOL System), HTML, XML, Active Reports 6.

Description: MI Online is an online mortgage insurance web application

provided for Contract Underwriters (CUWs) working on behalf of lenders or

servicers where they can apply for mortgage insurance for their mortgage

loans. The contract underwriters could be either an Onsite CUW or Service

Center CUW. The application was built in asp and the back end was VMS

(legacy COBOL system). Radian started migrating this application into

ASP.NET with back end as MS SQL Server in phase wise manner.

Modules migrated from ASP to ASP.Net

1. User Queue

2. Add/Edit User

3. Rate Quote

4. CUW

5. Servicing Transfer

Document Generation Service:

This is a WCF service which can be used to generate the various documents

(Commitment, Decline, Suspension, Notification, etc.,) required for MI

Online and other systems in the Radian. This service will read the data

from request, loads the Active Reports templates based on the version and

name of the DLL which are available in the templates folder, it runs the

report, and sends report in the form of base 64 formats as the response.

Roles & Responsibilities:

. Involved in design, development and unit test the various modules in

the application.

. Involved in design and development of web services.

. Leading the development team - assigning the tasks, collaboration with

the team members and helping the team members on technical issues.

. Attending daily status calls with client.

# Azure Cloud Engineering Services

Client : Microsoft Corporation

Duration : July 2010 to April 2010

Technologies : ASP.Net, C#, SQL Server 2008 R2, SCVMM API, SSRS, Visual

Studio 2010, IIS 7.

Description: Windows Azure Engineering Services re-engineer the public

cloud services to make them compatible to private data centers that can be

converted as cloud where the datacenter owner will have complete ownership

of the hosted environment. Cloud Engineering includes developing new tools

and enhancing the existing components according to the private cloud.

VMM Web App:

This application is to maintain the VMs and its operations. It has an

option to create multiple VMs unlike Self Service Portal where there is an

option to create only one VM at a time. Here user has an option to create

multiple VMs and View VMs of a particular user. It provides a facility to

perform operations (start, stop, pause, shutdown, etc.,) on multiple VMs at

a time.

Load Gen Web App:

This web application is to monitor the deployments in RDFE in Daily and

Hourly basis. It will show the different kind of reports/charts to analyze

the duration of each stage in the deployments which are deployed through

RDFE portal.

#Project Dashboard

Client : MindTree

Duration : Nov 2008 to July 2010

Technologies : ASP, ASP.Net 2.0, C#.Net, OWC, SQL Server 2008, VSS,

HTML, Java Script, CSS.

Description: This an intranet web application which provides the bird eye

views of all projects to the management. It captures the Quantitative and

Qualitative projects data which can be used to derive organizational

baselines and Management Information System (MIS) report. And this data can

be used as one of the inputs for Project management reviews by Delivery

Managers. This tool is accessible only to the PM and above managers. It

also provides the holistic view of the project health involving Project

Managers, Delivery Managers and Quality Catalysts. This is used by Project

Managers as a mechanism for seeking help, highlighting risks and issues for

taking corrective actions. It provides the summary for all the projects

executed at MindTree from project initiation to closure.

Test Metric Reports/Charts: This module accomplish in analyzing the current

level of maturity in testing and give a projection on how to go about

testing activities by allowing us to set goals and predict future trends.

The objective of Test Metrics is to capture the planned and actual

quantities the effort, time and resources required to complete all the

phases of Testing of the project. Test Metrics is a mechanism to know the

effectiveness of the testing that can be measured quantitatively. It is a

feedback mechanism to improve the Testing Process that is followed

currently.

The following Test Metric Reports/Charts are implemented as part of this

module.

- Test Case Efficiency

- Functional Coverage

- S1 Defects Detection and Density

- Total (S1 + Non S1) Defects Detection and Density

- Reopened and Dismissed Defects

- Test Execution Progress

- Defect Verification

- Defects Density

- Effort and Schedule Overrun

- Review Defects Density

- Automation Developed and Executed

- Test Containment Effectiveness

- Test Development Productivity

- Test Automation Productivity

- Test Execution Productivity

- Cost of Testing

TQI (Test Quality Index): This module helps the Test Managers to know the

quality of testing in their projects. TQI score will be calculated based on

some questions in the different area of testing. The Test Lead/Project

Manager has to fill around 40 questions on the following attributes in each

and every schedule month if the project is active.

- Quality of Test Strategy and Test plan.

- Quality of Test Design and Test Cases.

- Traceability, Quality of Test and Code Coverage

- Quality of Test Execution and Result Reporting

- Test Metrics, Analysis and Improvements

- Test Tools and Framework Usage

Roles & Responsibilities:

. Maintaining and giving support to ProjectDasboard application

and fixed some of the issues raised by the project teams.

. Involved in requirement analysis and implementation of design,

coding and stored procedures for the Test Metric Reports/Charts

module.

. Involved in requirement analysis and implementation of design,

coding and stored procedures for the TQI module.

#Reflexions - Customer Experience Survey Tool

Client : MindTree Limited

Duration : July 2009 to Nov 2009.

Technologies : ASP.Net, C#, OWC, SQL SERVER 2008, VSS, HTML,

JavaScript.

Description: Reflexion is the intranet web application which will be used

to drive the Customer Experience Survey process in the MindTree for their

customers. MindTree will conduct the surveys annually to all their customer

contacts or on a need basis. The survey drivers will be the Quality

Catalysts.

This application will provide the following features.

- Admin can configure (add/edit) the Questions, Answers, Answer

Groups, Rating Scales and Question groups which can be used to

configure the Survey.

- PM/QC can enter the contacts to their customers and projects.

- QC can initiate the Survey and in the initiation process the

application will send survey through an email to the customer

contacts. And they can send the reminder emails whenever they want

to send to the contacts that are not responded.

- Satisfaction % and Dissatisfaction % Reports. Process Area wise

reporting (Overall, Project Management, Engineering, Service

capability

- Low level or High Level Rating Reports.

Roles & Responsibilities:

. Involved in requirement analysis, system design and database

design of the entire application.

. Lead this project with the two team members and helped them in

implementing some functionalities.

. Involved in implementation of reports/charts and necessary

stored procedure of these reports in this application.

# PODO Solutions

Client : PODO, Mind Span Inc, USA.

Duration : Feb 2008 to Oct 2008.

Technologies : ASP.Net, C#, ADO.NET, SQL Server 2005, VSS, HTML, Java

script.

Media Management System (MMS): It is an intranet web application that

allows administrator to create advertisements and schedule them to run on

specific device (Digital Signage) at specific interval irrespective of the

location of the device. PODO system has Digital Signage mechanisms, which

have been installed in diverse retail industries. This application

facilitates staff members to locate the digital signage, set the time and

interval for a specific device. Once the administrator approves the order,

the advertisement will be launched at that scheduled time. The application

also provides other services like sending an amber alert, content

management etc.

MMSService: It is an XML web service that interacts with the digital

signage, Generics etc to exchange the demographic data, content information

and to ensure the actions taking place on each device on every location are

in sync.

Responsibilities:

. Involved in development of the modules.

. Involved in implementation of required stored procedures.

#Integration Service for PODO System

Client : PODO, Mind Span Inc, USA.

Duration : Nov 2007 to Jan 2008.

Technologies : SQL Server 2005, SSIS, MS-ACCESS.

Description: It is a SQL Server 2005 integration service developed to

import the data collected from various sources into the centralized

database on a periodic basis. The package is developed in such a way that

it looks for a MS Access db file on certain file location and imports the

data after verifying it.

Responsibilities:

. Involved in implementation of SSIS package.

#Campaign Management

Client : Americas Mart, Mind Span Inc, USA.

Duration : May 2007 to Oct 2007.

Technologies: VB.NET, ADO.NET, SQL Server 2000, VSS.

Description: Americas Mart has been developing and hosting trade shows,

conference programs, corporate meetings, as well as business and social

functions for over 30 years. Americas Mart can accommodate any size event,

from intimate meetings to large conferences to exhibits of 1,000 booths or

more. It is an independent digital trading exchange providing e-commerce

and informational services for sellers (wholesalers, manufacturers and

sales representatives) and buyers (retailers) of Americas Mart Atlanta.

Campaign Management is one of the modules in Registration, Attendance

and Marketing System. A type of marketing automation software that

optimizes the process for organizations to develop and deploy multiple-

channel marketing campaigns to target groups or individuals and track the

effect of those campaigns.

Responsibilities:

. Involved in implementation of all the forms in Campaign

Management module.

. Involved in implementation of required stored procedures.

#HCWSA (Henry County Water and Sewerage Authority)

Client : Henry County Water and Sewerage Authority, USA.

Duration : Feb 2007 - Apr 2007

Technologies: ASP.NET, C#, ADO.NET, SQL Server 2005, IIS, VSS, Crystal

Reports, HTML, Java script.

Description: Henry County Water and Sewerage Authority owns many Waste

Water treatment plants. This application is an intranet web application,

which captures entire operations of the plants. A different set of users

(Plant operators, Lab Technicians, LAS Operators, Power users, Admin, user

etc.,) enter various type of data on daily, weekly, monthly and quarterly

basis. This application performs process control calculations on the data

entered and also can generate reports (using Crystal Report) based on

different criteria. It will also send an automated mail to admin if the

outcome range of the entries crosses the limit specified.

Responsibilities:

. Involved in database design and system architecture.

. Involved in development of business layer classes.

#Artist Sign Up

Client : INTENT Media Works Inc., USA.

Duration : Sep 2006 - Jan 2007

Technologies: ASP.NET, C#, ADO.NET, SQL Server 2005, IIS, VSS, XML Web

Services, HTML, Java script.

Description: It is a web-based application where artist can sign up and

submit the media files and their metadata to be distributed. The artist can

submit different type of media like songs, video, e-book, photo, software,

games etc. There are seven steps for the submission of media file metadata.

In these seven steps, the artist can choose publishing type, media type,

metadata of the selected media, marketing model, and DRM window template

and ad zones.

Responsibilities:

. Involved in analysis, design and development of the entire

application.

. Involved in implementation of stored procedures in MS SQL Server

2005.

. Involved in database design.

. Development of web service for search the media files.

#Session Generator and Encoder

Client : INTENT Media Works Inc., USA.

Duration : June 2006 - Aug 2006.

Technologies : ASP.NET, C#, VB.NET, ADO.NET, IIS, XML, VSS, HTML, Java

Script.

Description: INTENT Media Works Inc. is the pioneer of rights-managed

digital media distribution via the Internet. Our revolutionary technologies

merge the ease of file-trading networks with the magnetic nature of social

communities to reach the largest and fastest growing consumer market

worldwide.

This Project has two applications in it Session generator and Encoder. In

session generator the user will select media files for licensing and

provide all information about the media like Provider name, whether the

media file is free or paid, its sponsored, website etc., which is stored in

an XML. The encoder will check the media files and information's stored in

this XML. And will encode the media files and will provide license to them.

This licensed media file will all its information is posted to a site where

these media files are checked whether they are properly licensed or not.

When everything is verified and displayed in their site for customers to

use them. These two applications are done for think and thick clients.

Responsibilities:

. Involved in analysis, design and implementation of session

generator module.

. Involved in development of classes related to encoder.

#TechLinks Exchange

Client : Tech Links, USA.

Duration : Jan 2006 - May 2006

Technologies : ASP.NET, C#, VB.Net, DotNetNuke, ADO.NET, IIS, SQL

Server 2000,

HTML, Java Script, VSS.

Description: It is a Web Based project in which all the processes are

divided into four modules. Prospective provider, Provider, Buyer and Admin.

When a buyer comes to the site (which is basically any anonymous or

member), the buyer chooses a category in which he/she would like to view

company/white paper listings. When the buyers choose a category, it will

take to another page that displays all of the companies within that

category who have profiles, as well as the white papers. Once the

prospective provider application gets approved from the admin then

prospective provider becomes provider and he can update his profile and

upload the papers. Admin has all the privileges to control all the services

in TechLinks Exchange like approving providers and papers, adding new

fields, adding provider agents etc. This project was done using DotNetNuke

that is open source content management system.

Responsibilities:

. Involved in development of server side user controls in C# and

deployed in DotNetNuke.

. Involved in database and system design.

. Involved in implementation of stored procedures using Microsoft

SQL Server 2000.

#Quote and Costing Module

Client : Rock-Tenn Company, USA.

Duration : July 2005 - Dec 2005

Technologies : VB.NET, ADO.NET, SQL Server 2000, VSS and SSRS 2000.

Description: Rock-Tenn paperboard is a leading manufacturer of paperboard

and converted paperboard products. The primary purpose of this project is

for the client to determine the standard cost of products sold by the

Columbus Converting Plant of Rock Tenn. by part size. In turn, the plant

will also use this data to calculate customer quotes based on specific

order size and packaging.

Responsibilities:

. Involved in analysis, database design, system design and development.

. Involved in implementation of stored procedures using Microsoft SQL

Server 2000.

. Involved in development of sales reports using SQL Server reporting

services 2000.

Personal Information:

Father Name : Sarveswara Reddy Chinnam

Date of Birth : 08th August 1980

Gender : Male

Nationality : Indian

Marital Status : Married

Passport No : F2506517 (Valid Till 10th Apr 2015)

PAN Card No : AGQPC8471R

Permanent Address : Door No: 6-40, Zamindhar Colony, Rayavaram -

533346, E.G.Dist., AP.

Present Address : Flat No: 302, 4th Floor, Sai Kuteer Apts, MIG - 597,

KPHB Colony 3rd Phase, Kukatpally,

Hyderabad, Andhra Pradesh, INDIA - 500072.

Place: Hyderabad

Date:

(Mani Kumar

Reddy Chinnam)



Contact this candidate