Post Job Free

Resume

Sign in

Software Development Sql Server

Location:
Frisco, TX
Posted:
April 17, 2024

Contact this candidate

Resume:

aws

E-Mail: ad421u@r.postjobfree.com Phone: +1-469-***-****

Professional Summary:

Over 10+ years of experience in IT including Analysis, Designing, Development, Testing, Bug fixing and Implementation in the Software Development Life Cycle (SDLC) of Client/Server and Web Technologies for various N-Tier applications.

Proficiency in development using Microsoft.NET technologies like ASP.Net, C#, VB.Net, ADO.Net, Web Services, MVC, AJAX, Windows Services, WCF Services, OOPS, XML, XSLT, SOAP, LINQ Text Editor, MS IIS … DHTML, VBScript, VSS, JavaScript, SQL Server.

Experience in designing web pages using HTML, JavaScript, HTML, CSS and jQuery, Angular JS, AJAX, Bootstrap and JSON, Node JS, UML.

Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and Language Integrated Query (LINQ) Providers for data manipulation.

Experience in working with ASP .NET MVC and Entity Framework as ORM Mapping tool for Data Access layer.

Extensive experience in Responsive web-based page and site designs using HTML, XHTML, DHTML, CSS, Bootstrap and AJAX.

Work experience on Visual Cron Client 9.2.0 to run the Batch Operations using Stored Procedures.

Thorough knowledge of Waterfall and Agile Methodologies in Application Development with hands on experience working in Agile Development Team following SCRUM Methodology and paired programming using Test Driven Development (TDD).

Experience in Designing, Development and Deployment of High - Performance, Scalable, Distributed, ASP.NET Applications. Experience in Test Driven Development (TDD) and Automation.

Experience with Web Service, WCF (Windows Communication Foundation) and ASP.NET Web API.

Good knowledge on Microservices, AWS (Amazon Web Services), working with EC2, RDS, Dynamo DB, S3, Cloud watch and Docker.

Work experience on Windows Azure, Azure Active Directory, and SQL azure, creating resource groups, subscriptions, build definitions and release definitions.

Experience with Microsoft Azure Services like IaaS and PaaS.

Highly Knowledgeable in latest client-side open-source frameworks such as Angular and experienced in frameworks Angular JS, ReactJS & jQuery.

Designed frontend web-based form using ReactJS & Angular 8/7/6/4/5/4/2 with Ajax controls CSS and HTML5.

Used Node.JS, React.JS, and Backbone.JS MVC framework for developing the Single Page Application (SPA).

Object pool a standard solution to common problems in software design.

Experience in creating Validation Controls for front-end validation.

Experience in development and usage of Web Services using WSDL, SOA, UDDI and SOAP.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server.

Proficient in developing REST Services and integrating them with Client Server Architecture. Implemented several REST Services with Node JS as Backend and Angular as Frontend.

Experience in advanced JavaScript/UI frameworks like Angular 7, Bootstrap and jQuery.

Implemented UI using MVC, HTML, XML, CSS, JavaScript, Angular 7, AJAX and Web Form Controls to create responsive web pages, developed Master Pages.

Implemented filtering, sorting and pagination using third party tools and Angular 7 framework.

Experience in handling databases like MySQL and NoSQL databases like MongoDB.

Developed several SOAP and REST API based internal tools to enhance quality and performance of existing code base and deployed in Cloud Foundry, AWS S3.

Design & implement end-to-end automation of infrastructure and continuous delivery of the applications by integrating Cloud Formation scripts, Jenkins, Ansible and AWS.

Strong knowledge in designing, developing reports using MS-Access, SQL Server Reporting Services.

Designed fronted web-based form using Angular 7/6/4/5/4/2 with Ajax controls CSS and HTML5.

Proficient developing applications using MVC, Blazor server - side and WEB API with Entity Framework.

Knowledge of using Continuous Integration / Continuous Deployment (CI/CD) tools as Jenkins.

Experience in Creating Unit Testing applications and Unit Testing with N-Unit.

Strong Experience in Design & Development of Client-Server & Web applications using Object Oriented Analysis and Design (OOAD) methodologies.

Technical Skills:

.NET Technologies

.Net Framework 4.5/3.5/3.0/2.0, ASP.NET CORE, ADO.NET, ASP.NET 4.5, C#.NET, AJAX Extensions, AJAX Control Toolkit, XML Web Services, ADO.NET, LINQ, WPF, MVVM, WCF, WWF, Silverlight, MVC, Blazor, ActiveReports v15.

Web Technologies

AJAX, JavaScript, VBScript, HTML 5, XHTML, DHTML, Flash, XML, XSLT, XAML, CSS 3, ASP, Knockout JS, Angular JS, Angular 7.

Databases

SQL Server Microsoft Azure, Oracle 10g, MS Access, SQL, MySQL, T-SQL, PL/SQL.

Reporting Tools

Crystal Reports, SSRS, SSIS

Version Control Tools

Team Foundation Server (TFS), SVN, Visual Source Safe (VSS).

Development tools

Microsoft Visual Studio, Visual Studio Code, Visual Cron Client 9.2.0

Methodologies

Client/Server Architecture, N-tier application architecture, OOA, Prototyping, Process Models, Systems Integration, SOA.

Development Methodologies

MVC architecture, Agile, Scrum.

Servers

IIS 7.0/6.0, Windows Server.

Education:

Master’s in Computer Science at University of New Haven

Professional Experience:

Client: Deutsche Bank Nov 2022 to till now.

Role: Sr. .Net Full Stack Developer

Responsibilities:

Design advanced .NET cloud and web applications using C#, ASP.NET, MVC 5/6, .NET web APIs, .NET Core 6, Entity Framework, and Azure PAAS technologies.

Involved in different phases of SDLC including requirement analysis and architectural design phases of the project using Agile methodologies.

Involved in iterative, test - driven and SCRUM method of Agile Methodology.

Worked on Visual Studio/ .NET Core Framework to implement Business Logic.

Coded business logic and database logic using Entity Framework and Repository Pattern.

Experience in Oracle and PL/SQL development implementing Stored Procedures, Functions, Triggers and Packages.

Hands on experience working on TOAD.

Used Entity Framework LINQ to entity for data access.

Responsible for creating efficient design and developing User Interaction screens using HTML, CSS3, Bootstrap, JavaScript, Angular 10.

Collaborated with the project manager and team members to plan project sprints and define user stories and tasks in Azure DevOps.

Collaborated with the DevOps team to define build and deployment processes, including setting up test environments, packaging the application, and automating deployment to staging and production environments.

Utilized debugging tools and techniques, such as breakpoints, watch windows, and logging, to identify and fix software defects.

Created complex SQL queries involving joins, subqueries, and aggregations to extract specific data sets required for reporting and analysis.

Utilized T-SQL to perform data manipulation tasks, including inserting, updating, and deleting records in the database.

Implemented advanced T-SQL features like user-defined functions (UDFs), views, and dynamic SQL for flexible data retrieval and processing.

Built Angular 10 components, UI services to consume REST services using Component based architecture provided by Angular 10.

Involved in creating a new model for an Entities and write a mapping for these Entities based on UML diagrams/Design architecture.

Created RESTFUL services using Web API, built HTTP services and formatted responses using web API media type formatter to JSON.

Implementing Azure Logic Apps, Azure Functions, Azure Storage and Service Bus Queues for large ERP Systems.

Developed and Scheduled Data Load jobs in Data Studio Tool/Cosmos Ul using Scope Scripts from both Structured and Non- Structured streams.

Responsible for implementing the token-based Authorization to the service endpoint.

Created Email notification service endpoint and, involved in designing the email HTML templates.

Created/Modified Stored Procedures, Triggers and Views in SQL and effectively used within the application and developed complex SQL queries.

Developed controller and service methods using TDD (Test Driven Development) methodology and developed unit and Integration tests by using Sonar Cloud.

Experienced in Configuration Management, setting up company Version policies, build schedule using Jira.

Experience in requirement gathering, analysis, design, documentation, unit test case reparation, coding and unit testing, code review, SLA based application support, SIT, and bug fixing, issue troubleshooting, UAT support, production implementation, post production support, root cause analysis and enhancement.

Environment: Visual Studio, NET Core Framework, C# .NET, HTML5, Entity Framework, Agile, Webservices, Azure, AJAX, Windows, JavaScript, CSS, SQL Server, COSMOS DB, Bootstrap, AngularJS (v13.0), Web API, IIS, iQuery, Jira, GitHub, Jenkins.

Client: State of Florida July 2021 to Oct 2022

Role: Sr. .Net Full Stack Developer

Responsibilities:

Effectively involved in various stages of development of the project starting from the project planning until production and maintenance using agile methodology.

Developed and assisted in migration of web application.

Utilized reusable components and guards to better accommodate the complete web application.

Performed code review, worked close to team members to ensure consistence to code standards.

Designed and developed application using C#.NET, ASP. Net MVC and deployed into App Service in Azure.

Test Driven Development (TDD) can be implemented using the NUnit Framework for unit testing and ability to load, explore and execute tests.

Used Agile practices and Test-Driven Development (TDD) techniques to provide reliable, working software early and often.

synchronization of data between the model and view components.

Developed and assisted in migration of web application to Angular 7 Application.

Designed the application using one-way/two-way databinding, filters, UI-routers and created custom directives in Angular 7.

Used Angular-CLI for initializing and project setup with scaffolding features.

Implemented UI grid, tables and several widgets in Angular 7.

Created a RESTful Web API service using ASP.NET Web API to generate data for the EMS which was then consumed in the front-end by Angular 7.

Implemented MVC frameworks like Angular.JS and Backbone.JS.

Proficient with front-end design tools like AngularJS, Angular, Material, Ui-Grid, Bootstrap, MatBlazor, CSS.

Implemented CRUD operations using $http service to call Web API methods.

Implemented a Single Page Application client-side UI using Blazor.

Helped implement the DAL layer of Web API using Entity Framework 5.

Working on Azure for universally available customer facing B2B and B2C applications.

Monitored via remotely run scripts Ambari, Azure Data Factory and Blobs.

Azure Storage development and design utilizing Blobs, Pages, Queues, Tables and VM's.

Library work involved designing classes to programmatic control of Azure.

Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings.

Maintained existing cloud environment using Microsoft Azure.

Created a database known as SQL AZURE database, which integrates with Active directory and Hadoop.

Deployed and Maintained windows phone applications on Azure cloud technologies.

Utilized Azure SQL Server for storing the data related to the recruitment and Wrote Efficient queries and stored procedures that saved the manual efforts of cleaning the data and efficient data handling and sanitized data.

Used Sessions, Cookies and Application-Level State Management in Application.

Created tasks for updating toconfig tracked files based on glob, tslinting, and compiling typescript files.

Updated dashboard front-end to support multiple dashboards and their CRUD operations using typescript.

Performed validations on Web Forms using .NET Validation Controls and Client-Side Validation using Angular4.

Implemented the service using Node.JS, a.JS for performance, development, maintenance & deployment reasons.

Implemented Azure SQL, Azure Storage and Azure Services.

Used Azure BLOB to access required files and Azure Storage Queues to communicate between related processes.

Using ADO.NET Entity Data Model in retrieving data using LINQ to SQL and LINQ to Objects with ASP.NET.

Developed several REST web services supporting both XML and JSON to performed tasks.

Used Sub Version Control (SVN) for repository/Code version Management.

Using Team Foundation Server as a source control.

Environment: ASP.NET, C#, MVC, WCF, WPF, Web API, .Net Framework 4.5, NUnit, HTML5, CSS3, AJAX, CSS, Angular 7/4, SQL Server, MS Access Database, Kendo UI, Azure, ADO.NET, Entity Framework, Visual studio 2017/2015, Blazor, JavaScript, jQuery, Azure, MVVM, SSIS, SSRS, MS SQL Server, TFS, UNIX, Agile.

Client: United Parcel Services (UPS), MD. April 2019 to June 2021

Role: .Net Full Stack Developer

Responsibilities:

Involved in all the phases of Software Development Life Cycle (SDLC) including Requirements gathering, Designing, Programming, Testing and Documentation of various projects.

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

Implemented Security, Routing, bundle configuration, Action Selectors, Action Filter, and Caching in MVC controllers for application development.

Installing, configuring and administering Jenkins Continuous Integration (CI) tool on windows machines along with adding/updating plugins such as SVN, GIT, Maven, ANT etc.

Used Microservice architecture, based services interacting through a combination of REST and leveraging AWS to build, test and deploy Identity Microservices.

Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket.

Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS).

Implemented and maintained the monitoring and alerting of production and corporate servers/storage using AWS Cloud Watch.

Created a Restful Web API service using ASP.NET Web API to generate data for the EMS which was then consumed in the front-end by ReactJS components.

Utilized react to create intuitive user interfaces, enhancing application usability and performance

Collaborate with front-end developers to implement responsive and visually appealing user interfaces, leveraging HTML, CSS, JavaScript, and frameworks like React.

Developed Screens, modules, events, classes, and functionalities on C#, vb.Net, ASP.NET MVC, Entity Framework Core, .Net Core, react based applications to meet the client requirements as per the Business Rules.

Using ReactJS for the UI design for single page application.

Designed Frontend within object-oriented JavaScript framework like React.JS and Required.JS.

Implemented client-side Interface using React Js.

Worked in using React Js components, Forms, Events, Keys, Router, Animations and Flux concept.

Built React components and stand-alone functions that needs to be added to any future pages.

Responsible for developing a front-end application using React Js and FLUX architecture for internal team’s productivity use.

Set up and configuration of various instruments on AWS direct connect to create DEV/IT, UAT and Production environment for short-term internal projects.

Used Entity Framework and LINQ to access the two databases so the user could create, edit, display, and delete data from the application’s UI.

Worked with ASP.NET Web Forms, Web Services, and State Management, caching features, configuring optimizations and securing the web application.

Used AJAX to retrieve the data from database asynchronously.

Used GIT version control to manage the source code and integrating GIT with Jenkins to support build automation and integrated with JIRA to monitor the commits.

Performance tuning of SQL queries, procedures using SQL Profiler and Index Tuning Wizard.

Implemented logging, Error handling by using Event Handler and Custom Logging for various SSIS packages.

Generated several drills down and drill through reports using SSRS.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Environment: React JS, Web API, .Net Framework 4.5, IIS 7.5, ASP.NET C#, Entity Framework, Bootstrap, Visual Studio 2015, Mongo DB, SSIS, SQL Server 2012, 2019, HTML, CSS, VB.NET, WCF, ADO.NET, MVC, JQUERY, KnockoutJs, NUnit, SQL Server Management Studio.

Client: State Farm, Bloomington, IL . Oct 2017 to Mar 2019

Role: .Net Full Stack Developer

Responsibilities:

Designed, modeled, architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) service hosted in a Windows service to support Distributed computing.

Product development is an Agile (SCRUM) methodology, where progress and task assignment are discussed in everyday meetings.

Developed dynamic ASPX pages for Application using ASP.NET MVC, C#.NET and HTML.

Worked with ASP.NET MVC 3.0, Partial Views, and Master Pages and developed Cascading style sheets (CSS) for consistent look and feel of the website.

Created Visual Cron Client jobs to run the Batch Operations using SQL Stored Procedures for both Incoming and Outgoing jobs to send and receive the extracted data with third party clients.

Created excel reports using C# and SQL Stored Procedures to extract the data by running Job ID’s.

Designed and generated PDF forms with barcodes using Active Reports 15 in C#.

Provided technical design and support on a project while leading hands-on coding efforts utilizing ASP.NET, .NET Framework REST Services.

Designed and developed UI components and implemented event handling using C#, HTML, CSS, JavaScript, jQuery, AJAX, and Worked on CSS to get consistent look and feel of the web site.

Developed various services in angular that consume rest services from the backend written in .NET.

Leveraged Angular resources for all data access, encapsulating URLs and standardizing data access interfaces.

Created a RESTful Web API service using ASP.NET Web API to generate data for the EMS which was then consumed in the front-end by AngularJS.

Designed AngularJS Modules and Controllers using different directives like ngShow, ngRepeat,

Established communication from AngularJS Project to Web API Project.

Developed web application using ASP.NET MVC 5 (Model-View Controller) and AngularJS.

Designed the application using an MVC (Model View Control) Architecture that promotes clear separation of the presentation, business logic and data access tiers.

Setup development environment using latest Blazor.Net with Asp.NetCore 3.0.

Created Forms that provide Asynchronous operations using AJAX Helper Class to provide functionalities like Partial Page Rendering, Client-Side Validations, Error Handling and Auto Complete to optimize UI.

Worked with Web API to provide services to HTTP requests.

Worked with IIS 7/6 and .NET Assemblies during application deployment.

Involved in developing SQL Stored Procedures, Views and SQL functions for dashboard, rule engine, permission, notification and workflow database operations.

Worked on Middle layer for data access components in ADO.NET and C# classes.

Developed style sheets for UI design and layout.

Designed an Enrolment UI for the project, where one can register with personal details.

Designed and developed UI using ASP.NET, HTML, CSS, jQuery, JSON and AJAX.

Built an image asset library using Knockout.js and Backbone.js as part of the same overall project.

Edited and corrected errors in jQuery functions for improving performance of a page.

Experience with razor code in View pages.

Working with QA team in automating SOA Testing.

Created Stored Procedures, SQL statements, Functions to manipulate the databases.

Developed applications in Test driven environment-using Unit testing.

Performing unit testing on logics that are being built.

Environment: Visual Studio 2019, .Net framework 4.5, C#.Net, MVC 5, ADO.net, TFS, Entity Framework 4.0, SQL Server 2012, AWS, Active Reports 15, Visual Cron Client 9.2.0, AJAX, JavaScript, Angular.js, Node.js, Knockout.js, WCAG, XML, HTML5, CSS3, Bootstrap.js, Blazor, Crystal Reports, IIS 7.0, Visio, OOPS, XAML, WPF, JSON, LINQ, JIRA.

Client: GWS, Virginia, VA. Oct 2014 to Sep 2017

Role: .Net Developer

Responsibilities:

Involved in development life cycle, from design phase to implementation phase, testing and deployment.

Followed Agile Methodology to produce high Quality software and satisfy the customers.

Involved C# .NET, ASP MVC, Razor, XML, HTML5, CSS3, HTML/CSS, JavaScript, jQuery, SOAP and REST APIs.

Used Model View Controller Architectural Design Patterns for the development of the product.

Developed xml documents.

Implemented Client-side validations using Data Annotations.

Designed and developed the user interface for various tools and implemented ASP.NET validation controls, JavaScript, jQuery, CSS for server and client-side validations, respectively.

Made full use of .NET object-oriented features (C#), event handling, error handling, caching and security feature.

Developed Web Services which can be used by number of clients in getting useful data.

Extensively used WCF services, thereby achieving complete Service Oriented Architecture.

Used jQuery UI controls, Templates and Widgets to Support the UI.

Designed, coded and modified applications by using ASP.Net.

Used LINQ and ADO.NET for developing data access layer.

Worked with data migration. Used tools like MS SQL Server integration services (SSIS) in transferring data from one database to another.

Created Database objects like Tables, Stored Procedures and Triggers in MS SQL Server.

Used ADO.NET objects such as Data Reader, Data Adapter and Data Set to object data source fetch and handle user data. Provided codes to perform Unit Testing.

Deployment of Application on Test and Production server.

Responsible for maintaining versions of source code using Team Foundation Server.

Environment: C#, ASP.NET, MVC, ADO.NET, VB.NET, HTML5, CSS3, Visual Studio 2012, SQL Server, SSIS SQL Server Integration Services, Razor View Engine, WCF, Web services, C#, UML, XML, CSS, AJAX, HTML, JavaScript, jQuery, TFS, LINQ to SQL and Windows Server.

Client: BNYM, Overland Park, Kansas.

Role: .NET Developer Feb 2014 to Sept 2014

Responsibilities:

Designed and Developed web application using .NET framework.

Understanding the Business requirements and preparing the functional requirements on a task’s implementation.

Created a user control on presentation layer, the Business and Data Access Layers were coded Developed application using C# and Object-oriented programming structure.

Developed Web forms using C#, ASP. Net, JavaScript, and CSS.

Created WCF web services for implementing business logic.

Create Restful API with using Web API.

Developed and maintained stored procedures, User Defined Functions, Indexes, Views, Tables, and Relationships on SQL Server 2012 database.

Implemented dynamic page elements and various controls for form error validation and implemented custom validation controls with JavaScript and jQuery.

Written Parameterized Stored procedures, Views, complex queries, and functions for data manipulation and querying data from SQL Server.

Worked on Stored Procedures by getting the more number Parameters to the procedures and developed with the loop functions on condition parameters.

Environment: Visual Studio, C#, ASP. Net, ADO. Net, HTML, CSS, jQuery, JavaScript SQL Server and TFS.

PRADEEP REDDY

Sr. Full Stack .Net Developer



Contact this candidate