SUMMARY

• 6+ years of strong experience inMicroStrategy 9.x/8.x/7.x, MicroStrategyDesktop,MicrostrategyReport Services, MicroStrategyWeb, MicroStrategyIntelligence server.
• Excellent hands on work experience in building Canned/Ad - hoc/Analytical reports using ROLAP & MOLAP Business Intelligence reporting tools (MicroStrategy 8i & 9i), MicroStrategy Desktop, MicroStrategyAdministration, MicroStrategy Web, and MicroStrategy Office, Object manager, Intelligent Cubes, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider and Data Mart.
• Extensive Experience in creating the Dynamic Dashboards & Scorecard reports using MicroStrategy 9.4.1.
• Good exposure to BI reporting MicroStrategy 8i, 9i & Tableau & SQL programming, RDBMS - Teradata, Oracle, and SQL server.
• Familiar with Intelligence Server and Narrowcast Server installation and configuration process.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Knowledgeable in business functionality for developing multidimensional modeling (Data Modeling).
• Delivered reports inDesktopandWeband viaNarrowcast Serverto multiple users.
• Experience inSchema designand creatingSchema objects usingStar and Snowflake(Hierarchies, Attributes and Facts, Transformations).
• Excellent experience in MicrostrategyReport development, Reporttesting, Reporttuning,Ad-hoc,scheduling report delivery andAlerts.
• Extensive experience on all types of MicrostrategyFilters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Proficient in SQL Command, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters.
• Experience in using Project Merge, Object Manager,and Enterprise Manager.
• Extensive Microstrategy development hands on experience withDesktop,Architect,Intelligence Server,Report Services,Enterprise Reporting, OLAP provider,Data MartandWeb components
• Exceptional ability to quickly master new concepts and capable of working in-group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment.
• Experienced in preparing resource & effort estimations/forecasts, MicroStrategy Roadmap Creation for end-to-end BI projects.
• Extensive experience in onshore/offshore coordination and responsible for project deliverables.
• Ensure the team follows the change control process when there is any request to change the agreed scope.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy Desktop 7x/8x/9.0/9.4.1 (Microstrategy Developer, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services Documents, Dynamic Dashboards, Microstrategy Narrowcast Server, Enterprise Manager)

Databases: Oracle 8i/9i/10g, TeraData, Sql Server, Ms-Access, SQL, PL/SQL, HTML, XML

Platforms and Web Servers: Windows 7, 8, 9x, Vista, MS-DOS, Internet Information Server (IIS) 5.x, Informatica 8.x/9.x, Data Stage, TOAD

Design Tools: MS Visio, Erwin, MS Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Senior MicroStrategy Developer

Confidential, Atlanta, GA

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• Administered Microstrategyenvironments and formulated user groups.
• Installation of Microstrategy Desktop and creating a Microstrategyproject.
• Handled user licenses for projects.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Managed backup of Metadata.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Customized web interface using SDK.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Microstrategy SDK customizations.
• Analyzed and developed the new objects in Dev environment and after testing the objects and reports migrated to Production Environment.
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Extensively worked on Microstrategy administration that includes Intelligence server administration, configuration of memory settings and performance monitoring.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.
• Utilized Eclipse to test the function of MicrostrategyWeb based on Web SDK.
• Defining Drill Hierarchies and creating relationship between attributes.
• Involved in project discussions related to schema objects which acts has a semantic layer for the Microstrategy project.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Coordinated with internal and external stakeholders.
• Strong knowledge in creating Intelligent Cubes, which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, MicrostrategyUser Groups and Users, assigning security roles to Users and Groups.
• Involved in creating security filters to end users to access data based on their privileges.
• Created services using Subscription sets, Schedules, and Information Objects.
• Formulated grid, graph, document and dashboard reports.
• Designed and developed the Dynamic dashboards.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked in different environments like, Development, QA and Production and migrate jobs from environment to environment by creating a ticket (Kanban) to the operations team.
• Worked with different feature teams on different Roadmap's simultaneously to deliver the line items in a timely manner.
• Worked on Agile project tracking tools (such as JIRA) and structured development methodologies (such as Agile Scrum, iterative)

Environment: MicroStrategy 9.4.1, Report Services, MicroStrategyDesktop, MicroStrategy Web, Mobile, MicroStrategy Dashboards, MS-Excel, Toad, Oracle 10g.

MicroStrategy Developer

Confidential, Dallas, TX

Responsibilities:

• Participated in all the Business Meetings with the users to give necessary inputs.
• Documented all the baseline projects based on Company Standards. Created baseline standard documents, which directly helped organizations baseline group to improve their quality of service and it also helped to resolve the tickets faster, and efficient way.
• Created MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Delivered formatted and conditional formatted reports through MicroStrategy Office.
• Worked on creating custom groups and consolidations as per requirements.
• Created Apply Simple and Apply Comparison functions to develop complex metrics and filters.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy to read, interactive documents using the new selectors like radio buttons, check boxes, panels, slider, button bar etc.
• Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked 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.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Tested all the reports by running queries against the warehouse using SQL Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes.
• Created Transformations (table based, formula based) this week vs. last week analysis reporting.
• Drilling options (Drill up down across) were used to generate ad-hoc reports.
• Created design and technical specification documents for realizing MicroStrategy objects to be integrated in the report.
• Strong knowledge in creatingIntelligent Cubes, which will give the performance when executing the reports, and also enabling Dynamic Sourcing for specific cubes.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidations and custom group objects in an enterprise data warehouse team environment.
• Created Dashboard and Scorecards using Report Services Documents.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Worked in customization of Micro Strategy Web.
• Designed Custom drill maps using drill map editor as per the requirements for drill through functionality.
• Worked effectively with ETL team to assist them in data validation.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Involved in Managing migration of Microstrategy projects and objects from Development to Testing and to production environment.
• Optimized reports to improve the performance.
• Co-ordinate test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.

Environment: Microstrategy 9.4.1 (Desktop, Architect, Web, Narrowcast Server, Enterprise Manager, Object Manager), Oracle 9.1, Oracle 10g, SQL, Informatica Power center, Quality Center.

MicroStrategy Developer

Confidential, Louisville, KY

Responsibilities:

• Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing teamto discuss the user requirements and status updates.
• Worked in a Scrum Agile process with two-week iterations delivering documents/report and dashboard at each iteration.
• Working closely with ETL team for collecting data and testing team for resolving defects.
• Experienced in implementing MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create reports and dashboards for the business users.
• Involved in troubleshooting MicroStrategy Reports, by optimizing the SQL using VLDB properties for creating complex reports using Advanced Filters, Compound Metrics, Conditional, Transformation and Level Metrics.
• Worked with MicroStrategy Desktop/Web to create new documents/dashboards and fix the issues with existing documents/dashboards.
• Involved in complete life cycle of multiple BI reporting projects of the group.
• Developing logical models, building hierarchies, attributes and facts, extracting tables from warehouse catalog.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Developed Scorecards and Dashboards that provide users a highly graphical, summary view of key metrics.
• Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.
• Optimized the performance of the MicroStrategy platform by implementing suitable report design processes, and SQL tuning.
• Worked on MicroStrategy Object Manager to move objects from development environment to the test environment.
• Involved in fork lifting the MicroStrategy project from Oracle to Teradata.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Worked in creation of Projects, ODBC, database instances and configuration of project.
• Created transformational metrics (Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Involved in maintaining optimal performance of BI application, performance monitoring, capacity planning, and tuning for multiple users.
• Configured Enterprise Manager to collect statistical data related to different projects.
• Facilitated Business analysis by creating relevant reports by using filters, custom groups, consolidations and transformations (table based, formula based)
• Adapt at managing projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Extensively involved in data modeling to create attribute relationships, and hierarchies.
• Worked in optimization of code and tuning queries for performance.
• Provided postproduction support to end-users.
• Worked on MicroStrategy Object Manager to move objects from development environment to the test environment.
• Created Cubes and scheduled them to run weekly bases.
• Created Visual Insights reports from Cubes.
• 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.
• Capture daily work progress and generate weekly status report.
• Worked on the performance tuning of the MicroStrategy reports.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server.

Environment: MicroStrategy 9.3 (Desktop, Web Server, Object Manager, Enterprise Manager, Distribution Services), Informatica Power Center, Quality Control, Teradata, ODBC, Windows 7, HTML, Oracle10g.

MicroStrategy Developer

Confidential

Responsibilities:

• Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Created services in MicroStrategy Narrowcast server using static and dynamic subscription sets.
• Attended weekly project and team meetings and provided status on the assigned tasks.
• Created project plans for development of MicroStrategy projects.
• Extensively used INFORMATICA Power center 8.6 client to extract data from sequential files, Oracle databases and loaded into a single data warehouse repository in SQL Server.
• Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
• Designed and translated Logical Data Models into various Physical Warehouse Schemas.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports.
• Wrote Stored Procedures to encapsulate Business processes.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server.
• Checked all the reports available in previous project, Scan data were developed with same or more functionality in EDW.
• Analyzed the user requirements and project specifications to identify entities.

Environment: MicroStrategy (Desktop, Intelligence Server, Web), SQL Server 2000 and Windows.