Phillip J. Brown

256-***-**** \ abl889@r.postjobfree.com

PROFILE

Software & Database Development professional with an experienced and

flexible background in the healthcare and IT industries. I have

accomplished notable success with a broad range of corporate PC and

web-based software initiatives while participating in the planning,

analysis, development, and implementation of solutions in direct

support of business objectives.

CORE SKILLS

? Database Design & Development ? Software Engineering

? Project Management

? Leadership ? Software Implementation

? Business Process Analysis ? CA Clarity Customization

TECHNICAL PROFICIENCIES

Operating Systems: Microsoft Windows XP/2000/NT/98/95/Vista/Server

(NT-2003)

Database Software: SQL Server, MySQL, Oracle

Desktop Application Software: CA Clarity 8.1 - 12.x, Access, Word,

Excel, Power Point, Project, Outlook, Visio,

Adobe Photoshop, Macromedia Dreamweaver, Visual

Studio (All Versions), Primavera 5 Project

Manager, WinSTETs, MPM, MOSS 2007 and Windows

Sharepoint Services3.0

Programming Knowledge: ASP.NET, ASP Classic, Java, JavaScript,

Java Server Pages, VB, VBScript, VB.NET, C#,

C++/Visual C, HTML, SQL, T-SQL, NSQL, PL-SQL,

PHP, Perl

CERTIFICATIONS

MCITP: SQL SERVER 2005 DATABASE ADMINISTRATOR

MCITP: SQL SERVER 2005 DATABASE DEVELOPER

MCP

MCTS

IT EXPERIENCE

Ryder c/o Otterbase, Inc. 02/2010

- Present

Consultant

Business Intelligence (SSIS, SSRS)

. Develop, design and administer SQL Server 2005/2008 ETL

o Methods used: Stored procedures, Triggers, SSIS (Custom

ETL), Performance Tuning

o Created SSIS packages consisting of the following:

. FTP download of available file

. Multiple formats

o .csv

o .txt

o .xml

. Registering of files

. Inserting data in files into existing/new tables in

database

. Archiving files on FTP server

. Archiving files on local server

. Data merging

. Data transformation

. Error handling

. Configuration setup

. XML Tasks

. Import

. Correction Editing

. Transformation

o Languages: T-SQL, SQL

. Develop and design SQL Server 2005/2008 reporting solutions

o Methods used: Stored procedures, SSRS

. SSRS methods

. Report design

. Navigation options

. Creation / Use of datasets within data regions

. Creation of report models

. Dynamic properties

o Languages: T-SQL, SQL

R2 Consulting, LLC - Birmingham, AL 03/2009

- Present

Consultant

Database Implementation, Integration & Customization

. CA Clarity 12.0.0.5028 customization

o Develop Stored Procedures, Triggers

o Portlets and Drilldown Portlets

o Languages: T-SQL, PL/SQL, NSQL

o XOG

o Gel Scripting

o Installation and initial configuration

. CA Clarity 8.1 customization

o Develop Stored Procedures, Triggers

o XOG

o Portlets and Drilldowns

o Languages: T-SQL, PL/SQL, NSQL

. Clarity Modules

o Demand Management (Ideas)

o Resource Management

o Project Management

o Portfolio Management

o Financial Management

o Clarity Studio

. Flat file integration with Clarity via SSIS and SQL Server 2005

. Oracle ETL in to Clarity backend SQL Server 2005 utilizing SSIS

. Custom back-end development for MS Project Server integration with

client specific applications.

. SQL Server 2005 optimization and tuning.

. Oracle optimization and tuning for Clarity 8.1 - 12

. Software used during integrations include:

o Peoplesoft

o Primavera 5 & 6

o MS Project

o CA Service Desk

o MS Excel

o MS Access

Highmark Technology - Birmingham, AL 02/2008 -

12/2008

Employee

Senior Data Architect

. Develop, design and administer multiple SQL Server 2005 databases

for various web-based applications

o Methods used: Stored procedures, Triggers, SSIS (Custom

ETL), Performance Tuning

o Created SSIS packages consisting of the following:

. FTP download of available .csv file

. Registering of file

. Inserting data in file in to an existing table in

database

. Archiving file on FTP server

. Archiving file on local server

. Data merging

. Data transformation

. Error handling

. Configuration setup

. And more...

o Languages: T-SQL, SQL

. Integrate CA Clarity 8.1 with CA Service Desk at the database level

o Develop Stored Procedures, Triggers

o Portlets and Drilldowns

o Languages: T-SQL, NSQL

. Custom back-end development for MS Project Server integration with

client specific applications.

. Assisted with MOSS 2007 installation and backend configuration.

o WSS 3.0

Innovative Emergency Management - Anniston, AL 01/2007

- 02/2008

W-2

Database Development / Web Application Development

. Designed SQL Server 2005 database to house Quality Control data for

various web-based applications

o Methods used: Stored procedures, Triggers, SSIS, SSRS

. SSRS methods

. Report design

. Navigation options

. Creation / Use of datasets within data regions

. Creation of report models

. Dynamic properties

o Location: Anniston Chemical Demilitarization Facility

(ANCDF)

. Re-designed multiple web-based applications for different

functionalities and programmed them to work dynamically with

various SQL Server 2000 & 2005 databases.

o Languages used: T-SQL, ASP.NET, C#, VB.NET, ASP Classic,

HTML, VBScript, and JavaScript

o Location: ANCDF

. Key point-of-contact for SQL Server 2000/2005 database issues

submitted through Help Desk web-application

o Location: ANCDF

Foothill Technologies, Inc. - Piedmont, AL 10/2006

- 2/2008

Consultant

Software Engineering / Web Application Development / Database Development

. Performed as Project Manager during the development of the Software

Requirements Analysis and Software Design documents

o Was delegated responsibility for overseeing a team of 3

Software Engineers.

. Designed a web-based secure image repository application

o Database: SQL Server 2005

. Methods used: Stored procedures, Triggers, SMO

. Compliant with HIPAA and Sarbanes Oxley Act of 2002

o Languages used: T-SQL, ASP.NET, HTML, and C#

. Designed an apartment rental website geared toward college

communities and small towns

o Database: SQL Server 2005

. Methods used: Stored procedures, Triggers

o Languages used: ASP.NET, VB.NET, T-SQL, HTML

. Designed a rental property tracking site (co-project with

university)

o Database: Oracle 10g

. Methods used: stored procedures, triggers

o Languages used: PL/SQL, PHP

R & B Associates - Anniston, AL 10/2006

- 12/2006

Consultant

Website Development / Administration

. Developed ecommerce website

o Database: MySQL

o Languages used: SQL, ASP.NET, HTML, and C#

o Implemented with PayPal Payment system

Truckers Resource.com - Anniston, AL 1/2005

- 3/2009

Consultant

Website Development / Administration

. Complete re-design of multiple websites

o Search Engine Optimization

o Database: MySQL, SQL 2005

o Languages used: ASP.NET, C#, HTML, PHP, JavaScript, VBScript

HEALTHCARE EXPERIENCE

(Experience applicable to IT is in Bold lettering)

iMedNet - Piedmont, AL 11/2004

- 3/2009

Owner

. Performed specialized physician searches and fee schedule negotiations

for insurance companies, attorneys and other organizations

. Web Application Design & Development

o Database: MySQL

o Languages used: HTML, Perl, PHP, JavaScript, VBScript, ASP

Classic

Integrated Health Plan, Inc. - St. Petersburg, Florida

2004 - 2006

Hospital Contracting Consultant

. Negotiated contractual arrangements between IHP and assigned hospitals

and hospital organizations.

. Developed Access database to improve productivity, organize data

clutter and streamline monthly reporting requirements.

Concentra Medical Examinations - Dallas, Texas 2001 -

2004

Regional Manager of Network Development

. Developed and maintained a 10 state service area encompassing the

traditional Southeast United States as well as MD, DC, DE, VA and WV.

. National Lead for physician data compliance during conversion to new

intranet-based claims operation software.

Well Care HMO/ Staywell Health Plan - Tampa, Florida 2000 -

2001

Network Development/ Provider Relations Representative

. Responsible for development of and contracting with individual

physicians, large medical groups, PHOs and IPAs for commercial,

Medicare and Medicaid (Staywell) products.

Humana, Inc. - Tampa, Florida 1999 -

2000

Contract Specialist

. Responsible for contracting with Hospitals, IPAs, PHOs, Ancillaries,

and Physician groups for the Humana Worker's Compensation and

Commercial products in the state of Florida.

. Developed a contract management database in Access used in tracking

physician network development progress and re-contracting efforts for

the Humana Workers' Compensation division.

Evolutions Healthcare Systems, Inc. - Holiday, Florida March

- July, 1999

Network Development Coordinator

. Negotiated contracts with Hospitals, Independent Physician

Associations, Physician Hospital Organizations, Ancillary facilities,

and physician groups throughout the whole western region of the United

States.

Beech Street Corporation - Tampa, Florida 1998 -

1999

Managed Care Specialist

. Responsible for contracting, credentialing, provider relations and

maintenance of physicians, physician groups and ancillaries for

southeast U.S.

Columbia\HCA Louisiana Division - New Orleans, Louisiana 1997- 1998

Credentialing Liaison

. Responsible for the development of a market Physician Hospital

Organization (PHO) as a base for a larger statewide PHO rollout.

. Key participant in the creation and development of Credentialing

Policy and Procedures in accordance with current NCQA and JCAHO

standards.

. Designed and implemented an Excel-based spreadsheet management system

for credentialing 1,200 physicians.

GA Limited - Gretna, Louisiana 1996 -

1998

Independent Computer Consultant

. Responsible for creation of FoxPro databases designed to client's

specifications.

o Languages: FoxPro 2.5

Mental Health Network, Inc. - Metairie, Louisiana 1994 -

1996

Provider Relations Manager

. Managed department responsible for network development, credentialing,

provider relations for all states.

. Developed management auditing reports to more accurately track the

progression of credentialing analysts.

. Developed critical monthly utilization reports based in QuattroPro and

EZ Cap Report Writer. Maintained and created benefit structures in EZ

Cap software system.

EDUCATION

Jacksonville State University BS in Computer Science

- Bachelors Concentration: Software Engineering

- Minor: Mathematics

MS in Computer Science

- Masters Concentration: Computer Systems and Software

Engineering

References Available Upon Request

Contact this candidate