A yardstick of quality where excellence is expected
Expert knowledge of (Excel & Advance Excel) and experience in reports creation using MS Office (MS Excel, MS PowerPoint and MS Word). Knowledge of advance excel functions (not limited to VLOOKUP, Sumifs, Countifs, Index, Match etc.)
Understanding of the data & reports MIS reporting by using MS Excel & VBA (Macro) at Operational and Client level.
Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concerned Teams.
Built out novel reports and migrated rebuilt legacy reports into new centralized reporting to meet reporting needs company-wide.
Design/develop the agreed upon solution using VBA coding in MS Excel.
Deliver end products, maintaining quick turnaround times and highest quality standards so as to execute quick turnaround work in MS Excel which involves VBA coding.
Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
Guided and mentored junior staff and provided expertise to concerned teams.
Managing the Monthly, Weekly & Daily Report creating in MS-Excel through in depth analysis and producing the actionable information.
Generating & maintaining day to day MIS Data and updating the management.
Extensive usage of formulae’s (Sumifs, Countifs, Averageifs, Sum-product, Index-Match, Vlookup/Hlookup, Match, Choose, datedif, Left/Right/Mid, IFerror/ISerror/ISna, text to column, IF, NestedFunctions, MAX, MIN, LARGE, Dynamic Pivot table/Calculated Fields, Data validation, Conditional formatting, Advanced filter etc.
Work Terms
I can work 8 hours on weekends and 2 hours daily on weekdays.