Business Intelligence Administrator Resume
SUMMARY
- 10+ Years of total IT experience, with 5+ years of progressive experience with excellent understanding of MicroStrategy Suite (Intelligence Server, Architect, Desktop, Web, Mobile, Narrowcast, and Report Services).
- 6+ years extensive experience in Data Warehousing SAP Business Objects 5.X/6.x/BOXIR2/3.1/BI4.1/4.2 Reporting Tool with strong development, Administration and architectural knowledge.
- 4+years of extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 9.x/10.x as Administrator and developer, including technical support, troubleshooting, report design and monitoring of system usage.
- Expert in Business intelligence administration in Training & Supporting end - user reporting needs using Tableau, MicroStrategy admin and Business Objects.
- Experience in MicroStrategy System Administration including Intelligence Server Installation and configuration, project duplication, Configuration of Metadata, creating users, user groups, assigning security privileges and Configuring memory settings.
- Strong experience in MicroStrategy Architect to work on Schema Objects such as Facts, Attributes, Transformations, Logical Tables, and Hierarchies.
- Involved in MicroStrategy 10.0x, 2019 version upgrade, applying hotfixes & testing.
- Configured iPad /Mobile configuring different MicroStrategy projects.
- Duplicating the new projects to the other environments and configured Use various data source like SQL server, composite, SQL Analysis server (cube), Vertica, Teradata, Oracle, Hadoop (Apache Knox multiple Hadoop cluster and Kerberos connection) in MicroStrategy.
- Expertise in using Administration tools like Job Monitor, User Manager, Cache Manager, Object Manager and Involved in Database instance configuration, user setup, security roles, governing settings and defining MicroStrategy Narrow cast Server objects like Service, Schedule, Subscription set and Information Objects.
- Comprehensive working knowledge in Developing Reports by using Freeform SQL queries and logical views in MicroStrategy Desktop. Experience in creating custom filters using Pass-Through Expressions in MicroStrategy.
- Monitoring and maintaining the Clustered I servers, Web servers in the Linux environment and troubleshooting.
- MicroStrategy installation, upgrades, configure, and troubleshoot software and set up new installation of MSTR 10.11/11.1 and integration with Oracle and MYSQL .
- Trained different types of end users onMicroStrategyDesktop and Web and supported a huge number of users.
- Installed MYSQL Database and configured Platform Analytics in MicroStrategy 2019.
- Expertise in solving production issues occurring from the Applications in BO Reporting layer and ETL layer, ORACLE SQL, Data Stage ETL and Linux/Solaris and Windows Platforms.
- Involved in infrastructure activities like installation of BI 4.0/4.1 on Linux/Solaris and windows environments Expertise in BI 4.0/4.1 tools with experience in information design tool, upgrade management tool, BI Launch pad.
- Involved in migration of code from BO XI 3.1 to BI 4.0/4.1 (BO R3 to R4 migration) using upgrade management tool.
- Expertise in Migration of Desktop intelligence reports to Web intelligence reports using Report conversion tool.
- Expertise in LINUX/Solaris commands and scripting.
- Very Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Installation, Developing, Testing, Migrating, Maintenance, and Troubleshooting.
- Experienced in Training & Supporting end-user reporting needs using Tableau, MicroStrategy and Business Objects.
- Responsible with 24/7 on call support for Trouble Management, Change Management and Production Management tickets using BMC Remedy Tool.
- Trouble shooting Severity 1 Issues with minimal business impact. Analyse Severity 2 and 3 Tickets and report the problem.
- Act as aTableauAdministrator, usingTableauServer for publishing the developed dashboards to server, authentication, authorization, security,TableauExtracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as aTableauContent Administrator.
- Configured Use various data source like SQL server, SQL Analysis server (cube), Vertica, Teradata, oracle, Hadoop (Kerberos connection) and creating Groups, Users, Workbooks and Projects.
- Strong advanced tableau developer skills such as complex calculations, table calculations, parameters, geographic mapping, data blending, and extract optimization.
- Create/Manage Groups, Users, Workbooks and Projects, Database Views, Data Sources and Data Connections and Use tamed to automate tasks and use tadadmin to perform administrative tasks.
- Expertise in tableau server 10.3 installed on windows server 2012 r2 with SAML configuration and active directory authentication. Installing, configuring and clustering in Tableau environment.
- Migrated workbooks/Dashboards and data sources, using TABMIGRATE and other tableau admin techniques.
TECHNICAL SKILLS
ETL tools: SAP BO Data Services 4.1 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), DataStage 8.5
Reporting Tools: SAP Business Objects XIR 2/3.1/4.0/4.1 (Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), life cycle manager, Promotion Management, Information Designer tool, Universe Designer, Web Intelligence, Desktop intelligence, BI Launchpad, Report Conversion Tool, Crystal Reports, Xcelsius, Live Office, Query as a Web Service (QaaWS), SAP Business Objects Explorer, Tableau 8.x/9.X/10.x, MicroStrategy 9.4/10.4, PowerBI,MS-Access, SQL Server Reporting Services (SSRS)
RDBMS: MS Access, Oracle9i/10g/11g (SQL, PL/SQL), T-SQL, Teradata15.x, Sybase, IBM DB2, SQL Server 2005/2008/2008 R2
Operating Systems: MS-DOS, Linux/Solaris, WINDOWS NT/XP/2000