We provide IT Staff Augmentation Services!

Microstrategy Architect/developer Resume

Charlotte, NC

PROFESSIONAL SUMMARY:

  • 10+ years Experience in MicroStrategy and DWBI.
  • MicroStrategy Certified, MicroStrategy Certified Engineering Principles(MCEP), MicroStrategy Certified Engineer(MCE), MicroStrategy Certified Developer (MCD).
  • Strong work experience in MicroStrategy 9.x/10.x/11.1.
  • Worked as BI Architect and assisted in Admin activities.
  • Experience working in Agile development environment.
  • Experience working in Azure Cloud environment.
  • Experience in creating and integrating MicroStrategy Reports, Dynamic Dashboards,Dossier, MOBILE Dashboards, Enterprise manager reports,and objects with the data warehouse.
  • Demonstrated Proof of Concepts to Various customers in Dossier, Dynamic Dashboard, Mobile Dashboard and MicroStrategy Capabilities
  • Designed and Developed Intelligent Cubes, Cube Reports and Dashboards
  • Developed Schema objects (facts, attributes, hierarchies, transformations, logical tables, table aliases) using MicroStrategy Architect.
  • Designed and Developed Templates, Filters, Prompts, Metrics, Base Formula, Consolidations and Custom Groups.
  • Extensively used Dynamic Dashboards/Scorecards for executives/senior management using Report Services Documents.
  • Implemented Dynamic Dates, VLDB Properties, Threshold, Report Data Options, Formatting, Advanced Sorting, Export Options, Prompt Ordering, Totals, Outline Mode based upon the business user change request on UAT Testing
  • Developed and maintained Daily, Weekly, Monthly, Quarterly, Annual Performance reports using EXCEL and MicroStrategy.
  • Strong working knowledge of report architect and development experience, deployment of MicroStrategy components on sources like Oracle, MS SQL Server,Netezza and Teradata.
  • Involved in Customer Training, Support and Maintenance.
  • Outstanding exposure with End - to-End implementation and maintenance of Data Warehousing and Database OLAP Reporting projects.
  • Extensively worked with End Users on the UAT of the Reports.
  • In-Depth industry experience in Retail/Manufacturing and Financial Services.
  • Trained in Basics MicroStrategy SDK web Customization
  • Excellent analytical and communication skills with great commitment to demanding schedule.
  • Highly comfortable working with technical and business teams. Involved in a team which received Best Team of the Quarter Award from MicroStrategy
  • Managed the Entire Software Development Life Cycle for a Custom Business Application
  • Managed multiple BI teams with various projects, in different MSTR versions as Lead BI architect
  • Designed and Developed Dynamic Dashboard, Mobile Dashboards which received Best Dashboard of the Quarter Award by MicroStrategy

SKILLS SUMMARY:

Tools: Microstrategy, Netezza, SQL Server, MS Access, .Oracle, DB2, Teradata, Visual Studio, Office, Java, C, C++, Informatica, Cassandra DB

Industry Applications: Transportation/Shipping, Retail/Wholesale Distribution, Banking, Marketing, Telecommunications, Automotives, Pharmaceuticals, Health Care

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MicroStrategy Architect/Developer

Responsibilities:

  • Involved in report requirement gatherings from Business users.
  • Involved in Data Modelling and and proposed Data Model recommendations from MicroStrategy perspective.
  • Architected the Project Schema objects such as Facts, Attributes, Table Alias, Logical Tables, etc.
  • Designed and developed Simple, Derived,Compound,Conditional and level based metrics.
  • Extensively used Filters,Prompts, templates,derived elements and Custom groups to generate reports/Dossier for business analysis.
  • Created existing SSRS reports in MiroStrategy.
  • Designed and developed standard and Adhoc reports, icubes, documents and dossier.
  • Created adhoc Dossier connecting to External data sources(Database, Excel) and published in MicroStrategy Library.
  • Created Enterprise Manager reports and Dossier to analyse Statistical data (User and Reports analysis).
  • Served as Tech Lead/Architect/admin support and managed 100+ end users.
  • Assisted MicroStrategy developers and end users with MicroStrategy Developer/Desktop and web reports.
  • Used SSMS extensively to test and debug MicroStraegy reports as a key step in data validation.
  • Involved in tunning reports and Dashboards/Dossier by using VLDB settings, Report Data options and Project level settings.
  • Prepared and maintained the MicroStrategy object migration documents, release notes to migrate the changes between environments(DEV,UAT and PROD).
  • Migrated and validated objects from DEV to UAT using object Manager.
  • Developed and deployed in Agile/Kanban development environment with 2 weeks sprints.
  • Created Users, User groups,Security filters and managed MicroStrategy Users and Projects.
  • Worked on multiple projects in different versions(10.4,MSTR 2019,MSTR .1))
  • Created and tested Power BI reports for business to connect Via MSTR using connectors.
  • Worked closely with Admins during MSTR upgrades in Azure cloud environments.
  • Created schedules and subscriptions for Daily alert, weekly and monthy reports.
  • Involved in UAT testing, user training and production support and Maintenance for the Business users.

Environment: MicroStrategy .1), MicroStrategy 2019, 10.4, Developer,Desktop, Web

Confidential, Charlotte, NC

MicroStrategy Architect/Developer

Responsibilities:

  • Understand and analyze existing report requirement.
  • Worked closely with BA’s to gather requirement and created mockup’s to business.
  • Feasibility study of new requirements using MSTR and provide workaround for Microstrategy limitation.
  • Developed reports and documents using Microstrategy Desktop and Web.
  • Created Visual Insights Dashboards as per requirements.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated metrics.
  • Designed and Developed excel and pdf Reports and demonstrated to business.
  • Created schedules and subscriptions for monthy extract reports.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Worked in Agile environment by Participated in daily status,Product gromming, Sprint planning and Retrospective.
  • Involved and worked in creating the process documentation.
  • Trained Client developers in how to create MSTR reports and documents.
  • Created object prompts and involved deployed in Various environments.
  • Performed Unit testing and Validating the reports.

Environment: MicroStrategy 10.1, 9.4.1, Desktop, Web

Confidential, Charlotte

MicroStrategy Architect/Developer

Responsibilities:

  • Involved directly with the business to gather Business requirements.
  • Created public objects like freeform sql reports, Intelligence cubes, filters, metrics, prompts.
  • Designed and Developed Reports, Dynamic Dashboards using various VI Widgets and demonstrated to business.
  • Involved and worked with admin team to create cube tidal jobs.
  • Created schedules and subscriptions for monthy extract reports.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated metrics.
  • Worked in Agile environment by Participated in daily status,Product gromming, Sprint planning and Retrospective.
  • Involved and worked in creating the process documentation.
  • Created packages and deployed in Various environments.
  • Performed Unit testing and Validating the reports.

Environment: MicroStrategy 9.4.1, Desktop, Web

Confidential, Charlotte

MicroStrategy Architect/Developer

Responsibilities:

  • Created schema objects Attributes, Facts, Hierarchies and Transformations
  • Developed MSTR objects by creating reports, filters, metrics, custom gropus and prompts using MicroStrategy Desktop.
  • Designed and Developed Reports, Dynamic Dashboards using various Widgets
  • Designed and developed Mobile Dashboard using various graphs and Widgets
  • Rebranded Microstrategy using basic MicroStrategy Web SDK

Environment: MicroStrategy 9.4.0,Mobile, Desktop, Web

Confidential

MicroStrategy Architect/Developer

Responsibilities:

  • Developed MSTR objects by creating reports, filters, metrics, and prompts using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Designed and Developed Reports, Dynamic Dashboards using various Widgets
  • Created and modified Internal MicroStrategy Administration in Change Point

Environment: MicroStrategy Mobile, Desktop, Web

Confidential, Mooresville, NC

MicroStrategy Architect/Developer

Responsibilities:

  • Involved directly with the business to gather Business requirements.
  • Designed and developed the Dynamic and Mobile Dashboard.
  • Demonstrated various Dynamic Dashboards, reports and Microstrategy capabilities to Business users
  • Involved in Proof of Concepts for Mobile Dashboards
  • Developed MSTR objects by creating reports, filters, metrics, and prompts using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated metrics.
  • Implemented transformations along with metrics to analyze the data between two time periods.
  • Analyzed the reports and created Intelligent Cubes, Scheduled and subscribed cubes, Created cubes based reports and Dashboards
  • Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
  • Delivered the reports in Desktop, Microstrategy Web and via Distribution services.
  • Used VLDB properties to optimize the SQL generation of the MicroStrategy reports for improved performance
  • Designed solution specific documents (SSD) and High level Design documents (HLD) for implementation and inter component dependencies
  • Created advanced filters using Joint Element List, Custom Expressions, Relationship Filters
  • Participated in Weekly status and planning meetings.

Environment: MicroStrategy 9.0.2, Terradata.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

  • Involved and Analyzed the Facebook Data
  • Created Web tags in Data Enrichment Team.
  • Involved in Creating Schema Objects (Facts, Attributes) using Microstrategy Architect.
  • Developed Application Objects (Metrics, Reports, Documents, filters, prompts) using Microstrategy Desktop and Microstrategy Web interfaces

Environment: MicroStrategy Mobile, Desktop, Web

Confidential

Developer - CFO Mobile Dashboard

Responsibilities:

  • Involved in gathering the requirements, Designed and developed the CFO Mobile Dashboard.
  • Developed MSTR objects by creating reports, filters, metrics, and prompts using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Created Consolidations and Custom Group for summarized reports

Environment: MicroStrategy Mobile, Desktop, Web

Confidential, Minneapolis, MN

Developer/Architect - Merchandising Dev

Responsibilities:

  • Involved and performed Schema changes if required by the other reporting team members.
  • Created Schema objects such as Attributes, facts, Hierarchies.
  • Involved directly with the business to gather Business requirements, Design and develop the FDC MOS PUSH Compare Dashboard.
  • Developed MSTR objects by creating reports, filters, metrics, and prompts using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, and Filters.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated metrics.
  • Implemented transformations along with metrics to analyze the data between two time periods.
  • Designed and developed Dynamic Dashboards using Pannel stacks, Pannels and selectors for users to Compares weekly FDC MOS and PUSH, dollars and units, relative to weekly FDC receipt activity using Report Services Documents.
  • Created Templates to drill down from reports to templates.
  • Documented all objects like reports, prompts, filters, and metrics for user references
  • Comfortably worked in a stage environment with change management, defect tracking and status reporting processes.
  • Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
  • Participated in daily status and monthly planning meetings.

Environment: MicroStrategy 8.1.2, DB2, MSTR Web.

Confidential, Charlotte, NC

MicroStrategy Architect/Developer

Responsibilities:

  • Installed MicroStrategy Version 9.x with Mobile and created connection to Metadata and I-server.
  • Created Schema Objects like Attributes, Facts, and Hierarchies.
  • Designed and Developed MSTR objects by creating reports, filters, metrics, prompts and templates using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, Filters, Custom Groups and Consolidations.
  • Created Sonic Dashboard and involved in mobile implementation at Sonic.

Environment: MicroStrategy 9.x, SQL Server, MSTR Web

Confidential, Boston, MA

MicroStrategy Developer

Responsibilities:

  • Analyzed business requirements from BRD document.
  • Created Schema Objects like Attributes, Facts, Public Objects like Metrics, Filters, and Prompts.
  • Produced reports utilizing Public and Schema Objects.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated filters, attributes and metrics
  • Designed and developed Dynamic Dashboards for executives/senior management using Report Services Documents.
  • Created subscriptions to delivered reports through emails using Distribution services.
  • Involved in the testing of Microstrategy reports through Microstrategy Web.
  • Involved in Migration and defect Tracking.
  • Involved in Daily Status and Planning Meetings.
  • Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.

Environment: MicroStrategy 9.x, SQL Server, MSTR Web

Confidential, Charlotte, NC

MicroStrategy Developer

Responsibilities:

  • Created Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
  • Created Objects like Complex Filters using pass through functions.
  • Troubleshoot objects like Prompts, Filters, Complex Metrics, Consolidations & Custom groups.
  • Created Transformations used in comparative reports.
  • Designed and Created Dynamic Dashboard using Report Services Documents.
  • Worked with interns and guide them in developing reports and Dashboards.

Environment: MicroStrategy 9.x, SQL Server, MSTR Web.

Confidential, Rayleigh, NC

MicroStrategy Developer

Responsibilities:

  • Analyzed business requirements from BRD document worked closely with end Users to get exact business requirements.
  • Designed and Developed MSTR objects by creating reports, filters, metrics, prompts and templates using MicroStrategy Desktop.
  • Created reports utilizing Metrics, Compound metrics, smart metrics, Prompts, Filters, Custom Groups and Consolidations.
  • Implemented OLAP Functions like ApplySimple, ApplyComparison for the complicated metrics.
  • Implemented transformations along with metrics to analyze the data between two time periods.
  • Developed reports using advanced filters, Custom Expression (Apply Simple, Apply Comparison) and Joint Element list for robust reports.
  • Designed and developed Dynamic Dashboards for Regional RVPs and Regional Account Managers, as well as the Regional Accounts Customer Analysis group using Report Services Documents.
  • Comfortably worked in a production environment with change management, defect tracking and status reporting processes.
  • Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
  • Participated in daily status and monthly planning meetings.

Environment: MicroStrategy 9.x, Teradata, MSTR Web.

Hire Now