Dave Kooker Email & Phone Number

Hamilton, Waikato, New Zealand

Performing Business Analyst and Pre-sales role, ensuring clients get what they asked for fee-for-service projects. Document clearly and accurately the voice of the customer so it is conveyed to the developers allowing the IT needs are translated to meet the needs of Company-X clients. Analysis and time management is performed in an Agile environment.

Tauranga, Bay Of Plenty, New Zealand

Senior Programme Analyst for the Midland Health Region. Successful implementation of the Orion® Concerto Clinical Portal. Conduct workshops to compile and document business requirements (800+, all functionalities) and non-functional business for the new Clinical Workstation Portal implementation for the five Midland Region DHB’s. Conduct review and approval sessions of all collated requirements. Regional business requirements will be implemented via the Orion® Concerto Clinical Portal and other 3rd party solutions. Identify and mitigate business requirement gaps between the Orion® Concerto Clinical Portal and other 3rd party solutions reconciled against the regional business requirements. Collect locally utilised code sets and provide suggested solutions for regional use of regional standarised code sets (43 code sets in total). Documented existing process flows using Visio.

Brisbane, Queensland, Australia

Pursued a long-term break from employment to acquire Graduate level education (Masters of Business Administration) from Griffith University. Involved in the teaching of photography and sale of photography services for hire.

System Analyst & Business Analyst / Incepture Consultant for Blue Cross Blue Shield of Florida, Jacksonville, FL.Business Analyst for Service Organization and Eligibility Membership & Billing (EM&B). Researched and documented current & future state Service Organization and EM&B process flows to determine how to best integrate Siebel CRM into their business processes. Design, build, and load a new consolidated databases from databases to easily track eTool utilization & paperless invoice business practices resulting in improved comprehensive reporting and provide better decision making. Create prototype SQL queries for upper management reporting dashboards. Prioritize, Draft Business Requirement documentation for approval. Compiled Value Realization Plan (VRP - Six Sigma) for project funding and approval of Siebel CRM enhancements. Managed the PDSI migration of 105 users to Siebel CRM.System Analyst for the EDW (Enterprisewide Data Warehouse). Researched and sourced systems of record for many code sets, to include CPT4, ICD9, HCFA, DRG, and Sales Agent/Agency. Developed migration business rules, SQL code, and determined technical capability to migrate the source data to the EDW. Deliverables also included RUP documentation; Supplementary Specifications and Design Guidelines.Business Analyst for the Specialty Pharmacy Injectable project. Produced RUP 'Use Cases' utilizing Rapid Process Improvement sessions for review and approval. Researched and drafted; Problem Solving documents, Scope Documents, Business Vision Documents, and Value Realization Plan (VRP - Six Sigma) for project funding and approval. Researched and documented National Drug Code (NDC) data sources, process flow of claims, and target databases effected by the use of NDC's through out BCBSF. Researched and documented the use of NDC's in the 837 HIPAA Claims transaction and the 278 HIPAA Medical Clearance transaction through the Electronic Data Interfaces and claims processing engines.

Senior Programmer Analyst / Baywood Technologies Consultant for O.S.I. Information Systems, Jacksonville, FL.Responsible for developing and maintaining VMS BASIC applications/utilities/conversions for an 'in-house' developed Accounting and Debt Collection application. Created and maintained both in-bound and out-bound electronic data exchanges by files and transactions with new and existing business partners. Re-designed the payment processing and post dated check process.

Senior Programmer Analyst / A Prime Solution Consultant for Merrill Lynch, Jacksonville, FL.Responsible for developing and maintaining MUMPS applications/utilities/conversions for an “in-house” developed Agent Registration application. Create and maintain both in-bound and out-bound Agent & Broker electronic data exchanges by files and transactions with new and existing business partners.

Business Analyst & System Analyst / Matlen Silver Consultant for Blue Cross Blue Shield of Florida, Jacksonville, FL.Researched, designed, implemented the integration of two separate Intranet technology based applications, PIP (Provider Information Project) and the outbound document application ‘Client Letter’ Letter Generator. Data modeled and mapped the provider data to the Client Letter application. Created letters, letter variables, user workgroups, and complied & organized the PIP Client Letter user deployment to seven provider business units (175 end users) and the HIPAA Privacy unit.Performed system test of the data migration from the PIP application database to the PIP Operational database for reporting and outbound provider documents. Developed SQL queries to automate the system testing and full certification of data integrity from source to target.Developed numerous SQL AD HOC queries against the provider databases to perform research for legal, government agency compliance, and provider utilization departments.Researched, designed, implemented, data map, and performed User Acceptance Testing of Siebel Analytics reports.Research and find solutions on current data maintenance issues, most notably, synchronized Vendor/Provider data between three different databases.Researched and documented how HIPAA (Health Insurance Portability Accountability Act) XML transactions will flow through the propriety legacy systems and databases through ‘Gather And Discover’ and Physical Design phase review sessions.Researched and documented the source of and verification of ANSI codes sets in the BCBSF HIPAA transaction Electronic Data Interface.Team lead (9 individuals) for the 278 XML HIPAA transaction ‘Authorization and Certification’ & 270/271 XML HIPAA transaction ‘Eligibility and Benefits’ through the G&A phase review and physical design. Researched and documented the 835 XML HIPAA transaction ‘Electronic Remittance’.

Senior Programmer Analyst / O.S.I. Information Systems, Jacksonville, FL.Responsible for developing and maintaining VMS BASIC applications/utilities/conversions for an 'in-house' developed Accounting and Debt Collection application. Created and maintained both in-bound and out-bound electronic data exchanges by files and transactions with new and existing business partners.Performed data conversions of consolidated business partners data (documented assets) to “in-house’ data mapping specifications. Largest data conversion was worth 264 million dollars of business assets.

Senior Programmer Analyst / Baptist St. Vincent’s Health System, Jacksonville, FL.Responsible for coordinating and/or developing all mainframe and application support to the HMO, Mission Health. Developed site-specific applications and utilities through the Applications Enhancement System module (AES), which the IDX application was not designed to perform. Data modeled and created new databases from existing databases. Populated separated databases using HL7 transactions. Developed and maintained 13 electronic data interfaces to the IDX Enrollment Interface. Qualify future IDX releases for installment. Report, debug, and help IDX investigate software irregularities. Instruct and provide MUMPS system administration. Perform staff development how to program in the MUMPS environment.

Senior Applications Developer / Sunquest Information Systems, Tucson, AZ.Maintain and enhance current and future releases of two MUMPS based Database Report Writer Applications, FlexiSearch and M/SQL (MUMPS Standard Query Language). Data mapped entire Laboratory, Blood Bank, Anatomy Pathology, Patient Management, and Accounting databases. Design and develop company approved fee-for-service hospital site-specific laboratory software. Peer-review and approve co-worker-developed software. Provide highest level of customer support when client support has exhausted their resources.

Data Processing Manager / Estes Homebuilding Company, Tucson, AZ.Responsible for carrying through company assigned goals by project management and system design techniques. Provide hardware and software support to enhance productivity and maintain data integrity. Modified extensively all accounting phases of the MCBA/Metro COBOL written financial software. Data mapped the Job Accounting data files using WANG PACE Data Management System for AD HOC sales & marketing reporting.

Performed inventory of books, periodicals, microfiche, and archived materials.

Entered invoice data online for accounts receivable. Performed addition of product weights and spot checks of all invoices before entering online, printing and posting of transactions.

Performed technical maintenance to DEC mainframes and various Personal Computers to the circuit card level. Documented maintenance performed and schematics for future standardization. Built and routed cable networks to interface various types of platforms together. Left to pursue a degree in Business Administration. Possessed Top Secret/SBI Security Clearance.

Worldwide

MOS 26E, Performed flight line and shop maintenance on faulty aerial radar and heat sensing equipment utilizing state of the art electronic test equipment and detailed schematics. Possessed Top Secret/SBI Security Clearance.

Master Of Business Administration (Mba)

Bs, Business Admin

Cum Laude

As, Business