Now you can Instantly Chat with Pawan!
When I became a part of my company Hays. I was fully dependent on UK MI Team because all reports were designed and developed by UK Team members. They had a deep knowledge of Access and Excel and apart from it they were very supportive and also...
I am very optimistic to upgrade my skills toward my profession. Experiencing in SQL, MS Access, using VBA in excel, Migration of excel dashboard into Power BI, developed some tools for other departments all these skills became possible due to my interest to enhance our skill according to time.Show More
Converted Static excel Dashboard into Dynamic and Interactive Dashboard
In earlier version of excel dashboard we used tab to navigate between different parts of report. Now we can navigate from one part of report to another part of report by just clicking on hyperlink of respective menu. Just like we use in website pageShow More Show Less
Activity Tracker ( Multi user and centralize reporting tools) based on excel and SQL
This report was develop for another department where AHT (Average handle time) was mendatory.
with the help of this tools Team lead was able to monitor live data in excel and they can also make thier own report in excel.Show More Show Less
ToolsOffice 365 SQL Server 2008 R2
MS Excel Based Calling Applicatin (Excel CRM)
This project was develop when I was in domestic BPO industies. This project was very helpfull for caller.
Earlier they had to scroll up and down , left or right excel sheet when customer asked for any information about their card.
after completion of this project all information was available in one screen . They just need to enter customer card number and click on 'Show Details' button. This project was fully based on advance excel fomula.Show More Show Less