SUMMARY:

• As a senior resource in business intelligence with over 15+ years of experience in system automation, technology enhancement, data warehousing and reporting of multi - terabyte data warehousing projects with focus on enhancing end user value, I acquired a strong background in defining, implementing, and improving enterprise-wide reporting system to give consistent results and meet customer expectations.
• I have worked in various Business Intelligence and Data Warehousing projects that requires various skills, including Mobile, Web, SDK, BI user and change control administration skills, plus a strong project management and delivery sense.
• I am experienced in understanding business processes, and defining BI solutions that fits into the customer workflow and environment in their respective industry. Also, I coordinated several successful migration and upgrades of multiple products with tight deadlines.
• Created technical requirement specifications.
• Administration of MicroStrategy.
• Dynamic Dashboards and Scorecards creation.
• Worked with subject matter experts to identify the key business requirements.
• Created documentation standards for Data Profiling and Data Integration processes.
• Well versed in aggregating disparate data sources across an enterprise and putting the information into a consumable format.
• Created testing specifications.
• End User training and support.
• Architecture & Warehousing.
• Data Modeling & Schema Object creation.
• Managed Multi site/off-shore projects.
• Created several solution prototypes
• Strategy Planning & Development.
• Change Management.
• Vendor Management.
• Scope development and Management.
• Team management/leadership.
• Strategy Planning & Development.
• Created project plans.
• Mobile application development.
• System Performance Tuning.
• System Upgrade.
• System Manager

TECHNICAL SKILLS:

Microstrategy 9.4.1, 9.3.x, 8.x

Microstrategy Cloud

Microstrategy UAT

System Manager

Xcode Mobile Rebranding

SQL Server & Access

Teradata

Oracle

Visio

Office

Microsoft Project

LDAP

Finance

Retail

Service

Telecommunications Services

Health Care Services

Pharmacy Benefit Management

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Confidential

MicroStrategy Project Lead - Solution Architect

Responsibilities:

• Preparing the MicroStrategy Upgrade Plan to suit the client / user needs.
• Setup 9.4.1 MicroStrategy Enterprise on 6 new Linux Servers, which are used for DEV, QA and PRD Environments.
• Configuration of I-server, web server, upgrade from 9.2.1 to 9.4.1.
• Setup the 9.4.1 MicroStrategy Mobile Server’s for DEV, QA and PRD.
• Setup 9.4.1 MicroStrategy Office
• Preparing the Customization Upgrade plan in a way to preserve the 9.2.1 Customizations in 9.4.1 by using SDK and Customization editor.
• Creation of Configuration, Schema and Public objects for the new project of Sell Thru and pulling data using Oracle, SQL server, Teradata.
• Creation of MDX connection to use with the Cubes for MSAS.
• Integrity manager Object manager, Enterprise Manager and Command manager
• Creation of new I Cubes and use of Data Blending and creation of reports, Visual insights, Documents, Dashboards and Scorecards and usage of templates, custom groups and consolidations.
• Knowledge of tools like TOAD
• Enabling and implementing the Multi-Source option for 9.4.1.
• As a project lead managing the entire software lifecycle
• Using Web Sphere for 9.4.1 Web servers for deployment of MSTR WAR files.
• Leading the team in code reviews.
• Working with the management and business users to summarize technical concepts and terms.
• As a MSTR Solution Architect I am involved in interview others.
• Multiple tasking and responding quickly to urgent requirements on short notice.
• Working independently and solving the users issues as they arrive and meeting dead lines as per the tickets raised by the users. We use Oracle Siebel Customer Relationship Management (CRM) Application to stream line all the BI user requests.
• End User training and support

Confidential

MicroStrategy Project Lead (Architect)

Responsibilities:

• MicroStrategy Administrator and Team Lead responsible to resolve all the BI requests on time.
• Leading BI meetings effectively, delivering presentations.
• Setup new installation of MSTR 9.2.1 & 9.3.1 and integration with Oracle, Teradata.
• Setup New MicroStrategy Environments for DEV, TEST, UAT & PRD to ensure stable and reliable BI solutions.
• Project migrations from one environment to another and duplication using MicroStrategy Object manager
• Setup and manage New Users, user groups internal as well as business client’s external users.
• Monitoring the MicroStrategy Application resources thru Enterprise Manager tool for efficient MicroStrategy BI maintenance and BI cost reduction by removing the unwanted resources from the tool and reducing the licensing cost and improving the efficiency.
• Design and development of Dynamic Dashboards using Business Intelligence “best practices”
• Working with subject matter experts to identify the key business requirements.
• Preparing UAT testing specifications.
• Work with the technical and Business users for Architecture & Warehousing Data Modeling & Schema Object creation.
• Implemented MSTR 9.3.1 System Manager to do some automated tasks.
• As I mentioned there are approx. 3000+ BI users in this project, I am resolving the user issues and requests by providing appropriate solutions and assigning the work to my team members here in United States and Indian offshore office. We use Oracle Siebel Customer Relationship Management (CRM) Application to stream line all the BI user requests.
• End User training and support

Confidential

Sr. Consultant

Responsibilities:

• Installation and configuration of MicroStrategy Suite 9.3.x. and its components.
• Intelligence Server configuration, Mobile & Web integration.
• Development of reports, Dashboards, Mobile applications, Derived metrics, Custom. Group, Consolidation,dashboards, widgets.
• To create technical and functional designs.
• Lead and participate in implementation.
• To provide technical oversight for large project.
• Support Service management team and estimate the engagement.
• To extend MicroStrategy best practices for service delivery.
• Mentoring junior colleagues and client users.
• Requirement Gathering
• Data Modeling & Architect
• User management & creation
• Health Core Research UI Dashboard Enhancements.
• Use of One Selector as compared to duplicated selectors on the same Screen.
• Removal of Extra prompts
• Improve the Navigation by using Easy to understand and colorful Sectors
• Use of Global selectors (to control all the ACS layout screens)
• Metadata upgrade,
• Project Migration,
• Package undo,
• Automate the Intelligence Server configuration
• Creation of Metadata, DSN etc.

Confidential, Philadelphia, PA

Microstrategy Consultant

Responsibilities:

• Interacted with the client, gathered requirements and analyzed the information, then worked on data modeling & Implementation, by working closely with DBA.
• Created schema objects like attributes, facts, hierarchies, transformations and public objects like metrics, prompts, consolidations, custom groups, drill maps, Intelligent Cube and templates.
• Created offshore users and Client users with different Security roles and privileges.
• Mobile App Development and Web Integration with I pad and IPhone.
• VLDB properties for performance tuning of Microstrategy reports.
• Used almost all the widgets (data cloud, funnel, thermometer, time series slider, waterfall, List viewer, Bubble, Micros charts for KPI, heat map, Google map, Interactive grid, graphs & grids) to design the Dynamic Dashboard’s like Customer Analysis, Separate Graph Matrix widget for Region vs Item Category, Regional revenue analysis, Item level revenue Analysis, Each item Clothing Style Life cycle Analysis, Fashion Market Trends, Store type Analysis for stand alone store, Franchise, Store within a mall, “Retail Store Location Performance” based on state, city, type, employee count, performance and “Customer orders” based on income, gender, location, payment type etc. Employee Analysis at Store & Region level, “ Corporate performance Metric Dashboards” to track status and trends with Graphical Indicators (Revenue, Sales, Expenses etc. -Actual to Goals).
• Upgraded MicroStrategy 9.0.1 to 9.2.1m
• Migrated Intelligence Server Universal from Windows to 64-bit UNIX and installed the missing font files because during the migration all fonts were converted to Courier New for the PDF & HTML documents.
• Updated the Metadata, Statistics & History List repositories.
• Migration of subscriptions from a Narrowcast Server environment to Distribution Services for email, file, and print subscriptions. So making the subscriptions centralized within Intelligence Server rather than a separate Narrowcast Server.
• Used Integrity manager to test the upgraded reports for any errors, based on SQL generated. Adjusted the VLDB settings, Project preferences in the Project Configuration Editor, Intelligence Server settings in the Intelligence Server Configuration Editor, Connection properties and Authentication modes.
• Trained users on navigation and provided on-call support for the users.

Confidential

Team Lead

Responsibilities:

• I played a major role in the complete Life cycle of the Project, starting from requirement gathering to report & document creation.
• Installation and configuration of MicroStrategy BI Suite 8.x, 9.x products including MicroStrategy Desktop, Intelligence Server, Web Server, Mobile etc.
• Logical Data Modeling.
• Being an Architect, I created attributes, facts, metrics, transformations, Hierarchies, filters, intelligent cubes, drill maps, custom groups, consolidations, and prompts, derived metrics, derived elements, view filters, and dynamic sourcing.
• Independently Administrated MicroStrategy Intelligence Server and Web server and the administration tasks like user creation, security and system maintenance.
• Prepared the system for upgrade, checked the supported data types and Metadata backup. Configuration and installation of Intelligence Server and Desktop 9.0.1m on a test server and established connection to the production metadata.
• Upgraded the previous Microstrategy objects from the ver8.0x to Ver9.0.1m using Configuration wizard and Desktop tool.
• Performed the efficiency & stability testing by closely monitoring the Intelligence Server and the production metadata.
• Thereafter, started the upgrade for Web server and Mobile Server.
• Migrated subscriptions from Narrowcast server to Distribution Services.
• Complete upgrade of Enterprise Manager warehouse and statistics tables.
• Designed Dynamic Dashboard like Corporate Performance, Sales Management, Financial dashboard, Human Resources Analysis, Employee Performance, Inventory Analysis, and Customer Satisfaction.
• Converted the previously created web flash dashboards to I pad dashboards.
• Provided training to client users before and after the upgrade.

Environment: H/w: Windows2003 Enterprise Server, Microstrategy 8.x, 9.x Teradata, Oracle10g

Confidential

Operations Manager

Responsibilities:

• Requirement gathering through user interviews and feedback.
• Microstrategy Software installation.
• Connectivity of Data Warehouse & Metadata in a 2-tire / 3-tire environment.
• Configuration of Intelligent Server, User Administration & Security.
• Development of Logical and Physical data model.
• Created Schema & Public objects.
• Created specification to be used for report creation and testing.
• Operational Reports Development.
• Dashboard Development using gauges, bar & line graphs, pie charts to consolidate business information across the enterprise.
• Invoice and statement document creation.
• Configure MicroStrategy web to view reports in web.
• Microstrategy office integration.
• Narrowcast Server configuration to send and receive reports via e-mail, to a printer, or save them to a file on a scheduled or event basis.

H/W: Sun E4500 Solaris server, P IV 4GB RAM O/S: Windows NT 4.0 Oracle 8.1.7Microstrategy 7.x, 8.0