SUMMARY

• 7+ years of Experience in Information technology and a good professional experience in Business requirements gathering, business intelligence, development, Testing, documentation, coding, product design, good management skills. Capable of understanding projects in different levels and business Intelligence implementation and maintenance, Data warehousing, good in web application development.
• Professional experience on Tableau Desktop, Reader and Server. (Tableau versions 7 / 8 / 9/10)
• Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Define specifications, design, and build of Tableau desktop reports and dashboards.
• Installation setup, performance tuning, user management and other administration of Tableau Server.
• Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Professional expert in roles such as BI End - to-End and solution implantation expert in data warehouse, BI KPIs modeling.
• Expert in designing customized interactive dashboards in tableau using marks, Action, filters, parameters, Security Concepts, calculations, and relationships.
• Expert in RDBMS concepts and constructs along with Database objects creation such as tables, Index’s, stored procedures, Views, user Defined functions, Triggers, and cursors.
• Extensive knowledge in creating Tableau scorecards, bar graphs, dashboards using stack bars, geographical maps, scattered plots, Gantt charts using show me functionality.
• Good experience in Software Development Life Cycle like project documentation design, testing and production development.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Involved in the installation of Tableau Server Application software, Tableau Desktop 8.0.
• Expert in Tableau Administration Tool for configuration, adding users, managing licenses, and data connections, scheduling tasks.
• Good experience on Databases skills with testing complex SQL & PL/SQL queries.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform and Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact, and Dimensions tables.
• Having knowledge onETLtools likeInformaticaand all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer).
• Extensive knowledge on various Internet-related platforms with specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.1
• Good communication skills, collaboration & am building skills, ready to work with new team employees, flexible to work in different project levels.

TECHNICAL SKILLS

BI Tools Experience: Tableau (Desktop 7 to 10, Tableau Server and Reader), Microstrategy

Data warehousing ETL Tools: Informatics Power Center 8 .X,7.X, SSIS.

Operating Systems: Windows 95/98/XP/2000/2003, UNIX, Linux.

Languages: HTML, CSS, JSP, SQL, PL/SQL, Python, Java, C, R.

Databases: Teradata, ORACLE 9i, 10g, 11g, DB2, MS SQL Server 2012, and MS-Access.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Database Tools: Toad, SQL Navigator.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Tableau Developer/ Admin

Responsibilities:

• Played a pivot role in the requirements gathering of the project by interacting with the business.
• Designed, developed and maintained daily and monthly summary, trending and benchmark reports repository in Tableau Desktop.
• Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements.
• Involved in building SQL queries that would be utilized in Tableau dashboards to satisfy the business's needs.
• Built various graphs for business decision-making using Python Matplotlib library.
• Used Git and Jira for code submissions and review process.
• Used Shell scripting, XML to automate some of the menial task
• Implemented visualizations and views like combo charts, stacked bar charts, pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.
• Published workbooks and extract data sources to Tableau Server, implemented row-level security and scheduled automatic extract refresh.
• Analyzed workbook performance on timeline and execution query, tuned and optimized analysis, calculated fields, layout and data source.
• Used Tabcmd for capturing tableau dahboards images to send business emails for business users.
• Created tableau server usage insturutions docments for future purposes.
• Applied tableau security and published report to Tableau Server Based on Sector Level & Market Level.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server to allow end users understand data on the fly by using quick filters for on demand needed information.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.
• Used Git and Jira for code submissions and review process.
• Created table, projections in Hp vertica database and worked on performance tuning in Hp vertica database.
• Developed various shell scripts to load the data from oracle to Hp vertica.
• Developed shell and SQL scripts to apply splits and coverage on trades which flow to Hp vertica through different feeds.
• Created project Documentation for future knowledge and provided 24/7-production support for Tableau users.

Environment: Tableau Desktop 10.3.2, Tableau Server 10.3.2, Hp Vertica Analytics Platform 8.1, Python 3.x (Numpy, Scipy, Scikit-learn package), Oracle 11g, Git Hub, Shell scripting, Linux, Windows 7

Confidential

Sr. Tableau Developer/Admin

Responsibilities:

• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Flat file, Excel to MS SQL Server using SSIS.
• SQL Server 2008 RDBMS database development using T-SQL programming, Views, queries, Stored Procedures.
• Created SSIS packages to load the data from Text File to staging server and then to Data warehouse from staging server.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created affinity analysis dashboard and Radical charts for better better understanding data.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots,Radical chart Geographic maps, Line chart, Pie charts and etc.,
• Created Financial reports, Demographics. This reports explains the Company profit and employe relationships and we calculated using norm for comparison.
• Set up required processes for Background Tasks, Data Engine, DataServer, VizQLServer, ApplicationServer, Repository and Gateway inTableauServer.
• Perform cleansing the redundant log files inTableauServer. Used parameters and input controls to give users control over certain values.
• Use Tab Admin commands to change configuration required forTableauServer.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
• Created and Published Tableau Dashboards into Tableau Server.
• Analyzed, manipulated and updated Database using SQL.
• Interacting with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Working onTableauadministration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions inTableau.
• ServerInstallation and Configuration ofTableau9.2 for Development, QA, UAT and Production, in a clustered Environment, along with Load/Gateway Balancers and Active Directories
• Created AD/SAML Authentications in tableau sever.
• PerformTableauServerback up to negate disaster recovery.
• Involved inBusinessProcess Redesign and its documentation.
• Assisted with user testing of systems and maintained quality procedures and ensured appropriate documentation is in place.
• Prepared theBusinessRequirement Document (BRD) and functional requirement document (FRD) for the enhancement of the existing services.
• Performed Analysis and Design of existing transaction sets, and modification of these transaction sets to ensure HIPAA compliance.
• Worked with subject matter experts to update existing Medicaid Management Information System (MMIS) in order to ensure HIPPA compliance.
• Writing SQL queries for data validation by using join conditions.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Provided support for Tableau developed objects and understand tool administration.
• Involved to create Documentation for debugging report for Tableau.
• Developed the table documentation for Tableau Dashboards.Wrote SQL queries for custom reports.
• Created functions, stored procedures, triggers and constraints using SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Recovered the backups of SQLServerproduction databases in testserverenvironment.
• Analyzed poorly performing SQL queries to improve application performance.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Microsoft SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, MS Excel, MS Access, Windows 2007 server.

Confidential

Tableau Developer/Admin

Responsibilities:

• Creating Patient satisfaction dashboards is designed to show the performance of key activities that directly or indirectly impact patient satisfaction, such as length of stay and lab test turnaround.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• TheAverage Length of Stay KPI dashboardsmeasures how long, on averarge, patients stay in your hospital after having a specific procedure, such as an appendectomy.
• ER Wait Timesmeasures the amount of time patients are currently waiting before being seen by an ER physician.
• The ER status dashboard provides an example of the type of real-time metrics ER workers need to track and monitor. By monitoring ER wait time and patient status, hospital staff can better respond to patient needs and deliver a high quality of service that reflects when on the entire organization.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau. Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Creating Patient Insurance claims dashboard, Patient Insurance satisfaction& Patient Claims Ratio and net income Ratios.
• Created report schedules, data connections, projects, groups inTableauserver.
• Used Toad for Data Validation.Defined best practices forTableaureport development
• Set Email subscriptions using SMTP emailserver.
• Create Groups, Projects and add Users inTableauServer.
• Involve in deployment of new dashboards to Test and Production environment.
• Create Schedules for dashboards to refresh automatically.
• Working with User for requirements and part of the team developing the software.
• PublishTableauworkbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Designing Proof of Concept and Mock-ups for new projects.
• Navigation and drill down features were implemented inTableaudashboards.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.,
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes, and Blended Axes.
• Used Trend Lines, Reference Lines, and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Built Stories in Tableau with various Data points to narrate the data to the end users.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQLserverdatabase.
• Worked with the DBA and Database developers to convert the functional specification to technical specification.
• Closely monitored the system performance after implementation to address any minor performance issues and evaluate the overall system.
• Wrote complex SQL queries to pull and process data from multiple data sources (SQLServer, flat files, etc.).
• Designed and programmed re-usable SQL code to prepare data for analysis.
• Downloaded data from various sources.

Environment: Tableau Desktop 8 & 9, Tableau server 9.2 / Administration, tabcmd, SQL Server, Teradata Studio Express, Teradata Aster, Oracle, Microsoft Excel 2007, MS Access, Windows 2007 server.

Confidential

Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Creating Customer RetentionDashboards for measuring the ability of your organization to retain customers over the long term and to generate recurring revenue from existing customers. Retention rate: The number of customers that make repeat purchases from your organization. Attrition rate: The number of customers that no longer make purchases from your organization.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Creating ThePoint of PurchaseorPoint of Sale KPIdashboards for the retail transactions are completed and compares each "point" over a given period.
• Creating Customer Satisfaction dashboard metricsmeasurethe quality of your customer service and providea reflection of the public's perception of your business.
• TheCost of Goods Sold KPImeasures the actual profit margin on products and services by analyzing how costs such as labour or shipping affect your profit margin.
• TheSales per Square FootKPI measures how much sales revenue you are able to generate for each foot of retail space provided. Use the following formula when calculating the sales per square foot KPI: Total Net Sales ÷ Total Floor Area
• Experience in Marks, Publisher, and Security.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Responsible for developing provisioning reports for various groups and upper management.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Creating Patient Insurance claims dashboard, Patient Insurance satisfaction& Patient Claims Ratio and net income Ratios.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Acloud dashboardhas key advantages overon-premise software such as being easier to deploy, requiring little to no IT support and is accessible on multiple devices.
• TheSales TargetTarget dashbords measures current sales (either dollar value or number of wins) and compares that value to a target orpast performance.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• 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.
• Experience with creating Worksheets and Dashboard.
• Working with Multiple Data Connections.
• Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes.
• Experience in BI interactive Dashboards and Tableau Publisher.

Environment: Tableau 8 Desktop, Tableau server, SQL Server 2008, R2, Informatics 8, SQL. Web Intelligence, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server.

Confidential, CA

Tableau Developer

Responsibilities:

• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Creating Sales Growth Dashboardmetrics measure the pace at which your organization's sales revenue is increasing or decreasing.Current sales revenue: The total dollar value of sales during the current time period. Previous period sales revenue: The total dollar value of sales during the period time period.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc...
• Creating TheSales Bookingsmetric measures the value of bookings over a given time period, where a "booking" is a won, signed, or committed sale. Booking: A won, signed, or committed sale where the purchase order has been received and approved.
• Created Sets, Groups and Data Bins as per user requirements.
• TheSales TargetDashboards measures current sales (either dollar value or number of wins) and compares that value to a target orpast performance. Wins: The number of new customers over a certain time period. Revenue: Income received through sales activities.
• Calculating TheAverage Purchase ValueKPI measures the average value of each purchase order your sales team processes. Purchase order: A document used to indicate the type of product ordered, number of units, and agreed upon prices and Purchase value, Units per transaction.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• 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.
• TheSales by Contact Methodmetric measures which contact methods are the most successful at generating sales, such as email, telephone, or in person.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Developed set analysis to provide custom functionality in tableau application.
• Expertise in creating Hierarchies for proving drill down option for the end user.

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005,XML, Tableau 8.1/8.0,SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer.

Confidential, Canonsburg, PA

Tableau developer/SQL BI developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related to each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Patient Record Dashboards for patient visiting doctor information and pharmacy bills, medical assistance, insurance track records and all categories included in this dash board.
• Origination Profit Analysis Dashboards: As is the case in any business, hospitals are always looking for ways to reduce costs and increase revenue.
• Patient Claim Payouts by Region this dashboard useful to find patient insurance claims records and payments
• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• 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 tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop
• Involved a key member in the development of E-R modeling (Logical design) of database incorporating business logic and user requirement
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to the server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards

Confidential

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent. Performed upgrades from Business Objects 6.x to Business Objects XI R2
• In the process of Upgrading Business Objects XI R1 to Business Objects XI R2.
• Installed and configured Weblogic 8.1 SP2 for Business Objects XI R1.
• Installed and configured Weblogic 8.1 SP5 for Business Objects XI R2.
• Configuration and Deployment of webcompadapter, jsfadmin, admin, desktop, analysishelp, styles, adhoc war files.
• Responsible for Providing sizing and recommendations on scaling the BOXI systems.
• Installation of Business Objects patches as on demand basis.
• Involved in installing DST patches to BO XI R1 environments.
• Used various transforms in SSIS to load data from Flat files, XML and FTP to SQL Databases.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Perform data modeling, periodic report validation, and data analysis by writing SQL queries using TOAD.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.