Post Job Free

Resume

Sign in

Web Sql Server

Location:
Hyderabad, Telangana, India
Posted:
August 06, 2018

Contact this candidate

Resume:

Rajesh Sayana

Email: ac6kok@r.postjobfree.com Phone: 732-***-****

Professional Summary

* ***** ** ********** ** diverse facets of Full-Stack .Net Development, including Analysis, design and development of Internet and Intranet enterprise applications.

Hands on experience in using TypeScript to build component based Angular 2/4/5/6 applications and have built components, modules, services, custom pipes, routes and data validation.

Experience in using Node.js as a server for hosting the angular applications and used npm (node package manager) to install required node packages.

Experience in using Angular CLI to generate components, services and used npm to install the project dependencies such as bootstrap, ngxPagination, ng2-bootstrap-modal, popper, jQuery, etc.

Proficient at building responsive and dynamic UI using HTML5, CSS, Bootstrap, JavaScript, jQuery and AJAX.

Expertise in developing RESTful and SOAP services in ASP.NET using C# and consuming the Web services, Web API in Angular application using HttpClientModule.

Experience in developing N-tier web applications using .Net Framework 4.0/4.5/5, ASP.NET, ADO.NET, C#, ASP.NET MVC 4/5, ASP.NET Web Forms, Entity Framework, LINQ, WEB API, WCF, Web service.

Experience in building ASP.NET MVC web applications implementing Onion architecture and Design Patterns such as Singleton, Repository, Unit of Work and Dependency Injection.

Experience in using Entity Framework code first as well as Database first approach. Experience in building ASP.NET Web Forms applications.

Experience in migrating ASP.NET Web Forms application to C# ASP.NET MVC Web applications.

Experience in implementing data encryption using AES encryption algorithm in C#.

Experience in building and consuming Web API, WCF and Web Services and working knowledge in parsing JSON and XML files.

Experience in using LINQ in the data access layer to perform CRUD operations on the database. Experience in creating LINQ to SQL, LINQ to Entity, and LINQ to object queries.

Knowledge on developing web applications using .Net core 1.0 technology.

Experience in working with Database servers such as SQL Server 2016/2012/2008, Oracle 10g/11g and MySQL.

Experience in Database Design, Normalization and creating Stored Procedures, Triggers, Views and User Defined Functions based on functional requirements.

Experience in creating SSIS (SQL Server Integration Services) packages for ETL process and using SSRS (SQL Server Reporting Services) for reports generation.

Experience in using testing frameworks such as NUnit, to test C# code, and Jasmine, which is run on Karma, to test the Angular code. Experience in using POSTMAN to test the Web API.

Experience in using version control tools such as TFS and GIT and project management tools such as JIRA.

Good exposure to the different phases of Software Development Life Cycle (SDLC) such as requirement gathering, analysis, design and development.

Hands on experience in developing projects using different SDLC methodologies such as Waterfall model and Agile.

Good interpersonal, communication skills and an able team player with focus on meeting strict deadlines. Self-Starter, Independent, Motivated, and Enthusiastic Team Player with Excellent Analytical, Problem Solving, Written and Communication skills.

Technical Skills

Web

HTML5, CSS3, Bootstrap 3/4, JavaScript, jQuery, Angular 2/4+, Node.js, AJAX, TypeScript

Microsoft .Net Technologies

ASP.NET Web Forms, ADO.NET, ASP.NET MVC, Web API, WCF, Web Services, Entity Framework, LINQ,, ASP.NET Core 1.0

Database

SQL Server 2008/2012, T-SQL, SSIS, SSRS, Oracle 10g/11g, PL/SQL, MySQL

Others

Oracle Toad, TFS, GIT, JIRA, POSTMAN, Slack, NUnit, Jasmine, Karma, Python, Java, RESTful, SOAP, Visual Studio, Visual Studio Code, Eclipse

Professional Experience

J.G. Wentworth Chesterbrook, PA

Role: Full-stack Software Developer (Angular/Web API) 01/2017-Present

J. G. Wentworth is a finance company that provides structured settlements, home loans, prepaid cards, Personal loans, Pre-Settlement funding and Annuity Purchasing. The project is to migrate different applications, which were built on web forms, to the single page application (SPA) using Angular and build a web portal for the customers to track their approved services. The application takes care of handling different service requests from customers, talking to different third-party end points, track the approval status and keep notifying the team for pending approvals throughout the whole process.

Responsibilities

Migrated ASP.NET Web Forms application to a Single Page Application (SPA) which is built on Angular framework.

Designed and developed the application using Angular 2/4/5, HTML5, CSS3, Bootstrap 4, TypeScript, AJAX, Web API and Entity Framework.

Developed custom/re-usable components, modules, pipes, and services to overcome Dependency Injection, as per the business needs.

Utilized Node.js as the server, npm to install Angular dependencies and built the project using Angular CLI.

Developed reusable Services that implement HTTPClientModule’s POST, GET, PUT, DELETE methods to invoke Web API methods and performed CRUD operations on the data.

Consumed Web Services and Web API to access data from the external Applications.

Used @Input, @Output decorators to pass data between parent and child components and have used @Injectable decorator for services that act as communication link between two sibling components.

Developed custom routes to the application using RouterModule and have used Router Guards to protect the application from unauthorized users.

Used ngxPagination module to implement pagination on the application to enhance the UI.

Performed Data Validation on the input fields based on the business requirements.

Developed Web API using C#, ASP.NET and Entity Framework 6.

Used Entity Framework Database first approach to build the models and used LINQ to query the database.

Created triggers, Stored Procedures and User defined functions as per the requirements.

Used POSTMAN to test the Web API and for the Angular application, used Jasmine Framework and Karma as a runner tool.

Built SSIS packages for transmitting data both internally and externally and developed web reports using SSRS.

Involved in the all the phases of Software Development Life Cycle. Worked in Agile/Scrum development environment and participated in daily meetings and discussions with all the stake holders.

Used JIRA tool for project management. Used version control tools such as TFS and GitHub for managing the code.

Environment: Angular 2/4/5, Typescript, Jasmine, Karma, Node.js, npm, CSS, HTML5, Bootstrap 4, C#, .NET Framework 4.5, Entity Framework 6, LINQ, Web API, Web Service, POSTMAN, JSON, SQL Server 2012, SSIS, SSRS, IIS7.0, GitHub, JIRA.

Suvoda Conshohocken, PA

Role: Full-stack Software developer (ASP.NET/Web API) 01/2016-12/2016

Suvoda is a health care service provider that offers different solutions such as Drug Inventory Management System (DIMS), Interactive Responsive Technology (IRT) and Trail Intelligence (TI). The project is to build a trail intelligence, that analyses clinical trials and predict the possible outcomes, unforeseen issues, measure KPI’s, and integrate it with IRT and DIMS to provide an efficient and smooth clinical trial process. The project also involves in enhancing the IRT and DIMS applications.

Responsibilities

Participated in requirements gathering, design, development, and testing phases of Software Development Life Cycle.

Followed agile methodology in project implementation.

Designed N-tier web application that implements Onion architecture using ASP .Net MVC 4.5 framework.

Implemented Repository Design Pattern and used Entity Framework for establishing a connection with the database.

Designed a Unit of Work class that implements Singleton design pattern, and acts as the only access point to the repository layer from different layers such as Service/MVC.

Created Interfaces to enforce functionality implementation and overcome Dependency Injection.

Used DataAnnotations in building the models. Enabled Migrations and used Code first approach to build the database.

Utilized ASP.NET Identity for authentication and authorization of different actions in different controllers.

Built Web API, Web Services to provide data to external end points and consumed third party Web Services/Web API to access data from external end points.

Added DTO layer to transfer complex objects based on the business needs from repository layer on to the MVC layer.

Designed ViewModel to bind the complex objects to the view and have used AutoMapper to map DTO objects to ViewModel objects.

Developed responsive user interface using Bootstrap 3, HTML5, JavaScript, jQuery and CSS and used AJAX and Partial Views to render content asynchronously.

Used ViewBag and TempData to transfer data between controller to view and from controller to controller respectively.

Developed dynamic SQL queries using LINQ and have generated LINQ to SQL, LINQ to Object type queries.

Used SQL Server 2012 version to store the database and involved in designing and modelling the database.

Created complex stored procedures that use dynamic SQL to generate query based on optional input parameters and have used transaction and exception handling.

Developed test cases using NUnit Framework and tested the Web API using POSTMAN.

Involved in all levels of testing from development to deployment.

Used TFS for version control.

Environment: ASP.MVC 5, ASP.NET Framework 4.5, C#, Entity Framework, LINQ, Web API, Web Services, JSON, CSS3, HTML5, Bootstrap 3, JavaScript, jQuery, AJAX, NUnit, POSTMAN, SQL Server 2012, IIS7.0, TFS.

Toyota Plano, TX

Role: Full-stack .Net Developer (ASP.NET/Web API) 10/2014-11/2015

Toyota is one of the leading car manufacturer companies in the USA. It has manufacturing plants spread across different parts of the world and has to frequently deal with shipping cars from manufacturing plants to different dealers spread globally. The project is to build a platform which allows the dealers communicate with each other and request for parts/accessories they need for their warehouse/show room.

Responsibilities

Developed an N-tier web applications using the ASP.NET MVC framework and developed a service layer to implement business logic.

Used Entity Framework 4 to communicate with SQL Server from ASP.NET MVC application.

Developed SQL queries using LINQ and wrote LINQ to SQL and LINQ to Entity type queries.

Developed Custom Validation for some input fields to meet the business requirements. Performed both Client side and Server side validation.

Implemented role based authentication by using the ASP.NET Identity and implemented AntiForgeryTokens to overcome cross site hacking attempts.

Built Web API to provide data to different external end points. Restricted access to Web API based on the roles.

Used SQL Server 2012 version to store the database and followed the database first approach to build the Models.

Involved in designing database objects such as Tables, Views, Stored procedures, and triggers using SQL server.

Developed NUnit test cases to test the application and used POSTMAN to test the Web API.

Involved in requirement gathering and development phase of SDLC and worked in Agile/Scrum environment and participated in daily meetings.

Used Team Foundation Server (TFS) for code management and JIRA for project management.

Environment: ASP.NET MVC 4, ASP.NET Framework 4.5, C#, Entity Framework 4, LINQ, CSS, HTML, JavaScript, jQuery, Web API, SQL Server 2012, IIS6.0, JIRA, TFS

MedPlus Pharmacy Hyderabad, India

Role: .Net Developer 06/2013-10/2014

MedPlus is a leading pharmaceutical company in India that sells prescribed drugs and medicines spread across different cities throughout country. Project was to build an internal web application for inventory management to track the inventory being shipped to each branch, sales history and analysis on each drug at each store, and to track their orders from their distributors.

Responsibilities

Developed ASP.NET Web Forms application to implement the functionality.

Used GridView to display data onto the front end and used Repeater to dynamically display the navigation menu links for different pages.

Designed responsive ASPX pages using CSS grid, JavaScript, HTML.

Performed Server side validation using JavaScript and jQuery.

Implemented session management using cookies.

Used AJAX Auto Complete to asynchronously render auto filling option for text box fields in the form after user enters minimum three characters in the text box on the UI.

Used ADO.NET to communicate with the database.

Used SQL Server 2012 version to store the database. Involved in designing the database.

Generated web reports using SQL Server Reporting Services (SSRS).

Followed the Waterfall methodology of the Software Development Life Cycle.

Used TFS and JIRA for version controlling and tracking the project status respectively.

Environment: ASP.NET 4.5, C#, ASP.NET Web Forms, ADO.NET, CSS, HTML, JavaScript, jQuery, AJAX, SQL Server 2012, SSRS, IIS6.0, JIRA, TFS

Educational Qualification

Masters in Computer Science - Villanova University



Contact this candidate