SENIOR BUSINESS ANALYST / MAINFRAME DEVELOPER

Versatile, accomplished, well-educated professional with an eclectic, multi-disciplinary background in legacy business applications, project management, and government systems. Fourteen years as systems analyst/programmer for healthcare claims processing, banking, and telecommunications firms. Ten years as manager, estimator, and co-owner of a construction firm.

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, Changeman,
• SARS (Storage and Retrieval System), SMS (Storage Management Systems), HSM (Hierarchical Storage Manager), JES, JES3, SDSF, IBM utilities

EXPERIENCE

Confidential, Garland, Texas 2009 - 2011
Caregiver For Father
Took extended sabbatical to provide full-time assistance to ailing parent who feared living in a nursing home. Father passed away in January, 2012. Now available for assignments nationwide, with no obligations except to a future employer.

Confidential, Fargo, North Dakota 2007 - 2009
Systems Analyst
Utilized COBOL, DB2, CICS, FTP, NDM, PVCS, and Remedy as lead mainframe analyst for: Medicare Part A claims; DRG/MCE releases; region mergers; Federal Employee Program (FEP) updates; standards and procedures; documentation. Trained in ITIL and HIPAA/PHI regulations. Assisted in Medicare Part B, PDAC and DME processing. Mentored junior staff members. Transmitted data via NDM to major CMS data centers.

Confidential, Watford City, North Dakota 2006 - 2007
Systems Analyst
Via teleconferencing and VPN, utilized COBOL, CICS, and DB2 in the development and maintenance of financial applications for a large insurance company (H.I.P.) based in New York City. Modified online claims programs to accept more claims lines. Modified programs to accept longer National Provider Identifier (NPI) number.

Confidential, Garland, Texas 2001 – 2006
Managed private investments. Advisor / money manager to family members with serious medical issues.

Systems Analyst / Consultant Assignments 1995 – 2001Confidential, Houston, Texas
During 28 month assignment, supported Check Processing Control System (CPCS) returned check and adjustment function using COBOL, CICS, DB2, TRIPS, SARS, MQ Series, APS, Accuity (Thomson) Infolink, LU 6.2, NDM, RACF, Viewdirect, and Pegasystems software. Assumed the responsibilities of an employee who was promoted to Executive Vice-President. Created and promoted Endevor packages using prodsubs. 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.
NDM’ed files between LPARs (e.g. from N.Y. region to Texas). 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 (checks for good DDA account number 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. Created purge reports. Utilized Pegaindex in online research.

Created ad hoc backup jobs, user and trouble reports, and periodic summaries. Created online lookup menus. Regression tested using a “time machine”.

Confidential. 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.

Confidential, 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.

Confidential, 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.

Confidential, 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.

Confidential, 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 development by a husband-wife programming team and completed it by myself.

Confidential, 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 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

Confidential University 
Master of Public Administration degree, major in City Management .
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 state jail standards for member jurisdictions of the East Texas Council of Governments in Kilgore, Texas.

Confidential University 
Bachelor of Business Administration degree, major in Finance (banking, investments, economics )

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

Confidential High School