Sql Server .Net

Manikanta

Full stack /.Net Developer

Email ID :- *****.*******@*****.*** Ph.: 469-***-****

PROESSIONAL SUMMARY:

Having 8+ years of software development experience in developing Client/Server, Internet & intranet applications.

Extensive experience in designing and developing applications using ASP.NET, C#, Web API, SOA, Web Services, HTML4&5, DHTML XML, ADO.NET, VBScript, JavaScript, SQL Server, AJAX, jQuery, CSS.

Extensive knowledge of Object Oriented Analysis/ Design (OOD) and various design patterns.

Experience in a fast-paced Agile / Scrum environment.

Experience in XML/XSL related technologies: XML, WSDL, XSLT and X-Path.

Extensively worked on Web server like IIS 5.0/6.0/7.5. (Internet information services)

Conceptualized and developed modules, detecting conflicts of interest in authorizations, bringing site within compliance faster than any other site using VB.NET.

Developed and consumed web services using the Microsoft ASP.Net with C# using the protocols such as SOAP.

Good understanding on WebSphere MQ, WebSphere Data stage environments and MQ integration.

Experience with SSO(Single Sign On) authentication, used it for user convenience.

Experience in programming early versions of Visual Basic.

Experience in creating Data Lake Accounts and Data Lake Analytics Jobs in Azure Portal Good knowledge on WPF/WCF Framework.

Excellent knowledge of different OOP languages like JAVA, .NET, VB, C, C++, C#.

Involved in creating WINFORMS for in-house Windows applications using C#.

Experience in using Entity framework and NHibernate as ORM tools to map classes with tables to enable working with rows as objects.

Experience working with JavaScript, VBScript, JQuery, Angular.Js, Knockout.JS Kendo UI and AJAX in ASP.NET for asynchronous communication and better user experience.

Worked with the Kendo UI using Grid and chart controls.

Strong developing experience in Visual studio.NET 2012/2010/2008.

Hands on experience in Service Oriented Architecture (SOA).

Thorough understanding of Relational Database, especially MS SQL Server and MS Access.

Good experience in Windows Azure Service Bus, and Windows Azure Document Database.

Expertise in using ADO.NET objects such as SQL Command, Data Reader, Data Set and Data Adapter.

Extensive knowledge of .NET security features such as Authentication & Authorization, Windows-based Authentication, Forms-based Authentication, Authorizing Users and Roles.

Proficient in Object Oriented Design/Development, Object Oriented Analysis and Design (OOAD), Model View Control (MVC) design pattern, Model-View-View Model (MVVM) design Pattern Team Foundation Server (TFS) and Test Driven Development (TDD).

Experience in writing complex Database Queries, Stored procedures, Triggers, Views and Functions using T-SQL, MS SQL Server 2008/2005/2000.

Experience on working with PowerShell Scripting and Bootstrap.

Experience in using Angular JS to test views and to do end to end unit testing by using continuous integration.

Experience in designing and developing of web forms using HTML,ASP.NET, AJAX, CSS, Typescript’s, Bootstrap, Angular.JS and XML.

Experience in developing the Desktop and mobile applications.

Experience in Designing and creating Visual Basic forms.

Developing Prototype for the project using AJAX, Hardcoded JSON, jQuery, AngularJS, JavaScript, HTML, and CSS.

Broad experience working with CSS Background, CSS Layouts, CSS positioning, CSS text, CSS border, CSS margin, CSS padding, Pseudo classes, Pseudo elements and CSS behaviors in CSS.

Maintained Cross Browser compatibility & implement Responsive Design using Twitter Bootstrap, custom media queries, etc.

Experience with IoC Cssontainer, Microsoft Deployment Toolkit

Experience in mentoring developer members and end users.

Strong interpersonal and communication skills.

Quick learner and can easily adapt to new technologies that help in improving the business.

EDUCATION:

Bachelor of Technology in Malla Reddy Engineering college(2004-2008)

Major: Information Technology.

Technical Skills:-

Languages: .Net Framework (1.1, 2.0, 3.0, 3.5, 4.0), VB .NET, C#, VC++, ASP.Net,

ASP 3.0, Visual Basic 6.0, HTML, VBScript, SQL, PL/SQL, COBOL

Operating System: DOS, Windows NT/98/XP/2000/2003/Vista/2008, UNIX

.NET Technologies: ASP.Net, COM+, ADO.NET, ADO, XML, WSDL, XML web Services,

Windows Services, Web Form, LINQ, WCF, WPF and Web API

Databases: SQL Server 2000/2005/2008, Oracle 9i/10g/11gR2+, T-SQL

ORM: Entity Framework, N Hibernate

Webservers: Internet Information Server 7.5 (IIS)

IDE: Visual Studio.Net (2015, 2013, 2012, 2010, 2008), Visual Basic 6.0,

Visual Interdev, UML, Visio.

Database Programming: Stored Procedures, Views, Functions and Triggers, Cursors in SQL

Server, Oracle (PL/SQL)

Reporting Tools: SQL Server Reporting Services 2008/2005/2000

Unit Testing Frameworks MS-Test, Nunit, Karma, Load Runner

Methodologies: Client/Server Architecture, N-tier application architecture, OOA,

Prototyping, Process Models, Systems Integration, SOA

Markup Languages: DHTML, HTML, XHTML, XML, XSL, XSLT, X-Path, CSS, JavaScript, jQuery,

jQuery Mobile, AngularJS, Backbone.js, PowerShell.

Version Control Tools: Visual Source Safe (VSS), Team foundation Server (TFS), Test Driven

Development (TDD) Serena Dimensions, Object Oriented

Development (OOD)

Other Tools: Exstream Dialogue, IBM Websphere MQ

Agile Tools: Rally, Version One

SSIS (Integration Services)

Lookup, Derived columns, Conditional Split, Merge, Union, Union All

SSRS (Reporting Services)

Drill Down, Drill Through, Chart/Pie, Cascading, Parameterized, Cross Tab, Sub Reports, Linked Reports, Tabular Reports

SSMS (SQL Server Management Studio)

DML, DDL, Triggers, Functions, Views, Cursors, Stored Procedures, Constraints, UDF, Normalization, SQL Operators, Indexes

Client: - Bank Of America Plano, TX Jan 2016 to Till Date

Role: Sr.Net Developer

Responsibilities:

Created several ASP.NET pages using ASP.NET, C#, ADO.NET, LINQ, and SQL Server 2008.

Designed User Controls (. acsx) for document upload, Comments Input, Multi Select Dropdown and Risk Question Control, which was used heavily across the application.

Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ and SQL Server 2008.

Created Stored Procedures/ Functions in SQL Server using T-SQL.

Implemented ASP.NET MVC pattern mechanism to display products.

Created views for various document libraries and Lists and applied filtering and sorting while creating the views.

Developed core functionality with the .NET framework using C#, MVC, Entity Framework, WebAPI and SQLServer2012.

Developed web forms in ASP.NET and necessary backend code to extract data from SQL Server 2008.

Use of NService Bus to transport Queues and messages.

Worked on creating Azure Blob for storing unstructured data in the cloud as blobs.

Microsoft Azure PaaS Services, Strategy and Planning.

Developed localization API s which stores the translated data in Azure and Sql tables

Worked on WCF services and consumed them in the internal applications

Generated reports using SQL server reporting services.

Imported data from flat files to SQL Server database using SSIS.

Developed and deployed web services using Visual Studio and IIS.

Working with AngularJS the framework, Databinding, Controller, Angular 2 APIs with various projects.

Implemented Angular 2 Services to bind the data and provide access to the data on the server.

Developed AngularJS Factories, Services and re-used across the application.

Designing of Angular 2 Modules and Controllers using different directives like ng-Show, ng-Repeat, ng-Controller and many more.

Written unit tests for Angular JS code using testing framework Karma.

Designed and implemented UI with extensive use of JavaScript,WebAPI, jQuery and Ajax.

Bootstrap is used for making the pages responsive with the changes in User Interfaces

Developed the UI Screens using HTML5, AngularJS, Bootstrap, JSON, JavaScript, AJAX, jQuery and CSS3 for complex page layouts while adhering to code standards.

Experience using all the approaches of Entity Framework like Code First, Database First, Model First.

Extensively used JQUERY, JSON, AJAX and DOM scripting for creating interactive web applications like auto complete form.

Created responsive webpages using Bootstrap Grids, Themes and Components such as Glyphicons, Badges/Labels, Progress Bars, Dropdowns in the web portal design.

Worked with GIT pattern and developed view-models using Typescript.

Rendered XML document to an HTML using XSL and XSLT Transformations.

Troubleshot various issues related to WebSphere Application Servers, BizTalk, HTTP Server, plug-in, Application and MQ.

Setup trust between on premise and cloud server using ACS and ADFS in Azure.

Creating and Managing Virtual Machines in Windows Azure and setting up communication with the help of Endpoints and also VM Migrations from Transitional hosts.

Used AZURE APP.FABRIC Message BUS to provide valuable functionality for integrating existing systems and building composite applications, deploy SOA components in an autonomous but federated manner for achieving true agility, flexibility among enterprises

Copy data to and from an on-premises file system by using Azure Data Factory

Create a Virtual Network on Windows Azure to connect all the servers.

Control data in accordance with the organization and client’s specific security policies. Process analysis and workflow design to builds efficient technical solutions.

Used Microsoft Team Foundation Server for source repository and version control.

Successful deployment of solutions in staging and production environment and supported in fixing the production environment issues.

Used JIRA to keep track of outstanding bugs to reduce downtime, increase productivity, and improve communication.

Used Microsoft Access to combine database engine with graphical user interface.

Used HP Exstream for multichannel customer communication management(CMM)

Used JENKINS for continuous integration and for automatic build process for mevan

Developed and deployed custom web parts using Visual studio 2010.

Used uDeploy for automating application deployment.

Hands on experience in creating Technical Design Documents, Use Case Diagrams, Process flow Diagram, Data Flow Diagrams.

Environment: C#, ASP.NET, Azure, VB.NET, VBA, Kendo UI, MVC, WCF, WPF, MS SQL 2008, BizTalk Server 2013, NService Bus, Visual studio 2013, Angular JS, jQuery, Bootstrap, Karma, Azure, Ajax, CSS, XML, XSLT, HTML 5.0, IIS 7.0, HTML, Team Foundation Server(TFS) and Agile.

Client:- Barclays,McKinney,Texas Oct’2014-Dec 2015

Role:- Full Stack/Sr.Net Developer

Responsibilities:

Involved in full life cycle of the project from requirements gathering, analyzing, designing, and developing the application using Iterative AGILE Methodology.

Involved with the client team to design and implement the advanced technologies WCF, SOA, ASP.NET, and VB.NET with the application logic in C # per the user requirements.

Involved in front end Application development using in ASP.NET, AJAX using C#, and back end in SQL Server 2008.

Used ASP.NET web server controls like Grid View, List View and Repeater for displaying the required information.

Created Rest full API’s using MVC4 Web API’s.

Extensive development using ASP.NET, VB.NET Web Forms using AJAX, Master Pages, Themes, Web Parts, Provider Model, JavaScript, TypeScript. Also, involved in proof-of-concept using ASP.NET Model-View-Controller, MVC pattern.

Designed and developed static and dynamic pages validating client side and Server side scripts.

Developed a windows application using VB.NET and web services for secured and machine specific log on to web based systems Involved in front-end development using Visual Studio 2013, ASP.Net, and CSS.

Used Code First Entity Framework approach.

Implemented VBA to control many aspects of the host application, including manipulating user interface features.

Developed WCF services for both Desktop and mobile applications.

Used JQuery, ASP.NET, VB.NET, AJAX toolkit controls and CSS to enhance the performance and richness to the user interface.

Integrating BizTalk with Oracle backend database server using WCF-Custom adapter with Oracle binding.

Coded with the Entity Framework, ASP.NET, and WPF.

Involved in deployment and release process, by building packages and by writing PowerShell script for automated deployment.

Developing WCF services and consuming them in WPF and class library applications.

Designed and developed WCF Web Services and configured our WCF Services with appropriate endpoints for consuming them in the web application.

Developed User controls using ASP.NET, VB.NET and C# and used them dynamically in the web pages using Master pages and CSS.

Used VB.NET/C# language for code behind pages to use the OOPs functionalities and to develop OOPS classes.

Consumed some external Windows Communication Foundation (WCF) Services to write logs to the database.

Implemented MVC on server side for handling GUI elements and service layer between front end and data layer.

Developed modules of the application in Visual Basic 6.0 and ASP

Developed the user interface for back office support and worked collaboratively in Agile scrum team on the design and development of application based MVC framework using Angular.js, HTML 5.0, and CSS3.

Designed dynamic and multi-browser compatible pages using HTML, CSS, Angular.js and JavaScript and developer responsive interface using Bootstrap and used SASS for CSS.

Developed the User Interface using HTML 5, CSS, Angular.js, and http calls to web-services

Utilized AngularJS as the development framework and done CRUD operations with http service.

Involved with bug fixing on functionality, and performance issues with JavaScript/jQuery.

Used test runner(Karma) for running test assemblies that use the NUnit test framework assemblies

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008.

Worked with FileNet, which helped customers to manage entire lifecycle of information.

Involved in designing and documentation of flows and functional diagrams using Visio.

Created numerous linked reports, cached reports, drilldown reports, and drill through reports as part of the project according to business requirements using Reporting Services (SSRS).

Migration of SSRS reports from SQL 2012 to SQL 2014.

Created client/server side converters to map Knockout models with ASP.NET.

Developing reports on SSRS on SQL Server (2000/2005/2008), and excellent in SSIS packages for integrating data.

Created XML web services using C# and transformed the XML Document into HTML.

Developing Web forms and windows forms for concerned applications.

Created Dropdown and Drill through reports using SSRS.

Imported data from flat files to SQL Server database using SSIS.

Written stored procedures in SQL server.

Used GIT for version control systems and source code management.

Used JENKINS for continuous integration and for automatic build process for mevan

Involved in production support and fixing production issues.

Environment: Visual studio 2010, C#, ASP.NET 4.0, Angular JS,knockout JS, Entity Framework,zVisual Basic, GUI, VB.NET, VBA, MVC, LINQ, WCF, WPF, Silverlight, MS SQL 2008, BizTalk Server 2013, Visio, jQuery, IIS 7.0, CSS, XML, HTML, SSIS, SSRS, Karma, jQuery Mobile, PowerShell, Team Foundation Server(TFS) and Agile.

Client:- Visa Austin,TX Feb 2013-Sep 2014

Role:- Full Stack/.Net Developer

Responsibilities:

Designed and developed Web Pages using ASP.NET, C#.NET, HTML, JavaScript, AJAX, jQuery CSS and server controls.

Developed secure login interfaces with ASP.NET Server controls.

Used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.

Used Validation Controls for corresponding validations required for business logic in Web Forms.

Designed and developed user interfaces using VB.NET and ASP.NET.

Coding the presentation layer using WPF and service layer using Windows Communication foundation technology.

Extensively used MVC for the designing on multiple devices.

Developed Custom Controls and User controls for reusable part of the web pages using C# with ASP.NET.

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing using Unit and responsible for writing test scripts and scenarios.

Created Rest full API’s using MVC4 Web API’s.

Used Bootstrap CSS for front end design.

Written the business logic in classes using VB.NET / C#.Net language and used in Webforms.

Worked with AJAX enabled WCF services using VB.NET, C# and ASP.NET.

Developed dynamic work flow process using ASP.NET 1.1, VB.NET and SQL Server 2008.

Created and deployed Web Services using ASP.NET and C#.Net, and generated the proxy class files based on the web services to consume in web application.

Maintained and enhanced existing software by analyzing and identifying areas for optimization and refactoring. Investigated new technologies and techniques and researched ongoing industry developments using OOPs.

Created generic repository using Entity Framework.

Built the reusable service components using AngularJS services with Object Oriented JavaScript, jQuery, HTML, CSS3,TypeScript based on the visual designs.

Developed various AngularJS directives to help build the functionality and UI behavior using JavaScript.

Tuning front-end applications like Visual Basic, which query the SQL Server databases.

Framework Experience includes Bootstrap 3, jQuery, Foundation and MVC.

Developed test-driven development (TDD) strategy guiding use of the unit unit testing framework.

Utilized C# generics, delegates, events, extension methods, anonymous types, and lambda expressions.

Designed and developed web pages using HTML, CSS3, AngularJS, JQuery, AJAX, JavaScript and ASP.Net, WPF.

Used LINQ to retrieve the data from the backend through Entity framework.

Extensively used ADO.NET objects like Sql Data Access, Sql Data Reader, COBOL, and DB2 SQL.

Developing reports on SSRS on SQL Server (2000/2005/2008), and excellent in SSIS packages for integrating data.

Enhanced the performance of WINFORMS application using tools like GDI+.

Developed Server side and Client side code using ASP.Net, JQuery and JavaScript.

Created Views by applying complex queries on multiple tables to create the virtual tables and implemented Cursors in Stored Procedures using SQL Server 2008, Implemented Joins in Stored Procedures to get the desired data by joining multiple tables.

Used TFS (Team Foundation Server) for source code control, project related document sharing and team collaboration.

Used Entity Framework as Data Access technology.

Responsible for testing, fixing the bugs and troubleshooting the technical problems.

Modified applications according to the user's requirements.

Used HP Quality Center to track the bugs

Used SVN for version control systems and source code management.

Used JENKINS for continuous integration and for automatic build process for mevan

Environment : ASP.NET 3.5/4.0, C#.Net, ADO.NET, JavaScript, Angular JS, CSS, Bootstrap, HTML, IIS 6.0, LINQ,OOP, XML, XSD, VB.NET, TFS, TDD, NUnit, Visual Basic,AJAX, WCF, WPF, Entity Framework, JQuery, Websphere MQ, MVC, SOA, Exstream Dialogue, COBOL, SQL Server 2008, SSRS, SSIS, WinForms, HTML, and DHTML.

Client:- ESIC (Employee State Insurance Corporation) Oct’2010-Dec 2012

Organization: Wipro Limited

Location:- Bangalore, India.

Role: .Net Developer

Responsibilities:

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

Actively participated in design and development of Database using efficient Database techniques.

Developed web forms for the end users using C#.Net and ASP.NET.

Involved in querying the database using ADO.NET and Stored Procedures for generation of reports.

Extensively used .NET inbuilt components like Data Grid, Data List and Calendar controls along with other .NET server controls.

Used Silverlight to create web application which allows drawing charts with economic variables.

Implemented XML Web Services using C#.NET.

Involved in creating WINFORMS for in-house Windows applications using C#.

Involved in creating Custom Controls, web controls and User Controls.

Authenticated logins and validated permissions.

Utilized Nunit to unit test .Net code.

Uploading the Data from text files to tables & wrote stored procedures to purge old data.

Developed applications to parse flat files into data using C#.NET.

Involved in using all the best features of ASP.NET including Dataset, Data View and Data Adapter.

Instrumental in maintenance of data integrity in back end Oracle 9i.

Developing Interfaces using AJAX.

Environment:- Visual Studio.NET, C#.Net, ASP.Net framework 1.1, VB.NET, GUI, ADO.NET, XML, HTML, ASP 1.1, AJAX, Oracle 9i, ASP.NET, Web Service, Silverlight, DHTML, SOAP, CSS, Java Script.

Client:- Manipal Hospitals Aug 2008-Sep’2010

Organization: - Wipro Limited

Location:- Bangalore India

Role: Software Engineer

Responsibilities:

Analyzed the requirements and prepared the analysis report.

Involved in Writing, modifying complex Queries, Stored Procedures and Triggers

Designed and developed the User Interface using Win-forms.

Source Code implemented using C#.Net

Developed WinForms and integrated these forms with Windows Services.

Developing User Control for Common Functionality in the ASP.NET.

Acquired knowledge in Web Technologies/client side technologies like JavaScript, JQuery, AJAX, HTML, and CSS, Bootstrap

Created Technical Design Documents, Use Case Diagrams, Process flow Diagram, Data Flow Diagrams

Performed validations using Validation Controls.

Environment Visual Studio.Net, SQL Server 2000, ASP.Net 1.0, JavaScript, XML, CSS, C#.NET.

.

Contact this candidate