SUMMARY:

• Over 8+years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Have working knowledge of Tableau Cloud.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Implemented Tableau/Oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Experience in Statistical Analysis Software (SAS) for developing and implementing various applications.
• Expert in Tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Improved Reports performance in Tableau using extracts and context filters.
• Strong Tableau Reports i.e. Worksheet and Dashboard creation experience.
• Utlized dynamic data connections for Reports creation.
• Experience with movement of Reports from SSRS to Tableau by applying reverse reengineering.

TECHNICAL SKILLS:

BI Tools: Tableau, Microstrategy,SAS

ETL Tools: Microstrategy, Microsoft SQL Server Integrated Services,IBM Data Stage 11.3

Databases: SQL Server 2008/2005, Oracle 10g/11g, MS-Access, DB2, IBM Netezza

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum. Agile Methodology

Scripting Languages: C, C++, HTML, SQL, PL/SQL and MS SQL.

Data modeling: Power Designer, ERwin, ER Studio, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Needham,MA

Tableau Developer

Responsibilities:

• Recreating SSRS Report hosted on SharePoint in Tableau 8.2.3 based on the requirement.
• Working closing with customer service and BI department for prompt and efficient delivery of Tableau Reports.
• Making use of dynamic connection to extract data from several servers for the creation of Dashboards in Tableau.
• Writing SQL to work with Tableau Dashboards and rectifying the errors as per VizQL (Query Language for Tableau).
• Taking care of Tableau Server permissions for Customer Service Dept.
• Working closely with Customer Service to understand their need for Tableau Dashboard.
• Performance Tuning of Tableau Dashboards to work effectively.
• Formatting of Tableau Worksheets for better look and feel as per the requirements.
• Applying Reverse Engineering to understand the previously created Reports in SSRS.
• Publishing the new Reports on Tableau Server.
• Working On Tableau 8.2.3 and responsible for all the aspect of Tableau Reports.
• Reverse Engineering SRS Reports to Tableau.
• Rectifying Errors in Tableau Reports and formatting the Reports wherever needed.
• Creating complex data views manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Usage of Parameters to filter the data before it can populate the dashboard.
• Making changes in the recreation of SSRS Reports wherever required after discussing with the Customer Support Team.
• Building of Dashboards from scratch without any requirement document.

Environment: - Tableau 8.2.3, My SQL, SSRS, SharePoint, MS SQL Server 2008

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Interacted with business users and performed Confidential Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• UsingTableauDesktop created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues withinTableau Server and Reports
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• 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.
• Involved in report tuning, caching, specifying query governing thresholds, and report ptimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.

Environment: Tableau 8.1, Teradata, Teradata SQL Assistant, Teradata Administrator, Business Objects, SQL, PL/SQL, MS Project,IBM Data Stage 11.3

Confidential, Warren, NJ

Tableau Developer

Responsibilities:

• Involved in Installation and configuration of Tableau Software. Have also configured distributed installation of Worker Servers for production environment.
• Created Users, groups and Domains from Active directory and created different License level for each User on Tableau Servers.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Environment: Tableau 7.0, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel,Tableau Cloud, SAS

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

• Design and development of new MicroStrategy Reports for the 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 preferences, helped 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.
• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.
• Analyzed Business Requirements and interacted with the Business Analysts for designing ad-hoc reports.
• Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts and Filters etc.
• Provided access to the Datawarehouse to a much larger audience by using Narrowcast Server.
• Personalized the report delivery as per user requirements.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
• Worked on MicroStrategy Intelligence server and MicroStrategy Webserver in production and development environments for performance tuning.

Environment: MicroStrategy Architect 9, MicroStrategy Desktop 9, MicroStrategy Web 9, MicroStrategy Intelligence Server, MicroStrategy Report Services, Teradata.

Confidential, Dallas, TX

Micro Strategy consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities, Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop8.0.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential, MI

Micro Strategy consultant

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Create connection maps to map users to different homogeneous databases or table spaces in a single project to direct end users against production and power users against development database.
• Designed, Developed and altered html document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
• Project duplication within and in between different project sources of Prod, Dev and UAT environments.
• Installed and configured complete MicroStrategy product suite on Prod, Dev and RE&I Lab environments.
• Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
• Validate, Detect and Repair logical/physical inconsistencies and corruptions of MicroStrategy metadata by running Scan MD/MD Doctor utilities.
• Actively involved in the Implementation of Novell LDAP authentication for MicroStrategy Products.
• Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
• Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.
• Actively involved in the full life cycle of Migration process from MicroStrategyv7.2.3 to MicroStrategyV7.5.1
• Actively participated in the proof of concept for the MicroSrategyv8.01 upgrade.

Environment: MicroStrategy tool suit 7.2.3/7.5.1/8.0, MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Teradata, Windows 2000/2003, Sun Solaris V9/V10, Altiris Client Management Suite V6.0.