SUMMARY

• I have 4+ years experience within MicroStrategy suite 10.1/9x and MSTR Components (Intelligent Server, Administrator, Architect, Desktop, Web, Narrowcast server).
• Extensive experience and knowledge within Data Warehouse includes: Dimensional Modeling, Star, Snowflake, Hybrid Schemas, Data Marts, OLAP, Fact and Dimension Tables.
• Expertise in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Working experience with Tableau, OBIEE and Cognos migrations to MicroStrategy.
• Developed reports related to Market Research & Analysis.
• Have also worked on reports for design & modeling of Supply Chain, Economic Analysis of Industrial Projects, Resource Planning, and Project Cost Estimation.
• Solid experience in gathering data requirements, business rules to build large enterprise warehouses.
• Active participation in design and implementation of physical and logical modeling of Data warehouse and Data marts.
• Extensive working experience with multiple ITSM tools such as Service Now, Manage Now.
• Working experience with UNIX environment to check Intelligence Server specific different logs/processes and restarting the Intelligence servers to debug and rectify the production issues.
• Having extensive working experience with Incident and change management and production initiatives.
• Monitoring and changing the Intelligence server related alert/warning so that we could rectify the issue before it impact production environment.
• Good experience in working with VLDB (Very Large Data Bases) on Oracle 8i/9i/10g, DB2, Teradata, and SQL Server with MicroStrategy Suite.
• Expertise in developing Scorecards & Dynamic Dashboards and good experience in using Report Services.
• Experience in developing Delivery Reports using MicroStrategy Narrowcast Server.
• Good Knowledge in Object Manager, Enterprise Manager, Command Manager.
• Experience in using VLDB properties for performance tuning and also worked with DBA in troubleshooting.
• Good Experience in using SQL query analyzer for validation of report data
• Experience in gathering report requirements, from the business users and translating Business needs into end - user Reports.
• Have worked on Mobile applications (I pad and I phone) and Visual Insights.
• Involved in Software Development Life Cycle (SDLC) process.
• Excellent experience working with various business teams, Supported QA Manager for Preparation of Quality Plans, Review and Approval of Project plan and Project documents, Collection and Compliance of project metrics.
• Ability to adjust to new and challenging situations with experience in handling.

TECHNICAL SKILLS

OLAP Tools: MicroStrategy 10.1/9X/8X (Architect, Desktop, Web, Narrowcast, Object Manager, Enterprise Manager), Tableau 9.0.3, SSRS

ETL Tools: Informatica, SQL Server DTS, Ab Initio

Data Modeling: Erwin 4.0/3.5.2

RDBMS: Oracle 11g/10g, Teradata 13.10, SQL Server.

Languages: SQL, PL/SQL, C, C++, VB Script, HTML, XML and DHTML

GUI: Developer 2000 (Forms, Graphics, Reports), Visual Basic 6.0.

Operating Systems: Windows NT/2000/XP/ME/95/98, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

MicroStrategy Support Lead

Responsibilities:

• Building the reports and customizing the dataset to improve the overall performance for the documents.
• We have full ownership of Confidential Insight MSTR applications so responsible to give approval for CRQs/weekends maintenance after proper impact analysis, and validate and co-ordinate with different teams for proper execution of CRQs.
• We have big infrastructure of Cube (500 cubes) with average size of 30-40 GB, so we are responsible to refresh/load and debugging all cube related issues in UAT and Production.
• Worked a lot for load balancing and cube performance optimization.
• The Project provides the enhanced data from the PEARL application to micro-strategy team for the report generation.
• The data is loaded into Sybase database and used in report generation.
• The key business requirement is to reduce the time in generation of the reports. The report is generated through Sybase database so, some tables loaded from oracle database to Sybase.
• There are also predefined cut off level for each dimensions in hierarchy to generate the report till that level.
• Extensive working experience with multiple ITSM tools such as Service Now, Manage Now.
• Working experience withUNIXenvironment to check Intelligence Server specific different logs/processes and restarting the Intelligence servers to debug and rectify the production issues.
• Having extensive working experience with Incident and change management and production initiatives.
• Monitoring and changing the Intelligence server related alert/warning so that we could rectify the issue before it impact production environment.
• Creating subscriptions/events for different KPIs and alerts.
• Working on existing reports and Dashboards for optimization (query optimization as well as other strategies like VLDB setting change and Intelligence server setting.
• Running Intelligent Cubes by using command prompt.
• Create schedules so as to automate the process of delivering reports and dashboards to their end users.
• Measure effectiveness of automation Report approach and make solid recommendations for increased efficiency in time to run Reports.
• Interacted with Users to get the business needs.
• Worked with offshore and onsite teams to validate the requirements and assure user acceptance, to determine the technical solutions for the applications.

Environment: MicroStrategy 10.2.0 Product Suite (Architect, Desktop, Narrowcast Server, Object Manager, Web) Teradata 13.10, SQL server, Windows XP, Ab Initio, UNIX, HP Quality Center 10.0,Sybase, Autosys.

Confidential, Chicago

MicroStrategy Consultant

Responsibilities:

• Involved in the installation of MicroStrategy suite and later involved in the version up gradations.
• Worked closely with business teams for better understanding of their needs and also the business processes.
• Interacted with Data Architect in building Views and Table structures.
• Created attributes by understanding the complexity of data and created relationships, hierarchies among the attributes.
• Extensively developed MicroStrategy Schema objects and Application objects.
• Designed and developed complex reports to implement Market Basket Analysis.
• Created Intelligent cubes for the better performance of the Dashboards
• Created complex and compound metrics to get the required result as per the business requirements.
• Created complex time filters for the trend graphs to work dynamic with desired time period.
• Extensively created packages to migrated objects from one environment to another by using object manager.
• Implemented the Object prompts to pass attributes dynamically through the dashboards depending on the level of the user.
• Created advanced level metrics, prompts and transformations for the project.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Used apply functions to execute the database specific function in the metrics and filters.
• Involved in Testing and Tuning of reports and dashboards.
• Played a key role in supporting business users and end users to provide solutions on the major functional and data issues.

Environment: MicroStrategy Product Suite 10.1 (Desktop, Architect, Web, Object Manager, Narrowcast Server, Enterprise Manager, Integrity Manager, Command Manager, Mobile), Teradata 13.10, SQL Server 2008, DB2, Ab Initio, UNIX, HP Quality Center 10.0.

Confidential, Atlanta, GA

MicroStrategy Consultant

Responsibilities:

• Involved in the installation of MicroStrategy suite and later involved in the version up gradations.
• Worked closely with business teams for better understanding of their needs and also the business processes.
• Gathered requirements, analyzed, designed, coded and then implemented the solutions for Merchandizing and Store Ops applications.
• Suggested aggregate tables for improving performance of dashboards.
• Architecture and Developed an application with multiple dashboards embedded that supports Single Sign-On through a SharePoint portal.
• Designed and implemented History List and Email subscriptions for the Merchandising application.
• Created attributes by understanding the complexity of data and created relationships, hierarchies among the attributes.
• Extensively developed MicroStrategy Schema objects and Application objects.Created dashboards and related reports for the Enterprise level applications built at Confidential .
• My Numbers application is implemented in more than 2000 stores, with around 30,000 Users.
• Created Intelligent cubes for the better performance of the Dashboards
• Implemented ACL’S for the dashboards to restrict 23 roles within the application to control the dashboards.
• Implemented Adaptive metrics concept for the metrics to control the time transformation inside the metrics which can dynamically run through all the time slices required for the project.
• Created complex and compound metrics to get the required result as per the business requirements.
• Created complex time filters for the trend graphs to work dynamic with desired time period.
• Extensively created packages to migrated objects from one environment to another by using object manager.
• Created Base formulas & Templates as a best practice.
• Implemented the Object prompts to pass attributes dynamically through the dashboards depending on the level of the user.
• Created advanced level metrics, prompts and transformations for the project.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Created links on metrics to open up a new detailed reports when clicked on it.
• Used apply functions to execute the database specific function in the metrics and filters.
• Used sections in the report services documents to create related reports and printer-friendly documents.
• Involved in Testing and Tuning of reports and dashboards.
• Worked with offshore and onsite teams to validate the requirements and assure user acceptance, to determine the technical solutions for the applications.
• Majorly assisted co-team members in finding the solutions for the critical requirements during the code development.
• Trained business users on the major functionality of dashboards and reports.
• Played a key role in supporting business users and end users to provide solutions on the major functional and data issues.

Environment: MicroStrategy Product Suite 9.4.1 (Desktop, Architect, Web, Object Manager, Narrowcast Server, Enterprise Manager, Integrity Manager, Command Manager, Mobile), Teradata 13.10, SQL Server 2008, DB2, Ab Initio, UNIX, HP Quality Center 10.0

Confidential, Plymouth Meeting

MicroStrategy Consultant

Responsibilities:

• Interacted with Users to get the business needs.
• Implemented Star Schema to fit reporting, query and business analysis requirements.
• Supported the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies, Transformations.
• Responsible for creating Metrics, Filters, Custom Groups, Prompts using MicroStrategy Desktop and Web.
• Involved in troubleshooting MicroStrategy prompts, filter, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Optimized Query Performance by using VLDB settings.
• Participated in configuration of Narrowcast Server.
• Developed XSL style sheets to match the corporate standards for reporting.

Environment: MicroStrategy 9.0.1 Product Suite (Architect, Desktop, Narrowcast Server, Object Manager, Web) Teradata, SQL server, Informatica, Windows XP.