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 serveralong 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 Manager and License Manager.
• Worked with Database teams on upgrading the Metadata and Database versions.
• 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, NC

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.
• 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.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Created documents with both Grids and graphs as per user requirements.
• 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.
• 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.5.1, Windows 2012 Sybase, SQL Server 2012, Teradata.

Confidential, AZ

Microstrategy Consultant

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.
• 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.

Confidential, CA

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.

Confidential, Milwaukee, WI

MicroStrategy Developer

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.

Confidential, Minneapolis, MN

MicroStrategy Consultant

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