PROFESSIONAL SUMMARY:

• Over 7 years of professional experience in implementing Business Intelligence, expertise in Data warehousing, Data architecture, Data modeling, using MicroStrategy.
• Over 5+ years of extensive experience with MicroStrategy 9.3, 9.2, 9.2.1, 8.0, 8.1, MicroStrategy Desktop, MicroStrategy Architect, SDK, MicroStrategy Web, MicroStrategy Intelligence Server.
• Worked on all phases of Data Warehouse development lifecycle and software development lifecycle, from gathering requirements to design, development, testing, deployment, and support.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Knowledge on various ETL reporting and database development tools like Informatica, SQL Server and Oracle with strong coding skills. And also worked on SDK environment to enable easy customization.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups and Intelligent cubes) with the data warehouse.
• Good knowledge in design and construction of metadata and experience working on intelligent cubes.
• Involved in creating projects that were connected to Warehouse and Metadata Repository through a 3 - tier architecture involving MicroStrategy Intelligence Server and also have the experience in duplicating MicroStrategy projects and creating new project sources.
• Extensively worked on Dashboard components including Widgets, panels, selectors& layouts for a dashboard implementation.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Excellent communication skills, analytical, problem solving skills and Self-motivated team player to work individually as well as in a team with Agile environment.

TECHNICAL SKILLS:

Business Intelligence tools: MicroStrategy Desktop, SDK, Architect, Web, Intelligence server, Administrator, Report Services, Command manager, mobile, SSRS, Quilkview, Tableau.

OLAP tools: MicroStrategy, Oracle server

ETL tools: Microsoft SQL Server Integration Services, Informatica

Supporting tools: MS Project, SQL Navigator, TOAD, Adobe Flash

Languages: C, Java, SQL, XML, HTML

Data Modeling Tools: TOAD Data Modeler,PowerDesigner, ERStudio, Erwin

DWH Concepts: Dimensional Data modeling, Physical and logical Modeling, Star & Snow-flake Modeling.

PROFESSIONAL EXPERIENCE:

Confidential - New York City, NY

Sr. MicroStrategy Developer

Responsibilities:

• Involved in the meeting with business users to discuss and finalize the requirements and design of the reports.
• Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes.
• Created Schema Objects using MicroStrategy Desktop and Architect.
• Experienced in usingMicroStrategy SDKandWeb Customizations.
• Designed and developed Intelligent cubes for maintaining stable environment.
• Developed Schema objects including attributes, facts, Hierarchies, Transformations.
• Created all types of Filters, Prompts, Templets, Metrics, Consolidations and Custom Groups.
• URL you construct will begin with this API base.
• Designed and Developed Reports and Report Service Documents with challenging requirements.
• Created dashboards in Interactive/Flash Mode by using multiple Panels, Selectors and dynamically passed multiple values from the selectors to the report linked in dashboard.
• Involved in creation ofDatamartReports, Partition Mappings and Aggregate tables to improve performance of reports.
• Used several Widgets and controls to Design and Develop Dashboards in Flash like all graphs types, Heat maps, Gauges, Time slider, Fish Eye etc.
• Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the flash version of the dashboards.
• Created advanced grid report, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on the fine detail formatting for a desired look and feel.
• Unit tested report layouts, validated the SQL query, Prompt ordering and defaults, security filters, export/print functionality and drilling options.

Environment: MICROSTRATEGY DESKTOP 9.3.1, WEB, ARCHITECT, SDK, OBJECT MANAGER, ORACLE 12C, WINDOWS 7 PROFESSIONAL EDITION.

Confidential - Phoenix, AZ

MicroStrategy Consultant

Responsibilities:

• Created different Transformations to get the last year’s actual transactions, week to day, week to period, week to quarter and week to year and effectively used them with the Metrics.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the Project.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, reports, dashboards, filters, metrics and templates using MicroStrategy Desktop.
• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
• Development tools and production-ready utilities that reduce code creation and maintenance and help you build customized applications
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to sales last year.
• Handled API documents and elements.
• Used SDK for web customization.
• Extensively used Narrowcast Server in various phases of Report generation namely Self-Subscription portal, Profile Management, Web, Proactive Information Delivery and alerting, Content Management and Personalization.
• Creating all Dashboards with HTML containers.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Involved in creating security filters to end users to access data based on their privileges.
• Created logical data models, recognized source tables and columns, to build Attributes, Facts, Hierarchies and Relationships, necessary to create a MicroStrategy project.

Environment: MICROSTRATEGY DESKTOP 9.3.1, MICROSTRATEGY WEB, MICROSTRATEGY ADMINISTRATION, SDK, MICROSTRATEGY INTELLIGENCE SERVER, MS SQL SERVER 2008, WINDOWS SERVER 2003, NETEZZA 466P6, XSL, HTML DHTML.

Confidential - Columbus, OH

MicroStrategy Consultant

Responsibilities:

• Developed and Analyzes Application objects (Metrics, Reports, Filters, Documents, Prompts) using the MicroStrategy Desktop and MicroStrategy Web interfaces.
• Created advance reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy prompts, level prompts, object prompts, value prompts) and Advanced Filters (Attribute Qualification, Set Qualifications and Advanced Qualifications Filters).
• Developed multiple complex reports using Derived metrics, Compound metrics and Filter in a metric to meet the requirements.
• Specialized development tools, such as the Portal Integration Kit and the Web Services Development Kit
• Used MicroStrategy Web SDK to customize the look and feel of the user interface - cosmetic and workflow changes, worked withplug-ins, toolbar links, s.
• Experienced in usingMicroStrategy SDKandWeb Customizations.
• Created new Facts, Attributes and attribute form expressions and Hierarchies as needed in the project.
• Developed Transformations (table based, formula based) to be used for comparative analysis like claims this year to last year (year to date and month to date).
• Extensively created Custom groups and Consolidations to meet the requirements.
• Optimized the Intelligence Server for better performance.
• Generated Weekly and Monthly reports as per the Client Requests usingSSRS.
• Created Dynamic dashboards with visual insight to improve marketing by product, customer, geographic and promotion analysis.
• Hands on experience in Performance Tuning of the tool and also modifying VLDB properties to achieve maximum performance.

Environment: MICROSTRATEGY DESKTOP 8.1.1, MICROSTRATEGY INTELLIGENCE SERVER, SDK, MICROSTRATEGY WEB, SSRS, MS SQL SERVER 2007.

Confidential - Center Valley, PA

MicroStrategy Architect/Developer

Responsibilities:

• As per business requirement, Designed developed and maintained MicroStrategy based reports
• Implemented Star and Snowflake Schema to fit reporting, query and business analysis requirements
• Worked closely with data modeling and ETL teams to develop the data model.
• Converted existing interactive reports with prompted and non-prompted reports using MicroStrategy
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters
• Created ad-hoc reports by drilling up, down, within, and across Hierarchies
• Tested all the reports by running queries against the warehouse using Teradata SQL Assistant. Also compared those queries with the MicroStrategy SQL engine generated queries
• Used MicroStrategy Report Service to generate electronic snapshots of business data and presented them in a visually appealing and intuitive format
• Expert in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an enterprise data warehouse team environment.
• Designed Prompts 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.
• Extensively worked with the Business users for gathering the requirements for developing reporting applications in MicroStrategy.
• Worked extensively with Intelligent cubes in developing the dashboards to increase the performance.
• Decode Javascript used in Hyperion Reports, achieve the logic using workaround like URL API & Web SDK
• Involved in designing Report services documents to create Dashboards per Business Requirements.
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Developed scorecards and dynamic dashboards that provide users a highly graphical, summary view of key metrics.
• Worked with business users to create SQL scripts for data extracts.
• Scheduled multiple reports for users and user groups.
• Develop & deliver MicroStrategy reports through Narrowcast Server
• Managing projects through entire systems development lifecycle including creating timely/thorough status reports and leading status meetings.

Environment: MICROSTRATEGY 8.1.3/8.1.1 (ARCHITECT, DESKTOP, SDK, NARROWCAST SERVER, OBJECT MANAGER, ENTERPRISE MANAGER), NETEZZA, WINDOWS XP PROFESSIONAL/7

Confidential

MicroStrategy Analyst

Responsibilities:

• Involved in upgrading MicroStrategy projects 8.0 to 9.0.1.
• Communicated with business for gathering information’s, designing, developing, administrating and maintaining MicroStrategy based reporting applications.
• Involved in performance enhancement and tuning of Microstrategy projects for better performance, accurate SQL and report.
• Evaluated MicroStrategy SDKproduct usage and where the potential benefits can be derived in the conversion efforts.
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Microstrategy Desktop.
• Used SDK for web customization.
• Customization of reports for creating various invoices and forms for decision makers by using XML and XSLT Style sheets.
• Creating corporate level Dashboards for senior level managers in Flash and Interactive modes using different kinds of Widgets & Selectors.
• Created Drill maps, Hierarchies, Transformations, Reports, Dashboards.

Environment: MICROSTRATEGY 8.0.1 (DEVELOPER, ARCHITECT, INTELLIGENCE SERVER, SDK, NARROWCAST SERVER, WEB, OFFICE), XML, XSL, XSLT, ORACLE 9I, SQL SERVER2005, MS OFFICE, WINDOWS 2000.