SUMMARY:

• MicroStrategy Developer with 8 years of experience in building projects and creating reports and dashboards using MicroStrategy 10.x/9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, Distribution services and OLAP services.
• Experience using MicroStrategy Business intelligence Suite 10.x/9.x/8.x ( Intelligence Server, Administrator, Architect, Desktop, Web, Visual Insight, OLAP Services, Report Services, Dashboard, Distribution Services, Mobile, Narrowcast Server, MicroStrategy Office, Object Manager, Enterprise Manager, Command Manager and Integrity Manager).
• Experience working with End Users in understanding their requirements and translating their needs into Reports.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects.
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill through the data.
• Worked on MicroStrategy SDK.
• Worked on MicroStrategy SDK modules like Web SDK, Mobile SDK, Narrow Cast Server SDK,
• Intelligence Server SDK etc.
• Experience in MicroStrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation.
• Extensive work on creating and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, user groups, security filter etc.) using MicroStrategy desktop
• Worked extensively on creating and formatting Dashboards with multi - layout.
• Extensively worked on VLDB properties for performance tuning.
• Extensively worked on Microstrategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Used Administrator tools like object Manager to move the objects from one environment to another environment.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
• Designing Data Mart using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact, Lookup Tables and Dimensional tables, Logical and Physical data modeling.
• Support the MicroStrategy platform by managing the Architecture, Configuration, Administration, and Connectivity while optimizing the MicroStrategy server platforms using governing, caching, scheduling and clustering.
• Strong knowledge in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Involved in installing and configuration of MicroStrategy suite including MicroStrategy Desktop Administrator and Web component.
• Experience in creating time series transformations like YTD, MTD, LY etc. using Transformations.
• Good knowledge in creating Schema objects such as Tables, Facts, Attributes, Hierarchies and Transformations.
• Pro-active involvement in continuous performance improvements for existing OLAP systems
• Expertise in using Administration tools like Job Monitor, User Manager, Cache Manager, Object Manager, Schedule manager.
• Worked on Data Warehousing and RDBMS concepts.
• Expertise in Defining MicroStrategy Narrow Cast Server objects like Service, Schedule, Subscription set and Information Objects.
• Extensive experience in creating MicroStrategy Reports and Application Objects such as Template, Filters, Metrics, Prompts, Custom Groups and Consolidations.
• Experienced in creating Advanced Metrics, Advanced Prompts and Advanced Filters in MicroStrategy Reports development.
• Good knowledge of MicroStrategy Web and Web Administration.
• Experience in Creating Visual insight dashboards in MicroStrategy Web.
• Have Good understanding of Intelligence cube (i-cube), custom group and consolidation in MicroStrategy.
• Expertise in creating Intelligent Cubes which is optimized for reducing total Database Time, Job Load.
• Expertise in creating interactive Dashboard, Scorecards and Documents based on user requirements.
• Worked on customizing and optimizing the query performance of report using VLDB properties.
• Familiar with Data Management Systems such as SQL, Oracle, Netezza and Teradata.
• Strong working knowledge of SQL, PL-SQL ability to understand and write complex SQL queries.
• Expert in Database development skills using SQL, PL/SQL, Stored Procedures, Stored functions.
• Well-Organized, Energetic, Quick learner, Team Player. Ability to adjust to new and challenging situations.
• Good Understanding of ETL technologies like Informatica and Data stage.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS:

MicroStrategy products: MicroStrategy Desktop 10.x/9.x/8.x/7.x (Administrator, Architect, Desktop, Enterprise Manager), MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server

ETL Tools: Data Stage, SSIS, Informatica

Data Modeling Tools: Erwin, MS Visio, MS Project,Toad.

Operating Systems: Windows XP/ 2008/2003/2000

Databases: MS SQL Server 2012/2008 R2, Teradata, and MS Access.

PROFESSIONAL EXPERIENCE:

MicroStrategy Developer

Confidential, Phoenix, Arizona

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing,
• Documenting Business Requirements, Functional Requirements and Data Specifications.
• Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Microstrategy objects necessary for the deliverable.
• Created transformational metrics (Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Hands on experience in using MicroStrategy SDK.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Creating Dash Board Reports to view personalized reports based on user requirements.
• Created different kind of Dashboards like traditional performance summery, traditional metric, dynamic content in both the interactive & flash mode.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in the creation of three types of reports like Map Application Reports, Reference reports and Ad hoc Reports.
• Involved in creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Involved in optimization of code and tuning queries for performance.
• Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists.
• Defining Access Control Lists (ACLs) to restrict users to access various environments based on their roles.
• Deploying new projects in the dev/test/stage and production environment.
• Defining the MicroStrategy Mobile configuration to allow mobile devices to run MicroStrategy reports.
• Regularly running license checks to make sure that all environments are in compliance.
• Managing Clustered I-Servers environment.
• Working with MicroStrategy technical support for any critical issue resolution.
• Arranging meetings to discuss the agenda of the each task assignment and its impact over the release.
• Involved in creating Security filters to end users to access data Based on their privileges.
• Responsible for keeping team members on track toward completing the terms of goals.
• Provided post production support to end-users.
• Performed a complete Production Support for the end users using MicroStrategy Web & also MicroStrategy Desktop

Environment: MicroStrategy 8.1/9.0.2 (Desktop, Administrator, Web), MicroStrategy Intelligence Server 8.0/8.1,MicroStrategy Narrowcast Server, Teradata V12, Windows XP/2000.

MicroStrategy Developer/Administrator

Confidential, Charlotte, NC

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Extensive Knowledge in Server Upgradation, Configuration, Implementing, Installation, Maintaining Controls and security policies on MicroStrategy.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Administered MicroStrategy environments and formulated user groups.
• Installation of Microstrategy Desktop and creating a Microstrategy project.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Have hands on experience on SDK.
• Experience in Upgrading MSTR 9.4.1 to MSTR 10.1.
• Coordinated with DBA team to resolve buffer pool issues in Microstrategy.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• 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.
• Implemented Intelligent Cube to decrease the Load on server while users watched reports simultaneously.
• Created number of Normalized database tables with different constraints to maintain Integrity. Triggers were implemented on the tables to maintain validity check on the data.
• Worked on different aggregate functions and scalar functions.
• Actively participated in developing Entity-Relationship (ER) Diagrams, and Data Dictionaries, by gathering information from the Business Users and detailed analysis of the data.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Experience in Creating Visual insight dashboards in MicroStrategy Web.
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Maintain standardized Microstrategy design, development, testing and deployment task documentation
• Incorporated user-friendly functionalities like pop-ups, list boxes and other object oriented events into the system.
• Used several Widgets for Dashboard reporting.
• Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, widgets in flash mode.
• Created Drill down dashboards which will allow users to navigate from one dashboard to another
• Unit Testing has been conducted to achieve desired results.
• 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), Subscription feature to improve the performance and mobility of the group
• Used free form SQL editor for complex report creation.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Implemented Event and Time Based Schedules. Worked as a Unix Administrator to monitor jobs that would trigger based on certain conditions and fire Event Schedule to kick off reports.

Environment: MicroStrategy Desktop 10.x/9.x, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server 2003

Senior MicroStrategy Developer/Administrator

Confidential, Peoria, IL

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing,
• Documenting Business Requirements, Functional Requirements and Data Specifications.
• Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Microstrategy objects necessary for the deliverable.
• Created transformational metrics (Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Had worked on MicroStrategy SDK.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Creating Dash Board Reports to view personalized reports based on user requirements.
• Created different kind of Dashboards like traditional performance summery, traditional metric, dynamic content in both the interactive & flash mode.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in the creation of three types of reports like Map Application Reports, Reference reports and Ad hoc Reports.
• Involved in creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Involved in optimization of code and tuning queries for performance.
• Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists.
• Defining Access Control Lists (ACLs) to restrict users to access various environments based on their roles.
• Deploying new projects in the dev/test/stage and production environment.
• Defining the MicroStrategy Mobile configuration to allow mobile devices to run MicroStrategy reports.
• Regularly running license checks to make sure that all environments are in compliance.
• Managing Clustered I-Servers environment.
• Working with MicroStrategy technical support for any critical issue resolution.
• Arranging meetings to discuss the agenda of the each task assignment and its impact over the release.
• Involved in creating Security filters to end users to access data Based on their privileges.
• Responsible for keeping team members on track toward completing the terms of goals.
• Provided post production support to end-users.
• Hands-on experience in using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, Pmon/View Point, Data mover).
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the BTEQ scripts.
• Hands-on experience in Teradata Performance tuning using Explain, Statistics collections, Skew factor analysis and Row Distribution.
• Performed a complete Production Support for the end users using MicroStrategy Web & also MicroStrategy Desktop

Environment: MicroStrategy 8.1/9.0.2 (Desktop, Administrator, Web), MicroStrategy Intelligence Server 8.0/8.1,MicroStrategy Narrowcast Server, Teradata V12, Windows XP/2000.

MicroStrategy Developer/Administrator

Confidential, Irvine, CA

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates for the project.
• Designed Components, Templates, 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.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Consolidations Custom Groups and Prompts for the reports.
• Created Dashboards and Scorecards to provide users the convenience of doing data analysis in a better way.
• Drilling options (Drill up down across) were used to generate adhoc reports.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Validated end user report requests using SQL and MicroStrategy tools.
• Created narrowcast services to email /send report service documents to a directory in PDF or excel formats.
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy like indexing temp tables, etc. Worked on Explain Plan to reduce cost of the SQL.
• Ran ScanMD a lot of times to make the projects errors free. Also some times did copy metadata to a testing server to validate with temporary test data.
• Assisted the DBA's and the ETL architects to design and create Tables in the Oracle database to achieve the business requirements.
• Developed and implemented Security Roles User Groups and Privileges and Object Security for the developers and End users.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc
• Flat files are loaded into databases using FastLoad and then used in the queries to do joins.
• Worked on exporting data to flat files using Teradata Fast Export.
• Working with Teradata DBAs on automated scripts for stats collections on tables, indexes and

  Columns.

• Implemented Event and Time Based Schedules. Worked as a Unix Administrator to monitor jobs that would trigger based on certain conditions and fire Event Schedule to kick off reports.
• Created reports in Enterprise manager for stats analysis on concurrency of the user reports.
• Developed Excel Macros to automate formatting after exporting Reports to Microsoft Excel.
• Performing QA and production migrations of MicroStrategy objects using Object Manager.

Environment: MicroStrategy 9.2.1 Product Suite (Architect, Desktop, Web, Narrowcast Server, Object Manager, Enterprise Manager), Windows 7

MicroStrategy Developer

Confidential, North Wales, PA

Responsibilities:

• Developing MicroStrategy Schema/Public objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator,
• Set analysis, What-if analysis, Data-mining, Data mart reports, etc).
• Created very complex reports eg: Market-Basket Analysis involving interactive web and windows interface.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts,
• Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting.
• Create Dashboards and Documents using Flex, Flash and Widgets.
• Configure reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Used MicroStrategy Office to connect Microsoft Excel, through MicroStrategy Intelligence Server.
• Installing, Version Upgrade, Configuring of MicroStrategy Products Renewing the License Key and activation of the Servers, Warehouse and Metadata on Unix Box.
• Performing Object Migration of almost 200 Objects In a week among Development, QA, Staging and Production.
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting.
• Configure reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Extensively created and used Custom groups and Consolidations.
• Used MicroStrategy Office to connect Microsoft Excel, through MicroStrategy Intelligence Server.
• Documented and reviewed design documents with the team.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Validated end user report requests using SQL and MicroStrategy tools.
• Responsible for Setting up the Web Server and I servers and deployed the Customized UI code
• Keep the license in compliance in all the environments.
• Worked as an MSTR support administrator which includes setting up the new users, resolving small work request related to Application Support.
• Strong working knowledge of SQL, PL-SQL ability to understand and write complex SQL queries.
• Expert in Database development skills using SQL, PL/SQL, Stored Procedures, Stored functions.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• Have used several Widgets for Dashboard reporting.
• Heavily worked on testing and validating the data and also involved in optimizing SQL, troubleshooting reports using VLDB properties.
• Fixed Defects and performed upgrades for existing projects.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Server, Windows XP Professional 2003

MicroStrategy Developer

Confidential, Louisville, KY

Responsibilities:

• Developed most of the Schema Objects such as the Tables, Facts, Attributes, Hierarchies and Transformations.
• Involved in development of the Public Objects such as Filters, Prompts, Metrics, Templates, Drill maps necessary for producing the Client Reports and Scorecards.
• Extensively worked on building all the Scorecards and Dashboards using MicroStrategy Report Services.
• Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.
• 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.
• Highly interacted with the Testing group to make them better understand various operational reports and Business Performance Measurements functionalities.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
• Extracted and analyzed data from the database using SQL to troubleshoot reports as needed.

Environment: MicroStrategy 8.0, Windows 95/NT/2000.

MicroStrategy Developer

Confidential

Responsibilities:

• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, compound Metrics and Prompts.
• Created reports with various object prompts to generate various Ad hoc reports.
• Implemented the user defined MicroStrategy objects like custom groups and consolidations according to the requirement.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop 7.x that can be re-used to build any number of metrics.
• Involved in Testing of reports and Migrated MicroStrategy7i projects from development to acceptance and to production.
• Created reports with various object prompts to generate
• Various Ad hoc reports.

Environment: MicroStrategy 7.x, Windows 95/NT/2000.