SUMMARY:

• Over 10+ years of IT experience in Business Intelligence/ Data Visualization and ETL with extensive Data Warehousing knowledge across Pharma, Financial, Retail and Telecom Industries.
• Around 6 years of Extensive experience in Tableau 7.0/ 8.2/8.3/9.1/ 9.3/10.0/10.1 as developer and administrator.
• Thorough understanding of Star and Snow Flakes Schema.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau Server logins and security checks.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS) and defined Data Source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi - dimensional expression (MDX), Perspectives and Roles.
• Expertise in Normalization/De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experience in creating Ad-hoc reports, subscription reports by using Report Builder in SSRS.
• Good experience in creating various SQL Server Integration Services (SSIS) packages, developing data flows and control flows.
• Experience in creating the extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases.
• Involved in creating complex dashboards, complex Parameterized sets, Story telling and feature rich dashboards.
• Experience in Tableau Administration for installations, Configuration, adding users, data connections, scheduling tasks, assign privileges etc.
• Good experience in wring a Custom SQL’s to improve the performance and also for validating the data.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau.
• Extensive experience in configuring the Hierarchy and Drill-down and drill-up capabilities.
• Experience in creating the data analysis to build the relation between the database tables and user requirements.
• Experience working with the Tableau Server and carry the Admin Tasks.
• Working knowledge on different data sources ranging from flat files, Oracle, SQL Server, Teradata etc…
• Proficient in writing complex queries using Oracle (PL/SQL).
• Working Knowledge in Agile methodology.
• Worked on gathering customer requirements and partnering with developers to ensure full understanding of internal/external customer needs.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Developed Sub Queries, SQL * Loader scripts, triggers, functions, stored procedures and packages.
• Hands on experience working on multiple databases, remote database environments and using DBLINK.
• Created ETL mappings to extract the data from different source systems, transform the data and then load to data warehouse.
• Developed various mappings using transformations like lookup, joiner, router, update strategy, Union, source qualifier, stored procedure, rank, expression and aggregator.
• Experience in schedule the jobs automatically by using Jenkins (DevOps).

TECHNICAL SKILLS:

Data Visualization/Reporting Tools: Tableau 10.x/9.x/8.x/7.x

Work book tools: Interworks 1.18

RDBMS: Oracle 11g/10g/9i, SQL Server 2005/2008,TeradataETL: Informatica 7.1.1/8.6.1

Oracle Tools: PL/SQL Developer, APEX, SQL*Loader, XML/BI Publisher, Toad, SQL Developer.

Languages: C, C++, Java

Web Technologies: HTML, XML, Java Script

Operating Systems: Windows Server 2003/2008/XP and Unix/Linux.

ERP: SAP ECC, CRM, SRM, NetWeaver, SAP HANA, Oracle Apps HRMS.

Hadoop (Big Data): Hive,Pig,Spark,,Impala

AWS: Red Shift, S3, EC2

PROFESSIONAL EXPERIENCE:

Confidential,Dallas,TX

Sr Tableau Consultant

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout and look &feel of the application to be developed.
• Worked with Alteryx tool for data preparation and analyzing the customer data.
• Removed & corrected bad data and also handled null data by using Alteryx.
• Developed scripts to load data into tableau accordingly and worked with multiple data connections including Hadoop/Hive by data blending.
• Worked with transforming huge volumes of data out and into Hadoop/HIVE .
• Automated the HIVE queries to join data from different data sources and analyzed the data.
• Worked on creating more than 100 teradata scripts for both Auto Finance and Home Loans dashboards.
• Created a custom SQL’s to reduce the data source data to improve the performance.
• Connected to the AWS Redshift directly from tableau to access cloud data warehouse and quickly perform visual analysis.
• Extensively worked on to improve the performance at database level and report level by collecting the statistics for user tables and implementing the cube/rollup concepts and also by hiding unused columns, by reducing the filters etc.
• Involved in analyzing the customer requirements and transform them into Tableau Dashboards and Reports.
• Developed complex visualizations like First view, COAF Summary and NPS view etc as per customer requirements,
• Created a trend charts for analyzing the 13 months data.
• Created calculated fields to display the 13 months data dynamically and also for calculating the number of different accounts.
• Connected to the different data sources like Hadoop HIVE, Oracle and SQL server, Teradata .
• Worked on creating different types of filters and sets as per the business requirements.
• Worked on action filters to navigate the data from one scorecard to another scorecard.
• Connected to the different data sources like Teradata and Amazon Redshift etc…
• Created the tooltip to display the information for CTQ values, number of surveys and Moments.
• Extensively worked on creating new and modifying the existing teradata scripts as per the requirements.
• Worked on monthly COAF scorecard refresh activity during month end.
• Worked on data validations by writing teradata scripts with existing system.
• Worked on tableau post-refresh activities like replacing the data sources, renaming the fields, creating sets and calculated fields.
• Resolved the validation issues by implementing cube/rollup concepts in Teradata.
• Analyzed the work book performance at tableau level by using performance recordings and interworks tool.
• Automated the COAF and Home loans scripts by using Jenkins (Dev-Ops tool).
• Worked with Github (version control system) to schedule the jobs in Jenkins.
• Published the dashboards to the QA server.
• Actively participated on daily stand-ups and weekly FSCO (FS customer Office) meetings.
• Published the developed dashboards, reports onto the Tableau Server so that the end users can able to access to the views.
• Worked on UNIX scripts to perform automation of jobs.
• Used the Java script to display visualizations from tableau server, tableau public and tableau online in web pages.
• Worked with Java script to dynamically load and resize visualizations.

Environment: Tableau Desktop /Server 9.3/10.0/10.1, Teradata 15.0, Excel, Sprint, Teradata SQL Assistant, AWS, Oracle, Alteryx, Java Script .

Confidential,CA

Sr. Tableau Consultant

Responsibilities:

• Involved in creating complex dashboards, complex Parameterized sets, Storytelling and feature rich dashboards.
• Worked with Apteryx tool to prepare and analyzing the data .
• Written Complex HIVE and SQL queries for data analysis to meet business requirements.
• Involved in designing and implementing the security for the HIVE databases.
• Analyzed the relations between the database tables and user requirements.
• Worked with Alteryx tool for data preparation and analyzing the customer data.
• Removed & corrected bad data and also handled null data by using Alteryx.
• Worked on Understanding of relational database structures, theories, principles, and practices.
• Extensively used Tableau features like Data blending, Parameters, Filters, Calculations, Hierarchies, Actions, and Maps etc.
• Connected to the different data sources like Hadoop HIVE, Oracle and SQL server.
• Developed, managed and maintained graph, table, slide and document templates that which allows for efficient creation of reports.
• Connected to the AWS Redshift directly from tableau to access cloud data warehouse and quickly perform visual analysis.
• Generated insights out of voluminous and complex datasets and built story lines.
• Created custom SQL and calculated fields within Tableau to facilitate automated production of data Visualizations.
• Published Workbooks by creating user filters so that only appropriate users can view/edit them.
• Generated context filters and handled performance issues while dealing with huge volume of data.
• Schedule the extract refreshes at the server and manage the Groups, Subscritions and permissions.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Connected to the different data sources like Hadoop HIVE, Oracle and SQL server.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Analyzed and prepared different types of reports based on RX and sales pharmaceutical data.
• Involved in knowledge transfer and created the documents for end-user support.
• Worked on Tableau Server installations, Configurations, Creating users, groups and projects.
• Performed data validations for tableau score cards by writing sql queries.
• Created a custom SQL’s to reduce the data source data to improve the performance.
• Involved in up-gradation of Tableau Server and also assigned access levels in server.
• Performed administration tasks such as creating, managing sites and backup the tableau data & restore from a backup, recover extracts from a backup & removing unwanted files, logs.
• Involved in administration tasks such as creating and managing sites like adding/Editing sites, adding users to a site, deleting site and importing/exporting site.
• Involved in managing groups like creating a local group via active directory and synchronizing active directory groups on site.
• Connected to the SAP BW data sources using the Tableau BW connector.
• Worked on creating extracts for sap BW data.
• Resolved the SAP BW connectivity/logon issues by using SAP Market place.
• Worked with SSAS to carryout ETL operations.
• Worked on different types of access securities like Active Directory/Local Authentication, User Identity, Single Sign on for authentication purpose.
• Worked on Unix scripts to perform automation of jobs.
• Worked with JAVA API’s to build the visualizations.

Environment: Tableau Desktop 8.2/8.3/9.1, Tableau Server 8.2/8.3/9.1, Oracle, Teradata, Unix,SQL Server, Excel, Alteryx, Hadoop, SAP HANA,Oracle SQL Developer, Agile-Scrum, Toad, Windows 2008 server,Java Script.

Confidential, Dallas, TX

Tableau Consultant

Responsibilities:

• Proactively communicated with the business users to understand the needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
• Created different views using Tableau Desktop which were published to the business stake holders for analysis and customization using filters and actions.
• Created various data connections from data source to Tableau Server for report and dashboard development.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Connected to the SAP BW data sources using the Tableau BW connector.
• Worked on creating extracts for sap BW data.
• Resolved the SAP BW connectivity/logon issues by using SAP Market place.
• Closely worked with SAPBW administrators to increase the performance.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
• Good experience in creating Business Objects Universe.
• Designed SSIS packages to extract, transfer and load data into SQL SERVER from different environments for the SSAS cubes.
• Worked on creating a calculations by using MDX .
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
• Worked with JAVA API’s to export visualizations to an image or PDF file .

Environment: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, Oracle, SAP HANA, Business Objects, Hadoop, PostgreSQL, Excel, SQL developer, Windows, CA Clarity PPM, Java Script .

Confidential

Tableau Developer/Administrator

Responsibilities:

• Worked on building, publishing customized interactive reports and dashboards.
• Created action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers and functions.
• Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience with Sorting, Building Groups and using in visualizations.
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Involved in Tableau Server installations, Configurations, Creating users, groups and projects.
• Involved in upgradation of Tableau Server and also assigned access levels in server.
• Performed Backup and restore of tableau server.
• Involved in administration tasks such as creating and managing sites like adding/Editing sites, adding users to a site, deleting site and importing/exporting site.
• Involved in managing groups like creating a local group via active directory and synchronizing active directory groups on site.
• Worked with numerous SSIS packages to load the data from third party systems to BI warehouse using different data flow transformations.
• Worked on different types of access securities like Active Directory/Local Authentication, User Identity, and Single Sign on for authentication purpose.

Environment: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, SQL developer, Oracle, Excel, Windows, SQL Server .

Confidential

Informatica Developer

Responsibilities:

• Served as Informatica Developer and Business Analyst, meeting deadlines and budget requirements.
• Worked on designing & developing data models by using Erwin.
• Interacted with Business Analyst to understand the business requirement.
• Identifying relevant source systems of the customer and extracting the data from source system.
• Created mappings to extract data from different source systems, transform the data and then load to data warehouse.
• Developed various mappings using transformations like lookup, joiner, router, update strategy, Union, source qualifier, stored procedure, rank, expression and aggregator.
• Preparing Unit test plan for the components developed and unit testing.
• Extracting primary or secondary data from existing internal (CRM, IMS etc.) or external data sources (i.e. Social media).
• Transforming the knowledge gathered from running specific models into actionable insights that could be readily deployed in the business cycles.
• Generating analytical reports by using SPSS, Tableau which covers areas like Physician Profile, Market Analysis, Call Objective and ROI.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Plotting structured with unstructured in terms of Physician prescribing patterns.
• Performance tuning of the ETL jobs by identifying the bottlenecks
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Informatics 7.1.1, Oracle 11g, Unix Shell, PL/SQL, SQL*Plus, SQL*Loader, Toad, Windows, UNIX, XML flat files, SQL Server.

Confidential

Oracle (SQL/PLSQL) Developer

Responsibilities:

• Designed and Developed data model using modeling tools like Erwin.
• Involved in developing & modifying SQL and PL/SQL tables, packages, functions, procedures,
• Cursors, collections, PL/SQL tables, views, indexes and database triggers.
• Coded PL/SQL scripts to implement triggers and functions for various packages.
• Involved in data migration from Flat files (.csv, .txt) into respective Oracle Database tables using SQL*Loader Scripts.
• Used dynamic SQL statements for run time SQL Query processing.
• Developed reports using XML/BI publisher.
• Tested SQL code and PLSQL and wrote indexes for efficient execution.
• Optimized code using TkProf and Explain Plan.
• Setup testing for module and integration settings.
• Documented the work by creating various reference manuals for reference by future testers and users.
• Used TOAD for faster and efficient code and application development.
• Used External tables to query the data from oracle tables.
• Performed Unit testing on reports and queries.
• Worked on Production support, bug fixing and enhancements.

Environment: Oracle 8i, PL/SQL, SQL*Loader, UNIX, Toad, XML/BI Publisher, Ms-Excel, Erwin