6 . ISSU E D BY CO D E N00033-11-D- 6505 1 . C O N TR A CT/ P U R CH . O RD E R/ A G R E E M E N T N O . N 0 0 03 3 2 . D E L IVE R Y O R D E R / C A L L N O . 0004 5 . P R IO RITY CO D E 8 . D E L I VE RY FO B D E ST IN A T IO N X O T H E R ( See Sch edule if o t h er ) 3 . D A TE O F O R D E R / CA L L 2011 Mar 02 4 . R E Q ./ P U R CH . RE Q U E S T N O . N 0003310556301 S E E IT E M 6 MI LI TA R Y S EA L I F T C O MMA N D , N 10 2 2 9 1 4 C H A R LE S MO R R I S C O U R T S E W AS H I N G TO N N A V Y Y AR D D C 2 0 39 8-55 40 7 . A D M IN IST E RE D BY (if o th er th a n 6 ) ( YY Y YM M M D D ) 1 0 . D E L IVE R TO FO B P O IN T BY (D at e) ( YY YY M M M D D ) U S I N F O R MA TI O N TEC H N O LO G I E S J O SE P H MO R R O N E 4 80 0 W E STF I E LD S B L VD , STE 2 50 C H A N TI L LY VA 2 0 15 1-42 0 2 CO D E 4LY J5 9 . CO N T RA CT O R FA CI L I T Y SEE SC HEDUL E 1 2 . D IS CO U N T TE R M S M A RK IF BU S IN E SS IS 1 1 . S M A L L S M A L L D IS A D VA N TA G E D W O M E N -O W N E D 1 3 . M A I L I N VO I CE S T O T H E A D D RE SS IN BL O CK See Item 15 2 5 . T O T A L $ X 1 7 . A CCO U N T IN G A N D A P P RO P RIA T IO N D A T A / L O CA L U SE CO D E 1 8 . I T E M N O . 1 9 . SCH E D U L E O F SU P P L IE S/ SE RVI CE S * If q u a n t i t y a ccep t ed b y t h e G o ver n m en t i s s a m e a s q u a n t i t y a ccep t ed b el o w q u a n t i t y o r d er ed a n d en ci r cl e. D E L I VE RY / 1 6 . 1 4 . SH IP T O Se e Sch e d u le S E E S C H E D U LE N 00 0 33 M A R K A LL P A C KA G ES A N D P A P ER S W ITH ID EN TIFIC A TIO N N U M B ER S IN B LO C KS 1 A N D 2 . 2 3 . A M O U N T 1 5 . P A Y M E N T W I L L BE M A D E BY CO D E MI L I TA R Y SE A LI F T C O MMAN D MS C N -8 3 9 14 C H A R L E S MO R R I S C T S E W A S H I N G TO N D C 2 03 98
Th i s d el i v ery o rd er/ cal l i s i s s u ed o n an o t h er G o v ern men t ag en cy o r i n acco rd an ce w i t h an d s u b j ect t o t erms an d co n d i t i o n s o f ab o v e n u mb ered co n t ract . T Y P E CA L L
O F P U RCH A SE O RD E R
S EE S CHEDUL E
24. UNITED STATES OF AMERICA TEL:
EMAI
CONTRACTING / ORDERING OFFICER q u a n t i t y o r d er ed , i n d i ca t e b y X . If d i f f er en t , en t er a ct u a l
BY: Michael Vicory
I f t h is bo x is m ark ed, sup p lier m ust sign A ccep t an ce an d r et ur n t h e fo llo win g n um ber o f co p ies:
N A M E O F CO N T RA CT O R SIGN A T U RE T Y P E D N A M E A N D T IT L E
( Y YY YM M M D D ) D A T E SI GN E D A CCE P T A N CE . T H E CO N T RA CT O R H E RE BY A CCE P T S T H E O FFE R RE P RE SE N T E D BY T H E N U M BE RE D P U RCH A SE O RD E R A S IT M A Y P RE VIO U SL Y H A VE BE E N O R I S N O W M O D I FIE D , SU BJE CT T O A L L O F T H E T E RM S
A N D CO N D I T IO N S SE T FO RT H , A N D A GRE E S T O P E RFO RM T H E SA M E . R eferen ce y o u r q u o t e d at ed
F u rn i s h t h e fo l l o w i n g o n t erms s p eci fi ed h erei n .RE F :
2 0 . Q U A N T IT Y O RD E RE D / A CCE P T E D * 2 1 . U N IT 2 2 . U N I T P RICE D IFF E RE N C E S 2 6 . IN SP E CT E D RE CE I VE D A CCE P T E D , A N D CO N FO RM S T O T H E CO N T RA CT E X CE P T A S N O T E D 2 7 a. Q U A N T IT Y I N CO L U M N 2 0 H A S BE E N ( Y YY YM M M D D ) c. D A T E d. P RIN T E D N A M E A N D T IT L E O F A U T H O RIZ E D GO VE RN M E N T RE P RE SE N T A T I VE b. SI GN A T U RE O F A U T H O RI Z E D GO VE RN M E N T RE P RE SE N T A T I VE e. M A IL I N G A D D RE SS O F A U T H O RIZ E D GO VE RN M E N T RE P RE SE N T A T IVE
36. I ce r t ify t h is acco u n t is co r r e ct an d p r o p e r fo r p aym e n t . g. E -M A I L A D D RE SS f . T E L E P H O N E N U M BE R a. D A T E ( YY YY M M M D D ) b. SI GN A T U RE A N D T I T L E O F CE RT I FY I N G O FFI CE R 2 8 . SH I P N O . 2 9 . D O VO U CH E R N O . 3 0 . IN I T IA L S 3 2 . P A I D BY 3 3 . A M O U N T VE RIFIE D CO RRE CT FO R 3 5 . BIL L O F L A D IN G N O . 3 4 . CH E CK N U M BE R 3 7 . RE CE IVE D A T 3 8 . RE CE IVE D BY ( Y YY YM M M D D ) 3 1 . P A Y M E N T CO M P L E T E P A RT I A L FI N A L P A RT I A L FI N A L DD Fo r m 1155, DEC 2001 P RE VI O U S E D I T IO N I S O BSO L E T E . 3 9 . D A T E RE CE IVE D 4 0 . T O T A L CO N T A IN E RS 4 1 . S/R A CCO U N T N O . 4 2 . S/R VO U CH E R N O . AD D R ES S AN D N AME (b) (4) (b) (6)
Section B - Supplies or Services and Prices
ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT
0001 1 Each $ $ NTE
FY11 Labor, EDW Maintenance FFP-LOE
FOB: Destination
PURCHASE REQUEST NUMBER: N0003310556301
NET AMT $ CEILING PRICE $0.00 ACRN AA CIN: N00033105563010001 $
ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT
0002 1 Each $0.00 $0.00 NTE
FY12 Labor, EDW Maintenance
This CLIN shall be funded in the amount of $ prior to the start of its period of performance. FFP-LOE FOB: Destination NET AMT $0.00 CEILING PRICE $0.00 $0.00 (b) (4) (b) (4) (b) (4) (b) (4) (b) (4)
Section C - Descriptions and Specifications STATEMENT OF WORK
STATEMENT OF WORK TASK TITLE: EDW MAINTENANCE SUPPORT
PERIOD OF PERFORMANCE: 03 March 2011 – 01 December 2011
COR/ACOR: As per base contract, Section G-3. Government PM:
Primary: Robert Walz, Alternate: Eric Doerfler,
1.0 SCOPE
1.1 Objective: The objective is to obtain contractor services in support in support of the MSC Enterprise Data Warehouse (MSC-EDW) Maintenance, in accordance with Section 4.4 of the base contract.
1.2 EDW Maintenance Requirements: This support includes the impact analysis, design,
development, testing and execution of system change requests for correction of system problems or enhancements requested to the EDW baseline by the MSC TPOC. The support personnel shall respond to user questions resulting from MSC Global Help Desk (GHD) Tier 2 inquiries and provide guidance on proper system process user interaction. The support also includes developing changes to EDW metric reports and associated data interfaces necessitated by customer processing and review.
2.0 GOVERNMENT FURNISHED EQUIPMENT/MATERIAL (GFE/GFM)
2.1 None
3.0 EDW MAINTENANCE TASKS AND DELIVERABLES
The contractor shall provide Maintenance support described as follows:
3.1 High-Level Task Summary. The contractor shall follow MSC internal processes as it relates to software maintenance activities as follows:
ID TASK DELIVERABLE
3.1 Develop CCRs Updated CCR forms
3.2 Perform Higher Level Requirements Analysis Requirements Documentation
3.3 Perform Detailed Requirements Analysis Detailed Requirements
Documents
3.4 Perform Alternative of Analysis (AoA) AoA Documentation
3.5 Create Functional Design Functional Design Documentation
3.6 Create Technical Design Technical Design
Documentation 3.7 Implement Technical Design to Include Deployable Multiple
Code
3.8 Create User Acceptance Test Scripts Test Scripts
3.9 Develop, Test and Implement Contingency Plan CP Updated and Tested CP
3.10 Perform Closeout Activities Close Out Documentation
3.11 Expenditure Burn-rate Reporting Monthly Maintenance Cost
Summary Report
3.2 EDW Maintenance Support. Contractor personnel shall possess minimum required skills with the hardware and software products identified in the Current Environment and Future
Environment listings below. The contractor shall provide a team whose collective functional and technical knowledge provides expertise in the software and hardware Current and Future environment listing. The contractor shall provide services on future versions of these
environment modules and/or other modules/COTS/GOTS products that provide the same function.
• CURRENT ENVIRONMENT
o Windows 2003 Server
o MicroStrategy Version 8.1.2 o Cognos Series 7 Version 4
o Red Hat Enterprise Linux Advanced Platform o Sybase IQ Version 12.7
o Sybase ASE Version 12.5.3
• FUTURE ENVIRONMENT
o Sun Solaris 10
o Sybase IQ v15.0 (64-bit) o Sybase ASE v15.0.3 (64-bit)
o Sybase ETL v4.9
o Windows 2003 Enterprise Server Edition, 64-bit MicroStrategy v9.0.2 The contractor shall evaluate the applicability of maintenance patch releases to the installed software baseline and recommend appropriate changes to the MSC configuration. The contractor shall provide release management support to facilitate migrating of changes from development and test to production instances and shall monitor software organization’s version changes, software expirations, and advise the COR accordingly
3.2.1 EDW Metric Reporting Support: The contractor shall provide personnel proficient in the areas of data warehousing and appropriate reporting methods and tools for standard and ad-hoc queries reporting. These personnel shall perform design, development,
implementation, and maintenance of the representative analysis and reporting approaches described below:
• MSC Data Warehouse development and implementation—this task comprises the development and implementation of data warehouse elements (warehouse and data marts as appropriate) and metrics to enable queries and analysis in support of the following efforts:
• Customer-defined Reporting—provide structure, metrics and appropriate reports for the analysis of areas pertinent to the emerging or existing data warehousing support of the MSC mission
• MBEC Support – provide operational support and metric interface and delivery for the Military Sealift Command Business Execution Cycle reporting needs
• Emerging Requirements—develop structure, metrics and appropriate reports to support emerging requirements analysis
• MSC-EDW Reports maintenance—the contractor shall maintain existing MSC-EDW
Reports
3.3 Tier III Help Desk: In accordance with section 4.4.1 of the base contract, the contractor shall assign personnel knowledgeable of the EDW implementation to provide Tier 3 Helpdesk resolution support for those issues which cannot be addressed by Global Helpdesk Tier 2 support. Personnel assigned to these tasks must have functional and technical knowledge of system processes and a detailed understanding of the capabilities of the products that comprise the EDW. The contractor shall provide:
• Trouble Ticket Tracking: The contractor shall aid MSC stakeholders to determine system issues, corrective solutions, and tracking of tickets and CCRs until closure.
• EDW Technical Functional Interface: Provide the service of an EDW functional interface between end users (customers) and the EDW metric development team to identify business requirements, document business rules, and interact with developers and stakeholders to prioritize, create or modify EDW metrics within the guidelines of MSC N63 software development policies
4.0 PERFORMANCE REQUIRMENTS SUMMARY (PRS)
Incentives, if applicable, are as per Section C.9.0 of the base contract.
Performance Requirement (Required Service) Desired Results of Performance (Outcome) Performance Standard Acceptable Quality Level (AQL) Performance Assessment (Sampling Method) Ensure MSC-EDW is maintained and supported IAW Microstrategy and DoD guidance 98% functional uptime (when the MCDC is operating fully) excluding scheduled maintenance outages and approved service
interruptions.
TIA-942 98% operational uptime Monthly reporting by
Operations Division Assist in IA Patching 99% completion of all IAVA patching 99% completion of all Government approved functionality patching Approved IA patching to occur within 90 days or as directed by IA authorities 99% completion of all IAVA patching 99% completion of all Government approved functionality patching Weekly Update Reports IAW section 5 of this SOW. Assist in incident and problem support/resolution 98% resolution of all incidents/problems Problem resolution to occur within appropriate 98% resolution of all incidents /problems Weekly Update Reports IAW section 5 of this SOW.
timeframe as determined by Program Manager, Customer, and EDW team on case-by-case basis Ensure software maintenance and modifications are completed in a timely manner 95% resolution of all maintenance and modification tasks Maintenance and Modifications timeframe to be determined by Program Manager, customers, and EDW team on a case-by-case basis 95% resolution of all maintenance and modification tasks Weekly Update Reports IAW section 5 of this SOW.
5.0 Deliverables
Deliverables will tend to be either Program / Project Management or Technical Deliverables. Program / Project Management Deliverables (e.g. Charter, Risk Management Plans, Project Plans (POA&Ms), Lessons Learned and Meeting Minutes) are described in section C4.1 of the base contract. Technical deliverables will be in accordance with sections C4.2 – C4.5 of the base contract and include items such as requirements documents, design documents, test plans and test scripts.
5.1.1 Weekly Updates
Requirements are as per the Monthly Status Report.
5.1.2 Monthly Status Reports (per section C8.4.1 of the base contract)
In accordance with the requirements set forth under paragraph C4.1.5 of the base contract, the contractor shall provide monthly status reports to the COR by the 15th day of each month, covering the previous month.
• The contractor shall provide a consolidated Plan of Action and Milestones as required. 5.1.3 Summary Cost Reports (per section C8.4.2 of the base contract)
The contractor shall prepare and submit a report concurrently with each invoice presented for payment. The contractor shall report expenses that can be invoiced under the contract. The report shall include labor expended for the period and cumulatively broken out to identify labor categories, labor rate and specific individuals utilized and the amount of labor hours expended by each; if applicable, labor expenses shall be reported at the SubCLIN level.
The contractor shall use the report format found in the Summary Contract Cost Report (Appendix J-12); alternate formats may be proposed and used, with prior approval of the Contracting Officer. Contractors must provide a cost summary sheet providing a breakout of costs per effort and cumulative costs as they relate to the budgeted amounts.
5.1.4 Monthly Burn Rate Status Report
This report shall include overall task order burn rate and granular costs specific to associated maintenance tasks assigned.
5.1.5 Program Management Reviews (per section C8.4.3 of the base contract)
• The first review will be conducted 90 days after award. Subsequent reviews will be done at three-month intervals.
• The contractor shall prepare and submit a Program Management Review (PMR) agenda to the COR 5 days prior to the PR meeting and prepare minutes within 5 days after the meeting.
5.1.6 Quarterly Financial Reporting This report shall include:
• Task Order title and number
• An overall summary of the past quarter • Total amount of funding obligated • Total amount of funding still available • Burn Rate
• Any changes to the burn rate identified
5.2 Format of Deliverables
All documentation deliverables shall be prepared using Microsoft Office products (Word, Excel, Project, and PowerPoint) in a format acceptable by the COR, unless the COR and contractor mutually agree to the use of other software. Delivery shall be via email unless otherwise specified.
Description of Deliverable Due Date Media Type Delivery Point(s)
Weekly Updates Weekly Via Email 1 copy to COR
1 copy to Govt PM Monthly Status Report by
Task
15th day of each month, covering the previous month
Via Email 1 copy to COR
1 copy to Govt PM
Summary Cost Report Concurrently with Contractor Invoice Via Email 1 copy to COR
1 copy to Govt PM Monthly Burn Rate Status
Report
15th day of each month, covering the previous month
Via Email 1 copy to COR
1 copy to Govt PM Program Management
Review Agenda
5 days prior to each PR meeting Via Email 1 copy to COR
1 copy to Govt PM Program Management
Review Meeting Minutes
5 days after each PR meeting Via Email 1 copy to COR
1 copy to Govt PM
Quarterly Financial Reporting Quarterly Via Email 1 copy to COR
Section F - Deliveries or Performance
DELIVERY INFORMATION
CLIN DELIVERY DATE QUANTITY SHIP TO ADDRESS UIC
0001 POP 03-MAR-2011 TO 30-SEP-2011 N/A N/A FOB: Destination 0002 POP 01-OCT-2011 TO 01-DEC-2011 N/A N/A FOB: Destination
Section G - Contract Administration Data
ACCOUNTING AND APPROPRIATION DATA
AA: 97 X 4 000 00033 0 000033 2F00000000000000000 AMOUNT: $
CIN N00033105563010001: $
FUNDS SEPARATED BY FISCAL YEAR
All lines of funding for this task order shall be clearly designated for use within a single Government fiscal year. Funding shall only be used as payment for services performed within the Government fiscal year for which that funding is designated. Funding will only be authorized for its designated fiscal year, and shall not in any manner be used for services performed outside of its designated fiscal year.
(b) (4)