We provide IT Staff Augmentation Services!

Microstrategy Architect Resume

SUMMARY:

Has extensive years of general industry experience with tons of years of solid experience in designing, building and maintaining large data warehouses using Microstrategy, Informatica PowerCenter and Oracle on Solaris. Has completed several s on the MicroStrategy Platform (including MCE) and has been working with all aspects of MicroStrategy. Has background as database and network administrator, in combination with his ETL exposure and expert - level MicroStrategy skills. Has excellent written and verbal communication skills and holds a degree in B.S. Applied Mathematics from the University of Philippines.

PROFESSIONAL EXPERIENCE:

Microstrategy Architect

Confidential

Responsibilities:

  • Serves as the sole Microstrategy Architect/Administrator responsible for the overall administration, architecting, support, report and dashboard/dossier development of the all Microstrategy Projects supporting all companies under Confidential.

Environment: MSTR 2020, SnowFlake, Diyotta, Airflow, Tableau

Microstrategy Consultant

Confidential

Responsibilities:

  • Responsible for architecting. report and dashboard development of the BI Microstrategy Projects supporting Big Data for Anti-Fraud Workbench, Legal, Dividends, Access Partner, and BI Datamarts Reporting.
  • Work includes converting majority of the reports from Business Objects to Microstrategy 10.1 accessing an Oracle 11g Database.

Environment: MSTR 10.4, Linux, Windows NT, Oracle 11g Database, Cloudera

Microstrategy Architect

Confidential

Responsibilities:

  • Responsible for architecting. report and dashboard development of the BI Microstrategy Projects supporting Old Republic Home Loans Data Warehouse.
  • Worked on a Mobile Application for Sales Agents using GPS functionality to extract the Zip Codes in a 2 mile-radius and show pertinent information about Real Estate Offices and their Agents.

Environment: MSTR 9.4.1 HF5, MSTR 10.1, Windows NT, IIS, Oracle 11g Database

Microstrategy Architect

Confidential

Responsibilities:

  • Responsible for the development and support of the Finance Microstrategy Project which is being converted from Business Objects.
  • Work involves architecting, report development and performance tuning of reports/queries; and mentoring junior to mid-level report developers, working with database administrators/system administrators.
  • Responsible for architecting Microstrategy Project supporting Finance and HR. Working on implementing new Cost Package Reporting project.

Environment: Clustered Server running MSTR 9.4.1 HF5 using Tomcat on Red Hat Linux O/S against Oracle 11g Database.

Microstrategy BI Consultant

Confidential

Responsibilities:

  • Responsible for the development and support of the EDW Microstrategy Project.
  • Work involves architecting, report development and performance tuning of reports/queries.
  • Also completed 2 dashboards (Agent Connect Dashboard and the new Registration Dashboard) which were distributed to various users using Microstrategy Distribution Services.

Microstrategy BI Consultant

Confidential

Responsibilities:

  • Responsible for the development and support of the Call Center Performance Managerment Project built in Microstrategy for the Analytics Platform hosted/maintained by Confidential .
  • The SaaS application provides Confidential with the ability to perform various call trending, call detail, call reasoning analysis against call center data stored at various levels.
  • Work involves architecting, report development and performance tuning to provide Confidential users with a reasonable UI experience.

Microstrategy BI Architect/Administrator

Confidential

Responsibilities:

  • Responsible for the maintenance and administration of all Microstrategy Environments (Development, Acceptance and Production), that houses various Projects i.
  • Sales Project, Sales International, Revenue Management etc. including new applications for the IPad in the Sales Mobile and Finance Mobile projects. The environment is a clustered configuration of Windows Servers running Microstrategy 9.0.1 against Oracle 11G, SQL Server 2000 etc.
  • Work included designing the required backend tables and mapping metadata objects to support new Microstrategy projects.
  • Work also involves coordinating with the Business on ensuring that due process is followed in pushing changes between environments as discussed/approved in the Weekly Change Control meetings.
  • Change requests are inputted into a ticketing system to formally track the requests, their statuses and their resolutions.
  • Was a major contributor in 2 Mobile QuickStrike Projects for the development of the Sales Mobile and the Finance Mobile applications that run on IPad.
  • Was able to find resolution of major bottleneck issues that could have prolonged the 15-day QuickStrike for Finance on addition to performance tuning reports/dashboards.

Environment: Clustered MSTR 921 on Windows./NT using IIS

Lead Data Analytics Engineer

Confidential, San Francisco, CA

Responsibilities:

  • Plan and execute yearly MicroStrategy Server environment upgrades to the latest approved software release. Upgrades performed include transitions from version 7.x to 8.x to 9.x, plus dot releases, hotfixes, and patches
  • Setup and monitoring of MicroStrategy cluster server environment
  • Development of best practices and execution of MicroStrategy metadata releases from development to QA to production environments using Object Manager
  • User setup and administration for 20,000 external end users, utilizing Command Manager and batch scripting
  • Script batch files to execute ETL processes and tie them to various administrative MicroStrategy tasks and processes
  • Sophisticated security setup and personalized Narrowcast delivery mechanisms to securely deliver content to internal and external parties
  • Setup and utilization of Enterprise Manager to identify and troubleshoot reporting performance problems
  • Suggest and implement performance improvements for all aspects of the Data Warehouse stack (Oracle Exadata Database, Informatica ETL, MicroStrategy SQL and VLDB optimizations, MicroStrategy caching strategy, Network, Hardware utilization)
  • Database and server hardware capacity planning for 3 major Data Warehouse extensions over the course of 6 years
  • MicroStrategy health checks and server monitoring of sessions, users, performance

MicroStrategy Developer

Confidential, San Francisco, CA

Responsibilities:

  • Provided advanced MicroStrategy reporting solutions for one of Confidential ’s key projects on a clustered MicroStrategy environment supporting over 1500 external end users.
  • Creation of real-time alerts using MicroStrategy Narrocast Server.

Senior Data Architect

Confidential, San Francisco, CA

Responsibilities:

  • Designed strategies for acquisition, transformation and loading of data into relational databases, data warehouses and multidimensional databases.
  • Administered MicroStrategy environments including Web and Narrowcaster, and implemented new projects featuring customizations for data mining implementations.
  • Defined administrative standards, policies and procedures for supporting and maintaining database and MicroStrategy environments.
  • Served as System and Database Administrator on Solaris environment, creating scripts for various administrative tasks.

Hire Now