Paul Murphy

513 Southview Avenue

Kennett Square, PA  19348

Telephone:  484-612-5429

Email: paul@smasoft.com

RESUME-PROFESSIONAL SUMMARY

Mr. Murphy is an experienced Senior Technical Analyst/Solutions Architect; currently specializing in .NET technologies including C#, ASP .NET, and Visual Basic .NET. He has 10 consecutive years of developing workflow and document management solutions, web based and desktop based. He has 20 years overall programming experience with a strong record of achievements for solving business problems and architecting, developing, managing, and implementing custom solutions, including n-tier web based projects. He is experienced in developing with C# .NET, Visual Basic .NET, Web Services, .NET Remoting, ASP .NET, JAVA, JASVASCRIPT, HTML, AJAX, C++,     SQL Server, Oracle, VB Script, XML, ADO .NET, PowerBuilder, Web design, development and implementation, and other development including the Microsoft Office suite. FileNet products used extensively include, but are not limited to, Integrated Document Management (IDM), Capture, e*Process, and P8, both web based and desktop based solutions.  His total project experience encompasses the entire software development life cycle, from data analysis and design through development and implementation for major companies.  Additionally, he has obtained exemplary supervisory experience. Mr. Murphy’s skill set includes application architecture, project management, development, implementation, and extensive technical writing experience as well as creating detailed design specifications.

TOOLS/ENVIRONMENTS

C# .NET, Visual Basic .NET, Web Services, ASP .NET, .NET Remoting, SQL Server, Oracle, JAVA, JASVASCRIPT, HTML, XML, ADO .NET, FileNet Integrated Document Management (IDM), P8, Capture, e*Process, AJAX, VB Script, PowerBuilder

Certifications

¨       Multiple performance bonuses and company accolades during 20+ year career

¨       FileNet Certified Programmer

¨       FileNet eProcess Certified Architect

PROFESSIONAL EXPERIENCE

Consultant

CIBER, Inc., April 2008 – present

C# .NET Expert/Business Analyst

Onsite at DE Dept of Health and Social Services ARMS project, December 2007 – February 2009

Utilized C# .NET, ASP .NET, COBOL, DB2 Database. Mr. Murphy was selected as the Lead .NET Architect and Business Analyst for the DE Audit and Recovery Management Operations Module web-based workflow solution, the purpose of which is to track investigations into alleged fraud by clients of the social services system. The Social Services investigators punched in relevant case data into the web application, tracking multiple elements of data related to an alleged case of welfare fraud. After an investigation is complete the user does complex mathematical calculations with a dynamic self contained web page to determine the amount the client was actually overpaid. The calculations were designed using dynamic ASP .NET tables allowing input for a range of months with many rows of data per month. After an overpayment amount has been determined, the application initiates and injects claims into the accounting system when a case has reached the end of the workflow. Served as chief developer and .NET Team Lead during the construction phase of the project. The solution was web-based using ASP .NET with C# code behind structures. The back end utilized a DB2 database with COBOL procedures facilitating database connectivity. The COBOL routines were accessed from .NET by means of web services. The application used web services and .NET remoting extensively in the solution.

Senior Technical Analyst/Team Lead, Solutions Architect

Miria Systems (formerly Soluziona USA, formerly Software Consulting Group), October 1998 – September 2007

Architected, developed, and implemented multiple custom .NET applications, including both thin client (web based) and thick client (desktop based) for a multinational company headquartered in Philadelphia. These thin client applications included but were not limited to eProcess FileNet workflow, with extensive business logic embedded. The desktop applications included multiple FileNet bulk import programs (with and without GUI), email import applications, eProcess injectors, and other.

 

Some of the projects worked on while an employee of Miria Systems are as follows:

Developed an e*Process-based workflow solution that tracked loan based collateral throughout its documented lifetime for a Fortune 500 banking corporation. Created robot applications that email users when certain events occur, creates workflows and parallel SQL Server data operations, and creates mortgage-supporting documentation using a COM-based interop to Microsoft Word. Also developed a .NET based multi-threaded injector application that scans the FileNet distribution queue and inserts work items based on the parameters contained within a distribution queue record, as well as other operations.

A Fortune 500 investment firm client required the design, development, and implementation of a full featured, complete custom FileNet based workflow application.  The software was split into four major development efforts, scan, index, work item processing, and maintenance. Led a team of eight developers in the effort to develop the suite of programs.  The scan program allowed the scanning of any types of images and simultaneously queued index data for those scanned images in a complex Oracle database schema. Designed document separator sheets, and custom air bill and envelope separator sheets to be used in the document preparation phase.  These custom separators set flags in the Oracle database, which were used during the index process.

The index program presented the users with a list of available FileNet Capture batches based on their security level implemented with the Oracle database.  After the users chose a batch to process, they were presented with an assembly form, which showed a tree view breakdown of all the documents and pages of the current batch.  The tree also detailed the inclusion of custom separator sheets.  The users were able to delete, insert, and rearrange document pages or separators as they desired.  The form also included a built-in custom image viewer.

The last form presented to the users allowed the creation of single or multiple virtual work items per individual document in the batch.  The process also allowed the assignment of custom indexing data to each work item extracted through Oracle look up type searches.  The form also included a built-in custom image viewer.  After all virtual work items were successfully indexed, the users were allowed to commit the FileNet batch while the software created actual workflow work items within the Oracle database.

Additional responsibilities included assisting in the development and implementation of other processes in the workflow system consisting of work item processing and workflow and database maintenance.

Team Lead for a six man team that developed a system that included a full featured e*Process marketing contracts workflow web application, a Panagon Capture scan module with customized customer id number lookup features, and an email robot application that scans e*Process queues and sends emails based on certain rules to certain groups or individuals when specific events are triggered for a multinational company headquartered in Philadelphia.

Developed an on-line ASP .NET thin client (web) application for the human resources department that allows users to upload documents from a remote client to the FileNet image repository.

Developed an on-line ASP .NET thin client (web) application for a global electronics manufacturing firm client that The applications allows users to upload documents from a remote client to the FileNet image repository.

A FileNet Workforce Desktop to Panagon conversion was required for several existing 16-bit applications for a major US banking corporation. These applications all used the VBX custom controls intrinsic to WF Desktop for queue manipulation, whether it be to allocate, look up, edit, insert or delete queue information. Solutions were developed that replaced all the VBX controls with code that duplicated the functionality using the IDM objects exposed in the Panagon suite. The custom programs interfaced with the exact same IMS as did the WF Desktop applications, allowing no server side alterations to become necessary.

The client also required a custom FileNet Panagon Capture indexing application to be created due to the fact that they had decided to use out-of-the-box Panagon Capture for a scanning solution to replace the WF Desktop custom scan program. The indexing application allows the user to open batches within the Capture repository. Then they can add index information retrieved through FileNet queue lookups, or add manually entered data as required. Barcode integration is also included within the custom Capture indexing program allowing for automatic indexing where applicable. All batches are committed to the FileNet IMS from within the custom Capture indexing application.

Developed two FileNet e*Process injector applications that manipulate data from several SQL Server tables, which were themselves dumped directly from a mainframe for a major US-based banking firm. Based within a transaction process, the transformed and fully reformatted data is inserted into other completely separate SQL Server tables using parameter based stored procedures. Subsequently, an e*Process work item is injected into the workflow where it is made available to the users through custom ASP pages. Only after all injection processes complete successfully is the injection considered complete, and then the transaction package is committed. The source code contains complete and procedure specific error handling allowing for the injection to be rolled back in case of failure at any point within the injection, regardless of whether it is during the SQL Sever cycle or later within the e*Process injection routines.

For a major US insurance corporation, an Oracle database connection was required for several applications, which included three FileNet IDM server based robot applications as well as a custom Panagon Capture scan application. The first robot application was an import program that polled a specific directory at timed intervals and imported to FileNet the documents it found along with auto-indexed information contained within an associated text file. Secondly, there was a pre-fetch robot that generated a batch file to allow documents to be pre-fetched on the FileNet server. The last robot program read mainframe data that was dumped to an Oracle table, and injected that data into specific FileNet distribution queues.

The scan application used the FileNet Panagon Capture custom controls to allow scanning to take place on several Bell and Howell image scanners. Indexing data was contained in barcodes that were printed on the document separator sheets. The indexing data was cross-referenced to an Oracle table, which allowed multiple index values to be contained within one single barcode. As the program applied the indexing to each document, an Oracle lookup was performed in order to parse the index data from each individual barcode.

Led a team in the development of custom software for a Fortune 500 investment firm.  The customer had a requirement for a custom FileNet find application.  Additionally, there were requirements to design, program, and implement a FileNet image import/auto-indexing application.  The software located images in a polling directory and looked up SQL Server data to find a match based on the filename of the image. The image was imported into FileNet, assigned index data extracted from the database, and committed to the FileNet repository.  The scanning of the target images was done by a third party application that deposited the scanned images in the polling directory.

Architected and developed four separate and unique custom FileNet Capture applications for three individual corporate units of a global automobile manufacturer that allowed the users to index and commit scanned images to the FileNet repository.  These applications presented the users with a list of batches currently available in the Capture BES and allowed them to select the batch they wanted to index.  Subsequently, a custom indexing screen appeared, showing users the image(s) contained in that batch.  Also shown were pre-populated combo boxes, free form text fields, and look-up search text boxes that retrieved SQL server account data for the criteria entered.  After verifying that all required fields were successfully indexed, the users were then permitted to commit the batch to the FileNet repository.

The customer required a custom FileNet find application that could interface with a SQL server database by extracting search criteria based on fuzzy searches.  The resultant account number or other information could be used as criteria against the FileNet repository searches, then a grid of resultant documents were presented to users for their viewing selection.

A secondary requirement of the FileNet find application was the need to develop a custom FileNet image viewer application that could mimic and extend the functionality contained within the standard FileNet image viewer.  Specifically, the customer desired the ability to view, print and fax individual pages of selected documents, given any combination of pages or documents required.  The viewer program also allowed for the ability to spit long images (greater than 11 inches) into multiple 8.5 x 11 inch pages.  The full size integrity of the images was maintained when they were printed or faxed to another location.

Worked on a project for a New Jersey state government agency that was devoted to patching a group of existing Visual Basic 5.0 programs.  Corrected significant logic faults, created new code for sections of additional logic flow, and added error handling.  The scanner interface utilized a Seaport Imaging SDK.  Rewrote the existing code, which allowed the document scanning process to work correctly.  Completed extensive work to allow the correct operation of the data warehouse storage capabilities.  Created a utility that allows the administrator to view the current index data and document status flags that are stored in the SQL Server tables.

Developed a Visual Basic ActiveX DLL allowing text report files stored in an Oracle database to be extracted, formatted, and imported into FileNet Panagon Capture for a global pharmaceutical corporation.  These text report files were automatically indexed and committed to a FileNet repository.  The compiled DLL was passed appropriate parameters (FileNet login, Oracle login, etc.) from an external program into a class method exposed as the only entry point into the DLL itself.  Wrote code that extracted text report files from an Oracle table and then created multi-page TIFF images from the text files.  Based on parameters passed, the program split the multi-page TIFF images into multiple single pages.  Subsequently, the code created new FileNet Panagon Capture batches, imported the TIFF images that had been previously created, and indexed the images with data extracted form the Oracle tables.  After the process was completed successfully, the capture batch was committed to the FileNet repository and a successful result flag was set within the specific Oracle records that were being processed at that time.  If the function encountered an error and could not complete the entire set of parent Oracle records, they would be rolled back in a transaction process allowing for a clean start at another time.

Led a team in developing a Watermark Imaging Expansion project for a US-based health care provider.  The project consisted of a utility program written in Visual Basic. The program manipulated document images extracted from a Wang document imaging system and uploaded to a FileNet Watermark based imaging system.  The program concurrently extracted index values populated in SQL server tables and applied those values to the document images as they were uploaded to Watermark.  Full fault tolerance was included in the program, allowing the upload process to be stopped and restarted multiple times without loss of data. Eliminated significant logic problems and architected new custom processes to extract, upload, and index the document images.  Architected and developed the process which uploads the document images.  A full featured control panel was presented to the users showing all the processes that were currently taking place, as well as the current state of the Watermark repository, the total number of documents that had been uploaded, and the number of documents remaining to be uploaded.  The specific design of the screen allowed the upload process to be stopped at any point and subsequently, the process could be restarted at any time.

Some additional development efforts included, but were not limited to, client server applications, custom ActiveX control development, utilities programs, miscellaneous SQL Server and Oracle database design, java development, integration, and implementation work, custom project implementation directives, requirements analysis, and numerous other custom applications.

Owner/Operator

Solutions Management Associates, February 1994 - present

Technical Analyst/Programmer

ATT Global Information Solutions, March 1990 – November 1995

Developer

Landis Consulting July 1987 – March 1990