Sammy's profile廖 显 Sammy.liaoPhotosBlogLists Tools Help

Blog


    17 April

    QAI Testing

    Today, hiSoft Training have already begun to learn the Testing course. It is the training teach by QAI ( Quality Assurance Institute). I feel it is very rich in content and get the big harvest after the course. Because that is the first standard organization and I can touch that is enough. I just hope I can find some time to listen to all the courses. I just hope.
    In the evening, on my way home, I walk by a small CD shop, and look around in it, just buy a CD of Vivian-"Strong love" maybe, I just translate the name by myself. That is my life-full of the job,technology,music and study. C'est la vie.
    16 April

    Blue Night

      
    Blue Night II Art Print by Robert J. Ford
      今天很累,用一天把General View to Oracle EBS培训课程全部讲完了,EBS所有的模块.昨天晚上开始准备,用了5个小时的样子,一直熬夜到了2点多,因为毕竟自己不是EBS出身的,不过最后效果还蛮好的,我比较欣慰,而且大家都收获很大.顺便考验了一下自己的学习能力.不过当讲完的时候,回到办公室,觉得真的很累,很累,很像休息.
      回家了,天开始热了,吃饭的时候看到有演"我们无法安置的青春",突然喜欢上了这样的一种苍凉,以及充实过后的孤独.
      电视里最近在热潮中日关系,不过我还是觉得中国的"软实力"被高估了,就像FT专栏作家Guy de Jonquieres预言的那样:真正有效的软实力,其基础是内在诱人的国家理念、原则和价值。尽管布什政府已经肆意地浪费了那些资产,但我猜,如果有选择的机会,多数亚洲人仍将选择失去光泽的美国梦,而非当代中国严厉的约束、无情的唯物主义和精神贫乏。
      今天晚上,应该没人陪我去喝咖啡.不过,我的心真的应该好好的休息一下了,找个地方先放放吧.
     
    13 April

    Service-Oriented Architecture (SOA)

     
     
    昨天,Mr Yang Training,给我们讲述Portal机制的时候,讲述到了SOA的思想,不过我觉得做IT做到这个层次上,已经开始有些哲学的思考了,比如,最早的面向程序,就好比单个细胞,一个一个的编写;后来的面向结构,就开始写组织了;再后来的面向对象,那就是开始写一个人的器官,比如手啊,脚啊什么的;再后来的面向组件,那就是写了一大堆标准化的器官,然后再开始拼构成人;现在就是面向服务,那不是就是先问问你需要什么样的效用,我就用什么样的组织给你实现么?看来这个是一个很大的飞跃,技术从关注程序本身,已经开始拥有自由,可以拥抱商业流程了,这是一个不错的改变,只是,我感觉Oracle在SOA上的动作稍微慢了些,呵呵,这个也跟Oracle一贯保持稳健增长的作风是分不开的.
     
    现在SOA现在大多都是用的Web Service,不过现在国际技术标准组织有得忙了,因为当全球各大厂商都开始为一种标准怒吼的时候,那么离它走向成熟也不远了.但愿在我有生之年能够赶上它的Fashion.我现在先作个比较感性的预言:在20之后,应该说像ERP这样的系统也可以实现个人用户化了,或则家庭版,那么世界除了机器以外,软件将无处不在!
     
    PS: 附上SOA与标准化组织
    W3C:http://www.w3c.org
    OASIS:http://www.oasis-open.org
    WS-I:http://www.ws-i.org
     
    有时间的时候我也去这里发发杂言,没准又封一个Expert之类的,呵呵.
    07 April

    Cognos 8 BI or Oracle BI EE (Siebel Analytics)

    I started to research the Oracle BI EE.There were a lot of areas where things were similar in the way you used them e.g. creating reports with drag-and-dropping objects into report or onto dashboards but as a whole I found that Oracle BI EE products have a better look and have a logical work-flow e.g. first create all required “reports” in the Answers area and then drag-drop them into the Dashboards. They spent very little time demonstrating the Cognos Dashboard and what was shown was nowhere near that of BI EE Dashboards. The BI EE Dashboards have a more professional look to them. BI EE gives the users the ability to create there own personal Dashboards by dragging pre-created reports onto their Dashboard area, allowing users to decide for themselves which reports they want displayed in their dashboard.


     
    Cognos Dashboard (this was the best image I could find on internet)

     
    Oracle dashboard

    Cognos has two methods of create reports, Cognos Query Studio and Report Studio. Differences begin that Report Studio has the ability to create more complex reports and according to Cognos, should only be used by trained personal with SQL knowledge. The demonstration of the tool highlighted its complexity and the requirement of SQL knowledge. Oracle BI EE also has two report creating tools, Answers for the basic reports and BI Publisher (previously XML Publisher) for the more complex pixel perfect type reports. The nice thing about BI Publisher is that you don’t need SQL knowledge to use it, of coarse if you want to create extremely complex queries, it’s also possible with direct queries to the database(s) but if you need to write SQL to retrieve your required data you should be asking yourself if you shouldn’t change you metadata layer instead. BI EE has the possibility to query the database tables direct but for security reasons this is by default disabled.

    I thinked that there would be a lot of SOA interaction demonstrated but the only SOA that was discussed was that a report could use WSDL to get info, such as a weather report for a particular city. I was hoping to see the ability of trigger business processes and also the ability to use the Cognos off-line, things that are possible in BI EE.  It was very evident that Cognos relies heavily on Microsoft products and is therefore not able to be used with open Office or other Linux based products.

    Cognos 8 did have some things that I liked: they had a Google search page with which you could search for particular report. Another useful item was that you could place reports in Word, Excel and Power Point.

    In the World, Cognos has had difficulty in getting the product into the market due to Hyperion’s strength but have started gaining market share in the past two years. Cognos sees the Hyperion takeover by Oracle as an opportunity to gain more clients, there reasoning being that Oracle will bundle Hyperion with other Oracle products and that current Hyperion customers don’t want to be forced to take other Oracle products when all they want is only the Hyperion product. We will have to wait to see how Oracle intends marketing the Hyperion product and see if it causes current Hyperion customers to change to other products.

    Please realize that these are my opinions of the products and is based on my recent experimentation with Oracle BI EE products and the presentation given by Cognos Netherlands which I assume they would have demonstrated the best aspects of their product (even though their demo data did not always match up when drilling down).

    02 April

    Oracle Financial Services Applications (OFSA)

    今天,开始为期一个星期的OFSA的培训,整个培训TRAINING AGENDA如下:

    April

    2(Monday)

    3(Tuesday)

    4(Wednesday)

    5(Thursday)

    6(Friday)

    Topic

    Architecture

    FTP

    PA

    ALM

    Practice Q & A

    9:00-10:30

    OFSA Architecture Introduction (Instructor: Changmao)

    FTP Concept and Methods Introduction (Instructor: Changmao)

    PA Concept and Methods Introduction (Instructor: Changmao)

    ALM Concept and Methods Introduction (Instructor: Changmao)

    Practice

    10:45-12:00

    OFSA Cash Flow Introduction (Instructor: Baozhu)

    FTP Functions Introduction (Instructor: Changmao)

    PA Functions Introduction (Instructor: Baozhu)

    ALM Functions Introduction (Instructor: Baozhu)

    Q & A

    午饭

     

     

     

     

     

    14:00-15:15

    OFSA Data Admin and Tables      (Instructor: Changmao)

    FTP Functions Introduction (Instructor: Changmao)

    PA Functions Introduction (Instructor: Baozhu)

    ALM Functions Introduction (Instructor: Baozhu)

     

    15:30-17:00

    OFSA Reports (Instructor: Changmao)

    FTP Functions Introduction (Instructor: Changmao)

    PA Functions Introduction (Instructor: Baozhu)

    ALM Functions Introduction (Instructor: Baozhu)

     

    17:00-17:30

    Case study  (Instructor: Changmao)

    Case study  (Instructor: Baozhu)

    Case study  (Instructor: Changmao)

    Case study  (Instructor: Changmao)

     

    经过一天,感觉还不错,内容也挺充实的,帮我扫除了一些误区。

    "银行业的竞争日益激烈,客户要求以尽可能低的价格获得最好的服务。因此,为了保证运营效率,我们必须时刻努力寻找提高运营生产率的机会。我们从使用 Oracle 系统中获得的收益与该目标是一致的。有了 Oracle,我们就能对合并过的财务信息有一个更快的、统一的了解,使得我们的管理层能够做出更为明智的业务决策。"

    -Phil Chronican,首席财务官,Westpac

    下面我们来看下它的技术感念,OFSA包括:

    ● 统一的银行业数据模型

    ● 内部资金转移计价应用

    ● 成本分摊和业绩分析应用

    ● 资产负债和风险管理应用

    ● 预算和计划控制应用

    ● 作业成本管理应用和相应的前端信息查询/报表展现工具

    模块化的结构设计使其能够很好的适应国内银行的不同需求。基于不同模块组合,OFSA能够实现专注收益率分析的管理会计系统以及专注市场风险和结构化风险的资产负债管理系统。此外,甲骨文公司统一的数据模型也为信用风险评估和信用风险管理提供了很好的支持,客户甚至可以利用甲骨文的数据模型建设银行企业级数据仓库。

    OFSA可以使银行及金融机构获得的明显的效益在于:

    ● 加强绩效考核,提高盈利能力,减少运作和管理成本

    通过OFSA的内部资金转移计价应用和成本分摊应用,构建银行的管理会计体系,帮助银行基于帐户数据精确计算机构、产品和客户的收益率和经济增加值,从而识别高收益的客户和产品,并有效考核机构业绩,更好的配置银行资源,充分提高银行的盈利能力,并降低成本。

    ● 满足监管要求,提高风险防范能力

    通过OFSA的资产负债管理应用,帮助银行快速借鉴国际先进的风险管理最佳实践,科学的分析和预测资产负债平衡表的市场变化影响,模拟不同商业策略的回报和风险情况,未决策层提供准确的、及时的、丰富的信息,提供符合银行监管要求及Basel II的标准报告,并通过风险的量化分析、理解、预测和模拟,提高银行的风险防范能力。

    ● 借助于丰富的管理信息,提高决策支持能力,更为迅速地应对竞争方面的压力

    OFSA提供的风险和绩效结合的管理信息系统,能够为银行管理层提供更为丰富的、更有价值的管理信息,包括经济增加值EVA、风险调节后资本回报率RAROC等,使决策者更加了解业务发生的真相,更好的面对现实和应对市场竞争的压力,从而作出明智的决策。

    ● 帮助银行逐步成为以客户为核心的高效企业

    以客户为核心和股东财富最大化,是银行经营的最终目标,风险调节绩效管理信息系统的实施,将为银行实现此目标提供最佳的技术支持和管理工具,真正把信息变为知识财富,从财务、业务流程、客户、员工学习与创新和风险控制等多方面,平衡的管理银行的日产运作,促进银行的持续发展,实现以客户为核心的高效企业的目标。