Sql Server .Net

Manoj Kukkala

+1-860-***-****/****.***@*******.***

Around 8 years of Experience in Application Development using ASP.Net, Windows Forms, Implementation and Maintenance of Internet/Intranet based Web and Desktop applications using Microsoft Technologies.

Experience in UI development using Web Forms, Web Parts, Master pages, Custom Controls, and customizing behavior using scripting languages like JavaScript, HTML, DHTML and CSS.

Experience in Implementation Projects, Upgrade and Support Projects.

Strong analytical and conceptual skills in database design and development, Data modeling, Schema modeling using SQL Server that encompasses Stored Procedures, Functions, Indexes, Views and Triggers, etc.

Experience in object oriented conceptual expertise classes, inheritance, encapsulation, and the tools used in their definition for UML, Use Cases.

Experienced in implementing applications using MVC.

Strong in advanced and emerging technologies including WCF, Web Services, LINQ and AJAX.

Knowledge of the Agile methodology.

Ability to learn new technologies quickly and having complex problem solving skills.

Ability to provide quality customer service, building trust through integrity of work, and build strategic relationships through teamwork.

Involved in design concepts, Three tier architecture, components, interfaces, messaging

Hands on experience in.Net Framework with ASP.NET, Win Forms, C#.NET, ADO.NET and LINQ TO SQL, etc.

Experience in database/Data Access RDBMS(Oracle), tables, triggers, logical and physical modeling, access strategies and tools

Strong verbal and written skills in order to effectively communicate with multiple levels of management.

Ability to troubleshoot and resolve development problems, and calmly and rationally assess situations.

Experience in Visual Basic.NET and other .NET programming languages

Broad understanding and experienced with Microsoft Windows and other Microsoft technologies.

Experienced in developing Microsoft Office based solutions.

Experienced in developing database applications using SQL Server. Experience with Oracle, DB2.

Experienced in developing interoperable solutions with Unix/Linux and/or Java using web services, COM/Java technologies

Designing and building custom ASP.Net Web applications using MVC / MVVM patterns.

Ability to facilitate software quality measures like TDD, Peer Review Programming and Pair Programming

Technical Expertise

.Net Technologies

ASP.NET, ADO.NET,SQL, XML, Web Services, LINQ, C#, VB6, VB.NET

Client/Browser Technologies

AJAX, XHTML, HTML, JavaScript, CSS, D3 Javascript, AngularJS,Microsoft Azure

Databases

MS SQL Server 2012/2008/2005, Oracle, MS Access 2007/2003

Design Methodologies

Design Patterns, Data Flow Diagrams, Flow charts

Tools & IDE

Microsoft Visual Studio 2010, Microsoft Visual Studio 2012, Microsoft Office, Microsoft Project Server, Microsoft Silverlight

Version Control

Microsoft Visual Source Safe, Team Foundation Server

Educational Qualification:

Bachelor degree in Engineering from India

Professional Experience

Company Name: Guideone, Des Moines, IA October 2013 – Till Date

Role: Sr.Net Developer

Description:

Guide One Insurance is in the process of transforming its Personal Lines products by implementing PL 2.0 program, it is one of the leading insurance group, which provides health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life and disability plans, and medical management capabilities and health care management services for Medicaid plans.

Responsibilities:

Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications.

Participated in daily scrums and weekly meetings with the project sponsors to meet expectations and deadlines.

Designed Business components and Data Access Layer using C#.

Used LINQ to XML and LINQ to Objects for retrieving the data efficiently and Just in Time manner.

Developed complex storedprocedures using temporarytables and loops using SQL.

Created roles, packages and deployed project data in cloud by AZURE.

Created data and os Virtual Hard Machine from project images in cloud by using AZURE.

Participated in moving application to AZURE and run in the cloud.

Used JQuery to dynamically render the content on web pages developed using C#.

Used ADO.NET Entity Framework Model as the Data Access Layer (Database First) and implemented the CRUD (Create, Update, Retrieve and Delete) operations, Mapping and executed stored procedures.

Developed core functionality with the ASP.NET MVC Framework (C#.NET, ADO.NET).

Design forms using Master Page in ASP.NET.

Implemented user interface in the form of mobile and desktop web app with high performance using AngularJS.

Responsible for developing, designing and implementing user interface in support of system using AngularJS.

Implemented client-side form validation rules using AngularJS.

Implemented AJAX Library, CSS, JSON and various web controls to present interface to users in a much comfortable environment.

Involved in building RESTful API.

Implemented WCF and REST services.

Designed and developed visual basic applications.

Implemented source control and release management system using TFS, SVN and GIT.

Involved in converting a single-threaded VISUAL BASIC 6 application to multi-threaded .NET.

Implemented operations like concatenation, minification, check, clear using GRUNT and operation using pipes, streams using GULP.

Designed reports MS-ACESS and linking them using VISUAL BASIC.

Involved in Visual Basic to provide ActiveX controls by Component Object Model.

Involved in portal GUI design using Master page, Login control, Site m ect Model. ap, Microsoft menu control and client side validation which is done by Ajax validation extenders.

Coding using C# of all layers- UI, Business and Data Access Layer to implement MVC architecture.

Developed CascadingStyleSheets (CSS) for User Interface uniformity throughout the application.

Develop sequence diagrams and user flows for the application using MS-Visio.

Development of UI using ASP.Net framework.

Developed data visualization framework data-driven approach to DOM manipulation using D3.Javascript.

Responsible for creating data using web standards like HTML, SVG and CSS.

Used JQuery and JavaScript for client side validation and other purposes.

Perform Unit & Integration testing.

Responsible for packaging and deployment and support of builds when code is deployed in development, system, acceptance and production environments.

Responsible for creating the tables, Views, Functions, Jobs using Oracle10g.

Responsible for deploying application on client servers.

Worked on SOA/Web Services for overall Integration tasks.

Implemented WCF services, better logging and exception management support to help in the early detection of new problems.

Provide technical support to business and testing team during testing phases..

Maintaining accurate and timely pipeline and service forecast data.

Used TFS for version control and to maintain the updates time to time.

Updated existing stored procedure for various modules.

Provided maintenance and resolved technical errors arising in the application.

Performed code reviews and utilized Subversion (SVN) for version control.

Worked on combination of SQL Server Reporting Services and Sharepoint, FTP, UAC scheduler a plus.

Implementing Microsoft Business Intelligence Development Suite with legacy data being on an IBM Mainframe in DB2, VSAM and sequential files.

Managing Transact- SQL and SQL database skills using Microsoft SQL Management Studio.

Designing C# scripting within SSIS

Indexed site’s content to optimize search capability and achieve SEO (Search Engine Optimization) targets.

Responsible for creating front-end Web applications using ASP.Net framework, MVC, MVVM patterns, JQuery, HTML5.

Actively involved in development of web application using front end tools such as Eclipse and Dreamweaver.

Environment: .Net Frame Work 4.5/3.5, Visual Studio 2010, ASP.Net, AngularJS, Javascript, C#, CSS, JSON, SQL Server 2008, XML, XSLT, Web Services, RESTful API, LINQ, WCF, GRUNT, GULP, Microsoft Azure, Crystal Reports, SSIS, VSS, TFS, Agile Methodology.

Company Name: Macys, Atlanta, GA January 2013 – September 2013

Role: .Net Developer

Description:

The project involved implementing the Sales Management System as per the business requirement specifications with respect to Order Management.

Responsibilities:

Implemented Data access layer using ADO.Net to connect and retrieve or manipulate database information.

Established communication between different applications running on same/different platforms using WCF.

Used Grid View, Data List and Repeater controls with Paging and Sorting for displaying various data on to the page.

Used Model View Controller architecture for part of the development of the product.

Programmed ADO.Net for communication between application and database, used extensively Data Grid, Data Set, Data Table, Data Views, Data Adapter and Data Readers to render reports.

Developed Stored Procedures, Triggers, and Views in SQL Server 2005 for accessing the database.

Developed T-SQL queries to fetch data as per the business requirements with proper tuning techniques.

Implemented and extensively used the Object Oriented programming concepts in C# and ASP. Net 3.0.

Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.

Implemented Serialization and Deserialization of objects.

Developed Custom Controls which provides flexibility, reusability better deign time experience.

Developed partial post back validations to manipulate data on web pages using AJAX.

Developed various stored procedures for the data retrieval from the database and generating different types of reports using SSRS.

Used Visual Source Safe for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Maintained existing Web applications including those written in Silverlight.

Involved in unit testing, integration testing and deployment of the application.

Environment: Visual Studio 2008, ASP.Net 3.0, ADO .Net, XML, HTML, JavaScript, IIS 6.0, Net Framework 3.0, Web Services, SQL Server Integration Services (SSIS 2008/2005), SQL Server 2005, T-SQL, DHTML, Windows Server 2003

Company Name: Prudential Bank Trust, Hartford, CT November 2011 – December 2012

Role: .Net Developer

Description:

We have developed a web based application to help and serve the employees of the company with different functionalities like displaying OBI reports, HTML reports.

Responsibilities:

Support in requirements gathering from the end users who work at Loan department.

Involve in Application Design, Code development for the Web based application.

Update design documents according to the changes made to the application.

Design forms using Master Page in ASP.NET.

Coding using C#of all layers- UI, Business and Data Access Layer to implement MVC architecture.

Worked on ASP.NETAjax for partial page updates and paging.

Developed CascadingStyleSheets (CSS) for User Interface uniformity throughout the application.

Developed Javascript code for client side validations

Involve in creating UI Components with all necessary validations and styles.

Code SQL Stored Procedures and integrated with application.

Use Web Services for Credit Card Verification for Bill Pay system.

Used Microsoft Source Control Version (SVN) for all the source code maintenance needs.

Involve in Unit Testing for the application developed using test cases.

Environment: ASP.NET, C#, VB.NET,SQL Server 2008, Visual Studio 2010, .NET Framework 3.5.

Company Name: Pfizer pharmaceuticals, Groton, CT May 2010 – October 2011

Role:.Net Developer

Description:

EHIS is an SOA compliant software package developed using web services. The package covers all administrative, patient tracking and reporting activities. Package includes functionalities for Treatment, Billing and Pharmacy.

Responsibilities:

Involved in Design, Coding, Testing and Implementation of the application.

Design and develop the GUI, Business Logic Layer and Data Access Layer.

Implemented the project using n-tier architecture with presentation tier (ASP.NET).

Business Tier (C#) and backend database tier (SQL Server).

Developed WinForms using C#.Net in Visual Studio .Net 2005

Created Tables, Views, Indexes and Relations using SQL Manager and created Stored Procedures and triggers for automated operations.

Used Visual Studio.NET debugger and ASP.NET functionality to debug the application.

Used ADO.NET Connection, Command, Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in SQL Server 2005.

Created Web User Controls and Custom Controls.

Environment: C#, ASP.NET, .NET Framework 2.0, Winforms, ADO.NET, Visual Studio.NET 2005HTML, JavaScript, CSS,SQL Server 2005

Company Name: Snap deal, Delhi, India December 2008 - April 2010

Role:.Net Developer

Description:

Designing a new online store website with all products and implementing gateway for secure payment.

Responsibilities:

Involved in Requirements Analysis for the application development and Production issue fixing.

Preparing PRD for new requirements and modifications in existing features.

Developed CMU web and windows application using .Net Framework 4.0 C#, ASP.NET.

Developed Windows service to read data from TCP port and process the data as per the protocols and save it to data base.

Developed windows service to transfer data between different services.

Testing and documentation throughout project Development Cycle.

Involved in database design and development.

Responsible for creating the tables, Views, Functions, Jobs using Oracle10g.

Responsible for deploying application on client servers.

Responsible for fixing deployment Issues on client servers.

Used Log4Net DLL for application level error handling.

Used Tortoise SVN for version controlling.

Environment: Windows 2008 server, Windows 7 Operating System, 3-tier architecture, Windows Services, ASP.NET, VB.NET,.NET 4.0 IDE .

Company Name: Myntra, Pune, India January 2007 – November 2008

Role:.Net Developer

Description:

This website contains cart, user management, order management, order tracking, product management, and place order without creating account and with account. Iron Clad website is integrated

with their inventory system.

Responsibilities:

Involved in gathering the System Requirements.

Used JavaScript and CSS in web pages for user customization of page background and styles.

Implemented user controls and utilized visual inheritance to create consistent views

Detailed design of ASP.NET Master Pages with more than one content place holder to give the consistent look and feel for the website.

Created ASP.NET content web pages that inherit from master page.

Developed XML-XSLT Transformations to display dynamically generated information.

Implemented product stock management on website and create product stock reports. If any product is out of stock or less the preferred quantity then it comes in admin notice and get email on that.

Involved in Database Table design along with development of stored procedures, Triggers, Views and Indexes for tables.

Documented technical and flow diagrams

Environment: NET Framework 2.0, Visual Studio 2005, C#, SQL Server 2005, ADO.NET 2.0, T-SQL, IIS, XML, XSLT, XSD, Visual SourceSafe

Contact this candidate