SUMMARY

• 6 years of IT Experience in Data Warehousing &Business Intelligence applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Excellent PL/SQL and T - SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user-defined functions.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x/8.x/ 7.x.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expansive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Experience in administering user, user groups, and scheduled instances for reports in Tableau.
• Experience in Tableau Server 9.1, online publishing, Sharing, and Tableau online.

TECHNICAL SKILLS

ETL/BI Reporting Tools: Tableau Suite of Tools 8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase PowerDesigner.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2008/2005/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming: SQL, TSQL, PL/SQL

Tools: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++.

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQLServer setup, Security Manager, Service Manager, SQL Server Analysis Services (SSAS).

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Design, development of tableau reports.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Installation and configuration of Tableau server in dev. and production environment.
• Authenticating the tableau dashboards before publishing to tableau server.
• Publishing the developed reports to production Tableau server environment.
• 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
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with Mobile analytical portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Loaded data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

Environment: BI solutions, BI environment, BI Applications, Tableau 8x, 9x BI toolkit\Product stack (Desktop\Server (Suite), Windows 8, SQL Server, and Excel, SSIS, SSRS, SSAS

Confidential, New Orleans, LA

Tableau Consultant

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implemented infographics and Dash boarding for data visualization.
• Interacted professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• 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.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop .
• Experience with Teradata.
• Experienced with trouble shoot of Teradata connection.
• Tested reports and uploaded tableau dashboard sontoserver and provided production support for tableau users.

Environment: Tableauserver/Administrator, Tableau Desktop v6/v7, Windows Server StandardR2, Oracle 11i, Sybase,Crystal XI, SSIS, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential, Greensboro, NC

Tableau Developer

Responsibilities:

• Hands-on analysis, design and development of reporting dashboards and parameterized and cross tabular reports.
• Experience in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
• Create PDF push reports and setup email distribution on Tableau server 7.
• Knowledge of Tableau sheet objects and understanding of available functions and properties and Tableau architecture.
• Preserving and/or clearing user selections during tab navigation based upon business need and automation of user actions.
• Understanding of installation, configuration and administration of tableau server and desktop.
• Should have involved in administration (User access, Scheduling, Server configuring.)
• Understanding of the architecture and process of the tableau servers. Performance tuning of the dashboards.
• Published common Tableau reports on Tableau server under appropriate projects.
• Involved in the creation of users, groups, projects, workbooks and the appropriate the permission sets for Tableau server logons and security checks.
• Performance administrative and support activities across a multi-environment Tableau infrastructure including security administration, & troubleshoot and performance tuning or deployment issues when required during the implementations.
• Scheduled data extracts on daily/hourly basis according to business needs, to provide most up to date data to the business users.
• Understanding of Tableau architecture and administration.
• Improved Tableau performance by adding more processes on tableau worker.
• Identify user profiles and design report delivery environment to meet users’ needs.

Environment: BI solutions, BI environment, BI Applications, Tableau 7x version product stack, Windows, SQL Server 2005, & Excel.

Confidential

ETL Developer

Responsibilities:

• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
• Extensively used Informatica Power Center.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Created scripts for Batch test and set the required options for overnight, automated execution of test scripts
• Responsible for regression testing ETL jobs before test to production migration.
• Provided support in handling file validation errors and database down and connectivity errors.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Troubleshoot the data and performance issues raised by user community, designed, developed and deployed the code to fix them.

Environment: Informatica Power Center 9.5, Business Objects XI, Power Exchange 9.5, Oracle 11i/10g, MS SQL Server, XML Files, Erwin 4.0 TOAD, SQL, PL/SQL, SQL Developer, Windows XP, UNIX.