Tableau Developer

Anjani Kasireddy

Email: **********.*********@*****.*** Phone:669-***-****

QUALIFICATION SUMMARY

12+ years of strong experience in design, development of Data warehousing and Business Analytics.

Good experience in Retail, Health care, Sales, Marketing, Finance, Telecom and Airways domain.

Self-starter, pro-active and goal oriented, and able to operate with a sense of urgency as needed to make deadlines, can take ownership of assignments.

Quick learner who can easily adapt to different responsibilities and technologies.

Strong analytical, problem solving and communication skills.

TECHNICAL EXPERTISE

BI Tools: Tableau (Desktop and Server), MSBI (SSAS, SSIS and SSRS), BOBJ, Power BI and Excel.

Database: Teradata, Oracle, Hadoop, HP Vertica, SAP Hana and PostgreSQL.

ETL Tools: Informatica Power Center, Teradata utilities, Talend, Hive and SSIS.

Languages: SQL, Unix Shell Script, Python, Java, XML, C and C# dotnet.

Other Tools: Autosys, ESP, GIT, SVN, Atomic, Control M.

WORK PROFILE AND RESPONSIBILITES

Requirement gathering and analysis, design, coding, testing for the new projects.

Developed end-to-end Business Intelligence solutions like data modeling, ETL and reporting

Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.

Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculated measures.

Design different types reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Created customized and interactive dashboards using multiple data sources.

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Created dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing Ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.

Time to time monitoring system performance and optimization.

Performing data replication across multiple dashboards to handle failovers.

Generated Tableau reports for analyzes the metrics and feature’s performance.

Proficiency in creating different types of reports such as Crosstab, Drill-down, Form, OLAP, Dashboard reports, Sub reports and Linked Reports, and formatting of different types of dashboards.

Sending the reports from different output file format into different end users using Standard and Data Driven Subscriptions.

Experience in configuring automation reports using various delivery mechanisms like Email Links, PDF attachments and Excel attachments.

Experience in deploying reports in various sources like Web browser, XML and PDF.

Good Knowledge on Google Cloud Platform.

PROFESSIONAL EXPERIENCE

Technical Lead/ Senior Tableau Developer @ Apple (via QuEST Global) - Sunnyvale, CA

July 2016 – Till Date

Domain: Retail, Channel Sales, Marketing and Finance.

Project Description:

The iUp Upgrade program allows customers who purchase an iPhone with AppleCare+ coverage to upgrade every year provided they are still enrolled in AppleCare+ and have made the necessary number of monthly payments. When a customer becomes upgrade eligible in China and the US, a communication is sent to the customer via the Rover communications platform. Customers can upgrade in the US after they have made their sixth payment or eleventh payment. Customers in China become upgrade eligible when they have been in the program at least 9 months. iUp Rover campaigns, helping the business report to the leadership team how many EMAILS, ASA push and SMS communications were sent, what open rates are for emails, and what percent of those receiving the communications upgraded.

Responsibilities:

Gathering requirements from business users, Preparing BRD (Business Requirement Documents) and FSD (Functional Specification Documents) document.

Analyzed the model flow and prepared the design documents.

ETL and Dashboard UI Design and Development.

Created complex dashboards using multiple systems (like RCM and RCS data.).

Created iUP Dashboards, AT &T Dashboards, LMS Reports, Communications Reports and Task Reports based on user requirement.

Created complex dashboard (Sell In, Shell Thru, TSA, BTB, BTB with ASP, BTB without ASP and ASP) using multiple data sources (like Teradata, HP Vertica and Excel).

Create multiple trend graphs like dual axis charts, Line chars, Bar charts, Pie Charts, Donut Charts, Tabular reports and Matrix reports.

Developed various dashboards, used context filters, action filters, parameters, and calculated sets for preparing dashboards and worksheets dealing with huge volume of data.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Create dashboards like quarterly, monthly, weekly, daily reports and schedule the dashboards to requested users.

Performance testing on multiple servers (UAT and production).

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.

Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues.

Building, publishing customized interactive reports and dashboards, report scheduling reports to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Worked on IT, UNIT, PVT, PROD testing and data validations.

Worked on the Job scheduling changes and dry run support.

Primary support for fall out reports and production job failures.

Environment: Tableau desktop 2020.1.4/2019.1.0, Tableau Server 10.5, Teradata Database (EDW),HP Vertica,Cloudera Hadoop Hive, Spark, and SAP HANA.

System Analyst II @ ThermoFisher (via Ruha Technologies) - Carlsbad, CA

Nov 2015 – July 2016

Domain: Health Care

Project Description:

Thermo Fisher Scientific Inc. is the world leader in serving science, with revenues of $17 billion. Our mission is to enable our customers to make the world healthier, cleaner and safer. We help our customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics and increase laboratory productivity. Through our premier brands – Thermo Scientific, Applied Bio systems, Invitrogen, Fisher Scientific and Unity Lab Services – we offer an unmatched combination of innovative technologies, purchasing convenience and comprehensive support. Innovative analytical instruments, lab equipment and specialty diagnostics that provide rapid and accurate results for customers in research, clinical and applied markets.

Responsibilities:

Create complex dashboard using multiple data sources (like Sales Force, Oracle, SQL and Excel).and Custom Hierarchies to meet the Business requirement in Tableau.

Create CMD,LPG,LSG,LPG Demand Waterfall, ERP, Monthly and Cognos (MBD Cube) Dashboards.

Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Create Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

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.

Regular involving in calls with customer and discussing about status and new requirements of the project.

Checking the production environment jobs and troubleshooting the failed jobs

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.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Creating, modifying, deploying and browsing Cubes with multiple fact measures and multiple dimension hierarchies in MBD Cube.

Environment: Tableau desktop 9.2, Tableau Server 9.2 version, Oracle, Microsoft SQL Server 2008 R2/2012, Microsoft Office, Windows 7. T-SQL, Sales Force and MBD Cube.

Application Developer @ Qatar Airways (Computer Sciences Corporation) - Bangalore, India

Jun 2013 – Nov 2014

Domain: Airways

Project Description:

Facility Management department offer comprehensive services to various departments support the overall operations. Maintenance activity is an important function carried out for the Residential and Commercial Buildings and Villas respectively situated in Doha, Qatar. With the business operation growing manifold, there is a desire to shift from a functional oriented environment to process oriented environment through this proposed IT enabled solution. The current process is maintained through manual process where extensive use of spread sheets for maintenance of records, data and statistics. Generation of reports is a time-consuming exercise both for data collation and statistical accuracy. Delay in reports results in delay in decision making of vital nature. Manual records do not facilitate for data retrieval and history on a real time basis.

Responsibilities:

Create Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.

Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Create dashboard using multiple data sources and Custom Hierarchies to meet the Business requirement in Tableau.

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.

Regular involving in calls with customer and discussing about status and new requirements of the project.

Checking the production environment jobs and troubleshooting the failed jobs

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.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Transformation of OLTP data to the Data Warehouse using SSIS (ETL) Packages.

Creating, modifying, deploying and browsing Cubes with multiple fact measures and multiple dimension hierarchies in SSAS

Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked Reports and Dashboards using the MDX Queries and T-SQL Queries.

Created Jobs, scheduling & running jobs and troubleshooting the failed jobs.

Environment: Tableau 9.1/8.3, Tableau Server, Oracle, Microsoft SQL Server 2008 R2/2012, Microsoft Office, Microsoft Visio, Windows 7. T-SQL, MS SQL Server 2012/2008 R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), Windows 2007, VBScript

Senior Software Engineer @ Pfizer (via HCL Technologies) - Chennai, India

Nov-2009 to April – 2013.

Domain: HealthCare.

Project Description:

Insight is an Order-to-Cash Management Data Warehouse. The Enterprise Resource Planning (ERP) application which involves taking customer sales (direct from the customer & retail) orders via different sales channels, such as email, internet, salesperson, fax or by some other means like EDI, and then fulfilling the order, shipping, logistic and then generating an invoice and collecting payment for that invoice and then receipt. It’s an Enterprise-wide application, catering to various businesses like PGP, PAH, PGS, PCS and etc. Pfizer Incorporated (NYSE: PFE) is the world's largest research-based pharmaceuticals firm, ranking number one in sales in the world. The company markets its pharmaceuticals directly to health care providers and patients; most of its sales are conducted through wholesalers including McKesson and Cardinal Health. Pfizer acquired Pharma rival Wyeth in a $68 billion deal in 2009.

Responsibilities: As a Production Support Engineer, I am responsible for

Handle L2 / L3 Support Tickets

Provide on-call support to production system to resolve any issues.

Communicate with other teams like DBA, UNIX and Development team.

Creating and maintaining various documents like Issues Resolution, Report Access Check List etc.

Monitor various scheduled Backup / Cube Processing Task.

Deployments to other environments like Testing, PROD.

Interacted with end-users, customers during various phases of the implementations (ETL, Reporting, Production Support, Enhancements and bug fixes)

Migrated existing SQL 2000 DTS packages into SQL 2008 R2 SSIS packages.

Design, Development, Testing the SQL Server 2008 R2 Packages.

Interaction with Onsite team to validate and clarify requirements for design/development work at offshore.

SQL query are reside in execute dts 2000 package, convert SQL query into procedure.

Using Script Component - SSIS tool does not support directly return type refcursor from procedure.

Preparation of Database Development and Development scripts.

Providing support to the onsite team for resolving application issues.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server(TFS), Windows XP, MS-Front Page, Oracle 9i, VBScript, Share Point Server, HP Service Center, Oracle Toad.

Software Engineer @ AOFL (via Exensys Software Solutions) - Hyderabad, India

Sep-2007 to Aug - 2009

Domain: Oil and Gas

Project Description:

AOFL is one of the largest Oil refining Company in India, And AOFL was already an ERP client of eXensys Software Solutions Ltd., AOFL is having nearly 35 Branches across INDIA.

AOFL BI is the complete BI solution for AOFL that consists of 7 MOLAP Cubes, 22 Dimensions and 18 Facts, and nearly 30 Static SSRS reports.

Responsibilities:

Design the Stage OLAP (Data warehouse and Data Mart) in SQL server 2005.

Handle the complete ETL Process of the Project using SSIS as ETL tool to load the OLAP.

Where I used the SCD type 1 for Dimension modeling.

And design the Package in such a way that it will load the fact tables incrementally.

Design the master package in such a way that by scheduling the single package the complete process will cover i.e., it will load the dimensions table first then the Fact tables and also the same package is used to process the cube.

Created the OLAP Cubes and KPI’S

Environment: MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server (TFS), Windows XP, VBScript.

PROFESSIONAL ACHIEVEMENTS

Received “SEE Award” from the client

Received “POWER OF ONE” awards

Received “Best Employee “of the Quarter

EDUCATION

Jawaharlal Nehru Technological University, India

Bachelor of Technology in Computer Science and Information Technology.

Contact this candidate