Rakeshkumar R.

Rakeshkumar R.

Techno Functional professional with a flair to understand and crunch the data for simpler analysis

Bengaluru , India

Experience: 9 Years

Rakeshkumar

Bengaluru , India

Techno Functional professional with a flair to understand and crunch the data for simpler analysis

24000 USD / Year

  • Start Date / Notice Period end date: 2019-06-23

9 Years

Now you can Instantly Chat with Rakeshkumar!

About Me

-Over 8 + years of IT experience ranging from support, coding, development, testing, analytics, data modelling, analysis and consulting

-Hands on Experience with Business Intelligence and Visualization tools like Tableau, MS – Excel an...

-In-depth knowledge on Tableau Desktop 9.x, 10.x, Tableau Server 9.x & 10.x and Tableau Reader

-Excellent interpersonal, analytical and presentation skills

-Excellent knowledge in working with multidimensional data and crunching data for meaningful analysis 

 

 

 

 


 

Show More

Portfolio Projects

Indirect Cost Excellence

Company

Indirect Cost Excellence

Description

  • Extract spend data from all sites through different databases and sheets in order to create a spend analysis to understand the procurement spend from a top-down approach
  • Creating data sets in SAS/BASE and using statements and functions like DO ITERATIVE, DO WHILE, IF-THEN/ELSE – IF, MERGE, TRIM, COMPRESS, CAT, STRIP, COMPBL, SUBSTR, SCAN, INTNX, INTCK, FIND, LEFT, RIGHT, UPCASE etc
  • Generated Reports using procedures like PROC APPEND, PROC CONTENTS, PROC EXPORT, PROC FREQ, PROC PRINT, PROC REPORT, PROC SORT, PROC SUMMARY, PROC TRANSPOSE etc
  •  Proficient in designing and developing of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Donut Charts, Pareto Charts, Dual Axis, Blended Axes and basic visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Geo Maps (Filled and Symbol)

Show More Show Less

Total Working Capital Improvement Project

Company

Total Working Capital Improvement Project

Description

  • To redesign the existing accounts receivables, inventory management, and accounts payable process and implement new strategies through working capital assessment
  • Extracting a large list of items (Maintenance Repairs & Operations) from the purchasing with respective categories through database, spreadsheets and flat files
  • Involved in Mapping data (MRO Items) with the purchase orders through Data Blending
  • Sending surveys to the stakeholders to understand the Capability assessment analysis and the challenges faced by the procurement team
  • Developed and designed Tableau dashboard and reports to understand the procurement spend through multiple classifications
  • Used Level of Detail (LOD) to understand the sub-categories supported by suppliers in contract
  • Prepared a savings analysis report by supplier and category to understand the discounts offered
  • Prepared a user-friendly Excel Macros tool to verify the supplier contracted price and delivered to client

Show More Show Less

Skills

MySQL Tableau

Tools

Tableau

Shared Services Processes Assessment

Company

Shared Services Processes Assessment

Description

 

  • To assess the existing processes managed by Business Services across Europe & Asia and suggestions to reorganize for better cost optimization
  • Merging data including FTEs, costs, orders processed, transaction volumes of accounts payable, accounts receivables, customer billing, procure to pay, payroll, employee data management
  • Created customized reports in Jasper Soft to classify data by different processes
  • Used database, excel sheet to generate data visualizations in Tableau
  • Used objects like filters, calculated fields, sets, groups, parameters and hierarchies
  • Created and modified interactive dashboards and guided navigation links within interactive dashboards
  • Consolidate and analyze the Time & Attendance and Payroll Administration data to streamline the processes as per the global standards
  • Proficient in using Power Query and Power pivot and merge and analyze data

Show More Show Less

Tools

Tableau

Benchmark Analysis

Company

Benchmark Analysis

Description

  •  To collect data and perform comparative analysis across all the departments within a state
  • Created Excel worksheet using macros to collect data across all departments
  • Merging of data through MS-Access, MS-Excel and other flat files
  • Experience in using advance excel functions like INDEX, MATCH, IF with AND/OR, TRIM, CONC, CEIL, FLOOR, MID, IFERROR, IFS, COUNTIFS, SUMIFS etc.
  • Proficient is understanding statistical terminologies and usage of functions like MEDIAN, QUARTILE.EXC, AVG, AVERAGEIFS, SUMPRODUCT for quantitative analysis
  • Knowledge of Data manipulation by overriding during the data validation phase
  • Creating and sending surveys to internal and external stakeholders to understand the acceptable practices and scope of improvement
  • Providing timely status to the project team on data collection and survey responses

Show More Show Less

Skills

IMacros Tableau

Tools

Tableau
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Conversational

  • Hindi - Conversational

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]