SUMMARY:

• Has 8 +years’ experience in Business Intelligence applications (Tableau & MicroStrategy), data modeling, designing and architecting data warehouses for teh Retail, Healthcare, Financial and Telecom industries.
• 5+ Years of extensive experience in Tableau Desktop, Tableau Server in various version of tableau including Tableau 9 x and Tableau 10 x. Proficient in data integration between different sources and reporting teh same on Tableau environment. Extensive experience wif Tableau Dashboard, Reports, and Data Visualization
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platforms like SharePoint.
• Well versed wif teh MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Dashboards.
• Extensively worked in creating and integrating Reports and Objects in MicroStrategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in teh data warehouse.
• Implemented proactive delivery reports and implemented teh business intelligence solutions using MicroStrategy Narrowcast Server.
• Extensive work experience wif Ad hoc reporting using SQL queries and standard reporting environment.
• Extensive work experience in designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema for FACT and Dimensional tables dat includes Logical and Physical data modeling.
• Familiar in working wif very large databases like Oracle, DB2, Teradata and SQL Server wif MicroStrategy Suite.
• Extensively worked wif business to gather, review, validate and document teh business requirements.
• Experience in writing, reviewing and executing test scripts using different testing applications.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience at building,, motivating and leading professional teams, managing projects and supporting client relationships.

TECHNICAL SKILLS:

BI Tools: Tableau 9.x/10.x, MicroStrategy 9.4.1/9.3.1/9. x/8.x Desktop, Web, Object Manager, Command Manager, Dashboards and scorecards.

ETL Tools: Informatica, Data stage, Alteryx

RDBMS: Oracle 12c/11g/10g/9i, Teradata, SQL Server 2008/2005

Languages: SQL, PL/SQL, HTML, C, C++.

OS: MS Windows NT/2003/XP/ME/95/98, Windows 8, Windows 10, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. Tableau Developer

Responsibilities:

• Extensively worked wif business to gather, review, validate and document analytic requirements.
• Building dashboards from Tabular Models to halp users to identify critical KPIs and facilitate centrally monitoring teh clinical data.
• Developing custom clinical trial dashboards for users to understand discontinuations rates, treatment compliance, patient safety and many more in a clinical study.
• Designed and developed teh most suitable User Interface such as Dashboards, multiple charts types, Trends.
• Developed complex calculated fields for teh business logic, field actions, sets and parameters to include various filtering capabilities for teh dashboards, and to provide drill down features for teh detailed reports.
• Produced attractive visuals/dashboards to convey teh story inside teh data.
• Produced analytics by blending different data sources in tableau.
• Worked extensively wif Advance analysis Actions, Filters, Calculations, Parameters, Background images, Trend Lines, Statistics and table calculations.
• Configured tableau to team SharePoint site so dat data into teh dashboard is imported directly.
• Performed Tableau Admin duties dat comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in teh Tableau Server.
• Optimized Data Connections, Data Extracts, and schedules for background tasks and Incremental Refresh for teh weekly and monthly dashboard reports on Tableau Server.
• Worked as production support lead, which involved managing, handling, analysis and implementation of Incidents/Issues.
• Worked wif data warehousing team to fix key data mapping, data flow and data integrity Issues.
• Good knowledge in Incident management tools like service now.
• Created reports to easily track, maintain and respond to Incidents on service now.
• Used service now auto schedule feature to export data directly and feed to tableau for user reporting.

Environment: Tableau Software 9.x/10.x, Microsoft office, SQL, Oracle, SharePoint, Alteryx

Confidential, Newark, NJ

Sr. Business Intelligence developer

Responsibilities:

• Interact wif teh Business Management Solutions team on a Data Warehousing project involving MicroStrategy implementation on Teradata database. Involved in software development life cycle (SDLC) of teh Project.
• Involved in interacting wif Data Architect in building Views and Table structures for Micro Strategy.
• Configured teh Intelligence Server and pointed teh database instances in both development & Production environments.
• On teh Architectural aspect of MicroStrategy, created and modified mappings in teh process of creating new Attributes and Facts.
• Created all possible Metrics, for enabling teh end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of teh business status, strength & weakness, potentials etc. for teh client at a glance, also interact wif data as necessary
• Embedded live Tableau dashboards on PowerPoint presentations, keeping teh slides always updated
• Designed and developed dashboards for use by Executives and Directors on a daily/weekly basis.
• Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability. Connected tableau server wif SharePoint portal and setup auto refresh
• Involved in MicroStrategy Administration using modules viz, User manager, Command manager, service manager, VLDB Settings, License manager, Subscriptions and Events.
• Performed teh administration tasks like tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Worked on support project involving fixing frequent customer trouble tickets.
• Created security filters to restrict access to users under their directors using tailored groups.
• Reduced teh time taken for teh reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.

Environment: Tableau Software 8.x, Microsoft office, SQL Server, Teradata, SharePoint, MicroStrategy 9.4.1 (Desktop, Administrator, Architect, Intelligence Server, Web, Object Manager)

Confidential, Secaucus, NJ

Tableau/ MicroStrategy Developer

Responsibilities:

• Design and development of new MicroStrategy Reports for teh new Retail BI system - created Schema objects / Application objects as well as configuration objects in Test environment.
• As MicroStrategy Architect Involved in building schema objects to supported business process change or enhancements throughout projects.
• Handling Daily user issues - Setting up and maintaining MicroStrategy web user roles and ps, halped in resolving daily issues in running Reports and Data Integrity issues.
• Created advanced metrics (simple, nested & compound), advanced filters, advanced prompts, report designs and drill maps.
• Created Tableau Dashboards showing Time Series Analysis of Web Traffic and sales conversion based on different factors. Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. dis replaced time consuming Excel/ SAS based data analysis.
• Created Tableau Dashboard visualizing impact of different media based Advertisements on Same Store Sales over different timeframe. Evolved Tableau visuals demonstrating relationships between TV advertisements, sales conversion of web traffic and call volumes at teh call centers. Complex data joining and data blending was used to bring all teh from diverse data sources in to one dashboard.
• Created advanced grid reports, consisting of data analysis by combining a template wif filters. Teh end-users were able to generate ad-hoc report by drilling up, down, wifin and across dimension or anywhere.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy dat can be re-used to build any number of metrics.
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template wif filters, using MicroStrategy Desktop and Web.
• Used MicroStrategy Object Manager to migrate MicroStrategy objects from development environment to teh Test environment.
• Design, build and maintain logical model for MicroStrategy reporting application.
• Design, build and maintain all MicroStrategy schema objects (attributes, facts, hierarchies).
• Good understanding of teh type of schemas dat best support MicroStrategy in different scenarios.

Environment: Tableau Software 7.0, Microsoft office, SQL Server, SharePoint, MicroStrategy 9.2 (Desktop, Administrator, Architect, Intelligence Server, Web), Object Manager, Oracle, UNIX.

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in teh software development life cycle (SDLC) of teh Project.
• Participated in teh end user meetings to obtain teh business requirements for creating reports.
• Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on teh user requirements.
• Used teh Project Creation Wizard to create Facts and Attributes and used teh respective editors to enhance them.
• Team player wif excellent communication and problem solving skills.
• Created Attributes, Facts for different MicroStrategy projects.
• Created teh requirements Documentation for teh MicroStrategy projects and also documented teh MicroStrategy Environment.
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Designed an efficient BI Dashboard for teh Company Executives, through efficient use of MicroStrategy Report Services.
• Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
• Implemented proactive, personalized information delivery services using MicroStrategy Narrowcast Server. Created different objects dat define Narrowcast Server services, including content Information Objects, Documents, Publications, Subscription Sets, and Schedules.
• Created all possible Metrics, for enabling teh end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web.
• Managing schema objects and application objects across teh project by using Object Manager.

Environment: MicroStrategy 9.0/8.0 (Desktop/Agent, Object Manager, WEB, Enterprise Manager) Teradata, Oracle 10g (PL/SQL), Windows 2000 Professional, UNIX.

Confidential

MicroStrategy Consultant

Responsibilities:

• Analyze requirements and develop derived metrics, custom report objects as required
• Involved in collecting teh business requirements from users by understanding teh Source System (OLTP) and interacting wif teh users.
• Created Complex Metrics forcing Dimensionality and Conditionality embedded wif prompts.
• Developed logical and physical data model by defining strategy for Star Schema wif Fact and Dimension tables wif Detail, Summary, Look-up Tables, Indexes and Views.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for teh business line to satisfy teh specifications using MicroStrategy Desktop and MicroStrategy web.
• Developed MicroStrategy reports and related objects.
• Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
• Responsible for testing of developed reports and report objects.
• Created transformations to-do time series analysis and to compare teh values at different times such as sales at dis year versus last year, or month-to-date.
• Created Dynamic Enterprise Dashboards and utilized teh new features to convert teh dashboards into Flash mode.
• Involved in Analysis, Design, Development, Testing, Documentation and Implementation of teh project.
• Maintain standardized MicroStrategy design, development, testing and deployment task documentation
• Troubleshoot MicroStrategy application issues internally and wif vendor
• Design, build and maintain logical model for MicroStrategy reporting application
• Design, build and maintain all MicroStrategy schema objects (attributes, facts, hierarchies)
• Understand teh type of schemas dat best support MicroStrategy in different scenarios

Environment: MicroStrategy Desktop 8.1.2/9.0, MicroStrategy Intelligence Server 8, Oracle 10g, SQL, Windows 2000.