PROFESSIONAL SUMMARY:

• Certified MicroStrategy professional with 10+ years of experience in IT industry.
• Over 8+ 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. Worked on panel stacks, widgets, and customization.
• Experience in Integrity Manager, Object Manager, Transaction Services and Visual Insight.
• Experience in Administration tasks like User, User Group, Scheduling, Security Roles.
• Extensive back ground and knowledge of Stored Procedures, Triggers and Functions.
• Strong experience in interacting with clients and translating business needs.
• Well - Organized, Quick learner, Self-motivated Team Player

TECHNICAL SKILLS:

Reporting Tools: Microstrategy, Business Objects

Databases: Oracle, DB2, SQL Server

Languages: 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, Healthcare, Auto/property insurance, correspondent mortgage domain

WORK EXPERIENCE:

Microstrategy Developer

Confidential, Phoenix, AZ

Technology: MicroStrategy, DB2

Responsibilities:

• Involved in the documentation of technical specifications of the NYA adequacy project.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards
• Well versed in 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, 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.
• 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

Technology: MicroStrategy, DB2

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.
• Extensively used passthru 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.

Confidential

Technology: MicroStrategy, DB2

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development
• Worked extensively in creating the schema objects Atrributes, Facts, Transformations, Hierarchies etc.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• 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.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Extensively worked on Layers, Panels, Selectors and different graph types.
• Extensively worked on the passthru functions.
• 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.
• Training new team members in Microstrategy.
• Support UAT and post production validations.

Software/Business Intelligence Developer

Confidential

Technology: Business Objects, Oracle

Responsibilities:

• Design, Development and Testing of Reports.
• Involved in UAT and production support.
• Point-of-Contact for all Reporting related tasks for the offshore team

Confidential, NJ

Technology: COBOL, JCL, VSAM, Easytrieve, Syncsort, File Aid, IMS DB.

Responsibilities:

• Requirement analysis, Estimation, Design and Creation and execution of Test Cases.
• Analysis, Design, Development, Review and Testing.
• Time and Cost Estimations for enhancements supporting Confidential .
• Providing Production Support.
• Ensured high degree of quality in the deliverables.