Hi, I’m
Venkatakrishna Gurram
Pricing Staff Specialist
Munich
Summary
Accomplished Business Intelligence Analyst with 10 years of experience in developing and managing data-driven insights for pricing strategies and supply chain optimization. Expert in utilizing Tableau to deliver actionable insights through data visualization. Proven track record in enhancing operational efficiency and profitability through meticulous data analysis, strategic planning, and effective communication with stakeholders.
Overview
11
years of professional experience
4
years of post-secondary education
1
Certification
Work History
Infineon Technologies
Staff Specialist (Business Intelligence)
2 2020 - Current
Job overview
- Collaborated with teams Like (Quoting, Pricing,Marketing and Product Management ) to understand the Business Question and develop Visuals in Tableau
- Imported the data from various sources such as SQL Server, SAP Business Objects,Oracle, CSV Files and Excel
- Collaborated with EMEA Marketing Team, providing insights and self-service dashboards
- Developed global Quote response time and Check back Rate Tableau dashboards to track Quote Activity, marketing and sales pipelines
- Created SQL queries for views and SAP BI, ensuring data integrity and accessibility
- Conducted performance tuning activities and managed Tableau Server administration
- Prepare and update monthly Dashboard to give price performance review to Product Lines and Marketing team
- Created various different charts including treemap, donut chart, stacked bar chart in the dashboard and also included different calculations, parameters and navigation option and mail to option in the action filter
- Worked on adhoc requests also for extracting the data from various source systems.
Diageo India
Net Revenue Analyst
04.2018 - 01.2020
Job overview
- Built the Competitive Pricing Tool (Excel & Tableau) that is being used by the Commercial Planning Directors
- Data mining, extraction, cleansing and mapping from various data sources as required by our stakeholders for further analysis
- Prepare Performance report and P&L reports for various regions on monthly basis
- Process Improvement - Automated the regular report using Excel and documenting the same for future reference
- Worked on Promotional Analysis, Pricing and sales analysis, Competitive analysis for various countries
- Developed pricing Strategy report using historical sales data
- Delivered timely, action-oriented analysis and reports that helped the stakeholders in taking business decisions.
Vmware India
Business Intelligence Analyst
06.2013 - 03.2018
Job overview
- Developed visualizations and tableau dashboards using Tableau Desktop and Data extract & reports for strategy and planning, operation execution/ activation and measuring the performance of key programs
- Created Global Marketing Tableau dashboards which will help the marketers to generate the high revenue and to be more productive
- Also which will help them to plan and arrange the Vmware events across worldwide
- Used Presto DB and PostgreSQL to load the data related to Sales, Customer, Product, Campaign, Territory and Marketing information
- Created multiple views and datamarts by writing SQL queries as per the stakeholders requirements and embedded this data as a datasource inside the tableau dashboards
- Created Curated dataset, which will help the users to see and analyze the data at one place which will reduce the searching time and to enable self service reporting for the users
- Developed QBR doc(Quaterly business review) to understand the outcome of Marketing campaigns and how much DF(Development funds) used and how much revenue they are generating, so that how they are profiting
- Worked as Tableau Admin to schedule the tableau extract refresh on tableau server, Allowing access to particular users based on their role
- Worked on performance tuning activities of tableau dashboards
- Coordinated project planning, resulting in a 98% successful on-time project delivery rate.
Education
Rajiv Gandhi university
Bachelor of Science from Healthcare
09.2006 - 05.2010
Skills
Business intelligence tools (Tableau, Power BI & QLIK)
Python and Machine Learning
Advanced SQL (SSIS, SSRS)
SAP Business Objects
SAP CRM
Data analysis
Data analytics
Pricing strategy
Advanced Excel proficiency
Revenue management
Project management (Confluence, JIRA)
Decision-making based on data
Report writing and presentation
Sales Operations
Order Management
Quoting Process
Certification
Tableau Training, VMware, 2016, 06/2016, 08/2016, Hands on Experience in creating various Actions, Groups, Sets, Bins and Annotation. Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter Plots Tree Maps, Heatmaps, and Highlight Tables using Tableau Desktop. Having good knowledge to create customized charts (Donut Chart, Waterfall, Funnel, & Bar-in sidebar). Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes) using Tableau Desktop.
Languages
German
English
Hindi
Telugu
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Net Revenue Analyst
Diageo India
04.2018 - 01.2020
Business Intelligence Analyst
Vmware India
06.2013 - 03.2018
Rajiv Gandhi university
Bachelor of Science from Healthcare
09.2006 - 05.2010
Staff Specialist (Business Intelligence)
Infineon Technologies
2 2020 - Current