Pawan K.

Pawan K.

Business Analyst

Noida , India

Experience: 10 Years

Pawan

Noida , India

Business Analyst

30168 USD / Year

  • Immediate: Available

10 Years

Now you can Instantly Chat with Pawan!

About Me

Dealing with onshore client for Report and Automation Project Understand and analyze automation opportunity and provide solutions to client. Handling Team in absence of Team Leader Working knowledge of SSIS,SQL Server, MS Access, Power BI, MS Team Co...

Show More

Portfolio Projects

Description

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

Show More Show Less

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 toanother part of report by just clicking on hyperlink of respective menu. Just like we use in website page

Show More Show Less

Description

This report was develop for another departmentwhere 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

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 whencustomer 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 wasfully based on advance excel fomula.

Show More Show Less

Description

Show More Show Less

Description

(Using VBA and Access Query)

Show More Show Less

Description

( Multiuser tracker and centralize reporting tools) based on excel and Access

Show More Show Less

Description

(Excel CRM)

Show More Show Less

Description

(Tools: MS Excel)

Show More Show Less