Post Job Free

Resume

Sign in

.Net Developer Sql Server

Location:
Avondale Estates, GA, 30002
Posted:
February 06, 2024

Contact this candidate

Resume:

Omair Siraj, Syed

Senior .Net Developer

ad3e5s@r.postjobfree.com 706-***-**** https:// www.linkedin.com/in/omairsiraj

Summary of Experience:

Over 9.3 years of experience in the IT industry, specializing in the design, development, application architecture, and maintenance of web-based technologies using Microsoft .NET.

Proven track record in team leadership, system analysis, design, and implementing flexible solutions with expertise in object-oriented software development using Microsoft technologies and relational databases.

Substantial experience in various .NET applications using Visual Studio .NET 2012/2010/2008 technologies, including C#.Net, Angular JS, Angular 2/4/6/8/9/11/13/14, Node Js, React JS, VB.net, Asp.net, Telerik Controls, Silverlight, AJAX, XML, and JavaScript.

Good understanding and working experience with ASP.NET providers.

Experienced in resolving problem logs and bugs logged by testers and businesspeople in .NET applications.

Vast experience in database systems, namely MySQL, MS SQL Server, MS Access, and Oracle.

Experienced in Microsoft’s Data Warehousing Tool SSIS (SQL Server Integration Services) and SSRS.

Hands-on experience in DTS, ETL, Creating Jobs, Packages, and Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) on SQL Server Database.

Strong skills and understanding of Object-Oriented Programming concepts, including Inheritance, Abstraction, and Polymorphism.

Extensive knowledge of developing stored procedures, triggers, functions, and optimizing queries for performance using MS-SQL Server & SQL Profiler.

Designed and developed .NET applications and coded for database applications to interact with the database, using ADO.NET, ADO, and customized frameworks.

Ability to write and interpret complex shell scripts in Bash and PowerShell.

Comprehensive experience with LINQ to Objects, LINQ to SQL, and LINQ to XML.

Experience with developing web applications using MVC, MVP architecture, and Application Blocks.

Worked extensively with ADO.NET objects such as Data Adapter, DataSet, and Data Reader to interact with databases like SQL Server & Oracle.

Experience working on Crystal Reports.

DevOps experience of around 7 years.

Experience with version control systems TFS and Source Safe.

Design and implementation for hosting large, complex applications in Azure.

Experience in consuming and publishing web services.

Knowledge of AJAX Control Toolkit and AJAX Extensions.

Created comprehensive reports using MicroStrategy and Tableau, providing actionable insights for key stakeholders.

Leveraged PuTTY for terminal access, navigation, and bash scripting in Linux environments, optimizing workflow efficiency.

Utilized REST Web Services to facilitate seamless data communication and integration within projects.

Operated within a SCRUM Agile environment, contributing to streamlined project delivery and collaboration.

Demonstrated intermediate expertise in database design, development, and implementation, enhancing data management practices.

Developed and maintained comprehensive automated test scripts using Selenium WebDriver for web applications, ensuring coverage of functional and regression testing.

Conducted rigorous cross-browser testing using Selenium to ensure consistent application behavior across multiple browsers.

Integrated Selenium scripts seamlessly with testing frameworks such as NUnit to organize and manage tests.

Incorporated Selenium-based automated tests into CI/CD pipelines enabling automated and scheduled test executions as part of the development lifecycle.

Applied performance tuning and query optimization techniques to enhance database efficiency and streamline query execution, ensuring optimal system performance.

Employed MSBuild and Nuget package administration, implementing automated build and deploy strategies for efficient workflows.

Good communication and interpersonal skills. Self-motivated and willing to learn new technologies and third-party products.

Excellent written and oral communication skills, capable of explaining complex technical issues in easy-to-understand terms.

Technical Skills:

Category

Technologies

.NET Technologies

ASP.NET 1.1/2.0/3.5/4.0/4.5, .NET Core 1.1/2.0/3.1/6, ADO.NET, AJAX, Classic ASP, LINQ, Entity Framework, Angular JS, Angular 2/4/8/9/11/13/14,

Languages

C# .NET, VB.NET, Visual Basic, C, C++, Java, PL/SQL, T-SQL, GraphQL,

Python, Ruby, PHP

Web Technologies

HTML, HTML5, DHTML,XHTML, XML, XSLT, XSD, WSDL, XAML, JSON, SOAP, CSS,SAAS,Web forms, Web Services, Win forms, WCF, WPF, MVC, Silverlight, XSLT, WSDL&UML, Angular 13/14, Node.js, React.js,

Scripting Languages

JavaScript - Leaflet, jQuery, Visual Basic Script, TypeScript, ESRI Java Script API.tf

Databases

SQL SERVER, Cassandra DB, Oracle & Oracle Spatial, MySQL, MongoDB, Postgres

Framework

Microsoft.Net Framework, .Net Core Framework

Operating Systems

Windows 98/NT/2000/XP/Vista/Windows 7/ Windows 8/8.1/Windows 10

IDE

Visual Studio 2003/2005/2008/2010/2012/2013/2017, Visio

Web Servers

IIS (Internet Information Server)5.0/6.0/7.5

Testing Tools

Microsoft Visio 2003, NUnit, XUnit, Http Client, Jest, Cypress, Selenium Webdriver and Rest Assured.

Reporting Tools

SQL Server, SSIS, SSRS, SQL Server Management Studio (SSMS)

Version Control

Visual Source Safe 6.0, Team Foundation Server, Tortoise,GIT, SVN and Mercurial

Project Experience:

Client: Nationwide, Columbus, OH Jan 2023 – till date

Role: Senior .Net Developer

Responsibilities:

Design solutions for various system components using Microsoft Azure Databricks and Datalake for data processing.

Rewrite legacy Windows Forms applications into web-based applications using web forms and client-side technologies like jQuery, JavaScript, JSON Data, NodeJS, and Angular 13/14.

Style web forms using HTML5, CSS3, Bootstrap, Data tables, and Font-Awesome for a modern and user-friendly l application interface.

Create Business Logic Layer & Data Access Layers to implement the MVVM architecture for efficient data handling.

A robust and lightweight web framework for building modern, cloud-based, and cross-platform applications.

Develop middle layer components using C#.NET, VB.NET, MongoDB, and ASP.NET, ensuring robust and scalable applications.

Improve the UI using Angular 14, Angular Material, Bootstrap, Kendo UI and Priming for enhanced user experience in applications.

Well-suited for microservices-based applications, allowing developers to build and deploy independent, scalable services.

Seamless integration with major cloud providers like Azure, AWS, and Google Cloud, supporting cloud-native development.

Implement ASP.NET MVC validation at the Controller level to ensure data integrity in processes.

Develop RESTful API services using .NET Core WEBAPI, C#, .NET Framework 4.5, LINQ, and MySQL, employing a claims-based authorization model for secure data access.

Implement token-based security using Restful API, ensuring a secure l application environment.

Develop web pages using Angular Class Libraries with best practices for l applications.

Create reusable components, custom modules, custom directives, pipes, and services in Angular 11 for efficient application development.

Developed and maintained comprehensive automated test scripts using Selenium WebDriver for web applications, ensuring coverage of functional and regression testing alongside designing solutions for various system components using Microsoft Azure Databricks and Datalake for data processing.

Conducted rigorous cross-browser testing using Selenium to ensure consistent application behavior across multiple browsers while rewriting legacy Windows Forms applications into web-based applications using web forms and client-side technologies like jQuery, JavaScript, JSON Data, NodeJS, and Angular 13/14.

Implemented Continuous Delivery processes, building Docker Images, and publishing into a private repository (Nexus v3) for streamlined deployment.

Utilized Agile Software Development methodologies, enabling efficient high-quality software development.

Managed source code using TFS for version control among team members.

Researched and documented new technologies beneficial for application development and DevOps practices.

Write complex SQL queries and stored procedures using SQL Server Management Studio for reporting and data processing.

Create joins, views, functions, stored procedures, and triggers as part of database programming for applications.

Perform unit testing on developed applications using Karma for reliable software.

Spearheaded the development of high-performance web applications, integrating Rest APIs and microservices using Node.js and .NET technologies.

Successfully delivered end-to-end solutions, covering both front-end and back-end development aspects, ensuring a comprehensive and seamless user experience.

Expertly utilized multiple IDEs for efficient development workflows and demonstrated mastery in languages such as C# and TypeScript, optimizing code quality and maintainability.

Engineered and maintained Rest APIs, with a specific focus on microservices architecture. Leveraged React.js for WebApp development, ensuring responsive and dynamic user interfaces.

Deployed applications on AWS, harnessing the power of AWS Lambda and API Gateway. Effectively utilized AWS services for data storage, employing both Postgres and DynamoDB databases.

Applied advanced principles of object-oriented design to ensure scalable and maintainable code structures, promoting modular development.

Implemented optimized SQL queries and leveraged Prisma ORM for seamless interaction with databases, ensuring data integrity and performance.

Led the complete lifecycle of REST API development, from initial design and coding to rigorous testing, deployment, and ongoing maintenance, ensuring adherence to industry best practices.

Conducted in-depth system analysis, identifying and resolving SQL bottlenecks. Applied robust troubleshooting skills to address complex issues, ensuring the reliability and efficiency of systems.

Implemented Infrastructure as Code using Terraform, automating the provisioning and management of infrastructure components, resulting in streamlined deployment processes.

Pioneered containerized and serverless application development using Docker, Lambda, and Kubernetes for enhanced scalability and resource optimization.

Played a crucial role in production support within a collaborative team environment, interfacing with multiple interfaces seamlessly.

Championed CI/CD practices, orchestrating seamless AWS deployments using tools like Harness and GitHub.

Actively participated in Agile methodologies, advocating for Test-Driven Development (TDD) to ensure code quality and reliability.

Engage in testing, debugging, maintenance/enhancement of projects, including code reviews for quality assurance.

Manage timelines, ensuring timely completion of projects as per estimates and maintaining high-quality standards.

Responsible for deployment in the client environment, ensuring smooth integration and functionality of applications.

This rearrangement emphasizes the technology and responsibilities relevant to application development and the client's needs.

Environment: Agile, Visual Studio 2012/2017, .Net Framework 4.0/4.5, VB.NET, ASP.NET MVC, Entity Framework, ASP.NET Web Forms, Azure, Docker, Kubernetes, Angular 14, Knock Js, WPF, Js, jQuery, AJAX, ADO.NET, MongoDB, TFS, AWS, Node Js, Data tables, Type Script, HTML5, T-SQL, SQL Server 2014, .net core 6, SSRS, SSIS, Crystal Reports, Apache Kafka, MySQL, Kendo UI, Prisma

Client: Wellcare Tampa, FL June 2020 – Dec 2022

Role: .Net Developer

Responsibilities:

Extensively worked on Agile SDLC methodology, participating in scrum meetings and sprint planning for software projects.

Collaborated in a complete agile team focused on gathering and designing tasks based on customer requirements in the domain.

Utilized PL/SQL for ETL code to meet data requirements, ensuring extraction, transformation, cleaning, and loading of data from source to target data structures.

Performed account/customer maintenance in applications using Account Maintenance (AM) and Beta Back Office (BBO) tools.

Collaborated with business analysts to gather and document business requirements through JAD sessions, ensuring clarity and specificity.

Led server migration in settings using AWS cloud servers, leveraging features like EC2, S3, Auto Scaling, RDS, ELB, EBS, IAM, and Route 53.

Designed Angular 8 modules and controllers for applications, implementing directives for effective user interfaces.

Developed Silverlight dashboards for managing project finances and displaying current project capacities.

Ensured ADA accessibility in applications through testing with NVDA Screen Reader, JAWS, Firebug, Colour Contrast Analyzer, and WCAG contrast checker.

Utilized SQL’s Data Definition Language (DDL) to design and modify database structures for the project, ensuring efficient data storage and retrieval.

Executed complex queries using Data Manipulation Language (DML) in PostgreSQL to extract, transform, and load data for analytics purposes.

Developed single-page applications (SPA) for using Angular 8, Asp.Net, C#.Net, HTML5, CSS3, and JavaScript.

Created reusable templates in applications using Angular directives and worked with NPM package manager tools (NodeJS).

Implemented WCF services for real-time data communication in applications, using SoapUI for functional testing/debugging of web services.

Utilized Kubernetes and Docker for CI/CD system runtime environment, facilitating build, test, and deployment on AWS servers.

Implemented Angular 8 routing and navigation, components, and services for efficient application development.

Designed, architected, and programmed WinForms, web-based applications, and libraries for data processing.

Analyzed and designed new .NET web, batch, and WCF applications in, providing effective visualization through charts and KPIs.

Prepared technical documentation, including system architecture and design documents for software projects.

Leveraged OpenStack and AWS cloud services for server launches, security group management, and PowerShell scripting.

Successfully deployed enterprise-grade PaaS solutions using Pivotal Cloud Foundry (PCF) for application migration and development.

Developed and executed test automation using a custom C# automation framework for functional testing in applications.

Designed and developed microservices using the MEAN stack (Nodejs, MongoDB, Angular) on a private cloud OpenStack platform for healthcare solutions.

Developed Windows applications with WinForms GUI and web applications using MVC frameworks for data management.

Conducted data requirements gathering for AutoSys installation on Windows and UNIX servers in the domain.

Developed web pages using Asp.net, HTML, and CSS for applications, ensuring a user-friendly interface.

Environment: Silverlight, WCF, ASP.NET, Console Application, C#, .Net Core 1.0, Jenkins, Tortoise SVN, GIT, PRISM, Pivotal Cloud Foundry, TDD, Angular 4/6/8, WPF, HTML, CSS, AWS, Google Cloud, Nodejs, Ajax, ADA, SoapUI, Swagger, Postman, jQuery, JavaScript, TFS, PL/SQL, D3.js, PowerShell, Automation Testing, SQL Server 2012, Kafka, Docker, Kubernetes, Windows,DDL,DML.

Client: Credit Suisse, New York, NY Nov 2019 – May 2020

Role: .Net Developer

Responsibilities:

Led a diverse set of assignments in the sector, involving information technology analysis, design, development, implementation, and maintenance of databases and applications.

Created icons, wireframes, and web applications with ASP.NET using MVC framework for various modules in the application.

Designed and developed applications using Agile/Scrum development life cycle to meet the dynamic needs of the industry.

Implemented single-page applications, incorporating Angular 2/4 for interactive cross-browser functionality in the user interfaces.

Responsible for UI design, creating contracts, and classes in WCF and WPF for different application modules.

Collaborated with UX teams to implement mock-ups and layouts, ensuring a seamless user experience in applications.

Developed UI using HTML5, TypeScript, and Angular 4, adapting web applications for the environment.

Created and maintained front-end pages using HTML/HTML5, SCSS, TypeScript, and JQuery, ensuring a professional appearance.

Built reusable templates for websites using Bootstrap and Font-awesome fonts.

Developed and consumed WCF web services to access data layer components, fostering seamless integration in applications.

Maintained the existing cloud environment using Microsoft Azure, adapting web applications to run against SQL Azure.

Utilized Azure Queues for background processing in the context of application development.

Developed client-side validation code using TypeScript and JQuery, ensuring data integrity and security in applications.

Created master pages with new icons, logos, buttons, colors, images, and fonts for a consistent look and feel of applications using SASS styles and HTML/HTML5.

Created database tables, wrote SQL queries, and designed stored procedures for all transactions in and out of the database using SQL Server, catering to the specific needs of operations.

Utilized Microsoft development tools like Visual Studio and Team Foundation Server (TFS) for efficient coding, issue tracking, and collaboration in application development.

Leveraged the Team Foundation Server for issue tracking, ensuring effective communication and problem resolution within the project team.

Environment: HTML/HTML5, CSS/CSS3, MVC frame work, TypeScript, JavaScript, Angular.JS, JQuery, Kendo UI, Bootstrap, AJAX, Entity Framework, Microsoft SQL Server, web forms, Agile development methodology, C#, ASP.Net, WCF, Azure, Web Services, Team Foundation Server, Adobe Photoshop, Adobe Illustrator, Dreamweaver.

Client: IEG, Hyderabad, India June 2017 – July 2019

Role: .Net Developer

Responsibilities:

Created different system pages which help executives to sell credits using the following technologies ASP. Net, C#, SQL Server, JavaScript, WCF, SmartClient, Telerik

Designed and improved software development process, including creation of application to improve quality of software and cement the ability to reliably deliver releases on schedule.

Using Azure Cloud services performed various web operations in Azure App Service

Worked on cloud computing using Windows Azure and SQL Server Azure

Involved in Database Design, creating tables, indexes, views, stored procedures, referential integrity.

Developed the complex features in C#, LINQ, SQL Server, and Oracle, i.e. the interaction with the other systems and APIs. Implemented MVC Filters on Authentication, Authorization and others.

Developed Web apps with HTML, CSS, JavaScript, Angular JS, jQuery, ASP.NET MVC, AJAX, JSON, Bootstrap and Telerik controls.

Design and developed using C# .NET SmartClient, taking advantage of Entity Framework and SQL Server with Windows and Web Services

Developing RESTful services with WebAPI and SOAP Web Services to be consumed by Web Applications.

Defined the architecture and technologies to use. Reviewer of analysis, design and implementation of application using ASP.NET MVC Core Architectural Design Pattern.

Responsible for implementing two screens from end to end. The MVC application also utilized Razor and LINQ. Involved in Deployment and Troubleshooting issues in the application during Go Live.

Implementation of Windows services using C#. Implement Agile Methodology focusing on TDD and Scrum. MS SQL, Oracle utilized to store data from integration layer processing.

Improved the test process using MSTest for unit testing, and FitNesse for integration testing.

Collaborated on creation of user stories and acceptance criteria with business owners and subject matter experts.

Documented entire project from machine setup and coding standards to test environments and system architecture.

Environment: C#, .NET, ASP.NET, MVC, Entity Framework, Data Model, XML, JSON, WebAPI, RESTful, Telerik, SSL, Visual Studio, SQL Server, LINQ, jQuery, JavaScript, Angular JS, CSS3, HTML5, Azure, TFS repository, GIT, MS Visio, SmartClient, Telerik.

Client: Cybage Software Solutions, Hyderabad, India Oct 2014 – May 2017

Role: Junior .Net Developer

Responsibilities:

Participated in Design reviews, Architecture reviews, Code Reviews and proposed solutions to the business problems.

Extensively used LINQ to Objects to query the objects based on requirement.

Used ASP.NET 3.5 Server controls, User Controls and HTML controls.

Developed Web pages with ASP.NET using JavaScript, Client-Side Validation, Server controls, HTML5 Controls, jQuery, and CSS.Implementing the Object Relational Mapping using nHibernate.

Using MVC 5 architectures to developed web-based applications.

Utilized ASP.NET, C#, Service Oriented Architecture (SOA), Windows Communication Foundation (WCF).

Implemented Data Access layer, Caching Application block, Application validation, Exception handling and logging components using Microsoft Enterprise Library 4.1 Application Blocks.

Developed and used various Web forms, Custom Controls and User controls using ASP.NET, C# and JavaScript.

Writing Complex Stored Procedures in SQL to pull data from DB2 and Oracle.

Involved in Database Designing, Views and Stored Procedures in SQL Server.

Involved in Unit testing and Integration testing with other modules.

Creating reports using the Crystal Report for the report needed by Middle Office, Back Office users.

Created Styles, Templates in Silverlight in designing the UI with XAML.

Environment: C# 3.0, ASP.NET 3.5, MVC 5, XAML, Visual Studio, ETL, ADO.NET, Js, HTML, DHTML, XML, XSL, XSD, SOAP, Web Services, jQuery, nHibernate, Ajax, Oracle, SQL Server

Educational Details:

Bachelor of Technology from Jawaharlal Nehru Technological University Hyderabad, India (2014)



Contact this candidate