Qualification Summary

• Over 7 years of IT experience in Data Warehousing, Data Architecture and Data Modeling using MicroStrategy Platform, Tableau, Informatica and Erwin.
• Strong experience using MicroStrategy 8.x/9.x Suite Intelligence Server, Administrator, Architect, Desktop, Web , Business Objects 5.x Web intelligence and Deski ,Tableau Desktop and reader.

• Worked with MicroStrategy Architect to build Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
• Created Transformations Table based, Formula based for using in comparative reports like sales of various products this year to last year year to date and month to date .
• Creating Logical views in MicroStrategy to support the new requirements.
• Managed schema development changes/enhancements effectively. Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
• Worked on Various Complex Data models involving both Star and Snowflake schema.
• Worked with the Business Analysts and involved in gathering Business requirements and determining the appropriate facts, attributes and metrics from the same and documented them.
• Guided the business users by creating prototypes for the Dashboards and Scorecards.
• Involved in Analysis, Design, Development and Implementation of Business Intelligence and Maintaining Applications using MicroStrategy DSS Tool suite.
• Worked extensively on MicroStrategy Desktop, Administrator, Intelligence Server and Web.
• Worked closely with MicroStrategy Narrowcast Server applications.
• Provided complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Extensively worked on the intelligent cubes and created reports out of it.
• Developed Reports, Flash dashboards and Interactive documents extensively from Desktop and Web.
• Experience in Visual Insight Services.
• Involved in creating Custom Documents in MicroStrategy to combine the Data sets of multiple reports and also created Custom Dashboards and Scorecards using Report Services.
• Extensively worked on the Object Manger to move the Objects between different Environments.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, and Performance monitoring.
• Tuned the reports to enhance performance and reduce the running time.
• Expertise in calling reports by passing parameters through Edit links and hyperlinks in reports and dashboards.
• Very proficient in working with large Databases like Oracle,Teradata and SQL Server.
• Used Erwin to generate logical Physical models of the Data Warehouse Structures.
• Used Tableau 8 reporting tool to develop custom SQL workbooks based on the business needs.

Technical Skills:

OLAP Tools: MicroStrategy 9.4,9.3, 9.1, 8.1.0, 8.0 8.0.1, 8.0.2 , Administrator, Desktop, Web, Architect,

Narrowcast, Report Services . Tableau 8.

ETL Tools: Informatica 7.0/ Power Center

Data Modeling: Erwin 4.0

RDBMS: Oracle 11g10g/9i, SQL Server, DB2 v7.2, Teradata V2R5,V2R6, 12/14, Teradata Aster, Microsoft Access, Essbase.

Tools: SQL plus, Erwin 4, Toad, Visio, SQL Query Analyzer, Visual Source Safe, MS-Office 2007, SharePoint, Remedy, MS-Project 2007, SAS Enterprise Scripting: SQL, PL/SQL, SQL-MR, ksh, Visual basic script.

Languages: SQL, PL/SQL,C,C

Professional Experience

Confidential

Role : MicroStrategy Architect / Developer

Responsibilities :

• SDLC methodology Requirement Gathering, BRD, BSD, Gap Analysis, Data Modelling, SSD, Project Architecture, Report Development and Performance tuning.
• Successfully Architected 2 MicroStrategy Projects for PO Change Tracking and Single View Reporting groups.
• Involved in gathering business requirements and documenting specifications.
• Architected objects and developed strategic reports integrating multiple country data for International Business groups.
• Worked with the Business Analysts and involved in gathering business requirements and determining the appropriate facts, attributes and metrics from the same and documented them.
• Architected objects and developed strategic reports integrating multiple country data for International Business groups.
• Managed schema development changes/enhancements effectively. Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
• Created Transformations table based, formula based for using in comparative reports like sales this year to last year year to date and month to date .
• Designed and Developed Templates, Filters, Metrics, and OLAP Reports using MicroStrategy 9.0.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the filter.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Resolved Many to Many relationship between the attributes and identified the one to one and one to many relationship between the attributes
• Provided end user training for the MicroStrategy Web users.
• Worked extensively on MicroStrategy Administration like creating the new users, roles Privileges, Access control lists.
• Responsible for various administration tasks like Tuning,Caching,specifying Query Governing Thresholds, and Report Optimization.
• Hands-on experience in administration and maintenance of MicroStrategy platform for all data warehouse components.
• Extensively worked on Dashboards using Report Services and also migrated documents to 9.0.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Extensively used Narrowcast Server for personalized Report distribution.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like query optimizations.

Confidential

Role : MicroStrategy Developer

Responsibilities:

• Started with generating MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop.
• Developed Complex business reports in desktop using multiple Prompts, Filters and Compound metrics.
• Created Narrowcast objects such as Information Objects, Question Objects, Publications Control Documents, Excel attachments, Email body , Services, Sub I/O, Schedules etc.
• Created Dashboards and Scorecards using Report Services and also migrated documents to 8.1.
• Trained Microstrategy's BI team on the updates from the tool and monitored them.
• Created Custom Documents using MicroStrategy Reports to combine the Data sets of multiple reports and also created custom Dashboards and Scorecards using Report Services.
• Developed Narrowcast Reports for the SMART support team using Static and Dynamic subscriptions.
• Designed Flash Enabled Interactive Dashboards by adding additional functionalities using panels, selectors and widgets and delivered the files to the end users via Narrowcast Server.
• Created Individual MicroStrategy reports in desktop using the Custom Groups and Consolidations and thus Information objects from them, to align them in the Excel Document editor in the Narrowcast.
• Extensively used Micro Strategy's Narrowcast to create Weekly Excel reports and created excel attachments in Narrowcast using the Excel document editor, populating the Document elements into it.
• Extensively worked on MicroStrategy administration like creating new users, roles and Access s control lists and Privileges.
• Developed the Excel Reports which contained multiple tabs and multiple dropdowns which was built using the Macro code for the Narrowcast Requirements.
• Involved in implementing optimization techniques to enhance the performance of queries dynamically generated by MicroStrategy using VLDB properties and also by interacting with DBA's and designers.
• Developed Weekly, Quarterly and Monthly scheduled Narrowcast Reports.
• Troubleshooted the Narrowcast Issues looking at the logs.

Confidential

Role : MicroStrategy Consultant

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.
• Created more than 100 reports from the scratch by creating the project, Attributes, Facts, Hierarchy, Filters, Metrics, Prompts and all other MicroStrategy related objects.
• Obtained the requirement specifications from the Business Analysts for Corporate work place project Interacted with the business users to build the sample report layout
• Worked on MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Some formal responsibilities on the project includes Reporting requirement finalization with business users report mockups , Help Data Analyst with Data Model Design, Create MSTR Schema Objects ,Work with DA and DBA on better index pattern and database views for higher performance, Performance Tuning on a Teradata database of 22 terabytes, Migration testing of MicroStrategy 7.5.2 reports to version 8 report.
• Created Users, Roles Privileges using the MicroStrategy Desktop Administrator .
• Developed Facts, Attributes, and Hierarchies using respective editors.
• Worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Generated freeform reports for faster and better performance of the system as per the user requirements.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for Oracle 9i and SQL hints.
• Designed and Developed Templates, Filters, Metrics, and OLAP Reports using MicroStrategy 8.1.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the filter.
• Designed and developed reports using Advanced Metric Objects, Filters, and Prompts and hence providing users with the facility to create customized reports by creating their own filters and templates.
• Resolved Many to Many relationship between the attributes and identified the one to one and one to many relationship between the attributes
• Provided end user training for the MicroStrategy Web users.
• Worked extensively on MicroStrategy Administration like creating the new users, roles Privileges, Access control lists.

Confidential

Role : MicroStrategy Consultant

Responsibilities:

• Created database for production environment In Oracle.
• Created users, roles and privileges on the Oracle databases.
• Created user groups, roles, privileges using MicroStrategy Application.
• Involved in Designing Ad-hoc Reports, Scorecards, and Dashboards.
• Generated analytical reports using Slice, Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Created and configured database for development and production environments.
• Created tables in SQL Server 6.5.
• Developed stored procedures and database triggers using PL/SQL.
• Database and log backups restoration, backup strategies, scheduling the backups. Backing up System User Databases and restoring them when necessary.
• Monitor tune SQL scripts. Creating upgrade scripts for production Database and support.
• Performance monitoring and tuning of SQL servers and Data transfers using BCP.
• Setting up the monitoring triggers on NT for SQL Server Databases