Sugunaselvam S

Education & Experience: Bachelor of Computer Science Engineering and have 8 years of professional experience as a Software Developer in .NET using C#, ADO.NET, LINQ, ASP.NET, SQL, PostgreSQL, and SSRS report.

Project Management and Analysis:
Proficient in delivering projects on time.

Skilled in requirement analysis and development plan walkthrough.

Proven ability to handle projects independently.

Client Communication:
Experienced in managing client communication through emails.

Demonstrated success in promptly resolving client-reported issues in web applications and SSRS reports and communicating solutions via emails.

Work Style:
Self-motivated with the ability to work independently or as a valuable team member.

Capable of handling projects individually.

Database Proficiency:
Strong knowledge of SQL and PostgreSQL, including creating stored procedures, functions, views, and scheduling SQL jobs to automate query execution at specified times.

Programming Skills:
Proficient in debugging C#, ADO.NET, LINQ and ASP.NET applications.

Data Encryption:
Proficient in using the Kleopatra tool for file encryption and decryption.

Automation Expertise:
Experience in automating SQL jobs and invoking Windows applications from SQL queries for file encryption and decryption on SFTP server paths.

MongoDB Skills:
Basic knowledge of creating MongoDB scripts to update values and generating JSON data for insertion into MongoDB.

Technical Lead

Completed a post-graduate course in .Net MVC, including C#, ASP.Net, MVC, and SQL, at the National Institute of Information Technology (NIIT), Nungambakkam, Chennai, from 2014 to 2015.

.NET Software Developer

• C#, ADO.NET, LINQ, ASP.NET and SQL, Designed and developed new pages in the eTrack product to enhance client usability. Also implemented product enhancements based on client requests. Additionally, Added new functionality and features to the eTrack product.
• In terms of SQL, Created numerous stored procedures, functions, views, and SQL jobs. Optimized these stored procedures by implementing techniques such as creating indexes, using NOLOCK, employing EXISTS() instead of COUNT(), specifying column names instead of using *, and utilizing JOIN queries instead of sub-queries.
• Experience in SSRS (SQL Server Reporting Services) as well, where developed and designed various SSRS reports and report pages to provide efficient reporting solutions to clients.
• Furthermore, in Entity Framework, Updated the model in the .edmx file in Visual Studio after making modifications to the table structure in SQL.
• Responsible for promptly addressing and resolving any client-reported issues within the eTrack product.
• Debugging Visual Studio code and SQL scripts, analyzing the root causes of issues, and effectively resolving them.
• Experience with PostgreSQL, where I have successfully created a variety of database objects, including stored procedures, functions, and views
• Troubleshot and resolved performance issues for databases and application.
• Utilized Postman effectively to perform CRUD operations on APIs, including selecting data with GET, inserting data with POST, updating data with PUT, and deleting data with DELETE requests. This demonstrates strong proficiency in API testing and manipulation across different HTTP methods.

• Requirement Gathering:
  
• Collaborated with project managers and business analysts to gather project information and requirements.
• Project Management:
  
• Actively participated in Daily Scrum meetings, providing updates on work item status.
• Effectively resolved daily support tickets in first half a day and continuing to work on change request (CR) tickets for sprint release.
• Analyzed CR requirements, broke down work items, and created Work Packages (WPS) to ensure on-time project delivery.
• Team Collaboration:
  
• Worked closely with team members to develop applications, cooperatively merging code into the SVN (Subversion) repository.
• Supported the QA team in identifying and resolving internal issues.
• Release Management:
  
• Coordinated with the release team, offering guidance and instructions, and facilitated the deployment of builds onto the server.
• Development and Enhancement:
  
• Developed and debugged the page using programming code in C#, ADO.NET, LINQ, ASP.NET, and SQL, which included Windows services, to enhance and improve project functionality.
• Created and maintained stored procedures, functions, views, and other database objects in SQL to meet project requirements.
• Issue Tracking:
  
• Effectively tracked and managed work items and project progress using JIRA.

• Career Advancement: Progressed from a fresher as a Software Developer Trainee to the role of Technical Lead , demonstrating significant professional growth and leadership abilities.
• Performance Recognition: Received 3 Spot Performance Awards for consistently delivering projects on time, efficiently managing support activities, and meeting deliverable commitments, highlighting a commitment to excellence.
• Automation : Successfully automated numerous SQL jobs, reducing manual workload and scheduling them to run on EST time, improving operational efficiency.
• Team Appreciation: Earned appreciation for exceptional teamwork, providing team support, and consistently meeting sprint deadlines, contributing to a collaborative work environment.
• Project Management: Effectively managed multiple projects concurrently, demonstrating strong project management skills and multitasking capabilities.
• Product Development: Designed and developed the TimeTrack product, which tracks employee statuses on a daily, monthly, and yearly basis, contributing to improved employee management and reporting.
• Mentorship: Mentored new employees about the product, completing the training program ahead of schedule, demonstrating a commitment to knowledge sharing and team development.

Name: sugunaselvam s

Mobile: 8015445806

Email: selvam.dcse@gmail.com

Address: No: 31/22, Karani garden second street, Saidapet, Chennai-600015