PROFESSIONAL EXPERIENCE:

Confidential

Senior MicroStrategy Administrator

My current role is that of a MicroStrategy Administrator, on a team of three admins. My primary job is to provide support for three separate environments, while we work to consolidate all environments. I’m tasked with reviewing the current environments, and making suggestions to improve processes and procedures, to be implemented in the final consolidated environment. Another major task I have is to review the current security model, and completely overhaul to allow for easier administration. I’m also working on streamlining the manual user creation process, and preparing us to transition to having LDAP manage users. I have created various process and procedure documents including user creation, project and object decommissioning, and security group maintenance.

Confidential

Senior MicroStrategy Administrator

I worked as the dedicated MicroStrategy Administrator, overseeing all aspects of roughly 15 distinct environments, spanning across 3 product groups. My initial goal was to evaluate and stabilize the current environments, and to make any recommendations for improvements, including best practices procedures, documentation, and architecture diagrams. I also worked to plan, test and implement a company wide upgrade from MicroStrategy version 9.4.1 HF9 to 10.4 HF4. In support of the upgrade, I maintained Sandbox and Migration environments, used to test new product features, and to test our projects against different database types. In addition, I worked with individual teams to help them become more self sufficient, by working on ways to automate routine processes, such as server restarts, package migrations, and history list cleanup. I was also responsible for server resource monitoring, system usage reports via Enterprise Manager, and overall server tracking, builds, and decommissions.

Confidential

Senior MicroStrategy Administrator

I worked as a Senior Administrator, servicing a variety of companies on a subscription basis. I had 4 - 5 main clients that I provided day-to-day administrative functions for. With the wide range of clients, I regularly worked with multiple version of MicroStrategy, ranging from .2. These functions included, but weren’t limited to, user maintenance, troubleshooting, performance, and general MicroStrategy questions. I was also also responsible for making sure all servers were up and running 24/7, scheduled and ad hoc migrations, new server installs, upgrades, and hotfixes. My job also required me to provide and document any recommendations to clients, which may improve their environment. My clients spanned multiple time zones, so I also worked with an offshore team to make sure constant support was provided. In addition, I mentored entry-level and junior Administrators, and brought them along until they were capable of handling clients on their own.

Confidential

MicroStrategy Administrator (Linux Environment, Web Logic, Oracle Warehouse)

For this contract my main responsibility is that of a liaison between IBM and Confidential . IBM was contracted to implement a BI solution for NII, and I’m tasked with verifying the implementation and assets, ensuring that Confidential has everything that is required to take over production support. In addition, I provide recommendations based on the vision for the proposed environments, and fill any gaps in documentation efforts or implementation strategy. I’m also providing documentation on MicroStrategy best practices, maintenance activities, daily support, backup strategy, and installation and upgrade procedures. There are 3 separate market environments in Chile, Peru, and the US, and I have upgraded these environments from MicroStrategy 9.0.2 to version 9.2.1. I am also tasked with assisting in finding the team that will support the completed environments, as well as, bringing this team up to speed and training them on supporting the systems.

Confidential

MicroStrategy Administrator (Windows/Linux Environment, Tomcat, SQL Server Warehouse)

I was brought in to provide support for current MicroStrategy 8 environments, as well as, to lead upgrade initiatives for 2 different groups. These upgrades ranged from upgrading version 8 to version 9, to upgrading version 9.02 to the latest version 9.2.1. I was also tasked with standing up new UAT and PROD environments, including intelligence and web servers, and working with web teams to configure LDAP, TAM (Tivoli Access Manager), Apache, and Tomcat. I also worked with Bladelogic to streamline the intelligence server installation process.

I completed some minor web customizations such as including the Confidential logo in the web interface, as well as applying the company’s color scheme. I assisted the lead administrator in setting up a proof of concept for MicroStrategy Mobile, and completed stress testing of Office reports after upgrades using Integrity Manager. I documented all work for Confidential to reference in the future.

Confidential

MicroStrategy Administrator (Linux Environment, Web Logic, Netezza Warehouse)

I was brought in to give recommendations on, and install and configure 5 MicroStrategy environments, including Development, UAT, SIT, Production, and Disaster Recovery. I installed 18 Intelligence Servers, 8 Web Universal Servers, and 3 instances of Enterprise Manager. I also converted current Narrowcast services into Distribution Services. I put maintenance procedures in place, such as, migration procedures using packages, user and report maintenance, and a metadata backup strategy. All environments were MicroStrategy version 9, running on Redhat Linux 5.3, and reporting off of Netezza. I created comprehensive documentation, including step-by-step installation and configuration guides, detailed architecture diagrams, and best practices documents.

Confidential

MicroStrategy Administrator (Unix Environment, Tomcat, Teradata Warehouse)

For this contract, my main responsibility was to provide support for the development, staging, and production MicroStrategy environments, while the company transitioned from MicroStrategy to SAP. I was the head of a 2-man team, with one resource being offshore. Specifically, I fielded all tickets related to MicroStrategy, including but not limited to: Web access and data issues, report services documents, OLAP services, bulk data exports, Narrowcast Subscriptions, test ID maintenance, and existing report modifications. The main focus of my position was to troubleshoot any issues introduced during report execution including spool space errors, exporting issues, long running reports, bad metrics and attributes, and poorly designed reports.

Confidential

MicroStrategy Administrator (Windows Environment, IIS, Oracle Warehouse)

Here my main responsibility was that of a MicroStrategy Team Lead. It was my job to ensure all MicroStrategy systems were up and running at all times and to provide 24X7 support. I delegated daily administrative tasks to offshore team members, while overseeing their work and checking for accuracy. I was responsible for installing any upgrades or enhancements, as well as, suggesting new upgrade paths to upper management and the client base. I also created new security and system maintenance procedures, and provided documentation. Other responsibilities included supporting developers with report execution errors, troubleshooting report SQL, report services documents, OLAP services implementation, data issues, warehouse catalog, VLDB settings, and other performance tuning techniques. I took care of all report and object migrations from development to production, including testing and change management tracking. In addition, I used Enterprise Manager extensively to create reports on system performance and usage. I installed and configured Narrowcast, and developed reports, which were mailed to users on a schedule basis. I created new projects and developed new reports to adapt to expanding business needs.

Confidential

MicroStrategy Administrator - (Windows Environment, IIS, Netezza Warehouse)

For this assignment my majors tasks included consolidating three separate MicroStrategy environments (v 7.2.2, 7.5.2, and 8.0.1); and upgrading the single environment to version 8.0.2\Hotfix 2. In addition, I combined 2 separate Narrowcast installs into a single instance, preserving all original users, subscriptions, and preferences. I also upgraded and configured Enterprise Manager, preserving all statistics collected before the start of the project. Other tasks included, copying and updating Report Services documents, copying over users while maintaining current profiles and objects, installation of E Trainer, as well as installation and configuration of all Intelligence and Web Servers.

Confidential

MicroStrategy Administrator/Developer - (Windows Environment, IIS, Oracle Warehouse)

Here I was the sole resource for the entire MicroStrategy environment. This included administration, as well as, development tasks. Specifically, I was assigned to create three separate environments; development, staging, and production. I was responsible for all software installs and patches, for both Intelligence and Web Servers, including all connectivity to SQL Server databases. Within these environments, I put together a user/group security model, as well as, a process to migrate reports and other objects through the MicroStrategy Life Cycle. As a secondary objective, I created all new objects and reports, as the data warehouses were populated with new data, to accommodate company growth. Once all environments were in place, I implemented Enterprise Manager to help monitor the system, and Narrowcast Server to deliver results in a timely fashion.

Confidential

MicroStrategy Administrator - (Unix Environment, IIS, Oracle Warehouse)

My main responsibilities were that of a MicroStrategy Administrator. I maintained 4 separate environments, including test, development, QA, and production. Administration tasks included creating users and applying access to projects, creating/duplicating projects, and migrating objects through the development process. I also tested and implemented upgrades to the latest version, while checking the validity of report, Report Services documents, and Office reports. Other responsibilities included troubleshooting execution errors for reports for the web interface, as well as, Desktop. At this position, I was also responsible for Microsoft SQL 2000 Reporting Services, in which I installed and configured in test and development environments, and provided support for limited users.

Confidential

MicroStrategy Administrator - (Windows Environment, IIS, Oracle Warehouse)

My main responsibilities were that of a MicroStrategy Administrator. One of my major duties was user maintenance and support. I created user accounts and groups, as well as granted permissions to those users and other schema objects. I also provided technical support for MicroStrategy Web, Architect, and Desktop Designer users, for issues involving connectivity, object moves, and report execution. I was responsible for moving new software releases, from alpha/beta into production, by means of Object Manager. In addition I installed, configured, and monitored multiple Intelligence and Web servers to ensure the system was operational, and accessible to clients.

Confidential

MicroStrategy Administrator/PC Analyst:

My main responsibilities were that of a MicroStrategy Administrator. I was in charge of four MicroStrategy servers that I built, maintained, and kept updated. I was the first point of contact for any issues or concerns involving the MicroStrategy implementation. I also implemented MicroStrategy Enterprise Manager, and created reports to monitor and track system usage. In addition, I provided second tier technical support for over 500 in house and remote users, as well as, configured and maintained desktops and laptops for these users. I also assisted the LAN/WAN Manager with user accounts, Exchange administration, backups/restores, disaster recovery, file and folder security, and networked printer administration.