Sheetal Soni

804-***-****

ac8mj3@r.postjobfree.com

mailto:ac8mj3@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.

●Experience with Elasticsearch, Kibana and Logstash(ELK) stack and C# NEST Client.

●Expert in designing and developing web and windows based applications using MVC, ASP.NET, Web API, C#, ADO.NET, Entity Framework, Enterprise Library, LINQ, SOAP, .Net Web Services, REST web services, IIS 7.0/6.0, JavaScript, HTML, CSS, XML.

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

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

●Expertise in working with Graphical User Interface (GUI) web development using technologies like Master Pages, AJAX Controls, JQuery, Angular JS, Angular 2.0,3.0,4, 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 2016/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).

●User PowerShell framework to perform CMD tasks.

●Experience on version control systems like GitHub and SVN.

●Experience on Web API to create HTTP RESTFul services to communicate with UI objects using JSON.

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

●Experience in using TFS for project source control management.

●Extensive experience in working with code repository on GitHub.

●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)

EDUCATION

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

TECHNICAL SKILLS

Programming Languages

C, C++, C#

Web Technologies

.NET Framework 4.6/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, GitHub

Front End

Visual Studio 2017/2012/2010/2008/2005, VSEDIT

Back End

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

Protocols

SOAP, SSL, FTP, TCP/IP, HTTP

.NET Technologies

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

Software Engineering

SDLC, UML, Agile, Waterfall

XML

XML, SOAP, WSDL

Application Server

Internet Information Services (IIS) 7.0/6.0/5.0

Operating Systems

Windows XP/2000/7/8/10

RAD/IDE

Visual Studio 2008/2010/2012/2013/2017

Version Control

Visual SourceSafe, Team Foundation Server (TFS)

Modeling and Testing Tools

MS Test

PROFESSIONAL EXPERIENCE

IEHP, Rancho Cucamonga, CA April 2016 – Present

Role: Developer III

Description:

The project CORE was to move the legacy claims system DIAMOND and all its component into third party vendor application MediTrac which was a windows application. It included integration projects with legacy system, front end development for mashup applications inside windows app, stylesheets, different modules for providers and members, Web Provider and Member portal development, re-architecture of SOA, processing EDI files and assignment projects.

Responsibilities:

Worked on Software Development Life cycle (SDLC) in Agile environment starting from Requirements gathering and performing object oriented analysis, design and implementation and developing new Web API interface.

Designed database to integrate legacy de-normalized database and store data in normalized form for consistency and searchability.

Developed Integration application using C# and later moved to Rabbit MQ for continuous integration using bus system.

Developed Web application for external Doctor search using SQL Server 2016 for back end, Web API to expose data to client, Enterprise Library to fetch data and LINQ to shape data, and TPL for parallel processing.

Developed search Website using HTML5, CSS, Angular 4, JavaScript.

Developed MVC application for changing currently assigned doctors to a member using Entity Framework

Used Dependency injection pattern to be able to expose data to different clients (internal, external) based on different business rules and security concerns.

Wrote complex stored procedures and functions to get data from legacy system and shape it for new database and views for business to be able to generate reports.

Used UDT to pass collection of data from data layer to database.

Used appropriate data structures to store/process data and wrote time and memory efficient programs.

Designed and developed bi-directional integration process to integrate data with third party claims system.

Created Windows Service and Web APIs to develop CTI POP system in integration with CISCO Finesse agent for customer service team.

Developed a program with dashboard that auto assign doctor to Members using C#, Web API, HTML, CSS and Angular 4.0.

Developed program to process monthly EDI files and load them in claims system with validation and business rules.

Set up NuGet Server for organization to be able to share DLL across the team and follow the same implementation for common behavior.

Set up Elasticsearch cluster and developed search APIs using NEST client for faster search in all applications.

Provided production support for various applications.

Followed test driven development and wrote unit tests for all the applications.

Developed application to report database inconsistency using MVC, SQL SERVER 2016, system tables and complex stored procedures.

Worked on a Windows application to update existing functionality and add new functionality.

Used third party Web APIs to update claims related data with company’s database.

Worked on XSLT stylesheets to display data on windows applications.

Worked in Agile environment using TFS and created Epics, features, stories and tasks.

Maintain project documentation on TFS and keep it up to date with work progress.

Environment: C# .NET, ASP.NET, MVC, MS Visual Studio 2013,2017, .NET Framework 4.0+, ASP.NET, UML, XML, XSLT, VSS, JavaScript, Angular 2,3.0,4.0, MVC Pattern, CSS, AJAX, SQL Server 2012, 2016, SSRS, IIS, T-SQL, Web services, SharePoint 2007, Microsoft Office, WPF.

Tenet, Dallas, TX Dec 2014 – March 2016

Role: Senior .Net Developer

Description:

At Tenet, we developed programs for managing outpatient centers, hospitals, providers and other provider’s locations data that included validation of specialties for their taxonomy codes and worked on different programs offered by/for other health system partners including management of large amount of Encounter data.

Responsibilities:

Designed MVC design pattern for ASP.NET application development using the ASP.NET MVC framework.

Designed and developed the triggers for Audit log history for content and ISA.

Created stored procedures, functions in the SQL Server 2008.

Involved in designing and coding of Presentation Layer, Business Logic Layer and Data Access Layer.

Implemented N-Tier architecture using C#, ADO.NET, WCF and LINQ.

Worked on ASP .NET State Management using Sessions and ASP .NET Caching features using Output Cache.

Involved in Design and Architecture of the ASP.Net application, WCF and WPF based Web Services.

Creating WPF Master Detail UI using Window Object Data source.

Worked on generic classes using C# to create Support Functions and Database Operations.

Created Caching Mechanism routines for minimizing Server Response time.

Designed a User Interface using Web Forms, XML, XSLT, JavaScript,Angular 2.0,3.0 Rails, AJAX, CSS, ASP .NET, Server Controls and Visual Studio .NET

Extensively used Multi-Threading for fetching data from web services using C#.

Used Team Foundation Server 2008 for Source Code Control, project related document sharing and team collaboration.

Prepared automation scripts in VB Script following scripting guidelines by creating the Global object repository and preparing Generic functions.

Involved in the development of business logic in ASP.NET.

Rendered XML document to an HTML using XSL and XSLT Transformations.

Involved in Documentation, Unit and Integration Testing and Debugging

Designed User Interfaces, Web pages, Web forms using Server controls, HTML and JavaScript (JQuery) and CSS to enhance UI experience on Client-side.

Creating applications using VB.NET and enhancing projects for .NET applications.

Created packages using ADO.NETSSIS for extracting data from MS Excel files, OLEDB, MS Access to SQL Server database.

Creating advanced Excel and Word reporting tools (100+ complex reports) for existing SQL Server 2005 databases using VB.NET Interop front end programming.

Created ASP. NET web pages that provide new features and enhanced user experience.

Worked with SSRS reporting services for generating few reports.

Environment: C# .NET, ASP.NET, MVC, WCF. ASP 3.5, MS Visual Studio 2008, .NET Framework 3.0, VB.Net, VB Script, ASP.NET, UML, XML, XSLT, XSL-FO, VSS, JavaScript, MVC Pattern, CSS, AJAX, SQL Server 2005,SSRS, IIS, JSP, Windows PL/SQL, N-Hibernate, Visual Studio, Web services, SharePoint 2007and Microsoft Office, WCF,WPF.

Senior .Net Developer

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

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.

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

●Enhanced old Web Sites build in ASP.NET, C# by adding, removing or modifying Business, Data and Presentation Layers. Worked on SSRS for dynamic Reporting and SSIS for data Integration and Transformations, ASP.Net, SQL Server 2008.

●Developed various SQL queries and PL/SQL Procedures in Oracle db for the Application

●Created Stored procedures using PL-SQL for data modification (Using DML insert, update, delete) in Oracle

●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.

●Used Cucumber to implement BDD.

●Designed the application using HTML Helper and Razor Views in MVC 4.0 architecture that promotes a clear separation between the different layers.

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

●Designed and Developed a Windows Service which uses MSMQ for asynchronous message processing

●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.

●Used SSIS to load data from source files to target tables.

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

.Net Developer

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

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

●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.

●Used GitHub to manage and modify existing code.

●Development of MSMQ WMI Provider (C++ DLL) for MSMQ monitoring. Deployment using CA Unicenter and Serious Samurize.

●Performed SQL operations using Oracle Database. Implemented Custom Validator.

●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, WCF, WPF, Team Foundation Server, MSMQ,GitHub, SOAP, RestFul, WSDL, XAML, ASMX, JavaScript, JQuery, Angular JS, SQL Server, SSRS, SSIS, SOA.

.Net Developer

ECRM Labs, India June 2011 – Sep 2012

Project: EMS (Enterprise Management System)

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.

Contact this candidate