Arundhati Gutta

adjqjv@r.postjobfree.com

630-***-****

Naperville, IL

Visa Status : US Citizen (Authorized to work for any Employer, no sponsorship required)

SUMMARY

** **** ***** ** ** Experience in Business Intelligence and Development of Reports in Tableau, Power BI, Looker, Oracle OBIEE, Microsoft BI Stack and Crystal Reports in various business domains -Healthcare, Insurance, Supply Chain, Manufacturing, Financial and Digital Marketing.

Data Warehouse Development: Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging. Strong understanding of Data Warehousing concepts, Dimensional modeling, Star schema and Snowflake schema

Domains Expertise: Experience in data warehouse and BI projects implementation with Manufacturing, Advertising, Healthcare, Financial, Government and Retail domains.

Project Management Estimation: Proven track record in managing Data Warehouse and BI technical teams, assisting the project manager with task planning, estimation and conducting project co-ordination activities. Well versed with SDLC life cycle Waterfall and Agile methodologies .

Requirements Gathering: Experience in Understanding business processes and gathering requirements from subject matter expert.

ETL Development: Expertise in creating ETL routines and mappings using Informatica, OWB, ODI, SSIS, and Alteryx data from multiple sources int0 targets. Extensively worked on the ETL mappings, analysis and documentation. Deep experience in creating fact, dimension, staging, ODS and other database objects like views, stored procedure, function.

BI Development: Expertise in designing and deploying BI reports and dashboards using Tableau, Looker, Microsoft SQL Server Reporting Services (SSRS), Microsoft Power BI, Oracle Business Intelligence Tools, Discoverer, BI Publisher, OBIEE and Crystal Reports.

Database Development: Knowledge in database development and designing using Oracle, Sql-Server, Hadoop Cloudera, Hive, Impala and Microsoft AZURE Cloud

Administration Tasks: Experience in performing Tableau administration tasks, in adding users, managing roles, assigning privileges.

Training and Instructing: Expertise in guiding, training, assisting the team members on technical issues and new technologies.

Documentation: Experience in developing physical design, logical design, source target, data profiling, bus matrix documentation that help in standardization.

QA and SLA's: Experience in peer review, unit testing and performing error free, on time and within budget delivery of projects.

Experience in Managing and Leading Teams.

Experience in Tableau Desktop for data visualization, Dashboards, Reporting and Analysis, Horizontal Bars, Vertical Bars, Stacked Bars, Scatter Plots, Geographic Maps, Pie Charts and Heat Maps.

Proficient in creating Parameters, Table Calculations, LODs (Level of Detail) Calculations and Conditional Formatting with shapes, colors, size, text, created Data source Filters, Context Filters, Qucik Filters and Extract Filters.

Used Actions, sorting, filters, sets and grouping extensively.

Built several Charts - Bar Charts, Line Charts, Pie Charts, Donut Charts, Bubble Charts, Staked Bar Charts, Tree Map and Gantt Charts.

Created several Date/Time Calculated fields, Aggregations, Geo Mapping, and Parameters.

Strong interpersonal skills and a proven ability to work effectively with peers, technical teams, project managers and quality assurance managers.

Self-starter and quick learner. Excellent Analytical, Problem solving and Communication Skills.

EDUCATION:

BS in Computer Science

Osmania University, Hyderabad, India

Diploma in Software Technology

Bureau of Data Processing Systems, Hyderabad, India

Diploma in Computerized Accounting

Dorsey Business School, Madison Heights, MI, USA

TECHNICAL SKILLS:

Specialities

Data Visualization, Business Intelligence (BI), Agile/Scrum Methodology

BI Tools

Tableau 7.0/8.0/8.1/8.2.5,/9/9.3/10.1/10.2/10.3/10.5/Tableau Hyper/

Tableau 2018, Tableau 2019, Tableau Prep

Looker, OBIEE 10g/11g, Oracle Discoverer, BI Publisher, Business Objects, Microsoft BI stack, SSRS, and Visual Studio, Microsoft Power BI,

Google Analytics 360, Sharepoint, familiar with D3 and Spotfire

Database

Hadoop Cloudera, Oracle 11g/10g/9i/8i,

MS SQL Server 2005/2008/2012/2014/2017, MS Access,

Microsoft AZURE Cloud, Teradata, Epic, AWS Redshift

Operating Systems

UNIX, LINUX, MS-DOS, Windows 7/2000/NT/XP/Vista

Tools and Packages

SQL*Plus, SQL Developer, TOAD, Oracle EBS, Oracle Forms & Reports,

Crystal Reports, SAS, JIRA

Languages

SQL, PL/SQL, VB Script, Javascript, Python and R

ETL Tools

Informatica 8.6.1, 9.2, Oracle Warehouse Builder (OWB, ODI) 11gR2,

MS SSIS, AtScale, Alteryx, Tableau Prep.

Testing Tools

QTP, Quality Center, ETL Testing

PROFESSIONAL EXPERIENCE:

Bank of America

Charlotte, NC

September 2020 to Present

Role: Tableau Visualization Expert

Role and Responsibilities:

Senior Tableau Visualization Expert in Enterprise Cards Division, Involved in requirements gathering, design, development of Dashboards, Creating Vendor Service Level Agreement Dashboards. Publishing Dashboards, maintenance and enchancements.

Moving data from DB2 to Oracle Database. Creating mock up wireframes in Powerpoint and Tableau.

Wells Fargo

Charlotte, NC

April 2019 to June 2020

Role: Senior Tableau Developer

Role and Responsibilities:

Senior Tableau Developer in Endpoint Security Engineering & Emerging Services(ESE ES) Division. Involved in Analysis, Design, Development, Periodical Data Refresh of Data Sources and Testing of Dashboards for HR Department for Senior Management and internal users. Created Technology Complaince Program(TCP) Steering Committee Dashboards, TCP Managers View Dashboards, TCP Travel and Training Dashboards for Information Systems Managers, Divisional Managers and TwoDown Managers. Created alternative views to Risk Level Tab in TCP Steering Committee Report used dynamic color coding which is an advanced feature of Tableau.

Enhancements and clean up and applied clear and crisp formatting and font to the views to get the best visualization. Used Wells Fargo Brand Standard Colors for Charts and the Headers and Labels. Created Donut Charts, Bar Charts and Line Charts and in the Tabular Reports all the enhancements were done which are exactly same as in Excel Mock up requirements given by Executives.

Published the Dashboards on Development server and on Production Server.

Used JIRA for Project tracking. Used Tableau Prep for Importing data and Transforming the Data.

Designed and developed CTO BOW Dashboard, Resource Sourcing Tool Dashboard and Hiring Plan Dashboard. Created Users Manuals for the Dashboards. Product Support of Dashboards in Production Environment.

Environment: Tableau 2018, Database MS SQL, JIRA, Sharepoint, Splunk

The Marketing Store (TMS)

Havi Group

Chicago, IL

Jan 2019 – April 2019

Role: Senior Tableau Developer

The Marketing Store Worldwide, LLC operates as a customer engagement agency. The company provides marketing technology solutions; and creates digital products and platforms. It serves brands worldwide. The company was founded in 1991 and is headquartered in Chicago, Illinois. The Marketing Store Worldwide, LLC operates as a subsidiary of HAVI Group, LP

Role and Responsibilities:

Design and Developed Connected Car, Opportunity Calculator Dashboards for China and Japanese Markets. Developed Dashboards according to User Mock Up. The Dashboards have an option of viewing the Charts and Tabular views and the data in English and converting into Chinese and Japanese. The Datasource was customized to use the Language of choice.

Environment: Tableau 2018, Tableau 2019 Database MySQL

Navistar

Lisle, IL

June 2016 – December 2018

Role: Tableau Visualization Expert / Admin

Navistar International Corporation (formerly International Harvester Company) is an American holding company, that owns the manufacturer of International brand commercial trucks, IC Bus school, Defense Vehicles and commercial buses.

Responsibilities:

Administrator Role : Administering Tableau Server and Tableau Desktop, and managing Tableau Sites.

Set up Subscriptions and Alerts on the Server.

Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory. Experience in the maintenance and scheduling of Tableau Data Extracts using Tableau Server. Publishing the Datasources and Dashboards to the server. Played a Key Role in identifying performance issues and suggested alternatives and work arounds for improving speed. Involved in Installation and upgrades. 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. Experience with Tableau application performance monitoring, capacity planning, Row Level Security and tuning for multiple Users on several projects. Experience with Active Directory Integration and Synchronization with Tableau.

1)Environment: Single node server

2)4 of each VizQl, backgrounder and cache processes.

3)Kerberos sign on.

4)Server version 10.5.4

5)Processor : AMD EPYC 7251 8-Core Processor, 2100 Mhz, 8 Core(s), 8 Logical Processor(s)

6)64 GB memory

7)1.5 TB space

8)~ 50 GB size of total backup as of now.

Visualization Expert/ Senior Developer Role: Managing group of four Tableau Developers, leading several projects, Interacting with business users from OCC, IPD and IT, Supply Chain departments to gain a good understanding of the business, analytical, and reporting needs, including the identification of critical metrics and KPIs. Story telling and presenting data with best practices and best visualizations.

Developed rich interactive visualizations integrating various reporting components from multiple data sources. Converted several Reports which were in Oracle Discoverer and OBIEE to Tableau Dashboards.

As a Tableau SME, responsible for the design, development and production support, maintenance of interactive data visualizations used across the company.

Supply Chain: Designed and developed High Priority Dashboards- Order to Delivery Dashboards for CEO which are displayed on the big screen next to the CEO’s desk.

Converted existing OBIEE Dashboards to Tableau Visually Rich Dashboards.

IT: Designed and build IT Operational Mega Dashboard, which gives the snap shot of IT Metrics for the CIO and the Executives. The Mega Dashboard has 22 Sheets with visually rich charts.

Included are the other 33 Tabbed Views which contains information and different types of charts about Budget, Ticketing, Assets, Resources, Overall Project Status and Asset Audits etc., the dashboards contain Bar Charts, Stacked Bar Charts, Pie Charts, Line Charts, Donut Chart, Bubble Chart, conditional color coded background for Ticket Metrics the workbook contains 200 plus sheets. Designed and Developed IT Metrics Dashboards in Tableau as well as in Power BI.

Manufacturing: Enchancements were done to - All Parts Manufacture Defects Dashboard.

Integrated Parts Division (IPD): Built Parts Analysis – Parts Usage on Built Vehicles Dashboard which holds 1.3 Billion rows of data, improved the data load time by creating Extracts and Applying Data Source and Quick Filters, embedded an external link which loads the Users Manual in PDF format for the users, built SQ Search Dashboards Version 1 and Version 2 and SQ Search Trends. Built SSAS Models for SQ Search Dashboards.

On Command Connect (OCC): Build OCC Repeat Offenders Dashboard, LT & A26 Dashboard, OCC Telematics Dashboard, OCC Telematics Active and Inactive Device Counts Dashboard, OCC EDL Drivers & Carriers Count Dashboard and other dashboards.

Call Center Metrics: Currently designing and developing Dashboards for Call Center Metrics. Open Aging Tickets, Closed Tickets Metrics Dashboards, Drivers and Carrier Logs Dashboards.

Environment: Tableau Desktop and Tableau Server 9.1/9.2/9.3/10.1/10.2/10.3/10.5

Hadoop Cloudera, Impala, Hive, Alteryx, Atscale, SSMS, Visual Studio 2014/2017 Microsoft Azure Cloud, Sharepoint, OBIEE and Cognos 10, Splunk, Hive, AWS

US Foods

Rosemont, IL

January 2016 – June 2016

Role: Tableau Admin/Senior Tableau Developer

Tableau: Involved in Analytics team in building Tableau reporting and Server from ground up. Experience in administering Tableau Server and Tableau Desktop.

Creating and managing Tableau Sites. Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory. Experience in the maintenance and scheduling of Tableau Data Extracts using Tableau Server.

Publishing the Datasources and Dashboards to the server.

Worked with business teams to gain a good understanding of their business, analytical, and reporting needs, including the identification of critical metrics and KPIs

Partner closely with cross-function peers and leaders to deliver reporting projects that solve business requirements.

Build and prototype dashboards to provide insights into the operations of a business function.

Developed rich interactive visualizations integrating various reporting components from multiple data sources. Provide training and expertise to business users and other stakeholders on Self-service BI. Work closely with the Data Architecture team and provide technical design recommendations on the data mart structures which support analytical applications.

Provided technical details for implementation of BI solutions

Design functional specs for BI front end applications including dashboards and reporting. Provide expertise and guidance to other developers in the use of the toolset. Develop and enhance relationship between developers and customers through good practices of Customer Service.

Set up sites, projects, workbooks, views and data sources, Working with Oracle 11g to query, sort and filter through data sources.

ETL Project :Lead the Campaign Management Data Project as the Technical Lead

Design, Develop, Test and Integrate the Campaign Management Data into Oracle Database. Build ETL mappings in Informatica, extract the source files(Flat Files) transform and Load process. Took complete ownership of the Project from design to going live in Production.

Environment: Tableau Desktop and Tableau Server 8.2.5/ 9.3, Cognos 10, Oracle 11g, SQL Developer, Salesforce, JIRA, Confluence, Informatica 9.2, HPSM, Control M

G/O Digital Marketing, A Gannett Company

Chicago, IL

December 2014 – December 2015

Role: Tableau Developer

Description: G/O Digital is a new division of The Gannett Company (NYSE: GCI). G/O Digital is solving major market problems and defining major market opportunities to transform local marketing. G/O Digital delivers simple solutions to connect with consumers locally in a meaningful, personal way and #WinLocal. With a comprehensive suite of digital marketing services, G/O Digital is powered by digital marketing leaders.

G/O Digital for SMBs: Integrated digital marketing provider to local businesses in more than 100 local markets.

Shoplocal: Powering local@scale through a real-time localization engine that syndicates digital content across any channel or format.

BLiNQ Media: Leading social engagement, solving the transformation of social content into local commerce at scale, across any channel, format and screen.

Key Ring: Leading mobile experiences, including the #1 shopping app, to attain, retain and reward customers

Responsibilities:

Assist internal customers, including executives, with analyzing data and developing effective reports, dashboards and visually rich graphs.

Respond to timely ad-hoc data request from multiple requesters.

Assist with high profile and complex projects that have a high level of visibility within the company.

Interact with Business users and understanding their requirements.

Designing, Developing, and supporting interactive Tableau Dashboards and reports.

Recommending Dashboards per Tableau visualization features.

Delivering reports to Business team on timely manner.

Drew upon full range of Tableau platform technologies to design and

implement proof of concept solutions and create advanced BI visualizations.

Designed and developed multiple Dashboards for the Sales, Marketing, and Finance Department, conversion of EXCEL and Powerpoint Reports to Tableau Reports.

Designed and Published several Workbooks and visually rich Dashboards for Finance Department. i.e. Bookings Report, Billing Report, Revenue and Budget Report, Cancellation Report and Retention Report etc…

Created Filters, Parameters, Hierarchies, Actions, used Data Blending and written Custom SQL Queries for Datasources, and used Stored Procedures as Datasources. Created Calculated Fields based on the requirements.

Generate reports for Marketing team to measure media channel and market by Region(city/geographic level) performance.

Create automated queries and reports to measure vital business statistics.

Documented processes and code.

Experience attaching to multiple data types utilizing Excel, CSV, MS SQL Server, within the current version of Tableau.

Published several Workbooks and Dashboards to Tableau Server & troubleshooted display issues.

Experience in utilizing Microsoft Power BI tools such as Power View, Power Pivot, Power Query and PowerMap to retrieve, analyze and present data in well-designed visualizations.

Performed Unit testing and successfully migrated the Workbooks and Dashboards to QA Environment and Production Environment.

Working both individually and as part of a collaborative team, while displaying excellent levels of discretion, professionalism, and the ability to solve problems analytically through critical thinking.

Created User Manuals for the reports in PowerPoint.

Environment: Tableau 8.2.5, MSSQL Server 2012, MS Power BI, Salesforce, JIRA, GITHUB, SmartGIT

Blue Cross Blue Shield of Michigan

Detroit, MI

August 2013 – November 2014

Role: Tableau Developer

A.M.Castle & Co

Oakbrook, IL

September 2012 – August 2013

Role: Senior BI Developer/Tableau/OBIEE/ETL Developer

Maryland State Department of Education

Division of Accountability and Assessment

Baltimore, MD

October 2011 – September 2012

Role: BI Developer

ADP, Hoffman Estates, IL

July 2009- October 2011

Oracle Reports Developer

Advocate Health Care, Downers Grove, IL

June 2007 – June 2009

Reports Developer

Viant, Naperville, IL

May 2000 – March 2004

Role: Programmer

CAPGemini America, Westchester, IL

May 1996 – May 2000

Role: Consultant –Oracle Reports Developer/Tester

Client : US Cellular Rosemont, IL

Oracle Developer

Client: United Insurance, Chicago, IL

Oracle Reports Developer

Contact this candidate