Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Pittsburgh, PA
Posted:
June 25, 2017

Contact this candidate

Resume:

Mohammed AlJaser

E: ac0z8w@r.postjobfree.com

M: 412-***-****

PROFESSIONAL SUMMARY:

3+ years of Professional.NET 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 EXPERTISE:

Operating Systems

Windows, Mac, Linux.

Programming Languages

C++, C#, C#.Net (4.0/3.5/3.0), Python, Java, HTML, T-SQL, PL/SQL

Web Technologies

ASP.NET4.5/4.0/3.5/3.0/2.0, ASP.NET MVC, Silverlight, Ajax, JavaScript, JQuery.

IDE Tools

Visual Studio 2017/2015/2013/2010, SQL Server Management Studio 2014/2008.

.Net Frameworks

.Net Framework 4.5/4.0/3.5/3.0/2.0

Databases

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

Reporting Tool

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

Version Control Tools

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

Middleware

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

Servers

Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0/4.0)

WORK EXPERIENCE:

AVEDENCE, eSource Technology, Pittsburgh, PA. Jan 2017 – Till Date

Role: .Net Developer

Environment: Visual Studio 2015/2017, C#, ASP.Net 4.5, JQuery, JSON, AngularJS, IIS, AJAX, ADO.Net Entity Framework, LINQ, XML, HTML, Bootstrap, Microsoft Enterprise Library, SQL Server 2014.

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 for developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL Server 2012.

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.

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.

CPittsburgh, eSource Technology, Pittsburgh, PA Mar 2016 – Dec 2016

Role: .NET 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 Services, SQL Server 2014 R2, Windows Server 2008 R2/2008.

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.

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.

WIYDX, WIYDX, Parsippany, NJ Jan 2015 – Feb 2016

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

WIYDX Is the tutorial for residency doctors, have all the diagnosis information and a lot of digital slides and images. it has almost all the section of medical and related diagnosis. it used the digital slides to learn pathology (histological) and it uses an image for clinical study. it has quiz builder and comparison features of diagnosis also center point to get any research data for diagnosis

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 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.

GRANTS, RMU, Moon, PA OCT 2014 – Dec 2014

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.

The project is to serve researchers who are looking for grants opportunities. I was responsible for developing an application for Administrative purpose using ASP.Net C# MVC. This application replaced an old system within the Research & Grant department where system functionality was an issue. This is an online website portal where researchers could easily find multiple grants opportunities.

Responsibilities:

Developed and designed a User Interface (UI) with JQuery, JavaScript, HTML, and CSS, so that the user can access all system functions and search various criteria.

Launched project’s 2nd phase, focusing on creating as Admin Portal using ASP.NET C# MVC, where the administrator could send information to the database and edit data during two-way communication.

Effectively developed Stored Procedures to join the application with the database using Oracle Database.

Modified existing software to correct errors, upgrade interfaces and improve performance.

Wrote maintainable and extensible code in a team environment.

Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval, and indexing.

UIIS, UIIS, Pittsburgh, PA Aug 2013 – Sep 2014

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

Unique international services is portal for immigration firm consulting company for Canada, have created public facing website uiis.ca and management portal uniqueinternation.ca, uiis.ca is a public facing website for information and customer interaction, it have customer portal for payment ( Moneris payment gateway). The management site is used to manage inquiries, it has an inquiry, follow-up document management, and payment module.

Responsibilities:

Detail architecture of the both public-facing and internal website

Worked on asp.net for the internal site

oCreated asp.net pages

oCreated business logic layer

oCreated data access layer

oCreated pdf reports

oAdded Moneris payment gateway

oHosted site on cloud

Worked on public facing site and created on mvc-4

oCreated CSHTML pages for public facing site

oAdded customer portal for payment tracking

oConsume and display data from Canada immigration government (cic.gc.ca) site on uiis.ca with RSS feed.

Used SQL Server as database

oTables, Stored Procedure, and views

o Create Backup plan and jobs

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

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

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.

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.

EDUCATION:

Bachelor of Software Engineering, Robert Morris University, Moon, PA.



Contact this candidate