735 North Jefferson Ave Loveland, CO 80537 Voice: (303)588-1996 email: justin@rm-mi.net SUMMARY OF QUALIFICATIONS * 23 years of problem solving business reporting needs with technical solutions. * 15 years of enterprise applications, systems integration and systems analysis. * 12 years of technical project management. * 4 years of project management to PMI standards. * 6 years of consulting and contract projects. The breadth and range of business acumen from start-up, small business, fortune 1000 and fortune 50 as well as local and Federal government entities enables diverse points of view to be quickly understood. Constantly exercising the inquisitive edge I have proven repeatedly the ability to gather information spanning the enterprise and granular levels of business process. Proven ability to orchestrate meetings with subject matter experts (SME) program management and technology teams to; vet business requirements, system needs and functional designs. Working my way up in skills applied to roles organized around data, reporting and dash-boarding. Roles of coordinator, technician and manager within scope of applications, database and network administrator, programming, training, technical writing and product management has given hands on skills knowledge to be applied directly to project management and complex systems analysis. Current JPASS - NISPOM Government SECRET clearance. Summary of Skills * Management of 5 + on-site & remote staff. * Project responsibility of cross-functional teams across multiple time zones on projects with extremely tight deadlines. * Managed integration, coordination, timing, and consistency of process. * Planned/prioritized sub-projects to meet overall goals and objectives. * Managed and participated on teams defining job scope and employee hiring/firing. * Facilitated regular reporting and reviews. * Customer/client focused communication style. * Created team building and motivational situations. * Analytical approach to consultation. * Business writing executive reports, business plans, and training materials. * Technical writing of request for proposals, installation procedures and help documentation. * Preparation of budgets and financials for start ups. * New business development in technology markets. * Emerging market research and analysis. * Negotiation of contracts. * Vendor relations and technical liaison. * Diplomacy applied to solve team dynamic and individual members challenges to achieve goals. * Selling and marketing various products and services. * Business data environments in DB2-AS/400, SQL Server 2000/2005, Oracle 8i,10g and 11g. * Oracle Fusion Middleware and SOA Suite 11g. * Oracle 11g JDeveloper prototyping and modeling. * Business analysis in Hyperion, SQL Enterprise, COGNOS, Crystal Reports (Business Objects), Access, Excel. * SQL server 2000 database administration (DBA). * Systems development life cycles and project methodologies (SDLC). * Requirements management in Borland Caliber-RM. * Data domain modeling with UML tools for MOLAP topology implementation vetting technical design with business requirements. * BRS and SRS documentation for SOA environment. * HL7 and X12 integration with corporate data domain. * Business rules, analysis and integration to business logic; JBoss Rules (DROOLS), BLAZE, BPEL. * Facilitation and implementation of PTF's and upgrades to enterprise business applications. * Enterprise systems include: J.D. Edwards ERP, SunGard H.T.E. Government Information Systems, ITRON Utility Systems, Tele-Works and Class Recreation Software and EFT implementations. * AGILE/SCRUM Development Product Management * Vernacular in telecommunications, managed health care, process management, facility operations, financial risk analysis. * Worked with and second level support of applications/business systems including and not limited to: LIMS, Utility Billing, Finance, GMBA, Building Permits, HMS Colorado Sales-tax, E-commerce, and within FDA and HIPAA regulated operations. * Development of business applications with Access 2003, (.NET), FileMaker and SQL/MSSQL database engines within N-tier architecture framework using ODBC, DAO, ADO, TCP/IP in LAN and WAN topology. * Migration of legacy data into OLTP and OLAP architectures (ETL). * Web Master/Web Author for inter/intra-net use. * Administrator of SOHO wireless network with 802.11b access point. * Trainer/teacher in class room settings and 1:1 settings of ERP applications. * Support (second tier) to clients on ERP and on Microsoft (XP) standard business applications. * OS inclusive of XP, 2000, NT Server, AS/400, MAC-OS, Win95/98, DOS, & LINUX. PROFESSIONAL EXPERIENCE Rocky Mountain Managed Information, Technology and Marketing Business Solutions Consultant/Contractor Loveland, Colorado 2004-Present Sole Proprietor dba: Rocky Mountain Mi (RM-Mi) Contracts and consulting in Information Systems on the areas of expertise: • Enterprise Resource Systems (ERP) • Business Reporting Systems • Data Warehouse Consolidation • Data Mart Definition • Requirements Analysis and Systems Integration • Software Project Management • Agile SCRUM/Development Product Analyst • Workflow Analysis and Design • Data and Domain Modeling • Client Relations • Technical and Professional Communication • Manage Teams - Team Lead • Creative thinker able to conceptualize project end to end. >> Large contract sectors include • Financial • Government • Healthcare • Telecommunications... • Contract: Product Management Team Analyst at McKesson Corporation, Advanced Diagnostics Management (ADM) August 2010 - present (project budgeted through November 19) AGILE / KANBAN Product Management (PM) in the role of requirements analyst supporting Health Care Payor Authorization claims workflow. Because of previous engagement with this team's leadership, this contract effort is to assist with moving backlog feature functionality into stories and onto the Kanban planning board during a phased growth period so that the PM can engage more client facing demonstrations of the ADM solution. The feature/stories are aligned with SME input and validation to provide value and are formed and sized for consistent planning with the engineering teams. Concurrently consulting on and documenting the optimal on-boarding process for future product management team members in this fast paced agile environment. Tools used; Atlassian bug & tracking tool - JIRA, collaboration WIKI's, Tortoise-SVN document control. The engagement deliverable is to communicate findings to product management in the McKesson ADM team. Veteran Engineering and Technology, LLC , Director Business Development; Project Management; Sr. Systems Analysis; Systems Architect; Technical Team Lead Fort Collins, Colorado April 2009 - June 2010 Manage and fulfill Federal contracts for the Veteran Engineering and Technology (VET) division core client, the United States Department of Agriculture (USDA.) Summary: Majority of effort as Project Manager, Systems Analyst, Systems Architect. 10% of time developing new business and reviewing project RFP's and possible resumes to fulfill team requirements. Detail: * SOA 2010 Project; Project management, systems anlysis, modeling and solution architecting of the Oracle 11g SOA pilot project for USDA VS-CIO. This Fusion Middleware installation contract included configuration of hardware, training on administration and development with tool suite, design specification creation and functional build test deploy of solutions. The core messaging workflow focuses on synchronous validation and asynchronous canonical schema storage for translation into divergent business systems data ontologies. As the project manager on this contract I developed the WBS and project plan per PMI standards. As the systems analyst I reviewd the requirements in the SOW and elicited functional requirements into a design specification using BPMN, UML and Visio to represent the architecture and propose solutions. Prototyping in Oracles JDeveloper I explored options and recomened final solution. As technical lead and project manager tasked and mentored my team of J2E develpers on SOA concepts and ADF solution constructs. * BRS 2009 Project; systems analysis of business functionality working with subject matter experts to elicit define and model a business requirements specification to solve animal movement tracking problem. Alignment of data mapping problem with workflow definition to describe the requirements per industry standards. As the sole consultant on this project I managed time and deliverables to our project milestones over a period of one year. Rocky Mountain Managed Information, Technology and Marketing Business Solutions Consultant/Contractor Loveland, Colorado 2004-Present Sole Proprietor dba: Rocky Mountain Mi (RM-Mi) Contracts and consulting in Information Systems on the areas of expertise: ... Continued contracting engagements... • Contract: Sr. Business Systems Analyst/Project Manager at Veteran Technology LLC November 2008 - April 2009 Requirements analysis and authorship applying OOA standards for Federal contract on USDA - NAIS - ATPS animal disease traceability project through Veteran Engineering and Technology. Project object was to uncover researcher needs around the animal-place-disease cohort data collection and analysis problem and present requirements to UML and OOA standards for future development. Converted contract to a FTE with VET. • Contract: Agile/SCRUM Development Team Analyst at McKesson Corporation April 2008 - October 2008 AGILE SCRUM Product Management by the book according to K. Schwaber and M. Cohn in the role of Business Systems Analyst supporting laboratory testing-claims workflow Product Management. Manage the product backlog feeding the sprint backlog. Create and manage WIKI with project artifacts derived from Edgewall-TRAC, Tortoise-SVN, GUI team wire frames/comps and scrum day review including burn-down charts, velocity estimates and user stories. Developed and maintain access data base of backlog, bugs, features and story requests with custom reporting and integration to Mindmap linking objects for visual dash-boarding of themes and epics. Write user stories and acceptance criteria vetting with SME teams. Coordinate and communicate cross functionally with software engineers, scrum master, stakeholders, managers and subject matter experts in Health Care Laboratory Workflow-Claims Authorization-Diagnostics Benefits Management. • Contract: Sr. Systems Analyst / Project Manager at Sprint Nextel Corporation January 2008 - February 2008 Identify gap analysis of existing and new reporting efforts for call center operations, define BRS requirements for new reporting efforts, create templates and approach documents for future report consolidation on (analog) ACD / ICM call center installations that are being upgraded to (digital) IPCC / ICM Cisco solutions with next generation MGX switches. Specifically addressing data to be accessed on the ODS and consolidated data warehouse for each call centers reporting needs to facilitate a consolidated corporate reporting framework. • Contract: Sr. Business Systems Analyst at McKesson Corporation January 2007 - November 2007 Lead BSA on BI module of SOA based next generation enterprise application suite for healthcare management (pay for performance KPI metrics) targeted to regional organizations specifically for clinical reporting tools to replace the CareEnhance CRMS product. Integrated modules to include: BI (network, care, accreditation, employer, financial reporting) - workflow (disease, care, utilization, triage management) - portals (physician, care managers, patients, employers) integrations (benefits, medical, pharmacy, lab claims). Requirements gathering defining needs of business and data through ETL, warehouse, marts and dimensional cubes for reporting metrics aligned to Hyperion System 9 BI - OLAP tools (Web Analysis and Interactive Reporting.) Working with the agile project methodology as liaison between business SME's and development in clinical reporting application to define; scenarios, use cases, requirement specifications. Requirement specification analysis function of the SDLC working the requirements through phases involving; business (BRS), software (SRS), data quality check (DQC), business rules-logic, SOA orchestration requirement specification around master entity index (MEI). Analysis of NCQA HEDIS and ICD-9 specifications for integration to business logic. Use of Borland Caliber-RM tool for requirements management. Proof of concept (POC) analyst on team that delivered POC of next generation reporting tool for legacy report product users conference. Data analyst on domain modeling effort conforming systems to corporate semantic model, HL7 and X12 standards with UML tools. • Contract: Technical Project Lead, Sr. Business Systems Analyst at Fair Isaac June 2006 - December 2006 Lead Consultant managing team of Microsoft System Engineers, SQL data and ASP experts where we migrated and re-engineered BLAZE Business Rules and ASP process from regional data center to consolidated corporate data center. Successfully moved more than 12 Terabytes of data and business systems transferred, synchronized and tested for soft cut for development and a hard cut for production go live. Migration involved integration into multiple sub domain's and a mix of physical and virtual (VM) servers for development environments and physical servers and multiple SANS for production environment all the while updating security topology to meet current industry standards as defined by HIPAA. • Ad Hoc small projects 2004 -2010 Web design, application development, technical writing, market penetration analysis, tradeshow support, business plan ghost writing, data quality, business process and business development consulting for profit and non-profit organizations. The City and County of Broomfield, Application Integration Specialist, Senior Applications Support Broomfield, Colorado, 1998-2004 Summary: Business systems analysis and business unit application integration specializing in business intelligence/reporting. Detail: Project management of the IT concerns across multiple business units. Vendor relations specific to applications (ERP) use upgrades and usability. Inter-government data integration expert with DB2, Oracle, SQL, and CSV data objects. Documentation creation including request for proposals (RFP) needs analysis, training and help materials. Consultative analysis services to end users regarding best of breed solutions per industry standards and decision support then implementation services of solutions resulting in business process improvments. Full software development cycle (SDLC) developing applications with in MS solution architecture framework. SQL Server 2000 database administration duties include migration, maintenance, backup recovery, security, and scripts. Advanced knowledge of business intelligence applications such as Cognos and Crystal Reports, of data extrapolation from IBM AS400 using native Query and DB2 tools as well as SQL Server and Oracle data using ODBC primarily with MS Excel and Access data aggregation and transformation for the benefit of reporting to executive staff in various departments in the city. Achievements :• Successful management and resolution of Year 2000 concerns. • Full SDLC of sales tax solution. • Migration of SQL Server hardware OS and software (97 to 2000). • LIMS server upgrade. • Successful Implementations of: Cognos tools. • of Blue Ocean Track-It. • of ERP web based help system. • Integration of remote Itron remote read utility interface. NUeBook, Founder, Loveland, Colorado, 1998-1999 In 1998 electronic book's (eBook) held promise of a new paradigm. Recognizing an opportunity and pursuing the business and technological aspects, as founder of an emerging company doing market research on the viability of the NUeBook concept taking the group through the startup phase. Determining the barrier to market was the unit cost of storage that did not fit within market studies of acceptable product cost, the venture was shelved. Achievements :• Assembled a top tier team of hardware, software and process engineers. • Advisory team members included MIT, Stanford, and fortune 1000 executives. • Development of a prospectus business plan that held the interest of industry professionals. • Networked and entertained venture discussions with fortune 500 businesses. Rocky Mountain Ram, Manager of Information Systems Boulder, Colorado. 1998 RMR manufacturers and sells computer memory modules direct to business entities. Tasked with maintaining TCP/IP network, security, servers and improving process and sales management software. Managed technical support staff. Achievements • Mapped and documented data-flow in existing FileMaker database. • Created Request for Proposal (RFP) for new application development. • Selected development vendor and negotiated project plan. AMGEN, Document Control Associate II, Logistical Operations Boulder, Colorado. 1995-1997 Achievements: • Developed database application that optimized maintenance department work process. • Organized company assets to save annual operating expenses. • Improved departmental communication with intranet web site for Logistical Operations. • Successful ETL of legacy data from AskManMan into FileMaker database. Member of: • POET (Purchase Order Electronic Transfer) development team. • Contract management development team. • Team leader of Boulder Technical Resources (BTR) communication team. • Cross trained in FDA Regulated operations purchasing, warehouse, distribution process. Conceptions UNltd., Manager of Telemarketing Services Rochester, Vermont. 1994 Managed call center testing market lists for publishing services fulfillment. Researched selected and cleaned prospect lists for quality. Authored marketing copy, managed staff of in house telemarketers, tracked results and prepared reports. Managed vendor relations and client relations. Achievements: • Rebuilt Access database tracking system to facilitate reporting quality. Miscellaneous professional experience Various sales, marketing and photography jobs, 1987-1994 EDUCATION • Bachelor of Science/Business Information Systems (BS/IS), University of Phoenix, 1999 Additional Coursework • Small Business Management, University of Vermont C.E.C., 1991 • Graphic Design, Church Street Center C.E.C., 1990 • Visual Communications, Lyndon State College, 1985-1987 • Outdoor Leadership and Woodland Ecology, Sterling Institute, 1983 Additional Training Seminars: 1995-2010 • Intro to Good Manufacturing Practices • Effective Business Writing • PACS Administration • Raising Capital • Hyperion System 9 BI+: Getting Started / Web Analysis / Interactive Reporting • COGNOS v5 Impromptu Administration • Advanced Crystal Reports v8.5 • Mastering Visual Basic 6.0 Fundamentals • MS Developer Series comparison of ACCESS 2000 and SQL7 • SQL Server 2000 Administration • Introduction to Oracle Administration • Oracle PL/SQL 8.1.5 • Oracle SOA Suite 11g Administration, Fusion Middleware, JDeveloper IDE, BPEL • PMI Certification Preparation (June 2010) currently preparing for PMP exam Member: IEEE, IIBA and PMI