SUMMARY

• MicroStrategy Developer with 8 years of experience in building projects and creating reports and dashboards using MicroStrategy 9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, Distribution services and OLAP services.
• Experience using MicroStrategy Business intelligence Suite 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.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Narrowcast Server and OLAP Services Environment.
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill through the data.
• 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.
• 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.
• 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.
• 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, ability to understand and write complex SQL queries.
• Well-Organized, Energetic, Quick learner, Team Player. Ability to adjust to new and challenging situations.
• Intensive experience and exposure to all aspects of MicroStrategy application such as Administration, Architecting and Mostly in Development.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS

MicroStrategy products: MicroStrategy Desktop 9.4.1/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, Toad.

Operating Systems: Windows XP/ 2008/2003/2000

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

PROFESSIONAL EXPERIENCE

MicroStrategy Developer

Confidential, Charlotte, NC

Responsibilities:

• 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.
• 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.
• Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
• 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.
• 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 Desktop 9, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server 2003

Senior MicroStrategy Developer

Confidential, Peoria, IL

Responsibilities:

• Involved in creating complex reports to be used by the various buyers for making critical decisions regarding the inventory at various times and for trend & sales analysis
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Created MicroStrategy Public Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop.
• Created and implemented MicroStrategy reports by creating projects, Custom Groups, Cubes, attributes, hierarchies, metrics, filters, and templates.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• 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.
• Created various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report, consolidation reports.
• Designed custom drill maps using drill map editor as required in the reports for drill through functionality.
• Generated advanced reports in grid, graph consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
• Created various pass through functions like apply simple, apply comparison and also case statements to support various business requirements.
• Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
• Worked on Intelligent Cubes to provide performance for dashboards and reports.
• Extensively worked on creating Report Services documents using multiple Grids and Graphs
• Applied OLAP and statistical functions to calculate metrics
• Designed Schema and public objects using Pass through functions (Apply Simple, Apply Comparison, Apply Avg, etc)
• Created different Transformations to get the last year actual transactions, week-to-day, week-to-period, week-to-quarter, and week-to-year
• Involved in creating user groups and assigning user privileges according to the types of reports that they can generate or view in MicroStrategy Web
• Worked on report services documents to create graphs as per user objective
• Used freeform SQL to create Enterprise Manager Reports & Parametric Data Transfer analysis reports
• Created Drill Maps to obtain aggregated results
• Involved in creation of security filters to end users to access database on their privileges
• Configured Intelligence server to generate pre-generated cache reports and used Narrowcast server to execute and deliver reports via web or email
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties
• 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

Confidential, Irvine, CA

Responsibilities:

• Involved in Requirements gathering by interacting with the Business Users.
• Generated and implemented 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.
• 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 Intelligent Cubes to speed up the process of data retrieval and used Dynamic Sourcing.
• 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.
• Created Report Services Documents out of existing reports and customized them to reflect the Company’s logos and color palette.
• 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.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

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:

• Participated in the end user meetings to obtain the business requirements for creating reports.
• Identified and defined Facts, Attributes, Hierarchies and Relationships.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, hierarchies, metrics, filters, and templates using MicroStrategy Architect.
• Designed the logical data model from the technical design documents and translating to a physical database design optimization and functional testing of the constructed database.
• Created Attributes, Facts, and Hierarchies for the Vendor & Product, Pricing and Basket Analysis projects.
• Created Complex Compound Metrics at different dimensionalities to count the Items sold at different store levels.
• Created Filters to validate the test plan conditions for the reports and per the business requirements.
• Created Custom Groups for the Vendor contact types and Competitive Pricing.
• Developed logical and physical data models for OLAP database applications.
• Gathered the reporting requirements from the Business customers for the Merchandising Vendor, Product, PO, Replenishment, Pricing, Competitive Pricing projects.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Created Templates to maintain a standard interface for the reports.
• Created Attribute-Attribute Prompts, Advanced Filters to obtain the Basket counts and used them along with the metrics at different dimensionalities
• Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Worked on Derived Elements by creating user-defined business (attribute) groups for comparison analysis.
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode. Have used several new controls for Dashboards like time series slider, radio buttons, and drop down menus.
• 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, NYC, NY

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report, design and development.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Created several data marts using MSTR for different tools to access large datasets.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked with the DBA on issues of database performance and security.
• Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project.
• Performed testing of all reports for the final deployment.
• Provided Business user training for the MicroStrategy Desktop/Web.
• Architected schema objects such as MicroStrategy Attributes, Facts, Transformations and Hierarchies.
• Created above store reports to support field coaches and general managers. The reports were highly visual and drillable.
• Aggregate tables were designed to efficiently run reports.
• Worked in on-off shore model to fulfill business requirement and assigning work to off shore
• Performance optimization using VLDB properties, created I - Cubes to improve performance and to reduce the load on database during Peak hours.
• Built numerous dashboards to meet Operational and financial reporting that enabled senior executive to easily visualize overall business
• Created ad-hoc reports and freeform SQL reports depending on user requirement.

Environment: MicroStrategy v9.2.1,MicroStrategy 9.0.1(Architect, Desktop, Report services, Dashboards, Enterprise Manager) Teradata 12.0, Windows XP.

MicroStrategy Developer

Confidential

Responsibilities:

• Architected schema objects such as attributes, facts and transformations.
• 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.