Post Job Free
Sign in

Sql Server C#

Location:
Hyderabad, Telangana, India
Posted:
May 09, 2024

Contact this candidate

Resume:

Rajashekar Reddy

Contact: 309-***-****

Email: **********@*****.***

PROFESSIONAL SUMMARY:

●Having Around 5 Years of Experience in designing, developing, and testing n - Tier Client/Server Web-based Applications using Microsoft .NET Framework and SQL Server with Agile and Waterfall Development Methodology.

●Good in an Agile Environment using Scrum methodology (participated in backlog item sizing and prioritization, iteration/sprint planning, daily stand-ups, Sprint retrospectives, etc.).

●Expertise in Object Oriented Programming (OOPS) concepts in C#: Abstraction, Encapsulation, Inheritance, and Polymorphism.

●Good experience on DevOps essential tools like Docker, Kubernetes, GIT, Jenkins,

●Spearheaded SDL Tridion CMS customization and extension projects to align with business requirements, resulting in enhanced content management workflows and improved user experiences.

●Developed and implemented content models, schemas, and templates, ensuring consistent and dynamic content delivery across multiple channels.

●Collaborated with frontend and backend developers to integrate SDL Tridion with external systems, such as CRM and e-commerce platforms, achieving seamless data exchange and improved customer engagement.

●Troubleshot and resolved technical issues related to CMS implementations, optimizing system performance and ensuring minimal downtime.

●Mentored junior developers, facilitating knowledge sharing and fostering a collaborative development environment.

●Participated in Agile development processes, contributing to sprint planning, daily stand-ups, and retrospective meetings.

●Good at Angular JS 2.0/4.0/5.0 implementation on the client side.

●Transforming client requirements into technical specifications, Modeling and developing an application using VB.NET, ASP.NET, WCF, EF, WEB API, MVC, MVVM, SQL Server, and WPF.

●Proficient in using.NET based frameworks in a distributed architecture and utilizing the framework to create service-oriented applications (SOA).

●Implemented SAML SSO (Security Assertion Markup Language Single Sign-On) authentication for a web application, enabling seamless and secure access for users across multiple systems.

●Developed API endpoints using .Net core and Spring Boot to integrate with third-party systems, enabling data exchange and functionality enhancements.

●Designed and implemented custom SAML SSO connectors to establish secure identity federation between our application and external identity providers.

●Collaborated with cross-functional teams to ensure proper authentication and authorization workflows were implemented in compliance with security best practices.

●Worked closely with clients to understand their requirements and integrated our application with their SAML SSO infrastructure, ensuring a smooth and secure user experience.

●Utilized OAuth2 framework to secure API endpoints and enable controlled access to sensitive data, ensuring proper authentication and authorization mechanisms were in place.

●Extensively used HTML5, CSS3, JavaScript, JQuery, Typescript, Telerik Kendo UI Controls, Bootstrap, and AngularJS to create Single Page Applications (SPA).

●Used Chrome developer tools for Client-side debugging.

●Implemented AngularJS MVC Framework on the client side and worked with features HTTP Service to make AJAX calls, Route Providers, Filters, Factories and Controllers, Models, Views to manipulate DOM.

●Expertise using MVC 5 design pattern created Models, Views, Controllers, View Models, Partial Views, Action Filters, Validations, Data Annotation, Custom Model Binder and Routing using Razor view with HTML helpers and AJAX helpers.

●Experience in hosting .NET applications on IIS 5.0 / 6.0 / 7.0 and good working knowledge of DHTML, HTML, CSS, XML, XAML.

●Expertise in .NET technologies (NET Framework - 1.1, 2.0, 3.5,4.5) including ASP.NET, C#, VB.NET, Win Forms, ADO.NET, MVC, WCF, XML, LINQ, Web Services & AJAX, Entity Framework 6.1, Angular JS 1.5, K2 black pearl (4.6.5, 4.6.11), Microsoft Azure Experience with messaging systems like Kafka, Kafka event sourcing.

●Extensive experience in Building web applications using Kendo UI widgets, JQuery, Angular 4.0/2.0/JS.

●Used Kubernetes to orchestrate the deployment, scaling and management of Docker Containers.

●Experience in data migrating (using tools like DTS, BULK_INSERT, and BCP) between different systems and SQL Server as a part of Data Migration and Data Maintenance using SQL 2000

●Expertise in designing and developing Windows based applications, Web based applications and Responsive web applications with MVC, ASP.NET, C #.NET, VB.NET, Java Script, J2EE,jQuery, Bootstrap, Angular JS, React JS and CSS.

●Worked with databases like Oracle, My SQL, MongoDB in different projects.

●Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2016/2014/2012/2008 implement secure middle-tier components consumed by web applications and windows applications utilizing SQL Server and stored procedures to perform logical business transactions. And also developed SQL Scripting for SQL commands.

●Working experience in Azure App & Cloud Services, PaaS, Polybasic, Azure Data Factory, Azure SQL

●Experience using ORM framework like Entity Framework (Code First, Database First, Model First approaches) to map DB entities to domain objects.

●Experience working with Microsoft Azure Cloud based IAAS, PAAS and SAAS

●Experience implementing SAML2 SSO & familiar with OAuth and OpenID Connect for SSO

●Knowledge of WCAG (Web Content Accessibility Guidelines) 2.0 guidelines.

●Excellent analytical skills for understanding and gathering the requirements, business rules/processes and detailed design of the application, analyzing Gliffy Diagrams, ER Diagrams, and Data Flow Diagrams.

●Highly experienced with modern JavaScript frameworks libraries like AngularJS, Node JS, JQuery, Gulp, and JSON.

●Proficient in object modeling, use cases, activity diagrams and class diagrams using UML.

●Experience in working with WCF Services, Restful web services, XML, XHTML Web Services using SOAP and WSDL following SOA in a distributed environment.

●Good knowledge on Microservices, AWS (Amazon Web Services), working with EC2, RDS, Dynamo DB, S3, Cloud watch and Docker.

●Worked with CI/CD tools like Jenkins and Docker.

●Worked on Microsoft Dynamics CRM 2014 to manage the customer relationship in the industry.

●Knowledge on e-Commerce with CMS to get the application on the web with required design.

●Used Postman, Fiddler to test APIs.

●Good knowledge on JIRA and Bitbucket to get the applications worked.

●Prepared Technical design document, Use Cases, Test Cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit & System testing.

●Experience in working with version control tools like Team Foundation Server-TFS, VSS, Subversion (SVN), and GIT.Good at ITIL standards and practices, used in banking domain.

●Knowledge of building, deploying, and managing applications using Microsoft Azure, deployment using software containers like Docker.

TECHNICAL SKILLS:

C#, VB.NET, AngularJS 2.0/4.0/5.0, Node JS, HTML, CSS, Bootstrap, XML, J2EE, XML Schemas.

Programming languages

ASP.NET Core, ASP.net 4.6/4.5/4.0/3.0, ADO.NET, WPF, Entity Framework.

.NET Technologies

ASP.NET, MVC 5/6, Web API, AJAX, XML, Web Services, WCF, ASP 3.0/2.0, Active X, WSDL, UDDI.

Web Technologies

REST, SOAP, WSDL, XML.

Web Services

HTML5, CSS3, XML, XHTML, XSLT, SAML2.0, JavaScript, VBScript.

Markup/Scripting Languages

Visual Studio.Net 2008/2010/2012/2013/2015/2017.

RAD/IDE

MS SQL server 2008/2012/2014/2016, MS-Access, MySQL.,MongoDB

Database Development

SQL Management Studio, Query Analyzer, Export & Import (DTS).

SQL Server Tools

JavaScript, jQuery, TypeScript.

Scripting Languages

SQL Server Reporting Services (SSRS 2008), Crystal Reports (2011 (14.0.x), 2013 (14.1.x)), SQL Server Management Studio (SSMS), Crystal Reports.

Reporting Tools

TFS, GIT, VSS.

Source Repositories

PROFESSIONAL SUMMARY:

Client: State of Florida, FL March 2022 - Present

Role: Sr. .Net Full Stack Developer

Responsibilities:

●Implemented the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories, and iterations.

●Designed and deployed server-side application using ASP.NET Core, C#, Entity Framework.

●Used top design patterns, Sync Await, Dependency Injection, and Layered Architecture for building the application.

●Worked with Angular 9.0 routing, lazy loading, services, components, directives, pipes, interceptors, http and reactive forms to develop the client-side application.

●Used LINQ to SQL to create queries to fetch data from DB from Controllers.

●Written

● aggressive unit test cases for the code at least to cover 90%.

●Utilized Test-driven development (TDD) technique to drive the design of software and force decoupling of dependencies.

●Implemented SSO Service to create theSAML Assertion for exchanging autoactivation data between Service Provider and Identity Provider.

●Using SDL Tridion, I have integrated with other systems, such as customer relationship management (CRM), e-commerce platforms, and marketing automation tools, to create seamless digital experiences.

●Designed database tables based on SAML 2.0 schema required to manage Single Sign On (SSO).

●Used Jenkins pipelines to drive all micro services builds out to the Docker registry and then deployed to Kubernetes, Created Pods and managed using Kubernetes

●Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker, on GCP (Google Cloud Platform). Utilized Kubernetes and Docker for the runtime environment of the CI/CD system to build, test deploy.

●Manage various AWS/AZURE environments for provisioning of Linux servers and services implemented by the providers.

●Created a virtual Network on Windows Azure to connect all servers and applications on this platform

●Worked on configuring IIS, which includes creating websites under sites, Handler Mappings, Application pool, Http Bindings, and configured Application Request Routing (ARR).

●Setting up AngularJS framework for UI development. Developed html views with HTML, CSS, JQuery, JSON, and Java Script.

●Led the development of critical J2EE applications for various state agencies, supporting public services and citizen engagement initiatives.

●Worked closely with stakeholders to gather requirements and translate them into technical specifications for J2EE projects.

●Designed and architected enterprise-level applications using J2EE technologies, adhering to best practices and design patterns.

●Implemented complex business logic and workflows in J2EE applications, ensuring compliance with state regulations and policies.

●Collaborated with database administrators to optimize database schema and queries, resulting in improved application performance.

●Integrated J2EE applications with external systems and APIs, enabling seamless data exchange between state agencies.

●Used Nunit & Fake It Easy for backend test cases and Jasmine & Fake It Easy for AngularJS test cases.

●Migrated a basic application from Angular 1.5 to Angular 2.0.

●Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker, on GCP

●Development for WCF, SSIS, ASP.Net, C#, SQL Server

●Used Azure Active Directory B2C (Business to Consumer) service for authentication to authenticate consumer identity services like Confidential, Confidential and Confidential.

●services and the ASP.NET provider model.

●Designed, developed and migrated SSIS 2008 to SSIS 2012 packages.

●Unit Testing of Angular Projects as well as SSIS Projects

●Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket.

●Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS).

●Developed Custom controls and User controls for reusable part of the web pages using C# with ASP.NET.

●Involved in implementation of Unit Testing using NUnit.

●Introduced and implemented Agile Methodologies such as Scrum, Extreme Programming (XP) and Test-Driven-Development (TDD).

●Extensive experience of Rational Unified Process (RUP), UML, XML, SQL and Stored Procedures.

●Performed all unit testing, debugging and post-release support using Xamarin Test Cloud with different iOS/Android OS versions and devices.

●Created and Maintained Web Content and Email Templates relating to AWS.

●Implemented HTML Helper MVC Web Grid using Kendo UI for boosting the pagination performance and loaded the graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

●Created WCF Service to retrieve and send information from client side without Post Back and consuming existing Web Services using SOAP, HTTP and WSDL.

●Performed automation engineer tasks and implemented the ELK stack (Elasticsearch, Fluent, and Kibana) for AWS EC2 hosts.

●Implemented Restful services HTTP Handlers in developing Web Service replication interface for setting up data feeds for content transportation in XML and JSON formats.

●Worked on .NET Security features such as Authentication & Authorization, Forms-based Authentication, Authorizing Users, Roles and User Account Impersonation, tracing.

●Written SQL Scripts, for creating database tables with foreign key relations in SQL Server 2018 using T-SQL.

●Designed and developed several SQL Server Stored Procedures, User defined Functions, Triggers and Views for all the DML functionality of the application.

●Used GIT & Team Foundation Server for source control, data collection, reporting and project tracking.

●Using TFS Spring Templates and Maintained all the User Stories and Tasks in TFS.

Environment: .NET Framework 5.0, ASP.NET Core, Visual Studio 2019, MVC 5.0, C# 8.0, Entity Framework 3.0, AJAX, JSON, XML, XSLT, AngularJS, Angular 9.0, VB.Net, Kendo UI, HTML5, CSS3, Bootstrap, SQL Server 2018, T-SQL, TDD, GIT, TFS, IIS.

Client: Google, CA Sep 2020 – Dec 2021

Role: .Net Full Stack Developer

Responsibilities:

●Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

●Proficient in leveraging MongoDB and .NET technologies to deliver robust and high-performance solutions.

●Strong expertise in database design, query optimization, and performance tuning.

●Developed a scalable e-commerce platform using MongoDB as the primary database, handling millions of records and concurrent users.

●Implemented complex data models, including hierarchical structures and nested arrays, to optimize query performance and enable efficient data retrieval.

●Designed and implemented a highly available MongoDB cluster with sharing and replica sets to ensure data durability and high scalability.

●Implemented monitoring solutions using tools like MongoDB Cloud Manager or Datadog to proactively identify performance issues and bottlenecks.

●Using SDL Tridion separated content from presentation using templates. Content authors create and manage content, while designers and developers create templates that control how the content is displayed on the website

●Developed and maintained J2EE applications for Google's cloud-based platforms, leveraging technologies such as Java Servlets, Java Server Pages (JSP), and Java Persistence API (JPA).

●Collaborated with cross-functional teams to design and implement scalable solutions for complex business requirements.

●Integrated J2EE applications with various Google Cloud services, ensuring seamless data flow and optimal performance.

●Implemented security measures, including authentication and authorization mechanisms, to safeguard sensitive data and ensure compliance with industry standards.

●Utilized MongoDB's diagnostic tools, such as mongo stat and mongo top, to monitor database performance and identify areas of improvement.

●Employed log analysis techniques to troubleshoot and resolve application errors, ensuring smooth operation of MongoDB and .NET systems.

●Involved in the re-design and architecture of Designee Management System application using client technologies like Angular 4/5.

●Working on a .Net application with C#, Angular, LINQ, Web-API and PostgreSQL

●Involved in development of forms for Application Process and Selection process in Angular 4/5

●Designed server-side applications using MVC and Web form in web application framework.

●Worked with Angular 2 routing, Lazy loading and React (JSX) Forms to develop the client-side application.

●Involved in writing JUnit Test cases for unit testing.

●Used Spring IOC for dependency injection and developed controllers for handling Http requests and providing Http response.

●Using Service Bus Queues for communication in multi-tier Azure application

●Worked with Kafka Cluster using Zookeeper. Developed Applications using Rule Engines-Jboss Drools 4.x, Work flows, Human tasks to implement Business rules validations.

●Implement Single Sign On using SAML2 for Integrate HR (Paperless Onboarding) & Conexus COBRA

●Managed Kubernetes charts using Helm. Created reproducible builds of the Kubernetes applications, managed Kubernetes manifest files and Managed releases of Helm packages.

●Created shell script batch job to load the fresh data using ETL workflow.

●Utilized Test-driven development (TDD) technique to drive the design of software and force decoupling of dependencies.

●Developed system services SOA application platform for use by all web applications utilizing WCF services and the ASP.NET provider model.

●Created Data Access Layer, BLL Business Logic Layer, Presentation Layer Classes using C# and .Net 4.0 for web pages.

●Used Microservice architecture, based services interacting through a combination ofRESTand leveragingAWSto build, test and deploy Identity Microservices.

●Implemented and maintained the monitoring and alerting of production and corporate servers/storage using AWS Cloud Watch.

●Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS). Developed Custom controls and User controls for reusable part of the web pages using C# with ASP.NET.

●Achieved Dependency injection by creating spring services, spring controllers and DAOs to wire objects of business classes.

●Kubernetes is being used to orchestrate the deployment, scaling and management of Docker Containers.

●Involving in implementation of Unit Testing using JUnit.

●Prototyped new features and ideas - Google Drive Drawing, Photoshop, HTML, XML, Sass, and React.js.

●Used AJAX controls to retrieve the data from the server without interfering the display and behavior of existing page.Worked on WEB API manipulation for companies’ intranet sites based on SDL Tridion.Used jQuery as it is a lightweight JavaScript library that emphasizes interaction between JavaScript and HTML.

●Used MVVM to decouple Xamarin code from the main code to make it pliable for the Unit Testing.Used jQuery and Prototype to meet AJAX and DOM scripting needs.

●Involved in coding and designing using C#, XML, ADO.NET, WCF, JavaScript, React JS, Underscore JS, JQuery, HTML, and Cascading Style Sheets (CSS).

●Designed and developed rich and enhanced web pages using MVC 4.0, C#, Entity Framework, JSON, HTML 5, CSS 3 and JQuery.

●Working on Rational Unified Process (RUP), UML, XML, HTML, SQL and Stored Procedures.

●Performed all unit testing, debugging and post-release support using Xamarin Test Cloud with different iOS/Android OS versions and devices.

●Developed React JS/ .NET web application using JavaScript, ASP.NET MVC 5, C#,

Visual Studio.

Environment: NET Framework 4.0, Visual Studio 2010, MVC 4.0, DTS Packages, DBMS, C# 4.0, Entity Framework, AJAX, JQuery, JSON, XML, XSLT, JavaScript, SQL Server 2008, VB.Net, Restful, TDD, SQL Server 2012, LINQ, T-SQL, TFS, IIS, HTML 5, CSS 3, React

Client: Tecordeon, Hyderabad, India March 2019- Aug 2020

Role: .Net Developer

Responsibilities:

●Implemented AGILE development methodology and provided estimates, and participated in Weekly grooming meetings, daily & weekly status report to the client on progress of the tasks.

●Used Jenkins pipelines to drive all microservices builds out to the Docker registry and then deployed to Kubernetes, Created Pods and managed using Kubernetes

●Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker, on GCP (Google Cloud Platform) . Utilized Kubernetes and Docker for the runtime environment of the CI / CD system to build, test deploy.

●Also, used Azure for Scaling and checking the reliability of the applications which were developed during the project.

●Experience on Deployment Automation & Containerization (Docker, Kubernetes).

●Changing the AWS infrastructure Elastic Beanstalk to Docker with kubernet.

●Collaborating with designer to create views for a responsive App and maintaining current code.

●Used Entity framework CODE FIRST to improve the overall performance of the application.

●Designed and developed MVC architecture with WCF binding concepts for making data binding for end points.

●Designed the Views, Layout pages, and Partial views using ASP.NET MVC, AngularJS 2.0/4.0/5.0, JQuery, AJAX, HTML5, CSS3 and BOOTSTRAP.

●Working as Module Lead for manufacturing service layer (MSL) component.

●Used spring for cross cutting concerns and IOC for dependency injection.

●Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and automated stored procedures.

●Data migration using ETL Tools in DTS.

●Written several packages using SSIS 2008 for data migration and ETL process.

●involved in complete application stack in Amazon Web Services (AWS)like EC2, S3 Bucket.

●Design, manage, and maintain tools to automate operational processes. Pick the right AWS services for the application.

●Leveraged AngularJS 2.0/4.0/5.0 resources for all data access, encapsulating URLs and standardizing data access interfaces. Created custom directives for re-usable components (multi-filed form elements, background file uploads, etc.).

●Tested the application as per the test cases and business logic using unit test and fixed the bugs.

●Implemented AngularJS 2.0/4.0/5.0 Controllers to maintain each view data.

●Implemented Angular Service calls using Angular Factory.

●Implemented data access using ADO.NET Entity Framework to store and retrieve new user information for further use.

●Use dependency injection-heavy classes to assist with comprehensive unit testing

●Written complex stored procedures and functions using PL/SQL for implementing backend logic for generating client notices.

●Worked in an Agile environment (scrum methodology) and participated in all stages of SDLC. Worked on all aspects and layers of the application. Developed front end using JavaScript, JQuery, Angular, Bootstrap, CSS, MVC 5. Created WCF services and Class libraries to implement business logic NHibernate 3.2 used as ORM. Developed unit tests using NSubstitute, MS Test, Autofac. Performed BDD test development using Gherkin syntax, Specflow, Selenium Webdriver API. Implemented section 508 requirements.

●Developed Responsive Web pages that are rich in user interactive using ReactJS, HTML5, and CSS3, JavaScript, jQuery Bootstrap.

●Developed and implemented the multi-threaded Web forms, Winforms GUI design by using .NET framework, Visual Studio 2017.

●Wrote application using Web API to talk to external applications and involved in writing small ASP.NET Web Forms application with VB.NET as programming language.

●Used Spring Core for concept Inversion of control (IOC) implemented using Dependency Injection.

●Implemented several services connecting to a WPF client to perform Read operations against SQL Server backend.

●Used Authentication when we recall the previous quote using email address and password.

●Implemented Server and Client-side validations using ASP. Validation controls, J-Query.

●Created and consumed ASP.NET Web services and implemented Restful Web API/WCF services for service layer and created Action filters and Exception filters to implement REST services.

●Developed n-tier Architecture and distributed .NET applications using Web Forms, Win Forms.

●Developed components using Spring Framework (Spring MVC, Core, dependency injection, Bean, spring security, and Spring AOP, Spring Boot, Aspects, Dependency Injection).

●Used Unit framework for unit testing (MSUnit and NUnit) the application.

●Used React-Router to turn application into Single Page Applications.

●Worked on using React JS components, Forms, Events, Keys.

●Performed Integration Testing, Load Testing, and Unit Testing using Visual Studio testing tools.

Environment: C#, ASP.NET, ADO.NET, Win form, Restful, MVC5, VB.NET, ReactJS, WCF, Web API 2.0, .NET Framework 4.5.2, NUnit, HTML, HTML5, CSS3, AJAX, CSS, Angular 2/4/5, SQL Server 2016, Entity Framework, Visual studio 2017, JavaScript, JQuery, N SERVICE BUS, MS SQL Server, TFS 2017, GIT.



Contact this candidate