Aditya Reddy

ac0xl3@r.postjobfree.com

+1-872-***-****

Sr. Tableau BI Developer

SUMMARY

Qualified professional with 8+ years of extensive IT Experience especially in Data Warehousing and Business Intelligence applications in Entertainment, Pharmaceutical, HealthCare, Manufacturing, Financial and Technology Solutions industries.

4+ years of extensive experience as Tableau Developer on Tableau 10.x/9.x/8.x/7.x product suite (Desktop, Server, Public, Reader, Mobile).

Experience in Business Intelligence, Database Modeling, Data Warehousing concepts, OLAP, ETL tools and reports generation.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall Software Development Life Cycle (SDLC).

Good Experience in conducting JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.

Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators.

Extensive experience in using Data Blending for merging data from different datasets and creating different visualizations like Scatter plots, Gantt Charts, Bubbles, Geographic Map, Histograms, Bullets, Heat maps and Density Chart.

Expert in creating Calculations (LODs, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Hands on experience publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers, Web pages.

Extensively used Tableau, Crystal Reports, Business Objects, SSRS, Informatica Power Center, SSIS, SQL Server, Oracle, Teradata and Hadoop Hive.

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.

Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.

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.

Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.

Successful as a team player to work in conjunction with other DBA's, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with various Test suites.

Ability to manage multiple and varied tasks with enthusiasm, deal with tough and demanding work priorities, prioritize workload with attention to details

TECHNICAL SKILLS:

BI Tools

Tableau (Desktop/Server/Reader/Public/Mobile), Crystal Reports XI, Business Objects, SSRS

ETL Tools

Informatica, Alteryx, SSIS

Databases

SQL Server, Oracle, DB2, Teradata, Netezza.

Database tools

SQL Developer, TOAD, Teradata SQL Assistant, Vertica.

Applications

Microsoft Office Suite (Word, Excel, Visio, PowerPoint)

Scripting Languages

HTML, SQL, PL/SQL, XML, VB, Java API

Data Modeling Tools

Power Designer, Erwin, ER Studio, MS Visio.

Operating Systems

Windows Server 2003/2008, Windows XP/7, iOS, Unix

PROFESSIONAL WORK EXPERIENCE

Anixter Inc., Glenwood, IL Oct 2015- Present

Sr. Tableau Developer/ Sr. Data Analyst

Anixter is a leading global supplier of communications and security products and electrical and electronic wire and cable. Anixter helps its customers specify solutions and make informed purchasing decisions around technologies, applications and relevant standards. The project is to implement Business Intelligence reporting solutions by creating reports, dashboards, and scorecards in Tableau.

Responsibilities

Liaison for project managers, managers, directors, and stakeholders.

Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.

Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).

Designed and constructed real time dashboards for sales and marketing teams using Tableau.

Connected to different data sources like Hadoop Hive, Oracle and SQL serever.

Built the DW environment using the Tableau and Hadoop Hive tables with Terabytes of data.

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.

Extensively 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 extensively 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 KPI’s

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

Utilized various Tableau functions like LOD, WINDOWS_SUM, WINDOWS_AVG, conditional functions (IF, Nested IF, CASE, etc.), RANK, Table calculations for various measures/calculated fields.

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.

Publishes reports/dashboards on Tableau server & embedded Tableau views in other web applications like SharePoint, Intranet pages.

Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.

Used Java Script API to customize the views, selects, filters, date and time.

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

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Worked on Different databases like Hadoop Hive, SQL, Oracle etc. Created complex views to fulfill reporting requirements.

Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 9.x/8.x (Desktop/Server), ERwin, Oracle, SQL Server, SSIS, SQL Developer, Toad, Confluence, Java Script API, Hadoop Hive, Microsoft Office Suite (Word, Excel, PowerPoint, Visio)

McKesson - Charlotte, NC Aug 2014 – Sep 2015

Sr. Tableau Developer/ Sr. Data Analyst

McKesson Pharmaceutical Distribution supplies branded generic and over-the-counter pharmaceuticals to more than 40,000 customers in three primary segments: retail chains, independent retail pharmacies and institutional providers such as hospitals, health systems, integrated delivery networks and long-term care providers. McKesson works with its customers on solutions - including supply management technology, world-class marketing programs, managed care and repackaging products and services - that help them meet their business and quality goals. The project is to implement Business Intelligence reporting solutions by creating reports, dashboards, and scorecards in Tableau.

Responsibilities:

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

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

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

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.

Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation.

Prepared/ blended data from multiple sources to TDE files using Alteryx.

Responsible for creating metrics, filters, calculated fields, parameters using Tableau Desktop.

Used geographic view which clearly gives the performance of a particular state.

Developed customized calculations when required.

Created various actions in database like action filters, URL actions to navigate from main dashboard to detail reports and to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.

Built the business intelligence framework and executive dashboard that enabled administrative teams to conduct quarterly, monthly, and yearly trend analysis and to tract existing customer sales.

Developed tableau reports/dashboards using bar graphs, scattered plots, geographical maps, pie charts, heat maps, gantt charts etc. and extensively used calculated fields, Quick Table Calculations, Parameters, Sets, bins etc.

Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server.

Created Custom complex SQL Queries to generate the data from data base and use it for making Innovate and Powerful Dashboards for easy Data Visualization and Forecasting in Tableau

Used effective filers (Quick filter, Action Filters, Context Filter), parameters, sets, appropriate Formatting Headers, Worksheets with different Visualization, Color Coding to handle Views more efficiently.

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 tableau security and published to Tableau Server based on Sector Level & Market Level.

Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.

Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Actively tracked schedule and had clear communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page.

Environment: Tableau (Desktop/ Server), Oracle, MS SQL Server, Alteryx, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Genentech - South San Francisco, CA Oct 2013 - July 2014

Tableau Developer/ Data Analyst

Genentech is one of the world’s oldest and most successful biotechnology companies. The firm has a number of successful cancer therapies based on its antibody technologies. The project is aimed to integrate data from multiple sources into data mart and develop reports and dashboards on the same using Tableau.

Responsibilities:

Gather and analyze the business requirements and then translate them technical specifications.

Building and publishing customized interactive reports and dashboards reports in the Tableau Server.

Effectively used Data blending, groups, combine fields, Dual Axis, aggregated fields and spotlighting to compare and analyze data in different perspectives.

Created parameters, quick filters, context filters and Sets to display top result set which changes dynamically.

Created sets, joins, hierarchies, filters, global filters, table calculations, calculated measures and parameters.

Developed various views in Tableau by different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.

Developed various dashboards, work books and data views depending upon the business requirements and published in the tableau server.

Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Defined best practices for Tableau report development. Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.

Published the developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.

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

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

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

Developed Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports and enabled ad-hoc reporting with report builder.

Executed and tested required queries and reports before publishing.

Creating test case for each data view in the Tableau.

Environment: Tableau 8.x (Desktop/Server), ERwin, SQL Server, Oracle, DB2, SQL Developer, DataStudio, T-SQL, SQL Server Management Studio, Microsoft Office Suite (Word, Excel, PowerPoint).

Oakley, Foothill Ranch, CA June 2012 – Sep 2013

Tableau Developer/ Business Intelligence Analyst

Oakley, Inc. designs, develops and manufactures sports performance equipment and lifestyle pieces including sunglasses, sports visors, ski/snowboard goggles, watches, apparel, backpacks, shoes, optical frames, and other accessories. The Company holds currently holds more than 600 patents for eyewear, materials, and performance gear. The project is to recreate BI reports for Marketing, Operations, Commercial and Finance teams in Tableau and sunset Business Objects.

Responsibilities:

Requirement gathering for various users, interviewing them, and satisfying their exact needs.

Conduct Design discussions and meetings to come out with the appropriate reporting Data Marts.

Built templates and dashboards for customized views of the data specific to each group and line of business

Used Oracle warehouse builder tool to enact some ETL processes required as per data source requirements for Tableau reporting

Involved in creating data models and building data marts.

Analysed business process workflows and assisted in the development of ETL procedures for moving data from EDW base tables to reporting data marts.

Analysed existing Business Objects Universes and reports to understand business needs and develop prototypes in Tableau.

Worked with Tableau administrator in creating users, users groups, projects, and the appropriate permission sets for Tableau server logon’s and security checks.

Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts

Used calculated fields, filters, Parameters, Groups, Sets, Bins, and complex financial calculations for various analytical reports.

Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.

Tested reports for query optimization and performance before posting them to the repository.

Analysed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL.

Provided on-going production support for End Users in the final stages of the project.

Trained the users to use reporting interface and to create ad-hoc reports based on their needs using Tableau.

Environment: Tableau (Desktop/ Server) 8.x/7.x, Crystal Reports, Power Designer, Oracle 11i, SQL Developer, Netezza, Microsoft Office Suite (Word, Excel, PowerPoint).

TIAA-CREF Financial Services – Charlotte, NC Jan 2011 - May 2012

Data Analyst

Teachers Insurance and Annuity College Retirement Equity Fund (TIAA-CREF) Financial Services is a full-service financial services group of companies that has dedicated itself to helping those in the academic, medical, cultural, and research fields for over 90 years. TIAA provides a wide amount of annuity options to persons enrolling for annuity options. The project is to implement business intelligence solutions using MicroStrategy product suite with data sourced for Oracle RDBMS.

Responsibilities:

Gathered and documented business requirements for existing and future business systems.

Worked with business, product, and architecture teams to develop the overall roadmap for the platform.

Evangelized the concept and benefits of a service-oriented architecture to business and product teams, along with working with the technical teams to understand business perspectives.

Providing ongoing management support to ensure that the roadmap delivers to the requirements, and serving as an ongoing liaison for addressing and resolving changes as the roadmap evolves.

Translated business requirements into services specifications and assisting with exposing the company’s business logic and data through Web services.

Developed the System Requirements Document (SRD) from the Product Requirement Document (PRD) based on the input from various customers and helped the architecture and development teams to better understand the requirements

Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.

Built Screen Mockups for various user interface screens based on the requirements.

Worked with the end users to train and mentor them for the Web usage and Desktop for the Power users and day to day coordination with the users on ad hoc requests for reporting and analysis.

Worked extensively on developing Fact, Attributes, Metrics, Report Filters, Templates, Compound Metrics, Filters, Custom Groups, Templates and Consolidations using Micro Strategy Desktop.

Involved in testing the reports using the MicroStrategy.

Environment: MicroStrategy, Oracle, Rational Software Tools, SQL, MS Visio, MS Office Suite.

ADP Technologies - Hyderabad, India Aug 2008 – Dec 2010

SQL Server Developer

ADP is a comprehensive global provider of Human Capital Management (HCM) solutions that unite HR, payroll, talent, time, tax and benefits administration, and a leader in business outsourcing services, analytics and compliance expertise. The project is to develop ETL packages using SSIS and generate parameterize reports of the customers.

Responsibilities

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.

Performed Database code Migration from SQL Server 2005 to 2008 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.

Environment: MS SQL Server 2008/2005, T-SQL, SSRS, SSIS, Windows XP, MS Visio, MS Projects.

Contact this candidate