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

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

 

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

 

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 

 

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)