SUMMARY:

• 11+ years of Experience in implementation of Business Intelligence and Data warehousing Solutions including 7+ years of MicroStrategy full life cycle Implementations.
• Experience in Design, Development and Maintenance of Microstrategy 9.x &10.x product suites in Banking, Travel & Hospitality, Retail and Consumer Goods Sectors.
• Expertise in MicroStrategy components including Architect, Desktop, Web, Intelligence Server, Distribution Services, Integrity Manager, Enterprise Manager, System Manager.
• Expertise in Architecting Microstrategy Schema (including Attributes, Facts, Hierarchies, Transformations)
• Expertise in creation of Public Objects (Metrics, Filters, Prompts, Custom Groups, Consolidations)
• Expertise in Project planning, Resource Planning and presentation of Proof of Concepts (POC)
• Expertise in Creation of Reports, Report Services Documents, Static and Dynamic Dashboards
• Expertise in creation of Dynamic and Multi panel dashboards using various Widgets and Selectors.
• Created Mobile Dashboards for iPad and other devices.
• Expertise in implementation of Microstraegy OLAP services (including Intelligence Cubes, Dynamic souring reports).
• Expertise in Enterprise Architecture of Microstrategy (Two - Tier, Three-Tier modes).
• Experience in Performance tuning queries.
• Expertise in creation of Distribution Services subscriptions using Time based and Event based triggers.
• Expertise in creation of System Manager workflows for Automation of running Dashboards & Cubes
• Expertise in Data Warehouse Architecture and Design.
• Involvement in Dimensional Modeling using Star Schema, Snowflake Schema and Relational Models.
• Expertise in using programming languages SQL and PL / SQL.
• Proficient in using Teradata & Netezza Databases.
• Expertise in migration of reports from Actuate, Crystal Reports in to Microstrategy.
• Successfully lead the development and Support teams, onsite and offshore coordination.
• Experience in change management, problem solving, team coordination and mentoring team members.
• Experience in giving User Training in Microstrategy.
• Excellent communication skills, interpersonal and analytical skills

TECHNICAL PROFICIENCY:

Business Intelligence: MicroStrategy 9.1/9.2/9.3/9.4/10.4/10.8 , Actuate and Crystal Reporting, Tableau (Learning), DOMO (Learning), Sisense (Learning), SAP BW

ETL: Informatica 10.x

Database: Teradata, Netezza, Amazon Redshift

Languages: SQL, PL/SQL

Development Tools: TOAD, SQL Plus, Aginity Workbench for Netezza & Redshift

Additional Tools: SAP ECC

PROFESSIONAL EXPERIENCE:

Confidential, NY/NJ

MicroStrategy Architect

Responsibilities:

• Business Requirement gathering and analysis to develop the design documents for the team
• Development of Schema Objects (facts, attributes, hierarchies, Transformations) and Public objects (filters, prompts, metrics, consolidations, custom groups, reports)
• Creation of Dashboards and Report Services documents, Visual Insight Services in Microstrategy 9.4, 10.4
• Creation of report services documents with multiple layouts and grouping options.
• Development of Logical views using SQL query on Desktop.
• Development and Configuration of Intelligent cubes and Report caching technique
• Creation of Aggregate tables to improve performance of reports.
• Setting up VLDB Properties at Report, metric and database instance Levels to manage Join, Metric calculations and query optimizations
• Provide production support and resolve the errors in production environment.
• Migration of objects from Development to QA and form QA to Production using Object Manager.
• Testing of Microstrategy reports for consistency using Integrity Manager.
• Configuration and setup of Microstrategy in Mobile devices and provide support of Mobile Dashboards
• Project lead and oversight activities including onsite and offsite co-ordination
• Training and Monitoring new resources in the team.
• Business User Training in Microstrategy

Environment: AWS Cloud, MicroStrategy 10.4.1 (9.4.1 upgraded) Desktop, Architecture, Web, OLAP Services, Administration, Dashboards, Netezza, Amazon Red Shift

Confidential

MicroStrategy Sr. Developer

Responsibilities:

• Requirement gathering from onsite team and the business users, creation of Design specification for the Reports, Documents and the Dashboards.
• Documenting Functional Specifications and Development of Technical Specifications.
• Proof of concept (POC) presentation by providing the business users with the sample reports.
• Presented POC for implementation of MicroStrategy Mobile Dashboard using Google Maps
• Creation of Schema objects and Public objects.
• Creation of Attributes, Facts, Hierarchies and Transformations.
• Worked extensively on creating Metrics, Filters, Prompts, Custom Groups and Consolidations.
• Creation of Dashboards and Report Services documents in Microstrategy 9.2.1.
• Created Dashboard with multiple Panels, Panel stacks selectors.
• Used selectors including Fisheye, Drop Down, Check Boxes, Radio Buttons, Button Bar, List Box and Date Selectors.
• Published dashboards in Flash and DHTML modes.
• Creation of Report services Documents with multiple tabs and grouping options.
• Creation of subscriptions using MicroStrategy Distribution services, used event based triggers.
• Creation of standard and complex reports with page by and break by options.
• Designed and Developed Templates, OLAP Reports using MicroStrategy.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.
• Setting up VLDB Properties at Report, metric and database instance Levels to manage Join, Metric calculations and query optimizations.
• Configuring the intelligence cubes, creation statistical tables.
• Execution of Cube advisor to find out the potential opportunities of intelligence cubes and creation of intelligence cube reports for performance improvement.
• Implementation of Dynamic Sourcing, Full and Batch refresh of Intelligent Cubes using System Manager.
• Unit testing and test case preparation for the reports
• Provide production support and resolve the errors in production environment.

Environment: MicroStrategy 9.2/9.3, Desktop, Architect, Web, OLAP Services, Distribution Services, Dashboards, Teradata.

Confidential

Microstrategy Developer / Team Lead

Responsibilities:

• Analysis of the existing reports in Actuate.
• Technical Design of the reports through Reverse Engineering process by analyzing the Actuate design file of the Report.
• Involved in creation of Schema Objects (Attributes, Facts, Filters) and Application Objects (Metrics, Derived Metrics, Prompts and Filters) for these Reports
• Involved in creation of complex Reports and MicroStrategy Report Service Documents
• Involved in creation of Free-form SQL reports based on SQL queries and Stored Procedures.
• Extensively used Drill link functionality through URL API and Drill Map and creating Reports at various levels of data granularity.
• Extensively used multiple sections and Conditional Formatting features in Report services Documents to achieve the Client requirement
• Involved in development of documents with multiple layouts and sending it to the users through Report Bursting technique.
• Involved in writing complex SQLs to optimize the Performance of Reports
• Involved in giving KT sessions on Actuate and MicroStrategy tools to the Team Members.

Environment: MicroStrategy 9.2, Desktop, Architect, Web, OLAP Services, Dashboards, Oracle, Actuate.

Confidential

Actuate Developer

Responsibilities:

• Co-ordination with Onsite, development of custom reports, gathering functional enhancements/requirements, application interface development and delivery of new custom reports for web application.
• Interacting directly with client Business Analysts to gather information for new Custom reports.
• Writing requirements and technical specification, new report design, modifying existing reports and implementation.
• Developed Schema Objects and Application Objects by analyzing the Dimensional Model and Business Requirements
• Created some very complex Reports, Scorecards and Dashboards.
• Peer reviewed deliverables of other team members
• Playing a role of initiating the Knowledge Transfer sessions for new team members.
• Leading the Actuate team (for Development and Design) and helping in the Ramp up of team members. Involved in sending the Status Report and Debugging the issues faced during Production release

Environment: Actuate 8 & Actuate 9, Desktop, DB2, TOAD

Confidential

Actuate Developer

Responsibilities:

• Migrating Actuate Reports which are developed in Actuate-7 to Actuate-9, hereby doing the porting of the reports.
• Support work where changes on the Database side and enhancements on the report queries depending upon the requirement.
• Working on the Performance Tuning of the queries of Actuate-9 reports

Environment: Actuate 7/ 9, Toad, VB Scripting, SQL Server, Windows 2005, MS Excel 2001.