SUMMARY

• 6+ years working with MicroStrategy Report Development lifecycle
• 5+ years working with MicroStrategy Report Document Services document delivery
• 5+ years of experience with Enterprise Data Warehousing
• 3+ years working with MicroStrategy Mobile Dashboard document delivery
• Hands - on experience with MicroStrategy 9.x/8.x/7.x, and MicroStrategy product suite (Desktop, Web, Intelligence Server, Narrowcast Server, Mobile), Report development, Report performance tuning & Document creation.
• Hands-on experience in developing interactive dashboards and Report Services documents.
• In-depth knowledge of data modeling concepts, including Star and Snowflake schemas and ROLAP.
• Working proficiency in SQL and Relational databases (Oracle, DB2, SQL Server, and Teradata).
• Skilled in Dimensional Modeling and ability to provide input in model development.
• Involved in creating projects those connected to Warehouse and Metadata Repository through a 3-tier architecture involving MicroStrategy Intelligence Server.
• Specialized in complete systems development life cycle.
• Expertise in setting VLDB properties, to fine tunes the reports, by customizing the SQL.
• Experience on working with Object Manager, Command Manager, Integrity Manager and Enterprise Manager.
• Experienced in using MicroStrategy Administrator tools and services.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 9.2.1/9.0.1 (MicroStrategy Desktop, Web, Intelligence Server, Business Objects, Narrowcast server)

RDBMS: Oracle 10g/9i/8i, SQL server, Teradata, DB2, Sybase, MS Access.

Languages: SQL, PL/SQL, C, C++, HTML, CSS, XML, Java, Shell Scripting.

Operating systems: Windows 98/NT/2K/XP/Vista/7, MS-DOS, UNIX/LINUX.

Database client tools: Toad for Oracle.

Design Tools: Adobe Photoshop, Microsoft FrontPage.

ETL tools: Informatica Power center, DataStage.

Packages: C#.Net, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

MicroStrategy Developer

Responsibilities:

• Designed and developed presentation objects, reports, and dashboards for delivery of BI solutions.
• Defined, implemented and refined the BI solution development methodology based on industry best practices.
• Developed technology specifications and ensured that any new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible.
• Applied architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability.
• Configured, maintained, and administered MicroStrategy models, packages, reports, and dashboards.
• Monitored and supported multiple jobs, scripts, and events.
• Deployed and supported MicroStrategy reports, ad-hoc packages, and In-memory cubes.
• Continually monitored and tuned the performance of the platform.
• Developed standard OLAP features such as intelligent cubes (I Cubes), data aggregation, derived metrics, Banding, Aliasing, Page by, Pivoting, Sorting, Thresholds and Subtotals.
• Trained different types of end users on MicroStrategy desktop and Web; supported huge number of users.
• Worked extensively on MicroStrategy Narrowcast Server to deliver scheduled reports using Static and Dynamic Subscriptions.
• Optimized tables, views and SQL definitions using indexing to enhance performance.
• Worked on Setting up user accounts, building security models and privileges, migration of objects from different environments, and performance monitoring of the MicroStrategy tool.

Environment: MicroStrategy 9.2.1/9.0.2 Product Suite (Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Command Manager, Web, Mobile), TeradataV2R6, Oracle 11g, DB2, DataStage, Informatica 8.6.1, Windows NT, UNIX and Toad.

Confidential, Mooresville, NC

MicroStrategy Developer

Responsibilities:

• Developed MicroStrategy schema and applications objects such as attributes, metrics, prompts, filters, templates, compound metrics, custom groups and consolidation, security Filters and transformation Metrics.
• Defined the relationship between the attributes, facts and other objects within MicroStrategy.
• Defined Hierarchies and drill functionality within MicroStrategy.
• Designed, developed and maintained MicroStrategy reports using standard features such as sort, rank, report filters, view filters, drill up, drill down and prompts.
• Developed complex MicroStrategy reports using advanced filters, conditional formatting, transformation metrics, level metrics and custom groups.
• Designed, developed and maintained MicroStrategy Mobile Dashboards using graphs, panel stacks, selectors, widgets, swipe and tap functionality.
• Troubleshoot and tuned MicroStrategy reports to determine and fix data issues, incorrect joins, incorrect results and performance issues.
• Coordinated with different teams to deploy the MicroStrategy changes between environments.
• Implemented user level security, object security, user roles and groups, create, modify and delete users, govern thresholds, set up distribution services using Narrowcast Server, install and configure MicroStrategy Desktop.
• Troubleshoot performance alerts, application availability alerts, system utilization alerts, delivery issues with Narrowcast reports and other similar issues with Intelligence Server, Narrowcast Server, Web Server and Mobile Server.

Environment: MicroStrategy 9.0.2/8.1.2 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Web, Mobile), Teradata, SQL Server 2008, Informatica, Windows NT, UNIX and Toad.