SUMMARY

• Senior - level database and development engineer with over 20 years of professional experience in the project management, strategic planning, analysis, design, development, execution, and delivery of highly complex, customized technology solutions.
• Solid background in formulating technology solutions for healthcare industries - including a strong knowledge of Facets software (version 2.96, 4.21, 4.31, 4.41, 4.51, 4.61, 4.71, 4.81, 5.01, 5.20), Visual Cactus, Contract Manager, HIPAA compliance, and Medicare/Medicaid environments.
• Expertise in diverse development platforms accompanied with multifaceted programming capabilities with a strong emphasis on Sybase and Microsoft-based technologies - including SQL Server and the .NET framework.
• Skilled team leader; adept in training, coaching, and motivating members to support broad ranging development, functional, and operational needs.
• Smart working and focused with exceptional analytical, organizational, and interpersonal skills.

TECHNICAL SKILLS

Languages: MS SQL Server, Sybase 15.0, Oracle, Access, Informix, FoxPro, TSQL, PL/SQL, DTS, Visual Studio.NET, ASP, Visual Basic, Visual Interdev, C, C#, Visual C++, XML, Windows/UNIX Socket programming, Delphi, Pascal, Perl, Assembler, Java (test environment)

Software: Facets (versions 2.96, 4.21, 4.31, 4.41, 4.51, 4.61, 4.71, 4.81, 5.01, 5.20), NetworkX (test environment) DataStage 11.3, Microsoft Office, dBase, Excel, Rapid SQL, TOAD, Crystal Reports

Platforms: Windows Servers, Windows 2000, DOS, AT&T/Unix, Sun/Unix, HP/Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

Facets Systems Integration/Data Analyst Consultant Lead

Responsibilities:

• Worked on Provider, Billing, Claims modules. Claim Recovery and Recoupment process
• Gathered requirements. Designed and worked provider EFT/ERA enrollment process.
• Work on EDI 835 Claim Payment/Advice

Confidential - Philadelphia, PA

Facets Systems Integration/Data Analyst Consultant Lead

Responsibilities:

• Worked on Provider, Membership, Accounting, Billing, Claims modules.
• Built claim load conversion process to Facets for new line of business.
• Claim pricing validation extensions.
• Claim denial validation processes.
• Built Provider360 web application using MS Studio.

Confidential - Virginia Beach, PA

Facets Extension application for benefit EDI

Responsibilities:

• Designed system to provide business the ability to modify EDI 270/271 product configuration, description and messages from a model product setup. The goal is to reduce number of configure hours across multiple product minimum as possible using Sybase, Microsoft SQL, TSQL, DTS, C#, VB, .NET tools, Crystal Reports, and DataStage.

Confidential - Philadelphia, PA

Data Architect/Systems Integration Consultant

Responsibilities:

• Lead team for Facets provider data conversion to new Provider Information Management System.
• Wrote inbound/outbound claim processes using Datastage, UNIX scripts, and Sybase/Oracle stored procedures.
• Worked on Facets batch jobs, Run books, error logs.
• Worked on Facets keyword files MMS, XPF, EDI transactions.
• Worked on Facets extensions.
• Built claim load process for CLMU batch.

Confidential - Philadelphia, PA

Facets Database/ Data Analyst Consultant Lead

Responsibilities:

• Technical lead charged with redesign of encounter claims processing system, reducing processing time from using Oracle, PL/SQL, SQL Loader, SQL Plus, Toad, VB, VB.NET, C#.
• Enabled member eligibility inquiry and claim status inquiry by developing socket listener interface for KMHP’s IVR telephony system and Facets claim processing application using HP/UNIX C, Sybase server, Facets application.
• Wrote Sybase stored procedures to retrieve data from Facets database application for Web interface member eligibility inquiry and Web interface claim status inquiry.
• Established Electronic Data Interchange messaging interface between Facets and Healthcare Data Exchange (HDX).

Environment: : Facets version 2.96 & 4.21, Sybase 12.0, Microsoft SQL 2000, TSQL, DTS, C#, .NET tools, Crystal Reports, Acesss, DataStage

Confidential

Software/Data Architect/Systems Integration Lead

Responsibilities:

• Leveraged complex DTS (ex. manipulation with VBScript) to import/export data to and from external customers within SQL 2000.
• Designing and developing real-time credit card system using C++, VB6, and MSSQL server.
• Prevented fraud by designing telephony fraud usage system using C++ and MSSQL server.
• Designed complex multithreaded real-time call engine for Callfx.com, initiating phone calls based on calendar, schedule, immediate mode, and batch mode from requests of telephony and Web interface using C++, MSSQL server, Oracle.
• Enabled conversion of different sound formats on demand to Vox, Asf, Ra for telephony and Web interface playback by designing CallFx.com, a voice conversion engine using Rhetorical and NeoSpeech text-to-speech engine and Voxstudio, developed massive database servers for CallFx.com using C++, VB 6.0, VB.NET, C#, Oracle.
• Initiated scheduled private calls to online members by developing Webfriend.com, a private call database with a multithreaded real-time private call engine, interfacing with Webfriend.com database and Dialogic call processing software using C++, MSSQL server, Oracle.
• Increased efficiency by designing telephony-Web interface for Ringingphone.com to relay SMS messages to cell phones using C++, VB 6.0, MSSQL2000 servers.
• Converted DNS server from Sun Solaris server to NT server by running Bind for NT software.
• Convert FTP server from Sun Solaris server to NT server running FTP server software for NT.
• Convert email server from Sun Solaris server to NT server running MS Exchange server.

Confidential - West Chester, PA

Software Engineer

Responsibilities:

:

• Developed and implemented real-time Management and User Interface (MAUI) for customized commercial video inserter to monitor video spot status, edit/parse schedules, trigger breaks, insert commercial video spots, and view logs for all TV networks using VB 5.0 and MSSQL 6.5 server.
• Reengineered and programmed Barker Access to devise and edit schedules and video previews for Barker video promotions using VB 5.0.
• Rebuilt and scripted control software to generate reports for systems phone home, extract system logs, upload schedule files, and upload video files to field machines using Perl, Informix, Access, and VB 5.0.
• Enhanced WorldGroup BBS C program source code by adding new features for field system phone home processes.
• Authored Retransmit Package Generator application to transmit video files via satellite to customers nationwide using C++.