Summary
Overview
Work History
Education
Skills
Experience Information
Summaryandaccomplishments
Nature of experience - Description
Timeline

Tnvp Sai Naveen

Hyderabad

Summary

Driven by a passion for data analytics, I excelled at DataFactZ, where I spearheaded the upgrade of MicroStrategy platforms and significantly enhanced system efficiency. My expertise in MicroStrategy, coupled with a knack for seamless team collaboration, has consistently propelled project success and optimized BI tool performance across multiple environments.

Overview

10
10
years of professional experience

Work History

Sr MicroStrategy Administrator

DataFactZ
02.2023 - Current
  • Company Overview: Working for Spectrum stores
  • Providing support and maintenance for the Production and lower Environment
  • Upgraded the Metadata from 2014 to 2019 and reconfigured the MSTR Application
  • Upgraded Hardware for MSTR application hosted in Linux from redhat 7 to redhat 8 version for the next compatible MSTR upgrade
  • Upgraded the MSTR platform from 11.3.4 to 11.3.9
  • Worked and setuped the Disaster recovery
  • Working on the object migrations from lower environment to prod Environment
  • Working for Charter client Charter communications
  • Managed day-to-day office operations, ensuring efficient workflow and adherence to policies.
  • Updated and maintained databases with current information.

Sr Data Engineering Analyst (MicroStrategy Administrator)

OPTUM Global Solutions
03.2022 - 02.2023
  • Company Overview: Multi Tenants
  • Worked on new users creation, modifying users, deleting users by using Command Manager and system manager workflow
  • Monitoring TWS jobs for Cube refresh and other subscription jobs execution
  • Worked with business to meet the security requirement for the db instance and user related objects
  • Worked with connectivity wizard to configure the Metadata, and DWH connectivity Information (DNS name, DB Instances) etc
  • Worked on automation for Admin related tasks through system manager workflow for restarting the iserver manager, tomcat and em dataload also created a flow system manager workflow for cube automation publishing and IR cube publishing
  • Multi Tenants
  • Providing support and maintenance for the Production environment
  • Upgraded MSTR from 2020 to 2021 version in all environments (dev, qa, uat & prod)
  • Upgraded the Metadata from 2014 to 2019 and reconfigured the MSTR Application
  • Working on the object migrations from lower environment to prod Environment
  • Worked on creating new schedules for scheduling the reports, Dashboards
  • Configured Platform analytics & Library
  • Responsible for performance testing using integrity manager after the upgrade
  • Actively involved in walkthrough and meetings with Business team to discuss related issues and review of the Objects and reports
  • Performed Unit Testing after upgrade
  • Conducted meetings with MicroStrategy Team and resolving MicroStrategy opened cases

Sr Development Spec 1

IQVIA
10.2014 - 03.2022
  • Company Overview: Production Support for all BI Tools
  • Procuring the windows server and Installed MSTR application
  • Upgraded MSTR from 2019 to 2020 version in all environments (dev, qa, uat & prod)
  • Responsible for user security
  • Responsible for creating new users, modifying users, deleting users by using Command Manager and access to the Projects
  • Created new schedules for scheduling the reports, Dashboards
  • Responsible for performance testing using integrity manager after the upgrade
  • Used object Manager for moving the objects
  • Monitoring Jobs
  • Installation and configuration for POWER-BI(On premises), SCA & SSRS
  • Deploying the .net applications in Server IIS & Creating the Sites in IIS Level
  • Providing production support to Bi tools for end user(MSTR, PBI, SCA & SSRS)
  • Installation of SQL 2016 & 2019 in servers
  • Managing Database backup for all environments
  • Monitoring Servers alerts
  • Production Support for all BI Tools

Education

BBM -

Skills

  • MicroStrategy 11x
  • MicroStrategy 10x
  • MicroStrategy 9x
  • MicroStrategy 8x
  • Power BI
  • SCA
  • SSRS
  • AWS Cloud
  • SQL 2014
  • SQL 2016
  • SQL 2019
  • Teradata
  • Oracle 19C
  • IIS
  • HTML

Experience Information

Total Experience: 10 Years in MicroStrategy

Summaryandaccomplishments

  • Good experience in MicroStrategy Suite 11.x/10.x/9.x for Administrator, Architect, Reports, Dashboard Support.
  • Having Experience in MicroStrategy upgrade & MicroStrategy Installations and I-server configuration, and worked on various version upgrades 9.2 to 9.4, 10.1 to 11, 2019 to 2020 and 2020 to 2021 upgrades.
  • Experience on MicroStrategy Server upgrades and applying the HOTFIX's.
  • Good Experience on MicroStrategy On-premises Environment (Windows).
  • Strong experience in handling the MicroStrategy tools, like Schema Objects, License Manager, Object Manager, Integrity Manager & System workflow manager.
  • Having basic experience on VLDB properties for reports, projects and Database Instances.
  • Expertise in Designing security model as per the business requirement.
  • Good Experience into overall MicroStrategy configurations.
  • Good experience on MicroStrategy Installations and Configuration of new servers.
  • MicroStrategy Office installations and configuring the projects.
  • Good experience on creating New Projects, and Project Duplications.
  • Experience on User creations, modification and deletions through Command manager.
  • Scheduling the reports by using Distribution services.
  • Good Experience in monitoring TWS jobs for Cube refresh and other subscription jobs execution.
  • Good Knowledge on SQL to check the data in the database.
  • Experience on Automation of Admin Related tasks using workflow manager.

Nature of experience - Description

  • Installation and configuration of all the suites of MicroStrategy 2019 BI products and setting up all MicroStrategy components like Command Manager, Enterprise Manager, System Manager and Integrity Manager.
  • Worked with the business users in identifying and defining the security requirements for report objects and Database Instances.
  • Upgraded all restricted MSTR environments (DEV, QA, UAT, STAGE and PROD from 2020 to 2021.
  • Have done the performance testing using integrity manager after the upgrade and before the upgrade to see the report execution results.
  • Created the Metadata & Statistic tables for the MicroStrategy projects on an SQL Server 2019 database.
  • Created Daily and Weekly database backup schedules in SQL for all the Environments.
  • Created new users and user groups, Security roles, Security filters access controls Lists as a MicroStrategy administrator.
  • Duplicated Project from lower environment to Production and maintained Objects in Sync within all environments.
  • Migrated objects from one environment to another environment Using Packages.
  • For Project migrations and Duplications, Automated System Manager workflows for deployments.
  • Implemented LDAP Authentication for all Internal and External Users.
  • Implemented Library and Collaboration for LDAP Authentication.
  • Maintained all environment servers metadata backup, and regularly monitoring the server health.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
  • Configured the Enterprise Manager for statistical reporting purposes.
  • Widely used SQL for troubleshooting the reports in case of any issue.
  • Worked on Providing Report Usage through Enterprise manager and all admin Activities.
  • Automated some of the admin tasks through system manager workflow like restart the tomcat, iserver manager and Em dataloader.
  • Monitoring TWS jobs for Cube refresh and other subscription jobs execution.

Timeline

Sr MicroStrategy Administrator - DataFactZ
02.2023 - Current
Sr Data Engineering Analyst (MicroStrategy Administrator) - OPTUM Global Solutions
03.2022 - 02.2023
Sr Development Spec 1 - IQVIA
10.2014 - 03.2022
- BBM,

Similar Profiles

CREATE PROFILE
Tnvp Sai Naveen