SUMMARY:

• Around 8 years of extensive experience in IT with full System Analysis & Design, Development, Administration, Integration, Implementation, Performance Tuning and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online and Tableau Reader in various versions of Tableau 10, 9/8/7/6.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expertise in designing and development of various dashboards, reports utilizing various 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 business/client requirement.
• Excellent knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in Oracle and MS SQL Server.
• Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Experience in administering user, user groups, and scheduled instances for reports in Tableau.
• Excellent knowledge of Business Intelligence platforms and processes across Banking, IT and Financial industries.
• Experience in implementing Data blending, Customized queries and advanced visualizations in Tableau.
• Extensive experience in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Excellent Experience in publishing Dashboards to Tableau Server.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Have been working with various data sources such as Oracle, SQL Server, Teradata and flat file sources.
• Worked with development teams and database administration staff to enhance database and application performance.
• Experience in managing Schemas, Tablespaces and Indexes.
• Result oriented, self-motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

BI/ Reporting Tools: Tableau Desktop v9/v8/v7/v6, Tableau Server v9/v8/v7/v6, Tableau Online, Tableau Public, Tableau Reader

RDBMS: Oracle 12c, Oracle 11g, 10g, 9i, MS SQL Server, Teradata, MS Excel, MS Access.

Languages: SQL, PL/SQL, Java, C, HTML, XML, UNIX Shell Scripting.

Other Tools: Power BI Desktp, QlikView, SAP Business Objects, SSRS

Operating Systems: Windows, UNIX/LINUX, AIX, HP-UX and Sun Solaris.

PROFESSIONAL EXPERIENCE:

Confidential, Rosemont, IL

Sr. Tableau Developer/Admin

Responsibilities:

• Extensive experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau Desktop using various sources such as Oracle.
• 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.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created stories in Tableau using Story functionality.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Responsible for developing Dashboards and preparing ad-Hoc Reporting.

Environment: Tableau Desktop 9.1, 9.0, 8.1, 8.0, Tableau, Oracle 11g & 12c, MS Access.

Tableau Developer/Admin

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map by color that was broken into cities allowing business user to understand.
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 8.1 & 7, Tableau Server, MS Office Suite, Teradata.

Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Created dashboards for the clients to measure performance of their services and financial management.
• Created views and dashboards on end client's sales data. Produced powerful dashboards telling story behind the data in an easy way to understand format such as pie, bar, geo, and line charts.
• Developed Scatter Plots and Area Maps to show investment/ROI by states.
• Developed Geo/Area Maps to show Finance details by states.
• Created Shared data sources for the users.
• Installed and Configured Tableau 8.0 on multiple environments.
• Verified the runtime user permissions on the Database.
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Created calculations this includes from basic arithmetic calculations to complex Mathematic calculations.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important projects & business stakeholders throughout the project life cycle.

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server 2008.

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Analysis for the Individualized Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Defined group level security standards for Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Created extract files for improving the performance.
• Used different Mark types and Mark properties in view to provide better insights into large data sets. Created various types of charts for better visualization.
• Created Bar Charts which are complied with data sets and added trend lines and forecasting data.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, MS Office.

Business Analyst / Business Objects Developer

Responsibilities:

• Was personally involved in meetings with Business Team Managers and colleagues to define and scope list of reports, content desired in these reports, formatting and presentation standards for these reports, Time Line of Development and helped in assessment of Level of Effort with other team members.
• Worked with Data Warehouse team to identify underlying Oracle database related to business requirements.
• Documented UAT Process and worked with the Team to take Sign Offs on reports completed.
• Document reports content with respect to data sources used and data reporting on.
• Was involved in Weekly Meetings with Managers to update Status of report development.
• Was proactive in updating all concerned stakeholders with respect to completed and pending tasks.
• Worked with different team member and end user groups to better understand the system and developed usable reporting products and reported in a timely manner.
• Worked on building Web Intelligence reports. Most of these reports prompted users to pass values to queries during execution and in some cases as were used for displaying or hiding a table or section.
• For Tables and Sections used variables as filters so as to show data or hide if condition is not met.
• In detailed reports which show holdings applied breaks at Sector Level to show Sub Totals for each Sector.
• Applied Custom Number formatting for selected measures.
• Used Pre-Defined Cells such as Page Numbers, Last Refresh Date and others on specific desired reports.
• Used Documents Structure Map and Element Properties to custom name them so as to relate to which data set each table or chart is referring to. Organized this information which helped in detail documentation of report design and development process.
• Updated Document Properties such as Refresh On Open and Auto Merge Dimensions to customize these and related setting for each specific report. Ideally used Refresh On Open for Dashboard Style Reports and used Auto Merge Dimensions only if applicable.
• Created list of tables and their relationships for dimensional modeling identifying lookup tables and fact tables and scoped inventory of tables needed for creating the universe.
• Updated applicable reports which needed changes with respect to either misaligned data or new display format or additional report level filters or query changes and other related changes and overrode current report to allow users to retest updated reports.
• Was involved in initial Product Support tasks for smooth transition of these reporting products into production and supported these reports for certain period of time until both end users and production support team got familiarized with new reports under maintenance.
• From time to time when ever any report needed upgrade either to underlying database changes and or business requirements change updated such reports and followed their development life cycle.

Environment: Oracle 9i, TOAD, Business Objects XIR3 XIR2 Web Intelligence.