Worked with the business team to gather the requirements and define the scope for Film–IT Team. Involved in Creation of Architecture and Maintenance of Microstrategy Environment for Film Strategy & Operations (FS&O) Team. Created Forecasting Tool using Microstrategy Transactional Services to Forecast the data using the Historical information. Worked with Teradata DBA in creating Complex Views and Tables specifically for Forecasting Tool. Worked on Dashboards/Documents which has complex calculations using Level metrics and also Converted the Web Dashboards/Documents to IPad Dashboards to be used in Microstrategy Mobile Apps. Created complex FFSQL Reports/Documents to meet the expectations of Real-Time Reporting. Resolved multiple Production issues and provided support. Implemented Control-M process to refresh Intelligent Cubes in Microstrategy. Worked on administration tasks like Tuning, Caching, specifying Query Governing Thresholds, Report Optimization and User Management. Created complex reports involved with complex queries with Documents and Dashboards. Involved in troubleshooting Microstrategy Adhoc Reports created by Business Users. Provided training to Non-Technical Users on Microstrategy Capabilities Leading and guiding the off-shore development teams.

Worked with the Conversion of Webfocus and OBIEE Reports to Microstrategy Reports.Understanding the logic of Parm files, Master files and Fex files in Webfocus and Document the requirements with Microstrategy development needs.Hands on experience with Webfocus Architectural design and converted it to Microstrategy Architectural design with respect to the Organization.Involved in meetings for the conversion process and provide the solution of OrganizationSecurity model through Microstrategy.Architectured various schema objects like Attributes, Facts, Logical Views and Hierarchies required for reporting.Created complex reports involved with complex queries with Documents and Dashboards.Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.Gained the knowledge of Report Caster in Webfocus and converted them into Microstrategy Reports and deliver to users using Distribution Services.Understood the Physical Layer / Business Model and Mapping layer / Presentation layer of a repository and architectured the schema in Microstrategy.Complex Adhoc Reports from Webfocus and OBIEE are developed in Microstrategy.Migrated Schema and Application objects using the Object Manager.Worked with Infrastructure team for administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Participated in requirements gathering sessions with the team to define and document the requirements.Analyzed the existing reports and warehouse to create a Gap Analysis document.Involved in architecting various schema objects like Attributes, Facts and Hierarchies required for reporting.Extensively worked on conversion of Reports and Dashboards from Business Objects to Microstrategy.Developed reports and Dashboards with Multisourcing option.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 Desktop for testing the reports.Various queries were written for optimization, exploited the indexing at the back-endInvolved in and provided solutions for complex Time Dimension related issues and analysis.Created base formulae, mathematical expressions using existing facts in Microstrategy desktop, which was used to build numerous other metrics. Developed various levels of reports and all objects involved in a report for user requirements, i.e. filters, metrics, templates, custom subtotals, Level Dimensionality.Identified the various attributes, metrics and reports needed from business group and involved users.Involved in Testing and Tuning of Reports and Objects. Worked on VLDB Properties for performance tuning.Worked with Infrastructure team in Report Delivery process as per user requirements without using Narrowcast Server and Distribution Services .Helped in ETL testing for dimensions and fact table.Worked with support team in fixing issues and defects raised by UAT team.Helped infrastructure team for sanity testing of the environment once it has been setupAdded custom font to web using Microstrategy Web SDK.Worked with Microstrategy mobile app development team to resolve the security flaws in iOS version 9.4.1.

Participated in requirements gathering sessions with the team to define and document the requirements.Analyzed the existing reports and warehouse to create a Gap Analysis document.Involved in architecting various schema objects like Attributes, Facts and Hierarchies required for reporting.Extensively worked on conversion of Reports and Dashboards from Business Objects to Microstrategy.Developed reports and Dashboards with Multisourcing option.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 Desktop for testing the reports.Various queries were written for optimization, exploited the indexing at the back-endInvolved in and provided solutions for complex Time Dimension related issues and analysis.Created base formulae, mathematical expressions using existing facts in Microstrategy desktop, which was used to build numerous other metrics. Developed various levels of reports and all objects involved in a report for user requirements, i.e. filters, metrics, templates, custom subtotals, Level Dimensionality.Identified the various attributes, metrics and reports needed from business group and involved users.Involved in Testing and Tuning of Reports and Objects. Worked on VLDB Properties for performance tuning.Worked with Infrastructure team in Report Delivery process as per user requirements without using Narrowcast Server and Distribution Services .Helped in ETL testing for dimensions and fact table.Worked with support team in fixing issues and defects raised by UAT team.elped infrastructure team for sanity testing of the environment once it has been setupAdded custom font to web using Microstrategy Web SDK.Worked with Microstrategy mobile app development team to resolve the security flaws in iOS version 9.4.1.

Worked on conversion of complex Essbase Reports to Microstrategy Reports.Participated in user interaction to obtain the business requirements and translated them in to report specifications for the Microstrategy platformDesigned and Developed Microstrategy Schema objects and Application objects like Attributes, Hierarchies, Facts, Metrics, Filters, Prompts.Created base formulae, mathematical expressions using existing facts in Microstrategy desktop, which was used to build numerous other metrics. For complex reporting needs, worked extensively on creating Compound Metrics, Custom Groups and ConsolidationsInvolved in creating Security filters and developed complex filters and transformations.Worked with VLDB properties for performance of SQL.Responsible for developing customized and Ad-hoc reports for Business analysis using Microstrategy Agent incorporating features like Drilling and Thresholds.Involved in customization of Grids and Graphs.Created Report Services Documents to personalize the reports as per user requirements, which included combination of several sets of individual grid reports, customizing and formatting.For comparative studies, created reusable Transformation objects that enabled time-series analysis Developed Reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.Created filters with advanced qualification involving ‘Apply Simple’ and ‘Apply Comparison’ functions.Tested all the reports by running queries against the warehouse using SQL.Also compared those queries with the Microstrategy SQL engine generated queries

Involved in the complete Life cycle of the Project.Participated in the end user meetings to obtain the business requirements for creating reports.Involved in the data analysis.Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.Created Advanced Reports in grid mode and graph mode using MicroStrategy Desktop.Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.Extensively used Report Services to generate Documents for exporting to Excel & PDF.Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes. Worked with the end users to finalize the Dashboard Layouts.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 Desktop for testing the reports on Web.Used Report cache sharing and Data mart reports to enhance the Report response time.Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.Extensively used MicroStrategy Report Services to generate Report Documents.