Sql Server Developer

Sireesha Kondamareddy

SUMMARY: PH.732-***-**** ********************@*****.***

●Around 6 years of experience in all phases of software development life cycle including requirement analysis, design, development, debugging, testing, performance tuning and deployment of small to mid size intranet and Internet based windows/web applications (B2B, B2C, distributed and Client server).

●Extensive experience in application development using Microsoft Visual Studio.Net2010, 2012, 2015 using .Net Framework 2.0, 3.5, 4.0. Visual C#,ASP.Net, ADO.Net, Windows/Web Services, WCF, .Net Security, Network programming, Creating Web Forms, MVC 5.0, Entity Framework 6.0.

●Experience in Development on WinForms, User Controls, Custom Controls.

●Have 4 years of solid experience in Database Design and Programming.(Queries, Sub-Queries, Stored procedures, User Defined Types and Functions, Views, Triggers) using SQL Server 2008, 2012.

●Proficient in application development on Multi-tier Architecture environment.

●Used SQL Server Reporting Services(SSRS) for Reports and Advanced reporting features of SQL Server 2012 like Scheduling, Delivery Processing etc;

●Expert in Web/User Interface development using AJAX, HTML, DHTML, CSS, JavaScript, JQuery, AngularJS.

●Experienced with object-oriented analysis and design.

●Hands on version control tools like MS Team Foundation Server, BitBucket.

●Has good communication and interpersonal skills. Able to learn quickly new Technologies, think creatively and solve problems in a team environment.

Technical Skills:

Languages : C#, ADO.NET, SQL, C++, C.

Internet Languages : ASP.NET, Web Services, Web API, JavaScript, JQuery, AngularJS 2.0, HTML, CSS, XML, SOAP

Framework : MVC, Entity Framework and WCF.

RDBMS : SQL Server 2008/2012

GUI Tools : Visual Studio.Net 2010/2012/2015, BitBucket, JIRA

Operating Systems : Windows 2008/2012

Web Servers : IIS 7.0, 8.0

Version Control : TFS, Git

Reporting Tools : SQL Server Reporting Services

Methodology : WaterFall, Agile (Trained and Certified).

Education:

●MCA from Sri Venkateswara University, 2004, India.

●BS Computers from Sri Venkateswara University, 2001, India.

Profession Summary:

Infosys Ltd; Oct 2016 - March 2018

Client : NextEra Energy Resources

Location : Florida

Project : Land Owners Portal

Role :Developer

Industry :Wind Energy

Technologies :C# 5, Angular 2.0, ASP.NET Web API 2.0, HTML5, CSS3,JQuery,Twitter Bootstrap,Typescript, SQL Server 2012,

MVC 5.0, Entity Framework 6.0,BitBucket,Agile (JIRA).

Land Owners Portal (LOP) is a NEER customer portal which is a web based Interface. It is a standardize platform that facilitates the sharing of asset and market data with Off takers.

It is a one stop solution that allows the NEER land owners to login and access the land related data for the projects they own and allows them to view their project payment details obtained from QLS and QRM,detailed Invoices which are obtained from the shared location provided by Quorum, associated documents which are retrieved from Documentum through API's and also the user can raise certain service requests online for their projects on need basis which are stored in local server and the required service is provided by the Quorum through Scribe integration tool.

Working Methodology: Agile

Roles & Responsibilities:

●Involved in Analysis, Designing and implementation of specifications provided by the customers.

●Developed REST API and Web based User Interface using Web API, ASP.NET, C#, MVC and Entity Framework, HTML, CSS and Angular JS.

●Worked on ASP.NET State Management and form based authentication

●Worked on Soap UI for testing REST API.

●Implemented input validation using the Angular JS.

●Involved in database design and implemented the Data Access Layer using Entity Framework.

●Involved in writing Queries, Stored Procedures and Triggers using Sql Server 2012

●Unit testing the developed functionality and verify the impact of change.

●Coordinating with QA team during testing phase.

Tata Consultancy Services Ltd. Feb 2015 – Sept 2016

Client : Kaiser

Location : California

Project: Enterprise Profiles and Preferences

Role: Developer

Industry: HealthCare

Technologies: ASP.Net, C#,.NET framework 4.0, Web forms, WCF 4.0, SQL Server 2012, Reporting Services 2010, AngularJS, HTML5, CSS3, SOAP 4.6, MVC 5.0, Entity Framework 6.0, Microsoft Application Blocks and Team Foundation Server, IIS 8.0.

Enterprise Profiles and Preferences (EPP) project provides as standard means across the enterprise to access the profiles and preferences of a “Consumer” (i.e. a prospect, applicant, member or former member). As part of Phase 1, an application allowing daily loading of data from Consumer Information Management Platform (CIMP) into EPP database was built as part of the utility, and a set of web-services allowing to query, create and update the data in cPnP were made available. The latter are currently enabling Document Management System (DMS) to generate three types of California Service Center (CSC) letters for the California members in their language of preference (incl. Spanish or Chinese). In Phase 2, the primary objective is to integrate with KP.org for a Real Time / Near Real Time (< 2 minutes data latency) uni-directional flow of data from KP.org to cPnP in order to further enhance the repository of preferences in cPnP.

Working Methodology: Agile

Roles & Responsibilities:

●Involved in Analysis, Designing and implementation of specifications provided by the customers.

●Develop WCF services and Web based User Interface using ASP.NET, C#, MVC and Entity Framework, HTML, CSS, and AngularJS.

●Worked on ASP.NET State Management, ASP.NET Caching, and form based authentication

●Worked on Soap UI for testing WCF services.

●Implemented input validation using Angular JS.

●Involved in database design and implemented the Data Access Layer using Data Application Blocks.

●Involved in writing Queries, Stored Procedures and Triggers.

●Developing of different web Reports using Reporting Services.

●Unit testing the developed functionality and verify the impact of change.

●Coordinating with QA team during testing phase

Tata Consultancy Services Ltd. July 2013 – Jan 2015

Client :Travelport

Location : California

Project: iLink

Role: Developer

Industry: Travel

Technologies: ASP.Net,C#,.Net Framework 4.0,Web forms, WCF 3.5, SQL Server 2008,ADO.NET, SQLServer Reporting Services, Javascript, JQuery, HTML 4.0, Microsoft Application Blocks and Team Foundation Server, IIS 8.0.

iLink is a centralized repository web application of all Travelport’s (GDS) customer Related data, their products and billing details.

Once the product is given to the customers, starting from the installation they will have different work orders that Travelport has to take care. iLink carry the details of different products that Travelport is hosting today and the customers of each product, their billing information for product purchase transactions and different work orders related to each transactions will be maintained in iLink applications. For these work orders there will be workflows at different levels which will be re-directing the work orders to different teams based on the work to be performed in the Work Order.

Working Methodology: Waterfall Model

Roles & Responsibilities:

●Requirement gathering, Analysis, Design, functional & technical specification, Coding, testing

●Designed and developed web services using WCF services and Web based User Interface using ASP.NET, C#.

●Database design, constraints, stored procedures, and packages using SQL Server 2008.

●Extensively used JavaScript for client side validation and implemented input validation using the ASP.NET Input Validation Controls.

●Unit testing the developed functionality and verify the impact of change.

●Developing of different web Reports using Reporting Services.

●Developing the front end pages using HTML and JQuery.

●Coordinating with QA team during testing phase

NTT Data Company May 2012 – Jun 2013

Client: Valuation Management Group

Location : Boston, MA

Project: InterACT

Role: Developer

Industry: Mortgage Banking

Technologies: C#.Net, Win forms, SQL Server 2008, ADO.NET, Team Foundation Server and Reporting Services, IIS 7.0.

InterACT is a software application which is used for managing and tracking real estate closing services like appraisal and collateral valuation services, credit reports, flood determinations, title and escrow services.

Flowing modules that describes the InterACT project are Order entry, Scheduler Assignment, Appraiser Assignment,

Appraisal Process and Invoicing

Working Methodology: Waterfall Model

Roles & Responsibilities:

Involved in Analysis, Designing and implementation and Testing of requirement specifications.

Develop Windows based User Interface using C#, Win forms, ADO.NET, SQL Server 2008.

Involved in writing Queries, Stored Procedures and Triggers in SQL Server 2008.

Implemented input validation using Validation Controls.

Involved in database design and implemented the Data Access Layer using Data Application Blocks.

Unit testing the developed functionality and verify the impact of change.

Communicating with the client on regular basis and getting the requirements and Implementation of the Program Change Requests as per the Technical and functional Design specifications.

Involved during the deployment of the application.

Contact this candidate