Resume

BI Tableau developer/ Data Analyst

Location:

Hyderabad, Telangana, India

Posted:

May 23, 2017

Contact this candidate

Resume:

Vanathy

Sr. Tableau Developer / Sr. Data Analyst

SUMMARY

•Overall 9 + years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment.

•3 years of extensive experience in Tableau Desktop/ Tableau Server, creating highly interactive Data visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.

•Expertise in BI/Data Warehousing concepts, designs, and project implementations.

•Sound knowledge of Retail, Health Care, Insurance, Telecom and Financial industries.

•Certified developer in Tableau 9.x product suite (Desktop, Server, Public, Reader, Mobile).

•Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

•Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

•Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications

•Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.

•Experienced in preparing Business Process Re-engineering Models.

•Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.

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

•Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

•Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

•Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.

•Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.

•Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.

•Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.

•Expertise in BI/Data Warehousing concepts, designs, and project implementations.

•Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

•Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.

•Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.

•Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.

•Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirements

TECHNICAL SKILLS

BI Tools : Tableau 10.1, MicroStrategy, Qliksense, Business Objects, SSRS

ETL Tools : Informatica, Data Stage, Microsoft SQL Server Integrated Services

Requirements Management : Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Change Management : HP Open View, CA Service Manager, Lotus Notes

& Service Management

Front End Tools : Microsoft Project, Microsoft Office, Visible Analyst

Databases : NoSQL, Oracle, SQL Server, DB2, Sybase, Access

Document management : Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool : HP Quality center 10.0

Scripting Languages : C, C++, HTML, SQL, PL/SQL and XML

Data modeling : Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Data Analyst/Tableau Developer June 2016 – Present Johnson & Johnson, Bridgewater NJ

Johnson & Johnson(JNJ) is the world's most comprehensive and broadly based manufacturer of health care products, as well as a provider of related services for the consumer, pharmaceutical, and medical devices and diagnostics markets. The lateral business units of JNJ Supply chain required an overall analysis of the financial data and thereby allocate the budget across the various domains.

Reponsibilities:

•Requirements gathering for updating current tableau dashboards with business users from various business segments of J&J

•Developed data quality analysis by creating metrics for various business rules in financial reports

•Created C-level KPI dashboards with interactive visualizations

•Installed, configured and maintained tableau environments in Dev, QA and Production as Tableau admin

•Using R for financial forecast modelling that will give insights on spending trends

•Validated, Tracked and analyzed the data to ensure correctness of data calculations ($ Values) for accurate representation in Tableau reports

•Created User filters and row level security for tableau users

•Convert Tableau dashboards to Qliksense and updating additional features from Qliksense for POC

•Preprocess the raw data from Instantis and applied Tableau to create meaningful Tableau visualizations

•Maintained the data integrity from source to target systems and also profiled the data to identify unanticipated business rules

•Forecasting the financial situation to assist the client in decision making

Environment: Tableau v9.3 and 10.1 (Desktop, Server),Qliksense, Teradata, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

McKesson, Dallas,TX Feb 2016- May 2016

Data Analyst/ Tableau developer

McKesson Distribution Solutions delivers pharmaceutical and medical products and business services to

retail pharmacies and institutional providers like hospitals and health systems throughout North America

and internationally. This project was specifically focused on the distribution of these SaaS products and performance analyses of the audit process. McKesson has established a Digital distribution system for these SaaS products and wanted to analyze the usage and distribution of these software products from vendors to client.

Reponsibilities:

•Analyze the business requirements for report development on SaaS products that are distributed through the DDS

•Developed audit, provisioning and user performance analyses reports of these Saas products in tableau

•Provided 24/7 support on these reports for Tableau Users

•Restricted the data for particular users using row level security and user filters

•Developed Tableau dashboards and visualizations using various actions, filters, parameters and calculations

•Interacted with the existing database developers and DBA to understand the existing schema.

•Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.3) reports

•Developed various tableau BI charts on assortment planning and reporting

•Created parameters, calculated fields, various filters and groups to facilitate different views on dashboards.

•Designed geographical maps with multiple LOD level of details

•Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool

•Actively participated in clarification meeting with the Clients

•Executed and tested required queries and reports before publishing.

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

•Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.

•Responsible for Developing Dashboard and preparing ad-Hoc Reporting.

Environment: Tableau (Desktop, Server), MS Access 2010,VBA, SSMS, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Home Depot., Atlanta,GA Aug 2015 – Jan 2016

Data Analyst/ Tableau developer

The Home Depot® is the world's largest home improvement specialty retailer, with more than 2,200 retail stores in the United States. Their assortment planning solution provides a foundation that will enable a number of further decision support and business process improvements. Based on the existing analytics, they have seamless ability to evaluate assortment changes at both the national and local level. This project is to perform financial analyses of assortments based on their performance and developing exception reports for merchants in both Tableau and MS Access platforms.

Reponsibilities:

•Understand the business requirements for report development on exceptions and financial reports

•Developed and deployed merchant friendly UI to generate assortment exception reports

•Created modules and pass through queries to access the DB2 environment source data

•Optimized the performance of the queries by passing the parameters based on the merchants selection from the UI

•Developed financial reports in tableau for understanding the assortment based on performance

•Used Tableau Desktop for blending databases and create interactive views and dashboards

•Resolved the data blending issues based on data from multiple sources

•Developed various tableau BI charts on assortment planning and reporting

•Created parameters, calculated fields, various filters and groups to facilitate different views on dashboards.

•Involved in the end to end analysis of the data from the source to the correctness of the reports

•Developed sales reports from Teradata on store wise performance and filtering them on top sales

•Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.

•Actively participated in clarification meeting with the Clients

•Executed and tested required queries and reports before publishing.

•Converted metric insight reports to tableau reports.

•Analyzing the data using Statistical features in Tableau to develop trend analysis.

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

•Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.

Environment: Tableau (Desktop, Server), MS Access 2010,VBA, Teradata, SQL, Teradata SQL Assistant, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Hanger Inc., Austin,Tx Sep 2014 – July 2015

Data Analyst/ Tableau developer

Hanger, Inc. is the world's premier provider of orthotic and prosthetic (O&P) services and products, offering the most advanced prosthetics and orthotics, clinically differentiated programs and unsurpassed customer service. Hanger, Inc. comprises nine business units that serve different segments of the O&P industry. The project is to perform impact analysis of changes in source data of existing Oracle Business Intelligence Reports as a part of Inventory Remediation project and implement Tableau reporting solutions for all on going and future reporting requests.

Responsibilities

•Gathered business requirements from external source systems to develop a new Inventory Valuation process.

•Analyzed the changes to the existing source systems to OBIEE reports as a part of inventory Remediation project

•Documented the daily ETL job process and its dependencies from source to datamarts

•Created Source to target mapping documents for clinical data and documented schema changes for ICD-10 implementation.

•Analyzed and documented the existing functional ETL processes and validated its business logic with the reports.

•Worked with the data warehouse team and coordinated team meetings to facilitate knowledge transfer of the production systems to new team members.

•Proactively developed process flow diagrams to the existing process and organized and shared the information across teams for various projects

•Adhered with all the project timelines and BRD approvals from business users, project managers and director

•Analyzed and coordinated meeting with vendors of commercially available data warehouse tool.

•Analyze, define and document requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks, controls and outputs.

•Coordinating meetings to analyze the business requirements and document the business logic in SQL scripts.

•Prepared enterprise data sources for use with Tableau, including non-structured, dimensional, and relational sources.

•Involved in drawing upon full range of Tableau platform technologies to design and implement proof of concept solutions.

•Developed prototype reports for various requirements using Tableau and presented the same to business users.

•Developed and standardized the best practices in dashboard design and layout in terms of fonts, colors, container selection and size, incorporating the titles and logos in the right places, etc.

•Developed Trend charts, Pareto charts, Bubble charts and Pie charts, and actions involving hyperlinks and filters to connect different vizs within a dashboard and to connect other dashboards which utilize the same worksheets.

•Turned data sets into models, tools, and pictures that solve business problems.

•Trained and mentored power users to develop reports using Tableau Desktop.

•Provided on-going analytical and technical support including maintenance and support of existing data sources, data integration, operational reports and dashboards.

Environment: Tableau (Desktop, Server), OBIEE, Informatica, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

TD Bank, NJ Aug 2013 – Aug 2014 Sr. Tableau Developer/ Sr. Data Analyst

TD Bank offers a broad array of retail, small business and commercial banking products and services to millions of customers through its extensive network of thousands of convenient locations and ATMs throughout the Northeast, Mid-Atlantic, Metro D.C., the Carolinas and Florida. The project was to combine various data streams to provide better analysis on request for proposals and budget forecasting via Tableau Desktop.

Responsibilities:

•Effectively interacted with data modelers and defined the mapping requirements from source to target.

•Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production

•Actively involved in new KPI generation for tableau Scorecards.

•Data collection and leveraging on data manipulation teams for required data.

•Identify new metrics and enhance the existing KPI's.

•Working extensively with Tableau Business Intelligence tool to develop various dashboards.

•Working extensively using Excel to validate the data and use as the source data files.

•Dashboard Visualization through Tableau BI application.

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

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

•Effectively used data blending, filters, actions, Hierarchies feature in tableau.

•Defined best practices for Tableau report development.

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

•Executed and tested required queries and reports before publishing.

•Converted metric insight reports to tableau reports.

•Analyzing the data using Statistical features in Tableau to develop trend analysis.

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

•Worked with Teradata database and pull data to work on BI requirement.

•Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop, Server), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Blue Ridge, GA Apr 2012 – Jul 2013

Sr. Tableau Developer/ Sr, Data Analyst

Blue Ridge helps retailers enhance customer experience and capture every sale by ensuring that the right products are where they need to be exactly when customers want them. The project was focused on creating dashboards using tableau to improve their merchandising insights and sales growth initiatives.

Responsibilities:

•Interacted with business users and performed Gap Analysis of Client requirements.

•Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.

•Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.

•Worked closely with business power users to create reports/dashboards using tableau desktop.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

•Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

•Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

•Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

•Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

•Actively involved in Setting up Tableau Environment.

•Worked with key business data to understand and analyze the customer data

•Creating Visualizations in tableau using Excel, DW and SharePoint data.

•Involved in report tuning, caching, specifying query governing thresholds, and report optimizations

•.

•Created Test Cases and documented the Test Results.

•Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

•Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS VISIO, Microsoft Office Suite (Word, PowerPoint, Excel).

Zurich Insurance Group, Schaumburg, IL Oct 2010 - Mar 2012

Sr. Data Analyst/ Business System Analyst

Zurich Insurance Group (Zurich) is a leading multi-line insurer that serves its customers in global and local markets. It provides a wide range of general insurance and life insurance products and services serving the global corporate, large corporate, middle market, specialties and programs, sector through the individual member companies of Zurich. The company hosts a very large database system and other operational databases. A central data repository is setup to capture metadata about many internal operational information sources.

Responsibilities:

•Interacted with business users and performed Gap Analysis of Client requirements

•Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.

•Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.

•Worked extensively with MS Visio and Rational tools to document requirements.

•Created the AS-IS and TO-BE process flow diagrams.

•Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions

•Defined functional business requirements, analyzed client requirements, and generated workflow processes

•Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.

•Assisted in project management activities like planning, development, task allocation, project execution

•Provided full project life cycle flowcharting, analysis and documentation.

•Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.

•Designed, developed, and tested the jobs, using Data Stage

•Involved in the some part of performance tuning.

•Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.

•Created Data Definitions and help maintain Metadata repository.

•Utilized Erwin for reverse engineering the database from DDL scripts.

•Experience in using MicroStrategy in creating and managing reports for an organization.

•Created documentation, worked with users for new module enhancements and testing.

•Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.

•Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

•Defined project milestones, schedules, monitoring progress and updating plans using MS Project.

•Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Traveler’s Insurance, Hartford, Connecticut Nov 2009 – Sep 2010

BI Developer/ Data Analyst

Travelers is an insurance leader, committed to keeping pace with the ever-changing needs of our customers, and anticipating their needs for the future. The company hosts a very large database system and other operational databases. A central data repository is setup to capture metadata about many internal operational information sources.