Skills

Employment History:

Confidential

Targeted Interactions Reporting

Responsibilities:

• Started with Analysing the Complex Logical data model and suggested the changes as per the MicroStrategy engine behaviour.
• Worked with the Data modeller to effectively design the Snow flake architecture that works effectively with the MicroStrategy application.
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Responsible for all MicroStrategy Architecture Development work across 3 projects.
• Provide sustainable BI solutions in a complex environment that have a high daily sales view across 15,000 stores to CXO's wide performance during peak hour to all Store Managers reach.
• Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
• Created metrics simple, nested compound , advanced filters, advanced prompts, report designs and drill maps.
• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.
• Analyzed Business Requirements and interacted with the Business Analysts for designing ad-hoc reports.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters etc.
• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Created Complex filters with advanced qualifications involving the 'Apply' functions.
• Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results
• Implementing end to end MSTR Application
• Created Dashboards using Report Services Documents.
• Applying various types of Thresholds in Dashboard Design Documents.
• Created various monthly Dynamic Dashboard Documents with multiple panel stacks, selectors, and customized widgets.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Created Transformations to use them to create Year-to-date, Month-to-date type metrics and also to create Prior Year Metrics
• Created/modified interactive Dynamic Dashboards and Scorecards for different users with drill down capabilities.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Configured the Enterprise Manager for statistical reporting purposes.

Environment: MicroStrategy 9.4, 9.3, 9.1, 9.2, 9.0, Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, SDK Oracle, PL/SQL, Windows 2008, MS Office, Visio.

Confidential

Responsibilities:

• SDLC methodology Requirement Gathering, BRD, BSD, Gap Analysis, Data Modelling, Project Architecture, Report Development and Performance tuning.
• Working on customizing and optimizing the query performance of reports for various users using MicroStrategy features like VLDB property.
• Implemented Narrowcast services for scheduling reports to business users and analysts.
• Creating maintaining schedule objects to create caches for dashboards, reports.
• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer
• Implementing end to end MSTR Application
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Extensively used filters, prompts, metrics, consolidations and custom groups to generate reports.
• Extensive use of dynamic dashboard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web View, interactive, Editable and flash mode , Subscription feature to improve the performance and mobility of the group.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
• Actively participated in developing Report Delivery Schedules
• Worked closely with business users and other development teams in all stages of the BI development lifecycle.
• Applying various types of Thresholds in Dashboard Design Documents.
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Created Transformations for using in comparative reports like revenue this year to last year.
• Analysed and developed Application Objects Metrics, Reports, Documents, filters, prompts using MicroStrategy Desktop and MicroStrategy web interfaces.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like query optimizations.

Environment: MicroStrategy 9.0 , Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Oracle, PL/SQL, MS Office, Visio

Confidential

Responsibilities:

• Understanding business requirements and dealing with the client.
• Creation of Project Design and Schema Objects in MicroStrategy Architect to meet proper joins requirement for the SQL generation.
• Analysis of the Dimensional Data-Modeling and suggesting changes in Data-Model to meet the reporting requirements.
• Designed and Developed Complex and large MicroStrategy Reports in MicroStrategy Desktop.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Analysis of SQL generated by MicroStrategy.
• Troubleshooting and Performance tuning of the SQL using VLDB properties.
• Monitoring and ensuring of project progress and preparation of Status reports.
• Involved in creating and implementing MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Implementing end to end MSTR Application
• Worked closely with business users and other development teams in all stages of the BI development lifecycle.
• Applying various types of Thresholds in Dashboard Design Documents.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Used advanced prompts, non-aggregate, conditional, transformation metrics and level Metrics for creating complex reports for business analysis.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Created several document objects to display multiple reports. Multiple report objects were embedded in the document objects, which included reports, graphs and some images.
• Transformations were used to perform time series analysis over various phases and also to calculate the variance and the growth percentage trends.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date

Environment: MicroStrategy 8.1/8.0. Administrator, Desktop, Intelligence server, Object Manager, Enterprise Manager, Narrowcast Server , Oracle 9i, /10g , MS Office, Visio

Confidential

Responsibilities:

• Author Business Requirement Document BRD , Business Solution Document BSD , and Report Requirement Document RRD and provide logical data modelling to the ETL and the off-shore teams.
• Extensively worked with Logical and Physical modelling, design and implementation of Oracle.
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Worked closely with business users and other development teams in all stages of the BI development lifecycle.
• Developed and Analyzed Application Objects Metrics, Reports, Filters, Documents, Prompts using the Microstrategy Desktop and Microstrategy Web interfaces and Created more than 100 reports from the scratch by creating the project
• Worked on MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Implementing end to end MSTR Application
• Applying various types of Thresholds in Dashboard Design Documents.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Created advanced reports which include Advanced Prompts Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt and Advanced Filters Attribute Qualification, Set Qualification and Advanced Qualification Filters .
• Optimized the Intelligence Server for better performance.
• Designed report templates to generate reports in Grid and Graph mode.
• Implements Drill functionality on the reports using Drill Maps.
• Created Dynamic dashboards to improve marketing by product, customer, geographic and promotion analysis.
• Coordinated with business, data modeling and ETL team at various levels for stabilization of reports.

Environment: MicroStrategy 8.1/8.0. Administrator, Desktop, Intelligence server, Object Manager, Enterprise Manager, , Oracle 9i, /10g , MS Office, Visio

Confidential

MicroStrategy BI Consultant

Responsibilities:

• 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.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications
• Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Architected the Schema for the project by creating facts, attributes, and hierarchies.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Designed and built pixel perfect report service documents and interactive Flash dashboards.
• Implementing end to end MSTR Application
• Applying various types of Thresholds in Dashboard Design Documents.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Build the report builder interface for the Ad hoc Analysis.
• Created transformations using Transformations by tables for YTD Year to date , and MTD Month to date for Time Series Analysis.
• Analyzed the legacy reports and recreated in the MicroStrategy.
• Set up the distribution services for distributing the report output to the different levels of users.
• Involved in troubleshooting MicroStrategy Web Reports

Environment: MicroStrategy, SQL Server 6.x, Visual Basic 5.0/6.0, Developer 2000, SQL Plus, PL/SQL Oracle7.i, Windows, UNIX, and Windows NT 4.0, MS Office, Visio

Confidential

Jr. Database/MicroStrategy Developer

Responsibilities:

• Gathered requirements from users and converted them to technical specifications.
• Performed SQL tuning to minimize data load time. Excellent gain in performance recorded and also involved in defining requirements, functional specifications, design documentation and test strategy
• Participated actively in Logical design.
• Effectively created DDL scripts and populated tables on Data Warehouse.
• Developed Data Validation and Polling processes for some of the ETL designs.
• Developed ABC Audit, Balance and Control processes in ETL.
• Involved in gathering business requirements, Analyzing, Modeling, and documenting specifications.
• Applying various types of Thresholds in Dashboard Design Documents.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Implementing end to end MSTR Application
• Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
• Worked extensively with filters, custom groups, prompts, consolidations and transformations so as to generate reports meeting business needs.
• Designed and populated Snowflake Time hierarchy.
• Set up the initial metadata by creating Schema Objects and Application Objects.

Environment: MicroStrategy 8.0x/8.1 Desktop, Web, Intelligent Server , Informatica, UNIX, Windows 2000, Oracle 9i, Data Flow diagram, SQL Server, MS Office, Visio