SUMMARY:

• 10 years of experience in Business Intelligence (BI) project development and implementation using MicroStrategy product suites including MicroStrategy Desktop/ Architect /Developer, Web, Architect and Administrator.
• Experience with MicroStrategy components - Mobile, Integrity Manager, Object Manager, Command Manager, Intelligence server, Narrowcast server and OLAP services.
• Experience MicroStrategy versions 8x/9x to 10.4.
• Extensive knowledge in Data Warehousing concepts, RDBMS and multi-dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Experience in working with the full project life cycle development process, involving analysis, design, development, implementation, and testing phases.
• Proficient in designing Reports with advanced features like Advanced filter qualification, prompts, Transformations, custom groups, and consolidations.
• 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).
• Strong experience in designing and developing interactive Dynamic Dashboards using Report Services objects like Heat Maps, Map Widgets, Panel Stacks/Panels, Selectors, Grouping and Grid/Graph combinations.
• Experience in developing Mobile dashboards and Transactional ServicesReport.
• Good experience with MicroStrategy Visual Insight Reports.
• Experience in integrating Google maps with MicroStrategy Dashboards using Google Maps Plug-in integrating with SDKand have good knowledge on MSTR SDK.
• Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance
• Have 3 years of Team lead experience with Onshore/Offshore in Project Development Cycle.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Strong skills in performance tuning usingVLDB properties and understand the reports SQL and verify across the databases.
• Worked with large databases like Oracle, SQLServer and Teradata.
• Strong experience in writing sql queries across all major databases to validate reports data.
• Strong experience in performance tuning writing sql queries in step by step manner in finding the defects and Query Optimization.
• An in-depth grasp of SQL reporting, analytics and business intelligence.
• Good experience in other BI tools like QlikSense, QlikView, Tableau, SAP Business Objects, Hyperion, SSRS.
• Designed and developed reports/dashboards in QlikSense/QlikView.
• Good experience in migrating reports from Business Objects, Hyperion, Tableau and SSRS to MicroStrategy.

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 (CA Rally) and Waterfall

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

PROFESSIONAL EXPERIENCE:

MicroStrategy Sr. Architect/ Developer

Confidential, Washington D.C

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 creating Transactional Service Reports.
• 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 data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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: MicroStrategy 10.4, Ab-Initio, Big Data, DB2

MicroStrategy Sr. Architect/Developer

Confidential, MD

Responsibilities:

• Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groupsplugin& 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.
• Responsible for data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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: MicroStrategy 10.4, QlikSense, SQL Server 2008

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/dashboards, Metrics, Filters, Prompts, Custom Groups & Consolidations and other public objects.
• Responsible for designing the Reports as per the user stories.
• Also created reports with Transaction services and FFSQL with stored procedures.
• 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.
• Responsible for data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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.
• Developed reports/apps in QlikSense(Need to migrate complex apps to MicroStrategy)
• Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Environment: MicroStrategy 10.4, QlikSense ver. Sept 2017,Informatica, SQL Server

MicroStrategyArchitect/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 data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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

LeadMicroStrategyArchitect/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.
• Responsible for data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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. MicroStrategyDevelope

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 Groupsplugin& 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.
• Responsible for data validation using sql queries across the database to validate reports data.
• Document the unit test case results at both report level and database (sql queries).
• 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

MicroStrategyDeveloper

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

MicroStrategyDeveloper

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, IBMDB2, 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