USHA JOSHI 850-***-****

Professional Summary:

** ***** ** ********** ** a .Net Development professional in various applications using Object Oriented Programming (OOP), Client/Server, N-tier architecture, Web based and Internet Technologies.

Experience in Software Development Life Cycle (SDLC) i.e. Analysis, Design, Development, Implementation, Testing and User Training of Enterprise Web-Applications, Stand alone and Distributed applications.

Experience in developing Web based applications and Client/Server applications using C#, MVC, ASP.NET (4.0/3.5/3.0/2.0/1.1), Classic ASP, ADO.Net, XML, HTML, XHTML, JavaScript and CSS.

Experience with Web Services (SOAP and REST), Windows Presentation Foundation (WPF), XAML, Windows communication Foundation (WCF), Windows Workflow Foundation (WWF) and Silverlight.

Experience in design and development of user interface (GUI) using XML, XSL, XSLT, AJAX, HTML, DHTML, VB Script, JavaScript and CSS.

Experience in Database design, Modeling and Database maintenance in SQL Server environment.

Experience on Node-Red

Experience on Grid View, Details View, Repeater and other ASP.NET Server controls for state management in .NET.

Experience on XML, Web Services, Windows Services, Web and Windows Custom Controls, User Controls, Data based controls like Data grids, Data lists, Repeaters, Class Libraries and LINQ.

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

Experience using the Data Access Components i.e. ADO. Net, ADO, DAO, ODBC and the SQL Server, Oracle coupled with good understanding of RDBMS concepts.

Experience with MVC, Command, Controller, MVVM design patterns and various design methodologies like Rational Unified Process, Waterfall and Agile Software Development with Extreme Programming, Scrum, Paired Programming, TDD and Continuous Integration.

Experience in writing stored procedures, T-SQL Queries, functions, triggers, views and schemas.

Used Node.js to interact with MongoDB and MySQL

Experience in MS Share Point Portal Server and BizTalk Server environment developing Web Parts.

Experience in developing Web Services, .NET Remoting and Data Transformations.

Experience in working with Visual Source Safe (VSS), Visual Team System (VTS), and sub version configuration (SVN).

Experienced in designing reports for Web Applications using Crystal Reports and SSRS and also worked on SQL Server Integrating System (SSIS) using SQL Server 2008/2005.

Experience in SQL Server Database design, Database Maintenance, developing T-SQL queries, stored procedures and SQL Server, DTS, SSIS, SSRS.

Experience working with RDBMS includes MS SQL Server 2008/2005/2000, Oracle 9i, 10g, 11g and MS-Access.

Experienced with Agile SCRUM methodology used for new product development.

Good working experience with office software’s such as MS Project, Visio, Rational Rose, MS Office.

Education:

Master of Computer Science (MSc), University of Mumbai

Bachelor of Science (Computer Science), University of Mumbai

Technical Skills Overview:

.NET Technologies

.NET Framework 1.1, 2.0, 3.5, 4.0, 4.5, WCF, WPF, ASP.NET, ADO.Net, C#, Window forms, AJAX, Web Services, Silverlight, SOAP, ADO.NET, XML, LINQ, SOA, .Net Remoting, VB.NET, IIS.

Languages

C#, VB.NET, VB 6.0, C++, PL/SQL, TSQL, ASP.

Web Technology

ASP.Net, AJAX, AJAX toolkit, ASP, HTML, DHTML, CSS, JavaScript, NodeJS, Web Service, Web API, XML, XSL, XSLT

Databases

MS-Access, Oracle 9i/10g, SQL Server 2000/2005

IDEs and Tools

Visual Studio .NET 2012/2010/2008/2005, Eclipse, EditPlus, MS Office, SQL Management Studio 2008/2005, SQL Developer, SSIS, SSRS, SharePoint.

Other Concepts & Technologies

XML Web Service, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), MVC, Unit Testing

Operating Systems

Windows XP/7, Unix

Professional Experience:

Client: State Of Tennessee through Maximus and Mastech Digital INC

Role: .Net and Sql Developer and Production Support(Level 3) October 2020 – 10/03/2023

Project: PDMS(Provider Data Management System)

Technologies:- Front End :- Asp.net, Html, Javascript, JQuery, AJAX

Business Layer:- C#, ADO.Net, Linq, Web Service(Rest)

Backend:- Sql Server

Investigate and fix the production highest critical and normal bugs.

Manually fixed the bugs

Handled Escalated debugging from the development team quickly within couple of days.

Review the bug related script code of other developers, provide feedback to them if the script modification is required and pass those bugs accordingly.

Deploy the highest critical and normal resolved bugs to the higher environment ie:- UAT and Prod.

Conduct the meeting with BA and other developers to resolve the critical production issues

Debug the application in detail to create the script related to the critical production issues.

Database Refresh of the lower environments ie:- UAT from PROD.

Debugged the application that are in production and going in to production.

Re-wrote the application in ASP .NET Core MVC as per the design documents.

Designed and developed Entity Framework 2.0 Code- First approach with Repository-Pattern based backend and used RESTFUL and Web API as transaction and communication technology to the client-side.

Developed ASP.NET Core Web API based on departmental requirements and specifications.

Worked on advanced concepts of ASP.NET Core MVC such as Models and Providers, Filters used for developing backend technology.

Implemented authorization and JWT Token based authentication to secure the ASP.NET Core Web API and provide authorization to different users.

Implemented convention-based CRUD actions like GET, POST, PUT and DELETE.

Designed and created models components, component modules and services to apply client side logic and dependency injection using Angular 2.

Implemented Client-side validation using Angular-2 Custom Form Validation with ng-show and ng-hide.

Client: Curant Health

Role: .Net Developer June 2019-October 2020

Project: InContact Website Portal, Reports, MedPlan, McKesson

Technologies:- Business Layer:- C#, ADO.Net, Linq

Backend:- Sql Server, SSRS Reports

Consumed InContact API to capture call details of the Pharmacists like the call logs and stored it in Azure Blob.

Performed ETL for the InContact extraction via the client API .net code, transformation using the C# .net code and loading to Azure blob Storage via the .net code.

Prepared and Scheduled SSIS Package for this ETL in SQL Server Job Agent.

For monitoring purposes created the SSRS reports for the Pharmacists and their managers.

Created unit test project for MedPlan and wrote various test cases to test various business scenarios.

For analysis purposes, used C# .net RegEx class to write the regular expressions to parse the McKesson files that arrived as a feed on WinSCP FTP folder.

Analyzed the flat files to understand the relationship between the patterns in the files, created and designed the database and schema for the McKesson. Created and scheduled the SSIS package to execute the exe.

Created SSIS package to move the data from the Azure SQL database to Stage MedPlan and from Stage MedPlan to SQL Server Pioneer Report database.

Rewrote the First Patient Stored Procedures to include the table variable instead of temp table, called the stored procedure to the SSIS package to display the missed patient records on the SharePoint FirstPatient list.

Created the UI using the WPF and Winforms

Implemented multithreading using the System.Threading.Thread class. Used various properties and methods of Thread Class like ThreadState, CurrentThread.

As a developer, used Asp.Net MVC Core, C#, Javascript, Jquery, Angular7, CSS and Bootstrap 3, and rewrote the InContact UI project based on the screen mockups.

Used Entity Framework to perform CRUD operations, i.e., read, insert, update, or delete from a database table.

Client: Consolidated Health Plan, remote position November 2018 – April 2019

Role: .Net Developer

Project: International Student Insurance

This project was for Student Insurance for National as well as International Students to create a feature rich responsive website with Rest API’s to facilitate insurance membership and policy documents and claims forms submissions and tracking.

Used Bootstrap to make the website responsive and feature rich on various kinds of devices like cellphones, tablets, laptops and large monitors.

Created multiple WCF web services to provide secured and low latency operations

Also deployed the websites in multiple environments like Dev, QA and Production

Made the website workable on most of leading browsers like Chrome, FireFox, Internet Explorer and Microsoft Edge

Designed and modified Schema of SQL Server databases to suit the application functionality

Also created and modified various stored procedures, user defined functions, triggers and views

To facilitate various reports for various purposes used SSRS

Created Custom controls using WPF

Client: United Healthcare, remote position Feb 2016 – November 2018

Role: .Net Developer

Project: Qcare

This project was to develop and maintain a feature rich website and software for monitoring critical patients

Responsibilities:

Evaluated business requirements and prepared the detailed functional and technical specifications that follow project guidelines.

Built and managed website in ASP.NET MVC.

Used Node-Red for wiring hardware and APIs.

Designed and developed various webforms in ASP.NET for patient portal.

Designed and modified database schema for various business requirements.

Designed, prepared as well as consumed various RESTful web services.

Used TFS as a Sourcesafe for managing code.

Worked on SQL server 2014 database as well as Oracle database.

Used MQTT protocol for messaging

Prepared and scheduled SSIS package to transfer data from MongoDB to SQL Server database.

Designed and developed SSIS packages for various business functionality for handling proper business work flow.

Handled and transferred large number of files using SSIS.

Raised and handled events using NodeJS

Prepared console applications for administrators and users for various utility features.

Optimized SQL queries to improve performance and fast loading of the SSRS reports

Prepared various SSRS reports for users to provide them good insight.

Provided production support as and when needed for troubleshooting issues.

Published and deployed websites in various environments.

Used Asp.Net MVC Core, C#, Javascript, Jquery, Angular7, CSS and Bootstrap 3 to rewrite the UI of the project based on the screen mockups.

Used Entity Framework to perform CRUD operations, i.e., read, insert, update, or delete from a database table.

Developed and consumed RESTFUL Web API services.

Created the Restful Web API using C#, Web API and .Net Core.

Client: State Of Michigan, Lansing, MI (VED Software Services) Jan 2015 – Jan 2016

Role: .Net Developer

Project: Universal Receipt Interface (URI)

Universal Receipt Interface (URI) project was to develop and maintain a feature rich website for State of Michigan for managing various financial transactions. These websites are compliant with e-Michigan coding standards and templates.

Responsibilities:

Worked on software development and website development projects Universal Receipt Interface (URI).

Implemented MVC architecture to accomplish task of isolating Business Layer, Presentation Layer and Data Layer.

Modified the functionality as per the business requirements.

Published and deployed websites in various environments.

Used MongoDB for storing the receipts entered by the users for fast response, low latency and horizontal scalability

Time to time supported the team for resolving various production issue related to SQL Server, Web Site, and IIS.

Prepared Views, ViewModels and Controllers in ASP.NET MVC 5.0 for adding, editing details of various entities of Universal Receipt Interface (URI).

Used AJAX calls and JSON for calling MVC controller action methods from JavaScript.

Used ADO.NET and Entity Framework 6 for handling database interactions with SQL Server.

Migrated legacy old database from Microsoft Access to SQL Server.

Prepared SSIS package for picking up various files with different file formats from ftp location and populating URI SQL Server database. Scheduled SSIS package to run every night for processing these FTP files.

Designed tables and created many stored procedures and functions in SQL server for accomplishing business functionality.

Designed the UI Mockup’s for various Use Cases.

Business Logic has been implemented using the concepts of Object-Oriented programming (OOP) with Code behind language C#.

Worked with ORM using LINQ to SQL/Entity framework designer for ASP.Net MVC application.

Built Responsive UI using Bootstrap 3.

Generated various reports in SSRS for Universal Receipt Interface (URI).

Used WPF Data Binding to display and interact with the data. Used the One Way Data Binding and Two Way Binding

Worked as a front-end developer using Asp.Net MVC Core, C#, Javascript, Jquery, Angular7, CSS and Bootstrap 3, rewrote the URI project based on the screen mockups.

Used Entity Framework to perform CRUD operations, i.e., read, insert, update, or delete from a database table.

Client: State Farm Insurance, Bloomington, IL (Thinksoft Technologies) Nov 2012 – Jan 2015

Role: .Net Developer

Billing Payment System (BPS) is a complex intranet application developed for multiple areas like CRC, Operation centers (Finance and Divisional areas), Support center and Systems. BPS application provides services like Inquiry on bills/payments, generates Credit Card Payments, generates Credit Card Refunds, generates a Remittance document, and generates Transaction History Report and Locate Customer.

Responsibilities:

Gathered requirements through interaction with all the relevant teams and prepared high level design and detailed design documents.

Involved in creating Technical Design Document, UML (Use Case Diagrams, Sequence Diagram, Class Diagram), Process flow Diagram, Data Flow Diagram.

Prepare complex and detailed business process flows to capture the business & functional requirements for new application development.

Graphical User Interface (GUI) was designed using ASP.NET MVC3 and the business logic was coded in C# [MVC Controllers].

Designed and Developed Web Forms using ASP.NET controls, C#, CSS and HTML to facilitate the registered users.

Created the SSIS package to migrate the insurance related data from Sybase to SQL Server.

Designed the application as a three-tier application with UI in the presentation layer, Business logic in the middle layer and Database activity in the third layer.

Developed site map path, master pages and themes to be used throughout the application for consistent appearance, and navigation.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

Wrote WPF code following MVVM architecture and designed GUI using XAML, displayed data in form, created user controls, consumed data services in WPF, created WPF Data grid, details data entry form, applied layout, styles and used data templates.

Developed various custom controls to have modular design in the Forms, one of them being Custom GridView developed using new features of GridView of .Net framework to show the entire data collected.

Used Windows Communication Foundation (WCF) for multiple services to interact with the application for the clients.

Used AJAX for partial rendering of the Web Forms to improve performance by not having the whole page post back.

Analyzed production data in SQL server to provide answers to various business Customers.

Implemented CSS classes to customize html/web server controls and skin on web server controls for consistent look and feel for all controls throughout the application.

Used ADO.NET and LINQ to SQL database programming to access and retrieve data from the SQL Server 2008 database.

Implemented Web Services in C# based on SOAP protocols using XML, XSLT and WSDL transforms for data transfers.

Designed and developed to perform user authentication and screen access authentication.

Developed windows services to send automatic emails and notifications based on the activities performed.

Worked with web.config files, debug VS .Net 2008 files and worked with IIS 6.0 server for creating the virtual directories and to setup of the website and run.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Used datasets, Data table and Data view to retrieve and manipulate data and display it in an ASP.NET page.

Worked with WSDL document and SOAP protocol while working with Web service. Developed and Maintained portal using ASP.NET, C#.

Performed client and server validations using Validation Controls.

Designed and developed normalized database in SQL Server 2008 to maintain various details of the devices, team members, device history, and access permissions.

Wrote SQL Queries to create tables, stored procedures, triggers, creating DTS Packages using SQL server and LINQ.

Generated reports using SSRS.

Involved in the deployment of project on the development and production Web servers.

Environment: ASP.NET 4.0, C#, WCF, WPF, Visual Studio 2008/2010, ADO.NET, MVC3, XML, LINQ, XSLT, CSS, SQL Server 2008, Windows.

Client: Aetna, Hartford, CT. (Thinksoft Technologies) Sep 2011 – Oct 2012

Role: .Net Developer

The Quoting and renewal System (QRS) is a web – based quoting tool in the Sales Rating and Quoting domain in the health insurance. It is an Insurance Quote Generation System used in Aetna for Small Business Segment. It is designed to be used for Quoting by Underwriters, Brokers and General Agents access to real-time new business quoting, online renewal and auto renewal. It enables Aetna user’s to Create and edit new business quotes, Send proposals to customers and View the status of the case as it moves through the quoting, underwriting and installation process.

Responsibilities:

Involved in development cycle including high-level design, data design, coding, testing, and creation of functional documentation.

Resolved production issues related to FTP files

Analyzed production data to resolve issues related to quoting by querying production SQL Server logs

Involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.

Created design documents, which include Use Cases, Process Flow Diagrams using MS Visio.

Worked on presentation, business and data access layer.

Generated various SSRS reports for management for analyzing overall quoting and renewal system

Designed and developed Web Forms using ASP.NET and C# and created necessary classes in the business components.

Created the SSIS package to migrate the insurance related transactional data from flat files to SQL Server

Involved in application design based on Model View Controller (MVC) Design Pattern and OOPS concepts.

Used AJAX Tool kit controls to enrich the GUI and usability.

Widely used JavaScript for Client Side Validation.

Involved in the designing the HTML and developing CSS, Skins for the site.

Involved in designing the Configuration XML for the site.

Used WCF of credit card service while customer payment process.

Deployed WCF service as TCPIP as well as HTTP service.

Identified the appropriate site structure and taxonomy to include site collections, top-level sites, child sites, and libraries.

Implemented Microsoft Enterprise Library Blocks like Data Access, Exception Handling, and Logging.

Developed large number of stored procedures for database operations using T-SQL.

Environment: C# 3.0, ASP.NET 3.0, WCF, Windows Workflow, JavaScript, MVC, CSS, AJAX, SQL Server 2005, Visual Studio 2008, IIS, Windows.

Client: Merrill Lynch, Hopewell, NJ (Thinksoft Technologies) Nov 2010 – Aug 2011

Role: .Net Developer

PCOE (Private Client Order Entry) a software for allowing international Equity orders to be placed for many countries from various regions like Asia, Europe, USA.

Responsibilities:

Gathered user requirements by interacting with users and prepared Software.

Created the user controls and web pages using Asp .NET.

Created Classic ASP application using HTML and Java script.

Designed and developed UI (Web Forms), User controls using ASP.NET (C#) after interacting with users for requirements.

Worked with SOAP Web services, Windows Services, .NET Remoting and SOAP Extensions.

Involved in redesign of Web Pages new interactive features.

Implemented GUI using HTML, XML, CSS and Web Form Controls to create web pages, developed Master Pages, and classes for reuse.

Implemented Data access layer (DAL) using ADO.NET to connect and retrieve and manipulate database information.

Implemented Functions, Triggers and Store Procedures using SQL in SQL Server 2008.

Imported all the price lists data from existing excel sheets to SQL Server database.

Responsible in Generating Reports and Bug fixing.

Provided assistance for integration of front end and back end applications.

Migrated SQL DTS package to SSIS.

Environment: Microsoft Visual Studio (2006), .Net Framework 2.0(c#), ASP.NET, ADO.NET, SQL Server 2008, Web Services, XML, HTML, CSS, Unit Testing, Integration Testing.

Company: RSK Info Solution Pvt Ltd, India (Thinksoft Technologies) Feb 2009 – Oct 2010

Client: Smile Quarto

Role: Jr .Net Developer

Smile Quarto can revolutionize their financial processes from managing meager accounting transactions to proactive real time finance engines, able to deliver true financial intelligence and to drive strategic changes throughout the organization.

Responsibilities:

Developed User Interface using ASP.Net web forms and web User Controls in C#.NET.

Retrieved and stored data using ADO.Net and SQL stored procedures.

Implemented live stock quote pricing using web services (webservicex.net).

Developed site map feature from XML Data source used for Menu using XMLDOM and ADO.Net concepts.

Used JavaScript, VB script for web application.

Developed several user controls for reusability in several Web-Forms.

Customized and integrated database driven content for the web pages for the portal.

Developed features for subscribing and sending newsletters.

Debugged, corrected and resolved all errors identified by client’s quality team.

Environment: ASP.Net 2.0, C#. NET, JavaScript, Web Services, XML, SQL Server.

Company: Sunsign Computers Ltd., India. (Thinksoft Technologies) Aug 2006 – Jan 2009

Role: Software Developer

This Project Deals with creation of website for shopping various Computer parts online. Using this project the Company has been maintaining all the information about their Products, Sales and Customer information data. Sunsign Computers deals with the Maintenance of their products, providing the information about the rates and availability of the products and provide online shopping. It gives an automatic reminder when the shipping is due and the amount of payment due by the Customer. This project stores the data in the Database regarding the products.

Responsibilities:

Designed and Developed Web Forms using ASP.NET controls, C#, CSS and HTML to facilitate the registered users.

Used Custom Validation and User Validations.

Used ADO.NET for data access layer to communicate with the SQL Server 2005 database.

Wrote T-SQL queries and Stored Procedures using MS SQL Server for data access and reports.

Involved in transformation of XML data using XSLT into HTML format.

Involved in Unit Testing, deployment and post production support for the application.

Generated reports using SQL reporting tool.

Environment: ASP.NET, VB.NET, HTML, XML, SQL Server, Visual Studio.

Contact this candidate