SUMMARY:

• 9+ years of experience MicroStrategy in Analysis, design and Implementation of BI applications using MicroStrategy.
• 2+ years of experience as Tableau developer.
• Worked in both Agile and Waterfall models.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de - normalized and normalized data models.
• Well versed and experienced in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
• Involved in analysis, design, development and implementation of Business Intelligence applications using MicroStrategy
• Extensive experience in setting up MicroStrategy Environments from Installation, configuring Metadata, server settings of Intelligence server, web server and mobile servers. project settings
• Strong experience in working with Security Filters, Access Control Lists, Security Roles, Privileges and maintaining Report Caches.
• Experience in maintaining system environments Dev/QA/Prod using Project Merge, Object Manager, and Project duplication to maintain projects across environments.
• Experience creating workflows in system manager.
• Experience with MicroStrategy Upgrades across various versions.
• Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server and Distribution Services.
• Extensive Data warehousing experience in Data Extraction, Data Integration, and Data Mining for Decision Support System using ETL and OLAP tools.
• Extensive experience working with End Users, Business System Analysts in understanding their requirements.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Expertise in Creating Document from multiple Datasets and Hyper Links in Documents and Drill Reports.
• Expertise in Developing Dashboards and usage of several widgets like Bubble Grid, Microcharts, Media, Fish Eye, Heat Map and few other widgets.
• Good knowledge in building OLAP cube reports to analyze data from different source systems.
• Intensive experience and exposure to all aspects of MicroStrategy application such as Administration, Architecting and Development using modules comprising Administrator, Architect, Desktop, Enterprise Manager, Intelligence server and Narrowcast Server.
• Very strong in MicroStrategy connectivity with various databases such as Oracle, Teradata, Sybase, DB2, SQL Server, Spark, Hive and HBase.
• Experienced in Full Life Cycle (SDLC) development of software applications. Good knowledge of understanding business logic and converting functional requirements to technical requirements. Thorough knowledge of multiple RDBMS & ODBC concepts, exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the design through production process.
• Ability to work effectively while working as a team member as well as individually. Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating System: DOS, UNIX (HP-Unix, Solaris 2.7/2.8, Linux 7.1), Windows 98/NT/2000/XP, Mac OSX

ETL Tools: Informatica 7.1, AbInitio.

MicroStrategy Suite: MicroStrategy 10x/9.x/8.x/7.x Desktop, MicroStrategy Architect, MicroStrategy Intelligence Server, Micro strategy Web, Micro strategy Narrowcast Server, Micro strategy Administrator (Object Manager, Command Manager), MicroStrategy Enterprise Manager, Micro strategy Office, Micro strategy Report Services

Other BI Tools: Crystal Reports XI / 10 / 9 / 8.5, Crystal Enterprise XI/10 /9 / 8.5, SSIS, SSRS, Tableau 10.1,10.3.

Data Modeling: Erwin 3.5/4.0, Microsoft Visio

Languages: Java, C++, C, C#, SQL, PL/SQL

Databases: Oracle 7.x/8i/9i/10g, MS-Access, SQLServer 2005, DB2, Sybase, Teradata, Netezza, Hadoop, Hive, Spark and HBase

PROFESSIONAL EXPERIENCE:

Confidential, Milford, CT

Sr. MicroStrategy Administrator/Architect/ Developer, Tableau Developer

• Daily/Weekly interaction with business analyst and external users for collecting high level requirements.
• Involved in Data modeling/Architect, metadata management, workflow definition, and interface control document sessions with the technical team.
• Designed solid and reliable schema in MicroStrategy from scratch.
• Created MicroStrategy interactive dashboards/reports (including supported schema and application objects), Scheduled demos to end users and collected feedback and provided enhancements in the next sprint.
• Created client based custom metadata managed system so that business has better understanding on the underlying schema and application objects in intelligent cubes.
• Interacted with Database Administrators (DBA) in creating necessary tables, views and materialized views based on business requirements.
• Created an automation procedure to trigger the series of cubes after the data loaded into the BI tables.
• Created Enterprise level dashboards to show end-user usage and tracking of deployed dashboards in production.
• Used Advanced Prompts, smart metrics and Level Metrics, consolidations for creating complex reports and enhanced the performance of reports with various optimization techniques.
• Performed unit testing, white and black box testing and UAT testing before migrating to production environment.
• Mentored junior level developers and trained them effectively throughout the life cycle of projects in parallel.
• Used Object Manger to create packages and migrated to different environments for the product releases.
• Performed various administrative tasks such as automating repetitive tasks in command manager, user access, security roles, duplicating projects, unloading projects, etc.
• Installed various versions of MicroStrategy in 9.x and 10.x versions and also applied various hotfixes.
• Created POC for dashboards in Tableau for dashboards currently in MicroStrategy.
• Worked on various upgrades 9.4.1 to 10.2 and 10.2 to 10.4.
• Worked on Enterprise Manager data load Issues after upgrade to MSTR 10.2 from 9.4.1.
• Tracked report performance using Enterprise Manager with graph layout and administer MicroStrategy tool.
• Enhanced the performance of reports with various optimization techniques.
• Migrated the project into Testing and Production environments using Project Duplication Wizard.
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.
• Creation of Intelligent cubes and sharing to reduce the database load and decreasing the report execution by using the Cube Services
• Successfully integrated MicroStrategy with Hadoop (Hive, Impala) and other big data tools part of the POC.
• Created Dynamic sourcing reports using intelligent cubes to boost the Dashboard Performance.
• Extensively work on providing security for the users using Security Filters.

Environment: MicroStrategy 10.x, 9.x (Architect, Developer, Administration, Web), Oracle 11g, Teradata 14.x.

Confidential, Wellesley, MA

Sr. MicroStrategy Consultant

• Involved in discussions with Bridgewater Associates business analysts and the eagle software integration team in creating the use cases for the reports.
• Involved in the documentation of technical specifications of the Bridgewater reporting project.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Worked on to create around 120 documents in Pdf and excel output format.
• Created 8 iPad based mobile dashboards using various functionalities and widgets.
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the custom style sheet requirement.
• Created reports based out of SSAS cubes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Used Pass-Through functions for adding additional business specific conditions in attributes and metrics.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Upgraded the MicroStrategy Intelligence Server, Web & Narrowcast server from v9.0.1 to 9.3.1
• Used ScanMD frequently to detect and fix logical metadata inconsistencies respectively.
• Used object manager to migrated objects between Dev to UAT/ UAT to Prod.
• Wrote Command Manager Scripts and procedures to create/Delete event based subscriptions against Oracle Data Warehouse.
• Worked with MicroStrategy Administrator in creating new users, roles, privileges, shared folders, access controls Lists.
• Worked with the eagle software integration team in creating the report rules and scheduling of the reports.
• Worked on excel formatting, macros and templates of the documents which are used in different services.
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.3.1, MicroStrategy Mobile 9.3.1, Oracle 10g, Microsoft SSAS, Eagle Performance suite.

Confidential, Milpitas, CA

Sr. MicroStrategy Consultant

• Project Lead for the three product lines called Safety Event management (SEM), Safety Rx, Retail Pharmacy Solutions.
• Safety Event management is a SaaS based product used by the hospital staff to manage the events occurred in the hospital. Safety Rx is a product used to track the incidents occurred with respect to the medicines given to patients during the hospital stay.
• Both Safety Event management and the Safety Rx used Microstrategy as the backend reporting engine.
• Retail Pharmacy Solution is a product used by the pharmacy to track the incidents in pharmacy.
• On boarded the first client Target Pharmacy. Presented several demos and prototypes regarding the product and the reporting features the product offers.
• Worked as a MicroStrategy Architect, Used MicroStrategy 9.3.1 for design and development of the reports and dashboards.
• Delivered 7 unique product lines with around 21 dashboards and ad-hoc report builder with around 350 attributes and 160 metrics.
• Worked with the Product mangers in analyzing the requirement.
• Identified the columns required for creating the Attributes and Facts.
• Developed Schema Objects Facts, Attributes and Hierarchies.
• Created complex metrics, filters and prompts.
• Worked with the end users to finalize the Dashboard Layouts.
• Identified the Source Tables and Columns required to create the Microstrategy Project, thereby achieving a Logical Data Modeling of the physical data warehouse in the Metadata Repository.
• All the reports were built off the intelligent cubes to address the performance needs.
• Created test report to understand the SQL generated by Microstrategy reports.
• Setup the alert mechanism for cube refresh schedules.
• Worked with the Application developers and testers in resolving any issues with respect to Microstrategy schema.
• Created several POC‘s for the functionality of the dashboard.
• Involved in troubleshooting Microstrategy Web reports, optimizing the SQL using the VLDB Settings.
• Provided end user training and support for all the product lines.

Environment: MicroStrategy 9.3.1/9.2.1 m, Oracle 10g, Rally, Windows.

Confidential, Warren, NJ

Sr Microstrategy Architect

• Used Microstrategy 9.2.1 for the report development.
• Followed the agile methodology in creating the dashboards.
• Worked with the functional team in understanding the requirements.
• Created the test dashboard mockups and prototypes for testing the functionality and the flow of the dashboards.
• Created the Schema objects, Application objects used by the reports and dashboards.
• Creating around 35 datasets which are used by various dashboards.
• Worked on various administration tasks Daily migration, Caching and scheduling of various reports.
• Worked with the testing team in resolving the bugs.
• Supported the enhancement requests.

Environment: MicroStrategy 9.2.1, Windows 7, Informatica 9, Teradata, HP Quality center.

Confidential, Glendale CA

Sr Microstrategy Administrator/Architect

• Instrumental in designing and developing the mobile approach to the dashboards.
• Installed MicroStrategy 9.0.2 Mobile, Created the dev, qa and prod environments.
• Configured the MicroStrategy web, mobile server for the dev, qa and prod environment.
• Created the Schema objects, Application objects used by the reports and dashboards.
• Used the Intelligent cubes in creating the datasets.
• Created complex report filters and prompts for the reports.
• Created the logical tables to make the data model flexible as per the report requirements, which reduced the time of the report development.
• Created complex IPAD based dashboards. Used various IPAD functionalities, Widgets in creating the dashboard.
• Setup the trusted authentication (Single sign on) for the mobile environment.
• Setup the I-Server clustering in the qa, prod environment.
• Deployed both .war files and images on both the dev, prod servers.
• Performed various support tasks such opening a technical support case, extracting the metadata, caches which are sent to the MicroStrategy support.
• Worked with the qa team in setting up the testing strategy for the Dashboards.
• Created the users groups and created a security strategy for the users of the mobile dashboards.
• Created the event based trigger for the data refresh of the intelligent cubes.
• Supported the enhancement requests, monitored the environment.

Environment: Windows server 2003, Microstrategy 9.0.2 M, Microstrategy Desktop 9.0.2, Web 9.0.2, Informatica 9, DB2, Apple IOS 4.3.3.

Confidential, Foster city, CA

Sr Microstrategy Developer

• Used MicroStrategy 9.0.1, 9.0.2 M for the development.
• Worked with the senior management and the user in understanding the requirements.
• Worked with the ETL team in designing the data model.
• Created the DSN for the metadata and the data warehouse, Used DB2 as the database.
• Created Micro strategy schema and public objects for the generation of reports and used Micro strategy Desktop to build and generate the advanced reports in grid, graph mode.
• Presented a mockup of the dashboard to the high level management, created a complex flash dashboard based on the feedback from the users.
• Created Complex Transformations, Custom Groups and Complex Filters using pass through Expressions
• Created report builder for adhoc reporting.
• Used narrowcast services in creating the alerts to the end user.
• Worked with the Microstrategy Mobile team in converting the dashboard to the IPAD, IPHONE version.
• Involved in giving demos and presentation to the end user.

Environment: Microstrategy 9.0.1, 9.0.2 MicroStrategy Desktop 9.0.1, Web 9.0.1, Microstrategy Narrowcast, Abnitio, Windows xp, Mac OSX, DB2, Rational Clear case .

Confidential, Hoffman Estates, IL

Sr Microstrategy Architect

• Worked on MicroStrategy 9.0.1. For report development.
• Worked with the Client in understanding the business requirements.
• Created around 40 grid report and three dashboards for the top level management, these dashboards are used in the survey and analysis of the products at the store level.
• Used Advanced Prompts, Non-Aggregately Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
• Used Microstrategy Narrowcast server for the distribution of the report at the store level.
• Create both Static subscription and dynamic subscription set for the narrowcast server.
• Created Complex custom Groups, Filters and Prompts for creating the grid reports.
• Created the requirements Documentation for the Microstrategy projects and also documented the Microstrategy Environment.
• Involved in giving Demos to the end user.

Environment: Micro strategy Desktop 9.0.1, Micro strategy Intelligence Server 9.0.1, Micro strategy Web 9.0.1,Microstrategy Narrowcast Server 9.0.1, Netezza 4.6, MS Office, Excel Macros, and Windows XP .

Confidential, Round Rock, TEXAS

Microstrategy Developer

• Worked on the Microstrategy 9.0 for the report development.
• Worked with the Business analyst from the payroll department on the report requirements and the business needs.
• Designed various templates for the report services document.
• Created both schema objects and the application objects.
• Used Custom free form SQL for creating the reports.
• Created various grid reports for the salesmen
• Created complex report filters, security filters and prompts for the reports.
• Created the logical tables to make the data model flexible as per the report requirements, which reduced the time of the report development.
• Created the report services documents for the top level management.
• Used complex report filters and also the view filters to work on the date dimension of the users.
• Trouble shoots the reports for the variations of data and by working on the definition of the report objects.
• Involved in testing the complex filters, prompts and metrics.
• Helped administrator in the daily migration to the SIT and Production environments.
• Used VLDB properties to optimize the SQL generation of the Microstrategy reports for performance.
• Involved in giving Demos/Presentations to end-users and training other developers in Microstrategy Desktop and Web.

Environment: Microstrategy Desktop 9.0, Intelligence Server9.0, Web Professional, Administration, Oracle 10g, MS SQL Server 2005, Windows XP, Windows 2003 Server, Windows SharePoint, TOAD, Business Objects XI R2 .

Confidential,  Charlotte, NC

Microstrategy Developer

• Understood the source system and interacted with users to get the elaborate report requirements and to gather business requirements.
• Installed Microstrategy web universal, Microstrategy Intelligent server in AIX environment.
• Created Metrics, Drill Maps, Filters, Templates, Hierarchies and Prompts to enable decision-makers to choose the condition for reports in MicroStrategy Desktop.
• Created Transformations (YTD, MTD, and QTD) for comparative reports to measure and extrapolate campaign results in real-time of previous similar campaigns & similar target market.
• Created consolidations and custom groups for reporting summarized values.
• Created Reports in MicroStrategy Desktop and Web according the business requirements.
• Involved in creation of dashboards for top level management to view overall business performance and find tremendous value in viewing timely, visually intuitive snapshots of strategic financial and operational data.
• Administered Narrowcast server, intelligent server, Web server on which Microstrategy components were installed.
• Created Narrowcast server to deliver dashboards to more than 40 plus users.
• Performance testing is performed every month for the analysis of the business usage every month.
• Identified the Source Tables and Columns required to create the MicroStrategy Project, thereby achieving a Logical Data Modeling of the physical data warehouse in the Metadata Repository.
• Developed documentation for the objects and reports that are created.
• Worked with the team to troubleshoot any Reporting issues in the production environment.
• Involved in testing of MicroStrategy prompt, filter, template, reports, consolidations, and custom group objects in an enterprise data warehouse team environment.

Environment: MicroStrategy Desktop 8.1.1, Intelligence Server8.1.1, Narrowcast Server 8.1.1,Microstrategy SDK, Web Professional, Administration,AIX, Teradata V2R6,XML,XSL,Oracle 10g, MS SQL Server 2005, Windows 2003 Server.