Data Tableau

Durga Nagaraju

Sr. Tableau Developer

Mobile: 309-***-****

Email: *********.**@*****.***

PROFESSIONAL PROFILE

I am an accomplished and dedicated professional with extensive experience across all areas of Data Analytics, Business Intelligence. An exceptional leader who is able to develop and motivate others to achieve targets, a proactive individual with a logical approach to challenges. I have 14+ years of Professional IT experience in Data warehouse, ETL and Business Intelligence reporting using Tableau Desktop, Tableau Server, Cognos, Informatica, SSIS and PL/SQL, Python, R, Data wrangling, Data science concepts etc.

SKILLS

●Well versed with complete Software Development Life Cycle (SDLC) process including requirement analysis, documentation, development, testing, implementation, and maintenance..

●Have a good understanding of Tableau architecture, design, development and end user experience.

●Extensive experience in Tableau Prep, Tableau Desktop, Tableau Server and in various versions of Tableau.

●Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option in Tableau.

●Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

●Good at implementing LOD (Level of detail) expressions

●Worked on Heat maps, tree maps, bullet charts, control charts, Box and Whisker plots, scatter plots, area charts, line graphs, stacked bar graphs, combined charts etc.

●Worked on TabPy Extension to leverage Python packages.

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

●Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.

●Extensive experience in SQL queries in SQL Server and PostgreSQL queries.

●Well versed in ETL SSIS Transformations.

●Good in Initial load and incremental load concepts. Experienced in creating slowly changing dimension (SCD) models.

●Have good knowledge on Python. Data exploratory analysis using python.

●Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.

●Mentored and trained users whenever new updates in Tableau

●Exceptional ability to quickly master new concepts and technologies. Have knowledge on Big data, Spark, PySpark, apache airflow.

●Worked on the Agile sprint model.

●Good working knowledge on Azure Cloud with certification.

●Good knowledge on Data Science and machine learning with certification.

●Good in trouble shooting with quick turnaround in fixing the issues.

●Good Team player working in groups as well as independently with excellent interpersonal skills.

●Strong verbal and written communication skills.

EDUCATION

Masters: Indian Institute of Technology (IIT), Chennai 2004-2006

CERTIFICATION

AZ-900 Azure Cloud Fundamentals

IBM Data science professional certification.

IBM - DB2 Fundamentals

Associate in P&C Insurance.

CAREER SUMMARY

Project 1:

Nielsen, Chicago

Sr. Tableau Developer Chicago, IL Sept 2019 – Current

●Created various Tableau dashboards for the management to depict customer Purchase data.

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

●Created Pareto chart to depict customer purchase behavior.

●Worked on Bullet charts to show the actual sales vs target sales for various Retail stores.

●Worked on Box and Whisker plots, control charts to identify outliers to assist Data science teams.

●Worked on various custom charts like donut, bar in bar, Gantt charts, water fall charts etc.

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

●Created sites, user groups and permissions for various dashboards

●Developed various methods for deriving Key Performance Indicators (KPIs) at various stages of data pipelines in order to build End user dashboards.

●Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

●Used functions like filter, split, rename, pivot, join, and union to clean and shape data in Tableau Prep.

●Have installed Tableau server and created sites and user groups and permissions.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Prepared functional use cases by gathering requirements from business users and representatives.

●Followed Scrum Methodology – iterative planning, weekly sprints, incremental and test-driven development, and quality assurance.

●Assisted Data Scientists by providing preprocessed data using various data wrangling techniques in python.

●Took trainings to internal and external teams.

Environment/Tools: Tableau Prep, Tableau, Power BI, Microsoft Azure, Python, Postgresql, MS SQL Server, Github, Jira, Kanban.

Project 2:

Alliant Energy, Madison Apr 2019 – Sept 2019

Project involves Data modelling, writing SQL Stored Procedures, Data analytics and designing numerous interactive dashboards, authoring reports depicting various Key Performance Indicators (KPIs) to facilitate the Upper Management to take important decisions.

Role: Sr. Tableau Developer

Responsibilities

●Performed development activities from gathering requirements, designing solutions, through developing reports, to testing publishing.

●Acting as an expert in Data Interoperability, Analytics and BI.

●Involved in creating dashboards by extracting data from different sources.

●Created Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization. Designed and developed multiple charts types, Trends, custom requests.

●Created Pareto chart to depict customer utility payment patterns.

●Worked on Bullet charts, Box and Whisker plots, control charts

●Worked on various custom charts like donut, bar in bar, Gantt charts, water fall charts etc.

●Performed Tableau type conversion functions when connected to relational data sources.

●Worked on SSIS and Tableau-prep tools for Data pre-processing.

●Created incremental refreshes for data sources on Tableau server.

●Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change,

●Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

●Created report schedules, data connections, projects, groups in Tableau server.

●Mentored business users on how to create dashboards etc.

Environment: Tableau Desktop, Tableau server, PL/SQL, T-SQL, Postgresql, SQL Server, Python

Project 3:

Citadel, Chicago July 2017 - Mar 2019

Sr. Tableau Developer

Worked as Tableau end to end resource in HRIT Analytics, involving planning, administration, various KPIs related to Human Resources in various businesses, worked with compensation data, recruitment analytics etc.

●Consulting with other designers, end-users, and managers to determine the scope and need for different data visualizations.

●As an admin managed users and groups, permissions, scheduling, subscriptions etc.

●Continuously monitoring the performance of the tableau reports/views. Fixing the long running views for a better performance.

●Developed recruitment Analytics Dashboards,

●Developed compensation Analytics Dashboards,

●Worked as Tableau admin managing User groups and permissions, Scheduling data source.

●Installed and configured Tableau server.

●Creation of data sources from various input points.

●Data cleansing activities

●Job Application Questionnaire Dashboards

●Campus Recruiting Dashboards

●Worked on SSIS and Tableau-prep tools for Data preparation work.

●Presentation of KPIs to the management.

Environment: Tableau Desktop, Tableau server, Tableau Prep, PostgreSQL, SQL Server, Python.

Project 4:

Shire, Chicago Apr 2016 – July 2017

Project involves Data analytics and designing numerous interactive dashboards, authoring reports depicting various Key Performance Indicators (KPIs) in Tableau to facilitate the Management to take important decisions.

Role: Sr. Tableau Developer

Responsibilities

●Analyzing the requirements for Reporting needs.

●Creating interactive dashboards by extracting data from different sources.

●Blended data from multiple databases into one report.

●Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change,

●Worked as tableau admin, maintaining users, groups and their permissions.

●Involved in creating a dual-axes bar chart with multiple measures.

●Involved in extraction, transformation and loading data directly from different source systems like flat files, Excel, Oracle and SQL Server.

●Raised issues to Tableau support team.

●Created report schedules, data connections, projects, groups in Tableau server.

●Served as a primary point of contact for Production Support issue resolution

●Excellent analytical and problem solving skills.

Environment: Tableau Desktop 10.2,10.1, Tableau server, Cognos, Qlikview, PL/SQL, T-SQL, Oracle, SQL Server, Python

Project 5:

Blue Cross Blue Shield Association, Chicago Nov 2013 – Apr 2016

Project involves Data analytics and designing numerous interactive dashboards, authoring reports depicting various Key Performance Indicators (KPIs) to facilitate the Upper Management to make important decisions. Projects also include Migration from Cognos to Tableau.

Role: Cognos Developer

Responsibilities

●Involved in Authoring various dashboards by extracting data from different sources.

●Created Dashboards to help managers to identify critical KPIs and facilitate strategic planning in the organization. Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management.

●Creating, enhancing and maintaining Framework Manager models to support business requirements.

●Heavily worked on Cognos Report Studio reports.

●Created various kinds of Filters, List reports, Cross tab and sub queries.

●Worked on Cognos 8 to Cognos 10 migration.

●Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

●Served as a primary point of contact for Production Support issue resolution

●Possesses Problem solving / troubleshooting experience /skills to assist Production Support in issue resolution

●Proven ability to independently champion business intelligence principles with business owners, application owners, data analysts and DBAs

Environment: Cognos, PL/SQL, T-SQL, Oracle, Vertica, SQL Server, Teradata, Java, MS Excel.

Project 6:

State Farm Mutual Automobile Insurance Company Mar 2012 – Nov 2013

Bloomington

Project involves creating Framework Models, Designing various multi-dimensional reports, scheduling jobs, Creating active reports, interactive dashboards depicting KPIs of Insurance sales and claims, and banking needs, migration from Cognos 8 to 10 and creating SQL Stored Procedures, database packages etc.

BI Developer

Responsibilities

●Involved in creating dashboards by extracting data from different sources

●Created dashboard using parameters, sets, groups and calculations.

●Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

●Involved in creating calculated fields, mapping and hierarchies.

●Created drill through reports in dashboard.

●Involved in creating data blending in case of merging different sources.

●Involved in creating a dual-axis bar chart with multiple measures.

●Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel,

●Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.

●Involved in creating The Line of Business Analysis report contains several combination charts that provide an executive with an overview of personal, commercial insurance.

●Provided training to power users in Analysis Studio and Report Studio.

●Involved in installation and configuration of Cognos BI Server, Framework Manager, and Powerplay Transformer.

●Involved in creating a Regional Analysis dashboard with which insurance executives can easily view performance across states and regions through a wide range of mapping capabilities.

●Scheduling and distributing reports through Schedule Management in Cognos Connection.

●Worked closely with the ETL Developers in designing and planning the ETL requirements for reporting, as well as with business and IT management in the dissemination of project progress updates, risks, and issues.

●Supported various existing applications in production environments.

Environment: Cognos10.(Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, Active reports, Business Insight, Business insight advanced), Powerplay Transformer 7.4, DB2,SQL, PL/SQL.

Project 7:

United Services Automobile Association (USAA) May 2010 – Feb 2012

Project Involves creating data models, authoring numerous reports, dashboards for various business needs for sales, claims for Banking and Insurance.

Role: Lead Cognos Developer

Responsibilities

●Involved in Requirements gathering interacting with Business Users, and other stakeholders.

●Designed Cognos data models in Framework Manager with different views (Database View, Business View, presentation View) using Oracle 11g as per business requirements.

●Developed Multi-dimensional models in Powerplay Transformer.

●Developed Powerplay Cubes for Insurance needs to do the multi-dimensional analysis.

●Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.

●Created active reports to provide an interactive analytic experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.

●Involved in creating Production, Underwriting and Claims Overview dashboards which provides a high-level overview of many business key indicators.

●Created report studio reports to facilitate Underwriting (Policy Type) Analysis by State.

●Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.

●Involved in creating The Line of Business Analysis report contains several combination charts that provide an executive with an overview of personal, commercial insurance.

●Provided training to power users in Analysis Studio and Report Studio.

●Involved in installation and configuration of Cognos BI Server, Framework Manager, and Powerplay Transformer.

●Scheduling and distributing reports through Schedule Management in Cognos Connection.

●Worked closely with the ETL Developers in designing and planning the ETL requirements for reporting, as well as with business and IT management in the dissemination of project progress updates, risks, and issues.

●Supported various existing applications in production environments.

Environment : Cognos 8.4, (Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, Active reports, Business Insight, Business insight advanced), Powerplay Transformer 7.4, DB2,SQL, PL/SQL.

Project 8

AXA, UK Aug 2006 – May 2010

AXA Insurance Company expertise is reflected in a range of products and services adapted to the needs of each client in three major business lines: property-casualty insurance, life & savings, and asset management.

Role Mainframe developer

Responsibilities

The existing Personal Lines policy processing systems are to be replaced with the AXA Ireland. New Claims System (NCS) is replacing the existing legacy claims systems

●Change Request development

●Code management

●Debugging and code fixing.

●Integration of the code.

●Development

●Unit testing

●Integration testing

●Preparing system test cases

●Warranty support

●Production support

Environment

IBM Mainframes, COBOL, JCL, PL1, SQL, DB2, SPUF, File Aid, ISPF, Xpeditor

KEY I.T. SKILLS AND TOOLS

Database

Oracle, MS SQL Server, PostgreSQL, Teradata

Operating Systems

Unix, Window

Business Intelligence Tools

Tableau Desktop, Tableau server, Tableau Reader, Qlikview, IBM Cognos 10.1, SSRS, Power BI

Big Data

HDFS, MapReduce, Pig, Hive, Sqoop, Spark

Web Servers

IIS,IE, SharePoint

Application Servers

Tomcat, Apache

ETL Tools

SSIS, Informatica 9.1.0, Power center,

Data Modelling

Erwin 4, MS Visio

Programming Languages

Python,VBA, PL/SQL, Java, JavaScript, R, SAS,

Contact this candidate