Bhavna Patel

About Bhavna Patel

Over 10 years of experience as a Sr. Microstrategy Developer. • Expertise in using…

Experience

1. Sr Microstrategy Developer

   IBM

   Apr 2011 — Present

   Involved in designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.• Responsible to develop public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports on top of the schema objects).• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex Microstrategy reports in an efficient way. • Involved in developing Dashboard Reports in Microstrategy by combining multiple datasets with the help of selectors for IPhone and IPad Applications. • Involved in creation of logical views and Freeform Sql Reports to translate Freeform Cognos Reports into Microstrategy Reports. • Used Apply Simple and Apply Comparison functions to develop Attributes, Metrics and Advanced Filters.• Involved in setting of VLDB properties at report and Metric, Attribute Levels to get more efficient sql query.• Responsible for migration of Hyperion and cognos reports into Microstrategy Reports.• Involved in exploring Cognos objects in Framework Manager, Report Studio then Replicate same objects in Microstartegy. • Expertise in moving the objects between two different projects by using Object Manager and resolve conflicts between the environments by using conflicts resolution window.• Involved in upgradation of Microstrategy projects from 8.1.2 to 9.0.2• Responsible for installation of Microstrategy 9.0.2 on new boxes and hot fixes on already existing boxes.

Education

• NYIT

  Master's degree

Skills

• Sql
• Etl
• Databases
• Microsoft Sql Server
• Microstrategy
• Oracle
• Sdk
• Cognos
• Business Intelligence