SUMMARY

• Having 8+ years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Having 8+ years of strong experience in Microstrategy 7.X/8.X/9/10 products including Microstrategy Narrowcast Server, Microstrategy Desktop, Microstrategy Web, Microstrategy Administrator, Microstrategy Intelligence Server and Microstrategy Architect.
• Extensive experience on Enterprise Reporting, Cube Analysis (MOLAP), Ad hoc query (ROLAP) & analysis, Statistical Analysis and Report Delivery & Alerting.
• Expertise in Creating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to User Objects.
• Expertise in Developing Public Objects (filters, prompts, metrics, Custom Groups, Consolidations, Searches) to develop Documents and reports.
• Very strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using Microstrategy Narrowcast Server.
• Expert in Creating Microstrategy Reports and implementing Microstrategy projects.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Expertise in Developing Reports by using Free Form SQL Queries in Microstrategy Desktop.
• Configuring Drilling Concept in Reports and Dashboards.
• Expertise in Creating Dashboards and Scorecards using Datasets for enterprise summary level reporting.
• Experience with large Microstrategy environment which leverages I - Cubes and Narrowcast processing.
• Experience in creating dashboards in Tableau.
• Experience in creating Distribution Services and deliver the reports based on business needs.
• Developed the reports against Star Schema and Snow-Flake Schema.
• Experience on working on VLDB Settings to increase the report performance.
• Good exposure to data query tools like DB2, SQL Server, ORACLE, S3 and AWSDynamoDB.
• Experience in generating reports using Advance/PowerPivot, Power Query, Power View of Excel and POC on Power BI Desktop and Power BI web services.
• Experience in various software development life cycle (SDLC) methodologies including Waterfall and Agile methodologies.
• Experience with initializing and implementing on-site/off-shore model.
• Improvement of existing processes related to defect prevention.
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS

Business Intelligence: Microstrategy Desktop 7.0/8.x,/9.x/10, Tableau, Microsoft Excel (Macros), Power BI, Power Pivot, Cognos, BexAnalyzer, SSRS

Data Modelling & ETL: Erwin, Abnitio, Teradata, SSIS

O/S: Windows XP/2000/NT/98, UNIX, Linux

Databases: IBMDB2, MS SQL Server, Oracle, MySQL

PROFESSIONAL EXPERIENCE

Confidential, OH

Microstrategy Consultant

Responsibilities:

• Interact with business analysts, business users and managers for Gathering, Analyzing, Documenting Business/Functional requirements and data specifications.
• Involved in designing conceptual data model.
• Created the schema in Microstrategy desktop based on the business requirements.
• Created Microstrategy reports by creating Schema objects like Attributes, facts, hierarchies, transformations and public objects like Custom groups, consolidations, Metrics, prompts and filters.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Involved in creating Security filters to end users to access data based on their privileges.
• Involved in the creation of three types of reports like Map Application Reports, Reference reports and Adhoc Reports.
• Developed dynamic Dashboards using multi layout and used panel stacks, panels, widgets and selectors.
• Strong understanding of all architectural components of MicroStrategy (Metadata, I-Server, Web Server, Architect, Developer, SDK, Object Manager, Command Manager, Analytics)
• Set-up the Narrowcast environment and created services using subscriptionsets, schedules, Information objects.
• Created Command Manager Scripts for security filter, user groups and user creations.
• Extensively used Integrity Manager to check the difference in sql’s and data in different data centers.
• Used Enterprise Manager and created reports to check the performance of the reports over a period and daily load checks.
• Used administrator tools like object manager and project merge to move the objects from one environment to another.
• Created MicroStrategy cubes and schedule them over night to get them cached and use against reports and dashboards.
• Involved in Developing Reports by using Free Form SQL Queries in Microstrategy Desktop.
• Involved in migration of Schema Objects (Facts, Attributes, Hierarchies, and Transformations), Application Objects (filters, prompts, metrics, consolidation, and custom groups), user groups from 8 to 9 and 9.0.2 to 9.4.1.
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Coordinate with business users and fix the pending and new production issues on a timely basis.
• Optimizing the performance tuning of Microstrategy Reports & Dashboards and SQL tuning.
• Training and supporting users on canned reports as well as ad-hoc requests.
• Design and architect Business Intelligence Reports using various technologies including Microstrategy, DB2, Freeform SQL, Microsoft Office, etc.
• Communicate offshore working team to explain client requirements and develop reports.
• Analyze and report defect / issues in a defect tracking system, ability to express the defects and provide detailed steps to reproduce them.
• Prepare and participate in walkthroughs/review of all deliverables.
• Involved in installation and configuration of Microstrategy 9.0.2, 9.4.1.
• Validations of report enhancements and software upgrades across all the BI applications.
• Involved in Production support for job monitoring, production migrations, validations include end to end process of packages deployment, scheduling of the jobs, web application security filters etc.
• Validation of report data using designed automation scripts.

Environment: Microstrategy Desktop 9.0.2,9.4.1, Microstrategy Web, Microstrategy Administration, Microstrategy Architect, Narrowcast Server, Integrity Manager, Enterprise Manager, Command Manager, Object Manager, Tableau, DB2, SQL Server, UNIX, Excel Power Pivot, Excel Macros, Java.

Confidential, Redmond WA

BI Consultant

Responsibilities:

• Involved in loading of source data using SSIS packages and creation of reports in Power Pivot and Cognos based on customer requirements.
• Validation of the reports and ETL transformation logic
• Worked in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (SQL Server, Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion.
• Experience in using T-SQL (SQL Server) & PLSQL (Oracle).
• Enabling of alerts and thresholds.
• Writing macros in Excel.
• Performed data validation b/w multiple systems
• Created excel based reports (using macros)
• Optimizing User queries based on customer requested templates.
• Managing and optimizing the extraction of data from various data sources (SQL)
• Generation of reports using automation scripting (batch files).

Environment: SSIS, Cognos Framework Manager, Cognos Report Studio,Cognos Query Studio Cognos Analysis Studio, Power Pivot, Excel Macros, Oracle, SQL Server, Data Stage, Linux.

Confidential, Forsecity CA

Microstrategy Consultant

Responsibilities:

• Created Metadata Repository and Statistical tables, Intelligence Server and Project on Microstrategy Desktop using the Configuration Wizard.
• Generated Microstrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Extensively worked with Microstrategy Intelligence Server, Microstrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Created complex custom groups using hierarchy to overcome the restriction of Microstrategy where total on columns and average on rows cannot be calculated at the same time.
• Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
• Designed various prototypes of dashboards using Microstrategy, which would give ability to the users to drill down to claim (lowest) level.
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in Microstrategy environment.
• Experienced in troubleshooting Microstrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: Microstrategy Desktop 9.0.2, Microstrategy Web, Microstrategy Administration, Microstrategy Architect, Narrowcast Server, Integrity Manager, Enterprise Manager, Command Manager, Object Manager, DB2, Windows, Unix/Linux, Excel Macros.

Confidential, Dover NH

Microstrategy Consultant

Responsibilities:

• Gathered and analyzed relevant data and created Schemas that fit reporting requirements. Defined fact and dimension tables, created aggregate table for performance.
• Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.
• Extensively worked with Microstrategy Desktop. Experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Created numerous Microstrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
• Experienced using Microstrategy Data Mining Services, Business users, report designers and have distributed these reports to all relevant decision makers.
• Worked with Narrowcast server for sending reports via email to a large executive distribution group.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets
• Created Dashboard and Scorecards, using Report Services Documents.
• Applied Teradata Application Utilities and Teradata SQL. Also Fine-tuned SQL using Teradata.
• Build mock up reports and presented to the users before starting the report development.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Involved in up-gradation from version Microstrategy 8.0 to Microstrategy 9.x.

Environment: Microstrategy Desktop 8.x/9.0.2, Microstrategy Web, Microstrategy Administration, Microstrategy Architect, Narrowcast Server, Integrity Manager, Enterprise Manager, Command Manager, Object Manager, Oracle, Teradata, Windows, Unix/Linux, Java, Automation framework using Java/automation tools integration.

Confidential, Charlotte, North Carolina

MicroStrategy Administrator

Responsibilities:

• Created the Metadata & Statistic tables for Microstrategy projects.
• Involved in normalizing the data from source systems by identifying columns in the table.
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Generated and implemented Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Extensively worked on Report Services to create performance dashboard reporting.
• Created drill maps for end users to drill down to most granular data.
• Created Aggregate Tables, Control Tables and Staging tables in Teradata.
• (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
• Creation, Monitoring of Autosys job scheduler for Teradata stored procs.
• Involved in using the Object Manager to move the objects from Development to Production Environment in Microstrategy.
• Worked on Enterprise manager to generate reports in enterprise manager. Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Environment: Microstrategy Desktop 7.x/8, Microstrategy Web, Teradata, QTP, Java, VBA, SAP BW, BEX Analyzer, EXCEL Reporting, SSIS, Autosys, and DTS packages script automation, SQL Server 2003/2005

Confidential

Software Analyst

Responsibilities:

• Earned recognition for automating data comparison process and for effectively managing process revisions per requirement changes.
• Obtained award for identifying revenue inaccuracies during SDLC using data quality monitors; and automating of data validations using SQL scripts.