Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Lincolnwood, IL
Salary:
110k/annum
Posted:
June 18, 2015

Contact this candidate

Resume:

Radhakar Ghimire

773-***-****

Email:acqavc@r.postjobfree.com

Professional Summary

Around 6 years of IT experience with hands-on experience in working in the Complete Development Life Cycle (SDLC)of Agile Development methodologies (i.e., Rational Unified Process, Extreme Programming, SCRUM and agile SCRUM) using latest Microsoft technologies like .NET Framework 3.5,4.0, and 4.5,

B2B integration and collaboration which delivers a significant return on investment by Solving Direct ServiceGrid which helps the business process network for service integration to realize the goals of an effective multisourcing strategy. Strong technical expertise on CRM in order to identify relevant client’s needs and best service to Customer. Experience with ERP concept in internal application in corporate level.

Extensive experience in developing applications using .NET Framework 2.0, 3.0, 3.5,4.0,4.5

Experience in developing applications using VB.net, VB.net Batch Program, ASP.NET, C#.NET, Win Forms, ADO.NET, Visual Basic 6, Web Services, XML/XSLT, HTML4/5,CSS2/3, JavaScript(, Java Script(Knockout.js, Angular.js.Backbone.js and Note.js,)JQuery, Entity Framework5.0/5.1, ASP.NETMVC3.0/4.0, AJAX, LINQ, LINQ-To-SQL,,WWF,WPF and WCF with 3-Tier architecture.

Able to handle SOAP message from clients and return SOAP response by using SOAP envelope with secured process.

Knowledge of LINQ(Language Integrated Query) by retreiving data from various data sources.

Strong technical expertise in developing applications using Web Technologies - ASP.NET, VB.NET, C#. NET, Web Services, Win-forms, WCF, WPF, IIS, Visual Studio. NET, jQuery, and JavaScript.

Created and deployed XML Web Services using ASP.Net and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Experience in writing Database Queries, writing Complex stored Procedures, Triggers, Cursors, Functions, Views in MSSQL Server (Transact SQL) and well familiarity with oracle Database(Oracle eBS).

Strong Object Oriented (OOPS) programming skills, SOA, and as extensively used C# to develop the middle tier of the applications.

Advanced knowledge in using .net data validation controls, caching objects, and session objects.

Having good skill and experience in performing both Unit and Integration testing.

Experience in working in Visual Source Safe (VSS) and Tortoise SVN environment using them as the Source control.

Strong analytical skills with proficiency in debugging and problem solving

Used Crystal Reports for report generation and integration into .NET applications.

Experienced in utilizing the new integrated features of ASP.NET versions like Windows Communication Foundation (WCF/Rest), Win-forms/DevExpress Winforms, WPF and MVC.

Profound knowledge of developing and consuming XML Web Services.

Hands on experience on AJAX Web browser technology to achieve Partial Rendering and to improve the Response Time.

Proven ability to plan, manage, motivate, and work efficiently in both independently and collaboratively in a team effort

Exceptional ability to master new concepts and capable of working as a Team, as well as independently.

Excellent in communication, analytical and presentation skills.

Technical Skills:

.NET Technologies

ASP.NET3.0/4.0 C#.NET, VB.Net, WPF,WCF, Win Forms, Web Forms, Web Services, Silverlight, XML, LINQ, Entity Framework5.0/5.1, AJAX, ADO.Net, VB scripting, ASP.NETMVC 3.0/4.0

Web Technologies

Web Services, AJAX programming, HTML4/5, Java Script(Knockout.js, Angular.js.Backbone.js and Note.js), JQuery, CSS2/3, Windows forms/DevExpress Winforms,ASP.Net, WCF,WPF and WF

Database Servers

MSSQLServer2005/2008/2010/2012, Oracle9i/10G/11G (PL/SQL) With Oracle eBS, MS Access, JSON, and JQUERY, CognosBI and Team Foundation Server2010/2012.

Operating Systems

Windows 98/2000/XP/Vista/Windows 7/Windows 8

IDE / Utilities

Visual Studio .NET 2003/2005/2008/2010/2012

Source Control Tools

MS Visual Source Safe (VSS), Team Foundation server (TFS) Tortoise SVN, Adobe Flash, SharePoint(2007,2010)

Design Patterns

MVC, MVP, Singleton

Professional Experience :

Integrys Inc. October, 21, 2013 –till now

.NET Developer

Chicago, IL

Project Description:

Designed and developed in Integrys Phone Number Interface Batch Programming. This project was developing using Microsoft .NET Technology. The Project includes main two modules Customer services (End User) and Internal Application (Batch Programming). Two Modules were developed in ASP.Net (VB.net).

Responsibilities:

Designed and developed the VB.net components for implementing business logic in middle tier in 3-tier application interacting with SQL Server database using Managed provider using ADO.NET. Enabled to use WPF application to prepare the end-user application.

Provided analysis and enhancements to existing CRM application to identify relevant client’s needs and best service to Customers. Enabled use of CRM concept in design reviews, and ensured design meets functional and operational requirements.

Provided technical expertise analyzing, setting strategy, and supporting B2B Integration by creating data, and process modeling work. Interviewed business/trading partner representatives to gather requirements and map its needs. Converted business requirements into technical requirements related to Mapping/User Exits/required Functionalities. Created functional and detailed technical specifications. Documented process flows and data flows. Created test scenarios and Unit testing for new functionalities. Executed test cases, performed system, and integration testing as well as documented testing results.

Used VB.Net form to complete the Data access layer Components.

Developed Crystal Reports to generate various reports like consultation follow up, all different companies under the Integrys.

Used web methods in Xml Web Services to retrieve specific detail level information.

Implemented Form Based authentication and Role based authorization to authenticate users.

Retrieved the data from the data sources such as Microsoft SQL Server and Xml files and connected it to Web forms for manipulating the data using ADO.NET Technology.

Developed SQL queries, Stored procedures, Functions, triggers to handle the business rules, data integrity and for various data transactions.

Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like MS Excel, MS Access, and Oracle.

Version and Source control was maintained using the Team Foundation Server.

Coded using XSLT in generating customer listtaking the data from XML document and formatting with XSL.

Performed extensive Unit testing using N-Unit.

Used SharePoint tool in order to handle intranet, content management (core) and document management based on business need.

Environment: Visual Studio 2012 VB.NET, ASP.NET, ADO.NET, HTML4/5, DHTML, CSS2/3 Win-form, WPF, JavaScript, Microsoft, XML Web Services, XSLT, IIS 6.0, SQL Server 2010,N-Unit, VSS, Crystal Reports, and TFS.

Accenture Inc. Services, July, 25, 2013 – August, 30, 2013

.NET Developer

Chicago, IL

Project Description:

Designed and developed in Accenture Printers2.0 Application Services (Printers2.0 project). This project was developed by using Microsoft ASP.NET MVC 4.0 DOT-NET Technology by C# programming Language. The Project includes mainly Code first approach with Entity Framework 5.1, Java Script (Knockout.js, Angular.js.Backbone.js and Note.js),Jquery, and SQL Server Management Studio.

Responsibilities:

Designed and developed the Accenture Printer’s Business logic by creating models of County.cs, FloorInfo.cs, OwnerInfo.cs, and PrinterInfo.cs for implementing business logic in middle tier in 3-tier application interacting with SQL Server database using Entity Framework 5.1.

Involved in enhancements, design reviews, and ensured design meets functional and operational requirements to create DbContexts, IDbContext, and PrintersDbContext.

Provided technical expertise in setting strategy Converted business requirements into technical requirements related to /Mapping/UserExits/required Functional, Documents process flows and data flows, Testing(Unit testing and Mock testing) scenarios for new functionalities Used standard tools and execute and document system testing and integration testing by understanding and utilizing of the SDLC process.

Retrieved the information of the Countries (from Countries DropDownList), Facility (from Facility DropDownList), and Floor ((from Floor DropDownList), that are located in particular Country, Facility, and Floor. Applied the GetFloorInfo, GetPrintersInfo, GetOwnersDetails, Set FloorsInfo, SetPrintersInfo, Activate floor, Facility and Country, and Detail Views of Homepage, Floor page, Countries page by using asp.net mvc ActionLink, Html helper, and linking to area methods.

Used MVC 4.0 with Entity Framework to enable the full control over the rendered HTML by Using Code first approach, and provide clean separation of concerns (SoC) and used CSS2/3 for designing of UI.

Implemented Admin and Superadmin where admin can access only assigned floor, admin role is assigned by SuperAdmin but SuperAdmin can access every floor.

Retrieved the data from the data sources such as Microsoft SQL Server,

Manipulated the data using Ado.net Technology with Entity Framework.

Retrieved complex data with easier way by using Jquery/JSON.

Developed SQL queries, Stored procedures, Functions, triggers to handle the business rules, data integrity. and for various data transactions.

Version and Source control was maintained using the Team Foundation Server 2012.

Performed extensive Unit testing using N-Unit and mock testing.

Environment:- Visual Studio 2012 VB.NET, ASP.NET, ADO.NET, HTML4/5, DHTML,CSS2/3 Win-form,WPF, JavaScript, JSON, Jquery Microsoft, XML Web Services, XSLT, IIS 6.0, SQL Server 2010,N-Unit, VSS, Crystal Reports

GE Capital Health Care Financial Services, May, 31, 2010 – July, 20, 2013

.NET Developer

Chicago, IL

Project Description:

Designed and developed in GE Capital Health Care Financial Services (Digital Cockpit project). This project was developed using Microsoft DOT-NET Technology. The Project includes main two modules Commercial Finance and Equipment finance. Two Modules were developed in ASP.Net and C#.Net. The Commercial Finance and Equipment finance has also in side different child Categories. GE is investing the Money in Global wise. Enabled to use WCF technology among the clients to communicate services globally.

Responsibilities:

Designed and developed the C# components for implementing business logic in middle tier in 3-tier application interacting with SQL Server database using Managed provider using ADO.NET.

Involved in enhancements, design reviews, and ensured design meets functional and operational requirements in both existing/new applications.

Provided technical expertise in setting strategy for B2B Integration by creating data and process modeling Work with the business/trading partner representatives to gather requirements and map it needs. Corrected data, updated application programs, and modified user workflow where appropriate in this application.

Used XAML while working with WPF.

Developed Crystal Reports to generate various reports like consultation follow up, nursing notes and integrated with ASP. Net.

To retrieve the information of the patients, staff, physicians who are in particular city for that we have used the Get Patients Details, Get Staff Details, Get Physicians Details web methods in Xml Web Services.

Implemented Form Based authentication and Role based authorization to authenticate users.

Retrieved the data from the data sources such as Microsoft SQL Server and Xml files and connected it to Web forms for manipulating the data using Ado.net Technology.

Developed SQL queries, Stored procedures, Functions, triggers to handle the business rules data integrity and for various data transactions.

Used WPF with combination of Animation controls (color, double), Transformations for creating different animated scenes.

Created WPF applications that combine documents, media content and application UI.

Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like excel Access and Oracle.

Version and Source control was maintained using the Visual SourceSafe.

Coded using XSLT in generating patient’s listtaking the data from XML document and formatting with XSL.

Performed extensive Unit testing using N-Unit.

Used WCF technology to communicate between services by creating endpoints.

Performed analysis frequently, and handled troubleshooting of data utilizing stored procedures, ad-hoc sql queries in this application.

Environment:-Visual Studio 2005,C#,WPF,VB.NET,ASP.NET,ADO.NET,HTML,DHTML,WebForms,Win-form/DevExpress, JavaScript (Knockout.js, Angular.js.Backbone.js and Note.js) (, Microsoft, XML Web Services, XSLT, IIS 6.0, SQL Server 2000,Windows 2003,N-Unit,VSS, Crystal Reports 9.

State Farm Insurance, May, 1, 2009– May, 30, 2010

.Net Developer

Chicago, IL.

Project Description:

State Farm Insurance is provider of auto, health, home and life insurance. Health Insurance Management System (HIMS) is fully automated and integrated application for managing the Policy plans, Agent Commission, Incurred but not Paid and Settlements. This Insurance Management System gives information of the client, policy details and premium rates and monitors the policies for delayed payments. It manages different claims per policies, claim settlements and allows coverage verifications.

Responsibilities:

Involved in object oriented analysis and design using UML (Unified Modeling Language) techniques such as use case, activity, sequence, class and component diagrams using Visio.

Developed the application using C#, ASP.Net, and JavaScript with SQL Server as the back end.

Silverlight unlike ASP.NET, runs on the client’s machine via the plug-in .The plug- in i.e. the runtime is the Silverlight specific CLR that manages the execution of the Silverlight application on the clientside, within the browser.

Designed user interface for Win-form/DevExpress and implemented application logic using C#.Net

Implemented WPF to create attractive and effective user Interface using XAML Document.

Used Dependency properties which are registered with the WPF property system that implement Value Expressions, Styling, Data Binding, change notification,

Developed .Net classes for Data Access layer using Data Access Application Block.

Developed and consumed Web services for getting health insurance premium quotes, Medicare Supplement Rate quotes, county codes etc.

Designed and developed reports using Crystal Reports for HIMS modules that are designed to take parameters for query, export into PDF/Excel/Txt formats.

Implemented .Net classes for Business logic Layer using C#.

Developed tables, stored procedures, views, functions and triggers to perform automated rules, updating to related tables in SQL server 2005/2008.

Implemented GUI using HTML, XML, Web Form Controls to create web pages, developed Master Pages.

Performed Code Reviews (manual) to implement performance and coding conventions guidelines.

Created application level Error Log utility to log all the errors for effective solution for help desk.

Used Visual Source Safe for version management process.

Environment: Visual Studio 2010, Win-form WPF,Net framework 3.0/3.5, C#, ASP. NET, SQL Server 2005/2008 AJAX, XML, XSL/XSLT, Web Services, SOAP, WSDL, JavaScript, Web Forms, HTML, Crystal Reports, Visual Source Safe

Philadelphia Corporation for Aging Dec 5, 2008-Apr, 28, 2009

.Net Developer

PA

These are Assessment tools used by Assessors/Care Managers/Investigators, Nurses and Supervisors of various departments. The tool is deployed on the laptops for the Assessment workers/Care Managers. The Nurses and the Supervisors access the server version. If connected to the Network, the tool works on Oracle 10g Database and in the field it works on MS Access. Assessment workers checkout cases on laptops via XML web service. Fill out the information in field and check the case back in for approval. Nurses and Supervisors approve the case and then the consumers get the requested services.

Responsibilities:

Involved in complete Life cycle (SDLC) of the project.

GUI development using ASP.Net for Web forms.

Created several winforms using C#.NET, ADO.NET, SQL server, WCF.

Writing code in both code behind and web interface.

Created Web User Controls to achieve maximum code reusability.

Created generic class module to Load/Save/Validate data in the application and achieved maximum code reusability.

Involved in writing complicated queries compatible with both Oracle and Access database.

Involved in writing Stored Procedures, Database Triggers, Views and Transactions handling in Oracle.

Involved in writing complex checkout program from Oracle to Access and checking from Access to Oracle database.

Worked Extensively on Creating and Calling XML Web Services used for checking In/Out consumer information, power to solve every distributed application problem, they were an easy way to create and consume services over the Internet by considering the goals for Web Services, to allow companies and developers to share services with other companies in a simple way over the Internet.

Error Handling, versioning of application.

Designed and created complex crystal reports using ADO.NET (XML).

Deployment and Distribution of application.

Role also requires communicating with and supporting business users and troubleshooting their issues within critical time limits.

Environment: ASP.net, IIS 5.0, Oracle 10g with Oracle eBS, MS Access, Crystal 9.0, ADO.net, Web Services, XML, XSD, Java Script, VB Script, Style Sheets.

Compuscan, Feb, 15,2008- Nov,25,2008

.Net Developer

Dallas, TX.

This application obtains input from various systems pertaining to portfolio holdings and returns, market FX, interest rate and volatility data; then using some specialized ideal hedge calculations, determines suitable trades to optimize the accounts' returns.

Responsibilities:

Was actively involved in requirements gathering and to create a Functional specification and Technical Design Document

Developed ASP.NET web application in C# which will communicate business logic components and then connect to database via Data Access Components

Implemented business logics in C# assemblies related to business layer and data layer

Created an Impact Analysis document for each change request and estimate the timing for change request.

Involved in optimizing various complex queries in oracle SQL Server and hands on experience with Oracle eBS.

Created XML Web services using C#, XML and SQL Server

Created and Maintained SQL Stored Procedures, Function in SQL Server 2000

Created the Reports and given in the format of PDF using PDF .SDK

Involved in Code Review and Maintained the Quality Records

Generate periodic status reports on this vertical for review by management

Environment: C#, ASP.NET, XML web services, Win-form, Crystal Reports, Visual Studio.NET 2008, SQL Server 2008

Education:

Robert Morris University, Chicago, Illinois

Master Degree in Information System

Trivhuwan University, Rampur, Nepal

Bachelor Degree in Science.



Contact this candidate