SUMMARY:

• 8+ years of experience in Business Intelligence, ETL and Data warehousing Technologies with expertise in MicroStrategy versions 8.x/9.x/10.x: Intelligence Server, Administrator, Architect, Desktop Designer, MicroStrategy  Web Administration, Security Administration, Object Manager, Integrity Manager, Report Services, Dashboards, Enterprise Manager and Narrowcast Server 
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, Production Support, Maintenance, Built and Release management.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports).
• Excellent experience in MicroStrategy Report development, Report testing, Report tuning, Ad - hoc and Custom Groups.
• Experience in more advanced features, such as Freeform SQL reports, complex filters, metrics, Data Mining Services, custom groups, consolidations, and prompts for advanced and predictive analysis.
• Expert in designing Schema, Public Objects, Reports, Dashboards, Scorecards in MicroStrategy and strong experience in SQL Development.
• Specialized in designing Report Service Documents and Dashboards with multiple datasets. 
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments and MicroStrategy Command Manager to run the automated scripts.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Extensive experience on all types of MicroStrategy Filters, Prompts, Templates, Metrics, Consolidations
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets).
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Teradata, Sybase flat files, XML files, and DB2 files. 
• Experience in Business Intelligence, ETL Applications, Data modeling techniques like star and snowflake schemas using Erwin tool.
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore-onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle 11g/10g/9i, Teradata 13.x/V2R6, Sybase, Netezza, MS SQL Server

Programming: PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML, CSS, JavaScript

Operating Systems: Windows Servers, UNIX, Linux

Other Tools: Toad, PL/SQL Developer,, SQL Assistant, MS Office, Microsoft Visio, Erwin

WORK EXPERIENCE:

Confidential, Rhode Island

MicroStrategy Consultant

Responsibilities:

• Involving in the design and development of logical and physical schema. 
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development. 
• Gathered functional and non - functional client requirements in order to optimize the design of BI deliverables such as reports, dashboards and visualizations. 
• Worked as a  MicroStrategy Architect and created best suited solutions to the existing system. 
• Created different Schema Objects like Attributes, Facts, Transformations, and Hierarchies by using MicroStrategy  Architect of the MicroStrategy  BI Suite. 
• Developed Metrics, Filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics. 
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes. 
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc. 
• Developed MicroStrategy  Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets and MicroStrategy Visual Insights. 
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner. 
• Creating complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality and conditional, generating Data Marts with per and post SQL for the Data Mart Tables. 
• Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report. 
• Worked with end users along with Business Analysts to build reports and dynamic dashboards. 
• Worked with the DBA & ETL Team on issues of database performance and security. 
• Prepare opportunity analysis report and business modeling for priority basis. 
• Responsible for ensuring quality and standard in all the research activities. 
• Determines which analytics approaches are best-suited for a particular desired result. 
• Conducted Data validation testing to ensure data quality. 
• Developed a web course and took several classes to train the end users to efficiently use MSTR. 
• Conducted Unit/System/User Acceptance testing on the  MicroStrategy  objects developed. 
• Providing technical support; troubleshooting report design; monitor system usage and proactive troubleshooting. 

Environment: MicroStrategy  10.0 (Architect, Developer, Object Manager, Distribution Services), Informatica Power Center, AWS, SQL Server, Oracle.

Confidential, St louis, MO

MicroStrategy Consultant

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters, dynamic aggregation and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc.
• Used MicroStrategy Distribution Manager, Narrowcast Server for automation of reports.
• Worked with Database to create the database tables, materialized views required for reporting.
• Involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Widely used VLDB properties at project level and also at individual report levels to overcome performance issues.
• Used database specific MicroStrategy OLAP pass through functions like ApplySimple, ApplyComparison to overcome complex logic in creating objects
• Involved in production support (24/7) and maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Confidential, Jersey City, NJ

MicroStrategy Consultant

Responsibilities:

• Worked with the Source Systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements. 
• Created the requirements documentation for the MicroStrategy  Projects and also documented the requirements in MicroStrategy Environment. 
• Installed software, secured model design, troubleshooting of application and database connectivity and tested load. 
• Created Reports using Complex Filters, Compound Metrics and Prompts.  
• Developed  MicroStrategy  Payroll Analysis and Productivity reports for HR. 
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment. 
• Good understanding of the type of schemas that best support  MicroStrategy  in different scenarios. 
• Used Advanced Prompts, Non - Aggregately Metrics, Transformation metrics and Level Metrics for complex reports. 
• Created several base formulas using existing facts in  MicroStrategy Desktop that can be reused to build number of Metrics. 
• Customized reports, documents and deployed them to  MicroStrategy Narrowcast Server. 
• Managed configuration and version control of production systems, maintained procedures and monitored fault correction. 
• Maintained scripts and documentation related to software licensing. 
• Supported project teams and domain architects to improve reliability development and testing of  MicroStrategy . 
• Worked on MicroStrategy Narrowcast to deliver the Weekly and Monthly Reports. 
• Generated the Reports, which includes the public and schema objects using the  MicroStrategy Components. 
• Developed Customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using  MicroStrategy . 
• Desktop with features of Drilling options (drill down, drill up and drill anywhere). 
• Performed the administration tasks like Tuning, Caching, specifying Query Governing, Thresholds, and Report Optimization. 
• Performed testing of all reports for the final deployment. 

Environment:  MicroStrategy 9.2.1(Desktop, Architect, Web, Object Manager), Tableau 7.0 (Desktop Server), Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL, Linux .

Confidential 

MicroStrategy Developer

Responsibilities:

• Involving in the designing of the Data Model. 
• Preparation of the logical data model by using Power Designer. 
• Responsible for gathering and refining business requirements from the Business users. 
• Build the Schema Objects like Attributes, Facts, and Transformations & Hierarchies as per the user requirements by identifying the required Tables. 
• Worked on Public Objects like Metrics, Prompts, Filters, Custom Groups and Consolidations. 
• Worked on the Migration of the Business Objects & SSRS reports to MicroStrategy reports & Dashboards. 
• Involved in troubleshooting MicroStrategy   prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment. 
• Optimized Query Performance by using VLDB settings. 
• Analyzing the business Objects, SSRS reports and data structures to understand and create the model which supports to   MicroStrategy. 
• Created the Reports and Dashboards by using public objects and schema objects. 
• Developed Reports and Dashboards using various functionalities like Prompts, Filters, Crosstab grids, Bar Charts, Pie Charts and Consolidations and Custom Groups. 
• Worked on performance tuning to make the dashboards efficient in web mode. 
• Preparation of the Unit test cases for the entire Reports and dashboards. 
• Involved in End - User training, Support and Maintenance. 
• Testing and scheduling reports as per the user requirements. 
• Involved in Migrating reports from Development to Production by using Object Manager. 
• Created Technical Document & Trained users at different levels of Report and Dashboard usage. 

Environment: MicroStrategy   9.0.1 (Architect, Desktop, Object Manager), Informatica Power Center, Teradata, Oracle.

Confidential

MicroStrategy Developer

Responsibilities:

• Started with gathering requirements from the users and documenting the specifications.
• Created the Report Specification document and had it signed of, after suggesting some useful alterations
• Analyzed the source system data.
• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Created Complex Metrics forcing Dimensionality and Conditionality which are mainly used in Client scorecards, summary, detail level reports and trending related reports.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends.
• Created Report Service documents with both Grids and graphs as per user requirements.
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Played a key role in User Acceptance Testing of the reports.

Environment: MicroStrategy 7.x.x/8.x.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Linux, Windows Server, SQL server, Oracle.