SUMMARY:

• A MicroStrategy Certified team player with over 12 years of IT experience in software development, designing and implementing with major focus on Business Intelligence tools, Data Warehousing and Database Applications.
• Worked on Actuate Administration Like Restarting the Apache and Actuate from Console and Command Line.
• Installing, Upgrading Configuring from various Version of MicroStrategy on Unix and Windows Family Servers.
• Installed and Configured Intelligent Server and Narrowcast Server to schedule execute and deliver reports using various delivery methods.
• Configured reports for end users in Narrowcast Server, Desktop, MicroStrategy Web.
• Successfully upgraded all MicroStrategy Intelligence Server 6 projects to MicroStrategy 7 Intelligence Server projects using the MicroStrategy 7 Project Upgrade Wizard.
• Successfully performed the Mapping of Application objects (Styles, Projects, XSL stylesheets).
• Provided relevant business insight to the authorized users via E - mail (SMTP), Web (SQL) and other popular communication devices.
• Expertise in Creating Dashboard applications and Scorecards.
• Practical experience of Logical Data Modeling and Data Warehousing concepts.
• Follows and enhances best-practices in terms of design, development and documentation standards.
• Extensive Working Experience with MicroStrategy 6.X/7.X/8x,9X MicroStrategy NarrowCast Server, Broadcaster, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, MicroStrategy Agent,, MicroStrategy MDX Adapter, Transactor.
• Expert in Creating MicroStrategy reports implementing MicroStrategy projects.
• Pro-active involvement in continuous performance improvements for existing OLAP systems
• Experience with ETL methodology for supporting Data Extraction, transformations and loading processing, in a corporate-wide-ETL Solution using INFORMATICA (Power Mart/ Center 4.7/1.7 - Meta Data Repository, Designer, Server Manager).
• Experience using ERWIN 3.0/3.5 as leading data modeling tool.
• Logical Data Warehouse / Data Mart designs to support the required OLAP analysis.
• Proven experience in complete life cycle of Design, Construction, Maintenance and Documentation of Data Marts.
• Extensively worked in Business Intelligence Data warehousing tools including Business Objects 5.0, Cognos Powerplay 6.61.
• A good understanding of Oracle, Teradata and SQL Server with respect to Enterprise Data Warehouses.
• Excellent communication skills and professional demeanor gained through extensive interaction with public, team work and leadership roles.

TECHNICAL SKILLS:

Business intelligence: MicroStrategy 6x / 7.1.1, 7.2.1, 7.2.3, 7i, 8.0,8.01,8.02,8.03,8.1.1,9.0 (MicroStrategy Desktop/Web, Intelligence Server, Narrowcast Server, MDX Adapter, Transactor), Business Objects, COGNOS.

Databases: Oracle 10g,9i/8i/7.x, Teradata 12/13, DB2, SQL Server

Utilities: Oracle SQL-loader, Visual Basic, Oracle Forms 6i, Reports 6i, ERWIN 3.5

Languages: C, PL/SQL JAVA Visual C++ 6.0, Visual Basic 6.0, Oracle SQL*Plus, PL/SQL.

ETL Tools:: Datastage,Informatica, SQL* Loader

OS: Window NT/2000/98, Sun OS 5.6,AIX 5.03,Unix

PROFESSIONAL EXPERIENCE:

Confidential, Oldsmar,FL

Microstrategy SME/Architect

Responsibilities:

• Worked on gathering requirement and transferred them to Logical and Physical model using Microstrategy and Performed Several POC for Various Teams.
• Upgraded MicroStrtagey10.1 from 9.4 on POC and Development Linux Servers.
• Installing Microstragey Web on Tomcat Apache Web server.
• Developed Microstrategy Reports, Dashboards and Visual Insight Reports.
• Developing MicroStrategy Schema/Public objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Set analysis and Data-mining
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Worked on Cloud migration using AWS and Azure.

Environment: MicroStrategyDesktop9.4-10.1, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server10.1Confidential, Maclean, VA

Sr.MicroStrategy Consultant

Responsibilities:

• Developed and Designing MicroStrategy Schema objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Data-mining, Data mart reports, etc)..
• Understood Business requirement and created Reports and Complex Static and Dynamic Dashbaords.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Extensively created and used Custom groups and Consolidations.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports

Environment: MicroStrategy Desktop9.3, MicroStrategy Intelligence Server9.3, SQL Server 10.0, SQL

Confidential, Losgatos CA

Sr.MicroStrategy Consultant

Responsibilities:

• Developed MicroStrategy Schema objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Data-mining, Data mart reports, etc)..
• Understood Business requirement and created Reports and Complex Static and Dynamic Dashbaords.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting.
• Configure reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Extensively created and used Custom groups and Consolidations.
• Used MicroStrategy Office to connect Microsoft Excel, through MicroStrategy Intelligence Server.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports

Environment: MicroStrategy Desktop9.3, MicroStrategy Intelligence Server9.3, Teradata 13.0, SQL

Confidential, Oldsmar,FL

Sr. Microstrategy Consultant

Responsibilities:

• Installing MicroStrtagey9.3 on POC and Development Linux Servers.
• Created User,Groups,Security Roles and Setup Microstrategy Projects.
• Installing Microstragey Web on Tomcat Apache Web server.
• Developed Microstrategy Reports, Dashboards and Transactional Services.
• Developing MicroStrategy Schema/Public objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports, etc).
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Good Working Knowledge on Iphone and IPAD using Microstrategy.

Environment: MicroStrategyDesktop9.2.1-9.3, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server9.2.1, Narrowcast Server9.2.1, Oracle, SQL, TOAD 8.6, RHL Server

Confidential, Swiftwater,PA

Sr. Microstrategy Consultant

Responsibilities:

• Understanding and Translating “Flue Zone” and “Zflu” User Requirement.
• Created Complex Dynamic Dashboards using Panels, Panel stacks, Dynamic Texts and Selectors.
• Used some of the Common Widgets Like Microchart, Heat Map, Bubble Graph or Bar Chart with Trend Line etc.
• Worked on Visual Insight, Visual Crossing and Google Maps.
• Hands on Experience on IPAD and Customized to fit the Dashboard on IPAD.
• Created Microstrategy Semantic Layer Like Schema Objects and Public Objects to meet the Business Need.
• Good Knowledge in SQL Troubleshooting and Tuning.
• Created Dynamic Subscriptions using Narrowcast.

Environment: MicroStrategyDesktop9.2.1, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server9.2.1, Narrowcast Server9.2.1, Oracle, SQL, TOAD 8.6, Windows 2000, 2003 Server

Confidential, Woonsocket,RI

Lead MicroStrategy Architect/Solution Architect

Responsibilities:

• Understood the Business Requirement and Worked with DBA and ETL team to Create Relational Data Mart at Monthly Aggregation.
• Architected and Created the Symantec Layer/Schema Objects and Public Object in Microstrategy.
• Created and Programmed Views/Procedure to Produce Correct SQL in SQLSERVER.
• Created and Designed Microstrategy Batch and Interactive Reports and Documents to fulfill Business Need.
• Designed and Programmed Narrowcast Server Using Dynamic Subscription to produce files on shared drive location.
• Created Batch Files and Set up a Process using Control M to Automate Report Generation that takes less than 6 Hours to produce comparing 48 Hours Using Legacy System.
• Successful Completion/Deployment to UAT, PROD and Provided Support for Final Product in Production Environment.
• 100% Successful Track Record to Complete the Project on Time and in budget.

Environment: MicroStrategyDesktop9.2.1, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server9.2.1, Narrowcast Server9.2.1, SQL server 2005, Oracle 11g.

Confidential, Dover,NH

Sr. MicroStrategy Architect

Responsibilities:

• Architected the Complete Daily and Monthly Data Marts tables for Microstrategy Reporting.
• Highly Engaged in Gathering and Understanding the Business Requirement to Translate into Technical Specification.
• Created Logical Views and Macros for Solve Complex Logic in Teradata.
• Designed Schema and Non Schema Objects and Performed User Training,

Environment: MicroStrategyDesktop9.2.0, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server9.2.0, Narrowcast Server9.2.0, Teradata, SQL, Teradata SQL Assistance.

Confidential, Oakbrook,IL

Sr. Microstrategy Consultant

Responsibilities:

• Tuning Some of the Most Complex Dashboard and Reports in TDA Reporting.
• Redesigning Reports and Dashboards to in corporate McDonalds Guidelines and Best Practices.
• Worked on Several Project Enhancements and Bug Fixes in MicroStrategy and Teradata Side in Global and Market Analytics.
• Created Most of the Schema and Non Schema Objects for Report Development/Dashboards.

Environment: MicroStrategyDesktop9.0.0, ObjectManager, EM, IntergrityManager, MicroStrategy Intelligence Server9.0.0, Narrowcast Server9.0.0, Teradata, SQL, Teradata SQL Assistance, Windows 2000, IBM AIX 5.1

Confidential, Atlanta,GA

Performance Tuning Project Lead Consultant/BI Architect

Responsibilities:

• Responsible for Leading the Team for Tuning and Upgrade from 8.11 to 9.0.0
• Review Confidential .’s current performance issues
• Identify factors that hinder performance across 3 Tiers (Data, Application and Presentation)
• Analyze, Capture, Present and Document performance improvement recommendations
• Make changes where necessary and possible across all tiers
• Promote and Deploy recommendations into new MicroStrategy 9 environment.

Confidential, Mclean, VA

Sr. MicroStrategy Consultant

Responsibilities:

• Developing MicroStrategy Schema/Public objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports, etc).
• Created very complex reports eg: Market-Basket Analysis involving interactive web and windows interface.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Derived metrics, Compound metrics and Filters, Filter in a metric- for very complex reports.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting.
• Configure reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Extensively created and used Custom groups and Consolidations.
• Used MicroStrategy Office to connect Microsoft Excel, through MicroStrategy Intelligence Server.

Environment: MicroStrategy Desktop8.1.1, MicroStrategy Intelligence Server8.1.1, Narrowcast Server8.1.1, DB2,Sybase, SQL, Toad 7.6, Windows NT / 2000, IBM AIX 5.1

Confidential, White Plains, NY

Sr. MicroStrategy Consultant/Administrator

Responsibility:

• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Developed MicroStrategy Schema objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters and Reports
• Create the design document, personalize the reports as per user requirements, which included customizing and formatting
• Create Dashboards and Documents using Flex, Flash and Widgets.
• Configure reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Used MicroStrategy Office to connect Microsoft Excel, through MicroStrategy Intelligence Server
• Installing, Version Upgrade, Configuring of MicroStrategy Products Renewing the License Key and activation of the Servers, Warehouse and Metadata on Unix Box.
• Performing Object Migration of almost 200 Objects In a week among Development, QA, Staging and Production.
• Installing Oracle 10g R2 on Windows and Unix Box and Configuring them to use as MicroStrategy Metadata
• Back Up and Archive MicroStrategy Metadata, Enterprise Manager, and Other schemas using Oracle Export Utility.
• Perform Restore of the Metadata in Case of Crisis or Corruption using the Oracle Import.
• Perform and Run Scan MD and MD Doctor Utility to Fix Metadata issues.
• Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
• Writing Windows Script and PL/SQL to automate Most of the MicroStrategy Functionality Including Project Duplication, Cache Purge Project Compare and Merge
• Large User Creation, Group Assignment, Role Creation, ACL and security filter intensively using Command Manager Utility.
• Installing, Deploying and Registering Narrowcaster Server, Setting Up NC Static and Dynamic Subscriptions, Services and Send Now.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Good Knowledge of SSO, Customization, External Security using MicroStrategy SDK.
• Familiar with Sun/iplanaet LDAP, Web seal, IBM Web sphere, Web logic, Apache Tomcat, IIS and have Good Knowledge of Deploying the Portlets.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Image Push to Both Intelligence and Web servers for Report Service Documents using Core FTP or FileZilla.
• Developed attributes, matrices, facts, Consolidation, Custom Groups and Reports.
• Used the Prompts to automate the report execution and scheduling the reports using job scheduler.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project
• 24/7 Production Support and aware of Famous Ticketing system Like Service Now, Manage Now and IBM Clear Quest for issue tracking.
• Configuring MicroStrategy Email Job alerts using Site Scope.

Environment: MicroStrategy 8.1.1, 8.1.2, 9, Desktop, MicroStrategy Intelligence Server, Narrowcast Server, Report Editor, Configuration Wizard, Warehouse Catalog, Attribute Creation Wizard, Fact Creation Wizard, Oracle 11g, Windows NT / 2003, REDHAT Linux,AIX5.03,Solaris 10.

Confidential, Kansas City,KS

Sr.Microstartegy Contractor

Responsibilities:

• Optimization, Installation, Configuration and design of MicroStrategy Data Warehouse and Metadata.
• Developed and Designed attributes, matrices, facts, Consolidation, Custom Groups and Reports.
• Used the Prompts to automate the report execution and scheduling the reports using job scheduler.
• Created a DB instance for Microstrategy and added all the tables, table prefixes and updated the table structure required for the Project
• Setting the security roles, Creating user groups and users for different projects.
• Worked with UDB files and generated users in Batch .
• Reproducing the whole project from DB2 to Teradata and setting the users accordingly.
• User support for production box and validating the jobs running on servers.
• Optimization of the reports for maximum performance, using the VLDB settings, checking the joins and table structure.
• Migrating the projects from Development to QA box or Production using the object manager and checking the dependency.
• Supporting QA and proving on site support to them in test script generation.
• Worked on Informatica 7.0 as an ETL tool to extract data from source systems to Target system.

Confidential, El Dorado Hills,CA

Sr. MicroStrategy Consultant

Responsibilities:

• Creation, Administration, Optimization, and Maintenance of all MicroStrategy platform components using MicroStrategy Architect
• Created project plans for development of MicroStrategy projects.
• Designed and translated Logical Data Models into various Physical Warehouse Schemas.
• Partitioned fact tables, used to speed up database query performance, are identified by MicroStrategy Architect using a partition mapping definition
• Created MicroStrategy Facts, Attributes, Hierarchies, Aggregate tables, and partition Mapping
• Developed System Hierarchy and User Hierarchies, to contain an arbitrary number of attributes and paths between them.
• Created and managed database connections to various data stores.
• Designed and created transformations enable users to perform sophisticated time-series analysis across metrics by grouping and comparing data at different time-periods.
• Developed of OLAP cubes and both ad-hoc and regular reports for purposes of analysis of user levels.
• Developed common reports used in Narrowcast Server.
• Developed more than 50 Reports for Sales, Human Resource departments.
• Provide relevant data to the Project Manager and build estimates and technical specifications.
• Defined definitions and created metrics, attributes, filters, prompts, Custom Groups and consolidation objects in MicroStrategy
• Implemented proactive, personalized, and relevant information delivery networks using MicroStrategy Narrowcast Server.
• Configured Narrowcast Server and built Narrowcast Services from scratch.
• Created Services using Static, Dynamic, and execution flow Subscription Set.
• Managed important administrative features like scalability, failure recovery, and troubleshooting meeting needs of projects.
• Created a Subscription Portal to enable the end-user the ability to define their own personalization and self-subscribe to services.
• Documented and reviewed design documents with the team, prototyped and obtained Director feedback at early stages of design, coordinated test plans, and provided feature/functionality/usage scenarios to documentation.
• Outlined Report Functional and Technical Specifications for the Report Development at Global Development Center in India.
• Review of report specifications and Unit Testing of reports.
• Involved in Formatting, SQL Inspection and Data Reconciliation steps for Reports.
• Worked with Confidential on resolving 8.0 issues.
• Worked with teradata and other databases to do the performance tuning and indexing the database to improve the scalability and performance mapping.

Environment: MicroStrategy Desktop 8.0.2, MicroStrategy Intelligence Server 8.0.2, MicroStrategy Web 8.0.2, Narrowcast Administrator 8.0.2, Oracle 10g, Teradata,Windows 2000/NT, ERWin 4.1.

Confidential, Sacramento,CA

Sr. MicroStrategy Consultant

Responsibilities:

• Responsible in designing the schema using DSS Architect with a special focus on User interface design.
• Created different desktop objects like filters, prompts, metrics, consolidation, custom groups, transformation, and drill maps.
• Worked on advanced features like heterogeneous column mapping, relationship filters, joint-child relationship, and Fact extensions.
• Developed Auto prompts to support end users by giving choice of different filtering criteria when they run the report every time.
• Involved in developing complex reports through Micro Strategy Desktop.
• Developed Reports enabling Data Drilling across multiple Dimensions using Agent and Web. Graphs and Alerts were used to support the Reporting process.
• Used Object Manager or duplication feature to promote development object into test project and finally to production.
• Deployed and administrated reports on web.
• Accomplished the broadcasting technology using Narrowcast server 7.2 for generating services.
• Defining Meta data strategies for growing user Community
• Administrating Narrowcast Server.
• Created the Information source modules to gather content from external sources.
• Created Various Narrowcast Server Objects like Information Object, Publication, Question Object, Service and dynamic Subscription sets.
• Worked with analysts to identify System Entities, Relationships between entities, Cardinality of relationships, Attributes.
• Identified Primary Keys, Alternate Keys, Foreign Keys
• Designed the Logical Data Model by identifying the Non Key Attributes, Data types and Lengths
• Designed the Physical Data Model by Converting Entities to Tables, Converting Attributes to Columns, and by applying Constraints of Host RDBMS
• Demoralize as Constraints dictated.

Environment: MicroStrategy Desktop 7.5.1, MicroStrategy Intelligence Server 7.5, MicroStrategy Web 7.5.1, Narrowcast Administrator 7.5.1, Erwin Data Modeler 4.1, Oracle 8i, MS SQL Server 2000/7 DTS Windows 2000/NT.