SUMMARY:

• Experienced Business Intelligence Solution Professional, with extensive BI lead and hands on experience in all areas of the MicroStrategy suite of applications, with strong development and implementation skills who effectively implemented/administered to a medium to large - scale data warehouse.
• Created multiple data models from core tables using combinations of database tables and logical views inside MicroStrategy
• Created multi-level security using Security Roles, Security Filters, Groups and ACL.
• Led various BI projects for Confidential, including migrations, upgrades and “new” development
• Modified multiple VLDB Settings at Project, Report and Attribute/Metric levels
• Certified Report Developer, Certified Advanced Administrator, Certified Narrowcast Administrator and Certified Project Design (Architect).
• Implemented Data Wrangling (Version 10)
• 15 years of daily usage in Analysis, Administration, Design Development, testing and implementation of business requirements using the MicroStrategy suite of tools.
• Experienced in MicroStrategy Desktop, Architect, Intelligence Server, Web, Narrowcast Server, Enterprise Manager and Office.
• Implemented Operations Manager (Version 10)
• Tableau experience creating connections, reports and dashboards
• Solid understanding of data warehouse design concepts including Star and Snowflake, Normalized and De-Normalized Schemas.
• Implemented multiple new Data Models
• Extensively worked with Metrics, Attributes, Drill Maps, Prompts, Filters, Transformations, Custom Groups and Consolidations.
• Daily use/working knowledge of MicroStrategy 10.2
• Working knowledge of Tableau
• Strong analytical and problem solving skills.
• Ability to meet stringent deadlines for implementation.
• Ability to work independently as well as in a team environment.

EXPERIENCE:

Confidential, San Francisco, CA

MICROSTRATEGY ARCHITECT BI CONSULTING

Responsibilities:

• Gather, define and integrate end-to-end requirements for growing BI environment.
• Design creative solutions to complex Design specifications
• Re-engineer existing environment while not influencing timelines
• Mentor junior level developer
• Coordinate work with off shore team
• Created Facts, Attributes and Hierarchy using MicroStrategy Architect.
• Design/Develop new architecture from business requirements/Database design team
• Created new dashboards and visualizations using Visual Insights.
• Working with business users to define dashboard and report requirements.
• Created Object, Element and Expression Prompts and Prompted Metrics.
• Created advanced metrics (level, derived, transformational, conditional, and compound metrics) with attribute dimensionality.
• Created complex/relational attributes using functions.
• Convert existing SQL based reporting to MicroStrategy
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Adjusted/updated VLDB properties and caching options for performance tuning.

Environment: MicroStrategy 10.2/ 10.1/10.0/9.4.1 , MicroStrategy Intelligence Server 10.1/10.0/9.4.1 , MicroStrategy Web Universal 10.2/ 10.1/10.0/9.4.1 , MicroStrategy Narrowcast Server 10.1/10.0/9.4.1 , SQL Server 2000/7.0, Oracle

Confidential, Newport Beach, CA

MIRCOSTRATEGY ARCHITECT BI CONSULTING

Responsibilities:

• Developed Data Model from Core Tables
• Implemented Operations Manager (Version 10)
• Implemented Data Wrangling (Version 10)
• Modeled MicroStrategy off the new data model
• Created over 1000 objects including advanced metrics and attributes using pass through functions as well as implemented multiple VLDB options
• Worked with business to define project requirements
• Created new dashboards and visualizations using Visual Insights.
• Working with business users to define dashboard and report requirements using MicroStrategy version 10.1

Environment: MicroStrategy 10.1/10.0/9.4.1 , MicroStrategy Intelligence Server 10.1/10.0/9.4.1 , MicroStrategy Web Universal 10.1/10.0/9.4.1 , MicroStrategy Narrowcast Server 10.1/10.0/9.4.1 , SQL Server 2000/7.0, Oracle

Confidential, Burbank, CA

BUSINESS INTELLIGENCE LEAD

Responsibilities:

• Plan and execute upgrades/new installations
• Mentor junior level developer
• Created Facts, Attributes and Hierarchy using MicroStrategy Architect.
• Design/Develop new architecture from business requirements/Database design team
• Created/Implemented Narrowcast System
• Created Services, Subscription Sets, developed Pre/Post SQL embedded in Subscription Sets, Schedules, Information Objects using Narrowcast Administrator.
• Created Object, Element and Expression Prompts and Prompted Metrics.
• Created advanced metrics (level, derived, transformational, conditional, and compound metrics) with attribute dimensionality.
• Created complex/relational attributes using functions.
• Designed and implemented strong regression testing process.
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Adjusted/updated VLDB properties and caching options for performance tuning.
• Created multiple flash enabled documents using many diverse chart/graphs/panels/sliders.
• Used Object manager, Project merge to migrate objects from development project to production environment.
• Conduct extensive data analysis for data accuracy.
• Deploy/use Enterprise Manager to correct performance issues

Environment: MicroStrategy 9.4.1/9.4/9.01/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Intelligence Server 9.4.1/9.4/9.01/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Web Universal 9.4.1/9.4/9.01/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Narrowcast Server 9.4.1/9.4/9.01/ 8.0.1/7.5.3/7.5.2 , SQL Server 2000/7.0, Teradata, DB2

Confidential, Concord, CA

Architect/Administrator/Report Developer

Responsibilities:

• Created Facts, Attributes and Hierarchy using MicroStrategy Architect.
• Design/Develop new architecture from business requirements/Database design team
• Created/Implemented Narrowcast System
• Created Services, Subscription Sets, developed Pre/Post SQL embedded in Subscription Sets, Schedules, Information Objects using Narrowcast Administrator.
• Created Object, Element and Expression Prompts and Prompted Metrics.
• Created advanced metrics (level, derived, transformational, conditional, and compound metrics) with attribute dimensionality.
• Created complex/relational attributes using functions.
• Designed and implemented strong regression testing process.
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Adjusted/updated VLDB properties and caching options for performance tuning.
• Created multiple documents using many diverse chart/graphs.
• Used Object manager, Project merge to migrate objects from development project to production environment.
• Developed custom ETL for purposes of data gathering.
• Conduct extensive data analysis for data accuracy.
• Deploy/use Enterprise Manager to correct performance issues

Environment: MicroStrategy 8.0.1/7.5.3/7.5.2 , MicroStrategy Intelligence Server 8.0.1/7.5.3/7.5.2 , MicroStrategy Web Universal 8.0.1/7.5.3/7.5.2 , MicroStrategy Narrowcast Server 8.0.1/7.5.3/7.5.2 , SQL Server 2000/7.0, Teradata, DB2

Confidential, Concord, CA

Architect/Administrator/Report Developer

Responsibilities:

• Responsible for Business Requirements gathering and analysis.
• Created Facts, Attributes and Hierarchy using MicroStrategy Architect.
• Created Services, Subscription Sets, developed Pre/Post SQL embedded in Subscription Sets, Schedules, Information Objects using Narrowcast Administrator.
• Created Prompts on Hierarchy and used them both as Static and Dynamic Prompts.
• Created Object, Element and Expression Prompts and Prompted Metrics.
• Created advanced metrics (level, derived, transformational, conditional, and compound metrics) with attribute dimensionality.
• Created MicroStrategy Partitions and Data Marts.
• Created multiple Drill Maps that allow drilling to Attributes, Hierarchies and Templates.
• Created complex reports using embedded report as a filter.
• Created Excel documents and PowerPoint presentations using MicroStrategy Office.
• Created complex attributes using functions.
• Designed and implemented strong regression testing process.
• Working knowledge of Enterprise Manager (analyzing Usage trends/Job monitoring for possible partitioning/Data Mart creations).
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Adjusted/updated VLDB properties and caching options for performance tuning.
• Designed, developed and implemented multi-layer security system using line-item security at the database level as well as security filters/ACL at the MicroStrategy level.
• Conducted multiple version upgrades and hot fixes.
• Created and deployed project plans for any new implementations.
• Used Object manager, Project merge to migrate objects from development project to production environment.

Environment: MicroStrategy 8.1.1/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Intelligence Server 8.1.1/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Web Universal 8.1.1/ 8.0.1/7.5.3/7.5.2 , MicroStrategy Narrowcast Server 8.1.1/ 8.0.1/7.5.3/7.5.2 , SQL Server 2000/7.0