Sql Server .Net
Resume:
HEMANTH
acr8wn@r.postjobfree.com
SUMMARY OF EXPERIENCE:
Over 7+ years of extensive programming experience in Visual Studio.Net using C#, VB.NET,ASP.NET,WCF,WPF, Silverlight,ADO.NET,ASP,VB6, XML, ASP, JavaScript, JQuery, XSLT, HTML, XHTML, DHTML, Web Forms, Web Controls, Win Forms and Microsoft SQL Server, Oracle 8i/9i/10g.
Professional experience in all phases of Software Development Life Cycle (SDLC) from Requirements gathering, analysis, design, development, documentation, Testing, Implementation, Deployment and maintenance of various Web Based and windows applications.
Experience on working with Windows Communication Foundation (WCF), Windows Work Flow Foundation (WWF) and Windows Presentation Foundation (WPF) in .NET 3.0/3.5.
Developed Applications, using the .NET Framework 3.5 and Windows Presentation Foundation (WPF).
Understanding and experience in Design Patterns like FACAD, Singleton and Factory on a Multi-tier architecture environment.
Experience in using Multithreading, Serialization, Shared Assemblies, Garbage Collection and IIS.
Extensive knowledge of WCF (Windows Communication Foundation), WPF (Windows Presentation Foundation) and LINQ (Language Integrated Queries) in ASP.NET 3.5
Extensively used Ajax and Ajax Tool kit for UI developing
Implement N-Tier Architecture and integrate the UI with Data base using ADO.Net concepts.
Strong experience in Object Oriented Programming (OOP) and methodologies.
Experience in creating and consuming XML Web Services, XML Schema (XSD), SOAP, WSDL and DISCO.
Experience in Working with Software Configuration Management using Microsoft Visual Source Safe (VSS) and Visual Studio 2005 Team Foundation Server (TFS).
Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS using Microsoft Business Intelligence Development Studio (BIDS)
Designed and Implemented Reports using Crystal Reports and Microsoft Report viewer, SSRS(rdlc)for report generation, integration into .NET applications
Performed N-Unit Testing for the piecewise testing of the Applications
Proficient in writing Unit Test Cases for Business logic, Web services and WCF.
Experience in securing web applications using ASP.Net authentication and authorization mechanisms.
Have hands-on experience in Configuring IIS and component services.
Good knowledge and experience in implementing Model view controller (MVC) architecture into client server and distributed systems.
Good Knowledge in ASP.NET MVC Web API and Angular JS to develop an application for performing CRUD operations.
Create, modify, and delete SharePoint accounts as directed and in compliance with all standard operating procedures and Configure SharePoint services and settings.
Designed CSS3 and HTML5 in the front end for desired look.
Proficiency in designing & implementation of new ERP systems / procedures to enhance overall efficiency of the Organization.
Extensively used ASP.NET 4.5 for Web Applications with WebSockets.
TECHNICAL SKILLS:
Programming Languages:
C#, VB.Net, SQL, T – SQL, PL/SQL, XML, XAML,DHTML, HTML, LINQ, ASP.NET, AJAX, C, C++,Cobol.
Web Technologies:
ASP.NET, AJAX, Web Services, CSS, JavaScript, HTML, VBScript, ASP, .Net Remoting, WPF, WCF,Silverlight,.Net Nuke, Site Core,VB6,Angular JS,JQuery.
Data Base :
SQL Server 2008/2005/2000 (T-SQL, Stored procedures, Triggers, DML, DDL, DTS, SSIS), Oracle9i/10g, MS Access Middleware, ADO.NET, ActiveX, DLL.
Protocols:
SOAP, SSL, FTP, TCP/IP, HTTP.
Reporting Services :
Crystal Reports, SQL Server Reporting Services (SSRS),
Application Tools
Visual Interdev 6.0, Visual Studio 2008/2005, Front Page, SQL Enterprise Manager, SQL Management Studio, TFS
Operating Systems
Windows Server 2003, XP, Windows NT / 2000.
Servers
Enterprise Servers IIS Server, Commerce Server, Content Management Server.
PROFESSIONAL EXPERIENCE:
Computer Aid Inc., Harrisburg, PA July 2015 – Present
.Net Developer
Claim Analysis Review and Tracking system this project which enables all the users to track the lifecycle of a claim. Information that is captured in the CART system can be accessed by anyone who has access to the CART system depending on their role.
Responsibilities:
Involved in gathering information from clients and analyzed the information and provided with the best solutions which meet client's requirements.
Good understanding of AGILE methodology with Scrum meetings. Completing the tasks in timely fashion with respect to each individual Sprint.
Created login-based members area that displays ASP.NET MVC web pages based on access levels and assigned Roles.
Utilized the advantage of Telerik controls (Grid View, Charts, Menu strips, Tab strips) in designing interactive Dashboard charts.
Worked with LINQ to Entity for querying the database.
Implemented Caching, Session State, and Cookie Management, view state, POST and GET techniques.
Involved in creating web site pages using AJAX, JavaScript, JQuery, HTML 5.0, bootstrap and CSS.
Used AJAX Toolkit to Update Web Control, Data Binding based on user selection with partial post back and made UI more interactive and user friendly.
Created Various reports using SSRS, Report Viewer Control and RDLC reports for client side rendering
Implemented Client side and server-side validations done using JavaScript and Validation Controls using AJAX calls.
Developed Stored Procedures, Triggers, and Views in SQL Server 2012 for accessing the database.
Enhanced the applications performance by constantly monitoring the queries by running Execution plans and query optimization techniques in SQL server.
Involved in fixing the bugs and Test Cases for the application
Used Visual Studio Business Intelligence Tools to create SSRS reports
Developed WCF Service to get the information from the database and Worked on Data Contract, Operation Contract, Service contract, Endpoints, Binding etc.
Implemented Web API to use in the application for critical operations and populate the JSON, XML type data to controller
Environment: Microsoft .NET Framework 4.0, Visual Studio 2013 Team Foundation Server, MVC, C#.NET, Entity Framework, Enterprise Library 5.0, Ajax and JavaScript, JQuery, WCF, HTML5, CSS3, SQL Server 2012
TPG Capital, Fort Worth, TX April 2013 – May 2015
.Net Developer
TPG Capital is one of the largest private equity investment firms globally, focused on leveraged buyout, growth capital and leveraged recapitalization investments in distressed companies and turnaround situations.
This project focuses on the systematic investigation of the root causes of identified problems or risks in an attempt to prevent their recurrence (for corrective action) or to prevent occurrence (for preventive action).
Responsibilities:
Worked with Business users and Analyst on understanding the requirements.
Developed Code-behind using C#.NET, involved in code reviewing as well as bug fixing in the application
Worked on different modules (Application Thread, Member Thread & Admin Thread) of the Web Application in all different phases of SDLC.
Good understanding of Agile methodology with Scrum meetings. Completing the tasks in timely fashion with respect to each individual Sprint. Task completion in respect to Design, business logic as well as the Test cases in a sophisticated manner.
Designed WCF model for building secured and reliable web services for accessing the data across the real time interfaces.
Used SharePoint 2010 for project document collaboration with in the team
Developed various user controls to enable reusability across the application.
Experience on ASP.Net Validations like Custom Validator, RequiredField Validators, and Regular Expression valuators, across the web application.
Thoroughly worked on AJAX for Client-side and Http Handlers (.ashx) files for Ajax implementation in the user controls/Web pages.
Dealt with many JQuery concepts like JQuery Date Picker, Accordion, JQuery Table sorter, etc.,
Extensively worked on Repository Framework in Data Access Layer with respect to Database operations (CRUD) which encapsulate the Entities generated at Business layer
Strong working experience in Repository Unity Container Pattern (Entity Framework) and its implementation over the Business and Presentation layers.
Generated the Entity Data model (.EDMX) and associating the POCO entity Objects.
Incorporation of UI validation as well security models using Enterprise Library 5.0
Worked on the Master pages and Cascade Style sheets ( CSS ) for achieving uniformity in application
Used Report viewer to integrate the SSRS reports with the ASP.Net Web Forms.
Deployed web applications to IIS on various servers using MSDeploy.exe and Team Foundation Server
Implementation of Data binding through Repeater, Form View and Grid View through Entity Data source, Object Data source as well as LINQ Data source.
Working on enterprise library integration with respect to Validation and Security frameworks. Also had efficient working knowledge of Exceptional handling implemented through Enterprise Library 5.0
Worked on the .NET Framework 4.5 to develop complex Web Applications.
Used LINQ queries to filter data set that is obtained from complex stored procedure, views, functions and Entities in the repository Layer.
Extensively used LINQ to objects and Lambda expressions
Efficiently worked on Visual Studio 2010 Team Foundation Server (TFS) with respect to Collaborative development as well as Source controlling with Gated/Un-gated check in models
Developed T-SQL queries, Stored Procedures, Functions &Views using SQL Server 2008 SSMS.
Coordinated with different teams, QA, Operations and DBA's for project completion and deployments.
Involved in N-Unit Test cases for UI as well as Repositories created.
Recent intensive project experience in Silverlight and WPF (Windows Presentation Foundation) development including front designing in Microsoft Expression Blend and back programming in Microsoft Visual Studio.
Developed MVP patterns and its implementation in ASP.NET Web Forms and experienced with MVC Framework.
Environment: Microsoft .NET Framework 4.0, Visual Studio 2010 Team Foundation Server, MVC, C#.NET, Entity Framework, Repository Framework, Enterprise Library 5.0, Ajax and JavaScript, JQuery, WCF, HTML/DHTML, CSS, SQL Server 2010, SharePoint
UNITED HEALTH CARE, Atlanta, GA. August 2011 - March 2013
.Net Developer
This is a health insurance program which provides needed health care services for people. It includes modules such as Registration Management, Billing, Financial Accounting, Fixed Assets, Payroll, Outpatient Management, Inpatient Management, pharmacy, General Stores, laboratory, User Manager etc.
It provides for enquiries about the patient such as patient's location, admission, and appointment scheduling and discharge details. Furthermore, this system even takes care of package deals for a patient for a fixed cost.
Medical Record keeps an abstract of clinical data about patients. It allows easy for a patient for a fixed cost.
Responsibilities:
Developed N-Tier application with UI in the presentation layer, Business logic in the middle layer and ADO.Net in data access layer by using C# as the programming language and SQL Server as the backend.
Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, Configuring optimizations and securing the web application.
Implemented Get, Post by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.
Customized SSRS reports to specific business requirements need by using SQL Reporting Service.
Created custom User controls by overwriting the existing properties of the Infragistis components.
Developed custom Web Application Systems by using C#, SQL Server for supporting end users operations of small and medium businesses.
Integrated other web application with Web Services, WCF and SharePoint Object Model.
Custom templates include couple of static HTML pages for Mobile and Desktop knockout views as item templates that will serve as client side view in MVVM pattern.
Imported and migrated data from old legacy systems into Microsoft SQL Server using C#, SSIS packages.
Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization.
Performed CRUD operations with WCF Restful services using WebGet, Web Invoke.
Worked extensively in developing Document Libraries, Picture Libraries, Discussion Boards, and Dashboards.
Provided guidance with support for clients and internal consultants to utilize the System.
Developed interfaces using .NET Pages, Web Services with C#, SOAP and XML.
Used crystal reports plug-in in Visual studio 2010, for showing the statement data of the end user.
Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.
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.
Developed system services SOA application platform for use by all web applications utilizing WCF services.
Provided KT to the support team and coordinated with Operations team for deployments and support.
Used DB2 to create DML procedures to perform operations.
Refactored, re-architected, and enhanced an existing AngularJS application to follow strict MVVM/MVC patterns for improved source code maintenance.
Environment: Visual Studio2010, .Net Framework, Infragistis, Web Services, C#.NET, ADO.NET, SQL Server,DB2, IIS 6.0, SSIS, XSD, SOAP, JavaScript, WSDL, XML, HTML, N-unit, AJAX Toolkit, CSS, SharePoint.
HITACHI, Dallas, TX Nov 2009 - August 2011
.Net Developer
A Recruitment Module developed to cater to the needs of Project Managers and Leads to recruit resources for their projects. The resources could be from either within the organization or new hires based on the availability in open market and skill set.
Responsibilities:
Implementation of the process workflow and business logic using C#. Net
Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database
Created .NET User Controls and Client-Server Validation Controls using ASP.NET, C# .Net and JavaScript
Worked on Business logic layer
Extensively worked on creating Windows GUI and Web interfaces using windows controls, user controls and sever controls
Created Various reports using SSRS, Report Viewer Control and RDLC reports for client side rendering
Implemented Windows Service for loading data from xml files to the Oracle database using serialization
Developed code for importing excels data to Oracle database with SSIS and SSAS
Extensively used Array List, List View to display data in the grids
Implemented validation using ASP.Net validation controls
Used .Net Data grid control to display, edit and page, and sort multiple records
Created database Stored Procedures, User Defined Functions and Packages
Tuned the existing application Stored Procedures for improving the performance
Used TFS for versioning and source code check in and check-out
Involved in Code reviews and guided team members for technical problems
Used several .NET AJAX controls to dynamically render the content on WebPages developed using C#
Ported previously used DAL (Data-Access-Layer) wrapper written in C++ into .NET classes using XML entity descriptions and mapping metadata with attributes
Used Http Watch to monitor and intercept various HTTP and HTTPS requests
Used ReSharper to help assist with Intellisense and provide preconfigured tools for N-Unit testing.
Creating applications using VB.NET and enhancing projects for .NET applications and Implemented changes in coding and designs using knowledge of VB .NET
Worked on project-based directives for client CRM environments and performed troubleshooting of client CRM issues and maintained documentation of all reported issues.
Environment: C#.Net, Winforms, ADO.Net, WPF, ASP.Net,.Net 2.x/3.x, Oracle 10g, SSIS, SSRS, IIS, XML, JavaScript, HTML, Vault, Reporting Services, Windows Services
ADITYA INFOTECH, Hyderabad, INDIA June 2007 – July 2009
.Net Developer
This project involved the undertaking of a PRM (Prospect Resource Management) an end to end Marketing tool. It is used for managing intensive marketing activities to businesses in need of productivity software. The system tracks all sales and marketing activities to ensure that up-to-date information is readily available for all prospects.
Responsibilities:
Collect and analyze requirements from the clients to design suitable software for them.
Built on a custom framework using C#, Win Forms, Web Services, .Net Remoting, ASP.Net, MS Transaction Server, and SQL Server 2000.
Developed the Use case diagram, Activity diagram using Rational Rose 2000e during the requirement-gathering phase.
Program client side and server side validations using _JavaScript and regular expressions.
Code the application in C# using ASP.NET including textboxes, combo boxes, data grids, tree viewcontrol, buttons, validation controls, and image buttons and zooming.
Implemented Business logic using C#.
Use ASP objects like Request, Response, Query string, Server and Application.
Worked on View State to maintain data between the pages of the application.
Developed and Used User Controls using C# and ASP.NET.
Wrote class library for Database Access layer using C# and ADO.NET.
Designed user control for re-use of UI functionality.
Identify and create indexes and stored procedures in SQL Server.
Developed client modules for retrieving, inserting and updating record from the database.
Designed the database and created tables, stored procedures and views using SQL Server 2000.
Directly accountable for various aspects of product design including assessment, coding, testing and optimization. Involved in code review and performance improvement as well as documentation.
Environment: C#, ASP.NET, .NET 1.1/ 2.0, HTML, JavaScript, CSS, Win Forms, .NET Framework, .NET Remoting, ADO.NET, XML, Web Services, SQL Server 2000, Windows 2003, IIS, VB.NET, Visual Studio .NET
Contact this candidate