A day in Life of ETL Consultant

Consultant Analyses the business deeper to come up with star-schema design and further ETL load design,
Working as datawarehouse consultant most important task is to fix granularity of fact across dimensions to be analysed in FACT-DIMENSION Star schema design.
Granularity depends on business requirement and key drivers for business to be analysed for having its impact on Topline and Bottomline of Company. For Clinical Research key driver is No. of patient Enrolled, For banking key driver is cost of adding new customer,
Now patient is analyzed across geography dimension, against time dimension. But at what level of Granularity.
(#no of patient, day)   OR
(#no of patient, year)  OR
(#no of patient, hour)
This depends on business need and level of criticality to time. For Stock trading Every second is crucial but not for clinical trails but if trial involve enrollment of large public it may required a drill down to per day figure in BI reports hence provisions must be there in star schema.
Besides this The Other task per day can be taken based on stage of project
https://sandyclassic.wordpress.com/2014/02/19/a-day-in-life-of-datawarehouse-architect-part-1/
For datawarehouse Engineer involved with task the day look like
https://sandyclassic.wordpress.com/2014/02/19/a-day-in-life-of-datawarehousing-engineer/
For Unstructured data analysis you can look at
https://sandyclassic.wordpress.com/2011/10/19/hadoop-its-relation-to-new-architecture-enterprise-datawarehouse/

Then data Transformation are applied for
Example in Informatica and SSIS:

https://sandyclassic.wordpress.com/2014/01/15/eaten-tv-from-partly-eaten-apple-part-2-artificial-intelligence/

Two Sets of documents are There LLD and HLD to look at what needs transformation to be applied.
Like in Informatica Transformation Types are :

http://www.techtiks.com/informatica/beginners-guide/transformations/transformation-types/

Look at all transformations available in Informatica version 9

http://www.folkstalk.com/2011/12/transformations-in-informatica-9.html

These can be customized according to logic required.
Next step is Loading to datawarehouse dimension tables  and then to Fact table.
Read: https://sandyclassic.wordpress.com/2014/02/06/coke-vs-pepsi-of-datawarehousing-etl-vs-elt/
And more

https://sandyclassic.wordpress.com/2013/07/02/data-warehousing-business-intelligence-and-cloud-computing/

A day in life of datawarehouse Consultant

Consultant Analyses the business deeper to come up with star-schema design and further ETL load design,
Working as datawarehouse consultant most important task is to fix granularity of fact across dimensions to be analysed in FACT-DIMENSION Star schema design.
Granularity depends on business requirement and key drivers for business to be analysed for having its impact on Topline and Bottomline of Company. For Clinical Research key driver is No. of patient Enrolled, For banking key driver is cost of adding new customer,
Now patient is analyzed across geography dimension, against time dimension. But at what level of Granularity.
(#no of patient, day)   OR
(#no of patient, year)  OR
(#no of patient, hour)
This depends on business need and level of criticality to time. For Stock trading Every second is crucial but not for clinical trails but if trial involve enrollment of large public it may required a drill down to per day figure in BI reports hence provisions must be there in star schema.
Besides this The Other task per day can be taken based on stage of project
https://sandyclassic.wordpress.com/2014/02/19/a-day-in-life-of-datawarehouse-architect-part-1/
For datawarehouse Engineer involved with task the day look like
https://sandyclassic.wordpress.com/2014/02/19/a-day-in-life-of-datawarehousing-engineer/
For Unstructured data analysis you can look at
https://sandyclassic.wordpress.com/2011/10/19/hadoop-its-relation-to-new-architecture-enterprise-datawarehouse/

Then data Transformation are applied for
Example in Informatica and SSIS:

https://sandyclassic.wordpress.com/2014/01/15/eaten-tv-from-partly-eaten-apple-part-2-artificial-intelligence/

Two Sets of documents are There LLD and HLD to look at what needs transformation to be applied.
Like in Informatica Transformation Types are :

http://www.techtiks.com/informatica/beginners-guide/transformations/transformation-types/

Look at all transformations available in Informatica version 9

http://www.folkstalk.com/2011/12/transformations-in-informatica-9.html

These can be customized according to logic required.
Next step is Loading to datawarehouse dimension tables  and then to Fact table.
Read: https://sandyclassic.wordpress.com/2014/02/06/coke-vs-pepsi-of-datawarehousing-etl-vs-elt/
And more

https://sandyclassic.wordpress.com/2013/07/02/data-warehousing-business-intelligence-and-cloud-computing/

A day in life of BI consultant

Work Of BI consultant besides understanding domain of client
BI consultant primary role is to create and manage the Semantic layer using which BI reports will be created. data modelling for semantic layer, BI infrastructure and server sizing.
BI integration with ERP(SAP, Oracle Apps, peopesoft), CRM,
CMS (sharepoint, joomla,documentum)
Creating BI App using Cognos
https://sandyclassic.wordpress.com/2014/03/12/bi-app-development-using-cognos-sdk/

Creating BI App using BO java
https://sandyclassic.wordpress.com/2014/03/11/bi-app-development-using-bo-java-and-asp-sdk/

so work is mixture of work defined in article
https://sandyclassic.wordpress.com/2014/02/02/a-day-in-life-of-business-intelligence-bi-architect-part-1/

A day in life of BI Engineer
https://sandyclassic.wordpress.com/2014/01/26/a-day-in-life-of-bi-engineer-part-2/

For ETL Architect
https://sandyclassic.wordpress.com/2014/02/19/a-day-in-life-of-datawarehouse-architect-part-1/

For ETL different approaches.
https://sandyclassic.wordpress.com/2014/02/06/coke-vs-pepsi-of-datawarehousing-etl-vs-elt/

For Future of BI
https://sandyclassic.wordpress.com/2012/10/23/future-cloud-will-convergence-bisoaapp-dev-and-security/

Another Top Search Number 21 on my blog

Another Top search
Another Top Search Number 21 on my blog :

“Security Risk management in healthcare over cloud” on google
My blog on top

https://sandyclassic.wordpress.com/2014/04/10/security-risk-management-in-healthcare-on-cloud/

Security Risk Management in Healthcare on Cloud

Quick presentation made in 1 hour


Security Risk Management in Healthcare on Cloud using NIST guidelines

I do no know anything. Life is Learning.

people who target say “I Do not know anything”. my answer is yes 🙂
I only say to them: “Everytime I am learning new things” Last 30 yrs I was learning and I will keep learning ..because there are so many things I still do not know… Life is made to learn everytime and Every minute from Everyone even from small Child who has not even started speaking…

% of world knowledge my be I know 0.05% person who know most would be say 1%… so keep learning..

That’s how I could grow from engineer to architect…..