PROFESSIONAL SUMMARY:

• Confidential with 12+ years of experience in IT industry.
• Over 9+ years in Data Modeling, Design, and Development of MicroStrategy Reporting
• Experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Development, Testing, Implementation and Support.
• Expert in Architecture like creating Schema objects with MicroStrategy Desktop like simple and compound Facts, Attributes, Fact extensions, Hierarchies, Transformations.
• Experience in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups) with the data warehouse.
• Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Sorting, Grouping and Filtering.
• Experience in creating Intelligent Cubes using Complex Filters and Compound Metrics.
• Experience in designing interactive Dynamic Dashboards using Report services objects like Waterfall, Graph Matrix, Gauges, Micro Charts Widgets, and Grid/Graph combinations.
• Experience in creating illustrative Dashboards and Documents, panel stacks, widgets, and customization.
• Experience in Architect, Integrity Manager, Object Manager, Transaction Services and Visual Insight.
• Experience in Command Manager and System Manager.
• Experience in Metadata, IServer, Web Server, Mobile Server, Narrowcast Server.
• Experience in Administration tasks like User, User Group, Scheduling, and Security Roles.
• Extensive experience in Stored Procedures, Triggers and Functions.
• Strong experience in interacting with clients and translating business needs.
• Familiarity with Agile (Scrum) project methodology and practices.
• Well - Organized, Quick learner, Self-motivated Team Player

TECHNICAL SKILLS:

Reporting Tools: Microstrategy, Business Objects

Databases: Oracle, DB2, SQL Server, Teradata, Hadoop

Languages: SQL, Visual Basic, COBOL, JCL

Data Warehouse: DW Architecture, ETL & Reporting Process, Data Modelling

Operating System: Windows XP,VISTA, 8.0

Other tools: HP Quality Center, Microsoft Project Plan (MPP)

Domain Knowledge: Banking, Retail, Healthcare, Auto/property insurance, correspondent mortgage domain

WORK EXPERIENCE:

Microstrategy Architect

Confidential

Responsibilities:

• Involved in the knowledge transfer documentation of technical specifications of the ShopperView project.
• MircroStrategy architect at onsite.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards
• Creating different schema objects like Attributes, facts, Hierarchies and Transformations.
• Involved in creating public objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Extensively worked on Cubes.
• Designed interactive and visually stunning Dynamic Dashboards using multi layout, widgets, Grid/Graph combinations etc.
• Extensively worked on Layers, Panels, Selectors, and Templates etc.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Have hands-on experience in Command Manager and System Manager. Used these two products as a part of a value adds to the project.
• Worked extensively on VLDB Properties for performance tuning.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Involved in UAT support and post production validations.
• Training the new users in Microstrategy.

Microstrategy Developer

Confidential, Phoenix, AZ

Responsibilities:

• Involved in the documentation of technical specifications of the NYA adequacy project.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards
• Creating different schema objects like Attributes, facts, Hierarchies and Transformations.
• Involved in creating public objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Designed interactive and visually stunning Dynamic Dashboards using multi layout, widgets, Grid/Graph combinations etc.
• Extensively worked on Layers, Panels, Selectors, and Templates etc.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked extensively on VLDB Properties for performance tuning.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Took training on Hadoop and started working on it in a short span.
• Helped the team members to get familiarize with the Hadoop.
• Created Partition Mappings and Aggregate tables to improve performance of reports.
• Involved in UAT support and post production validations.
• Training the new users in Microstrategy.

Microstrategy Developer

Confidential

Responsibilities:

• Involved in complete development life cycle of the project including gathering requirements, user interaction and report design, development and rollout.
• Worked extensively in creating different schema objects like Attributes, facts, Hierarchies and Transformations.
• Created Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Worked on creating illustrative dashboards using Layers, Panel Stack, Selectors and widgets.
• Worked on various graph types and Multi layout reports.
• Created Transformations for using in comparative reports like revenue this year to last year
• Worked on Intelligent Cubes to solve the performance issues.
• Created User, User Group, Scheduling, Security Roles.
• Migrating components to different environments.
• Extensively used pass-through functions in attributes and filters.
• Support UAT and post production validations.
• Demonstration of reports and Microstrategy training to the clients

Confidential

Technology: MicroStrategy, DB2

Responsibilities:

• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked extensively in creating different schema objects like Attributes, facts, Hierarchies and Transformations.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Worked on creating illustrative dashboards using Layers, Panel Stack, Selectors and widgets.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Handling slowly changing dimensions in a data warehouse depending on the user needs.
• Involved in the creation of Intelligent Cubes and Aggregate Tables to improve performance of the Reports and dashboards.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Support UAT and post production validations.
• Training of Microstrategy to the new users.