Post Job Free

Resume

Sign in

Asp.Net Sql Server

Location:
Lansing, MI, 48933
Posted:
April 26, 2024

Contact this candidate

Resume:

Name: Amresh Charan

Phone: 856-***-****)

Email: ad5atn@r.postjobfree.com

Tech: .Net Developer

Professional Summary:

●Overall 12+ years of experience in Microsoft Dot Net (ASP.NET, JavaScript, Dotnet Core, ReactJS, jQuery, Web API, Entity Framework, Microservices, AZURE DevOps, Docker, kubernetes,), backend (SQL Server, Oracle), testing, deploying and documentation of software solutions.

●Experienced in requirement gathering using methods like document analysis, workshops, use cases, business process documents scenarios, business analysis, workflow analysis.

●Involved in design confirmation, development & documentation of software life cycle.

●Used agile methodology in projects and also used tools like Mir board, JIRA, and Confluence.

●Technical lead for PSEG generation project using ASP.Net, C#, JavaScript, JQuery, SQL server, configuring of tags, creation of tags, adding user and trusts, archive backup, troubleshooting, creation of interfaces, monitoring status of plants using process-book, maintaining multiple interfaces and instances, monitoring the OSI PI customization like PI ACE (with ASP.Net)

●Experienced in MVC programming using ASP.NET, SQL server, WCF, Entity Framework

●Hands-on experience in building UI Applications using ASP.Net, Java Script, HTML5, CSS, Boot Strap, JSON, AJAX, JQuery.

●Experience in deploying applications in IIS on-Prem and cloud (Azure cloud).

●Worked as a senior developer for the project Raw Materials Distribution system in Phase-I and Phase-II using C#, JavaScript, SQL Server, Oracle, Sybase, Robo Help, VSS, Unit Testing, System Integration Testing.

●GIS Developer cum analyst using ASP.Net, C#, Silverlight, ORACLE, Water GEMS, ARCGIS Suite.

●Experienced in implementing multi-threading to achieve performance, concurrency.

●Experience with RDBMS concepts like Functions, DML SQL queries, Stored Procedures and PL/SQL programming.

●Worked in historian databases like OSI soft PI which stores the time series data.

●Experienced in writing SQL queries and stored procedures in MS SQL and Oracle.

●Experienced in ASP.Net with PI SDK programming customization for real time series data with OSI Soft PI suites.

●Hands on experience with version control systems like GIT, BIT Bucket, VSS and SVN.

●Skilled in different tools like MS Visual studio, VS Code, Postman, Fiddler.

●Experienced in unit testing, system testing, and performance testing of web applications.

●Expertise in debugging the applications using Visual studio and Chrome and Edge debugger.

●Experienced in deploying applications on Application Server

●Experienced in applications support and maintenance post implementation.

●Experienced in creating batch files, automation tools to monitor applications health.

●Imparted training to new joiners in the organization on ASP.Net/SQL Server.

●Possess good analytical, problem solving, communication and inter-personal skills.

Technical Expertise

Elements

Particulars

Primary Skills

Asp.Net, C#, Dotnet Core, JavaScript, JQuery, MVC patterns, JSON, HTML, CSS, REST Web API, PowerShell, Entity Framework

Operating Systems

Windows (Server 2008R2, 2012,2016, 2019),AWS Workspace

Languages

Asp.Net, C#, Dot Net Core, Java Script, JQuery, React JS, PowerShell, XML, HTML, SQL, Oracle

Development Tools

Microsoft Visual Studio IDE, Postman, Fiddler, Azure DevOps, GIT, JIRA, Confluence, Visual Studio Code

Databases

SQL Server, Oracle, Sybase, PostgreSQL, Historian database(OSI Soft PI)

Source Code Management

SVN, GIT, BitBucket, VSS, docker

Client / Server Technologies

WCF, Web Services, WebAPI

Education details with University Name: MCA, BITS Mesra

Professional Experience:

Client: Builders First Source/Mphasis.

Role: Dotnet Developer

Location: New Jersey, USA

Period: March 2023 to till date

Description:

Builders First Source is the nation’s largest supplier of structural building products, value-added components and services to the professional market for single-family and multi-family construction and repair and remodeling. Its focus is on providing unparalleled service to both large and small customers.

BLP- is the Buy logic Pro website to be used by the buyers to handle POs-(Purchase Orders) and RFQs (Request for Quotations). Buyers send the RFQs to vendors from BLP and then vendors respond from Vendor portal and based on the competitive price the vendor is selected.

It is a development project and has several modules like Purchase Orders, RFQs, Manage Users, Vendors, Contacts, Locations, search module etc. It makes use of Dotnet-C#, Dotnet Core, Web API, Entity Framework SQL Server, AZURE DevOps.

The main objective of this project is to:

•Manage POs details

•Manage POs and RFQs details

•Integrate it with Vendor Portal created in REACT and Web API

•Provide validations of interactions using MuleSoft API

•Provide authentication/authorization to the user

•Provide ease to the buyers, Vendors and admins

Responsibilities:

•Develop console and web applications or libraries for different modules

•Create web services/WCF to be consumed by other external or internal modules.

•Create stored procedures to be used in different modules.

•Integration of dot net modules with other interfaces using ASP.Net (C#), Dotnet core(C#), Entity Framework, MVC and Web API.

•Create Stored procedures, functions in SQL Server

•Attend daily scrum call using Agile board

•Add tasks to Agile board

•Develop code/fix issues based on the sprint [REACT code fix, back-end code fix, Web API code fix]

•Convert old Dotnet framework to higher framework or to Dotnet core.

•Manage configuration of code base using Azure GIT.

•Create Microservices for the Vendor Portal and make them deployable and testable.

•Manage Azure CI/CD, deploy code base, release code.

•Work on performance tuning of the developed modules both at the code side and database side.

•Used these WEB API to increase the page response and better performance of the application. There were pages which were using traditional Stored Procedures and later we implemented Web API and EF to provide better performance, scalable and cloud deployable.

•Do development testing and help the testing team to do the testing.

•Review the code of team members, mentor and guide the juniors

•Work on sprints and update status in the Agile board

•Schedule and provide a demo to the product owner to show the product.

•Schedule retrospectives and list down the points. Attend sprint planning and provide estimates.

Environment: Visual Studio 2022(ASP.Net, C#, Web API, MVC, Dotnet core, REACT, Entity Framework), SQL Server, AZURE DevOps, JavaScript, jQuery, POSTMAN, WCF Test client)

Client: Publix Super Markets Inc.

Role: Dotnet Developer

Location: Florida, USA

Period: 16th Sep 2022 to Feb 2023

Description:

Publix is a privately owned company and its stock is not publicly traded. You must be a Publix associate to invest in Publix stock. Publix Asset Management Co. manages global investments through successful asset allocation and securities selections, total AUM for portfolios over $15 billion. They invest in equity, fixed income and alternatives securities with substantial out-performance over benchmarks in the time managed.

SMS-Stock Management System project is a development project which deals in providing better user experience to the Stockholders management. It keeps the details of the interactions of stockholders like stock buy and stock sell details, stockholder personal details like name, SSN, address, party ID, number of stocks purchased, dividend, date of birth, death. It also has SHSS (Stockholder Self Service) where a stockholder can raise their request for fulfillment.

This SMS is integrated with SHSS to flow the data from SMS to SHSS and vice versa. It is a development project and has several modules like Interaction module, Sell/Purchase module, validation module, search module, SAP processing module. It makes use of Dotnet-C#, VB, Dotnet Core, WCF, Web API, SQL Server, AZURE DevOps.

The main objective of this project is to:

•Manage stock holder details

•Manage stock holder’s interaction details

•Provide better UI for customers and business

•Provide validations of interactions using SAP data

•Provide stockholder self service

•Provide authentication/authorization to the user

•Provide ease to the stockholders and administration

Responsibilities:

•Develop console and web applications or libraries for different modules

•Create web services/WCF to be consumed by other external or internal modules.

•Create stored procedures to be used in different modules.

•Integration of dot net modules with other interfaces using ASP.Net (C#), Dotnet core(C#), Entity Framework, MVC and Web API.

•Create Stored procedures, functions in SQL Server

•Attend daily scrum call using Agile board

•Add tasks to Agile board

•Develop code/fix issues based on the sprint [Angular code fix, back-end code fix, Web API code fix]

•Convert old Dotnet framework to higher framework or to Dotnet core.

•Manage configuration of code base using TFS/Azure GIT.

•Create Microservices for the SHSS and make them deployable and testable.

•Manage Azure CI/CD, deploy code base, release code.

•Work on performance tuning of the developed modules both at the code side and database side.

•Implemented multithreading to achieve performance, concurrency.

•Used these WEB API to increase the page response and better performance of the application. There were pages which were using traditional Stored Procedures and later we implemented Web API and EF to provide better performance, scalable and cloud deployable.

•Do development testing and help the testing team to do the testing.

•Review the code of team members, mentor and guide the juniors

•Work on sprints and update status in the Agile board

•Schedule and provide a demo to the product owner to show the product.

•Schedule retrospectives and list down the points.

•Using OSI Soft PI dashboard for reports, PI AF sdk,

•Attend sprint planning and provide estimates.

Environment: Visual Studio 2022(ASP.Net, C#, VB.Net, Web API, MVC, Dotnet core, Entity Framework), SQL Server, AZURE DevOps, JavaScript, jQuery, POSTMAN, WCF Test client

Client: Healthy Paws Pet Insurance

Role: Sr. Dotnet Developer

Location: Long Island, New York

Period: 3rd Aug 2021 to 13th Sep 2022

Description:

Healthy Paws Pet Insurance project is a development project which deals in providing better insurance to pets. Similar to health insurance for humans, pet insurance covers the cost of medical treatments for unexpected injuries and illnesses. It provides dog insurance and cat insurance. It covers claims for kidney failure, heart disease, ear infection etc.

This Healthy Paws Pet Insurance project is a development project and has several modules like Data Reconciliation, Bot processing, claim wizard, Dashboard, Audit and trail, Salesforce etc. It makes use of Dotnet-C#, Dotnet Core, BOT, Web API, SQL Server, Tesseract-OCR, ReactJS (POC).

The main objective of this project is to:

•Provide role-based accesses

•Provide better UI for customers and business

•Provide automated processing of claims

•Provide better audit and trail

•Reduce manual efforts while validating and approving claims

•Data reconciliation process also takes place

Responsibilities:

•Develop console applications or libraries for different modules

•Integration of Dotnet modules with other interfaces using ASP.Net (C#), Dotnet core(C#), Entity Framework, MVC and Web API.

•Create SQL database, SQL tables, indexes, SPs, functions, Views

•Attend daily scrum call using Agile board

•Add tasks to Agile board

•Develop code/fix issues based on the sprint [Front-end code fix, back-end code fix, Web API code fix]

•Manage configuration of code base using BitBucket/Git

•Create Microservices for the dashboard, audit and monitoring, claim wizard and make them deployable and testable.

•Containerize components using Dockers and Kubernetes.

•Manage Azure CI/CD, deploy code base, release code.

•Work on performance tuning of the developed modules both at the code side and database side.

•Implemented multi-threading to achieve performance, concurrency.

•Used these WEB API to increase the page response and better performance of the application. There were pages which were using traditional Stored Procedures and later we implemented Web API and EF to provide better performance, scalable and cloud deployable.

•Do development testing and help the testing team to do the performance and regression testing.

•Review the code of team members, mentor and guide the juniors

•Work on sprints and update status in the Agile board

•Schedule and provide demo to the product owner to show the product.

•Schedule retrospectives and list down the points.

•Attend sprint planning and provide estimates.

•Team handling was also one of my activities

Environment: Visual Studio 2019(ASP.Net, C#, Web API, MVC, Dotnet core, Entity Framework), SQL Server, AZURE DevOps, JavaScript, jQuery, Tesseract-OCR

Client: Shell Oil and Gas

Role: Sr. Dotnet Developer

Location: Houston, Texas

Period: 14th Feb 2020 to 30th July 2021

Description:

Shell EBS project is a development/enhancement project which is comprised of global monitoring facilities uniquely delivering continuous, consistent and automated Exception Based Surveillance (EBS) to contribute to asset integrity, deferment reduction, increased operational performance and regulatory compliance. It takes the plant information in real time across North Americas, South Americas and Gulf of Mexico. Used the OSI PI System and software application modules from OSI soft, an SQL relational database and the Web Intelligence reports platform as the foundation for the new system — including interfaces for OPC, RDBMS.

The main objectives of this new system will be to:

•Delivering continuous, consistent, and automated Exception Based Surveillance

•Asset integrity,

•Deferment reduction,

•Increased operational performance

•Regulatory compliance

Responsibilities:

•Project enhancement and integration with other external interfaces using ASP.Net (C#) and Web API, Entity Framework, Javascript, jQuery.

•Create database entities like database, tables, views, Indexes, procedures and functions.

•Create C# class libraries for reusability of similar functionalities.

•Created Web API to increase the page response and better performance of the application. Identified the traditional Stored Procedures and later we implemented Web API and EF to provide better performance, scalable and cloud deployable.

•Create Microservices for the reporting, role management, dashboard, Exception workflow and made it deployable and testable.

•Implemented multi-threading to achieve performance, concurrency.

•Attend daily scrum call using Agile board

•Add tasks to Agile board

•Update the documents in confluence page for central repository

•Handling junior team members from technical perspective

•Develop code, fix issues of front end and back end and do data validation if any.

•Do development testing and help the testing team to do the performance and regression testing.

•Code review and walkthrough

•Provide demo to the product owner to show the product.

•Attend retrospectives and log the review comments.

•Incorporate review comments if any after product demo.

•Provide estimates during sprint planning and prioritize task as per the product owner.

Environment: Visual Studio 2019(ASP.Net, C#, Dotnet Core, Web API, MVC), SQL Server, JavaScript, jQuery, Kendo UI, AZURE devops, OSI-Soft PI DA, PI AF, OPC interfaces.

Client: PSEG Generation Project

Role: Dotnet Developer

Location: Newark, New Jersey

Period: 10th Feb 2016 to 10th Feb 2020

Description:

This joint project between the engineering and information technologies (IT) departments used the OSI PI System and software application modules from OSI soft, an SQL relational database and the Web Intelligence reports platform as the foundation for the new system — including interfaces to the company’s SAP enterprise computing systems and the SAP plant maintenance (PM) module. The system was installed and PSE&G began to predict failures using a combination of: conditioned assessment algorithm results, experience from internal subject matter experts (SMEs), and OSIsoft’s client tools (Process Book and Datalink). Now the system is estimated to have saved PSE&G more than $300,000 in maintenance and capital costs.

The main objectives of this new system will be to:

•Change maintenance practices from reactive to proactive

•Re-orient corrective maintenance procedures

•Redirect capital expenditures more efficiently, based on planned replacement of equipment rather than replacement following a failure

•Reduce equipment failures

•Reduce order management expenses, maximize equipment performance, optimize asset replacement strategy

•Better prioritize maintenance orders based on OSI-PI applications

Responsibilities:

•Creation of new web pages using Asp.net, C#, MVC, Entity framework

•Creation of views, stored procedures, functions, triggers, indexes

•Creation of C# helper classes for reusability

•Creation of JavaScript helper classes for validation and reusability

•Creation of unit test cases

•Creation of WebAPI and microservices for customer, assets and outages.

•Creation of C#.net code for integration with Outage Management System (OMS)

•C#.net code for integration with Geographical Information System (GIS) having Oracle DB.

•Project maintenance and integration with other interfaces

•Helping business with user acceptance testing

•Daily wellness checks of the OSI-PI servers, AF servers using SMT, process book, datalink and PI-SDK, database servers and application servers

•Investigate the root cause and create support tickets

•Analyze the existing system and propose enhanced and automated mechanism

Environment: Visual Studio 2008(C#, Asp.Net, Dotnet core, Entity Framework), SQL Server, Oracle, JavaScript, jQuery PI-SMT, PI-DATALINK, PI-PROCESSBOOK, ICU, INTERFACES, RLINK, PE, PI-ACE, PIAF,

Client: NAT-STEEL Integration and Enhancement project

Role: Dotnet Developer

Location: Kolkata, India

Period: 15th April 2015 to 09th Jan 2016

Description:

NatSteel Holdings is the leading provider of steel in the Asia Pacific region. It has operations in seven countries: Singapore, China, Thailand, Vietnam, Malaysia, the Philippines and Australia. The company became a part of Tata Steel in 2005 and produces about 2 million tons of premium steel products. The business scenarios are more on make to order and very few cases for make to stock for Standard Mesh products. Below are the products from Downstream.

•Cut and Bend (CAB)

•MESH

•PRECAGE

•BORED PILE CAGE (BPC)

•COUPLERS

Responsibilities:

•Project development, maintenance of real time data and integration

•Webpages creation using C#.net, Javascript, WCF, SQL Server

•Update of C# helper classes in DAL, BAL, UI based on the changes

•Create SQL server tables, indexes, Stored procedures, functions, views

•Developing the front-end code for integrating with Oracle and SQL Server and OSI-PI servers

•Creation of JavaScript generic functions as library for reusability

•Unit and system testing

•Writing JavaScript validations

•Integrating the web services in the front-end page and creating PI Webparts

Environment: Visual Studio 2010(C#), SQL Server, Oracle, JavaScript, WCF,

OSI Soft (PIOLEDB), Process Book, PI Datalink, PI-SMT and enhancing PI-ACE, PE.

Client: IPC-NRC project

Role: Dotnet Developer

Location: Kolkata, India

Period: 21st Mar 2014 to 10th April 2015

Description:

Nickel Major is the second largest producer of Nickel in the world. It has its mines across different geographies.

The manufactured Products business at NICKEL MAJOR has grown exponentially over the past year and has now become a billion-dollar business. The sale of manufactured products at Nickel Major, which includes the sale of intermediate products and copper products such as copper anodes and copper concentrate, has grown significantly over the past years. This represents a need to develop an EIS system as an integrated system for both Finished Products and Raw Material Products, new system development is needed. System which was to be developed using Microsoft .Net 3.5 and SQL Server 2005 as the Database. OSI PI is used to keep the records of historian database. The customization in the OSI PI is needed with .net for preparing the SPC charts. PI calculations are done using OSI PI.

Responsibilities:

•Project Coordination/development (Onshore)

•Developing the front-end code for integrating with OSI PI

•Webpages creation using C#.net, Javascript, WCF, SQL Server

•Update/create of C# helper classes in different layers based on the changes

•Create SQL server tables, indexes, Stored procedures, functions, views

•Unit and system testing

•Writing JavaScript validations

•Integrating the web services in the front-end page

Environment: OSI PI with PI sdk, Visual Studio 2008(C#), SQL Server, javascript, WCF

Client: VALE(EIS) project (OSI PI with ASP.Net)

Role: Dotnet Developer

Location: Kolkata, India

Period: 21st Dec 2013 to 17th March 2014

Description:

Nickel Major is the second largest producer of Nickel in the world. It has its mines across different geographies.

The manufactured Products business at NICKEL MAJOR has grown exponentially over the past year and has now become a billion-dollar business. The sale of manufactured products at Nickel Major, which includes the sale of intermediate products and copper products such as copper anodes and copper concentrate, has grown significantly over the past years. This represents a need to develop an EIS system as an integrated system for both Finished Products and Raw Material Products, new system development is needed. System which was to be developed using Microsoft .Net 3.5 and SQL Server 2005 as the Database. OSI PI is used to keep the records of historian database. The customization in the OSI PI is needed with .net for preparing the SPC charts. PI calculations are done using OSI PI.

Responsibilities:

•Project Coordination/development (Onshore)

•Developing the front-end code for integrating with OSI PI

•Webpages creation using C#.net, Javascript, WCF, SQL Server

•Update of C# helper classes in DAL, BAL, UI based on the changes

•Create SQL server tables, indexes, Stored procedures, functions, views

•Unit and system testing

•Writing JavaScript validations

•Integrating the web services in the front-end page

Environment: Visual Studio 2008(C#), SQL Server, OSI PI with PI sdk, JavaScript, WCF

Client: JUSCO-GIS/ IMIS project

Role: Dotnet Developer

Location: Kolkata, India

Period: 4th April 2013 to 10th Dec 2013

Description:

Mysore City Corporation (MCC) decided to establish an Integrated Management Information System (IMIS). The objective of the proposed design is to facilitate the overall objective of supplying uninterrupted water (24x7) to citizens of Mysore. IMIS would provide dynamic information on land base, consumers, assets and facilitate for a demand and revenue projection. This would help MCC to provide quality services to their consumers and also improve the revenue realization.

The benefits of this project are as follows:

Better Operations & Maintenance and Management

•Detect & Plug Utility Specific Losses – Non-Revenue Water

• Improve service & operations management – Assets, repairs, service requests etc.

•Efficient utilization of workforce

•Metering and monitoring infrastructure and business processes

•Reduce costs

Maintain Healthy Financial Performance

•Revenue Management – collection and billing inefficiencies, revenue leakages

•Manage costs w.r.t O&M, tariffs etc.

•Manage Investments in utility infra upgrade, service & maintenance – better ROI

Improve Customer Satisfaction with Respect To

•Supply of water

•Quality of Water

•Accurate and efficient Billing and Collection mechanism

•Better Customer Interaction

Responsibilities:

•Developing the front-end code and backend using C#.net, Javascript, SQL Server, Oracle

•Creation of GIS services using ArcGIS for GUI for maps

•Integrating the ArcGIS maps in the Dotnet GUI

•Unit and system testing

•Writing JavaScript validations

•Creation of web services for the clients

•Writing JavaScript generic functions to reuse

•Integrating the web services in the Silverlight page

•Responsible for the entire infrastructure related activities within the account

Environment: Visual Studio 2008(C#, Silverlight), Oracle 11G, ArcGIS Server, ArcGIS Desktop, Arcs DE, Water GEMS, JavaScript, WCF



Contact this candidate