PROFESSIONAL SUMMARY

• Business Analyst and Application Consultant with 15 years of professional experience.
• Well versed in business process engineering and software development life cycle to include analysis, design, development, testing and implementation of software applications.
• Exceptional presentation skills with a background in sales and marketing.
• Adaptable team player capable of serving as a leader or functioning as an individual contributor.
• Excellent at developing rapport with users and executives alike.
• Proven ability to integrate sales and marketing with technology.
• Experienced in delivering accurate and usable business intelligence to help managers and executives make informed decisions.
• Excellent analytical skills with a solid understanding of enterprise architecture.
• Skilled at bridging the gap between business process and software architecture to deliver effective solutions.
• Able to analyze a situation, define problems opportunities, and execute solutions in a changing environment.
• Skilled in learning systems very quickly and managing multiple projects simultaneously.

TECHNOLOGICAL PROFICIENCIES

• Dashboards, Analytics, Business Intelligence: Crystal Reports, Business Objects, and JMP Statistical Analysis.
• Database Tools: SQL Server 2008, Oracle, MS Access, Toad RDMS Console, XML, and SQL.
• Documentation Productivity Tools: Visio UML Design and Use Case Scenarios , MS Project, Excel, Word, and PowerPoint.
• Web Design Tools: Dreamweaver, Visual Web Developer 2010, Photoshop, CSS, HTML, VBScript, ASP, and ASP.NET

INDUSTRY EXPERIENCE

• Ag Equipment Finance: Designed and built managerial reports, dashboards, and month end statements for managers and executives across three offices and two counties for De Lage Landen Agri-Credit . These business intelligence systems deliver critical information in multiple languages for 200,000 equipment contracts, representing 1.5 billion in assets.
• Ag and Retail Banking: Developed and maintained the retail web presence for EBANK Earlham Savings Bank for over ten years. Created online auto loan application, online mortgage, and refinance application. Designed systems to help bank employees update frequently changing information on website quickly and easily. Worked effectively with banking Vice Presidents and staff to deliver a variety of solutions.
• Insurance: Designed marketing and sales system for estate planning seminars at National Investors in Redfield, Iowa. Attended and graduated from sales and marketing seminars at AEGON USA TransAmerican in Cedar Rapids.

PROFESSIONAL EXPERIENCE

Confidential

Project Manager / Business Analysis

• Project Management and Business Analysis for design and build of new case management system using Alfresco CMS and JSP.
• Coordinating the business needs and technical requirements between users and programmers.
• Establishing workflow and content data models to enhance productivity for state-wide offices.
• Responsible for complete software specification, working with end users, programmers, and administrators. Developing multiple use case diagrams to facilitate this new software build.

Confidential

Business Analyst/Application Consultant

• Consumer Credit Information Receivables System Application and Business Intelligence consultant providing assistance during the development phase of this program and serving as the key person for all Business Intelligence systems and data delivery systems. This system manages and maintains the principal and interest calculations for over 200,000 equipment invoices across multiple countries and languages.
• Performed GAP analysis between business processes and system features.
• Interfaced with business users to prepare and update functional requirements. Created test cases and test scripts for Unit Testing.
• Designed test plans and test cases for User Acceptance Testing UAT .
• Managed changing business requirements and project scope between three offices.
• Documented new system processes. Prepared user documentation end user training.
• Worked closely with local and remote managers to establish needs and deliver reporting systems.
• Collected requirements from Joint Application Development JAD sessions from three different offices Johnston, Toronto, Philadelphia and worked with managers to deliver timely business intelligence.
• Responsible for all statement and business intelligence quality assurance.
• Wrote extensive SQL code bringing together complex views to deliver the right information in real time.
• Designed and built business intelligence systems connecting Oracle, Crystal Reports, and Business Objects to report on business KPIs.
• Created various reports with Drill Down, Cross Tab, Master Detail, and Charts to make the reports easier to understand and analyze.
• Implemented key functionalities in reports such as Filters, Variables, and Schedules.
• Managed users and groups with Central Management Console CMC and assigned privileges to different members.
• Worked with executives to design and build dashboards to deliver line-of-credit information, payment history, and inventory turnover ratios in a graphical and easy to understand format.
• Worked on multiple committees as team leader and team member to collect user requirements, and distill the feedback into an effective message for the executive committee.

Confidential

Warehouse Process Flow Analysis Consultant

• Interviewed all executives, accountants, warehouse, and sales personnel to assess the functionality of their enterprise software architecture.
• Discovered bottlenecks between accounting, sales, and warehouse process.
• Provided recommendation to top executives for improving enterprise wide software performance and customer service.

Confidential

Business Analysis

Provided web, database, and marketing assistance to Central Iowa businesses as an independent consultant. Projects and roles listed below:

Confidential

• Worked as the internet business consultant for over ten years. Built and maintained the bank's web presence.
• Interfaced with staff and senior executives to deliver the banks online customer presence.
• Collected functional requirements and prepared business requirement documents for online loan system
• Analyzed requirements and translated results into design specifications.
• Developed use cases, workflow, screen mock-ups and documentation.
• Designed and implemented an online mortgage application for the origination of loans for refinance, construction, home equity, and new purchase.

Confidential

• Worked as an internet business consultant for nine years at Iowa's largest truck dealership. Built and maintained their online websites and assisted in creating customer database and direct mail programs.
• Designed and managed direct marketing campaigns to target truck purchasers.
• Designed and developed data driven website of new and used inventory.
• Created efficiencies in marketing and prospecting systems that saved time for sales staff and made the process of selling trucks easier.

Confidential

• Worked as consultant for five years helping Iowa's largest construction association connect members with technology to deliver services more efficiently.
• Interfaced with association staff to determine business needs and deliver software solutions.
• Designed and built full service web data application for association's members to access critical information.
• Designed and built event registration systems to interface with legacy systems.
• Built a searchable directory of member skills and services.

Confidential

• Worked as internet and database analyst to connect the inventory of this property management business to their target market.
• Conducted Joint Application Development JAD sessions with stakeholders to understand the apartment management business and their changing needs.
• Designed and built multi-tiered web data application that manages large amounts of information and multi-media files for apartment rental properties.
• Built system to deliver inventory reporting information across distributed offices.

Confidential

• Created systems and reports to help DART deliver claims information and business intelligence reports to managers and executives.
• Developed database application to interface between an existing SQL Server and a proprietary Medicaid submittal program used by the State of Iowa.
• Developed reporting application for the accounting department to track monthly operating expenses of 500 plus vehicles.

Confidential

• Worked to create a searchable web directory for Iowa's largest construction trade council that saved CIBCTC thousands of dollars in annual printing costs.
• Collected user requirements and established system goals.
• Created directory application for connecting contractors to their target market.
• Developed Member's only website for users to quickly and easily update contractor listings.

Confidential

• Worked to help this Central Iowa manufacturing communicate services to potential customers.
• Developed use case with UML for design of new product quoting system.
• Designed and built a marketing website that allows potential customers to upload specs and CAD files regarding plastic fabrication jobs.
• Designed and developed online employment application.

Confidential

Business Analysis

• Worked for Central Iowa's largest physician-owned multi-specialty clinic to develop systems to track important patient information and improve work flow.
• Defined business requirements and project objectives with client meetings.
• Created a patient management solution that tracks patient flow, reports physician referrals, interfaces with dictation software, and communicates to all segments of the Radiology Department.
• The program increased patient flow, reduced waiting times, and allowed the department to do more with the same or less staff.

Business Analysis

Confidential

• Worked with the Iowa School Cash Anticipation Program ISCAP to deliver system for tracking short term lending to Iowa school districts.
• Elicited and documented business and technical requirements.
• Responsible for all financial calculations, reporting accuracy, and business logic.
• Identified business calculation rules to deliver managerial and executive reporting.
• Worked in cooperation with users and programmers to create system documentation.

Area Sales Manager

Confidential

• Grew sales network from zero to fifty travel agency offices in two years.
• Travelled internationally to product shows developing supplier relationships.
• Designed business incentive travel packages for various corporations