SUMMARY:

• 8 years of strong experience as MicroStrategy Developer & Architect building projects and creating dashboards and reports using MicroStrategy 10.x/9.x/8.x/7.x, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, Intelligent Cubes, Intelligence Server, Object manager and MicroStrategy Architect with focus on Data warehousing and Data modeling.
• Expertise in creating dashboards by using Intelligent Cubes and specialized in designing Report Service Documents and dashboards with multiple datasets. 
• Excellent experience in MicroStrategy Report development, Report testing, Report tuning and adhoc reporting.
• Expert in designing Schema, Public Objects, Reports, Dashboards, Scorecards in MicroStrategy and strong experience in SQL Development.
• Experience in working on Freeform SQL reports, complex filters, metrics, Data Mining Services, custom groups, consolidations, and prompts for advanced and predictive analysis.
• Proficient in SQL Commands, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformations using Prompts and Filters.
• Experience in Schema design and creating Schema objects using Star and Snowflake (Hierarchies, Attributes and Facts, Transformations).
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments and MicroStrategy Command Manager to run the automated scripts.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Worked with heterogeneous data sources like SQL Server 2012, Oracle, XML files, Teradata, Sybase flat files, and DB2 files. 
• Experience in coordinating with Database Management team, Business Analysts, End users in understanding their requirements, assisting and providing technical solutions. 
• Extensive experience in onshore/offshore coordination and responsible for project deliverables.
• Involved in monitoring and production support in a 24/7 environment.
• Experience in problem solving and delivering practical solutions. 
• Excellent communication skills, Self - starter, good team player, enthusiastic, innovative and challenge oriented.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10/9.x/8.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle 11g/10g/9i, Sybase, Netezza, MS SQL Server, Teradata 13.x/V2R6

Programming: PL/SQL, TSQL, C, C++, HTML, CSS, JavaScript

Operating Systems: Windows Servers, UNIX, Linux

Other Tools: PL/SQL Developer,, SQL Assistant, MS Office, Microsoft Visio

WORK EXPERIENCE:

Confidential, San Francisco, CA

MicroStrategy Consultant

Responsibilities:

• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Extensively created MicroStrategy Adhoc reports, Report Services Documents, Dashboards.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets.
• Developed Intelligent Cubes to provide improved performance of key portal dashboards.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc. 
• Worked in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups. 
• Used Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Involved in creating security filters to end users to access data based on their privileges. 
• Created subscriptions to email reports to various groups and individuals.
• Adjusted/updated VLDB properties and caching options for performance tuning.
• Extensively worked on SQL queries and also involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Created Test cases as a part of Unit Testing of the generated Reports.  
• Production Support has been provided for ongoing issues.

Environment: MicroStrategy 10.2 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), SQL Server 2012, Windows 7.

Confidential, Fort Mill, SC

MicroStrategy Consultant

Responsibilities:

• Worked with team of Microstrategy developers   and ETL Team for onsite and offshore. 
• High user interaction, understanding their requirement. 
• Administrative experience creating user, setting up privileges. Security access to metrics and attribute level. 
• Develop the reports against Star Schema and Snow-Flake Schema. 
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. 
• Experience with OLAP services. Understanding of Microstrategy architect and it's data flow.
• Experienced in troubleshooting in problems related to I-server, data warehouse, ETL process, metadata, project source and project. 
• Creation of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Actively participated in developing Report Delivery Schedules. 
• Created various Dynamic Dashboard documents with multiple panel stacks, selectors and customized widgets. 
• Converted reports and dashboards from Qlikview to Microstrategy. 
• Generated Key Performance Indicators (KPI) metrics and other metrics. 
• Created Transformations for using in comparative reports.
• Optimized Query Performance by using VLDB settings at report and project levels.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, Minneapolis, MN

MicroStrategy Consultant

Responsibilities:

• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development. 
• Designed Dashboards in 9.4.1/9.3.0 summarizing key business indicators (KPI's) by presenting them in visually intuitive, easy-to-read, interactive documents. 
• Multi panel Dashboards with information about Transactions, Offers and Events, Attributes, Links to detail report was Designed and Implemented using 13 datasets. 
• Worked on the performance tuning of the Microstrategy  reports. 
• Development experience with visual insight, dashboards, and mobile. 
• Created analysis and added visualizations using the data from existing reports and Intelligent Cubes (I-cube). 
• Created Dashboards for Business Leaders, Business Managers to access on IPhone and IPad. 
• Involved in the administration of the Microstrategy   environment. 
• Worked with Data modeling and Database Admin and provided specification for Data Mart Design. 
• Worked with ETL Team to define the mapping between the operational database and the warehouse. 
• Created reports with various object prompts to generate various Ad hoc reports. 
• Trained other team members and business users on various functionalities of Microstrategy tool suite. 
• Created Enterprise Manager Reports & dashboards to analyze customer usage of the reports and average run time of the reports. 
• Used Command Manager for bulk user creation and automating schedules. 
• Used Object manager to deploy Microstrategy  objects from development in to test and production environments. Performed the role of a backup administrator. 
• Troubleshooting report and data issues and supporting the users in problem resolution. 
• Defined and developed use case documents and worked with users on user acceptance testing. 

Environment: MicroStrategy 9.4.1/9.3.0 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Lincoln, RI

MicroStrategy Consultant

Responsibilities:

• Worked on understanding the logical data models by recognizing the source tables and columns, to build Attributes, Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.
• Created Datasets which feed into the dashboard and validated the data on the datasets. 
• Took the advantage of various controls like widgets and selectors to provide more user friendly and interactive Dashboards. 
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy to read, interactive documents using the new selectors like radio buttons, check boxes, panels, slider, button bar etc. 
• Implement OLAP functionality within report service documents to enhance performance. 
• Created conditional metrics, level metrics and modified fact definition when needed to calculate certain complex metrics. 
• Worked with the team to redesign the schema, modify attribute definitions and fact definitions to improve the performance of the report. 
• Extensively created filters, prompts, custom groups, consolidations and transformations to generate reports for Business analysis. 
• Performance tuning of SQL for long running reports. 
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Worked in 3 environments: Development, UAT and Production and used Object Manager to migrate objects in all the environments. 
• Created security roles, users and user groups. Assigned privileges to users and groups through security roles and assigned predefined grouping and custom grouping of permissions to objects using Access Control List (ACL).
• Implemented Security filters at the user level for data level security. 
• Used Command Manager to automate the whole MicroStrategy administrative tasks including, purge cache, user management, and trigger reports according to event load. 
• Extensively used Enterprise manager to monitor server usage and user activity. 
• Took regular backups of the metadata and used ScanMD to remove inconsistencies in the metadata. Also used MD Doctor to remove certain physical inconsistencies in the metadata. 

Environment: Microstrategy 9.3/9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata 13/V2R6, Oracle 10g/11g, MS Office, Windows.

Confidential, Raritan, NJ

MicroStrategy Consultant

Responsibilities:

• Participated in all the Business Meetings with the users to give necessary inputs. 
• Created Microstrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.  
• Importing tables using Warehouse catalog and Creating Logical Tables. 
• Worked on creating custom groups and consolidations as per requirements. 
• Created Apply Simple and Apply Comparison functions to develop complex metrics and filters. 
• Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services. 
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements. 
• Tested all the reports by running queries against the warehouse using SQL Navigator. Also compared those queries with the Microstrategy SQL engine generated queries. 
• Created Transformations (table based, formula based) this week vs. last week analysis reporting. 
• Drilling options (Drill up down across) were used to generate ad-hoc reports. 
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidations and custom group objects in an enterprise data warehouse team environment. 
• Involved in Managing migration of Microstrategy projects and objects from Development to Testing and to production environment. 
• Optimized reports to improve the performance. 
• Co-ordinate test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.

Environment: MicroStrategy 8.x.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Windows Server, SQL server.

Confidential

MicroStrategy Analyst/ Developer

Responsibilities:

• Creation of the Public Objects like Metrics, Custom Groups, Consolidations and Reports. 
• Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects. 
• Duplicating the projects and configuring with new database instance. 
• Design, develop and implement reporting and analysis environment.
• Interact with clients to gather and analyze business requirements. 
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing and involved in report performance tuning.
• Played a key role in User Acceptance Testing of the reports.
• Testing of all MSTR projects as per changes implemented in Schema and Backend.

Environment: MicroStrategy 8.0.1, Windows Server, Oracle 9i.