Post Job Free

Resume

Sign in

Sql Server Visual Studio

Location:
Ashburn, VA
Posted:
September 22, 2023

Contact this candidate

Resume:

Bhargav T J

703-***-**** adzvkq@r.postjobfree.com

https://www.linkedin.com/in/bhargav-t-j-b68323289/

SUMMARY:

Expert in developing web applications, and services in Microsoft Visual Studio .Net IDE using Classic ASP, ASP.NET, C#.Net, VB.NET, ADO.NET, Entity Framework, LINQ, MVC, WCF, and SQL Server.

Proficient in developing web and Windows applications with Microsoft .NET framework 4.7.2/4.6.1/4.6/4.5.2/4.5.1/4.5 using C#, SQL Server 2012/2016 which includes the development of Functions, Stored Procedures, Views, Joins and Triggers and on MS Access.

Developing complex user interfaces (GUI) using ASP.NET 5.0/ 4.0 and MVC 5.0/4.0/3.0.

Building Single Page Applications (SPA) using Angular7/8/10 framework, Services, templates, directives, and Typescript.

Hands-on experience with JavaScript, Html5, Css3, Bootstrap, Angular 7/8/10 modules.

Extensive Experience with LINQ and ORM technologies like Entity Framework 6.0/5.0/4.3, Database First, Code First, and performance tuning in Entity Framework.

Good working experience using Source Code Control Systems like Microsoft Visual Studio, Microsoft Team Foundation Server, and GitHub.

Working experience in developing and scheduling build and release pipelines using Azure DevOps (CI/CD).

Proficient in Design Patterns, OOP concepts, Object Oriented Design, and SOLID Principles.

Experience Working in Agile Scrum and waterfall Methodologies.

Working experience in developing and scheduling build and release pipelines using Azure DevOps

Involved in the Development, Maintenance, and Documentation of diverse applications.

Effective working independently and collaboratively in teams.

Experience working in production activities such as release planning and risk analysis.

Experience in developing Console Applications for task scheduler batch jobs.

Worked with .NET Server Controls, User controls and Forms Validation Controls using ASP.NET

Implemented N-Tier Architecture and integrated the UI with the Database for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.

Experience in SQL Server Database Design, Analysis, and Normalization and in writing tables, Stored Procedures, Views, Triggers, Indexes, and Constraints.

Experience in database development, in creating complex Stored Procedures, Views, and Triggers using SQL, T-SQL, and performance tuning in SQL Server 2016.

Experience in securing web applications using ASP.NET authentication (Forms-based Authentication) and authorization mechanisms like authorizing Users, Roles, and User Account Impersonation.

Experience in Azure for system Deploying, Operating, and Maintaining compute, network, and storage in the Microsoft Azure environment using Microsoft Technologies.

Ability to analyze problems and root causes develop innovative solutions to business challenges and streamline operations.

Excellent analytical and interpersonal skills, Quick learner, and good performer both in team and independent job environments. TECHNICAL SKILLS:

Programming Language C# .NET

Web Technologies HTML5, CSS3, XML, JavaScript Object Oriented Programming, SASS & LESS CSS Extension language.

JavaScript Frameworks &

Technologies

JQuery, Angular, Bootstrap

Web .NET Framework, ASP.NET, ASP.NET MVC, Web Services, ADO.NET, LINQ, Log4Net, NuGet, Entity Framework, Web Forms, Web API, SSIS Development Tools GitHub, TFS, Visual Studio 2017/2019/2022, Visual Studio Code, Microsoft SQL Server Management Studio.

RDBMS MS SQL Server 2012/2016, MySQL, SQL Server 2012, Snowflake, Oracle, MongoDB

ERP / CRM Dynamics 365, Salesforce

Methodologies Agile, Waterfall

Source Repositories Azure DevOps, GIT, TFS, Visual Source safe Cloud Environment Azure DevOps, Azure

WORK EXPERIENCE:

Green Project Technologies – New York, USA Jan. 2023-Jun.2023 MongoDB Developer

Responsibilities:

Monitoring the MongoDB Atlas Staging Cluster to find the slow-running queries in the profiler search engine.

Identified the queries that are tagged as slow while most of them are running COLLSCAN as property.

Programmed and found the slow-running queries in the staging environment.

List of collections in staging mapped with the production server and identified the same collections perform the slow operations in the production.

Verified the query performance and found the execution time is more than 1000 milliseconds.

Slow performance queries are optimized in the development platform and deployed in staging and production servers.

Optimal Indexes are replaced with COLLSCAN in the query performance.

Average time is brought to 50 milliseconds in the production server.

Upgrading the version control in the staging server from 5.6v to 6.0v. Environment: MongoDB Atlas, Trello, MS Office, NoSQL, Slack Cybage Software Pvt. Ltd – Hyderabad, India Dec. 2020-Jun.2022 Software Engineer

Responsibilities:

Involved as a part of the Core development team and hotfix for production issues and legacy bugs.

As a development team member involved in the business user requirements grooming on change requests.

Programmed and updated enhancements to the application using Dotnet, and AngularJS for clients: IPSOS and USPS.

Coordinated with a team of 22 in planning, requirement gathering, system design, and implementing application modules, and unit testing.

Implemented .Net framework 4.7.2 and Object-Oriented Methodologies for application development.

Involved in using Angular JS components, Forms, Events, Keys, and Routers.

Experience with hosting Web Apps, Creating SQL, Web Roles, and Worker Roles in Azure.

Involved in the creation of User controls, custom controls using C#, and ASP.NET that build up the pages.

Building Strongly Typed applications with Angular 8/9/10 and ASP.NET MVC.

Created a Folder cleanup configuration service, hosted it in the IPSOS server to delete the old log files, and deployed it on 30+ applications. Programmed and automated scripts using pseudo code and pipeline, speeding up manual tasks by 90%.

Performed validations on Web Forms using .NET Validation Controls and Client Side Validation using Angular 8/9/10.

Worked with User Controls C#.NET code-behind files, debugging, and Quality Testing of the code.

Worked with Events, Delegates, Anonymous Methods, Indexers, Generics, and Multithreading.

Processed the CI/CD Automation pipeline for the applications to deploy on the dev, stage, and production environments.

Performed code development and tested applications in development and staging platforms.

Operated on various tools such as VS code, Visual Studio, Microsoft SQL, Azure DevOps, Postman, and Data Analytics tools. Environment: Visual Studio 2019/2022, .NET 4.5/4.6.2/4.7.2 MVC, Postman, Fiddler, SQL Server2016, Entity Framework, HTML5, CSS3, JQuery, Bootstrap 4, Angular, PowerShell Scripts, SQL Server Management Studio, SSIS, Microsoft TFS version control, JIRA, Azure DevOps, CICD pipeline, Visual Studio Code, GitHub, Slack, Trello Cybage Software Pvt. Ltd – Hyderabad, India Jul. 2020-Nov.2022 Trainee Software Engineer

Responsibilities:

Underwent training on Full Stack Development. Lead a team of 6 members in the probationary period.

Developed three website projects and deployed similar applications with various technology.

Trained in various tools like Microsoft Office, TFS, GitHub, VS Code, Visual Studio, Fiddler, and Jira.

Helped peers within a project and interacted with respective trainers on various tools and technical concepts.

Completed the project “MovieNexGen” website worked with core developers and database queries are updated in the application. Here is the GitHub link - https://github.com/bhargav0804/MovieNexGen/blob/main/script.sql CERTIFICATIONS:

Scrum Alliance – Certified Scrum Master

Microsoft – Azure Data Fundamentals

Snowflake – Hands-on Essential Data Warehouse

Six Sigma – Lean Six Sigma Green Belt

Tableau – Create views and dashboards

PROJECT EXPERIENCE:

Providence Farm Collective – Orchard Park, New York Jan. 2023-Jun.2023 Salesforce Developer

Description:

PFC organizes events and recruits volunteers and donors. With the development of technology. They were involved in gathering all the data of the people and storing it in an Excel report with the transition of technology. They are switching to Salesforce to track all activities, including data collection.

Technologies: Salesforce, MS Office, and Analytical Skills. University at Buffalo – Buffalo, New York Aug. 2022-Dec. 2022 SQL Developer

Description:

Developed a centralized database system for a network of hospitals that uses SQL to manage a high-level database for analysis of forecasts, patient records, and older information that may be accessed more quickly, and business insights grow. Technologies: Microsoft SQL server management studio, Oracle live SQL, Tableau, Excel, SQL, Forecasting, and Lucid chart. PROJECT PUBLICATION:

An intuitive platform for implementing cloud brokerage architecture using an aggregate algorithm. Mar. 2020 Distributed computing comprehensively grasped appreciation to the high business facility it affirmations to its customers. Cloud administration arrangement in the commercial center is an essential undertaking for both cloud purchaser and cloud supplier for the most part if the cloud customer asks for explicit properties for its applications. In this way, this endeavor is assigned to a third part which is the cloud go-between. The proposed framework a cloud asset merchant is suggested that will oversee the task of supplier’s assets to shopper progressively. Further, the administration booking calculation is characterized by discovering an enhanced match between the accumulated prerequisites with the supplier’s contributions. Here is the publication link - https://www.ijrte.org/portfolio-item/F8838038620/ EDUCATION:

UNIVERSITY AT BUFFALO, THE STATE UNIVERSITY OF NEW YORK Master of Science, Management Information Systems (GPA: 3.89/4.00) Jun. 2023 Related Courses: Data Warehouse, Statistical Analysis, Database Mgmt., Technology Innovation Mgmt., IT Process Quality Management, Enterprise Models, Predictive Analysis, and Web Analytics for e-commerce. SRM INSTITUTE OF SCIENCE AND TECHNOLOGY, CHENNAI, INDIA Bachelor of Engineering in Computer Science (GPA: 3.5/4.0) Jun. 2020 Related Courses: Database Management Systems, Cloud Computing, Web Programming, IOT, OOPS, and Data Structures.



Contact this candidate