Sheetal Soni

214-***-****

acs0tq@r.postjobfree.com

PROFESSIONAL SUMMARY

7+ years of professional experience in all stages of the SDLC (Software Development Life Cycle) involving requirements gathering, analyzing, designing, implementation, testing, deployment, documentation and maintenance of various stand-alone, intranet, client-server and web-based projects with exposure to diverse business domains including Banking, Healthcare and Retailing.

Advanced experience in developing Web and Client/Server Applications based on Microsoft .NET Technologies and expertise in implementing N-Tier Architecture.

Expert in designing and developing web and windows based applications using MVC, ASP.NET, C#, ADO.NET, Entity Framework, Enterprise Library, LINQ, SOAP, Web Services, AJAX Control Tool Kit, IIS 7.0/6.0, JavaScript, JQuery, HTML, CSS, XML and XSLT and Visual Studio.

Experience with OOP/OOD (Object Oriented Programming and Design) like Inheritance, Polymorphism, Encapsulation and Design patterns like MVC, Object pool standard solution to common problems in software design Patterns in 3-Tier, N-Tier and Service-oriented architecture (SOA) applications.

Extensive knowledge of WCF(Windows communication Foundation), WPF(Windows Presentation Foundation) and LINQ (Language Integrated Queries).

Extensive front end and backend development experience working with .Net Framework 4.5/4.0/3.5/3.0/2.0, Visual Studio 2013/2012/2010/2008/2005.

Expertise in working with Graphical User Interface (GUI) web development using technologies like Master Pages, AJAX Controls, JQuery, CSS, Themes and Skins.

Good experience in Exception Handling, Debugging and tracing by which the whole picture of application runtime behavior can be seen and analyzed more efficiently.

Experience in designing and developing Databases in SQL Server 2012/2008/2005 which includes the development of Stored Procedures, User Defined Functions and Triggers using Transact SQL.

Good working experience with ADO.NET, Microsoft Application Blocks and Entity Framework as a part of accessing and updating the database.

Experience in using Language – Integrated Query (LINQ) to query and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

Involved in development of projects using SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS).

Experience on working with Windows Communication Foundation (WCF).

Experience of working with latest concept of C# like Generic Collection, Custom Attribute, Reflection and Partial Classes.

Designed and coded Web Services using ASP.NET and consumed web service from web client.

Experience with Data Accessing including using DataAdapter, DataReader and DataSet in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.

Experience in manipulating XML, Converting Data between ADO.NET and XML and Proven Knowledge in DTD, Schema, XSL (XSLT, XPath, and XQuery) and LINQ.

Experience in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles)

TECHNICAL SKILLS

Programming Languages

C, C++, Visual C#, Visual Basic

Web Technologies

.NET Framework 4.5/4.0/3.5/3.0/2.0, ASP.NET 4.5/4.0/3.5/3.0/2.0, MVC 3.0/4.0, WCF, Web Services, AJAX, CSS, JAVASCRIPT, JQUERY, HTML 5, HTML, JSON, ASP.NET Web API/LINQ

Front End

Visual Studio 2012/2010/2008/2005, VSEDIT

Back End

SQL SERVER 2012/2008/2005,Oracle, Entity Framework, ADO.NET

Protocols

SOAP, SSL, FTP, TCP/IP, HTTP

.NET Technologies

. Net Framework 4.5/4.0/3.5/3.0/2.0, ADO.NET, Web Services

Software Engineering

SDLC, UML, Agile Programming

XML

XML, XSL, XSLT, XSD, SOAP, WSDL

Application Server

Internet Information Services (IIS) 7.0/6.0/5.0

Operating Systems

Windows XP/2000/7/8/NT/Vista

RAD/IDE

Visual Studio 2005/2008/2010/2012/2013

Version Control

Visual SourceSafe, Team Foundation Server (TFS)

Modeling and Testing Tools

Microsoft Visio 2003, nUnit, NMOck

EDUCATION

Bachelor of Engineering, Electronics & Communication, Rajiv Gandhi Technical University, India.

PROFESSIONAL EXPERIENCE

Senior .Net Developer

Matson Navigation Inc., Phoenix, AZ Jan 2015 – Present

Matson’s transportation offerings span the globe from Shanghai to Savannah to delivering a wide range of multi-modal services throughout North America. It’s one of the nations' top logistics providers; Matson Logistics extends the reach of the company’s transportation network, offering customers domestic and international rail intermodal service. GATES project is to port all functionality associated to the “FACTS”, mainframe application to a web-based platform and to support a fixed number of high priority enhancements. Gates is a web application used for creating Bookings and Bill the shipments ordered by customers, creating Quotations and Templates, maintain commodities, link container to bookings. Rate Engine is a main module in this application responsible to rate and charge the customers.

Responsibilities:

Involved in the SDLC of requirement analysis, design and development of the web-based application in the fast paced agile methodology.

Designed and developed web pages using ASP.NET, C#.NET, JSON, HTML and JQuery, WPF.

Developed the application with n-tier architecture using Class libraries, Data entities, Services, Data access layer, business logic layer and stored procedures.

Worked on ASP.NET client side state management (view state, cookies and query strings) and server side state management (application state, session state and profile properties) using C#.

Worked on several ASP.NET server controls like Calendar, Grid View control, Repeater Control, Object Data Source Control and handled server side events to optimize performance.

Used Master Pages for branding purposes by displaying the logo and copy right information on every page and maintaining the same look and feel across the entire application.

Effectively handled ASP.NET client / server side state management features such as view state, hidden fields, cookies and query strings, application state and session state.

Extensively used Grid view and Details view to display information based on search criteria along with Sorting. Worked extensively on Grid view custom templates for providing additional flexibility. Implemented all data manipulations like Update, Insert and Delete on Grid view.

Developed search and advanced search components using Entity Framework to retrieve the search results from backend database (Asynchronous call) with AJAX features with partial page updates.

Used JavaScript to perform validations and catch the events on client’s browser.

Designed, modeled and architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted in IIS.

Extensively used HTML tables as Grid, for better performance instead of Data Grids along with Paging, Sorting and Filtering options. Data loading is been performed with JSON, Entity Framework.

Developed the business layer with LINQ to Objects and LINQ to SQL.

Created SQL scripts in SQL Server 2012, and implemented complex logic SQL queries and stored procedures.

Used Microsoft Application Data Blocks for executing the SQL stored procedures.

Performed Integration test, Unit test, Stress and Regression test with improved debugging standards.

Created the .NET builds and made sure the builds are migrated all the way up to the Production Environment.

Used SQL Tools such as Query Analyzer and SQL Profiler for query optimization.

Involved in taking backups, Restoring, Import / Export data using SQL Server Import and Export Wizard.

Used Team Foundation Server (TFS) for all the source code maintenance needs, tracking using work items.

Environment:.NET Framework 4.5, Visual Studio 2012, ASP.NET 4.5, C#, Application Blocks, TFS, WPF, AJAX, JQuery, JSON, XML, XSLT, JavaScript, SQL Server 2012, LINQ, T-SQL, TFS, IIS.

Senior .Net Developer

Saint-Gobain, Dolton, IL Sep 2013 – Dec 2014

Freight Management application is for tracking the daily supply of manufactured goods to the customer located all over India. By defining the contracts with the transport vendors, booking the trucks, validating the invoices received from vendors. This application is for having full control of outward freight sent from factory and reconciling the bills received from vendors. It pulls the information from Enterprise software (Oracle Apps, SAP) using Sql jobs. It validates the data and pushes back to enterprise software for bill booking and payment.

Responsibilities:

Involved in object oriented analysis and design using UML (Unified Modeling Language) techniques such as use case, activity, sequence, class and component diagrams using Microsoft Visio.

Developed the application in 3-Tier architecture, UI Layer, Business Logic Layer and Data Access Layer using C#, ASP.Net, and JavaScript with Sql Server 2012 as the back end.

Developed and consumed WCF services for getting Commercial insurance premium quotes, Auto Supplement Rate quotes, county codes etc.

Designed and developed reports using SQL Server Reporting Services for CIMS modules that are designed to take parameters for query, export into PDF/Excel/Txt formats.

Implemented Multi-Threading and Asynchronous WCF service calls to improve the performance of the application.

Worked with the Architect to drive out requirements of the project and design the application.

Agile methodology was used for faster and iterative software development.

Implementation of Test driven development (TDD) approach to ensure quality and minimal bug/defects inherited software solutions and involved in on-call support for issues in production.

Used LINQ to Objects, LINQ to SQL to manage, query, and order the list of contacts maintained by the application.

Developed tables, stored procedures, views, functions and triggers to perform automated rules, updating to related tables in SQL server 2012.

Implemented GUI using HTML5, TELERIK Controls, CSS and Web Form Controls to create web pages, developed Master Pages, user controls for reuse. Used Ajax Control Toolkit extensively for developing asynchronous and more dynamic parts in the application.

Performed Code Reviews (manual) to implement performance and coding conventions guidelines.

Created application level Error Log utility to log all the errors for effective solution for help desk. Used ELMAH through NuGET package manager for Visual Studio 2012.

Used Team Foundation Server for version control.

Performed extensive Unit testing using NUnit. Prepared test cases for functionality testing in each module.

Environment: Visual Studio 2012, .Net framework 4.0, C#, ASP.NET, ADO.NET, Sql Server 2012, AJAX Control Toolkit, XML, XSL/XSLT, WCF, JavaScript, TELERIK Controls, Web Forms, HTML, CSS, MS Visio, NUnit, SQL Server Reporting Services, Team Foundation Server (TFS)

.Net Developer

BMO Harris Bank, Brookfield, WI Jul 2012 – Aug 2013

The application was for Online Banking. The application provides client account information like account summaries, account details, monthly statements, balance transfers, accrued interest, check ordering, loan application, credit cards and financial services. More alerts and correspondences were created to enhance the online banking experience of the customers. Transactions were done using batches and web services. This was a conversion project from the legacy application to a more enhanced version.

Responsibilities:

Understanding and analyzing the client's requirement.

Involved in the development of new applications and enhancement of existing applications to provide additional functionality.

Developed web forms in ASP.Net using C#.Net, AJAX Controls, HTML and JavaScript.

Worked extensively with Windows Communication Foundation (WCF) for client server applications

Worked with WPF for integrated desktop applications

Developed several MVC applications with ASP.NET MVC, JavaScript, jQuery, JSON, HTML, XHTML, CSS, and REST Client.

Achieved database connectivity and data processing using ADO.NET.

Used jQuery for client side validations.

Used SQL Server Integration Services to upload data from Excel, Flat, Xml files into database.

Used SILVERLIGHT to provide media stream for customers to know more about the policies.

Worked on SQL server reporting services to generate reports.

Used Visual Source Safe control for sharing and editing of data.

Using Bootstrap, implemented a Responsive Web Design. After the initial page load, the application executed all data transactions with the server through MVC Web API via JSON, no additional full page loads were initiated.

Used SOAP and REST services for requesting information from endpoints.

Extensive logging and error handling was performed in C# using log4net.

Created tables and Stored Procedures in SQL Server 2010 and used LINQ for querying objects.

Used Team Foundation Server as Source Control.

Be available on-call rotation to assist in project development, operational and maintenance issues in all the environments.

Environment: .Net 3.5, ASP.Net, C#, LINQ, Entity Framework, WEBAPI, Boot Strap, AJAX, ADO.NET, SharePoint Server, MVC, WCF, WPF, Team Foundation Server, SOAP, RestFul, WSDL, XAML, ASMX, JavaScript, JQuery, Angular JS, SQL Server, SSRS, SSIS, SOA.

.Net Developer

Owens & Minor, Mechanicsville, VA Oct 2011 – Jun 2012

Project: Clinical Supply Solutions

Clinical Supply Solutions (CSS), formerly known as QSight, is a hospital inventory management tool, which designed for use by hospital departments. CSS enhances the ability of clinical staff to make inventory management easier by providing clear, real-time, windows into inventory management.

Responsibilities:

Involved in the whole Software Development Life Cycle of the application.

Designed user interface screens and implemented application logic in Microsoft .NET framework using ASP.NET, C# and JavaScript.

Developed ADO.Net based data access layer against SQL Server Database.

Extensive use of JavaScript for client-side validation.

Developed WCF Services to allow communication between Presentation layer and Service layer.

Implemented AJAX to minimize server round trips to improve overall performance and to provide an advanced user experience.

Extensively used ADO.NET classes to work with SQL Server database. Used Connection Command, Data Reader, Data Adapter, Data Set and Data Tables for disconnected mode of operation.

Used LINQ for building and executing a query expression.

Developed a Windows Communication Foundation (WCF) service and hosted it.

Developed web forms using Windows Presentation Foundation (WPF) and XAML.

Designed and deployed various complex reports such as Tabular, Cross-tab, Pie Chart reports, Sub Reports, Drill down reports, and Drop down reports using MS Reporting Services.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files using Business Intelligence Development Studio.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel,PDF, HTML etc.

Involved in designing and implementing application using .net framework to call the reports from presentation layer.

Identified and worked with Parameters for parameterized reports.

Used SharePoint Sever to manage, communicate documents for review and collaborate the work with team members.

Involved in Testing and Integration of Source/Version Control using Visual Source Safe

Environment: .Net 3.5, Visual Studio.Net 2010, ASP.NET, C#, Window Services, Web Services, Web Forms, Win Forms, Team Foundation Server, SQL Server 2008, SSRS, SSIS.

.Net Developer

ECRM Labs, India Jan 2010 – Sep 2011

Project: EMS (Enterprise Management System)

EMS is a Full-Featured web-based system designed application that deals with automation of organizational activities. The Most important module of this application is Human Resource Management Module, which interacts with all the other modules in creating/maintaining the Employee Profiles, Project Details, Department Details, and Consultant Details etc. Payroll management Module deals with creating salaries, salary formulae, Tax slab and so on. HR Master includes in maintaining the employee details .company details, project details and the department details, assigning projects to the employees.

Responsibilities:

Developed Web Forms Using ASP.NET & VB.Net.

Involved in the whole Software Development Life Cycle of the application.

Followed scrum methodology of agile development with a sprint for 30 days.

Gathered User Requirements and developed scenarios using UML that included identifying the use cases and its surroundings, drawing Use case diagrams, drawing class diagrams and sequence diagrams using Microsoft Visio.

Developed code in VB.NET for the development of the application for various modules.

Used Form Based Authentication for the Application as a .NET Security measure by providing a login page.

Used Java Script for validating client side data entry web screens.

Developed Reusable Classes using VB.Net.

Developed Data Layer using ADO.NET to communicate with MS SQL Server.

Improved the application performance using stored procedures and connection pooling and Memory management.

Modified the existing logic by separating the business logic and application logic.

Prewritten stored procedures were executed using the SQL Command objects.

Used Data Grid, Data List, Repeater controls to show detailed information.

Used Session Management and ASP.NET validate controls for validating the information provided by the user.

Used caching technique, which dramatically improved web application performance like throughput and scalability.

Created SQL scripts, stored procedures, triggers and views in MS SQL Server 2005.

Used ADO.NET classes provided by the .NET Framework for database connectivity.

Environment: .Net Framework 3.0, C#, SQL Server 2008, Visual Studio 2008, ASP.NET, ADO.NET, Crystal Enterprise.

.Net Developer

UTI Bank LTD, India Aug 2008 – Dec 2009

Project: Tax Collection

UTI Bank Ltd. is the one of the tax collection center for statewide and smart Tax Collection is a centralized and web based comprehensive software solution for effective functioning of the tax collection department. It assumes a greater significance because it is a difficult task to maintain the collections at branch levels individually. To reduce the overheads and to increase the efficiency, it is decided to centralize the database and monitor the operations from head office.

Responsibilities:

Involved in different phases of Software Development Life Cycle (SDLC) including Designing, Programming, Testing and Documentation.

Analyzed and designed approaches using UML use case diagrams, class diagrams, state diagrams, and activity diagrams.

Implemented the presentation layer using Master Pages, HTML, XML and JavaScript.

Used CSS for common appearance all over the website.

Used Java script for client side data validations.

Worked with Grid Controls, Sever controls to meet the client requirements.

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

Created Business Logic Layer and Presentation layer in ASP.NET.

Contributed significantly to design of the object model in the middle tier.

Created Common Data Access Layer using ADO.NET.

Used ADO.Net objects such as DataAdapter, DataReader and DataSet for consistent data access.

Involved in testing and fixing bugs.

Environment: Visual Studio 2005, ASP.NET 2.0, ADO.NET, HTML, JavaScript, MS SQL Server 2005, Windows XP.

Contact this candidate