Technical Management Requirements Management Business Analysis Process Improvement Datamart & Data Warehouse Solutions
US-TX-Austin (will consider relocating)
ALLEN JOHNSTON 204 Lois Lane Paige, TX 78659 512-253-6361 Email: email@example.com
Summary of Qualifications
I have over 20 years of experience in planning, designing, and implementing complex datamart, data warehouse, and business intelligence solutions. Lead cross-functional teams with diverse technical and non-technical backgrounds. I am adept at problem solving, consensus building, and team motivation. I possess strong problem solving and troubleshooting skills and work well in team environments or independently. I have a Master of Science degree in Computer Science, with a concentration in artificial intelligence.
Areas of Expertise:
• System Development Lifecycle • Technical Management & Leadership • Datamart & Data Warehouse Solutions • Business Intelligence Strategy • Methodology & Process Improvement • Requirements Elicitation & Management • Business Analysis • Technical Documentation & Specification • Proposal & SOW Content Development
MAY 2008 -- Present Subject Matter Expert/Enterprise Engineer (Telecommute) Data Consulting Group, Inc., Detroit, MI
Description: The United States Health Information Knowledgebase (USHIK) is a metadata registry of healthcare-related data standards, funded and directed by the Agency for Healthcare Research and Quality (AHRQ) with management support from the Centers for Medicare & Medicaid Services (CMS). USHIK houses a collection of data elements and information models from Standards Development Organizations (SDOs) and various healthcare organizations. This web-based (http://ushik.ahrq.gov/) resource fosters the use of established standards in the creation, mainte¬nance and access to metadata used for Health Information Exchange (HIE). USHIK is based on the ISO/IEC Standard 11179 -- Metadata Reg¬istries.
One of the metadata collections contained in USHIK is the Common Formats specification for reporting patient safety events. The Patient Safety and Quality Improvement Act of 2005 requires that Patient Safety Organizations (PSOs) to collect patient safety event information from healthcare providers in a standardized manner. AHRQ's Center for Quality Improvement and Patient Safety (CQuIPS) published the initial version of the Common Formats via USHIK in May 2010. My primary role with DCG has been to oversee this initiative from requirements definition and development to production deployment.
Responsibilities: Prepare draft project schedule for Patient Safety reporting metadata deployment Update and maintain project schedule for Program Manager Conduct and manage business requirements determination and definition Create Requirements Traceability Matrix (RTM) Create task dependency matrix Develop test plan based on Patient Safety reporting business rules and requirements Perform Q/A validation of USHIK components
MAR 2006 -- DEC 2007 Subject Matter Expert, Net-Centric Data Strategy AlfoTech Solutions, Inc., San Antonio, TX
Description: Worked as a Subject Matter Expert on the TRICARE Health Information Technology Management Support (HITMS) contract. The focus of my task was to analyze the Military Health System (MHS) Metadata Registry (MDR) structure, functionality, and its potential utility within the MHS. Specifically, in coordination with users, to make recommendations and develop functional requirements for reengineering aspects of the MDR to address the following requirements:
• Publishing net-centric Defense Discovery Metadata Specification (DDMS) compliant metadata to the DoD Community through discovery metadata • Feeding the DoD MDR with updated MHS metadata structures • Loading MHS MDR with local tables, datasets, and other artifacts as identified, utilizing Terminology Services Bureau (TSB) capabilities for comparison and querying within the MDR
Responsibilities: Analyze information management requirements for soundness, completeness, and quality Evaluate issues with workflow, organization, and planning and recommend appropriate corrective action Apply business process improvement practices to re-engineer methodologies and practices for business modernization projects Provide vision, leadership, guidance, and problem solving to develop innovative, cost effective solutions that leverage standards-based products and emerging technologies Develop and apply organization-wide information models for use in designing and building integrated, shared software and database management systems Perform as a lead technical authority, evaluating and defining the enterprise integrated architecture, software, data, and system interfaces Assist in the development and implementation of data management methodologies Evaluate work standards, conducting reviews to resolve potential work discrepancies that may be noncompliant with contract requirements
AUG 2000 -- FEB 2006 TRICARE Executive Information/Decision Support Program Office Chief Engineer and Architect MAY 2003 -- FEB 2006 Irving Burton Associates, Falls Church, VA
OCT 2001 -- APR 2003 Jacer, LLC, Fairfax Station, VA
AUG 2000 -- OCT 2001 Irving Burton Associates, Falls Church, VA
Description: I served as Chief Engineer and Architect for the TRICARE EI/DS Office Program with a $36M annual budget and staff of approximately 25 Military, Civil Servant, and Contractor personnel.
The Program supported a central data warehouse, the MHS Data Repository (MDR) and five enterprise independent data marts: • Managed Care Forecasting and Analysis System (MCFAS), which forecasts and reports enrollment and eligibility for the TRICARE beneficiary population • Population Health Operational Tracking and Optimization (PHOTO), a reporting and analysis datamart for Healthcare Effectiveness Data and Information Set (HEDIS) • MHS Mart (M2), a reporting and analysis datamart for direct care and purchased care claims data • Medical Surveillance System (MSS), a detection system for reporting “events of interest,” based on daily encounter data • TRICARE Enrollment Data (TED), a reporting and analysis system for purchased care data
The MDR provided online storage of and access to over 2.3 billion records of ambulatory and inpatient direct and purchased care, eligibility and enrollment, pharmacy, and cost and staff workload data for 102 inpatient treatment facilities and over 400 outpatient clinics. Over 1 billion records were captured annually and more than 13 million records per month were transmitted to external agencies, e.g., VA, CDC, NEHC, and GEIS. An additional 33 billion records were available for retrieval and analysis, via automated archival storage. EI/DS systems supported over 2,500 users world-wide, maintaining data on a beneficiary population of more than 9 million.
Responsibilities: Advise and brief Program Office Staff on architecture and engineering topics Recommend architecture strategies and provide relevant input to budget development Monitor system performance and utilization Conduct research and perform market studies to evaluate relevant emerging technologies Author technical sections of RFPs and statements of work Staff, mentor, and manage the Program engineering staff (5 engineers) Ensure requirement definition processes resulted in clear, concise, and complete “build-to” specifications for task order statements of work Participate in all development design reviews to ascertain soundness of solution approach Review and critique vendor proposals Oversee and evaluate Program Office system integrator development initiatives Develop a CMMI Level 3 compliant Systems Engineering capability systems engineering plan, and systems engineering handbook
JUN 1996 -- AUG 2000 Technical Manager, Data Warehousing Oracle Corp., Herndon, VA
Description: I was employed by Oracle as Technical Manager, assigned to Federal and Telecommunications Data Warehouse consulting practices, where I performed as Project Manager, Team Lead, Technical Lead, and on-site Consultant for various data mart and data warehouse implementations.
Responsibilities: Supervision of datamart and data warehouse teams Functional requirements elicitations and definition of technical specifications Establish project scope Design of the overall solution strategy and architecture Participated in the creation of project plans and schedules Frontend application development/coding Technical management of the RDBMS data staging task Develop ETL module development/coding
AUG 1993 -- JUN 1996 Decision Support Systems Consultant ISIS, Inc., Arlington, VA
Description: Establishing ISIS, I provided decision support systems consulting, design, and development services to various clients, including: The World Bank, Rite Aid Corporation, Marriott Corporation, and AT&T Financial Services Division. I was a subcontractor for Oracle on the AT&T engagement and subsequently accepted an employment offer from them. APR 1992 -- Aug 1993 Director, Applications Development Project Office B-K Dynamics, Inc., Rockville, MD
Description: I supervised a team of decision support system developers and performed design and development tasks on projects for the U.S. Navy and Defense.
MAR 1991 -- APR 1992 Senior Program Director, Express Projects Systems Exploration, Inc., Arlington, VA
Description: I was hired as Computer Scientist and Task Manager for a Navy decision support project and was subsequently promoted to Senior DSS Program Director. Supervised team of decision support system developers, performed design and development tasks, participated in bid and proposal efforts for new business development, and coordinated pre-sales technical support activities.
DEC 1989 -- FEB 1991 Principal Technical Computer Scientist Resource Consultants, Inc., Vienna, VA
Description: I was hired as a decision support systems developer in the capacity of as a Technical Computer Scientist and was promoted to Principal Technical Computer Scientist.
MAR 1989 -- DEC 1989 Computer Programmer/Analyst ECON, Inc., Fairfax, VA
Description: I was employed as a Programmer/Analyst to provide programming support, requirements elicitation, and application development in support of NASA decision support application development.
AUG 1987 -- APR 1989 Part-Time Computer Programmer Jack Bieler Associates, Linthicum, MD
Description: I programmed modules for a Xenix-based, multi-user mortgage loan tracking system.
• DEC 1986: The American University, Washington, DC - MS, Computer Science
• JUN 1984: Strayer University, Arlington, VA - BS, Data Processing Management
• DEC 1983: Strayer University, Washington, DC - AA, Computer Programming