Post Job Free

Resume

Sign in

Sql Server Software Development

Location:
Denton, TX
Posted:
December 05, 2023

Contact this candidate

Resume:

Name: Sai Kiran

Mobile: +1-214-***-****

Email: ad1p2l@r.postjobfree.com

Summary:

Having 8+ years of experience in all the stages of SDLC (Software Development Life Cycle) involving requirements gathering and analysis, architectural design, development, testing, deployment, documentation and production support.

Extensively worked on Console, Windows Desktop, Web and WPF applications using C# as the primary language.

Sound knowledge of Object Oriented Programming (OOPs) principles and various design patterns like Singleton, MVC, MVVM and N-Tier Architectures.

Expert in developing and deploying Web Applications using .NET Core 3.0, ASP.NET MVC 5, Web API, ADO.NET, Entity Framework, LINQ, Web Services, XML, JSON, AJAX Control Tool Kit and IIS 6.0/5.0.

Extensive front end and back end development experience working with .NET Framework 4.5/4.0/3.5 and Visual Studio.

Expertise in implementing Restful services using ASP.NET Web API and XML based web services including SOAP.

Experienced in working with WCF (Windows Communication Foundation) using WSDL and UDDI.

Expertise in designing highly responsive web pages with HTML 5, JavaScript, CSS 3, Bootstrap, jQuery, and Angular JS.

Extensive experience in creating rich content Web and Windows Forms, User Controls, Custom Controls, Server Controls, Windows, and Web Services.

Skilled in consuming third party libraries such as Telerik UI, Telerik Documents and Reporting Services and Aspose.NET.

Expertise in Database Design and Programming (User Defined Functions, Stored procedures, Triggers, Transact SQL) using SQL Server 2008 R2/2012/2014/2016.

Involved in development of projects using SSIS (SQL Server Integrated Services), SSRS (SQL Server Reporting Services) and DTS (Data Transformation Services).

Expertise in using Object Relational Mappers such as Entity Framework, ADO.NET and NHibernate objects such as SQL Command, Data Reader, Data Set and Data Adapter to establish Database connection and retrieve data.

Extensively used LINQ and Lambda Expressions to write queries against strongly typed collections of objects by using language keywords and familiar operators for Data Manipulation.

Experienced in implementing securities like Authentication & Authorization using Forms-based, Windows-based authentication and User Account Impersonation.

Sound knowledge of Software Configuration management with various version control systems such as TFS, VSS, SVN, GIT and Git repositories including Git Hub and Bit Bucket.

Experience in cloud application development, deployment, and worked with development team to create appropriate Azure cloud solutions for client needs.

Experience with Azure DevOps for creating, building, and releasing pipelines and involved in working with logging using log4net and Azure logs.

Good experience with development methodologies including Agile Scrum, Waterfall and Test – Driven development.

Expertise in Documentation (Technical Specification Document), Unit Testing with NUnit and implementing Unit Test Objects to test components and writing Unit Test Cases.

Highly organized, dedicated with a positive attitude along with the strong analytical and trouble shooting skills.

Flexible, enthusiastic, and project-oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Technical Skills:

.NET Tools/Technologies

Microsoft Visual Studio 2017/2015/2013/2012/2010/2008, ASP.NET, .NET Framework 3.0/3.5/4.0/4.5/core/5/6, ADO.NET, LINQ, MVC (2.0,3.0,4.0,5.0), Entity Framework, WPF (Windows Presentation Foundation), NHibernate

Programming/Scripting Languages

C#, VB.NET, C, C++, JavaScript, jQuery, Angular JS, Node JS, Typescript, React JS, VB Script, AJAX

Web Technologies

Windows Services, WCF (Windows Communication Foundation), WSDL, UDDI, SOAP, XML, JSON, Web API, HTML 5, CSS3, Bootstrap

Web Servers

Internet Information Services (IIS 5.0/6.0)

Databases

Microsoft SQL Server 2008 R2/2012/2014/2016, MS Access, Oracle 8i/9i/10g, Database modeling.

Reporting Tools

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Crystal Reports

OS/Methodologies

Windows 7/10 Vista/XP/ 2008/2003, UNIX, MS DOS

Design and Process

MVC 2/3/4/5, MVVM, Singleton Pattern, SPA (Single Page Applications), Waterfall, Agile Scrum, Test Driven Development

Version Control

GitHub, MS Visual Source Safe (VSS) & Team Foundation Server (TFS), SVN, Bitbucket

Cloud Services

Azure Cloud Services, Azure Devops, CI/CD Pipelines

Other Tools/Technologies

Postman, Java, NUnit, Microsoft Visio, Microsoft Excel, Word, and PowerPoint

Work Experience:

Client: Koch Industries, Inc – Wichita, KS Dec 2022 - Present

.Net Developer

Project: CLM – Client Lifecycle Management

Koch Industries Inc is a privately held conglomerate having its client-base all around the globe across its subsidiaries including oil and gas, mining, refining, chemicals and biofuels, fibers industries. Client Lifecycle Management is one such tool that enables the management to streamline the process of managing its clients from registration to maintaining a healthy relationship. I am fully responsible for the end-to-end development of “Documents Management” Module where I am involved in developing the most important features for the users to upload/download/delete/edit/view their documents. I have implemented sorting, filtering, search, and custom views functionalities.

Responsibilities:

Involved in requirement analysis, and application designing sessions with team members and business analysts to outline the proposed IT Solution.

Involved in the design, develop, test and deployment of the Web application for Client Life Cycle Management using .NET Framework 6.0, ASP.NET MVC, Web API Framework using C# along with its front end UI using Razor view engine.

Built RESTful Web APIs using ASP.NET Web API, allowing seamless communication between client applications and server-side services.

Developed business logic including code behind files, user controls, and classes in the middle-tier and robust server side coding with database interactions using C#.

Implemented interactive UI/UX with HTML5, CSS3, Bootstrap and JavaScript frameworks such as Angular JS.

Extensively used Angular JS & Node JS in generating user specific dynamic views and performing front-end validations.

Performed typical operations such as file manipulation, program execution, and printing text using Aspose.Net.

Utilized Object Relational Mappers including Entity Framework, ADO.NET and NHibernate to perform database operations and manage data access in SQL Server and Oracle databases.

Designed and implemented complex SQL queries, stored procedures, and database schema for optimal performance and data integrity.

Implemented data validation and security measures to protect against common web vulnerabilities, such as cross-site scripting (XSS) and SQL injection.

Implemented authentication and authorization mechanisms, such as role-based access control (RBAC) and token-based authentication, using ASP.NET Identity or third-party authentication providers.

Worked on ASP.NET Client Side State Management with View State, Cookies, Query String, and Server Side State Management with Application State, Session State and Profile Properties.

Involved in Azure cloud application development, deployment, worked in integrated development environments, and application lifecycle management components.

Worked on Queues, Blobs, and Containers to persist data on Azure. Used Azure Cloud for Hosting Webservices for retrieval and posting Data to SQL Server for applications.

Implemented continuous integration and deployment (CI/CD) pipelines using Azure DevOps.

Extensively managed environments for legacy codes using specific containers with respect to the prescribed architecture.

Extensively used Git with Bit Bucket code repository for maintaining the version control of the code.

Developed application in Agile model and involved in daily scrum meetings and deployed applications in Dev, Test, QA and Production Environments.

Performed Unit and Functional Testing by automating end-to-end testing with XUnit. Provided technical support and prepared requirements documents for the testing.

Environment: .NET Framework 6.0, ASP.NET MVC, Web API, Entity Framework, MS SQL Server, Oracle, ADO.NET, NHibernate, LINQ, HTML 5, CSS3, Bootstrap, JavaScript, Angular JS, XML, JSON, XUnit, Azure Devops, Git, Bit Bucket.

Client: State of Virginia – Richmond, VA April 2021 – November 2022

.Net Developer

Project: Tele-Support

State of Virginia serves the people and assists them efficiently with telephonic support. I am part of the team providing technical support to develop and maintain web and windows applications to ease the process of providing and tracking assistance to the corresponding people who report their issues via telephone. I was part of developing various features such as to display customer’s issues/complaints/concerns and record/track employee’s communication with each customer. It also has features to set up follow up calls with the customers and an employee dashboard to assess their performance on a daily/weekly/monthly/yearly basis.

Responsibilities:

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

Designed and developed rich and enhanced web pages using ASP.NET MVC 3.0, C#, Entity Framework, JSON, HTML 5, CSS3, jQuery, AJAX, and XML.

Implemented abstract, sealed classes, interfaces, and classes to construct the Data-Access Layer and Business Logic Layer using C# and Entity Framework.

Extensively used HTML Tables as grid for better performance with paging, sorting and filtering operations with data being loaded by Entity Framework, JSON.

Performed client-side validations and made AJAX (Asynchronous JavaScript) Calls for Data Processing.

Utilized the AJAX Control toolkit 2.0 tools like Calendar, dropdown, animation controls for implementing AJAX partial page updates with UI Control elements.

Designed and developed Interactive Graphical User Interface for various modules using WPF (Windows Presentation Foundation), Windows Service, Desktop Applications inheritable Win Forms and User Controls.

Efficiently utilized XML Web Services with SOAP and WSDL to communicate with other applications and components.

Created WCF Service to send and retrieve information from client side and consumed web services using SOAP and HTTP

Wrote well-tuned Stored Procedures, Triggers, Sequences, Functions and Views to access and store/retrieve data into the Oracle and SQL Server databases.

Used Entity Framework and NHibernate in the data access layer to perform Create/Read/Update/Delete operations on the data stored in the MS SQL Server and Oracle 9i Databases.

Developed new user interface components for different modules using Telerik UI, Documents and Reporting Services.

Team Foundation Server (TFS) is used for maintaining the version control of the code actively involved in updating the TFS tasks on daily basis.

Worked closely with peers and cross functional teams to troubleshoot and investigate reported issues. The issues may range from UI, Interfaces, and Databases.

Involved in making migrations of application from on-premise production servers to Azure Cloud.

Performed Integration Test, Unit Test and Regression Test with improved debugging standards with automation using NUnit.

Actively Involved in writing the technical specification document for the developed modules.

Environment:

C#, .NET Framework 4.5 ASP.NET MVC 3.0, MS SQL Server 2012, Oracle 9i, Entity Framework, WCF, WPF, SOAP, JavaScript, jQuery, Telerik UI, TFS, AJAX, HTML, CSS, Visual studio 2012, NUnit, Azure Cloud.

Client: Entellisoft Technologies-Hyderabad, INDIA Jan 2018 – Dec 2020

.Net Developer

Project: Meet Up (Appointments Scheduler).

Meet Up is a web application internal to Advanced Health Media used by healthcare professionals to schedule individual appointments with peers and register for conferences, meetings and medical gatherings. It offers a dashboard for the users to see individual appointments and invites for the meetings/conferences and enables users to accept/decline and there by blocking their calendars. It allows the users to provide their feedback and reviews for each conference they have attended. It enables users to record important notes for future follow ups. It also has an interface for the users to provide digital signature if needed any.

Responsibilities:

Designed and developed web pages with ASP.NET Server Controls using VB.Net, ASP.NET, Java Script, HTML and XML.

Involved in developing Data Access Component to establish the SQL Server Database connectivity using ADO.NET.

Used NHibernate features, in the data access layer which was built to implement Read/Write operation on the Oracle 8i database.

Designed and developed web forms using user ASP.NET controls Server Controls with Client side validations using Java Script and Angular JS.

Wrote well-tuned Stored Procedures, Functions and Views to access and store data into the SQL Server, Oracle 8i and DB2 databases.

Written T-SQL queries, Cursors, Triggers to handle the business rules, data integrity and for various data transactions and also generating reports using DB2 and SQL Server Databases.

Developed web services with SOAP and consumed it using WCF Framework and Angular JS to make HTTP requests.

Developed Single Page Applications using ASP.NET Framework with Angular JS on the front-end and C# as the primary language for Business Layer with Controller Actions.

Involved in the Design and development of Web Forms.

Utilized Collections Objects and wrote type safety compliance code to manage run-time errors or performance issues.

Used Angular JS Dependency Injections to inject objects into a class, instead of relying on the class to create the object itself.

Involved in developing Web.Config file and used Forms based authentication for the Security.

Involved in creating Assemblies (.NET Components).

Developed a Search Engine to search for the User’s information from the database.

Involved in creating User Control to display like Menu on the Web Pages.

Co-ordinate with clients and business analysts' team for understanding of requirements.

Maintaining a web application using IIS 6.0. Involved in documentation of the project.

Performed Restful API Testing by developing automation framework from scratch with Selenium.

Worked on ASP.NET features like state Management, caching features, configuring optimizations and securing web application.

Utilized BitBucket with Git for maintaining the version control of the code actively involved in updating the branches on daily basis.

Environment:

ASP.NET, C#, VB.Net, HTML, Visual Studio 2010, JavaScript, Angular JS, WCF, SOAP, Ajax, MS SQL Server 2010, SSRS, IIS 6.0, Oracle 8i, DB2, Selenium, Git, Bitbucket.

Client: RIGELO SYSTEMS-Hyderabad, INDIA Sep 2015 – Dec 2017

.Net Developer

Project: CCTL (Cement and Concrete Testing Laboratory)

CCTL conducts inspection on building & Construction materials to certify for its quality and durability. The main goal of this project is to automate the process of inspection by replacing the paperwork with electronic means. We developed a web application that could be used by the inspectors to record their findings while inspection and revisit later to make digitally sign and prepare the final report with just a click. It uses Aspose.Net framework to generate reports in doc and pdf formats.

Responsibilities:

Involved in the logic extraction, requirement gathering, design and development of the project.

Impact analysis for all the changes suggested to the backend batch processes.

Detailed design for the redesigned SQL workflows.

Developed GUI for the windows application using ASP.NET. Worked on modules implementing the business logic in VB.Net and C#.

Developed ASP.NET Web API based on departmental requirements and specifications.

Worked with advanced concepts of ASP.NET MVC such as Models and Providers, Filters used for developing backend technology.

Established Communication between web server (UI) and application server through XML based web services.

Created user controls to work with UI and performed front-end validations using JavaScript and jQuery.

Coded stored procedures, functions, and complex T-SQL Queries for the automatic batch processes on SQL Server Database with Entity Framework.

Creating Database Design, Database Triggers and Stored Procedures for ensuring data integrity and consistence.

Established connectivity with DB2 Database and executed SQL Queries to run the test scripts.

Implemented JWT Token based authentication to secure the ASP.NET Web API and provide authorization to different users.

Utilized Team Foundation Server (TFS) for maintaining the version control of the code actively involved in updating the TFS tasks on daily basis.

Environment:

ASP.NET MVC 3, C#, VB.Net, Web API, MS Visual Studio 2005, Windows Forms, Web Services, HTML, CSS, JavaScript, jQuery, ADO.NET, WPF, T-SQL, SQL Server, DB2, TFS, Aspose.Net.



Contact this candidate