PROFESSIONAL SUMMARY:

• Over 7 years of IT Experience with well acquainted in performing as Microstrategy Administrator/Architect/ Developer, using Microstrategy tool Suite with Strong Domain Knowledge of Telecommunication, Financial Bank and Insurance , Pharma and Healthcare.
• Comprehensive working Knowledge with Microstrategy Desktop, Microstrategy SDK, Microstrategy Web, Microstrategy Narrowcast Server and OLAP Services Environment.
• Extensive Experience in Software Analysis, Design, Development and Production Support of Business Intelligence application using Microstrategy.
• Hands on experience working on creating and integrating Microstrategy Reports and Objects Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups .
• Experience in Microstrategy Office, Narrowcast, User security management, Object Manager designing reports grid, drilldown, ad hoc, OLAP cube and dashboards in Microstrategy 8.0.1/8.1.1 Microstrategy 9.9.1,9.2,9.3,9.4.1.
• Experience in creating MSTR data model for any kind of requirements.
• Experience in upgrading existing reports in older versions of Microstrategy 9 to Microstrategy 9.4.1.
• In-depth understanding of fundamental Data-Warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
• Experience in Microstrategy schema application layer, report analysis report services dynamic dashboards design, development, implementation, migration and testing.
• Experience in Essbase managed object reporting. Complete idea of cube structure and functionality of managed objects in MSTR reports and dashboards.
• Extensively worked on delivering reports and business intelligence solutions on the web using Microstrategy Narrowcast Server.
• Extensive experience in writing oracle SQL and PL-SQL procedures, functions, triggers and packages
• Knowledge in Optimization of Data Migration, ETL Processes.
• Exposure to client interaction, user-requirement analysis and User support.
• Team player with good interpersonal, communication skills and the ability to work in a team environment.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices and problem solving skills.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Microstrategy Consultant

Responsibilities:

• Worked on a project called Economic Data Systems EDS as a Microstrategy Architect and developer.
• Converted the SAP BO reporting into MSTR layer.
• Implemented the whole universe from BO into Microstrategy Schema.
• Developed all the schema objects that include Attributes, Facts, etc.
• After the schema is established, started developing all the public objects such as metrics, reports, filters, prompts.
• Developed a lot of heterogeneous attributes as the data model was more suitable for BO and the same reporting structure had to be implemented in MSTR.
• Developed nested prompts in order to achieve the same prompting functionality in BO.
• Developed dashboards for various regions.
• Also developed separate dashboards for Excel, PDF and linked them to web in order to get the desired print format.
• Worked on performance tuning of the reports to avoid additional runtime.
• Worked with ETL team in order to create views required for MSTR.
• Worked close with Microstrategy admin and checked through all the migrations from Dev to Test, then QA and finally PROD.
• Worked on changing several VLDB settings of the reports.
• Created user guide and also documentation required for PROD team to support the project.

Environment: Microstrategy 9.3.0, MicroStrategy Desktop, MicroStrategy Web, Oracle, Business Objects.

CONFIDENTIAL

Microstrategy Lead

Responsibilities:

• Worked as a MSTR Administrator and upgraded the environment from 9.3.1 to 9.4.1 hf 4.
• Implemented LDAP authentication for MSTR developer and siteminder authentication for MSTR office, web and mobile.
• Developed command manager scripts in order to authenticate all the new users after the upgrade.
• Experience in helping the network and infrastructure team in moving the I-servers across environments. Clustered I-servers in various environments.
• Updated Enterprise Manager Project and stats during the upgrade to 9.4.1 hf4.
• Administered Microstrategy Environments and formulated user groups.
• Worked as MSTR tech lead for one of the projects that involved reporting enhancements.
• Worked through SDLC and completed the migration to QA after the development.
• Built various schema objects like attributes, logical tables, facts.
• Developed various public objects like metrics, reports.
• Worked on VLDB settings that helped in report enhancement in multiple projects.
• Extensively worked on development of various objects like attributes, metrics, custom groups, reports and table aliases.
• Closely worked with ETL to make sure not to have the existing compound metrics in reporting that impacts performance.
• Managed a team of off shores that included developers working on multiple projects.

Environment: Microstrategy 9.4.1, 9.3.1, MicroStrategy Developer, MicroStrategy Web, Microstrategy Intelligence Server, DB2.

CONFIDENTIAL

Microstrategy Consultant

Responsibilities:

• Worked as Business Intelligence architect along with a team of architects involved in dashboard development.
• Created various dashboards in interactive, flash mode for multiple projects collecting requirements from the team.
• Made changes to existing dashboards to meet user requirements and enhanced the performance of these dashboards.
• Built intelligent cubes and scheduled them accordingly for better performance of dashboards that were dependent on these cubes.
• Built dashboards that were visually appealing in flash mode.
• Worked with visual Insight in order to develop dashboards in a faster time and visually appealing.
• Developed requirement documents that were needed for reporting using Microstrategy which included various definitions and granularity level.
• Worked very close with the database team and understood the data which needs to build in reports.
• Worked close with the database team to understand the data warehouse such that it helps during the creation of reports and dashboards.
• Worked on creating Microstrategy data model after gathering all the requirements.
• Worked in executing SQL queries when there were errors in reports and tried to resolve the data gaps.
• Worked close with teams in SQL server integration and efficient with SSIS functionalities.
• Attended few of Tableau training sessions and started to get familiar with the tool during the course of time.
• Developed a couple of reports using Tableau and used the multi visualization feature it provides in report building.
• Involved in Performance tuning of SQL for long running reports
• Built various schema objects like attributes, facts and also developed metrics, filters, prompts used for reports.
• Worked close with Microstrategy admin and checked through all the migrations from Dev to QA and then to PROD.

Environment: Microstrategy 9.4.1, 9.3.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Provider, Tableau desktop, Teradata.

CONFIDENTIAL

MicroStrategy Consultant

Responsibilities:

• Worked as a team lead for a MSTR team of developers and helped them in development of various standalone reports.
• Worked with Essbase experts and extensively with users from different regions of business.
• Created dashboards collecting requirements from various directors of business using managed objects.
• Worked in enhancing the performance of previous dashboards by decreasing the run time, datasets and redundancy.
• Worked in Scrum Environment and conducted meetings with all the other developers and assigned tasks.
• Worked very close with the MSTR admin during migrations to other environments from DEV.
• Hands on experience defining security filters, migration lists needed for administrator and also documented all the migrations.
• Created a single dashboard and made it useful for all six different regions of business with help of a prompt.
• Created derived metrics from existing metrics managed objects and made them useful on the dashboard to decrease run time.
• Worked on MDX cube catalog and made various hierarchical changes depending on the levels in Essbase.
• Worked close with the portal team which was used to run all the developed reports and dashboards for clear understanding of the whole structure of project.
• Created documentation for various migrations and worked very close with MSTR admin to understand migration of all the dashboards and reports.
• Extensively used various filter conditions, attributes, metrics for developing datasets and respectively using them in dashboards.
• Worked with all directors from various regions and prepared several dashboards and enhanced them on a weekly basis upon requirements.
• Solved couple of issues with understanding the MDX of each and every dataset and made sure they met requirements.
• Developed couple of dashboards in Visual Insight to explain the functionalities of VI in Microstrategy.
• Combined a couple of dashboards with help of measures and made sure all the required information is present and as a result decreased the number of datasets and dashboards.
• Involved in customization of MSTR web dashboards.

Environment: Microstrategy 9.3.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Provider, Essbase.

CONFIDENTIAL

Senior MicroStrategy consultant

Responsibilities:

• Worked with business requirements analyst's subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
• Participate in daily status and monthly planning meetings
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Worked on customization of MSTR web with the help of Microstrategy SDK.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting
• Used report services for various banded report to satisfy the printing requirements of the user.
• Provide production support of MicroStrategy reporting application.
• Create users in MicroStrategy and grant required access for projects.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Complete understanding of data warehouse concepts as worked close with the requirements and database teams.
• Configuration of Narrowcast server and Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
• Prepared technical project related documentation.

Environment: Microstrategy 9.3/9.2/9.1, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Provider, Oracle 10g and UNIX

CONFIDENTIAL

Microstrategy Developer

Responsibilities:

• Extensively involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Designed Interactive Dashboards in Micro strategy Web to assess company's performance and monitored the overall goals of the business.
• Maintain and track market basket log, Utilize and analyze information from log to provide statistics that will assist in taking the department to the next level.
• Create/prepare monthly summary reports on market basket activity, highlighting product gaps.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Micro Strategy Desktop and Micro Strategy web.
• Created Facts, Attributes and Hierarchies using the Micro Strategy Architect.
• Developed various Metrics, filters, consolidations, custom groups and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Defined all objects after complete designing of data warehouse and understanding the various requirements.
• Involved in customization of Micro Strategy Web Dashboards.
• Involved 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.
• Involved in creating various transformations to analyze different metric values in this year to last year using Micro Strategy Architect.
• Extensively worked on Documents by adding additional functionalities using XSL sheets to create more personalized documents with images, hyperlinks and other report objects.
• Involved in performing various analysis using the Micro Strategy Desktop.
• Involved in implementing optimization techniques to enhance the performance of queries dynamically generated by Micro Strategy by interacting with DBA's and designers.
• Used Narrowcast server for content Management, Self Subscription, Profile Management, Proactive information Delivery and alerting and to personalize the reports and information.
• Involved in configuring the Intelligence Server and pointing the database instances in both development and production environments.
• Worked with Administrator in installation process of the Micro Strategy Tool Suite.
• Designed mappings and the logic to migrate data from Legacy source system to the target Database.
• Worked with Informatica tool suit for data Extraction, Transformation and Loading into the warehouse database from Oracle databases.

Environment: MicroStrategy 9, MicroStrategy Desktop 9.x, MicroStrategy Web 9.x, MicroStrategy Intelligence Server 9.x, Informatica Power Center 8.1, Teradata, Windows XP Professional

CONFIDENTIAL

MicroStrategy consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities, Project Setup Installing, configuring, managing and controlling and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling lock, limit and filter out the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop8.1, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

CONFIDENTIAL

Microstrategy Developer

• CONFIDENTIAL is an CONFIDENTIAL , providing a range of traditional and consumer care insurance products and related services. The project involved in making reports on issued health insurance by year, departments, and regarding their policies.
• Responsibilities:
• Extensively created filters, facts, Consolidations, Transformations and Custom Groups using MicroStrategy Desktop to generate reports for the Business analysis.
• Used pass-through functions applysimple and applycomp in attributes and filters definitions.
• Involved in creating MicroStrategy objects like Metrics Conditional, Transformational, Dimensional, and Compound , Filters, Prompts Filter, Object , Templates and Reports.
• Created ad-hoc reports by drilling up, down, within and across dimensions.
• Created Metrics, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy for report development.
• Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
• Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.
• Worked in writing SQL Queries Sub queries and Join conditions, correlated sub queries
• Involved in back end development of Oracle PL/SQL objects for report creation.

Environment: MicroStrategy 8.1 Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter Oracle, SQL Server, Informatica, IBM DB2, ASP, XSL, HTML