
Closed
Posted
Paid on delivery
I need a fast, clean configuration of financial reports inside Mifos X/Fineract using Pentaho. The focus is on loans and savings—everything that helps our branch teams track disbursements, repayments, balances, and overall portfolio quality in one click from the Mifos reporting menu. You will start from my current instance (already running Fineract 1.x with Pentaho connected) and: • Build or adapt Pentaho .prpt files that surface the key loan and savings metrics we rely on • Wire the datasets to the existing Mifos datamart so the reports refresh automatically • Expose the finished reports in the “Loan and Savings Reports” section of Mifos with the correct permissions and parameter filters (branch, date range, product) • Provide both Tables and Detailed Summary Reports in British English and the correct Locale • Provide a short hand-off doc or screencast showing where the data sources are mapped and how to tweak parameters for future products Everything should slot straight into the production server with minimal downtime; I’ll give admin access to the staging server first then to live server once verified, the moment we agree on the structure. Deliverable is the complete Loan & Savings report pack, fully tested and ready for staff to run. Please include a brief outline of how you plan to approach the ETL queries and any similar Pentaho-on-Mifos work you’ve completed. Looking forward to getting this live quickly. PS: I already have some of the Pentaho templates installed and I am on the latest Fineract version.
Project ID: 40511353
10 proposals
Remote project
Active 23 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $18 USD for this job

Hello, I have carefully read your requirements, and it would be an honor to assist with your Mifos X/Fineract Pentaho reporting setup. With 14+ years of experience in enterprise applications, database reporting, ETL processes, and custom reporting solutions, I can configure and optimize your Loan & Savings report pack using Pentaho while ensuring seamless integration with your existing Fineract environment. My approach will involve reviewing the current Pentaho templates and datamart structure, optimizing ETL queries for performance, building or enhancing .prpt reports for loan and savings analytics, configuring branch/date/product filters, and exposing the reports within the Mifos reporting menu with proper permissions and British English locale settings. I will thoroughly test all reports on the staging environment before deployment to production, ensuring accurate calculations, fast execution, and minimal downtime during rollout. A complete handover document and/or screencast will be provided, covering datasource mappings, report parameters, and future maintenance procedures for your team. Please check my profile for client reviews and ratings that reflect the quality and reliability of my technical work. I would be happy to discuss your existing templates and reporting requirements in more detail. The project budget and timeline can be discussed further after reviewing the current report pack and data structure. Warm Regards, Harpreet Singh
$20 USD in 5 days
3.6
3.6

With over 10 years of solid experience in full-stack development, particularly in web and database management, I am well positioned to tackle your Mifos X/Fineract Pentaho Loan & Savings Reports Setup project. My fluency in languages such as Node.js, PHP, and Python combined with proficiency in different frameworks: React, Vue.js, Django, and Laravel will be key in building or adapting the required Pentaho .prpt files. Working on APIs and Integrations like REST will also facilitate deploying and wiring datasets to ensure automatic refreshing of reports. It's noteworthy that I’ve handled several similar projects that require ETL queries using Pentaho-on-Mifos configuration previously. This guarantees that I'm familiar with the task at hand. Additionally, having worked extensively with various databases including PostgreSQL and MySQL bodes well for navigating your specific Mifos datamart. Rest assured that our journey together would be marked by clean code, clear communication and on-time delivery which in turn ensures minimal downtime for your production server. Finally but importantly, I am committed to providing post-project support inclusive in my services— it’s never really over until my client is satisfied. I’d be glad to provide a powerful digital solution for your business through the Mifos X/Fineract Pentaho Loan & Savings Reports Setup project so let’s connect and get this done quickly.
$20 USD in 7 days
3.6
3.6

Hi, I can help configure the Loan and Savings report pack in your current Mifos X/Fineract setup with Pentaho. I have experience working with financial reporting, SQL datasets, Pentaho .prpt reports, and production-style banking or microfinance systems. My approach would be to first review your existing templates, datamart tables, report parameters, and permissions, then adapt or build the required loan and savings reports with branch, date range, and product filters. I will focus on clean ETL queries, accurate portfolio figures, disbursement, repayment, balance, and summary metrics, while keeping the reports easy for staff to run from the Mifos reporting menu. I can also provide a short hand-off note showing the data mappings and how to adjust parameters later.
$20 USD in 7 days
0.0
0.0

Went through the details carefully and I know what needs to be done. New to Freelancer but 7 years of backend experience. Can start today — what's the best way to share access?
$10 USD in 5 days
0.0
0.0

Hello, I’m interested in helping configure and deliver a production-ready Loan & Savings reporting pack for your Mifos X/Fineract environment using Pentaho with minimal downtime. Based on your requirements, my approach will begin with reviewing the current Fineract 1.x + Pentaho setup, existing templates, and datamart structure to avoid unnecessary redevelopment and ensure compatibility with your latest environment. For report development, I will build or adapt .prpt reports focused on the operational metrics your branch teams need, including loan disbursements, repayments, balances, portfolio quality, and savings performance. Reports will include both detailed and summary table formats in British English with the correct locale configuration. For ETL and data integration, I’ll map datasets directly to the existing Mifos datamart, optimise SQL queries for refresh performance, and configure parameter filters such as branch, date range, and product selection. I’ll also configure permissions and expose reports correctly inside the Mifos “Loan and Savings Reports” menu. Final delivery will include tested reports, deployment support, and a short hand-off guide covering datasource mapping and future parameter updates. Best regards, [NUR ALIESYAH DALILAH]
$15 USD in 2 days
0.0
0.0

Hi! I can help you configure the Pentaho reports and connect them properly with your existing Mifos/Fineract data structure. My approach would be: 1. Review your current Pentaho setup, sample reports and database schema. 2. Check the SQL queries, joins, filters and parameters needed for loan and savings reports. 3. Create or adjust the .prpt reports with the required metrics. 4. Test everything first in the test environment before moving to production. 5. Deliver a short summary explaining the setup and how future parameters can be adjusted. I have experience with SQL, data analysis, database queries and web systems, and I can work carefully to keep downtime minimal. I can start by reviewing the existing models and then deliver the first working report for validation before completing the full package.
$20 USD in 4 days
0.0
0.0

With a solid foundation in sophisticated Database Management and SQL, my team at Shambhu Mobility & Tech Ventures is fully equipped to tackle your Mifos X and Fineract Pentaho project with the utmost precision and speed. Drawing from our extensive experience in Systems Engineering and Custom Backend Architectures, we have the intricate know-how needed to build or modify Pentaho .prpt files to showcase vital loan and savings metrics efficiently. Additionally, our expertise in relational database systems such as MySQL will enable us to effectively wire the datasets to your existing Mifos datamart, ensuring automatic report refreshments. Furthermore, our Corporate Data Automation capabilities align perfectly with the need for fast and smooth reporting structures and advanced scripting solutions can guarantee excellent performance of your reports on any scale. We focus on delivering not just functional but also secure solutions, and that is why we prioritize transactional data security using top-of-the-line DBMS frameworks. To top it all off, you would benefit greatly from our structured approach to projects. We will
$10 USD in 7 days
0.0
0.0

Hi William, You want a clean Loan & Savings report pack in Pentaho, surfacing disbursements, repayments, balances and portfolio quality in one click from the Mifos menu, deployed safely from staging to live. My ETL / query approach: 1) On staging, review your datamart and existing .prpt templates so reports follow your data model (m_loan, m_loan_transaction, m_savings_account, office hierarchy). 2) Parameterised SQL bound to Pentaho params ${branchId}, ${startDate}, ${endDate}, ${productId}, with office-hierarchy filtering for branch vs head-office roll-ups. 3) Validate each metric (outstanding principal, PAR buckets, repayments vs expected) against Fineract's own portfolio figures before sign-off. 4) British English labels, en_GB locale, correct currency/number formatting. 5) Table + Detailed Summary versions under "Loan and Savings Reports" with the right permissions, plus a short hand-off doc/screencast. I test fully on staging, then promote validated .prpt files to production: low-risk, no downtime. Background: Fintech, SQL financial reporting and data modelling; comfortable with Fineract's loan/savings schema and Pentaho authoring. One clarification: the brief says Fineract 1.x but your PS says latest version. Could you confirm the exact version? It affects how the datamart and data sources are wired. I can start as soon as I have staging access. Best regards, Esaie
$20 USD in 7 days
0.0
0.0

Hello, I can help configure the Loan and Savings report pack inside your existing Mifos X / Fineract and Pentaho setup. My approach would be to first review your current Pentaho templates, existing datamart, report categories, permissions and available filters. Then I would build or adapt the required `.prpt` reports for key loan and savings metrics, including disbursements, repayments, balances, overdue loans, portfolio quality, deposits, withdrawals and branch/product summaries. For the ETL and query side, I would keep the solution clean and production-safe. I would reuse the existing Mifos datamart where possible, write optimized SQL datasets with parameters for branch, date range and product, and avoid unnecessary changes to core production tables. For complex summaries, I would use reporting views or datamart logic so the reports stay fast and easy to maintain. The finished reports would be added to the correct Mifos reporting section with permissions, British English labels, locale formatting and tested filters. I would also provide a short hand-off document showing the mapped data sources and how to adjust parameters for future products. I suggest starting on staging, validating all outputs, and then deploying to production with minimal downtime. Best regards, Vladimir Trifonov
$20 USD in 7 days
0.0
0.0

London, Nigeria
Payment method verified
Member since Nov 19, 2006
$30-250 USD
$30-250 USD
$30-100 USD
$30-250 USD
$30-250 USD
$15-25 USD / hour
$250-750 USD
$15-25 USD / hour
$250-750 USD
$250-750 USD
₹10000-200000 INR
₹1500-12500 INR
₹12500-37500 INR
$250-750 USD
₹75000-150000 INR
€12-18 EUR / hour
₹750-1250 INR / hour
$500-1000 USD
£10-20 GBP
₹12500-37500 INR
₹600-1500 INR
₹1500-12500 INR
$2-8 USD / hour
$25-50 USD / hour
₹100-400 INR / hour