SUMMARY

• Over 8 +years’ experience in Business Intelligence applications (Tableau, MicroStrategy), data modeling, designing and architecting data warehouses for the Retail, Financial and Telecom industries.
• Scheduled Weekly and monthly meetings and escalated Management about progress of reports.
• Delivered on time reports and Task on every sprint and Completed Weekly, monthly and Quarterly Milestones.
• Well versed with the Tableau product suite namely In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server, Workbook and Dashboard.
• 4+ Years of extensive experience in Tableau Desktop, Tableau Server in various versions of tableau including Tableau 9 x, 8 x and 7 x. Proficient in data integration between different sources and reporting the same on Tableau environment. Extensive experience with 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 with other platforms like SharePoint.
• Extensively worked in creating and integrating Reports and Objects in Micro Strategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse.
• Implemented proactive delivery reports and implemented the business intelligence solutions using Micro Strategy Narrowcast Server.
• Extensive work experience with 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 that includes Logical and Physical data modeling.
• Familiar in working with very large databases like Oracle, DB2, Teradata, and SQL Server with Tableau and MicroStrategy Suite.
• Extensively worked on MicroStrategy Architect that includes closely with the business to gather, review, validate and document the business requirements.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience Confidential building, training, motivating and leading professional teams, managing projects and supporting client relationships.

TECHNICAL SKILLS

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

ETL Tools: Informatica, Data stage.

RDBMS: Oracle 11g/10g/9i/8i, Teradata, DB2, SQL Server 2008/2005

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

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

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

BI Tableau Lead/Administrator

Responsibilities:

• Performed requirement analysis of large-scale business systems and translated requirements into Statement of Work, Business Requirement Documents, Use Cases, Functional Specifications, Project Proposals, Testing and Post Implementation Plans.
• Responsible for gathering requirements and understanding the source systems to implement BI.
• Responsible for Data Modelling and Data Analysis.
• Responsible for development of Reports and Dashboards using Tableau.
• Responsible for tool evaluation for Data Integration and Data Visualization.
• Responsible for Building MDM/EDW.
• Responsible for Building Sales, Marketing and Finance reports and dashboards.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
• Responsible for creating Tableaumodels, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Responsible for presenting Weekly release status using PowerPoint.
• Responsible for building Reports/Dashboards related to Sales, Marketing and finance using Tableau.
• Responsible for converting all excel reports in to Tableau reports and dashboards.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience in working withTableauDesktop andTableauServer.(Versions 9 and 8)
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Responsible for installing Tableau server for DEV, QA and Prod environments.
• Responsible for creating sites, users, groups and projects in tableau server.
• Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy; define project scope, implementation phases, estimate resources and timelines.
• Experience with creating advanced reports in Salesforce.com.
• Responsible for the quality of data withinSalesforce
• Data analysis and manipulation
• Regularly perform data de-duping and cleanup procedures
• Audit, uncover and resolve data integrity issues
• Support developments to enhance and improve data collected
• Strong understanding of Salesforce.com best practices, security, and functionality.
• Responsible for preparing business case for new project or scope items.
• Performed data Analysis to Assess Scope items.
• Good Working knowledge on Excel, PowerPoint and Visio to generate reports, presentations and Process flows.

Confidential, Phoenix, AZ

Tableau developer

Responsibilities:

• Involved in the Involved in software development life cycle (SDLC) of the Project.
• Participated in the end user meetings to obtain the business requirements for creating reports.
• Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
• Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
• Team player with excellent communication and problem solving skills.
• Created Attributes, Facts for different MicroStrategy projects.
• Created the requirements Documentation for the MicroStrategy projects and also documented the 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 the Company Executives, through efficient use of MicroStrategy Report Services.
• Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
• Responsible for converting Microstrategy reports in to Tableau reports and dashboards.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience in working withTableauDesktop andTableauServer.
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Experience in creating Different maps, dual axis charts.
• Experience migrating the tableau development report to production.

Confidential, Middletown, NJ

Business Intelligence Consultant

Responsibilities:

• Worked extensively with business users to gather new requirements and solve existing issues.
• Analyzed the requirements to identify gaps between the requirement guidelines and technical design
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Created MicroStrategy objects metrics, filters, prompts, templates, consolidations, transformations, and custom groups using MicroStrategy Desktop.
• Created and implemented MicroStrategy reports by creating projects, custom groups, cubes, attributes, hierarchies, metrics, filters, and templates.
• Worked in developing reports, metrics, derived metrics, compound metrics and filters for complex reporting.
• Develop data aggregations in Teradata for adhoc reporting.
• Used adaptive metrics concept to dynamically calculate the metrics according to the elements of an attribute.
• Created Dashboards for various business requirements using widgets like Micro Charts, Bubble Graph, and Heat Map; as well as to personalize the reports as per user requirements, by using and editing several sets of individual grid reports.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Utilized auto prompt filter feature giving the end-user a choice of different filtering criteria each time they run the report.
• Created various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report, consolidation reports.
• Extensively worked on creating Report Services documents using multiple Grids and Graphs.
• Worked in tandem with offshore team to leverage capabilities and meet the business requirements.
• Involved in the Tuning of VLDB properties to enhance the performance of the reports Confidential project level as well as report level.
• Built complex formulas in Tableau for various business calculations.
• Built reports by connecting against Single Table, Multiple Tables and Custom SQL.
• Worked withTableauDesktop andTableauServer.
• Experience in creating Tableau worksheets and dashboards based of requirements.
• Experience in creating Different maps, dual axis charts in Tableau.
• Unit tested the reports and closely worked with QA team in developing test cases and scenarios.
• Provided User support during project development & End user testing of reports.

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

• Created MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop
• Created Dynamic dashboards using various widgets, controls and also conducted the requirements sessions with the end users to design the dashboards.
• Extensively involved in implementing Narrowcast Server. Set up and configuration of Narrowcast Server for sending out MicroStrategy reports and dashboards to the concerned business users nationally.
• Created metrics for users to build their own reports on Web by creating their own templates and filters using the available metrics.
• Created Reports, Dashboards using time series slider, radio buttons, and drop down menus, widgets for the flash version of the dashboards.
• Heavily worked with the users on the requirements for the Dashboards.
• Generated base formulae, mathematical expressions using existing facts in MicroStrategy desktop, which was used to build numerous other metrics.
• Implemented Caching strategies for high performance BI
• Created Transformations for using in comparative reports like revenue this year to last year
• Used Object Manager or duplication feature to promote development object into test project and finally to production.
• Involved in Testing and Tuning of Reports and Objects.
• Created Narrowcast application objects to deliver pool reports to the Business Users using Narrowcast System.
• Configured Enterprise Manager and updated statistics, folder paths and object deletions for multiple projects.

Confidential 

SQL Developer/ Tester

Responsibilities:

• Designed, developed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters and object prompts according to the business needs.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle10g and SQL hints.
• Analyzed reusable actuates code to help convert the reports into MicroStrategy canned reports.
• Used pass-through functions (applysimple and applycomp) in attributes and filters definitions.
• Implemented Report Services and generated the documents to be distributed to end users using Narrowcast Subscription.
• Tuning of SQL Scripts and also was involved in Data cleansing.
• Took regular back-ups of the Production Metadata in SQL Server Database.
• Involved in design of the application system.
• Involved in developing complex reports through Micro Strategy Desktop.
• Developed Reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.
• Provided level of effort estimates for new project work, enhancements and fixes.
• Performed the administration tasks like tuning, Caching, specifying Query and Report optimization.