Rakeshkumar R.

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

Bengaluru , India

Experience: 9 Years

Bengaluru , India

24000 USD / Year

9 Years

Now you can Instantly Chat with Rakeshkumar!

-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

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

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

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

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