PROFESSIONAL SUMMARY:

• 8 years of experience in Data warehousing and Business Intelligence technologies along with around 3 years of data visualization using Tableau.
• Expertise in Tableau 7, 8, Business Objects 4.0, 4.1, and SAP Business Intelligence 7.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Expertise in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process DTP , Multi providers and Master data Info Objects, Transfer Structures, Transfer Rules and Update Rules..
• Widely used BEx for building Queries and workbooks and preparing end user training documents.
• Expertise in front-end Components like BEx Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Worked on User exits for various variables.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS:

• DBW Tools : Tableau Desktop 7.0, 8.2, Business Objects 4.0, 4.1 and SAP BI 7
• Other Reporting Tools : SAP Business Explorer BEx Analyzer, BEx Query Designer, SAP LUMIRA
• Environment : Windows 2008, windows 2003, XP.
• Database : Oracle 9i/11g, SQL Server 2008, MS Access 2000.
• Language : VB 6, VBA, VB.NET, C .NET, HTML, SQL

PROJECTS SUMMARY:

Confidential

Role: Senior Tableau Developer/Analyst

Responsibilities

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 8.2, Business Object 5x, Amazon Redshift.

Confidential

Role: Tableau Developer

Responsibilities

• Created dashboards for analyzing POS data using Tableau 8.0.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports.
• Worked on workbook Permissions, Ownerships and User filters.

Environment: Tableau Desktop 8.0, Tableau server / Administrator, SQL Server 2008.

Confidential

Role: Senior SAP BW/Tableau Consultant

BW consultant Activities:

• Analyse and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Built and enhanced BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data,
• Transformations, and Update Rules, DSO, Extractors, Info sets, Aggregates, Process Chains, User Exits.
• Interacted with business to gather requirements, prioritized work, developed enhancements to the existing system,
• Coordinated testing, and performed change management/training for BW Reporting and applications.
• Worked on Inventory data sources like 2LIS 03 BX, 2LIS 03 BF and 2LIS 03 UM
• Good functional knowledge of Sales Distribution Sales Orders, Deliveries, Billing MM Purchasing Inventory Management , FI and general business process of SAP R/3.
• Designed and developed standard reports, cross-tab reports.
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports.

Tableau Consultant Activities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience in Marks, Publisher and Security concepts.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created the Test Evaluation and Summary Reports.
• Experience in BI interactive Dashboard.
• Experience of Client-Interaction on onsite/Offshore.

Environment: SAP BI 7.0, ECC6, BeX Analyzer, Tableau 7.0

Confidential

Role: BW Offshore lead

Responsibilities:

• Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from SAP ECC to SAP BI.
• Scheduling and monitoring of Data loads.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Worked on Creation of Process chains.
• Testing the reports with data and Rectified the issues occurred.
• Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.
• Set up periodic Data loads from legacy system flat files
• Creating and managing dataflow using DTP, Transformations and info packages.
• Designed and developed queries to generate reports in BEx Designer
• Involved with performance tuning of queries by compression, repartitioning of info cubes.
• Created aggregates for info cubes to improve query performance.
• Created new and linked universes.
• Created Master detail, Charts and Cross-tabs reports to view data in an analysed way.
• Involved in developing finances KPI reporting
• Developed 34 process chains to automate the initialization and delta updating of all data
• Working on various routines and enhancement ABAP coding
• Utilized new BI 7.0 transformations and DTPs for all new developments.
• Utilized the Analysis Process Designer APD to populate summary cubes using complex queries on other cubes.

Environment: SAP BI 7.0, SAP 3.5, ECC6, SQL Server, BeX Analyzer

Confidential

Role: BW Developer

Responsibilities:

• Designed/Build Documentation which provides to end users and developers to run their reports
• Designed/Built InfoCubes, Multicubes and prepared InfoCube, Multicubes Design Documents
• Created communication structures, transfer structures, transfer rules and update rules
• Developed a start routine and transfer rule for unit of conversion
• Worked on BW performance and Tuning project Query .
• Activated LO Cockpit extract structures for Logistics
• Performed extraction from multiple source systems including SAP using LO and flat files
• Created Custom/extractors and InfoCubes for General Ledger, Special Purpose Ledger in FI/CO areas.
• Worked on sales order processing, Delivery, shipping and billing.
• Created queries using variables, RKFs, filters, exceptions, conditions, free chars and almost all BEx features
• Improved query performance by creating Aggregates, secondary Index, Partition InfoCube
• 24/7 on call production support and monitoring Jobs in BW and R3 systems

Environment: SAP BI 7.0, SAP 3.5, ECC6, SQL Server, BeX Analyzer

Confidential

Role: BW Developer

Responsibilities:

• Installed Business Content and activated the SAP delivered Standard InfoCubes and InfoSources
• Worked on Generic Data Extraction RSO2 to create Datasources for transaction and master data
• Created Views in the non-SAP database systems and generated Data Source for the tables/views.
• Maintained customized InfoCubes, Operational Data Sources, and Multicubes for the business requirements.
• Defined update and transfer routines in transformation rules.
• Extensively used BEX Designer to build queries, queries with worksheets to access data from BW data targets.
• Involved in the development of programs for data conversion, interfaces, custom reports and transmission of data to vendors using advanced concepts like BDC, LSMW, and SAP Scripts
• Migrated material master legacy data into SAP system using LSMW in MM module.
• Extensively worked on ABAP/4 programming in SD, PP and MM modules.
• Design, development and testing of reports, user exits, SAP scripts and print programs.
• Developed programs using Step Loops and Table Control using multiple screens.

Environment: SAP BW 3.5, SAP R/3 4.6C, BEx