Vickie Vogt-O’Malley

***** ****** *** **********, ** 80020

720-***-**** Email: adzdsl@r.postjobfree.com

Experienced IT Professional with extensive expertise in application software support, development, programming and Oracle, Essbase and DB2 data warehouses.

Areas of Expertise

Healthcare field to include HL7 messaging Application Software Support. - Teletracking, STAR, etc

Systems Analysis Computer Systems Management.

Computer Programming and Custom Programming Administering Hyperion Essbase Databases

Oracle Data Warehouses DB2 Data Warehouse.

SQLPLUS & SQLLDR Data Requirements Gathering

Needs-Research and the Implementation of Computer Systems. FACETS Claims System Data Knowledge

Business Objects – Webi and Deski applications Informatica

CSR Ticketing Systems such as TFS, CRM, JIRA, ServiceNow

Systems/Operation Software Knowledge: IBM RS6000 Systems, IBM PS2 Systems, PC LAN Systems, Unix Servers, IBM VSE & MVS Systems, SQL Servers, Web Based Applications.

Programming Languages: COBOL, Macintosh Word Processors, Excel, Word Perfect, Microsoft Works, Unix, JCL, EasyTrieve, PL/SQL, SQLPLUS, SQLLDR, Adobe Acrobat, C-Shell scripts, TOAD, Hyperion Essbase, Hyperion BI Tools.

Professional Accomplishments

In the top four analysts for case closures 98% of the time each month.

99% success rate of maintaining warehouse daily SLA.

98% resolution of user issues within 1-2 hours.

Performing Hyperion consolidation process for accounting department to include consolidating data, running extract programs, validating extracts and verifying totals between Hyperion and the mainframe warehouse each month within set schedule and SLA 98% of the time.

Ensured successful execution of daily production loads to the ORACLE data warehouse through SQL procedures and SQLLDR using c-shell scripts meeting SLA 98% .

Automated load processes using crontabs improving load efficiency by 20%..

Ensured daily maintenance and support for the data warehouse application software package using DB2 commands meeting SLA 98%.

Maintained existing and developed new COBOL programs for loading data to the warehouses meeting project deadlines 99%.

Successfully upgraded software packages and data warehouse support tables with 2% error ratio.

Administering security ids and access requests within 2 hours of request approval.

Designed, developed, and tested new Essbase database structure for computer upgrade to Oracle project within project deadlines.

Developed complete documentation for execution process of loading and validating the Essbase database warehouse.

Developed new SQL procedures and c-shell scripts for loading data to the Oracle warehouses

Created error resolution documentation and logs for solving user issues.

Worked on new development projects to include designing table layouts and loading data to new tables for the warehouse in both COBOL/JCL and SQLPLUS/C-Shell scripts.

Researched data problems and developed, tested and executed fixes with 97% success rate using SQLPLUS..

Successfully tested and installed new versions to vendor software packages

Continued Vickie Vogt-O’Malley, pg. 2

PROFESSIONAL EXPERIENCE

Application Analyst Antero Resources Denver, Colorado 2023 – current

Provide Level 2/3 support for the Accounting and Land applications to include Enertia, OpenInvoice, AFE, Docvue, Excaliber.

Maintain documentation in appropriate tracking system while adhering to prescribed escalation and change control procedures.

Participate in the verification of the systems after the monthly maintenance/patches and software upgrades.

Writing up runbooks for the production applications.

Writing up Documentation for the setup of servers for the Enertia upgrade project.

Tech Lead Tech Mahindra Broomfield, Colorado 2022 – 2023

Provided Level 2/3 support for day-to-day production issues of the STAR healthcare application.

Maintained documentation in appropriate tracking system while adhering to prescribed escalation and change control procedures.

Participated in the installation of maintenance/patches and software upgrades.

Application Analyst I Catholic Health Initiatives . Englewood, Colorado 2018 – Current

Provide Level 2 support for day-to-day production issues maintaining documentation in appropriate tracking systems while adhering to prescribed escalation and change control procedures. Support Healthcare applications such as Teletrracking, STAR, Rev Runner, MCG, Paragon, Rightfax, etc

Completes assigned tasks as per defined project scope, timelines, and budgets for implementations. Works to prescribed methodologies for all project implementations. May work on multiple implementations at any given time

Participates in the installation of maintenance/patches and software upgrades.

Assists in documenting business and system processes and procedures through the use of industry standard process flow and flow charting techniques

Application Administrator LenderLIve . Glendale Colorado 2017 – 2018

Conduct initial troubleshooting of data issues, configuration issues and workflow issues for JIRA software.

Document problems and resolution in ticketing system.

Set up new projects, user security, process flows in JIRA software.

Provide daily support to users of applications.

Technical Support Specialist HMS . Longmont, Colorado 2016 – 2017

Conduct initial troubleshooting and resolution of data issues, configuration issues, and import issues on clients’ systems.

Communicate resolutions of client issues to Support staff.

Assign TFS ticket to appropriate developer if issue is a bug.

Document problem and resolution in appropriate tracking system.

Communicate customer status, concerns and issues to appropriate account manager, management, and support personnel when situation warrants.

Perform QA Testing of the Web based application as needed.

Set up client environments, to include database tables and web code, as needed.

Technical Support Coordinator HMS . Longmont, Colorado 2015 – 2016

Create support tickets for client issues and assign to appropriate developer for resolution.

Create weekly reports for clients regarding their open issues.

Conduct weekly meetings with clients to review open issues.

Serve as liaison between developers and clients for communications regarding open issues.

Document problem and resolution in appropriate tracking system.

Continued Vickie Vogt-O’Malley, pg. 3

Communicate customer status, concerns and issues to appropriate account manager, management, and support personnel when situation warrants.

Application Support Analyst McKesson Corporation . Westminster, Colorado 2011 – 2015

Provide and coordinate application and technical support for assigned customer installations.

Conduct initial troubleshooting and identification of base software application defects.

Assign problem to appropriate applications analyst for further quantification when necessary.

Coordinate activities of other support personnel during problem resolution while controlling customer expectations.

Document problem and resolution in appropriate tracking system.

Communicate customer status, concerns and issues to appropriate account manager, management, and support personnel when situation warrants.

Systems Analyst InfoPrint Solutions Company . Boulder, Colorado 2008 – 2011

Developed complete documentation for execution process of loading and validating the Essbase database warehouse.

Created error resolution documentation and logs for solving user issues.

99% success rate of maintaining warehouse daily SLA.

98% resolution of user issues within 1-2 hours.

Administering security ids and access requests within 2 hours of request approval.

Performing Hyperion consolidation process for accounting department to include consolidating data, running extract programs, validating extracts and verifying totals between Hyperion and the mainframe warehouse each month within set schedule and SLA 98% of the time.

Designed, developed, and tested new Essbase database structure for computer upgrade to Oracle project.

Sr. Programmer Analyst II Great West Life & Annuity . Englewood,Colorado 2003 – 2007

Ensured successful execution of daily production loads to the ORACLE data warehouse through SQL procedures and SQLLDR using c-shell scripts meeting SLA 98% .

Developed new SQL procedures and c-shell scripts for loading data to the Oracle warehouses.

Coded, tested and installed changes to COBOL/JCL mainframe programs and SQL procedures.

Automated load processes using crontabs improving load efficiency by 20%..

Worked on new development projects to include designing table layouts and loading data to new tables for the warehouse in both COBOL/JCL and SQLPLUS/C-Shell scripts.

Researched data problems and developed, tested and executed fixes with 97% success rate using SQLPLUS..

Successfully tested and installed new versions to vendor software packages

Sr. Programmer Analyst I Great West Life & Annuity Englewood, Colorado 1999 – 2002

Associate Applications Programmer Analyst McKesson Corporation Dubuque, Iowa 1997 – 1999

Associate Product Support Analyst McKesson Corporation Dubuque, Iowa 1994 - 1997

Education

B.S. in Computer Science - LORAS COLLEGE . Dubuque, IA

Dubuque Senior High School – Dubuque, IA

Skills Training

Hyperion Interactive Reporting Training

PL/SQL Training.

DB2 Administration Certification Training

AIX Administration Training.

Contact this candidate