SUMMARY

• Over 7+ years of strong experience in MicroStrategy 9.x/8.x/7.x, MicroStrategy Desktop, Microstrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence server,
• Familiar with Intelligence Server and Narrowcast Server installation and configuration process
• Knowledgeable in business functionality for developing multidimensional modeling (Data Modeling).
• Delivered reports in Desktop and Web and via Narrowcast Server to multiple users
• Experience in Schema design and creating Schema objects using Star and Snowflake (Hierarchies, Attributes and Facts, Transformations).
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad - hoc, scheduling report delivery and Alerts.
• Extensive experience on all types of Microstrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Proficient in SQL Command, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters
• Good understanding of RDBMS - Teradata, Oracle, and SQL server
• Experience in using Project Merge, Object Manager, and Enterprise Manager.
• Extensive Microstrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web components
• Excellent experience configuring VLDB properties to fine-tune reports.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment.
• Experience training non-technical users and providing customer support.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy Desktop 7x/8x/9.0 (Microstrategy Desktop, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services Documents, Dynamic Dashboards, Microstrategy Narrowcast Server, Enterprise Manager)

Databases: Oracle 8i/9i/10g, TeraData, Sql Server, Ms-Access

Languages: SQL, PL/SQL, HTML, XML

Platforms and Web Servers: Windows NT/ 95/98/2000/2003 , MS-DOS, Internet Information Server (IIS) 5.x.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Micro Strategy Developer

Responsibilities:

• Gather requirements by interacting with senior managers and users for design of reports.
• Participate in BI team meetings to discuss the user requirements.
• Create logical data models, recognize source tables and columns, and build Schema objects, Application objects necessary for creation of a MicroStrategy project.
• Create Complex grid reports with OLAP and drill capabilities.
• Architected schema objects such as Attributes, Facts and Transformations.
• Generate grid and graph reports by using appropriate Facts, Attributes,, Level Metrics, Advance filter.
• Created reports with various object prompts to generate various Ad hoc reports.
• Design Interactive Dashboards in MicroStrategy Web to assess company’s performance and monitor the overall goals of the business.
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Create standardized reports (Canned reports) and Report Services documents for users.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the inner join, outer join, nulls and zeroes
• Performed creating Derived metrics, compound metrics using apply simple. Apply complex, smart metrics, enabling dynamic aggregation.
• Used Transformations (table based, formula based) for comparative reports for Investment Operations.
• Production support, trouble-shooting and fixing of reports was done in record time.

Environment: MicroStrategy 9.2.1 (Architect, Intelligence server, SDK, Web, Web Universal, Narrowcast server, Desktop), Report Services, Oracle 10G, Toad for Oracle version 8.6.1, Informatica Power center 8.1.1, SQL Server 2005, ERWIN, Microsoft Visual SourceSafe 6.0 and Windows Server 2003

Confidential, OH

Sr Microstrategy Report Developer

Responsibilities:

• Extensively involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users.
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Designed Interactive Dashboards in MicroStrategy Web to assess company’s performance and monitored the overall goals of the business.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using MicroStrategy Desktop and MicroStrategy web.
• Created Facts, Attributes and Hierarchies using the MicroStrategy Architect.
• Developed various Metrics, filters, consolidations, custom groups and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Involved in customization of MicroStrategy Web.
• Involved in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Involved in creating various transformations to analyze different metric values in this year to last year using MicroStrategy Architect.
• Involved in performing various analysis using the MicroStrategy Desktop.
• Created complex n-level nested prompts, filters and reports to enable business analysis
• Optimized the performance of the Microstrategy platform by implementing suitable report design processes, SQL tuning, VLDB settings
• Designed Freeform SQL reports for meeting specific needs.
• Production support, trouble-shooting and fixing of reports was done in record time

Environment: Micro Strategy 9.x/8.5 (Architect, Intelligence server, Web, Web Universal, Narrowcast server, Desktop), Report Services,, and Windows Server 2003, PL SQL

Confidential, NJ

MicroStrategy Developer

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Generated reports for the cooperation for Assets period to period.
• Delivered documents for Financial Analysis, Statements and Summary, Customer lifetime value and Customer loyalty.
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Createdlogical data models to recognize source tables and columns, to buildMicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationshipsnecessary to createMicroStrategyproject.
• Team member for the upgrade from 8.0.1 to 9.0
• Developed Flash Dashboards & Scorecards in MicroStrategy 9 using Widgets and Selectors for summary level reporting
• Created joins and relationship according to the data model Schema.
• Identify and modified source tables and columns in the warehouse required creating the MicroStrategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options like simple and advanced.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Involved in various back end ETL development tasks and Production Support.

Environment: MicroStrategy 8.0.1/, MicroStrategy Desktop 8.x/9, SDK, MicroStrategy Web 8.x/9, MicroStrategy Intelligence Server 8.x/9, MicroStrategy Narrowcast Server, IIS, SSL, ERWIN 4.0, TOAD 7.0, Microsoft Visual SourceSafe 6, Informatica Power Center 5.1, Teradata V2R5, Oracle 11i, Windows XP.

Confidential, IL

MicroStrategy Report Developer

Responsibilities:

• Worked on requirements gathering from the clients and estimation of efforts including analysis of existing system and analysis of data.
• Designed and developed the environment to generate reports. Extensively worked on Logical Data Modeling, Installing and setting up of Microstrategy Intelligence server and Web servers. Involved inClustering of servers. Developed DTS packages to populate SQL Server warehouse and Oracle databases..
• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Created Complex metrics, Nested Filters, Nested Prompts Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Used apply functions like apply simple to meet the report requirements wherever necessary.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Used several widgets for Dashboard like Funnel, Gauge, Heat maps for reporting.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in Microstrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Provided access to the Data Warehouse to a much larger audience by using Narrowcast Server. The reports and Information have been personalized as per the user requirements
• Performing all the administration tasks like Monitoring and Analyzing the system usage and managing the projects. And using the Command Manager to purge the caches on database loads.
• Used free form SQL editor for complex report creation to get the data from the Data warehouse
• Fixed Defects and performed upgrades for existing projects.

Environment: Microstrategy 8.1(Administrator, Architect, Desktop, Narrowcast sever, Object Manager), Oracle 9i, SQL Server 2005, Informatica 6.2, Windows XP Professional.

Confidential, GA

MicroStrategy Report Developer

Responsibilities:

• Involved in gathering of business requirements.
• Architected schema objects such as attributes, facts and transformations.
• Created various metrics using statistical functions.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be re-used to build any number of metrics.
• Involved in defining and designing the Report Templates.
• Created MicroStrategy application Objects that included Conditional and Compound Metrics, Embedded, Dynamic and Relationship Filters, Filter and Object Prompts, Templates, and Reports
• Using Object manager to move objects between Development and production projects
• Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings.
• Architected schema objects such asattributes, facts and transformations.
• Created variousmetricsusingstatistical functions.
• Createdreportswith variousobject promptsto generate various Ad hoc reports.
• Optimized theIntelligence Serverfor better performance.
• Created various report services andDashboarddocumentson salessent monthly to vendors.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.

Environment: MicroStrategy 7.5 (Desktop, Administrator, Web), MicroStrategy Intelligence Server 8.1.1, ERWIN, Informatica, TOAD, SQL Loader, Teradata, Oracle 8i, Windows XP/2000.