I'm kind of excited about the latest project. Started last Tuesday. Build a data warehouse from a SQL NAV system. Luckily a previous developer started a DW, then left.
So I picked up where they left off. Unfortunately, they didn't use proper naming conventions nor did they implement a staging area.
So I gutted almost everything except for the Dim Tables, as they pointed to the correct source tables, not much to change there.
I mapped out all the fields needed for the reports, a total of 83. Next, mapped the fields to the NAV database. Then created the fact tables and constraints pointing back to the Dim tables.
So the client said it would be okay to create the first set of reports in SSRS page viewer in SharePoint. So I built all seven reports. This morning they went to QA. Had some executives sit at my workspace in the war room, and we went over each of the reports, couple of changes here and there on the fly, deployed back to SharePoint, saved in Team Foundation Server and it's looking pretty good.
One of the executives said they've been waiting on these reports for two years and couldn't believe I did them in a week.
I've always considered my skills to be at the Senior level. This project was a confidence booster to some degree. As I performed the work unassisted, with a tight deadline and no prior knowledge of the line of business or database. I think the end result is solid and hopefully the clients are pleased with the results. I think the role on this project was more of an architect.
And I built a data warehouse with 10 dim tables, 10 fact, complete ETL in SSIS with some complex SQL and SSRS reports into SharePoint. And I built the Security model as well to use the NT Authenticated user passed in from SharePoint to limit the result set to specific users based on a table in the NAV system.
Based on my original estimate, 98-119 hours, I should finish up at 73. And I built an SSAS cube because I thought the PowerView Dashboards were getting added to this phase.
I may look a little funny, but I think this project was a win.
This is what consulting is all about.