Data Project Management

CHANUKYA RAO M

Lead Tableau Developer

Email: **********@*****.*** Phone:617-***-****

PROFESSIONAL SUMMARY:

7.5 Years of BI experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse/ Data Marts and Business Intelligence.

About 7years of extensive Tableau Experience in Enterprise Environment that includes 8.x/9.x/10.1versions as a developer and Administrator.

Extensive experience in developing tableau reports inInsurance and banking domains.

Experienced usingSQL Server, Hadoop, Alteryx, Informatica etc.

Strong experience with RDBMS systems like Netezza, MySQL, DB2.

Designed several business dashboards and In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Exposure to various Project Management methodologies with a thorough understanding of Waterfall and Agile (Scrum) concepts and techniques and tools like Jira.

Successfully upgraded Tableau platforms and ensured functionality is working during upgrades.

Skilled in Tableau Desktop for data visualization, reporting and Analysis; Bubble Charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.

Designed Tableau dashboards using Hierarchies, filters, calculated fields, Sets, Groups, and Parameters etc.

Improved Reports performance in Tableau dashboards using extracts and context filters.

Expert in creating semantic layer in Tableau desktop and often used data blending to connect to different databases.

Solid understand of SQL, and have worked with various data source types like Oracle, SQL server, Microsoft Access databases, and Excel Spreadsheet.

Experience in configuring reports from different data sources using data blending.

Experience in Software Development Life Cycle (SDLC) that includes providing documentation on design, testing and migration from development to production.

Worked closely with the Data Warehouse team and Business Intelligence team to understand

repository objects that support the business requirement and process.

Experience in developing test plans and test cases/scripts documentation and User Acceptance Testing (UAT) to yield system validations against documented requirements.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Tools &Techniques: Business Intelligence, Data Analysis, Data Warehousing, Project Management, User Stories, Requirement Elicitation, Wireframes, JAD Sessions,

Database: MySQL, Oracle, SQL Server, Netezza.

ETL &Reporting: SQL,ODI, Tableau, Informatica.

Functional Area:HealthCare, Banking, Finance

Project Management Methodologies – Standard SDLC, Agile (Scrum),

Languages: C++, Unix Shell, XML, HTML, PL SQL.

Operating Systems: Windows, LINUX & OS X.

State street Corporation, MA Dec 2015 – Nov 2017

Lead Tableau Developer

Responsibilities:

Responsible for creating the complex Analytical, Executive and operational Tableau Reports.

Used to connect to live databases and creating the Tableau data extracts for creating the workbooks.

Connected to multiple data sources (excel files, flat files, SQL Server) to do analytics in Tableau Desktop and creating the Data extracts and data sources, publishing to Tableau server.

Major responsibilities include getting requirements from the user and developing in Tableau.

Extracting data from different sources connecting them and used the same to create dashboard.

Worked on updating Tableau server from 9.3 to 10.1.

Assisted BI team in learning Tableau and addressing development roadblocks.

Extracted data from different databases and source systems like flat files using ETL tools .

Worked on Designing, developing and deploying Tableau scripts to import data from source systems and deploy Tableau dashboards

Created Sales and Marketing Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.

Developed visualizations using sets, Parameters, Calculated Fields, table calculations, Dynamic sorting, Filtering, Parameter driven analysis and developed the dual axis charts for multiple measures.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Development experience with strong understanding of Tableau Architecture and Administration.

Worked with team on creating materialized views.

Good experience with Tableau installations, configurations and administration, performed troubleshooting.

Coordinated daily activities with the IT Developers, QA and Product teams along with the project management group.

Wrote Test Cases and Test plans and developed strategies with Quality Assurance group to implement them.

Extensively worked with Quality Analysts to make sure that the functionality meets requirements.

Defined best practices for Tableau report development.

Environment: Tableau 9.3,10.1, SQL Server, Oracle, Informatica, Microsoft Office Suite (Word, PowerPoint, Excel), HP Quality Center.

Fresenius Medical, MAOct 2014– Nov 2015

Tableau Developer

Responsibilities:

Design and develop new Tableau dashboards.

Interact with business users in gathering, analyzing and documenting the business requirements and translate them into KPI's and metrics for reporting.

In-depth understanding of Tableau concepts such as Level of Details, Analytics, Joins & Blends and Extracts.

Data modeling as per reporting needs and provide requirements to data team.

Create variety of data visualizations like Bar graphs, Line charts, Trend Views, Scatter Plots, Heat Maps, Pie Charts, Page Views, Print Views, Crosstab, Tabular Reports etc.

Extensive use of Joins, Blending, Custom SQL, Attributes, Hierarchies, Action Filters, Extract filters, data source filters, Parameters, Table Calculations, LOD expressions, Sets, Groups, Bins in Tableau Desktop.

Use of parameters, transformations, custom visual charts.

Publishing various kinds of live, interactive data visualizations, dashboards, reports and workbooks from tableau Desktop to Tableau QA & Prod Servers.

Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.

Built Tableau visualization for distribution and predictive analysis.

Semantic views are built combining various sources; it is used as report feed for Tableau dashboards.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple functional business units responsible for operations and strategic decision making.

Optimizing dashboard sizing requirements for end user's Laptop, Desktop and Mobile phone.

Performance tuning for faster rendering of existing dashboards handling large volume of data.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Coordinated daily activities with the IT Developers, QA and Product teams along with the project management group.

Environment: SDLC, JIRA, Tableau8.1,8.2, MS Visio, OBIEE, Netezza, MS Office Suite, HP Quality Center, MS Project planner

Medicover Insurance, Pune. Feb 2011 – Jul 2013

BI/ Tableau Developer

Responsibilities:

Worked as a liaison gathering business requirements, problem definitions, analyzed and documented business processes by communicating with stakeholders.

Data analysis and Reporting - Visualize, summarize and communicate discoveries to the stakeholders, using BI Reporting tools such as Tableau, and Excel Pivots.

Performed analysis of existing Capital Asset processes and develop data mapping specifications to create Informatica extract maps and workflows to populate the Access Layer data warehouse

Creation of metrics, attributes, filters, reports, and dashboards.

Developed advanced chart types, visualizations and complex calculations to manipulate the data.

Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time and location dimension.

Developed different types of Tableau reports including: histogram, Control charts, bar in bar, Donut charts and Pareto charts.

Performed best practices during implementation and integration of Tableau Platform

Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain status.

Developed visuals like Gantt. Chart, scatter plot with drill down and navigational functionalities.

Incorporated multiple data sources to develop a dashboard.

Connected Tableau server to publish dashboard to a central location for portal integration.

Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.

Documented the Technical Requirement of the Instances for installation on Tableau server on cloud.

Created, maintained & scheduled various reports like Tabular Reports, Matrix Reports.

Use of parameters, transformations, custom visual charts.

Worked with QA team and UAT team to go over the various test scenarios.

Environment: RUP, UML, JIRA, Tableau,Pivot tables, Informatica, SQL,, MS Visio, MS Office Suite, HP Quality Center, MS Project planner

Yagna Technologies, Hyderabad, IndiaAug 2010 – Feb 2011

BI Analyst

Responsibilities:

Responsible for full cycle of reporting solutions from definition, design and implementation of the data visualization solution.

Created complex dashboards combining different charts, tables, calculated fields and maps.

Created Slowly Changing Dimension Type II maps using Informatica loading multiple sources defaulted residential/commercial loans into the Oracle staging tables

Worked on Data Model design, Data Extraction, Transformations and Loading, Mapping Workflows and Customized Analytics Reports.

Worked on data Extraction, Transformation and Loading (ETL) which helped to easily move and manipulate data from heterogeneous environment.

Extracted data from data warehouse and generated client desired data using various formats like CSV, Excel, or Access

Prepared test case, Test scripts from the data mapping documents for semantic views and validated data from source to target.

Environment: SDLC, JIRA, SQL, MS Office Suite, HP Quality Center, MS Project planner

EDUCATION:

MS in Engineering Management from Old Dominion University (ODU), Norfolk, VA 23529

Bachelor of Technology from ICFAI Business School, INDIA.

Contact this candidate