Last active: 1 day ago
Over 6 years of experience in Cognos10 (10.2.1/10.1.1) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer), with Cognos 8 (8.4/8.3/8.2), Cognos series 7 suite ( Cognos Impromptu Administrator 7.x/6.x, Impromptu Web Reports (IWR) 7.x/6.x, Power Play Transformer 7.x/6.x, Power Play Enterprise Server (PPES) and Access Manager), Cognos Data Manager ,Microstrategy,SSRS and Tableau
• Worked in various phases of the software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
• Experience in Data Warehousing and Business Intelligence area in various domains.
• Experience with Data Warehousing concepts, RDBMS and multi-dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Developed Framework Manager Models (Layers, Relations, Query Subjects, Star-Schema and Packages) and published packages.
• Experience developing complex reports (List, Cross Tab, Chart, Singleton Repeater, Active Reports) using drill-through, prompts, master-detail, burst options, dynamic filtering in Cognos BI.
• Developed reports using advanced functionality of Analysis Studio such as drill up and drill down, rank, slicers.
• Produced operational reports in SSRS i.e. drill down, drill-through, dashboard and matrix reports
• Created linked and subreports in SSRS.
• Created reports with using stored procedure.
• Experience in Performance tuning of the existing Cognos Reports.
• Proficient in creating Ad-Hoc Reports using Query Studio based on user requirements.
• Experience in Cognos administration.
• Strong data analysis and multidimensional modelling experience.
• Build DMR model based on data hierarchies. Developed reports against DMR model.
• Experience in migrating/upgrading Reports & Packages from Cognos 7 series to Cognos 8 and Cognos 10.1.1.
• Experience in Cognos Life Cycle Manger while migrating from Cognos 8.4 to Cognos 10
• Deployment of Models, Packages, Folders, Reports, Cubes, and Data Sources from Development environment to production environment.
• Performed Defect Prevention Activities in Project.
• Participated in system integration, performance and user acceptance testing for systems.
• Provided Production support by checking the integrity of the reports in the production support.
• Skills in developing SQL programming.
• Proficient in creating On-demand and Schedule reports, handling sub-reports and defining complex queries for generating drill down reports using MS SQL Server Reporting Services
• Expert in writing Parameterized Queries for generating Tabular reports and Sub-reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS
• Involved in Performance Tuning of Reports to reduce report execution time.
• Created reports from multiple data sources (Excel, SQL Server) to reflect the current business rules.
• Worked with Business Analyst and end users in understanding and preparing functional, technical specifications and designed documents.
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Knowledge on Creating dashboards in Tableau desktop.
• Ability to handle multiple tasks concurrently and meet the deadlines.