Sql Server Data

Patrick G. Hogan

*** ******** **., *****, ** ****0

864-***-**** abifio@r.postjobfree.com

SUMMARY

IS Professional with extensive experience including over 10 years as a

Systems Analyst and Development / Technical Team Lead. Multi-faceted

career developing and maintaining systems in mainframe and client-server

environments with some exposure to web technologies. Highly adaptable with

quick learning habits and a history of finding effective solutions.

Analysis, Project Coordination and Planning, Team Leadership, and Team

Building

. Analyst and developer for maintenance of Medicaid processing systems,

including extensive code analysis and test development. Consolidated

or added to existing documentation on ad hoc basis to support

analysis.

. Project analyst / coordinator in preparing for deployment a vendor

browser-based multi-tier application in a shared services environment,

including validation of rules table data being migrated from VSAM to

UDB/DB2. Created system diagrams for project planning and made

presentation to AVP-level on system capabilities.

. Analyst / development coordinator for installation and upgrade of an

enterprise class reporting system, as well as definition of tables,

validation of load results, query design, and complex reports

development. Created system diagrams for project

planning/implementation. Prepared detailed reporting server

installation guides.

. Analyst / lead on client/server projects involving project planning,

application and data architecture issues, implementation planning and

execution including data migration, assorted lifecycle documentation,

etc.

. Team technical lead supporting development and testing by onshore and

offshore web and report developers.

. Hardware/software evaluation and planning analyst for several

projects, primarily for database servers.

Software and Database Development and Support

. Maintained / enhanced mainframe Medicaid (MMIS) claims processing

system.

. Maintained / enhanced mainframe claims processing systems for major

insurers.

. Led planning / design / execution of distributed database development

for several projects, including database platform planning, database

access support, planning for data extraction and loading, etc.

. Completed documentation and compliance requirements for several

applications.

. Led / participated in design process for various applications,

including analysis, data design and testing.

. Led / participated in analysis, coding and testing activities on

various platforms using various languages and tools, including both

client/server and mainframe (batch and online).

. Led / participated in technical issue analysis, resolution,

troubleshooting and general support of various applications and

servers.

. Acted as development administrator for mainframe databases and in

setup of distributed test databases.

TECHNICAL AND METHODOLOGY SKILLS

Languages, packages, tools, methodology:

SQL (mainframe, client/server and desktop); COBOL (II) Batch & Online

EXEC2, CLIST, REXX JCL; RACF; Culprit

CICS Command Level, BMS

APS with MVS and MicroFocus COBOL; C/C++ training & exposure

MS Access, Excel, Powerpoint, Visio; Lotus Notes - some development

Visual Basic 6.0; Java, J2EE, JSP: training & exposure; Powerbuilder

Actuate eReporting w/Actuate Basic on Actuate Server 7; XML training &

exposure

Crystal Reports; SAS; Websphere App Dev training, exposure

Vantage insurance system; InterVoice IVR system

Saratoga Avenue CRM package; SDLC, CMM, OOA, OOP

Structured Analysis, Design, Data Modeling, etc.; Use Cases, Seq. Diagrams,

etc.

Remedy 5.0; Mercury Test Director

Development environments, editors, data systems, tools:

TSO (ISPF/PDF); Online - CICS; Batch - JCL, Endevor, Control-M/O/D

VM/CMS, XEDIT; MVS -- VSAM, FileAid, Xpediter, InSync

DB2 -- QMF, Insight/DB2, SPUFI; ProEdit; CA-IDMS; IMS

DB2/2; UDB/NT thru 8.1; Sybase 10, 11

MS SQL Server 7 and 2000 with DTS; Stored Procedures

SharePoint (user)

EDUCATION

Bachelor of Arts in English, The University of The South, Sewanee, TN

Numerous technical, business skills, and self-development courses and self-

training

EMPLOYMENT HISTORY

Clemson University Seneca, SC -- August 2008 to December 2009

Applications Analyst II

. Supported mainframe-based Medicaid claims system for the State of

South Carolina (MMIS); also exposed to the eligibility system

(MEDS) and handling of feeds coming in and out for providers and other

payors, and to the actual payment run process.

. Worked with various kinds and levels of claim adjudication changes

and corrections, including changes to eligibility codes and rules,

special program membership eligibility and payment levels, procedure

code handling, rules on procedure code frequency and

combinations, special surgical rules, procedure bundling, etc.

. Worked to implement or modify special state programs such as those

for extended coverage, e.g. the SCHIP program for newborn

care.

. Researched and clarified requirements written in varying levels of

detail, researching to determine what programs in the system needing

updating, the flow of data and adjudication logic, where and how data was

stored in the IDMS database etc.

., Made the necessary modifications and designed testing in

coordination with the State's Medicaid business team (DHHS),

generating test cases by a variety of means; executed the test cases

(usually via partial or complete claims adjudication test trails).

. Validated test results thru system output reports and examination of

output data files, as well as by viewing claims online..

. Used COBOL, JCL, IDMS (with screens in ADS), IBM utilities, SQL and

SAS; also used MS Access for data analysis including job schedule and

JCL member list reconciliation.

Management Decisions, Inc. Greenville, SC -- August 2007 to February 2008

Contractor

. Worked in mainframe production control, maintaining job and report

schedules and distribution using Control-M/O/D. Also learned CA-ESP

scheduling product to which client is converting. Used JCL and some

COBOL, TSO EXEC/CLIST and REXX, MS Access with SQL for data analysis

and validation.

Marketplace Staffing Services Greenville, SC -- May 2007 to August 2007

Consultant

. Worked with MS Access 2003 and Excel to analyze, transform, clean,

and report on parts sales data and common characteristics for a

consolidation project. Generally, data arriving from other sources was

staged in Excel, analyzed and transformed manually (including use of

filters etc.), and when in an appropriate state, loaded into Access

tables. Further analysis and modification was done in Access if

necessary using manual examination and queries. Then used Access query

and report objects to generate reports showing common patterns in

parts characteristics. After the business analyzed these reports,

tables were prepared with values indicating which parts were to be

eliminated or replaced by other existing parts. Then wrote additional

queries and reports to structure this data by customer and current

part number, showing the old and new components of parts assemblies,

along with the old and new cost, price and gross margin figures.

Because of the logic required (e.g., correlating old part numbers with

their replacements and also including unchanged parts in the report),

I had a series of nested queries to associate and array the data as

needed for the final report.

Heavy use of SQL joins, etc.

Core IT Staffing Columbia, SC -- July 2006 to March 2007

Senior Contractor

. Worked with JCL, Endevor, COBOL, APS, IMS, VSAM, DB2, CICS, SyncSort,

Eztrieve, MAX for development and maintenance of health insurance

processing systems. This involved analysis, understanding and working

with eligibility and claims data from various phases of the processing

cycles, locating change points in APS/COBOL and JCL, determining and

executing test cases, etc. Most extensive project involved tracking

the flow of optical data image records from various sources out of the

claims cycles and into and out of a common repository using a DB2

tables as the master index, with SQL for data validation, and

involving setting up of many data control checkpoints. Interacted

with analyst via Visio charts, etc.

Management Decisions, Inc. Greenville, SC -- April 2005 to June 2006

Senior Contractor

. Worked with JCL, Endevor, Control-M, COBOL, VSAM, DB2 with SQL

queries and updates, CICS, FTP, DFSORT, Eztrieve, InSync, Tracemaster

for development and maintenance of Supply Chain systems. This involved

understanding and working primarily with the tracking and analysis of

inventory and related data at various stages of the resource flow. The

most unique project involved scheduling of jobs to receive and forward

order data across disparate hardware/software platforms from points of

sale at various times during the day. Presented solution proposal to

interested parties for validation.

MetLife Greenville, SC -- to September 2004

Information Systems Consultant

. Led technical phases of project to implement a vendor product using

WSAD, J2EE/JSP, JDBC, DB2 Connect, DB2/AIX, DB2/MVS etc., in a matrix

environment, performing associated analysis, documentation, diagrams.

. Led technical phases of project to manage Actuate reporting server

(NT), using SQL Server 2000, DTS, MQ Series; developed system

diagrams; developed complex reports and coordinated testing; used MS

Access as a tool to capture SQL Server table data (containing

financial data for specialized life policies) for analysis and

prototyping. Used manual viewing, queries, reports to analyze the data

and at times for prototype data setup.

. Served as technical lead on integration of client/server databases /

processes with SQL Server 7.0/2000 using stored procedures, Avenue CRM

package, MS Access; this included using Access as a data staging tool

to extract, correlate, transform/clean, and update data from disparate

sources including csv files, Access tables, and SQL Server tables and

produce a financial data file for the datamart. This involved the use

of macros and queries to determine the data completeness and

integrity. Used Crystal Reports to generate reports from Access and

SQL Server databases.

. Helped lead planning/prototyping on a multi-platform integration

project involving mainframe COBOL, Clipper, a vendor insurance

package, and interfaced w/Java, MQ Series. Developed and presented

diagrams of proposed solutions.

. Assisted in development/support of a Powerbuilder/Sybase application.

. Developed and supported basic/intermediate Notes databases for

internal use.

. Led research and support of Visual Basic application development

issues: MDAC versions, VB data controls, UDB drivers; also assisted

with development of MS Access data entry applications using forms, and

other desktop development.

. Led maintenance of an APS/Microfocus COBOL app with a UDB/NT

database; made major performance improvements; worked with DBAs to

resolve database access issues. Developed system diagrams to

communicate with affected stakeholders.

. Led planning, design, implementation of an Interactive Voice Response

(IVR) system using vendor tools based on Smalltalk; set up DB2 and

OS/2 databases and transfer scripts in REXX; worked with telecom to

setup phone systems for callpaths, DNIS, etc.

. Led design/implementation of an APS/Microfocus COBOL application;

designed and supported DB2 and DB2/2 databases; wrote standalone and

APS COBOL programs, SQL; developed an APS interface to CICS that

utilized the CPIC interface over LU6.2 and supported underlying

workstation configuration; administered an IBM LAN Server and

workstations, and performing hardware/software planning and support.

. Supported various processing needs using dBase, Clipper, Q&A, and

COBOL.

Programmer/Systems Analyst

. Developed a CICS system for reconciling and applying payroll

deduction.

. Maintained and developed on Vantage mainframe system; and developed

companion systems, using COBOL, CICS/BMS, Assembler, TSO, VM.

. Assisted in design/development of a CICS health provider information

system.

. Performed various roles in support of mainframe systems (COBOL,

other).

Contact this candidate