SUMMARY:

• Having 4+ years of experience in MicroStrategy ( Intelligence Server, Desktop, web and mobile) in Analysis, design and Implementation of BI applications using MicroStrategy 9x/10x
• Use the Warehouse Catalog to move and update tables in MicroStrategy.
• Expertise in developing Public objects (metrics, filters, prompts, Custom Groups, and Consolidations) to develop Documents and reports.
• Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies.
• Created and defined attributes from fact tables in the appropriate fields under the Attribute Definition section for each dimension.
• Created Interactive Dashboards, Documents using various Selectors and Widgets and Intelligence Cube which helps in better understanding of business trends.
• Improved performance with Intelligence Cubes.
• Involved in configuring the Mobile Dashboard setup and preparing the Mobile Dashboard for IPad.
• Extensively used VLDB Properties to tune Reports/Documents.
• Delivered visualizations and Widgets including Bubble Grids, Visual Crossing Maps, Heat maps, Time Series, Waterfall graphs, Micro charts, and Scatterplots
• Experience on working/creating Drill Maps and Thresholds.
• Involved in creation of Visual Insight for designing the Dashboards.
• Create Parent/Child relationships and set up dynamic attributes.
• Having good knowledge on MicroStrategy Tools (Configuration Wizards, Connectivity Wizards, DB Query, License Manager)
• Knowledge/POC in moving Reports from Dev environment to QA environment and from QA to Prod using Object Manager.
• Creating users, user Groups and assigning security roles for the project.
• Having good knowledge on Data warehouse concepts like Star Schemas and Snow flake Schemas.
• Good knowledge in MicroStrategy Products (Object Manager, Command Manager, Integrity Manager)
• Having experience in SSRS reporting.
• Having experience working on Greenplum and Teradata databases.
• Involved in unit testing, experience in creating unit test cases documents and user Manuals.
• Good knowledge in RDBMS and Data Warehousing Concepts.
• Good communication, interpersonal skills.
• Have ability to work with deadline and timeline pressures.
• Basic knowledge on working with Teradata database.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/ 2000/2003/2007/ XP/7

Databases: SQL Server, Teradata, Snowflake

BI Tools: MicroStrategy v10.11, 10.7, 10.5, 10.4, 10.2, 9.4.1, 9.3, 9.2.1, MicroStrategy Developer/Desktop, MicroStrategy Architect, MicroStrategy Web, Intelligence Server, MicroStrategy Mobile, Report Services Document, Object Manager, OLAP Services, MicroStrategy Diagnostics and Hyperion.

PROFESSIONAL EXPERIENCE:

MicroStrategy Senior Developer

Confidential

Responsibilities:

• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the MicroStrategy Desktop and MicroStrategy Web interfaces.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created new Facts, Attributes and attribute form expressions and Hierarchies as needed in the project.
• Developed Transformations (table based, formula based) to be used for comparative analysis like claims this year to last year (year to date and month to date).
• Extensively created Custom groups and Consolidations to meet the requirements.
• Created Dynamic dashboards with visual insight to improve marketing by product, customer, geographic and promotion analysis.
• Hands on experience in Performance Tuning of the tool and also modifying VLDB properties to achieve maximum performance.
• Used Distribution Server to subscribe reports and report service documents in PDF or excel files.

Environment: MicroStrategy Cloud 10.11, 10.9 (Administrator, Architect, Desktop, Web, Intelligence Server, Object Manager) Teradata and Snowflake.

MicroStrategy Developer

Responsibilities:

• Gathering business requirements from Global and Regional users/Clients, analyzing them and converting into intuitive design solutions.
• Work closely with Data Modeler to build the data model for the project.
• Identify necessary attributes and facts from the data model entities that are required in MicroStrategy Schema layer.
• Creating schema objects such as Attributes, Facts, Logical Tables, Alias tables, Transformations, Hierarchies, Security filters for data entitlement and provided relationships as needed in the project.
• Implemented solutions based on the complex requirements for Ad - hoc reports and Dashboards.
• Creating MicroStrategy application objects such as Reports, Dynamic Documents, Visual Insight, Ad-hoc reports, freeform SQL reports, Metrics (Conditional, Transformational, Dimensional and Compound), I-Cubes, Filters, advanced filters, view filters, Prompts, Derived Elements, Derived metrics, Consolidations, Custom groups.
• Implemented drill down solution for a Document using Visual Insight through URL API and Edit Links
• Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes, Dynamic Sourcing, View filters, Derived Elements, Derived Metrics etc.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters.
• Migrated the project objects between DEV to QA and worked with Admin team for QA, UAT, PROD and COB environments as part of application lifecycle management.
• Interaction with Clients and make necessary changes to reports per Client requirements.
• Created Security roles as per business requirements and assign them to business users/user groups.
• Created security filters to restrict row level data for some users/user groups.
• Extensive experience in the troubleshooting and Performance tuning of the reports/documents/dashboards using VLDB properties.
• Implemented Personally identifiable information (PII) such as restrict column data to certain users/user groups using object level ACL.
• Implemented effective solution to hide Excel image on the documents under complex scenario with security constraints.
• Designed and implemented various solutions for improving performance of the Documents and Cubes.
• Implemented proper relationships between Attributes for achieving desired SQL query in MicroStrategy.

Environment: BI MicroStrategy v 10.4, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, Command Manager, Object Manager, Transactional Services.

MicroStrategy Developer

Responsibilities:

• Participated in requirement analysis from Hyperion reports to MicroStrategy.
• Identified the required Application objects with respect to Hyperion reports.
• Developed MicroStrategy Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Data mart reports, etc.).
• Created Alias tables to define attribute role.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric for very complex reports.
• Used panels, panel stacks, sections, grids for dashboards.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Created the design document personalize the reports as per user requirement, which included customizing and formatting.
• Worked on the complete end to end testing for enhanced quality of the application.
• Validating data returned in all reports, provided a detailed analysis of data, and identified data quality issues.
• Interacted directly with clients for prioritizing tasks and sorting out the requirements completely.
• Actively participated in status meetings of the work done.

Environment: BI MicroStrategy v9.4.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, MicroStrategy Mobile, Object Manage, MicroStrategy Analytics Enterprise, SQL Server, DB Visualizer, SQL Developer, Windows, MS Office.

MicroStrategy Developer

Responsibilities:

• Configuring the Mobile Dashboard setup and creating the Mobile Dashboard with for IPad / I phone/Android.
• Designing the reports/documents based on the business requirements.
• Created Intelligence Cubes and to reduce the database load and decreasing the report execution time by using the Cube Services.
• Designed the public Objects such as Metrics, Prompts, Filters, Drill Maps, Consolidations and custom Groups.
• Worked with Visual crossing maps.
• Unit testing and documenting the unit test results in the UTR(Unit test results.doc)
• Providing the extensive support for the QA/SIT and UAT test environments.
• Involved in Breaking down of Custom Groups and Consolidations reports/document to Intelligence Cube by creating level filter in metrics.
• Having knowledge on working with Object Manager to migrate objects from Dev to QA-Test environment, and from QA to production.
• Worked on command manager to create User and User-Groups.
• Worked with performance tuning by using VLDB.
• Created Security Filters to restrict data for User or User Groups. And assigning the privileges to the User Groups by using the Security Roles.
• Provided support for the application in post-production.

Environment: MicroStrategy 9.4.1, SQL server, license manager.

MicroStrategy Developer

Responsibilities:

• Worked on designing an Excel export dashboard with multiple attributes and metrics.
• Created Reports by using Desktop.
• Created various metric (Simple, Nested, Compound and derived).
• Created various filters (Attribute qualification, set qualification, report qualification and filter qualification) by using desktop.
• Created Prompts (Filter definition prompts, object prompts and value prompt) by using desktop
• Created Custom groups and Consolidation based on requirements.
• Worked on thresholds and images in the dashboard.
• Created documentation on user, user group and security, and Project change management.
• Created Security Filters to restrict data for User and User Groups. And assigned the privileges to them by using the Security Roles.
• Worked with performance tuning by using VLDB.
• Involved in Unit Testing of Reports.
• Worked with Visual Insight dashboard which includes Data Blending.
• Provided the support after post Production.

Environment: MicroStrategy 10.x, Teradata.