Professional Summary

• Eight years of strong experience in MicroStrategy 9.x/8.x/7.x, MicroStrategy Desktop, Microstrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence server.
• Have a very good understanding and worked in Retail, Financial and Manufacturing domains.
• Extensive experience working with all aspects of MicroStrategy tool suite MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services .
• Worked on Public Objects Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates to develop reports.
• Proficient with dimensional data modeling techniques such as Star schema and Snowflake schema, which includes Logical and Physical data modeling.
• Capable identifying business components Attributes and Key Performance Indicators KPI .
• Good knowledge in Micro Strategy Object Manager.
• Good Experience in RDBMS like Teradata, Oracle, SQL Server and DBMS like MS Access.
• Extensive experience creating complex Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Extensively worked and developed Metrics, filters and prompts to give decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Involved in troubleshooting prompt, filter, template, consolidation, and custom group objects.
• Competent developing reports on Grid, Graph, DHTML, PDF, and Flash modes.
• Optimized report generation with respect to Very Large Databases VLDB to make absolute use of Database Flexibility, Caching, Security, Scalability Issues and involved in troubleshooting MicroStrategy reports.
• Possess good knowledge and understanding of SQL and worked on SQL tools such as Toad or Aginity.
• Experience in full software development life cycle SDLC analysis, Design, Development, Configuration, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Self-initiative, well-organized, quick learner, self-motivated, excellent analytical and communication skills and ability to work independently.
• Experience training non-technical users and providing customer support.

Technical Proficiency:

Professional Experience

Confidential

Sr .MicroStrategy Consultant

Responsibilities:

• Gather requirements by interacting with senior managers and users for design of reports.
• Participate in BI team meetings to discuss the user requirements.
• Create logical data models, recognize source tables and columns, and build Schema objects, Application objects necessary for creation of a MicroStrategy project.
• Provide training to BI TEAM to create Report , Document, filter, prompt and Derive metrics on web for their requirement by using attributes and metrics.
• Architected schema objects such as Attributes, Facts and Transformations.
• Generate grid and graph reports by using appropriate Facts, Attributes, Level Metrics, Advance filter.
• Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.
• Design Interactive Dashboards in MicroStrategy Web to assess company's performance and monitor the overall goals of the business.
• Implemented different Schemas Star and Snow Flake to fit reporting, query and business analysis requirements.
• Used and help customize auto prompts filter feature to provide the end-user a choice of different filtering criteria and options during report runtime.
• Create standardized reports Canned reports and Report Services documents for users.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the inner join, outer join, nulls and zeroes
• Used Transformations table based, formula based for comparative reports for Investment Operations.
• Production support, trouble-shooting and fixing of reports was done in record time.

Environment: MicroStrategy 9.2.1m/9.3 Administrator, WEB, Intelligence Server, Desktop, Narrowcast Server , Oracle 9i/10g, SQL 2008.

Confidential

Sr MicroStrategy Consultant

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Involved in normalizing the data from source systems by identifying columns in the table, which came in as fully De-normalized flat file.
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations to analyze customer data and product Inventories.
• Created Transformations table based formula based for using in comparative reports like sales this year to sales last year.
• Created all possible Metrics for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Customized the MicroStrategy web interface and the Intelligence Server settings for the project.
• Extensively worked on creating Complex filters and Compound Metrics for Complex Reports.
• Created Intelligent cubes to reduce the server load and increase the overall efficiency.
• Used object prompts extensively in developing Adhoc reporting.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Involved in data modeling like logical and physical.
• Created Custom Documents, Dashboard applications and Score carding.
• Worked on SQL tools such as Toad or Aginity.
• Developed Reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.

Environment: MicroStrategy 9.2.1m/9.0/9.2/9.1.2 Administrator, WEB, Intelligence Server, Desktop, Narrowcast Server , MicroStrategy SDK, Report Editor, Configuration Wizard, ScanMD, Warehouse Catalog, Project Merge, Object Manager, Attribute Creation Wizard, Fact Creation Wizard, Java, XML, Toad, Informatica, ERWIN, Teradata, SQL Server 2000/2005, BTEQ / BTEQWin, DB2, Oracle 9i/10g, Windows NT/2000/XP.

Confidential

Sr MicroStrategy Developer

Responsibilities:

• Took part in regular meetings with Business Team on and discussed the requirements and design for reports and documents.
• Gathered relevant data and analyzed before creating Schema that fit are in accordance with the reporting requirements, defining fact, dimensions and creating aggregate table for enhanced performance.
• Created Report Service dashboards in DHTML and Flash Mode and applied KPI and graphics wherever necessary.
• Developed and supported Microstrategy Objects applying features like Dimensional Metrics, Transformation Metrics, Conditional Metrics, and Relationship filters, Prompts, managed pass through functions.
• Worked in the desktop and the web environment to create projects and improving performance whenever asked for.
• Worked on SQL tools such as Toad or Aginity.
• Dealt with Intelligent cubes for optimal use database resource.
• Proficient in data modelling techniques and involved in physical data modelling.
• Created and maintained consolidated documents from individual reports giving user a unified view of reports of a common domain.
• Worked on Project connectivity of Microstrategy metadata, database instances, project sources and ensuring connectivity to various servers to retrieve data for reporting purposes.

Environment: MicroStrategy 9.1 Architect, Intelligence server, SDK, Web, Web Universal, Narrowcast server, Desktop , Microstrategy Distribution Service, OLAP, Microstrategy Report Services, Documents, Dashboard, Report Services, Oracle 10G , PL/ SQL , Toad for Oracle version 8.6.1, Informatica Power center 8.1.1, SQL Server 2005, ERWIN, Microsoft Visual SourceSafe 6.0 and Windows Server 2003.

Confidential

MicroStrategy Report Developer

Responsibility:-

• Involved in gathering of business requirements.
• Architected schema objects such as attributes, facts and transformations.
• Created various MicroStrategy objects such as Metrics simple and compound , Filters, Prompts, Custom Groups, Consolidations, etc.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Created custom attribute functionalities using OLAP services.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Micro strategy Intelligent Server Tuning for performance.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Used Narrowcast Sever for timely delivery of report for authorized users.
• Involved in troubleshooting Microstrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Actively participated in developing Report Delivery Schedules.
• Created reports with various object prompts to generate various Ad hoc reports.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Oracle production environment.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: Microstrategy9.0/8.0 Architect, Agent, Object Manager, WEB, Enterprise Manager, Narrowcast , MicroStrategy SDK, Netezza, Oracle, Java, Informatica, ERWIN, TOAD, Windows NT, Windows 2000