Paranaque City Government Tender

Description I. Phase 1.3 :database Integration And Design (api Integration Module) - 1 Lot -1.consulting And Ideation: *conduct In-depth Analysis Of Current Business Processes, Then Design And Incorporate Optimized Workflows Into The Solution. *gap Analysis: Evaluation Of Existing Systems And Processes To Identify Areas For Improvement. *provide Technical Expertise And Guidance In Application Design And Software Architecture. *define Robust Data Frameworks, Structures And Flows For Efficient Data Management And Enhanced Connectivity. *collaborate With End-users In The Design Of User-friendly And Visually Appealing Interfaces That Are Also Optimized In Function. *develop Preliminary Design Concepts For The User Interfaces Of Both Modules -2.database Integration And Design: *database Design: Designing An Optimized Data Schema For Data From Integrated Modules. *database Development: Implementation Of The Designed Databases, Including Tables, Relationships, And Indexes. *data Migration: Secure Transfer Of Existing Data Into The New Databases *integration: Establishing Data Flow Between The Modules And Ensuring Compatibility With The Executive View Dashboard. *security Implementation: Implementing Robust Security Measures To Safeguard Sensitive Data. -3.ui/ux*wireframing: Create Wireframes And Interactive Prototypes To Visualize The Application's Structure And User Flows. *ui Design: Develop A Modern And Responsive User Interface, Including Graphics And Design Assets. •adaptive User Interfaces Designed To Accommodate Different Relevant User Categories. *ux Design: Optimize User Workflows And Interactions To Ensure A Seamless And Engaging User Experience -4.create Barleeblue Platform Compatible Api Integration Module From Other City Departments/offices: *the Api Integration Module Will Serve As A Centralized Platform That Facilitates Seamless Communication And Data Exchange Between Different Departments And Office Systems Within The City. *the Api Module Will Ensure Real-time Or Near Real-time Synchronization Of Data Across Departments. *the Api Module Will Include Role-based Access Controls, Allowing Departments To Access Only The Data They Are Authorized To View. This Ensures That Sensitive Information Is Protected While Enabling Efficient Inter-departmental Communication. *all Api Calls Between Departments Will Be Encrypted And Authenticated Using Industry-standard Protocols Such As Oauth 2.0 Or Api Key Authentication. This Ensures That Only Authorized Users Or Systems Can Access Or Modify Data. *the Module Will Aggregate Data From Different Departments, Enabling To Generate Reports Across Multiple Departments. -5.create Barleeblue Platform For Verification, Certification, And Clearance Of Payment Records Module: •create A Module For Issuing Certified True Copies Of Previous O.r. Paid To The City’s Treasury Department Upon The Taxpayer’s Request. •streamline The Existing Verification Process Of Records, Certifications, And Clearance Of Payment Records Into The Platform. •automate The Verification Of Payment Records Against Financial Databases To Ensure Accuracy And Compliance Before Issuing Certifications. -6.create Barleeblue Platform Compatible Consolidated Financial Reporting (cfr) Module: •the Consolidated Financial Reporting (cfr) Module Aims To Provide An Automated, Centralized Platform For Financial Reporting That Complies With The Department Of Finance’s Electronic Statement Of Receipts And Expenditures (esre) Standards. •leveraging The Api Integration Module, This Module Will Gather And Consolidate Financial Data From Various Departments Into A Unified Platform, Ensuring Real-time, Accurate, And Compliant Financial Reporting. •the System Will Maintain A Comprehensive Audit Trail Of All Access And Report Generation Activities. •role-based Access Controls Will Be Implemented To Ensure That Only Authorized Personnel Can View The Reports. -7.executive View Dashboard – Eric 2.0 Real Time Integration •integrated With The Consolidated Financial Reporting Module, This Dashboard Will Offer Decision-makers Instant Access To Key Financial Indicators, Performance Metrics, And Compliance Data, Enabling Better Governance, Faster Decision-making, And Improved Fiscal Management. •the Dashboard Will Display Real-time Financial Data Consolidated From Various Lgu Departments. •the Executive View Dashboard Will Adhere To Strict Security Protocols, Including Role-based Access Controls, To Ensure The Safety And Confidentiality Of Financial Data. 8.cloud Infrastructure Set-up And Deployment •design Optimal Server Architecture For A Cloud-based System, Providing Access For Taxpayers And Government Staff From Any Location With An Internet Connection. •ensure That Below Security Protocols Are Observed When Setting-up And Deploying In The Cloud.oenable Multi-factor Authentication (mfa) Ocreate And Assign Appropriate Permissions To Users And User Groups.oenable Firewalls.oenable Logging And Monitoring Of System Activities. •set-up Sdlc Environments For Development, Testing/staging, And Production. Note: Aws Subscription Not Included. •setup Scheduled And Automatic Backup Of Application And Database In Cloud Server. •set-up Application And Server Monitoring To Send Alerts For Cases Of Service Interruption And Unusual Resource Utilization. 9.user Acceptance Test •conduct User Acceptance Test Prior To Implementation. 10.training And Warranty •conduct 1 Session User Training •free 6 Months Technical Support And Warranty Upon Signing Of The User Acceptance Testing (uat). After Which, The Maintenance Agreement Commences (separate Quotation). Benefits: Implementing This Project Yields Multiple Benefits For The Organization, Including: 1.enhanced Visibility: The Platform Enables Access To The Latest Data, Enhancing Collaboration And Decision-making To Encourage Informed Strategic Planning For The Parañaque City Local Government. 2.improved Customer Experience: Simplifies Application And Approval Processes For Business And Residents, Resulting In Faster Turnaround Times For Permits And Licenses. 3.compliance: The Platform Supports Compliance With Local Regulations And E-sre Requirement For Report Generation. 4.data Consistency And Accuracy: The Platform Reduces The Risk Of Errors And Discrepancies By Maintaining A Unified Reference Point For All Integrated Offices’ Data. 5.increase Efficiency: The Platform Reduces Processing Times, And Ensures Accurate Record-keeping, Ultimately Improving Service Delivery To The Public. Ii. Phase 1.2 : Database Intergration And Design For Rpt - 1 Lot -1.consulting And Ideation: *conduct In-depth Analysis Of Current Business Processes, Then Design And Incorporate Optimized Workflows Into The Solution. *gap Analysis: Evaluation Of Existing Systems And Processes To Identify Areas For Improvement. *provide Technical Expertise And Guidance In Application Design And Software Architecture. *define Robust Data Frameworks, Structures, And Flows For Efficient Data Management And Enhanced Connectivity. *collaborate With End-users In The Design Of User-friendly And Visually Appealing Interfaces That Are Also Optimized In Function. *develop Preliminary Design Concepts For The User Interfaces Of Both Modules. -2.database Integration And Design: *database Design: Designing An Optimized Data Schema For The Following–rpt Idle Land, Amnesty, Delinquency Notice, Redemption Of Real Property, And Treasury Records Management Modules. *database Development: Implementation Of The Designed Databases, Including Tables, Relationships, And Indexes. *data Migration: Secure Transfer Of Existing Data Into The New Databases. *integration: Establishing Data Flow Between The Modules And Ensuring Compatibility With The Executive View Dashboard. *security Implementation: Implementing Robust Security Measures To Safeguard Sensitive Data. -3.ui/ux - Wireframing: Create Wireframes And Interactive Prototypes To Visualize The Application's Structure And User Flows. *ui Design: Develop A Modern And Responsive User Interface, Including Graphics And Design Assets. *adaptive User Interfaces Designed To Accommodate Different Relevant User Categories. *ux Design: Optimize User Workflows And Interactions To Ensure A Seamless And Engaging User Experience. -4.create Barleeblue Platform Compatible Rpt Idle Land, Amnesty, And Delinquency Notice Modules: •idle Land Module *create A Module For Identification And Management Of Undeveloped Or Underutilized Land Within The City Jurisdiction (idle Land) *implement A Tax Engine That Calculates Property Taxes Based On The Assessed Land Value, Its Utilization, Zoning, And Local Tax Codes. Adjust Tax Rates For Idle Or Underused Land To Encourage Optimal Usage *implement A System Of Dynamic Tax Rates That Adjust Based On A Set Of Pre-defined Factors. •amnesty Module *the City Will Be Able To Define The Scope Of The Amnesty Program (e.g., Tax Years Covered, Percentage Of Penalties Waived). *set Timelines For The Availability Of The Amnesty Program (start And End Dates). *specify Eligibility Criteria (e.g., Must Be A Registered Taxpayer, Must Not Have Pending Legal Cases Regarding Property, Etc.). *provide Automated Eligibility Assessments, Eligibility Applications Tracking, And Reporting Of Amnesty Programs Implementation. *present Taxpayers With A Recalculated Bill Reflecting The Tax Relief, Showing Both The Original And Reduced Amounts. •delinquency Notice Module *the Module Will Generate And Send Automatic Notices Of Delinquency To Property Owners Whose Taxes Are Overdue. *the Delinquency Notice Module Will Cross-check With The Amnesty Module And Include Information About Eligibility For Tax Relief In Delinquency Notices, Encouraging Delinquent Taxpayers To Apply For Amnesty Where Applicable. *automatically Calculates And Applies Penalties And Interest As Specified By Local Regulations For Late Payments, Giving Real-time Updates On The Taxpayer’s Outstanding Balance. -5.create Barleeblue Platform Compatible Treasury Records Management And Workflow Module: •enable Data Correction Of Records And Transactions For Erroneous Data, Strictly Under The Credentials Of The Treasurer With Audit Logs And Related Security Measures. *create And Enable Approval Workflow For Different Departments Involved On Data Corrections (with Audit Logs). -6.executive View Dashboard – Treasury Department Integration*enable Reporting Capabilities In The Executive View Dashboard For Data Integrated From The Assessor And Treasury Modules. *provide A Web-based Interface To View And Manage Rpt And Treasury Transactions On The Executive View Dashboard. *centralize Capabilities Included In This Phase Of Development Secured Through Role-based Access. *provide Overview Reports For Financial Data Available On The Platform Included In This Phase Of Development. •provide Access To An Amnesty Monitoring Dashboard Showing Real-time Statistics On Amnesty Applications, Total Taxes Collected, And The Number Of Resolved Delinquent Accounts. -7.cloud Infrastructure Set-up And Deployment *design Optimal Server Architecture For A Cloud-based System, Providing Access For Taxpayers And Government Staff From Any Location With An Internet Connection.*ensure That Below Security Protocols Are Observed When Setting-up And Deploying In The Cloud. *enable Multi-factor Authentication (mfa) *create And Assign Appropriate Permissions To Users And User Groups. *enable Firewalls. *enable Logging And Monitoring Of System Activities. *set-up Sdlc Environments For Development, Testing/staging, And Production. Note: Aws Subscription Not Included. *setup Scheduled And Automatic Backup Of Application And Database In The Cloud Server. *set-up Application And Server Monitoring To Send Alerts For Cases Of Service Interruption And Unusual Resource Utilization. -8.user Acceptance Test *conduct User Acceptance Test Prior To Implementation. -9.training And Warranty *conduct 1 Session User Training *free 6 Months Technical Support And Warranty Upon Signing Of The User Acceptance Testing (uat). After Which, The Maintenance Agreement Commences (separate Quotation). Benefits: Implementing This Project Yields Multiple Benefits For The Organization, Including: 1.enhanced Visibility And Control: Improves Operational Efficiency, Supports Decision-making, And Ensures Accurate Record-keeping Over Treasury Collections Operations. 2.compliance: The Platform Supports Compliance With Local Regulations And Protects Property Rights. 3.increased Revenue: Encourages Prompt Payment, Reduces Revenue Loss, Supports Financial Recovery, And Fosters A Cooperative Relationship Between Taxpayers And Local Authorities. 4.increased Efficiency: Enhances Processes For Idle Land Identification And Collection, Amnesty Application, Delinquency Notification, Real Property Redemption And Treasury Workflows. 5.data-driven Decision Making: Real-time Dashboards Will Allow Decision-makers To Monitor The Effectiveness Of The Amnesty Program And Delinquency Notices, Enabling Adjustments To Policies If Necessary. Iii. System Phase 1.1: Rpt-collection And E-fass Module And Executive View Dashboard-rpt And Assessors Integration - 1 Lot This Is A High-level General Scope Of Service And Is Subject To Change Upon Acceptance Of Proposal And Data Gathering. Consulting And Ideation: Conduct In Depth Analysis Of Current Business Processes, Then Design And Incorporate Optimized Workflows Into The Solution.; Gap Analysis: Evaluation Of Existing Systems And Processes To Identify Areas For Improvement.; Provide Technical Expertise And Guidance In Application Design And Software Architecture.; Define Robust Data Frameworks, Structures And Flows For Efficient Data Management And Enhanced Connectivity.; Collaborate With End-users In The Design Of User-friendly And Visually Appealing Interfaces That Are Also Optimized In Function.; Develop Preliminary Design Concepts For The User Interfaces Of Both Modules.; Database Integration And Design:database Design: Designing An Optimized Data Schema For The Rpt Collections And Efaas Modules.; Database Development: Implementation Of The Designed Databases, Including Tables, Relationships, And Indexes.; Data Migration: Secure Transfer Of Existing Data Into The New Databases.; Integration: Establishing Data Flow Between The Modules And Ensuring Compatibility With The Executive View Dashboard.; Security Implementation: Implementing Robust Security Measures To Safeguard Sensitive Data. Ui/ux: Wireframing: Create Wireframes And Interactive Prototypes To Visualize The Application's Structure And User Flows.; Ui Design: Develop A Modern And Responsive User Interface, Including Graphics And Design Assets.; Adaptive User Interfaces, To Accommodate Different Relevant User Categories.; Ux Design: Optimize User Workflows And Interactions To Ensure A Seamless And Engaging User Experience. Create Platform Compatible Rpt-collections Module: Enable Current Rpt-collections Modules On The Platform Which Include: Billing, Payments, Online Payment, Collection Report, Tax Clearance, And Or Details.; Create Platform Compatible Efaas Module: Update Property Appraisals And Assessments Based On Different Real Property Transactions Such As: Property Transfers, Property Subdivision, Property Consolidation, Re Assessment, And New Tax Declaration.; Generation Of Sequence Numbers For Assessment Of Real Property Numbers Or Tax Declaration Numbers For Transactions.; Manage Assigned Pins.; Provide Flexibility In Assessment Calculations By Enabling The Use Of Different Data Sources For Calculations Such As Fair Market Value, Base Unit Of Construction Cost, And Assessment Level Per Assessed Value.; Executive View Dashboard – Rpt And Assessor Integration: Enable Reporting Capabilities In The Executive View Dashboard For Data Integrated From The Assessor And Rpt Modules.; Provide A Web-based Interface To View And Manage Rpt And Assessor Data And Transactions On The Executive View Dashboard.; Centralize Capabilities Included In This Phase Of Development Secured Through Role-based Access.; Provide Overview Reports For Financial Data Available On The Platform Included In This Phase Of Development Cloud Infrastructure Set-up And Deployment: Design Optimal Server Architecture When Provisioning For A Cloud-based System. Usage Of Cloud Infrastructure Enables Access From Anywhere With An Internet Connection, Ensuring Convenience For Taxpayers And Government Staff. Ensure That Below Security Protocols Are Observed When Setting-up And Deploying In Cloud: Enable Multi-factor Authentication (mfa), Create And Assign Appropriate Permissions To Users And User Groups., Enable Firewalls. Enable Logging And Monitoring Of System Activities.; Set-up Sdlc Environments For Development, Testing/staging, And Production. Note: Aws Subscription Not Included. Setup Scheduled And Automatic Backup Of Application And Database In Cloud And On-premise Server. Set-up Application And Server Monitoring To Send Alerts For Cases Of Service Interruption And Unusual Resource Utilization. User Acceptance Test: Conduct User Acceptance Test Prior To Implementation.; Training And Warranty: Conduct 1 Session User Training; Free 6 Months Technical Support And Warranty Upon Signing Of The User Acceptance Testing (uat).