John A. Weber, PMP

Senior Project Manager and Business Analyst / Technical Writer

Professional Resume JAWConsulting@comcast.net

Objective: A critical role in business operations that will emphasize my experience, technical knowledge, communication skills and project management acumen to transform technical and business ideas into deliverables within the healthcare, manufacturing or service arenas.

Summary: Colleagues refer to me as �one that gets the job done�. A strong business mind with attention to details involving technical writing, project management, systems analysis, and mentoring / advising focusing on taking the impossible and making solutions possible!

Qualifications: A cutting edge technical writing leader wielding creative, innovative solutions with emphasis on empowering individuals to build work groups into teams, maximizing potential and resources. More than 19 years experience in the IT environment.

Technical Writing Areas:	Project Management Areas:	Business Analyst / Overall Skill Areas:
-Technical Writing / Documentation	-Facilitate Information Systems Analysis	-Create Innovative Solutions
-User Manual Design	-Lead Work Groups	-Set New Standards
-Lead Editing Teams	-Build Passionate Teams	-Mentor
-Write Grant Proposals	-Manage & Allocate, Assign Project Resources	-Train
-Editor on PMBOK® Guide V4, 2008	-Automate & Track Workflow	-Hire
-Design Information Systems	-Business Development	-Initiate Cutting Edge Concepts
-Research & Investigate Procedures	-Government Projects	-Due Diligence / Feasibility Studies
-Policy & Procedure Design	-Healthcare Projects	-Software Architecture
-Healthcare Systems Design / Development	-Communications Planning	-Develop Policy & Procedures
-HIPAA Compliance	-Initiate and Maintain Work Scheduling	-Client Relations
-Proposals	-Provide Work Direction and Guidance	-Business Modeling
-Systems Methodology		-Encryption Data Protocol
-Financial Software Development		-Gather Input / Needs Requirements
		-Define Business Requirements

Publications:

· Member of editing team for future publication of PMI�s PMBOK® Guide V4, 2008

· Co-prepared presentation �Patient Safety Implications for Medica�s Members and Considerations for Medica�s Leaders�, 05/22/2008, 06/06/2008

· Authored most articles and compiled: �Minnesota CODES Comprehensive Reference Manual: Technical Reference, User Manual, Training Manual�, 04/05/2006

· Co-authored �CODES Basic Linkage Guidelines�, a national training manual published by National Highway Traffic Safety Administration (NHTSA), 03/08/2006

· "MN CODES How-To Manual" for the CODES Network, sponsored by NHTSA, 09/23/2005.

· Published utility software entitled "CODES ToolBox" complementary to the CODES project for the CODES Network sponsored by NHTSA, 09/06/2005.

· Contributed to Tips Column in FoxPro Advisor technical journal / magazine, July 2000 issue.

· Guest Interviewee on Weekly Technology Podcast, Episode 235 "Small Bytes", St. Cloud State University, 06/11/2007 http://web.stcloudstate.edu/mamonn/smallbytes/SmallBytes235.mp3

· Many user manuals and technical manuals, spanning many years

Software:

Programs: Microsoft Office XP, 2003, 2007, Microsoft PowerPoint, Microsoft Paint, Microsoft Project, Visio, Microsoft Paint,Adobe Acrobat, CODES 2000, SBT Accounting, ProcessProâ„¢, AccountMate, Citrix, Telemagic, Skyline Contact Manager

Programming Languages / Tools: XML, Visual FoxPro, dBase, Clipper, CodeBook, BASIC, Access, AQT query tool

Process / Methodologies: Requirements Gathering, Gap Analysis, Business Process Modeling, Information Architecture, RUP, UML, Use Cases, Waterfall, Sequence Diagrams, QA, Data Modeling, Process Improvement Methodologies, User / System Acceptance Testing, User-Centered Design

Development Environments / Platforms / Application Experience:

Windows 98, NT, 2000, XP, Novell, PDP/VAX/VMS, Multi-user networked platforms, Visual FoxPro 5.0, 6.0, 7.0, 8.0, FoxBase+ / DOS / Windows 1.x, 2.x, Clipper, dBase IV, Access 2000, 2002, Qantel�s QICBASIC, CodeBook framework, SBT Accounting, ProcessPro, CODES, Siebel 7

Memberships:

Member, BA Collective (Business Analyst Networking Group)

Member, Project Management Institute (PMI)

Member, Software Contractors Guild

Volunteer co-author on international review committee next revision of PMBOK® Guide, Version 4 from PMI, coming in 2008

John A. Weber, PMP � Page 2

Professional Work Experience:

2007 - Present Medica � Collective Genius Consultant

Business Analyst Consultant

· Business Intelligence focused business analysis working with enterprise level healthcare data warehouse and data marts.

· Detailed data element level to gather input requirements in Hospital (Inpatient, Outpatient), Physician, Pharmacy claims, utilization interdependencies and business rules.

· Develop dashboards and analytics for metrics in healthcare costs, premiums, return on investment using Siebel 7 and AQT query tool.

· Research healthcare quality incidents based on hospital claims to generate statistical report for senior executives � assume project direction and logistics planning and execution to expedite installation & perform analysis with �AHRQ QI� software, format results to usable presentation in PowerPoint and Excel

· Gather business requirements with clients, document and communicate results obtaining feedback as appropriate using Word, Excel and Visio.

· Collaborate with technology staff, business units to streamline operations and expedite projects for moving forward on time.

· Document and recommend resource requirements, determine timelines, constraints, dependencies and other factors for project planning using Word and Excel.

Additional Detail on Role:

§ Siebel 7 dashboard development, iBot scheduling and maintenance

§ Oracle database quality assurance data verification utilizing AQT tool

§ Collaborate with clients across business units and upper management obtaining buy-in on phasing of major projects

§ Facilitate business requirements gathering meetings Document visual diagrams and flowcharts as needed in Excel, Word, Visio, MS Paint

§ Data warehouse, data mart and focused data mart planning in a star schema environment

2006 � 2007 St. Cloud State University (State of Minnesota)

IT Project Manager / Business Systems Analyst / Supervisor

· Manage authorization and security related projects restricting access to data and portions of applications specifically by user.

· Collaborate with upper management and technical staff across University campus & State University / College System for team building and project management. Obtain buy-in at all levels to build ownership in projects for maximum potential overall.

· Work with management and IT staff to plan and research web portal technologies through SharePoint.

· Manage projects in a cross functional process environment to migrate integration of applications utilizing the portal infrastructure; assign tasks, resources

· Manage and prioritize projects to streamline efforts and improve efficiency of staff and resources; payroll for 1,000 instructors over summer sessions automated to reduce administrative costs for staff time and overhead estimated up to $5,000 annually

· Automate and close gap on outstanding parking tickets amounting to 10�s of thousands of dollars lost revenue through facilitating relationships with multiple states� motor vehicle departments� data transfer and synchronizing with accounts receivable system at University.

· �Resurrect� a dying project on campus that went through multiple false starts and successfully roll out usage for class scheduling and obtaining buy-in from faculty and staff to move forward with enthusiasm.

Additional Detail on Role:

§ Project management � full life cycle initiating, planning, executing, monitoring and closure for web applications

§ Create processes and procedures for business process improvement; provide thought leadership

§ Supervise team of 3 application developers, perform regular work reviews and coach for career development steps; assign tasks, work duties

§ Assume leadership in absence of Director, 10 - 20 staff members

§ Collaborate with users (across campus & across state University & College system) and upper management

§ Automation of software; working with outside vendor to configure and customize, build bridge between vendor product and internal software (AIMS Parking software)

§ Document visual diagrams and flowcharts as needed in Excel, Word, Visio, MS Paint

§ Coordinate communication and project planning in high profile, large scope enterprise initiative to upgrade security and migrate applications to a new platform at a campus and state-wide level

§ Negotiated data sharing agreements with approximately 10 other states

2001 � 2006 MN Department of Health (State of Minnesota)

IT Project Manager / Business Systems Analyst / Supervisor

· Develop standardized template for secure access to applications and data restricted to a customized level per user.

· Create methodology for automated quality assurance in data collection, analysis and reporting for work group. Enable ongoing ability to conduct quality assurance at regular intervals to improve data quality from 80% to consistently over 99%.

· Gather input requirements; design, program, implement unique methodology based on strong algorithm combined with more secure �wrapper� than that used in the industry to ensure privacy of healthcare data implementation for HIPAA compliance.

· Build team of developers for healthcare tracking data repository to include secure encrypted data transmission of healthcare patient chart / medical billing information; become subject matter expert in hospital billing records.

· Recognized nationally as mentor, technical writer, key technical support for national project in data linkage; improve quality of linkages at state level implementation and streamlined documentation and preparation software to accompany project.

· Lead project from insignificance and risk of being discontinued to high visibility in state and national level.

· Motivate team to succeed and collaborated with other agencies to work together successfully.

· Mentor staff at state level and national level during technical conferences. Obtained distinction as data linkage �guru� and key contact, mentor.

Additional Detail on Role:

§ Project management� full life cycle initiating, planning, executing, monitoring and closure for internal data gathering & analysis initiatives

§ Gather input from work unit to edit and compile comprehensive �How-To Manual� to enhance professional appearance, readability and grammar; developed document management process and infrastructure by means of a protocol for standard file & folder naming conventions

§ Establish workflow, paper filing system for setting standards and consistency; administer data security, develop backup procedures

John A. Weber, PMP � Page 3

MN Department of Health (State of Minnesota), Continued

§ User manual documentation in various projects; Word hyperlinks in table of contents and figures linking to chapter content and actual diagrams; Excel, MS Paint. Documented visual diagrams and flowcharts as needed in Excel, Word, MS Paint

§ Lead teams to write and edit federal grant applications to CDC and subsequent regular required government reporting regulations

§ Motivate team to become innovative and leading edge in each one�s respective talents and skills; provide thought leadership

§ Build effective team regarded as setting standards in various projects at national and state level

§ Lead ongoing team (cross functional environment) of data analysts, programmers and related data staff to empower team in designing and implementing various data collection and analysis projects

§ Supervise team of 3-4, perform regular work reviews and coach for career development steps

§ Advise / mentor staff locally / nationally for data linkage projects between State Agencies

§ Serve on various multi-state agency committees, advisory boards in a consulting / advisory role; e.g. Strategic Planning Committee on Motor Vehicle Crash data, Emergency Medical Services Data Quality Standing Committee, Traffic Records Coordinating Committee.

§ Lead Architect to design / operate large state database management system � MN Trauma Data Bank (MTDB) foundational work to provide further automation throughout work unit, potential savings of thousands of dollars over several years

§ Improve timeliness, accuracy and quality of data for state commercial vehicle crash reporting by building system to process the data. Directly influenced quarterly reporting status from red light to green light and restoring millions of dollars in funding

§ Work extensively to develop integrated data preparation / linkage technology to analyze results between multiple sets of data where specific identifiers do not always exist � Crash Outcome Data Evaluation System (CODES)

§ Liaison to public groups � reporting / clientele interfacing

§ Quality planning / control / create and implement methodology for ongoing quality assurance

§ Build / implement new innovative protocol for secure encrypted data transfer between hospitals / State Health Department

§ Design and support XML data transfer protocol from MN State Patrol to Federal Highway Safety Administration using Visual FoxPro bridging to CVAR Direct; interaction with outside vendor, write User Manual and Technical Manual using Word, Excel and MS Paint

1998 - 2001 Dahl Consulting, Inc

Lead Project Business Systems Analyst / Programmer

· Assist client to facilitate smooth transition of contractual relationship to improve customer satisfaction and profitability. Negotiate revision in contract to reallocate staff resources from one project to others resulting in savings of over $140,000.

· Design safety net structure to eliminate inconsistencies and unpredictability in accounting software for a client. Remove inconsistencies allowing increased profitability, preventing loss of revenues of about up to $50 Million.

· Build trust relationship with client for consistent deliverables and profitability with client and consulting firm. Provide environment to improve relations between client and other contractors to increase customer satisfaction and continue flow of work uninterrupted.

· Work on delivery of healthcare provider turnkey solution for hearing aid patients; submission of clinical (professional) claims.

· Develop software to facilitate healthcare billing claims to central clearinghouse.

Additional Detail on Role:

§ Lead Project Programmer / Systems Analyst (lead planning / overall direction on various projects, key point of contact for clients / keep projects on track / communication flow

§ Business Analyst / Systems Analyst

§ Design new systems

§ Maintain / improve current systems

§ Innovation on new methodologies / procedures providing system solutions

§ On call 24/ 7 coverage of software support

§ Visual FoxPro, Citrix remote connection

§ Customize SBT Accounting package for process manufacturing industrial client

§ Build security / data dictionary updates

§ Investigate several levels of software code / uncover / correct defective code / system design flaws

§ Develop new repair algorithm to compensate for vulnerabilities in accounting package

§ Liaison to customer to improve customer relations across IT consultants working on project

§ Develop methodology to correct random unpredictable errors & behavior throughout software system

§ Coordinate version control of client updates with IT team

1997 - 1998 Data Base Ideas, Inc

Business / Systems Analyst / Programmer

· Facilitate discussions to understand overall philosophy and methodology of fulfillment systems. Design improved system to integrate with existing system to increase productivity and eliminate redundancy.

· Develop test model for improving rewards and rebate fulfillment tracking system for client. Streamline system with high customer satisfaction virtually eliminating redundant reports and checks printed for a single recipient under multiple rebates.

· Coordinate working with key stakeholders on staff team to move projects forward with success. Obtain buy-in and support from staff successfully for projects.

Additional Detail on Role:

§ Maintenance

§ Clean up links, structural indexes, tags

§ Legacy conversion to Client/Server from Clipper to Visual FoxPro

§ SQL queries / reports

John A. Weber, PMP � Page 4

1997 New Horizons Computer Learning Center

Systems Analyst / Trainer

· Advise management, sales executives on best practices for database architecture, systems operations.

· Train clients including technical and end user staff on FoxPro database techniques, queries and reports.

· Streamline configuration and set up telemarketing software for sales staff.

Additional Detail on Role:

§ Consultant trainer

§ Customize software

§ Configuration management

§ Maintenance & cleanup of filters, security TeleMagic telemarketing software tracking Windows & DOS

§ FoxBase / dBase, Novell network platform

1994 - 1996 SHL Systemhouse, Inc. (Division of MCI)

Senior Field Engineer / Desktop Support Analyst

· Resolve configuration and hardware issues for client desktops in timely manner to improve productivity. Train users on most effective and streamlined use of resources.

· Track and follow up on work orders presented in networked environment of several hundred users.

· Develop standard procedures and installed / configured desktop equipment for 100�s of users.

Additional Detail on Role:

§ Client interaction, troubleshooting, resolution of software & hardware issues

§ Customize software settings

§ Configuration management

§ Novell network platform

1991 - 1993 Pentecostal Assemblies of Canada

IT Manager / Business Systems Analyst / Programmer

· Build project priority and resource allocation tracking system for entire office of 70 staff members and many departments. Increased productivity and workflow allowing more projects to be completed in timely fashion without exceeding available resources.

· Document procedures and software with streamlining of program code for national office. Eliminate duplication of software programs and documented 90-95% of procedures and existing programs.

· Design cataloging system for historical documents and artifacts to be quickly located in national office archives library. Build catalog system with ease and speed of lookup to enable interested persons to conduct historical research.

Additional Detail on Role:

§ MIS Department Manager

§ Project management � initiating, planning, executing, monitoring, closure