Pawan K.

Pawan K.

MI Designer with experience of SQL Query, Power BI, MS Access, Advance Excel and VBA

Noida , India

Experience: 10 Years

Pawan

Noida , India

MI Designer with experience of SQL Query, Power BI, MS Access, Advance Excel and VBA

30168 USD / Year

  • Immediate: Available

10 Years

Now you can Instantly Chat with Pawan!

About Me

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

Portfolio Projects

 Migrated Excel reports into Power BI

Company

 Migrated Excel reports into Power BI

Description

I have migrated our existing excel  dashboard into Power BI as per client request 

Show More Show Less

 Converted Static excel Dashboard into Dynamic and Interactive Dashboard

Company

 Converted Static excel Dashboard into Dynamic and Interactive Dashboard

Description

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 page

Show More Show Less

Tools

Office 365

 Activity Tracker ( Multi user and centralize reporting tools) based on excel and SQL

Company

 Activity Tracker ( Multi user and centralize reporting tools) based on excel and SQL

Description

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

Skills

Excel VBA SQL

 MS Excel Based Calling Applicatin (Excel CRM)

Company

 MS Excel Based Calling Applicatin (Excel CRM)

Description

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

Skills

MS Office

Tools

Excel sheets