SUMMARY:

• 9 years of experience as MicroStrategy Consultant with extensive business intelligence consulting experience in multiple industries, including retail, finance, real estate, healthcare, etc. Familiar with both the traditional waterfall methodology and agile methodology.
• Comprehensive knowledge in MicroStrategy architecting and development, project management, security management, administration and testing. Working experience on MicroStrategy SDK development, integration, and maintenance. Ability to collaborate with data warehouse teams and ETL architects on overall design and solutions.
• Extensive experience in working with business users to gather reporting requirements, source data analysis, data modeling, ETL design and implementation, report and dashboard development, testing and deployment of MicroStrategy projects.
• 9 years of experience and expertise of SQL, relational databases, data modeling and web - based applications. Working knowledge of various RDBMS such as Microsoft SQL Server, Sybase, DB2, Oracle, Teradata, and MySQL, as well as big data solution such as Hadoop.
• Experience with large scale enterprise data warehouse design and development (10 ~ 100TB) in Oracle and Teradata. Development of logical and physical data modeling using snowflake and star schema.
• Hands-on experience in designing MicroStrategy Mobile reports and dashboard apps on iPhones and iPads. Used Visual Insights, Report Services, Distribution Services, and Transaction Service to create Web-based applications.
• In-depth knowledge in using MicroStrategy R integration to create derived metrics for advanced analytics, such as ARIMA model forecasting and Survival Analysis.
• Working experience on assisting with QA testing, data validation and production support including system troubleshooting, performance tuning and change management. Managed user training programs in preparing user’s guide, training documentation, walk through of demos and exercises.

TECHNICAL SKILLS:

BI/OLAP: MicroStrategy 8.x/9.x/10.x (including Intelligent Cube, OLAP Services, Architect, Developer,Server Administrator, Web Universal, Report Services, Visual Insights, Office, Mobile BI), Tableau, Business Objects, Qlikview, Cognos .

Data Warehouse/ETL: Informatica, Datastage, Teradata, SQL Server, DB2, Oracle, Sybase, MySQL.

Data Modeling: Erwin

Others: SAS, SSPS, R, Python, JavaScript, Microsoft Project, Microsoft IIS, Apache Tomcat, IBM WebSphere .

PROFESSIONAL EXPERIENCE:

Confidential,Owings Mills,MD

Sr. MicroStrategy Architect

• Analyze the execution log and legacy documents of existing Business Object reports, compare the similarity and differences across the BO reports and universes to rationalize the scope of conversion efforts.
• Oversee a team of junior developers, provide guidelines and directions on the reports and documents development, and develop solutions for complex business logics.
• Analyze, derive and standardize complex business logics from hundreds of store procedures and Business Object reports on a legacy reporting and database system, and translate them to new report business logic according to the new database system.
• Design and develop holistic solutions to implement complex business logics and functional requirements by utilizing the full scale of MicroStrategy out of box functionality such as logical view, freeform SQL report, Intelligent Cube, bursting, data blending, derived attribute, and URL API.
• Design and develop semantic layer infrastructure to support complicated business logics on a new database by creating database views, MicroStrategy logical views, attributes, and facts.
• Design and develop complex reports, documents and dashboards to replace the existing Business Object documents.
• Optimize report and document performance by tuning VLDB settings, changing logical view SQL code, implementing Intelligent Cube, and working with DBA to optimize the database table indexes.

Confidential,McLean,VA

MicroStrategy Consultant

• Designed and developed Cubes, reports and interactive dashboards to satisfy the users’ functional and performance requirements. Created Level Metrics and Derived Metrics to perform complicated calculations and logic tests using data from multiple database.
• Utilized MicroStrategy multisource options to design and develop Cubes and reports to perform complicated data retrieving job from multiple transactional databases. Utilized MicroStrategy data blending features to join data at dashboard level to achieve desired performance and scheduling requirements.
• Optimized Cube publishing performance and Dashboard performance to meet the performance requirements by changing the VLDB settings and restructuring the Cubes used for the dashboards.
• Assisted in designing and developing MicroStrategy Logic Views as backbones to help retrieving data effectively from multiple transactional databases.
• Optimized the freeform SQL Codes used to create MicroStrategy Logic Views, and effectively improved the performance by more than 80% in some cases.
• Assisted the ETL team to design and develop the ETL process using Informatica to build desired data mart to meet the desired performance requirements.
• Assisted in designing and developing Data Mart Reports to support data write back functions required for the project.

System Information: MicroStrategy 10.2, Oracle, Informatica, Sybase, DB2, SQL Server, and Linux

Confidential,Yuba City, CA

Sr. MicroStrategy Architect

• Interacted with clients in gathering business requirements and developing technical requirements for the Dashboards and Reports. Analyzed, identified and resolved the data issues and functionality issues.
• Designed, developed, and implemented over 20 reports, over 10 VI dashboards, and 4 interactive RS dashboards for the management team.
• Designed and implemented functionalities within the dashboards, such as selectors, widgets, information windows, and D3 plugins.
• Worked with java developers to develop and integrate SDK plugins such as customized D3 widgets and add-on customized functions.
• Created schema objects that project required, such as logic views, attributes, facts and hierarchies; and application objects like metrics, filters, custom groups and consolidations.
• Applied R Integration to create advanced derived metrics using Survival Analysis and ARIMA prediction models to fulfill client’s analysis requirement.
• Researched and resolved statistical problems associated with the derived metrics created by R Integration, such as time series data, and survival analysis censoring data.
• Integrated ESRI map with VI dashboard to present the data in a geographical form, and integrated the VI dashboards with RS dashboards using HTML container.
• Assisted in MicroStrategy Administrative tasks like creating users, user groups and security filters, and migrating objects and projects across environments using Object Manager and Project Merge Wizard, as well as upgrading MicroStrategy from 9.4.1 to 10.4.
• Optimized and improve the performance of MicroStrategy reports and dashboards by creating and scheduling intelligence cubes, caches, and configuring VLDB Settings.

Confidential,New York,NY

Sr. MicroStrategy Developer

• Designed and developed interactive Dashboards using out-of-box tools and advanced visualizations such as ESRI maps by integrating Visual Insights visualization. Created advanced data visualization and analysis using Visual Insights.
• Interacted with users to understand their reporting needs in order to create new reports, and improve performance of the existing reports.
• Designed and developed interactive Dashboards and Reports for Mobile users on both IOS and Android platforms using MicroStrategy Mobile features.
• Designed Intelligent Cubes by analyzing business data and the needs of business power users to support Visual Insights users and improve overall user experience.
• Optimized the performance for existing reports and Intelligent Cubes to bring down report response time remarkably by optimizing SQL using the VLDB Properties and creating appropriate aggregate tables, indexes and table partitions in data warehouse.
• Work closely with SDK developers to maintain and improve deployed SDK applications such as customized widgets and customized website.
• In charged of unit testing and regression testing for all the critical defect reports in MSTR and database environment.
• Worked closely with DBA and ETL developers to in corporate additional business data to the data warehouse for BI reporting, and make changes to the views in the database to support the reports.
• Troubleshot and resolved high-priority and critical defect issues in production and put reports back to production within the deadline.

System Information: MicroStrategy 9.4.1, Teradata, Oracle, DB2, Datastage, and Linux

Confidential,Columbia,MO

Sr. MicroStrategy Developer

• Created star schema to develop the data mart in the data warehouse. Involved in creation of schema objects attributes, facts, hierarchies and transformations for development of application objects on top of it.
• Involved in creation of Advanced Metrics including Conditional, Level, Rank and Transformation Metrics. Created three types of reports: Enterprise reports, Dashboard analysis reports, and Ad-hoc reports. Also used pass-through ApplySimple function to build custom attributes and metrics, as well as attribute-to-attribute relationship filters to satisfy reporting requirements.
• Involved in development of Interactive Dashboards and Scorecards using MicroStrategy built-in widgets and custom visualization. Worked with Visual insights to create advanced data visualization and analysis.
• Optimized query performance by experimenting and configuring VLDB properties in MicroStrategy. Deployed Intelligent Cubes and report caching to speed up the processing time and improve user experience.
• 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.
• Worked with Tableau to create interactive dashboards and advanced data visualizations.

System Information: MicroStrategy 9.2 .1, Informatica PowerCenter 9.1, Oracle 11, SQL Server, Linux, and Windows

Confidential,San Francisco,CA

MicroStrategy Consultant

• Collaborated extensively with Data Architects, Teradata DBAs, ETL developers and Business System Analysts to understand the requirements and translate in to Teradata system requirements.
• Created and managed high performing databases and managed the workload effectively. Contributed to the creation of efficient physical data models.
• Responsible for the performance turning, optimization of queries. Ensured the Teradata system resources are used effectively and data is loaded, transformed, extracted with minimum latency.
• Managed BI environment including monitoring the environment, migrations, user creation, security privileges and report schedules. Tuned, debugged and resolved technical issues of the existing reporting solutions and supported the end users.
• Analyzed the source systems and mapped tables in the Data Warehouse environment to give accurate solutions to the reporting requirements.
• Developed and maintained business intelligence reports, dashboards and cubes as appropriate for the business team needs. Created and run ad-hoc reports for various business units when immediate analysis, decision making and direction setting are needed for the business.
• Managed Business Intelligence/Report development lifecycles, including requirements, design, development, testing, UAT, production implementation and support thereafter.
• Understood new business models and adapted the right business reporting methods into the development of KPIs, reports and dashboards. Played a key role in BI and data warehouse platform development and support. Presented the self-service feature of BI tool, empower business users to discover data.

Confidential

MicroStrategy Developer

• Data migration from legacy systems and existing CRM applications to integrate the data warehouse.
• Developed and maintained reports, dashboards and cubes as appropriate to meet the business team’s needs. Migrated the design of legacy reports and dashboards to the MicroStrategy platform.
• Prepared functional requirement documents for internal IT team for implementation of MicroStrategy 9.2.1 BI for corporate and executive board.
• Created naming standards for attributes, metrics and filters to empower business users.
• Developed public objects like metrics, custom groups, consolidations, prompts, templates and filters, and created various hierarchies
• Coordinated with database architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.
• Technical writing for the engineering services division for construction and project management
• Prepared documentations BRD and FRD related to the MicroStrategy project implementation.

Confidential

MicroStrategy Developer

• Analyzed the new projects and translated functional requirements into technical specifications and supported data analysis and validation. Developed MicroStrategy grid, HTML, report services and dashboard reports in Oracle warehouse databases.
• Applied MicroStrategy best practice methodology with snowflake and start schema data modeling design. Created advanced schema objects including common child attributes, relationship filters, custom groups and consolidations, level metrics, and intelligence cubes.
• Worked with ETL staff to interpret operational database schema including entity-relationship diagrams, resolved many-to-many data relations using surrogate keys, resolved ragged hierarchies and recursive hierarchies.
• Participated in migrating MicroStrategy objects, reports and dashboards to the new MicroStrategy 9.0.1 platform.
• Extensively adopted OLAP services (view filter, report objects, derived elements, dynamic sourcing) to improve report and dashboard performance. Used report cache sharing and data mart reports to enhance the report response time.
• Applied MicroStrategy Object Manager to promote changes across various environments and configured Narrowcasting services to distribute personalized data content to various user groups with customized preferences.
• Designed and developed complex aggregate, joiner, lookup transformation rules (business rules) to build consolidated (Fact/Summary) data identified by dimensions using Informatica PowerCenter tool.

System Information: MicroStrategy 8.1/9.0.1, Informatica PowerCenter 8.6, Oracle, UNIX, and Windows.