Candidates About

 

Charan

Professional Summary:

·         Extensive 8+ years of experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 10.x/9.x/8.x

·         Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups & Conflict Management with Project team members.

·         In depth understanding of the As-Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing a business solution.

·         Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.

·         Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Context filters, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending etc.,

·         Expertise in Performance Tuning Tableau Dashboards and Reports, which built on huge Data sources.

·         Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Donut charts, Waterfall charts, Pareto Charts, Tree Map and Highlight tables.

·         Expertise in web integration of Tableau Reports with HTML or Asp.Net in iFrame with different URL parameters.

·          Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data retrieval sql queries/programming of data conversion and researching complex data problems.

·         Proficient in Star and Snowflake Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.

·         Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.

·         Working knowledge of performance improvement measures to optimize data loading time and Data retrieval by implementing different data models like building summary tables etc..

·         Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.

·         Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.

 

Technical Skills:

BI Reporting Tools	Tableau Desktop 8.x /9.x/10.x, Tableau Server 8.x / 9.x/10.x, Microsoft Power BI, Sequel Server Reporting Services, Microsoft Power BI Services(Server), SSRS Report Server, SSRS Reports Management
Databases	SQL Server 2008/2012/2014, My SQL ,Oracle
ETL	SQL Server Integration Services (SSIS), Informatica 7.x/8.x
Operating Systems	Windows 95/98/2000/XP/Vista/7/8/10, Unix, and Linux
Other Tools	MS Office 2010, MS Excel 2016, SVN
Management Tool	JIRA
SDLC	Agile, Scrum, Waterfall Methodologies
Languages	C, C++, HTML, SQL, PL/SQL, XML

 

 

PROFESSIONAL EXPERIENCE:

Target, New Jersey                                                                                                                    Jan 2017 to Present

Sr. Tableau Developer

Description:

     Target Corporation is the second-largest retailer store in the United States. It operates 1,834 stores throughout the United States which includes the discount store Target, the hypermarket SuperTarget, and flexible format stores previously named CityTarget and TargetExpress before being consolidated under the Target branding.

Responsibilities:

·         Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.

·         Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server.

·         Developed Tableau server audit reports to view and analyze tableau server insights (health, Tableau server usage, Tableau server data extract failures etc.).

·         Created ETL meta-data reports using SSRS, reports including execution times for the SSIS packages and failure reports with error description.

·         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.

·         Involved into installations and system setup and configurations.

·         Worked with Stakeholders and business users for mentoring and training.

·         Tableau desktop and server tickets resolution using JIRA (primary contact for support)

·          Resolving Tableau Dashboards development and performance issues

·         Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Crosstabs, Histograms etc.

·         Developed effective and interactive Dashboards using Parameters and Actions.

·         Developed donut charts for analyzing sales planning data.

·          Created different KPI's using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)

·         Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

·         Mastered the ability to design and deploy rich Graphic visualizations using Tableau.

·         Strong Dashboard design experience and passionate practitioner of effective data visualization and familiarity with best practices around visualization and design.

·          Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.

·          Expertise in working with data building Groups, Hierarchies, and Sets.

·         Also involved in administrative tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

 

Environment: Tableau Desktop 9.3/9.0/8.3/8.0, Tableau server, Oracle SQL developer, Oracle 11g, PL/SQL, Windows 2010 server, SSIS,MS Office 2010,Excel, Power Point, Share Point.

 

 

Regions Bank, Birmingham, AL

Tableau Developer/Analyst                                                                                                 Nov 2015 to Dec 2016

Description:

       Regions Financial Corporation is a bank and financial services company which provides retail and commercial banking, trust, securities brokerage, mortgage and insurance products and services.

Responsibilities:

·         Worked closely with Business users to gather requirements and designed, developed and maintained Tableau functional reports and dashboards.

·         Collaborate with ETL teams to deploy solutions and to support effective use of BI data by business users.

·         Designed rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.

·         Developed Tableau data visualization using Cross tabs, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts etc.

·         Developed reports using Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Table calculations and LODs.

·         Wrote UNIX shell scripts to spawn the Loader job for daily load of data.

·         Distributed Tableau reports using Packaged Workbooks and PDF to different user communities.

·         Developed Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

·         Developed Complex calculated fields for the business logic, Field Actions, Sets and Parameters to include various Filtering capabilities for the dashboards, and to provide drill down features for the detailed reports by using Tableau Desktop.

·         Published and shared the workbooks with the business using Tableau server.

·         Involved in Tableau Administration by adding users, groups, data connections, scheduling tasks, embedding views in the Tableau Server.

·         Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

·         Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the code share data between partner airlines, etc.

·          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.

 

Environment: Tableau Desktop 9.3/9.0/8.3/8.0, Tableau server, Oracle SQL developer, Oracle 11g, PL/SQL, Windows 2010 server, SSIS,MS Office 2010,Excel, Power Point, Share Point.

 

BHP Billiton, Chicago, IL                                                                                                        July 2014 to Oct 2015

Tableau Developer

Description:

It is one of the world's six major oil and gas companies, whose performance in 2013 made it the world's largest oil and Gas Company, the sixth-largest energy company by market capitalization and the company with the world's fifth-largest revenue (turnover). It is a vertically integrated company operating in all areas of the oil and gas industry, including exploration and production, refining, distribution and marketing, petrochemicals, power generation and trading. It also has mining interests in biofuels and wind power.

Responsibilities:

·         Gathered user requirements, analyzed and designed software solution based on the requirements.

·          Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.

·         Prepared Business Requirement document and then converted business requirements into technical designs.

·         Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.

·         Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server.

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

·         Created complex formulas and calculations within Tableau to meet the needs of complex business logic.

·         Created and assisted users in Tableau dashboard development.

·         Defined best practices for Tableau report development and effectively used data blending feature in tableau.

·         Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

·         Creating users, groups, projects, Data connections, settings as a tableau administrator.

·         Maintaining server activities, user activity, and customized views on Server Analysis.

·         Manage the application's users, groups, and integration with Active Directory.

·         Good SQL reporting skills with the ability to create SQL views and write SQL queries.

·         Integration of Tableau reports with Asp.Net web applications and usage of url parameters for better visualization improvement.

 

Environment: Tableau Desktop 9.2, Tableau Server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, SSIS, MS Office 2007

 

GEICO Insurance, Washington, MD                                                                                   Jan 2013 to June 2014

Business Intelligence Analyst

Description:

GEICO Insurance is the second largest auto insurer in the United States, after State Farm. It is a wholly owned subsidiary of Berkshire Hathaway that as of 2014 provided coverage for more than 22 million motor vehicles owned by more than 13 million policyholders. GEICO writes private passenger automobile insurance in all 50 U.S. states and the District of Columbia. GEICO uses a direct-to-consumer sales model. GEICO is well known in popular culture for its advertising, having made a large number of commercials intended to amuse viewers.

Responsibilities:

·         Involved in full project lifecycle of SDLC and coordinated with all project teams.

·         Interacted with Subject Matter Experts & End Users and gathered business requirements.

·         Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.

·         Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.

·         Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.

·         Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

·         Created and administered user, user groups, and scheduled instances for reports in Tableau Server.

·         Wrote UNIX shell scripts to spawn the Loader job for daily load of data.

·         Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.

·         Extensive experience in creating dashboards using calculations, parameters in Tableau.

·         Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.

·         Mastered in different formatting techniques, using Annotations and Mark Labels.

·         Developed effective and interactive Dashboards using Parameters and Actions.

·         Maintaining server activities, user activity, and customized views on Server Analysis.

·         Prepared proof of concept for best practices in Tableau deployment.

·         Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.

·         Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop

·         Played an important role in coordination with the entire team and managing the time estimates for the entire project.

·         Used SQL queries and validate the data in the warehouse and marts.

·         Provided post implementation production support.

 

Environment: Tableau (Desktop/ Server), Informatica, SSIS, Oracle, SQL, PL/SQL, Windows 2007 server,

 

 

 

 

 

Arrow Electronics, Centennial, CO                                                                                      Jan 2012 to Dec 2012

Tableau Developer/Data Analyst

Description:

Arrow Electronics, Inc. is a provider of products, services and solutions to industrial and commercial users of electronic components and enterprise computing solutions. The Company has a portfolio of product offerings available from various electronic components and enterprise computing solutions suppliers. The project is to manage Tableau data sources and develop various reports to view key performance indicators of the supplier wise sales, product wise sales, revenue growth, etc.

 Responsibilities:

·         Served as Data Analyst meeting deadlines and budget requirements.

·         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, policies and procedures.

·         Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

·         Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

·         Interact professionally with diverse group of professionals in the organization including managers and executives.

·         Wrote UNIX shell scripts to spawn the Loader job for daily load of data.

·         Developed Standard Operating Procedures (SOP) for Monitoring.

·         Extensively used data blending, embed functionalities in Tableau.

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

·         Involved in license management SLA's with Tableau support.

·         Defined and created procedures to install Tableau desktop in silent mode.

·         Defined best practices for Tableau report development.

·         Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.

·         Provided 24/7 production support for Tableau users.

·         Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

·         Provided Tableau Server and Tableau Desktop training for other employees in the organization.

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

·         Use MS Excel, Word, and Power point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.

·         Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

 

Environment: Tableau, SharePoint, Informatica, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).

 

 

 

 

 

Softech, Hyderabad, India                                                                                                       June 2009 -Dec 2011

SQL Developer

Responsibilities:

·         Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options

·         Involved in Design, Development and testing of the system

·         Implemented logical and physical database modeling using Erwin tool.

·         Wrote complex SQL queries for validating the data against different kinds of reports.

·         Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

·         Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.

·         Created indexes, Constraints and rules on database objects for optimization.

·         Worked on Documentation using MS word

·         Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management

 

Environment: Windows Server, MySQL, Microsoft SQL Server 2005/2008, Oracle, Microsoft Visual Studio.