We provide IT Staff Augmentation Services!

Microstrategy Developer Resume

San Jose, CA

SUMMARY

  • 8+ years of extensive experience in Microstrategy Suite ( Microstrategy Desktop, Architect, Web, Narrowcast Server, Object Manager, System Manager ) as a Developer, Architect, Administrator, Tableau in Enterprise Environment, in Tableau 9.0 and 10.0 as a Developer.
  • Good experience with other BI tools like Tableau, Business Objects
  • Good experience on Migration of reports from Business Objects to Microstrategy to Tableau.
  • Experience in working with the full project life cycle development process, involving analysis, design, development, implementation and testing phases
  • Experience in migrating objects between Development, Testing and Production environments.
  • Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.
  • Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards, scorecards, freeform SQL reports, objects ( Attributes, Logical Views, Filters, Metrics, Transformations, Hierarchies, Drill maps, Facts and Prompts ).
  • Extensive experience in designing and developing interactive Dynamic Dashboards using Report Service Objects like Panels, Selectors, Grouping and Grid/Graph combinations.
  • Extensive knowledge in various reporting objects like Facts, Attributs, Hierarchies, Transformations, Filters, Prompts Calculated Fields, Sets, Groups, Parameters etc in Tableau .
  • Designed and Developed Interactive Tableau Dashboards and Reports, Recommending dashboard enhancements per Tableau Visualization features.
  • Worked with large databases like Teradata, Oracle .
  • Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/dashboards.
  • Capable of translating complex business needs into technical solutions (i.e. ability to understand the users’ requirements).
  • Have good understanding of Tableau Architecture, Design Development and End user experience.
  • Ability to work in multiple projects simultaneously and independently as well as in a team environment.
  • Good knowledge and understanding on data warehouse concepts.

TECHNICAL SKILLS

Reporting tools: MicroStrategy 10.x, 9.x, Tableau 9.x

Operating Systems: WINDOWS 8, XP, 2003, 2008, 2012, Solaris

Data warehouse: Teradata, Oracle

Etl Tools: Informatica

Date Modelling Tools: Erwin

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Microstrategy Developer

Responsibilities:

  • Majorly involved in understanding the data model from scratch required to generate the Dashboards.
  • Designed various templates to overcome the existing dashboard issues and presented to Business.
  • Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval.
  • Developed the dashboards based on Business inputs to overcome all the issues with existing GM Walk dashboards and data model.
  • Involved in writing complete SQLs required for reporting based on requirement.
  • Worked with Business Analysts to build reports and dynamic dashboards
  • Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.4, PostgreSQL 10.7

Confidential, San Jose, CA

Microstrategy Developer

Responsibilities:

  • Majorly involved in understanding the data model from scratch required to generate the reports.
  • Developed the Schema objects required for the project like Facts, Attributes, and Transformations, Fact Extensions.
  • Developed metrics, filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
  • Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval
  • Validated end user requirements using MicroStrategy tools Involved in design/development life cycle including gathering requirements, user interaction and report design and development
  • Involved in writing complete SQLs required for reporting based on requirement.
  • Worked with Business Analysts to build reports and dynamic dashboards
  • Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.4, Teradata 16

Confidential

Sr. Tableau Developer

Responsibilities:

  • Involved in identifying the business requirements and translating them into logical design
  • Presented the logical data model to the business and incorporated their suggestions
  • Created customized Tableau Dashboards, integrating custom SQL from Teradata and performing Data blending in Reports.
  • Developed macros in Teradata to load the data from base tables to Businesslayer tables
  • Monitoring Teradata SQLs on production using Teradata Viewpoint and provided immediate fixes as required.
  • Developed the Tableau Dashboard to report the KPIs of all the products and Player segmentation
  • Automated the dashboard to Exec’s on daily basis
  • Experience with high volume datasets from various sources like Teradata Tables, Text files, XML targets.
  • Worked under Agile methodology to deliver the changes to business

Environment: Tableau 9.1, Informatica, Teradata 13

Confidential

MicroStrategy Architect and Administrator

Responsibilities:

  • Played a key role in gathering Funtionally and Technical requirements as we have to report multiple Timezones and multiple Currencies including regulated markets like US, Spain, Denmark, France etc.
  • Involved in identifying the gaps and and business reporting requirements and translating them into database requirements.
  • Involved in discussions with various partners like PMU, Danskespil, Borgata for reporting in various Timezone’s and various currencies from a single project in Microstrategy.
  • Involved in decision making on how to proceed to bring the various Timezone’s data into one database
  • Set up new folder structures, User groups and security filters
  • Developed schema objects needed for report development needs
  • Ensured Row Level Security at database level to access single Timezone data at any point of time
  • Developed various Interactive Dashboards including various widgets, Panels, Selectors, Grouping and Grid/Graph Combinations.
  • Ensured there shouldn’t be data duplication because of various Timezones
  • Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.1, Informatica, Teradata 13

Hire Now