Sr. MicroStrategy Consultant

Professional Summary

• Over 7 years of IT Experience with well acquainted in performing as MicroStrategy Developer, Architect and Administrator using MicroStrategy tool Suite with Strong Domain Knowledge of Financial Bank and Insurance , Communication and Restaurants industry.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, Micro strategy Web, Micro Strategy Narrowcast Server and OLAP Services Environment.
• Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups .
• Experience in Micro strategy Architect, Office, Narrowcast, User security management, Object Manager designing reports grid, drilldown, ad hoc, OLAP cube and dashboards in Micro strategy 8x/9x.
• In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Security and deployment, FACT and Dimensional tables, Logical and Physical data modelling.
• Experience in Microstrategy schema application layer, report analysis report services dynamic dashboards design, development, implementation, migration and testing.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Experience in data extraction and transformation ETL using Informatica Power Center, exposure to Clients interaction, user- requirement analysis and user support.
• Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i, DB2, TERADATA V2R6.0, SQL Server 2003/2008.
• Involved with the Full Life Cycle Development of project using Object Manager, Integrity Manager and Command Manager.
• Performance monitoring, System optimization and Tuning experience in Multiple BI applications. Proficient in setting up the Metadata Repository, Configuring the Intelligence Server, creating user groups, security filters, roles and privileges.
• Worked along with MicroStrategy Knowledge Base to troubleshoot complex Report related issues.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills

Project Details

Confidential

MicroStrategy Architect /Developer

Responsibilities

• Involved in gathering business requirements and documenting specifications.
• Responsible for all MicroStrategy Architecture/Development.
• Modified Existing version of MicroStrategy objects in order to meet the requirements.
• Verified the logical schema for existing dimensions, worked with ETL Team for new tables, columns.
• Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes.
• Worked on learning zone reporting project which involves key metrics such as Percentage certified, trained in conjunction with various business attributes in the organisation.
• Architected and Developed composite solutions involving restaurant RGM's and Above Restaurant leaders ARL's users access reports that retrieve the restaurants based on the user security.
• Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
• For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
• Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
• Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
• Created security filters and other report objects, drilling, defined hierarchies.
• 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.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
• Tested all the reports by running queries against the warehouse using Nexus Query tool. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
• Created documents using panels, panel stacks, sections, grids, graphs and widgets.
• Tuned the reports by taking advantages of VLDB properties and complex report filters.
• Worked with DBA's in identifying the long running queries of daily reports data and enhanced the performance by indexing, data distribution, and monitoring other activity on box.
• Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
• Collaborating with business partners to provide technical report assistance.
• Provided end user training for the MicroStrategy Web users.
• Has a significant role in managing the time estimates and coordination with different teams in the project.

Environment: MicroStrategy Desktop 9.4/9.3.1, MicroStrategy Architect, Object Manager, Visual Insights, Nexus Query Tool, Netezza.

Confidential

Sr. MicroStrategy Developer

Responsibilities

• Involved in collecting the business requirements and documenting the specifications.
• Work with Business Analysts to develop analytical approaches that meet business requirements.
• This involves translating requests into database queries, analyzing data, and transforming results into actionable reports
• Design and develop complex reports and dashboards using MicroStrategy Desktop and Web.
• Created advanced reports, consisting of data analysis by combining a template with filters.
• Ability to analyze data, and develop meaningful custom reports.
• Develop Standard as well as Ad-Hoc Reports Visual Insights Analysis using MicroStrategy BI platform.
• Responsible for building cubes and drill through in reports/dashboards.
• Developed attribute filter prompts to give end users a choice of different filtering criteria each time they run the report.
• Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
• Created complex dashboards using panels, panel stacks, grids, graphs and widgets.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties and working with DBA's.
• Validating report results against requirements for consistency and accuracy.
• Worked on Visual Crossing software to present the Geographical map with zip layer on the dashboards using filters, labels and legend etc.
• Presented some key metrics as Heat maps visualization.
• Worked on Teradata SQL assistant to understand the data related issues.
• Worked on HP QA tool to track and update the defects related to MicroStrategy BI platform.
• Troubleshooting and analyzing data issues within reports.
• Collaborating with business partners to provide technical report assistance.
• Enhance current custom reporting platform and present best practices across team.
• Played an important role in coordination with the entire team and managing the time estimates.
• Support production BI infrastructure in a high availability business critical environment.

Environment: MicroStrategy Desktop 9.2.1/9.3.1, MicroStrategy Web, MicroStrategy Office Visual Crossing, Visual Insights, Agile, Teradata SQL Assistant 12.0, HP QA.

Confidential

Sr. MicroStrategy Administrator/Developer

Responsibilities

• Involved in collecting the business requirements and documenting the specifications.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop.
• 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 complex filters with advanced qualification involving 'ApplySimple' and 'ApplyComparison' functions.
• Created several base formulas mathematical expressions using existing facts in MicroStrategy that can be re-used to build any number of metrics.
• Involved in data validation, analysis, testing and debugging.
• Developed Attribute filter prompts to give end users a choice of different filtering criteria each time they run the report.
• Worked extensively on creating and making use Application Objects like Metrics and Compound metrics, Custom Groups and Consolidations for complex reports.
• Performance Optimization was done to existing reports and report response time was brought down remarkably.
• Designed and developed Intelligent cubes for maintaining stable environment.
• Designed and developed Dashboards for interactive analyses using widgets and selectors.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties query and sub query optimizations for SQL server and SQL hints.
• Worked on SAP Business Objects reports through Info View and Webi.
• Designed SSIS Packages using several transformations to perform Data Transformation
• Extracted data from flat files and from RDBS sources like Oracle and SQL Server.
• Created Schema objects using the Business Objects designer.
• Worked on Teradata SQL Assistant to understand the data issues.
• Ran Report queries against Netezza database to compare the report run time and sql run time.
• Worked along with MicroStrategy Knowledge Base to troubleshoot Report related issues
• Involved in Full product life cycle like configuring the intelligence server by providing the server definition.
• Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used Object Manager to move the objects from different environments and also Project Duplication wizard to migrate the projects between different environments.
• Ran different SQL scripts to obtain information of different users and their access levels.
• As per business requirement used different ACL's for different objects.
• Created users, user groups and security roles based upon the business process.
• Used License Manager to check whether number of licenses.
• Continuous monitoring on the alerts like number of Active users, user connections, job runtime, enterprise manager load, CPU utilization and file Size.
• Daily Application verification of set of projects to make sure smooth flow of business process.
• Collecting the list of number of users to analyze the load on DB I took help of Enterprise Manager to create statistic report to optimize the MicroStrategy system and implemented Narrowcast Server to send personalized business intelligence information and reports.
• Analyzed and developed partitioning and indexing strategies for performance tuning of MicroStrategy reports and used intelligent cubes for faster query performance using memory cache.
• Upgraded MicroStrategy Metadata 9.0.0 to 9.0.2 and 9.2.1 of all the environments.

Environment: MicroStrategy Desktop 9.2.1/9.0.2/9.0.0, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy SDK , Teradata SQL Assistant 12.0,SQL Server 2005/2008,SSIS 2005, Toad 10.0.0.41,Oracle 10g ,Netezza 466p6,Solaris 10.

Confidential

Sr. Micro Strategy Architect/Developer

Responsibilities

• Gathered and analysed business requirements from clients and end-users.
• Involved in metadata creation and extensively worked on building relationships
• Developed user-defined BI applications, projects against the business model stored in repository using MicroStrategy Architect.
• Developed schema objects facts, attributes, hierarchies, tables using MicroStrategy Architect.
• Created different prompt filters and used as report filter to select the date ranges.
• Extensively used filters, templates, thresholds to generate reports for business analysis.
• Identified relationships using automatic column recognition in MicroStrategy Architect 9.x.
• Configured Very Large Database VLDB Properties at different levels report, metric, project and database Instance for optimization.
• Used Microstrategy functions such as ApplySimple and ApplyComparision in metric calculations and developed reports in Microsoft Excel including pivoting tables.
• Extensively used Distribution Services of MicroStrategy 9 to deliver documents and dashboards to End users.
• Developed an extensive collection of interactive Dynamic Dashboards widgets, selectors using MicroStrategy Report Services and OLAP modelling for distribution to executives and field sales teams.
• Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Used Multi Source Drill anywhere feature of MicroStrategy 9 for adhoc users.
• Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel and PDF spreadsheets.
• To increase performance used intermediate tables and preferable sub query type for oracle database in VLDB settings.
• Explained the whole design of ETL Process using Visio tool.
• I took help of Enterprise Manager to create statistic report to optimize the MicroStrategy system and implemented Narrowcast Server to send personalized business intelligence information and reports.
• Analyzed and developed partitioning and indexing strategies for performance tuning of MicroStrategy reports and used intelligent cubes for faster query performance using memory cache.
• Used TOAD to analyse the data and variation of different tables to enhance the performance of MicroStrategy.

Environment: MicroStrategy Desktop 9.0.1, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy SDK, Dashboards, Oracle 9.2.,TOAD 8.5,Windows XP.

Confidential

Sr. MicroStrategy Consultant

Responsibilities:

• Involved in Full product life cycle like configuring the intelligence server by providing the server definition.
• Setup the project sources, creating projects, duplicating projects, moving projects, deploying projects, mapping the warehouse catalog, creating metadata tables and statistics tables, creating necessary MicroStrategy objects.
• Designed, developed and architected a MicroStrategy project that accesses prescriber, hospital and sales representative information and generates reports for the sales operations department..
• Involved in collecting the business requirements and documenting the specifications.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Created complex filters with advanced qualification involving 'ApplySimple' and 'ApplyComparison' functions.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Gathered requirements from the users and defined KPI's to build scorecards and dashboards.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Created advanced grid reports, consisting of data analysis by combining a template with filters.
• Worked as a support resource for other related projects and was responsible for re-architecting required changes and checking the report results in QA.
• Involved in project migration application of contents like users, groups and reports using duplicating wizard.
• Tested all the reports by running queries against the warehouse using Sql Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Worked with Narrowcast configuration and involved in administration issues.
• Responsible documentation and configuration of Enterprise Manager for logging statistics and advanced reporting purposes.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like join, query and sub query optimizations.
• Upgradation of Microstrategy 8.1 version to Microstrategy 9.0 by keeping a backup of metadata.

Environment: MicroStrategy Desktop 8.1.1/9.0.1, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy SDK, Dashboards, Adobe Flex, SQL Server 2008, Teradata V2R6.0, Erwin 4.5 and Windows 2003.