Tableau Developer
Resume:
Anupama Kurra
BI Report Developer & Data Analyst (Tableau)
adhltk@r.postjobfree.com
Summary:
More than 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 2020.2.1, 2019.2, 2018.1.2, 10, 9.1,9.0, Tableau 8/7/6.
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
Technically hands-on experience mainly with creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboard color coding, formatting, Tableau designs, proto types and Tableau mock up reports, wireframes, frame works, design documents and reporting.
Proficient in Installing, Configuring and Administration of Tableau Server. End to end experience in designing and deploying data visualizations using Tableau.
Extensive experience on building dashboards using Tableau and involved in requirements gathering/analysis, design (Mock ups, Proto types, frame works), development, testing and production roll over of reporting and Analysis projects.
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.
Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD, Snowflake, MS SQL & Teradata.
Creating complex ad-hoc Reports using data access and report design using Business Objects Web Intelligence modules, Desktop intelligence, Crystal Reports.
Efficient in tableau server administration using tsm commands, tableau server manager, server installation and maintenance.
Experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming. Design, development and coding with ORACLE, SQL Server & Teradata databases
Used Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies. Utilizing Python and Django creating graphics, XML processing, data exchange and business logic implementation.
Apt at writing Data Mapping Documents, Data Transformation Rules and Data Dictionary maintenance, Data Warehousing, Data Migration, and Interface Requirements Documents.
Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements. Versatile team player with excellent analytical and presentation skills.
Education:
Bachelor of Computer Science, JNTU, Hyderabad, INDIA
Year: 2012
Technical Skills:
BI/ Reporting Tools:
Tableau Desktop 2020/2019/2018/v10/v9/v8/v7/v6, Tableau Server v10/v9/v8/v7/v6, Tableau Online, Tableau Public, Tableau Reader, MSBI Suite, Business Objects XI R3, 4.0, Web Intelligence, Crystal Reports 2011/2013.
RDBMS:
Oracle 12c, Oracle 11g, 10g, 9i, MS SQL Server, Teradata, MS Access, Snowflake
Languages:
SQL, PL/SQL, Java, C, XML, Python
Other Tools:
TOAD, SQL Developer, MS SQL Server Management Tools, Amazon Redshift, Salesforce, Google Analytics
Operating Systems:
Windows 7, 8 & 10, Windows Server 2008/2008R2 & 2012/2012R2,2016, UNIX/LINUX
Professional Experience:
Employer: Capgemini, USA
Client: Barclays, Whippany, NJ
Role: Tableau Lead
Aug’20 – Present
Barclay’s financial has been using their legacy SAS based excel reports for credit and strategic business users. The project’s objective was to analyze, develop and convert approximately 200 excel reports into Tableau.
Environment: Tableau Desktop: 2019.2/2020.2.1, Tableau Server, Oracle, Excel, PL-SQL.
Responsibilities:
Analyzed excel based SAS report and created technical specification documents with source and target data fields mapping.
Interacting with business users in understanding the business use cases and report functionality.
Working together with SAS and Ab Initio teams to understand the data flow and workflow processes.
Building the complexity matrix for excel to tableau report conversion.
Coordinating with offshore tableau team and leading the development effort with other developers.
Acting as a liaison between client and onshore-offshore development teams.
Working with Barclay’s Tableau Admin team to understand their environment and create a development/migration plan.
Involved in development of a variety of tableau reports using tables, graphs, advanced calculations, LODs, dynamic filters and tableau actions.
Familiar with a wide variety of reports that provide essential business information like NFL team spending, Airline Rewards, Barnes & Nobles monthly packages, Airline quarterly business reports etc.
Creating presentations that demonstrate tableau architecture, tableau functionalities, rationalization capabilities etc.
Created a Microsoft Forms based business survey to capture business priorities, usage of tableau reports that provided essential input for project planning and scope.
Responsible for preparing Unit testing templates, production approval documents, release documents.
Planning, scheduling and adhering to the monthly project deliverables.
Demonstrating the new reports to business users, gathering their inputs and knowledge sharing with the offshore team.
Client: Dynata, Shelton, CT
Role: BI Developer (Tableau)
Aug’19 – Aug’20
Environment: Tableau Desktop: 2019.2/2020.2.1, Tableau Server, Snowflake, Postgres, Agile, Kanban, Cognos, Python.
Dynata is one of the world’s leading single providers of first-party data contributed by people who opt-in to member-based panels that the company manages and maintains. The company has built innovative data services and solutions around this core asset to bring the voice of the individual to the entire marketing spectrum, from market research to marketing and advertising.
Responsibilities:
Perform development activities from gathering requirements and designing solutions, through developing code, to testing and release deployment.
Created database objects for the snowflake system like tables, views and stored procedures.
Defined & followed the best practices for Tableau report development and extract scheduling.
Successfully overcame technical challenges in project: Domain change on Tableau server, Report migration from Cognos to tableau, creating unified data sources in snowflake etc.
Built tableau reports & dashboards for Panel data to show campaign analysis, reward redemptions, daily & monthly overview of recruitments, daily issues voucher summary etc.
Created shared data sources on tableau server using custom SQL scripts and data blending.
Validating and Testing of the Database data. Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
Linking data from different connections together on one dashboard and to filter data in multiple views at once.
Effectively managed Tableau server security by provisioning user groups. Setting up appropriate level of permissions with projects, reports and data sources.
Hands on experience in using tsm commands efficiently to perform server administration activities like taking server/site backups, site import/export, enabling postgres database etc.
Hands on experience in using the new tableau server manager.
Built custom tableau performance reports using postgres databases to show long running extracts that consume server resources, user/groups permissions dashboards.
Train the trainee sessions for other tableau developers within organization.
Developed training documents & material for core business users to create simple tableau reports and publishing them to the server.
Supporting day to day BAU activities such as tableau login issues, user profile creation, troubleshooting failed extracts, data issues etc.
Trained in Agile methodology. Familiar with utilizing Kanban board, scrum board in Jira.
Effectively tracking the development and production support tickets in Jira for bugs, incidents and enhancements.
Employer: Advantage Business Marketing, Rockaway, NJ
Role: Tableau Developer
July’18 – June’19
Environment: Tableau Desktop 2018.1.2, Tableau Server, Redmine, Redshift, Salesforce, Google Analytics, Google DFP, Agile, Sprints, Releases, Scrums, SQL, Excel
Responsibilities:
Tableau power user! Daily dashboard creation using all types of data sets catered to all types of audiences.
Working with team members to compile data from various external sources to create a unified view of subscriber base and activity.
Delivering a clear picture of data workflows and product performance to executive team.
Coordinating with a team of digital analysts and data developers in working towards data integrity and serving reporting needs for sales and editorial teams.
Developing dashboards with Several Key Performance Indicators (KPI’s) for sales representatives.
Creating Master dashboards that incorporate all the key metrics and sub reports.
Generating weekly reports in tableau (scheduled + Ad-hoc) and sending them through Mule to the end clients.
Review and validate the data consistency and data quality in the reports/dashboards.
Resolving data-related issues that interrupt daily workflows for both internal and external users of 25+ websites.
Enabling user security access and provisioning appropriate level of permissions.
Extensively worked on developing reports using salesforce and redshift data sources.
Building both overview and detailed visualizations in Tableau in order to find trends to aid in business decisions.
Using tableau to effectively automate the process of subscription/unsubscribe for the newsletters and magazines.
Creating an analytical view for monitoring the website traffic & site visits from google analytics snapshot data.
Developed a web metrics dashboard using google analytics to review and understand the gaps for further improvements.
Created Tableau dashboards for integrating with MOBIUS BI Platform project & personalizing them at individual buyers.
Project Name: My Parexel Portal
Client: Parexel International, Billerica, MA
Role: Tableau Analyst and Administrator
Mar’18 – Jun’18
Environment: Tableau Desktop 10, Tableau Server, JIRA, SQL developer, Toad, Oracle 11g, PL/SQL, Agile, UML, Sprints, Releases, Scrums
Description: My Parexel Project is internal web development for Parexel Pages and Tiles. It is target toward Parexel’s Customers and Employees. Users are able to personalize their personal web page once they log into My Parexel. Implementing the business intelligence module for My Parexel Portal by pulling the data from the back end for analysis using tableau desktop reporting tool. Exploring and analyzing the systems and process data using the tableau reporting tool.
Responsibilities:
Acted as both functional and business sides of the web development to interact with the various cross departmental stake holders.
Gathered requirements from business Users in various sessions, formed questions to ask business owners and stakeholders of My Parexel portal and created use cases based on that.
Responsible for the My Parexel business, functional and technical requirements gathering, use cases, user stories, BRD and FSD, mock up\wireframes of web site pages.
Liaison between the client business departments and the project management and Technical development teams to share the business report expectations knowledge and needs.
Prepared the Report Inventory, Report Mapping doc, report business requirement document (BRD) and the report Functional Specifications Document (FSD) for all the 3 tiers source, data and Analyzed the business and functional requirements of the various source systems, middle data source fields and destination reporting Tableau fields.
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, 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.
Defined and created procedures to install Tableau desktop in silent mode.
Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
Prepared proof of concept for best practices in Tableau deployment.
Project Name: R&M KPI Dashboard
Client: Optimum, New York City, NY
Role: Tableau Developer
June’17 – Dec’17
The goal of this project was to develop an executive KPI dashboard for Reliability and Maintenance group. The dashboard supported dynamic navigation capabilities with advanced slice and dice options.
Responsible for gathering the required data and designing the dashboards for the organization metrics from the scratch.
Designed dashboards turning static Excel sheets into engaging data presentations, dynamic charts and graphs, and interactive visual analytics for the initial Proof of Concept presentation to the users.
Developed a Dashboard that consisted of 10 Key Performance Indicators (KPI's) with drill down & drill up capabilities using various charts & graphs within the dashboard with efficient use of available real estate.
Created complex navigation scenarios within the dashboard based on the row & column selection inside a scorecard.
Developed different layouts/screens with multiple components at different levels of Hierarchy-Sub-function/Region/Site.
Created Drop Downs, List boxes in dashboards providing User Selection. Involved in creating many components like bar charts, stacked column charts and combination charts.
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.
Project Name: Random Trial Management System
Client: Novartis, Florham Park, NJ
Role: Tableau Developer
Sep’16 – Apr’17
Environment: Tableau Server 9, Tableau Desktop 9, Oracle 11G, Teradata and Excel
Description: The Project was intended to provide categorical breakdown analysis which includes the major reasons a trial/test may fail to be processed on a straight-through basis.
Responsibilities:
Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
Acted as a Tableau Developer, experience in extracting, and transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
Worked as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.
Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, Usage of reports and end user tableau reports training.
Published the requirement specific dashboard reports to Tableau Server for navigating the developed dashboards in web.
Sending the dashboards to users by emails with the help of admin team with subscriptions.
Given training/demos to users on Tableau Desktop for development.
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Administered user groups and scheduled instances for reports in tableau.
Administered user, user groups, and scheduled instances for reports in Tableau.
Built complex formulas in Tableau for various business calculations.
Project Name: IRT-EDW
Employer: Parexel International, Hyderabad, INDIA
Role: Tableau Developer / Validation Engineer
July’13 – April’16
Environment: Tableau 8x, Business Object XI R3, BI Info view, Crystal Reports XI, Oracle 9i/10g, SQL Developer 3.1
Description: The project scope was to convert the IRT database which collects data from various source systems into an Enterprise data Warehouse and then use the data visualization tool Tableau for reporting and dash boarding of Portfolio, Program, and Project related data. Additionally, several Business objects / Crystal reports were recreated in tableau with better enhancements.
Responsibilities:
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/Flat Files 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 sub-categories allowing business user to understand.
Projected and forecasted future trends in terms of number of trials by developing Area Maps to show details at various levels.
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.
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.
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.
Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Project Name: Clinical Trial Management System
Employer: Parexel International, Hyderabad, INDIA
Role: Associate Software Engineer / Reporting
April’12 – June’13
Environment: Microsoft SQL Server 2005\2008 data base, MS Excel, Tableau 7x, SSRS
Description: The project involved working with Business Intelligence tools (Tableau BI 7x) to extract data from Clinical Trial Management System (CTMS) to support the business in making intelligent decisions when targeting improvement efforts. The Project team is primarily responsible for analyzing, visualizing and exploring the data thus producing a standardized set of metrics, reports, analysis, and ad-hoc reporting capabilities that drive root cause analytic insights.
Responsibilities:
Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
Installation and configuration of Tableau products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.
Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
Building the customized and interactive dashboards using multiple data sources.
Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.
Acted as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking –and ordering the data and using Tableau reports for various analysis Top – N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign –off on the requirements.
Contact this candidate