We provide IT Staff Augmentation Services!

Microstrategy Sr. Developer Resume

0/5 (Submit Your Rating)

Arlington, VA

SUMMARY

  • Over 10+ years of IT experience with well acquainted in performing as Business Intelligence Developer with strong experience on MicroStrategy Desktop, Architect and Administrator using MicroStrategy tool Suite with strong domain Knowledge of Financial Bank, Manufacturing and Retail industry.
  • Comprehensive working experience with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Narrowcast Server and OLAP Services Environment.
  • Extensive experience in Software Analysis, Design, Development and Production Support of Business Intelligence application using MicroStrategy.
  • Extensively worked in creating and integrating MicroStrategy Reports and Objects like Attributes, Facts, Hierarchies, Transformations, Filters, Metrics, Prompts, Templates, Consolidation and Custom Groups.
  • Experience in MicroStrategy Architect, Office, Narrowcast, User security management, Object Manager designing reports grid, drilldown, ad hoc, OLAP cube and dashboards in MicroStrategy 8x/9x/10x.
  • In - depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
  • Created Tableau Dashboards with interactive views, trends and drill downs.
  • Created dashboards, Scatter Plots, Bullet charts and Heat Maps using Tableau Desktop.
  • Developed Freeform SQL reports and integrated into MicroStrategy Report Services Document.
  • Experience in Microstrategy schema application layer, report analysis report services dynamic dashboards design, development, implementation, migration and testing.
  • Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
  • Extensive knowledge on SQL and very large databases like DB2, Oracle 9i, SQL Server v2005 & v2008, Teradata V2R5, V2R6, V12 and Netezza v4.2.
  • Experience working with MicroStrategy and BigData (Hadoop) collaboration.
  • Teradata Basics V2R5 certified professional.
  • Involved with the Full Life Cycle Development of project using Object Manager, Integrity Manager and Command Manager.
  • Excellent problem-solving skills with strong technical background and good interpersonal skills.
  • Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.x/9.x/8.x Desktop, Architect, Administrator, Web, Intelligence Server, Distribution Services, Report Services and OLAP Services

Databases: DB2, Oracle 9i, SQL Server v2005/v2008, Teradata V2R5/V2R6/V12 and Netezza v4.2

OS: Windows XP/ 2010/2003/2000 and UNIX

PROFESSIONAL EXPERIENCE

MicroStrategy Sr. Developer

Confidential, Arlington VA

Responsibilities:

  • Involved in gathering business requirements and documentation specifications.
  • Created schema objects such as Attributes, Facts and Hierarchies.
  • Created public objects like Reports, Filters, Metrics, Prompts, Custom Groups, Consolidations.
  • Created Reports, Dashboards and FFSQL Reports.
  • Created Intelligent Cubes and extensively worked on improving performance of Intelligent Cubes.
  • Troubleshooting and analyzing data issues within reports.

Environment: MicroStrategy Desktop v10.4, Teradata v12, JIRA and Teradata SQL Assistant 12.0

Confidential

MicroStrategy Architect /Sr. Developer

Responsibilities:

  • Involved in gathering business requirements and documenting specifications.
  • Responsible for all MicroStrategy Architecture/Development.
  • Modified Existing version of MicroStrategy objects to meet the requirements.
  • 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.
  • Worked on learning zone reporting project which involves key metrics such as Percentage certified, trained in conjunction with various business attributes in the organization.
  • 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.
  • Tested all the reports by running queries against the warehouse using Toad Query tool. Also compared those queries with the MicroStrategy SQL engine generated queries.
  • 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.
  • Hands on experience on Tableau Desktop versions 7.
  • Created dashboards, Scatter Plots, Bullet charts and Heat Maps using Tableau Desktop.
  • Converted existing BO reports to tableau dashboards.
  • Collaborating with business partners to provide technical report assistance.
  • Provided end user training for the MicroStrategy Web users.
  • Had a significant role in managing the time estimates and co-ordination with different teams in the project.

Environment: MicroStrategy Desktop v10.4/v9.4, MicroStrategy Architect, Object Manager, Visual Insights, Toad for Data Point Tool v3.4 & Netezza v4.2.

MicroStrategy Developer

Confidential

Responsibilities:

  • Involved in collecting the business requirements and documenting the specifications.
  • Work with Business Analysts to develop analytical approaches that meet business requirements.
  • This involves translating requests into database queries, analyzing data, and transforming results into actionable reports
  • Design and develop complex reports and dashboards using MicroStrategy Desktop and Web.
  • Created advanced reports, consisting of data analysis by combining a template with filters.
  • Ability to analyze data and develop meaningful custom reports.
  • Develop Standard as well as Ad-Hoc Reports Visual Insights Analysis using MicroStrategy BI platform.
  • Responsible for building cubes and drill through in reports/dashboards.
  • Developed attribute filter prompts to give end users a choice of different filtering criteria each time they run the report.
  • Created complex dashboards using panels, panel stacks, grids, graphs and widgets.
  • Reduced the time taken for the reports to run by taking advantages of VLDB properties and working with DBA's.
  • Validating report results against requirements for consistency and accuracy.
  • Worked on Teradata SQL assistant to understand the data related issues.
  • Worked on HP QA tool to track and update the defects related to MicroStrategy BI platform.
  • Troubleshooting and analyzing data issues within reports.
  • Collaborating with business partners to provide technical report assistance.
  • Played an important role in coordination with the entire team and managing the time estimates.

Environment: MicroStrategy Desktop v 9.2.1/8.1.2/8.1.1/8.0.3 , Teradata V2R6/v12 and Netezza v2.5, MicroStrategy Web, MicroStrategy Office, Agile, Teradata SQL Assistant 12.0 & HP QA.

We'd love your feedback!