Prasanth Reddy

Experience

1. Ibm Cognos Bi Developer

   Cognizant

   Oct 2019 — Present · Bengaluru, IN

   10 + years of Report and dashboard development experience in Cognos Analytics. Working experience in Cognos Analytics 11.2 and older versions like Cognos BI 10.2,8.4,8.3 versions• Having good experience in Power BI, QlikView and Informatica • Experienced in complex Relational Reports creation in Cognos on top of ODBC Databases like Oracle, MS SQL Server, Teradata etc.• Involved in all phases of a project, which includes Requirement Gathering, Analysis, Effort Estimation, Design, Codedevelopment, Code Reviews, Unit Testing, Integration Testing.• Involved in Development, Enhancement, Migration (Cognos 8 to Cognos 10 to Cognos 11) projects and Production • Expertise on the following modules: Cognos Framework Manager, Powerplay Transformer, Report Studio, Query Studio, Analysis Studio and Event Studio• Developed Dashboard and Stories in Cognos 11 environment and sharing the reports with business and stockholders• Experienced in creating Relational Model, DMR Model, Packages in Framework Manager and building Dimensional models, OLAP Cubes in Power Play Transformer• Experienced in modelling using Framework Manager and relational database as source, applied data level, query subject level and package level security & published packages to Cognos.• Strong knowledge in Star Schema, Snow-Flake Schema modelling methodologies for building enterprise data warehouses• Experience in creating Stored procedures, Functions, Views, Computed Columns etc. in SQL Server Database• Extensive knowledge of Data Validation Techniques • Good Knowledge on creating / updating the Cognos transformer Cubes and publishing the cubes in Cognos portal.• Having good knowledge on writing the SQL/PL SQL queries to build the reports.• Have been working to handle the tickets through Incident Management, Service Request Management, Change Management etc.• Having good Domain knowledge in Pharmacy, Life Science, Banking, and Insurance