Department Of Social Welfare And Development Main Tender

Description Request For Proposal (negotiated Procurement - Small Value Procurement – Consulting Firm) Hiring Of Consulting Services For The Development And Enhancement Of The Integrated Accounting, Budget, And Cash Information System (iabcis) Dswd Rfp No. 24-gop-svp-cf-012 (pr No. 2024121883) 1. The Republic Of The Philippines, Through The Department Of Social Welfare And Development – Information And Communications Technology Management Service (dswd-ictms) Cy2024 Funds Intends To Apply The Sum Of Nine Hundred Ninety-five Thousand Pesos (php995,000.00) Being The Approved Budget For The Contract (abc) For The Hiring Of Consulting Services For The Development And Enhancement Of The Integrated Accounting, Budget, And Cash Information System (iabcis) Under (dswd Rfp No. 24-gop-svp-cf-012). 2. Objectives The Consulting Firm Shall Be Engaged To Develop And Enhance Iabcis For The Aics System, Including The Creation Of The Software Requirements Specifications (srs) And The Detailed Development Process For The Module. The Scope Of Work Includes: A. Analyzing And Documenting The Business Requirements For The Fms Module, Ensuring Alignment With The Aics Program’s Objectives; B. Designing And Developing The Fms Module Based On The Defined Srs, Ensuring Seamless Integration With The Aics System; C. Conducting Comprehensive Quality Assurance Tests To Validate The Functionality, Security, And Performance Of The Fms Module; D. Assisting In The Deployment Of The Iabcis Within The Aics System, Including The Delivery Of Training To End-users And Technical Staff; And E. Providing Post-deployment Support And Warranty Services To Ensure The Module Operates Effectively Within The Dswd Domain, Addressing Any Issues Or Updates As Needed. 3. Scope Of Work The Consulting Firm Will Be Tasked With The Development And Enhancement Of Iabcis For The Aics System, Focusing On Delivering Key Outputs That Meet The Following Milestones: A. Project Planning. The Consulting Firm Shall Formulate An Inception Report Or Project Plan Indicating The Framework, Approaches, Methodologies, And Specific Timeline For Tasks, Activities, And Deliverables Of The Project, Including Privacy Impact Assessment. B. Requirements Analysis, Design, And Project Management. Conduct A Thorough Requirements Analysis, Create System Design, And Manage The Project. This Phase Includes Understanding Dswd’s Needs, Defining System Specifications, And Overseeing The Project’s Progress To Ensure Meeting Objectives. C. Software Development. Development And Enhancement Of Iabcis For The Aics System According To The Specified Requirements. This Involves Coding, Configuring, And Creating All Necessary System Components, Ensuring Functionality And User-friendliness. D. Testing. Perform Extensive Software Testing To Ensure It Meets All Functional, Security, And Performance Requirements. This Includes Identifying And Fixing Bugs And Verifying System Integrity And Efficiency. E. Deployment Support. Assist With The System’s Deployment In Dswd’s Environments, Including Support During The User Acceptance Testing (uat) Phase And Final Deployment In The Production Environment. F. Training Of Trainers. Design And Implement A Training Of Trainers For Managing And Using The Iabcis For The Aics System. G. Maintenance. Offer Maintenance Services Post-deployment For A Specified Support Period To Address Any System Issues, Updates, Or Enhancements. The Scope Of The Fms Module Development Includes The Following Essential Features And Functionalities: A. Data Capture, Recording, And Processing Of Financial Transactions • Allotments: Capture And Record The Approved Allotments For The Aics Program Within A Specified Year • Monthly Disbursement Plan (mdp): Enable The Creation And Export Of The Mdp For The Aics Program • Obligation Of Financial Claims: Facilitate The Preparation, Processing, And Approval Of Financial Claims • Notice Of Obligation Request And Status Adjustment (norsa): Manage Changes And Updates To Approved Obligation Request Status • Disbursement Voucher (dv): Streamline The Preparation, Processing, And Approval Of Payment Requests For Service Providers • Lddap:ada/check: Automate The Creation And Approval Of Advice To Debit Account (ada) For Payments From Available Notice Of Cash Allocation (nca) Balances • Issuance Of Bir 2307: Automate The Preparation And Issuance Of Withholding Tax Certificates For Financial Transactions B. Nca And Appropriation Management • Notice Of Cash Allocation: Generate And Export Notices Reflecting Available Cash, Which Are Linked To The Mdp And Appropriations Module C. Report Generation • Statement Of Allotment, Obligation, And Balances (saob): Provide Summaries Of Allotment Statuses, Obligations, And Balances In Exportable Excel/pdf Formats • Registry Of Allotment, Obligation, And Disbursement (raod): Produce A Detailed Log Of Financial Activities, Also Available For Export In Excel/pdf Formats D. Audit And Administrative Features • Activity Logs And Audit Trails: Track And Monitor User Activities And System Administration Processes For Accountability And Security E. Module Integration The Fms Module Will Interact With Key External Entities, Including: • Aics Personnel: For Inputting Program-related Financial Data • Aics Data: For Synchronizing Existing Program Data With The Fms System • Finance Personnel: For Processing And Monitoring Financial Transactions And Generating Reports • Btms And Iabcis Systems: To Ensure Interoperability For Streamlined Data Exchange And Financial Operations 4. Technical Specification A. General Requirements • Web-based Compatibility: The Financial Management Service (fms) Module Within The Aics System, Must Be Accessible Via Popular Web Browsers And Support Both Computer And Mobile Device Use. This Ensures Broad Accessibility And Ease Of Use For Diverse Users. • Cloud Deployment: The System Will Be Hosted On Dswd’s Cloud Infrastructure, Aligning With Modern Cloud-based Application Deployment Practices For Scalability And Reliability. • Compatibility With Dswd Infrastructure: The Fms Module Within The Aics System Must Be Compatible With Existing Dswd Digital And Cybersecurity Infrastructure, Ensuring Seamless Integration And Adherence To Security Standards. • User Load Capacity: The System Should Be Capable Of Handling User Traffic As Projected By Dswd, Ensuring Consistent Performance Even During Peak Usage Periods. • Licensing And Server Provision: Dswd Will Provide Licenses For Servers And Other Services That The Fms Module Within The Aics System Will Utilize In The Production Environment, Ensuring Compliance With Software Licensing Requirements. • Service Provider Access Limitations: The Consulting Firm Will Not Have Access To Dswd’s Production System. They Must Provide Comprehensive Instructions And Support For Dswd System Administrators For System Deployment And Setup. • Ownership Of Work Products: All Work Products, Including Software, Documentation, And Design Materials Developed For This Project, Will Be The Sole Property Of Dswd. B. Functional Requirements • Provision Of Process Flows, Use-cases, And Wireframes: Dswd Will Provide The Service Provider With Approved Process Flows, Use-cases, And Wireframe Diagrams. This Information Is Crucial For Guiding The Development Process And Ensuring Alignment With Dswd’s Operational Requirements. • Regular Cadence Meetings: The Service Provider Is Required To Conduct Regular Meetings With Dswd. These Meetings Are Intended To Address And Resolve Any Issues Or Questions Arising During The Software Development Process, Ensuring Smooth Progression And Alignment With Project Goals. C. Non-functional Requirement • Compliance With Cybersecurity And Data Privacy Policies: The System Must Adhere To All Dswd Cybersecurity And Data Privacy Policies. This Ensures The Protection Of Sensitive Data And Aligns With Legal And Regulatory Standards. • Real-time Audit Log Transmission: The Fms Module Within The Aics System Must Be Capable Of Sending Real-time Audit Logs To A Designated Syslog Server, Conforming To The Format Prescribed By Dswd. This Feature Is Crucial For Monitoring System Activities And Maintaining Security And Compliance. • Disclosure Of Third-party Libraries: The Service Provider Must Disclose All Third-party Libraries Used In The System’s Development. These Libraries Must Be Verified To Be Free From Security Vulnerabilities, Ensuring The Overall Security And Integrity Of The System. D. Software Quality Assurance (testing) • Comprehensive System Testing: The Service Provider Is Required To Conduct Thorough Testing Of The System To Ensure All Functionalities Work As Intended And Meet The Specified Requirements. • Security Vulnerability Assessment: The System Must Be Rigorously Tested For Known Vulnerabilities. The Service Provider Must Ensure The System Is Secure And Safeguarded Against Potential Cyber Threats. • Load Testing: The Service Provider Must Perform Load Testing To Validate The System’s Performance And Stability Under Varying Degrees Of User Traffic, Ensuring Reliability And Efficiency During Peak Usage. • User Acceptance Testing (uat): Dswd Will Conduct User Acceptance Testing To Ensure The System Meets Their Operational Needs And User Expectations Before Final Deployment. E. Deployment Environment • Provider’s Development And Testing Environments: The Service Provider Is Responsible For Developing And Testing The System Within Their Own Development And Testing Environments. This Ensures That Initial Development And Primary Testing Phases Are Handled Independently Before Uat. • Dswd’s User Acceptance Testing (uat) Environment: Dswd Will Provide A Separate Uat Environment. This Is Where Dswd Will Conduct User Acceptance Testing To Assess The System’s Functionality And Compliance With Specified Requirements Before Final Acceptance. • Dswd’s Production Environment: The Finalized System Will Be Deployed In Dswd’s Production Environment. This Is Where End-users Will Operationalize And Access The System, Ensuring A Real-world, Operational Setting For The Aics-gl System. 5. Work Deliverables And Payment Schedule Payment Tranches Deliverables Timeline % Of The Contract Price 1st Inception Report And Project Plan, Including Framework, Methodologies, And Timeline Within Five (5) Calendar Days After Receipt Of The Notice To Proceed 0% 2nd Business Process And Requirements Analysis (bpra) Report Within 10 Calendar Days After Acceptance And Approval Of Inception Report 15% 3rd System Requirements Specification (srs) Document Within 5 Calendar Days After Acceptance And Approval Of Bpra 15% 4th Approved System Design (wireframes, Use Cases) Within 10 Calendar Days After Acceptance And Approval Of The Srs Document 10% 5th Functional Iabcis With Complete Features, Api Integrations, And Accompanying Documentation Within 50 Calendar Days After Approval Of The System Design 30% 6th Test Reports For Performance, Vulnerability, Assessment, And User Acceptance Test Within 10 Calendar Days After The Completion Of The Development Phase 10% 7th User, Developer, And System Administrator Manuals Within 10 Calendar Days After Acceptance Of The Uat Reports 10% 8th Documentation Of Training Of Trainers, Training Manuals For Users Within 10 Calendar Days After Completion Of Training Sessions 5% 9th Final Project Completion Report, Including Sign-off Document And Packaged System Documentation (hard And Soft Copies, Including Source Codes) Within 10 Calendar Days After Acceptance Of System Documentation 5% The Consulting Firm Shall Develop The Fms Module Enhancement For The Aics System, In Accordance With The Scope And Deliverables Specified Above. The Solutions, Including The Information Systems And Applications, Are Expected To Be Delivered Within Four (4) Month Period For The Complete Project Implementation. 6. Institutional Arrangements The Consulting Firm Shall Report Directly To Ictms And Will Work Closely With The Pmb-cid And Fms As Business Owners. A Dswd Project Management Team For The Development And Enhancement Of Iabcis Will Also Be Created To Support The Consulting Firm. While The Location Of The Consultant Team May Be Flexible At Different Times Of The Project, It Is Expected That The Majority Of Consultancy Work And Activities Will Be Conducted In Quezon City And With The Dswd Project Personnel, Given That The Engagement With Business Owners And Stakeholders Is Critical To The Successful Delivery Of Outputs And The Project’s Scope Of Work And Requirements. 7. Ownership And Use The Dswd Financial Management Service (fms) Module For The Aics System, And Source Code That Will Be Developed Shall Be Fully And Exclusively Owned And Used By The Dswd And Shall Not Be Transferred In Favor Of Any Entity And In Any Other Mode. Intellectual Property Over The Design And Implementation Of The Requirements (including Custom Code And Configurations) Shall Remain With Dswd. Source Code Or Binaries, Database Schema And Definitions, Configuration Files And Build Artifacts, Documentation, And Any Other Custom-developed Artifact Of The Application Specifically Developed For This Project Must Be Submitted To The Dswd In Order For The End-users To Carry Out Independent Maintenance And Updating/modification Of The Application In The Future. The Complete Source Code And Scripts, Properly Versioned, Must Be Submitted To The Dswd Immediately At The Start Of The Implementation Phase. 8. Minimum Qualifications And Experience Of The Consulting Firm • With At Least Three (3) Successfully Completed Design, Development, And Operational Handover Of Detailed Information System (preferably Digital Social Protection Delivery System) Or Any Related Technical Implementation Documentation Across A Diverse Set Of Geographies And Industry Sectors. • With At Least Five (5) Years Of Experience As An Institution Working With Government On Design, Development, And Management Of Digital Solutions, Including Across Different Administrative Levels And Sectors. Demonstrable Knowledge Of Data Governance, And Data Interoperability. • With Sufficient Human Resources Possessing Technical Expertise In Areas Relevant To The Project, Such As Web-based Application Development And Cloud Services, The Consulting Firm Should Have Technical Personnel Or Staff Certified In Technologies Like Vue.js, Laravel, And Php For The Web Application Stack, As Well As Expertise In Ms Sql Server For Database Management And Other Relevant Certification That Is Applicable. 9. Budgetary Requirements: The Project Will Be Funded Under Ictms 2024 Current Funds For Nine Hundred Ninety-five Thousand Pesos (php995,000.00) For The Payment Of The Consultancy Services For The Development Of Integrated Accounting, Budget, And Cash Information System (iabcis). 10. Evaluation Criteria Qualification Rating With At Least Three (3) Successfully Completed Design, Development, And Operational Handover Of Detailed Information System (preferably Digital Social Protection Delivery System) Or Any Related Technical Implementation Documentation Across A Diverse Set Of Geographies And Industry Sectors 35% A. More Than Three (3) Successfully Completed Design, Development, And Operational Handover Of The Detailed Information System 35% B. At Least Two (2) Successfully Completed Design, Development, And Operational Handover Of The Detailed Information System 30% With At Least Five (5) Years Of Experience As An Institution Working With Government On Design, Development, And Management Of Digital Solutions, Including Across Different Administrative Levels And Sectors. Demonstrable Knowledge Of Data Governance, Data Interoperability 45% A. More Than Six (6) Years Of Experience As An Institution Working With The Government On Design, Development, And Management Of Digital Solutions, Including Across Different Administrative Levels And Sectors. Demonstrable Knowledge Of Data Governance, And Data Interoperability 45% B. At Least Five (5) Years Of Experience As An Institution Working With The Government On Design, Development, And Management Of Digital Solutions, Including Across Different Administrative Levels And Sectors. Demonstrable Knowledge Of Data Governance, And Data Interoperability 40% With Sufficient Human Resources Possessing Technical Expertise In Areas Relevant To The Project, Such As Web-based Application Development And Cloud Services, The Consulting Firm Should Have Technical Personnel Or Staff Certified In Technologies Like Vue.js, Laravel, And Php For The Web Application Stack, As Well As Expertise In Ms Sql Server For Database Management And Other Relevant Certification That Is Applicable 20% A. More Than One (1) Project Team Member Has Technical Certification Relevant To Web-based Application Development 20% B. At Least One (1) Project Team Member Should Have A Technical Certification Relevant To Web-based Application Development. Below Is The Preferred Project Team Composition: Role Quantity Project Manager 1 Developers 2-3 Ui/ux Designer 1 Quality Assurance (qa) Specialist 1 Business Analyst 1 Systems Administrator 1 15% Total 100% Passing Rate 85% Note: Failure To Meet Any Of The Minimum Requirements Per Criteria Stated Above Will Automatically Be Given A Zero (0%) Rating And Will Be Automatically Disqualified. 9. The Dswd Now Invites Interested Consulting Firms To Submit The Following: A. Company Profile/portfolio (highlighting The Years And Experiences Of The Firm And With Proof Of Engagements With The Government); B. Comprehensive Curriculum Vitae (cvs) Of The Project Team Members Including Evidences; C. Financial Proposal (annex A); D. Bir Certificate Of Registration; E. Mayor’s/business Permit; F. Income/business Tax Return; G. Duly Notarized Omnibus Sworn Statement With Secretary’s Certificate; And H. Proof Of Philgeps Registration/ Philgeps Registration Number. 10. The Required Documents Shall Be Submitted At The Address Below Or Through Email At Quotations@dswd.gov.ph Not Later Than 3 January 2025 At 5:00pm. 11. The Project Duration For Cy 2024 Is Four (4) Months Upon Receipt Of The Notice To Proceed (ntp). 12. The Consulting Firm Shall Be Required To Issue Official Receipt (or) As Acceptable Evidence Of Receipt Of Payment For Disbursements. The Chairperson Bids And Awards Committee C/o Bids And Awards Committee Secretariat As-procurement Management Division Dswd Central Office Ibp Road, Constitution Hills. Quezon City Telephone Nos.: (02) 8931 8101 To 07 Voip Nos. 10095 Email Address: Bacsec@dswd.gov.phquotations@dswd.gov.ph (original Signed) Monina Josefina H. Romualdez Undersecretary And Chairperson Bids And Awards Committee