Microstrategy Architect/developer Resume
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