Sivakumar

Sr. Data Analyst/ Sr. Tableau Developer

acvli1@r.postjobfree.com, 630-***-****

SUMMARY:

* ***** ** ** ********** in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools in Healthcare, Retail, Finance and Technology industries.

4 years of extensive experience with design and development of Tableau visualization solutions.

Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (9.x/8.x/7.x) and Vizql, SQL, PL/SQL and UNIX shell scripting.

Experience in business process analysis/modeling, business requirements, and developing High level Designs for the Business applications in Agile and Waterfall implementations.

Good knowledge of Kimball/Inmon methodologies and experience in creating Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject-level) in developing star schema and snowflake schema.

Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.

Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.

Expertise in Tableau, Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, Business Objects, Unica, Google Analytics, Toad, Microsoft Office Suite.

Expertise in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.

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

Proficient in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, Donut, Waterfall, Pareto and Highlight tables.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

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

Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.

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

Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.

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.

Excellent analytical, problem solving, communication and time management skills.

TECHNICAL EXPERIENCE:

Analytical Tools

Tableau (Desktop/Server/Public/Online/ Reader) 9.x/8.x/7.x, Adobe Analytics, SSRS, Business Objects

ETL Tools

Alteryx, DataStage, Informatica, SSIS

Databases

Teradata, Oracle 11i/10g/9i, DB2 UDB, MS-SQL Server, Sybase

Requirements Management

Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools

Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management

Documentum, Visual Source Safe 6.0, Share point, Ultra Edit

Defect Management tool

HP Quality Center

Methodologies

Data Modeling – Kimball/Inmon, Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Waterfall, Agile.

Data Modeling Tools

Power Designer, ERwin, ER Studio, MS Visio

Languages

SQL, PL/SQL and JavaScript

Operating System

Windows NT/2000, UNIX (HP UX, AIX), AS/400, OS/390.

Web Applications

HTML, Perl, XML and JavaScript

Scheduling Tools

Control M, Autosys, ESP Scheduler

PROFESSIONAL EXPERIENCE:

Thermo Fisher, Allentown, PA Feb 2015 to Present

Sr. Data Analyst/ Sr. Tableau Developer

Thermo Fisher Scientific is the world leader in serving science, with revenues of $17 billion and more than 50,000 employees in 50 countries. The main focus is to enable customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics and increase laboratory productivity through their premier brands – Thermo Scientific, Applied Bio systems, Invitrogen, Fisher Scientific and Unity Lab Services. Created new Tableau Environment for Life Technologies Department and developed various dashboards on Tableau.

Responsibilities:

Gather and analyze the business requirements and then translate them to technical specifications.

Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.

Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Identify key business metrics measurements and develop methods to represent data in support of the measurements.

Provide guidance and insight on data visualization and dashboard design best practices in Tableau

Created different views in workbook to visually analyze data.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.

Developed customized calculations when required.

Worked on drill through reports by creating HTML references.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.

Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.

Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.

Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.

Embedded Tableau reports/dashboards on to the external web pages.

Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.

Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Created various schedules for dashboard refresh/extracts based on user needs

Scheduled both Data source connections and Dashboards for daily refresh/extracts.

Working with Tableau Metadata tables and Postgre SQL for system analysis and maintenance.

Environment: Tableau (Server/Desktop) 9.x/8.x, Tableau cmd, Adobe Marketing Cloud, Google Analytics, Oracle, Teradata, Java API, Microsoft Office Suite (Word, Excel, PowerPoint).

ShopRite, Keasbay, NJ June 2014 – Jan 2015

Sr. Data Analyst/ Sr. Tableau Developer

ShopRite Supermarkets is a retailers' cooperative chain of supermarkets in the northeastern United States, with stores in New Jersey, New York, Connecticut, Delaware, Maryland, and Pennsylvania. The company consists of 50 individually owned-and-operated affiliates with over 296 stores, all under its corporate and distribution arm, Wakefern Food Corporation. Wakefern itself owns and operates 33 of the locations through subsidiary ShopRite Supermarkets, and is the largest affiliate in the cooperative. The project is to implement Business Intelligence application by creating various reports, dashboards and scorecards using Tableau Reporting Services.

Responsibilities:

Gathered business requirements from end users, analyzed and documented the same for various reporting needs.

Analyze complex data from various data repositories and become familiar with user base locations.

Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.

Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.

Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.

Created side by side bar chart comparison of Vendors who were into Retail along with profit revenue generated.

Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.

Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.

Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.

Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.

Used parameters and input controls to give users control over certain values.

Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.

Created Data extracts for better performance of dashboards and accessing data offline.

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.

Integrated dashboards with live Connection in Microsoft PowerPoint.

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

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Created reports using Custom SQL for complex report views.

Executed and tested required queries and reports before publishing.

Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server)9.x/8.x, Alteryx, Oracle, MS SQL Server, SQL BI Suite (SSIS, SSRS, SSAS), Visual Studio, Java API, SQL, SQL Server Management Studio, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

ProHealth Care, Milwaukee, WI Nov 2012 – May 2014

Sr Data Analyst/ Tableau Developer

ProHealth Care is a regional critical and primary care provider with nationally recognized programs and physicians, and ranks among the most technologically and clinically advanced community health care systems in the country. The project is to implement Enterprise Data Warehouse Environment and Build some analytical reports/ dashboards from DW data.

Responsibilities:

Gathering Business and Specification Requirements from the Business users and also with the Technical team.

Providing a high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.

Create Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Models (PDM) using ERwin data modeling tool.

Create source to target mapping documents (design documents) involving the Business rules and transformation rules.

Reviewing the High Level Design (HLD) Document and Design Specification Documents provided to the ETL technical team once the Logical Data Model is reviewed and approved by the business users.

Developed SQL, Bteq (Teradata) queries for extracting data from production database and built data structures, reports.

Worked with BA in updating the source to target mappings (Data Dictionary) including business rules and transformation logic.

Coordinated with Business Analysts/Developers/Architects and other team members, attended code reviews and design walk troughs to get a grip of the whole end to end process and suggested changes wherever necessary

Added multiple checkpoints in the end to end DW process and performed checks to ensure the data flow is as expected, by running queries on the Oracle/SQL Server/Sybase.

Created Data Definitions and help maintain Metadata repository.

Designed and Developed Drill through reports, Dashboards and modified the existing Dashboards using Tableau Desktop.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created External filter, internal filter and Context filter to improve performance of tableau reports.

Utilized various tableau functionalities such as data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Created Table of Contents (TOC), a common navigation page which had all the links to various reports.

Published Workbooks and Dashboards to the Tableau server.

Used commands in Tabcmd and Tabadmin utility tool.

Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

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

Environment: Tableau (Desktop/Server), Teradata, Oracle, Bteq, PL/SQL, SQL Server 2008, Sybase, Informatica Power Center, ERwin, DB2, MS Office Suite (Word, Excel, PowerPoint)

CNA Financial, Chicago, IL Jan 2011 – Oct 2012

Sr. Data Analyst

CNA Financial Corporation is one of the largest property and casualty insurance organizations in the United States, providing insurance protection to more than one million businesses and professionals in the U.S. and internationally. The project involved working on the development of Operational data store (ODS) and Data marts to support Business Intelligence needs.

Responsibilities:

Played a key role in gathering and documenting Business requirements.

Conducted Requirement walk-through meetings with key stakeholders.

Participated in technical walk-through meetings to develop the functional design for the implementation.

Performed detailed requirement analysis and created data mapping documents

Acted as liaison between Business Intelligence and Business User groups to relay change requests.

Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.

Oversee the performance of Design to develop technical solutions from Analysis documents.

Designed the conceptual data and business process models.

Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.

Make use of data modeling techniques in designing the data marts project.

Extensively involved in Data mapping and Data modeling.

Assisted the DBA in converting the logical models to physical.

Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.

Developed mappings and workflows in Informatica to extract data files for third party vendors.

Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.

Involved in modifying Teradata stored procedures and performance tuning of various tables.

Managing metadata by mapping dimensions and fact tables of various schemas/data models

Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using ERwin Tool.

Perform application testing e.g.: of loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.

Environment: Teradata, Erwin, ER/ Studio, Informatica, Oracle, DB2, Teradata SQL Assistant, TOAD, MS Visio, MS Office Suite (Word, PowerPoint, Excel).

Medtronic, Minneapolis, MN Nov 2009 – Dec 2010

SQL Server / BI Developer

Medtronic is the world's third largest medical device company specializing in technology, services and solutions. The major scope of the project is to combine different databases into one for overview of operational costs and data is used for BI tool to make analysis of resource utilization, materials stocking levels, purchasing options, and supplier performance.

Responsibilities:

Wrote program to export as text files or PDF to outside Business Users.

Utilized SQL Queries, stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports such as sales information, deposit and payout and their incentive compensation information.

Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries

Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports

Created formulas and/or used statistical or financial functions for reports as needed.

Used SQL stored procedures, created alias data tables as required to improve report performance.

Created Stored Procedures and Views as data sources using Oracle databases for reports.

Wrote different queries and stored procedures to make our daily data

verification and conversion processes faster, more accurate and automated.

Used Optimizer HINT for tuning SQL and PL/SQL queries rewrite most of them for efficiency

Worked with DBMS_PROFILER to tune PL/SQL Procedures.

Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.

Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling

Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.

Implementing performance tuning methods to resolve issues and bottlenecks. Identifying long running queries and performing performance tuning.

Created trigger to collect the trace files to get login information.

Created Materialized Views and partitioning tables for performance reasons.

Used cursor, ref cursor, bulk collect and bulk insert (BULK BINDING) in procedure to reduce its execution time.

Environment: Microsoft SQL Server 2008, SSRS, SSIS, XML, T-SQL, SharePoint, MS Word and Excel, SQL Profiler, Toad.

Mindtree Ltd, Hyderabad, India June 2008 – Oct 2009 Business Objects Developer

Mindtree is a global information technology consulting firm specializing in corporate IT services and solutions. The project is to be part of Business intelligence team for the client - Silicon Valley Bank Financial Group and work closely with the Loans/Deposits Operations, Capital Markets, Trade Finance, Credit reporting business Groups to identify and fulfill their reporting needs.

Responsibilities:

As a team member involved in collecting all the requirements for building the database.

Developed data solutions to support company's initiatives using Relational Database models, Business Objects and Informatica.

Developed Reporting/BI Solutions, Score Cards and Dashboards using MS Excel, Business Objects WEBi, Universe, BO Explorer.

Developed complex Business Objects universes by using features like aggregate aware, Index aware, Conditions and hierarchies.

Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.

Worked on building Informatica mappings for data load from OLTP to OLAP system for reporting.

Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.

Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected and unconnected lookups, Filter transformation, and sequence generator transformations.

Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.

Used SQL, PL/SQL for database related functionality.

Worked on SQL Tuning and Optimization of the reports.

Environment: Business Objects, Informatica Power Center, Oracle, SQL Server, PL/SQL, UNIX, Windows XP, MS Office Suite (Word, Excel, PowerPoint)

Contact this candidate