Business Intelligence / Data Warehouse Professional
Last active: 1 month ago
• About 13 years of Information Technology experience in development, testing, documentation, and maintenance of applications.
• Over 10 years of experience in developing Cognos Applications including Relational and Dimensional modeling, that includes over 4 yrs of experience with Cognos 8.x
• Migrated to Cognos 10.2 from Cognos 8.4.
• Identified determinants, relational dimensions, and measure dimensions. Identified hierarchies and scope relationships to create Dimensionally Modeled Relational (DMR) packages
• Expertise in different aspects of Information Technology including System/Software Development Life Cycle (SDLC), Project Management, Change and Business Process Management etc.
• Excellent team player be it cross-functional team or functional team.
• Expertise with Cognos tools such as Cognos8.x, ReportNet, Impromptu, PowerPlay; Impromptu Web Reports (IWR), PowerPlay Enterprise Server (PPES), Upfront, Transformer, Access Manager, Architect, and Scheduler, Framework Manager.
• Involved in the process analysis, catalog design, Package design and performance optimization of Business Intelligence Reports
• Created Business Intelligence Reports using Cognos Impromptu and Cognos PowerPlay.
• Developed OLAP solutions using Transformer and Framework Manager.
• Administered Access Manager to implement Security among Cognos applications.
• Installed and Configured PowerPlay Transformer and/or Cognos8.x Framework Manager for building multidimensional Cubes.
• Automated Reports and generated documents using Scheduler.
• Created and managed reports in Zero-footprint environment using ReportNet, Cognos8 (Report Studio, Query Studio, and Analysis Studio).
• Created Packages (Multiple data sources including PowerPlay cubes) using Framework Manager and published to ReportNet, Cognos8.x.
• Used Drill through, prompts, filters, and complex calculations in Cognos8, ReportNet, Impromptu and PowerPlay.
• Created report and reports with sub reports using Crystal Reports, converted reports in Crystal reports to Cognos8 reports.
• Did statistical Analysis using SAS Enterprise Guide.
• Macros for automation of MS Excel reports, Showcase 7.1 Queries.
• Created Dashboards using Tableau 8.0
• Created Dashboards using PowerPivot for Excel 2010