SUMMARY:

• IT experience with 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.
• Experience using product suites including MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Mobile, Visual Insight MicroStrategy Architect, MicroStrategy Administrator.
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi - dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Expertise in Desktop creating and integrating MicroStrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations.
• Worked extensively on VLDB Properties for performance tuning.
• Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built on flex for specialized dashboard.
• Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data Mart Reports, Partition Mappings and Aggregate tables.
• Experience in MicroStrategy development, Query Performance Tunings and Data Modeling
• Exposure to Oracle SQL, SQL/PLSQL.
• Hands on experience on relational databases and data modeling.
• 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.
• Worked on Administration tools like Job Monitor, User Manager, Cache Manager, Enterprise Manager Object Manager, Command Manager, Integrity Manager and Schedule Manager. knowledge of MicroStrategy security features such as ACLs, Roles, and Filters.
• 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 with the Database Team to design and implement schemas which efficiently and accurately through MicroStrategy.
• Involved at all stages of the data warehousing project, setting up the schema, and architecture, developing reports, security and deploying to end users.
• Worked closely with the business to Gather, Review, Validate and Document the Business Requirements.
• Worked on Industry, Retail, Banking, Finance and Health care Domains.
• Trained and Provided technical guidance to junior developers.
• 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, Teradata, SQL Server

Operating Systems: Windows 7, Windows Server

Languages: SQL, PLSQL, HTML, XML

Methodologies: Star Schema, Snow Flake Schema.

Concepts: Data Warehousing, Business Intelligence

Business Domains: Industry, Health, Telecom, Insurance

PROFESSIONAL EXPERIENCE:

MicroStrategy Developer

Responsibilities:

• 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 with filters using MicroStrategy Desktop.
• 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.
• 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 this year to last year.
• Created Intelligent Cubes to solve the performance issues.
• Hands on experience working with 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, 10.x (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), SQL Server, SQL, Windows, MS-Access

Confidential, Texas

MicroStrategy Developer

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Logical Schema design in MicroStrategy.
• Extensively worked with 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.1 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), Oracle 11g, Windows XP

Confidential,

MicroStrategy Developer

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 this period to sales this 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 Server 2000, SQL

Confidential,

Microstrategy Developer

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 creating Metrics, filters and Prompts in 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 this period to sales this 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, Intelligent Server, Narrowcast Server, OLAP Services, MicroStrategy Desktop,MicroStrategyWeb, Oracle 10g, PL/SQL