Excel Mantra

Excel VBA and Analytics
Am an expert on Microsoft Excel and VBA with more than 12 years of professional experience. I have delivered various projects related to Microsoft Excel such as Analytics, Dashboards, Excel Macros and VBA Automation Projects.

I specialize in VBA Coding and automation projects. A specialized custom menu for each project I delivered is one of the USPs most liked by my past clients. Excel based reporting and Analytics comes natural to me. I follow Stephen Few's methodologies for professional reporting Dashboards.

Data Visualization - Tableau, Alteryx, PowerBI, SQL and Google Data Studio
Using the tools I have delivered projects related to data modeling, visualization and complex management dashboards. Have also delivered projects related to data reconciliations using custom SQL logics in Alteryx. Am pretty versed with data blending in Google Data Studio where multiple sources were required to be clubbed and represented as Dashboard Stories.

Google Sheets and AppScript
Have delivered projects involving Google Sheet as the final data storage app and fetching details from external sources either by API connection or by data import features. In such projects, java based Google AppScript is used to interact with the external source and fetch data. These AppScript containers can be scheduled to run at a given time and execute automatically removing the need of human/manual intervention.

Languages & Framework: VBA, VB 6.0 Desktop Software, vb.net, JAVA, Google AppScript
Reporting: Excel, Tableau, Alteryx, Power BI, SQL, Google Data Studio, and Access