A Day in Life of Datawarehouse Architect part 1

A data warehouse Architect generally help to design datawarehouse , requirement gathering in ETL Low level design LLD, and HLD high level design, setting up database infrastructure design for datawarehouse like Storage Area Network requirements, Rapid application Clusters for database of datawarehouse more details read
Datawarehousing consists of three main area :
1. ETL(data migration, data cleansing, data scrubbing, data loading )
2. Datawarehouse design
3. Business Intelligence (BI) Reporting infrastructure.
BI
Read These Two part article for BI
– https://sandyclassic.wordpress.com/2014/01/26/a-day-in-life-of-bi-engineer-part-2/
– https://sandyclassic.wordpress.com/2014/01/26/a-day-in-life-of-business-intelligence-engineer/
And Architect
https://sandyclassic.wordpress.com/2014/02/02/a-day-in-life-of-business-intelligence-bi-architect-part-1/

Design : Now Coming to part 2 (is generally work of Data warehouse architect)
Read Some details More would be covered in future articles
https://sandyclassic.wordpress.com/2013/07/02/data-warehousing-business-intelligence-and-cloud-computing/
9:00-9:30 Read and reply mails.
9:30-10:30 Scrum Meeting
10:30-11:30 update documents According to Scrum meeting like burn down chart etc..update all stake holders.
11:30-12:00 Meeting with Client to understand new requirements. create/update design specification from requirement gathered.
12:00-13:30 create HLD/LLD from the required user stories according to customer Landscape of technology used.
13:30-14:00 Lunch Break.
14:00-14:30 Update the Estimations ,coding standards , best practises for project.
14:30-15-30 Code walk through update team on coding standards.
15-30-16:30Defect call with Testing and development Team to understand defects, reasons of defects, scope creep, defect issuse with defect manager, look at issue/defect register
16:30-17:30 Work on specification of Design of datawarehouse modelling Star or Snow flake schema design according to business requirements granularity requirements.
17:30-18:30 Look at Technical Challenges requiring Out of Box thinking, thought leadership issue, Proof of concept of leading Edge and Breeding Edge technologies fitment from project prospective.
18:30-19:30  onwards Code for POC and Look a ways of tweaking , achieving technology POC code.
19:30- 20:30 onwards Forward thinking issue might be faced ahead by using a particular technology is continuous never ending process as there can be multiple combination possible to achieve as well as using particular component or technology should not create vendor lock in, cost issues, make/buy cost decisions, usability, scalability, security issues (like PL/SQL injection, SQL injection using AJAX or web services may be affected by (XSS attack or web services Schema poisoning), Environmental network scalability issues. Affect due to new upcoming technology on Existing code.
20:30 Dinner
Available on Call.. for any deployment, production emergency problems.

A day in Life of Software Architect – part 2

Read part 1:
https://sandyclassic.wordpress.com/2014/02/02/a-day-in-life-of-software-architect-part-1/
Work scheduled of a day depends on which phase projects are in currently. As typically architect work across multiple projects and help Project Manager PM aligning with organisation strategy and standards, reduce risk, liaising with stakeholder to full fill expectations develop blueprint for project.
different classes of architect have different skills and expectations:
Read More details: https://sandyclassic.wordpress.com/2011/09/25/enterprise-architecture-togafitilzachmanetomngoss/
Suppose a project is using a agile methodology: Then Architect day starts with.
Business Analyst gather requirement from clients, Architect work with them in putting technical prospective to each business Case.
In case of software services company Architect Even help sales team in estimations during bidding process like total man hours required for the projects under bidding.
Architect Also work with domain specialist along with business Analyst to find implications of changes in business environment, regulations, etc and its affect on software implemented or under implementations.
Architect Help Higher management in giving directions to roadmap of implementions or future implications on use of lets suppoe third party Charts in our BI product (license fees has to given for each chart (Make or Buy decision).Other options is make yourself it may take time (speed vs flexibility : Time to Market is crucial). Making takes time but gives flexibility, IP intellectual property, and may reduce cost in long term But Buying already developed third party may not give flexibility but can give speed and reduce cost in short term.
Adjusting solution to landscape of Client a Telecom case study.
Read This case Study for more details of similar process in telecom Stack development:
https://sandyclassic.wordpress.com/2013/10/26/telecom-technology-stack/

What happens At Enterprise Architect level ? see this presentation:
https://sandyclassic.wordpress.com/2013/02/28/498/

So A day typically depends on stage of projects like (initiation, development, implementation or maintenance), Domain of projects (insurance, finance, healthcare) and Technology used (J2EE, ERP (peoplesoft, oracle apps, SAP), .net, COBOL etc. data warehousing and BI).
Example Peoplesoft ERP Architect
e.g. Peoplesoft architect is using already dilivered set of programs, reports, table, forms, processes etc Has to take decisions Based on GAP Analysis. Plan ERP customisation either using peoplecode for UI and Forms or (SQR,nvision, Crystal reports) for report customisation, Or Administrative tools for customizing background processes.
Then plan for implementation of say suppose customising supply chain module to use some KABAN process or customising General ledger to introduce new regulation of mandatory approvals and Archiving records Or customising payroll according to country specific labour laws and company specific compensation policies.
Once functional Experts points what changes are needed Peoplesoft Architect has to draw a map immediately what Changes would be required in technology.
Then work along with team on implementations, stabilization of ERP and further supporting the ERP along with team figure out technical challenges and POC alternative solutions by using different levels of tools/technology in ERP or by integrating third party products.
To be continued…..

A day in Life of Software Architect – part 1

In Computer science world Architect is designer of Software just like
Relation between Architect and Engineer is same as  between Architect of Building and Civil Engineer of Building. While Civil engineer looks at how much cement to be used block constructed, How much steel, iron rods to be used in pillars..is mixture stron enough to used, material quality and usage etc.
Architect looks at design ,asthetics and sustainability of Building like  What should be thicknes of iron road and of pillar to sustain wind pressure?

IT world Civil Engineer is Software Developer and Architect is Software Architect.
Like civil Engineer Software developer looks How much lines of code can I achieve this task?, optimize code(material usage)?, Estimate time of completion of task assigned?, follow design specification to achieve concrete product.
While Architect Looks design of Software is integrable with existing Landscape of client(similar to building aesthetics to environment), long term sustainability/scalability of solution etc..
Different Types/Kind of Architects required in IT industry Read:
https://sandyclassic.wordpress.com/2011/09/25/enterprise-architecture-togafitilzachmanetomngoss/

Architect sits between Project Manager, Stake holders and Development team.
Responsible for overcoming technical challenges in projects, Design roadmap taking stakeholders project goal aligning with business Strategy of company.
Not only Architect generates Design Artefacts for project but also gives technical guidance in for of standards/regulatory technical constraints, and Alternative solutions to road blockers, better technical coding, bridge between testing and development team to achieve defect free as well in time delivery according to specifications. While controlling resources, initiation of project , implementation to maintenance Phase provide technical solutions to project manager.
Architect must be conversant with all latest technical trends related to Technical Domain (Network for infrastructure architect, Database design/development for Data Architect,
BI&DW for Datawarehouse architect, J2EE/design pattern for Java architect, Mobile development for Mobile Architect etc etc..) Enterprise Architect works still higher level to collate data from Each of these architect to create roadmap(What? When? Why? How?) in Artefacts

To Be Continued in Next Article:

Enterprise Architecture TOGAF,ITIL,Zachman,eTom,NGOSS

A list of ALL ENTERPRISE FRAMEWORKS…

– Business Frameworks (e.g. BMM, Six Markets, Porters 5 Forces, McKinsey 7S, etc)
– Architecture Frameworks (e.g. PEAF, MODAF, TOGAF, TEAF, IAF, etc)
– Programming Frameworks (e.g. .NET, J2EE, etc)
– Project Management Frameworks (e.g. PRINCE2, MSP, etc)
– Service Management Frameworks (e.g. ITIL, etc)
– Industry Operations Frameworks (e.g. eTOM, Pragmatic Marketing, etc)
– Any other type of framework in any other domain so long as it is related to an ENTERPRISE.

There are various field of Architecture floating around in IT industry.Specially in indian IT industry where things are still taking shape.HR department is india in most forgotten department it still need to learn more about Labour laws and nothing more..Top institution in india for HR which was essentially focus on labour laws and nothing more.Other subjects are taught not with great emphassis..Problem that is  okay for manufacturing industry where management is dealing with unskilled uneducated manpower..but same is not true for Industry.Institutes still need to inculcate basic principle of psychological analysis , service industry and basic computer knowledge so people can visualize trends in skills needed to shape future of employee in company.

So For Industry still under trap of HR to define there own terminology for different job skills.In country outside india for which indian IT companies are executing project Position are well defined.Take a case Architect in software industry.

Architects can be classied into two category:

1)Enterprise Architects.

Architect working at enterprise level with various certification level like ITIL( process based for Service Management),TOGAF for Thne

Zackman for domain model, there are customised framework like NGOSS and e-TOM for Telecom industry

2) Domain specific Architects.

Domain Architect can be classied into four major types:

  1. Application or Language Architect (Java Architect,.NET Architect,PHP Architect, open source Architect, Integration Architect, Platform As Service Architect)  . These architects are primarily concerned with design patterns and application integration and language specific issues, options available like in integration web service is course grain integration but there are other option like CORBA,JNI web services is last option. So Java architect is SME for Java related design issues. same way .NET Architect, PHP Architect.Integration Architect are looking at how integrated different layer(ESB,Web services, COM,CORBA etc..).
  2. Database/Data Architect (Data Architect, ETL Architect, BI Architect, Performance Architect)
  •  Data Architect: concerned with logical data modelling (LDM) and Physical database  modelling (PDM), design of OLTP system and design normalized scehmas and table structure.
  • ETL Architect : Takes care of Data Integration layer (Extract Transform Load data from SQL server to Oracle from SAP populated tables into target datawarehouse. Designing or Star schema or extended star schema for Data warehouse.
  • BI Architect: Looks to create semantic Layer which helps user to convert dynamically dragged objects to there respective SQL equivalent.and reporting layouts ,data structure which support them,layout to of report on web on mobile or on portal.reports from tactical to strategic reporting to Exception reporting and business events.
  • Performance Architects are concerned performance to Web servers , data bases performance ,query response time, latency etc.

3. Network Architect (Storage Architect, Network Architect, System Architect,Virtualisation or Infrastructure As Service IAAS.

  • Storage Architect: Concerned with SAN storage and design of storage network its interface with network components. whether to go for SAN or NAS or DAS ,RAID levels, SCSI or Fiber channel , servers, vendors to go with (EMC Clarion,netapp,hitachi)  etc.analysts predict that enterprise storage will account for 75% of all computer hardware expenditures so storage is critical.
  • Network Architect: Network architecture have exploded in recent decade.Network architect needs to look into network Design, specification,Network security. Like Cisco defines 5 fields (1. Voice like VOIP, 2. Security, 3. Design, 4.Routing and Switching, 5.Wireless).Each one can have its own architects.person may not be specific to Cisco but can cut across to like juniper network junos firewall, or sonic firewall is in network security.
  • System Architect: concerned Types of servers used and Os Admin related activities.e,g Red hat admin subject matter expert with server datacenter know how, blade vs RACK, virtualisation layers,hypervisor (vmware ESXi, Microsoft hyperV, IBM AIX LPAR) etc.

4. Architect not defined above,

ERP Architects:

  • SAP Architect(since SAP has its own solution framework  like SAP Solution Manager  which help in maintaining and upkeep of solution and framework at solution or practice level, Also like SAP BI is domain specific architect who know out for 16 reporting tool flavor from WebI,Xcelsius,DesKI, live office, Quaas which one to use when).
  • Peoplesoft Architect: Looks into PS specific techno-functional issues customization , enhancement, or performance issue, installation and data migration, its integration with different web server app server.
  • , Oracle Apps Architect.: Oracle Application domain specific solution to use of Oracle BPEL, ESB, SOA suite, fusion middle ware vs old form report customization Vs used of OAF or ADF.