PROFESSIONAL SUMMARY:

• Having 9+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment in Tableau 8.x and 9.0,9.2 & 10.x/10.3 as a Developer Tableau Desktop, Tableau Server & SAP BOBI 4.0,4.1,4.2, SAP HANA, Micro Strategy, SSRS Reports, Power BI, R language, Python.
• In - depth knowledge on Tableau Desktop and Tableau Server. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, 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.
• Experience in preparing Functional specification and Technical specification documents.
• Used Tableau server for publishing the dashboards to the server, user management, user security, administration, and Content Restriction as a Tableau Content Administrator.
• Experience working as a Tableau analyst, Tableau Developer and Tableau Administrator and experienced as in using the Tableau BI Products Tableau Desktop and Tableau Server.
• Created automated scripts forTableau workbook refresh when not using live connections.
• Experience withTableau maintenance tools andTableauserver monitor to start/stop services and maintain statuses.
• Involved in extracting data from source to HDFS and importing data from HDFS to Hive using SQOOP.
• Expertise in creating Report Inventory, Report Mapping document, Report business requirement documents (BRD), Reports functional requirements documents (FRD), Use cases diagrams and report inventory document.
• Expertise in Data Analysis, Data Extraction, Data Marts. Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts and Project Manager
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Extensively worked for various versions of tableau 8x and 9x.10.x.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Creating Backup scripts to take periodic backups for the content onTableauServer.
• Used Tab adminand Tab cmd commands in creating backups and restoring backups
• Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Introduced Tableau to Client's to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in creating ad-hoc reports by using Report Builder in SSRS.
• Created Dashboard's using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Performed Linux/Unix administration including changes, deletes, disk space and worked on Linux logical volume, creating a volume group, file systems, and troubleshooting.
• Managed Users on Unix/Linux and Windows systems.
• Experience in training Business users through online and in-class sessions.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau8.0 to 9.3).
• KDeveloped reports using Microsoft Power BI (Desktop, Service, Mobile).
• Experience on CMC creating Users, Groups, Access Levels, Security, Folders, Categories, and Connections etc.
• Experience in creating Crystal Reports including sub-reports, Standard reports, Crosstab reports, drilling reports, analysis reports, data reports along with LOV.
• Experience in Creating Adhoc Reports using Web Intelligence Rich Client and schedule the reports as per the business needs and supporting.
• Well versed in Business Objects Suite (XI R3/XI R4) BOBI 4.0,4.1, Universe Designer, Web Intelligence(WebI), Information Design Tool(IDT)
• Developed complex BI reports for SAP modules such as SD, MM, FI-CO and HR.
• Experience on CMC creating Users, Groups, Access Levels, Security, Folders, Categories, and Connections etc.
• Complete knowledge on python with R language.
• Experience in creating Crystal Reports including sub-reports, Standard reports, Crosstab reports, drilling reports, analysis reports, data reports along with LOV.
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges
• Significant experience with ASAP/SDLC, SCRUM Methodology requirements analysis, design, development, testing, documentation, user training and support.
• Out-standing skills in debugging and problem solving.
• Experience in creating/reviewing Requirement Specification & Design documents

TECHNICAL SUMMARY:

REPORTING TOOLS: Tableau Desktop 8.x/9.x/10.1,10.3, Business Objects 4.0/4.2, Qlick View, Cognos.

Business Intelligence ETL & MODELLING TOOLS: Tableau 8,x/9.x/,10.x/10.3. SAP Business Objects 4.2/4.0, Information Design Tool, Universe Design Tool, Web Intelligence, Xcelsius/Dashboard, SAP Design Studio, SAP Lumira, Crystal Reports 2011, SAP Hana Studio 1.x/2.x, SAP BI 7.3, SAP BI 7.0, Bex Query Designer, SAP BODS 4.2.

Databases Tools: SAP HANA, Hadoop, MapReduce,Oracle 11g/10g, SQL Server, DB2,Teradata, HDFS, Hive.

Environment: s: Win XP/ 2000/2003/2007 , Windows server 2008/2012. UNIX, LINUX(Redhat)

Programming Language: SAP ABAP/4,SQL, PL/SQL.

PROJECT EXPERIENCE:

Confidential, Chicago, IL

Tableau Developer/Admin

Responsibilities:

• Work with the business users in gathering the project specifications by conducting user requirements gathering sessions.
• Analysing the requirements and technical specifications by partnering with Business owners to develop the reports that conform to the enterprise standards
• Reports to Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks.
• Excellent in optimizing dashboards, performed Data validation and testing of visualizations with backend data prior to deployment.
• Created various types of charts like Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, Histograms and Dashboards inTableauDesktop to provide better data visualization.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop.
• Resolved the bugs reported by QA team in existing dashboards.
• Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle, Sybase).
• Experience in develop a working knowledge of internal Big Data applications like Hadoop, and Green plum.
• Perform administrative and support activities across a multi-environment in Tableau infrastructure including security administration, release management,
• Utilized capabilities ofTableausuch as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Managed Users on Unix/Linux and Windows systems.
• PerformedTableau Adminrelated activities likeTableauServer installation, backup, upgrades.
• UsedTableauserver to publish developed dashboards and taken care of authentication, security, scheduling and refreshments, user management, adding users and groups, content restriction to users, to content based on access level as aTableauContent Administrator.
• Worked on scheduling the extracts and setting up the permissions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Experienced in managing schedules and scheduling workbooks and activities onTableauServer
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Worked with report parameters and performed parameterized and cascading parameterized reports using SSRS in visual Studio.
• Expert in creating ad-hoc reports by using Report Builder in SSRS & webi.
• Setup security, user groups and configuration ofTableauserver 10.2 in various environments and usedTableauCMD andTableau Admintools to configure the server according to best practices.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL. Strong RDBMS fundamentals.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Environment: Tableau10.3, Hadoop, Hive, SQL Server, PL/SQL, Excel, Oracle, SAP Business Objects 4.2, WEBI, Analysis for office, SSIS, SSRS,SAP HANA, BEX Query Designer, Tableau Server, Power BI, Linux.

Confidential, CA

Sr. Tableau Developer/Admin

Responsibilities:

• Extensively involved in design and development of Tableau visualization solutions for ALR using operational dashboards and reports development, workbooks on various flavours of RDBMS like Oracle, Teradata and MS SQL Server.
• Excellent in optimizing dashboards, performed Data validation and testing of visualizations with backend data prior to deployment.
• Work with database developers to define, create, and optimize data sets for data visualizations
• Worked on creating groups, conditions, filters, ranking in reports
• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different data sources.
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tab Admin and Tab CMD commands in creating backups and restoring backups of Tableau repository.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Creating Backup scripts to take periodic backups for the content onTableauServer.
• Used Tab adminand Tab cmd commands in creating backups and restoring backups.
• Created custom applications like "Subscription app" where users input their email address to schedule the workbooks data to be delivered as a dataset on a monthly basis usingTableaurest API resources to interact with various workbooks and dashboards.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored VIZQL server, Application Server and Tableau Data server activity to track performance and system availability
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Import or export various data files (excel, web data, text file. Dbase/ETL connection etc.)Tableauto maintain the data source efficiently.
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, and SQL Server 2008.
• Found 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
• Created and updated server architecture for scheduling tasks, analyzed and resolved performance and served based issues.
• Involved in license management SLA's with Tableau support.
• Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.

Environment: Tableau Desktop 9.1,9.3, 10.x,10.1, Hadoop, Hive, MYSQL, SQL Server 2012, PL/SQL, T-SQL, SSIS, SSRS, MSOffice. SAP Business Objects 4.1, SAP HANA 1.0, Tableau Server, Linux.

Confidential

Sr.Tableau Developer/Admin

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within TableauDesktop.
• Extensive experience in usingTableaufunctionalitiesfor creating differentReports,Interactive Dashboardswith page and dashboard Prompts.
• Designed and maintain many monthly as well as ad-hock reports.
• Extracting data from multiple sources and using Data Blending technique to create dashboards.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Act as a Tableau BI end to end life cycle implementer involving in Data Analysis (Tableau Analyst), Dashboards development (Tableau Developer) and Dashboards Administration (Tableau Admin).
• As a Tableau Analyst, used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs,Measures using various graphs,charts,indicators, and gauges.
• Understanding the tool capabilities of CA Clarity PPM tool and Composite data virtualization tool.
• Majorly focused on Tableau BI tool and to bring the new requirements from Clarity system and then to end tableau dashboards and closely worked with the clarity development team and Composite team acted like an end - to - end Tableau Implementer(Tableau Analyst, Tableau Developer and Tableau Admin) throughout the project.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, Refreshing extracts, Tableau Layout designing,Tabeau Work sheet Actions, Tableau Functions, Tableau Connectors(Live and Extract), Dashboard color coding, formatting and report operations(sorting, filtering(Quick Filters, Cascading filters, context Filters),ranking, Top-N Analysis, hierarchies)
• Skilled in TableauDesktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• End to end experience in designing and deploying data visualizations using Tableau.
• DesignedanddevelopedvariousanalyticalreportsfrommultipledatasourcesbyblendingdataonasingleworksheetinTableau Desktop.
• ExtensivelyusedadvancechartvisualizationsinTableaulikeDualAxis,BoxPlots,BulletGraphs,Treemaps,BubbleCharts,WaterFallcharts,funnelchartsetc.,toassistbusinessusersinsolvingcomplexproblems.
• Expertise in Tableau Calculations, Dashboard Visualizations, Data blending
• Dashboards include different components like Column Chart, Stacked Chart, Bar Charts, Pie Chart, Label Based Menu, Combo Box, Grid, Ticker, Gauge, Maps etc.
• Created Visualizations by using SAP Lumira.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc

Environment: Tableau9.2,10.x, Tableau Server, SAP Business Objects4.1, WEBI, BODS, SAP HANA 1.0, SAP Lumira, Power BI, SSRS, SSIS.

Confidential

SAP Tableau consultant / Business Objects

Responsibilities:

• Created numerous dashboards inTableauDesktop based on the data collected by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Created adhoc reports to users inTableauby connecting various data sources. Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generatedTableauadhoc reports.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues withinTableau Server and Reports.
• Extensive experience inTableau Desktop,Tableau ServerandTableauReaderin various versions of Tableau7 and Tableau8and Tableau9.2
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Environment: SAP Business Objects 4.1, IDT, WEBI, BODS, SAP HANA 1.0, SAP BW 7.3, SAP Lumira. Tableau 8, 9.2

Confidential

Tableau consultant/ Business Objects

Responsibilities:

• Experience with the design and development ofTableauvisualization solutions
• Created extracts, published data sources toTableauserver, refreshed extract inTableauserver fromTableauDesktop
• Published Workbooks and Dashboards to theTableauserver
• Created External, internal and Context filter to improve performance of the worksheets and dashboards
• Experience in using Mark types and Mark properties in views to provide better insights into large data sets
• Experience in using dimension on Page shelf for a detailed analysis of the view.
• Created parameters and quick filters inTableau
• Created sets to display top products based on their sales
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
• Used various ETL tools to extract data intoTableauDesktop and data wrangling using SSIS in data preparation phase.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Dashboards with interactive views, trends and drill downs
• Combined visualizations into Interactive Dashboards and publish them to the web
• Created groups and users inTableauserver
• UsedTableauand Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations
• Implemented new features inTableau9.1 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 8, 9.2 SQL Server 2008 R2, Microsoft Office, T-SQL, Dashboard Designer, Crystal Reports, ODBC, CMC, SAPBO4.1,SAPBODS 4.2

Confidential

SAP Business Objects Consultant

Responsibilities:

• Actively involved in gathering requirements from end users.
• Involved inBO3.1 server patch updates and migration of content from DEV to QA and PRD environments.
• Exclusively worked on Rapid mart ETL jobs.
• Used DI objects like transforms, scripts, Data flows, Work flows in initial load and delta load mappings.
• Developed number of Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
• Involved in reports scheduling and user and group creation.
• Involved in creation of two universes for project status reports and operations dashboard.
• Exclusively worked on creating reports and AWS Operational Dashboard.
• Created prompts at universe level, resolved loops, worked with inner joints and outer joints.
• Involved in creation of dashboard ETL job usingSAPand NON-SAPsources.
• Involved in modification of existing reports according to business user's requirement.
• Created queries using QAAWS for AWS operations dashboard Created complex Dashboards using query browser.
• Worked on various components in the Dashboard.
• Exported the data from the dashboard to the webi using open doc syntax
• Created URL’s to pass the parameters from the dashboard to the webi download
• Created the Users and Groups and assign roles and security to the users.
• Involved in Daily and Monthly Status Meeting for the Inventory Management Project.
• Converted existing Universe (.unv file) to Business Layer (.unx) and pointed all the documents to Business Layer (.unx file) and tested them.
• Managed and Supported Production Systems and resolved many production issues with in SLA.

Environment: SAPBO3.1, Universe Designer,SAPBODI 3.0, SQL Server 2005, Xcelcius 2008, Microsoft Office, Tomcat 4, Xcelsius 2008, CCM, CMC, Crystal Reports.

Confidential

SAP Business Objects Developer

Responsibilities:

• Restarted servers on weekly basis and Monitored services regularly.
• Migrated universes and reports from one environment to another environment by using LCM (Life Cycle Manager).
• Improved Server Performance by changing the server parameters.
• Involved in full life cycle of Business Objects reporting Application.
• Analyze the reporting requirements with the business users and come up with the Technical specifications for Universe and BO Reports.
• Modified Universes using OLAP Data sources and Databases.
• Created Context, Alias to resolve the Loops in the universe.
• Created the Reports using Business Objects functionalities like, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements
• Created Trend Reports with Charts and drill down on Sales.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Created Hierarchies from providing drill down options for the end-users.
• Involved in resolving the previous reporting issues and trouble shooting.
• Reviews of changes handled by other team members.
• Documented all the changes made to the universe and reports for future reference.
• Created webi reports on top of BEX queries.

Environment: Windows 7, SAP BW, SAP BO 4.0, WEBI, CMC, LCM.

Confidential

SAP BW/BO Developer

Responsibilities:

• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters.
• Created WEBI reports with different functionalities like Alerts, Sections, Sorting, Break, Filters, Input Controls, Merge Dimension and Ranking.
• Experienced in developing WEBI reports using advanced features including Hyperlinks, Ranking, Input Controls and Merge Dimensions.
• Used section, break, rank, Alerts, Filters, Sorts chart features in WebI document.
• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc.
• Created and Developed BW Queries Using BEx Report Designer.
• Involved in creation of Data Sources and Info Sources, for Data extraction, transformation and loading from SAP R/3 system & Flat File to SAP BI.
• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc.
• Working on Info cube, DSO, Multiprovider and Info Object Creations.
• Configured and extracted data from the R/3 to BI System.
• Designed queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions and Conditions etc.
• Maintained Info Cube and Creation of Info Package and scheduling the data into the Data Targets.
• Identifying Data sources, Installation of Data sources and editing as per requirement.
• The Business Content Cubes Activated like Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
• Created various ad-hoc reports based on the Business Users requirements using WEBI Tool.
• Experienced in working with various types of Charts, Graphs and drill down reports.
• Scheduled Web Intelligence reports and managed the instances using CMC.
• Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
• Developed Dashboards like Sales by State and Created Dashboards by Region Wise, Geographical area Wise, Top Sales of the State and Top 5 Product wise Sales.
• Creation of Derived Tables, resolving loops, traps in universe 4.0

Environment: SAPBW, SAPBusiness Objects, Universe Designer, WEBI.