SUMMARY:

• Having 8 years of experience in building projects and creating reports and dashboards using MicroStrategy 10.x/9.x/8.x, MicroStrategy tool Suite, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, Distribution services and OLAP services.
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill through the data.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects and also creating and formatting Dashboards with multi - layouts.
• Experienced working on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server& Distribution servers.
• Experienced in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation.
• Experience in MicroStrategy Architect, Office, Narrowcast, User security & management, Object Manager & designing reports (grid, drilldown, ad hoc, OLAP cube) and dashboards in MicroStrategy.
• Expertise in Data visualization development using Tableau to create complex, intuitive and innovative dashboards.
• Created Tableau wireframes for various lines of business.
• Experience in customizing the prompts using SDK etc. Also experienced in all levels of customization using MSTR SDk
• Worked on SDK modules like Web SDK, Mobile SDK, Narrow Cast Server SDK, Intelligence Server SDK etc.
• Extensive experience with all areas of MicroStrategy including Architecture, Dashboard development, Administration, Web and Intelligence Server monitoring/diagnostic and resource optimization
• Experience in Object Oriented Analysis Design (OOAD), and development of Software using UML Methodology, good knowledge on Jenkins J2EE design patterns and Core Java design patterns.
• Having the knowledge on OBIEE, and Abinitio and Hadoop Eco-system.
• Used MicroStrategy Object manager to migrate the objects/projects between Development and production servers.
• Experience in integration of various data sources from Databases like Teradata, Oracle, SQL Server, CSV files and text files.
• Extensive Microstrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web components
• Worked on SDK (Software development Kit) environment to enables easy customization and integration of the Microstrategy BI platform with enterprise business applications.
• Extensive work on creating and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, user groups, security filter etc.) using MicroStrategy desktop.
• Good working knowledge of Extraction, Transformation, and Loading of data from different sources using ETL tools such as Informatica , Oracle Warehouse Builder .
• Experience working on VLDB properties for performance tuning.
• Expertise in Mobile Development work in developing RESTFUL Services & in developing Front end as well (Ex: HTML Pages, CSS, JavaScript, Ajax etc..)
• Utilized Eclipse to test the function of Microstrategy Web based on Web SDK.
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers
• Designed Data Mart using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Well versed in installation, configuration and Project creation and tuning of MicroStrategy Business Intelligence.
• Customized web interface using SDK.
• Experience in using build tools like ANT, Maven and logging framework Log4J.
• Heavily involved in the front validation of the ETL code. Used DbVisualizer to validate the ETL code that populates the webapp.
• System Optimization, performance monitoring.
• Extensive experience working on large data warehouse databases like TERADATA and Oracle and in writing/troubleshooting SQL and performance tuning Strong troubleshooting capabilities in MicroStrategy Desktop.
• Used MicroStrategy report services, distribution services and narrowcast services to create reports and scheduling reports via e-mail, via shared network drive.
• 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:

OLAP Tools: MicroStrategy 10.2,10.x/9.X/8.X/7.X (MicroStrategy Desktop, Intelligence Server, Distribution Services, Architect, Report Services, Narrowcast Server, Distribution services, OLAP services, Enterprise Manager, Integrity Manager and Object Manager ).

Web Technologies: HTML, CSS, DHTML, XML, XSL, JSP, JavaScript, Microsoft Front Page, Excel and Home Site 4.0.

Programming: Java,SQL, PL/SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, ASP, C, C++RDBMS: Oracle 10g/9i/8i/8.0, IBM DB2, MS Access 2003/2007, MicroSoft SQL server, Teradata V2R5,V2R6

PROFESSIONAL EXPERIENCE:

Confidential, Boston

MicroStrategy Lead Developer

Responsibilities:

• Analyze requirements and develop derived metrics, custom report objects as required
• Developed Microstrategy reports and related objects
• Responsible for testing of developed reports and report objects
• Interface with business users for requirement definition, user acceptance testing, training and deployment
• Maintain standardized Microstrategy design, development, testing and deployment task documentation
• Upgraded and maintained JSP based webapps with geospatial data from Microstrategy Intelligence Server
• Worked with the Data Modelers for creating the dimensional model based on the requirements
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making
• Created MSTR Prelim and Detail design documents based on the business requirements.
• Troubleshoot MicroStrategy application issues internally and with vendor
• Worked with business analysts to baseline the reporting requirements
• Created the MDS (Master data services) forms for business user to feed the forecast data
• Design, build and maintain logical model for MicroStrategy reporting application
• Design, build and maintain all Microstrategy Schema objects (attributes, facts, hierarchies)
• Understand the type of schemas that best support Microstrategy in different scenarios
• Perform code reviews and unit testing
• Support user, system, performance and regression testing efforts
• Created number of Normalized database tables with different constraints to maintain integrity. Triggers were implemented on the tables to maintain validity check on the data.
• Worked on different aggregate functions and scalar functions.
• Actively participated in developing Entity-Relationship (ER) Diagrams, and Data Dictionaries, by gathering information from the Business Users and detailed analysis of the data.
• Designed the user interface and menus using triggers, and procedures.
• Took part in designing and implementing multiple forms for each module.
• Incorporated user-friendly functionalities like pop-ups, list boxes and other object oriented events into the system
• Participated in upgradation of MSTR version 10 to 10.2 and 10.4.
• Designed, developed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters and Used pass-through functions (apply simple and apply comp) in attributes and filters definitions
• Used several Widgets for Dashboard reporting.
• Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, widgets in flash mode.
• Used SDK for few existing plugin change/update, got from MicroStrategy direct vendor.
• Created up to seven layer dynamic dashboard by using panel stacks and selectors which will provide information for all levels of hierarchy.
• Created Drill down dashboards which will allow users to navigate from one dashboard to another.
• Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Created Enterprise Manager Reports for various analyses.
• Object prompts according to the business needs.

Environment: Microstrategy Desktop, Microstrategy 10.2, Microstrategy 9.2 (Architect, Agent, Object Manager, Tableau, WEB, Administrator, Enterprise Manager, Narrowcast), Intelligence Server, Web, Administration Windows NT

Confidential, Virginia

Senior MicroStrategy Developer

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Designed Dashboards using the new selector’s radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Performed routine administrator tasks during absence of MicroStrategy administrator.
• Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks and selectors.
• Involved in testing the entire project when Terradata is upgraded from V2.5 to V2.6.
• Analytics Technical and Functional designs for Dynamic Dashboards.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports.
• Performed testing of all reports for the final deployment.
• Provided Business user training for the MicroStrategy Desktop/Web.
• Architected schema objects such as MicroStrategy Attributes, Facts, Transformations and Hierarchies.
• Data Modeler/Analyst in Data Architecture Team and responsible for Conceptual, Logical and Physical model for Supply Chain Project.
• Created above store reports to support field coaches and general managers. The reports were highly visual and drillable. Aggregate tables were designed to efficiently run reports
• Worked in on-off shore model to fulfill business requirement and assigning work to off shore
• Build reports that were distributed to 100’s of users as email
• Performance optimization using VLDB properties, created I - Cubes to improve performance and to reduce the load on database during Peak hours.
• Built numerous dashboards to meet Operational and financial reporting that enabled senior executive to easily visualize overall business
• Created ad-hoc reports and freeform SQL reports depending on user requirement.

Environment: MicroStrategy v9.2.1,MicroStrategy 9.0.1(Architect, Desktop, Report services, Dashboards, Enterprise Manager) Teradata 12.0, Windows XP.

Confidential, Detroit

MicroSrategy Developer

Responsibilities :

• Participated in the end user meetings to obtain the business requirements for creating reports.
• Identified and defined Facts, Attributes, Hierarchies and Relationships.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, hierarchies, metrics, filters, and templates using MicroStrategy Architect
• Designed the logical data model from the technical design documents and translating to a physical database design optimization and functional testing of the constructed database.
• Created Attributes, Facts, and Hierarchies for the Vendor & Product, Pricing and Basket Analysis projects.
• Created Complex Compound Metrics at different dimensionalities to count the Items sold at different store levels.
• Created Filters to validate the test plan conditions for the reports and per the business requirements.
• Created Custom Groups for the Vendor contact types and Competitive Pricing.
• Developed logical and physical data models for OLAP database applications.
• Gathered the reporting requirements from the Business customers for the Merchandising Vendor, Product, PO, Replenishment, Pricing, Competitive Pricing projects.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Created Templates to maintain a standard interface for the reports.
• Created Attribute-Attribute Prompts, Advanced Filters to obtain the Basket counts and used them along with the metrics at different dimensionalities
• Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Worked on Derived Elements by creating user-defined business (attribute) groups for comparison analysis.
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Creating the custom tags
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode. Have used several new controls for Dashboards like time series slider, radio buttons, and drop down menus.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• Have used several Widgets for Dashboard reporting.
• Heavily worked on testing and validating the data and also involved in optimizing SQL, troubleshooting reports using VLDB properties.
• Fixed Defects and performed upgrades for existing projects.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Server, Windows XP Professional 2003

Confidential, Chester Brook, PA

MicroSrategy Developer

Responsibilities :

• Involved in creating complex reports to be used by the various buyers for making critical decisions regarding the inventory at various times and for trend & sales analysis
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Coordinating migration processes handled by the operation team, from the Development Environment to the Push to Production environment.
• Created MicroStrategy Public Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop.
• Created and implemented MicroStrategy reports by creating projects, Custom Groups, Cubes, attributes, hierarchies, metrics, filters, and templates.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• 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 various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report, consolidation reports.
• Designed custom drill maps using drill map editor as required in the reports for drill through functionality.
• Generated advanced reports in grid, graph consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web
• Created various pass through functions like apply simple, apply comparison and also case statements to support various business requirements.
• Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
• Worked on Intelligent Cubes to provide performance for dashboards and reports.
• Extensively worked on creating Report Services documents using multiple Grids and Graphs
• Applied OLAP and statistical functions to calculate metrics
• Designed Schema and public objects using Pass through functions (Apply Simple, Apply Comparison, Apply Avg, etc)
• Created different Transformations to get the last year actual transactions, week-to-day, week-to-period, week-to-quarter, and week-to-year
• Involved in creating user groups and assigning user privileges according to the types of reports that they can generate or view in MicroStrategy Web
• Worked on report services documents to create graphs as per user objective
• Used freeform SQL to create Enterprise Manager Reports & Parametric Data Transfer analysis reports
• Created Drill Maps to obtain aggregated results
• Involved in creation of security filters to end users to access database on their privileges
• Configured Intelligence server to generate pre-generated cache reports and used Narrowcast server to execute and deliver reports via web or email
• Involved in troubleshooting MicroStrategy Web Reports, andoptimizing the SQL using the VLDB properties
• Performed a complete Production Support for the end users using Microstrategy Web & also MicroStrategy Desktop

Environment: MicroStrategy 8.1/9.0.2 (Desktop, Administrator, Web), MicroStrategy Intelligence Server 8.0/8.1,MicroStrategy Narrowcast Server, Teradata V12, Windows XP/2000.

Confidential

MicroSrategy Developer

Responsibilities:

• Developed a 3-tier client/server product in the corporation for use by the merchandising department to access a relational Oracle database in a multidimensional way (ROLAP) using Micro Strategy’s DSS tool suite of products in a heterogeneous networked environment.
• Designed the Micro Strategy Architectural Documents for the Projects
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics.
• Developing customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using Micro Strategy Agent with features of Drilling options drill up, drill down and drill anywhere.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Performed testing of all reports for the final deployment.
• Used Micro Strategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized content to the subscribers. Involved in installation and configuration of the Narrowcast Server and perform various tasks to have the subscription and other features to work.

Environment: Microstrategy 8/7.1.2 Product Suite, Oracle 9i, Informatica, Toad, Windows XP.

Confidential

MicroSrategy Developer

Responsibilities:

• Created project plan for the development, implementation and operation of the Microstrategy system using Microsoft Project.
• Architected schema objects such as attributes, facts and transformations.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, compound Metrics and Prompts.
• Created reports with various object prompts to generate various Ad hoc reports.
• Implemented the user defined Microstrategy objects like custom groups and consolidations according to the requirement.
• Created several base formulas (mathematical expressions) using existing facts in Microstrategy Desktop 7.x that can be re-used to build any number of metrics.
• Involved in Testing of reports and Migrated Microstrategy7i projects from development to acceptance and to production.
• Created reports with various object prompts to generate
• Various Ad hoc reports.

Environment: MicroStrategy 7.x, Windows 95/NT/2000.