.Net Developer Sql Server

Aftab Ahmed

Senior Full Stack .net developer/ C# developer

319-***-**** **************@*****.***

LinkedIn: https://www.linkedin.com/in/aftab-a-0a76b1211/

SUMMARY

** ***** ** ********** ******ping Web applications in ASP.NET Framework and .NET Core, working on backend and front end.

Proficient in Blazor and MudBlazor for building rich, interactive web applications with a modern, component-based architecture. Demonstrated expertise in leveraging Microsoft platforms to create scalable, secure, and efficient solutions across various industries.

Strong Experience in developing Web applications in .Net Core 3 and 5, .NET 6, .NET 7, C#, and SQL Server with EF Core.

Led DevOps initiatives utilizing Azure DevOps, Azure Pipelines, Kubernetes, and Docker, streamlining the development pipeline and ensuring continuous integration and delivery.

Implemented OIDC authentication and authorization mechanisms for secure user authentication in .NET applications.

Integrated OIDC with ASP.NET Core Identity for seamless user management and authentication workflows.

Proficient in Python programming language, with experience in developing scripts and automation tools for data analysis, ETL processes, and system administration tasks.

Skilled in SQL Server Reporting Services (SSRS) for generating reports and data visualization.

Experienced in SQL Server Integration Services (SSIS) for ETL processes.

Engaged in collaborative problem-solving, fostering an Agile mindset within the development team.

Implemented CSS media queries and browser polyfills to ensure consistent user experience in a .NET-based healthcare portal accessed from various devices and browsers.

Skilled .NET Developer with extensive experience in T-SQL development for Microsoft SQL Server databases.

Experienced in utilizing AWS RDS for MySQL or PostgreSQL for scalable and managed database solutions.

Stayed updated with the latest React JS trends, libraries, and best practices through self-learning and professional development.

Worked closely with UI/UX designers to translate wireframes and mockups into responsive Kendo UI layouts.

Proficient in Test-Driven Development (TDD) methodology, with hands-on experience in writing unit tests, integration tests, and acceptance tests for .NET applications.

Proficient in C#, ASP.NET Web Forms, ASP.NET MVC.

Experienced designing and developing MVC applications.

Proficient in developing Blazor Server side applications and WEB API with EF Core.

Experience Developing Secured .NET Web API and JWT Token authentication.

Design and Develop Android application on Android Studio, connected to Oracle and SQL Server databases through Web API with Retrofit2.

Experience developing Microsoft .NET applications for automotive industry like WebForms, WinForms, Web Services, Smart device applications.

Proficient in integrating .NET applications with various AWS services such as S3, DynamoDB, and SQS for storage, database, and messaging needs.

Experienced in front-end tools like Angular 14, Bootstrap.

Experience in all stages of software development life cycle like Requirements Definition and Administration, Design, Implementation, Testing and Deployment.

Experience developing Silverlight SCADA applications with Expression Blend.

Experience developing Spring MVC applications and hibernate to connect Oracle DB.

Experience in Database Management Systems, SQL Server, MySQL, Oracle

Experience developing with PL/SQL (scripts, queries, packages, stored procedures, functions, jobs, views).

Participate on System implementation from scratch of two manufacturing plants, one of them on Sao Paulo, Brazil.

Experience Getting user requirements, solution design, Development, Implementation plans, Release to production and application maintenance.

Extensive experience in Testing, Debugging and troubleshooting the existing code using Firebug, Chrome Inspector, IE Toolkit and other tools.

Experience with version control tools such as SVN, Git, Gitlab and Team Foundation Server (TFS).

TECHINICAL SKILLS

Programming languages

C# (8.0, 7.0, 6.0, 4.5 / 4.0 / 3.0 / 3.0 /2.0), Core Java, Python 3.

Markup languages

XML, XAML, XSL, XSLT, XMLHTTP, XMLDOM, HTML5, DHTML, CSS

Scripting languages

JavaScript, jQuery, Ajax, AngularJS, NodeJS, Express js, ECMAScript 6, UnderscoreJs, Angular, TypeScript, EmberJS, YFiles, Blazor, MudBlazor

.Net Technologies and Frame works

.NET CORE (1.0/2.1/3.1), ASP.NET, ADO.NET, LINQ, WCF, WPF, ASP.NET MVC, Entity Framework Core and .NET Framework (4.5 / 4.0 / 3.5 / 3.0 / 2.0 / 1.1 /1.0), Microsoft Azure

Servers

Microsoft IIS (10.0/8.0/7.5 / 7.0 / 6.0 / 5.1)

Databases

MS SQL SERVER (2017/2012 / 2008 R2 /2008/2005), Oracle (9i/10g/11g), MS-Access 2010

Reporting Tool

Azure DevOps, Crystal Reports (2010 / 9 / 8.5 / 8), SQL Server Reporting Services (SSRS)

Operating Systems

Windows, Mac and Unix

Testing Tools

XUnit, NUnit, JUnit, MS Unit, Karma Framework, Selenium

Development Tools

Visual Studio 2019/2017/2015/2012/2010, VsCode, Team Foundation Server, Visual Source Safe(VSS), SVN, JIRA, Gitbash

Other Tools

MS Visio, MS Office

PROFESSIONAL EXPERIENCE

.Net full stack lead

State of Iowa- (Department of Healthcare Services), June 2024 – Sep 2024

Responsibilities:

Led the design, development, and deployment of enterprise applications, utilizing C#, ASP.NET Core, and Webforms to meet business needs for web-based solutions.

Develop and maintain full-stack applications using .NET, Python, and Node.js with a focus on GIS data handling and visualization.

Modernized legacy GIS systems by integrating open-source GIS tools like PostGIS and Leaflet, significantly enhancing spatial data accessibility.

Collaborated with cross-functional teams to gather business requirements, analyze system needs, and create both functional and technical specifications.

Architected and implemented user interfaces using Angular, TypeScript, Bootstrap, and Knockout, ensuring a responsive and dynamic user experience.

Built and optimized backend systems with C# and Entity Framework, improving database interactions and application performance.

Designed, configured, and maintained custom workflows in AEM, automating content approval and publishing processes to reduce manual intervention and increase deployment speed.

Built and managed digital asset management solutions within AEM, organizing assets and implementing tagging for efficient retrieval and compliance.

Leveraged Microsoft Azure, AWS EKS, and Lambda functions to build and deploy scalable, cloud-based solutions that improved application reliability and reduced infrastructure costs.

Managed and deployed content on AEMaaCS, leveraging cloud-native capabilities to support scalable content solutions for global teams.

Developed and maintained dynamic web applications using Blazor and MudBlazor, resulting in enhanced user experiences and reduced page load times by utilizing a component-based architecture.

Leveraged Microsoft technologies like Azure and .NET to build and deploy scalable, cloud-based solutions, improving application reliability and reducing infrastructure costs.

Built complex user interfaces with MudBlazor to enable seamless, responsive, and visually appealing web designs, adhering to modern UI/UX principles.

Configured AWS Lambda for dynamic scaling to handle unpredictable workloads, improving response times and ensuring fault tolerance.

Collaborated with cross-functional teams to support ServiceNow development and customization initiatives, ensuring alignment with business goals and ITSM processes.

Worked with ServiceNow's Asset and Configuration Management module to ensure proper tracking and auditing of IT assets, helping to minimize risk and maximize utilization.

Trained and provided ongoing support to ServiceNow users, helping them navigate the platform, maximize its features, and improve ticket resolution time.

Automated routine reporting tasks in ServiceNow, using scheduled reports and notifications to provide stakeholders with up-to-date service delivery information.

Implemented ServiceNow's Change Management module to track and evaluate changes, ensuring proper approval and documentation processes were followed, reducing risk of disruptions during updates.

Used AWS Lambda for data processing, automating event-driven workflows, and integrating third-party APIs for streamlined communication across services.

Developed FaaS (Function-as-a-Service) using AWS Lambda to enhance the application’s flexibility, enabling rapid scaling and reducing infrastructure dependency.

Migrated legacy monolithic applications to microservices, using Docker, Kubernetes, and AWS Lambda to enhance performance and flexibility.

Implemented and optimized Azure DevOps pipelines to automate build and deployment processes, reducing deployment time and ensuring continuous integration.

Integrated AEM with essential external services, including Salesforce and SSO, using RESTful APIs to facilitate seamless data exchange and enhance personalization.

Developed and managed digital asset management solutions within AEM, organizing assets and implementing tagging for efficient retrieval, reusability, and compliance.

Satellite Service Provisioning includes setting up parameters like bandwidth and IP addresses, and Mediation of Call Data Records ensures these configurations are captured in the CDRs for accurate tracking.

Satellite Service Provisioning provides continuous monitoring of service performance, while Mediation of Call Data Records processes usage data for quality analysis.

Satellite Service Provisioning involves user authentication to grant access to services, and Mediation of Call Data Records verifies that usage data is linked to the correct customer accounts.

Satellite Service Provisioning ensures services are properly deactivated when needed, while Mediation of Call Data Records ensures that all usage data is correctly archived for historical analysis.

Satellite Service Provisioning configures various types of services like data and voice, while Mediation of Call Data Records normalizes data across different service types for consistency.

During Satellite Service Provisioning, service parameters are set for each customer, while Mediation of Call Data Records ensures that usage data for these services is captured accurately.

Reduced content creation and deployment times by 20% through custom component development and author-friendly templates.

Managed the development and maintenance of SQL Server databases, including creating tables, views, stored procedures, and triggers for optimized data storage and retrieval.

Acted as a primary point of contact for troubleshooting and resolving critical system issues, working closely with the Help Desk and end users to resolve bugs and implement fixes.

Performed thorough code reviews to ensure compliance with best practices and maintainable code quality across the team.

Set up and maintained CI/CD pipelines using Azure DevOps and GitHub to automate builds, testing, and deployment, ensuring smooth integration and delivery processes.

Provided technical guidance to junior developers, helping them resolve complex technical challenges and reviewing their code for quality assurance.

Established and enforced coding standards across the team to ensure consistency in development, performance, and security.

Configure WCF services in web.config or app.config files, setting up endpoints, behaviors, and bindings.

Apply role-based authorization in WCF services to control access to different service operations.

Implement message-level security in WCF services to encrypt and secure SOAP messages.

Developed SCADA systems tailored to client requirements, focusing on scalability and reliability.

Connected SCADA systems with SQL databases for real-time data logging and retrieval.

Integrated SCADA systems with various PLCs, including Allen-Bradley, Siemens, and Schneider Electric.

Improved SCADA performance through database indexing, tag optimization, and script refinement.

Managed end-to-end SCADA project lifecycles, from requirements gathering to deployment.

Integrated cloud services such as Azure and AWS to enhance the scalability and availability of the applications, leveraging their platform services for key features.

Assisted with batch processing using SSIS and developed custom reports using SSRS for business intelligence purposes.

Designed and developed RESTful APIs using FHIR (R4) standards for seamless data exchange between EHR systems, patient portals, and third-party services (labs, pharmacies, insurers).

Collaborated with cross-functional teams to develop FHIR-enabled workflows with developers, healthcare providers, and business analysts, supporting User Acceptance Testing (UAT).

Implemented version control to support multiple versions of FHIR (STU3, R4) for interoperability with older systems and new implementations.

Optimized FHIR API performance through query parameter tuning, pagination, and server-side filtering to support large-scale data retrieval with minimal latency.

Demonstrated flexibility in adjusting to evolving project requirements in an Agile environment, delivering high-quality solutions within tight deadlines.

Developed custom themes and plugins to extend WordPress functionality.

Configured and managed WooCommerce for e-commerce platforms, including payment integration.

Optimized WordPress websites by implementing caching, image optimization, and lazy loading.

Managed website migration across servers and domains, ensuring data integrity and zero downtime.

Secured WordPress sites with firewall plugins, malware scans, SSL, and access controls.

Integrated WordPress with third-party systems such as CRMs and marketing tools.

Migrated legacy monolithic applications to microservices, enhancing performance and flexibility.

Implemented microservices using Docker and Kubernetes for seamless containerization and orchestration.

Optimized microservices communication with RESTful APIs, gRPC, and message brokers like Kafka and RabbitMQ.

Ensured high availability by designing microservices with fault-tolerance and circuit breakers.

Integrated microservices with cloud platforms such as AWS, Azure, and GCP for scalability.

security is reinforced in microservices by employing firewalls and security groups to restrict network access.

security between microservices is enhanced using service mesh technologies (like Istio) for secure communication.

security in microservices is improved by utilizing private networks or VPNs to protect data flows.

Network segmentation is a key security practice applied to isolate microservices based on their security requirements.

Implemented GIS data integration with PostgreSQL and PostGIS for enhanced data processing and spatial analysis capabilities.

Collaborated with cross-functional teams to support GIS data requirements in large-scale projects, providing insights and technical solutions.

Developed templates and forms in Microsoft Word and Excel to standardize reporting processes, reducing overhead for team members and increasing consistency in deliverables.

Automated routine reporting tasks and data extraction using Microsoft Excel macros and VBA scripts, improving operational efficiency and reducing manual errors.

Collaborated on cross-functional team projects using Microsoft Teams and Microsoft Office 365, ensuring seamless communication, file sharing, and document version control across global teams.

Supported system architects by visualizing cloud infrastructure and deployment strategies in Microsoft Visio, providing clear visual representations of cloud environments and service integration.

Designed and documented API specifications and data exchange models using Microsoft Visio, helping backend teams understand service architecture and data flow for complex systems.

Enabled team-wide collaboration and document management through Microsoft SharePoint, organizing project files, reports, and technical documentation in a secure and easily accessible environment.

Set up multi-language websites using plugins and ensured proper localization.

Environment: . C#, ASP.NET Core, ASP.NET Webforms, VB.NET, Angular, Knockout, TypeScript, JavaScript, HTML5, CSS3, Bootstrap, Entity Framework, LINQ, SQL Server 2016+, SSIS, SSRS, Microsoft Azure, AWS, REST APIs, Visual Studio 2022, Azure DevOps, GitHub, TFS, NUnit, Postman, Power BI, OAuth2, JWT, Docker, CI/CD, Jenkins, Git, Saas, JSON, XML, microservices, Pair Programming, IIS.

Lead C# Dot Net Full Stack Developer

State of MA- (Department of Healthcare Services), Boston, MA Apr 2021 –May 2024

Project# 1 Description:

The State of Massachusetts Department of Healthcare Services (DHCS) is responsible for overseeing and managing the healthcare programs within the state, ensuring residents have access to quality healthcare services. The department administers programs like Medicaid and the Children’s Health Insurance Program (CHIP), and ensures that low-income individuals, families, and those with disabilities receive necessary medical coverage

Responsibilities:

Create a Responsive Blazor Server application in .NET 7 with Visual Studio 2022 and SQL Server 2022 Database with Entity Framework Core.

Design and create SQL Server database structure (tables, views, functions, and stored procedures).

Implemented responsive and interactive user interfaces using React 17, enhancing the overall user experience.

Developed Python scripts to automate repetitive tasks, such as data cleansing, file manipulation, and report generation, resulting in a 30% reduction in manual effort.

Developed and optimized complex T-SQL queries, stored procedures, and views to retrieve and manipulate data from SQL Server databases efficiently.

Developed and maintained custom modules and functionalities within OpenText Server to optimize document management processes.

Designed and developed custom components, templates, and workflows in Adobe Experience Manager (AEM) to support dynamic web content management.

Worked with IT operations teams to ensure that ServiceNow was fully integrated with other IT service management tools, ensuring a cohesive approach to incident management, monitoring, and service delivery.

Customized ServiceNow modules to support business-specific use cases, optimizing workflows and ensuring that all user interactions adhered to organizational processes and policies.

Developed responsive and dynamic user interfaces using Vue.js framework, enhancing user experience and interactivity in web applications built on the .NET platform.

Implemented a real-time notification system using React Hooks to manage state and WebSocket API for instant updates, improving user engagement and experience.

Integrated Oracle database functionalities into .NET applications, optimizing data retrieval and storage processes for improved efficiency.

Designed and implemented GraphQL APIs using Hot Chocolate library in .NET, enabling efficient and flexible data querying for client applications.

Developed and maintained web and desktop applications using VB.NET, ASP.NET, and WinForms, adhering to coding standards and best practices.

Built component-based UIs with Blazor and MudBlazor, providing seamless and responsive user experiences across desktop and mobile devices.

Collaborated with cross-functional teams to integrate ASP.NET Web APIs, supporting complex data workflows and real-time client-server communication.

Optimized database performance on Microsoft SQL Server through query tuning and indexing, leading to a 25% improvement in data retrieval times.

Utilized Angular 15 framework to build dynamic and responsive front-end applications, leveraging TypeScript, HTML, and CSS for UI development.

Conducted regular code reviews and implemented bug fixes in a legacy ASP.NET Web Forms application, resulting in improved stability and performance.

Utilized React Context API along with React Hooks to manage global state and facilitate data sharing across components, leading to improved code organization and scalability.

Created custom modules, web parts, and widgets within Kentico to tailor solutions to business requirements.

Developed RESTful and SOAP APIs for seamless integration between Kentico and external applications.

Integrated Kentico with third-party systems like CRM (Salesforce, Dynamics), payment gateways, and other platforms.

Managed and maintained multi-language, multi-site environments using Kentico CMS.

Adhered to ISA-101 and other industry standards for effective SCADA visualization.

Enhanced SCADA performance through efficient scripting and resource management.

Optimized SCADA system performance by implementing streamlined scripting techniques and efficient resource allocation.

Managed the complete lifecycle of SCADA projects, from initial planning and design to final deployment and post-implementation support.

Implemented redundant SCADA architectures to ensure system reliability and minimize downtime.

Conducted comprehensive testing and validation of SCADA systems to guarantee seamless operation in production environments.

Incorporated energy monitoring functionalities within SCADA systems, enabling precise tracking and cost-effective energy usage.Leveraged Kentico EMS for email campaigns, marketing automation workflows, and A/B testing.

Led content migration efforts from legacy systems to Kentico, ensuring smooth transitions with minimal downtime.

Improved website speed and performance through caching, CDN implementation, and database optimization.

Implemented role-based access control (RBAC) and other security best practices to protect sensitive content.

Handled Kentico version upgrades and applied hotfixes to maintain system stability and security.

Collaborated with content teams, provided training sessions to editors, and ensured best practices in content management.

Established xUnit and Moq frameworks for automated testing, aligning with TDD best practices.

Applied Agile principles to enable continuous delivery, breaking down features into manageable tasks for iterative development.

Utilized Dapr building blocks for features like service-to-service invocation, state management, and pub/sub messaging.

Configure transport security in WCF services, such as HTTPS, for secure communication.

Manage certificates in WCF services to secure communications with X.509 certificates.

Encrypt data in WCF services using built-in security mechanisms to protect sensitive information.

The supportive nature of pair programming helps reduce burnout among developers.

Pair programming enhances testing practices through collaborative review.

Managed Kubernetes clusters to orchestrate containerized .NET applications in a microservices architecture, ensuring high availability, scalability, and reliability of the system

Developed and maintained Kafka producers and consumers using the Confluent. Kafka .NET client library

Responsible for implementation of Azure Function Apps of version 3 with .Net core 6.0 as target framework.

Created visually compelling and interactive reports with Power BI visuals, including charts, graphs, maps, and custom visuals.

Utilized Microsoft Visio to create and maintain clear and detailed process models, system architecture diagrams, and workflows to assist in the visual communication of complex application designs and technical processes.

Designed and documented application architecture and data flow diagrams in Microsoft Visio, supporting efficient troubleshooting and future scalability decisions.

Developed network topologies, service interdependencies, and deployment strategies using Microsoft Visio, ensuring alignment between infrastructure and application components for high availability.

Used Microsoft Excel to develop comprehensive reporting tools, leveraging advanced features like pivot tables, data validation, and complex formulas for real-time analytics and decision-making.

Created project schedules and resource management dashboards in Microsoft Excel, ensuring efficient tracking of milestones, budgets, and timelines throughout the development lifecycle.

Utilized Vuex for state management in Vue.js applications, maintaining a centralized state and enabling efficient data sharing among components.

Applied DevOps practices to Python projects, configuring CI/CD workflows for efficient testing and deployment.

Integrated SSRS reports into .NET applications, embedding them seamlessly within web interfaces or desktop applications.

Implemented reactive forms using RxJS to streamline user input handling and validation processes.

Successfully migrated legacy JavaScript code to TypeScript, reducing bugs and improving code readability by 30%.

Designed and implemented SSIS packages to automate data extraction, transformation, and loading (ETL) processes, reducing manual effort by 50%.

Utilized AWS RDS to host SQL Server databases for storing and querying financial transaction data in a .NET-based application.

Developed and maintained .NET applications with MySQL database integration, ensuring seamless functionality and optimal performance.

Utilized AJAX to implement asynchronous data retrieval and update operations, improving application performance and user experience.

Designed and developed responsive and visually appealing user interfaces using CSS, HTML, and JavaScript.

Optimized web application performance by implementing lazy loading techniques and optimizing CSS and JavaScript files.

Integrated with back-end APIs and services using JSON and XML for data interchange and communication.

Deploy Application on IIS Server on Windows Server as self-hosted.

Implement Telerik for Blazor Packages to design the components.

Proficient developing applications using ArcGIS Maps SDK for Interactive maps.

Implemented LINQ queries to retrieve, filter, and transform data from NoSQL Server databases.

Use Seri log Logging functionality to log Exception messages.

Developed data-driven web applications using .NET Core and Blazor, handling end-to-end functionality from UI to backend services.

Utilized MudBlazor for implementing modern, responsive layouts, creating visually engaging interfaces with minimal JavaScript dependency.

Executed code refactoring and optimization initiatives, reducing page load times by 40% and enhancing application performance.

Created responsive and interactive web pages using ASP.NET Web Forms, HTML, CSS, and JavaScript, ensuring cross-browser compatibility.

Implemented FHIR Query Parameters for filtered searches, pagination, and optimized data retrieval.

Created role-based access control (RBAC) using FHIR resource scopes to restrict access to sensitive data based on user roles.

Configured SMART on FHIR applications to allow patients and providers access to personal health information through mobile apps and portals.

Collaborated with cross-functional teams to design and implement FHIR-based workflows for clinicians and developers.

Managed decentralized data storage across microservices with SQL, NoSQL, and event sourcing patterns.

Developed and deployed microservices in CI/CD pipelines to automate build, test, and release processes.

Applied DevOps principles to monitor and maintain microservices using tools like Prometheus and Grafana.

Enhanced security in microservices with OAuth, JWT tokens, and API gateway-based authentication.

Enabled independent scaling of microservices based on workload demands to optimize infrastructure usage.

The Applications were implemented in an-AWS Environment.

Environment: .NET 7, Blazor Server app, Python, SSRS, Kubernetes, LINQ, ETL,TDD, HTML, CSS, JavaScript, Power BI, EFCore, SQL Server, TypeScript, Telerik, ArcGIS, AWS, Kendo, JSON, MySQL, VB.Net, Web forms, Kafka, Devops, Git, microservices, XML, Saas, IIS.

Project# 2

Design and Develop a Web application in Angular 14 to report incidents and wáter meter failures. Create .Net Core Web API in C# to communicate with back-end.

Responsibilities:

Create a Web application with Angular 14.

Design and Develop Responsive user interface using Angular Material.

Create custom directives, components, and Services.

Implement Rxjs Library to create new Observables.

Designed and deployed SSRS reports to provide real-time insights into sales trends, leading to a 20% increase in sales revenue.

Utilized RxJS to handle asynchronous operations and manage complex data flows in Angular applications.

Designed and implemented OIDC authentication mechanisms using libraries like Identity Server 4 or Azure AD B2C for .NET applications.

Developed Docker images for .NET Core applications, optimizing image size and dependencies to enhance deployment efficiency and reduce resource overhead.

Implemented client-side validation using JavaScript and jQuery to ensure data integrity and improve user input validation.

Implemented Vue.js plugins and extensions to extend the functionality of web applications, leveraging the vibrant Vue.js ecosystem to meet project requirements effectively.

Configure Azure Devops pipelines for build and Deployment.

Implemented Oracle data encryption techniques to enhance data security and comply with industry standards.

Contributed to the development and documentation of technical standards, guidelines, and best practices for T-SQL and Angular development within the organization.

Integrated energy monitoring solutions into SCADA for cost optimization.

Migrated legacy SCADA systems to Ignition for modernized capabilities.

Leveraged IoT and edge computing to connect SCADA with smart devices.

Optimized communication latency between SCADA and field devices.

Collaborated with IT teams to maintain SCADA server and network health.

Monitored and maintained SCADA systems to ensure 24/7 uptime.

Migrated legacy applications to Microsoft Azure,

Contact this candidate