JUSTIN MEAD 735 N. Jefferson Ave. Loveland, CO 80537-4407 Telephone: 303.588.1996 Fax: 970.669.4413 email: justin@rm-mi.net ------------------------------------------------------------------------------------------ TECHNICAL MANAGEMENT RESUME ------------------------------------------------------------------------------------------ Business Skills Summary -- Management ------------------------------------------------------------------------------------------ * 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. ------------------------------------------------------------------------------------------ Technical Skills Summary - Business Systems Analyst/Project Manager ------------------------------------------------------------------------------------------ * Business data environments in DB2-AS/400, SQL Server 2000/2005, Oracle 8i and 10g. * 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 CaliberRM. * AGILE/SCRUM Development Product Management. * 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. * 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. * 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, Loveland, Colorado 2004-Present DBA: Rocky Mountain Mi (RM-Mi), Founder, Senior Business Analyst Technology Consultant Consulting in Information Systems specializing in: • Reporting Systems • Data Warehouse Consolidation • Data Mart Definition • Requirements Analysis and Systems Integration • Agile SCRUM/Development Product Analyst • Software Project Management • 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. Secondary market focus in the SOHO for web hosting services and Independent Software Vendor (ISV) contract programming. Projects include business decision consulting on architecture, development, and design, Access database application development/user enhancement programming using VBA, DAO, ADO and N-Tier Architecture. MS Pocket PC data point of entry application development using the Visual Studio (.NET) environment. RM-Mi also provides marketing with technology, ghost writing, logo design, web development and hosting, as well as consulting on technology process improvements. Recent project industries have included; health care, financial credit services, environmental consulting, retail inventory management, business to business sales, real estate list management, laboratory information systems, medical technologies architecture, and projects for sole proprietors in public relations, therapy, cartooning, sculpting, photography and personal services. Large contract sectors include • Financial • Government • Healthcare • Telecommunications Projects include: > Agile/SCRUM Development Team Analyst at McKesson Corporation (Public Company; 10,001 or more employees; MCK; Healthcare management industry) April 2008 – Present (6 months) AGILE SCRUM Product Management by the book according to K.Schwaber and M.Cohn in the role of Business Systems Analyst supporting 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. > Sr. Systems Analyst / Project Manager at Sprint Nextel Corporation (Public Company; 10,001 or more employees; S; Telecommunications industry) 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. > Sr. Business Systems Analyst at McKesson Corporation (Public Company; 10,001 or more employees; MCK; Healthcare management industry) January 2007 – November 2007 (11 months) 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 subject matter experts (SME) 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 (DQC), business rules-logic, SOA orchestration requirement specification around master entity index (MEI). Analysis of NCQA HEDIS specifications for integration to business logic. Use of Borland CaliberRM 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. >Sr. Business Systems Analyst at Fair Isaac (Public Company; 1001-5000 employees; Financial industry) June 2006 – December 2006 ( 6 months) 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 then 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.  ... <> The City and County of Broomfield, Colorado, 1998-2004 Applications Specialist,   Information Technology (Government) 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, Loveland, Colorado, 1998-1999 Founder,   (Technology start up) 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 with in 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, Boulder, Colorado. 1998 Manager of Information Systems (Computer hardware industry) 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, Boulder, Colorado. 1995-1997 Document Control Associate II,  Logistical Operations Department. (Pharmaceutical industry) 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., Rochester, Vermont. 1994 Manager of Telemarketing Services (Publishing industry) 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 ------------------------------------------------------------------------------------------ Academic ------------------------------------------------------------------------------------------ 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-2007 • Hyperion System 9 BI+: Getting Started / Web Analysis / Interactive Reporting • Intro to Good Manufacturing Practices • Effective Business Writing • Raising Capital • 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 • PACS Administration • ------------------------------------------------------------------------------------------ http://www.rm-mi.net/resume version 200800928.0-TM ------------------------------------------------------------------------------------------