๐ฉ๐ปโ๐ผ I am a passionate Finance & Business Intelligence (BI) consultant, a qualified Accountant (๐๐ฃ๐ ๐๐๐๐๐ฟ๐ฎ๐น๐ถ๐ฎ) and a proactive problem solver.๐ผ At work, I enjoy identifying opportunities for process improvements, analysing data to gain insights, and developing smart solutions to complicated Excel & Power BI problems.I work as a project manager and a lead modeller on a range of projects. I provide consulting solutions for clients from various industries to help with: โบ automating repetitive tasks & optimising business performance โบ building financial models (e.g. 3-statement models, project finance, actuals, budget, forecast, variance, scenario analyses, consolidated statutory financial statements, management reports, valuations) โบ creating data & operational models โบ generating dashboards for reporting and decision-making purposes.โ๏ธ I am proficient in the following tools: โบ ๐๐ฑ๐๐ฎ๐ป๐ฐ๐ฒ๐ฑ ๐๐
๐ฐ๐ฒ๐น (shortcut keys, PivotTables, Dynamic Arrays, LET/LAMBDA, Power Query, Power Pivot, VBA, Office Scripts) โบ ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ (M, DAX, data transformation, data modelling, visualisation) โบ ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐๐๐ผ๐บ๐ฎ๐๐ฒ (cloud & desktop flows, AI Builder) โบ ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ฝ๐ฝ๐ (Dataverse, Dynamics 365, Solutions, Power Fx) โบ ๐ฆ๐ค๐โ๐ป I write several blogs and is responsible for the Final Friday Fix and Monday Morning Mulling blogs (Excel challenge series) on sumproduct.com website, where I cover Power BI/Excel functions & everyday problems encountered when building models/reports and dealing with raw data.โก๏ธ Some examples of ๐ฎ๐๐๐ผ๐บ๐ฎ๐๐ถ๐ป๐ด ๐บ๐ ๐๐ผ๐ฟ๐ธ: โบ exporting multiple Excel models with relevant data from a master template โบ printing out invoices / PDF reports โบ sending emails with relevant attachments and body contents โบ extracting data from PDF invoices with different structures and renaming them in bulk โบ generating automatic reports / dashboards from various sources (e.g. files, websites, NetSuite, Salesforce, SQL, Dataverse, Power BI, API etc.) โบ creating my own shortcut keys & Excel functions with LAMBDA, Power Query and VBA.๐ I am always curious about underlying causes of problems around me. Outside of work, I often take courses, attend webinars, solve Excel challenges, read books and listen to YouTube/podcasts in different areas to broaden my knowledge and develop new skills.๐ My favorite quote:
Listed skills include Self Management, Love Of Learning, Xero, Moodle, and 30 others.