We provide IT Staff Augmentation Services!

Digital Microstrategy Developer/consultant Resume

SUMMARY:

  • 7+ years of experience in Information Technology, experience with Data Warehousing Reporting Tool MicroStrategy using Desktop, Web, Intelligence Server, and Report Services.
  • Extensively worked in creating and integrating Reports and Objects in MicroStrategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse.
  • Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Created Dynamic Dashboards showing organizations yearly performance and analyzed the sales, revenue, profits using various graphs and widget
  • Experience in designing mock up reports for client demos
  • Extensive work experience in designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema for FACT and Dimensional tables that includes Logical and Physical data modeling.
  • Involved in Data architectural designing and database integration, data warehousing.
  • Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving with in Business Objects Enterprise and Reports.
  • Worked on all phases of data warehouse development lifecycle, from gathering requirements to design, development, testing, deployment, and support.
  • Implemented features like Integrated Query reporting and powerful iterative analysis were provided to the end users through MicroStrategy Desktop and Web
  • Experience in performance tuning SQL queries by providing hints, obtaining explain Plan, analyzing tables and adding indices.
  • Extensive MicroStrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web BI Suits and Reporting Tools.
  • Experience in Sending Weekly and Monthly Status Reports to Client/Higher Management. Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills
  • Excellent problem solving skills with a strong technical background and good inter personal skills.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.2,10,9.4.1, 9, 9.2, 9.2.1, 8.0, 8.1 (Desktop, Architect, Web, Intelligence server)

Databases: MS Access, Teradata, MS SQL Server, Mobile SQL server

Operating Systems: Windows XP, Windows vista, Windows 7

Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook, MicroStrategy Office

Dashboard and Widgets: MicroStrategy Dashboard

PROFESSIONAL SUMMARY:

Confidential

Digital MicroStrategy Developer/Consultant

Responsibilities:

  • Responsible for all MicroStrategy Architecture/Development.
  • Verified the logical schema for existing dimensions, worked with ETL Team for new tables, columns.
  • Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes.
  • Architected and Developed composite solutions involving users access reports
  • Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
  • For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
  • Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
  • Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
  • Created security filters and other report objects, drilling, defined hierarchies.
  • Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • Coordinated with the team members in order to update the progress of the development.
  • Scheduled meeting with the clients and the development team and reporting to the project manager.
  • Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
  • Tested all the reports by running queries against the warehouse and also compared those queries with the MicroStrategy SQL engine generated queries.
  • Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
  • Created documents using panels, panel stacks, sections, grids, graphs and widgets.
  • Tuned the reports by taking advantages of VLDB properties and complex report filters.
  • Worked with DBA's in identifying the long running queries of daily reports data and enhanced the performance by indexing, data distribution, and monitoring other activity on box.
  • Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
  • Collaborating with business partners to provide technical report assistance.

Environment: MicroStrategy 10.2, Desktop, Intelligence Server, Web, Administration, SQL Server, Window10, My SOL Workbench, Red shift

Confidential, Washington, DC

MicroStrategy Developer

Responsibilities:

  • Created Reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Experienced the latest version of MicroStrategy 10.2, 9.0.1 & above .
  • Developed Public Objects like filters, prompts, metrics, templates, consolidations, etc.
  • Experienced in using Schema Objects to create reports.
  • Worked on Data Warehousing and RDBMS concepts.
  • Created view and tables to generate clean SQL for reports
  • Tested reports and Dashboards in different environments to ensure the functionality and results.
  • Coordinated with team in order to deliver the product on scheduled time.
  • Actively participated in the data modelling and given suggestions in formulizing the table structure.
  • Worked with databases like Teradata for testing and validation of data and to create reports.
  • Experienced in promotion of Objects to different environments.
  • 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.
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
  • Created template reports using advanced prompts like object prompts, expression prompts, filters.
  • Designed the Micro Strategy Architectural and Developers Documents for the Projects.

Environment: MicroStrategy 10.2, 9.4.1, Desktop, Intelligence Server, Web, Administration, SQL Server, Window XP, Pl-SQL, Tera Data

Confidential, New York, NY

MicroStrategy Developer

Responsibilities:

  • Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
  • Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
  • Created multiple flash and dynamic dashboards using Intelligence Cube and Documents
  • Data blending implemented on EMPI databases and generated interactive dashboards.
  • Created adhoc reports to users by connecting various data sources.
  • Handled admin activities granting access, managing extracts and Installations.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Designed the data architecture and Involved extensively in Database Performance tuning
  • Migrating Project objects using Object Manager and comparing different environments using Integrity Manager of MicroStrategy
  • Help Data Analysts to create reports for Analysis using Cubes, Documents and Dashboards
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Generated context filters and used performance actions while handling huge volume of data.
  • Coordinating with IT and Business in the planning, design, development, and deployment of New Dashboards and Reports and mapping of data from Data warehouse as per requirements
  • Upgrading MicroStrategy versions, applying hotfix
  • Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Generated dashboards for sales with forecast and lines.
  • User Java Script API to customize the views, selects, filters, date and time.
  • Generated dashboards with combination charts for clear understanding.

Environment: MicroStrategy 9.4.1, 9.0, Intelligence Server, Web, Administration, Greenplum, pgAdmin 8.3.1, SQL Server 2005 and 2012, PL-SQL

Confidential, Secaucus, NJ

MicroStrategy Administrator

Responsibilities:

  • Worked on three different projects starting from creating the fact tables and dimension tables till the creation of the Report service document.
  • Administered two MicroStrategy Development systems and one production system. Responsibilities included schema design, creating new users, assigning security model standards, performing object migration/report publication, tuning server settings, tuning SQL, and scheduling weekly maintenance tasks on the metadata.
  • Worked one-on-one with business users in developing report requirements, specifications and design.
  • Created the transformation tables and developed schema and public objects on top of them to include in the reports which can compare as Is Vs as Was
  • Created Report Service Documents for HR and Finance Projects.
  • Used Advanced Prompts, Non- Aggregate Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
  • Experience in Mobile SDK to customize mobile application like rebranding, integration with google maps.
  • Involved in creating the Technical Documentation for Developers and Check lists for the users for the MicroStrategy Project.
  • Involved with Business analyst and Client for requirement gathering.
  • Developed reports for the pricing data warehouse which compared business pricing strategies to local competitors. Reporting included category management, executive summaries and price difference.
  • Responsible for Administration tasks include creating users and applying access to projects, creating/ duplicating the projects and migrating objects from development environment.
  • Created dash boards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
  • Received appreciations from Business users for creating Dashboards looks and feel like their sample reports.

Environment: MicroStrategy 9.2.1 (Administrator, Desktop, Architect, Web, Narrowcast Server, Object Manager, Enterprise Manager, Office, Report Services), Teradata, Windows NT

Confidential

MicroStrategy Developer

Responsibilities:

  • Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
  • Created MicroStrategy Schema objects basically data architecture sand Application objects using MicroStrategy Desktop and Architect.
  • Creating Pivot charts and KPI Reports using MS Excel and Lookup functions.
  • Developed Customized and Ad-hoc reports in Grid & Graph mode using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations - The end-users were able to generate Ad-hoc Report by Drilling up, down, within and across dimension or anywhere.
  • Execute periodic - weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
  • Moved Objects from one environment to other.
  • Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
  • Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
  • Tracking enhancement projects to ensure the project delivery on time.
  • Effectively manage Changes through Change management process.
  • Created Summary and Drill down reports for various attributes based on their hierarchies.
  • Efficiently handle and Manage production support activities through Incident Management.
  • Project Metrics collection and reporting to senior management.
  • Used free form SQL editor for complex report creation.
  • Weekly status review with client.
  • Identify potential development opportunities and propose innovative solutions.
  • Making sure that always sticking with the SLA (Service Level Agreements) commitments and producing SLA report to client and management.

Environment: MicroStrategy 9.2.1, MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Informatica, Oracle 9i, Oracle SQL Developer, Teradata SQL, Windows XP/2000.

Confidential

MicroStrategy BI Developer/Analyst

Responsibilities:

  • Analysis and Design and development of ERP Bolt-on’s for sourcing, demand and retail management
  • Coordination and resolution of production issues with support team
  • Design and development of BI applications for retail business using MicroStrategy. Development of new reports and metrics for inventory management, retail store operations, pricing, markdowns etc. I had worked on the following projects.
  • Regular vs Markdown analysis by department (This report provides analysis to company planning executives for Retail Sales and Inventory, Unit Sales and Inventory and Margin Dollars.)
  • Lucky Specialty planning dashboard (This dashboard provide the analysis at Style level).
  • Hourly Flash Sales Dashboard (this Dashboard provide the Hourly Unaudited/audited sales and transaction KPIs).
  • Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
  • Involved in gathering business requirements and documenting specifications.
  • Created the Metadata & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Created drill maps for end users to drill down and recover data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
  • Worked on Enterprise manager to generate reports in enterprise manager
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services).

Hire Now