SUMMARY:

• 8+ years of experience in Data warehousing and Business Intelligence technologies along with 5 years of data visualization using Tableau Desktop.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Tableau tools include Tableau Desktop versions 7/8.1/9/10.1, Tableau Reader, Tableau Public, and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Strong knowledge of Software Development Life Cycle (SDLC).
• Good understanding and background in financial services, media, and telecom industry.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Excellent communication skills in both written and oral along with ability to tell a story through data.
• Ability to interact professionally with a diverse group including executives and managers.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop 7/8.1,9,10.1 Tableau Public 8.1,9,10.1, Tableau Reader 8.1,9,10.1 Tableau Server 8.1,9,10.1 Cognos 8.4/10.1

Programming: SQL, UNIX Shell

Utilities: MS Office Suite, MS SharePoint, MS Project

Databases: Oracle 10g/11i, Oracle SQL Server 2008 R2, MS Access, MS Excel

Platforms: Windows 7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX, Linux, Ubuntu

Networking: TCP/IP, LAN/WAN Technologies

EXPERIENCE:

Confidential, CA

TABLEAU DEVELOPER

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 showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to Mortgage Loan by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Implemented code in Python to retrieve and manipulate data.
• Blended data from multiple databases into one report by selecting primary keys 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.
• 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 9 & 10.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Sr Tableau Developer

Responsibilities:

• Experience using Tableau tool to handle the various data feeds from the different data sources using Tableau Desktop tool.
• 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
• Performing Business analyst tasks like creating the project plan with all the required presentation
• Responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of one or more user areas.
• Implementation of incremental data extracts updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management, scheduling.
• Worked with other team members and involved in development of the Hive/Impala scripts for extraction, transformation and loading of data.
• Install and configure the Tableau Server application. Implemented Cube Security. Enhanced performance of the Power Cubes.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines etc., in many tableau reports.
• Connected Tableau Desktop with Teradata to extract data from stored procedures and custom SQL to plan refresh timings and publish to tableau server.
• Proactively communicate Tableau server issues and maintenance schedules.
• Interacting with business stakeholders to understand their decision - making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Participated in Transition management assist users and educate them on tableau ad-hoc reports.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, sequence buffer length.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Involved in loading data from Hive and imported to R for data analysis and visualization.
• Created dashboards using past present and future statistical data to analyze the sales with respect to geographies.

Environment: Tableau Desktop 9.2, Tableau server, Teradata server, Teradata14, SQL Server Management Studio, Oracle 10g, MS Access, R studio, Informatica 9.x

Sr Tableau Developer

Responsibilities:

• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes.
• Created reconsolidation reports for conversion purpose using various joins.
• Involved in reviewing business requirements and analyzing data sources form Excel/MySQL, Redshift 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 showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.
• Optimized various dashboards to create excellent visualizations.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MySQL, Oracle, SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys 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.
• 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.
• Rewrote various business process and tested result in MS Excel using various functions and sub query with not exists.
• Involved in updating functional requirement document after development and created documentation for deployment team.
• Experience working with advanced Tableau features like LOD expressions.

Environment: Windows, Tableau Desktop (Version 8.2 - Version 8), Tableau Server (Version8.2 - Version 8), SAS, MS Office Suite, Oracle 10g, SQL Server, MS Excel, Redshift, ERWIN, MS Excel.

Tableau Developer

Responsibilities:

• Involved in report and dashboard requirement gathering from the end users to define accurate requirements.
• Good understanding of the customer business and implementing the same over to the reporting needs.
• Implemented new universes using IDT and modified existing ones according to requirements and performed checks, resolving traps, using contexts, aggregate awareness, hierarchies and derived tables.
• Performed report/universe optimizations in greatly reducing the run time of reports.
• Created complex Webi reports with multiple queries, custom sql, complex functions, merge dimensions, drill, down/up/across/through, complex filters etc.
• Performed Admin tasks such as monitoring DB services, BO Server running with optimal Performa monitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches etc.
• Migrated reports/universes from Dev to QA to Prod.
• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.
• Created users, user groups and maintained user access rights in Tableau.
• Created Architecture Design documents and Technical Specifications Documents.
• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh etc.
• Implemented Tableau Mobile across several lines of businesses.
• Provided technical support to all team members during project execution.
• Performed reports/dashboards performance optimization.
• Involved in User Training of Tableau dashboards.
• Created intuitive ways in Dashboards to implement multi - level drill through s, Ranking, Dual Axis, Geo Coded Mapped views, Histograms etc.
• Helped in testing and impact assessment on dashboards with changes to the data warehouse.
• Created test documents that help in validating reports and dashboards in QA.

Environment: Tableau 7.2 Server and Desktop, Oracle 10g and 11g, SQL Server 2012, Teradata, SQL/PLSQL, Netezza, Windows Server/professional, VISIO.

TABLEAU DEVELOPER

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active

DW/BI DEVELOPER

Responsibilities:

• Analyzed the specifications provided by the clients and developed specification documents for reports as per client requirements.
• Involved in designing and creating various models and publishing packages in Framework Manager.
• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Created complex, multipage reports using most of the Cognos functionality (such as Prompts, Conditional Formatting, and Conditional Rendering).
• Created dashboard from scratch that included drill-through, filters, calculations, graphs, crosstabs, lists, conditional blocks, and master detail relationship.
• Performed optimization on the existing reports to decrease the run time to meet the real-time requirements and made changes to the existing reports for good look and feel for the users.
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Created cubes in Transformer using Framework Manager IQD’s, packages and report studio reports as a source.
• Experience working on Cognos Administration with expertise in installation, configuration, Troubleshooting and setting up security for Cognos 8.4 environments.
• Responsible for creating user groups and roles to manage security in Cognos Connection and access rights of the reports for the end users.
• Creates, modifies and manages the SQL server jobs.
• Used different MSSQL commands to pull customers data for thorough analysis of their purchase pattern, like select statement, count statement, select distinct, top, order by statement, inner join, outer join.
• Involved in administration tasks like scheduling - single report scheduling.
• Resolved the performance issues of the reports.
• Created test cases for unit testing of the reports.
• Deployed packages and reports from development to QA and then Production servers.
• Trained the end users to effectively use the reporting tool (Query Studio) to build and customize their ad-hoc reports.

Environment: Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Cognos Access Manger, Oracle 10g,MS Office

Confidential

BI DEVELOPER

Responsibilities:

• Actively involved in business meetings with the customers for understanding the as-is process flow and new business requirements or enhancement activities.
• Prepared the technical and functional specification documents for report development, coding and testing.
• Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
• Created standard filters, prompts, calculations and conditions in Catalog.
• Created various impromptu reports (List, Cross-Tab and Drill through) and power play Reports.
• Defined join conditions, table aliases and views for the user requirement.
• Updated impromptu catalog by adding tables and creating new joins.
• Created various report studio reports using calculations, filters, prompts conditional formatting and drill through.
• Created IQDs that are used as data sources in PowerPlay transformer to generate transformer models.
• Converted char fields to varchar fields and date functions.
• Migrated reports from Cognos EP Series 7.3 to Cognos 8 Environment.
• Published impromptu reports and PowerPlay reports to upfront and scheduled reports to run periodically.
• Validated report results with the source data and authorized the reports to production environment.
• Granting access to different users for the system.
• Provided technical assistance, training and mentoring to business users.
• Involved in Data Auditing process using SQL to validate the masked data.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality.
• Installing applications like Impromptu user 7.3 & PowerPlay user 7.3.

Environment: Cognos 8.0 BI, Cognos Powerplay7.3, Transformer 7.3, Cognos Report Net 1.1, PowerPlay Enterprise Server 7.3, Upfront 7.3, Impromptu 7.3, Access Manager 7.3, TOAD 7.2