SUMMARY:

• Over 7 Years of professional experience in design, development, testing, implementation and maintenance in data warehousing environment.
• Involved in overall technical design and implementation of Business Intelligence solutions including MicroStrategy Schema Model, Data Warehouse semantic model and other BI/DWH technology platforms and delivery strategies.
• Worked and designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end - user a choice of different filtering criteria each time they run the report.
• Created the drill down reports based on business user requests, for better analysis of the hypothesis testing.
• Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Creating metrics which are data driven by statistical calculations such as ANOVA and Hypothesis Testing.
• Using MicroStrategy platform to identify, analyze and report on Key performance indicators (KPI’s) that are benchmarks of Six Sigma and ISO 9001 projects success.
• Building of Six Sigma score cards to complement a full range of KPI rich dynamic Dashboards.
• Creating balanced scorecards, operational reports and business performance analysis for ISO 9001 project.
• Employed MicroStrategy Desktop in designing 3-tier and 4-tier MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Generated and implemented MicroStrategy reports by creating projects, Dashboards, Attributes, Hierarchies, Metrics, Filters, and Templates.
• Configured reports for end users in MicroStrategy Desktop and MicroStrategy Web.
• Created User Groups and assigned privileges based on end-user roles using MicroStrategy Administrator.
• Worked on performance tuning techniques, tuning report SQL via schema object manipulations, IServer, ICubes tuning.
• Analyzed and upgraded MicroStrategy from one version to another and also applying the Hotfixes for that particular release.
• Implemented Microstrategy object migrations between environments and aligned with internal processes and toolsets.
• Worked in moving the objects from the staging server to production server by using the object manager.
• Exposure to client interaction, user-requirement analysis and User support.
• Team player with good interpersonal, communication skills and the ability to work in a team environment.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices and problem solving skills.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 9.2.1/9.01/8.1.2/8.1.1/8.0.2/7. x (Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Command Manager, Administration), Business Objects, OBIEE

Data Modeling: ER diagrams, Microsoft Visio

DB Programming: SQL, PL/SQL, OLAP queries, MS SQL, DB2

Web Technologies: Web Analytics, SEO, Google Analytics

ETL Tools: Informatica 8.0/7.1

Project Management: System Development Life Cycle, UML, RUP, Visio, Project

Databases: MS Access, Oracle 10g/9i/8i/8.x, SQL Server 7/2000/2003, DB2, Teradata and Microsoft Sql

Operating systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP

Software Packages: MS-Office 2007, Microsoft Word, Excel, Power Point, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, San Jose CA

Sr. MicroStrategy Developer

Responsibilities:

• Involved in the complete cycle of the project.
• Interacted with Subject Matter Experts (SME), Information and Integration Architects to get required information for report design processes and implemented optimization techniques to enhance performance of the microtrategy platform
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries.
• Responsible for gathering requirements from Business User and creating mockups.
• As per business requirement, designed developed and maintained MicroStrategy based reports.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Worked with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Created Application Objects like Metrics, Filters, Prompts and Reports using Microstrategy Desktop.
• Created Intelligent Cubes, Intelligence cube reports, View Filters and Derived Metrics.
• Created transformations using Transformations by tables and expressions for Time Series Analysis.
• Created Schema Objects like Facts, Attributes and Hierarchies in Microstrategy Architect.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.

Environment: MicroStrategy 10.2/10.4 (Desktop, Administrator, Web), MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Integrity Manager, DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential, Phoenix AZ

Sr.Microstrategy

Responsibilities:

• Involved in the complete Life Cycle of the project.
• Responsible for gathering requirements from Business User and creating mockups.
• Administered MicroStrategy environments and formulated user groups.
• Handled user licenses for projects.
• Managed backup of Metadata.
• Supervised report delivery and established project schemas.
• Formulated grid, graph, document and dashboard reports.
• Coordinated with internal and external stakeholders.
• Created Dashboards using Flash and DHTML wizards like Time Slider, Interactive Stacked Graph, Interactive Bubble Graph, Heat Map and Microcharts.
• Created Stored Procedures to support reports.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.
• Provided post production support for users & resolved defects during the QA and UAT process.

Environment: MicroStrategy 10.x (Architect, Intelligence server, Web, Web Universal, Desktop), Report Services, Teradata, SQL Server, Windows Server 8.

Confidential, Des Moines, IA

Sr. MicroStrategy Developer

Responsibilities:

• Enforced advanced administration, management and performance tuning techniques.
• Imparted advanced technical troubleshooting.
• Outlined documentation and handled Project Migrations.
• Managed research of solutions to business and technical problems.
• Formulated Functional & Technical Specifications and Test Plans.
• Worked with business requirements analyst’s subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting
• Used report services for various banded report to satisfy the printing requirements of the user.
• Provide production support of MicroStrategyreporting application.
• Create users in MicroStrategy and grant required access for projects.
• Prepared technical project related documentation.

Environment: MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy OLAP Provider, Oracle 10g and UNIX

Confidential, Parsippany, NJ

Microstrategy Consultant

Responsibilities:

• Extensively involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Designed Interactive Dashboards in Micro strategy Web to assess company’s performance and monitored the overall goals of the business.
• Maintain and track market basket log, Utilize and analyze information from log to provide statistics that will assist in taking the department to the next level.
• Create/prepare monthly summary reports on market basket activity, highlighting product gaps.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Micro Strategy Desktop and Micro Strategy web.
• Created Facts, Attributes and Hierarchies using the Micro Strategy Architect.
• Developed various Metrics, filters, consolidations, custom groups and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Involved in customization of Micro Strategy Web Dashboards.
• Involved in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Involved in creating various transformations to analyze different metric values in this year to last year using Micro Strategy Architect.
• Extensively worked on Documents by adding additional functionalities using XSL sheets to create more personalized documents with images, hyperlinks and other report objects.
• Involved in performing various analysis using the Micro Strategy Desktop.
• Involved in implementing optimization techniques to enhance the performance of queries dynamically generated by Micro Strategy by interacting with DBA’s and designers.
• Used Narrowcast server for content Management, Self-Subscription, Profile Management, Proactive information Delivery and alerting and to personalize the reports and information.
• Involved in configuring the Intelligence Server and pointing the database instances in both development and production environments.
• Worked with Administrator in installation process of the Micro Strategy Tool Suite.
• Designed mappings and the logic to migrate data from Legacy source system to the target Database.
• Worked with Informatica tool suit for data Extraction, Transformation and Loading into the warehouse database from Oracle databases.

Environment: MicroStrategy 9, MicroStrategy Desktop 9.x, MicroStrategy Web 9.x, MicroStrategy Intelligence Server 9.x, Informatica Power Center 8.1, Teradata, Windows XP Professional

Confidential

MicroStrategy consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities, Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop 8.0.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential

MicroStrategy Consultant

Responsibilities:

• Closely worked with the functional team in the process of gathering and documenting the business requirements.
• Created projects, attributes, hierarchies, metrics, filters, and templates using , MicroStrategy Agent.
• Star Schema was mainly used with Geography, Customer, Product, and Time as basic dimensions.
• Built Reports and Dashboard using report services.
• Created Dashboards in both the interactive & flash mode.
• Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
• Created Logical views in MicroStrategy for complex report creation situations.
• Tested the SQL and validate the report with the database.
• Developed Metrics and compound metrics, filters for complex reports.
• Involved in troubleshooting MicroStrategyprompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Developed various Auto prompts to give end users a choice of different filtering criteria each Time they run the report.
• Researched efficient aggregation, indexing, and partitioning strategies and optimal Time to run Schedule jobs using Enterprise Manager.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).

Environment: MicroStrategy 8.1/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter), Informatica, VB, Microsoft EXCEL Teradata V2R5, HTML.