We provide IT Staff Augmentation Services!

Microstrategy Architect/developer Resume

4.00/5 (Submit Your Rating)

MD

SUMMARY:

  • 9+years of experience in MicroStrategy Suite (MicroStrategy Intelligence Server, MicroStrategy Architect, Desktop, Web, Narrowcast Server, Object Manager).
  • Good experience in other BI tools like QlikView v12, QlikSense v3, Tableau v9, SAP Business Objects, Hyperion, SSRS.
  • Good experience on migration reports from Business Objects, Hyperion, Tableau and SSRS to MicroStrategy.
  • Experience in working with the full project life cycle development process, involving analysis, design, development, implementation, and testing phases.
  • Extensive knowledge of Data Warehousing concepts, RDBMS and multi - dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
  • Good experience in Object model/Data model.
  • Experience in migrating objects between Development, Testing and Production environments.
  • Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance
  • Total 3 years of Team lead experience with Onshore/Offshore in Project Development Cycle.
  • Good knowledge in integrating MicroStrategy with Third Party Single Sign on tools.
  • 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 Services objects like Heat Maps, Map Widgets, Panels, Selectors, Grouping and Grid/Graph combinations.
  • Good experience with MicroStrategy Visual Insight Reports.
  • Good Experience with Transactional Report Services.
  • Experience in integrating Google maps with MicroStrategy Dashboards using Google Maps Plug-in integrating with SDK.
  • Experience in MicroStrategy Custom visualization /plugin using JavaScript.
  • Good Experience in MicroStrategy Web Customizations and advanced reporting.
  • Experienced in using Project Merge, Object Manager, and Enterprise Manager.
  • Proficient in designing reports through MicroStrategy Desktop with optimal usage of key features like Advanced filters, filters, prompts, Transformations, custom groups, and consolidations.
  • Good experience in MicroStrategy Report services documents and dashboards
  • Knowledge in Narrowcasts, Distribution services and Mobile dashboard development.
  • Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
  • Used VLDB properties such as Joins, Query Optimization, Metrics (Null Check and Zero Check), Select/Insert and Tables.
  • Worked with large Databases like Oracle, Teradata and SQL Server.
  • Good knowledge on PL/SQL Queries.
  • Expertise in Dimensional data modeling of De normalized schemas and normalized schemas.
  • Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements).
  • Created Analytic-based selectors grid/graphs that control other grid/graphs through a panel stack. Inserting as many panels as needed within a panel stack.
  • Renaming panels, change their border, and format its font and individual background colors of the title bar.
  • Created Drilling path and implement those into reports such that user can Drill across different System and User hierarchies.
  • Responsible for documenting the Functional & Technical Design documents. Responsible for completing Functional Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.
  • Experience in handling the upgrade of MicroStrategy Environment from 9.2 to 9.3.
  • Excellent communication and interpersonal skills with user and client interaction experience.
  • Ability to work in multiple projects simultaneously and independently as well as in a team environment.

TECHNICAL SKILLS:

Operating System: Win (2003/NT/XP/VISTA/7), UNIX/Linux

Reporting Tools: MicroStrategy, Qlik Sense, QlikView, SAP Business Objects, Tableau, SSRS, Hyperion

ETL: Informatica, Data stage

Methodologies: Agile and Waterfall

RDBMS: Oracle 10g/9i/8i, Teradata 12.0, IBM DB2 8.0, SQL Server

PROFESSIONAL EXPERIENCE:

MicroStrategy Architect/Developer

Confidential, MD

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Also created reports with Transaction services and FFSQL with stored procedures.
  • Used SDK to implement different folder icons.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Creating the test cases for each report and cross verifying the end results.
  • Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible in testing the reports/dashboards before moving to other environments.
  • Responsible for moving the projects from one environment to another environment (using Object Manager).
  • Integrated the MicroStrategy reports access with third party applications.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Environment: MicroStrategy 10.2, Informatica, SQL Server

MicroStrategy Architect/Developer

Confidential, VA

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible for integrating dashboards with SDK.
  • Responsible in testing the reports/dashboards before moving to other environments.
  • Responsible for moving the projects from one environment to another environment (using Object Manager).
  • Integrated the MicroStrategy reports access with third party applications.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.
  • Responsible in upgrade of MicroStrategy versionfrom9.2to9.3.
  • Providing knowledge to Users both in MSTR Desktop and Web.

Environment: MicroStrategy 9.4.1, 10.1, Business Objects, QlikView, Informatica, Oracle 9i

Lead MicroStrategy Architect/Developer

Confidential, VA

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups plugin& Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Creating the test cases for each report and cross verifying the end results.
  • Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible in testing the reports/dashboards before moving to other environments.
  • Responsible for moving the projects from one environment to another environment (using Object Manager).
  • Integrated the MicroStrategy reports access with third party applications.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.
  • Providing knowledge to Users both in MSTR Desktop and Web.

Environment: Micro Strategy 9.3.1, DataStage, SQL Server 2008

Sr. MicroStrategy Developer

Confidential, TX

Responsibilities:

  • Responsible for the Creation of Project source and projects
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups plugin& Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Monitoring the reports and doing the performance tuning.
  • Creating the test cases for each report and cross verifying the end results.
  • Extensively created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.
  • Providing knowledge to Users both in MSTR Desktop and Web.

Environment: Micro Strategy 9.3.1, QlikView, Informatica, SQL Server 2008

MicroStrategy Developer

Confidential

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Monitoring the scheduled reports and doing the performance tuning.
  • Creating the test cases for each report and cross verifying the outputs.
  • Extensively created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other tools.
  • Responsible for the Creation of Schedules and Subscriptions for Report deliveries to emails using MSTR Desktop and MSTR Web.
  • Responsible for sending reports to the user using MSTR Office and also worked in creating the URLs to generate the Reports to Mobile/iPad using Mobile Configuration in Web.
  • Administering on User Manager, enabling/disabling the User in Standard and LDAP Authentications.
  • Responsible for the Creating Users and User Groups under LDAP Authentication mode and assigning the projects and security roles.
  • Modifying the privileges to the users for the projects like enabling/disabling POWER USERS and other Standard User privileges.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.
  • Supporting the existing projects and enhancing the reports on requirement.
  • Manipulating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.
  • Providing knowledge to Users both in MSTR Desktop and Web.
  • Played major roles like Administrator/Architect/Developer in MSTR Desktop

Environment: Micro Strategy 9.2.1, QlikView, Data stage 7.5.2, Oracle 9i

MicroStrategy Developer

Confidential, GA

Responsibilities:

  • Understanding and validating business requirement and data warehouse schema and do logical data modeling for MicroStrategy.
  • Doing report design and development as per the requirement specification.
  • Creating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.
  • Used JavaScript and Validation Controls for validating the controls.
  • Created schema objects like attributes, facts and logical tables using MicroStrategy Architect rights
  • Created public objects like Metrics, Filters, prompts, custom groups and consolidations using MicroStrategy developer rights
  • Created Dashboards extensively using the Panel stacks, selectors and many more functional tools.
  • Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing team to discuss the user requirements and status updates.
  • Supporting the Project team in SIT and UAT testing.
  • Worked in a Scrum Agile process with two-week iterations delivering documents/report and dashboard at each iteration.
  • Working closely with ETL team for collecting data and testing team for resolving defects.

Environment: MicroStrategy 9, Hyperion 9, IBM DB2, Teradata, SQL Server

MicroStrategy Developer

Confidential, Milwaukee, WI

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups plugin& Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Creating the test cases for each report and cross verifying the end results.
  • Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible in testing the reports/dashboards before moving to other environments.
  • Responsible for moving the projects from one environment to another environment (using Object Manager).
  • Integrated the MicroStrategy reports access with third party applications.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Environment: Micro Strategy 9.4.1, MSBI, Data Stage, SQL Server 2005

We'd love your feedback!