We provide IT Staff Augmentation Services!

Microstrategy Architect/developer Resume

El Segundo, CA

SUMMARY:

  • Over 7+ years of experience in MicroStrategy and data modeling, designing and architecting data warehouses and business intelligence applications.
  • Well versed in MicroStrategy product suite (MicroStrategy Desktop/Architect/Web/Distribution services/Intelligence Server/ Administrator/Dashboards/ Reporting Services).
  • Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations)
  • Expertise in Developing User Objects (filters, prompts, metrics, Custom Groups, Consolidations, Searches) to develop Documents and reports.
  • Expertise in designing multi layout Dynamic Dashboards, used custom Widgets to build on flex for specialized dashboard along with Scorecard reports in MicroStrategy using various widgets and graphs to track company's performance, and monitor overall goals.
  • Extensively utilized MicroStrategy Object Manager in the migration of Objects from Development to QA and then to Production.
  • Skilled in Intelligent Cube Development, Custom widget, D3 visualization development and implementation.
  • Strong in SQL especially in using nested table expressions, unions, multi - table joins, scalar functions, derived columns and another complex querying.
  • Skilled in performance tuning of SQL queries providing hints, table analysis, index addition, obtaining explain plan and BI analysis.
  • Extensive knowledge in Databases (Oracle, SQL Server), with more exposure towards query Performance Tuning in VLDB properties.
  • Experience in delivering reports in Desktop, Web and via the Narrowcast server.
  • Extensively designed Data Marts using multi-dimensional modeling techniques (Star Schema, Snowflake Schema for FACT and Dimensional tables that includes Logical and Physical data modeling).
  • Extensive experience in implementing dash boarding and D3 visualizations.
  • Extensive experience in using MicroStrategy Distribution Services to provide high-volume and high-efficiency distribution of reports, documents and dashboards to email addresses, file servers, networked printers, FTP locations, and devices such as mobile phones.
  • Extensively worked on MicroStrategy Administration (Intelligence Server Administration, the configuration of Memory settings, and Performance monitoring).
  • Experience in providing seamless and consistent mobile reporting tools for individual brands within an agile environment leveraging multiple technologies using Mobile MicroStrategy.
  • Expertise in Design documents, resource and effort predictions, and MicroStrategy roadmap for an end to end BI projects
  • Experience in developing I-Cubes and Incremental Refresh Datasets for I-cubes to load the data into I-Cubes..
  • Expertise in creating Ad-Hoc/Analytical Reports using ROLAP and MOLAP BI Tools and MicroStrategy (8i /9i /10)
  • Experience in development and enhancement of Web Reports (On demand, ad-hoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab).
  • Experience in creating automated scripts for MicroStrategy automated deployment process.
  • Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects.
  • Experience in creating custom drill maps as required in reports for drill through functionality.
  • Extensive experience in migrating various reports to Distribution Services and cloud services such as AWS or Azure.
  • Possess excellent knowledge in wide range of Database concepts including Data Warehousing, Dimensional Modelling, Fact and Dimensional tables, ER modelling and Databases.
  • Skilled in creating complex reports, Complex Filters (Dynamic, Embedded, Custom and Relationship Filters), Compound Metrics with dimensionality and conditional also generated Data Marts.
  • Experience in Performance Optimization of MSTR Reports, using Intelligent Cubes for better performance and to reduce the load on Database.
  • Experience in Intelligent cubes implementation.
  • Expertise in OLTP/OLAP Systems Analysis.
  • Worked along with QA, testers and business users to ensure completeness and accuracy of reports data.
  • Expertise in designing advanced Dashboards/Documents both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools and designing Visual Insight reports.
  • Experience in customizing MicroStrategy Web using add-ons, Transforms and Event Handlers.
  • Skilled in using tools like TOAD, SQL Developer Application.
  • Involved in the full life cycle development of the data warehouse project.
  • Excellent exposure to Software Development Life Cycle (SDLC).
  • Highly motivated with the ability to work effectively as a team player and as well as independent.
  • Phenomenal problem-solving skills with a strong technical background, good inter personal skills and ability to quickly master new concepts.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 10.11/10.4/10.1/9. x/8.x (MicroStrategy Desktop, Web, Distribution Services, Mobile, Narrowcast Server, OLAP Services, Object Manager, Command Manager & Enterprise Manager), Tableau, PowerBI

Languages: C, C++, SQL, PL/SQL

ETL: Informatica

Web Technologies: HTML, CSS 2, MS Front Page

Databases: Oracle 9i, 10g, 11g, SQL Server, Teradata, Vertica, Hadoop(Hive)

MS: DOS, Windows 98/NT/2000/XP/VISTA/7/10, UNIX and LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

MicroStrategy Architect/Developer

Responsibilities:

  • Involved in the business interaction with the users and gathered the reports that needed to exist in the Project.
  • Involved in Database meetings and also worked closely with business users in gathering the requirements and preparing Business Requirement Document.
  • Created the technical specifications of the reports for user acceptance.
  • Design and Develop MicroStrategy Dashboards using customized Widgets.
  • Involve in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB properties.
  • Provided optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
  • Worked extensively with Business Analyst to finalize the dashboard layouts and provide fine detail formatting for a desired look and feel.
  • Worked with Big Data solutions such as Apache Hadoop, Hortonworks.
  • Worked with relational databases such as Teradata, Oracle, Vertica.
  • Worked with dedicated and focused teams to complete critical milestones under pressure with tight deadlines.
  • Provided various management level reports, Time series analysis and wide range of graphs using MicroStrategy Web.
  • Took part in design and development of Data marts and integrating them with Data warehouse.
  • Worked on building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.
  • Work on full SDLC projects to support MicroStrategy BI applications in Enterprise Consolidated Data Warehouse.
  • Gathered business requirement documents from Business analysts/users and translated them to technical requirements.
  • Designed data model and table structures in data warehouse using classical snow flake schema to support MicroStrategy reporting.
  • Worked closely with ETL teams to understand data flow. Made recommendations to table structures to add additional columns to make the reports more efficient.
  • Developed MicroStrategy Mobile dashboards which are compatible with Android/iOS mobile devices.
  • Analyzed and developed the new objects in a Test environment and after testing, the objects and reports are migrated to Production Environment.
  • Created new subscriptions in both DEV and PROD environment to deliver reports to business users through email.
  • Performed Unit Testing of the reports by writing down manual SQL queries.
  • Worked extensively to create Analysis dashboards by using MicroStrategy Visual Insight to explore and understand the data using intuitive D3 visualizations.
  • Created I-Cubes to improve performance by loading huge amounts of data in memory, which the business users can use when needed.
  • Created Incremental Refresh Datasets for I-Cubes to load the historical data into cube.
  • Worked in developing customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options.
  • Created Freeform SQL reports in MicroStrategy whenever dimensionality of the SQL query can’ Confidential be achieved or some of the join conditions or filters can’ Confidential be created in MicroStrategy.
  • Created MicroStrategy reports and I-Cubes using .CSV files and TM1 sources.
  • Worked in onshore offshore model and led the offshore MicroStrategy Developers to meet the project deadlines.
  • Hands on experience in using different tools like Confidential Cognos, Teradata SQL Assistant, DB Visualizer and different ODBC drivers for Teradata, Hadoop and Vertica.

Environment: MicroStrategy 10.11/10.4(Administrator, Desktop, Web, Mobile, Narrowcast Server, Object Manager, Enterprise Manager, Distribution Services, Integrity Manager, Command Manager), Teradata, Hadoop, Vertica, DVT, Cognos, JIRA, Kanban

Confidential, Columbus, OH

MicroStrategy Developer

Responsibilities:

  • Involved in the business interaction with the users and gathered the reports that needed to exist in the Project.
  • Involved in Database meetings and also worked closely with business users in framing the Scope Document.
  • Responsible for testing the reports by writing down SQL queries.
  • Created ETL technical Specification documents, which are used for developing Data, warehouse Schema.
  • Created the technical specification for the reports for the user acceptance.
  • Used MicroStrategy Architect to create Facts, Attributes, Relationships and Hierarchies.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Used MicroStrategy Web to generate Advanced Reports.
  • Created Consolidations, Custom Groups and Prompts for the reports.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Analyzed and developed the new objects in a Test environment and after testing the objects and reports, migrated to Production Environment.
  • Designed and developed dashboards and score cards using the latest version 10
  • Created Report Service Documents for HR and Finance Projects using Adobe Flash introduced in the latest MicroStrategy version 10
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Designed and Developed Web Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.
  • Used Distribution Services to deliver reports directly to business users through Email & History List.
  • Created custom dash boarding using widgets like time series sliders, Micro charts, Lipstick graphs etc. in HTML5.
  • Developed standard OLAP features such as intelligent cubes (I Cubes), data aggregation, derived metrics, Banding, Aliasing, Page by, Pivoting, Sorting, Thresholds and Subtotals.
  • Deployed and supported MicroStrategy reports, ad-hoc packages, and In-memory cubes.
  • Created dashboards which evaluate and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
  • Got appreciations from Business users for creating Dashboards looks and feel like their sample reports.
  • Created Analysis dashboards by using MicroStrategy Visual Insight to explore and understand the data using intuitive D3 visualizations.
  • Performance optimization using VLDB properties, created I-Cubes to improve performance and to reduce the load on database during Peak hours.
  • Worked extensively on dynamic dashboards and scorecards using Report Services with illustrative pie charts and graphs for different Business requirements.
  • Used MicroStrategy Administrator for accurate information regarding system usage and performance.
  • Integrated first interactive mobile dashboards Confidential for 50 users - including heads of regions, field leaders and home office personnel - which facilitated quick business decisions, aided in store/partner visits and measured merchandise category performance.
  • Supported 3,000+ stores worldwide by supplying interactive mobile real time and historical dashboards / applications which enable Confidential leaders to make informed decisions.
  • Worked on configuring Mobile server and created reports using it.
  • Designed database schemas for OLAP warehouse databases.
  • Created/enhanced catalogs and set user profiles to grant user permissions for querying.
  • Created subscriptions for Delivery of reports using Distribution Services.
  • Validated end user report requests using SQL and MicroStrategy tools.
  • Triggered both static and dynamic subscriptions in MicroStrategy Narrowcast.
  • Created automated scripts for MicroStrategy Object Manager 9.4.x to 10.x to create, import and undo packages.
  • Created and XML file to use to import the package and create the undo package by using Object Manager GUI.
  • Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics
  • Designing Metadata Structure using MicroStrategy Configuration Wizard
  • Used MicroStrategy 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.
  • Developed customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options.

Environment: MicroStrategy 10.0(Administrator, Desktop, Mobile, Narrowcast Server, Object Manager, Enterprise Manager, Distribution Services, Integrity Manager, Command Manager) SQL Server 2008, Teradata.

Confidential, Chicago, IL

MicroStrategy Developer

Responsibilities:

  • Designed and developed logical data model for MicroStrategy reporting environment.
  • Identified source tables and columns required to create MicroStrategy project.
  • Improved the performance of the reports by changing VLDB properties.
  • Created Ad-hoc Reports by drilling up, down, with across hierarchies.
  • Developed different transformations which help business users to compare present data with previous year’s data in reports.
  • Extensively used MicroStrategy Report Services to generate Report Documents.
  • Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modeling and Data Warehousing applications.
  • Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
  • Migration planning and implementation with all supported service packs, hot fixes, and patches.
  • Substantially developed project management practices and communication between software development teams, leading to smoother and more efficient implementation and better utilization of time and budgets
  • Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments
  • Actively participated in developing Report Delivery Schedules. Modified VLDB Settings to tune the reports for faster execution.
  • Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
  • Resolved issue pertaining to the MicroStrategy Intelligence Server, Distribution Services, Narrowcast Server, and Enterprise Manager.
  • Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
  • Worked with Logistics Analyst who developed a business requirement. Build mock up reports and presented to the users before starting the report development.
  • Took part in the design and development of Data marts and integrating them with Data warehouse.
  • Generated Freeform SQL reports writing SQL queries against different databases.
  • Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 10.1/9.3x/9.5x/8.0.3, Teradata V2R6.1.1, SQL Server 2005, Windows XP, Erwin, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboard, Distribution Services, Teradata and SQL.

Confidential

MicroStrategy Developer

Responsibilities:

  • Gathered and analyzed relevant data and created Schemas that fit reporting requirements defined facts and dimension tables, created an aggregate table for performance.
  • Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.
  • Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters.
  • Utilize in-depth knowledge of functional and Technical experience in data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to the customer.
  • Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
  • Developed reports, dashboards, SQL queries using Tableau.
  • Worked on migrating Narrowcast reports to MicroStrategy Distribution Services.
  • Synthesized and translate Business data needs into creative visualizations in Tableau.
  • Performed Tableau administration tasks like the creation of users, groups, projects, workbooks and permission sets for Tableau server logons and security checks.
  • Tuned Tableau reports for optimized performance.
  • Assisted with best practices during implementation and integration of Tableau Platform.
  • Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
  • Development and enhancement of Intelligent Cube / Documents & D3 Visualization.
  • Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
  • Provided various management levels with reports, Time series analysis and a wide range of graphs using MicroStrategy Web.
  • Performed data validation for reports and metrics.
  • Worked in handling the MicroStrategy BI tools and Narrowcast Administration.
  • Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets
  • Created Relationship Filters based on Existing Model.
  • Worked with Logistics Analyst who developed a business requirement. Build mock up reports and presented to the users before starting the report development.
  • Took part in the design and development of Data marts and integrating them with Data warehouse.
  • Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.

Environment: MicroStrategy 9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, Distribution Services, OLAP, Tableau 7/8/8.1, Oracle 11g, Netezza, Windows 2003, MicroStrategy Dashboard, Oracle.

Confidential

MicroStrategy Developer

Responsibilities:

  • Extensively worked on full SDLC projects to support MicroStrategy BI applications in Lennox Enterprise Data Warehouse
  • Gathered business requirement documents by interviewing users and translated them to technical requirements
  • Design data model and table structures in a data warehouse using classical snow flake schema to support MicroStrategy reporting
  • Worked closely with ETL teams to understand data flow. Made recommendations to make the reports more efficient
  • Build a Leadership team MicroStrategy Android Mobile app that shows that is drillable across multiple dimensions.
  • Created data sets and dashboards using Intelligent Cubes to improve the performance.
  • Optimized MicroStrategy reports running efficiently by using MicroStrategy Intelligent cubes, aggregates, VLDB settings and database optimizations
  • Architected and integrated data models to MicroStrategy schema to support self-service BI Adhoc environment.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Filters, Metrics, Prompts, and Templates etc.)
  • Created Dashboard with multiple panels and panel stacks with different selectors.
  • Worked on debugging complex reports by identifying the issues and making appropriate changes.
  • Involved in Code Optimization and Query Tuning to improve the performance of the reports.
  • Involved in UAT Testing and Defect resolution.
  • Worked on Administration tasks like Creating user groups, Object Migration, Providing Access, Events and Creating subscriptions for scheduled deliveries.
  • Proficient in writing pass through functions like Apply Comparison and Apply Simple.
  • Worked with MicroStrategy Technical Support and worked with them in finding the solutions and workaround for Product Related Issues.

Environment: MicroStrategy8.1/9 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboard, Teradata and SQL.

Confidential

MicroStrategy Administrator/Developer

Responsibilities:

  • Gathered requirements from users and converted them to technical specifications.
  • Performed SQL tuning to minimize data load time. The excellent gain in a performance recorded and also involved in defining requirements, functional specifications, design documentation and test strategy.
  • Participated actively in Logical design.
  • Effectively created DDL scripts and populated tables on Data Warehouse.
  • Developed Data Validation and Polling processes for some of the ETL designs.
  • Developed ABC (Audit, Balance and Control) processes in ETL.
  • Created complex metrics with different level dimensionality, condition and transformations for the user and business specific reporting needs.
  • Worked extensively with filters, custom groups, prompts, consolidations and transformations so as to generate reports meeting business needs.
  • Designed and populated Snowflake Time hierarchy.
  • Set up the initial metadata by creating Schema Objects and Application Object.

Environment: MicroStrategy 8.0 (Administrator, Micro strategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server), Actuate e Report Designer Professional 6.

Hire Now