Over the last 5 years, I have developed a wide range of Excel reports by using different features. My core competency lies in developing automated Excel (from the ground up or building on existing bases) which is intuitive to use and user-friendly, yet very powerful. I am seeking opportunities to automate tedious and complex Excel processes so that you and your business can be more productive.
I have extensive experience working with a leading solar company as a "Deputy Manager Data Analyst and Reporting(BI)" and also a superuser of SAP b1. Due to my dedicated focus on analytics solutions, I deliver top-quality, process & self-driven, and most professional deliverables in the shortest turnaround time.
1. Designed a fully automated user-friendly VBA-based excel utility for the management reporting of Sales, Collection, Receivables, payables, sales & telesales performance on a daily, weekly, and some monthly basis.
2. I processed the external inventory audit of approx. 7.4 Million dollars worth and 212 Thousand excel rows and 22 columns of data.
3. Designed a centralized WMS(Warehouse management system) at an online google Sheets for more than 1000 transactions daily from different regions.
4. Designed a fully automated user-friendly VBA-based excel utility for the production line and its inventory management.
5. I come with extensive domain expertise in Electrical, Solar, Industrial Automation, PLC & supply chain industries, warehousing, production, and Logistics.