SUMMARY:

• Has 8.2 Years of extensive IT industry experience in all phases of the System Development Life Cycle (SDLC) including Requirement Gatherings and Analysis, Design, Development, Testing, Implementation and Maintenance Support of OLAP/Data Warehousing Web Applications.
• Extensively worked on reporting tools such as Microstrategy, Tableau.
• Worked Extensively on MicroStrategy Enterprise Reporting Services in creating the Reports and Documents for Enterprise users.
• Extensively worked on Microstrategy versions 8.1x, 9.0x, 10.0x and explored new options in Microstrategy 10.0x.
• Involved in Microstrategy 9.0x and 10.0x version upgradation & testing.
• Worked on desktop, Object Manager, Command Manager and Project Merge Wizard.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Extensively worked on Microstrategy 9.3 Visual insights and explored the options in it.
• Explored visual insight Using D3 Visualizations in MicroStrategy Dashboards.
• Performed data blending coming through various data sources in visual insight.
• Create Highly Visual Dashboards in Minutes using visual insight.
• Administered MicroStrategy environments and formulated user groups.
• Supervised report delivery and established project schemas.
• Worked on iPad 4, configuring the server setting, configuring the Microstrategy projects etc.
• Created separate version dashboards for iPad view.
• Delivery of reports to the users through Narrowcast Server.
• Developed very large Reports having over 45 metrics each using Complex Filters and Compound Metrics.
• Implemented OLAP Functions like Apply Simple, Apply Agg, and Apply Comparison for the complicated filters, attributes and metrics
• Experience working with very large databases and large Micro Strategy projects.
• Optimized query performance by using VLDB (very large database) properties
• Extensively worked with End Users on the UAT of the Reports
• Involved in creating move documents from development to testing environment.
• Strong in Data warehousing concepts and well versed with dimensional modeling (Start Schema and Snowflake Schema) & Good knowledge in SQL.
• Worked extensively in Team Oriented Environment with strong, analytical, interpersonal and communication skills.
• Extensive experience in Installing, Configuring and Using MicroStrategy 9/8.1/8.0/7.5 tool Suite (MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services and MicroStrategy Distribution Services).
• Extensive Knowledge in Server Upgradation, Configuration, Implementing, Maintaining Controls and security policies on MicroStrategy.
• Extensive knowledge in cubes creation and scheduled Maintenance of cubes for Data Load in cluster environment.
• Extensive experience in MicroStrategy 8.x/9.x (Desktop, Administrator, Narrowcast server).
• Experience in analyzing the MicroStrategy system usage and performance by looking at the enterprise manager reports and taking appropriate actions to tune the system for improving the performance.
• Experience in using the command manager scripts to configure and manage the project settings.
• Experience in Project Duplications, Project Migrations using object manager from one environment to another.
• Extensively involved in performance tuning at database level collecting statistics and at MicroStrategy level using VLDB properties, aggregate tables, intelligent cubes, caching and other configuration settings.
• Strong working experience in MicroStrategy Architect such as Schema Objects such as Simple, Compound, Custom facts and Attributes, Transformation, Logical Tables, Hierarchies etc.
• Extensively worked in MicroStrategy Report Services to design Static Document/Dashboard/Dynamic/Interactive Dashboard/Flash Dashboards for amazing data visualizations.

TECHNICAL SKILLS:

Operating System:: Windows 98/XP/2000

Reporting Tools:: Microstrategy 8.1.1, 9.0.1, 9.2.1m, 10.x, Tableau 7.0, 8.0 and 8.1, 8.2

ETL Tools:: Informatica Power Center 8.1.1

Languages:: SQL, PL/SQL

Databases:: Oracle 9i, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Microstrategy Developer & Architect

Responsibilities:

• Identifying the different objects in BRD & clarifying.
• Going through Report Specification Documents and Understanding the User requirements.
• Creation of technical design, Mockup data, Object mapping document, based on the requirement document.
• Created new Facts, Attributes and Attribute Form Expressions and Hierarchies as needed in the project.
• Excellent hands on work experience in building Canned/Ad - hoc/Analytical reports using ROLAP & MOLAP Business Intelligence reporting tools (Microstrategy 8i & 9i), Microstrategy Desktop, Microstrategy Web, and Microstrategy Office, Object manager, Intelligent Cubes, Report Services, Enterprise Reporting, OLAP provider and Data Mart.
• Involved in Microstrategy version upgradation from 9.0.1 to 9.2.1m and testing done across all the reports and dashboards.
• Delivery of reports to the users through Narrowcast Server.
• Extensively worked on Report Services Documents using dashboards.
• Worked on different widgets like Bubble graph widget, Graph matrix widget etc.
• Developed transformations to generate reports of type Sales this period to Sales this period Month, M3M, QTD Month, YTD, MAT, Week, and QTD Week and so on.
• Designed 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.
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts
• Tested the Microstrategy objects across Database
• Involved in Microstrategy version upgradation.
• Worked with Linux skills, familiarity with intelligence server and clustered and non-clustered environment

Environment: MicroStrategy desktop 9.2.1m, 10.0.x, MicroStrategy Administration, Oracle SQL (10g), Windows 7.

Confidential

Microstrategy 9.2.1m, Architect

Responsibilities:

• Extensively worked with Metrics, Facts, Transformations, and Custom Groups & Report Services.
• Responsible for creation of Canned/Ad-hoc Reports, Metrics with Public and Schema Objects for HR domain requirements.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Design and Development of Business Analysis Interactive Dashboards & Scorecards organizations HR's goals & KPI in Microstrategy Desktop and web.
• Once ETL is done and data gets loaded to Data warehouse, Defined and created Microstrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.
• Conditional formatting on metric thresholds, limiting report data access using security filters.
• Strong in Narrowcast Server especially using Scheduling, Subscription and Event Base Alert Services.
• Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.
• Using visual insight Quickly add, rearrange, or remove report objects from a visualization in a quick dashboard.
• Create additional visualizations to display the data in multiple ways, then easily modify, rearrange, or resize visualizations in a quick dashboard in visual insight.
• Add filtering based on report objects to a quick dashboard, to allow users to only display the information they are interested in.
• Add thresholds to a quick dashboard, to change the display of data based on the value of a metric

Environment: Microstrategy 9.2.1(Desktop, Architect, Web) and TOAD for testing Reports, Ms Office, Oracle 10g, Windows 7.

Confidential

Microstrategy 9.0.1 Developer & Architect

Responsibilities:

• Created Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Developed Public Objects (filters, prompts, metrics, Custom Groups, Consolidations, and Searches) to develop Documents and reports.
• Created Free Form SQL reports based on user requirement.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison and Transformations.
• Worked with Object Manger to Migrate Objects from DEV to TEST & PRODUCTION environments.
• Designed 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.
• Developed Report Service Documents, interactive dashboards and scorecards with different widgets for High level Management.
• Optimized query performance by using VLDB (very large database) properties.
• Tested Microstrategy Reports across Database.
• Tested Micro strategy objects across Database.

Environment: Microstrategy 9.0.1(Desktop, Architect, Web, Administrator and Oracle Developer for testing Reports, Ms Office, Oracle 10g, Windows 2003 Server).

Confidential

MicroStrategy Developer & Architect

Roles and Responsibilities:

• Create Proof of Concept for implementing different Specifications for Microstrategy Reports.
• Created new Facts, Attributes and Attribute Form Expressions and Hierarchies as needed in the project.
• Performance tuning of the reports
• Analyze and Understand the Business reports and identify the rationalization opportunities.
• Content Analysis of reports to map the report data elements to Business Glossary.
• Creating a Report Specification Document for every report using the Content Analysis Document and sign-off specification documents with Business.
• Create Report Decomposition Document by referring the Specification document and validate all data elements in the decomposition document against the Business glossary.
• Review and understand the Technical Design Document and find out the gaps in Report specification documents.
• Created Ad-hoc reports with Dynamic prompt answers for the end users to generate.
• Improved report performance using VLDB properties, Caching.

Environment: Microstrategy 8.X,9.0.1(Desktop, Web and TOAD for testing Reports, Ms Office, Oracle 10g, Windows 2003 Server).