Badges

75 Points
10 Years

User Activity

Almost 9 years ago
We connect to Google Analytics, EverHour, Asana, Authority Labs, and Google Docs. EverHour does not even have an API and we managed to automate ETL from it. All this in one month. Our client is, needless to say, very satisfied.
About 10 years ago
I see what you mean now One of the ways you can use this is by specifying a user-defined function in the Modified Javascript Value step. Pentaho uses Javascript as the scripting language. You can define this once within a tab that is marked as Start only (executed only once…
About 10 years ago
Do you mean something like an ORM layer that would allow your code to be database agnostic Pentaho ETL could run custom Java code (implemented as a user-defined Step) that has access to an ORM layer. We've done something similar when we need to access OpenERP (before the…
About 10 years ago
We frequently call Python scripts from within Kettle. So we have the best of both worlds Kettle's ETL scripts are no harder to maintain than source code. They are just text files that can easily be maintained within a version control system. The benefit is the visual…
About 10 years ago
Excuse me? Good for Windows but not for other operating system? I built 3 Data Warehouses so far using Pentaho on servers running Ubuntu and Debian Linux OS and one on Windows. There is nothing that can be said about Pentaho is better for either Operating Systems.
Over 10 years ago
Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho Reporting – Part 3 of 6
Almost 11 years ago
Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho BI Server – Part 2 of 6

Projects

About 10 years ago
Application Development Project
A new service: Automated report and dashboards for businesses that is not yet ready for a full-blown Data Warehouse

About me

I solve data management problems for companies in various sectors of industry: Airline Travels, Energy Bill Management, Manufacturing, Commercial Printing/Publishing, Transportation and Logistics, Health Care, and Software Development.

Specializing in building Data Warehouses, designing and implementing BI tools and processes, Change Management, OLAP database schemas, and ETL transformations, I also provide ERP solutions to businesses and organizations.

Specialties: Data Warehouse design and implementation, Business Data Management, BI System Optimization and Training, SDLC, Change Management, Team Building, ETL, Pentaho, OpenERP

Interesting Projects and Accomplishments