Vikram Emmodoju

Tableau Developer with an overall 5.5 years of hands-on experience in Tableau desktop and server, Designing, Analysis, and Management in the Business Intelligence development that includes Analysis, Design, advanced analytics and data warehousing. Proficient in Tableau BI Suite and technologies for high-performance analytics to enhance business results and decision-making. Experienced in evaluating both short & long term business needs to support key business goals.

Business Intelligence Tools: Tableau 2020/2019/10 and BO

Web/Application Servers: Tableau Tableau Desktop, Tableau Server, and Tableau Online, SQL Server, Advanced Excel.

Operating Systems: Windows Family.

Database: Oracle 11g Database, MS SQL Database.

Duration: Jan-2020 to till date

Role: Tableau Developer

Client: John Clark Motor

Environment: Tableau 2021/2020 and SAP BO, Oracle and SAP BW/HANA

_

Description:

John Clark Motor Group is a family-run vehicle dealer group that operates in the northeast of Scotland. Team highly experienced, dedicated team of Used Car Specialist Buyers regularly help customers sell their car quickly and for immediate payment. customers can discover a range of cars to suit various budgets. Customers can browse a selection of new cars from Audi, BMW, Dacia, Jaguar, Land Rover, MINI, Nissan, Peugeot, Renault, SEAT, Skoda and Volkswagen. On top of this, John Clark Motor Group dealerships sell used cars from a variety of other manufacturers, such as Citroen, Fiat, Ford, Mercedes-Benz, Porsche and Volvo.

_

Responsibilities:

• Prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Data quality testing by comparing output of dashboard with database. Functional testing by checking filters, navigation etc.
• Publishing dashboards on server and giving access to users getting reviews from end users and modifying the dashboards accordingly.
• Developed Tableau data visualization using Cross tabs, Heat maps, and Scatter plots,Geographic map,Pie Charts and Bar Charts.
• Creating reports using Tableau for customized and ad-hoc Queries.
• Provided Production support to Tableau end users and Wrote Custom SQL to support business requirements.
• Schedule a meetings regular basis with end users for any clarification required
• Developed complex reports using features like Drill capabilities, dynamically display the tables and charts, YTD and MTD calculations with multi sources
• Prepare unit test cases and validate reports against them.
• Trained end users in understanding the Tableau Desktop functionality and to create their own dashboard
• Created Tableau dashboards to show sales of retail data for monthly, quarterly and yearly basis.

· Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.

TCS Career Edge-Knockdown the Lockdown

Duration: Apr-2019 to Dec-2020

Role: Tableau Developer

Client: PMI

Environment: Tableau , BO ,Oracle Data Base SQL, Windows

_

Description:

BORA stands for Back Office Reporting & Analysis. It is an end to end data warehouse application by PMI for their Marketing and Sales Support Department. This data warehouse is then used for several reporting requirements catering the analytical requirements of PMI managers belonging to various levels of hierarchy. The application are developed in SQL 2000 and 2005 using DTS Packages and Stored Procedures.

_

Responsibilities:

• Built complex financial reports with eight data sources and worked with blending which were based on data from various data sources.
• Experienced in performing various database activities which includes writing SQL queries, Custom SQL while building the reports.
• Experience in Table Calculations and Filters (Data Source, Report, Column, Context, User and Actions).
• Experience in Dual Axis and showing the graph in New Visualization.
• Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
• Experienced in showing top 10 highest values and top 10 lowest values in same sheet.
• Experience in creating LOD Expressions.
• Experience in developing reports with Parameters, Groups, Sets, Calculated fields
• Has involved in Quality Management activities by creating project related documents.
• Has involved as mentor and trained colleagues in Tableau within the organization.

Business Objects Designer Tool to Build Universes.

Duration: OCT-2018 to March-2019

Role: Tableau Developer

Client: Nordea Bank AB

Environment: Tableau 9.3, Oracle 11g.

_

Description:

Nordea Bank AB commonly referred to as Nordea, is a European financial services group operating in northern Europe and based in Helsinki, Finland. The Bank is the result of the successive mergers and acquisitions of the Finnish, Danish, Norwegian and Swedish banks of Merita Bank, Unibank, Kreditkassen (Christiania Bank) and Nordbanken that took place between 1997 and 2000.

_

Role & Responsibilities:

• Worked on the requirement gathering of the reports for Nordea Bank to create proper dashboards.
• Analysed the database tables and created views based on the columns needed.
• Used Data Blending, groups, combine fields, calculated fields and aggregated fields to compare and analyse data in different perceptive.
• Created Rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created Graphs like dual, bar and line etc.
• Responsible for creating interaction able business stake holders, gathering requirements and managing the delivery.
• Connected Tableau Server to publish dashboard to a central location for Integration.
• Created All the Types of Filter and global filter.
• Created Trend Lines, Reference Lines and statistical techniques to describe the data.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Duration: Mar-2017 to Sep-2018

Role: Tableau Developer

Client: OMRON

Environment: Tableau, SAP BO ,Informatica 9.1, Oracle 11g

_

Description:

OMRON is a Japanese based organization which provides control components and systems for factory automation, helping companies realize their manufacturing goals. Provides control components used in home appliances. Omron’s Health care division provides both home use and professional medical equipment-based blood pressure monitors and pedometers encourage individuals to take.

_

Role & Responsibilities:

• Understanding the requirements & Design Specifications.
• Analyse the requirements and subsequently developing the Worksheets, Dashboards, and Stories.
• Troubleshooting issues associated with BO reports/universes/connections
• Generated web Intelligence Reports using multiple Data providers as per new CR’s.
• Analysed the database tables and created database views based on the columns needed.
• Used Data Blending, groups, combine fields, calculated fields and aggregated fields to compare and analyse data in different perceptive.
• Created Parameters, quick filters and context filters.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• · Designed, developed, deployed and maintained Universes Used