SUMMARY:

• Microstrategy Desktop: Reporting Essentials.
• Microstrategy Desktop: Advanced Reporting 200 - Case Studies.
• Microstrategy Desktop: Advanced Reporting 200.
• MicroStrategy Report Services: Advanced Documents for MicroStrategy Desktop.
• MicroStrategy Report Services: Dynamic Dashboards 100.
• MicroStrategy Report Services: Advanced Dynamic Dashboards 200.
• Microstrategy: Engine Essentials.
• Microstrategy Advanced Data warehouse.
• Microstrategy Data Mining Services and advanced Analytics.
• Microstrategy Administrator.
• Microstrategy Web Administration and Tuning.
• Microstrategy Intelligence Server Tuning and Advanced Administration.
• Microstrategy Enterprise Manager Essentials.
• Microstrategy Engine Tuning and VLDB Properties.
• Microstrategy Transaction Services for Dashboards and Mobile App.
• Microstrategy SDK Customization Essentials.
• Microstrategy SDK Visualization.
• Microstrategy Web Professional.
• Microstrategy Mobile for Apple@ IPad and IPhone@.
• Microstrategy Free Form SQL Essentials.
• Microstrategy Web SDK: API Essentials.
• Microstrategy Web SDK: Customizing Security.

PROFESSIONAL EXPERIENCE:

Confidential

MSTR BI Application Consultant

Project Assignments

• Lead the developer’s team for establishing Penetration & Retention Project
• Perform connections and architecture of the Penetration & Retention Project.
• Preform the architecture side and building the semantic layer for the project.
• Participate in developing the supporting reports, documents and dashboards.
• Perform web customization at the web server using windows .NET - Prompt customization using WCE, and Eclipse.
• Perform basic to advanced customization scenarios (look & feel, Navigation work flow and functionality) .
• Good command in Portal integration with MSTR portlets and url API, personalization, configurations and security with SSO.
• Convert 5 dashboards from flash to DHTML.
• Creating packages for migration across environments.
• Coaching the team of developers and provide the technical advices in their day to day activities.
• Perform some admin activities for maintain users and groups. Creating customized reports using Enterprise manager to monitor caches, reports performance.,

Confidential

Sr. Applications Development Manager

• Acting as Primary Architect/Designer / for multiple MSTR projects for compliance & metrics Analytics.
• Coaching the team of developers and provide the technical advices in their day to day activities.
• Participated in Compliance Metrics & Analytics Project including for adding features and enhancement for 6 dashboards.
• Participated in designing MSTR Dashboards to be integrated EEMS / Entitlements Projects
• CitiRisk - Acted as a primary architect lead for Consumer Fraud, Fraud Risk Assessment, Fraud Operations and Consumer management Reporting - Projects. Which were conversion project from BO into MSTR
• Compliance Metrics Project - Fully responsible for implementing new Dynamic security features to the reporting environment, (8) Dashboards enhancements and fine tunings.
• Configure & Customize WEB MSTR for Compliance metrics Project Web SDK. JSP, Plugins API’s, Java scripts. CSS. HTML5 DOM, XML.
• Responsible for redesign the existing WH/ Data Mart’s Schemas. (SQL scripts, Stored procedures, MVs and views)
• Responsible for creating Schema Design, WH architecture, Command manager scripts & procedures to migrate 6000 metrics, 1000 attributes, advanced metrics into the schema Layer.
• Responsible for Performing SQL Code review and performance tuning.
• Creating CM scripts for Bulk Objects Creation via Procedures/Outlines and CM scripts.
• Developed cross project Security roles, Objects Privileges, Transmitters, Schedules, Alerts and subscriptions.
• Responsible for configuring and setting-up the Project source, Project-settings, connectivity, DB instance, maintaining the WH Catalog.
• Utilize MSTR 10 new features with multi DB input sources, data blending and governances.

Confidential

MSTR Team Lead

• Primary Architect/Designer to Multiple MSTR Projects.
• Lead a group of Business analysts/ETL Developers/SQA Testers in developing and implementing MSTR Projects.
• Participate in Scrum meetings/Internal Reviews.
• Conduct fine tuning and the resolution of the performance issues.
• Support MSTR Development team in the technical issues and provide the technical advices.
• Responsible for creating the necessary migration packages across various environments.
• Collaborate with MSTR admins in defining customized setup for special projects.
• Follow-up with the Data modelers on the logical and physical Schema design and manage all aspects of project designer’s tasks.
• Professional in using MSTR IM, CA, CM, EM utilities.
• Re-designed and developed Enterprise Dashboard for Orders Management system using MSTR V9.4
• Created multiple reports, documents for various projects and Visual insights.
• Reconstruct and redesign Order Type Dashboard, Order Category Dashboard and Order Volume Dashboard to apply new features /enhancement and to enhance the performance
• Performing fine tuning for all reports, documents for the assigned projects.
• Performing dynamic reporting design which enables eliminating object redundancy.
• Upgrading the projects to utilize I cubes to allow more shared datasets and enhance the performance of retrieving the data.
• Applying VLDB properties that suit the design to tweak the SQL engine to generate the best optimal performance and code generation.
• Responsible for redesign Unit Pricing Project and building the schema layer strategy.
• High exposure to data blending.

Confidential

Sr. MSTR project Manager

• Responsible for Managing, architecting and developing (Supplement project) which includes architecting the financial P&L and BS as subject area. The project focuses on building I cubes out of Sybase Pearl DB Schema and create a visual model of VI analysis and bundle of reports/documents that support the business needs.
• ESSBASE MDX Conversion Project that configure, map, import Essbase MDX cube into MSTR project and extract hierarchies, measures and implement metrics. Generates bundle of reports with full OLAP services features as a POC, building an I Cube off MDX cube, create Data marts out of MDX Cube and utilize MSTR report/documents and dashboard delivery.
• Participated in converting 18 slides (Documents) from using SYBASE datasets into I CUBE usage.(PMR Project)

Confidential

Sr. BI Architect

• Responsible for creating and architecting MSTR VSIMS (Valuation Services information Management System) Project for the reporting group.
• Participate in Designing the Data warehouse that works well for MSTR.
• Created a data model for the 13 reports - with high degree of Complexity- that need to be converted from BO/Crystal Reports into Microstrategy.
• Maintain the Warehouse Catalog (MSTR).
• Created the required schema objects and define the relationships.
• Perform the developing phase for the bundle of reports.
• Conduct testing the output results.
• Apply SQL engine performance settings to enhance the query performance.
• Participate in Agile Scrum meeting and update the management of the project progress.
• Participate in conversion process for Grid/Documents COGNOS into MSTR for Profitability and analytics reporting Application (Netezza/Oracle 11g).

Confidential

Team Leader/Sr.Systems Analyst

• Translate business requirements using complex methods and models to determine appropriate system solutions.
• Work with end users, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities using MicroStrategy.
• Support all phases of project lifecycle (design, build, test, and implementation), including business process change and enhancements
• Provide technical leadership on complex projects by devising approach and cohesive solutions
• Partner with Data Model and ETL teams to convey enterprise data needs for reporting requirements
• Perform gap analysis on business requirements and technical design, recommend adjustments if necessary
• Participate in ETL and physical data model design and reviews
• Collaborate with cross-functional teams in creating optimal, maintainable, and scalable architecture
• Owns and manage enterprise BI application environment strategies for (Development, QA, and Production environments)
• Perform migrations of objects between project sources
• Provide support for development issues related to architecture and/or performance
• Support user, performance and regression testing efforts
• Mentor, coach, and train fellow associates in technical and business competency growth

Confidential

Project Team Leader/Sr.Systems Analyst

• Managed and implemented ARAMCO Cash Management System for Treasury dept., which included user requirements gathering, analysis, design, and developing, prototyping and implementation phases.
• Responsible for remodeling the customer information business process with related accounts and programs migration process.
• Participate in managing and analyzing the Pool rate project for treasury Dept.
• Responsible for General Ledger accounts enhancement and implementation.
• Conducted preparing the cost-benefit analysis and added-functions for the account statement project.
• Managed and designed the development of the Credit/Debit Advices.
• Supervised and developed Phase-1 of the proposed E-brokerage system.
• Assisted in planning Migration project for the Core-System from NCR9800 to UNIX.
• Was chosen as a committee member for Strategic planning concerning Y2K problem project’s phases, schedule tasks, staff resources assignments.