Pruthwiraj Samal Email & Phone Number

Bangalore

• Experience in creating merchandising blocks to make products visible in our website.• Proficiency in segregating, filtering, sanitizing and cleaning Seller data.• Experience in creating charts and dashboards of Seller wise and Listing wise data using Tableau.• Experience in using vlookup, index, match, countif, averageif, sumif, iferror, trim, sleft, right, mid, concatenate etc . functions to calculate seller, order, return and listing data faster.• Experience in searching the… Show more • Experience in creating merchandising blocks to make products visible in our website.• Proficiency in segregating, filtering, sanitizing and cleaning Seller data.• Experience in creating charts and dashboards of Seller wise and Listing wise data using Tableau.• Experience in using vlookup, index, match, countif, averageif, sumif, iferror, trim, sleft, right, mid, concatenate etc . functions to calculate seller, order, return and listing data faster.• Experience in searching the null data of products belongs to different categories.• Experience in creating pivot table, calculated fields and items to add new fields to pivot using different formulas.• Experience in writing sql queries to retrieve data from database through an Web Interface Sprinkle.• Proficiency in creating listing of different seller data belong to different categories.• Experience in checking the quality of different products of different categories.• Experience in interacting with Seller about the product details to be listed in Udaan website.• Experience in creating Shortcuts to automate repetitive tasks using Excel VBA.• Experience in consolidating similar data using excel data consolidation.• Experience in cloning listings using Database Web Interface and Udaan Web Console.• Experience in creating simple User Forms to make operation easier for Sales Representative and Seller. Show less

Bangalore

• Experience in preparing BM WO Analysis month wise report for all regions using Microsoft excel and Sql Server.• Proficiency in segregating, filtering and cleaning the data of all hospitals.• Experience in creating pivot tables, charts and dashboards of hospital wise and assets wise data.• Experience in using vlookup, index, match, countif, averageif, sumif, iferror, trim,left, right, mid, concatenate etc . functions to calculate assets data and Work order data… Show more • Experience in preparing BM WO Analysis month wise report for all regions using Microsoft excel and Sql Server.• Proficiency in segregating, filtering and cleaning the data of all hospitals.• Experience in creating pivot tables, charts and dashboards of hospital wise and assets wise data.• Experience in using vlookup, index, match, countif, averageif, sumif, iferror, trim,left, right, mid, concatenate etc . functions to calculate assets data and Work order data faster.• Experience in importing various types of PPM/Price billing data into excel and analyse them.• Experience in creating calculated fields and items to add new fields to pivot using different formulas.• Experience in taking backup of data from Sql Server 2016 every day.• Proficiency in creating new email id, deletion and email id management in Microsoft Exchange 2010.• Experience in configuring, archiving, troubleshooting, importing and exporting of backup file (.pst) in Microsoft Outlook 2007/2010/2013.• Experience in using select, update, insert, delete queries to manage the hospital and assets data in Sql Server 2016.• Experience in troubleshooting different issues in our own Healthcare Technology Management Software(HTMS).• Experience in quotation, purchase and vendor management.• Created macros to automate repetitive tasks using macro recorder.• Experience in consolidating Hospital and Assets data from different regions. Show less

Bangalore

• Generated summary reports for monthly data like Upload details, Attendance, enrollment count etc.• Used vlookup, hlookup, index, match, offset, rows, text, trim, concatenate, if, sumif, countif,averageif, and, or, left, right functions on excel 2007/2010/2013.• Created pivot tables to generate multiple reports for summarizing the data.• Created dynamic charts to represent month wise enrolled & uploaded data in a visual manner.• Provided certain rules to data by configuring… Show more • Generated summary reports for monthly data like Upload details, Attendance, enrollment count etc.• Used vlookup, hlookup, index, match, offset, rows, text, trim, concatenate, if, sumif, countif,averageif, and, or, left, right functions on excel 2007/2010/2013.• Created pivot tables to generate multiple reports for summarizing the data.• Created dynamic charts to represent month wise enrolled & uploaded data in a visual manner.• Provided certain rules to data by configuring alerts through data validation.• Created manifest file for bulk uploading of CIDR Packets using Script.• Reconciliated and uploaded CIDR Packets to remote UIDAI Server by using utility Aadhaar SFTP Client and Internet.• Solved technical issues in SFTP by contacting with UIDAI technical team.• Filtered unique packets among bulk packets by using Script.• Maintained database of EIDs for enrolled and received packets.• Generated CSV and SQL dumps district wise from database as per client requirement. Show less