PROFESSIONAL SUMMARY:

• Over 9 Years of strong IT Experience in Business Intelligence (BI) and Data Warehousing Project Development and Implementation Using MicroStrategy 10.x/9.x/8.x Product Suites including MicroStrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server etc.
• Strong expertise in Tableau software as applied to BI analytics reporting and dashboard projects worked on Tableau 10.x/9.x
• Expertise in Data visualization development using Tableau to create complex, intuitive and innovative dashboards.
• Created Tableau wireframes for various lines of business.
• Worked on all phases of Data Warehouse development lifecycle and software development lifecycle, from gathering requirements to design, development, testing, deployment, and support.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Knowledge on various ETL reporting and database development tools like Informatics, SQL Server and Oracle with strong coding skills.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups and Intelligent cubes) with the data warehouse.
• Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in better understanding of business trends.
• Good understanding of intelligent cubes and Visual insights, and good knowledge in Analysis, design and construction of the metadata.
• Involved in creating projects that were connected to Warehouse and Metadata Repository through a 3 - tier architecture involving MicroStrategy Intelligence Server and also have the experience in duplicating MicroStrategy projects and creating new project sources.
• Extensively worked on Dashboard components including Widgets, panels, selectors& layouts for a dashboard implementation.
• Excellent problem-solving skills with strong technical background and good interpersonal skills.
• Excellent communication skills, analytical, problem solving skills and Self-motivated team player to work individually as well as in a team with Agile environment.

TECHNICAL SKILLS;

Business Intelligence tools: MicroStrategy Desktop, Architect, Web, Intelligence server, Administrator, Report Services, Command manager, SSRS, Tableau Desktop, Server, Online ……

OLAP tools: MicroStrategy, Oracle server.

ETL tools: Microsoft SQL Server Integration Services, Informatica.

Supporting tools: MS Project, SQL Navigator, TOAD, and Adobe Flash.

Languages: C, Java, SQL, XML, HTML.

Data Modeling Tools: TOAD Data Modeler, Power Designer, ER Studio, Erwin.

DWH Concepts: Dimensional Data modeling, Physical and logical Modeling, Star Snow-flake.

PROFESSIONAL EXPEREINCE:

MicroStrategy Developer

Confidential, Portland, OR

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• 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.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• 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.
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Involving in the design and development of logical and physical schema.
• 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.
• 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.
• 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.4 (Architect, Developer, Object Manager, Distribution Services), Tableau Desktop 8.1-8.2, Tableau server / Administrator, AWS, SQL Server, Oracle.

MicroStrategy Developer

Confidential, West Chester, PA

Responsibilities:

• Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports.
• Involved in Metadata creation and extensively worked on building relationships.
• Working closely with business in creating dashboards based on the data from various Data sources.
• Utilizing Tableau server to publish and share the reports with the business users.
• Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired
• Created statistic reports to optimize the MicroStrategy system and implemented Narrowcast Server to send personalized business intelligence information and reports.
• Created Drilling reports across different within the Hierarchy and other hierarchies.
• Implemented Transformations using in comparative reports like revenue this year to last year.
• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Developed schema objects (facts, attributes, hierarchies, tables) using MicroStrategy Architect.
• Created reports using Advanced Filters, Prompts, Custom Groups and Consolidations.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Responsible for documenting the Functional and Technical Design documents.
• Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance) for optimization.
• Created advanced grid report, consisting of data analysis by combining a template with filters. The end - users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Excellent experience in MicroStrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.
• Used Command manager to create Some Users and assign User Privileges.
• Use Object Manager/Project Merge to manage change management for MicroStrategy objects across different environments (DEV, QA, UAT and PROD)
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Involved in Data validation testing and UAT to ensure data quality.

Environment: MicroStrategy 10.1/9.4.1 (Developer, Architect, Administrator, Web, Object Manager, Enterprise Manager, Command Manager, Office), Tableau 10.0, DB2, Oracle 11g/12c, Visual Insights, Teradata, Windows 8.

MicroStrategy Developer

Confidential, Wilmington, DE

Responsibilities:

• Created several Schema and Public objects as per the Business rules.
• Created logical data models to recognize source tables and columns to build MicroStrategy Schema Objects including attributes, Facts Hierarchies and Relationships necessary to create MicroStrategy Project.
• Worked closely with data warehouse and ETL teams on designing flexible and scalable data models for ROLAP across all enterprise data assets.
• Generated reports for the cooperation for assets period to period.
• Generated Key Performance Indicators KPI metrics to metrics.
• Developed Flash Dashboards & Scorecards in Micro Strategy 9 using Widgets and Selectors for summary level reporting.
• Managed projects through entire Systems Development Life Cycle, including creating timely thorough status reports and leading status meetings.
• Worked in end - to-end implementation of Business Intelligence projects, especially in scorecards, reports, cubes, & dashboards Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW (SQL Server) and consumed by Tableau Desktop
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Successfully migrated dashboards from Business objects to Tableau by translating the Universe objects in calculated fields.
• Added new users to groups and assigning them security privileges.
• Proactively created report formats and delivered personalized messages from the BI platform through Micro Strategy Narrowcast Server to a wide range of users.
• Developed and maintained the reporting solutions for the release and deployment between enterprise environments -QA and production migrations of MicroStrategy objects.
• Worked closely with business users and other development teams in all stages of the BI development lifecycle.
• Involved in report trouble shooting using VLDB properties.
• Assisted with user support and training and creation of Ad hoc data warehouse queries as needed.
• Expertise in developing MicroStrategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Performed installing, configuring, and administering MicroStrategy Intelligence Server, Web Server, and Mobile Serve.
• Also involved in migration using Object Manager.
• Worked on Performance tuning and stress testing initiatives.
• Participated and contributed to the BI strategy.

Environment: Microstrategy desktop 9.3.1, web, architect, object manager, Tableau 9.4, SQL Server, oracle 12c, windows 7 professional edition.

MicroStrategy Developer

Confidential, Ewing, NJ

Responsibilities:

• Interacting with customer on daily basis and providing valuable suggestions and freezing the requirements
• Created MicroStrategy Schema objects such as attributes, tables, Hierarchies and facts using MicroStartegy Architect.
• Involved in understanding the source target mapping documents.
• Used the Tableau desktop to analyze and obtain insight into large data sets.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Grid form of reports.
• Created Transformations (table based, formula based) for using in comparative reports like year to date and month to date.
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Implemented OLAP cubes functionality in Query performance.
• Worked on Drill map editors, Hierarchy relations, and pass through functions for complex reports.
• Performed the Administration tasks like caching, specifying Query Governing Thresholds and Report Optimizations.
• Developed reports for MicroStrategy Web users.
• Understanding the Data model and identifying the tables to be used for reports.
• Developed Report Services dashboards and documented and formatted the reports.

Environment: MicroStrategy 9.0.2 (Desktop, Web, Object Manager, Enterprise Manager, Office, Report Services), Oracle 10g, Tableau 9.0, Unix, Shell scripting, SQL Server, Informatica 9.1

MicroStrategy Developer

Confidential

Responsibilities:

• As per business requirement, designed developed and maintained MicroStrategy based reports
• Implemented Star and Snowflake Schema to fit reporting, query and business analysis requirements
• Worked closely with data modeling and ETL teams to develop the data model.
• Converted existing interactive reports with prompted and non-prompted reports using MicroStrategy
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters
• Created ad-hoc reports by drilling up, down, within, and across Hierarchies
• Tested all the reports by running queries against the warehouse using metadata SQL Assistant. Also compared those queries with the MicroStrategy SQL engine generated queries
• Used MicroStrategy Report Service to generate electronic snapshots of business data and presented them in a visually appealing and intuitive format
• Designed Prompts and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Worked extensively with intelligent cubes in developing the dashboards to increase the performance.
• Involved in designing Report services documents to create Dashboards per Business Requirements.
• Worked with business users to create SQL scripts for data extracts.
• Scheduled multiple reports for users and user groups.
• Managing projects through entire systems development lifecycle including creating timely/thorough status reports and leading status meetings.

Environment: MicroStrategy 8.1.3/8.1.1 (Architect, desktop, Narrow cast server, Object manager, Enterprise manager), nettezza, Windows XP Professional/7.

MicroStrategy Developer

Confidential

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.
• Extensive 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.
• Worked with Narrowcast server for sending reports via email to a large executive distribution group.
• Provided various management levels with reports, Time series analysis and wide range of graphs using MicroStrategy Web.
• Worked on the MicroStrategy Web and Web Administration
• Worked in handling the MicroStrategy BI and Narrowcast Administration.
• Created various Monthly Dynamic Dashboard documents with multiple panel stacks, selectors and customized widgets

Environment: MicroStrategy 8.0.1 (Developer, architect, intelligence server, narrowcast server, web) oracle 9i, sql server2005, MS Office, windows 2000.