SUMMARY

• 8+ years of IT Experience with well acquainted in performing as MicroStrategy Developer, Architect and Administrator using Microstrategy tool Suite with Strong Domain Knowledge of Communication, Financial (Bank and Insurance), Healthcare, Retail.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, Microstrategy Web, Microstrategy Mobile, Enterprise Manager, Command Manager, Object Manager, Integrity Manager, Operations Manager, Systems Manager, MicroStrategy Narrowcast Server and OLAP Services Environment.
• Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using Microstrategy.
• Extensively worked in creating and integrating Microstrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Experience in MicroStrategy Architect, User security & management, Object Manager & designing reports (grid, drilldown, ad hoc, OLAP cube) and dashboards in Microstrategy 10.x/9.x/8.x Product Suite.
• In - depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
• Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Experience in data extraction and transformation (ETL) using Informatics Power Center, exposure to Clients interaction, user- requirement analysis and user support.
• Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i, DB2, TERADATA V2R6.0, SQL Server 2003/2008/2012.
• Involved in Projects like Full Life Cycle Development of Data Warehousing, Project planning, business Requirement Analysis, Data Analysis, and Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
• Experience in creating Dynamic RSD’s and Visual Insight Dashboards using D3 Visualizations and custom widgets (both Web and Mobile)
• Performance monitoring, System optimization and tuning experience in Multiple BI applications. Proficient in setting up the Metadata Repository, Configuring the Intelligence Server, creating user groups, security filters, roles and privileges.
• Worked along with MicroStrategy Knowledge Base to troubleshoot complex Report related issues.
• Excellent problem-solving skills with strong technical background and good interpersonal skills.
• Strong SQL Skills Related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.

TECHNICAL SKILLS

BI Tools: Microstrategy10.x/9.x/8.x (Architect, Developer, Administrator, Desktop, Web, Intelligence Server, Narrowcast Server Report Services and OLAP Services), SAP Business Objects XI 3.1

Databases: Oracle 10g,9i,8i and SQL Server (2005/2008/2012 ), IBM DB2, MS Access 2000 and Teradata V2R4.1,V2R6.0, Netezza

Data Modeling: Microsoft Visio, Erwin 4.5

Supporting Tools: MS Project, SQL Navigator, Adobe Flash, Flex, SSH Client, Reflection X

ETL Tool: Informatica

Languages: C, C++. Java

Web: HTML, DHTML, XML, XSL, JSP, JavaScript, Microsoft Front Page, Excel

OS: Windows XP/ 2003/2000/2007/ Vista/10, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, NJ

Microstrategy Consultant

Responsibilities:

• Created logical data model using MicroStrategy Architect tool (10.2, 10.4)
• Created Multi layout report services document with multiple panel stacks, selectors, information windows, Hyperlinks (Passing Prompt Parameters to destination report).
• Involved in gathering business requirement meetings and preparing BRD documents
• Involved in complete SDLC processes and scrum meetings.
• Working on Visual Insight dashboards which includes ESRI Maps and other D3 Visualizations In
• MicroStrategy.
• Freeform definition reports for Transactional services reports allowing user to write back to the databases.
• Created dashboards exclusively for mobile purposes using custom widgets like (bubble, gauge, thermometer, Heat Maps etc.)
• Upgraded MicroStrategy environment from 10.2 to 10.4.5. Technical lead for the upgrade and the servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues.
• Developed Transactional report services documents using Free Form SQL definition reports
• MSTR- Server configuration and maintenance.
• Creating User groups, security roles, Meta Data security filters, Subscription and schedules (event and time based).
• Configuring and setting up Enterprise Manager for statistical Analysis.
• Using command manager for bulk operations, System Manger to create automating scripts.
• Objects migration and comparison using Object Manager tool.
• Monitoring the server performance across the project servers using operations manager (like Memory Usage, Disk space, CPU etc.).
• Managing large variety of user base by creating different user groups with different security filters.
• Onsite training & demonstration for new business users and providing clarification to business users when and required.
• Offshore Coordination- Guiding and helping team in resolving complex production issues.
• Worked closely with other applications across the organization to analyze and support cost modelling processes through invoking JSON Web Service via restful web service and API interface.
• Worked on displaying real-time information from the web in the dashboard using HTML containers that allows users to render HTML code directly in the document.
• Execute periodic -- weekly & monthly standard reports consisting of data analysis by combining a template with filters using Microstrategy desktop and web.
• Created complex metrics with different level dimensionality condition and filters and transformations for user and business specific reporting needs.
• Worked on Agile Methodology to complete the business requirements timely.
• Improved report performance using VLDB properties, Caching.
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Created historical YTD and MTD filters and prompts specific to historical Projects.

Environment: Microstrategy 10.2/10.4.5 , MS SQL Server 2012, Windows 2008, Oracle 10g,9i,8i and Teradata V2R4.1,V2R6.0 MS Access 2000

Confidential, Sacramento, California

Microstrategy Consultant

Responsibilities:

• Interact with business analysts, business users and managers for Gathering, Analyzing, Documenting Business/Functional requirements and data specifications.
• Managed service backlogs and a support queue of requests for POS to provide efficient business reports in Microstrategy reporting environment.
• Created logical data models, recognize source tables and columns, to build Microstrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Created multiple reports connected to publish Intelligent cubes to provide quick access of data and report execution.
• Worked on Performance tuning of Reports.
• Worked with Microstrategy Knowledge Base to troubleshoot some Report related issues.
• Designed Freeform SQL reports for meeting specific needs.
• Moved objects from one environment to another using Object Manager.
• Created Summary and Drill down reports for various attributes based on their hierarchies.
• Worked on creating transaction services enabled document by linking Transaction Services report to a grid, or text fields in a panel stack for users to view and edit the business data.
• Worked on ESRI map visualization to analyze Microstrategy data in DHTML or Flash mode
• Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.

Environment: Microstrategy 9.4/10.2, MS SQL Server, Windows 2008, Oracle 10g,9i,8i and SQL Server (2005/2008), MS Access 2000

Confidential, St Louis, Missouri

MicroStrategy Consultant

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Worked in converting reports from SAP Business Objects to MicroStrategy Reports as per the business user’s requirements.
• Managed service backlogs and a support queue of requests for POS to provide efficient business reports in Microstrategy reporting environment.
• Design and developed Microstrategy schema objects like Attributes, Facts and Hierarchies using Microstrategy Architect.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Worked extensively on creating Application Objects like Metrics (level, conditional etc.), Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
• Developed filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Developed number of historical, monthly and daily reports and report service documents.
• Created Dashboards and Report service Documents for Productivity and Performance summary.
• Used report services for various banded report to satisfy the printing requirements of the user.
• Involved in troubleshooting MicroStrategy prompts, Filters, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Responsible for monitoring the performance and stability of the software during performance test prior to going-live and after going-live continued to monitor as part of the post-production support.
• Worked on configuring the Intelligence Server, creating user groups, security filters, roles and privileges.
• Worked with MicroStrategy Knowledge Base to troubleshoot some Report related issues.
• Worked on Agile Development and Semantic modeling extensively to satisfy business users’ requirements.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.

Environment: MicroStrategy 9.4.1 (Web, Desktop), MicroStrategy Intelligence Server 9.4.1, MS SQL Server, Windows 2008, Oracle 10g,9i,8i and SQL Server (2005/2008), MS Access 2000 and Teradata V2R4.1,V2R6.0, SAP Business Objects XI 3.1

Confidential, Portland, Oregon

MicroStrategy Consultant

Responsibilities:

• Worked with business requirements analysts to identify and understand requirements and produce the report design specification of the project.
• Created the application objects metrics, filters, Prompts and Reports using Microstrategy Desktop to meet report requirements.
• Worked on OLAP services extensively and created cubes, derived metrics and view filters.
• Design and development of Microstrategy schema objects like Attributes, Facts and Hierarchies.
• Created complex metrics with different level dimensionality condition and transformations for user and Business specific reporting needs.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup Tables for finding the Gap analysis.
• Developed number of report service documents and interactive Dashboards for the Project.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Analyzed legacy reports and understand the data flow, relations and business needs and recreated the reports in MicroStrategy.
• Used report services for various banded report to satisfy the printing requirements of the user.
• Created logical view to satisfy the dashboard requirement for the project
• Used advanced Widgets and graphs for the Dashboards
• Tested the Reports, Documents and Dashboard and all the schema objects and metrics.
• Created the transformations for the time series analysis.
• Worked on Agile Methodology to complete the business requirements timely.
• Created caches for commonly -used reports and documents to reduce the database load and improve the system response time.
• Worked on Microstrategy Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters.

Environment: Microstrategy 9.4.1 (Web, Desktop), Microstrategy Intelligence Server 9.4.1, MS SQL Server, Windows 2008

Confidential, Burbank, CA

MicroStrategy Consultant

Responsibilities:

• Installation of Microstrategy Desktop and creating a Microstrategy project.
• Creating Attributes, Facts and relationship between attributes using Microstrategy Architect.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Microstrategy Architect.
• Defining Drill Hierarchies and creating relationship between attributes.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Created reports using complex filters and compound metrics and prompts.
• Creating reports from intelligent cubes, Data mart Reports.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups and involved in creating security filters to end users to access data based on their privileges.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.

Environment: Microstrategy 9.4.1, Report Services, Microstrategy Desktop, Microstrategy Web, Mobile, Web Sphere Application Server, Microstrategy Dashboards, MS-Excel, Oracle 10g.

Confidential, Reston, VA

Microstrategy Consultant

Responsibilities:

• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with Microstrategy Architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
• Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
• Createddrill mapsfor end users to drill down and recover data.
• Extensively worked with Microstrategy Intelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.

Environment: Microstrategy 9.3.1(Administrator, Architect, Desktop, Web, Object Manager, Enterprise Manager), ETL, UNIX, Windows XP, MicroStrategy Dashboard, Oracle 9g, Toad for Oracle.

Confidential

Data Warehouse Developer

Responsibilities:

• Migrated large volumes of ETL data from legacy systems to Oracle database.
• Extensively designed Data mapping and filtering Database connectivity is done using ODBC.
• Verification of functional specifications and review of deliverables.
• Complex SQL queries are used for data retrieval and migration of reports from Crystal Reports to Business Objects.

Environment: Business Objects, Erwin Tool 3.2, Shell Scripting; Crystal Reports 6.5, Oracle 8i, COBOL.