SUMMARY

• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8 and SQL, PL SQL and Unix shell scripting
• Experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Proficient in designing Data Mart and Data Warehouse using Erwin, Star and Snowflake Schemas.
• Introduced Tableau to my team to produce appealing data visualizations to clients and to help them make effective business decisions
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
• Experience in configuring reports from different data sources using data blending.
• Implemented Tableau/oracle BI security Confidential the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-tierenvironment
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of +Reporting and Analysis projects
• Used Essbase outline extractor utility to extract metadata and loaded into planning application through HAL.
• Developed the batch scripts to automated process using outline extractor.
• Used HAL to load accounts, entities, and custom dimensions from flat file into Planning Cube.
• Developed Task Lists, Work Flows, Menus and Business Rules with an option for Run-time prompts.
• Experienced in roles such as End-to-End BI and data-warehouse Solution implementation expert, BI Project Concept Scoping, BI Semantic layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.
• Experience in Requirement Analysis, Gap Analysis, Change Management and Impact Analysis, Capacity planning, Proposal Development, Design validation, Technical leadership, and mentoring and user training.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop 8.2/8.1/7, Tableau Server 8.2/7,Tableau Reader

OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x, Hyperion Planning, Excel Add-In, Smart View, Oracle Data Integrator, Hyperion Work Space and Hyperion Shared Services

ETL: Informatica Power Center 8.1.1/7.1.2/7.1.1/7.1.5 , DataStge 7.5

Tools: Erwin 4.0, SQL Developer, TOAD, Pl/Sql Developer Tidal Enterprise Edition and MS Visio.

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata and IBM DB2.

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

Environment: Windows XP/2000/2003/NT 4.0/Vista, UNIX, Sun Solaris, Linux and MS-Dos.

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO, IL

TABLEAU CONSULTANT

RESPONSIBILITIES:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableaudesktop server.
• Mentored business power users to create reports/dashboards usingtableaudesktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features ofTableausoftware like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW fortableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, quick filters, actions, hierarchies features in tableau.
• Executed and tested required queries and reports before publishing.
• Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through TableauApp in IPad, iPhones, and other smart mobile phones.

ENVIRONMENT: Tableau 7/8.2 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

TABLEAU CONSULTANT

RESPONSIBILITIES:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• As a Tableau Desktop Developer I was responsible for creating dashboards and overall creation of data visualizations.
• Good experience on in dashboards designing with large data volumes from various data sources (SQL Server, oracle, spreadsheets etc.)
• I have a Strong report/dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design..
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Worked closely with reporting team and lead the HAIR Reporting team for deployingTableaureports and publishing them on theTableauand Share point server.
• Validated data Confidential the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Created custom date time calculations and macros in the reports.
• Created jobs, schedules and report views for the business users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Provided Assistance to users in building reports in Report Studio, Query Studio, and Analysis Studio
• Provided solution to users who raised tickets and educated new users with basic Cognos reporting.

ENVIRONMENT: Tableau Desktop 8.0, Power Play Transformer 7.3, ReportNet1.1/8.3, Microsoft SQL Server 2012.

Confidential, NORWALK, CT

TABLEAU CONSULTANT

RESPONSIBILITIES:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tabcmd and Tabadmin utility tool. upgraded Workbooks and Dashboards from Tableau 6 to Tableau 7
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 6/7.0 Desktop, Tableau server, Oracle 11i, Data Stage 7.5, SQL Server, TOAD, Windows 2003/ XP, UNIX.

Confidential - HOUSTON, TX

SQL DEVELOPER

RESPONSIBILITIES:

• Installed and maintained MS SQL Server 2005 on Windows server 2003 server.
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Support and maintained database clustering.
• Configuring, tuning and optimizing SQL Server 2000.
• Involved in the implementation of snapshot replication.
• Administer tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes and triggers.
• Creating DTS packages for data import/export, scrubbing and scheduling jobs for backups.
• Creating database maintenance plan for performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing
• Maintained high availability of database using database Mirroring and Log shipping.
• Job monitoring and make sure all jobs running successfully Confidential night.
• Performed level scripting, fixing of codes and software enhancement process.
• Worked with linked servers and distributed transactions.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Involved in cubes using SQL Server Analysis Services.

ENVIRONMENT: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SSRS.