TECHNICAL SUMMARY:

• 7 years of hands on experience in MicroStrategy architect, design, report and web/mobile dashboard development, performance tuning and troubleshooting, system administration.
• Extensive experience in end-to-end development of MicroStrategy projects in a variety of vertical industries, such as Real Estate, Retail, Manufacture and Telecommunication, etc.
• In-depth understanding of fundamental Data-Warehouse concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Fact and Dimensional tables, Logical and Physical data modeling. Addressed advanced data warehousing modeling and resolved challenges including slow changing dimensions, recursive and ragged hierarchies, etc.
• Facilitated clients to extract business requirements, then decomposed them into user reporting system design. Created various scoreboards and dashboards for demo, evaluation or analysis purposes for both Web and Mobile Interfaces. Used varied methods for performance tuning.
• Participated in the change management across DEV/ UAT/ PROD environments using Object Manager and merging the projects using Project Merge Wizard.
• Extensive knowledge and experience in user training, testing plan and documentation. Experience in working with cross-functional teams to perform business validation and building automated testing suite.
• Experience in Database Design for RDBMS, familiar with ETL and skills in stored procedure, function, package and trigger. Good understanding different database management systems including Oracle, SQL Server, DB2 with respect to Enterprise Data Warehouses.
• Experience in implementing all phases of the System Development Life Cycle SDLC , including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client-Server, Multi-tier, Web Internet/Intranet , Data Modeling and Data Warehousing/OLAP Applications.
• Extensive working experience with Tableau and Salesforce CRM.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business Intelligence Consultant

Scope: This project provides solutions for integration of Salesforce.com to MicroStrategy suite. Duplicated original dashboards from Salesforce.com in MicroStrategy Web interface. Use free-form SQL reports and MicroStrategy transaction services to build mobile dashboards with write-back capabilities. Involve in whole life cycle of the project within application development and dashboard design to support sales people with intermediate and interactive feedback.

Roles Responsibilities:

• Work with business analysts to identify and understand requirements and produce the report design specification and estimates the project. Ensure data structure in Salesforce with SOQL. Use logical views and MultiSource to replenish metadata. Design and develop MicroStrategy schema objects including Attributes, Facts and Hierarchies.
• As the principal architect and developer, deliver proof of concept POC release of the application under a tight time schedule. Work closely with ETL and data architect team in reconstructing data warehouse schema to meet new report requirements and improve query performance.
• Architect MicroStrategy attributes, facts, metrics and user hierarchies. Create advanced attributes and metrics using passthrough ApplySimple and ApplyComparison functions and attribute-to-attribute relationship filters to build custom attributes and metrics to satisfy reporting requirements.
• Configure Web and Mobile Server. Collect Issues during the dashboard designing and creating process. Conduct daily meeting with the client's IT team and business users to ensure the progress is up to speed. Build Freeform SQL reports and stored procedure to achieve transaction services. Create and maintain the intelligent cubes for dashboards. Work with graphic designer to design and create for both web and mobile dashboards.
• Involve in application performance tuning by utilizing both MicroStrategy OLAP Services, Intelligent Cube, VLDB properties and data warehouse aggregate tables, index optimization, partition tables and investigation of query explain plans.
• Coordinate in moving the objects from different Environments by using Object Manager. Merge projects using project merge wizard. Create Users and User groups. Design project and object level security according to business requirements.
• Set up the test environment for the offshore testing team. Assist in QA testing by reviewing SQL statements in dashboard for validation and performance in terms of data modeling.
• Facilitate clients to extract business requirements, then decomposed them into user reporting system design

Environment: MicroStrategy 9.4.1, Sql Server 2008 R2, Tomcat Apache, SSIS, CloudingoStudio.

Confidential

Role: Sr. Business Intelligence Consultant

Scope: Our client provides specialized services in efficiency, money savings and special events for casino resort destinations based on MicroStrategy platform supported output. This project aims to solve the following technology gaps: invalid data, lack of instant reports, no centralized data sources, low latency updates for analysts in the field to give latest insights to clients, archaic reporting capabilities, lack of effectively analyzing the health of client's programs.

Roles Responsibilities:

• Created MicroStrategy schema objects and application objects as the foundation of BI solution. Developed fully-prompted report builder to facilitate user's ad-hoc reporting demand like meeting CRF, time range using Object Prompts and Hierarchy-in-template.
• Designed logical and physical data models using snowflake schema. Architected data models and database design for BI solutions in business areas including compliance reporting, land spend and saving, meeting activity management and monitoring.
• Developed level metrics, conditional metrics and relational filters to meet user requirements and used Free-Form SQL reports in dashboard development. Custom-designed drill-maps for reports and dashboard enable client with the ability to justify the value of its services. Created custom group and consolidation objects to meet user's reporting requirements. Built templates for canned repots.
• Created Data Visualization reports using Bar Graphs, Pie charts, Trend lines for data analysis and used various MicroStrategy widgets including Bubble grid, Data Cloud, Fish eye selectors and slide bars. Hided the complexity by making the dashboards dynamic and easier to navigate
• Involved in testing and validating report data with business and data analysts. Helped to build automated testing suite. Used Integrity Manager to verify report SQL's and validate report data between two environments after object migration. Participated in the change management across DEV / UAT / PROD environments using Object Manager and merging the projects using Project Merge Wizard.
• Helped the business partners on preparing training documentation and users training. Produced turnover documentations for the production support team as well as training on the application. User training: create detailed user guide and data dictionary. Create, maintain, and update docs. Help users for hands-on exercises like how to use canned report pre-defined report , how to understand data and how to create Ad-hoc report.
• Involved with business analysis with customer management directors to define key performance measurement metrics and translate into reporting solutions. Come up with meeting types, spend and destinations based optimization strategies from analytics report data. Analytics services developed include activity categorization, executive dashboard, top 10 destinations, top 10 hotel chains, OLAP reporting.
• Extensive technical and functional communications with a variety of enterprise teams. Coordinated with testing and ETL team to ensure reports and dashboards are delivered on schedule.

Environment: MicroStrategy 9.3.1, Oracle 11g, Oracle SQL Developer

Confidential

Role: Microstrategy Consultant

Scope: Simplifies advanced querying, large-scale data manipulation, complex data analysis and highly formatted reporting leveraging data from the industry's consumer database.

Roles Responsibilities:

• Developed MicroStrategy attributes, facts, metrics and user hierarchies. Created canned reports for general web users and ad-hoc report builders for power users. Used free-form SQL reports and MicroStrategy transaction services to build reports and dashboards with write-back capabilities. Used advanced flash widgets such as micro-chart and heat-map.
• Involved in application performance tuning by utilizing MicroStrategy OLAP services, Intelligent Cube, and VLDB properties. Worked with DBAs and ETL Team to implement aggregate tables to improve query performance.
• Responsible for MicroStrategy production support and administration. Tasks include security setups, users and user groups' security and access management, configuration of LDAP authentication, change management using Object Manager, system monitoring and troubleshooting. Used Integrity Manager to validate and compare report SQL and data during MicroStrategy upgrade.
• Responsible for hosting conference meetings, gathering and refining business requirements from business users. Preparing functional and technical design documents to facilitate data warehouse schema design and MicroStrategy schema mapping.

Confidential

Role: Microstrategy Consultant

Scope: Within the leading PVC profile production enterprise from New England, Microstrategy is used for providing POC in sales forecast analysis corresponding to the conflict of high-volume production and diversity of market customization. Built logical and physical model, deployed Microstrategy product. Created top rank sales dashboards by different type accordingly and exported results into Excel for end user analysis.

Roles Responsibilities:

• Worked as architect and developer, initial release and 2nd release of the application. Worked closely with ETL and data architect team in reconstructing data warehouse schema to meet new reporting requirements and improved query performance.
• Deployed multisource option in warehouse catalog to add duplicate lookup and fact tables into MicroStrategy from secondary source data. Implemented data model for the Type II slow changing dimensions SCD data model. Created logical views and table alias for attribute roles.
• Created various MicroStrategy components such as metrics, filters, prompt, transformations, custom groups, and consolidations for reports and dashboards. Built aggregation tables, table indexes, Intelligent Cubes, OLAP services and configured VLDB settings to enhance query performance
• Developed dashboards in both DHTML and Flash mode. Deployed ESRI map to the MicroStrategy dashboard. Customized the dashboard for each sales representative and delivered the personalized subscription service through MicroStrategy Narrowcast server. Conducted trainings how to use MicroStrategy report builder for ad-hoc analysis for the power users.

Confidential

Role: Business Intelligence Consultant

Scope: Confidential Enterprise Suites was used to build a unity of customer information management system and marketing platform based on data from former major account system, business client system and customer integral system. Various dashboards and standalone reports were created in supporting for both internal and external users. Rearrange and standardize customer information tables with ETL team. Used canned and ad-hoc reports of multi dimensional user queries for marketing support. Built scoreboards providing analysis drilling and KPI monitoring.

Roles Responsibilities:

• Acted as the lead architect/developer in gathering reporting and dashboard design specifications. Provided best-practice development advice and guidance. Indentified and designed the aggregated table to improve query performance. Provided support to data warehousing teaming to ensure data loading accuracy. Completed MicroStrategy schema design and report development.
• Created and implemented MicroStrategy schema objects and application objects by creating facts, attributes, transformations, hierarchies, reports, filters, metrics template. Create several base formulas mathematical expression using existing facts in MicroStrategy.
• Created advanced ApplySimple and ApplyComparision for dynamic dashboard. Developed customized and ad-hoc reports using templates, metrics and filter for business analysis with features of drilling options. Created data visualization report using bar graphs, pie chart, trend lines for data analysis and used various MicroStrategy widgets including bubble grid, data cloud, fish eye selectors and slide bars.
• Involved in changing management across DEV/ UAT/PRD environments using object manager. Assisted with importing LDAP users and user groups into MicroStrategy metadata and integrating LDAP authentication with MicroStrategy.
• Provided guidance, background information and assistance to business users on the interpretation and effective use of business intelligence

Confidential

Role: Microstrategy Architect/ Developer

Scope: Enhanced supply chain management system with respect to material planning in petrol chemical industry through MicroStrategy Suites. Created dashboards for enterprise resource planning. Built scoreboards of diverse widgets and provided drilling among different dimensions for management.

Roles Responsibilities:

• Architected MicroStrategy attributes, facts, metrics and user hierarchies. Created advanced attributes and metrics using ApplySimple , ApplyAgg and ApplyComparison to meet the business requirements. Designed and wrote oracle functions for MicroStrategy objects. Created MicroStrategy reports and documents.
• Created MicroStrategy schema objects and application objects as the foundation of BI solution. Identified and defined facts, attributes, hierarchies and relationships. Modified the existing MicroStrategy architecture citing performance bottlenecks and re-architected the existing hierarchies. Designed and developed metrics, advanced filters, dynamic dates, prompts and reports. Custom-designed drill-maps for reports and dashboard. Created custom group and consolidation objects to meet user's reporting requirements.
• Created Users and User groups. Designed project and object level security according to business requirement. Involved in MicroStrategy upgrade process from version 7.5 to 8.1.
• Led the testing team for the MicroStrategy reports. Planned and executed the project testing including unit testing, integration testing system testing and user acceptance testing. Responsible for logging testing issues and fixing the report defects. Extensively used VLDB setting for SQL tuning and performance turning. Coordinated with UAT testing team and provide solutions when needed.
• Responsible for gathering user requirements through user interviews and facilitating brainstorming meetings. Worked with functional technical IT team to ensure cohesive and consistent project priorities and deliverables. Designed multi-dimensional model based on reporting requirements in Oracle database. Adopted Kimball's methodology of analyzing business.
• Set up the test environment for the testing team and helped with the troubleshooting. Responsible for the user training, including providing lectures, preparing training materials and exercises and designing dashboard reference