Karthik Reddy

Sr. Tableau Developer/ Sr. Data Analyst

Phone No: 630-***-****

Email: acypbk@r.postjobfree.com

Summary

Qualified professional with 8+ years of extensive IT Experience as a Tableau Developer, Data Analyst,

and Business Systems Analyst especially in Data Warehousing and Business Intelligence applications in

Information Security, Finance, Retail, Ecommerce, and Capital goods companies.

Extensively worked on Tableau 9.x/8.x/7.x (Desktop, Server, Mobile, and Public), BusinessObjects,

and Crystal Reports.

Expertise in BI/Data Warehousing concepts, designs, and project implementations.

Adept in business process improvement, re-engineering, change request management, review process, and

reporting escalation.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall Software Development Life

Cycle (SDLC).

Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions

(JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders,

Subject Matter Experts and the technology group.

Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business

Process Analysis, Physical and Logical data modeling.

Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from

Tableau Desktop to Tableau Servers.

Highly proficient in design and development of prototype reports/ dashboards in Tableau during the

requirement gathering phase to visualize the reports and clarify requirements.

Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters

and creating Dashboards for key Performance Indicators.

Experience in creating Data Blending by merging data from different datasets. Created visualizations using

Scatter plots, Gantt Charts, Bubbles, Geographic Map, Histograms, Bullets, Heat maps and Density

Chart.

Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table

Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card

Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Extensive experience in using Tableau (Desktop/ Server), Oracle, Teradata, Informatica Power

Center, Business Objects Enterprise, Business Objects Data Integrator, SQL Server, Oracle 11g, and

DB2.

Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in

creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.

Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data

Warehouse (EDW) and Data Marts.

Experience in designing the data conversion strategy, development of data mappings and the design of

Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source

relational to target relational.

Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored

Procedures, User-defined Functions, Views, Cursors and Triggers.

Flexible, enthusiastic and project oriented team player with excellent communication skills with

leadership abilities to develop creative solution for challenging requirement of client.

Technical skills:

BI Tools Tableau( Desktop/Server/Mobile/Public), Crystal Reports XI, XCelsius,

Business Objects, Web Intelligence

ETL Tools Informatica Power Center, SSIS, Teradata BTeq

Databases Teradata, Oracle, SQL Server, DB2, MS-Access

Database tools Teradata SQL Assistant, SQL Enterprise Manager, TOAD,

SQL Developer

Applications Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio

Scripting Languages C, C++, HTML, SQL, PL/SQL, XML, VB

Data Modeling Tools Power Designer, Erwin, ER Studio, MS Visio.

Design/Version Control UML, Rational rose

Operating Systems Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7, OS 400

Professional work experience

LifeLock, Mountain View, CA

September 2015 Till Date

Sr. Tableau Developer/ Sr. Data Analyst

LifeLock is a leading provider of proactive identity theft protection services for consumers and identity

risk and credit worthiness assessment for enterprises. The company is pioneer in identity protection, leveraging

unique data, science and patented technology and providing identity threat detection, proactive identity alerts,

and comprehensive remediation services. The project is to contribute to the Reporting and Analytics

framework by defining KPIs, creating reports and dashboards that are delivered on periodic basis (i.e., daily,

weekly, monthly, quarterly, etc.) and ad-hoc/ as-needed basis using Tableau.

Responsibilities:

Worked with Business Users from different functional Units and understand business challenges in terms of

providing reporting solutions across organization.

Worked directly with BI Architect, Administrator, DW / DBA team and Business Units to deliver solutions

Updated BI Manager with any Reporting challenges and worked towards creating solutions for the same.

Prepared project reports for management and assisted the project manager in the development of weekly and

monthly status reports, policies and procedures.

Developed and maintained high level overview of the project and design flows using MS Visio.

Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata

that can be used for development of various Tableau reports/ dashboards.

Designed, developed and published customized interactive reports and dashboards using Tableau.

Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing

dashboards and worksheets in Tableau.

Created Groups and Custom Hierarchies to meet the Business requirement in Tableau.

Effectively used data blending feature in tableau and defined best practices for Tableau report development.

Administered user, user groups, and scheduled instances for reports in Tableau.

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 according to

deliverable specifications.

Consistently attended meetings with the Client subject matter experts to acquire functional business

requirements in order to build SQL queries that would be used in dashboards to satisfy the businesss needs.

Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT)

for AP Reporting.

Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.

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.

Executed and tested required queries and reports before publishing.

Worked with Tableau administrator in managing Production, Test and Development environments including

installation of patches, security administration and access controls in Tableau.

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to

validate static and dynamic data for data validation.

Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or

system change to ensure that the published dashboards are displaying accurate and up-to-date information.

Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders

and business groups.

Provided support for Tableau developed objects and understand tool administration.

Environment: Tableau 9.x (Desktop./Sever), SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW

Query Designer, Analyzer, Teradata, Oracle, SQL Server, Teradata SQL Assistant, SQL Server

Management Studio, Toad, SQL, Microsoft Office Suite ( Word, Excel, PowerPoint, Visio).

First American Financials, Irvine, CA

Jan 2014 Aug 2015

Sr. Tableau Developer/ Sr. Data Analyst

First American Financial Corporation provides financial services through its Title Insurance and

Services segment and its Specialty Insurance segment. The Companys core business lines include title

insurance and closing/settlement services; property data and automated title plant records and images; home

warranty products; property and casualty insurance; and banking, trust and investment advisory services. The

project is to implement BI reporting solutions by creating reports, dashboards, and scorecards in Tableau.

Responsibilities:

Involved in defining the whole project life cycle, following RUP methodology. Developed a vision plan that

defined the primary goals and objectives of the project. Analyze business requirements and segregated them

into high level and low level

Actively involved in gathering requirements from end users, involved in modifying various technical &

functional specifications.

Assisted Project Manager in developing design and specification, according to the requirement and information

gathered during JAD sessions and other forms of information gathering methods.

Implemented report development methodology for operational analytics group.

Provided business intelligence guidance to business operation analyst groups.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt

charts using show me functionality.

Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies.

Creating data blending while designing a dashboard reading data from different datasets.

Extensively worked on Tableau dashboard and SQL query optimizations and response monitoring.

Used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble

Charts, Motion Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex

problems.

Worked with Advance analysis Actions, Drill-Down Analysis, Calculations, Parameters, Background images,

Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report

and Dashboard using KPIs

Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.

Installed Tableau Server 8.1 in Dev, QA, and Production environments.

Deployment of Tableau reports, creating project folders and assigning user/group permissions.

Worked creating Aggregations, Calculated fields, Table calculations, Totals, percentages using Key

Performance Measures (KPI) and Measure.

Utilized advance features of Tableau software like to link data from different connections together on one

dashboard and to filter data in multiple views at once.

Created actions in worksheets and dashboards for interactivity and to compare data against different views.

Created and managed tableau server groups and permissions.

Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web

applications like SharePoint.

Designed and developed aggregate data extracts for larger tables and configured schedulers on the server to

refresh the data.

Restricted data for particular users using Row level security and User filters.

Consulting with business partners on reporting requirements and deciding business strategies for slice and dice

analysis.

Responsible to facilitate load testing and benchmarking the developed product with the set performance

standards.

Conduct demonstration for business users and interacted with end users.

Actively participated in clarification meeting with the Clients.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.x/7.x( Desktop/ Server), SQL developer, SQL 2008, Oracle 10g, DB2,

Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office Suite ( Word, Excel, PowerPoint).

BJ's Wholesale Club, Westborough, MA

Nov 2012 December 2013

Data Analyst/Tableau Developer

BJs Wholesale Club, Inc. is a leading operator of membership warehouse clubs in the Eastern

United States. The Company currently operates 200 Clubs in 15 states from Maine to Florida and employs

more than 25,000 Team Members. The project is to implement Business Intelligence Application to study the

companys performance across various metrics by designing and creating Reports / Dashboards on customer,

supplier, Sales, and operations data using Tableau Reporting Services.

Responsibilities:

Involved in creating dashboards by extracting data from different sources.

Created dashboard using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating calculated fields, mapping and hierarchies.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different sources.

Involved in creating a dual-axes bar chart with multiple measures.

Involved in extraction, transformation and loading of data directly from different source systems like flat files,

Excel, Oracle and SQL Server.

Working on generating various dashboards in Tableau Server using different data sources such as Teradata,

Oracle, and MS Excel.

Extensively used data blending in Tableau.

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Server in all the environments.

Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

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.

Created report schedules, data connections, projects, groups in Tableau server.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau

repository.

Involved in creating Stored Procedures, tables, and views for applications.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and

appropriate User defined functions.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server

related issues.

Environment: Tableau 8.x/7.x (Desktop, Server, Reader), Oracle, Teradata, JavaScript API, SQL, Teradata

SQL Assistant, Toad, UNIX, PUTTY, Microsoft Office Suite (Word, Excel, PowerPoint).

Reputation Changer, Philadelphia, PA

April 2011 Oct 2012

Data Analyst/ Business Systems Analyst

Reputation Changer is an American online reputation and brand management company that provides

internet search management by creating web articles about its clients in order to have them overtake negative

news, and Wikipedia profile management. The project is to analyze existing BI reports in Business Objects for

various requirements and recreate the same using Tableau Reporting Solutions.

Responsibilities

Actively involved in gathering requirements from end users, involved in modifying various technical &

functional specifications.

Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better

understanding of the Business Processes.

Developed and maintained data dictionary to create metadata reports for technical and business purpose.

Created action plans to track identified open issues and action items related to the project.

Designed complex risk reports, Score Cards, and Dash Boards using BusinessObjects.

Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories,

filtering the data etc.

Designed filters, power prompts, and complex financial calculations for various analytical reports.

Analyzed various reports, dashboards, scorecards in BusinessObjects and created the same using Tableau

desktop server.

Completed training in Tableau Desktop and Server.

Designed and Developed various analytical reports from multiple data sources by blending data on a single

worksheet in Tableau Desktop

Utilized advance features of Tableau software like to link data from different connections together on one

dashboard and to filter data in multiple views at once.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports

and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Make use of filters and making them local and global accordingly.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the

server can view the data.

Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Design and development of various reports and dashboards that can be easily accessible through Tableau App

in Ipads, iPhones, and other smart mobile phones.

Responsible to facilitate load testing and benchmarking the developed product with the set performance

standards.

Actively participated in clarification meeting with the Clients.

Created Test Cases and documented the Test Results.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and

handled the performance issues effectively.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 7.x ( Desktop/Server), BusinessObjects, Web Intelligence, Teradata, Teradata SQL

Assistant, Teradata Administrator, SQL, PL/SQL, MS Project, HP Open View,

CNH Industrial, Racine-WI

Jan 2010 March 2011

Data Analyst/ Business Systems Analyst

CNH Industrial is an Italian company which through its various businesses designs, produces, and

sells agricultural and construction equipment, trucks, commercial vehicles, buses, and special vehicles

(IVECO), in addition to power trains for industrial and marine applications (FPT Industrial). It is present in all

major markets worldwide. CNH Industrial is focused on expanding its market through joint ventures. The IT

project at CNH is emphasized on various report related issues and fixes. Design of Business Objects that is

used for generating various reports, dashboards related to customers, suppliers.

Responsibilities:

Involved in Full life cycle design and development of Business Objects Enterprise Applications

Involved in gathering the requirements from Business Managers for reports development

Designed and developed Universes as per report requirements of Business analysis

Identified the Metrics and sub metrics, Key performance indicators (KPIs) for Dashboard development

Worked on multiple data providers to develop the dashboards coming from different sources

Involved in bug fixing for invalid data flows, Work flows and projects, testing of Stored Procedures and

Functions, Testing of Data Integrator jobs, and the Target Data Worked with Contexts and Aliases to resolve

the Loops in Universes

Managed Users, Groups and their access privileges on the documents

Extensively worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison,

Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, and Pivot

Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by

contexts

Creating various UDFs in the database for data retrieval in complex reports

Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW

Designed Stored Procedures while generating the reports and tested them against Oracle Database

Identified critical areas of business risk and modified business processes to reduce risk by using the Risk-

Management Process

Identifying & Managing risks, Resource analysis, Cost analysis, Post project analysis & coordination among

cross-functional teams & follow-up with clients for settlement of project based issues

Design, develop, test and enhance the Informatica mappings with changes in the business requirements.

Reverse engineer business requirements from already developed mappings.

Data Profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve

quality of data and help business to understand the converted data better to come up with accurate business

rules.

Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web

services using DB2

Used Data Integrator Administrator for scheduling the jobs and validation of the jobs before executing them

Environment: Business Objects Xi3.1, Xi r2, Crystal XCelsius 2008, QAAWS,Designer, Desktop

Intelligence, Web Intelligence, Oracle 9i, DB2, Informatica Power Center, SQL Server 2005, Windows XP

CSG INTERNATIONAL, Bangalore, India

July 2008 Dec2009

Business Objects (BOXI) Developer

CSG International is a leading international financial services organization. the company provide

protection and wealth accumulation products and services to the individual and the corporate customer around

the world. The project is to maintain Business Objects Infrastructure hosting variety of BI capabilities for

variety of Business units.

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to

analyze business requirements and outline the proposed solution.

Build the new universes as per the user requirements by identifying the required tables from Data mart and by

defining the universe connections.

Used Derived tables to create the universe for best performance, and use context and alias tables to solve the

loops in Universe.

Created complex reports stating revenue generation per year using cascading and user objects like

measure objects by using @aggregate_aware function to create the summarized reports.

Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics.

Created parameter driven reports according to user requirements using Web I.

Developed the Quarterly Quality Metrics report for end users to view Quarter wise using Drill Down feature.

Generated Reports using the Universe as the main Data provider and also using the personal data files provided

by the users.

Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and

headcount.

Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports

according user requirements.

Implemented Security Features of BusinessObjects like row level, object level and report level to make the

data secure.

Provided the security access management by creating users/groups and folders.

Implemented the ETL process and business logic by using PL/SQL.

Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled,

debugged and tested. Extensively used stages available to redesign Data stage jobs for performing the required

integration.

Developed universe user documentation guide for the end users reference.

Adopt best in class practices and standards for development, support, quality control and documentation.

Provided training for end users for generating their own report including complicated reports.

Environment: BusinessObjects XIR2/6.5.1, Crystal Reports XIR2, Designer, Desktop Intelligence, Web

Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP.

Contact this candidate