Insurance Manager

Summary

IT business systems professional with ** years’ experience working for a large corporation, huge not-for-profit foundation, and two state agencies. Experienced in a wide range of software and platforms.

Seeking a Business Analyst position with established company or foundation.

Business Systems

Financial/Insurance: Labor Distribution General Ledger (hereafter, LDGL), EFT, Medicare Part D, Life Insurance Billing, State Prescription Assistance Programs, Workers' Comp

Human Resources: Payroll, Employee Benefits, State Agency Recruitment, Employee Assistance Program, Equal Employment Opportunity

Technical Skills

DB Architecture: Relational, Hierarchical (IMS), Virtual Storage Access Method (VSAM)

DB/Data Source: PeopleSoft, SQL Server, SSMS, SSEM, IMS, MS Access, XML, VSAM, CSV, GDS

ETL/Reporting/BI: SAP Business Objects Web Intelligence, PeopleSoft Query Manager, SSRS, SSIS, DTS, Easytrieve, MS Excel, CA-Telon, SyncSort MFX, ISPF, IBM In & OutBound, SharePoint BI (lower tier), Excel Web Queries, Notepad++, Data Analysis Expressions (DAX)

Software: Java, VB.NET, Visual Studio 2008/2010, T-SQL, PL/SQL, JavaScript, Servlets & JSP, VBA (Access & Excel), Various Software Functions, WebSphere, VisualAge For Java, SAS

Mainframe: COBOL, MVS, TSO/ISPF, DOS/VSE, JCL, VSAM, CICS, SDSF, CA-Telon, Easytrieve

Misc: SharePoint 2007/2010/2013, InfoPath, Office 2010/2013/365, Remedy, SurveyMonkey, VSS

Experience

Senior Business Analyst (Contractor)

National Payroll Services @ Kaiser Permanente, Portland, OR, Oct. 2014 to Dec. 2016

PeopleSoft HR: Support for LDGL financial system; heavy Query Manager; develop and schedule new client reports; heavy ad-hoc reporting; assist clients in resolving payroll clearing errors; liaison between LDGL users and national departments; set criteria, examine and approve UAT; update mapping to interfaces and reports; update both system technical and functional documents.

SAP Webi: Remedy ITSM data mining for reports, dashboards and charts creation; analysis of data using business rules I encoded into variables; report origin data conversion via formulas and custom variables; create schedules.. Metrics on incidents, work orders, software releases and helpdesk service requests for National Payroll Services' business analysts.

Member of several projects: Job code family realignment; earnings codes consolidation; Windows 10 upgrade impact test team; department coordinator for Java Runtime Environment upgrade; LDGL transaction kick-outs evaluation.

MS Excel: Develop applications to generate payroll LDGL operations control records. Incorporate Excel Web Queries into workbooks as near dynamic data sources linked to SharePoint content. DAX, VBA, formulas & macros.

MS Access: Support Overpayment Tracking System; analysis of prior years' overpayment reasons; minor enhancements. Create DB to serve as repository for dispersed staff and supervisor direct reports information.

100+ DB record configurations for earnings, deductions, taxes and employee job codes.

Data analysis, cleansing, dimension settimg, parsing, derivation, modeling, mapping, and documentation.

SharePoint team site owner and developer. New pages, web-parts, navigation, work flows, and content queries. Create groups as needed; add/remove members.

Data extracts from SAP, PeopleSoft (general ledger, and payroll), Overpayment Tracking System, SharePoint (site content), Oracle mainframe (via SAS apps), for analysis, interfaces and reporting purposes.

SAS: Maintain, alter embedded queries for report-generating applications.

SQL Server Developer and Mainframe Programmer Analyst

Insurance, Oklahoma City, OK, Oct. 2006 to Nov. 2013

Create numerous custom reports using SQL Server Reporting Services (SSRS).

Create tables, SPs, triggers, jobs and schedules in SSEM and SSMS for Med Part D, and New Business.

Maintain stored procedures, DTS and SSIS processes. Convert Automate middleware into SSIS packages.

Reverse engineer discontinued document management software (Xics utility) using VB.Net.

Load 3rd party files, such as Peachtree Financial, into SQL Server after manipulation.

Load state prescription assistance program files of varying formats into SQL Server after cleansing & reformatting.

Implement new life insurance plans nto existing legacy systems. Heavy JCL test cycles for billing notices.

Member of modification team tasked with incorporating HP Exstream Document Management.

Medical Information Bureau request and response XML parsing with XQuery file shedding.

MS Excel: Develop process to getting endorsements approvals done quicker when implementing

Java Developer & IMS Mainframe Programmer Analyst

State of Oklahoma (Office of Personnel Management), Oklahoma City, OK, Nov. 1997 to Oct. 2006

Team leader for Oklahoma Agency Payroll System, IMS database system, from 2001 to 2006.

Development responsibilities for three targeted salary adjustments and two statewide pay raises.

MS Access: Maintain EEO, Carl Albert Public Internship Program, and employee assistance programs.

Develop and modify various mainframe reports using IMS COBOL and Easytrieve software for payroll nd EFT.

Develop Java applications to communicate with and operate optical mark recognition (OMaR) scanners, access master test key files, score job applicant tests, connect to IMS via IMS Connect and record score on mainframe.

Using WebSphere, create JSP and JavaScript supplemental questionnaire web applications.

Member of data-extraction team for legacy system to PeopleSoft HR conversion.

Data conversion team leader for the Oklahoma Classification and Compensation Reform Act of 1999.

Implement Series I savings bonds into payroll system. Create U.S. Treasury interface.

Extract, update and load flexible spending account reimbursements from Emp. Benefits system into payroll EFT.

Heavy system and data analysis for Y2K, legislative changes, interfaces, databases, and new IT mandates.

Develop guidelines for temporary staff for Y2K data-conversion efforts. Manual for CA-Telon report techniques.

System analysis and modification necessitated by pay raise for Oklahoma Univ football coach Bob Stoops.

Education

Oklahoma City University

Oklahoma City Community College

New Horizons Corporate Trainers

B.S., Business Administration

Computer Science major

Mastering Access, Advanced Access

SharePoint I,

SharePoint II

Certificates (Mar. to Sep., 2017 through TrainOregon; available upon request)

Data, Database Management and Miscellaneous

MS Access 2016 Advanced

MS Excel 2016 Statistical Analysis

MS Excel 2013 Advanced Operations

MS Access 2013 Advanced

MS Excel 2016 Data Validation with Power Pivot

SharePoint 2013 Power User

SAS Basics Training

MS Excel 2013 Financial Formulas

IBM SPSS Statistics Training

Miscellaneous

Oklahoma Office of Personnel Management.

Employee of the quarter.

Devised title of the quarterly Agency Payroll System newsletter, Payroll Matters.

Contributed articles to quarterly newsletter.

Member of charitable campaign committee having 186% increase over previous year's contributions.

Globe Life Insurance

Member of company's Feed the Children volunteer committee.

Member of company's Christmas choir.

U.S. Army, Special Electronics (1989 - 1992)

ASVAB score: 90

Battalion soldier of the month and quarter.

U.S. Signal Corps training brigade (Ft. Gordon, GA) safety-slogan creator

San Joaquin Valley College, Computerized Accounting (1988 - 1989)

Outstanding Scholastic Achievement: 91.7%

Contact this candidate