My professional interests include business strategy and operations, the quantified self, tech, startups, and sustainable development.
Currently, I work as a business analyst at Evalueserve. The scope of my job includes:
Working with clients across a wide range of industries and business functions
Benchmarking companies on financial and operating statistics, Financial Statement Analysis by gathering information from company reports/filings and from sources such as Bloomberg, Factiva, Thomson Reuters etc
Preparing company profiles, industrial profiles, individual profiles, organizational charts and press search
I would like to draw your attention to the below-mentioned skills of mine:
I have a strong command over elements such as pivot tables, advanced formulas like lookup function, conditional formatting, and data validation & formatting.
I love creating dashboards and Excel gives me the right tools and platform to showcase my love for data and dashboards. You can check out some of my work at Github @akulchhillar
VBA gives me the power which helps to showcase my passion for programming. I have completed a couple of online courses from Coursera on VBA. I have experience ranging from creating macros for day-to-day use to the advanced use of macros which involves the use of interacting with several applications with Excel-like Outlook, Powerpoint, Word, etc.
Python and Data Visualization
My never-ending love for programming can be established by the fact that I have taught myself Python from scratch. Plus because I love playing with data I used my knowledge of Python to produce visualizations.
I have worked on various PowerBi projects where I have worked on creating extensive dashboards and reports along with DAX queries to manipulate data. Being someone who loves working with data, PowerBi just provided me one more avenue to explore insights and describe the data and tell people what's happened till now. Plus I believe PowerBi is an intuitive tool for me when it comes to data exploration and representation.
The latest skill in my kitty is working with MYSQL and can do a decent job when it comes to writing SQL code to query data with subqueries as well, create a stored procedure, inserting and updating tables, creating views.