Vignesh S

• Worked as an ETL and API Developer on the PIMS platform, contributing to the design, development, and enhancement of provider data processing solutions.

• Designed, developed, and modified SSIS ETL workflows to implement new business rules, data mappings, transformations, and integrations.

• Deployed, validated, and optimized SSIS packages across environments, ensuring reliable execution and high performance.

• Developed and enhanced REST APIs to support secure data exchange and integration between PIMS and other enterprise applications.

• Collaborated with business, data, and cross-functional teams to ensure data accuracy, integrity, and compliance with business requirements.

• Worked in an Agile environment, participating in daily Scrum and Sprint Planning while using Azure Repos and Azure Boards for source control and story tracking.

• Led a team of 8 support engineers in diagnosing and resolving complex technical issues for .NET and React.js applications.

• Coordinated with development teams to provide quick resolutions to critical production issues.

• Implemented monitoring and alerting systems to proactively identify and address potential issues.

• Conducted root cause analysis and provided detailed incident reports to stakeholders.

• Developed and maintained knowledge base articles to document common issues and solutions.

• Provided training and mentorship to support engineers, enhancing their technical skills and knowledge.

• Designed and developed web applications using .NET Core REST API, Entity Framework
• Collaborated with project managers, QA testers, and business analysts to deliver robust and efficient software solutions.
• Optimized database queries and stored procedures to improve application performance.
• Provided technical support and maintenance for existing applications, resolving issues and implementing enhancements.
• Mentored junior developers, providing guidance and support in their professional growth.
• Account: Continental Casualty Company (CNA)

• Worked as part of the production support team, resolving issues caused by data discrepancies, UI defects, and backend code errors.
• Handled on-call responsibilities on a rotational basis, analyzing incidents, providing immediate workarounds, and implementing permanent solutions.
• Debugged and fixed ASP.NET applications, ensuring smooth production functionality.
• Investigated and resolved ServiceNow (SNOW) tickets on a daily basis within agreed SLAs.
• Utilized SOAP services to debug requests/responses and identify root causes of integration failures.
• Collaborated with offshore teams for development and issue resolution activities.
• Diagnosed SQL Server errors, writing queries, and performing data fixes as needed.
• Supported business teams in day-to-day operations and handled JIRA requests effectively.
• Troubleshot production incidents involving web and desktop applications, batch jobs, and databases.
• Conducted detailed root cause analysis (RCA) of production issues and implemented permanent code fixes.

• Designed and developed custom, reports, dashboard cubes, SQL queries per individual customer specifications and used.
• Designed user interface for ASP.NET 4.0 application in C#.
• Experienced in Normalizing database and wrote TSQL queries for database design.
• Designed and developed the complete Front-end application using Web forms with C# as code behind (Business layer in C#).
• Experience in database designing by writing complex queries, views, trigger, index, functions, cursors and stored procedures using MSSQL
• Post-Release maintenance, bug fixing and adding new features based on user requests.
• Deploying and publishing website through IIS(Internet Information Server)
• Account: Operations (Tool Development Team)
• Project Description: The main focus of this project is to provide the users to maintain the daily volumes by updating and plan them accordingly to achieve their daily targets. Configurable Tool for managing the operations Dash Boards.