Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Washington, DC
Posted:
July 22, 2016

Contact this candidate

Resume:

Hari Pokhrel

SUMMARY

*+ years of experience in Analysis, Design, Development, Support & Maintenance of Software applications.

Experience in developing web applications using Microsoft .NET Framework, C#.NET, ASP.NET, Sharepoint, AJAX.net, JQuery, WCF, Web services and SQL Server 2005/2008/2010/2012.

Extensive experience in creating rich content Web-Forms, Win-Forms (Windows Forms), Web User Controls, Custom Control, Server Controls, Windows Service and Web Service.

Experience in Design, Development and Implementation of High-Performance, Scalable, Distributed web applications using Microsoft Technologies.

Experience in Software Development Life Cycle of Client/Server applications using Agile/Scrum Methodology.

Experience in Test Driven Development (TDD) and Continuous Integration.

Solid understanding of N-Tier architecture, Object Oriented Design & Development.

E+xperience in MVC (Model View Controller), Creational, Structural & Behavioral design patterns.

Familiarity in building Web Services using WSDL, UDDI and SOAP Protocol and .NET Remoting.

Knowledge of data access methods like ADO.NET, ADO, ODBC for JET and Relational databases.

Proficiency in developing XML applications using DTD, Schema, XSL.

Good experience in Java Script, JQuery, HTML, IIS and CSS.

Hands on experience in SQL Server database design and development of Tables, Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers and User Defined Functions and Expertise in programming with TSQL.

Experience working in environment like Active Directory/Windows 2003/2008 R2.

Experience in Configuration Management Tools like Microsoft Visual Source Safe, SCM Clear Case & TFS.

Experience in report generation tools like Crystal Reports & B2Win.

Excellent communication and interpersonal skills.

Highly dedicated, quick starter, solution driven pattern programmer, Strong in Object Oriented Analysis and Design, Excellent at solving complex problems under strict deadlines.

EDUCATIONAL QUALIFICATION

Master of Computer Science, Stratford University, VA

SKILL SET

.Net Technologies and Related Tools

.Net Framework 1.x/2.0/3.x/4.0, VS.Net 2003/2005/2008/2010, C#.Net, ADO.Net, ASP.Net, AJAX, LINQ, WCF & Web Services.

Prog. Languages and Applications

C#, C, Baan 3gl/4gl, Open World, B2Win.

Web Technologies

ASP.Net, ASP, HTML, XML, SOAP, Sharepoint, JavaScript, JQuery, CSS.

ETL Tools

DTS & SSIS.

Reporting Tools

Crystal Reports & B2Win.

Databases

SQL Server 2005/2008, Oracle, MS-Access.

Operating Systems

Windows Family and Unix.

Application Servers

Microsoft IIS.

Other Tools and Software’s

Rapid SQL, Toad, Visual Source Safe, SCM Clear Case, TFS, MS – Office, Lotus Notes.

WORK EXPERIENCE

Project Details

Client: Peace Corps, Washington, DC Senior .Net developer ( Feb 2015 – Till date)

Responsibilities:

Worked in an agile environment to design and develop high quality software application using latest Microsoft .Net technologies such as MVC 4.0/5.0, C# 5.0, Asp.Net 4.5/5 and Jquery Mobile.

Regularly gathered business requirements from the Software support team and developed functionalities as per the requirements.

Built and Consumed SOAP/RESTFUL web services and Implemented WCF applications.

Developed Web API and Web services methods with the JSON Serialization.

Implemented the various State Management techniques like Session, Cache and View state to persist information in .aspx files and between post backs.

Designed and develop application using Visual Studio 2013, ASP.NET, C#.NET, AJAX, XML, WCF, RESTful Service with WCF, JQUERY, JSONand CSS with object oriented programming techniques.

Expertise in building WCF services using REST and SOAP protocol.

Worked extensively with SoapUI, software to test all the web services I wrote.

Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization

Developed licensing feature to allow licensed products to libraries with proper licenses

Used the OOD patterns and SOLID principles like Inversion of Control, Dependency Injection while developing layers in the n-tier architecture

Configure the application to meet requirement using the Microsoft Dynamics CRMCustomization Tool, Workflow Tool, or SDK.

Writing PLSQL queries in Oracle 10g to perform schedules in the meeting module

Connected System manager (configuration application for library admins) to the Cloud library allowing users (library admins) to configure e-books for their libraries.

Extensively used HTML5, BOOTSTRAP, ANGULAR JS and JQUERY and created Single Page Applications (SPA).

Implemented Angular JS data binding and dependency injection.

Experience in Creating services, controllers and modules in Angular JS applications.

Added search functionality to look up resources based on the keywords

Applied localization to encompass the users in multiple countries.

Used version control Team Foundation Server (TFS) for maintaining history of source code, project documents and to track project status.

Implementing Object Oriented design patterns MVC or MVVM as suited for the projects in the solution.

Involved in change management activities for deployment into the production server.

Data Access was developed using ADO.NET with SQL Server store procedures, triggers, views,DDL,DML. performance tuning and SQL tuning and query optimization.

Created generic packages in Oracle to implement and support report generation using email functionality for file exports.

Experience in generating reports using SQLServer Reporting Services (SSRS), creating packages using SQL Server Integration Services (SSIS).

Implimented database design (Physical and Logical Database Design) and Normalization.

Performed root cause analysis and fix issues reported by the QA team.

Environment: .Net Framework 4.5/5, MVC 4.0/5.0 Visual Studio 2013/15, Oracle Pl/sql, C#, ASP.Net, WCF, AJAX, Entity Framework, SOAP, REST, LINQ, HTML, SQL Tuning, Angular JS, JSON, JavaScript, Jquery Mobile, TeamTack, Agile, TFS, Perforce.

Client: IMAGE API, Tallhasee FL .Net Consultant (03/2012 – Jan 2015)

Responsibilities:

Responsible and active in the analysis, definition, design, implementation, management, maintenance and deployment of full software development life-cycle (SDLC) projects.

Customized the .Net template for Project Task assignment, Build Release version control.

Developed application using C#.Net and AJAX under Visual Studio 2010 environment. Extensively used controls such as Data Grid and Data List to populate the records for presentation layer. Extensively used Multi-Threading for fetching data from web services using C#.

Developed User Interface using .NET and extensively worked with win forms using VB.Net and Implemented validation using validation controls and JavaScript client slide validation. Data format using HTML, CSS and client side scripting using JavaScript.

Assisted in physical and logical database design.

Involve in deployed the web application on IIS web server.

Used JQuery and JavaScript to implement AJAX calls and other type of client side logic.

Worked on Data Access layer with dataset and data adapter which interacts with SQL Database. Also Worked with SQL Server Reporting Services (SSRS) for providing comprehensive reporting functionality for variety of data sources.

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

Writing functions, stored procedures and views using PLSQL tool in Oracle9i

Experience in Agile Methodology for full life-cycle of the project such as planning analysis, prototyping, design implementation, testing, release and following for next iteration as per needs.

Involved in development of WebForms, classes using ASP.NET MVC 5.0 that incorporates both N-Tier Architecture, and Database Connectivity.

Collaborated and coordinated with release management, change management and incidentmanagement teams to avoid escalations.

Worked on prototyping upgrading entire site to the .NET 4.5 Framework.

Developed a new web application utilizing ASP.NET MVC, HTML 5, CSS and Bootstrap

Used Model-View-Control (MVC) software architecture in web applications to view the html.

Developed the application using ASP.NET 4.0, C#, and MVC 3 in Visual Studio 2010

Configure SQL Server Integration Service (SSIS) for scheduling database backup and Implemented indexing for various tables in the database for improving the performance of the application.

Designed and developed packages to extract, transform and load data using SQL Server integration services (SSIS).

Created T-SQL queries, stored procedures and triggers in the SQL Server 2008 database, along

with DDL and DML.

Experience in Microsoft Team Foundation Server (TFS), and creating different report formats using SSIS.

Database development including schema design, T-SQL queries, stored procedures, Triggers, SQL query tuning and user defined functions creation for SQL server 2005 and 2008.

Used the Code first migration Entity Framework 4.0/6.0 for the use of LINQ-based Data Access.

Extensively applied the Object Oriented Analysis and Design (OOAD) concepts, and used designpatterns like Singleton and Abstract Factory, Model-View-Controller (MVC) architecture framework.

Involved in developing test cases for unit testing, integration testing and also conducting code walk-through.

Experienced in End-to-End Software Development Life Cycle using Waterfall (SDLC), Application Development Methodology (ADM) and Agile Methodologies as well ER Diagram, UML Modeling and Data Flow Diagram.

Create brief technical specification documents according to verbal and written functional requirements and other requirements. Also wrote Design Documents, Deployment Documents and User Manuals. Worked on perform coding, unit testing, error handling, bug fixing, bug verification and created an error log section in which the support/admin will get the error message in a well formatted html view. And troubleshooting in security, remoting, threading, and serialization.

Involved with the CRM team to design Entity relationship between online application and Microsoft Dynamics CRM to integrate application with Microsoft Dynamic CRM.

Involved in development of Complex Queries, Stored procedures and Triggers by using ORACLE9i (SQL, PLSQL).

Environment: NET Framework 4.0, Visual Studio .NET 2010, C#.NET, VB.Net, SQL Server 2005/2008, HTML, XML and MS Visual Source Safe, SQL tuning, Oracle 9i, ASP.Net, MVC, AJAX, Javascript, CSS, T-SQL, UML, MS Visio, Agile Methodologies, SOAP, WCF, SSRS, SSIS

Client: Flextronics International, MD USA Application Programmer (06/2008 – 03/2012)

Cape Project

Flextronics International is an electronic manufacturing company. Cape project involves enhancements and maintenance of their existing Customer Order Management application and enterprise resource planning applications.

Responsibilities:

Technical specification and Detailed Design document preparation.

Regular interaction with business users and client representatives to understand requirements and provide support for the systems.

Used Object Oriented Design Patterns to implement classes and modules.

Set up the SharePoint environment by installing and configuring MOSS 2007.

Coding, code review, unit testing and build activities.

Prepared time estimation for new developments, enhancements and bug fixes. Prioritized the issues based on urgency and time required. Created and communicated these priorities and development plans by discussing with functional team and client team to avoid misunderstandings and confusions. This helped to handle issues without any customer escalations and increased customer satisfaction which helped to extend the contract to one more year.

Designed database, Created Tables & Written stored procedure and triggers at the back end.

Interact with infrastructure, release management, change management, QA, DBA and application teams.

Created Views on Surveys and using SharePoint Designer 2007 added custom columns and turned on Column Filtering.

Developed new customizations which included new UI, database tables and data access methods.

Existing web forms were modified to incorporate partial page updates and client side validations. AJAX techniques are incorporated throughout the system to improve responsiveness of the system.

Developed complex reports such as pending order statements, order history for a period and backorder detail reports which helped the client to avoid paper work as well as calculations in excel.

Improvised the application considerably from hours to seconds by SQL tuning, parallelization, pagination and Bulk Insert.

Created logical database design using VISIO by applying the RDBMS concepts and normalization techniques for data integrity. Generated Letters using ActivePDF. Used NUnit for Unit testing of application.

Implemented a new module to upload and manage documents in the system. This acted as a central repository which was shared among users. This helped the client to upload and share important design documents, reports and usability instructions to all the relevant users.

Extensively used data bound controls such as gridview, listview and repeater. Implemented paging for these controls in such a way that only the current page data was fetched from the database and thus improved performance.

Customized the SharePoint Portal to target specific content to user groups based on various categories like their job title, special interests, group membership.

Worked closely with functional team as well as with client team to deliver tasks in a timely manner under strict deadlines.

Handled production issues which required detailed problem analysis and provided bug fixes if required.

Environment: .Net Framework 2.0, Visual Studio 2005/2008, C#. Net, ASP.NET, ADO.NET, MSAjax.Net, CSS, JavaScript, SCM, SQL Server 2005, HTML, SharePoint 2007, Crystal reports 8.0/10.0, Baan Vb.

Client: Solectron Corporation (Flextronics), MD USA System Engineer (07/2006 – 06/2008)

Solectron Integration Development

Solectron Corporation is an electronic manufacturing company. Integration project involves new developments for the integration of Baan ERP with different applications like Marc, Datasweep etc. Also it involves the enhancements of existing functionality, production support and bug fixing.

Responsibilities:

Requirement Analysis, Technical specification and Design document preparation.

Worked as Integration developer.

Worked with on-site and offshore team in coordination and developed new Business Object Interfaces to transfer real time data between Baan and other applications like Marc and Datasweep. Created Business Objects and dynamic link libraries to exchange real time data such as sales order/purchase order details, Order Acknowledgment, shipment/receipt details.

Developed.Net applications and web service components to integrate Baan with third party applications.

Used Baan openworld and AFS functions to transfer data between baan and external applications. Wrote interface functions to create/extract XML files which contain data elements. Helped other teams to create database query to update/pick data from database tables.

Led production support team consisted of 3 members in handling production tickets without escalations and within the given time.

Conducted knowledge sharing sessions and technical training to Production support team to make them handle production tickets which required detail analysis. Also conducted knowledge transfer sessions to internal IBM teams.

Conducted knowledge sharing sessions to client team as part of project hand over activities when the client company was taken over.

Checked execution plan for all database queries used in each development and improved the performance of the queries based on their cost.

Coding, Code review, unit testing and implementation activities.

Created configuration reports for quality related activities. Attended training for configuration management.

Environment: .Net Framework 2.0, Visual Studio 2005, C#. Net, Win forms, Web Services, ADO.NET, BaaN Vb, Webmethod, B2Win 5.0, XML,XSD,XSL, Oracle 9i, IBM SCM, Windows 2000.

Merp Systems, Herndon VA Associate System Engineer (09/2004 – 06/2006)

Responsibilities:

Analyzed production tickets and provided bug fixes.

Carried out new development, enhancements.

Involved in Coding and Unit testing

Prepared monthly Configuration Reports for the project which gave details about issues completed during a month.

Created Baan SQL queries.

Created exchange schemes to export/import data between different Baan companies.

Created test plan and test results.

Created delivery dumps and installed in production environment.

Managed creation and deletion of baan and database users.

Environment: BaaN Vc,B2Win 4.0/5.0,Oracle 9i, IBM SCM Clear Case.



Contact this candidate