SUMMARY

• Having 6+ years of IT experience wif focus on Business Intelligence systems. involved in various stages of teh Software Development Life Cycle (SDLC) from requirements gathering, analysis, modelling, design, development, enhancement, test and production.
• Proficient experience using MicroStrategy 9.x product suites including MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Mobile, Visual Insight MicroStrategy Architect, MicroStrategy Administrator.
• Strong noledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi - dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Extensive experience in creation of public Objects Namely Metrics, Filters, Prompts, Custom Groups, Consolidations, Drill Maps, Search Objects, Reports and Documents.
• Created Drill down Reports and Intelligence Cubes.
• Worked on Conditional Metrics, Level metrics and advanced prompts for creating advanced reports.
• Experience in building teh Intelligence Cube Solutions.
• Involved in creating, implementing and maintaining Dashboards, KPIs and Scorecard Reports on teh web.
• Worked on Administration tools like Job Monitor, User Manager, Cache Manager, Enterprise Manager Object Manager, Command Manager, Integrity Manager and Schedule Manager.
• Work closely wif teh ETL team to design data. noledge of MicroStrategy security features such as ACLs, Roles, and Filters.
• Strong noledge in Industry, Retail and Health care.
• Having Good experience in Agile Software Development.
• Accomplished System Optimization, Performance Monitoring and Tuning in MicroStrategy Business Intelligence environment.
• Installing, configuring of all MicroStrategy activities including MicroStrategy Desktop, Administrator, Intelligence Server, Web and MicroStrategy Narrowcast Server on NT Servers and mapping to client machines.
• Interacted in defining MicroStrategy Narrowcast Server objects like Service, Schedule, Subscription Set and Information Objects.
• Involved in designing of MicroStrategy metadata.
• Interacted wif teh Database Team to design and implement schemas which efficiently and accurately through MicroStrategy.
• Created Interactive and visualization Dashboards.
• Adept in Dash Boarding and Documents, worked extensively on panel stacks, widgets and customized teh web.
• Involved Confidential all stages of teh data warehousing project, setting up teh schema, and architecture, developing reports, security and deploying to end users.
• Worked closely wif teh business to Gather, Review, Validate and Document teh Business Requirements.
• Trained and Provided technical guidance to junior developers.
• Strong skills of working wif databases like SQL Server 2008/2005, PL/SQL, Oracle SQL.
• Ability to quickly master new concepts, be an effective team player, strong written and verbal communication/interpersonal skills and self-motivated.

TECHNICAL SKILLS

BI Reporting Tools: MicroStrategy Product Suite (Architect, Administrator, Desktops, Web, Narrowcast and Mobile)

Databases: Oracle, MS SQL Server

Operating Systems: Windows 7, Windows Server

Languages: SQL, HTML, XML

Methodologies: Star Schema, Snow Flake Schema.

ETL Tools: Informatica

Concepts: Data Warehousing, Business Intelligence

Business Domains: Industry, Health, Telecom, Insurance

PROFESSIONAL EXPERIENCE

MicroStrategy Developer

Confidential

Responsibilities:

• Designed & Worked extensively on creating procedures and tables for Transactional Services Reports.
• Created Dashboards for Business Leaders, Business Managers to access on iPhone and iPad.
• Generated advanced reports in Grid, Graph, and SQL mode, consisting of data analysis by combining a template wif filters using MicroStrategy Desktop.
• Created reports depends on Forecast Amount and Billed Amount.
• Involved in defining and designing teh Report Templates.
• Developed Public Objects like filters, prompts, metrics, templates, consolidations, custom groups etc.
• UsedMicroStrategyDeveloperto build schema objects Hierarchies, Transformations, Attributes, Facts and relationships as a function of teh logical model
• Performed testing of all reports for teh final deployment.
• Created template reports using advanced prompts like object prompts, expression prompts, filters.
• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for theMicroStrategyplatform.
• Worked on Production issues queue, performance tuning of teh reports.
• Used Object Manager to deploy MicroStrategy objects from development in to Sandbox and Production environments.
• Worked on Enterprise Manager Reports & Dashboards to analyze customer usage of teh reports and average run time of teh reports.
• Troubleshooting report and data issues and supporting teh users in problem resolution.
• Developed teh logical and physical data models, using different kinds of graphs and widgets to satisfy teh client requirements.
• Created Transformations for using in comparative reports like revenue dis year to last year.
• Created Intelligent Cubes to solve teh performance issues.
• Hands on experience working wif Visual Insight Dashboards.
• Defining Drill Hierarchies and creating relationship between attributes.
• Involved in using teh Object Manager to move teh objects from Development to Production Environment inMicroStrategy.
• Used free form SQL editor for complex report creation.
• Used teh Object Manager to migrate teh objects from Development to UAT/Production environment in MicroStrategy.

Environment: MicroStrategy9.4.1 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), SQL Server 2008, Windows 7

MicroStrategy Developer

Confidential

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Logical Schema design in MicroStrategy.
• Extensively worked wif MicroStrategy Desktop. Extensive experience in building Filters, Consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generate reports meeting teh Business Analyst needs.
• Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Expertise in using teh Architect in desktop.
• Creation of Canned Reports, Ad-hoc reports, Free form reports, Transaction reports.
• Creation of Dynamic Dashboards, Documents, Mobile Dashboards.
• Well Versed Using Panel Stacks as Information window.
• Versatile in working on Bubble Grid, Heat Maps, Data Cloud Widgets, Time Series widgets etc.
• Involved in different administration tasks such as creating Users, Security Roles and assigning different access rights to teh Users.
• Worked on Command manager to create Some Users and assign User Privileges.
• Responsible for various Performance tasks like Tuning, Caching, assigning Query, Governing Settings, and report Optimization.
• Worked Document Caches and Intelligent Cube reports to Improve Dashboard Performance.
• Set up schedules for various Reporting Objects, Cache clearing & Intelligent Cube refresh.

Environment: MicroStrategy9.4 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), SQL Server 2008/2012, Microsoft Excel 2010.

MicroStrategy Developer

Confidential, GA

Responsibilities:

• Installation and Configuration of MicroStrategy Suite.
• Expertise in creating MicroStrategy dashboards, reports, applications and schema objects (Attributes Facts, Filters, Hierarchies, Metrics, Prompts, Custom Groups, and Consolidations).
• Created Adhoc reports using prompts for selection of Concept, time periods and weeks.
• Extensively worked in developing Metrics, Compound Metrics and Filters for complex reporting.
• Set up new security filters for teh user roles to limit teh access to teh data.
• Performed troubleshooting tasks on MicroStrategy web reports, optimized query performance using teh VLDB Properties.
• Created transformations for YTD (year to date), MTD (month to date), and WTD (week to date), YTM (Year to Month), PYTM (Previous Year to Month) analysis.
• Migration of projects, reports and Objects between Development, QA and Production environments using Object Manager.
• Designed, Developed and Maintained MicroStrategy Mobile Dashboards using graphs, panel stacks, selectors, widgets, swipe and tap functionality.
• Interacted wif teh Architect team to import teh necessary tables to create schema Objects. Interactive Dashboards inMicroStrategywif various functionalities like Drill down, Link, Thresholds, Information View, and Selectors etc.

Environment: MicroStrategy9.3, Intelligence Server, Web, Administration, SQL Server 2005 and 2012, Windows 7.

MicroStrategy Developer

Confidential, VA

Responsibilities:

• Involved in all phases of SDLC.
• Used MicroStrategy Desktop in creating different Reports to meet teh in-house Business Requirements.
• Extensively used different types of filters, consolidations and custom groups to generate teh reports for Business analysis.
• Extensively used different prompts, to point out teh objects in report level.
• Generated reports by using schema objects like attributes, facts, hierarchies and transformations.
• Worked on thresholds to achieve teh client requirements.
• Worked on drilling options like drill down and drill up in teh report level, to move from one report to another report.
• Coordinated activities offshore towards meeting project timelines.
• Involvement in application maintenance activities and implementation.
• Documented all teh user requirements and configured.
• Providing support to QA and Production.

Environment: MicroStrategy9.3.1((Desktop, Web, Architect, Administration, MSTR Tools), Narrowcast Server, Oracle, Windows XP and Windows Server.

BI Report Developer

Confidential

Responsibilities:

• Going through Business Requirement Specification Documents and Understanding User Requirements.
• Analyzing teh Requirement and Preparing Technical Design Documents
• Developed Public Objects (filters, prompts, and metrics, Custom Groups, Consolidations) to develop reports.
• Created View filters, Report Limits on teh report data
• Involved in creatingMetrics, filters and Promptsin MicroStrategy Desktop environment.
• Created weekly, monthly reports for teh management team and field operation managers using
• Micro Strategy Desktop.
• Developed transformations to generate reports of type sales dis period to sales dis period last year and so on using transformations.
• Worked on Export of MSTR objects, Reports and dynamic dashboards into Flash mode, HTML, PDF and MS Office formats.
• Increased teh performance of teh reports by tuning teh SQL.
• Extensively used VDLB properties for better performance for large reports.

Environment: MicroStrategy9,MicroStrategyDesktop(Architect),MicroStrategyWeb, MicroStrategyIntelligence Server,MicroStrategyMobile, Narrowcast Server, SQL, Teradata, SQL server.

BI Report Developer

Confidential

Responsibilities:

• Extensively created filters, facts, Consolidations, Transformations and Custom Groups using MicroStrategy Desktop to generate reports for teh Business analysis.
• Used pass-through functions (apply simple and apply comp) in attributes and filters definitions.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational and Compound), Filters, Prompts, Templates and Reports.
• Created different Transformations to get teh last year actual transactions, week to day, week to period, week to quarter and week to year effectively using them wif teh metrics.
• Created ad-hoc reports by drilling up, down, wifin and across dimensions.
• Optimized Query Performance by using VLDB settings Confidential report level.
• Created various Monthly Dynamic Dashboard documents for teh decision makers wif multiple panel stacks, selectors and widgets.

Environment: MicroStrategy9, Intelligent Server, Narrowcast Server, OLAP Services, MicroStrategy Desktop,MicroStrategyWeb, Oracle, Windows Server, Windows XP