One of the good things about consulting is end to end programming. Typically you're involved in the entire life cycle of the project.
From scoping a project out, to creating a Statement of Work, to designing the data model, the ETL, the OLAP cube, the reports, the Dashboard, perhaps integration with SharePoint, Active Directory, Security Groups, documentation and moving to production.
I prefer playing the role of Utility Player. I like to jump from task to task, wherever needed on any particular day.
A few weeks ago, I was working on a project, much of the ETL was already done, dozens of reports were in the process of passing Quality Assurance. I mentioned to the client that I could speed up the Crystal Reports. They asked how.
So they gave me a sample report, which was running slow, over 8 minutes. I did a few tweaks, all withing the Crystal Reports developer - no changes to the SQL pointing to the Business Object Universe, the report ran in 4 minutes. Shaved off 1/2 the time. Then I did a few more tweaks, and it ran in under 2 minutes. Shaved another 50% off.
The goal was to run under a minute, but the Production server should have more processors and memory, so I'm guessing it will meet the 1 minute requirement.
Now all the reports will get the same tweaks, and the run times should be much faster.
And then on to the next task.
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Data becomes information. Information adds value if used properly to align business practices, streamline processes with net result of incr...
Data is the new oil. Sort of a good analogy. Except new oil is constantly required. And there is only so many oil wells on the planet. A...
What do you want to do when you grow up. For some of us, we still haven't decided. After close to 50 years. Chances are, if you chos...