Sql Server Web Services

Gowtham. E

Sr .Net Full Stack Developer

Email: ***********@*****.*** Mobile: +1-571-***-****

LinkedIn: https://www.linkedin.com/in/gowtham-enjam-110b15131

PROFESSIONAL SUMMARY:

* ***** ** ***** on experience with all phases of Software development life cycle (SDLC), Analysis, Design, Development, Testing and Maintenance of applications based on windows/web in various domains.

Expertise in Programming, development and design applications using Microsoft Technologies like C#.NET, VB.NET, ASP.NET, ADO.NET, Web API, WCF, Web Services, WPF, SQL-Server 2014/2012/2008/2005, Visual studio 2015/2013/2010/08.

Extensive experience in both Win Forms and web Forms.

Experience in web development with JavaScript, JQuery, Bootstrap, AJAX, JSON, CSS, AngularJs 2.0, HTML, HTML5 and DHTML.

Good knowledge and experience with Win Forms, CSS, AJAX, JavaScript, React.JS, VBScript, and designing User Interfaces.

Support and maintain the Win Form applications.

Experience in implementing JQuery Objects and JQuery UI Widgets.

Expertise in creating Views, Partial Views, Strongly Typed Views, Sections, and Areas etc. In ASP.NET MVC with Razor View Engine.

Experience in using ASP.NET Web Forms & AJAX framework for creating efficient and interactive web applications that work across all popular browsers.

Developed Web & Windows Applications Using ASP.NET Web Forms, C#.NET, VB.NET, MVC 4.0/5.0/6.0.

Experience in development and implementation of Restful Web APIs, and exposes endpoints using HTTP verbs like GET, PUT, POST and DELETE.

Proficient with .NET Web services, windows Communication Foundation (WCF) using WSDL, WPF using MVC and MVVM design patterns, SOAP and UDDI protocols.

Developed applications using technologies including C#, Net 4.0, Entity framework, LINQ to SQL, WPF and backend SQL developer.

Worked on AngularJS 2.0 of Filters, Validations, Controllers, Directives, Scopes, Models, Services, Dependency Injection, Routing and Prototyping.

Knowledge in creating Single Page Application (SPA) using Angular JS 2.0

Have hands-on experience on Microsoft Azure cloud Storage.

Extensively used ODBC driver in various places like SSIS Packages, C#.NET applications to extract the data from Azure Storage table.

Experience in implementing and migrating and deploying workloads on Azure VM.

Extensively working experience in database design and development, for creating complex queries, Constraints, Indexes, Triggers, Views, Stored Procedures, Functions using T-SQL in SQL server 2016/2014/2012/2008.

Strong Experience in MY SQL database design using PL/SQL to write Stored Procedures, Functions, Triggers and strong experience in writing complex queries MY SQL Server and My SQL.

Worked on ADO.NET like SQL command, Data reader, Data set and Data Adapter.

Good experience on Web services, Windows Communication Foundation (WCF) and Windows Presentation Foundation (WPF) Services.

Implemented, configured, and customized JIRA issue tracking software with Agile plugin across all company functions and acted as JIRA administrator.

Good at the using various SSIS components or tasks to create a package to handle data flow.

TECHNICAL SKILLS:

Web Technologies

.NET Framework 4.6/4.5/4.0/3.5, ASP.NET Core 1.0, ADO.NET, WinForms, and Web Forms, XML, Web Services, LINQ, WPF, WCF, MVC 5/4/3, MVVM, Entity Framework 6.

Languages

C, C++, C#.Net, VB.Net, PL/SQL, T-SQL, Oracle12c/11g.

Scripting Languages

VBScript, HTML, CSS, Java Script, J-Query, AngularJs, ReactJS.

Web Technologies

HTML, HTML5, CSS3, XML, JSON, DOM, XAML, IIS, AJAX, SOAP, WSDL, Web Services, OWIN, ODATA.

Operating Systems

Windows 2010/2008/2007/XP/2000, Windows Server 2016/14/12/08/05, UNIX/Linux.

Databases

MS SQL Server 2016/2012/2008, MS-Access, MY SQL, Microsoft Azure.

Version Control

Visual Source Safe (VSS), Team Foundation Server (TFS), GIT, Tortoise Subversion (SVN)

Protocols

TCP/IP, HTTP, FTP

Tools

SQL Server Integration Services (SSIS), Postman, Fiddler, JIRA, Jenkins.

Reporting Tools

Crystal Reports, SQL Server Reporting Services (SSRS)

IDE

Visual Studio 2017/2015/2012/2010/2008/2005, Visual Basic, FoxPro.

EDUCATION:

Bachelor of Technology in Electronics and Communications Engineering, Jawaharlal Nehru Technological University, India. 2005-2009.

PROFESSIONAL EXPERIENCE:

Verizon Wireless, Morristown, NJ. (Nov 2015 – Present)

Sr .Net developer

Verizon Wireless provides wireless services to around 150 million subscribers. It is the largest wireless telecommunications provider in the United States. Our team core responsibilities are Analysis and design of end to end of system flow per business and marketing requirements and works on applications that support the Verizon Wireless Customer Care organization by providing quick access to customer contextualized data and support materials.

Responsibilities:

Involved in analysis, design and development of application with full Software Development Life Cycle (SDLC).

Created Business Logic Layer & Data Access Layers to implement the MVC architecture.

Involved in the implementation of client side validations using AngularJS and ASP.NET Web Forms Validation.

Configured Windows Communication Foundation (WCF) service to authenticate clients with Windows credentials for intranet applications for login validations.

Created Models and View Models in ASP.NET MVC by using MVVM and defined validations with the help of data annotations.

Designed large numbers of WPF Forms, Custom Controls and User Controls using XAML language for UI and Dynamic Web Parts for personalized content which allows Change, Edit, Move the content on pages as per users' own choice.

Developed front-end using AngularJS, Bootstrap, JQuery, HTML5 based on MVC architecture in Asp.Net Web Forms.

The front-end use HTML5, CSS3, ReactJS, jQuery and Bootstrap to build a single page web app that communicate with back-end via RESTful API.

Using ReactJS to implement rich functions in various pages: form validation, crud, grid list, search, sort, pagination, multi-selection, tags-input, advanced/custom directives, authentication, unit tests, etc.

Developed JSON, Xml pages Using Web API’s.

Created & Exposed RESTful Web API endpoints using HTTP verbs of GET, PUT, POST & DELETE for all database CRUD operations.

Analyzed and designed new WPF application using MVVM and Repository pattern.

Used C#.Net, ADO.Net Entity Framework and SQL Procedures in-order to access the MS SQL database for the front-end presentation.

Implemented features of ASP.Net such as Calendar Controls, Repeater Control, and Validation controls, Dataset, Security using Forms authentication.

Worked on Grid view using ADO.NET and retrieved data from SQL server 2016/2014 using queries.

Created data access layer and implemented LINQ to SQL for database connectivity in SQL Server 2016 and MY SQL.

Experience in Automating, Configuring and Deploying Instances on Azure environments and in Data centers.

Experience in Windows Azure Services like PaaS, IaaS and worked on Azure PaaS storages like Blob (Page and Block), Sql Azure.

Seriously improved overall system performance by optimizing SQL queries, by migrating SQL data to Azure Tables.

Used GIT as a Code Repository and followed source code handling practices like Check-In daily basis.

Tracking and prioritizing issues and new features for later releases of software using JIRA

Environment: VisualStudio2015, C#, .NetFramework4.0, WEB API, EntityFrameWork6.0, AngularJS, Bootstrap, Java Script, Azure, IIS 7.0/7.5,ADO.NET, LINQ, WPF, XML,JSON, MVVM, JIRA, SQL Server 2016/2014, SSIS, SSRS, GIT.

Equifax, Texas, USA (Oct 2014- Nov 2015)

Sr .NET Developer

Responsibilities:

Used .Net framework 4.0, n-tier architecture and Object Oriented Methodologies for application development.

Development of component classes and interfaces in C# encapsulating the business logic with strict adherence to Object Oriented Paradigms.

On Server side, Created and used Restful Web API endpoints for database operations (CRUD).

Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts for specific functionality in search module.

Also leveraged WCF security mechanism at transport level with windows authentication type for our intranet applications.

Created and exposed Restful Web API endpoints using HTTP verbs of GET, PUT, POST and DELETE.

Modified Restful Web Services to interact with the other applications and exposed them using SOAP and HTTP.

Using of Fiddler and POSTMAN tool for testing Web APIs endpoints.

Effectively used ASP.NET security infrastructure for authenticating and authorizing user access as well as performing other security related tasks using C#.NET.

Used front-end web development tools like AngularJS, JavaScript, Typescript, HTML, CSS, and JQuery.

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.

Create SOAP based WCF service as well as RESTful Web API to send and receive web service messages and converted the JSON format data to XML.

Good at writing UNIX Shell Scripting Commands.

Involved in writing application level code to interact with Restful Web APIS, Web Services using AJAX, JSON, XML and JQuery.

Extensively used ADO.NET for retrieving, querying, storage and data manipulation for achieving continuous database connectivity

Involved in Unit and Regression Testing and resolving browser compatible issues using IE developer tools, Firebug and Chrome developer tools.

Developed many SQL queries to fetch data as per the complex business requirements.

Developed SSIS packages, created Stored Procedures, Triggers, Views and Functions for the Application.

Extensively worked on Views, cursors, CTE's, schemas, permissions issues with client/server database design on SQL server and MY SQL.

Designed & developed various SSIS packages (ETL) to extract & transform data & involved in Scheduling SSIS Packages.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Played Key role in team of ETL developers for re-writing DTS packages and updating them to SSIS packages.

Good experience on MS Azure Cloud Architecture (MS Azure Pack (Private Cloud), PaaS and IaaS) assessments.

Involved in Build, Debug and Deployment of the components.

Responsible for maintaining versions of source code using (TFS) Team Foundation Server 2013.

Environment: VisualStudio2013, C#, MY SQL, ASP.NET MVC 4.0, WCF, Entity Framework 6.0, GIT, AngularJs, Typescript, Java Script, JQuery, Unix Shell scripting, TFS 2013, WCF, IIS 7.0, AJAX, WinForms.

Dish Network, Englewood, CO (April 2013- Sept 2014)

.NET Developer

Responsibilities:

Involved in System Study, Requirement Gathering and involved in extensive interaction with users.

Designed presentation layer for dynamic web forms using ASP.NET 4.0 Framework, DHTML, CSS3 and Visual Studio 2012.

Involved in all phases of System Development Life Cycle (SDLC) and developed solutions for diverse programming scenarios in C#, employing object-oriented programming concepts.

Developed the expert advice Web User Interface using AJAX Control Toolkit and AJAX technology to enhance the visual appearance to avoid the flickering effects across server post backs.

Rendered XML document to HTML using XSL and XSLT transformations.

Created Web Services for Provider Enrollment using WCF technology.

Demonstrate strong organizational and development skills with high attention to detail by using VB.NET.

Extensively used ADO.NET for retrieving, querying, storage and data manipulation for achieving continuous database connectivity.

Expertise using ADO.NET objects such as DataReader, DataAdapter and DataSet to fetch source data and handle user data.

Used version controller Visual Source Safe (VSS).

Created Views, Triggers and Stored Procedures using T-SQL.

Consulted with management and designed and developed all phases of the application.

Created cross browser compatibility templated using CSS3 to format the data.

Used SSRS to generate reports and integrated with ASP.NET Web Page using Report Viewer.

Documented business workflows textually as well as in UML diagrams.

Involved in Documentation, Unit Testing, Integration Testing and Debugging.

Environment: ASP.NET, C#, ADO.NET, MS Visual Studio 2012, MS SQL Server 2014/2012, Web Services, WCF, SSRS, JavaScript, Typescript, CSS3, UML diagrams, AJAX, XML, XSLT, DHTML, HTML and IIS.

Henry Ford Health Systems (HFHS), Detroit, MI (Mar 2012 - April 2013)

.NET Developer

Responsibilities:

Developed application and made changes in the application concerned with business rule changes.

Involved with the client team to design and develop the application according to client requirement using WCF, SOA and ASP.NET with the business logic implemented using C#.

Involved in SCRUM meetings with other team members to discuss the flow of the project.

Designed and developed Corporation forms using C#.NET using n-tier architecture.

Designed UI for all Corporation and UCC forms with CSS and Bootstrap, jQuery and JavaScript.

Developed complex Stored Procedures using temporary tables and loops using SQL and PL/SQL.

Prepared documents such as test documents, technical specification, and production move documents.

Developed XML page content file to read the front end text from XML File.

Designed and developed Web Service to generate PDF forms after successful submission of filling.

Development was done using Agile Methodology with daily scrums, paired programming using TDD (Test-Driven Development).

Designed and developed User Control for the application to make the reusable in application like Address Control, Login Control etc.

Extract, Transform and upload data into MY SQL databases using EDI Source components.

Strong Experience in MY SQL database design, write Stored Procedures, Functions, Triggers and strong experience in writing complex queries, using Oracle, DB2, SQL Server and MY SQL.

Interface with Application Users and other team members to solve data issues and user requests.

Property, Access Modifiers and Inheritance was used to develop code.

Used JavaScript for client side validations.

Create standard scripts for creation of tables and data insert scripts.

Environment: ASP.NET, C#, .NET Framework, MVC 4.0. Bootstrap, CSS, JavaScript, Visual Studio 2010, SQL Server 2014/2012, HTML, XML and TFS (Team Foundation Server).

Bajaj Allianz, Hyderabad, India (Nov 2009 – Dec 2011)

Jr .NET Developer

Responsibilities:

Involved in developing front end using ASP.NET, VB.NET, HTML and CSS.

Developed new services/classes and enhanced existing services for database access using C#.

Designed and developed User Controls for accepting customer inputs and presenting records/results to customer using ASP.NET.

Implemented input validation using ASP.NET, Input Validation Controls and JavaScript.

Used Customer Validation, User Validation and JavaScript to give access to registered users.

Created type libraries from the existing C# dll’s and these dll’s are consumed in the middle tier architecture.

Provided session level security and role based authentication using session objects and cookies.

Used AJAX to improve the performance of the web pages and to display the data on frequently visited pages.

Experience in MY SQL Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors on My SQL.

Wrote and debugged Stored Procedures and Functions in SQL Server.

Created User Controls and Custom Controls for the application.

Communicated with multiple groups in order to integrate the new enhancements into the regular flow.

Environment: .NET Framework, C#, My SQL, ASP.NET, XML, CSS, ADO.NET, T-SQL, SSIS, SSRS, Web Services, Windows XP, SQL Server 2008, IIS, JavaScript.

Contact this candidate