Post Job Free

Resume

Sign in

.Net Developer Sql Server

Location:
Charlotte, NC
Posted:
February 26, 2024

Contact this candidate

Resume:

Megha A Kore

+1-980-***-****

ad3xbj@r.postjobfree.com

A professional Lead.Net Developer building software applications using languages and technologies of the. NET framework. I have been responsible for designing, coding, testing, and deploying applications, as well as providing technical support and maintaining software throughout its lifecycle in agile methodology. Professional Summary:

Over 12+ years of experience, as a Lead .Net Developer, in Functional specifications, Analysis, Design, Development, Troubleshooting, Configuration, Management and implementation of Enterprise level applications in Microsoft technologies like C#, ASP.NET MVC, ASP.Net Web API, .Net Core, Angular, Entity Framework, Design Pattern, Microsoft SQL Server, IIS, TFS, AZURE PAAS, Azure Web Jobs and front-end technologies like HTML5, CSS3, JavaScript, jQuery in IT projects.

Programming languages: C# (10+years), ASP.NET platform (10+years), MVC (6 years), CSS (7 years), JavaScript (5 years), SQL Server (8+years) and HTML (8+years) - using Visual Studio and SSMS and Team Foundation Server.

Demonstrated proficiency in development using Microsoft.NET technologies like ASP.Net, C#, ADO.Net, Web Services, Web API, MVC, AJAX, OOPS, XML, XSLT, HTML, SOAP, VSS, JavaScript, SQL Server.

Extensive Experience in designing web pages using HTML, JavaScript, HTML, CSS and jQuery, AJAX, Bootstrap and JSON.

Strong experience in programming with .Net Framework using C#, ASP.Net, Visual Studio 2008/2012/2013/2015.

Proficient in implementation of N-Tier Architecture Data Access Layer, Business Logic Layer, User Interface

Strong understanding of Microsoft Technologies in the fields of Web-forms, Web Services, Web API using ASP.Net, C#, MVC, AJAX, SAML 2 Authentication Services, Object Oriented Programming, Design Pattern, Web API, Azure PASS, using Microsoft .Net Framework MVC, Angular, Dot Net Core, Entity Framework, Design Patterns.

Experience in design pattern like Singleton, Dependency Injection, MVC architecture framework.

Experience in creating Views, Partial Views.ASP.NET MVC,.

Strong experience on MS SQL Server use of Tables, SQL queries, Store Procedures, Views using SQL and SSIS. Have experience using Azure SQL Services.

Experience on Static Code Analysis on SonarQube Tool. Developing reports of Static Code Analysis through Sonar Database.

Experience in Object Relational Mapping (ORM) using ADO.NET, Entity Framework. Involved in creating data layer functions using ADO.NET Entity Framework to connect to database and fetch data. Used NHibernate as the ORM tool for data access.

Thorough understanding of SOAP and REST API.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using JS and getting the Data back as JSON and parsing it onto the UI.

Working experience in Database Design and writing store procedure, functions, triggers, views, joins, performing query optimization and Performance tuning in SQL Server 2008/2010/2012/2014 databases

Excellent skill in implementing tables, views, stored procedures, functions, schemas, and Triggers using SQL Server.

Good Experience in deploying Web applications (Web Apps), Web Jobs with cloud services by creating simple cloud service with visual studio, testing it, locally, deploying to live Microsoft Azure cloud environment

Expertise on working with integration of Azure AD, Authentication service like LDAP into the application.

Integrated number of web app identity into Portal for Global access using SAML.

Involved in development of projects using SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS)

Good experience with Agile (SCRUM) methodology and Waterfall.

Exposure in Requirement Analysis, Architecture &Design Documentation, Reviews, System Development, System Testing, System Implementation, User Documentation.

Good Experience in requirement gathering and documenting it into Software Requirement Specification Document(BRD-Business Requirement Document),Functional Specification Document (FSD), Test Documents, User Manual document.

Experience in configuration and version management using Team Foundation Server (TFS), GIT and defect tracking tools like Kanban, Visual Studio Team Services, and Database projects.

Performed Unit Testing,Functional Testing and Performance Testing.

Hands on experience in end-to-end development in MVC architecture using MVC, Dot Net Core, Azure, Azure Web App Services, TFS, Git Hub and deployment.

Experience of TFS Code features like Code Review, Code check in, TFS revision control and Compare history. Involved in Code Review Process and testing application. Involved in Refactoring.

Experience of TFS and GIT branching, Version control, staging and production environment. Deployment using CI/CD for Staging and production environment.

Experience using Project management tools like JIRA, SharePoint, Kanban

Worked in Tata Technologies with various clients like Tata Motors, Cummins, Tata Innovista, HR Onboarding,Internal IT Project for SAP-HANA Integration.

Provided exceptional client services to assigned clients and other stakeholders and act as the first line day-to- day contact for several defined clients.

Assisted the engagement manager in the organization of the client work and delivery of exceptional client service along with developing possible business opportunities.

Successfully created POC for .Net Web Application for Integrating with Salesforce system. Consuming CDOS web services using XML/SOAP, using azure web services and integration in the application. Created Dot Net core app for simple integration with Web API.

Integration Expert: Extensive experience integrating Web application with Azure,SAP HANA Systems, CDOS Systems, other web application integration using Web API, SAML.

Work with different system owners for application integrations and data exchange between systems.

Experience in consuming web services provided by other systems for application integration SAP HANA, CDOS web services.

Good Experience in creating Console application for business specific requirement for creating services.

Good experience in creating Azure Web jobs, Scheduling and deploying web jobs.

Strong database design and programming experience. Strong skills in writing Stored Procedures, Triggers, User Defined functions using SQL Server 2014/2008/2005, Azure Database.

Proficient in developing various web services like ASP.Net Web API using REST architecture.

Excellent debugging skills. Able to debug complex technical issues including multiple system components.

Excellent experience in creating consuming Web services SOAP, Azure WEB API, Integration with CDOS, Salesforce, API management using Web API’s, XML, Soap, JSON.

Experienced in working with globally dispersed team, and actively involved in cross group collaboration, also have experience in delivery high quality software on time.

Expert in developing web app, proactively work to reduce support costs and improve productivity (continuous improvement)

Collaborative with excellent written and verbal communication skills.

Currently working in Kollasoft from January 2024. Technical Skills:

Languages: C#, XML, SQL

Operating Systems: Windows (10/8.1), Windows 7, Windows Server 2003/2008(64 bit)

Microsoft technologies: .Net Framework 4.5 / 4.0 / 3.5 / 2.0 / 1.1 / 1.0, ADO.Net, ASP.Net 4.0 / 3.5 / 2.0 / 1.1, MVC 5/4/3, AJAX, Web Services.,.Net core 3.1

Frameworks: .Net Frameworks, Angular,MVC Architecture Web Technologies: HTML, HTML5, XHTML, XML, XAML, XSL, XSLT, JSON, CSS 2.0/CSS 3, Azure, Ajax, Web Services,

Boot Strap, Azure PASS, Azure IAAS.

Databases: SQL Server 2012/ 2014/ 2016 Azure SQL Database Services.

IDE: Microsoft Visual Studio &; SQL Server Management Studio 2014, 2012.

Development Tools: Visual Studio 2015 /2013 /2010

Scripting Language JavaScript, AJAX,JQuery

Version controls: TFS,Visual Source Safe, GIT (CI CD Pipeline Deployments)

Web Server IIS 6.0/7.0

Cloud Azure Web App Services, Database Services, Azure Web Jobs

Protocols: TCP/IP, HTTP, FTP, and SOAP.

Reporting Tools: SQL Server Reporting Services

Other Tools: MS Visio, MS Office, NUnit

Database Tools: MSSQL Server Management Studio

Qualification:

Bachelor’s in Information Technology from Walchand Institute Of Technology, India (2010) PROFESSIONAL EXPERIENCE:

Tata Technologies.

Project 1 : Tata Innovista

Client : Tata Sons

Duration : Jan 2020 – Feb 2022

Role : Lead .Net Developer

Description : This is web Tata InnoVista is a unique 'One Tata' platform for recognizing and celebrating innovations of the companies at the group level. Participating in the group-wide initiative encourages and motivates the teams and promotes a culture of collaborative innovation, learning and sharing. This is web application where user participate in different category of awards and Jury member evaluate these entries. And final winners are declared. Responsibilities:

Responsible for requirement gathering, discussions, POCs for the project.

Responsible for deliverable documents like, BRD, FDD, Test Documents, User Manual.

Responsible for Scheduling delivery plan and creating timelines and communicating weekly updates.

Developing components using ASP Dot Net MVC, C#

Interact with product owner and developer in requirements analysis, design reviews, testing and documentation for application being developed in Agile environment

Developed Web based application using Microsoft .NET technologies (C#, ASP.Net, MVC, Web API)

Developed UI interfaces with MVC Razor Views (CSHTML), CSS JavaScript, jQuery.

Used ADO.Net extensively for database interactions using Data Reader, Data Adapter, Data view and Datasets.

Created and used User Controls in developing the front-end application and web applications using .Net.

Utilized various JavaScript and jQuery libraries, AJAX for form validation and other interactive features.

Developed Web forms using ASP.Net server controls and validated input using Java Script.

Created and maintained database objects like complex Stored Procedures, Tables, Views, and User Defined Functions in SQL Server 2012.

Worked on SOAP and RESTFUL Services using WEB API, which return JSON data.

Implemented Authentication and Authorization security mechanisms.

Develop and maintain system for organizing and tracking execution of test plans in Kanban.

Responsible for fine-tuning the stored procedures and SQL Queries that have been found expensive in the load testing conducted for the releases.

Responsible for maintaining versions of source code using GIT.

Responsible for deployment of web application on development and production environment.

Developed Server side and Client-side code using ASP.NET, C#, JavaScript, jQuery. Environment: C#. ASP.Net4.5, MVC 4, Web API, RESTful APIs, Visual Studio 2015, SQL Server2014 Microsoft Azure

Project : Cummins Care(Customer Application for Response and Engagement) Client : Cummins

Duration : Jan 2019 – Dec2019

Role : Lead .Net Developer

Description : This Is Web Based application for response and engagement. This app is for India end customers who own Cummins Products. Its main purpose is to provide services to customers through features like Add Product, Create Service Request, get History, Feedback, Contact Us. This app is value addition in getting better Customer Service Satisfaction. This involves integration with CDOS, API Management. It is implemented using Azure WebAPI and JSON response for each integration scenario.

Responsibilities:

Involved in the requirement analysis, design, and development of the web application tool using Asp.Net MVC, Web API, SOAPand C#.

Successfully did integration with CDOS system and Salesforce for user database purpose.

Development of functions, logics for Azure Web API services.

Extensive use of Azure web API, Azure web app services, Azure SQL Database.

Responsible for developing and hosting app on Azure.

Used Azure SQL Database service and integrated it in app.

Worked on exporting reports to Excel, Address Master Excel Upload.

Developing components of Admin portal for services request.

Created DAL (Data Access Layers) to establish database connectivity and data manipulation.

Designed Administrator pages to handle overall application.

Experience in deployment using IIS Application Servers.

Involved in creating, building, deploying and executing the application in the development and production environments

Involved in designing Database Architecture.

Implemented Optimized Stored Procedures.

Wrote the Database store procedures, Views using SQL Server.

Azure SQL was used for Data Storage

Maintained the Version, Labelled Versions and Backups of the source using Team Foundation server

(TFS).

Environment: ASP.Net 4.5, MVC 4, C#, Angular, SQL Server 2014, Microsoft Azure, Windows 7, .Net Framework 4.5, Team Foundation Server 2010, Visual Studio 2015, XML, AJAX, HTML5, CSS, JavaScript, Web API, SOAP, Restful, TFS, Microsoft Azure web app services, Azure SQL Database services Project : Onboarding

Client : Internal IT

Duration : Mar2016 – Dec 2018

Role : Lead .Net Developer

Description : This Is Web Based application for candidate joining the organization and also for stakeholders. New employees are asked to fill out eForms which, they also understand about why the organization they are/ have joined is so special.all the activities to be performed and performed by the Preboarding/ Onboarding stake holders will be monitored and handled through their specific dashboard’s. Responsibilities:

Involved in Dot Net and SAP Hana integration requirement gathering and integrating all the web services consumed and data accessed.

Created POC for Dot Net and SAP Hana Integration successfully which involved SAP Hana Client installation

Understanding Hana Queries and converting it into SQL queries.

Developed SQL queries and consumed web services into the application.

Involved as senior developer and implemented Dot Net and SAP HANA integration in critical time line in order to deploy the application with all the other internal IT applications delivery.

Responsible for developing and hosting app.

Used SAP HANA client, server for SQL queries.

This project was developed under stringent timeline conducting POC parallelly developing the application queries and with parallel discussion with SAP team.

Implementation of 3-Tier architecture.

Developing Web application using ASP.Net, MVC5, and C #, JSON, HTML5 and CSS3.

Developed complex queries using tables and loops using SQL.

Developed SQL Queries, Stored Procedures and Triggers using T-SQL in SQL Server.

Documentation of design options and solutions according to Software Development Life Cycle (SDLC) methodology.

Developed core functionality with the ASP.NET MVC Framework (C#.NET, ADO.NET)

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Develop sequence diagrams and user flows for the application using MS-Visio.

Development of UI using ASP.Net framework.

Deployed the application on the IIS Server.

Used jQuery and JavaScript for client-side validation and other purposes.

Branching and Branch management TFS

Perform Unit & Integration testing.

Provide technical support to business and testing team during testing phases

Written and modified the technical documents, deployment documents. Environment: IIS 7.5/8, ASP .Net 4.5 C#, C#, MS-SQL Server 2012/2014, Windows 7,.Net Framework 4.5, Team Foundation Server 2010, Visual Studio 2015, XML, AJAX, HTML5, CSS, JavaScript, VSS, TFS Project : EMS Measurement(Enterprise Measurement System) Client : Tata Motors

Duration : July 2014 – Feb 2016

Role : Senior .Net Developer

Description : This Is Web Based application providing measurement services to for instruments and gauges. This is used to do the measurements of instruments and gauges and readings are noted. This is used to measure the accuracy of instruments.

Responsibilities:

Developed ASP.NET 3-tier Web based applications using Visual Studio 2012.

Designed and developed the UI interface using ASP.Net, AJAX, User Controls, and Web Forms using C# as code behind.

Designed database, created tables and store procedure.

Involved in Process identification and analysing workflow.

Responsible for design, development of forms and reports and its implementation.

Developed application logic and implemented same in C# using SQL as database.

Developed job email to be triggered on weekend for intimation of calibration work.

Worked on exporting reports to Excel.

Deployment of application on test and production server.

Good working knowledge of SQL Server 2014.

Written and used Stored Procedures, Tables and Views, Triggers, Functions using SQL server 2012.

Experienced in using TFSfor version controlling, tracking the work items etc.

Designed and developed project workflows using Microsoft Visio design tool for technical documentation.

Involved in analysis, design, implementation, code review, testing and deployment of the application.

Written and improved application technical documentation and provided knowledge transfer to team members.

Troubleshoot and resolve issues surrounding performance, response times, capacity and system limitations.

Maintenance and Defect Tracking Using TFS.

Environment: ASP .Net 4.0 C#, SharePoint 2013, Office 365, SQL Server 2014, Visual Studio 2012, Team Foundation Server 2013.

Project : EMS Calibration(Enterprise Metrology System) Client : Tata Motors

Duration : June 2013 – June2014

Role : Senior .Net Developer

Description : This Is Web Based application providing calibration services to for instruments and gauges.Goal of calibration service is to minimize measurement uncertainty by ensuring the accuracy of test equipment.Calibration improves the accuracy of the measuring device. Accurate measuring devices improve product quality. Responsibilities:

Designed and developed web forms as per the customer requirement.

Senior software developer and involved in discussion with client in requirement gathering and created blueprint document.

Responsible for Process identification and analysing workflow.

Responsible for design, development of forms and reports and its implementation.

Used 3 –tier architecture for Presentation Layer, Business Layer, Data Layer and implementation using ASP.NET C#.

Developed and consumed web service for SMS and also used scheduler for SMS.

Created console application for SMS services for the application.

Used ADO.Net to interact with database.

Created user manual for users.

Deployment of application on test and production server.

Provided production support and enhancement

Involved in developing applications in C# 4.0 and .Net Framework4.0 to meet the business requirements using Visual Studio.NET 2012.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.

Extensively used CSS for page layout and display of graphics.

Created queries and Store Procedures for quick and efficient retrieval of data using SQL Server 2014.

Used Team Foundation Server (TFS) to maintain the version control history during development.

Assisted in quality assurance measures such as code reviews, test case creation and unit testing for different modules.

Worked with a team to define requirements and provide technical advice and troubleshooting. Update technical documentation.

Created various documentation like BDD, FDD, Test Documents, User Manuals.

Involved in troubleshooting user and desktop specific bugs in various departments.

Also Provided system training to users and involved in client interaction for improving the performance.

Used SharePoint for storing the documents in the web application. Environment: ASP .Net 4.0 C#, SharePoint 2013, Office 365, SQL Server 2014, Visual Studio 2012, Team Foundation Server 2013.

Project : eNPI (New Project Initiative)

Client : Tata Motors

Duration : July 2010 – May 2013

Role : Dot Net Developer

Description : eNPI portal is the solution for effective project planning and monitoring across all platforms to support on time delivery of the vehicle programs and ensued business results. Includes Project Office a dashboard which covers data across all plants and process. ETS (Events Tracking System) is end user module for recording day to day activity and trashing of project progress against timeline. Responsibilities:

Involved in client interaction, designed the SRS documents.

Designed and developed web forms as per the customer requirement.

Responsible for Process identification and analysing workflow.

Responsible for design, development of forms and reports and its implementation.

Used 3 –tier architecture for Presentation Layer, Business Layer, Data Layer and implementation using ASP.NET C#.

• Creation of design document, SRS, user manual.

• Modification of existing application to make it user friendly.

• Bug Fixing, Data Requirement & Clarification.

• Custom web part development and deployment. User management and managing permission for site.

• Used ADO.Net objects like Data adapter, data reader, data set, data for reading/updating record in database.

• Testing of module of the project and creating test reports.

• Deployment of application on test server.

Provided production support and enhancement in the application.

Involved in developing applications in C# 4.0 and .Net Framework 3.5 to meet the business requirements using Visual Studio.NET 2010.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.

Created store procedure, functions, SQL queries using SQL Server 2005.

Created reports using SSRS reporting services and Testing.

Used Team Foundation Server (TFS) to maintain the version control history during development.

Assisted in quality assurance measures such as code reviews, test case creation and unit testing for different modules.

Worked with a team to define requirements and provide technical advice and troubleshooting. Update technical documentation.

Created various documentation like BDD,FDD, Test Documents, User Manuals.

Involved in troubleshooting issues and SQL queries.

Used SharePoint for storing the documents in the web application. Environment: C#, .NET 3.5, MOSS 2007, SQL Server 2005, SSRS. Personal vitae

Gender Female

Address 7704 Arboretum Drive, STE 201

Charlotte NC 28270, USA

Date Of Birth 04/12/1988

Location Charlotte, NC, USA

- Megha Kore



Contact this candidate