SUMMARY

• Around 7+ years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting,dashboard and Administration.
• Extensive experience with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategyWeb,MicroStrategy Office and MicroStrategy
• Participated in the Software Development life - cycle of the data warehousing and Business Intelligence project.
• Extensive Experience in Software Analysis, Design, Development of business intelligence application usingMicroStrategy 9.x
• Expert in Designing Data Marts using different multi-dimensional modelling techniques such as Star Schemaand Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modelling
• Strong expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies,Functions and operators.
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates,Documents, Custom groups and Consolidations).
• Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in betterunderstanding of business trends.
• Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Proven troubleshooting capabilities in MicroStrategy Desktop.
• Worked extensively on Oracle, Teradata, and SQL Server with Micro strategy Suite.
• Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategyconfiguration, reports and other output.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Performed the role of team member/developer dedicatedly.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy … MicroStrategy Developer, Visual Insight, Mobile, Intelligence Server, Cubes, Object Manager, System Manager, Enterprise Manager, Report Services, Distribution Services.

RDBMS: Oracle 10g, Teradata, Sql Server

Operating Systems: Windows 98, XP, Unix/Linux, Mainframe

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Senior Microstrategy Developer

Responsibilities:

• Interacting with customer on daily basis and providing valuable suggestions and freezing the requirements• Created Microstrategy Schema objects such as attributes, tables, Hierarchies and facts using Microstrategy Architect.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Gridform of reports.
• Created Transformations (table based, formula based) for using in comparative reports like year to date andmonth to date.
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports forbusiness analysis.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools inMicroStrategy.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Implemented OLAP cubes functionality in Query performance.
• Worked on Drill map editors, Hierarchy relations, and pass through functions for complex reports.
• Performed the Administration tasks like tuning, caching, specifying Query Governing Thresholds and ReportOptimizations.
• Developed reports for MicroStrategy Web users.
• Understanding the MicroStrategy Reporting environment of the organization.
• Understanding the Data model and identifying the tables to be used for reports.
• Developed Report Services dashboards and documented and formatted the reports.
• Responsible for monitoring schedules for the database triggers on daily bases.
• Co-ordinate to off shore team and evaluate offshore work.
• Unit testing of the created reports
• Preparing the mapping document for dashboard and report
• Create a template for the dashboard & auto style for report

Environment: Microstrategy … (Desktop, Web, Object Manager, Enterprise Manager, Distribution server, Office, Report Services), Windows XP, Teradata

Confidential, Beverly Hills, CA

Senior Microstrategy Developer

Responsibilities:

• Interacting with customer on daily basis and providing valuable suggestions and freezing the requirements• Created Microstrategy Schema objects such as attributes, tables, Hierarchies and facts using Microstartegy Architect.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Gridform of reports.
• Created Transformations (table based, formula based) for using in comparative reports like year to date andmonth to date.
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports forbusiness analysis.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools inMicroStrategy.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Implemented OLAP cubes functionality in Query performance.
• Worked on Drill map editors, Hierarchy relations, and pass through functions for complex reports.
• Performed the Administration tasks like caching, specifying Query Governing Thresholds and ReportOptimizations.
• Developed reports for MicroStrategy Web users.
• Understanding the MicroStrategy Reporting environment of the organization.
• Understanding the Data model and identifying the tables to be used for reports.
• Developed Report Services dashboards and documented and formatted the reports.
• Monitoring the schedules for the database triggers sometimes on daily bases.

Environment: MicroStrategy 9.0.2 (Desktop, Web, Object Manager, Enterprise Manager, Office, Report Services), Oracle 10g, Windows XP

Confidential, Boca Raton, FL

Microstrategy Dashboard Developer

Responsibilities:

• Gather report requirements and creating reports using Micro Strategy 9.0.1
• Gather dashboard requirements and developing interactive dashboards using Micro Strategy
• Co-ordination with the Business Analyst and understanding the Business requirements
• Identifying different source tables and columns required to create a MicroStrategy project.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graphand Grid form of reports.
• Involved in administrative works creating users, security filters, trigger database events and time basedevents.
• Preparing dashboard design document & create template for Dashboard
• Created Transformations (table based, formula based) for using in comparative reports like sales this yearto last year (year to date and month to date).
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports forbusiness analysis.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed dataelements
• Designing and developing of Dashboard with the dataset created.
• Creation of the mht file and Delivery of the Dashboard.
• Creation of .rst, Implementing Layout concept in the Dashboard.
• Implementing customized widget in the Dashboard
• Created standard and ad-hoc reports.

Environment: MicroStrategy 9.0.1 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web), Oracle 10g, Win XP

Confidential

Microstrategy Developer

Responsibilities:

• Gather report requirements and create reports using MicroStrategy 8
• Co-ordination with the Business Analyst and understanding the Business requirements
• Identifying different source tables and columns required to create a MicroStrategy project.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graphand Grid form of reports.
• Created Transformations (table based, formula based) for using in comparative reports like sales this yearto last year (year to date and month to date).
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports forbusiness analysis.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed dataelements
• Build and thoroughly test reporting changes and enhancements, understand data validation requirementsas appropriate.
• Perform all aspects of software quality assurance/testing applications.

Environment: MicroStrategy 8 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy