Post Job Free

Resume

Sign in

Sql Server Project

Location:
Kent, WA
Salary:
11000
Posted:
November 07, 2017

Contact this candidate

Resume:

Dilip Kumar Kona

Email: ac2533@r.postjobfree.com

425-***-****

Summary:

10+ years of IT Experience in Designing, Development and Maintenance of Scalable, Distributed, Web and Windows based applications using Microsoft .Net Technologies.

Expert in developing Web Applications using ASP.NET, C# and MVC Framework.

Experience in working with Internet languages like HTML5, CSS3, Webcore, JavaScript, JQuery, Angular JS & Ajax calls.

Experience in developing & consuming the REST, WCF and Web Services.

Experience working with Azure features like Cloud Services, App services, VMs, Auto Scaling, Azure SQL DB.

Experience in working with Azure hosting and deployment using Cloud and App services.

Experience in SQL Server Database design, Database maintenance, writing queries, stored procedures and triggers.

Experience working in fast-paced environments like AGILE Development.

Experience in Responsive UI design.

Experience in CMS(Content Management Systems) such as COMPASS widely used for Microsoft marketing sites.

Sound knowledge of version control systems like GIT, Team Foundation Server and Visual Source Safe.

Experience in technologies like LINQ, XSLT and Entity Framework.

Have good understanding & working experience of IIS.

Experience in developing Win forms, Windows services and Console applications.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Strong analytical and programming skills coupled with knowledge of object-oriented analysis and design methodologies.

Knowledge in SSRS reports and SSIS.

Experience in Unit testing using MOQ and integration testing using Selenium

Experience in writing Scope scripts in Cosmos environment.

Worked closely with Project Managers, Clients, Development Teams, Business Analysts and Offshore Teams.

Excellent communication and interpretation skills enabling effective interaction with Developers, Project Managers, and Business Analysts to review the requirement specifications.

Technical Skills:

Web Technologies:

ASP.NET, MVC, HTML5, Angular JS, JQuery, Java Script, HTML 5, CSS3, WebCore, Ajax, WCF, Web Services, Rest Services.

Languages:

C#.Net, VB.Net, ADO.NET.

Tools

Compass CMS, Cosmos, Firebug, Fiddler, Style Cop, SQL Profiler.

Version Control:

Visual Source Safe, Team Foundation Server, GIT

Database:

Microsoft SQL Server, Azure SQL & Access;

Microsoft Azure

VM’s, App Services and Cloud Services, Azure SQL Database, Blob Storage.

IDE:

Visual Studio, SSMS.

Windows Servers

Windows Server 2008 and 2012; IIS 6/7;

Professional Experience:

Support.Microsoft.com (Client: Microsoft - Redmond) April 2017 – Till Date

DotNet - Sr Technical Lead

Environment: ASP.Net, MVC, Visual Studio 2015, C#, WCF, REST, HTML5, Angular JS, Webcore CSS, Compass CMS.

Description: Support.Microsoft.com is the global web support portal for all the Microsoft major products. It has the different key features like Repair Order workflow, Answer desk support, custom templates to create the self-help articles for different Microsoft product, etc..

This project comprises of Creative, Development, testing, Production and Localization and

involves development, integration and maintenance of all the external and downstream services used by Support.Microsoft.com.

Responsibilities:

Understanding the Client requirement and prepare the high-level design document for the feature.

Developed the web pages using ASP.NET, C#, MVC, Angular JS, HTML5, Webcore CSS and Compass.

Created the new compass templates for the new feature.

Integrated new WCF service into the current SMC architecture.

Implemented the SLL Logging for all the incoming and outgoing service requests for the new feature.

Creating the Proof of concepts for the new features.

Involved in preparing the technical documents.

Involved in the code review and assigning the tasks to team members.

Involved developing applications using Agile-Scrum methodology.

Extensive usage of GIT souce control.

Involved in preparing the Unit test cases usning MOQ.

Involved in preparing the integration testing using Salenium.

Involved in the code review and assigning the tasks to team members.

Debugging and troubleshooting the production issues.

XboxOffers.com (Client: Microsoft - Redmond) September 2016 – March 2017

DotNet - Sr Technical Lead

Environment: ASP.Net, MVC, Visual Studio 2015, C#, WCF, REST, HTML5, Angular JS, JSON, CSS3.0, Compass CMS.

Description: Xbox Offers web portal is used to launch different types of online offers to the targeted XBOX users. The main objective of these offers is to convert the XBOX Silver users into Gold users by providing different types of rewards. Xbox Gold users invite their targeted silver friends via portal and once invited silver friend got converted gold, gold user will rewarded with some coupons/games. This portal is flexible to launch different types of offers like Single Reward, Multiple Reward and Milestone based reward offers. Depending upon the campaign requirement, we could able to launch the suitable offer online.

Responsibilities:

Involved in full life cycle of the project from defining the architecture to developing and testing.

Developed the web pages using ASP.NET, C#, MVC, Angular JS, HTML5, CSS.

Integrate the external services (WCF, REST) into the current system.

Writing Cosmos scripts for Conversion tracking (Silver to gold conversion).

Setup the Xlow pipeline to schedule the scope script on daily basis and load the converted users in AZURE Database.

Creating the Proof of concepts for the new features.

Involved in the code review and assigning the tasks to team members.

Extensive usage of GIT souce control.

Involved in preparing the technical documents.

Involved developing applications using Agile-Scrum methodology.

Involved in Daily Scrum meetings and Team Sprint Meetings.

Involved in writing the Unit Tests and integration tests.

Deployed the Web Application into Azure environment for both UAT and production environment and enabled the auto scaling to handle the load in webservers.

Debugging and troubleshooting the production issues.

Surface.com & Microsoft Band (Client: Microsoft - Redmond) March 2013 – August 2016

DotNet - Technical Lead

Environment: ASP.Net, MVC 5.0, Visual Studio 2012, C#.Net, WCF, HTML5, JQuery, JSON, CSS3.0, Compass CMS.

Description: Surface.com is a Web Development project scoped to design, develop, maintain and support (www.surface.com) website. This project comprises of Creative, Development, testing, Production, Tagging and Localization. It involves development, integration and maintenance of all the external and downstream services used by Surface.com.

Responsibilities:

Involved in full life cycle of the project from defining the architecture to developing and testing.

Developed the web pages using ASP.NET, C#, MVC, HTML5, CSS, Java Script and JQuery.

Involved in integration of WCF and Rest services into the current system.

Involved in designing the new compass templates for new pages.

Creating the Proof of concepts for the new features.

Involved in the code review and assigning the tasks to team members.

Involved in writing the Unit Tests and integration tests.

Involved in preparing the technical documents.

Involved developing applications using Agile-Scrum methodology.

Involved in Daily Scrum meetings and Team Sprint Meetings.

Involved in Deployment and Maintenance of the project builds between various environment such as development, UAT and Production.

Debugging and troubleshooting the live site issues.

Bing Maps (Client: Microsoft - Hyderabad) March 2010 – Dec 2012

DotNet - Senior Developer

Environment: .NET Framework 3.5/4.0,Visual Studio 2008/2010, C#, TFS, SQL Server 2008, AJAX, WCF, Developer tools, JQuery, HTML, CSS and Fiddler .

Description: Bing, Is a most popular search engine from Microsoft organization, gives an organized search results for the customers based on the user query entered in the search box. It has various features like News, Videos, and Maps and has extensive support for many markets.

Responsibilities:

Involved in Bing Maps market expansion for Australia Market on both Maps as well as detailed local search results.

Enhanced and developed the functionality using ASP.NET, C#, HTML5, JQuery, and CSS.

Consumed Windows Communication Foundation (WCF) & REST Services for Business Logic Layer for Service Oriented Architecture.

Creating custom tools to validate the different Providers data of search data.

Involved in writing the Scope scripts for getting the instrumented information from cosmos database.

Created framework to execute the scope scripts automatically on daily basis and ingest the output data into SQL server.

Perform Unit Testing and code review for the team.

Debugging and troubleshooting the Live site issues.

Involved in Deployment and Maintenance of the project builds between various environment such as development, UAT and Production.

Inventory Management System (Client: XLNTIdea - Hyderabad) Jan 2009 – March 2010

DotNet - Senior Developer

Environment: Visual Studio 2008, C#, TFS, SQL Server 2008, AJAX, WCF, Developer tools, JQuery, HTML, CSS and Fiddler.

Description: IMS (Inventory Management System) is a web-based application to track the complete inventory information of the printers manufactured by the XLNT IDEA. IMS involves different modules like sales, inventory, suppliers, purchase order and various custom reports to the needs of the business.

Responsibilities:

Involved in Software Development Life Cycle of the project including Analysis, Design, Development, and Deployment of the application

Used Visual Studio IDE to design the web pages, develop and debug the application.

Enhanced and developed UI functionality using ASP.NET, Ajax, HTML5, JQuery

Involved in Testing, Deployment, and Maintenance of the project.

Validations for each form ASP.Net Validation controls.

Involved in design of the database from the scratch.

Involved in writing stored procedures, functions in the data layer.

Perform Unit Testing and integration testing.

Responsible for handling the application errors, log the errors and monitoring the error logs.

Investigate the root cause of regression bugs and fix them, refactor the code.

Involved in generating Custom Reports using SSRS.

Involved in Production issues troubleshooting and deploying the release work items into production Environment

Web Delivery System (Client: Transdyne - Hyderabad) March 2008 – Dec 2008

DotNet - Software Developer

Environment: Visual Studio 2008/2010, C#, TFS, SQL Server 2008, AJAX, WCF, Developer tools, JQuery, HTML and CSS.

Description: The main objective of this system is to Review, Download and Print the transcribed documents. This application allows the user to get the actual files from anywhere through Internet. The Client (Doctor) can search for the document using Patient Name, MRN Number etc and get the actual Document information. One or more documents are selected at a time and downloaded through https site. These documents are categorized based upon provider name (Appropriate Doctor), Date (Created Date) etc. Web Delivery will show the list to be Reviewed/Download/Print based upon the login privileges. This system allows the authorized user to even transcribe the voice file into document.

Responsibilities:

Involved in Software Development Life Cycle of the project including Analysis, Design, Development, and Deployment of the application

Designed and Developed the UI, Web Services, and Data Access Layers required for the Web Delivery portal using ASP.NET C#.

Enhanced and developed UI functionality using ASP.NET, Ajax, HTML5, JavaScript

Validations for each form using Java Script and ASP.Net Validation controls.

Involved in database design and writing stored procedures, functions.

Responsible for handling the application errors, log the errors and monitoring the error logs.

Perform Unit Testing and code review for the team.

Responsible for handling the application errors, log the errors and monitoring the error logs.

Involved in Production issues troubleshooting and deploying the release work items into production Environment

LAB SOFT (Client: VIJAI ELECTRICALS - Hyderabad) May 2006 – Feb 2008

DotNet - Software engineer

Environment: Visual Studio 2005, VB.Net#, TFS, SQL Server 2005, Developer tools, JavaScript, HTML and CSS.

Description: VIJAI ELECTRICALS is a leading company in manufacturing of Power Transformers. The objective of this project is to measure the quality of the transfer by calculating the Load Loss, Efficiency, Impedance and Regulation of the Transformers and conduct tests like Load Loss Test, No Load Loss Test, Winding Resistance Test, Harmonics Test etc.

By conducting the above test we will get the readings like Amps, Volts, Watts, LV Resistance, HV Resistance etc. We would be able to get those readings into our software through Power Analyzer, which is connected, to the computer. Power Analyzer is as Machine, is used to capture the readings (like Amps, Volts, Watts, PF, Frequency, etc.,) of a particular Power Transformer. Finally based on the result they are going to measure quality of the transformer’s.

Responsibilities:

Developed the UI using C#, ASP.Net, ADO.net, XML, JavaScript, Ajax, Javascript, CSS, and HTML.

Involved in Testing, Deployment, and Maintenance of the project.

Involved in database design and writing stored procedures, functions.

Involved in generating Reports using Crystal Reports.

Debugging and troubleshooting the issues and fixing bugs.

Used visual source safe(VSS) for source code maintenance.

Education:

Bachelor of Technology, Andhra University, India



Contact this candidate