OBJECTIVE:

I am seeking a challenging position in Senior Microstrategy Consultant (Architect, Administrator and Developer) that will fully utilize my proven skills and talents.

SUMMARY:

• Very experienced with developing and creating MicroStrategy Reports and Dashboards
• Very experienced with detail data analysis, providing dimensional data modeling solutions and developing conceptual/logical physical data models
• Very familiar with creating overall data modeling and data quality standards
• Very experienced with architecting MicroStrategy projects
• Very experienced with Microstrategy Administration: Installation, Update, Patch, Configuration, Troubleshooting on - going management and support
• Very experienced with MicroStrategy components such as Desktop, I-Server, Narrowcast Server, and Web-Server
• Very experienced with Microstrategy Administration: Installation, Configuration, Troubleshooting on-going management and support
• Very familiar with Microstrategy version 5.6, 6.x, 7.1, 7.2, 7.5, 8.2, 9.1, 9.2, 9.3, 9.4. 10.1
• Very familiar with installing Microstrategy products (I-server, Desktop, web server. Narrowcaster and EM) and upgrading new version.
• Very experienced with ER and dimensional data modeling
• Very experienced with Enterprise Manager to create and produce statistic report to optimize the Microstrategy system
• Very experienced with maintain and support Microstrategy reports to facilitate automatic scheduled processing using Microstrategy Narrowcast.
• Very experienced with Enterprise Manager to create and produce statistic report to optimize the Microstrategy system

PROGRAM LANGUAGES, TOOLS, PLATFORMS AND DATABASES:

• Microstrategy 5.x, 7.1.117, 7.2, 7.5, 8.01, 8.2, 9.1, 9.2, 9.3, 9.4, 10.1
• Microstrategy Narrowcaster, Desktop, I-Server and Web-Server, Enterprise Manager, Object Manager
• Oracle, NCR Teradata, MS SQL Server (6.5/7.0)

PROFESSIONAL EXPERIENCE:

Confidential, Century City, CA

Microstrategy Architect & Dashboard Developer

Responsibilities:

• Designed the architecture layer in MicroStrategy for Flash and Marketing Dashboards
• Supported the MicroStrategy Dashboards implementation
• Provided technical leadership for the entire MicroStrategy environment including Architecture, best practices, processes and development standards

Confidential, San Francisco, CA

Microstrategy Architect / Developer / Administrator

Responsibilities:

• Supported and maintain MicroStrategy Servers and many scheduled reports which send to the hotels daily, weekly and monthly basis.
• Migrated MicroStrategy Servers from 9.2 to 9.4
• Worked closely with Business Intelligence Business Analyst team and MSTR Team to be able to provide better Microstrategy reports to Business Users
• Supported batch jobs run from Confidential to trigger the reports and upload the files to the Server

Confidential, San Francisco, CA

Lead Microstrategy Developer

Responsibilities:

• Provided day-to-day maintenance and administration of MicroStrategy Intelligence and Narrowcast Servers
• Developed FAB related schema objects and reporting objects and designed reports supporting business requirements
• Developed MicroStrategy reports to provide customer-market basket analysis of the skin care products
• Designed and developed multiple BE FAB program reports using MicroStrategy
• Managed Microstrategy I-Server caches, memory, users and privileges

Confidential, Redwood City, CA

Senior Microstrategy Consultant

Responsibilities:

• Manage MicroStrategy environment for Confidential
• Create MicroStrategy Registration Page Bounce Rate, Game Stats by Club/Free/Guest Analysis, Subscriptions Dashboards, and the Dashboard using Omniture (Web Analytic tool) data
• Lead MicroStrategy admin and developer responsible for MSTR project design, report development and administration; consolidated and standardized the existing schema and reporting objects

Confidential, San Francisco, CA

Senior Microstrategy Consultant

Responsibilities:

• Complete conversion and prepare to deploy Microstrategy reports as required to replace mainframe system.
• Make technical decisions and allocate resources to minimize cost, risk, delay, and insures Microstrategy will perform as expected in production.
• Provide post Microstrategy go-live support as needed to address unexpected issues and maximize system performance during peak.
• Develop alternative technology path as needed to compensate for unexpected deficiencies in Teradata planning, skills and resources.

Confidential, Cupertino, CA

Senior Microstrategy Consultant

Responsibilities:

• Architected MicroStrategy 9.2 Projects and developed the reports and dashboards
• Provide technical skills on Microstrategy 9.2 including development, architect and administration
• Installed and configured MicroStrategy 9.2 I-Servers, Web-Servers, Narrowcast and Enterprise manager

Confidential, Sunnyvale, CA

Senior Microstrategy Consultant

Responsibilities:

• Performed development in the construction of a data warehouse system (Microsrategy 9.2) that reported from very large Oracle merchandising database
• Gathered requirements from business experts to identify marketing goals, plan campaigns, segments and treatments.
• Developed Direct Marketing System reports using Microstra te gy 9.2 Desktop
• Using MicroStrategy OLAP, created versatile reports as analytical tools for calculating campaign performance data to optimize marketing yield.

Confidential, San Francisco, CA

Senior Microstrategy Consultant

Responsibilities:

• Performed upgrade and patches on Microstrategy I-Server, Web-Server and Narrowcast Server
• Managed Microstrategy Clustered Server
• Performed transforming project data requirements into dimensional data model.
• Conducted logical data remodeling and data analysis.
• Identify the key facts and dimensions necessary to support the business requirements and develop these requirements into logical and physical dimensional models
• Performed development in the construction of a data warehouse system (Microsrategy) that reported from very large database
• Using MicroStrategy OLAP, created versatile reports as analytical tools for calculating campaign performance data to optimize marketing yield.
• Developed Direct Marketing System reports using Microstra te gy Desktop

Confidential, San Francisco, CA

Senior Microstrategy Consultant (Architect, Administrator and Developer)

Responsibilities:

• Gathered requirements from business experts in Merchandise, Sales, Data Warehouse, Finance
• Developed very complex Sales and Inventory performance reports using Microstrategy Desktop
• Developed technical requirements and functional test cases working with IT Applications developers and business clients.
• Make technical decisions and allocate resources to minimize cost, risk, delay, and insures Microstrategy will perform as expected in production.
• Developed and troubled shoot complex retail reports

Confidential, San Francisco, CA

Senior Microstrategy Consultant

Responsibilities:

• Designed and developed the insight of client’s portfolio and market analysis reports for leading financial institutions (Wells Fargo Home Mortgage, Bank of America, Citigroup Financial, Fannie Mae, Washington Mutual, Federal Reserve Board, Countrywide, etc.)
• Developed Microstategy reports to provide delinquency information, prepayment information, and general loan characteristics at aggregate level of the client’s portfolio and the market.

Confidential, Pleasanton, CA

Senior Microstrategy Consultant

Responsibilities:

• Performed project merge from development to production environment using Project Merger Wizard
• Configured Microstrategy Intelligence Server to make project available in production environment
• Developed and troubled shoot complex retail reports
• Using MicroStrategy OLAP, created versatile reports as analytical tools for calculating sales and I inventory for any given period or moment
• Set up the security in the Microstrategy system: Controlling access to application functionality (privileges & permissions)
• Performed administration on Microstrategy web products
• Managed, audited and upgraded license Microstrategy system for the proper licenses
• Used Enterprise Manager, loaded data from statistics tables to data warehouse table and scheduled Enterprise Manager Statistic reports
• Monitored current user’s accesses, reports running and database connection by using monitoring tools such as Job Monitor, Project Monitor, User Connection Monitor and Cache Monitor
• Migrated metadata from development environment to production environment by using Confidential

Confidential, San Francisco, CA

Senior Microstrategy Consultant

Responsibilities:

• Using MicroStrategy Desktop Ver. 7.2, 7.5, analyzed online transactional data entered via terminals over retail stores and created reports viewing and manipulating data in multiple formats
• Created mapping documents by gathering functional requirements from business analysts
• Migrated metadata from development environment to production environment by using Confidential
• Scanned metadata by using Scan MD and MD Doctor
• Tested LW Next Sales and Inventory, MTD Net Sales and inventory and Retail Last 4 Weeks run time for performance issues
• Performed duplication a project from one environment to another environment
• Made Microstrategy system efficient by reconfiguring caches(report, element and object ), history list and scheduling
• Developed and supported 30-40 simple to complex retail and DTC (Direct to Customer) reports against Retek (RDW) Database, including Media Code Summary Report, Daily Backorder Forecasting, SKU Level Pricing and Inventory by Media Code, and Inventory Status Report, ETC.

Confidential, Raleigh, NC

Microstrategy Specialist

Responsibilities:

• Developed very complex Confidential monthly reports using Microstragy Desktop
• Created report requirement documents by gathering information from business users and business analysts
• Migrated existing Focus reports to Microstrategy Reports on NCR Teradata Database
• Tuned performance issues on very complex Confidential monthly reports such as Computer Forwarding System reports (200 metrics in one report)
• Identified business rules of current Focus Confidential Barcode System Reports and created Microstrategy Report Specification documentation including source to target mapping
• Analyzed NCR Teradata Enterprise Data Warehouse using QueryMan and designed Microstrategy schema including time and location hierarchies, fact and attributes