Resume

Sign in

Data Tableau

Location:
Plano, Texas, United States
Posted:
December 20, 2018

Contact this candidate

Resume:

Hakesh Kondakindi

858-***-****

ac70tv@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 8+ years of IT experience in Software Development and experience in Tableau Desktop, Tableau Server, Tableau Reader and Tableau Public in versions 8.x and 9.0, 10.x.

Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.

Publish Tableau Dashboards in Tableau Server, Tableau public Premium.

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

Experience in OBIEE 10g configuring repository, create and manage Dashboards, Reports/Answers using industry best practices.

Performed Tableau Server admin duties add users and groups from Active Directory and schedule instances in Tableau Server including weekly data dump.

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

Extensive experience on building Analytic Dashboards using Tableau.

Prepared backups using Tabadmin and Tabcmd commands.

Formulated procedures for installation and configuration of Tableau desktop.

Designed and developed SSIS packages for Tableau dashboards.

Knowledge of Health Insurance Portability and Accountability Act (HIPAA), information security stand. Very good knowledge on Patient and Health care data ware housing and developing analytics accordingly.

Very good knowledge and principles on good practicing of data analysis and data visualization.

End to end experience in designing and deploying data visualizations using Tableau

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in tableau reports.

Experience in creating Tableau Dashboards Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables with quick filters, parameters, sets, group, filter and URL actions, table calculations, various performance optimization, scheduling of data refresh and dashboards.

Good knowledge on Star Schema, Extended Star schema and Snowflake modeling.

Involved in Design and Development, Testing and Production rollover of Reporting and Analysis projects.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

Performed extraction, transformation and load (ETL) functions using data from multiple data sources and designed and built efficient dimensional data models using SQL and QlikView scripts for data visualization.

Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors, importing data from excel.

Knowledge on Informatica, DataStage. Demonstrated ability to self-motivate and be flexible within a fast-paced environment.

Excellent understanding and Strong experience in entire software development lifecycle (SDLC).

Excellent interpersonal and technical skills, quick learner, good team player.

Good Communication skills.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau Desktop 6/7/8.1/9/10, Tableau Public 8.x/9.x, Tableau Reader 8.x/9.x, Tableau Server 9.x,10, MicroStrategy, SSRS, SSIS, SAP, QlikView, OBIEE.

Languages: C, C++, PHP, XHTML, CSS, JavaScript, Python, PHP, Shell Script, MySQL, PL/SQL, NoSQL, RESTful Web Services, ASP .Net web API

Data Mining Tools: Rapid Miner and Tableau Software

Databases: MYSQL, SQL Server 2012, Teradata, Oracle, Mango DB

Operating Systems: Android, Unix/Linux, and Window

Other Tools: Android Studio, Eclipse, SharePoint, Informatica, Control –M, Quality Center, Load Runner

PROFESSIONAL EXPERIENCE

Bank of America, Plano, TX Jan 2018 – Present

Role: Tableau Developer

Responsibilities:

Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.

Responsible for making reports using Tableau desktop (10.2), Teradata according to the user's requirements.

Worked closely with Customer service and BO department for prompt and efficient delivery of Tableau Reports.

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

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Developed various data connections from data source to Tableau Desktop for report and dashboard development.

Created new Data source and replaced with existed Data source.

Created Schedules and Extracted the data into Tableau Data Engine.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked with Advance Analysis Actions, 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.

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.

Migrated SSRS reports to Tableau. Designed and developed Tableau reports based on the SSRS reports which are developed using store procedures. Custom SQL is developed to migrate and create same reports on Tableau.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Created and Published Tableau Dashboards into Tableau Server.

Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.

Analyzed and gained understanding of the underlying data and generated Tableau dashboards with forecast and reference lines.

Created Users and groups on Tableau Server and created monthly subscriptions of reports.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

Wrote Custom SQL to develop analytics to meet business requirements. Very strong experience with SQL.

Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.

Environment: Tableau Desktop 10.x/9.x, Tableau Server 9.x, MySQL, ETL, BO XI 3, SSRS, SSIS, SharePoint, SQL Server and Windows.

Eli Lilly and Company, Indianapolis, IN Aug 2016 – Dec 2017

Role: BI Analyst/ Tableau Developer

Responsibilities:

Developed various types of Charts and customized it according to requirement.

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

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections Add/Edit Sites and corresponding administration rights (System vs. Content) Create/Modify/Manage server task schedules Monitor server activity/usage statistics to identify possible performance issues/enhancements.

Developed Metadata Models in Tableau and dashboards. Experienced with trouble shooting and optimizing Report performance.

Customized data by adding filters at both the Framework level and Report level.

Created organized and formatted reports, folders and other contents on Connection Portal. Created List Reports, Cross tabs, Cascading Prompts.

Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/ Mapping and Presentation layers of metadata repository.

Worked with OBIEE Answers, Intelligence Dashboards. Involved in creation of prompts, views, aggregates, pivot tables, measures, customization, conditional formatting of reports to as per user requirements.

Created the SSIS /DTS packages and scheduled them using SQL Server Agent

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process (Informatica).

Used SQL Assistant to analyze and query from the Teradata DB.

Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.

Provided Training and End User Support with my reports and Knowledge transfer.

Applied three levels of security to the model (Data, Object and Package).

Applying Row and Object level security to Reports.

Performed Admin task for user permissions, scheduling the reports.

Performed Report Administrator to give set of permissions to the end user.

Created scripts for Informal and Formal Testing after development in QA Environment using HP-ALM.

Performed testing using HP-ALM and report the test results for approval and make changes accordingly as per business requirement.

Environment: Informatica, Toad for Oracle, OBIEE, Service Now, MS Project, MS Visio, SSIS, SSRS, SPSS, SAS, HP-ALM. Tableau Desktop 8.2 and 9.0, 9.2, 10.2 Tableau server, SQL Server 2012, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office.

Fannie Mae, Reston, VA Aug 2014 to – July 2016

Role: Tableau Developer

Responsibilities

Involved in reviewing business requirements and analyzing data sources form Excel/MS SQL Server for design, development, testing of reporting and analysis projects within Tableau Desktop.

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 in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.

Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.

Created multiple automated reports and dashboards sourced from data warehouse using Tableau/SSRS.

Wrote T-SQL procedures/Views to facilitate data access for reporting needs.

Update and upgrade the OBIEE platform to customize the system as per needs. Install and configure OBIEE tools across multiple tools and versions.

Designed SSIS Packages to transfer data from flat files to SQL database tables.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

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

Developed Metadata Models in Tableau and dashboards.

Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.

Formulated procedures for installation and configuration of Tableau desktop.

Designed and developed SSIS packages for Tableau dashboards.

Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.

Environment: Tableau Desktop (Version 8.1.2 - Version 9.0.2), ETL -Informatica, SSIS, SSRS, SQL Server, Microsoft Visual Studio, Microsoft Visual Basic, Webstrom, Oracle, OBIEE, SQL Server Management Studio, MS Excel, MySQL.

Boehringer Ingelheim Pharmaceuticals, Inc. Sep 2012 - July 2014

Columbus, OH

Role: BI Developer (Informatica, Tableau)

Responsibilities:

Worked on Data Mapping for the models for data transformation.

Involved in Creation of Tableau Reports, Dashboard Reports.

Created Complex Reports using Report studio, Plugged Prompts, Drill through Master- Detail Reports.

Gathering the requirements from the Business users and understanding the functionality & business rules.

Preparing functional design document, requirement document & technical design document for reports.

Developing data model to create reports and dashboards.

Developing worksheets using parameters, calculated fields, groups, sets and hierarchies.

Developing worksheets with different styles like bar, pie, tree map, dual axis, filled maps.

Implementing the reports with best practices to improve the report performance.

Creating rich dashboards using Tableau Dashboard and applying actionable insights.

Implementing user level security to restrict the data by group level and user level.

Publishing dashboards to tableau server and managing the security for users

Preparing deployment documents and involving in production deployments.

Created burst table and did Bursting of reports.

Prepared, developed and modified Powerplay reports and graphs with different layouts according user requirements.

Developed No. of Charts and customized it according to requirement.

Experienced with trouble shooting and optimizing Report performance.

Customized data by adding filters at both the Framework level and Report level.

Created List Reports, Cross tabs, Cascading Prompts. Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process.

Customized data by adding Filters Calculations, Prompts, Summaries and Functions.

Provided Training and End User Support with my reports and Knowledge transfer.

Applied three levels of security to the model (Data, Object and Package).

Applying Row and Object level security to Reports.

Performed Admin task for user permissions, scheduling the reports.

Performed Report Administrator to give set of permissions to the end user.

Environment: Informatica, SSIS, SSRS, Tableau, DB2, Teradata, ETL, Toad, Oracle, SQL, MySQL server.

Eli Lilly & Company, Hyderabad, India Aug 2010 - Aug2012

Role: BI Analyst

Responsibilities:

Developing customer segmentation approaches that support Marketing programs and implement systems and reports to monitor performance.

Business Analysis knowledge for business process, the need to understand all aspects of the company’s operations. Identify, analyze and design proves to improve the overall flow of information within the company.

Interacting with stakeholders, gathering requirements, elicitation techniques like interviewing, questionnaires, brainstorming, focus groups, cost/benefit analysis and risk analysis.

Maintain and develop (in close coordination with IT department) databases and analytic applications in environments such as SAP, Excel/Access, Business Objects, or other proprietary environments.

Developed custom user interface and business applications on the Salesforce.com platform.

Used various Transformations in SSIS Dataflow, Control flow using for loop Containers.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created SSIS packages with error handling, logging and performed data cleansing by creating tables to eliminate the dirty data using SSIS.

Leveraged clients existing IT framework/CRM system for better data visibility and system integration.

Develop and sustain relationships with key stakeholders.

Assisted in developing Project Scope, Business Requirements and Functional Requirements with internal team and clients. Facilitated the creation of test scenarios and test scripts.

Update and process internal data (call file, sales data, etc.) into Excel and other environments using automated procedures and custom programming.

Create and update the catalog of standardized market definitions and analytical business rules used within the analyses and reports. Maintain detailed master-calendar of key deliverables, including lead times for editing and approval processes.

Ownership of the development, maintenance and update of all national/subnational, and market tracking analyses according to a defined schedule.

Collaborate in development of presentations with clear storylines to communicate key conclusions and recommendations to brand and management teams.

Environment: Tableau, SQL, MS-Office, Lilly CRM, Salesforce, SAP, Excel/Access, Business Objects, OnDemand.

Unichem Laboratories, Hyderabad, India June 2009 - July 2010

Role: Business Analyst

Project: Product and Market Analysis for Cardiac, Diabetic and Endo Team.

•Successfully completed training on in-house databases, extracted data from various data sources, applied Excel functions to transform raw data in business information required for reporting and data analysis purposes.

•Integrated data into Salesforce applications.

•Created forms, benchmarks, objects, and projects. Successfully participated in group projects.

•Prepared various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified report templates as required

•Scripted VBA code which helped managers to store client meeting activity information in automated way.

•Prepared user guides by documenting the steps involved in generating various reports provided snap shots and explained the calculations with examples.

•Provided recommendations for improving existing reports generation process by pointing out constraints and suggested corrective measure.

Environment: MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, MS Office.



Contact this candidate