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