SUMMARY

• Over 6 years of experience in Data warehousing and Business Intelligence concepts.
• Extensive experience in creating and integrating MicroStrategy reports and objects (Facts, Attributes, Filters, Metrics and Prompts) with the data warehouse.
• Expert in creating dynamic dashboards and scorecards including mobile dashboards for iPad and iPhone.
• Experience in communicating with business users in gathering information, designing, developing, administrating and maintaining MicroStrategy based reporting applications.
• Experience in creating various Schema objects like Hierarchies, Attributes and Facts, Transformations using Star and Snowflake Schemas.
• Hands on experience on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Efficient work experience in creating complex reports in MicroStrategy Desktop and Web user interfaces using key features like Templates, Filters, Prompts and advanced Metrics.
• Designed Flash Dashboards which involves the new features like Widgets and Selectors.
• Implemented MicroStrategy on various operating systems like Windows and UNIX.
• Proficient in using Microsoft Office tools like Word, Excel and Visio.
• Sound working knowledge of 2 - Tier client/server architecture and 3-Tier architecture.
• Experience in developing SQL queries and stored procedures.
• Excellent communication and inter personnel skills.
• Exceptional ability to learn and master new technologies.
• Ability to deliver outputs in short deadlines.
• Ability to change and adapt to the work environment, and can handle multiple projects simultaneously.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy Desktop 9.x/8.x/7.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Mobile.

Databases: MS Access 2007, MS SQL Server, Teradata, DB2, Oracle.

Operating System: Windows (NT/XP/ 2000/2003/2008 Client/Server), AIX, Red Hat Linux 5.6.

PROFESSIONAL EXPERIENCE

MicroStrategy Developer

Confidential - Naperville, IL

Responsibilities:

• Interact with the Business Users to gather requirements for Dashboards.
• Identified the Facts, Attributes that goes in the Dashboard and documented the Technical specification.
• Worked on installing MicroStrategy products on client machines based on roles and privileges.
• Involved in upgrading MicroStrategy versions from 9.2.1 to 9.3.
• Used MicroStrategy Desktop 9.2.1 to build schema objects like Hierarchies, Transformations, Attributes and Facts.
• Developed Flash Dashboards for multiple business clients using custom widgets, panels, selectors and flash visualizations.
• Created custom Dashboards and score cards for iPhone & iPad.
• Interacted with the respective teams and identified the source tables need to pull from the Data Warehouse.
• Created Prototype Dashboards and presented to the user group for user acceptance.
• Worked on formatting selectors, changing their fonts, background colors, gradients, borders etc.
• Created Analytic-based selectors grid/graphs that control other grid/graphs through a panel stack.
• Insert as many panels as needed within a panel stack.
• Rename panels, change their order, and format their individual background colors.
• Worked on changing borders of a panel stack and formatting the font and background color of the title bar.
• Provided training to the users, created documents for the users, involved in customer support and stabilize the report in production environment.

Environment: MicroStrategy 9.2.1/9.3 (Architect, Object Manager, Web, Administrator, Enterprise Manager, Narrowcast), MicroStrategy Mobile, Windows XP Professional, MS SQL Server.

MicroStrategy Developer

Confidential, Freeport, NY

Responsibilities:

• Worked with business requirement analysts in gathering business requirements and analyzing report specification documents.
• Extensively worked on creating weekly, monthly and yearly sales reports and created dashboard and scoreboard reports for easy visualization.
• Involved in Dimensional Modeling by choosing the business process, stating the grain, and selecting the dimensions and facts.
• Developed Schema Objects like Facts, Attributes, Hierarchies and Transformations using MicroStrategy Architect.
• Analyzed and developed Application Objects like Metrics, Reports, Documents, filters and prompts using MicroStrategy Desktop and web interfaces.
• Created simple, nested & compound metrics.
• Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Involved in slice and dice of data by developing Intelligent Cubes in version 9.x.
• Involved in tuning MicroStrategy Intelligence Server for better performance.
• Worked as backup administrator in charge in adding new users to groups and assigning them security privileges.
• Used MicroStrategy Report Services to generate Report Documents.
• Created various Monthly Dynamic Dashboard documents using features like multiple panel stacks, selectors and customized widgets.
• Created types of reports including Enterprise reports, Dashboard analysis reports and Ad-hoc reports to show the end users.
• Understand the type of schemas that best support MicroStrategy in different scenarios.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.0x, 8.0x, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Windows 2000/NT and UNIX, MS SQL Server.

MicroStrategy Developer

Confidential - Rochester Hills, MI

Responsibilities:

• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Created the requirements Documentation and also documented the MicroStrategy Environment.
• Developed facts, attributes, hierarchies, tables using MicroStrategy Architect.
• Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Created Freeform SQL reports, reports services documents and HTML documents.
• Developed Customized and Ad-hoc reports using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations.
• Involved in developing complex reports through Micro Strategy Desktop.
• Involved in Enterprise Manager Activities like generating reports based on system performances and user analysis.
• Experience on User Manager by Creating, modifying MSTR Users Accounts.
• Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings
• Developed Real Time, Daily and Monthly Reporting.
• Provided post production support to end-users.

Environment: MicroStrategy 9.0x, Narrowcast Server, Intelligence Server, Web, Administration, MS SQL Server, Teradata.

MicroStrategy Developer

Confidential

Responsibilities:

• Involved in creating, supporting and upgrading queries for production database.
• Extensively interacted with the Database experts in understanding the Source System and efficient translationof technical data to Business terms through self-developed design templates.
• Worked on relationship tables to avoid Many-Many relationship in between parent and child attributes.
• Worked on level of dimensionality to include all the metrics in the same report.
• Worked on conditional formatting and Thresholds to put conditions on metrics.
• Created and inspected MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groupsin reports and documents using MicroStrategy Desktop.
• Worked on development of overall program performance dashboards at summary level and detailed level.
• Involved in using Advanced Prompts, Conditional, Transformation and Level Metrics for creating complex reports.
• Created user groups, roles, privileges using MicroStrategy Command Manager.
• Created users in MicroStrategy Desktop for testing reports on Web.
• Extensively involved in creating Dashboards and Documents based on Intelligent Cubes for the project.

Environment: MicroStrategy 8.1, MicroStrategy Web, Report Services, Informatica 6.2, SQL Server 6.x, Oracle databases, UNIX.

MicroStrategy Developer

Confidential

Responsibilities:

• Gathered and analyzed business requirements from clients and End-users.
• Developed the logical and physical data models, created data definition language statements and worked with database administrators to transition these models to database administrators for successful physical implementation.
• Created filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Generated Key Performance Indicators metrics and complex metrics.
• Documented MicroStrategy objects like reports, prompts, filters and metrics for user reference using project documentation feature.
• Created corporate level Dashboards in Interactive modes using different kinds of Selectors and widgets.
• Created Intelligent Cubes in solving performance issues.
• Involved in design, development and maintenance of reports, also involved in data validation, analysis, testing and debugging.
• Worked with table aliases, level metrics, transformations and custom groups.
• Involved in MicroStrategy Administration tasks like creating new users, roles, assigning privileges, shared folders and access controls Lists.
• Worked along with MicroStrategy Knowledge Base to troubleshoot any Report related issues.

Environment: MicroStrategy 8.1 (Desktop, Web, Intelligence Server, Report services), Windows 2003, DB 2.

ETL/MicroStrategy Developer

Confidential

Responsibilities:

• Interacted with the business teams, data-modeling and ETL teams in various levels for the development of the reports.
• Worked as MicroStrategy developer for the full lifecycle of the data-warehousing project from requirement gathering from business to rollout.
• Developed reports using MicroStrategy 8.0/8.1, created users, roles and privileges on monitored and tuned SQL queries.
• Created the design and development of the reports.
• Consolidated reports that are similar and developed using stored procedures.
• Created schema objects like Attributes, Metrics, security filters and other report objects, also defined hierarchies using MicroStrategy Desktop.
• Creation of Project Design and Schema Objects in MicroStrategy Architect.
• Designed and Developed Complex and large MicroStrategy Reports in MicroStrategy Desktop.
• Designed and developed Dashboards using MicroStrategy Report Service Documents for various products and services
• Development of dashboards and scorecards for management reporting using Report Services.
• Delivered the dashboards as per the user requirements.
• Monitored and ensured the project progress and prepared status reports.

Environment: MicroStrategy 8.0/8.1 (Administrator, Desktop, Architect, Intelligence Server, Narrowcast Server, Web), Windows 2000, SQL Server 2005.