{"id":4167,"date":"2025-02-10T14:38:48","date_gmt":"2025-02-10T14:38:48","guid":{"rendered":"https:\/\/www.kyanosai.com\/Career\/?post_type=jobpost&#038;p=4167"},"modified":"2025-02-10T14:38:48","modified_gmt":"2025-02-10T14:38:48","slug":"microstrategy-developer","status":"publish","type":"jobpost","link":"https:\/\/www.kyanosai.com\/Career\/jobs\/microstrategy-developer\/","title":{"rendered":"Microstrategy Developer"},"content":{"rendered":"<div><b data-olk-copy-source=\"MessageBody\">Skill Set<\/b>\u00a0:-\u00a0<b><span class=\"mark4i9tzxr7f\" data-markjs=\"true\" data-ogac=\"\" data-ogab=\"\" data-ogsc=\"\" data-ogsb=\"\">MicroStrategy<\/span>\u00a0+BI+ ETL + SQL +Data Modeling + Data Visualization<\/b><\/div>\n<div aria-hidden=\"true\"><\/div>\n<ol start=\"1\" data-editing-info=\"{&quot;orderedStyleType&quot;:1}\">\n<li>Worked on creating MSTR\u00a0reports same as BO reports.<\/li>\n<li>\u00a0 Created complete new\u00a0<span class=\"mark4i9tzxr7f\" data-markjs=\"true\" data-ogac=\"\" data-ogab=\"\" data-ogsc=\"\" data-ogsb=\"\">microstrategy<\/span>\u00a0reports same as Business\u00a0object reports by understanding BO SQL queries and its output. Understand its SQL and check the availably of the tables and columns in snowflake schema.<\/li>\n<li>\u00a0Created complete new MicroStrategy\u00a0reports same as Business\u00a0object reports by understanding BO SQL queries and its output. Understand its SQL and check the availably of the tables and columns in snowflake schema.<\/li>\n<li>Created attributes and basic metric using command manager scripts.<\/li>\n<li>Validate the MSTR\u00a0report data\u00a0with BO report output and DB queries.<\/li>\n<li>Created ICEDQ script for validating and comparing the MSTR\u00a0data\u00a0with Business\u00a0object report data.<\/li>\n<li>Done metric values validation on higher level.<\/li>\n<li>Created testing document comparing values with DB and BO reports.<\/li>\n<li>Coordinated with ETL team while validating data, creating schema and metric validation as it was a database\u00a0migration project from Netezza to snowflake.<\/li>\n<li>Working on end to end report and dashboard development for Service Management\u00a0Office.<\/li>\n<li>Created iPad dashboard for Change, Incident, Service, Finance, Configuration Management\u00a0ticketing data.<\/li>\n<\/ol>\n<div aria-hidden=\"true\"><\/div>\n<div aria-hidden=\"true\"><\/div>\n<div><b>Education and Experience<\/b><\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02+ years of\u00a0<span class=\"mark4i9tzxr7f\" data-markjs=\"true\" data-ogac=\"\" data-ogab=\"\" data-ogsc=\"\" data-ogsb=\"\">MicroStrategy<\/span>\u00a0development role<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Skill Set\u00a0:-\u00a0MicroStrategy\u00a0+BI+ ETL + SQL +Data Modeling + Data Visualization Worked on creating MSTR\u00a0reports same as BO reports. \u00a0 Created complete new\u00a0microstrategy\u00a0reports same as Business\u00a0object reports by understanding BO SQL queries and its output. Understand its SQL and check the availably of the tables and columns in snowflake schema. \u00a0Created complete new MicroStrategy\u00a0reports same as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","jobpost_category":[],"jobpost_job_type":[],"jobpost_location":[],"jobpost_tag":[],"class_list":["post-4167","jobpost","type-jobpost","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost\/4167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost"}],"about":[{"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/types\/jobpost"}],"author":[{"embeddable":true,"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/media?parent=4167"}],"wp:term":[{"taxonomy":"jobpost_category","embeddable":true,"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost_category?post=4167"},{"taxonomy":"jobpost_job_type","embeddable":true,"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost_job_type?post=4167"},{"taxonomy":"jobpost_location","embeddable":true,"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost_location?post=4167"},{"taxonomy":"jobpost_tag","embeddable":true,"href":"https:\/\/www.kyanosai.com\/Career\/wp-json\/wp\/v2\/jobpost_tag?post=4167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}