PROFESSIONAL SUMMARY:

• 6 years of IT experience In MicroStrategy Suite (Intelligence Server, Architect, Developer, Web).
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data Warehouse.
• Expertise in Creating Schema Objects (Facts, Attributes, Hierarchies, Transformations) to Develop User Objects.
• Good experience in creating DSN's for meta data and Data base to connect them through configuration Wizard.
• Experience in report analysis & report services, OLAP services, dynamic dashboards design, development, implementation and testing
• Extensively worked on Report testing, Report tunig.
• Experience on creating Intelligent cubes development and implementation.
• Expertise in designing the Report Services Documents using Grid/Graphs using multiple datasets.
• Expertise in creating interactive Documents and Dashboards by using Selectors, Panel Stacks, Prompts and Linking the Documents .
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• 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)

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

Operating Systems: Windows 2003/NT / XP / 2000

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

WORK 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 and Project Merge Utilities.
• Involved in Requirements gathering by interacting with the Internet Business Users.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Expertise in Installing, Configuring of all Microstrategy activities including Microstrategy Desktop, Administrator, Intelligence Server, Web and Microstrategy Narrowcast Server
• Administer Microstrategy projects, servers, security, users and object migrations
• Analyzed system requirements and developed detailed test plan for unit, integration, and System testing. For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Design, develop, test and implement Microstrategy reports, report objects, dashboards and documents.
• Created Schema and Public objects, Complex Filters, Compound Metrics and Prompts.
• Identify and create public objects Metrics, Prompts, Filters, Drill maps, Custom Groups, Consolidations, Templates, Reports and Security Filters.
• 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 creation of test data using UNIX shell scripts and SQL
• 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 Onsite and Offshore 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 Architect, 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.