SUMMARY

• 8+ years of experience in Micro Strategy 9.x/8.x
• Experience in leading, managing and monitoring teams for various projects as project lead
• Involved in using MicroStrategy Tool Suites including (MicroStrategy Intelligence Server, Narrowcast Server, Desktop and Web).
• Experience in installation, upgrading, configuration, Project creation and tuning of MicroStrategy Business Intelligence.
• Very good understanding of Data Warehouse Architecture and Designing.
• Experience in working on Direct Project Source and Server Project source.
• Expertise in Analysis, design and construction of the metadata.
• Involved in Creation of Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in developing Application objects (filters, prompts, metric, custom groups, consolidation, searches) to develop documents and reports.
• Expertise in using Pass - Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Expertise in Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Expertise in creating Hyperlinks in Documents and Drill Reports.
• Experience in creating advanced Custom Filters by using Pass-Through Expressions in MicroStrategy.
• Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Experienced with different kinds of Dashboards like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• Fine tuning of the MicroStrategy reports using Data mart Reports, Partition Mappings and Aggregate tables.
• Involved in Administration tools like Object Manager, Schedule manager and Command Manager.
• Expertise in Defining Micro Strategy Narrowcast Server objects like Service, Schedule, Subscription set and Information Objects.
• Experience in duplicating the project and also experience in Migrating the object from one project to other.
• Involved in Migrating objects from one environment to other.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy 9.3.1, MicroStrategy 9.2.1m, MicroStrategy 9.0.2, MicroStrategy 9.0.0, MicroStrategy 8.1.x (Hotfix 3.0)

Data Modeling: Normalized, De-normalized, Star and Snow Flake Schemas

Databases: SQL Server 2005/2007/2008 , Oracle9i, MS Access, Teradata, Netezza

ETL Tools: SQL Server Intelligence Services (SSIS)

Programming Languages: SQL, C

Development Tools: SQL Agent

Quality Assurance Tools: Bugzilla

Domain Knowledge: Online Marketing and Web Analytics, Retail and Construction Industry

Operating System: Windows, Red Hat Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Architect

Responsibilities:

• Gathered requirements from client
• Designed schema model
• Created schema objects, public objects, reports, documents, dashboards
• Migrating objects across the environment
• Technical Issue Management - Analysis, Isolation, Diagnosis and resolution of reported technical platform or configuration issues
• BI Application Deployment Management - Support to developers and project teams in the release of applications and application change management. Processing and logging of new capabilities as they migrate from development to pre-production and from pre-production to production.
• Daily Operations Monitoring and Management
• Introduced the concept of Dashboard and Visual analysis to the client.
• Reconfigured the whole environment of the client in all 3 environments
• Reconfigured the Project source settings for performance tuning.
• Daily based update meetings with the team

Environment: MSTR 9.4.1, Cloud, Teradata, Netezza

Confidential, New York

MicroStrategy Architect/Administrator/ Project lead

Responsibilities:

• Gathered requirements from client
• Designed schema model
• Created schema objects, public objects, reports, documents, dashboards
• Created MSTR mobile applications
• Upgraded MicroStrategy environment
• Conducted checkpoint review meeting
• Set up MicroStrategy environment
• Manage and monitor 10 member team in MicroStrategy development and project completion
• Migrated projects from one environment to another
• Set up Migration process
• MicroStrategy upgrade from 9.2.1m to 9.3.1 HF3. I held the role of key technical resource and project coordinator for the upgrade of a 600+ user MicroStrategy environment. I was directly involved or leading all aspects of the project including planning, installing and upgrading, and validation testing. I was also tasked with upgrading all web customizations
• Technical Issue Management - Analysis, Isolation, Diagnosis and resolution of reported technical platform or configuration issues
• BI Server Configuration Management - Planning and implementing growth and change to the BI server infrastructure. Precise tracking of current and future states.
• Application Performance Management and Capacity Planning - Tracking of application usage and performance measurement histories. Analysis, diagnosis and resolution of performance issues.
• BI Application Deployment Management - Support to developers and project teams in the release of applications and application change management. Processing and logging of new capabilities as they migrate from development to pre-production and from pre-production to production.
• Daily Operations Monitoring and Management
• Introduced the concept of Dashboard and Visual analysis to the client.
• Reconfigured the whole environment of the client in all 3 environments
• Reconfigured the Project source settings for performance tuning.
• COnfigures Enterprise Manager and configured it.
• Daily based update meetings with the Team in New York and India.
• Working on Building the User Groups and identifying and deleting the unused objects.
• Worked with database teams on upgrade pre requisites

Environment: MSTR 9.3.1, Red Hat Linux, Windows, Teradata 14, Oracle

Confidential, Arizona

MicroStrategy Architect/Administrator/ Team lead

Responsibilities:

• Gathered requirements from client
• Designed schema model
• Created schema objects, public objects
• Created complex MicroStrategy reports/dashboards
• Created Mobile reports
• Deployed Mobile apps
• Worked on User License management. Total 3500 users
• Reduced MicroStrategy CPU consumption to reduce the licensing cost
• Migrated projects from one environment to another
• Upgraded MicroStrategy environment from 9.0.2 to 9.2.1m. Technical lead for the upgrade. Upgraded 23 servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues. User base was 3500+
• Worked on Netezza upgrade MicroStrategy testing

Environment: MSTR 9.2.1m, Red Hat Linux, Windows, Netezza, Oracle

Confidential, New Jersey

MicroStrategy Architect/Developer/ Team lead

Responsibilities:

• Gathered requirements for the Scorecard and Reports with clients
• Created design documents and mockups for scorecards and reports
• Designed schema model
• Created Schema Objects needed for development of the Scorecard
• Designed and developed complex MicroStrategy reports
• Involved in performance improvement process of the reports

Environment: MSTR 9, Red Hat Linux, Windows, Teradata, Oracle

Confidential, Pennsylvania

MicroStrategy Developer

Responsibilities:

• Studied and analyzed the existing database
• Created Report Description document
• Created Report and Dashboard design Document
• Create MicroStrategy Reports in MicroStrategy 8.1.2
• Developed dashboards in MicroStrategy 8.1.2
• Worked on MicroStrategy office 8.1.2
• Created excel macros for the application

Environment: MSTR 8.0, Windows, SQL server

Confidential, Pennsylvania

MicroStrategy Developer

Responsibilities:

• Analyzed the requirements
• Studied and analyzed the existing database
• Studied existing MicroStrategy Project and Schema to identify gaps
• Created Report and Dashboard design Document
• Created MicroStrategy Schema and Application Objects - Attributes, Facts, Metrics, Filters, etc.
• Create MicroStrategy Reports in MicroStrategy 8.1.2
• Developed 1 new dashboard in MicroStrategy 8.1.2
• Modified 4 existing dashboards - added panels, new reports, edited existing panels, etc.

Environment: MSTR 8.0, Windows, SQL server

Confidential

MicroStrategy Developer, QA Engineer

Responsibilities:

• Analyzed the reporting requirements for the project
• Assisted in preliminary data quality analysis
• Consolidated report requirements for the project, based on the dashboard requirements
• Developed reports required for the project in MSTR 8.1
• Wrote test cases for dashboards
• Conducted selective data testing on dashboards by writing SQL code against the database (SQL Server 2005)
• Tested the Dashboard and completed the Test Case
• Used Bugzilla as the Issue Reporting tool for the project

Environment: MSTR 8.0, Windows, SQL server, Oracle

Confidential

QA Engineer

Responsibilities:

• Wrote test cases for dashboards
• Wrote SQLs for data checking of dashboards
• Tested dashboards’ look and feel and data
• Logged all the encountered issues in BugZilla
• Project work, modeled upon actual Confidential ’ customer’s applications, consisted of the analysis and development of data warehouse/business intelligence solutions as further described below:

Environment: MSTR 8.0, Windows, Oracle, SQL server

Confidential

Data Warehousing Associate

Responsibilities:

• SQL Essentials education and training
• Introduction to Data Warehousing
• Data Warehouse Design
• Data Integration
• MicroStrategy Business Intelligence Platform - MicroStrategy Certified Engineer (MCE) training.
• Courses: Reporting Essentials, Project Design, Advanced Reporting, Enterprise Reporting, Dynamic Enterprise Dashboards, Intelligence Server Administration, Enterprise Manager, Command Manager, Object Manager, Web Report Design and Analysis, Development Standards, and Narrowcast Server.
• Consulting Skills Training including communication skills, decision making, time management, email writing and client management