We provide IT Staff Augmentation Services!

Microstrategy Architect Resume

Austin, TX

SUMMARY

Confidential professional with 7 years of experience in data warehouse & business intelligence, with primary focus on data analysis, architect, design and administration of MicroStrategy based applications for Web and Mobile platforms. Effective communication with clients to gather requirements, effort estimation, design documentation, deployment for a standard or agile sprints BI application project.

SKILLS:

Primary Skill: MicroStrategy 10.x, 9.x, MicroStrategy desktop, Visual Insight, Tableau

ETL Tools: Informatica Understanding

Databases: SQL Server, Teradata, Oracle, DB2, MYSQL.

Others: Toad, Jira, TFS, Axosoft, Elasticsearch, Logstash, Kibana, Power BI

MICROSTRATEGY EXPERTISE:

  • Architect: designed and built schema and application objects in MicroStrategy following the best practices. Analyzed report requirements and created logical data model. Understanding the source database and designing the physical data model.
  • Reports: created simple to complex reports involving advanced filters, custom groups, consolidations, level metrics, transformations, derived elements, Free - Form SQL reports, Transaction Services based reports, data-mart reports.
  • Dashboards: created intuitive and interactive dashboards for MicroStrategy Web and Mobile. Integrated D3 visualization into MicroStrategy Visual Insight dashboards.
  • Intelligent Cubes: tuned performance of reports involving large volume of data through intelligent cubes, and other VLDB settings.
  • Administration: experience in administration, security implementation using security filters and ACL’s.
  • Experience in project duplication, object migration using Object Manager, project baseline comparison using Integrity manager, Health Center, setting up of Enterprise Manager Project and scheduled data load.
  • Automation: designed and developed custom System Manager workflows along with Command Manager and batch scripts, to automate thereby reducing the turnaround time for admin activities like, intelligent cube refresh, user creation/modification, assigning security filters, creation of subscriptions.
  • Installation and upgrade: experienced in MicroStrategy installation, configuration and experienced in upgrading MicroStrategy to new versions.
  • Schema and architecture design: Understand the source system and the granularity of the data.
  • Used Microsoft Excel and sometimes Visio to design the logical and the physical data models.
  • Worked as a Teradata DB administrator. Performed a lot of DDL and DML operations on the databases.
  • Worked on SQL server and Oracle, and performed the similar activities.
  • Worked on hybrid models Both Snowflake and Star schema .
  • Development: Automated a lot of MicroStrategy applications that involved creation of Stored Procedures, Common Table Expressions, Triggers, write-back functionality using Free form SQLs and Transaction services in MicroStrategy that requires development of custom SQLs. I have encountered the need for designing the tables in such a way, that I handle the Many-to-Many relationships, ragged and recursive hierarchies as well.
  • Performance Tuning & Optimization: Writing an optimized SQL, has been my first priority. Hence I have optimized a lot of MicroStrategy reports that have been poorly designed and thereby generating bad SQL. If things could not be optimized through MicroStrategy directly, I create indexes, partitions on tables after analyzing the stats of the SQL against SQL optimizers.
  • Security: When it comes to security, I do understand the concept of handling data level security at the database level, apart from MicroStrategy based security.

OTHER EXPERTISE:

  • Requirement gathering
  • Design Documentation
  • Effort estimation for standard or agile sprints BI application projects.
  • Team handling and mentoring

WORK EXPERIENCE:

Confidential, Austin, TX

MicroStrategy Architect

Tools: MicroStrategy 10.6, Oracle 12, Toad, Axosoft for task tracking

Responsibilities:

  • Directly interacted with the client to understand the requirements and their BI needs.
  • Studied the existing systems and provided solutions for BI environment setup.
  • Created design documents, detailed task and effort estimation documents for MicroStrategy assignments.
  • Designed and developed the data model for the data warehouse.
  • Designed and developed Schema and application objects as per business rules.
  • Developed documents and dashboards Quarterly and Annual budget documents for around 45 Departments as per business requirements with complex business logic.
  • Stabilized the existing datasets. Fine-tuned the performance of the existing reports.

Confidential

MicroStrategy Architect

Tools: MicroStrategy 10.4, MicroStrategy 9.4.1, SQL Server 2014, Microsoft TFS

Responsibilities:

  • Worked with customers to understand the requirements and their BI needs.
  • Studied the existing systems and provided solutions for BI environment setup.
  • Created design documents, detailed task and effort estimation documents for MicroStrategy assignments.
  • Designed and developed Schema and application objects as per business rules.
  • Developed dashboards and reports as per business requirements.
  • Performed various admin activities in MicroStrategy and developed solutions through automation using System manager, command manager and batch scripts.
  • Heavily used Intelligent Cubes, as the source of reports and dashboards.
  • MicroStrategy installation, configuration and upgrade.
  • Provided insight through ad-hoc reports and dashboards, integrated D3 Visualization like Bubble charts, Box Plots, Bullet charts, Calendar view with visual insight dashboards.

Confidential

MicroStrategy architect and developer

Tools: MicroStrategy 9.4.1, SQL Server 2014, Jira

Responsibilities:

  • Gathered requirements to understand the reporting requirements.
  • Developed Schema and application objects as per business rules.
  • Built dashboards for various analysis Sales, Inventory, Operations, On-time delivery, customer complaints, and product damage data analysis .
  • Developed custom Enterprise Manager reports and dashboards.
  • Worked on admin activities like user creation, security filters and ACLs.

Confidential

MicroStrategy Developer

Tools: MicroStrategy 9.4.1, Jira

Responsibilities:

  • Worked as a MicroStrategy developer to address issues with the daily subscription reports and dashboards to different users in different time-zones and different languages.
  • Tracked and managed tasks using Atlassian Jira, for better visibility and on-time delivery of tasks.

Confidential

MicroStrategy architect and developer

Tools: MicroStrategy 9.4.1, Teradata

Responsibilities:

  • Developed mobile dashboards for Bayer’s field force representatives and developed dashboards for Executives on analysis of competitors’ products.
  • Integrated URL APIs on the dashboards.
  • Designed and developed landing page for different groups of users and provided access to specific dashboards through conditional formatting.
  • Created schema and public objects based on different subject areas.
  • As part of the admin activities, worked on the fine tuning if the I-cubes performance using the VLDB configuration settings, security filters creation and ACLs.

Confidential

MicroStrategy architect and developer

Tools: MicroStrategy 9.4.1, Oracle 10g

Responsibilities:

  • Developed schema objects.
  • Developed application objects, reports and web based dashboards.

Hire Now