Post Job Free

Resume

Sign in

Asp.Net Sql Server

Location:
Texas City, TX
Salary:
80$
Posted:
August 18, 2023

Contact this candidate

Resume:

ASandeep Kumar Bijili

989-***-****

ady1is@r.postjobfree.com

Professional Summary:

. Around 11+ years of experience in IT industry in design, development,

application architecture, and maintenance of web-based technologies using

Microsoft .NET technologies.

. Proven track record of team leadership, system analysis, design and

implementing flexible solutions with an expertise in object-oriented

software development using Microsoft technologies and Relational

Databases.

. Substantial experience in various .NET applications using Visual Studio

.NET 2012/2010/2008 technologies like C#.Net, Angular 13, Angular 8, Node

Js, React JS, VB.net, Asp.net, Microservices, Telerik Controls,

Silverlight, AJAX, XML and Java Script.

. Built microservices for a time management application using CQRS pattern.

. Vast experience in database systems namely My SQL, MS SQL server, Oracle

PL/SQL, PostgreSQL, MS Access, NOSQL and Oracle.

. Developed and deployed Docker containers on Kubernetes.

. Worked on an Identity project which involved authentication and

authorization.

. Thorough knowledge on working with OpenID connect and oAuth 2.0.

. Good experience in working with solution protocols including HTTP, SAML,

oAuth, JWT.

. Experienced in implementing .NET Security features like Authentication

and Authorization using Form-based and Window-based authentication,

Authorizing Users, Roles and User Account Impersonation, tracing.

. Developed and maintained web applications using the React Boilerplate

framework.

. Experience with working on GraphQL on server side for applications using

ReactJS 16, 17 and Redux.

. Experience in AWS services. Worked on AWS EKS on one of most my projects

at Arcoro.

. Hands on experience in DTS, ETL, Creating Jobs, Packages, and Reporting

Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) on

SQL Server Database.

. Experience in working with large datasets on Synapse SQL, Azure Data

Studio, etc.

. Extensive knowledge of developing stored procedures, Triggers, functions

and optimizing queries for performance using MS-SQL Server & SQL

Profiler.

. Experienced in designing and developing .NET applications.

. Built messaging microservice on ASP.NET Core to provide real-time SMS

notifications.

. Developed code for the database applications to interact with the

database, which use ADO.NET, ADO and Customized frame works.

. Ability to write and interpret complex shell scripts in Bash, PowerShell.

. Comprehensive experience with LINQ to Objects, LINQ to SQL, and LINQ to

XML.

. Good understanding and working experience with ASP.NET providers.

. Experienced in resolving the problem logs and bugs logged by testers and

businesspeople in the .NET applications.

. Experience with developing web applications by using MVC, MVP SOA,

architecture, and Application Blocks.

. Experience working on Crystal Reports.

. Experience with version control systems TFS and Source Safe.

. Design and implementation for hosting large, complex applications in

Azure.

. Experience in consuming and publishing web services.

. Knowledge on AJAX Control Toolkit and AJAX Extensions.

. Worked with Azure pipelines and Azure DevOps.

. Worked extensively with ADO.NET objects such as Data Adapter, DataSet,

and Data Reader to interact with data bases like SQL Server

2008/2005/2000 & Oracle 11g/10g/9i.

. Excellent written and oral communication skills, capable of explaining

complex technical issues in easy-to-understand terms.

Technical Skills:

Programming Languages C# 4.5/3.0/2.0, VB.NET, C, C++, VB6.0

Operating Systems Windows Vista/XP/2000, Windows Server 2008/2003,

MS-DOS

Web Technologies ASP.NET, MVC framework, JavaScript (jQuery plus

Node, Angular 13, Angular 8, React, or Backbone)

HTML 5/ CSS DHTML, CSS, AJAX, XML, Web Services,

Couchbase, WCF, Silverlight, WPF, Microservices.

Web/Application Servers Internet Information Services 7.0/6.0/5.0, REST,

SOAP.

Integrated Development Visual Studio (2013, 2012, 2010), Eclipse.

Environment

Databases SQL Server 2014/2008/2005, MS Access, Oracle 12g,

MySQL, PostgreSQL, Cassandra, SOLR.

Scripting Languages JavaScript, Angular JS, Angular 13 4, 6, PowerShell,

React JS, Node Js, jQuery, VB script.

Testing tools NCoverage, NUnit, TFS Test Framework

Reporting Tools Crystal Reports, SSRS, Active Reports

Versioning tools Visual Source Safe, TFS, SVN, GitHub.

Education:

. B-Tech from JNTU, Hyderabad, India -2011

. Master of Science from Central Michigan University, USA. (Aug 2013 - Dec

2014)

. Master of Business Administration from Central Michigan University, USA.

(Aug 2013 - Dec 2014)

Professional Experience:

Client: CDK Global - Austin, TX

Dec 2022 - Till Date

Role: Principal Software Engineer (.NET)

CDK Global focuses on providing end-to-end, omnichannel retail commerce

solutions to our partners in the automotive, heavy truck, recreation, and

heavy equipment industries. We are a leading provider of integrated data

and open, agnostic technology to nearly 15,000 retail locations in North

America

Responsibilities:

. Worked on OEM Service application, which is built on .NET Core, ASP.NET,

EF Core 6, React 17, SQL Server.

. Designed and implemented the application using Microservice architecture

for its various distinct advantages like loose coupling and design

patterns.

. Developed and maintained web applications using the React Boilerplate

framework.

. Utilized the React Boilerplate's scalable architecture and best

practices to build robust and performant front-end applications.

. Writing Complex SQL Queries and Stored Procedures using SQL Server

Management Studio.

. Designed and implemented Restful API layer along with calls to consume

an API Layer.

. Optimized application performance by implementing code-splitting, lazy-

loading, and other performance optimization techniques provided by the

React Boilerplate.

. Collaborated with the backend BFF applications to define and integrate

RESTful APIs.

. Conducted thorough testing, including unit tests and integration tests,

using tools like Jest.

. Implemented efficient state management solutions, such as Redux or React

Context API, to handle complex data flows and shared states across

components.

. Collaborated closely with product managers, designers, and backend

developers to gather requirements and translate them into architectural

decisions.

. Utilized middleware Redux Saga, to handle asynchronous operations,

including API calls and side effects.

. Integrated Redux with React components to connect them to the

application state and dispatch actions.

. Optimized performance by utilizing memoization techniques and reselect

library to avoid unnecessary re-renders.

. Integrated AWS SDKs or APIs into applications to interact with S3

services programmatically.

. Implemented file upload and download functionality using AWS S3,

ensuring efficient and secure data transfer.

. Integrated Bamboo with version control systems (e.g., Git, SVN) to

trigger builds and deployments on code changes or merges.

. Designed and implemented build and release workflows using Bamboo,

ensuring reliable and consistent software delivery.

. Managed and organized project backlogs and user stories in Jira,

enabling efficient backlog grooming and sprint planning.

. Experience in developing Microservices using ASP.NET core.

. Conducted regular Veracode scans to identify security vulnerabilities

and weaknesses in software applications.

. Collaborated with development teams to prioritize and address identified

vulnerabilities, ensuring the timely resolution of security issues.

. Interpreted scan results and provided actionable recommendations for

remediation based on Veracode's findings and best practices.

. Implemented secure user authentication mechanisms, such as

username/password-based authentication, token-based authentication

(JWT), or OAuth.

. Used OpenID Connect and Auth 2.0 for authentication and authorization

middleware layer.

. Utilized C# attribute-based authorization to enforce authorization rules

and restrict access to specific resources or actions.

. Utilized Azure services and resources, such as Azure App Service, Azure

Functions, Azure Storage, and Azure Cosmos DB, to build scalable and

reliable cloud-based applications.

. Utilized Azure monitoring and logging tools, such as Azure Monitor and

Azure Log Analytics, to monitor and analyze application performance,

availability, and security.

. Wrote units test on Xunit for backend APIs and services in microservice

architecture project.

. Integrated Azure services with other components, such as databases,

message queues, and third-party APIs, to create end-to-end solutions

Client: Arcoro - Scottsdale, Arizona

Nov 2021 - Dec 2022

Role: Principal Software Engineer (.NET)

Arcoro is a leader in Human Resource industry, targeted towards

construction businesses. The company provides end-to-end tools for all the

HR needs for an organization. The company offers various modules such as

Onboarding, Talent, ATS, Reporting, TimeSheets, etc. to its customers.

Responsibilities:

. Architected multi-app, multi-tenant data warehouse and ELT in Azure

Synapse Analytics.

. Steered platform development of internal Angular 13 framework to improve

engineer efficiency and application consistency.

. Built an Identity project from scratch to enable Authentication and

Authorization of users using oAuth 2.0 and OpenID connect.

. Design solution for various system components using Microsoft Azure

Databricks, Datalake.

. Worked with cloud services like Azure, AWS and involved in ETL data

integration and Migration.

. Experience with Cloud hosting and administration in AWS or Azure.

. Defined AWS security groups which acted as virtual firewalls that

controlled the traffic allowed to reach one or more AWS EC2 instances.

. Experience writing and deploying AWS Lambda functions.

. Created Business Logic Layer & Data Access Layers to implement the MVVM

and SOA architecture.

. The HTTP based RESTFUL API service was developed using .NET Core WEBAPI,

C#, .NET Framework 4.5, LINQ, T-SQL. The service used a claims based

authorization model.

. Manage environments for legacy codes using specific Docker containers

based on the required architecture.

. Developed and deployed Docker containers on Kubernetes.

. Writing SQL Stored Procedures which are helpful for reports and also

involved in Creating Reports using SSRS and Crystal Reports on Oracle

databases.

. Writing Complex SQL Queries and Stored Procedures using SQL Server

Management Studio.

. Designed and implemented Restful API layer along with calls to consume

an API Layer.

. Rewriting the legacy windows forms applications into web based

application using web forms and client side technologies like jQuery,

JavaScript, JSON Data, NodeJS, Angular 13, 8, React Js.

. Part of gathering requirements, design, and development of project by

using WPF, OOPS concepts and solid principles.

. Lead a team of 8 people to design and develop a web-based project.

. Experience in developing Microservices using ASP.NET core.

. Designed and implemented the application using MicroService architecture

for its various distinct advantages like loose coupling and design

patterns.

. Day to Day responsibilities include gathering requirements from the

business team and estimate the hours required to complete the

requirements.

. Prepared business documents and ppts of the requirements of the project.

. Had regular meetings the users to get the business requirements.

. Worked on a POC from scratch and deployed the in the windows server.

. Experience in Functional Programming and was a key part of developing

BDD approach in the project.

. To enable efficient and effective high-quality software development by

developing Agile Software Development methodologies.

. Creating the design of security module that authenticates users based on

the roles and issue of permissions based on the roles.

. Styling the Web Forms using HTML5, CSS3, Bootstrap, Data tables, Font-

Awesome.

. Also involved in Discussion Board for Client Interaction for the change

requests and follow-ups.

. Developed middle layer using C#.NET, VB.NET and ASP.NET.

. Involved in complete application stack in Amazon Web Services (AWS) like

EC2, S3 bucket.

. Used Telerik Chart Control to display the data in graphical format.

. Experience in Implementation of Token base security using Restful API.

. Developed the web pages using Angular 13 Class Libraries with the best

practices.

. Involved in Design and Developing components of the applications using

ASP.NET, MVC, C#, VB.NET, JavaScript, Knock Out Js, jQuery.

. Used Entity Framework Code First Approach and issued queries using LINQ,

then retrieve and manipulate data as strongly typed objects and adapted

an automated mechanism for accessing and storing the data in the

database.

. Used ASP.NET validation controls and JavaScript for implementing Server

and Client side validations.

. Implemented ASP.NET MVC Validation implemented at Controller level.

. Used LINQ to SQL as the data provider for communicating with SQL Server

Database.

. DevOps experience with continuous security testing and automation on

public clouds such as Google Cloud, Azure and AWS.

. Used forms-based Authentication and role-based Authorization for

security.

. Reviewed and modified programs to ensure technical accuracy, security

and reliability of applications.

. Also Involved in Testing, Debugging, Maintenance/Enhancement of Project

and code review of the Applications.

. Experience with build and release and PowerShell Scripting.

. designed and development for Azure PaaS environment.

. Maintained timelines as per the estimate and finishing it on time with

quality.

. Responsible for the Deployment in the client environment.

. Created joins, views, functions, stored procedures and triggers as part

of the database programming.

. Prioritized query optimization and Involved in performance tuning.

. Utilized Kubernetes and Docker for the runtime environment of

the CI/CD system to build, test deploy on the AWS server.

. Researching and documentation of new technologies which are helpful for

development of application.

. Utilized TFS for source code maintenance among the whole team members.

. Performing Unit Testing on my part of the application developed using

Karma.

. Also Involved in Testing, Debugging, Maintenance/Enhancement of Project

and code review of the Applications.

Environment: Agile, Visual Studio 2012/2017, .Net Framework 4.0/4.5,

VB.NET, AWS ASP.NET MVC, Entity Framework, ASP.NET Web Forms, Knock Js,

WPF, Js, Microservices, jQuery, AJAX, ADO.NET, MongoDB, React Js, TFS, Node

Js, Data tables, AWS, EKCS, Type Script, HTML5, T-SQL, SQL Server 2014,

.net core, SSRS, SSIS, Crystal Reports, Docker, Azure, Angular 13, 8.0.

Client: JBS - Greeley, CO

Aug 2019 - Nov 2021

Role: Software Engineer IV

JBS is the world's meat processing producer. It processes various meats

like Beef, Pork, Chicken across the globe, operating in around 57

countries. JBS USA is headquartered in Greeley, CO and is a pioneer in Beef

market.

Responsibilities:

. Design, build, develop, maintain and support the organization

applications (both stand alone and web based).

. Design each piece of an application or system.

. Work closely with the Development team to create new Enchantments for

the application, an application developed with following technologies:

Dot Net, Oracle,React Js, jQuery, Kafka, View Js, Java Script, HTML,

Azure, Win Forms, Micro Services, Web Services, Postman, and SSRS.

. Analyze user needs and software requirements to determine the

feasibility of the design within time constraints.

. Worked on JWT token authentication and SAML authentication.

. Worked on a single page application built with Angular along with the

Apollo client for GraphQL interactions.

. Development of the proof of concepts and confer with the system analysts

and programmers to obtain information on project limitations,

capabilities, performance requirements and interface and making sure the

application meets the organization framework standards.

. Document design specifications, installation instructions, and other

system-related information.

. Modeling of system database to store, modify, and retrieve data to

generate management Information System that will be maintained and used

at various terminals of the organization.

. Maintain, Repair and chance the computer system upgrades.

. Create a variety of models and diagrams.

. Extensively used Telerik UI Controls for advanced WPF and Silverlight.

. Communicate with staff or clients to understand specific system

requirements.

. Analyze users' needs and then design, test, and develop software to meet

those needs.

. Work with groups of Software Engineering to complete the daily tasks

assigned by the team lead.

. Working closely with the business team to improve the features of the

application.

. Select appropriate design solutions or ensure the compatibility of

system components.

. Analyzing and improving system capabilities by using various performance

tuning methods and Provide Technical guidance and Support to users on a

Regular Basis.

. Developing a proof of concept project for the users to get an approval

for the budget for future projects.

. Recommend software upgrades for programs and systems

Environment: C#, ASP.net, Visual Studio, Web Services, ADO.Net, Angular

CLI, SQL Server, MySQL, Oracle 12g, MS Access, PL/SQL, ASP.NET, HTML4,

HTML5, Js, Rabbit MQ, Kafka, WPF, Docker, JavaScript, View JS, SSAS, SSRS,

MongoDB, MS- Project, OOPS.

Client: JBS - Greeley, CO

Nov 2018 - Aug 2019

Role: Full Stack Dot Net developer

JBS is the world's meat processing producer. It processes various meats

like Beef, Pork, Chicken across the globe, operating in around 57

countries. JBS USA is headquartered in Greeley, CO and is a pioneer in Beef

market.

Responsibilities:

. Part of gathering requirements, design, and development of project by

using OOPS concepts and solid principles.

. Worked on a POC from scratch and deployed the in the windows server.

. To enable efficient and effective high-quality software development by

developing Agile Software Development methodologies.

. Creating the design of security module that authenticates users based on

the roles and issue of permissions based on the roles.

. Rewriting the legacy windows forms applications into web based

application using web forms and client side technologies like jQuery,

JavaScript, JSON Data, AJAX, Angular 4, Angular CLI.

. Styling the Web Forms using HTML5, CSS3, Bootstrap, Data tables, Font-

Awesome.

. Created Business Logic Layer & Data Access Layers to implement the MVC,

SOA architecture.

. Also involved in Discussion Board for Client Interaction for the change

requests and follow-ups.

. Developed middle layer using C#.NET, VB.NET and ASP.NET.

. The RESTFUL API service was developed using .NET Core WEBAPI, C#, .NET

Framework 4.5, LINQ, T-SQL. The service used a claims based

authorization model.

. Designed and implemented HTTP based Restful API layer along with calls

to consume an API Layer.

. Experience in Implementation of Token base security using Restful API.

. Involved in Design and Developing components of the applications using

ASP.NET, MVVM, Knock Js, C#, VB.NET, JavaScript, jQuery.

. Used Entity Framework Code First Approach and issued queries using LINQ,

then retrieve and manipulate data as strongly typed objects and adapted

an automated mechanism for accessing and storing the data in the

database.

. Used ASP.NET validation controls and JavaScript for implementing Server

and Client side validations.

. Implemented ASP.NET MVC Validation implemented at Controller level.

. Used LINQ to SQL as the data provider for communicating with SQL Server

Database.

. Used forms based Authentication and role based Authorization for

security.

. Reviewed and modified programs to ensure technical accuracy, security

and reliability of applications.

. Also Involved in Testing, Debugging, Maintenance/Enhancement of Project

and code review of the Applications.

. Experience with build and release and PowerShell Scripting.

. Maintained timelines as per the estimate and finishing it on time with

quality.

. Responsible for the Deployment in the client environment.

. Writing Complex SQL Queries and Stored Procedures using SQL Server

Management Studio 2014.

. Created joins, views, functions, stored procedures and triggers as part

of the database programming.

. Prioritized query optimization and Involved in performance tuning.

. Writing SQL Stored Procedures which are helpful for reports and also

involved in Creating Reports using SSRS and Crystal Reports using Oracle

databases.

. Researching and documentation of new technologies which are helpful for

development of application.

. Utilized TFS for source code maintenance among the whole team members.

. Performing Unit Testing on my part of the application developed.

. Also Involved in Testing, Debugging, Maintenance/Enhancement of Project

and code review of the Applications.

Environment: Agile, Visual Studio 2012/2017, .Net Framework 4.0/4.5,

VB.NET, ASP.NET MVC, MVVM, Entity Framework, ASP.NET Web Forms, jQuery, Js,

Xamarin, ADO.NET, Microservices, Docker, Windows Forms, SSIS, SSRS, React

Js, TFS, Azure, Data tables, Infragistics, Type Script, T-SQL, SQL Server

2014, SSRS, Crystal Reports, Angular 4.0.

Client: Sandbox Computers - California

Sept 2018 - Oct 2018

Role: Full Stack Software Developer

Sandbox Computers is a starup company aimed at developing software for

school kids which enables them to learn computer science in their schooling

lives. The company offers courses for various section of kids and operates

in 50 different schools across Ventura County in California.

Responsibilities:

. The objective of the project is to develop comprehensive system designed

to manage and maintains the details of Members who have invested an

amount in the firm on interest basis. The modules include Member module,

Accounting Module, Reports Module.

. Analyzed and understood the functionality of product feature.

. Developed an Independent HTTP based API to make calls to third party

service using Screen Scrapes.

. Involved in Requirement gathering, Couchbase, Functional and technical

specification.

. Developed Web forms using ASP.NET server controls and validated input

using Java Script.

. Designed and Developed Disturbed Services for polling MSMQ and Lambda

Expressions with SQL services.

. Developed XML Web Services to communication with Cassandra.

. Assisted in designing, architecture, and development of large-scale web

applications.

. Implemented RabbitMQ message queuing for post processing after

submission.

. Coordinated with other technical teams for development of portal

solutions to support API.

. Used Ajax calls through Handlebars JS and Ember JS to populate the data

tables on the front-end.

. Code review and documentation for the feature.

Environment: MVC Framework, VB.net, Postgres, Couchbase, Disturbed

Services, Rabbit MQ, PowerShell, e-API, AWS, REST, SOAP, Web Services,

jQuery, EC2, DynamoDB, Microservices, Jasmine, Oracle, SQL Server 2008,

Eclipse, Moq, Angular 4.0, React JS, HTML, Kafka, CSS, MSP.

Client: CareSource - Ohio

Jun 2018 - Aug 2018

Role: Software Developer

The objective of the project is to automate the current processes which are

executed manually by people or thru few systems. This automation involves

various process of the systems to come together. This project also includes

a portal for members and providers to get access to information and

services and use them according to their needs. This project uses WEB APIs

to send and receive data through the system.

Responsibilities:

. Analyzed and understood the functionality of product feature

. Worked closely with the business to gather requirements and discussing

user stories during development.

. Involved in requirement gathering, functional and technical

specification.

. Developed the project using ASP.NET CORE using C# 5, ReactJS.

. Used Dapper, Entity Framework as a persistence framework for this

project.

. Used MVC architecture and Entity Framework for this e-commerce

application.

. Used Dependency Injection across the project to enable loose coupling

between classes and also make it easier for unit testing.

. Developed various Web Apis for the project so that these web services

can be used in different ways by various other projects.

. Used HTML5, CSS3, Javascript, Bootstrap, ReactJS to build the front end

of the application.

. Performed client side validation on the web forms using Javascript.

. Involved in building RESTful Services with ASP.NET Web API.

. Used Swagger to interact with the Web APIs.

. Updated grids using Asynchronous Java script and XML, AJAX.

. Worked with API versioning when moving from legacy system to the new

system.

. Worked closely with testing to solve issues and fix bugs if any.

. Participated actively in sprint planning sessions and retrospective by

providing valuable inputs for business to consider.

. Used TeamCity for continuous build integration & deployment.

. Used Octopus Deploy to deploy the code to various environments as the

whole was using a devops model.

. Followed Razor View Engine approach in the MVC Pattern.

. Created automated tests and functional tests using Xunit.

. The project was integrated with Git and also SVN to manage repos.

. The project was using Devops model and there were shorter periods

between deployments.

Environment: MVC Framework, VB.net, Postgres, Couchbase, Disturbed

Services, Rabbit MQ, PowerShell, e-API, AWS, REST, SOAP, Web Services,

jQuery, EC2, DynamoDB, Microservices, Jasmine, Oracle, SQL Server 2008,

Eclipse, Moq, Angular 4.0, React JS, HTML, Kafka, CSS, MSP.

Client: Sandbox Computers - California

Sept 2015 - Jun 2018

Role: Full Stack Software Developer

Sandbox Computers is a starup company aimed at developing software for

school kids which enables them to learn computer science in their schooling

lives. The company offers courses for various section of kids and operates

in 50 different schools across Ventura County in California.

Responsibilities:

. The objective of the project is to develop comprehensive system designed

to manage and maintains the details of Members who have invested an

amount in the firm on interest basis. The modules include Member module,

Accounting Module, Reports Module.

. Analyzed and understood the functionality of product feature.

. Developed an Independent HTTP based API to make calls to third party

service using Screen Scrapes.

. Involved in Requirement gathering, Couchbase, Functional and technical

specification.

. Developed Web forms using ASP.NET server controls and validated input

using Java Script.

. Designed and Developed Disturbed Services for polling MSMQ and Lambda

Expressions...



Contact this candidate