Rakesh Adigoppula
Sydney,Australia
Summary
Result-driven professional with a verifiable track record targeting assignments with an organization of repute in the Business Analytics, Data Analytics & insights industry Perceptive Senior Business Analyst with [Number] years driving successful business processes for [Type] companies. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Tata Consultancy Services Ltd.
06.2019 - Current
- Worked as a Tableau Desktop developer focusing on developing high-end visualization driven by data coming from various data sources SQL Server, MS Excel
- Extensive development experience tableau desktop version 8.3, 9.2, 10.1etc
- And Tableau server
- Good knowledge on LOD's, Order of Operations, Sets, Table calculations and web Data connector
- Served as tableau admin whose duties include adding users, groups managing licenses and scheduling tasks and embedding views in the tableau server
- Trained the end users to perform adhoc analysis in business object reports
- Excellent understanding of concept like star schema, Snowflake Schema using fact and dimension tables and relation data base(Oracle), MS-Access and Client/Server Application
- Good experience in using URL's, Hyperlinks, Filters for developing complex dashboards
- Developed different views using Tableau Desktop that were published to the business stake holders for analysis and customization using filters and actions.
02.2020 - 04.2020
- Developed Power BI and Tableau reports and dashboards from various Data Sources like Databases, Azure Databases
- Good Experience in database design, data modeling, development, implementation and reporting in Power BI
- Working with team of developers designed, developed, and implement a BI solution for Sales, Product and Customer KPIs
- Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE
- Implemented Tableau mobile dashboards via Tableau mobile application
- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
- Practical understanding of data modeling (dimensional and relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables
- Build and execute Data Visualizations to agreed deadlines
- Analyse audience data to drive better targeting decisions
- Integrate audiences with Data Management Platform (DMP)
- Conducting regular split-testing on customer audiences, subject lines, landing pages, template designs and messaging
- Liaise with internal clients to understand their requirements, suggest ways to improve targeting through accurate and timely campaign reporting and the use of previous campaign findings to fine tune/improve marketing effectiveness
- Evaluated and analyzed the effectiveness of communication channel to influence subscribers.
01.2018 - 06.2019
- Created various measures and columns in Power BI Modelling using Data Analysis Expressions
- Sorted a column with help of another column to sort the date fields according to Calendar based on Business requirement
- Developing logics for campaigns like legal, retention, growth & loyalty
- Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE
- Implemented Tableau mobile dashboards via Tableau mobile application.
Business Analyst
IBM India Ltd.
03.2015 - 06.2019
- Analyzed business requirements and build logical data models that describe all the data and relationships between the data
- Have created calculated fields and Measures with DAX expressions
- Have experience on creating Power BI Reports with various visualizations and custom Visualizations
- Used various filters (Page level, Visual level, Report level) to restrict the data and created Slicers for the user perspective by using Sync slicers
- Created columns to sort the data based on calendar dates
- Having experience on installing and configuring Data Gateway to deploy scheduled refresh for Power BI service reports
- Having good experience in Power Query (ETL) to transform the data within Power BI
- Created Bookmarks and sync slicers to move from one page to other page based on requirement like moving forward and backward navigations
- Perform tuning and troubleshooting of applications, modules and reports to improve performance and minimize system resource constraints
- Ensure adequate system requirements are documented for changes to the system platforms by maintaining a closing working relationship with various stakeholders
- Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
- Implementing demand forecasting models which improves upon forecast accuracy
- Targeting potential customer segments through effective communication channels; designing the product mix for the same
- Analyzing efficiency of various campaigns by performing essential analysis using SQL queries, to enhance insights & expand upcoming campaigns; generating campaign lead list accurately & on time
- Ensuring timely resolution of Marketing team queries & ad-hoc requests by collaborating with marketing stakeholders.
Skills
- Microsoft Power BI
- Tableau
- Splunk
- DB2, SQL & Teradata
- MS Excel
- Power query Editor
- MySQL, Azure SQL, ADF, T-SQL
- MS Dynamics365
- Azure Services
Certification
- Agile Practitioner from Bluemix IBM
- MS Power Bi trained Certification
- Tableau Desktop Qualified Associate Certification
- AMCAT Certified Business Analyst
Accomplishments
- Received Manager Recognition award 2016
- Received star performer award for the quarter 3 in 2017
- Received blue points for every Initiation (Part of pride and work dedication)
- Received Best Performer award in 2019
Languages
English, Telugu & Hindi
Location Preference
Sydney, Australia
Academic Details
HIET College of Engineering, JNTU, Hyderabad, Telangana, India, 2014, 71.58%, CV Raman Junior College, AP, Telangana, India, 2010, 78.6%, Nagarjuna high School, AP, Telangana, India, 2008, 84.50%
Personal Information
Date of Birth: 12/04/92
Extracurricular Activities
Participated in Adhvaya fest for robotics competition in Hyderabad Volunteer in Go green project in south India Participated in Multiple National level robotics and innovation programs Organised blood donation camp in undergrad college
Projects
DOMAIN-Australia REALESTATE, 02/2020 - 04/2020, Sydney, Australia, Developed Power BI and Tableau reports and dashboards from various Data Sources like Databases, Azure Databases. Good Experience in database design, data modeling, development, implementation and reporting in Power BI. Working with team of developers designed, developed, and implement a BI solution for Sales, Product and Customer KPIs. Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE. Implemented Tableau mobile dashboards via Tableau mobile application. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Practical understanding of data modeling (dimensional and relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables. Build and execute Data Visualizations to agreed deadlines. Analyse audience data to drive better targeting decisions. Integrate audiences with Data Management Platform (DMP). Conducting regular split-testing on customer audiences, subject lines, landing pages, template designs and messaging. Liaise with internal clients to understand their requirements, suggest ways to improve targeting through accurate and timely campaign reporting and the use of previous campaign findings to fine tune/improve marketing effectiveness. Evaluated and analyzed the effectiveness of communication channel to influence subscribers
Timeline
02.2020 - 04.2020
Senior Business Analyst
Tata Consultancy Services Ltd.
06.2019 - Current
01.2018 - 06.2019
Business Analyst
IBM India Ltd.
03.2015 - 06.2019
- Agile Practitioner from Bluemix IBM
- MS Power Bi trained Certification
- Tableau Desktop Qualified Associate Certification
- AMCAT Certified Business Analyst
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
James RussoJames Russo
Student at Full TimeStudent at Full Time