The Database Guru

PARTHA MANDAYAM

**** **** ***** ******, ****, OH 44224

E-mail : ******@*****.***

Home: 330-***-****

Cell : 503-***-****

OBJECTIVE

Seeking an opportunity to build dynamic websites using the latest cutting-edge .Net technologies.

EXPERIENCE SUMMARY

• Total 20 years experience : 15 years experience in VB & SQL Server, 6 years in HTML/ASP/IIS, 3 years in VB.Net/C#/ASP.NET , 6 years in Crystal Reports, 5 years in Crystal Enterprise, 6 years in MS Access, 2 years in XML/XSL, 2 years in Coldfusion, 2 years in ERWIN, 3 year Unix/INGRES and 3 years in Oracle. 5 years in Production Engineering.

• Certified VB, SQL Server and ASP Programmer.

• Developed a call accounting package worth $2500 per unit - total sales worth $37.5 million for Trivium Systems.

• Created data warehouse for Vesta Inc which improved ASP web reporting efficiency by 250%

• Extensive experience in developing n-tier web-based client-server applications for several prestigious clients like Federal Reserve Bank of San Francisco, State of West Virginia, Eddie Bauer, Vesta, Pacificorp, Regence, Micron Electronics, Corillian, Nacco Materials Handling Group, Supra Products, Trivium Systems, etc.

• Was Project Manager for GE(Corp), Account Manager for Regence Blue Cross Blue Shield at A&I Benefit Plan Administrators, and Lead Developer for Regence Blue Cross Blue Shield.

• Trained in AJAX, WCF, Visual Studio 2008, IIS Security, Active Directory, SQL Server 2000, OLAP, Visual C++, Informatica, VB.Net, XML Web Services, Interpersonal Communication, Leadership Skills.

• Official Microsoft beta tester for SQL Server 2008, Visual Studio 2008, Windows Vista, Office 2007 and Microsoft Virtual PC 2007.

• Technical expert at www.expion.com, www.vistaresearch.info, www.experts-exchange.com, www.allexperts.com and www.askme.com.

• Consulting expert at Gerson Lehrman Group ( http://www.glgcouncils.com)

• Check out my official Microsoft ASP.Net blog at http://weblogs.asp.net/pmandayam

• Check out my profile on LinkedIn at http://www.linkedin.com/in/mcp111

• Member of Cleveland .Net Special Interest Group (http://www.bennettadelson.com/technicalresources/sig.aspx) , Cleveland C#/VB.Net user group ( http://www.clevelanddotnet.info ), Cleveland Sharepoint user group (http://www.sharepointcleveland.com/default.aspx ) and INETA ( www.ineta.org )

• Member of Microsoft Executive Business Circle and Sun Microsystems Executive Board.

• Member of International Who’s Who Historical Society for Technical Professionals

• Member of International Association of Business Leaders, a very prestigious international organization. Membership is only by invitation for outstanding contributions in your field.

• Member of Toastmasters International, a leadership and communication skills development club

• Member of Certmag 500, an exclusive evaluation committee of IT Professionals formed by Certification Magazine

• Member of IEEE Computer Society

• Creative, highly motivated, team player and deadline-savvy with superior work habits, multi-tasking and system documentation skills

• I am a US Citizen

SKILLS

Visual Studio 2008 SQL Server 2008 VB.Net/C# IIS/ASP.NET

AJAX Javascript/ VBScript HTML/ASP WPF/WCF/WF

LINQ Silverlight QNXT HIPAA / EDI

Crystal Reports XI Crystal Enterprise Web services XML/XSL

Oracle 10g Biztalk SOA Data Warehousing

Sharepoint RUP UML Cypress

Starteam Remedy Windows Vista Access

Dreamweaver Flash Java/EJB Informatica

PROFESSIONAL EXPERIENCE

Sr Prog Analyst, Kaiser Permanente, Jun 2007 to Feb 2009

• Kaiser Permanente is the largest HMO in USA. Development of BETS ( Benefits Enhancement and Tracking System ) ,which keeps track of benefit details of Kaiser Permanente members, using Visual Studio 2005, Oracle 10g, C#, VB.NET and ASP.NET. Converted several ASP pages to ASP.NET. Converted several VS2003 websites to VS2005 format.

• Used AJAX controls like UpdatePanel , ScriptManager , UpdateProgress and AJAX Control Toolkit to build dynamic web pages.

• 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, Detailsview, Listview and Datapager. Used latest C# 3.0 features like LINQ, object initializers, anonymous types, lambda expressions, extension methods, etc.

• Used Borland Starteam for source control and Remedy for change management

ASP.NET Developer, Summacare, Dec 2006 to April 2007

• Summacare is the largest health plan in Ohio. Developed complex EDI Dashboard claims reporting web based system using Visual Studio 2005, SQL Server 2005, C#, VB.NET and ASP.NET. The system shows details of various types of claims such as HCFA 1500, UB92, etc. The web forms have the look and feel of the actual UB92 and HCFA paper forms. Users can search data based on various criteria like Claim number, member number, Provider ID, Date of service etc. Partial wildcard searches on any of these fields are also possible.

• Used Microsoft Enterprise Library functions for data access and all code is securely stored on Visual Studio 2005 Team Foundation server.

• Used most modern AJAX techniques like XMLHTTPRequest for data access. Wrote complex Javascripts for form validation and web page rendering.

Software Engineer III, Unisys Corporation, Nov 2003 to Nov 2006

• Developed extremely complex Medicaid Management information system ( MMIS ) based on SOA with over 800 reports for the state of WV using Crystal Reports 10 and SQL Server 2005. The system that we developed is called HealthPAS and uses the QNXT Medical Claims Processing System from QCSI. These reports were earlier available on a legacy mainframe system in COBOL and were converted to Crystal Reports. Some new reports were also designed. The state of WV accesses these reports through a web portal developed using the API provided by a document management system called Cypress. The reports are scheduled in Crystal Enterprise which transfers them to the Cypress DocuVault and the end-users are then able to view these reports using a web interface. The HealthPAS system also has the capability of directly receiving medical claims in EDI format from various providers and the data is then parsed by EDI processing software and stored in a SQL Server database. Acted as SQL Server DBA doing extensive performance tuning of queries used in the reports. Was a member of the Unisys Sharepoint user group and attended regular meetings on Sharepoint technology. All reports were accessed using a portal built on Sharepoint Server 2003. Extensive programming using web parts and asp.net components.

• Developed an automated data extract program using VB and SQL Server DTS to extract claims data into flat files which were then automatically placed on a network drive where the client could access them. This was later ported to Vb.net and SQL Server 2005.

Project Manager for Business Solutions Group Corporation, Portland, OR, Apr 2003 to Nov 2003

• Development/maintenance of several Visual Basic applications seamlessly integrating with Quickbooks 2002, 2003 and 2003 Canadian edition Financial Accounting Software.

• Automated Production Management (APM ) is an ERP software which allows companies to maintain customer, items and material data and seamlessly transfer items from and to Quickbooks. It also does material costing and keeps track of inventory and reorder levels.

• Automated Food Production (AFP) system keeps track of ingredients and recipes for the food industry. You can also keep track of packaging costs for the various food items.

• Membership Management system (MMS) enables trade unions to maintain membership details of their employees and also keep track of dues owed by the members.

• Remote installations and troubleshooting using Webex internet conferencing tool.

• Extensively used Windows XP, VB6, SQL Server 2000, Crystal Reports, Quickbooks SDK, Infragistics Ultrasuite.

For a more detailed resume please see http://partha.tripod.com/long_resume.doc

PROFESSIONAL MEMBERSHIPS

Member of IEEE Computer society, American Management Association , SQL Server Worldwide Users Group, MSDN, Oracle Technology Network, Cleveland DOTNET User’s Group , XML Web Services Special Interest Group, INETA ( International .Net Association ), International Webmasters Association, Rational Developer Network, Sun One Inner Circle Program, Sun Executive Boardroom, Microsoft Executive Business Circle, Oracle Development Tools User Group (ODTUG) , Java Developer Connection, Intuit Developer Network, Nokia Developer Network, Motorola Developer Program.

EDUCATION

B.S. Engineering, College of Engineering, Pune, India (1987)

Advanced Certification in System Analysis, Symbiosis Institute, Pune, India (1988)

Contact this candidate