• 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)

• 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

• 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

• 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

To perform supplier consolidation and supplier optimization across 12 different countries & 40 sites in Europe for multiple business units spread across different categories 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 Categories included MRO, Freight, Packaging and other indirect Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization Merge purchasing data from different sources (database, spreadsheet, flat-file 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 Normalizing different currencies and different date formats to overall company level view Generated Reports using procedures like PROC APPEND, PROC CONTENTS, PROC EXPORT, PROC FREQ, PROC PRINT, PROC REPORT, PROC SORT, PROC SUMMARY, PROC TRANSPOSE etc Experience in performing GAP analysis in the project to understand As-Is and To-Be conditions for each category Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters Experience in creating various filters like quick filters, data source filters, context filters and user filters in Tableau Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop Created complex dashboards and published on to Tableau server 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) Developed reports using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots Testing of reports and dashboards of team members before publishing Presented the overall reports to the procurement board with findings of the industry standards across the European market Have been onsite to UK & travelled across Europe and directly reported to the Program Director Environment: MYSQL, SAS/BASE, SAS/PROC, Tableau Desktop, Tableau Server, MS-Excel, Power point