LAKKAKULA RAVI KIRAN

Planning and coordinating with the customer and suppliers to understand requirements and developing Dashboards
Built, trained and managed a team of Data analysts for delivering the Client Profitability BI solutions
Delivered phase 1 of the Client Profitability Project CP-iERP v1 project well before the delivery target
Developed the Utilisation BI solution having 19 different Dashboard tabs for top management people
Worked on delivering Operational and Finance Reports on AP, AR, GL, FA Modules
Extensive usage of Custom SQL Code for performing lightweight data modeling in Tableau

Planning and coordinating with the customer and suppliers to understand requirements and developing dashboards which give deep insights for taking decisive decisions for the CFO, CEOs and managers.
Built, trained and managed a team of data analysts for delivering the Client Profitability BI solutions using Power BI, Tableau, and building Enterprise Datawarehouse integrating multiple data sources like Salesforce, Workday, Dynamics 365 and creating Master dimension marts in Semarchy using Azure Synapse.
Built Tableau/Power BI dashboards for users across 72 different markets within Dentsu.
Delivered the phase 1 of the Client Profitability Project CP-iERP v1 project well before the delivery target by working and leading a team of 4 BI data analysts.
Saved over INR 1.5 million by identifying the data cleanliness issues and missing timesheets of the employees.
Developed the Utilisation BI solution having 19 different dashboard tabs for top management people to get a record recurring quality issue, develop training programs and reward systems for the employees.
Reduced recurring defects by almost 90%.
Worked on delivering many operational and finance reports on AP, AR, GL, FA modules.
Generated Trial Balance and Profit&Loss reports for company for monthly/quarterly/YTD closures.
Used custom SQL code for performing light weight data modelling in Tableau.

Developed a Tableau Dashboard solution for a critical Learning Management project
Designing the Advanced Reports as per the Requirement and created the reports using Tableau Desktop and Microsoft SQL server
Configure The LMS to support social interaction over various business KPIs
Design various views in Tableau like Tree maps, Heat Maps, Scatter plot
Use data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives

Using R and Excel to perform calculations which contribute to better forecasting
Join Skype weekly conference calls to discuss over the suggestions and corrections relating the published Reports
Involved in migrating the content towards the QA for testing

Produce collated invoice reports to the Global ecommerce and finance teams
Create and deliver Risk models using KPIs
Use of Alteryx & Custom SQL UNION commands to perform Data preparation prior to analysis of the OLAP data
REGEXP commands to identify and filter strings, URLs, and logs
Present data using charts such as Pie-chart, Stacked Bar chart within given SLAs

Developed a Tableau dashboard solution for a critical Learning Management project which helped in reducing the procurement costs and man-hour savings by over Euro 150,000.
Designed advanced reports as per the requirement and created the reports using Tableau Desktop and Microsoft SQL Server and deploying on Tableau Server.
Configured the LMS to support social interaction over various business KPI,s and facilitate collaborative opportunities basing the cumulative report analysis.
Designed various views in Tableau like Tree maps, Heat Maps, Scatter plot.
Used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Analyzed various invoice data and prevented fraudulent activities among hundreds of millions of ecommerce transactions across the globe.
Produced collated invoice reports to the Global ecommerce and finance teams.
Created and delivered risk models using KPI’s which works as trend identifiers.
Used Alteryx and custom SQL UNION commands to perform data preparation prior to analysis of the OLAP data.
Used REGEXP commands to identify and filter strings, URLs and logs.
Presented data using charts such as Pie-chart and Stacked Bar chart within given SLAs.
Used statistical analysis to segment the transactions basing the customer behavior to develop KPI,s to prevent deposits and debit card frauds.
Reported over weekly or ad-hoc Scrum meetings with the Finance & Scot teams along with PM & SME before publishing the same to the master encapsulated workbook for UT.
Deployed the dashboards and worksheets over the Tableau Server with relative site-role permission for secure authenticated end-user or client access.

Worked as junior intern software engineer before moving into reporting team for reporting using JasperSoft and later into Tableau.
Used R and Excel to perform calculations which contribute to better forecasting.
Joined Skype weekly conference calls to discuss the suggestions and corrections relating to the published reports.
Involved in migrating the content towards the QA for testing.