SUMMARY:

• 8+ years of Microstrategy environment experience on both Development and Administration.
• Proficient experience using MicroStrategy v9.x/8.x product suite and Tableau 8.x and 7.x.
• Have a strong knowledge in understanding overall work flow of the Microstrategy Environment on Operating systems Solaris 10, Linux 6.x and Windows 2008 & 2012 versions.
• Uplifted and migrated Microstrategy 9.2.1 to 9.4.1 from Solaris 10 to Windows 2012 server along with implementing cluster nodes setup to scale out the environment and implemented windows authentication replacing LDAP auth.
• Good experience in installing Microstrategy 9.x, 8.x software & Hotfix, Installing drivers, Creating DSN’s, Configuring Databases on both Windows and Unix Environments.
• Created schedules (Time based and Event based), Events, Subscriptions, Project Duplications based on the requirements from application teams.
• Expertise in working on Command Manager, Integrity Manager, Object Manager, Enterprise Manage, Scan MD, MD Doctor and License Manager tools.
• Worked with Database teams on upgrading the Metadata and Database versions.
• Expertise on working with Distribution Services And worked on Narrowcast Server managed Subscriptions as well.
• Extensive experience in designing, creating and modifying different Reports.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, etc.) from data warehouses including Teradata, Sybase and SQL Server.
• Strong experience in designing and developing MicroStrategy Reports, Schema Objects, Application Objects, Configuration objects.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non - geographic data. .
• Exceptional analytical and problem solving skills. Self-motivated team player and have good experience in opening cases and working with Microstrategy Premium Support Engineers.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy v9.x, v8.x, Tableau v8.x, v7.x Business objects.

Databases: SQL Server 2012/2008/2005, Teradata, Sybase, MySQL, Posgres, SSAS

ETL Tools: Informatica 8.x/7.x/ 6.x, SSIS, SQL *Plus.

Languages: SQL, PL/SQL, T-SQL.

Data Modeling Tools: Physical and Logical Data Modeling using Erwin.

Operating Systems: Windows 2012/2008/2003, Solaris, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Microstrategy Consultant

Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Prepared the logical and physical Data Models
• 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.
• Used Scan MD and MD Doctor Tools for troubleshoot Mstadata
• Involved in creating users in MicroStrategy Developer for testing the reports on Web
• After designing the high level Plan of the development effort, delegating the work among the team coordinating with offshore development teams to ensure efficient distribution of work efforts.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Troubleshooting Mobile Services and creation of reports and dashboards.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Worked on Distribution Services.
• Worked on Command manager for provision of new users and other tasks, such as cache management, ETL job triggers, etc.
• Worked on Integrity Manager for testing and validating data accuracy, as well as to moniter the report performance after the changes.
• Used Object Manager for migrations of objects and packages between different projects and environments
• Worked on Distribution Services for creating schedules and refreshing intelligent cubes
• Prepared test cases for subjecting the application code to necessary and effective testing.
• Extracted and analyzed data from the database using SQL to troubleshoot reports as needed using MicroStrategy ODBC Test tools.
• Expertise in configuring Mobile feature in Microstrategy to send send files to IPhones, Andriod devices, Ipad etc and configure them to access reports from I Server.
• Extensively worked on creating schedules / subscriptions for the reports / documents based on the need.
• Have very good experience of project level settings and have changed it at various stages across environments for better performance of the project / reports.
• Develop Command Manager scripts to monitor the server resources/making other project and server relates changes

Environment: Microstrategy v9.4.1, Windows 2012, DB2, SQL Server 2012, Teradata.

Microstrategy Consultant

Responsibilities:

• Migrated Microstrategy Environment from 9.2.1 to 9.4.1 on Linux Platform and configured Windows Authentication.
• Involved in migrating Data from DB2 to Netezza. And doing end to end validation using Integrity Manager Tool.
• Worked on changing the Object expression in the Projects like Attributes, Metrics, Filter’s etc according to Netezza Platform.
• Worked with Command Manager Tool on changing VLDB settings for reports using scripts.
• Worked on Command Manager, Integrity Manager, Object Manager, Enterprise Manage, Scan MD, MD Doctor and License Manager Tools on business requirements.
• Involved in installing of hot fixes on the environment.
• Creation of user groups at the Project level and granting the necessary permissions.
• Troubleshooting the environment to improve performance.
• Working with Database Administrators to develop logical designs for database/warehouse tables, as well as the logical schema for supporting end user report requirements
• Working with Service Now tool to track the Tickets and resolve them accordingly.

Environment: Microstrategy v9.4.1, Linux 6x, DB2, SQL Server 2012.

Microstrategy Administrator

Responsibilities:

• Uplifted and migrated Microstrategy 9.2.1 to 9.4.1 from Solaris 10 to Windows 2012 server along with implementing cluster nodes setup to scale out the environment and implemented windows authentication replacing LDAP auth.
• Involved in migrating some of the Projects from Microstrategy to Tableau at the server and developer level.
• Uplifted SQL Server Metadata, Enterprise Manager Console databases from SQL Server 2005 & 2008 to SQL 2012.
• Worked on creation subscriptions using distribution services to business users in different formats like HTML, Excel, Flash, Plain Text etc both on schedule based and event based and monitoring the jobs in regular intervals.
• Worked on creating and managing Narrowcast Server to send multiple files and documents in one single attempt to the business users.
• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development. Created Reports using complex Filters and Compound Metrics and Prompts.
• Analyzed the business requirement, identify the requirement, reviewing and communicating with business and getting sign offs from business.
• Generated and implemented advanced MicroStrategy Reports concepts by creating metrics, filters, templates, consolidations, transformations and custom groups.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Working with Free-Form SQL reports to create reports that are not supported by existing schema model.
• Created Intelligent Cubes for performance tuning.
• Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, widgets in flash mode to predict the trend in market and for interactive presentation and use of data.
• Used several Widgets for Dashboard reporting.
• Successfully created Physical Schema, Indices including unique, secondary join upon determining which is best in terms of performances.
• Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.
• Created Schedules, Subscriptions, Events, on the business requirement.
• Created Dashboards to monitor internal Service Now incidents, Schedules of the projects on the weekly and monthly bases.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes in data.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication

Environment: Microstrategy v9.4.1 & v9.2.1, Tableau v8.x & v7.x, Solaris, Windows 2012 Sybase, SQL Server 2008 & 2012, Teradata.

Microstrategy Consultant

Responsibilities:

• Analyzed data to create complex reports according to customer requirements.
• Designed and created dynamic dashboards for daily, weekly and periodic sales analysis.
• Created and implemented above widgets into Microstrategy web and Narrowcast Server.
• Created various narrowcast services to deliver the files to users via e-mails as well as to the file locations.
• Created e-mail services using Narrowcast Server to notify users about the file updates on web site.
• Used various Pre and Post sql statements for notification system.
• Created I-Server and Narrowcast data-load schedules.
• Created and used various custom excel templates for report formatting in Narrowcast Server.
• Improved the performance of the dashboards using VLDB properties.
• Improved the design and performance of the existing dashboards.
• Created user level security using system prompt.
• Created value prompts, so that the selections can be automatically passed to next dashboard without re-prompting.
• Setup to clear the cache of the reports and to re-run them on data-load.
• Created various schema objects, prompted and non-prompted filters (including relationship filters) and metrics and consolidation and custom groups.

Environment: Microstrategy v9.2.1, Teradata.

Designation: MicroStrategy Developer

Roles and Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Fully Responsible for the Design/Implementation of Proposed reports and Dashboards.
• Created multi-panel Dashboards that involved extensive usage of all Dashboard Functionality and also tuning them for enhanced performance.
• Designed and Developed Dynamic Dashboards using various selectors and widgets like time series slider etc.
• Created Users/User Groups and assigned appropriate security roles to meet the access privilege requirements.
• Created simple and Complex Reports in MicroStrategy Desktop and made it available to users for access through MicroStrategy Web.
• Created Dashboards to present critical company data in a single report.
• Used free form SQL editor for complex report creation.
• Implemented complex MSTR functionalities like Relationship Filters, table aliasing and data marts and written freeform sql to achieve various reporting requirement.

Environment: MicroStrategy v9.0.2, Netezza, SQL Server, Windows 2003.

Designation: MicroStrategy Consultant

Roles & Responsibilities:

• Generated and implemented advanced MicroStrategy Reports concepts by creating projects, attributes, hierarchies, facts, metrics, filters, Scoreboard, Dashboard and templates using MicroStrategy Architect, MicroStrategy Agent.
• Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for Business analysis.
• Created free form and grid based reports service documents.
• Used Micro Strategy Web to offer interactive reporting to the end users through a web browser.
• Used PL/SQL procedures in different places.
• Implemented Narrowcast Server Services to send reports to files and users via E-mail, based on schedules and static and dynamic subscriptions .

Environment: MicroStrategy Desktop 8.x, Oracle 9i/10g, Teradata,