input_data/BigPharma - Data Retrieval and Warehousing - SOW 19 - Fully Executed.txt

  1 
 
Statement of Work: Data  Retrieval and Warehousing  
 
STATEMENT OF WORK  
THIS AGREEMENT (“Statement of Work” or “SOW”) dated February 16 , 2024 , is between Acme, LLC 
(“Consultant” or “Acme”) and BigPharma Corporation  (“Client”  or “BigPharma” ).  
This Statement of Work is controlled by the terms and conditions set forth in the Master  Services  Agreement 
(“Agreement”) between the aforementioned parties dated October 13, 2021 , which references the following 
terms:  
Description of Services and Deliverables  
There has been an initiative with Acme and BigPharma to develop an API  to retrieve and store 
clinical trial management data from the Klugo  (AeoHospita)  vendor application . This will allow  for the stored 
data to be consumed by internal dashboards through SQL . The application will be responsible for 
chronological triggering t o reflect the live CTMS application.  
The implementation will utilize one (1) full -stack developer. The Acme full -stack developer will be 
responsible for the technical design, development, and initial quality assurance testing of full -stack software 
solutions, including database  and application  layers.  Developers will provide estimates for work items in their 
respective backlogs and leverage Azure DevOps to manage work items and forecast upcoming delivery. 
Developers should collaborate with other UT ABE team members on technical design for implementations and 
will follow current development best practices and established BigPharma conventions . 
Acme will collaborate with Klugo on CTMS API documentation and access to the CTMS application.  
Hyla ine and Client representatives will meet weekly to review the project status , identify  progress against 
agreed milestones, identify key risks, and remove roadblocks as needed.  
Acme shall ensure that any deliverables, including any strategy guidance etc., related to BigPharmas’ websites or other digital assets will conform to BigPharma standards for web 
accessibility and compliance (e.g. WCAG 2.1 level AA) ( “Access Standard”) unless otherwise agreed by BigPharma in writing. Conformance to the Access Standard shall be considered to be a condition of 
acceptance for any deliverables where such Access Standard is applicable.  
Acme  will use the followi ng deliverables and services  as a basis of work:  
 
D e liv e rable s : 
 Quality assurance -tested code, according to BigPharma’s standards.  
 Biweekly Status Reports.  
DocuSign Envelope ID: af558147-6fbd-4c0d-b9dc-8bc7355691b5 Technical designs, and other development or deployment artifacts.  
Ser v ices : 
 Participate in BigPharma IT Architecture and Business Enablement technical team activities, 
including but not limited to daily standups, design reviews, pair programming, sprint planning, and sprint 
review.    
o Collaborate with business analysts, business stak eholders, and other developers.    
o Create technical designs for new application modules, features, and development items.    
o Contribute to overall team deliverables, including status reports, sprint reviews, etc.    
 Conduct quality assurance testing for completed development items, potentially including unit testing, 
automated testing, and integration testing.    
 Utilize BigPharma DevOps  platforms to manage code repository and branching strategy to ensure 
a clean, current codebase.     
Delivery Schedule  
This engagement will begin within  90 days of the execution of the Statement of Work. Acme will provide one 
(1) full -stack developer for an estimated three  (3) weeks .  
Delivery of specific scope features will vary based on prioritization by BigPharma's business and 
estimation by developers. Delivery Schedules are estimates only, as completion dates assume the start date 
specified by this SOW and correctness of assumptions detailed in this document and in discussions with 
BigPharma. 
Investment  
Acme will provide the services and deliverables described above at a monthly per -Consultant rate of $24,000  
or weekly per -Consultant rate of $5,400 . Acme agrees to perform all services based on Client instruction, 
Client priority, an d available time; however, this does not guarantee completion or delivery of any 
functionality or schedule. For monthly flat -rate billing, Consultants typically work 40 hours per week, with 
variances to ensure delivery when necessary consistent with Hylain e’s Results -Focused culture. Consultant 
vacations less than a period of 10 business days are not deducted from invoicing rates.   
 
Hours over 55 per week per Consultant, regularly outside typical working hours, or weekend hours will be 
billed on a Time and Materials, Overtime rate of $300 per hour per Consultant. Acme will send invoices at 
the conclusion of each month to octoegg@example.com  with Tony Smith on copy at phhqkjy@demo.com .   
 
Should any Consultant be regularly required to work outside of core business hours (Monday -Friday 8am -6pm) 
as part of their project, Acme will invoice an additional $300 per da y per Consultant hazard fee.   
 
Based on the weekly  per-Consultant rate with contingency  of one week , the estimated cost after completion 
of tasks is $21,600. Per previous planning exercises, the time estimated to create the data retrieval and 
storage API i s three (3) weeks. These estimates are not guaranteed but are a fair representation of the  
potential  delivery time based on developer experience.    
 
 
DocuSign Envelope ID: C16C8CB2-B927-460F-900D-894B82C56485Project Constraints and Flexibility  
Any project must always balance three types of project constraints: Scope, Cost, and Time. Acme agrees to 
perform all services based on Client instruction, Client priority, and available time. Client  acknowledges that 
prioritizing two of the project con straints will necessitate flexibility on the third . 
Expiration  
This contract will expire if not executed by Client and received by Acme  by February 28, 2024 . 
Travel Expenses  
If Consultant is engaged to work outside of the ir home metropolitan area, Client agrees to pay for actual and 
reasonable costs incurred by Acme  for travel, living, and boarding, provided anticipated expenses are in 
accordance with Client’s travel policy. Acme  will render invoices for expenses upon completion of the 
services or monthly, in the event the duration of services exceeds one month. Invoices for expenses are 
payable upon receipt.  
Assumptions  
 All changes and change requests outside the defined Description of Services and Deliverables of this 
Statement of Work (i) will be accomplished in writing, (ii) will be executed by both parties, and (iii) may 
have cost and schedule implications if agreed upon in writing by Client. Acme will detail any changes to 
cost and schedule resulting from such changes in an execut ed Request for Change or SOW.   
 BigPharma will provide a team member who will take on the primary responsibilities for 
applicable project management, including status reporting, sprint review materials, etc.    
 BigPharma will share any av ailable previous vendor documentation and architecture related to 
the software applications in scope for the Acme developers.    
 Client will provide BigPharma credentials for Acme developers.    
 Client will provide access to any work manageme nt and collaboration tools, plus On -Premises or Cloud 
infrastructure as needed.    
 Client will facilitate communication between Klugo to ensure proper implementation of the data retrieval 
and storage API.   
 Client will provide reasonable access to key perso nnel in a timely fashion.   
 Client will provide guidance as to budgetary and licensing restrictions for tool selection.   
 Client is responsible for providing a technological and processing environment conducive to supporting the 
system selected by Client and  in accordance with the specifications recommended by the software 
publisher.    
 Client assumes complete responsibility for the selection, licensing and performance of all hardware and 
software. Consultant makes no claim, and accepts no responsibility whats oever, as to the suitability of 
such hardware and software applications for Client’s business operations and objective.   
DocuSign Envelope ID: 5792dac8-d8d4-48d1-907b-eba041badee4 Client will provide a development and testing environment for integration with other systems. If Client 
cannot provide such an environm ent, Client will accept any loss of productivity on production 
environments due to development, testing, deployment, and support of software on these systems.   
 Acme is not liable for changes to Client’s third -party systems, or the data therein, while wo rking in 
conjunction with the respective vendors of each system.   
 Client will provide a VPN connection to allow Acme to connect to their network remotely.    
 Acme expects and plans to perform all services in a continuous manner. Delays mandated by Cli ent will 
have cost and schedule implications. Acme will detail any changes to cost and schedule resulting from 
such slippage in an executed Request for Change.   
 Acme will deem all data provided by the Client for development and testing purposes as no t personally 
identifiable as described by GLBA and HIPAA, unless Client formally notifies Acme otherwise.    
 Client will encrypt and specifically label any data that any Federal or State act protects before providing 
such data to Acme for development and testing purposes.   
 Client will have five (5) contiguous business days to review provided deliverables and notify Acme of 
acceptance or required changes. If Client does not notify Acme within five (5) contiguous business days, 
Client will have acc epted the deliverable.   
 Formal training is outside the scope of this SOW.   
 Acme will perform the Services and Deliverables in a professional and workmanlike manner, consistent 
with industry standards and in accordance with the Agreement.   
 
IN WITNESS THEREOF, the parties have executed this Statement of Work as of this ____ day of ____, 2024 . 
 
 
Acme , LLC                                                                      BigPharma Corporation   
 
By: ____________________________ ________  By: _____________________________ __________  
Name: _ ______________________ __________      Name: _ ______________________________ ____ 
Title: _________________________ _____ _____     Title: ________________________________ _____  
 
 
DocuSign Envelope ID: 18fa0d76-6841-4267-bb02-648b29d54d66
Elon Musk
CEO
John Jackson
VP, CIOFeb.26th