SUMMARY

• 8 years of experience in Information Technology, Business Analysis, Data Analysis, design, development, testing, implementation and maintenance in a BI environment.
• Experience in delivering reports and dashboard solutions against BI specifications
• Expertise in Tableau as applied to BI data analytics, reporting and dashboard projects.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks fromTableauDesktop toTableauServers
• Strong Experience in Developing reports and dashboards using Tableau 8x versions.
• Extensively involved in performing administrative activities such as User administration, Views creation, Group management, report authorizations withinTableau
• Skilled inTableauDesktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes
• Skills and experience in using appropriate calculations, parameters, report types, dynamic attributes, sets, cubes, filters etc withinTableau
• Created schedules, Tasks, Groups, Users, Permissions and Subscriptions onTableauserver.
• Experience in creating various views inTableauby different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot and heat maps.
• Experience inMicroStrategy8.x /9.x Desktop, Report Services, Web, Intelligence Server, and OLAP Services.
• Experience on Intelligent Cube Development, Custom widget, visualization development and implementation.
• Experience with Agile development methodologies
• Experience in writing complexMicroStrategyqueries, including the use of relationship filters, custom groups, consolidations, VLDB properties
• Installing, Configuring of allMicroStrategyproducts includingMicroStrategyDesktop, Administrator, Intelligence Server, Web Server.
• Worked directly with End users to determine requirements, design and develop queries to best meet the clients’ business needs
• Experience on Project creation, schema objects creation, Development of queries, documents & dashboards with flex based widgets.
• Created different types of objects attributes, metrics, filters, prompts, Custom Groups, Consolidation & also created security model for all users.
• Implementation of best practices in terms of design, development and documentation standards.
• Knowledge in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables. Good understanding of Star and Snowflake schemas

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, TX

Tableau Consultant

Responsibilities:

• Involved in the gathering of business requirements and translating them to the report specifications for the conversion of Actuate Reports to Tableauplatform.
• Analyzed requirements for various reports, dashboards, created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards usingTableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop.
• Worked on extensively large data volumes, experience writing SQL against databases using Toad, SQL developer to write queries for understanding data and testing dashboard output.
• Extensively used advance chart visualizations inTableau to assist business users in data discovery and solving complex problems.
• Utilized advance features ofTableau 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.
• Suggested ways to improve dashboard rendering performance as directed by user requirements.
• Extensively used analytical features inTableau like Statistical functions and calculations, trend lines, forecasting etc. in manyTableau reports.
• Publish the developed dashboard, reports on theTableau Server so that the end users having access to the server can view the data.
• Setting up of sites, projects, user groups and users in Production environment.
• Installed and ConfiguredTableau8.2 on multiple environments.

Confidential, Houston, TX

Tableau Consultant

Responsibilities:

• Proactively communicated with the business users to understand the needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination with Clients for feasibility study of the project inTableauand drawing up the timelines as per project requirement.
• Created Users, Groups and projects inTableauenvironment.
• Created and managed schedules for users.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the updated data accurately.
• Created different views usingTableauDesktop that were published the business stake holders for analysis and customization using filters and actions.
• Created different charts showing KPI by color that were broken into regions allowing business user to understand which stores are outperformers in different categories.
• Developed various data connections from data source toTableauServer for report and dashboard development.
• Combined visualizations into InteractiveTableauDashboards and published them to the web portal.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets usingTableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending, filters, actions, Hierarchies feature inTableau.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards and handled the performance issues effectively.
• Achieved performance tuning by implementing Caching, Aggregate tables and creating indexes on tables.
• Involved in preparing material and training Business users.

Confidential, Foster City, CA

MicroStrategy Consultant

Responsibilities:

• Spearheaded MSTR upgrade project by consolidating metadata from multiple servers into one, standing up new production environment and separating out web servers for 4 separate environments.
• Upgraded MD from v9.2.1m and v9.3.1 to v9.4.1 HF7.
• Project Duplication, user profiles management and object migration using Object Manager.
• Comparing projects for delta and syncing them by migrating objects before go - live.
• Extensive user and user group cleanup and deploying of a streamlined user management model for easy administration.
• Worked extensively on Command Manager to create users, user groups and subscriptions.
• Configuration of I-server. Project level configurations.
• Installation of MSTR Web, configuring web settings and authentication modes.
• Meeting with clients for installing plugins for MSTR Office 9.4.1. Performed configuration changes, xml modifications and adding multiple project sources using a single URL.
• Troubleshooting administration issues, resolving day to day production tickets.
• Setup MSTR mobile server, created configurations and generated Mobile URL for IPad.
• Built Enterprise Manager reports to monitor usage for reporting to management.
• Performed End to End upgrade tasks on multiple client facing and internal servers. Resolving duplication issues, MD inconsistencies using Scan MD and draft overall project plan involving offshore resources.

Environment: MicroStrategy Desktop 9.2.1m 9.3.1 9.4.1, MicroStrategy Web 9.2.1m, Oracle 10g, Windows 2000/NT, SQL Server

Confidential, Louisville, KY

Micro strategy Developer

Responsibilities:

• Requirements gathering from the business users, conducting meetings to understand reporting needs and drafting mock ups.
• Working with BA’s to identify data sources, conduct data profiling for due diligence on different type of data.
• Extensive validation of data across different layers of the warehouse, identifying discrepancies and working with ETL for debugging.
• Evaluating Netezza views designed to work with new and existing microstrategy schema.
• Tested all the reports by running queries against the warehouse using Agitiny Query tool.
• Worked in team to identify and analyze the requirements of the users. Worked closely in understanding the requirements to support the new reporting requirements.
• Built Hierarchies, Attributes, Facts and Relationships between various attributes and developed logical models for reporting environment.
• Developed advanced Filters (Report as Filter, Prompted Filter, Advanced Qualification Filters ) for complex reports.
• Created the Hierarchical Prompt, Object Prompts for Forecast Merchandise to give the end users the required power to define the report definition at the run time.
• Extensively worked in Nested metric, Derived metric and Compound metrics(Deviation, Accuracy, Accuracy % etc ) embedded with Pass through expressions such as Apply simple and Apply Comparison .
• Worked on Dashboard and Report Service Document embedded with complex reports with Custom Groups
• Perform data analysis in the source system before loading into staging table.
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
• Implemented advanced data drilling features, drill maps that allow users view the reported information in greater details, from high-level enterprise wide overview to information relating to specific stores and products.
• Worked with security levels such as Security filter, connection mappings, object level security and project level security.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.
• Trained users in MicroStrategy Web .
• Migrated Schema and Configuration Objects into various env. using Object Manager.

Environment: MicroStrategy Desktop 9.2.1, MicroStrategy Web 9.2.1, Netezza, Windows 2000/NT, Oracle 10g, Netezza Twin Fin, Saas, Cognos 10

Confidential, Columbus, OH

MicroStrategy Consultant

Responsibilities:

• Supervising daily ETL, liaising with offshore for successful completion of DAC and UC4 jobs so caches, cubes are appropriately refreshed.
• Extensive user management, security filters, object security for individual users depending on their security clearance and territories of service.
• Production support of MicroStrategy iPad and Web applications designed for C-level executives.
• Troubleshooting dashboard data and security issues.
• Migration of objects after bug fixes and enhancements using Object Manager, carrying out metadata checks using Scan MD.
• Testing bug fixes and enhancements, working with developers to resolve production issues.
• Monitoring application performance for various projects with Enterprise Manager involving custom reports.
• Documentation, supervising smooth ownership transition as applications go live
• Intelligent server configuration and troubleshooting server issues.
• Running shell scripts for routine operations, command manager.
• Created Events, Scheduling and Subscriptions for cache generation for individual iPad and Web end users.
• Training offshore resources in executing MicroStrategy production jobs, coordinating with multiple resources for handling 24X7 production support.

Confidential, Indianapolis, IN

Data Analyst/Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse.
• Assisted in design of conceptual and logical data models of Data Warehouse and tables.
• Was responsible for indexing of the tables in that data warehouse.
• Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.
• Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Proficient in Functionality Testing, Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), Visual Basic, SQL, SQL Server, T-SQL, Oracle, C#.Net, XML, WebLogic, Websphere business process modeller