SUMMARY

• Having 6+ years of IT experience wif focus on Business Intelligence systems. involved in various stages of the 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 the Intelligence Cube Solutions.
• Involved in creating, implementing and maintaining Dashboards, KPIs and Scorecard Reports on the 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 the 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 the 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 the web.
• Involved Confidential all stages of the data warehousing project, setting up the schema, and architecture, developing reports, security and deploying to end users.
• Worked closely wif the business to Gather, Review, Validate and Document the 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 the 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 the logical model
• Performed testing of all reports for the 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 the 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 the reports and average run time of the reports.
• Troubleshooting report and data issues and supporting the users in problem resolution.
• Developed the logical and physical data models, using different kinds of graphs and widgets to satisfy the client requirements.
• Created Transformations for using in comparative reports like revenue dis year to last year.
• Created Intelligent Cubes to solve the performance issues.
• Hands on experience working wif Visual Insight Dashboards.
• Defining Drill Hierarchies and creating relationship between attributes.
• Involved in using the Object Manager to move the objects from Development to Production Environment inMicroStrategy.
• Used free form SQL editor for complex report creation.
• Used the Object Manager to migrate the 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 the 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 the 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 the 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 the user roles to limit the access to the data.
• Performed troubleshooting tasks on MicroStrategy web reports, optimized query performance using the 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 the Architect team to import the 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 the in-house Business Requirements.
• Extensively used different types of filters, consolidations and custom groups to generate the reports for Business analysis.
• Extensively used different prompts, to point out the objects in report level.
• Generated reports by using schema objects like attributes, facts, hierarchies and transformations.
• Worked on thresholds to achieve the client requirements.
• Worked on drilling options like drill down and drill up in the 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 the 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 the 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 the report data
• Involved in creatingMetrics, filters and Promptsin MicroStrategy Desktop environment.
• Created weekly, monthly reports for the 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 the performance of the reports by tuning the 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 the 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 the last year actual transactions, week to day, week to period, week to quarter and week to year effectively using them wif the 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 the 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