PROFESSIONAL SUMMARY:

• Around 8 years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting, dashboard and Administration.
• Extensive experience with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, 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 using MicroStrategy 9.x
• Expert in Designing Data Marts using different multi-dimensional modelling techniques such as Star Schema and 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 better understanding 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 MicroStrategy configuration, 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 9.4.1/9.3.1/9.2.1, MicroStrategy Developer, VisualInsight, Mobile, Intelligence Server, Cubes, Object Manager, System

RDBMS: Oracle 10g, Teradata, Sql ServerManager, Enterprise Manager, Report Services, Distribution Services.

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

PROFESSIONAL EXPERIENCE

Confidential, Nashville TN

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 Grid form of reports.
• Created Transformations (table based, formula based) for using in comparative reports likeyear to date and month to date.
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Used MicroStrategy project builder in creating different Reports to meet the in house Business Requirements.
• 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 Report Optimizations.
• 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 9.3/9.4.1, (Desktop, Web, Object Manager, Enterprise Manager, Distribution server, Office, Report Services), Windows XP, Teradata

Confidential AZ

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 Grid form of reports.
• Created Transformations (table based, formula based) for using in comparative reports likeyear to date and month to date.
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Used MicroStrategy project builder in creating different Reports to meet the in house Business Requirements.
• 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 Report Optimizations.
• 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, Phoenix AZ

Microstrategy Dashboard Developer

Responsibilities:

• Conduct meetings with business users on finalizing reporting requirements.
• Gather dashboard requirements and developing interactive dashboards using Micro Strategy 9.2.1version
• 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 Graph and Grid form of reports.
• Involved in administrative works creating users, security filters, trigger database events and time based events.
• Preparing dashboard design document & create template for Dashboard
• 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).
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
• 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, Relational ship Filters and pass through functions for complex reports.
• Developed reports for MicroStrategy Web users
• Understanding the MicroStrategy Reporting environment of the organization.
• Extensively involved in designing the data model with data model designer according to the changing dimensions in the project.
• Understanding the Data model and identifying the tables to be used for reports.
• Developed Report Services dashboards and documented and formatted the reports.

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

Confidential, Wilmington DE

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 Graph and Grid form of reports.
• Involved in administrative works creating users, security filters, trigger database events and time based events.
• Preparing dashboard design document & create template for Dashboard
• 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).
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements
• 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 adhoc reports.

Environment: MicroStrategy 9.0.1 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web), Oracle 10g, Windows 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 Graph and Grid form of reports.
• 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).
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements
• Build and thoroughly test reporting changes and enhancements, understand data validation requirements as appropriate.
• Perform all aspects of software quality assurance/testing applications.

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

Confidential

MSTR Database Tester

Responsibilities:

• Co-ordination with the Business Analyst and understanding the Business requirements
• Gather report requirements and create reports using MicroStrategy 7.2.2
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements
• Build and thoroughly test reporting changes and enhancements, understand data validation requirements as appropriate.
• Perform all aspects of software quality assurance/testing applications.
• Understand the product functionalities with help of RDD and Technical Specification.
• Execute the test cases manually using CARS workbench.
• Report the defect in Change Point and track it to closure.
• Perform regression testing to ensure the correctness of the applications.
• Attending the Status Call with Onsite Coordinators and the Clients.

Environment: MicroStrategy 7.2.2 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web), SQL, Windows XP,CARS