PARTHA MANDAYAM

16125 NW Schendel Ave, #H, Beaverton, OR 97006

Phone : 503-614-2853, E-mail: mcp111@hotmail.com Cell:503-807-3417

OBJECTIVE

Seeking an opportunity to utilize my extensive database and web skills to build dynamic data-driven web sites.

EXPERIENCE SUMMARY

· 16 years experience : 4 years in production engineering and 12 years in IT.

· 7 years experience in VB & SQL Server, 3 years in ASP, 4 years in Crystal Reports, 4 years in Access, 4 years in HTML, 3 years in Unix writing shell scripts using korn shell, bourne shell, and cshell and 2 years in Oracle.

· Certified VB, SQL Server and ASP Programmer.

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

· Created web enabled reports using Crystal Enterprise for Salem Kaizer Public schools and mentored the IT dept. in Crystal Reports

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

· Comprehensive documentation of complex supply chain management system for Eddie Bauer – improved efficiency by 50% by using ADO calls.

· Improved electronic discovery efficiency by 50% for Fios Inc.

· Wrote complex cursors, stored procedures and improved performance by 50% for Pacificorp.

· Extensive experience in developing n-tier web-based client-server applications for the manufacturing, financial, healthcare, real estate, banking, electrical and apparel industries

· Technical expert at www.expion.com and www.askme.com

· Familiar with Microstrategy and Project management concepts such as PERT/CPM, Gantt chart, etc and also conversant with the use of MS Project and the full software development life cycle..

· Familiar with RUP and UML and an active member of the Rational Development Network.

· Trained in IIS 4.0 Security, Active Directory, SQL Server 2000, Visual C++, Informatica, VB.Net, XML Web Services, Interpersonal Communication, Leadership Skills.

· Creative, highly motivated, team player and deadline-savvy.

· Superior work habits, layout skills and system documentation skills

· Permanent resident of the United States.

SKILLS

Visual Basic	SQL Server	HTML/ASP	IIS
Crystal Reports	COM/MTS	Data Warehousing	Javascript
VBScript	Access	Oracle	.Net
Coldfusion	XML/XSL	Java/EJB	Unix
Black Box Testing	White Box Testing	Crystal Enterprise	Informix

PROFESSIONAL EXPERIENCE

EDI Specialist for A&I Benefit Plan Administrators, Portland, OR, Sep 2002 onwards

· Created data warehouse for storing medical claims data in SQL Server.

· Developed Telephone call tracking application using VB.NET, ASP.NET.

· Created complex DTS packages for data transfer from fixed length flat files to SQL Server and vice versa involving loading data from one flat file into multiple tables using ActiveX scripts.

· Developed various Health Insurance forms in Crystal Reports from EDI transaction data such as 837P, 837I, 837D, etc.

· Was responsible for the monthly claims data transfer to Regence Blue Cross Blue Shield and also created comprehensive documentation for the process.

· Transferred data from Progress to SQL Server.

· Training on Microsoft Biztalk server and Redix EDI HIPAA package. Created multidimensional cubes in SQL Server 2000.

· Extensively used Windows XP, Visual Studio.NET Enterprise Architect, VB.NET, ASP.NET, SQL Server 2000, DTS, OLAP, Progress 4GL, ADO.NET, COM, HTML, VBScript, Javascript, Crystal Reports 9.0, Crystal Enterprise 9.0, Perl, Filemaker, Coldfusion

Software Engineer for Prodx, Portland, OR, Mar 2002 to July 2002

Projects Executed:

Vesta Inc, Portland, OR

Improved report processing efficiency by 250% by building a data warehouse for e-commerce web sites.
Created stored procedures to implement new algorithms to minimize credit card fraud.
Created complex web reports using ASP and SQL Server 2000 to report fraudulent order data by customer, credit card number, email address, etc
Performed complex migration of data between databases with dissimilar schemas by creating a mapping matrix and writing several ETL migration scripts.
Was SQL Server DBA responsible for performance tuning and synchronizing schema changes between development, QA and staging servers.
Used the XML features of SQL Server 2000 and XSL for parsing the output.
Completely involved in development and testing, defect tracking and bug fixing.
Created JSP pages with BEA Weblogic. Used Wincvs and Visual Sourcesafe for configuration management.
Used ERWIN and ER/Studio for data modeling. Created extensive documentation of database schema.

· Transferred data from Progress to SQL Server. Created multidimensional cubes in SQL Server 2000.

Extensively used Windows 2000, VB6, C++,SQL Server 2000, Progress 4GL, XML/XSL, DTD, ASP, JSP, BEA Weblogic, IIS 5.0, Visual Interdev, ADO, COM, HTML, VBScript, Javascript, DHTML,CSS,OLAP, VB.NET, ASP.NET, Coldfusion

Software Engineer for Nexcentral Inc., Portland, OR, Jan 2002 to Mar 2002

Created a web interface for doctors to access Oregon Health Plan data stored in a SQL Server 2000 database.
Used complex DHTML features such as dynamically inserting rows in HTML tables at run-time.
Extensively used CSS for assigning dynamic styles to the web page.
Created some reports in Crystal Reports involving extensive subreports, web-enabled reports using Crystal Enterprise.
Wrote Excel macros to modify the menu and toolbars using the CommandBars collection.
Completely involved in development and testing, defect tracking and bug fixing.
Extensively used Windows 2000, VB6, VBA, Excel, SQL Server 2000, Crystal Reports 8.5, Crystal Enterprise, Crystal Web Server, CSP, ASP, IIS 5.0, Visual Interdev, ADO, OLEDB, COM, HTML, VBScript, Javascript, DHTML,CSS,OLAP, VB.NET, ASP.NET

Software Consultant for Triad Technology Group, Portland, OR, Aug 2001 – Nov 2001

Projects Executed:

Salem Keizer Public Schools, Salem, OR

· Created progress reports in Crystal Reports 8.5 designed to run over the internet using IIS, Coldfusion and Crystal Enterprise.

· Used advanced reporting features such as conditional formatting and complex formulas, subreports, multiple detail sections, etc.

· Created Excel forms involving several macros for populating drop down lists , listboxes, etc.

· Mentored the IT Department in Crystal Reports.

· Completely involved in development and testing, defect tracking and bug fixing.

· Extensively used VB6, VBA, Excel, SQL Server 7.0, Oracle 8i, PL/SQL, Crystal Reports 8.5, Crystal Enterprise, Crystal Web Server, CSP, ASP, IIS, Visual Interdev, Coldfusion, ADO, OLEDB, RDO, COM, HTML, VBScript, Javascript, DHTML,OLAP

Software Consultant for Rapidigm Inc, Portland, OR, Jun 1999 - Aug 2001

Projects Executed:

Blue Cross Blue Shield, Portland, OR

Developed Contracts and Booklets system for generating insurance contracts and booklets which was an improvement on the existing Erisco FACETS system and used the same business rules.
Created extensions to FACETS using VB.
Was lead developer involved in Functional Specifications, System design and prototyping.
Completely involved in development and testing, defect tracking and bug fixing.
Used ERWIN and ER/Studio for data modeling.
Wrote Excel macros for sending Email using Outlook.
Created shell scripts using korn shell, cshell and bourne shell.
Extensively used VB6, VBA, Excel, ADO, C++, OLEDB, RDO, COM, Oracle 8i, PL/SQL, Coldfusion, Crystal Reports 7.0, Sybase System 11, Lotus Notes, Unix, korn shell, cshell, bourne shell, ASP, HTML, VBScript, Javascript, DHTML, SQL Server, Perl

For a more detailed resume please see https://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, PADNUG ( Portland Area DOTNET User’s Group ), XML Web Services Special Interest Group, INETA ( International .Net Association ), Rational Developer Network, Sun One Inner Circle Program, Java Developer Connection

EDUCATION

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

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