MicroStrategy Administrator Resume Example
Love this resume?Build Your Own Now
MICROSTRATEGY ADMINISTRATOR
Summary
- Highly effective MicroStrategy Consultant with over 6 years of experience in Working with Data, Analytics and Reporting platforms including Business requirements gathering,design and implementation and proficiency in transforming from various sources(flat files, Oracle, DB2 , Xml) to Data Warehouse using ETL tools.
- Experience in using Teradata and Informatica Utilities to extract and load data.
- Developed PL/SQL stored procedures to handle complex business logic.
- Strong knowledge and understanding of SQL and ability to write SQL queries.
- Have performance tested and involved in tuning of target appliances proposing and configuring system configurations, and resource groups to maximize performance, and minimize queuing and execution time of daily batch processing.
- Strong knowledge and understanding of SQL and ability to write SQL queries.
- Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
- Good experience in working with cloud services like Azure.
- Directed and monitored all activities for BI project from initiation to delivery.
- Hands on Experience with Mobile BI Solutions. Expertise in creating new dashboards and trimming Existing Dashboards onto Mobile.
- Implemented cube based architecture for reporting and converted paper based reporting to dossiers.
- Built SDK tools to monitor reporting jobs and customize home page for training & feedback.
- Demonstrated ability to learn business processes and adapt technical knowledge to provide creative and powerful solutions.
Technical Skills
ETL Tools: Informatica PowerCenter 9.5.1/9.0/8.6, Datastage, MuleSoft Databases: Oracle 11g, Teradata 15.x,16.x, SQL Server 2016, Hive Hadoop: MapR Data Modeling: Erwin, Power Designer | OS: MS DOS, Windows NT/2000, RedHat Linux 8.x, Unix Languages: SQL, PL/SQL, HQL Scripting: Python, Shell Scripting, PowerShell Query Tools: TOAD, WinSQL, Sql Assistant Reporting: MicroStrategy 2019,10.x,9.x, PowerBI and Tableau |
Experience
MicroStrategy AdministratorInfosys Ltd | Addison , TX | Jul 2018-Current
- Involved in Designing and implementing all BI MicroStrategy projects ensuring the solutions align with Cinch's Strategic direction and technology standards.
- Created users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
- Created the Metadata & Statistic tables for the MicroStrategy projects.
- Performed installing, configuring, and administering MicroStrategy Intelligence Server, Web Server, and Mobile Server.
- Designed Data Marts using different multi-dimensional modeling techniques such as Star schema and Snowflake schema, FACT and dimensional tables and also Logical & physical data modeling.
- Responsible for aspects of MicroStrategy including architecting the environment, object development, intelligent cubes and data mining.
- Designed,Developed,Optimized,processing for Structured Data by leveraging MapR - Hive, Hbase, zookeeper,spark and sqoop.
- Collaborated with ETL team to optimize and debug code in IBM Datastage and BTEQ environments.
- Extensively worked in both Ad-hoc and standard Reporting Environments and Involved in creating Reports scalable to large volumes of data.
- Worked on many Digital projects to efficiently build data warehouse schema and also process near real-time / batch data.
- Designed Data marts and intelligent cubes to increase the performance of bulk and most frequently used reports.
- Created and used data mart reports to establish relational tables that can be used like tables in the project schema.
MicroStrategy AdministratorInfosys Ltd | Bolingbrook , IL | Apr 2016-Jul 2018
- Developed and maintained the reporting solutions for the release and deployment between enterprise environments -QA and production migrations of Micro Strategy objects.
- Managing the user security through security roles and security filters.
- Administration of system manager , command manager , integrity manager and object manager.
- Worked on upgrading MicroStrategy version 9.4.1 to 10.1 and then over to 10.2 and later to 10.3 and 10.4.
- Tested the pass-through functionality in MSTR and implemented on the MSTR I-Servers.
- Generated freeform SQL reports writing SQL queries against different databases.
- License administration across all MSTR environments using License Manager.
- Connection setup to Hadoop big Data cluster (Data Lake) through the Kerberos Authentication Mechanism.
- Provided the production and pre-production environment support.
- Involved in troubleshooting Micro Strategy Web Reports, optimizing the SQL using the VLDB Properties.
- Created internal reports which are main sources of all the external reports.
- Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
- Worked closely with ETL people to make sure the data is in the right type needed for reporting.
- Administered MicroStrategy environments and formulated user groups.
- Installing and setting up Intelligence server and Web servers.
MicroStrategy DeveloperAnthem, Inc. | Akron , OH | Apr 2014-Apr 2016
- Designed Logical and Physical schema for integrated data warehouse environment using Fact and Dimensions tables from various databases.
- Developed and implemented Configuration objects, Schema objects, and Application objects.
- Involved in a team for upgrading MicroStrategy product suite from 8.1.0 to 9.0.1.
- Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
- Configured Metadata, Configuration objects, Schema objects, Application objects in all environments (Dev, Test and Prod) to reflect changes made in oracle data warehouse
- Expertise in implementing performance tuning techniques for MicroStrategy and Datawarehouse issues.
- Created Schedules, Jobs, User groups, facts, attributes, transformations, hierarchies, reports, filters, prompts, consolidations, metrics and templates.
- Designed and implemented MicroStrategy security model and security filters at different levels (Database, Project, Group, User, Report, and Object) for the integrated data warehouse project.
Education and Training
Master of Science: Information TechnologyUniversity of Toledo
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Formatting
- Word choice
- Strong summary
- Typos
Resume Overview
School Attended
- University of Toledo
Job Titles Held:
- MicroStrategy Administrator
- MicroStrategy Developer
Degrees
- Master of Science : Information Technology
Similar Resumes
