Sql Server Data

Location:

Topeka, KS

Posted:

January 10, 2019

Contact this candidate

Resume:

Jai J Lekkala ***********@*****.*** 785-***-****

PROFESSIONAL SUMMARY

Seven plus years of experience in the field of software development using AGILE SCRUM methodology and Waterfall. Was involved in all aspects of Waterfall methodology: Analysis, Design, Development, Implementation and Testing of business applications.

Extensive experience working with ASP.NET Core, ASP.NET, MVC Frameworks 6.0/5.0/4.0/3.0/2.0 and implemented controller actions and Views, Partial Views, Areas, Sections, Strongly Typed Views and View Models with State Management, Security, Caching features and optimization configuration.

Proficient knowledge in Entity Framework 6.0/4.3/Core Code First and Database First approaches with ASP.NET MVC 5.0/4.0 and ASP.NET Core 2.0/1.1 to implement CRUD operations, data massaging, Fluent API with LINQ to Entities.

Skilled in developing .NET Security features such as Authentication & Authorization, Forms-based Authentication, OKTA integration, OAuth user-based authentication and token based authentication.

In depth knowledge in working with attribute routing, data serialization and model binding in Web API.

Leveraged web services with technologies like SOAP, REST, XML and WSDL. Knowledgeable on REST services using ASP.NET Web API and C#, used Web API to provide services to HTTP Requests. Good understanding on design, and deep functional experience in creating, deploying and consuming RESTful Services with Web API.

Well experienced in developing Single page applications (SPA) and client-side functionalities with various rich UI and responsive features along with performance functionalities in web applications using frameworks and concepts like jQuery, AJAX, JSON, HTML 4/5, XML, XSLT, XHTML, Angular JS 1.5/1.6, Angular 2/4/5/6, Bootstrap and Angular Material.

Proficient in implementing Filters, Validations, Controllers, Components, Directives, Routings, Factory and Services in AngularJS 1.5/1.6 and Angular 2/4/5/6.

Efficiently used Data access techniques to connect, retrieve and manipulate the database information using ADO.NET objects like Data Sets, Data Reader and Data Adapter.

Expertise in database design (RDBMS), programming, implementation and development using MS SQL Server 2005/2008/2012/2017. Analytical and conceptual skills in database related work primarily with creating complex Stored Procedures, Views, Triggers, Functions, T-SQL, Indexes, Cursors, and Performance Tuning using tools like SQL Profiler.

Proven expertise in report writing using SQL Server Reporting Services (SSRS) / SQL Server Integration Services (SSIS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Experienced in version control systems such as Team Foundation Server (TFS), VSTS, Git and Subversion for active tracking of work progress and maintaining code repository.

Expertise working with build tools like Gulp, Grunt, Webpack based of NPM package management and NodeJS.

Goal oriented, highly organized and can achieve targets as an individual or as a team member and exhibits very good communication and inter-personal skills.

EDUCATION QUALIFICATIONS

Bachelors: Computer Science and Engineering from Jawaharlal Nehru Technical University, Hyderabad.

TECHNICAL SKILLSET

Microsoft Technologies

ASP.NET Core 2.0/1.1, ASP.NET 4.6/4.5/4.0/3.5/2.0, MVC 5/4/2, Entity Framework 6 / Core, Web Forms, WCF, ADO.NET, Azure, Nuget

Programming languages

C# .NET, HTML, JavaScript, CSS, SASS/LESS, TypeScript, T-SQL, LINQ, XML, Razor syntax

Front End Technologies

HTML 4/5, CSS3, Bootstrap, jQuery, AJAX, Angular 2/4/5, AngularJS, Angular Material, JavaScript, TypeScript, NPM, NodeJS, Bower, Gulp, Grunt, Webpack, Telerik

Framework

.NET Framework 4.6/4.5/4.0/3.5/3.0/2.0, .NET Core

Protocols

TCP/IP, HTTP, UDP/IP and FTP.

Services

WCF, SOAP, Web API, JSON, XML, JWT, Postman

Web Servers

Microsoft IIS (8.0/7.0/6.0/5.0)

Database

SQL Server 2017/2012/2008/2005, T-SQL

Version Control Tools

Team Foundation Server 2013/2010/2008, GitHub, GitLab, Git, SVN

IDE Tools

Visual Studio 2015/2012/2010/2008, Visual Studio Code, SQL Server Management Studio, VSTS, Microsoft Azure, NUnit

WORK EXPERIENCE

Client: Kansas Departmet of Labor, Topeka, KS Jan 2018 – Present

Role: Full Stack Developer

Responsibilities:

Involved in understanding and analyzing client business, requirements for the system.

Developed two angular 6 web application one for intranet users and the other for the internet users.

Angular application that follows public conventions is established on features like modules, components, services, dependency injection and tools like angular-cli, Webpack, Angular Material.

Designed angular application using the latest Typescript language and with tools like ts-lint to follow general Typescript conventions.

Designed a RESTful .NET Core API that will serve as a backend for the both external and internal angular application.

Worked with third party RESTful API using HttpClient in .NET Core.

.NET Identity core authentication is used to let only authenticated users to access the site.

Worked on AD authentication for the admin site.

Handled Reset Password, Change Password, Change Email using the token-based mechanisms provided by identity core.

Worked with the SMTP services provided by .NET Core.

Used LINQ to SQL and LINQ to Objects for retrieving the data efficiently and just in time manner.

Worked with SSMS to interact with SQL Server.

Involved in updating the data model of the application.

Git source control is utilized to keep the history of code changes.

Worked with Git IDEs like SourceTree to perform checkouts, commits, pushes, and merges.

Performed Unit Testing, Integration Testing and Regression testing for all units in developed pages in a regular basis using NUNIT Tool to improve the performance of the application.

The process of deploying the application onto the IIS server is handled.

Demonstrated the UI modules to Users with bi-weekly meetings as per the SPRINT.

Environment: SDLC, .NET Core, ASP.NET Core Web API, Entity Framework Core, Visual Studio 2017, Visual Studio Code, C#, CSS3, HTML5, JavaScript, TypeScript, Angular 5, Angular Material, AJAX, NPM, Node.js, Angular CLI, Azure, SQL Server 2017, SSMS, Source Tree, GitLab, Webpack, OKTA, JSON, LINQ, IIS.

Client: Aetna, Richmond, VA March 2017 – Jan 2018

Role: Full Stack Developer

Responsibilities:

Involved in implementing the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories, and iterations and responsible for specifications review and part of estimation of deliverables.

Developed the application using N-Tier architecture using C#, ASP.NET Core, Entity Framework Core, LINQ, Web API, HTML5, CSS3, JavaScript.

Extensively used Angular 2/5 and Angular Material on frontend. Utilized Angular directives, factory, service and filters. Created custom directives to reuse them across the application, to create own HTML tags and induce functional behavior to those tags.

Used Dependency Injection for injecting various Angular services to Angular Controllers to enable AJAX calls. Also Implemented Angular 5 Services to bind the data and provide access to the data on the server.

Created an Angular 5 Routing Module to connect different controllers to the views within the single-page application.

Worked with Angular Material, a UI Component framework which provides a rich set of well-tested, reusable and accessible components, to build an enterprise level application.

Flexbox, a new layout mode in CSS3 implemented through the Angular Flex Module was used to design a completely responsive layout for the application to support all devices and sizes.

Created various RESTful Web API services to return serialized JSON data consumed through Angular services.

Made use of NPM (Node Package Manager), a package manager for Node.js to download and define all required packages and their versions.

Angular CLI, a command line interface was used with Node.js modules for initializing, building, developing and scaffolding angular apps.

Leveraged Entity Framework Core and made LINQ queries to connect to the database and implemented CRUD functionality with Code First and Database First approaches for an ASP.NET Core Web API application.

Maintained both Web API hosting and client Angular application on Azure.

Used OKTA, an external authentication platform, through public APIs for authentication and authorization purpose.

JWT (JSON Web Token) was used for transmitting JSON identity and access tokens securely among different parties.

Created and maintained database schema, tables, views, stored procedures and indexes for better performance using SQL Server 2017.

Created and maintained the Microsoft Azure Database instance used by the application.

Used SSMS for configuring, managing and administrating all the changes in SQL Server.

Utilized Git on GitLab for source control to keep track of new and past versions of code written in the application.

Worked with Git IDEs like SourceTree to perform checkouts, commits, pushes, and merges.

Made use of different build tools like Webpack in conjunction with Angular CLI and Node.js to develop the application for multiple environments as well as implement build and compilation scripts for production ready code.

Client: Pentagon Federal Credit Union, Alexandria, VA January 2016 – March 2017

Role: Full Stack Develeoper

Responsibilities:

Used AGILE SCRUM methodology to deliver in sprints and Status Meetings and Code Review Meetings.

Implemented UI using HTML5, CSS3, JavaScript, AngularJS, Angular2, AJAX, Bootstrap to create responsive web pages and developed user friendly layouts.

Angular Modules are created to keep all the related components of an application together.

To transfer the application data between models and views Data Binding is used with the help of different in-built Directives.

Multiple AngularJS Controllers were developed to connect the various services and views within the SPA.

Implemented AngularJS services that were injected into the application controllers to run HTTP calls to the backend Web API endpoints and return the JSON data to the controllers and views.

Utilized CDN hosted libraries to decrease the resource pulls from the server and to decrease the application load time as common libraries like lodash or MomentJS can be cached.

JWT Token authentication through Web API was used as the identity and access token method to provide the Angular application access to the backend Web API endpoints.

Designed and created the backend SQL Server databases, models, and relationships through a Code First approach within Entity Framework.

Worked on complete SSIS life cycles including creating SSIS packages, building, and executing the packages in multiple environments: development and production.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using SQL Query Analyzer in MS SQL Server.

Designed and developed Extraction, Transformation, and Load (ETL) scripts utilizing T-SQL and provided solutions to critical issues by enhancing performance of the ETL processes.

Created complex Stored Procedures, Triggers, Views and queries that combined multiple models and complex relationships within good execution plans to meet transactional and reporting data needs.

Implemented SQL Server Reporting Services (SSRS) reports within the environment to meet data reporting needs.

Used VSTS version control system to keep track of all changes to source code and deal with branching and merging when developing features or enhancements outside of the main branch.

Bundling and minification for all HTML, Javascript, CSS and Image assets was implemented through Gulp tasks and executed as NPM/Node commands.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

Environment: Visual Studio 2012, Visual Studio Code, .NET Version 4.5, Entity Framework, ASP.NET Web API, C#, CSS3, HTML5, Twitter Bootstrap, JavaScript, jQuery, Angular JS, Angular 2, AJAX, SQL Server 2012, T-SQL, Gulp, NUnit, SSRS, SSIS, SSMS, JWT, IIS, VSTS.

Client: Wipro, INDIA. January 2012 – December 2013

Role: .NET Developer

Responsibilities:

Followed Agile SCRUM Developmental approach to deliver product releases by SPRINT processes in an iterative and incremental approach (SCRUM).

Used HTML, JavaScript and CSS throughout the application to add content rich and interactive web pages.

Used JSON/AJAX and Custom HTML Helper Classes to implement asynchronous calls to the server for updates.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope using the ASP.NET MVC framework

Paging, filtering, sorting and searching on the data in table was done through Telerik Grid component for a consistent look and advanced data display functionality within the application

Added new functionality to existing tools and web solutions using ASP.NET MVC, Razor and Entity Framework.

Implemented communication mechanisms between View to Controller using View Bag, Temp Data and Action Results and Controller to View using Model Binder, Http Request Collection and State Models.

Used LINQ to Entities extensively to query and filter the models to be displayed on view.

Implemented WCF Services with various contracts like Service Contracts, Operation Contracts, Data Contracts, Message Contracts and Fault Contracts.

Developed CRUD functionality in ASP.NET MVC with the help of Entity Framework Code First and Database First approaches.

Designed and developed different database objects containing functions, triggers, store procedures with T-SQL to manipulate database of the application.

Diagnosed and tuned different performance issues with SQL Server DMV's.

Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Managed and hosted applications on IIS Web Server including dealing with properties like application configuration, HTTPS certificates, Pathing, and Bindings.

Implemented Unit Testing, Integration Testing and System Testing using NUnit.

Involved in Unit Test cases, code review checklist preparation and validation.

Utilized Team Foundation Server (TFS) for version control during development and maintenance.

Environment: Visual Studio, .NET 4.0/3.5, C# 4.0, ASP.NET 5.0/4.0, MVC, EF, WCF, HTML, CSS, JavaScript, AJAX, JSON, SQL Server 2012, SSMS, SQL Profiler, SQL Server Agent, LINQ, T-SQL, Telerik, NUnit, IIS, TFS.

Contact this candidate