SUMMARY:

• 9 years of IT experience in Business Intelligence(BI) Project Development and Implementation Using MicroStrategy 10.x/9.x/8.x/7.x Product Suites including MicroStrategy Desktop, Web, Architect, Administrator, Intelligence Server, Narrowcast Server.
• Expertise in complex report development, Flash, dynamic dashboard using MicroStrategy Web and Desktop.
• Expertise in analyzing and documenting Business Requirement documents (BRD), Functional Requirement Documents(FRD) and System Requirement Specification (SRS).
• Experience in defining Test cases, review and maintaining Test scripts, User Acceptance Testing (UAT), analyzing bugs and fixing them.
• Strong SQL skills, including use of nested table expressions, unions, multi - table joins, scalar functions, derived columns.
• Well versed with the MicroStrategy product suite namely MicroStrategyDesktop, MicroStrategyIntelligence server, MicroStrategyArchitect, MicroStrategyAdministrator, MicroStrategyWeb, MicroStrategyReport Services, Microstrategy Mobile, MicroStrategyDashboards and MicroStrategyNarrowcast Server.
• Full life cycle implementation experience encompasses Business Requirements definition, Data Analysis, Data Warehouse Architecture, Deployment, Logical and Physical Data Modeling, Gap Analysis, Data Conversion, Validation, Testing Methodologies (unit, integration, stress, and bug tracking and fixing), Designing and Developing ETL modules, Building various types of Operational Data Stores (ODS), Documentation, Production Migration, Post Implementation Support, Assessment and Enhancement and Refinements for various Business Intelligence Applications
• Good Experience in Linux Environment.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricted data for particular users using Row level security and User filters
• Sound working knowledge of 2-Tier client/server architecture and N-Tier architecture
• Very good experience in working with very large databases on Oracle, Teradata, SQL Server with Micro strategy Suite
• Knowledge in Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages, and triggers
• Knowledgewith the Extraction Transformation and Loading (ETL) processes.
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements)
• Worked for various clients in telecom / Banking / insurance domain such as, NCR, Verizon and Liberty Mutual Insurance.
• Training sessions to train employees about new features in latest release and helping them upgrading MicroStrategy 8.1 to MicroStrategy 9.0.
• Demonstrated ability to work effectively with all levels of staff, customers and other IT personnel
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements)

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 7x,8x,9x,10x Administration, Tableau 10x,Narrowcast Server, MicroStrategy web, Intelligence Server and Web Universal, Report Services, MicroStrategy Office, Metadata Auditing)

Data Warehousing ETL & Relational Databases: Teradata,Oracle,SQL server, DB2, Microsoft Access.

Web server and Application server: Web Logic, Tomcat and Web sphere

Operating systems: Windows NT/2000, Windows XP, 7, UNIX (AIX, Solaris, SCO-UX, HP-UX)

Other skills: Project management, technical requirements writing, Writing Test Suite.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

MicroStrategy Architect

Responsibilities:

• Extensively involved in Data modeling, Administrator tasks, Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Narrowcast services development, complete automation of services using page by execution for performance and Use of prompt answering of Narrowcast services.
• High user interaction, understanding their requirement
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Administrative experience creating user, setting up privileges. Security access to metrics and attribute level.
• Having good Experience in SQL.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Extensive use of dynamic dashboard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• Experience with Object manager and Enterprise manager to maintain object throughout the project life cycle and improving performance of the system.
• Experience with OLAP services. Understanding of MicroStrategy architect and it's data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, metadata, project source and project.
• Actively participated in developing Report Delivery Schedules
• Created various Monthly Dynamic Dashboard documents for GBCR with multiple panel stacks, selectors and customized widgets
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.

Environment: MicroStrategy Architect 10.1,9.4,9.3,9.2.1, MicroStrategy Desktop 10.1,9.4,9.3,9.2.1, MicroStrategy Web 10.1,9.4,9.3,9.2.1,Narrowcast Server, SQL server, ORACLE 10g/11g, Natezza, Informatica Designer 6.0, Windows 2000/NT.

Confidential, Overland park, Kansas

MicroStrategy Architect/ Developer

Responsibilities:

• Managing team of MicroStrategy developers and ETL Team for onsite and offshore. Extensively involved in Data modeling, ETL Mapping, Administrator tasks, Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Narrowcast services development, complete automation of services using page by execution for performance and Use of prompt answering of Narrowcast services.
• High user interaction, understanding their requirement
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Administrative experience creating user, setting up privileges. Security access to metrics and attribute level.
• Experience in working with MicroStrategy Transaction Services and Visual Insight
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Extensive use of dynamic dashboard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• Experience with Object manager and Enterprise manager to maintain object throughout the project life cycle and improving performance of the system.
• Experience with OLAP services. Understanding of MicroStrategy architect and it's data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, ETL process, metadata, project source and project.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
• Having good Experience in SQL.
• Actively participated in developing Report Delivery Schedules
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Having Good Experience in Linux Environment
• Created Transformations for using in comparative reports like revenue this year to last year.
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.

Environment: MicroStrategy Architect 9.3,9.2.1, MicroStrategy Desktop 9.3,9.2.1, MicroStrategy Web 9.3,9.2.1,Narrowcast Server, Teradata V2, ORACLE 10g/11g, Natezza, Informatica Designer 6.0, Windows 2000/NT.

Confidential, Charlotte, NC

MicroStrategy Architect / Developer

Responsibilities:

• Training sessions to train employees about new features in latest release and helping them upgrading MicroStrategy 8.1 to MicroStrategy 8.5.
• Narrowcast services development, complete automation of services using page by execution for performance and Use of "Question objects" for prompt answering of Narrowcast services.
• High user interaction, understanding their requirement.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Huge amount of performance improvement done on existing documents by using main strength of MicroStrategy like report cache and intelligent cubes.
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Extensive administrative experience creating user, setting up privileges. Security access to metrics and attribute level.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
• Actively participated in developing Report Delivery Schedules
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets
• Having good Experience in SQL.
• Taken various measures for performance enhancement like aggregation techniques, OLAP Feature, Data mart and report caching.
• Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• High end experience with OLAP services. Understanding of MicroStrategy architect and its data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, ETL process, metadata, project source and project.
• Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering.
• Develop the reports against Star Schema and Snow-Flake Schema.

Environment: MicroStrategy9.2.1,9.0,(Desktop,Administrator,Architect,IntelligenceServer,Web,ObjectManager),Informatica, Teradata V2R5, SQL Server, Windows, Oracle10g, Erwin, Informatica 6.2, MS SQL Server, Windows

Confidential, West Chester, PA

MicroStrategy Developer

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities, Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Having good Experience in SQL.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop9.0,8.1,MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential

MicroStrategy Developer

Responsibilities:

• Performance, mobility and security requirements being met while developing solution.
• Extensive work on report development from ground up, connecting to data warehouse, defining metadata and define performance feature
• Worked on services and subscription to generate and deliver the report documents and business information to black berry, fax or email.
• Interactive report document and dashboards and dynamic dashboards with use of tooltips and highly customized features like subtotal, alerts, derived metrics, color coding, drill maps etc. to better understand about business and business trends.
• Extensive experience in troubleshooting of MicroStrategy web, desktop reports, testing and data validation.
• Features like subtotal, alerts, derived metrics, color coding, drill maps etc. to better understand about business and business trends.
• Scorecards creation for key performance indicator, including all drill options. Use of drill maps to jump and segregate data in required form.
• Extensive experience in troubleshooting of MicroStrategy web, desktop reports, testing and data validation.

Environment: MicroStrategy Desktop 8.1.2,8.0.3, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata V2R4.1, Oracle 9i, Erwin Data Modeler 3.6, Ab Initio 1.0, Windows 2000/NT and UNIX.