VJ
SUMMARY Ø *8 years* of IT experience in development and implementation of Data Warehousing Applications using *Cognos 8i, Cognos ReportNet*, *Cognos Impromptu*, *Cognos Power Play Enterprise Server, Cognos Transformer**.* Ø *Experienced and certified in data modeling, data warehouse, data mart and OLAP for business analysis using Star & Snowflake schema. * Ø Heavy expertise using OLAP tools. Ø Experience in *OLAP* System Study, Analysis and E-R modeling, developing *Database Schemas* like Star schema and Snowflake schema, which are used in relational, dimensional and multidimensional modeling Ø Strong technical skills in *Oracle, SQL, PL/SQL and Teradata* Ø Implemented dimensional data modeling and cube development using *SSAS* Ø Data Analysis using* Cognos ReportNet and Cognos ReportNet administration and Report Developments.* Ø *Expertise in Reportnet administration.* Ø Solid expertise on the usage of tools such as ReportNet *(*Framework Manager, Report Studio, Query Studio, Cognos Connection), *Analysis Studio and Event Studio in Cognos 8.* Ø Used* Impcat2xml utility to migrate impromptu catalogs to ReportNet.* Ø Created professional reports in Report Studio and ad hoc reports in Query Studio. Ø Experience in creating the Catalogs and implementing the *Security using User Classes* in Impromptu Administrator. Ø Extensive experience in modeling using Framework Manager including applying table level, and data level security. Ø Experience in designing, developing and maintaining *Cognos Impromptu and Cognos Power Play reports.* Ø Experience in building *multidimensional models* and creating *Power Cubes* for distribution using *Power Play Transformer*. Ø Experience in using the *Cognos Decision Stream* as the *ETL* tool to populate the star-schema, Mappings, Transformations, scheduling the Sessions and Batches for ETL process. Ø Strong experience in *Oracle 8i/7.x database programming using PL/SQL*(Stored Procedures, Functions, Triggers, Cursors). Ø Excellent skills in *programming*, debugging, trouble shooting and tuning using languages as *SQL, PL/SQL, C, C++ and Java*. SKILLS DW Tools *Cognos 8 BI,* *ReportNet* 1.1/1.0x,* *Decision Stream 7x/6x, *Cognos Impromptu 7x/6x/5x, PowerPlay Client, PowerPlay Transformer 7x/6x*, PowerPlay Explorer for the Web and Enterprise Server Manager, *Impromptu Web Reports.* Data Modeling Star-Schema & Snowflake-Schema Modeling RDBMS Oracle 10g/9i/8i, SQL, PL/SQL, MS SQL Server 2000/7/6, MS Access, Teradata ETL Tools *Informatica PowerCenter 8.x/7.x/6.x,* SQL *Loader, SQL*Plus and AQT Languages Java, C, C++, C, SQL, PL/SQL, XML, HTML, Shell Scripting OS Windows XP/ NT 4.0/ 98/95 and UNIX *Thanks & Regards* *Mike Kenny*** [image: volgalogo]* (**408) 216. 7673** (Voice) (413) 235.7695 (Fax)* [email protected]* *www.volgasystems.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle-Distribution" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-Distribution -~----------~----~----~----~------~----~------~--~---
