Nitin Korade Email & Phone Number

Warsaw, Pl

Pune, Maharashtra, India

Pune, Maharashtra, India

Vadodara Area, India

Worked as MSTR Architect/Developer. Created all MSTR objects including Public/Application, Schema and configuration objects.Upgraded MicroStrategy from 10.3 to 2019Converted legacy python reports to MSTR.Created Supplier Scorecard dashboards.Good exposure on Cherwell ticketing System/Azure ADO/JIRA.Worked as Sisense Data Engineer/Architect.Created numerous Elastic Cube and modeled them to optimal design.Created various complex dashboards. Made various custom changes using JavaScript/JQuery.Responsible for Cube/Dashboard migration from Dev/Stage/PROD.Automated cube deployment using python for changing Client ID and Server connection string.

Pune Area, India

- Upgraded MSTR 10.3 version to 10.7- Migrated Metadata from SQL server to Oracle.- Identified all MSTR objects and reports that uses VLDB setting to reduce work efforts by writing custom SQL.- Identified all objects that are SQL specific(internal functions being used) and convert then to Oracle specific.- Upgraded MSTR from 10.7 to 10.11- Automated N number of object creation using Python and Command Manager.- Good explores on Microstrategy API and Library.- Imported MSTR Reports/Cubes to QLIK using Microstrategy API.- Hand on experience on Microstrategy Transaction Services.

Uppal, Hyderabad

• As a MicroStrategy architect developed and integrated various business modules into existing data warehouse• Created numerous MicroStrategy objects which include features like dimensional metrics, transformation metrics, conditional metrics, role playing attributes, relationship filter,pass through functions • Created various Dashboard and Scorecards using Report Services Documents for external and internal users• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization• Created several Custom tables, Views, Aggregations and Stored procedures for developing Freeform reports• Handled all production and staging migrations using object manager• Worked on performance tuning of various reports using VLDB setting and SQL Server performance tuning approaches.• Created various I-Cubes and scheduled jobs to refresh the cubes.• Involved in creating security filters & security Roles to end users to access data based on their privileges• Develop reports implying complex filters with advanced qualifications involving the ‘Apply simple’ and ‘Apply comparison’ functions• Involved in R integration with MSTR and created various Forecast Dashboards• Good exposure on table aliasing and creating heterogeneous mapping between attributes.• Experience on Single Sign on Process for MicroStrategy users• Created various stored procedures and ETL packages as a part of data warehouse developmentEnvironment: MicroStrategy 9.4 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services),SSIS 2012, SQL Server 2012.

Hyderabad Area, India