Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Cleveland, OH, 44113
Posted:
March 31, 2017

Contact this candidate

Resume:

Peter

aczlbt@r.postjobfree.com

678-***-****(Only Corp to Corp)

Summary:

6+ years of IT Industry experience in all the phases of System Development Life Cycle (SDLC) such as strategy and analyzing, designing, building (coding), testing and documentation of software products.

Experience in the Design and Development of Class Diagrams using UML. Web Pages, Win Forms, Web User Controls, Web Custom Controls, Server Controls and other application components using ASP.NET MVC 3.0,3.5,Web Services, C# .NET, VB.NET, ADO.NET, IIS, SOAP, HTML, JavaScript.

Extensive experience in Oracle 9i/10g, Sql Server 2005/2008, SQL, PL/SQL, T-SQL, MS-Access.

Proficient in database design and development, which includes: creating tables, indexes, triggers, writing complex queries, stored procedures and views using Transact SQL and PL/SQL. And designing DTS and SSIS Packages.

Extensively worked with ADO, ADO.NET to connect to SQL Server, Oracle databases using Connection, Command, Adapter, Dataset, Data View, Data Row (current/original Version), Data Column, Data Reader, Constraint and other Database Objects.

Have work experience in developing application using Visual Studio.NET 2005/2008/ 2012

Have hands-on experience in Configuring IIS and component services.

Developed and deployed portal solutions and also experience in creating complete software packages.

Strong Object Oriented Programming Concepts (OOP).

Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems

Windows 98/2000/XP,2007, Windows NT, Windows Server 2003/2008

Languages

C++, C#, SQL, PL/SQL

Databases

Oracle 8i/9i, MS SQL Server 2000/2005, MS Access.

Web Servers

IIS 4.0/5.x/6.0

Graphical Tools / Environment

MSVisualStudio.NET2005/2008/2012, MS Visual Interdev

Protocols

TCP/IP, FTP, HTTP, SMTP, SOAP

Internet Technologies

HTML, DHTML, XHTML, XML, ASP.NET, JavaScript,

Reporting Tools

SSRS, SSIS, Crystal Reports

Miscellaneous Dev. Tools

CLR Profiler 2.0.

PROFESSIONAL EXPERIENCE:

Client: Key Bank, Cleveland, OH NOV 16-Present

Role: .NET Developer

Description:

Key bank is a US regional banking corporation, headquartered in Cleveland. The company's main businesses include commercial banking, consumer lending, payment processing, investment advising, used for printing checks, mailing, tracking void / stopped checks. This banking system reconciles transactions and always balances account(s) debits and credits at the end of the year.

Responsibilities:

Implemented partial Agile Methodologies for rapid development and continuous delivery of the working application.

Implemented Telerik Kendo UI controls for developing the front end for the application.

Developed the application using ASP.NET web form designing and Multitier framework.

Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level.

Effectively used CSS3, HTML 5, Partial views and Layout Pages.

Used SSRS to generate reports and integrated with ASP.NET web page using report viewer.

Created and exposed RESTful web services using WCF architecture for the client to communicate and exchange data, and Used Solr for Search with .NET(VB.NET and C#).

Used WCF for developing and deploying services on windows in line with the Service Oriented Architecture (SOA).

Worked with TFS (Team Foundation Server) for managing versions of code.

Used SSRS and SSIS for Reporting and Integration service.

Involved in writing Stored Procedures and Triggers using T-SQL.

Used SOAP and REST services for requesting information from endpoints.

Used LINQ for building and executing a query expression.

Involved in the Unit and Integration testing.

Environment: C#, .NET 4.0/4.5, ASP.NET 4.0/4.5, ASP.NET MVC 4/3, Visual Studio 2012/2013, JavaScript, AJAX, jQuery, Bootstrap,AngularJS, Entity Framework 6.0, HTML, Telerik, WPF, WCF, IIS 7.5, XML, XAML, SOAP, LINQ, SQL Server 2012, TFS, SSRS, SSIS, Azure.

Client: NCR, Duluth, GA SEPT 15- OCT 16

Role: .NET Developer

Description:

The project involved developing the complete e-commerce functionality and admin features developed included interfaces for Order Management, Inventory management, Custom shopping cart etc. This project is designed to manage the operations of online orders. The functionality of this project is Taking Online orders, processing the Orders, Managing the inventory, Managing Purchases, Managing gifts information.

Responsibilities:

Developed Web pages with ASP.NET using JavaScript, Client Side Validation, Server Controls, HTML Controls, JQuery, Ajax and CSS

Developed Data Access Layers, Business Rule layers using ASP.NET and C#.

Used Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 3.0 application using HTML.

Developed web applications and web forms using HTML5, JavaScript, CSS3, Angular JS, C#, .NET4.0 and 4.5

Implemented Model-View-Controller (MVC) design pattern using Single Page Application (SPA) - Angular JS for the User Interface (UI)

Front-end development using latest HTML5 and CSS3 techniques, backed by jQuery and other Javascript frameworks to enable optimum user experience throughout the site.

Creating client side validations with JQuery selectors, Events and Server side validations with ASP.NET 4.5.

Involved in Developing WPF, WCF services to enable effective communication.

Worked Extensively on migrating Winform controls to WPF controls.

Created SOAP based WCF service as well as RESTful Web API to send and receive web service messages and converted the JSON format data to XML.

Extensively using crystal reports and SQL Server Reporting Services (SSRS) for generating reports populated by data in databases.

Enabled Client and Server cache using ASP.NET Cache API in MVC application.

Extensively Used TFS (Team Foundation Server) for the maintenance and status of the developers for development of application.

Developed the SQL Server Stored Procedures, Views and User-Defined Functions etc. that are required for the application.

Developed system services SOA application platform for use by all web applications utilizing WCF services.

Exposed Orchestration as web services and consuming web services into Orchestration

Transforming XML schemas using Maps and XSLT transformations.

Environment: .NET Framework 4.5, MS Visual Studio 2015, Azure, ASP.NET, C#, Microsoft Dynamics CRM, T-SQL,WPF, Entity Framework 4 MVC,Web Services, IIS, SOAP, HTML5, CSS3,JSON,, LINQ,

Client: Safeway Insurance, Westmont, IL FEB 15- AUG 15

Role: .NET Developer

Description:

Safeway is an insurance company, which will provide auto insurance.

Safeway was initially a C++ application developed for Safeway Insurance. This prism is being rewritten in ASP.NET with code behind in VB.NET. My responsibility involved front end Coding and using method calls from COM+ to transact with the SQL Database and XML. An OEM Prototype was used for the GUI with changes made at development to suit the current requirements. Business requirements for the functionality and look and feel were strict which made development a challenge. Preserving the functionality, while creating a lean performance driven application was the main goal through out the project. This was achieved by reducing the number of post back server trips by maximizing the use of JavaScript on the Client side.

Responsibilities:

Analysis, design and development of Applications.

Implemented Business Tier, Data Access Tier using C# and .NET 3.5(WCF) and Web Services.

Developed Custom Controls, User Controls and Inherited Controls as per the project requirements.

Developed front-end using HTML5, CSS3,JavaScript and Asp.net.

Developed a new web application utilizing ASP.NET MVC which provides performance data visualization to users.

Used WCF for developing and deploying services.

Developed user controls and validation controls using ASP.NET

Used LINQ to SQL to connect to the SQL Server Database from the .NET applications.

Used LINQ to Entities to build set of operations, parameters and expression during execution of set of data from SQL Server.

Created stored Procedures using SQL Server 2008.

Worked on Extraction, Transformation and Loading (ETL) process using DTS, MS-SSIS application tools.

Migrated SSIS Packages in SQL Server 2008R2 Package Deployment Model to Project Deployment Model in SQL Server 2012.

Implemented SQL Server Reporting Services (SSRS) to generate reports for CFSF module.

Environment: .NET Framework 4.0/3.5, Visual Studio 2012, ASP.NET 3.0, Web Forms, ADO.NET, C#, XML, HTML, LINQ2SQL,VB6, CSS, Oracle 9i, WCF, SSIS, SQL Server 2012,NUnit,Visual SourceSafe 6.0, Windows Server 2003.

Client: CNS INC, Rockville, MD OCT 13- DEC 14

Role: .NET Developer

Description:

Case Management System (CMS) is a real time windows application which will caters the needs of McHenry IL court day to day transactions. It contains various modules like Notices, Illinois Reports, law bulletin, Monitor Gather, Child support etc. These applications will gather input from various departments of court. Application will generate reports accordingly.

Responsibilities:

Analyzed the business requirements from the users.

Designing of User interface with C# and WinForms.

Understanding of VB6.0 existing application and business logic

Designed Business components and Data Access Layer using C# and WinForms

Involved in the performance improvement of the application by stress testing and analyzing the test results.

Writing of Stored Procedures, Functions using SQL Server 2005.

Maintenance of the various database objects – tables/views/stored procedures - in SQL Server 2005.

Customized MS Dynamics CRM 2016 application based on the business requirements.

Involved in version management of source code using VSS.

Analysis and trouble-shooting of defects.

Testing the application and fixing the bugs if any.

Involved in analysis and designing of reports using Crystal Reports.

Understanding of Domain Knowledge.

Preparation of Test Cases for Unit testing and System Testing for the application.

Preparation of Build and Internal Release Notes for QA.

Performed code review for the team members.

Environment: C#, WinForms, LINQ, .NET Framework 3.5, Visual Studio 2008, VB6.0, ADO.NET, SQL Server 2005,CMS, Visual Source Safe and Crystal Reports 2008.

Client: Mphasis,Bangalore, India JAN 12- AUG 13

Role: Associate Software Engineer

Description:

The working of the Jet Mobile application has been divided into 3 different modules, namely:

Push service, Pull service: Account status, Flight Schedule, Flight Status.

Web Interface

Admin Module:

Activate /Deactivate Services

Message Screen

Campaign Messages (For Composing Messages)

Responsibilities:

Developed ASP.NET web forms and Class libraries for business and data access logic using C#.NET.

Developed the web pages using ASP.NET, HTML, JavaScript and CSS for styling the Web pages.

Developed Role Base Security by Using ASP.NET to authorize the request member to a specific Role.

Used Data Grid View control to provide a customizable table for displaying data.

Used Data Grids, Data Sets, Data Views, Data Adapters and Data Readers to extract data from Backend.

Used JavaScript and AJAX for client side validations and scripting in the Web Pages.

Written Stored Procedures, Functions and Queries in SQL Server.

Performed Unit, Integration, and User Testing and documented the results.

Environment: .NET Framework 2.0, ASP.NET2.0, C#, ADO.NET, Visual Studio 2010, XML, HTML, CSS,C++, JavaScript, SQL Server 2000/2005, VSS, Microsoft Office and Windows 7.

Client: AGTechnologies Pvt. Ltd, Mumbai, India AUG 10- DEC 11

Role: Associate software Engineer

Description:

The Scope of this Software is as given below:

Collect the information about the employee’s activities and generate the analysis report of the activities. In this application, designated person can allocate the work to the employee and employee can start work on the assigned task. All employees of the organization will use this application. Employees are divided into two categories:

Employees working at client site.

Employees working in AG premises.

Responsibilities:

Interacting with end-users and converting their requirement into .NET code modules using C#, user controls, ASP.NET framework, HTML, DHTML.

Providing technical support for the Company during project development stages.

Creating test plans, CTP, CSD, build and deployment script.

Database operations include creating, writing T-SQL Stored Procedures, Views and SQL Scripts for altering the Database Schema.

Environment: .NET Framework 1.1, Visual Studio 2003, C#.NET, ADO.NET, MS SQL Server, JavaScript

Education:

Bachelors in Computer Science

Jawaharlal Nehru Technological University (2010)



Contact this candidate