C#ASP.NETJavaVisual Studio 2013AzureSitecore CMSSQL Server 2012Node.jsTelerikAJAX

Developing ASP.NET applications for commercial auto insurance billing for RV's, Boats etc using C#, ASP.NET, Java, Visual Studio 2013, Azure, Sitecore CMS, SQL Server 2012, Node.js and Telerik UI Controls for AJAX.
Used Agile methodologies for project planning and execution.
Web application interacts with a web service to get file layout data for commercial auto insurance details to be sent to various clients like State of NC, Stonewood Insurance, etc.
Created several C# classes to generate output data files as per client specifications to display insurance data.
Developed reports to show billing details, user demographics, etc using SSRS.
Created SSIS packages to import billing parameters from Excel files.
Created web parts using Sharepoint 2013.

ASP.NETOracle 11iC#VS2010

TravelCenters of America is the largest full-service travel center company in the United States, serving professional drivers and motorists alike. 
Development/maintenance of ASP.NET web applications using VS2010, Oracle 11i, C#, ASP.NET for travel center billing.
Creating Excel reports from web pages using Spreadsheetgear (www.spreadsheetgear.com).
Development/maintenance of C# console applications to generate scheduled excel reports using Spreadsheetgear.
Used Team Foundation Server for source code control. Branching and merging code between Development, QA and Production.

Visual Studio 2010.NET 4.0C#ASP.netLINQJavascriptJqueryJqueryuiangularjsMySQLRijndael encryption algorithms

Development/maintenance of cutting-edge e-commerce website for order sampling using Visual Studio 2010, .NET 4.0, C#, ASP.net, LINQ, Javascript, Jquery, Jqueryui, angularjs, Generic lists and collections, Rijndael encryption algorithms and MySQL, the world's most popular open source database.
MySQL was used like a NoSQL database rather than a traditional RDBMS with just a key field and all the data was encrypted as a blob. There were functions to encrypt the data into a blob while saving from the web page and decrypting and displaying the data on the web pages.
The actual table structures were defined in the C# classes.
Used Jquery FancyBox to display a cool popup to show order details when order number was clicked.
Used cool dropdown JqueryUI calendar control to show drop-down calendar when the associated textbox was clicked so the user could select date ranges for an order history report.

Visual Studio 2008C#.NETjqueryangularjsxmlxsltASP.netSQL Server 2008 R2NoSQLTelerik UIAJAXSSRS

Development/maintenance of Caisis Cancer Care Management system using Visual Studio 2008, C#, .NET, jquery, angularjs, XML, XSLT, asp.net and SQL Server 2008 R2 (www.caisis.org) with Nosql.
Modification of Caisis software based on user change requests.
Used Subversion for source code control.
Used Telerik UI for ASP.NET AJAX controls to build dynamic websites.
Created patient diagnostic reports in SSRS.

SSISSQL Server 2008NosqlVisual Studio 2008/2010C#.NETBusiness Intelligence Development Studio

Developed billing invoice extracts using SSIS, SQL Server 2008, Nosql, Visual Studio 2008/2010, C#, .net and Business Intelligence Development Studio. Modified billing extract to conform to new CMS ( Centers for Medicare and Medicaid services ) 45-day rule which states that a member should be sent an invoice within 45 days of an adjustment.
Modified Varolii SSIS package to use different grouping for the 2012 year. Varolii is a company used by CVS for automating prior authorization calls.
Used Serena Teamtrack for change management and Visual SourceSafe for source code control. Used BIDS Helper Add-on to improve SSIS package productivity in Business Intelligence Development Studio.
Created cubes in SSAS2008 to analyze claims data.

Visual Studio 2008C#ASP.NetMVCangularjsWCFSQL Server 2008R2jquerySISSSAS2008

Invacare HCS provides patient management services to home health providers who have a desire to improve their cash collection operations, and recognize the benefits of having a third-party help them manage the increasing complexities of Medicare and health insurance reimbursement trends.
Developing asp.net applications using Visual Studio 2008, C#, MVC, angularjs, WCF, SQL Server 2008R2, jquery for home medical care for elderly patients suffering from sleep apnea. The system automatically dials patients and helps them get their supplies.
Created a business intelligence dashboard for patient metrics using SQL Server Reporting Services.
Automated chain mailing of patient letters using SQL Server Reporting Services.
Developed C# program to create patient data exports in Excel files which were placed in special network folders by the provider from where the providers could access them.
Modified SSIS data transfer package to limit data file input to files from the past seven days. Earlier it was processing all the data which was unnecessary. Used SSIS Script task and wrote VB.Net script to get the files from the past seven days using date embedded in the file name.
Created cubes in SSAS2008 to analyze patient data.

SSRSSSISBIDSVS2008SQL2008R2SSAS

Development of BI Analytics dashboard for analyzing Policypro auto insurance system metrics using SSRS, SSIS, BIDS, VS2008 and SQL2008R2.
Developed SQL server data warehouse for reporting and created SSIS packages to move data from OLTP SQL Server and DB2 production databases to the data warehouse.
Created complex SSIS packages with multiple conditional data flow.
Found several bugs in SSRS and SSIS and reported to Microsoft via their connect portal http://connect.microsoft.com
The reports are developed at different levels of summarization.
Hourly - transaction breakdown based on the hour of the day - These reports help in understanding the transaction mix at different times and identifying the peak periods (Time Horizon: A given day) Daily - trend based on "Day of Week". This is important since there is a significant variation, especially for End of Day transactions (Time horizon: 3 - 6 months) Weekly - trends based on weekly summarized data (Time horizon: 6 months to 1 year) Monthly - trends based on monthly summarized data (Time horizon: 1 - 3 years). Created cubes in SSAS to analyze insurance data.

ASP.NETVS2008C#MVCSQL2008jqueryAngularjs

Development & maintenance of ASP.NET web application for calculating insurance agent commission based on several business factors using VS2008, C#, Angularjs, MVC, SQL2008, and jquery.
Created web pages for adding, modifying, deleting and viewing agent commission data.
Modified complex stored procedure for determining agent commission to incorporate logic for retrieving commission data for agents in the states of IN and MN. This is part of Policypro, a multi-million dollar web-based auto insurance system, built from the ground up on the .Net platform, which will replace the existing mainframe-based system.

VS2008C#ASP.NETVB.NETSQL Server 2005

Developed mobile application for Networks in Motion (www.networksinmotion.com) to offer Gokivo Navigator navigation application (www.gokivo.com) on the latest Sony Ericsson mobile phone in the USA, Canada, Eastern and Western Europe using VS2008, C#, ASP.NET, VB.NET and SQL Server 2005 and the asp.net storefront e-commerce shopping cart components (www.aspdotnetstorefront.com).
Achieved tremendous application performance improvement by tuning and optimizing SQL queries.

Visual Studio 2005Oracle 10gSQL Server 2005C#VB.NETASP.NETSSRSSSISAJAXTelerikSilverlightMOSS2007 Sharepoint portalMetalogixVisual Studio 2008WPFWCFWFPRISMLINQHP Quality Center

Development/Maintenance of BETS (Benefits Enhancement and Tracking System) for the largest U.S. HMO (8 million+ members) using Agile methodologies.
BETS tracks benefit details of Kaiser Permanente members.
Used Visual Studio 2005, Oracle 10g, SQL Server 2005, C#, VB.NET, and ASP.NET. Converted several ASP pages to ASP.NET which improved efficiency by 200%.
Converted several VS2003 websites to VS2005 format which increased ease of development and reduced bugs.
Converted several VB6 applications to VB.NET to improve performance and scalability.
Created SSRS reports and SSIS packages in SQL Server 2005. BETS team is global involving frequent coordination with the offshore team in India.
Developed Winforms application for insurance quotes.
Used web services to import payment data from other systems.
Mentored several junior programmers and assisted with technology vision, resource allocation, project planning, and vendor evaluation.
Performance tuning of complex SQL Queries.
Used AJAX controls like UpdatePanel, ScriptManager, UpdateProgress, and AJAX Control Toolkit along with Infragistics Netadvantage and Telerik RADControls for Silverlight to build dynamic web pages which loaded 200% faster and resulted in enhanced user experience. Custom web parts programming for MOSS2007 Sharepoint portal. Sharepoint database consolidation between several branch offices and migration from Sharepoint 2003 to MOSS 2007 using Metalogix. Built dynamic user interfaces with Expression Blend seamlessly integrating with Visual Studio 2008, WPF, WCF, WF, PRISM Silverlight toolkit, and Silverlight Control Toolkit.
Developed ASP.NET web application in VS2008 to track change requests for the BETS system using most modern ASP.NET 3.5 controls like Gridview, Details view, Listview and Datapager. This was a full life cycle implementation right from gathering requirements to final implementation. This replaced an unwieldy manual spreadsheet application with a slick and compact web interface and increased user productivity by 200%. Used latest C# 3.0 features like LINQ, object initializers, anonymous types, lambda expressions, extension methods, etc. to deliver a highly enhanced and productive user experience.
Used Borland Starteam for source control, Remedy for change management and HP Quality Center for testing.