Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Pittsburgh, PA
Posted:
May 23, 2018

Contact this candidate

Resume:

Monali Patel

Email:ac5k0r@r.postjobfree.com

C: 724-***-****

PROFESSIONAL SUMMARY:

Certified .Net Developer – (brainbench.com transcript ID number 13737800)

* ***** ** ************.*** Development experience in all phases of SDLC (Software Development Life Cycle) such as planning, analysis, design, and implementation.

Incorporated many rich, user-friendly, responsive features in the application using Angular JS, HTML5, JQuery, Ajax, CSS3, and Bootstrap in process of Developing Single Page Applications (SPA).

Highly Knowledgeable in ASP.NET MVC 4.5/4.0/3.0 in implementing Model, View and Controllers with State Management, Security, Action methods Including Creation of Partial Views, Strongly Typed Views, Filters Routing etc.

Experienced in Implementing WCF services and consuming using different protocols and implementing features like Debugging, Performance, and Security and creating Service, Data, Fault and Message Contracts, and services.

Experience in using Lambda Expressions, Query Expressions, Anonymous Types and Extension methods with Language-Integrated Query [LINQ] (LINQ to XML, LINQ to SQL and LINQ to objects).

Leveraged the introduction of Web API Controllers (Web API 2) in ASP.NET MVC 5 to build, maintain Restful API’s and consume the API’s client side using Angular JS data binding.

Experience in working extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2014/2008 & Oracle 11g/10g/9i/8i.

Extensive Experience in Creation of Stored Procedure, Views, Triggers, Functions, T-SQL, PL/SQL, Indexes, Cursors, Performance Tuning, and SQL Profiler. Including writing of complex queries using SQL.

Hands on experience with SQL Server Reporting Services (SSRS), SQL Server Integrating System (SSIS) using SQL 2014/2008.

Excellent Verbal Communication, Written, Analytical Skills with a customer service oriented attitude and worked with the offshore team as onsite coordinator to provide the update on the daily basis.

Technical Skills:

Operating System

Window, Mac, Linux.

Programing Languages

C#.NET, SQL, C Net(4.0,3.5,3.0),java,HTML,T-sql,PL/SQL

Version Control Tools

Visual SourceSafe,Subversion,Team Foundation Server(2015,2013,10,08),GIT

.Net Frameworks

.Net 2.0/3.0/3.5/4.0/4.5

IDE Tools

Visual Studio 2005/2008/2010/2013/2015/2017,SQL Management Studio2014/2008

Web Technologies

ASP.NET 4.5/4.0/3.5/3.0/2.0,ASP.NET MVC, Silverlight, PHP, Ajax, JavaScript, JQuery.

Operating Systems

Windows 98/NT/2000/XP/Vista/7/8/8.1/10

Reporting Tool

SQLServer Reporting Services (SSRS 2008/2005),Crystal Reports (2010/9/8.5/8)

Servers

SQL Server 2008/2005/2003/NT,Microsoft IIS (7.0/6.0/5.0/4/0)

Protocols

SOAP, TCP/IP, HTTP

Middleware

WPF,WCF,ADO.NET 4.0/3.5,Web API,Web Servies,Entity Framework 6.0/5.0

Database

SQL Server 2014/2008,Access 2010/2007/2003,oracle 11g/10g/9i/8i/My SQL,Toad

WORK EXPERIENCE:

CPittsburgh, eSource Technology, Pittsburgh, PA. april2018-Till now

Role: .Net Developer/UI developer

Update the system

Maintance daily,weekly,and yearly task

CPittsburgh, eSource Technology, Pittsburgh, PA. April, 2017-jan,2018

Role :.Net Developer/UI developer

Environment :Visual Studio 2015/2017, C#.Net, ASP.NET 4.5, Java Script, JQuery, JSON, SOAP, IIS 7.0,

AJAX, LINQ, HTML, SQL Server Integration Service, SQL Server 2014 R2, Window Server 2008 R2/2008

Description: CPittsburgh is a website that helps and serves the residents of Pittsburgh to discover their city. Also, people who are traveling to Pittsburgh, it will be a great guide to planning their visit. Students can plan where they want to go to college by providing the top 5 universities in the city information. It will guide the user to their favorite activities and where they can do it, as well as where to eat by presenting some information about the best restaurants in the city.

Responsibilities:

Involved in the complete Software Development Life Cycle including Analysis, Design, and Implementation.

Developed solutions for diverse programming scenarios in C#.Net, employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Implemented changes in coding and designs using knowledge of C#.Net.

Extensive Experience in Implementing View, Model, Controller and View model by using ASP.Net MVC 4.5 Framework.

Used ASP.NET MVC4.5 Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.

Implemented UI layer using Partial views,views, Layouts, Themes by using Razor, Bootstrap, HTML5.

Developed Micro services architecture using Spring Boot.

Using a service febric in a middle tiear data.

Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET

Created Html Helpers in order to reduce the amount of tedious typing of HTML tags.

Developed Entity Framework and made LINQ queries to connect to the database and implemented CRUD functionality with Entity framework Code First and Database First approaches with ASP.NET MVC 4.5.

Developed stored procedures, views for data manipulation, ensuring set up relations includes indexing, constraints, and foreign keys in SQL server.

Cppittsburghwest.com, crownplaza,Pittsburgh,pa March 2017-june, 2017

Role: .Net developer

Environment: Visual Studio 2012, ASP.Net4.0, C#.Net, LINQ, HTML5,SSAS, SSRS, WCF, CSS3, XML, SQL Server 2012, JavaScript, IIS 6.0

Description: Cppittsburghwest is a Hotel management Website. This website all cover various aspects of online hotel reservation and management. Visitors can book rooms by seeing the facilities available and room rates. Visitors can read a review and compare price for online booking .Also booking for wedding and meeting hall.

Responsibilities:

Gathering and Analyzing the Business requirements from the Business Owner/ Managers and design a prototype, prepare specification and technical documents.

Used Microsoft.Net Framework component LINQ (Language Integrated Query) for data querying capabilities.

Designed and developed the system using Agile Methodologies

Used data grid to review and modify manipulated data.

Extensively worked on ADO.NET Entity Framework for developing core data layers for the distributed applications.

Involved working with MVC design Pattern for the rich user interface.

Involved in using VB.NET,JavaScript and AJAX for Client side validations and validating the input data using validation controls.

Used Entity framework to create mapping objects to access the database.

Developed stored procedures for extracting data from Database in SQL server 2012.

Enhanced the applications for Single sign-on based on user security roles/credentials and C# Programming language for creating drivers to the devices that are used for identification and authenticating the users.

Developed Custom User Controls using Partial views to reduce the Complexity in User Interface Coding and provide better look and feel.

Imported and exported the data from datasets to Excel for internal reviews.

Added functionality in business layer and Data access layer.

Documented and Unit tested the web pages that were developed and reports were presented SQL reporting services (SSRS).

Responsible for designing and developing ASP.NET web pages using ASP.NET, Javascript, ADO.Net, SQL, HTML5, CSS3 and AJAX, Web services.

Involved in analyzing large quantities of data using SSAS by storing data in axes and cells instead of the traditional relational two-dimensional view in rows and columns.

Responsible for code review and maintenance.

AVEDENCE, eSource Technology, Pittsburgh, PA. November, 2016-March, 2017

Role: .Net Developer

Environment: VisualStudio2015/2017, C#, ASP.Net 4.5, JQuery, JSON, AngularJS, IIS, AJAX, ADO.Net Entity

Framework, LINQ, XMAL, HTML, Bootstrap, Microsoft Enterprise Library, SQL Server 2014

Description: The Avedence DAM system is a digital asset management system that captures stores and allows collaboration and dissemination of video, audio, photographic and document based digital content to a broad base of users for a broad range of purposes. Avedence workflows manage content based on policy and process for content handling by the agency, customizable by the user. Avedence is a central content and process repository for FOIA request collaboration.

Responsibilities:

Implemented OOPs concept to properly structure, secure and minimize codes.

Implemented the AGILE software development process, using SCRUM methodology.

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Responsible for Designing and Developing the Reusable UI Components Like MVC Master Pages “Layouts and Nested Layouts”, “View Start” and MVC User Controls “Partial Views”

Created various Angular Services & injected them into Angular Controllers (using Dependency Injection) to enable AJAX calls and created custom angular directives to create own HTML tags and induce some kind of functional behavior to those tags.

Actively involved in coding and designing using C#, XML, JavaScript, HTML5, and Cascading style sheets (CSS3), Bootstrap.

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL Server 2012.

Responsible for Micro Services.

Developed Micro services architecture using Spring Boot.

Using a service febric in a middle tiear data.

Implemented AJAX functionality using Angular JS to load contents individually in different partial views to minimize loading time and for better user experience.

Implemented the Entity Framework Code First Approach to interact with Database and also implemented the Mappings, Model Changes, CRUD operations and dealt with performance issues.

Micro service using gradle.

Used JSON (JavaScript Object Notation) format to serializing and transferring of data.

LINQ was extensively used in view extension to parse out unnecessary information and to make call to SQL database.

Performed complex parameterized SQL queries to multiple tables in SQL server 2014 and implemented Joins in Stored Procedures to get the desired data by joining multiple tables in Domain layer.

Jewellery Hub, InfoBizz, India March 2016-Oct 2016

Role: .Net Developer

Environment: VisualStudio2013, C#, C#.NET, ASP.NET 4.0/3.5, EDMX, JQuery, Oracle, IIS 7.0, AJAX, ADO.NET Entity Framework 4.3 LINQ, XML, Microsoft Enterprise Library, Windows7, HTML, CSS, Bootstrap, Toad.

Description: Barcode label generation with unique barcode no. for each jewelry. Automatic SMS Alerts to customers after purchase the products and due payment etc. Automatic Calculation for generate invoice. Capture Customer Detail, Payment Method at Billing. Product search by barcode scan. Product Exchange, Return Discounts & Offer Management. Various Reports like Sales, Outstanding Payment, VAT, etc. Automatic Data Backup on daily basis.

Responsibilities:

Software development to support new Web Interface and Web API development C#, HTML, Razor, and Entity Framework 4.5 was used for development.

Developed UI with use of HTML5, CSS3, JavaScript, JQuery, Bootstrap, Angular.js and AJAX.

Worked on PowerShell for automating deployment. Used TFS for source control and bug tracking.

Used Microsoft Entity Framework Database First approach for the Data Access Layer.

Involved in creating web forms with numbers of Visual Studio 2015.2017 standard controls and components for UI.

Responsibilities will include documenting Functional Requirements, Specifications and developing detailed technical design documentation and development work estimates.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using JQuery and getting the Data back as JSON and parsing it onto the UI.

Also used master page and used user controls when ever need in the web page.

Implemented Azure Application Insights to store user activities and error logging.

Used an Agile, Scrum approach methodology for software development.

Deployment of Application on Test and Production environment and Integration of different systems with the application.

Airline Reservation Booking, India March2013 to June2014

Role: .Net Developer

Environment: ASP.Net 4.0, C#.Net 4.5, MVC, WEB API, SVN, 2012, OOD, LINQ, SQL Server 2012, Windows services, AJAX, JavaScript, JQuery and Angular1

Description: User can book their tickets from any location, thus saving their time and effort. Users can place their query as per their requirement and get results immediately on particular flight as per their desired location and as per entered price.

Responsibilities:

Developed front-end web pages using AJAX, HTML5, and CSS3.

Extensive development using ASP.Net, MVC, C# using Web Applications and OOPS Concepts.

Worked withASP.NETMVC 3.5 Model to build the UI layer for the existing solutions.

Developed services using WEB API and used them in doing the AJAX calls using JSON

Responsible for using LINQ to SQL data provider to communicate with the database

Worked Extensively with Web Forms and maintained existing system.

Used CSS3 to change the look of the application

Responsible for using LINQ to SQL data provider to communicate with the database

Design and develop rich user interfaces with HTML/CSS/JavaScript, JQuery and Angular1

Used JavaScript, JQuery and Angular1 in effective web design.

Used AJAX and JQuery language for client side scripting.

Wrote Stored Procedures, Functions, Indexes, Triggers to access data from SQL Server 2010Database

Tuned the SQL Queries for better performance

Developed T-SQL queries for accessing the database

Developed Web services, Win forms using ASP.NET and C#.

Interfaced with the database and stored procedures using Services.

EDUCATION:

Bachelor of Computer Application, S.P.University, India.



Contact this candidate