SUMMARY:

• 7 years of IT experience in MicroStrategy Suite (Intelligence Server, Architect, Administrator Developer).
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data Warehouse.
• Experience in report analysis & report services, OLAP services, dynamic dashboards design, development, implementation and testing
• Extensively worked on Report testing, Report tuning.
• Experience on creating Intelligent cubes development and implementation.
• Worked on integrity manager to test the reports.
• Worked with logical models for reporting environment using schema objects (facts, attributes, hierarchies) to interpret data.
• Extensive experience in creating and integrating Microstrategy Reports and Objects like Attributes, Filters, Facts, Prompts, Custom Groups, Consolidations, Transformations, Fact extensions, Hierarchies with the data warehouse to enable clients to assess their services against the data assets to increase profitability and manage risks by reducing the operational costs.
• Defined and created metric filters prompt and consolidation objects in an enterprise data warehouse team environment.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Hands on experience in Report service document creation like Dashboards and scorecards.
• Good experience on web customizations by using SDK
• Used Object Manager to migrate Objects from Development to Testing and to Production environment.
• Worked on upgrading the MicroStrategy project created in MicroStrategy version 9.2.1 to version 9.4.1.
• Very well versed with Data Warehousing concepts.
• Excellent communication skills, analytical, problem solving skills and Self - motivated team player to work individually as well as in a team environment.
• Experienced in developing Test Strategies, Test Plans, Test Procedures, Test Scripts and Test Cases (manual and automated) after reviewing requirement documents, functional specifications, and technical design documents.
• Worked with Test Lead, Business Analyst to verify the Test Cases.
• Excellent skills in overall Defect Management/Problem Solving including tracking bugs, reporting using Test Director/Quality Center.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9.x/8.x (MicroStrategy Desktop, MicroStrategy Web,Object Manager,Integrity Manager,Command Manager

Databases: Oracle 8i/9i/10g, MS Access, MS SQL Server 2000/2005.

Operating Systems: Windows 2003/NT / XP / 2000, Unix/Linux

Office tools: Ms-Word, MS-Excel, MS-Power point

Programming Languages: JavaScipt,Java,XML,HTML

PROFESSIONAL EXPERIENCE:

Confidential, Mclean-VA

Microstrategy Consultant

Responsibilities:

• Worked on full project life cycle.
• End- to-end Deployment\Maintenance of Microstrategy Platform with, Project duplication, Object Manager .
• Expertise in Installing, Configuring of all Microstrategy activities including Microstrategy Desktop, Administrator, Intelligence Server, Web.
• Good exposure to Web architecture and SDK(Web SDK,Visualisation SDK)
• Worked on performance tuning of reports
• Administer Microstrategy projects, servers, security, users and object migrations
• Analyzed system requirements and developed detailed test plan for unit, integration, and System testing.
• Worked on HPALM to create Test cases, track the defects for the Microstrategy Scorecard.
• Involved in preparation of Test Plan based on business and functional specifications
• Involved in managing defects and testing process using Jira
• Involved in testing application which is developed based on agile software methodology.
• Conducted Positive, Negative, Navigational, end-to-end and User Interface Testing.
• Worked on system, integration, regression, and backend testing.
• Monitored Quality Center to close the bugs/cases as and when developers fixed the bugs.
• Involved in weekly team meetings and interacted with developers, analysts and business Clients to discuss the bug fixes.
• Coordination with Test Team members on Testing Activities.
• Created the defects for the objects which are not meet the data validation in HPALM.

Environment: MicroStrategy Desktop 9.3.1, MicroStrategy Developer, MicroStrategy Web, Object Manager, Sql Server.

Confidential, Concord- CA

Microstrategy Consultant

Responsibilities:

• Involved in gathering business requirements from end users and translate them into Report specifications.
• Involved in creation schema objects(facts, attributes, hierarchies, transformations) and application objects(filters, prompts, metrics, custom groups, consolidations, Reports)
• Employed various schema modeling techniques like compound attributes, heterogeneous mapping and role attributes.
• Extensively worked on dynamic Dashboards using selectors, panels, panel stacks, Widgets in flash mode.
• Used various widgets like data cloud, funnel, Heat map and Gauge for creating effective dashboards.
• Created seven layers dynamic dashboard which provided all levels of hierarchy data.
• Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode).
• Created drill down dashboard to navigate the users from one dashboard to another.
• Extensive experience in creating Reports, Documents, Dashboards and Visual Insights using MicroStrategy Web and also deployed them to MicroStrategy Mobile.
• Created the Intelligent cubes and shared to reduce the database load and to improve the report performance by using cube services.
• Extensively used Filters, Prompts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis.
• Provided reports for end users to create ad-hoc report by drilling up, down, within and across dimension or to pre-define templates. Involved in the data analysis.
• Successfully created Physical Schema, Indices including unique, secondary, join upon determining which is best in terms of performances.
• Created advanced prompts and conditional, transformation metrics to achieve the complex reporting needs.
• Used pass through functions (Apply comparison, Apply simple) in the attribute and filter definitions.
• Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Creating & scheduling reports to multiple users via Distribution Services & Data Driven E-mail Alerts.
• Tuned the reports by taking advantages of VLDB properties and complex report filters.
• Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
• Worked on upgraded version which is 9.4.

Environment: MicroStrategy Desktop 9.4/9.3.1, MicroStrategy Architect, Object Manager, Visual Insights, Teradata.

Confidential, Austin-TX

Microstrategy Developer

Responsibilities:

• Involved in the meetings with business users and data modelers to discuss and finalize the requirements.
• Established an Enterprise Data Warehouse and MicroStrategy Implementation to analyze Clickstream data for Leads Collection of revenue from Marketing Campaigns,Smartclicks, Sales & Revenue details over various modes of sales (digital downloads, Package sales).
• Interacted with Business users, data modeler to get required information for report design processes and implemented optimization techniques to enhance performance of the microstrategy platform
• Created and maintained attributes, metrics, filters, prompts and reports. Performed technical problem solving and troubleshooting. Coordinated and deployed Microstrategy report changes to the Production environment
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations to analyze customer data and product inventories.
• Created security filters, Complex reports (Indicator, Set analysis, What-if analysis, Data-mining reports).
• Used to develop complex Filters and Transformations.
• Experience with MicroStrategy report services in developing ad-hoc reports using advanced filters, Level metrics, advanced subtotals, Value prompts, Derived metrics, Custom groups and Consolidations.
• Involved in setting of VLDB properties at report and Metric Levels to define outer joins between tables to get complete data from the required table and used different Query Optimization settings specific to database to improve performance of Query.
• Created Intelligent Cubes and generated reports out of them for high performance & less query time and thus making use of In-memory BI with the help of MicroStrategy OLAP services.
• Used Object Manager to migrate objects from development to testing and to production environment.
• Distributed personalized information to each user by creating Subscriptions with the help of MicroStrategy Distribution Services
• Performed report testing and data quality using Teradata SQL Assistant.
• Supported business users with MicroStrategy Technical issues.

Environment: MicroStrategy 9/8.1.2, Architect, Desktop Reports, Web Intelligence Reports, Report Services, Administration, Dashboards, Enterprise Manager, Object Manager, Toad, Teradata.

Confidential, Chicago-IL

MicroStrategy Developer

Responsibilities:

• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Actively participated in developing Report Delivery Schedules .Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Taken various measures for performance enhancement like aggregation techniques, OLAP Feature, Data mart and report caching.
• Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Grouping and Filtering.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Employed MicroStrategy Desktop in designing 3-tier and 4-tier MicroStrategy projects.
• Optimized query performance by updating VLDB properties and by modifying cache behavior.
• Customized reports using Custom Groups and Consolidations.
• Creating Intelligence Cubes and publishing them for better performance
• Extensive knowledge in creating Dynamic Enterprise Dashboards using different controls, attribute selectors, metric selectors, panel selectors, sliders, widgets and utilized the new features to convert the Dashboards into Flash mode, and also incorporated Dashboards with linking (Hyper links, edit links), drilling capabilities, filtering, slicing.

Environment: MicroStrategy tool suit 8x/9x, Windows 2000/2003, Teradata, SQL Server.

Confidential

MicroStrategy Analyst

Responsibilities:

• Worked as a MicroStrategy Developer in a team of three for design and development of the MicroStrategy reports.
• Gained good understanding of the logical data model.
• Collaborated with business partners to define requirements and reporting specifications and provide technical report assistance.
• Involved in dimensional data modeling (Star Schema), Business and Data Analysis.
• Validated reporting results against requirements. Troubleshoot and analyze data issues within reports.
• Worked with the ETL team and business operational teams to understand data sources and implement new requirements.
• Created schema objects (Attributes, Facts, Hierarchies, and Transformations) from Warehouse catalogue and public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Drill Maps) on top of schema objects.
• Expertise in using Apply Simple and Apply Comparison Operators in advanced qualification filters.
• Created ad-hoc reports by drilling up, down and across hierarchies
• Involved in creation of aggregate tables to improve performance of reports.
• Involved in moving the objects between two projects and two different environments by using Object Manager and Update Packages.

Environment: MicroStrategy Desktop 8x MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata, Oracle 9i, Windows 2000/NT and UNIX.