SAP Business Objects and Tableau Developer

Summary:

* ***** ** ********** ** Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.

Hands on experience on Tableau 9.0/9.1/9.2/10.0/10.1.

Good exposure and understanding on BO XI 4.0/4.1. Knowledge and experience working on the new features and applications added in BO Information Designer Tool.

Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, MS Access and client/server applications.

Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation. Written SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.

In Depth understanding of Data Warehouse concepts, OLAP, OLTP, Star Schema, snowflake schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling, Fact

& Dimension tables.

Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.

Involved in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/ analysis, designing and developing reports, performance tuning, testing, migrating to production and post production support.

Good working knowledge on SAP BI/BW 7.0 with exposure on BEx queries, BEx Analyser, Info cubes

In-depth knowledge in migration, working and implementation of Business Objects Enterprise Reports

Ability to analyze and dissect user requirements and build front-end BI applications according to specifications.

Created interactive Dashboards using multiple BI Tools with Drill-Down capabilities, Dashboard prompts, Local and Global Filters. Experience in training Business users through online sessions.

Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.

Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts. In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server. I have been involved in automating the tableau report refresh using TABCMD utility.

Worked extensively in Informatica Power Center 8.6 9.1.

Proficient in databases like Oracle, SQL Server and Teradata. Strong programming and debugging skills in PL/SQL, SQL and UNIX shell scripting.

Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers perspective. Having strong analytical, logical, Communication and problem-solving skills. Ability to adapt to new technologies by self-learning.

Education:

• BE in Computer Science, St.Joseph’s college of Engineering, Anna University. GPA: 3.5 June 2013 Work experience:

• Senior Software Engineer August 2016 - Present

Agilisium Consulting, Los Angeles, US

• Project Engineer April 2013 - July 2016

Wipro Technologies, Chennai, India

Project details:

Project #7 : Corsair – Tableau Report Development

Client : Corsair Components

Duration : Aug 2017 - Present

Role : Tableau Developer

Technologies : Tableau, Amazon red shift, Snap logic Description:

This involves the replication of Excel Pro reports to the tableau report so as make it user friendly. Key Responsibilities:

• Developed Customer Sales Dashboards using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

• Developed Executive Dashboards for Regional Managers.

• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

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

• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.

• Involved in Performance tuning of tableau reports and reduced 50 % load time.

• Worked with security teams to setup user access levels, and server sizing based on country and Package level access.

• Involved in Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

• Automated Tableau report for user to get daily sales reports using TABCMD utility. Project #6 : Intuitive Surgical – Production Support Client : Intuitive Surgical Inc

Duration : Aug 2016 to May 2017

Role : SAP BO Consultant

Technologies : SAP Business Objects, SAP Business Warehouse, SAP BODS, Tableau, Xcelsius Description:

Intuitive Surgical was a robotic surgical company, where I was involved in full time production support for SAP Business Objects and Tableau.

Key Responsibilities:

• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of nongeographic data.

• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.

• Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BOBJ WEBI reporting tools.

• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.

• Responsible for day to day operations and technical deployment to ensure solution is in compliance with quality and regulations, meeting user’s requirements, and applying standards and best practices.

• Worked with complex data integration from multiple source system, multiple subject area, multiple data entity data environments.

• Made modifications to existing universes by adding new tables in the data warehouse, creating new objects and exported the universes to repository.

• Responsible for designing, building, testing, and deploying Tableau Dashboards, Universes and Reports using Web Intelligence through Business Objects.

• Modified Xcelsius dashboard by adding new table and pulling data to it.

• Recording monthly issue pattern and providing the permanent fix. Providing on time fix for bugs occurred.

• Worked on all the standards & guidelines Best Practices Documentation, and the functional & Technical design specification documentation.

• Providing day to day updates with onsite coordinator.

• Updating service now tickets on time abiding to the SLA. Project #5 : Crystal Report validation

Client : Zurich Insurance

Duration : Mar 2016 to Jul 2016

Role : Developer

Technologies : SAP Business Objects, Crystal Reports, Netezza. Description:

This project involved monitoring of existing crystal and BO reports. End to end production support was given to the user.

Key Responsibilities:

• Daily monitoring the business reports and dashboards

• Providing on time fix for bugs occurred.

• Responsible for modifying BO universe as per user request.

• Providing day to day updates with onsite coordinator. Creating Change request for any kind of change made Project #4 : APO BW Migration

Client : Wipro Technologies with Apple Computers Inc Duration : Nov 2015 to Feb 2016

Role : Developer

Technologies : Tableau, Teradata, SAP BW, Bex queries Description:

This project involved migration of SAP PD8 system to Teradata. All the functionalities have been replicated to Teradata. SAP PD8 system used bex queries as the reporting layer in turn these reports have been converted to tableau reports.

Key Responsibilities:

• Analysis of specifications and requirements provided by the clients.

• Analysis of SAP BW Bex reports.

• Gathering the requirements for the tableau report.

• Involved in data modeling activities.

• Creation of tableau report as per the Bex report.

• Test cases preparation for validating the report between tableau and SAP BW Bex report.

• Responsible for unit and Integration testing.

Project #3 : ACBI Enhancement project

Client : Wipro Technologies with Apple Computers Inc Duration : Aug 2015 to Oct 2015

Role : Developer

Technologies : SAP Business Objects, Teradata, Informatica. Description:

This project handles the Apple care business reports. As part of this project, we were ought to modify the 2 existing reports and did some bug fixes.

Key Responsibilities:

• Analysis of specifications and requirements provided by the clients.

• Data modelling for creating new objects.

• Investigating the data at the database side in case of any data inconsistencies.

• Report data issues has been fixed.

• Reporting daily status and Coordinating with Onsite Project Lead.

• Responsible for entire Unit, Integration and Regression testing.

• Migrated the reports to the IT, UAT and production environment. Give full time support after production implementation Project #2 : TMS Freight Rates

Industry : Wipro Technologies with Apple Computers Inc Duration : Jan 2015 to Mar 2015

Role : Developer

Environment : SAP Business Objects, Teradata, Informatica, Unix Shell Scripting Description:

Transportation Management System (TMS) deals with the end to end details about the vendors, carriers and freight from the origin to its delivery. In this project, we were ought to create 6 new reports and then modifying 2 existing reports.

Key Responsibilities:

• Analysis of specifications and requirements provided by the clients.

• Addition of objects, tables and joins required for reporting.

• Analyzing the warehouse schema both dimensions and facts tables.

• Designed report template according to the company standards and Client requirements.

• Involved in creating 8 reports of which 4 were complex items.

• Responsible for entire Unit, Integration and Regression testing.

• Migrated the reports to the IT, UAT and production environment.

• Co-ordinated with the various teams like performance, DBA review, Release Management to get the feedback on the codes which we have created.

• Maintaining common repository using SVN tool for deploying the codes.

• Validation of Reports. Expertise in implementing changes related to enhancements and maintenance. Project #1 : Sales Universe Enhancements

Client : Wipro Technologies with Apple Computers Inc Duration : Apr 2014 – Jul -2015

Role : Developer

Environment : SAP Business Objects, Teradata, Informatica, Unix Shell Scripting. Description:

This project involved building of a new BO universe to analyze the Sales information. Here the data was being pulled from source ECC system to Teradata through informatica. Then a new BO universe have been built and on top of that business reports have been created.

Key Responsibilities:

• Involved in Analyzing and gathering requirements.

• Inducting new objects, joins and contexts wherever required.

• Created reports as per the business request.

• Responsible for development, testing and then migrating the changes to the IT, UAT and production environment.

• Involved in entire unit testing, Integration testing for the changes.

• Done entire regression testing for the universe that doesn’t affect the existing universe setup.

• Created a security setup on universe to make sure that the data will be shown only to the authorized person.

• Build adhoc reports and validated the data flow.

• Implemented new interfaces required for the project in the teradata system.

• Maintained a common repository using SVN for all the interfaces and codes to deploy in production environment

Contact this candidate