Posted 8 months ago
Skill Set :- MicroStrategy +BI+ ETL + SQL +Data Modeling + Data Visualization
- Worked on creating MSTR reports same as BO reports.
- Created complete new microstrategy reports same as Business object reports by understanding BO SQL queries and its output. Understand its SQL and check the availably of the tables and columns in snowflake schema.
- Created complete new MicroStrategy reports same as Business object reports by understanding BO SQL queries and its output. Understand its SQL and check the availably of the tables and columns in snowflake schema.
- Created attributes and basic metric using command manager scripts.
- Validate the MSTR report data with BO report output and DB queries.
- Created ICEDQ script for validating and comparing the MSTR data with Business object report data.
- Done metric values validation on higher level.
- Created testing document comparing values with DB and BO reports.
- Coordinated with ETL team while validating data, creating schema and metric validation as it was a database migration project from Netezza to snowflake.
- Working on end to end report and dashboard development for Service Management Office.
- Created iPad dashboard for Change, Incident, Service, Finance, Configuration Management ticketing data.
Education and Experience
2+ years of MicroStrategy development role