SUMMARY

• Over 11+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including
• Technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Many successful MicroStrategy from small to very large distributed load balanced installations.
• Migrating over 100 reports and dashboards from the legacy BI system (MicroStrategy) to Tableau
• Reducing the development, fetch and execution times by over 80%.
• Created Universes according to the user needs, defined connections and exported universes to the different universe domains.
• Responsible for resolving Business Object Universe loops using Aliases and Contexts to remove the cyclic dependencies and also resolved Fan Trap and Chasm Traps.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Created Classes, sub classes, Dimension objects, Measure objects in multiple universes, checked the Integrity of the
• Generated BO reports for several levels and used drill analysis which allowed users to view data at a more detail level,
• Designed and coded application components in an agile environment utilizing a test driven development approach.
• Migrated 95 SAS dashboards to Microstrategy.
• Conducting enterprise-wide trainings for 500+ users, ranging from developers to EVPs, on using
• BI Tools (Tableau and MicroStrategy) focusing on best practices, standards and effective visualizations
• Good Domain knowledge of Banking, Insurance and Health Care applications.
• Experience of working at Client Location and interacting with business partners in requirements gathering and processing requirements.
• Extensive work knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Report Services.
• Expert in creating complex Grid/Graph Reports in MicroStrategy Desktop using Templates, Metrics, Filters, (Cascaded) Prompts, Drill Maps, Consolidations, Custom Groups, Subtotals, OLAP Functions, Compound metrics
• Involved in Query optimization/troubleshooting of MicroStrategy reports with and without VLDB properties. Good experience in creating MicroStrategy Dashboard reports.
• Extensive knowledge in Full life cycle implementation of simple to complex Business Intelligence projects.
• Responsible for Gathering requirements and Coordinating with Offshore team, creating Framework Manager Model, Creating different types of reports, performance tuning and trouble shooting of reports, Scheduling the reports, and Creating project supporting documents.
• Extensive experience in analysis to design the BO Universes and Business Objects Reports to support the user requirements. Used aggregate awareness in Universes and created reports employing functionality like Slice and Dice, Drill down, Functions, Filters & Formulae.
• Implicated in Preparation of Metadata in Framework Manager by importing tables views and stored procedures from Database and Preparation of Presentation layer in Framework manager.
• Experience in working with Control-M application to trigger events of remote application servers
• Experience in creation of test plans and test cases and testing of Business Intelligence BI tool based Reports.
• Experience in creating/reviewing Requirement Specification (SRS) & Design HLD) documents.
• Experience in directly working with business partners from Offshore.
• Good experience in Change Management Request of reports.
• Good Knowledge on Info Web, SDLC and IT Service Catalog applications.
• Trained on Qlikview.
• Effective communication & presentation skills.

TECHNICAL SKILLS

OLAP Tool(s): Tableau 10.1,10,9.3, 9.1, 9.2, 8 MicroStrategy 8.1, 9.1, 9.2, Cognos, Business Objects

ETL Tool: Informatica 9(Trained)

Database & Tools: Hadoop Hive,GreenPlum, Teradata, Sql Server 2000/2005, DB2, Oracle

Operating System: Windows NT, Windows XP

Others: MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Chicago,IL

Tableau Archietect

Responsibilities:

• Worked on the development of Dashboards for Key performance indicators for the top management.
• Interacted with business users and performed Gap Analysis of Client requirements. Development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Created parameters and quick filters. Created sets to display top products based on their spend.
• Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards.
• Set up security & user groups in the new 10.1 version
• Work with Server admins on the implementation rollout plan, change management and release management activities
• Production migration to Tableau 10.0 to 10.2 version
• Post production support B Tableau server Administration
• Support multi environment Tableau infrastructure including security, troubleshooting and general system maintenance
• Creating administrative dashboards and reports for tracking server and resource utilization.
• Troubleshooting performance issues and resolving them with utmost priority in production environment.
• Develop complex universes as per business needs which includes features like aggregate aware, Index aware, Hierarchies, Custom LOVs and etc.
• Performance Mangment task,using CCM and CMC.Overall responsible for capacity analysis,Peroformance tunning,auditing and optimzation.
• Provides the management with performance reporting,proactively plans and implements tunning indicated.

Confidential, Charlotte, NC

BI Consultant

Responsibilities:

• Developed Visualizations using Tableau Connecting different patterns like Essbase Cube directly, Essbase Cube via OBIEE Metadata, OBIEE metadata layer and Hadoop Hive.
• Created different kinds of actions to make the worksheet invisible while there is no selection.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Installation, configuration, patching and upgrading of Tableau tool across the environments
• Manage the application’s users, groups, and integration with Active Directory
• Automate monitoring & server job processes
• Created and maintained project tasks and schedules.
• Provided programming estimates, identified potential problems and recommended alternative solutions.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development.
• Selected and implemented agile development practices according to the application requirements for every project.
• Doing Tableau Server Management (like Clustering, Load Balancing, User Management etc)
• Expertise with tableau migration and scheduling.
• Experience in taking back ups and restoration of Tableau repository
• Good knowledge on Tableau Metadata tables and Postgre SQL

Confidential, Phoenix,AZ

Tableau Architect

Responsibilities:

• Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Line Charts, Scatter Plots and Combination Charts Marking, Drill Down, Hierarchies, Coloring, Calculated Columns and Custom Expressions etc., .
• Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau9.1 desktop/Server.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created parameters and quick filters. Created sets to display top products based on their spend.
• Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards.
• General troubleshooting experience using server logs
• Good understanding of API and java scripts usage in tableau
• Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau9.1 desktop/Server.
• Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management,
• Troubleshooting and general systems maintenance.
• Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment

Confidential, CA

Tableau Architect

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8.1 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Create interactivereportsand dashboards inTableauDesktop
• Experience on tableau server backup and restore configurations
• Subscriptions to Reports or Worksheets in Tableau Desktop.
• Created report schedules on Tableau server.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Administered user, user groups, and scheduled instances for reports in Tableau
• Act as an expert in Data Interoperability, Analytics and BI
• Serve as a primary point of contact for Production Support issue resolution
• Review, assess and promote adoption and standardization of Tableau support solutions across CT

Confidential, Phoenix,AZ

Tech Lead

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using MicroStrategy Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Creating DB views for the reporting purpose.
• Preparing Report Mapping Documents as per Specifications.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Created Test Cases and documented the Test Results.

Confidential, Phoenix, Salt Lake City

Tech Lead

Responsibilities:

• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Generated and implemented advanced MicroStrategy Reports by creating attributes, hierarchies, facts, metrics, filters, prompts and templates using MicroStrategy Architect.
• Extensively used filters, facts, consolidations, transformations and custom groups to generate reports for Business analysis.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc reports by drilling up, down, within and across dimension or anywhere.
• Co-ordinate onsite and offshore team work.
• Worked on tuning reports to resolve multiple issues and problems with existing reports.
• Tuning of the Reports and Data Mart reports by using VLDB Settings, Project Level Settings, Pre/Post SQL, Partition Tables, Indexes and Aggregate tables to reduce the running time
• Involved in developing of MicroStrategy Report Services Document and Dynamic Dashboards using various kinds of widgets
• Worked on Performance Tuning of the MicroStrategy reports after implementation.
• Worked with panel stacks, selectors, title bars, quick switch and flash widgets when developing dynamic dashboards.
• Used Bubble graph, gauge, time series slider, and fish eye selector widgets in developing dynamic dashboards.
• Supported the QA team to test new product functionalities, escalate bugs and or fixes to the appropriate team.
• Worked with back end database administration to provide necessary tables as per requirements.
• Worked with end user frequently to resolve various issues in day-to-day activities.

Confidential, Salt Lake city,

Tech Lead

Responsibilities:

• Access and analyze business requirements; system impacts, system requirements and manage the development activities.
• Developing Standard and Create reports using MicroStrategy Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Creating DB views for the reporting purpose.
• Preparing Report Mapping Documents as per Specifications.
• Unit testing and System testing the reports.
• Comparing the data in the existing reports vs. baseline reports by using Exam diff.

Confidential, Chicago,IL

Full Life Cycle Implementation

Responsibilities:

• Creation of models and packages in Framework Manager using multiple data sources.
• Resolving the loops using Shortcut Joints and Alias method.
• Created a Cube using "Sql Server Analysis Services” and used as Source for Cognos Framework Model.
• Created drill through reports using SSAS Cube as a source.
• Created parameterized linked reports using SSRS.
• Involved in Analyze, Design, Build, Test and Implementation phases of KPI project.
• Involved in business meetings to understand the High level Designed documents.
• Gathered the required information to develop the Project model and business required Reports.
• Prepared Technical Specification documents to develop the reports.
• Involved in installation of cognos8 software on different environments.
• Configured IBM enterprise edition and web servers.
• Involved in installation of cognos8.3 software in Oracle 10g environment.
• Created Framework manager model and packages for KPI.
• Applied filters and calculations in Framework manager.
• Extensively used report studio to develop simple and complex reports.
• Developed various Ad hoc reports and Schedule reports.
• Created Filters, Prompt pages, calculations, conditions required for the reports. Developed Complex reports by using Conditional formatting and Conditional blocking.
• Developed drill through reports by using report studio.
• Creation of deployment achieves for the reports in Cognos connection to move to server environment.

Confidential

Team Member

Responsibilities:

• Gathered reporting requirements from business end users/clients, documented requirements.
• Created various classes and objects for Universe. Measure, Dimension and Detail objects were created to meet the needs of end user requirements so that every possible query can be achieved.
• Designed universes using Business Objects Designer as per Business user requirements.
• Involved in designing, developing, deploying & testing the universe for report generation.
• Created Report Templates for consistency in the look and feel of the reports.
• Generated and Analyzed Drill down, Slice and Dice, master/detail reports for analysis.
• Formatted reports as per the User’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Created users and groups in the CMC Central Management Console and grated permissions based on their usage levels.
• Created, modified and maintained Business Objects universes and metadata using Designer.
• Created and maintained Business Objects reports in Web Intelligence.