SUMMARY

• Around 7 years of professional IT experience Business Intelligence Tool with MicroStrategy.
• Experience in designing and generation of business reports using OLAP reporting tool MicroStrategy.
• Expertise in creating and integrating MicroStrategy reports with objects (Attributes Metrics, Hierarchies, Filters andPrompts).
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Experience in creatingIntelligent Cubes,Documents, interactive Dashboards and Scorecards.
• Experience in using MicroStrategy Architect for creating Project, Attributes, Facts, Hierarchies and Transformations.
• Experience in migrating projects using MicroStrategy Object Manager and Project Merge.
• Experience in administrative tasks like User Creation, Scheduling the reports and report service documents.
• Experience in using MicroStrategy Desktop, MicroStrategy Intelligence Server and MicroStrategy Web.
• Having experience in creating and Performing Unit Test Cases
• Good knowledge in ETL using Informatica 8.6
• Having excellentSQLskills and good knowledge in data warehouse concepts.
• Excellent communication skills with ability to work independently as well as collaboratively in team environment to contribute problem - solving strategies. At ease in interacting with people at all levels, able to work under pressure.
• Excellent team player with good analytical, communication and interpersonal skills

TECHNICAL SKILLS

Business intelligence: MicroStrategy 8.0.2/ 9.0.2/9.2.1/9.3.2/9.4.1, SAP BO XI 3.1/4, SSRS, Tableau 9.0

Databases: Oracle, TERADATA, SQL Server 2000/2005

Languages: SQL, C

ETL tool: Knowledge on Informatica 8.6, SSIS

Operating Systems: Windows 2000/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

MicroStrategyReport/Dashboard Developer, Architect

Environment: MicroStrategy Desktop 10.4,Intelligence Server,Web,SQL server

Responsibilities:

• Communicating directly with Clients and Gathering user requirements.
• Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
• Identified and CreatedPublic ObjectslikeMetrics, Compound Metrics, Prompts, Filtersusing MicroStrategyDesktop.
• Creating Reports usingConsolidations,Custom GroupsandDrill maps.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performed the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats
• Creating Reports usingIntelligent Cubes.
• Designed various Grid and Graph reports and Dashboards based on customer requirements.
• Optimized reports for better performance using VLDB properties.

Confidential

MicroStrategyReport/Dashboard Developer, Architect

Environment: MicroStrategy Desktop 10.4,Web,Netezza.

Responsibilities:

• Communicating directly with Clients and Gathering user requirements.
• Creating Functional and Technical Design Documents as an input to application design business solution components.
• Creating Report mockups and templates from business requirements.
• Creating Projects, Configuring Database Instances and Importing tables using Warehouse Catalog.
• Configuring Projects with Multi-Source Database Instances as data coming from multiple servers.
• Creating MicroStrategy Schema and Application objects such as Attributes, Facts, Transformations, Metrics, Prompts, Filters, Drill Maps, Consolidations and Custom groups.
• Creating complex MicroStrategy reports using Advanced Filters, Level Metrics, and Transformation Metrics and using Pass-Through Functions in the schema objects.
• Designing various Report Services, Dynamic Dashboards based on Customer Requirements
• Creating Reports usingIntelligent Cubes.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performing the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats.
• Troubleshooting and tune MicroStrategy reports to determine and fix data issues, incorrect joins and performance issues.

Confidential

MicroStrategyReport/Dashboard Developer, Architect

Environment: MicroStrategy Desktop 9.4.1,Web,SQL Server 2012.

Responsibilities:

• Communicating directly with Clients and Gathering user requirements.
• Creating Functional and Technical Design Documents as an input to application design business solution components.
• Creating Report mockups and templates from business requirements.
• Creating Projects, Configuring Database Instances and Importing tables using Warehouse Catalog.
• Configuring Projects with Multi-Source Database Instances as data coming from multiple servers.
• Creating MicroStrategy Schema and Application objects such as Attributes, Facts, Transformations, Metrics, Prompts, Filters, Drill Maps, Consolidations and Custom groups.
• Creating complex MicroStrategy reports using Advanced Filters, Level Metrics, and Transformation Metrics and using Pass-Through Functions in the schema objects.
• Designing various Report Services, Dynamic Dashboards based on Customer Requirements
• Creating Reports usingIntelligent Cubes.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performing the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats.
• Troubleshooting and tune MicroStrategy reports to determine and fix data issues, incorrect joins and performance issues.

Confidential

MicroStrategyReport Developer

Environment: MicroStrategy Desktop 9.4.1,Intelligence Server,Web,SQL Server 2012.

Responsibilities:

• Going through Functional Requirement Documents and Understanding the User Requirements.
• Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
• Identified and CreatedPublic ObjectslikeMetrics, Compound Metrics, Prompts, Filtersusing MicroStrategyDesktop.
• Creating Reports usingConsolidations,Custom GroupsandDrill maps.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performed the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats
• Creating Reports usingIntelligent Cubes.
• Designed various Reports and Dashboards based on customer requirements.
• Optimized reports for better performance using VLDB properties.
• Created and Performed Unit Test Cases.

Confidential

MicroStrategyReport Developer

Environment: MicroStrategy Desktop 9.4.1,Intelligence Server,Web,Oracle 10g

Responsibilities:

• Going through Functional Requirement Documents and Understanding the User Requirements.
• Created Schema Objects like Attributes, Facts, and Hierarchies using MicroStrategy Architect.
• Identified and CreatedPublic ObjectslikeMetrics, Compound Metrics, Prompts, Filtersusing MicroStrategyDesktop.
• Creating Reports usingConsolidations,Custom GroupsandDrill maps.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performed the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats
• Creating Reports usingIntelligent Cubes.
• Designed various Grid and Graph reports and Dashboards based on customer requirements.
• Optimized reports for better performance using VLDB properties.
• Created and Performed Unit Test Cases.

Confidential

MicroStrategyReport Developer

Responsibilities:

• Going through Report Specification Documents and Understanding the User Requirements.
• Identified and CreatedPublic ObjectslikeMetrics, Compound Metrics, Prompts, Filtersusing MicroStrategyDesktop.
• Creating Reports usingConsolidations,Custom GroupsandDrill maps.
• Creating Complex grid reports with OLAP and drill capabilities.
• Performed the report data manipulations using various options like:Data Pivoting, Page by, Sorting, Totals, and Thresholdsetc.
• CreatedTransformations for comparative reports like sales this year to date, Month to date, Quarter to date etc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats
• Creating Reports usingIntelligent Cubes.
• Designed various Grid and Graph reports and Documents based on customer requirements.
• Created and modified schema objects (facts, attributes and hierarchies) using MicroStrategy Architect.
• Optimized reports for better performance using VLDB properties.
• Created and Performed Unit Test Cases.

Confidential

MicroStrategy ReportDeveloper

Responsibilities

• Going through Report Specification Documents and Understanding the User Requirements.
• Identified and CreatedApplication objectslikeMetrics, Compound Metrics, Prompts, Filtersusing MicroStrategyDesktop.
• Creating Reports usingConsolidations,Custom groupsandDrill maps.
• Performed the report data manipulations using various options like:Data pivoting, Page by, sorting, totals, thresholdsetc.
• CreatedTransformations for comparative reports like sales this year to date, Month to date, Quarter to date etc.
• Created Customized Auto Styles to allow reports inMicroStrategyDesktop andMicroStrategyWeb to apply customized formats
• Creating Reports usingIntelligent Cubes.
• Designed various Grid and graph reports and Documents based on customer requirements.
• Created and modified schema objects (facts, attributes and hierarchies) using MicroStrategy Architect
• Optimized reports for better performance using VLDB properties.