.Net Core Software Engineer

Chetan Sharma

Phone: +1-682-***-****, http://about.me/oshochetan

Email: ******.******@*****.*** LinkedIn: linkedin.com/in/oshochetansharma PROFESSIONAL SUMMARY

• Senior .NET Programmer over a decade of experience specializing in Microsoft technologies. Proficient in VC#.Net, ASP.NET, .NET Core, MVC, EF Core, AZURE, CI/CD, Win Forms, Web Forms, Web Services, XAML, Ajax, LINQ,IIS, WCF, WPF, ADO.Net, SSIS, SSRS, React, Angular, NodeJS,TypeScript,JavaScript,jQuery,HTML5,CSS3, PL/SQL,T-SQL,SQL Server Management Studio and Web API.

• Experience with cloud computing, database administration, and AI/ML technologies.

• Holds dual master’s degrees, in Business Administration from HPTU and Artificial Intelligence

(AI) from Prestigious Indian Institute of Technology (IIT) Mandi.

• Certified in MS Azure Essentials, Ethical Hacking, Full stack .NET Core, and multiple programming languages including Oracle 9i, VC#, and C#.

• Database Administrator / Data Analyst with over five years of experience in data management, SQL Server administration, and MIS systems in government and enterprise environments.

• Skilled in SQL Server (2012–2022), T-SQL, SSIS, stored procedures, performance tuning, indexing, backups, and database security.

• Proven expertise in data integration, reporting, and system migration projects. Background in Azure SQL, data governance.

• Experience in all stages of the SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, implementation, testing, deployment, documentation and maintaining of various stand-alone, intranet, client-server multi-tier web and GUI software applications.

• Good working experience of WCF, WPF, LINQ, Web API, XML, Web Services (SOAP, WSDL),

.NET Remoting Server Components using .NET Framework.

• Experienced with the .NET Platform, Visual Studio 2010/2012/2013/2015/2022 Microsoft SQL Server 2016/2012/2008/2022 R2/2012, C# 4/5 and ADO.NET.

• Extensive use of the ADO.NET Data grids, Data Readers and Datasets for Data Manipulation.

• Knowledge in developing cube and dimensions using SQL server Analysis Services (SSAS).

• Experienced WPF, WCF development, ASP.NET Web Forms, ASP.NET State Management & ASP.NET Caching.

• Strong experience using IISWeb Server, Object Oriented Analysis and Designing (OOAD), Object oriented programming.

• Experience with reporting tools SQL Server Reporting Services (SSRS) and Crystal Reports, creating ETL packages using SQL Server Integration Services (SSIS) for generating reports populated by data in databases.

• Experience in developing Restful services using Web API framework.

• Some Experience in working with Microsoft Azure cloud services like Storage (Blob, Table, Queue), Web Sites, Web Roles, Web Apps, Azure Service Bus, Azure virtual network, SQL Azure, Data Sync, Traffic Manager, CDN, Caching.

• Proficient in SQL Server for developing complex stored procedures, Triggers, Tables, Views, User-Defined Functions, SQL joins, Index and query writing.

• Experience in Design Patterns like Singleton, Factory, Abstract & Facade patterns

• Ability to quickly acquaint with new concept and technologies. WORK EXPERIENCE

1. Management Information System Specialist / Database Analyst Feb 2018 – March 2025 NIELIT Shimla

• Plan, coordination, implement and monitor the PMAY-HFA project.

• Managed and maintained SQL Server databases across development, test, and production environments.

• Collaborated with .NET and DevOps teams to support application release cycles and ensure data consistency.

• Developed and optimized complex stored procedures, triggers, and views to support application performance and reporting.

• Created and managed SSIS packages for automated data loads, ETL pipelines, and third-party data integrations.

• Handled database backups, restores, and recovery planning across secure environments.

• Implemented data-level security, including Row-Level Security (RLS) and encryption for PII/PHI compliance.

• Conducted data analysis and business intelligence using Crystal Reports, and Excel dashboards.

• Led database migration and upgrade efforts from older versions to SQL Server 2019+. 2. MIS (Management Information System) Specialist / Database Analyst Feb 2017 - Jan 2018 UNDP India

• Managed and maintained SQL Server databases across development, test, and production environments.

• Regular communication and coordination with the National Project Management Unit, State Project Steering Committee, and Management Unit with respect to project activities in the state.

• Manages all IT-related aspects of the e-district project involving feasibility studies, systems analysis, design, development, and implementation of new, moderately complex functionality in websites.

• Maintains upgrades or enhances existing ULB Websites; troubleshoots and provides continuing user support, including resolving difficult problems, advising on the use of new techniques, monitoring transactions to measure performance.

3. Senior Programmer Mar 2016 - Jan 2017

Velocis Systems Pvt. Ltd.

• As a Senior Programmer led the analysis, design, development, and integration of the Client- edistrict Chandigarh Website, driving a 20% increase in user satisfaction scores.

• Conducted 30+ stakeholder meetings to gather and refine Business Requirements Specifications (BRS) and Software Requirement Specifications (SRS), ensuring alignment with business objectives in the realm of networking and computer science.

• Actively contributed to 100% of agile methodology ceremonies, including Daily SCRUM meetings and Sprint sessions, resulting in a 15% improvement in project delivery timelines, with expertise in full stack development.

• Executed 100+ test scenarios using REST client tools like POSTMAN and SOAPUI, achieving a 90% pass rate and ensuring robustness and reliability of REST API services, specializing in ORM and networking protocols in .Net and Sql server environment.

• Implemented logging mechanisms resulting in a 30% reduction in application downtime by identifying and resolving performance bottlenecks proactively, leveraging skills in .Net and Sql server environment.

• Managed version control and code maintenance for a codebase of over 10,000 lines, ensuring collaboration efficiency and codebase integrity, with proficiency in jQuery and full stack development.

• Developed 10 REST web services, resulting in a 25% increase in application functionality and usability, with a focus on software engineering principles.

• Collaborated with cross-functional teams to troubleshoot and resolve Azure cloud infrastructure issues, resulting in a 40% reduction in incident response time.

• Developed and maintained ETL processes to support data warehouse and reporting requirements, resulting in a 30% improvement in data processing time and a 10% increase in data throughput.

• Engineered end-to-end application components for 3 projects in .Net and Sql server environment, resulting in a 30% improvement in system performance and reliability, with a focus on full stack development and system architecture.

• Developed SSIS solutions for data preprocessing, resulting in a 25% reduction in data processing time and improving overall system efficiency, showcasing expertise in data engineering.

• Conducted 50+ code reviews, leading to a 15% improvement in code quality and adherence to technical standards, with a focus on collaborative software development practices.

• Executed 100% of test plans and conducted unit and system testing, ensuring a 95% pass rate and robustness of applications, with a focus on software quality assurance.

• Analyzed and optimized 100+ SQL queries, resulting in a 20% improvement in database query performance, demonstrating expertise in database optimization techniques.

• Developed REST API and Implemented OAuth based authentication to secure the RESTful

.NET Core Web API and provide authorization.

• Delivered 100% of documentation and status updates on time, ensuring clear communication and transparency across project stakeholders, showcasing strong communication and project management skills.

4. Senior Programmer Mar 2015 - Mar 2016

Cyber Consulting Pvt. Ltd. .

• Actively participated in Scrum meetings to understand and address project requirement effectively.

• Engineered a edistrict website featuring a secure login system, driven by robust database architecture.

• Proficiently crafted stored procedures, functions, triggers, and optimized SQL joins for enhanced database operations.

• Utilized VC#.NET within Windows Forms to develop engaging interfaces facilitating streamlined travel processes and trip information management.

• Employed C# within the Entity Framework and LINQ to entities to architect the backend systems of Windows Forms applications.

• Implemented role-based security protocols, tailoring application access to varying employee levels, ensuring data integrity.

• Spearheaded the creation of virtual documents, trip workflows, and internal packages through SSIS, optimizing operational efficiency.

• Demonstrated proficiency in MS Active Directory and Windows Forms development, ensuring seamless integration and functionality.

• Conducted comprehensive cross-platform audits of Active Directory (AD) objects and user permissions, ensuring compliance and security.

• Configured SMTP servers and developed a robust mailing component, facilitating personalized and group communication for end user-related updates.

• Leveraged JavaScript and AngularJS to enrich GUI web development, enhancing user experience and interactivity.

• Designed and optimized SQL Server stored procedures for efficient data manipulation and retrieval, ensuring database performance.

• Utilized Visual Source Safe as a reliable source code repository, facilitating collaborative development and version control.

• Architected Windows Communication Foundation (WCF) services and seamlessly integrated them into applications, enhancing communication capabilities.

• Proactively monitored production metrics and collaborated with management, providing insightful reports to drive operational improvements.

• Collaborated with production management to identify and address operational issues, compiling and presenting weekly issue reports for resolution.

• Designed and developed robust applications for both web (ASPX/Silverlight) and Windows

(WPF) platforms, ensuring cross-platform compatibility and user satisfaction.

• Demonstrated expertise in multithreading distributed systems and Test-Driven Development

(TDD), optimizing system performance and reliability.

• Engaged in thorough code reviews across various applications, ensuring adherence to coding standards and best practices.

• Provided valuable assistance to users during User Acceptance Testing (UAT), effectively identifying and resolving bugs to ensure product quality.

• Engineered SQL Server stored procedures, cursors, triggers, and functions to maintain database integrity and optimize application performance.

• Proficiently managed performance monitoring functionality and batch processing, ensuring system stability and efficiency.

5. Computer Programmer Nov 2014 - Feb 2015

IAP Company Pvt.Ltd. •

• Write programs in a .net for VAHAN and SARATHI Software.

• Update and expand existing programs in .net and Debug programs by testing for and fixing errors.

• Troubleshoot VAHAN and SARATHI website problems debug and upgrade existing code.

• Analyzed, designed, developed, tested, and implemented 12 client-server and web applications using .NET and Views in Microsoft SQL Server environments.

• Documented data and information with a 30% reduction in debugging time, showcasing strong debugging and triage skills.

• Mapped 50 .NET classes to database tables and CLR data types to data types, ensuring a 90% reduction in integration errors.

• Utilized Entity Framework and AngularJS to develop single-page applications, leading to a 40% improvement in user satisfaction metrics.

• Demonstrated proficiency in MS Active Directory and MS WinForms, contributing to a 20% increase in development efficiency.

• Developed GUI web applications using JavaScript and AngularJS, resulting in a 25% increase in user engagement metrics.

• Monitored performance functionality and batch processing, optimizing application efficiency by 15%.

• Deployed projects to various servers, including test and production servers, with a 20% reduction in deployment time.

• Addressed production server issues and resolved defects in test environments promptly, leading to a 30% improvement in defect resolution time.

• Monitored production metrics and provided summary reports to management, resulting in a 40% improvement in decision-making processes.

• Collaborated with production management to identify and address issues, resulting in a 25% decrease in critical incidents.

• Provided production support by documenting tickets and communicating with users, maintaining a 90% user satisfaction rating.

• Implemented Service Oriented Architecture (SOA), resulting in a 25% reduction in service call latency.

• Hosted WPF services using basic HTTP binding, facilitating seamless communication between systems, with a 30% reduction in communication overhead.

• Developed WPF web services for data export and import, resulting in a 50% improvement in data transfer speed.

6. Software Engineer Apr 2014 - Oct 2014

Cogniter Technology Pvt.Ltd.

• Design and developed legacy ASP.Net MVC application using C#, .NET (4.6), XML, REST API, Microsoft Visual Studio 2019/2022, Microsoft SQL Server 2019/ 2022, TFS, and Postman. Maintaining programming libraries, user manuals and technical documentation.

• Designed and utilized ORM mappings to translate legacy mainframe data structures into modern relational database schemas.

• Created detailed UML diagrams (Use Case, Class, Sequence, and Activity diagrams) to represent system components, business processes, and workflows, ensuring clear communication and alignment across cross-functional teams and stakeholders.

• Designed and documented activity diagrams and flowcharts to visually map out key business processes, including client information management, eligibility determination, and case workflows, enabling better collaboration and efficient development and testing efforts.

• Designed and developed ETL processes to facilitate the transfer and transformation of historical data from the legacy mainframe system into the SQL database, ensuring data accuracy, integrity, and consistency.

• Collaborated with business analysts to document current workflows and business requirements, creating detailed flowcharts and UML diagrams to visualize business logic and interactions within the system, ensuring a clear understanding for all stakeholders.

• Conducted data mapping sessions to translate mainframe data structures to the new SQL relational database model, ensuring all legacy data was captured, transformed, and stored correctly in the new system.

• Worked in close partnership with cross-functional teams (development, QA, business analysis) to ensure the migration met all functional and non-functional requirements, including security, performance, and compliance standards.

• Designed and implemented scalable .NET solutions, improving system performance and reliability for over 300m number of users across the state, ensuring the system could handle increased traffic and demand.

• Utilized ASP.NET MVC and Web API to develop and optimize RESTful services, enabling efficient management of client information, eligibility checks, case workflows, and interaction with external third-party systems and services.

• Enhanced SQL Server database performance by optimizing complex queries, designing stored procedures, and improving indexing strategies.

7. Computer Programmer Dec 2012 - Dec 2013

NIELIT Shimla

• Write programs in a .net for the Election department.

• Led the successful migration of 5 ASP.NET applications to MVC 5.0, resulting in a 40% increase in application performance and scalability.

• Ensured full responsiveness across diverse devices and desktop browsers, resulting in a 25% increase in user engagement, by utilizing AngularJS and Bootstrap frameworks for front-end development.

• Orchestrated URL routing with UI state router, modularizing application components and reducing codebase complexity by 30%.

• Utilized Bootstrap to craft responsive mobile websites, achieving a 40% improvement in user satisfaction on various screen sizes.

• Implemented design patterns such as Singleton and Abstract Factory, resulting in a 30% increase in code maintainability and extensibility.

• Leveraged MVC features including Data Annotation, Partial Views, Layouts, and Strongly Typed Views to architect scalable and organized web applications, reducing bug density by 20%.

• Implemented CRUD operations utilizing Angular 2.0 with WEB API, resulting in a 30% reduction in development time for data manipulation features.

• Utilized Razor Engine to create dynamic web pages with server-side rendering capabilities, resulting in a 25% improvement in page load times.

• Collaborated in database design, SQL query optimization, and performance tuning, resulting in a 30% improvement in application scalability and responsiveness.

• Developed and optimized stored procedures, temporary tables, table variables, functions, and joins, resulting in a 25% reduction in database query execution time.

• Implemented RESTful web services consumed by both web and mobile applications, resulting in a 20% improvement in data exchange efficiency.

• Implemented RESTful HTTP verbs (GET, PUT, POST, and DELETE) for efficient data manipulation and resource management, resulting in a 30% reduction in network latency.

• Leveraged LINQ for querying against strongly typed collections, XML documents, web services, objects, and Entity Framework, resulting in a 25% improvement in data retrieval and manipulation efficiency.

• Collaborated with teams on relational database design and integration for application backends, ensuring data integrity and performance.

• Contributed to the development of information technology solutions utilizing C language for backend systems and performance-critical components.

• Worked on Implementing several .Net core, Asp.Net Web, Asp.Net MVC applications.

• Created several micro services using CQRS design pattern and microservice architecture.

• Wrote Stored Procedures, Triggers, Functions, and Sequences to access data from database along with ADO.NET Class & Methods.

• Designed architectural diagrams for new and existing .Net applications.

• Determine optimal solutions for architecture, efficiency, maintainability and scalability in cooperation with developers and architects.

• Delivered solutions in support of full life-cycle implementation of software products and systems utilizing a structured, documented software development process.

• Implemented unit tests, Integration tests, performance tests and domain tests.

• Created several NuGet packages to avoid code duplication across .Net web APIs.

• Implemented API versioning strategy.

• Worked on several .Net web api prod support issues.

• Worked on Agile methodologies and actively involved in refinement and planning sessions. 8. Database Administrator (DBA) Apr 2012 - Dec 2012 NIELIT Chandigarh

• Develop processes for optimizing database security.

• Set and maintain database standards for Water Project Mohali DBMS.

• Manage database access.

• Performance tuning of database systems.

• Install, upgrade, and manage database applications.

• Diagnose and troubleshoot database errors.

• Recommend and implement emerging database technologies.

• Create and manage database reports, visualizations, and dashboards.

• Create automation for repeating database tasks.

• Install the server software.

• Configure database servers.

• Monitor and maintain system health and security.

• Design backup processes for server and associated data. EDUCATION

Master of Technology (M.Tech) in Artificial Intelligence and ML (PT) Mar 2022 - March 2025 Indian Institute of Technology (IIT) Mandi • Himachal Pradesh, IN, https://www.iitmandi.ac.in/ Master in Business Administration (MBA) (PT) Mar 2015 - Feb 2017 Himachal Pradesh Technical University Hamirpur • Hamirpur, India, https://www.himtu.ac.in/ Bachelor of Technology in Computer Science and Engineering with Honors Jun2007- Jul 2011 Himachal Pradesh University Shimla, Shimla, Himachal Pradesh, India, https://hpuniv.ac.in/ PROJECTS

EDistrict

• Designed and optimized backend SQL Server databases supporting 50,000+ active users.

• Designed a scalable e-governance solution for NIC, ensuring high availability and Compliance with government standards.

• Implemented ETL processes using SSIS to ingest government data from legacy systems.

• Reduced report generation time by 45% through index optimization and query tuning.

• Ensured 24/7 uptime and disaster recovery support for mission-critical data.

• Developed a website using ASP.NET Core, reducing processing time by 30%. QR Phishing Detection Technique with the help of AI

• Implemented AI-based analytics in a QR Codes, increasing fraud detection accuracy by 25%). SKILLS

• LANGUAGES: C#, ASP.net Core 7&8 using VC#.Net, PL/SQL

• IDE: Microsoft Visual Studio (MS) 2022.

• .Net Technologies: Angular as a frontend, Azure Cloud Deployment, Chat GPT, GitHub Copilot, ASP.Net core Web API, Type Script/ES6, REACT, MVC, LINQ, EF Core 9, JQ, WCF, WEB SERVICE, WPF/SL, HTML, XML, AJAX, ADO.NET., POSTMAN, IIS Web server.

• Databases: SQL Server (2012–2022), Azure SQL, Oracle, MS Access

• Tools: SSIS, SSRS, SQL Profiler, Data Factory, SQL Agent

• Scripting: T-SQL, PowerShell, Python (for automation/log parsing)

• Data Management: Indexing, Query Optimization, Backup/Restore, Security, Row-Level Security (RLS)

• Reporting Tools: Crystal Reports, Power BI, SSRS

• Cloud Platforms: Azure SQL, Blob Storage, Azure DevOps

• Version Control & Collaboration: GIT

• MSBI Tools : SSIS, SSAS, SSRS

• Version Control Tools : Team Foundation Server (TFS)

• Middleware: WCF,ADO.NET, Entity Framework 5.0/4.1, LINQ, Web Services

• Webserver: IIS 8.0/7.0/6.0

• Others: Performance tuning, Database auditing, Data modeling, ETL workflows TRAINING and Certification:

• Full –Stack .NET Core with Microsoft Azure Essentials Certification & Gen AI from Great Learning Academy Delhi

• VC#.NET from NIIT NEW DELHI.

• Oracle 9i from NIIT Chandigarh.

• CORE JAVA (J2SE) from NIIT Chandigarh.

• IT SECURITY & ETHICAL HACKING from APPIN TECHNOLOGIES NEW DELHI.

• NET4.0 and ASP.NET4.5 from CS INFOTECH Chandigarh.

Contact this candidate