Cognos Analyst

BI tool -Cognos, Relational Database Knowledge - Tables, Relations, Types, Database Model 3NF, Database Model Dimensional, Database Model STAR, Database Model Schema, MS SQL Server, Data Analysis, DW/BI

Knowledge OLPT, DW/BI Knowledge OLAPOracle SQL, Empirical understanding of data systems (BI analytics, data blending, data warehousing, data ETL, etc) on process automation and standardization Good experience in requirement gathering/ analysis, coding, Unit testing, SIT SupportKnowledge working on both Agile and waterfall modelsDevelop end to end framework

9+ Years of experience in BI Reporting5+ Years of experience in designing Cognos Business Intelligence Reporting systems9+ years SQL development experience either SQL Server, DB2, Oracle, Sybase and MySQL.

Ability to create complex reports requiring multiple parameters, summarizing data with crosstabs, using sections and section underlay for groups, and related report functionsKnowledge of Shell Scripting and BI

Strong written and verbal communication, and proficiency in reporting analysis tools.

Understanding of ETL & DWH ConceptsCore Compliance Domain knowledgeExperience in the Agile Scrum Methodology