Send Only Direct Client requirements to kevin.sm...@amzur.com Experience Summary
- 11 years of IT industry experience in the areas of Requirements gathering, Analysis, Design, Development, Testing, Implementation, Migration and Application support. - 7 years of experience in Analysis, Modeling & Design, and Development of Datawarehousing and Reporting Applications using Business Intelligence (BI, OLAP) Technologies. - 7 years of experience in various COGNOS Tools – Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Metrics Designer, Transformer, PowerPlay, Cognos Connection & Cognos Administration. - Created Dimensional Models in ROLAP architecture using Star Schema and Snowflake Schema and in MOLAP architecture using Cubes. - Interacted with Business users. Gathered and translated the requirements into Dimensional Model. Modelled Dimensions and Facts. - Worked in different roles as Modeller, Administrator, Designer and Developer. - Identified and Implemented different dimensional model scenarios including Conformed Dimensions, Hierarchies, Dimensional Roles and Aliasing, Behavioral dimensions, Multi-Valued Dimensions, Bridges, Degenerate dimensions and Factless Facts. - Extensively worked on Cognos Framework Manager and Transformer functionalities – Designed and Implemented Cubes, Created metadata models in Framework Manager, Importing metadata from different Sources, Dimensional Hierarchies, Star Schema Grouping. - Expert skills in designing and developing complex Reports & Dashboards in Report Studio & Analysis Studio. Implemented Master-detail relationships, Drill-throughs and Report Bursting. - Involved in Administration activities - configuring the Security, Dispatchers, Gateways, Upgrades and Installations. - Experienced in SQL & MDX and in relational databases DB2, Oracle and SQL Server. - Identified and fixed performance issues. Research and suggest best practices on optimizing the Cognos Functionalities from the Application perspective. *Certifications * - IBM Certified Developer – Cognos 8 BI Metadata Models** - IBM Certified Designer – Cognos 8 BI Reports** Skills Profile Cognos Tools COGNOS 8.4/8.3/8.2 series – Transformer, Framework Manager, Report Studio, Analysis Studio, Cognos Connection, Query Studio, Metric Studio, Metrics Designer, Powerplay, Cognos Impromptu series 7, Report Net 1.1, Cognos Configuration Languages XML, HTML, Javascript, Cobol, SQL, MDX, PL/SQL, Shell Scripting Databases Oracle 10g/11g, DB2, SQL Server, MS Access Special Software Erwin Data Modeler, Informatica 8.6/8.1.1, SQL Developer, SQL Plus, TOAD, Infor EAM, MS Visio, Infoman, TSO/ISPF, CA7, File-Aid, Xpediter, MS-VSS, Rational Clear Quest, HP Quality Center, Service Center, JCL, Rexx. System Analysis and Design** Business Analysis, Data Modeling, Impact Analysis, Effort Estimation, Design, Development, Test plans, Implementation plans, Implementation & Production support. Computer Systems Windows2000/XP/NT, IBM3090, OS/390, WindowsServer2003, Linux *Thanks & Regards,* Kevin Smith | Amzur Technologies Off: (813) 600 4060 x 127 | Fax: (813) 774 7819 kevin.sm...@amzur.com <mur...@amzur.com> | www.amzur.com *An ISO 9001:2008 Certified Company*** "*Amzur is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national origin or citizenship status or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria."* -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To post to this group, send email to oracle-users@googlegroups.com. To unsubscribe from this group, send email to oracle-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-users?hl=en.