SUMMARY

• 7 + years of total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/ Data Mart Design, BI Solutions, OLAP, Client/Server and Web applications on Window and Unix platforms.
• 3+ years of experience in Tableau Desktop, Tableau Server, Tableau Reader.
• Hands on experience in data visualization tools like Tableau and Lumira.
• Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• End to end experience in designing and deploying data visualizations using Tableau.
• Working knowledge in gathering external data to Tableau from different sources like Oracle, MySQL, AWS Redshift, SQL Server & flat flies etc., for data visualization.
• Expert in SAP Business Objects 4.1/4.0/XI3.1/XIR2/6.X Universe, Web Intelligence
• Hands on experience in SAP Business Objects 4.1 with HANA backend
• Hands on experience in Dashboards using Design Studio
• Implemented mail functionality to outlook from design studio using java script
• Worked on a migration project from BO XI 3.1 to SAP BO 4.0
• Specialized in creating complex query reports using BEx query, Info cube, Oracle, SQL Server, SAP HANA, MS Access, local files, and various RDBMS.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Professional in writing complex Formulas, Sub Reports, Summary Reports.
• Worked extensively with Advance analysis like Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
• Was actively involved in the Server migration and the Fresh Tableau Server Installation process.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Integrated Tableau with SAS Data source.
• Administered user, user groups, and scheduled instances for reports in Tableau by controlling the access of resources to intended user.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Very good at building custom SQL queries comprising of various Aggregate functions and excellent in performance tuning.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experienced in Managing Data Model and Improving Performance using the Master Data Services for SQL and Add - in in Excel.
• Used Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities
• Have good understanding of Tableau architecture, design, development and end user experience
• Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Extensively involved in conducting knowledge transfer sessions and training users on accessing Tableau software/tools.
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
• Expert in creating OLAP connection to SAP-BW with BICS client.
• Expert in connecting to BEx queries and using info objects in WebI reports.
• Very good hands-on experience in writing complex SQL scripts/ queries to perform End-to-End
• Experience in requirement gathering and designing windows and web application solution and Design Patterns.
• Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
• Key person for Unit Testing, User Acceptance Testing (UAT)/ Power users on using the new tools and processes.
• Ability to handle multiple tasks and work independently as well as in a team.
• Expertise in using Version controllers like SVP and Git.

TECHNICAL SKILLS

BI Tools: Tableau Suite of Tools 10.1/9.x/8.x which includes Desktop, Server, online and PublicSAP Business Objects 4.x/3.x and Microsoft Power BI.

Programming: SAS, R, SQL, PL/SQL and Unix.

Databases: AWS Redshift, Oracle 11g/10g/9i, MS Sql Server 2008/2005, MS Access, DB2, Teradata, SAP HANA, Cloudera.

Package: MS Word, MS Excel, MS Power point, MS Project.

Environment: Windows, Unix, Teradata.

Performance Tool: Interworks Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Working with a team of Data Analysts, Business Analysts and Process Managers designed, developed and implemented visualizations for Auto Loan finance business area. Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Created Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks.
• Developed reports using custom SQL queries and created. tdsx, .tde and .tds files.
• Created reports and filtered them by various measures and dimensions.
• Joined multiple data sources from Teradata SQL, AWS Redshift and MS Excel, created hierarchical dimensions, calculated measures and filters to create Tableau Server dashboards for customer complaints, call center operations, web analytics and paperless metrics.
• Developed workbooks with various functionalities and deployed them on Tableau server.
• Created nice visualizations like donut charts, Gantt charts, Bullet charts and funnel chart.
• Created views using various axes like Individual Axis, Dual Axis and Blended Axis.
• Used Trend Lines, Reference Lines, box plots and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Wrote custom SQL quires AWS Redshift and created tableau data sources.
• Performed Data validation and testing of visualizations with backend data prior to deployment.
• Created data extracts in tableau for better performance.
• Collected tableau dashboard performance statistics using Inter works tool.
• Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
• Created Tableau dashboards on desktop and published to tableau server.
• Scheduled the published dashboards from Tableau Server on daily basis.
• Involved in performance tuning of slowly running SQL queries.
• Write SQL queries for data validation and data integration where necessary.
• Created incremental refreshes for data sources on Tableau server.
• Work closely with DBA's and ETL teams to meet reporting requirements and improve performance.
• Evaluate live vs extracts connections based on data size and performance requirements.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Desktop 10.1 & Server, Teradata, AWS Redshift, MS Office, MS Excel, Tableau Interworks, SQL Workbench, JIRA and GIT.

Confidential - Philadelphia, PA

Tableau Consultant/ Site Admin

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps per deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements 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.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau.
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1
• 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.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created
• Hyperlinks for each of the Metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Tableau Server 8.1/9.3, Tableau Desktop 8.1/9.3, Windows Server Standard R2,, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Responsible for Designing the Reports as per client Requirements and translated them to technical specifications.
• Involved in the migration of content from old Tableau server to new Server.
• Worked with server engineers to ensure server process configuration options and performance tuning.
• Created Tableau scorecards, dashboards using Various plots (stack bars, bar graphs, scatter plots)
• Demonstrating key information for decision making.
• Created conditional and context filters to filter the data on dashboard. Responsible for Creating Parameters for desired functionality.
• Involved in data profiling, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.
• Worked extensively with Advance Analysis Actions, Calculated fields, Sets, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.
• Worked on Facts, Attributes, and Data blending as well as newly introduced Cross data base joins.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created demos in Tableau Desktop and published onto Tableau Test Server.
• Extensively Worked on Level of detailed expressions to breakout a measure by another measure.
• Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
• Hands on experience on extract, manipulate and built complex formulas in Tableau for various business calculations.
• Deployed Tableau Dashboards and worksheets in clustered environment using Google Analytics.
• Documented the whole process of working with Tableau Desktop, and evaluating Business Requirements.
• Involved in resolving reporting issues and design issues throughout the reporting life cycle.
• Worked with client and team members to understand and clarify visualization requirements

Environment: Tableau Desktop 8.3, Tableau server, SQL developer, SQL Server, Oracle11g/12c, Hadoop, HiveNoSQL, Linux/Unix, HTML/CSS, JavaScript, Microsoft Excel 2012, Microsoft office suite, SAS, JIRA and GIT.

Confidential, Vienna, VA

BI Consultant

Responsibilities:

• Analyses user requirements and translated them into front end Tableau visualizations and reporting solutions.
• Designed and developed dashboards with parameters, calculated fields, groups and hierarchies
• Managed and maintained Tableau Server, Desktop, users and user groups.
• Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Gathered requirements and documented them
• Created Tableau data visualizations as per user requirements
• Used data blending feature to combine data from multiple data sources
• Tested BW roles and authorizations in Tableau
• Provided user training on adhoc reporting through Tableau
• Scheduled Tableau data extracts to store data in tableau server
• Improved dashboard performance by scheduling Tableau data extracts
• Created book marks functionality for users to save their current version of selections
• Used action filters to call other dashboards
• Created and published BW connection in Tableau site
• Designed a security model to provide rights access at right level

Environment: Tableau 8.2, SAP Web Intelligence, SAP BW 8.3

Confidential

SAP BO Developer

Responsibilities:

• Created universes to develop the webi reports based on the reporting requirements.
• Actively involved in requirements discussion
• Expert in understanding the complete Architecture (Database, Data modeling & Administration)
• Expert in upgrading project from BO 3.1 to BI 4.0
• Extensively used import wizard for promoting code to different environments.
• Designed Universes with Oracle DB and SQL Server DB and published to repository to use in WEBI and Dash board design.
• Created both relational connections and System DSN for Database systems.
• Created universe by connecting OLAP SAP BW and used in WebI and dashboard design reports.
• Created universes by using the joins, aliases, cardinalities etc.
• Defined Custom Hierarchies in Universe as per the business rule for the reports to be viewed at selected level.
• Developed Complex Reports such as Sub Reports, Drill Down and Drill Up using Webi and Dashboard designer.
• Created new Folders, Users and Groups in CMC.
• Created Custom Calendars and Scheduled Reports based on Calendars.
• Provided Security to Folders, Universes and Reports per the User rights.
• Provided knowledge transfer to other team members.
• Developed and foster a collaborative working relationship with clients.

Environment: SAP Business Objects Enterprise XI3.1 (Designer, WEBI), SQL Server 2008, Oracle 10g

Confidential

SQL Developer

Responsibilities:

• Managed database objects like stored procedures, views, tables etc.
• Optimized queries that were taking long time to display desired result set.
• Created groups, roles, users and assigning access privileges to users.
• Created new stored procedures and modifying existing ones as per business requirements.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
• Performed data analysis to generate various trend reports.
• Performed identification, analysis and resolved report defects within time scope and established development guidelines.

Environment: SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS)Windows XP