SUMMARY

• Over 7 years of experience in MicroStrategy Suite 10.x/9.x/8.x in Development and Deployment of Business Intelligence Projects, Analysis and Administration.
• Extensive experience with MicroStrategy 10.1,10, 9, 9.2, 9.2.1, 8.0, 8.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy OLAP.
• Hands - on development assisting users in creating and modifying worksheets and Data Visualization Dashboards.
• Expertise in Creating Complex Reports inMicrostrategyDesktop using features like templates, custom groups and consolidations.
• Expertise in gathering requirements from business users to build future application as per defined Micro Strategy standards.
• Good experience in schema objects (Facts, Attributes, Hierarchies, and Transformations).
• Expertise in developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates and Searches) developed Reports, Documents and Dashboards.
• Experience in MicroStrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts and also experienced in maintain and modify existing projects, applications and reports as required.
• Experienced in MicroStrategy Report Services, Dynamic Dashboards, Freeform SQL, Query Optimization, Project Schema, and MicroStrategy Server Administration.
• Well versed with Micro Strategy 9 functionality of dynamic dashboard development, Intelligent Cube OLAP Services and in schema object creation via the Graphical Architect using Multi- data source functionality.
• Experienced on IntelligentCubeDevelopment, Custom widget, visualization development and implementation.
• Worked on all phases of the data warehouse development Lifecycle, from gathering requirements to design, development, testing, deployment, and support.
• Expertise in OLTP/OLAP Systems Analysis.
• System Optimization, performance monitoring and tuning experience in Micro Strategy Business Intelligence environment using Micro Strategy Enterprise Manager.
• Expertise in Translating Business needs into end-user reports.

TECHNICAL SKILLS

BI-Tools/Micro Strategy: MicroStrategy 8.x/9.x/10.x (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Administrator, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server), Business Objects.

Databases: Oracle 8i/9i/10g, MS-ACCESS, SQL Server 2005/08, DB2.

Languages: SQL, PL/SQL

Operating Systems: MS-DOS, UNIX, LINUX, WINDOWS 95/98/NT/2000/2008 R2.Windows 7/Vista/XP/2003/2000

Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential - Bloomington, MN

Microstrategy Developer

Responsibilities:

• Maintained optimal performance for BI applications, performance monitoring, capacity planning, and tuning for multiple clients.
• Generated and implemented Microstrategy reports by creating projects, attributes, hierarchies, metrics, filters, and templates
• Developed dashboards for executives for different kind of views.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
• Configured reports for end users in Desktop, Microstrategy Web, and Narrowcast Server.
• Built Narrowcast Server to deliver reports and alerts via multiple delivery methods and publications.
• Configured in troubleshooting Microstrategy prompt, filter, template, consolidation, and custom group objects in an enterprise data warehouse team environment.
• Created documents from multiple datasets to using Report Services. Created and formatted calculations and derived metrics based on the requirement
• Responsibilities included requirements gathering, design, prioritized business goals and information needs.
• Collected information from business users for finalizing system and reporting requirements.
• Extensively worked with MicroStrategy Desktop/Developer. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, Schema Objects and prompts to generated reports meeting the Business Analyst needs.
• Worked on developing complex reports which involved advanced metrics, filters, custom groups and Consolidations
• Created/modified interactive Dynamic Dashboards and Performed installation and configuration of Microstrategy suite, Windows, SQL Server7.
• Involved in taking regular Backups of the Production Metadata in SQL Server Database.
• Managed projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Created stored procedures, views and triggers using Teradata Queryman.
• Worked on fine tuning and restructuring the Data Model to enhance the performance and to address wide range of users.
• Created template reports using advanced prompts like object prompts, expression prompts, filters.
• Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting.
• Designing, implementation, testing and delivery of reports and dynamic dashboards solutions.
• Troubleshooting of issues faced by reporting team.
• Created Test cases as a part of Unit Testing of the generated Reports.

Environment: Microstrategy 10.0x Desktop, Microstrategy Intelligence Server, Narrowcast Server, Report Editor, Configuration Wizard, Warehouse Catalog, Attribute Creation Wizard, Fact Creation Wizard, Teradata V2R4.1, SQL Server 2000, DB2, Oracle 8i, Windows.

Confidential - Dublin, OH

Microstrategy Developer

Responsibilities:

• Join in daily stand up meetings with Project manager, business analyst, ETL team, data moulders, testing team to discuss the user requirements and status updates.
• Worked in a Scrum Agile process with two week iterations delivering documents/report and dashboard at each iteration
• Working closely with ETL team for collecting data and testing team for resolving defects.
• Extensively worked in creating and integrating MicroStrategy reports and Objects (Attributes, Facts, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.) using the Microstrategy Desktop and Microstrategy Web interfaces.
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Created Logical Tables/Freeform Reports within Microstrategy for complex reporting situations.
• Created Transactional reports to submit transactions to the database.
• Extensively worked on Report Services to create Performance Dashboard reporting.
• Involved in Query optimizations using VLDB properties.
• Troubleshoot and Debugging Reports and Documents for the web users.
• Working with MicroStrategy technical support for any critical issue resolution.

Environment: MicroStrategy 9.3.1 and MicroStrategy Product suite including Microstrategy Desktop, Microstrategy Agent, Microstrategy Web, Microstrategy Intelligence Server, SQL Navigator and Windows.

Confidential, Columbus, IN

MicroStrategy Developer

Responsibilities:

• Participated in all the Business Meetings with the users to give necessary inputs.
• Documented all the baseline projects based on Company Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service and It also helped to resolve the tickets faster and efficient way.
• Created MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Delivered formatted and conditional formatted reports through MicroStrategy Office.
• Worked on creating custom groups and consolidations as per requirements.
• Created Apply Simple and Apply Comparison functions to develop complex metrics and filters.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy to read, interactive documents using the new selectors like radio buttons, check boxes, panels, slider, button bar etc.
• Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked 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.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Tested all the reports by running queries against the warehouse using SQL Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes.
• Created Transformations (table based, formula based) this week vs. last week analysis reporting.
• Drilling options (Drill up down across) were used to generate ad-hoc reports.
• Created design and technical specification documents for realizing MicroStrategy objects to be integrated in the report.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidations and custom group objects in an enterprise data warehouse team environment.
• Created Dashboard and Scorecards using Report Services Documents.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Worked in customization of Micro Strategy Web.
• Designed Custom drill maps using drill map editor as per the requirements for drill through functionality.
• Worked effectively with ETL team to assist them in data validation.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Involved in Managing migration of Microstrategy projects and objects from Development to Testing and to production environment.
• Optimized reports to improve the performance.
• Worked in Installation and configuration of Micro Strategy 9.0.1.
• Worked in Upgrading of version 8.1.2 to 9.0.1
• Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.

Environment: Microstrategy 9.4.1 (Desktop, Architect, Web, Narrowcast Server, Enterprise Manager, Object Manager), Oracle 9.1, Oracle 10g, SQL, Informatica Power center, Quality Center

Confidential, Wilmington DE

Microstrategy Developer

Responsibilities:

• Created advanced qualification Filters, custom groups, prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to the business needs.
• Used advanced prompts, conditional, Transformation metrics and Level metrics for creating complex reports.
• Implemented drill functionality on the reports using Drill Maps.
• Created dynamic dashboards to improve marketing by product, customer, geographical and promotion analysis.
• Developed reports enabling Data Drilling across multiple dimensions using Microstrategy Desktop.
• Worked extensively on developing Metrics and compound Metrics, complex metrics, Filters, custom groups, Templates, Consolidations and OLAP Reports using Microstrategy 9.0.
• Developed Schema objects like Facts, Attributes, Hierarchies and assigned relationship like one to one, one to many and many to many between different attributes.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis.
• Created Transformations like YTD (year to date), MTD (month to date), WTD (week to date) analysis.
• Created Advanced Reports in grid mode and graph mode using Microstrategy Desktop.
• Created Base formulas, Deals and Allowances used the same along with the Metrics.
• Involved in taking regular Backups of the Production Metadata in SQL Server Database.
• Involved in Functional Testing and Tuning of the Microstrategy Reports.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Created Customized Hierarchy for Drill Maps, & Created report formats and delivering personalized messages from the data warehouse through Micro Strategy Narrowcast server to a wide range of users.
• Used Report cache sharing and Data mart reports to enhance the Report response time.
• Involved in Query optimizations using VLDB properties
• Worked on Informatica as to extract data from source systems to target system. And also tuning the maps for improving load timings.
• Used Informatica 6.0 as an ETL tool to extract data from source systems to Target system. Have good experience in Repositories, like maintaining versions of repositories, managing users and upgrading repositories

Environment: Microstrategy 8.1.1 (Desktop, Administrator, Intelligence Server, Web, SDK), Microstrategy Agent, Microstrategy Object Manager, Teradata, SQL Server, Informatica 6.0/8.x.

Confidential

MSTR Database Tester

Responsibilities:

• Generated MicroStrategy reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Created complex custom groups using hierarchy to overcome the restriction of MicroStrategy where total on columns and average on rows cannot be calculated at the same time.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in MicroStrategy environment.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: MicroStrategy 8.0, Microstrategy web, Microstrategy Intelligence server, Windows server 2003, SQL Server 2005,