SUMMARY:

• Over 8 years of IT experience in Data modeling, ETL Tool and Business Intelligence in building and designing semantic layer, reports and dashboard development in MicroStrategy and Tableau.
• Over 5 years of experience in Business Intelligence(BI) project Development and implementation using MicroStrategy 9.4.1/9.3.1/9.2.1/9.0.2/8. x product suits including MicroStrategy Desktop/Developer, Web, architect, OLAP Services, Administrator, Intelligence server, and Narrowcast server.
• Expertise in Working on Direct Project Source (Two - Tier) and Server Project Source (Three-Tier).
• Full life cycle implementation encompassing Business requirements definition, Data analysis, Data Warehousing, Logical and Physical Data Modeling, Reporting, validations.
• Adequate knowledge of fundamental Data warehousing concepts such as dimensional modeling, star and snow flake schemas, modeling data marts.
• Proficient in creating Schema Objects such as Attributes, Facts, Hierarchies and Transformations.
• Extensive experience in creation of public Objects Namely Metrics, Filters, Prompts, Custom Groups, Consolidations, Drill Maps, Search Objects, Reports and Documents.
• Very strong in MicroStrategy connectivity with various databases such as Oracle, Teradata, MS Access, SQL Server.
• Worked on different Performance Tuning methods like Caching, Aggregate Tables, Partition Mapping, VLDB settings and creating Indexes on tables.
• Experience in MicroStrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Hands on Experience in Creating Documents from multiple Datasets like Map Application Diagram, Grid and Graph.
• Expertise in Creating Hyper Links in Documents and Drill Reports.
• Experience delivering reports in Desktop, web and via the narrowcast server.
• Expertise in creating Subscriptions, Triggering Schedules & Events to ensure secure distribution of reports and documents to business users using Distribution Services.
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Loading processing in a corporate -- wide-ETL solution using Informatica.
• Extensive knowledge on SQL/PLSQL and worked comfortably in Oracle 10g /9i/8i, Netezza, SQL Server 2003/2008/2012 database environments.
• Experience in supply chain management with the product flow, information flow and finances flow.
• Experience in training developers and advising technical groups on reporting best practices.
• Excellent experience working with various business teams, Supported QA Manager for Preparation of Quality Plans, Review and Approval of Project plan and Project documents, Collection and Compliance of project metrics.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.

TECHNICAL SKILLS:

BI Reporting Tools: MicroStrategy Product Suite 10.2/ 9.4.1/9.3.1/9.2.1/9.0.2/8. x (Architect, Administrator, Desktop, Web, Narrowcast and Mobile), Tableau.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2005/2008/2012/2017, Netezza, MS Access, Sybase IQ.

Operating Systems: Windows 98/2000/2003/ XP/Vista/7/8.1/10, Unix.

Languages: C, SQL, PL/SQL.

Data Modeling Tools: Microsoft Visio, SQL Power Architect, MySQL.

Methodologies: Star Schema, Snow Flake Schema.

ETL Tools: Informatica 7.1.2/8.1

Other Tools: Microsoft Office (Word, Excel, Power point, Access), Microsoft Outlook, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential, Lincoln, RI

MicroStrategy Developer

• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Extensively created MicroStrategy Adhoc reports, Report Services Documents and Dashboards.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets.
• Developed Intelligent Cubes to provide improved performance of key portal dashboards.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Created Attributes, Facts, Metrics and Filters using Pass - Through Functions.
• Used Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Involved in creating security filters to end users to access data based on their privileges.
• Created subscriptions to email reports to various groups and individuals.
• Updated VLDB properties and caching options for performance tuning.
• Extensively worked on SQL queries and also involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Created Test cases as a part of Unit Testing of the generated Reports.
• Production Support has been provided for ongoing issues.

Environment: MicroStrategy Developer 10.2, Object Manager, Service Manager, Enterprise Manager, Distribution Services, OLAP Services,SQL Server, Sybase IQ.

Confidential, Dearborn, MI

MicroStrategy Developer

Responsibilities:

• Responsible for Interacting with the users to collect the business requirements and analyzed the needs of the end users.
• Architected the Project Schema from scratch and designed the entire schema layer such as Attributes, Facts, Hierarchies and Transformations etc.
• Developed simple metrics, compound metrics, used transformations and dimensionality in metrics using MicroStrategy Desktop.
• Generated ad-hoc grid reports by enabling the user to drill up, down, within, and across hierarchies.
• Used MicroStrategy OLAP Services such as View Filter, Dynamic Aggregation, Derived Metrics, Derived Elements and Intelligent Cubes to generate ad-hoc reports and complex reports.
• Created Complex Filters such as Relationship Filters, Dynamic Filters, Embedded Filters, Custom Expression Filters and Joint Element List Filters.
• Experience in creating and using Filter prompts, Hierarchy prompts, Object prompts, Value prompts and usage of prompts in filters.
• Created multilayered dashboards using various controls such as panels, panel selectors, widgets and grids using multiple datasets in MicroStrategy web.
• Worked on Intelligent cubes and sourced the datasets to dashboards.
• Used panels, panel stacks, sections, grids, graphs and widgets for dashboards.
• Developing simple reports and visual insights in Microstrategy Web.
• Configured Mobile Server for reports and Visual Insights Analysis delivery for iPad.
• Improved and Optimized user reporting experience by providing pre built reports and dashboards that monitor MicroStrategy related activity using Enterprise Manager.
• Created a Baseline and compared reports from one project to baseline using Integrity Manager to uncover discrepancies in the result sets.
• Experience in invalidating, deleting and purging Report Caches.
• Transferred User privileges, Security filters and Schedules among different user groups with the help of User Merge Wizard.
• Experience in creating time triggered and event triggered schedules, administrative tasks and events.
• Worked with Business users in user acceptance testing.

Environment: MicroStrategy 9.2.1/9.0.2 (Desktop, Command Manager, Object Manager, Enterprise Manager, Distribution Services, OLAP Services, Configuration Wizard, Integrity Manager, User Merge Wizard), Oracle 11g.

Confidential - San Francisco, CA

MicroStrategy BI Consultant

Responsibilities:

• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Extensively created MicroStrategy Adhoc reports, Report Services Documents and Dashboards.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets.
• Developed Intelligent Cubes to provide improved performance of key portal dashboards.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Created Attributes, Facts, Metrics and Filters using Pass - Through Functions.
• Used Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Involved in creating security filters to end users to access data based on their privileges.
• Created subscriptions to email reports to various groups and individuals.
• Updated VLDB properties and caching options for performance tuning.
• Extensively worked on SQL queries and also involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Troubleshoot reporting for SQL generation errors/ Data defects.
• Created Test cases as a part of Unit Testing of the generated Reports.
• Production Support has been provided for ongoing issues.

Environment: MicroStrategy 10.2 (Intelligence Server, Administrator, Architect, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), SQL Server 2012, Windows 7.

Confidential

MicroStrategy BI Consultant

• Gathered requirements from users and converted them to technical specifications and provided best solutions to meet the client expectations.
• Developing, Maintaining, Enhancement, testing and leverage the enterprise Reports based on business needs.
• Designed and developed advanced grid reports, documents and dashboards for different departments Marketing, Sales, Campaign Analysis & Executive).
• Worked on understanding the logical data models by recognizing the source tables and columns.
• Created metrics involving MTD/YTD Transformations for better business analysis.
• Created Excel reports and Report Services Documents out of existing SAS reports and customized them to reflect the business Needs.
• Created dashboards showing Daily/Weekly/Monthly/Yearly performance metrics using various bar graphs and line graphs.
• Designed and customized reports to supply the business with improved flexibility and functionality.
• Worked with the team to redesign the schema, modify attribute definitions and fact definitions to improve the performance of the report.
• Used the VLDB properties for performance tuning and SQL optimization.
• Suggested Database Schematic Changes to Database Administrator to improve MicroStrategy reports performance.
• Involved in writing test scripts and validating the Production data.

Environment: MicroStrategy Reporting Suite 9.3/9.0 (Intelligence Server, Desktop/Developer, Architect, Web, Object Manager, Enterprise Manager, Integrity Manager & Tools), MS SQL Server 2008/2005, Windows 7.