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.
• 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.
• 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.
• 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