Web Services Sql Server
Resume:
Sai Teja N
*********@*****.***
SUMMARY:
Over 7+ Years of IT Experience in Requirement Analysis, Design, Development, Implementation of Web-based and Windows based Mobile application development, Client-Server and n-tier Application.
Possess technical skills in .Net Technologies like Classic ASP, ASP.Net, and C #.Net, VB.Net and Web Services, WinForms, LINQ.
Experience with C, C++, C#, Multithreading programming.
Extensive experience in SQL Server, Oracle, and Microsoft AZURE.
Strong Experience in data retrieval and manipulations using ADO.NET, ENTITY FRAMEWORK 4.5/6, Message queues and Event Hub.
Proficient in SQL Server Database Writing Queries, Constraints, Views, Stored Procedures, Triggers and User Defined Functions.
Extensive experience with various relational databases (SQL Server, Oracle, Avocado, Kusto Explorer, Cosmos).
Strong knowledge of Object Oriented Programming Concepts (oops), SOLID PRINCIPLES, Data Structures, Algorithms.
Experienced in Object Oriented Programming and Design Patterns.
Experience in Version Controlling tools such as VSO, TFS, GIT.
Wrote extensive HTML/ HTML5, CSS3, JavaScript, Angular JS, Ajax, XML, XAML, XSD, BOOTSTRAP, and JQuery code to build GUI, dynamic pages.
Experience in working with .NET features like Inheritance, Polymorphism, Interfaces, Data abstraction, Events & Delegates, Generics & Collections and Exception handling in.NET applications.
Strong Experience in designing, developing & consuming XML web services (.ASMX) using C#, SOAP Headers and Extensions, SOAP Protocol.
Hands on Experience in using various frameworks, tools and technologies like Visual Studio.
Extensive knowledge of the software development life cycle (SDLC) from requirements gathering, Analysis, Design, Development, Integration, Implementation and Testing of applications.
Worked in both Water Fall and Agile (Scrum) methodology.
Hands on Experience in ASP.NET MVC3/4/5, WCF, WPF, .NET 3.0/3.5/4.0.
Experience in all phases of application development including User Interface/ Presentation, Business Logic by using Dynamic CRM and Data tiers.
Generated reports using various reports generation tools/services like SQL Server Reporting Services.
Has Sound functional knowledge on Finance, Telecommunication and Healthcare domain.
Developed an Azure based high performance compute environment to support the massive computational requirements of client congressional redistricting Azure application.
Developed core front end components of a fast, stable, complex desktop web applications using framework Angular JS and Backbone JS.
Experience with N-Unit framework for unit testing.
Developed GUI using Web based (ASP.NET Web Forms, MVC) application development using C#.
Worked on Web application development using MVC 5.0/4.0 and ASP.NET Web Forms.
Working experience with SSRS and SSIS.
Proficient in automated tools like selenium.
EDUCATION:
Bachelor of Engineering in Computer Science India.
TECHNICAL SKILLS:
Microsoft Technologies &
Design Patterns.
ASP.Net4.5/4.0/3.5/3.0/2.0, Asp.Net, MVC 4/5, Web Forms, Win forms, WPF, WCF, ADO.Net, LINQ, Dependency Injection (DI).
Web Technologies
Windows API, Web Services, Web API (RESTFUL) HTML5, XHTML, CSS3, AJAX, XML, XAML, MSMQ, Silverlight, Kendo UI.
Web Servers
IIS 5.0, IIS 6.0, IIS 7.5, IIS ADMIN.
Programming Languages
C#, VB.NET (VB6), VBScript, OOPS, Data structures, Algorithms
Development Tools
Visual Studio .NET 2003/2005/2008/2010/2012/2013, PowerShell 2.0.
Clientbase Technologies
JavaScript, JQuery, KnockOut.js, Angular.js,Backbone.js, Node.js
Frameworks
Microsoft .Net 4.5/ 4.0/ 3.5/3.0, Entity Framework, Bootstrap, Microsoft Azure, Swagger.
Databases
MS SQL Server 2012/2008/2005, Oracle 10g, 11g, PL/SQL, NO SQL, RDBMS, Cassandra, NHibernate,Kusto Explorer,Avocado,Cosmos.
BI Tools
SSIS, SSRS, SSAS, SSDT, Crystal Reports.
Version Controller
TFS, Microsoft Visual SourceSafe, GIT, NUNIT, MSUNIT
Database Tools
SQL Server Query Analyzer.
Software Packages
MS-Office 2003/ 07/10/13, MS Access, Messaging Architectures
Operating Systems
Windows Win8/XP/NT/95/98/2000/2008/2012, Android SDK.
Methodologies
Agile(SCRUM), waterfall
PROFESSIONAL EXPERIENCE:
Staples, Framingham MA May 2017 – Till Date
Role: Sr .NET Developer
Responsibilities:
Interaction with Business users to understand the business flow and gathered business requirements for the application development and general advisory services
Involved into multiple Security Related Web Applications TRAMS, EPACS, and CORNERSTONE.
Analysis and design Application Architecture for the Process Flow.
Development, Testing, Deployment and Maintenance of high-performance, scalable, distributed ASP.NET web application EPACS by using software life cycle.
Extensively involved in migrating VB.Net application to .Net Framework 4.0 C# ASP.Net application in IDE Visual Studio 2015.
Used Team Foundation Server (2012) for source code control.
Involved in the design and development of application on ASP.Net MVC 5.0 Framework.
Designed User Interface with HTML5, CSS3, Telerik RAD Controls, JQuery, AngularJS, Bootstrap, JavaScript, JQuery and AJAX to enhance UI experience.
Angular JS was used for creating the controllers, factories, to make the web application dynamic and for making DOM manipulations.
Responsible for developing Layout, Nested Layout Pages, Partial Views using CSS style sheets for having common layout.
Implementation of client-side validations using JQuery and ASP.NET MVC Validation implemented at controller level.
Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.
Created an internal Web Service using C# and JQuery that performs a search on various entities.
Actively involved in coding the business logic using C# and developed the data models by code first approach using Entity Framework 6.0.
Working on creating Rest Services using ASP.NET Web API and C#.
Responsible in creating tables, writing SQL queries, stored procedures, Triggers, Functions, Indexes, defining roles, database users and assigning roles to the users by using SQL server 2008 R2.
Working independently in the process of application development, enhancement and also involved in migration to shared server, hosting and publishing.
Created and supported various ETL processes especially SSRS (SQL Server Reporting Services) Reports and SSIS (SQL Server Integration Services).
Develop reports using complex formulas and to query the database to generate different types of reports using SSRS with in the application.
Designed SSIS packages to transfer data between the databases, load data into databases, archival of old records, scheduling the jobs to do these tasks periodically
Performed both N-Unit Testing and end to end testing of the application using Selenium
Used Microsoft Azure active directory to provide access to cloud based applications and configuring the web role and worker roles in Azure in the final release of the application.
Responsible for knowledge and proficiency of multiple windows client and server operating systems.
Environment: C#, VB.Net, ASP.NET, Visual Studio 2012, SQL Server 2008 R2, Business Intelligence Data Tools 2008 R2, TFS 2012, MVC 5.0, Entity Framework 6.0, MS-VISIO, .Net framework 4.0, C #.NET, HTML5, CSS3, JavaScript, JQuery, AJAX, Angular JS, Kendo UI, Bootstrap, WCF, Web Service, Microsoft Azure, N-Unit testing, Selenium.
Client: Cerner Corporation, New Concord, OH Sep 2015 to May 2017
Role: Sr.NET Developer
Responsibilities
Involved in the complete Software Development Life Cycle (SDLC) phases of the project, right from analyzing the requirements, making relevant code changes, testing, and deployment.
Handled client interactions, resolved the issues and documented the requirements.
Designed and Developed application using ASP.NET MVC, C#, WCF, WEB API, XML and SQL Server 2012.
Was Responsible to provide Critical High Charts in the UI for the Internal Reports using Angular JS, Java script, JSON, MVC, HTML, C#.Net.
Developed Restful Web Services on HTTP Handlers with POST, GET Methods for XML and JSON requests.
Implemented Entity Framework with C# in Visual Studio to establish connections between server-side web application and a MS SQL Server 2012 database.
Wrote customized queries (Scope Scripts) in Microsoft proprietary Big Data analysis platform COSMOS and redirected the data to the UI for generating the reports (High Charts).
Also represented the internal data as charts (dashboards) in the PowerBI Dashboard.
Used SOAP to communicate and pass the information in XML format from web service to the application.
Worked on the enhancements, bug fixes, porting, testing of the CRM dynamics UI, also developed the test cases for the pieces of the new functionality that was added using NUnit.
Utilized ADO.NET Entity Framework technology extensively for data retrieving, querying, storage and manipulation using LINQ.
Integrated Microsoft Flows UI into the CRM UI. Also worked on the telemetry data which included mainly logging various events into their proprietary tool Jarvis(DB).
Application was automated through selenium.
Developed Web services using WCF to interact with third party systems to pull provider's information.
Exposed to Agile-Scrum application development methodology.
Developed presentation layer which includes UI components, validations using HTML5, applying styles using CSS, used JQuery to make Ajax calls.
Development of complex stored procedures and SQL queries using SQL Server for extracting, inserting and manipulating the data and display on Grid view controls and dropdown list boxes and User controls.
Implemented Angular JS to get the front-end.
Developed Restful service using WCF framework and used AngularJS for getting data.
Implemented Multithreading for the complex design patterns.
Was part of a Microsoft internal reporting tool system which was developed with MVVM and WPF and has extensive user friendly customized reports for the higher management to check the performance of the various sub systems like the Geo, data center, Orgs.
Developed the rest services using WCF and are reused in the WPF application.
Signed and developed enhanced webpages using MVC 5.0. Used TFS and Git Hub for Version control.
Environment: Visual Studio 2015, 2013, .NET Framework 5, MVC, RESTful web services, C#, SQL Server, ASP.Net, JSON, HTML5, CSS3, JavaScript, MVVM, AngularJS, JQuery, WPF, SQL Server 2012, TSQL, PL/SQL, PowerBL.
Client: 21ST Century, Woodland hills, CA Aug 2014 to Sept2015
Title: .Net Developer
Responsibilities:
Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications
Used Agile Methodologies in development process.
Developed web and windows based application using ASP.NET, C#, Web Services, IIS.
Utilized .NET Web API, .NET MVC, Entity Framework, jQuery, Bootstrap, SQL Server.
Worked on creating and consuming Web API restful services for vendor data validation service.
Implemented Charts in the UI Using AngularJS, MVC, HTML, CSS, JSON for the huge internal clients Data.
All Data Access was done through REST web services calls to a cache database on the back end.
Create event driven Web Forms using ASP.NET and C# and implemented form validations using Validation Controls using both Custom Validations and JavaScript Script like JSON was written for Client Side Validations.
Working on experimental HTML5/CSS3 implementations for use-cases.
Developed WCF Service to fetch the Customer Details to be reported on a monthly basis.
Implemented WPF to create, attractive and effective user interface using XAML document.
Involved in the Database design, wrote stored procedures, database views and T-SQL queries for the underlying SQL Server Database.
Extensively worked on Restful web services using Web API. Implemented Multithreading and came across deadlock situations.
Responsible for the Functional Unit Testing, Bug Fixing and troubleshooting the technical problems in module and application level.
Involved in writing Complex SQL queries, stored procedures and Triggers accessed SQL SERVER database using ADO.NET.
Developed Stored Procedures, Triggers, and Views in SQL Server 2008 for accessing the database.
Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.
Mentoring team members technically and functionally with respect to .NET development.
Involved in daily project status reporting to client using conference calls, preparing project status report for client program management.
Environment: ASP.NET MVC5.0, C#.NET, RESTful web services, ADO.NET, HTML5, CSS3, Web API, Entity Framework, WCF, JSON, JavaScript, AngularJS AJAX, IIS 7.0, JQuery, NUnit, SQL Server, Web Services, TFS.
Client: Merge Healthcare, Hartland, WA Mar 2013 to June 2014
Title: .NET Developer
Responsibilities:
Used 3-Tier system having Business Logic Layer (C#.NET), Presentation Layer and Database Layer (Database Connection and Security Settings)
Used Agile methodology SCRUM to study system, consolidating requirement, establishing inter process relation and team communication, using Agile our team developed cross functionality and distribution of requirements and understanding the current working of system.
Developed and designed web application using 3-Tired architecture and MVC design pattern.
Used REST architectural model in web service development part, and also RESTful web services which implements both principles of REST and HTTP.
Used WCF services to store files in a repository, using a file storage service and hosted the service using multiple end points.
Used Web API to build RESTful web services to interact with ASP.NET MVC modules
Developed custom controls to enable reusability and used rich graphic controls of WPF.
Extensively worked with C#.NET for creating data access layer and business layer and integrated with ASP.NET pages.
Created and deployed Web Services using C#, SOAP, XML for Pulling Customer Service Records
Extensively used XSLT to convert XML data fetched from the database, using a querying web service.
Design of UI in ASP.NET using C#.NET controls, C#.NET and writing of common controls.
Used LDAP/ Active Directory to authenticate the user.
Used Silver light and JavaScript to create animations and rich UI experience in the web pages.
Used ADO.NET for SQL server database interactions using Data Adapters, Data Reader and Dataset.
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, User Defined functions and triggers.
Performed Unit Testing, Regression Testing and Load testing on the modules according to the requirements and development stand.
Implemented Web services and WCF (SOA) for the communication between client and server using SOAP.
Used Team Foundation Server as version control for storing different versions of Source Code.
Designed and documented code-behind specifications and methods with their signatures and description.
Used RMS Bug Tracker to track testing bugs. Used TFS for version controlling.
Interacted with business analysts to resolve functional issues and technical implementation considerations
Environment: C#.NET, .NET Framework 3.5/3.0, RESTful web services, MVC 4.0, WCF,ASP.NET 3.5/2.0, ADO.NET, ASP.NET Ajax, IIS 6.0, Silver light, jQuery, MVC,JavaScript, NUnit, SQL Server 2005, HTML, CSS, TFS.
Client: IBERIABANK CORP, Lafayette, LA Dec 2011 –Feb 2013
Title: .Net Developer
Responsibilities:
Working in an agile Environment to deliver higher-quality software far more rapidly.
Successfully organized initial set of requirements into master list of Use Cases.
Involved in development of Web Forms, Classes using VB.NET that incorporates both N-Tier Architecture, and Database Connectivity.
Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
Worked on different aspects of .NET framework, like ASP.NET 3.5, ADO.NET and VB.NET.
Involved in designing of User Interface with CSS, HTML, and DHTML.
Connected Data with Data Source Control and Data-Bound Web Server Controls, Created tables with relationship and indexes.
Implemented JavaScript and JQuery for client side validations.
Developed presentation layer using Server-controls, HTML Controls, User Controls, and Custom Controls.
Created and deployed Web Services using VB.NET, SOAP, and XML for Pulling Customer Service Records.
Modified web services to interact with the other applications and exposed them using SOAP and HTTP.
Used AJAX to trade data with a web server, without reloading the page.
ADO.NET was used to connect to the data bases in a disconnected oriented architecture.
Created event driven Web Forms using ASP.NET and implemented Form Validation.
Extensively used Grid view control throughout the application.
Used SOAP to Implement Web Services, and consumed and published XML web services in the application
Created CSS files to be applied to various web forms on the web pages.
Involved in preparation of cascade style sheet (CSS) files.
Involved in Code review phase. Extensively involved in Stored Procedures Optimization.
Used VSS to maintain the version and source control. Participated in full software development lifecycle.
Environment: Visual Studio 2008, .NET Framework 3.5, RESTful web services, ASP.NET, VB.NET, ADO.NET, XML, HTML, DHTML, JavaScript, IIS 6.0, SQL Server 2005, XSL, CSS, AJAX Toolkit, Win Forms, UML, and VSS, SOAP, N Unit, Windows Server 2003.
Client: MBS Software, Bangalore, India Jan2011-Oct2011 Role: .Net Developer
Responsibilities:
Involved in understanding and analyzing the client’s business, requirements for the system.
Involved in Design and Developing components of this application using ASP.NET, C# .NET, VB. NET, JavaScript.
Architect and implement high volume, high traffic transactional application using conventional design practices (SOA, design by contract, MVC)
Implemented business, database access layer classes in C# using UML class diagrams and sequence diagrams.
Written SQL Queries, Stored Procedures, Triggers, Backup and Restore Database, defining roles, creating database users, Assigning Roles to user’s using SQL Server 2005.
Application design based on n-tier Architecture.
Extensively involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.
Involved in preparation of cascade style sheet (CSS) files.
Developed secured web services using .Net, C#, XML/SOAP.
Written code to access secure web service using .Net, Web form using C# and ASP.Net, WSDL, Proxy Class, XML/SOAP.
Environment: Visual Studio 2008, .NET Framework 3.5, ASP.net, RESTful web services, C#, MVC, XML, Web services, IIS, Java Script, Windows 2000 Server, HTML, DHTML, UML, CSS, Ajax Toolkit, VSS, SSIS, SQL Server 2005.
Contact this candidate