.Net Developer Sql Server

GANESAN SUBBIAHPANDIAN

Sr. Full Stack Lead developer Technical Architect

PHONE: +919-***-****

**********@*****.***

Ganesan Subbiahpandian LinkedIn

Visa: GREEN CARD

A seasoned and proven track record .NET Developer with 17 years of experience in designing, building robust, scalable web applications using the .NET framework, proficient in C#, ASP.NET MVC, and SQL Server, with a strong focus on clean coding practices, agile methodologies, and delivering high-quality software solutions. Passionate about leveraging technology to achieve business objectives, backed by a comprehensive skill set and a dedication to continual growth and learning.

Single point of contact for all deliveries for multiple Project & initiatives facilitating and coordinating across multiple applications.

Working directly with Core Technology leaders, IT personnel, and business program resources to analyze and execute project requirements and manage stakeholder expectations.

Demonstrated track record of acting as business partner to leaders and team members across multiple business units with ability to build relationships, trust, and rapport.

Extensive experience in technologies includes Angular, React, .NET core, Web API, ASP.NET, MVC 4, WPF, Silverlight, WCF, C#, VB.Net, SharePoint, SQL Server, PostgreSQL, MongoDB, SSIS, SSRS.

Implement the code coverage using XUnit, NUnit and MSTest.

Deployed Angular, NET core, SQL server applications in Microsoft Azure environment.

Expert knowledge SQL Server and proficient in writing SQL statements, creating and modifying database objects like Packages, Stored Procedures, Functions, Views, Triggers, Indexes and T-SQL, SSIS Packages and SQL Jobs, ESP and Autosys jobs.

Implemented CICD pipeline using Jenkins and Azure DevOps.

Extensively worked on ADO.NET, Dapper, Entity framework, Code First for accessing the databases.

Excellent knowledge of Object-Oriented Design and Development.

Analyze the market and competitive environment to define a differentiated product vision that delivers unique value. Translate analyses into sound recommendations based on data and experience.

Strong analytical, problem-solving, and decision-making skills with track record of leading, managing and improving processes.

Provide management updates, status reporting, and dashboards from a quality perspective.

Extraordinary knowledge in Word, Excel, PowerPoint, Project, and Access

Managing forecast, resource planning / budgeting & invoicing

Has full management responsibilities for teammates: hiring, disciplinary, coaching, terminating, performance reviews.

TECHNICAL SKILLS

OS

:

Windows, Linux

Microsoft

:

.NET Framework, .NET Core, MVC, C#, ASP.NET, Web/Win forms, WCF, Web API, Silverlight, JavaScript, AJAX, ADO.NET, JSON, XAML, LINQ, Entity Framework 4.5, CSS.

Web Server

:

IIS, Nginx

IDE

:

VS2022, VS2019, Visual studio code

Database

:

SQL Server, Oracle, PostgreSQL, MongoDB

Version Control

:

TFS, GIT, Azure DevOps, Bitbucket

Scripting Languages

:

Angular, React, JavaScript, jQuery, Mustache Js

ETL & Reporting

:

SSIS & SSRS

Styles

:

Bootstrap, CSS

Other Tools

:

TOAD, SQL Management Studio, MS Office, Visio, SQL Profiler, Fiddler, Postman, Service now, Jira, Swagger, Autosys Scheduler

Methodology

:

Agile Scrum and Waterfall.

DevOps tools

CI/CD using Azure DevOps, Jenkins, Jfrog, artifactory, Ansible.

Cloud Technologies

Microsoft Azure, AWS, OpenShift Container, Docker, Kubernetes

EDUCATION & CERTIFICATIONS

Bachelor of Engineering (B.E)

Safe agile certification

Certified in Project Management, Risk Management

PROFESSIONAL EXPERIENCE

Associate Consultant – Tata Consultancy Services Ltd

Nov 2022 - Till

Project: Fiduciary Dashboard

Nov 2022 - Till

Fiduciary dashboard app helps to find the No of exception for the trades based on the timeframe under the market/division manager/portfolio manager. Also, it helps to tract and close the exceptions for current, past due based on their due dates.

Roles& Responsibilities:

Working as a Lead and Involved in translating technical requirements into design documents, establish specific solutions, and leading the effort including programming and Testing.

Developed of multiple UI components, admin, authentication modules and Features Angular.

Implement rxjs for asynchronous programming and ngrx for local storage in angular app.

Developed back-end services using .Net core web API and implement MediaR and Dapper for data access.

Involved to develop components, modules, and redux concepts in React application.

Implement OAUTH based authentication using Ping federate in React and API.

Implement the API logs through log4net.

Create packages/stored procedure for Oracle database and load the using blob.

Import the data using SSIS packages and schedule the packages in Autosys.

Created unit test projects using XUnit, MsTest.

Involved to deploy Web Api in IIS and OpenShift container.

CI/CD deployment through Jenkins/azure devops for internal and external clouds.

Involved to deploy the custom applications in Azure app services.

Used azure function to upload custom images and audio files to azure blob storage.

Build and deploy docker images for web app, API in azure container registry repository.

Lead the team and mentor the junior team members.

Technology

Angular, React, .Net core Web API, Bootstrap styles and controls, CSS, SQL, SSIS, Autosys and Oracle, Open shift container

Technical Service Manager – Cognizant Crop

Oct -2006 to Nov -2022

Project: Truist .NET Human System Applications

Aug-2013 to Nov-2022

Truist .NET Human System Development is critical project, which is having various applications like Varicent ETL, Variable Pay Plan, MergerRIF, Reporting and Unitedway under Human Systems

Roles& Responsibilities:

Involved in designing the application architecture using various Microsoft components.

Involved in the development of web application using .NET core, MVC 4 & Angular

Involved to develop the windows application forms using WPF and develop UI in Blazor.

Import the data using SSIS packages and schedule the packages in ESP.

Created the various services using web service, WCF and Web API.

Working as an onsite coordinator and getting the business requirement from the client and transfer the same to offshore Team and complete the work on time.

Cyber security, Code scan done through Veracode and SonarQube.

Created custom reports using Reporting Services (SSRS).

Created more than 100+ SSIS packages for ETL process.

Technology

ASP.NET 4.0, .NET Core, Booststrap styles, CSS, MVC 4, WPF, Web API, SSIS, SSRS, Query and Angular

Project: Truist Custom Applications - MS Technologies

May-2010 to Jul 2013

Employee Directory application is used to show and update the following details like employee details, Branch Details, Department details, IRM details etc.

Roles& Responsibilities:

Involved in the development of web page and SSIS packages for send mail and import branch and center data.

Involved to create stored procedure and create the common employee control which is used across the application using JQuery and Silver light.

Onsite Co-coordinator Getting the business requirement from business team and transfer the same to Offshore Team and complete the work on time.

Involved to prepare production package preparation and deploy co-ordination.

Technology

ASP.NET 4.0, C#, Silver light, WCF, SSIS, SSRS, JQuery, Sharepoint 2007.

Project: Client Central Sales and Service

March-2008 to April-2010

Client Central is a Retail Banking division of Branch Banking and Trust Corporation. Client Central deals with the development and maintenance of the system which covers the Account opening for various products such as Deposit account, saving account, CD and IRA products etc

Roles& Responsibilities:

Involved in the development of CDIRA, Launch page, Message board, NSF/OD and One Time Transfer Model, Account summary etc.

Implemented on printing and activity logging functionalities.

Involved to create the sales incentive and Retail Loan line Inquiry WCF service.

Involved in unit testing and integration testing.

Playing the Module Lead Roles for Client central Sales and Service application and owns the responsibility of the build and delivery activities that are carried out to deliver the application to onsite up to Dec 2008.

Technology:

C#, Dot Net, WPF, WCF

Project: AIS Wave III & SRQ.Net Migration

Oct 2006 to March-2008

AIS WAVE III is a migration project involving migration of Windows application developed in VB to VB.Net, as Microsoft is withdrawing support for Vb6 runtime and Windows Vista will not support the VB6 Runtime.

Roles& Responsibilities:

Played the Module Lead for Wave III .Net Migration.

Re write of code in .Net and Unit testing for Projects.

Implemented Aetna enterprise framework and MSEL in Wave III .Net Migration for user authentication and Data access.

Developed User controls which can be reused for different projects.

Extensively worked on the SQL queries, stored procedures, and cursors.

Technology:

VB.Net, IBM DB2, MS SQL Server

Software Engineer – Brij Data Link Pvt Ltd

Feb -2006 to Oct 2006

Programmer – Acemind Technologies

Aug 2004 - Jan 2006

Contact this candidate