- Have expertise in Excel advanced programming and features.
- Can get the KPIs from the sharepoint sheet, and also have the tracked hours calculate the payments per the rate card.
- Similarly the cost forecast based no the Primavera can be plugged in to get the different stats like ACWP Vs BCWP, BCWS etc.
- Have done similar project reporting from Shareporint data, providing a Weekly Report of all different projects, key tasks and their status (RGB). (Freelancer project).
- Project costing based on hours ticked by employees in consolidation with the Ratecards can be calulcated.
- Will provide buttons to make it easy to access the functionality and get the reports.
- Based on the Payment applicaton, template the file columns could be arranged so that the data can be uploaded from the Excel file for payments.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Pl. review my portfolio on recent projects.