Anand SubramanianData Science, Excel Expert
No reviews yet
I'm a Microsoft Excel instructor with 20+ years of experience and a passion for empowering learners like you. With my practical teaching style and personalized approach, I'll guide you through the intricacies of Excel and help you become a proficient user.
My methodology combines theory and hands-on practice to ensure you grasp Excel concepts and apply them effectively. I specialize in advanced functions like pivot tables, VLOOKUP, HLOOKUP and Macros, enabling you to streamline data analysis and reporting tasks.
But I don't stop there. I understand the importance of data cleaning, consolidation, and converting PDFs to Excel. I'll provide guidance and support for these tasks, helping you handle diverse data challenges with ease.
As a dedicated teacher, my ultimate goal is your success. I take pride in witnessing the growth and confidence my students achieve in their Excel abilities. Rest assured, I'm here to support you beyond the classroom, providing assistance for minor use cases and specific requirements.
Choose me as your Excel instructor, and together we'll conquer Excel's complexities and unlock your full potential. Get in touch today, and let's embark on a transformative journey toward Excel mastery.
Subjects
Python Beginner-Intermediate
R (Programming) Beginner-Intermediate
Machine Learning Beginner-Intermediate
Excel Beginner-Intermediate
Experience
Senior Development Manager (Nov, 2021–Present) at FIS Global
Senior Manager (Oct, 2018–Nov, 2021) at Incedo Inc.
Manager (Jul, 2017–May, 2018) at Bristlecone India Ltd
- Built Business Use cases and extract cost leakage transactions from the spend data - Analyzed contracts and spend transactions and find anomalies in unit price variation and total spend - Automated share of business dashboard for the Senior Management - Prepared Supplier Consolidation matrix for cost and time optimization
Senior Manager (Jul, 2016–Jun, 2017) at Deccan Herald
• Automated daily sales report using Python. • Applied Clustering Algorithm in Python to segment clients based on various attributes, thereby running different campaigns. • Updated projections, monitored outcomes, and recommended suitable actions on a regular basis with inputs from key stakeholders. • Analysed the competition and provided directions to Sales, Circulation, Production and Editorial teams to focus on key areas to maximize profits, reduce costs and enhance readership. • Collected data from different data sources, analysed and provided key insights into company performance. • Conducted Spend Analytics, built and monitored data for relevant processes to enable decision-making.
Manager (Nov, 2014–May, 2016) at Gerdau Steel
• Prepared weekly and monthly forecast, and participated in meetings with senior management to review sales, product mix, issues, initiatives and opportunities. • Apprised the management in case of a declining trend with respect to the Annual Business Plan. • Worked closely with Supply chain and procurement teams to meet delivery and production goals and ensured that inventory levels were sufficient to meet customer needs. • Prepared Excel macros to automatically calculate fixed cost for all departments. • Summarized and visualized the business trend with the help of Tableau thereby helping Management to take spot decisions. • Developed customer segmentation algorithm in Python thereby enhancing the order book, resulting in increased market share.
Manager (Oct, 2003–Nov, 2014) at Essar Steel
• Designed and performed Ad hoc reports and analysis for CEO, President – Global Marketing, Senior VP of Sales and Director of Operations. • Devised effective plans with a view to achieve sales target and profitability by identifying low volume - high income generating customers using K-Means Clustering • Extensive usage of Classification Techniques in Python to scrutinize and track customer behaviour to identify trends and unmet needs. • Prepared weekly sales and collection plan based on the rolling forecast shared by Production team. • Identified opportunities for new segments and territories for sales growth. • Liaise between business and technical personnel to ensure mutual understanding of processes and applications. • Liquidated the stocks and generated cash flow for smooth completion of target. • Participated in Change Management (SAP ECC 6.0) and conducted workshops at all sales locations across the country. • Conceptualized and implemented Cutover Strategy with complete accountability of cutover data.
Education
Post Graduate Diploma in Software Engineering (Jun, 1999–May, 2000) from Mahindra Institute of Software Engineering and Management
B.Tech (Chemical Engineering) (Sep, 1994–Dec, 1998) from Calicut University–scored 71.2
Fee details
₹1,500–3,000/hour
(US$18.10–36.20/hour)
The above charges are purely teaching charges (excluding travelling expenses if any)