SUMMARY:

• Dedicated, driven professional with 7 years of experience in Business Intelligence, Consulting, Data analytics and Reporting.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau 6.0/7.0/8.0/9.0
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1 and 8.2.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Data Visualization expert on technologies like Tableau, MicroStrategy, Spotfire and has gained expertise in these years in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Involved in several Visualization projects and led the development of projects and gathered several accolades from the client.
• Sound knowledge of the entire SDLC.
• Fast paced learner, quick solution provider and have worked under tight timelines and always deliver to the delight of the client.
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.

TECHNICAL SKILLS:

BI Tools: Tableau8.x/7.x/6.x

Relational Databases: MS SQL Server 2005/2008, Oracle 8i/9i/10g/11g, Teradata, MS Access.

Tools: and Packages SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio.

Languages: SQL, PL/SQL, C, HTML, XML

Operating Systems: Windows 9x/XP/2000/Vista/7, Unix

Configuration Management Tools: Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Tableau Developer/ Data Analyst

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Worked on Motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Worked extensively with Advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
• Created Data Definitions and help maintain Metadata repository.

Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010

Confidential, Los Angeles, CA

Sr Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Technical document on top of BRI document for the business users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Extensively worked onTableauDesktop by creating Sears & Kmart Complex reports & Dashboards.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.0
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, and Data connections as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Analyzed thedata using statistical features intableauto develop Trend Analysis reports.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Experience in development of MDX queries to extract and modify the data from Multi-Dimensional data sources (Cubes).

Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL server 2008.

Confidential, SFO, CA

Tableau Developer

Responsibilities:

• Involved in defining the project life cycle, following RUP methodology. Developed a vision plan that defined the primary goals and objectives of the project. Analyze business requirements and segregated them into high level and low level.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Assisted Project Manager in developing design and specification, according to the requirement and information gathered during JAD sessions and other forms of information gathering methods.
• Used Data Warehouse Architecture and Design - Star Schema, Fact and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.
• Worked on Developing a Data mart for dealer sales connect and developed SQL views on the mart to facilitate BI reporting on the same.
• Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Extensively worked with Teradata SQL Assistant, Teradata Administrator for running different queries.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 8.3/8.2/8.1/8.0, Tableau Server/Administrator, Teradata, SQL, PL/SQL, Teradata SQL Assistant, SQL Developer, DB2, Oracle, SQL Server, MS Project, Control-M.

Tableau Developer

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.
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes.
• Involved in Custom Geo-Coding; By creating a .CSV file and Assigning geographic roles to fields not recognized by tableau.
• 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.
• Involved in preparing the estimation documents, design document for new reports that are to be developed and also involved in preparing the impact analysis document for a change that is imminent.
• Creating and setting privileges on Users/User Groups.
• Developed Dashboards, Complex Reports having many calculations, complex layouts, HTML items etc. in Report Studio.
• Ensuring that team members are adhering to SLA’s in Incident Management for Priority tickets raised in CA Service Desk.

Environment: Tableau 7 Desktop, Tableau server, Oracle 11i

Confidential, NY

SQL Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Strong performance, diagnostic, and query tuning skills.
• Involved in creating ER Diagram, Data Architecture design, Data modeling.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Designing SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Optimized indexes, SQL queries and stored procedures to improve the quality of the software.
• Design, review, and create primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc reports for the clients as per their requirements using SSRS.
• Variance reports using Reporting Services (SSRS).
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Responsible for taking data objects across different databases: Development -Test - Production.
• Created trace in SQL Profiler and used Data-base engine tuning advisor for Performance tuning on stored procedures and script.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, VSS

SQL Developer

Responsibilities:

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction.
• Preparedfunctional specificationsfor user requirements.
• Experienced in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms or reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
• CreatedTables, Indexes, Table Spaces, Views synonyms,andintegrity constraints.
• Involved in creation ofschema objects, rolesandprivileges to users.
• PreparedUser manual, Technical documentsfor the end user.
• Prepared executables for system deployment and led the release of applications following
• Maintenance and support for the system.

Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX