WRP - Dan Hansen

Dan Hansen

Professional Summary
    Extensive Software Development, Business Analysis, and Project Management experience in the Publishing, Health Insurance, Government, and Banking industries. Proven ability to manage sales and distribution, perform layout and edit publications, manage software development projects, supervise software developers, and develop project plans, functional specifications, system design specifications, program specifications, test plans, and test scripts.

Software Technical Expertise
    Microsoft Word
    Microsoft Excel
    Microsoft Access
    Adobe PhotoShop
    Adobe PageMaker
    COBOL
    Rational RequisitePro
    Rational TestManager
    Rational Clearquest CASE tools
    System Development Life Cycle

Professional Hilights
    White River Productions, Inc., Bucklin, MO, 2004–present. Marketing and sales director, database management, and packing and shipping supervisor.

Database Design and Operations Manager
    Responsibilities include gathering and meeting customer requirements, importing address and mailing data, reformatting data for USPS specifications, maintaining membership databases which includes data entry, membership check processing (lock box), interfacing with directors of historical societies, and performing regularly scheduled backups.

Mailroom Operations Manager
    Responsibilities include managing mailroom employees. Ensure that US Postal regulations are met.

Sales Manager
    Responsibilities include cold-calling customers, managing customer accounts including accounts receivables and accounts payable, managing advertisement images and text, receiving and fulfilling product orders.

Document Imaging and Scanning
    Responsibilities include overseeing employees, performing image scanning, document storage and retrieval, retouching images and pre-press preparation, final pre-press document proofing, proof reading.

Regence Blue Cross Blue Shield of Oregon, Portland, OR, 1999–2003
Team Lead/Business Analyst
    Served in the Information Technology Department whose mission was to convert from a Legacy Mainframe Based System to a Client Server Based System, a multi-million-dollar project. Ran projects designed to extract data from FACETS database and forward it on to the legacy general ledger, claims processing, and cash disbursement systems. Both came in on time and within budget. Created functional requirements and system design specifications based on interviews with the Finance Department Business Unit and Maintenance Programmers. Developed program specifications and test plans. Implemented and performed acceptance testing. Led team of two programmer analysts and offshore coders to create file extracts from FACETS database and forward it to the five departments in the appropriate data format. Developed project charter, functional requirements, system design specifications, reviewed program specifications, developed and reviewed test plans. Delivered system to integration test team for testing. Led a team of programmers and acted as the liaison (business analyst) to various business units on a project that continued to develop and then to maintain a meta-data tracking system. The system captured information about data fields within the legacy mainframe system using results from the Year 2000 project. Information was then used in the conversion project.

Quality Assurance
    Served on two-person team to review more than 60 functional specifications and system design specifications for the Application Architecture Team in order to improve the quality by ensuring a more effective translation of business needs into project specifications. Made recommendations to management on whether it was feasible to correct discrepancies or the project should be discontinued. Developed and maintained system design and data flow diagrams in the project information database using Visio 5.0.

Training and Development
    Rational Suite of Tools: RequisitePro, TestManager, Clearquest. Utilized Business Analyst experience to determine appropriate data fields and set up the Rational RequisitePro database, working directly with the vendor. Implemented the system by training 25 Lead Analysts and Business Analysts. Installed the application on their desktops, leading them through the process. Provided one-on-one training on the system, and how to load business requirements into the system. Served as their customer support, coaching and mentoring them throughout the process.

Software Testing
    Served on seven-person Integration Test Team that tested various applications in the post-development phase to determine the suitability of the new membership and claims system. Developed and implemented test scripts using Rational TestManager based on pre-determined business functional requirements. Provided feedback to development team about testing errors and logged testing errors as incidents into Rational Clearquest.

Providence Health Plans, Beaverton, OR , 1996–1999
Senior Systems Analyst
    Served in the Information Services Department of a health insurance company with approximately 750,000 members. Ran projects that extracted membership and claims data from the AMISYS database and forwarded to various external organizations and internal supporting databases. Extracted membership eligibility data, forwarded it to the ID card vendor and worked directly with the vendor to solve data formatting issues and data transmission volume issues, and set up delivery schedules. Extracted membership eligibility data and forwarded it to the IVR database, working with database analysts to determine data formatting requirements. Coordinated with Washington State Health Care Authority, Health Care Finance Administration, Cigna Health Insurance Company, Central Oregon Independent Physicians Association to facilitate the exchange of member eligibility and claims data. Provided programmer/analyst skills to the company wide accounting and provider conversion effort. Analyzed business requirements, developed functional and system specifications, developed programs and test plans to convert the Surecare accounting data to the AMISYS database. Developed and maintained a provider identification number cross reference database in ACCESS for Provider Relations Department in order to ensure a smooth conversion of provider data from one database to another. Ensured that the Health Plan's programs and databases were Year 2000 compliant and completed the task on time and within original estimated budget. Provided on-call support for the daily batch process.

US Bancorp, Portland, OR, 1995–1996
Business Analyst III
    Served on the Convenience Banking Team that developed web-based banking and ATM machine software for a large financial institution. Worked on a project to develop a system for the Customer Service Department that was used to manage customer's internet logon identifications and passwords. Provided research including a feasibility study and cost benefit analysis to gain project approval for the internet banking project. Gathered requirements through interviews with the Customer Service Department and developed functional specifications to meet those business requirements.

Bonneville Power Administration, Portland, OR, 1988–1995
Senior Systems Analyst
    Served in the Materials and Procurement Division as a contractor at the Department of Energy Western Regional Headquarters. Worked on a project that provided the business process model of transmission line material and procurement processes to the head of the materials and procurement division. Interviewed procurement analysts, engineers, construction project leads, and other personnel in order to develop dataflow diagrams and the business process model using CASE tools. Recommended changes to the tower steel procurement and inventory process that saved $1.2 million for each transmission line constructed. Served as a programmer on a team that developed a time keeping and work reporting application that automated the tracking and reporting of hours worked of contract trade union personnel. Served in the Materials and Procurement Division as a contractor at the Department of Energy Western Regional Headquarters. Supervised a team of programmers, analysts and technical writers that developed systems to support the Materials and Procurement Division. Developed software that tracked shipping manifests and generated state mandated reports for the materials handling department that saved 3 person-hours per week.

Pacific Union Conference of Seventh-day Adventists, Westlake Village, CA, 1982–1988
Programmer Analyst
    Served in the Information Technology Department, a three person operation, for a five state regional office that managed individual trust funds of over $95 million. Provided development, implementation, maintenance and support of software systems. Produced an accounts payable system where the check writing and reconciliation was reduced from 2 days per month to 3 hours per month. Developed and maintained a financial statement writing system saving 160 man/hours per year. Ran software that produced the mailing labels for a monthly magazine and shipped them to the off-site print shop. Served as operations manager for 6 months with duties that included troubleshooting user problems, running daily batches, on-call support, maintaining computer room inventory, serving as backup for data entry staff, replacing disposable printer parts and running cables to new terminal locations.