Partha Mandayam

Technology Consultant

Independent Freelancer

SQL Server 20 years
CSS 12 years
VB.Net 12 years
Javascript 12 years
C# 12 years
ASP.Net 12 years

I am a result-oriented IT professional with extensive experience in managing projects, collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for several Fortune 500 US Clients. I have worked as Dynamic Project Manager for GE (Corp) and Business Solutions Group Corp and Lead Developer for Kaiser Permanente, Regence Blue Cross Blue Shield, and Allied Signal Aerospace. I was involved in developing cutting-edge AJAX-enabled ASP.NET websites for Summacare, Kaiser Permanente, University Hospitals, and Progressive Insurance, which improved application performance by over 200%. I worked on a replacing an unwieldy manual excel spreadsheet based Change Request Management system with a slick and compact web interface, improving data integrity and efficiency by 200%, for Kaiser Permanente. Represented Unisys Corporation as Sr. Business Intelligence and Reporting Expert on the proposal team for New Hampshire MMIS ( Medicaid Management Information System ). I was involved in developing a call accounting package called Call Analyst for a telecom Company Trivium Systems in Beaverton, OR, USA which was sold for $2500 per seat in 1999. I am an extremely tenacious person. Created data warehouse for Vesta Inc which improved ASP web reporting efficiency by 250%.


Positive Attitude
  4.5 / 5
Team work
  4.6 / 5
  4.6 / 5
  4.3 / 5
Problem Solving
  4.5 / 5
  4.6 / 5


English communication
  4.5 / 5
Past work clarity
  4.5 / 5
Client interaction experience
  4.6 / 5
  4.6 / 5
Open to learning
  4.5 / 5
Open source contribution
  3.0 / 5




  • Allstar Technology

    .Net Architect

    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.

  • Travel Centers of America

    Software Consultant

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

  • Power and Signal

    Software Consultant

    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#,, 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.

  • University Hospitals

    .Net Architect

    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, and SQL Server 2008 R2 ( 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.

  • CVS/Caremark

    Application Developer

    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.

  • Invacare

    IT Consultant

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

  • Progressive Insurance

    Application Programmer


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

  • Progressive Insurance

    .Net Architect


    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.

  • Cardinal Commerce

    Software Developer

    VS2008C#ASP.NETVB.NETSQL Server 2005

    Developed mobile application for Networks in Motion ( to offer Gokivo Navigator navigation application ( 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 storefront e-commerce shopping cart components (
    Achieved tremendous application performance improvement by tuning and optimizing SQL queries.

  • Kaiser Permanente

    .Net Architect

    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.