Manager Analyst

BRUCE A. DAVIS

***** ****** ***** 972-***-****

OKLAHOMA CITY, OKLAHOMA 73162 ******@***.***

SENIOR BUSINESS SYSTEMS ANALYST / MAINFRAME DEVELOPER

Versatile and well-educated information technology professional with almost 20 years experience as a business

systems analyst/applications developer for large banking institutions, insurance companies, telecommunications

companies, and food distribution firms. Proficient in software development utilizing legacy skills including COBOL,

CICS, DB2, SQL, SPUFI, JCL, IDCAMS, VSAM, MVS, and TSO/ISPF. Holder of a bachelors degree in business

(finance major) and a masters degree in public administration (concentration in city management).

FUNCTIONAL SKILLS

• SOFTWARE DEVELOPMENT: Expert practitioner of SDLC including business requirements, functional specs,

technical design, coding, peer reviews, unit and systems integration testing, implementation, and production support.

Collaborated with DBAs in optimizing relational and hierarchical databases. Managed data conversions/migrations and

assisted in systems upgrades. Proficient in versioning controls, deployment tools, and change management packages.

Deployed high-volume, transaction-oriented online and batch applications in large scale multi-platform environments.

Performed 24X7 troubleshooting and debugging duties and expeditiously resolved problem tickets.

• FINANCIAL MANAGEMENT: Competent in financial applications, e.g. demand deposits, check adjustments, bank

reconciliations, job costing, billing, compensation, purchasing, accounts payable, and accounts receivable.

• ORGANIZATIONAL ACUMEN: Proficient in estimating, planning, and prioritizing project tasks and completing

deliverables on schedule, within budget, and in conformance with standards and specifications. Assisted in training end

users and mentoring junior staff. Executed change requests and produced timely ad hoc and status reports.

TECHNICAL SKILLS

• LANGUAGES: COBOL II, SQL, QMF, SPUFI, Pacbase, Microfocus COBOL, Visual Basic

• DATABASES: DB2, IMS, Access, Informix, Datacom DB

• OTHER TOOLS: CICS, JCL, VSAM, TSO, CA-7, MVS, ISPF, File-Aid, Abend-Aid, Smarttest, Expeditor,

Remedy, Intertest, NDM/Connect Direct, FTP, Excel, Word, Outlook, Visio, Easytrieve, Panvalet, Librarian, UNIX,

Endevor, APS, MQ, IDCAMS, RACF, Iceman, Icetool, Syncsort, Opcon, PVCS, Infopac, Serena Changeman,

SARS (Storage and Retrieval System), SMS (Storage Management Systems), HSM (Hierarchical Storage Manager),

JES, JES3, SDSF, TMON, Powerbuilder, Platinum utilities

EXPERIENCE

State of New Mexico, Human Services Dept Santa Fe, New Mexico 2013

Applications Developer

Utilized COBOL, CICS, MVS, VSAM, JCL, DB2, SPUFIs, MS Excel, MS Word, MS Outlook, FTP, NDM, File-Aid,

and Platinum tools in support of application development and maintenance of child support enforcement software for

the state Human Services Department. Provided 24X7 on-call support and troubleshooting for daily CICS cycles and

nightly batch cycles. Developed electronic legal forms used by child support enforcement division staff at 17 branch

locations throughout New Mexico. Received basic instruction in CA-Gen programming and methodology.

Family Caregiver Garland, Texas 2009 - 2012

Caregiver For Father

Took extended sabbatical to provide full-time assistance to elderly, widowed parent who feared living in an assisted

living facility. Father passed away in 2012.

BlueCross BlueShield of North Dakota Fargo, North Dakota 2007 - 2009

Systems Analyst

Utilized COBOL, DB2, CICS, FTP, NDM, PVCS, Serena Changeman, and Remedy as lead mainframe analyst for:

Medicare Part A claims; DRG/MCE releases; region mergers; Federal Employee Program (FEP) claims processing and

module updates; standards and procedures; documentation. Trained in ITIL and HIPAA/PHI regulations. Assisted in

Medicare Part B, PDAC and DME processing. Mentored a staff member from India and a staff member fresh out of

college. Transmitted data via NDM to major CMS data centers.

CrossUSA, Inc. / HIP Health Plan Watford City, North Dakota 2006 - 2007

Systems Analyst

Via teleconferencing and VPN, supported the integrated claims processing system (QCARE) of HIP Health Plan, a

New York based insurer with 4 million subscribers. Modified and tested professional (CMS1500) and facilities

(UB04) online/batch claims adjudication modules and JCL. Installed Claim Check in test region. Modified modules to

expand facility level of care beyond 99 lines. Modified modules to allow QCARE to change In Network to Out of

Network. Modified modules to accept longer National Provider Identifier (NPI) number. Monitored financial batch

cycle and reporting. Utilized COBOL, DB2, CICS, JCL, VSAM, FTP, File-Aid, Eztrieve, Expediter, and Librarian.

Private Investor / Family Caregiver Garland, Texas 2001 – 2006

Managed private investments. Advisor / money manager to family members with serious medical issues.

SYSTEMS ANALYST / CONSULTANT ASSIGNMENTS 1995 – 2001

Client: JP Morgan Chase Bank Houston, Texas

During 28 month assignment, supported Check Processing Control System (CPCS) returned check and adjustment

function using COBOL, CICS, DB2, Visual Basic, IMS, TRIPS, SARS, MQ Series, APS, Accuity (Thomson) Infolink,

LU 6.2, Endevor, NDM, RACF, Viewdirect, and Pegasystems software. Assumed the responsibilities of an employee

who was promoted to Executive Vice-President. Migrated data to a UNIX platform. Performed Y2K remediation and

24X7 troubleshooting duties. Resolved “suspended” check errors and returned items (e.g. incorrect read by sorter; out

of balance batch tickets; missing items; missing bundles; non-negotiable items; detail records which didn’t match

summary records) from Texas and New York LPARs, and posted the results to each region’s DDA and General

Ledger. Developed online reports showing return item “Fed Class” codes (G/L account; transmit date; transmit

amount). Modified end-of-day general ledger reconciliation workflow, expediting the adjustment of New York and

Texas returned items, formatted by PEGA. Created DDA Account conversion program which verified good DDA

account numbers from “heritage” system. Managed DASD space availability and cached records using PEGA Reelay

“trace analysis”. Worked closely with Pegasystems Workflow Administrators in resolving (purging/caching)

segmented files.

Client: Brookshire Grocers, Inc. Tyler, Texas

Utilized COBOL and Datacom in the development of financial modules for invoice, purchase order, and accounts

payable systems upgrade at a supermarket chain with more than 150 stores. Coordinated systems testing with end

users.

Client: Healthmarkets (formerly UICI, Inc.) North Richland Hills, Texas

Supported subsidiary operations (PMSC and Insurdata) and NASE claims processing.

Developed online CICS inquiry screens for health insurance claims and billing applications using DB2, SQL, COBOL

II, Infopac, DMS, Icetool, and Novell Netware. Created remote stored procedures to pass data from mainframe to

Powerbuilder. Performed Y2K remediation. Created ad hoc reports which: calculated premiums, commissions, and

updated general ledger; updated accounts payable and membership files. Modified reports pertaining to:

detailed/summary policy information file; open enrollment; policy lapse; returned items processed; new accounts for

premium by state/city/zip code.

Client: Halliburton Energy Services Duncan, Oklahoma

Developed online and batch IMS / DB2 / SQL modules for human resource compensation systems.

Produced: plan year payment reports; a DB2 program for calculating employee bonuses; an online maintenance

process for employee participation in HMOs.

Client: Texas Instruments Dallas, Texas

Developed human resource compensation applications. Tested and migrated purchasing system to an outside vendor.

Developed and tested DB2 / IMS / SQL applications driven by contract expiration dates.

McLane Company Temple, Texas 1994 – 1995

Systems Analyst

Project leader at a major wholesale food distributor serving more than 50,000 customers nationwide. In cooperation

with a business analyst (who is now Director of Applications Development at McLane), developed batch and online

CICS / DB2 / Pacbase sales and inventory pricing-rules systems modules. Converted, tested, and migrated periodic

sales information from mainframe to a UNIX / Informix platform. Took over a complex online project in early stage

of development by a husband-wife programming team and completed it by myself.

Hewlett-Packard (formerly Electronic Data Systems) Plano, Texas 1990 – 1994

Systems Engineer

For Blue Shield of California Account in Sacramento, California - Collaborated with business analysts in

development of design and functional specs for major claims system upgrade. Improved batch claims workflow at

service centers throughout northern California. Developed voice response system for healthcare providers.

For Strategic Banking Systems (SBS) Account in Plano, Texas – Designed, coded, tested, and maintained online / batch

Pacbase applications supporting a demand deposit account service-charge analysis function used by corporate staffs at

Bank One (now Chase Bank) and Norwest Bank. Trained in DB2, SQL, Pacbase, and IMS.

For AT&T Account in Bedminster, New Jersey - Developed test scripts, modules, and user requirements for the Rated

Message Verification Project (RMRVP), a long-distance telephone billing project which recouped $2 million in

missing revenue. Produced code runbooks, coordinated production runs and Change Service Requests (CSRs) with a

regional processing center (RPC) in Alpharetta, Georgia. Used GENTRAN system to port EDS code to the RPC.

Created: ad hoc summary programs:Easytrieve programs; scrub procedures and file fixes; and message

validation/splitter jobs. Installed LDS (Long Distance System) releases and updated the AT&T Exchange Message

Interface (EDI) standards document. Designed, tested, and implemented an Informix / Unix-based application which

tracked missing long distance calls.

For Phase II Training in Plano, Texas - Graduated from rigorous curriculum in legacy system skills including

COBOL, CICS, VSAM, Assembler, JCL, File-Aid, and Abend-Aid. Received instruction in SDLC methodology.

EDUCATION

University of Texas at Arlington Arlington, Texas

Previously enrolled in Master of Computer Science degree program. Courses included Pascal, C, Discrete

Mathematics, and VAX. Left academic program to join Electronic Data Systems (now Hewlett-Packard Enterprise

Services) on a Blue Shield of California assignment in Sacramento, California.

University of North Texas Denton, Texas

Master of Public Administration degree, major in City Management (Hatton W. Sumners Alumni Scholar; GPA: 3.5).

Scored in top 10% nationally on Graduate Record Examination. Produced a demographic projection/analysis for the

Planning Department of the City of Denton, Texas. Produced an analysis of newly enacted Texas jail standards for

member jurisdictions of the East Texas Council of Governments in Kilgore, Texas.

Southern Methodist University Dallas, Texas

Bachelor of Business Administration degree, major in Finance (banking, investments, economics; GPA: 3.4).

Control Data Institute Dallas, Texas

Graduated Summa Cum Laude (coursework included COBOL, CICS, JCL, VSAM, and DBase).

Garland High School Garland, Texas

Graduated 11th in class of 620. Member, National Honor Society and Mu Alpha Theta Math Club.

Contact this candidate