Previous Job
Previous
Micro Strategy Architect - Mississauga, ON
Ref No.: 17-00622
Location: Mississauga, Ontario
Role                : Micro Strategy Architect
Location         : Mississauga, ON
Positions        :
 
Permanent

Required experience / skills:
  • Understanding of End to End BI/DW Development and Operations Life Cycle.
  • Analyze requirements, write functional and technical specifications, development of reports.
  • Prepare and conduct Unit testing.
  • Design and create jobs Required Skills.
  • Should have good knowledge on BI principles, SQL, DB2.
  • Excellent written and verbal communication skills.
  • Dimensional Modeling understanding.
  • Experience of handling complex business requirements in BI reporting and creating intuitive design solutions.
  • Good conceptual knowledge and working experience on Meta data creation framework models Report Development Concepts.
  • Good experience on reporting tool Micro strategy.
  • Aggregate Layer hands-on,
  • SDK expertise will be a plus
  • MSTR Desktop advanced reports,
  • MSTR Narrowcast Services,
  • MSTR Web Professional,
  • Advanced Metrics, Filters, Custom Group, Consolidation and other application objects,
  • MSTR performance tuning,
  • DB advanced SQL scripting,
  • MSTR report troubleshooting,
  • Created security roles, schedules, subscription, User's and Group's with their desired privileges as per the requirement.
  • MSTR Desktop Architect, Attributes, Facts, Hierarchy, Transformation, Logical table partition (Schema Objects)
  • Having experience on Creation of Custom Groups, Attributes, Consolidations, Facts, Filters, Attributes and Metrics, Prompts.
  • Having experience on creating of Micro Strategy Reports, Dashboard, scorecards, reports performance tuning.
  • Created Transmitters, Devices and User for Automated Distribution Services through Desktop and Web.
  • Have loaded and unloaded the project.
  • Write back to source data based on analysis by business users alerts via mail.
  • Knowledge of the Product Suite, their architecture and details of the components of the individual products in the suite.
  • Report development lifecycle.
  • Report Testing Concepts.