LiveCareer-Resume

microstrategy administrator resume example with 6+ years of experience

Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Professional Summary


Highly-skilled software development and database professional bringing about 3 years in software design, development, and integration with knowledge of Python and SQL languages. Experienced professional versed in all stages of the development cycle for dynamic web projects as well as driving successful application creation and generation utilizing multiple platforms.

Skill Proficiency
  • BI Tools: MicroStrategy v9.4.1, v10.1, v10.2, v10.3 and v10.4 (MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web Server, MicroStrategy Mobile Server, MicroStrategy OLAP Services, MicroStrategy Architect, MicroStrategy Distribution Services, MicroStrategy Office.)
  • Platforms: Windows 2000/XP Pro/2003 Server, Linux RHEL, Unix.
  • Databases: Oracle, Teradata, MySQL, Hortonworks HDP, Access, Teradata Aster, MongoDB, Apache Hive, Microsoft SSAS, Microsoft SQL Server, Microsoft SQL Database and HP Vertica.
  • Web Servers: Apache Tomcat, IIS, Oracle WebLogic and Red Hat JBoss
  • Troubleshooting and debugging
  • Security expert
  • Shell scripting
  • Exceptional time management
  • Knowledge of C, java and python.
  • Advanced problem solving skills
  • Performance and scalability optimization.​
  • Report development.
  • Execute SQL Queries against DB.
  • Understanding of MSTR architecture and components
  • MSTR installation and maintenance on clustered environment on Windows, UNIX,LINUX environments
  • SSO/Server Authentication Setup & Administration
Education
George Mason University Fairfax , Expected in 2014 Master of Science : Computer System Networking and Telecommunications - GPA :
JNTU Hyderabad India, Expected in 2012 Bachelor of Science : Electronics and Communication Engineering - GPA :
Career Highlights
Infosys Ltd - MicroStrategy Administrator
Tuscaloosa, , 03/2017 - Current
  • Managing the user security through security roles and security filters.
  • Managing the project workflow through the workflow visualization tool.
  • Reporting the project status as a scrum member in daily scrum calls.
  • Automating admin activities like user management, security, project management and DB management through the command manager scripts.
  • Collaborated with developers and MicroStrategy professional engineers to enhance supportability and identify performance bottlenecks.
  • Working on invoking the command manager scripts through the command line interface in the non-windows environment.
  • Developing the reports, dashboards and visual insights using the corporate data.Requesting the changes through the JIRA.
  • Creating and updating the project documentation in confluence. 
  • Administration of system manager, command manager, integrity manager and object manager.
  • Prepare documentation on standards and best practices pertaining to administration, deployment, and support of Microstrategy and upload them in confluence.

Environment: MicroStrategy 10.4 (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Intelligence Server ), Mongo DB (No SQL) Oracle, Apache Hive, Netezza, RHEL, Windows 7, JIRA, Confluence, Kanban and Service Now.  

Infosys Ltd - MicroStrategy Administrator
Warren, , 01/2017 - 02/2017
  • Develop the python/UNIX/Batch scripts and support the existing scripts.
  • Develop the interfaces and applications in Python scripts.
  • Hands on experience on the Java software development kit.
  • Requested several changes through the ticketing tool.
  • Attended the daily standup call as a scrum member in the agile methodology.
  • Provided the prod and the pre-prod environment support.
  • Identified the bugs in the Operations Manager and opened an enhancement request with MicroStrategy support.
  • Upgraded the MicroStrategy environment from  v9.4.1 to v10.2.

Environment: MicroStrategy 9.4.1/10.2 (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy OLAP Services, MicroStrategy Intelligence Server ), SQL Server, Oracle,  RHEL.

Infosys Ltd - Application/Sw Development/Support
Wilmington, , 06/2015 - 2017
  • MicroStrategy Application/Software Development/Support Installation and configuration of MicroStrategy versions 10.x on I-server, web server and mobile server.
  • Worked on upgrading MicroStrategy version 9.4.1 to 10.1 and then over to 10.2, later to versions 10.3 and 10.4.
  • Handled several bugs in the MicroStrategy version 10.3 and reported them to the MicroStrategy technical support team.
  • Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
  • Designed various Dashboards/Scorecards reports, which provide the practical ability for the business user to design and refine their own reports without programming.
  • Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
  • Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.4, 10.1 and 10.2.
  • Adding and supporting users technically in the MicroStrategy environment. Expertise in Object Manager to migrate the MicroStrategy Objects from development to QA and then to the production environment.
  • Tested all the reports by running queries against the warehouse using Toad and compared those queries with the MicroStrategy SQL engine generated queries.
  • Tested the pass-through functionality in MSTR and implemented on the MSTR I-Servers. Involved in upgrading MicroStrategy v9.4.1 to MicroStrategy v10.1 and v10.2.
  • Developed Auto Prompt Filters that gave the user a choice of different filtering criteria each time they run the reports. Extensively used Integrity Manager to test reports when upgraded from MicroStrategy v9.4.1 to MicroStrategy v10.1.
  • Generated Freeform SQL reports writing SQL queries against different databases. Provided basic user training for the MicroStrategy Desktop/Web.
  • Created the Metadata & Statistic tables for the MicroStrategy projects on an Oracle database.
  • Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
  • Gathered user requirements for the new project in MicroStrategy environment including database information and established new projects across Development, UAT and Test environments.
  • Uploading the files into MSTR I server through Linux machine. Installing new plugins to support the usage of MSTR D3 visualizations in existing dashboards and visual insights.
  • Customizing the MSTR logo in MSTR web and mobile. Running command manager scripts for the MSTR administration purposes.
  • Setting up the Operations Manager component of MSTR for administering the pre-prod environment system health. Managing user security on the environment and granting the project access.
  • License administration across all MSTR environments using the License Manager (MSTR tool). Connection setup to the Hadoop big data cluster (Data Lake) through the Kerberos Authentication mechanism.
  • Maintaining the Upstart for users to request access to several user groups thereby gain access to projects to which these user groups are tied up to. Clustering the I-servers in MSTR version 10.2.
  • Worked on a nonportfolio project and updated the project tracking tool with the current phase/stage of the project.
  • Configured TASK API, URL API and supported the related issues. Maintaining the projects in sync across all the pre-prod environments using project merge tool. Installed and configured the operations manager on the web server.
  • Creation of the health center system with MHA and HA for the tracking the performance and health of the servers. Creation of groups, environments and scheduling the data loads for the projects in Operations Manager (OM).
  • Setting up the counters, Alerts for tracking the server health. Delivering solutions to the user’s technical issues through the Request Tracker.
  • Managing user creation and maintaining users through AT&T's User management portal. Developed System Manager Workflow as part of automation (phase-1) to import the package.
  • Worked closely with the MicroStrategy professional services for MicroStrategy project consisting of the enterprise data.

Environment: MicroStrategy 9.4.1/10.1/10.2/10.3/10.4 (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Intelligence Server ), SQL Server, Mongo DB (No SQL) Oracle, Apache Hive, Aster, RHEL, Windows 7/10.


First Object , Inc. - MicroStrategy Administrator
City, STATE, 11/2014 - 06/2015
  • Developed the reports, dashboards and visual insights.
  • Managed the I servers and web servers hosting the application.
  • Developed the Shell scripts to automate the tasks.
  • Managed the team of three to develop the project by providing required technical skill set.
  • Created/updated customization plug-ins in MicroStrategy SDK for Mobile, Authentication and UI Customizations.
  • Experienced using Pass-through functions and In Memory cubes.
  • Experienced the customer-facing role for requirements gathering and architecting solutions for MicroStrategy projects.        
  • Well versed with Admin tools Object Manager, Command Manager, Enterprise Manager, System Manager, Operation manager.
  • MSTR installation and maintenance on clustered environment on Windows, UNIX, LINUX environments.
  • Experienced in admin functionalities of MSTR such as setting up New Projects, User creation, ACL, Security Groups, Roles, Movement of objects using Object Manager
  • SSO/Server Authentication Setup & Administration
  • Hands on experience on Installation and Deployment of MicroStrategy objects from development to QA and production environment.

Environment: MicroStrategy 9.4.1/10.1(MicroStrategy Administrator, MicroStrategy

Desktop, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy

Intelligence Server ), SQL Server, Oracle, Netezza, RHEL, Windows 7


Fannie Mae - MicroStrategy Developer/Administrator
City, , 08/2014 - 11/2014
  • Designed various Dashboards, reports, and visualizations which provide the practical ability for the business user to design and refine their own reports without programming.
  • Created Security roles, Security Filters and assigned them to groups and users to meet the user requirements. Upgraded the MicroStrategy environment from v9.3.1 to v9.4.1 and upgraded the project's metadata.
  • Moved the MicroStrategy Metadata to the robust system. Configured the Enterprise Manager to analyze the user traffic and the projects/reports that are being used.
  • Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.4, 10.1 and 10.2.
  • Managing user security on the environment and granting the project access. License administration across all MSTR environments using the License Manager (MSTR tool).
  • Prepared test cases and tested the MSTR v9.4.1 performance after upgrading the operating system to windows8.
  • Upgraded the MicroStrategy environment from v9.3.1 to v9.4.1 and the project's metadata.
  • Designed the custom groups and consolidation for reports and developed the reports, dashboards, documents, visualizations for the business analysis.
  • Migrated the MicroStrategy objects across the environments and configured the Enterprise Manager to analyze the user traffic and the projects/reports that are being used.
  • Worked with users to determine custom requirements or enhancements for their project.
  • Developed basic and user-specified metrics.
  • Created the drill maps for users to drill and recover the data.
  • Interacted with DBA team for the DB related issues from the MSTR standpoint.
  • Followed best practices and created standards document for MicroStrategy project development.
  • Setting user privileges depending on the role of the user.
  • Managing the projects and the user licenses. Clustering of multiple servers for better performance.
  • Managing the Intelligent cubes. Analyzed the system usage with the Enterprise Manager and maintained the Health center console.
  • Scripting to automate server to send an email to admin group during server termination mode and stop mode.  
  • Reported several issues to MicroStrategy as a primary liaison and requested several changes through the ticketing tool.
  • Provided both pre-prod and prod technical support and provided the status as well as the enhancements needed to the application in the daily standup call as a scrum member in the agile methodology.

Environment: MicroStrategy 9.4.1 (MicroStrategy Administrator, MicroStrategy Desktop, 

MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services,

MicroStrategy Intelligence Server ), SQL Server, Oracle, Netezza, RHEL, Windows 7/8, BMC Remedy.


By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • George Mason University
  • JNTU

Job Titles Held:

  • MicroStrategy Administrator
  • MicroStrategy Administrator
  • Application/Sw Development/Support
  • MicroStrategy Administrator
  • MicroStrategy Developer/Administrator

Degrees

  • Master of Science
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: