SUMMARY:

• 6 Years of IT experience as Tableau Developer, Business / Data Analyst with expertise in Data visualization, design and report development in Business Intelligence (BI).
• Strong knowledge of BI data modeling, high level architecture design, business processes and Analytical solutions.
• Experienced in analyzing the customer requirements and transform them into Tableau Dashboards.
• Experienced in using Tableau Desktop, Tableau Server and good understanding of Tableau Architecture.
• Utilizing tableau to implement analytical solutions accessing and integrating data from multiple sources.
• Extensive experience in creating highly interactive Data visualizations and Dashboards using tableau features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, LOD’s etc.
• Analyzing data sources/warehouse - SAP, SAP BI, SQL Server, Oracle, Excel and flat files for design, development, testing, reporting and analysis projects within Tableau.
• Generate and publish Tableau dashboards based on Product/leadership requirement.
• Develop ad-hoc SQL queries for analysis and studies to answer business questions.
• Provide Business Intelligence and Data Analytics/Visualization by Developing/Designing interactive Dashboards.
• Strong business analysis skills and understanding of Project life cycle and SDLC methodologies including Waterfall, Agile and Scrum.
• Strong Analytical, solve problems, Prioritize Deliverables and Manage Project Scope with Business Customers. A very quick learner and adapt to new technology with ease.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 9 /10.X .2, Tableau Server, Tableau Online, Public, SQL Server, SAP Business Objects 4.x

ETL: Informatica, SAP Data Services

Databases: SQL Server, Oracle, Teradata & MS Excel

Languages: C, C++, SQL

Soft Skills: Strong analytical, problem solving and documentation skill

PROFESSIONAL EXPERIENCE:

Confidential, Fort Mill, SC

Tableau Developer

Environment: SAP ERP, Workday, Sales Force, Ariba, DRM, MS Excel files, SAP BW, Business Objects, TableauInformatica, SQL Data Base.

Reporting tools - Tableau and Business Objects

Responsibilities:

• Interacted closely with the Business users to gather the business requirements, prepare design documents and performed Gap Analysis for requirements.
• Interacted with Strategic Development Team, Business analyst and Managers to analyze business needs and developed technical specifications.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Create and modify Interactive Dashboards and analytical reports using KPI's from multiple data sources and provided navigation features through Tableau actions.
• Designing dashboards with the use of visualization tools like Tableau Using SQL for managing large volume of data.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS)
• Interacted with the existing database developers and DBA to understand the existing schema.
• Communicating with Finance and Supply chain customers to analyses historical data and identify KPIs.
• Improving data processing speed by building SQL automations and optimizing SQL Queries for best performance.
• Implementing Tableau mobile dashboards with the help of Tableau mobile application.
• Created Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Built SQL views and tables in Oracle SQL developer and Microsoft SQL Server to obtain the required data and Fine \tuned SQL Queries for maximum efficiency and performance.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Data extraction from various ERP’s and source systems - SAP, Workday, Ariba, SQL Data base, Business provided excel files and flat files.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Experienced in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database, also involved unit testing and bug fixes.

Confidential, Atlanta, GA

Tableau Developer / Business Analyst.

Environment: Oracle ERP, EPBCS, DRM, Big Data Hadoop, Teradata, SQL Database, TableauInformatica, SQL Data Base.

Reporting tools - Tableau & SAP Business Objects (BOBJ WebI)

Responsibilities:

• Gathered Business requirement and create a reporting solution for users to perform analytics and ad-hoc reporting for business applications.
• Involved in data preparation, data blending, and the creation of data models sets.
• Experienced in designing Interactive worksheets and dashboards integrating various reporting components from multiple sources.
• Created action filters, context filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Financial reports to show variance between Actuals and Budget / Forecast, Month-to-date (MTD), Year-to-date (YTD and Full Year (FY) comparison views.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts using Tableau Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Developed dashboards using Tableau Live and Extract Connection.
• Designed various extract from different data source like Database, Excel, Text etc.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to the different user community.
• Making sure the team delivers reports as per the requirements.
• Analyzing the data to identify trends and share insights to business community.
• Designing dashboards with the use of visualization tools like Tableau Using SQL for managing large volume of data.
• Communicating with Finance and Sales customers to analyses historical data and identify KPIs.
• Performed on data Integration of Tableau with RedShift, Hadoop and Cloud data platforms.
• Performance tuning on SQL Queries for best performance and Improving data processing speed by building SQL automations.
• Implementing Tableau mobile dashboards with the help of Tableau mobile application.
• Extensively used tableau features like Filters, parameters, calculations, context filters, Hierarchies, Actions and LOD’s as per requirement to build the tableau visualizations.
• Implemented Fixed/Include/Exclude LODs to pass the filters from front end to Tableau through tableau API for IR Visualizations.
• Created/Published LIVE, extract connections as per the business requirements, and scheduled tableau extracts on tableau server.

Confidential, Pittsburgh, PA

Tableau Developer / Data Analyst

Environment: Reporting tools - Tableau, SAP Bex, Web Application Designer, Business Objects SQL Data base, SAP BW, CRM - Trade Promotion Management (TPM)ECC - COPA, Sales, Finance, IM, HTP Planning and SPM (Spend Performance Management)

Responsibilities:

• Understanding the KPIs and Requirement Documents.
• Created various interactive reports & dashboards using Excel/Access & PowerPoint.
• Involving in interacting with business users and understand GAP analysis according to the client requirements.
• Daily meeting with team members and stakeholders and gathers the requirement.
• Reviewed business requirements and analyzed data from various sources like SQL Database, SAP Business Warehouse, Excel and Project Dump for analyze, testing and development the project.
• Prepared various report (Finance Income Statements, Profitability Analysis, Project systems, SRM Purchasing reports) and scheduled according the client’s requirements.
• Review the customer data for deficiencies or errors, correct any incompatibilities, if possible and check out generated report and perform.
• Coordination with stakeholders, internal and outer team members.
• Monitored Project report /Cristal management report and prepared the dashboard as per the client requirements.
• Experienced in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.
• Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.

Confidential

Software Engineer

Responsibilities:

• Worked as an Informatica Developer, worked on designing & developing data models by using Erwin.
• Interacted with Business Analyst to understand the business requirement.
• Identifying relevant source systems of the customer and extracting the data from source system.
• Created mappings to extract data from different source systems, transform the data and then load to data warehouse.
• Developed various mappings using transformations like lookup, joiner, router, update strategy, Union, source qualifier, stored procedure, rank, expression and aggregator.
• Preparing Unit test plan for the components developed and unit testing.
• Transforming the knowledge gathered from running specific models into actionable insights that could be readily deployed in the business cycles.
• Performance tuning of the ETL jobs by identifying the bottlenecks.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Collected and collated appropriate data for use in databases and conduct related research.
• Coordinated with Business Analysts to convert Functional Requirements into technical Specifications.
• Developed Year End reports using Sub queries, functions and procedures in PL/SQL and Oracle Reports Developer.
• Developed triggers and indexes for efficient data management.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.