Sql Server Developer

Ram Ciit

Application Developer

Indianapolis, IN

***********@*****.*** - 317-***-****

Over 6 years of proven experience in developing the Client, Server and Web based applications using Microsoft

Technologies - .Net and SQL Server 2008/2005.

* Experience in developing and Integrating Web based applications using Asp.Net, C#.Net, JavaScript, HTML

and Database Operations using SQL SERVER 2008/2005.

* Hands-on expertise in WCF, RESTful Services, LINQ, Entity Framework, MVC, SQL Server Reporting

Services, Integration Services and Cognos Decision Stream.

* Have working knowledge on Share Point such as administration and web part development.

* Strongly initiative in programming. Experience in testing applications manually, using various automation

tools and VSTS performance testing.

* Worked extensively in multiple software life cycles such as waterfall, Agile and Prototyping.

* Advanced level Transact-SQL development skills which include designing relational and multidimensional

database model, creating Multipart Business dependent Stored Procedures, Tables, Cursors, Views, Indexes,

Triggers and Functions.

* Overall database design, such as creating normalized databases, assigning proper indexes, constraints,

creation of triggers, and stored procedures.

* Experience in performing the security scans of code using Vera Code and Black Duck and resolving the

flaws. Experience in source control tools SVN, TFS, and RTC.

* Skilled in creating Use cases and Test Cases based upon business requirement.

* Experience in leading and mentoring a team size of 6 based out of multiple locations.

* 'Star' level contributor for .Net forums in Microsoft's forums site with more than 1300 forum posts and 9580

points.

* Microsoft Community Contributor Award winner for year 2011.

* International Exposure: Toronto, Canada.

* Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and

leadership skills to develop creative solutions for challenging client needs.

WORK EXPERIENCE

Senior Application Developer (.Net/SQL/SSIS/Cognos)

Deloitte Member Firms - February 2011 to 2014

PDI is the data repository for people information. The purpose of the PDI Input Process is to integrate data

from multiple sources (member firms and other global applications) by standardizing and validating the data.

The project includes .Net development with WCF and various data ware house tools from Microsoft (MSBI)

and Cognos Decision Stream.

Responsibilities:

* Worked with Client/Business Analysts to define data requirements.

* Developed architecture document.

* Involved in preparing the complete SDS for all applications.

* Built WCF RESTful services for data retrieval across domains.

* Built the complete business logic using C#, services with WCF and UI by Asp.Net/jQuery.

* Involved in coding the application end to end from the scratch for several applications.

* Designed and developed SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers

to handle complex business rules and history data.

* Working as SPOC for providing transition to the new resources.

Environment: .Net 4.0, WCF (Rest) 3.5, SQL Server 2008, SSIS, ADFS, Entity Framework, Cognos Decision

Stream.

Software Developer (.Net/VSTS/SQL/Share Point)

Microsoft - April 2010 to August 2011

A sales channel Incentive Program is one where Partners participating in the sales channel are provided funds

in order to encourage their participation and increase their effectiveness in the sales channel. A typical IP

has policies on how the incentive funds are earned by the participants and how the funds are disbursed to

participants.

Responsibilities:

* Participated in meetings with the client and team members.

* Developed web application using .net for incentives calculation.

* Created database for the application, keeping the rules of normalization and business requirements intact.

* Developed triggers and stored procedures to incorporate the business logic and process.

* Involved in deploying the application to upper environments and fixing the bugs during stabilization/testing

phase.

* Did performance testing using VSTS 2010.

Environment: .Net 3.5, VSTS 2010, SQL Server 2008, Share Point 2007/2010.

Software Programmer (.Net/SQL/SSRS)

Vavou - November 2008 to April 2010

Vavou is a collection of online marketing tools that will handle the entire Internet business marketing in one

go. It has around 20 applications like Blogs, Network management, Tender engine, Internal Advertisements,

News Letters, Ticketing system, Communications console, feedback etc, . Among which 9 are done by our

company. It has many good features like mail sending, making phone calls and online chat etc. This project is

developed using advanced technologies and follows high standards as it is completely business oriented and

it will be used by many people throughout the world.

Responsibilities:

* Involved in the creating of the design document of the process

* Developed web application using .net, where users can register and create their own blogs and post the

articles.

* Integrated third party Telerik controls to achieve complex functionality in UI.

* Integrated third party controls to provide chat and phone call features in web application.

* Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined

Functions.

* Involved in deploying the application to upper environments and fixing the bugs during stabilization/testing

phase.

Environment: .Net 3.0, Telerik, SQL Server 2005, SSRS

SSRS Developer (SQL/SSRS)

Lucid Commerce - May 2008 to November 2008

Lucid is a big team over the entire world. Our team has developed around 200 reports for this. It involves

writing complex scripts in SQL, UI etc. This team is having a database which updates day by day. The reports

have to retrieve the data from the data base as per the customer's requirement.

Responsibilities:

* Involved in requirement gathering, analysis, design, development, change management, deployment and

user training

* Created tables, indexes and constraints.

* Created Views for Extracting Data.

* Involved in scripting Stored Procedures, Triggers, and Functions.

* Developed SSRS reports.

* Involvement in fixing the bugs during stabilization/testing phase.

Environment: SQL server 2005, SSRS

Intern Developer (.Net/Win forms)

Microsoft - March 2008 to May 2008

It is a reporting technique using the World Wide Web, Exploiting the power of Internet, Webcasts offer the

possibility to enjoy digitally captured symposia, scientific sessions and other presentations directly from the

desktop through user's favorite browser mostly using the new technology of streaming like .Net C#, Win forms,

etc.

Responsibilities:

* Involved in Study Analysis of specification Documents.

* Involved in developing the windows forms.

* Involvement in fixing the bugs during stabilization/testing phase.

Environment: Visual Studio 2005/Windows Forms

EDUCATION

Bachelor of Technology

Jawaharlal Nehru Technological University - Hyderabad, Andhra Pradesh

ADDITIONAL INFORMATION

Technical Skills:

Programming Languages C#, VB.NET

Technologies .Net 2.0/3.5/4.0

Web Technologies ASP.NET 2.0/3.5/4.0, WCF & RESTful Services

Database SQL Server 2008/2005

Development IDEs Visual Studio 2012/2010/2008/2005

Other Languages XML, HTML, JavaScript

Other

Win forms, ADFS, LINQ, MVC, VSTS performance testing, SSRS, SSIS, Share Point Administration, Cognos

Decision Stream, TFS, RTC, Vera Code, Black Duck, FxCop, StyleCop

Contact this candidate