Business Intelligence Analyst

TOM RENZ

Business Intelligence Analyst Profile

*****@*****.** • 719-***-****

LinkedIn • Aurora, CO

Accomplished Senior Developer with extensive IT experience and proven record of optimizing system performance and spearheading significant software upgrades. Excel at implementing strategic changes to enhance job run times and system capabilities, ensuring high client satisfaction. Equipped with robust skill set in developing, designing, and maintaining code, and talent for improving performance on existing processes. Demonstrated ability to learn new technologies and adapt to organizational structures and processes, ready to contribute as vital asset to forward-thinking teams.

Technical Skills

Programming Languages:

Python; PL/SQL; MicroFocus (MF) COBOL; Shell (Bash, Korn) Scripting; MSBI (SSIS, SSRS, SSAS, ETL); VB.Net (2003, 2005 & 2008); COBOL; COBOL II; XML; SQL; CI; Speedware; PowerHouse (Quiz, Quick, QTP, etc.); C; C++; RPG; Fortran; Reflection RCL; Transact; HP Business Basic; Basic; Protos; Pascal; Visual Basic (VB); EDI

Databases:

Oracle SQL; ProgreSQL; MS Access (SQL); MS SQL Server; IMAGE/3000; TurboIMAGE; IMAGE/SQL; ALLBASE/SQL; Sybase SQL, Sybase Open Client/Open Server; Star Schema, Snowflake Schema

Applications:

AMISYS Advance; AMISYS 3000; MSI; Macess; PM/PI System; FMS; SFD; MS Office Suite; HTML; JetForm; Fantasia; Reflection; Minisoft’s WS92

Hardware:

HP-UX; Linux Red Hat; HP3000; HP3000-9xx; HPe3000-9xx; HP9000-8xx; HP250 & HP260; Intel-based PCs; Apple; IBM-S360; Sun; XP512

Software:

SQL Developer, Suprtool; QEdit; SQL Server 2000; SQL Server 2005; V/Plus (View/3000); Omnidex (IMSAM, DataDex, OmniUtil, DBInstal, etc.); NetBase (Shadowing, Bridge, NBCTRL, NBDIR, NBSpool, Vista, etc.); Espul, Reveal; Adager; HPGlance (HPGlancePlus); Cluster/iX, Lund Tools (SOS, Performance Gallery, Defrag, etc.); Query; ISQL; VCS/3000; eChangeMan; NetIPC; NRJE; PTOP; High Availability Fail Over (HAFO); DBGauge; SPT/XL; Formation; FAX/3000; NPConfig; NMMGR; NetTool; MasterOP; Maestro; SpoolMate; Minisoft’s NP92; FTP; Samba; Telnet; Dictionary/3000; Rapid/3000, Appworx

Operating Software:

Linux, HP-UX, Unix, MPE/V; MPE/XL; MPE/iX; Sun OS; MS-DOS; Windows 3.1/95/98; Windows XP Professional, Window 1

Professional Experience

AXIOM Systems Inc, Frederick, MD

Senior Consultant

Mar 2012 — Jan 2024

Optimized AMISYS environment upgrades, including transition from version 6.5 (HP-UX) to 8.8.3 (Linux) for multiple healthcare clients. Streamlined maintenance and development of AMISYS-Advance programs. Enhanced job performance through strategic modifications. Spearheaded integration of Big/Little Endian variables within job processes. Innovated PL/SQL processes within job and shell scripts to facilitate user-driven updates with minimal future alterations. Oversaw creation of new jobs, processes, tables, and application codes to align with evolving healthcare standards and client needs. Reviewed unit testing, assigned tasks, and deployed adjustments per new procedure and diagnosis codes. Resolved defects and corrected issues in jobs, scripts, and COBOL programs during user testing.

●Improved job performance by implementing strategic changes, resulting in run time improvements of 40-95% across various processes.

●Played pivotal role in steering software upgrades to latest version, enhancing system capabilities and client satisfaction.

●Developed and maintained critical code, contributing to seamless implementation of ICD-10 and interfacing with external vendors.

●Supported EDI team in processing membership loads, adding vital Language & Race-Ethnicity fields to AMISYS membership tables.

●Drove conversion from AMISYS-Advance Release 3.2 to 6.4 by reviewing, suggesting changes, documenting support, testing, and preparing documentation for SIT environment transition.

●Led migration initiative from AMISYS-Advance 6.5 to 8.3 by owning review processes, recommending changes, documenting support, conducting testing, and preparing documentation for SIT environment transition.

●Refined SQL scripts to correct A10 record build issues, ensuring accurate member data loading and avoiding complex COBOL program alterations.

Automated DVD Vending Machines, Denver, CO

Senior Developer / Architect / Designer / Operations Manager

Jan 2009 — Feb 2012

Designed and implemented innovative DVD rental kiosk systems, overseeing development from conceptualization to deployment. Directed engineering processes, approving final product designs and compiling component lists for kiosk functionality. Developed and maintained kiosk software using VB.Net and SQL, enhancing user experience with various features, including title management, rental transactions, and trailer displays. Delivered remote support and training for kiosk operation and software integration. Ensured continuous software improvement, responding to customer feedback with timely bug fixes and feature enhancements. Spearheaded database management for MS Access, optimizing data storage and retrieval processes.

●Led transition of kiosk software from VB.Net 2003 to VB.Net 2005, and initiated upgrade to VB.Net 2008.

●Enhanced kiosk functionality with integration of touch screen monitors, RFID components, and dispensing units.

●Streamlined rental and purchase process, contributing to increased consumer satisfaction and kiosk usage.

●Upheld high standards of technical support, resolving issues promptly to minimize downtime.

Affinity Health Plan, Bronx, NY

Senior Programmer Analyst

Jan 2007 — Dec 2008

Led system conversions and programming support for key healthcare platforms, ensuring seamless transition of business segments to Facets system from AMISYS. Oversaw medicare claims processing while maintaining compliance and accuracy. Developed recovery processes for overpaid providers. Guided team members and fostered collaborative environment to drive process improvements. Designed and implemented interfaces between AMISYS and various document management systems to streamline data flow and accessibility. Engineered reconciliation processes for providers to manage outstanding claims. Identified and resolved issues with processing unique claims assigned to firm’s control number in CLP0100 and other processes surpassing program limits.

●Streamlined batch job processes, reducing run times and ensuring completion before critical system activations.

●Implemented email notification system for job summaries and alerts, improving communication and issue resolution.

●Owned production support, managing change requests and program enhancements to optimize performance.

Additional Experience

Senior Programmer Analyst, Anthem BC/BS, Denver, CO

Senior Programmer Analyst, Ochsner Health Plan, Metairie, LA

System Administrator / System Manager, Printpack, Inc., Atlanta, GA

Senior Programmer/Analyst, FirstCare, Austin, TX

System Administrator / System Manager, School Specialty, Appleton, WI

Application Support / Developer, Programmer, System Analyst, DBA, System Administrator / System Manager, Foundation Health Systems (FHS), Rancho Cordova, CA

System Administrator/System Manager, DBA, Systems Programmer, Presbyterian Healthplan, Inc. – Albuquerque, NM

Application Support/Developer, Programmer, System Analyst, DBA, System Administrator / System Manager, QualMed, Pueblo, CO

Senior Computer Systems Designer, Lockheed Martin – Enterprise Information Systems, Denver, CO

Programmer/Analyst, WestAmerica Mortgage, Denver, CO

System Manager, System Administrator, Operations Manager, Systems Designer, Programmer Analyst, Instructor, Denver Technical College, Denver, CO

Operations Support, Instructor, Parks College, Denver, CO

Education

Bachelor of Science in Computer Science

Regis University, Denver, CO

Associate of Science in Computer Science

Parks College, Denver, CO

Professional Training & Certifications

[PCEP-30-02] PCEP – Certified Entry-Level Python Programmer, Python Institute

Fundamentals of HPUX, Hewlett-Packard

Network and System Administration I, Hewlett-Packard

AMISYS Advance 2.0 Training, SS&C / On-the-job

Oracle 9i, 12, 19 / PL / SQL Training, Udemy / On-the-job

PostgreSQL DBA Training, Udemy

MSBI, SSIS, SSRS, SSAS Training, Udemy

AWS Cloud Training, The Cloud Bootcamp

Azure Cloud Training, The Cloud Bootcamp

Google Cloud Training, The Cloud Bootcamp

Oracle Cloud Training, The Cloud Bootcamp

MultiCloud Training, The Cloud Bootcamp

Contact this candidate