Sign in

.Net Developer Sql Server

Lunawada, Gujarat, 389230, India
March 06, 2018

Contact this candidate

.Net Developer

Priyanka Mandavkar



Around 8 years of experience as .Net Developer in advanced Microsoft. Net technologies.

Solid experience in SDLC-Software Development Life Cycle implementation including Requirement Analysis, Designing/Architect, Coding, Unit Testing, Integration Testing, Project Maintenance, Performance Tuning, System Support and Technical Support.

Hands-on programming ASP.NET, C#.NET and ADO.NET

Proficient in working with applications based on MVC2/MVC3/MVC4, CSLA, 3-Tier and N-Tier Architecture.

Implemented SOA architecture with web services using SOAP, WSDL, UDDI, and XML.

Extensive experience in XML, XML Web Services, WCF in ASP .NET.

Solid knowledge in Object Oriented Analysis/Design and implemented Design Patterns across the applications.

Experience in LINQ, Working with various providers like LINQ to Objects, LINQ to SQL, and LINQ to XML.

Hands-on experience in UI Design using Web Forms.

Good knowledge in Client/Server Integration and Partial-page updates using AJAX Services.

Extensive experience with .NET Framework, ADO.Net.

Extensive database designing and programming skills using MS SQL Server, Oracle 10g and MS Access.

Hands on experience in SQL Server to create Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using T-SQL, Maintaining Database, Experience in Query Optimization.

Hands on experience in Oracle database to create Tables, Views, Query, Clauses, Operators, Joins, stored procedures, functions, Triggers and Cursors

Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML.

Experience in Creation of Web User Controls and Web Custom Controls.

Experience in using Team Foundation Server in Visual Studio and mapping the applications in TFS.

Experience in gathering requirements from users and from the management to decide on the technical architecture and infrastructure to be used and come up with a design process.


M.S. Computer Information Systems

M.E. Electronics & Telecommunication

B.E. Electronics & Telecommunication

Technical Skills


C#.Net, VB.Net PL/SQL, T-SQL

Web technologies


Distributed Tech

Web Services, WCF

Web/App servers


Database Servers

SQL Server, Oracle and MS Access

Operating System

Windows, MS-DOS

Scripting languages

JavaScript, VBScript, JScript, JQuery


Microsoft.Net Framework, NUnit

Other Software’s/Languages

Core JAVA, R language, Microsoft Azure (cloud computing), VMware Workstation, Weka, RStudio, MS Office suite, Visual Studio, LaTex, Simulation model, Pro/Engineer, ERP system, MULTISIM, MATLAB, Adobe Photoshop, Adobe premiere.

Professional Experience

ExxonMobil Corporation, Houston, TX Jul 2017 to Present

.Net Developer

I was engaged in designing of a software which will be built on the Engineer's Data Model platform and integrated with well-design and planning tools, enabling engineers to access historical data and streamline cost estimation and reporting workflows. Reports and plots are automatically generated, making it easy to analyse the results and present findings to key stakeholders.


Created the business requirement document for the project and created use case diagram as part of the systems analysis and design.

Requirement Gathering and involved in architectural high-level design.

Developed Core Application solution using Visual Studio 2017.

Developed the application using C# in .Net Core 2.0 using agile methodology in 3-tier architecture.

Worked on Cloud based Azure technology.

Worked on UI design functionality. Bootstrap, CSS selectors and HTML elements for the better display of the modules on front-end.

Implicated in action in Analysis, Design and Development phases of the web application.

Involved in the SCRUM meetings with other team members to examine the flow of the project.

Agile Methodology is being used for the development with daily scrums, coupled with Test-Driven Development (TDD).

Analysed and designed new features using C#.NET Core, Web API Core

Developed the portals using .Net Framework 4.6.

Developed Restful Services using WebAPI core.

Implemented Auto Mapper in order to map Db Entities to Domain Entities.

Worked on Entity Framework Core 2.0 with DB First Approach.

Developed Domain Entities in order to communicate with the Db Entities with Auto Mapper

Worked on Logging Mechanism Using Application Insight to log or trace the application.

Worked on Writing the Required Stored Procedure using SQL 2016.

Worked on LINQ Query's to query Db as well as C# objects.

Worked on writing Custom filters in webAPI core in order to handle Exception etc. by a common procedure.

Combined GIT with Jenkins for automation during the code check-out process. Used it in Release Process & Policy in SDLC.

Worked on Entity Framework database first model as part of making enhancements to existing project.

Environment: Visual Studio 2017, MVC4, ASP.NET, JavaScript, JQuery, jQuery UI, Web API2, WCF, Entity Framework6 (EF6), Webservices, CSS.

Cico Oil & Gas, Houston, Texas Sept 2016 to Jun 2017

.Net Developer

Cico Oil & Gas is an expert in pipe unloading, pipe handling and pipeline logistics for the oil and gas pipeline construction industry. It serves as full service transportation consultants, with proven expertise in handling rail logistics, barge freight, and locating and preparing pipe yards.

Spread Boss is the innovative pipeline tracking system that redefined the industry standard for recording organizing, storing and retrieving all data and documents associated with your pipe and components With Spread Boss - Customer Portal the data can be viewed 24/7, in real-time, from any location even as it is being collected.

Productivity- Time Tracking Application, tracks the time with the tasks.


Designed and Developed Spread Boss application using ASP.NET 4.0, c#, WCF, Generics, XML, MVC3.0, SQL Server 2012.

Implemented graphical user interface (GUI) for web forms.

Implemented data access and business logic to meet client requirements.

Created Business logic layer & Data access layers to implement the MVC architecture.

Implemented Routing, URI, Security, Action Filter techniques for application development.

Implemented Cascading Style Sheet (CSS) to improve look and feel of the ASP.NET web.

Managed and maintained development of PHP backend for dynamic database driven websites.

Created Stored Procedures to perform automated rules, updating to related tables using SQL Server 2012.

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

Implementation of client side validations using JQuery and ASP.NET MVC validation implemented at controller level.

Implemented Client side functionality using JQuery.

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

Involved in performance tuning of the application by creating various database Indexes and optimizing database queries.

Created re-usable utility libraries to generate reports in various formats from ADO.Net Dataset.

Developed the Windows Forms application using Windows Forms, C#.Net.

Created Restful services using ASP.NET Web API for exposing data

Implemented agile scrum methodology in application development.

Implemented Multithreading Concepts to improve the application performance.

Handled ASP.NET features such as Exception Handling and Custom Error messages.

Involved in retrieving data using Entity Framework with ASP.NET.

Handled Run Time Errors & Design Time Errors by implementing appropriate Errors handlers in C#.NET.

Involved in Requirements gathering, Conceptual Design, Analysis, and Detail design, Development and System Testing.

Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Responsible for deployment of the Application in production and resolving any post-deployment issues.

Provided estimates, daily & weekly status report to the client on progress of the tasks

Environment: Visual Studio 2015, .NET Framework 4.0, C#.Net, MVC 3.0, Web API, Entity Framework, LINQ, HTML5, BootstrapJS, CSS, JQuery, AngularJS (1.0), TCP/IP, XML, SQL - Server 2012, TFS, WCF, AJAX, JavaScript.

Phillips 66, Bartlesville, OK Oct 2014 to Aug 2016

.Net Developer

At Phillips 66, Transportation and Refinery domain applications are used to match up tickets for the pipeline systems in the lower 48, manage environmental compliance tasks, downstream employees and contractors to view the qualifications of welders and other downstream workers. The applications are also used for viewing and updating pipeline asset information and allows customers to view tariff prices. Internal applications are meant for admin to keep tariff information accurate, Electronic Pipeline Maintenance and Leak Report tracking, look up the gauge table based on a railcar initials and number, and allows the business units to review and possibly override the Rail Detention charges that will be billed to customers. It also allows who can get product at a truck rack terminal and how much, displays operational data used to make scheduling and operational decisions.


Fixing defects on Transportation and Refinery domain applications

Major and minor enhancements on Transportation and Refinery domain applications using MVC, OracleDB, IIS, Web Service, MS Visual Studio 2013, C# .NET

Created Unit tests using Nunit

Used WCF service for net TCP binding used by third party application

Single point of contact for any issue related to Transportation and Refinery domain applications

Conduct user acceptance testing to ensure the program can be used easily, quickly and accurately

Write detailed documentation for the operation of the program by users

Update, repair, modify and expand existing software and generic applications

Providing technical assistance to the team

Environment: C#, ASP.NET, .NET 3.5, VB.NET, WCF, Oracle, HTML, DHTML, XML, AJAX, JavaScript, Web Services, JQuery, VBScript, SSIS, SSRS

Yash Software solutions, India Jan 2010 to May 2014

.Net Developer

Yash IntraNET provides first-hand information with ease to the employees of the organization, automates the processes by reducing the slow and inflexible paper processes, and acts as a knowledge base. It provides employee information like Ecode, Name, e-mail, extension and project with searchable options. The official news, announcements, Bulletin, corporate holidays, Training information and Employee birthdays are hosted in IntraNET. The requisitions like Leave, pay slip, salary / service certificate have been automated. The status of the requisitions can be viewed in the dashboard. The pay slips generation, conference hall booking, System details updating, time sheet has been automated. IntraNET acts as a knowledgebase through discussion forums, IT developments happening throughout the world. The Entire IntraNET database consists of 184 tables.


Developed the application using ASP.NET, VB.NET with Oracle 8i as the backend

Used Microsoft FrontPage in creating html pages

Created object oriented design and framework by identifying classes and implemented object oriented programming using VB.NET

Designed web forms using ASP.NET and used VB.NET as code behind

Designed table structure for Oracle database

Coded Oracle stored procedures, functions for the improved performance

Experienced in Oracle Views, Query, Clauses, Operators, and Joins

Worked on Oracle database to Create Trigger and Cursor

Used ADO.NET for, Data Grid and Data list controls

Validation was done using validation control in ASP.NET

Involved in creating .NET Reports to present the data in different views

Participated in the whole life cycle of the project including design phase of the project, which was designed using ASP.NET, VB.NET and ADO.NET

Developed the front-end screens using Web forms

Environment: Visual Studio .NET 2008, ASP.NET, ADO.NET, VB.NET, .NET Reports, Oracle database, IIS, VSS, and Windows 2000.

References available on request

Contact this candidate