Surendra Kumar Sinha Advance Excel, VBA & Macro, Dashboard Creation
No reviews yet

Result oriented professional with 15+ years of experience in BPO/KPO and corporate Industries. I have been involved in Developing excel VBA Macros, Online data uploading and downloading through Macros, Data analytics, MIS Reporting. Created Automated Balance Sheet, P&L Account, Bank Reconciliation, supervision of data processing/Mining and data consolidation work. I have a passion for creative innovation and solving complex problems. I am eager to further implement my skills and improve my data analysis experience. Data Cleaning in excel using formulas, SUMIFS, XLOOKUP, Pivot Table, SQL Query, Match, Index, Offset. Data visualizations using Power BI.
Providing Excel Basic, Advance and Excel Macro(VBA) training to professional who are working and students who want to get job.
highly skilled and passionate Advanced Excel and VBA Trainer. Adept at transforming complex data into actionable insights.
specializes in teaching professionals and students how to leverage the full power of Excel and VBA to enhance productivity, efficiency, and decision-making.

Subjects

  • Python Beginner-Intermediate

  • VBA & Macro Beginner-Expert

  • Data analysis and visualization Beginner-Expert

  • Excel (Advanced) Beginner-Expert

  • Excel Dashboard Reporting Beginner-Expert

Experience

  • Deputy Manager Finance and Accounts (Nov, 2021–Present) at Innova Solutions
    Automated manual reporting processes by developing advanced macros and VBA scripts, reducing report generation time by 25 hours per month
    Designed complex data models within Excel to analyses quarterly sales trends across many key product lines, increasing forecast accuracy by 18%
    Collaborated with IT to integrate Excel with SQL databases, allowing for real-time data pulls that supported dynamic reporting capabilities
    Designed Excel VBA to automate sending of daily emails includes a complex process of selecting sets of recipients determine appropriate Outlook template to use, modify template contents and actual release of the email reducing email generation time by 30 hours per month
    Build status visualizations using power BI for operational and executive level
    Assisted with budgeting and forecasting models increase annual accuracy of financial predictions by 18%
  • Manager MIS (Nov, 2015–Nov, 2021) at Mindlance Inc
    Managed large datasets in Excel for market analysis, identifying key growth opportunities that contributed to a 10% increase in market share
    Performed advanced data validation and cleansing to maintain database integrity, assuring high-quality data for business reporting and analytics
    Supported financial team by managing database using SQL improving
    Developed tools for comparing employee names of different client portals using Fuzzy logic and VBA to create dashboard saves 20% effort with 98.5% accuracy
    Developed Divisional Accounting Dashboard in excel from Quick Book using VBA
    Developed payroll comparing Tool and Designed web Macros to upload data on client portal.
  • HR Analyst (Compensation & Benefit) (Jul, 2011–Nov, 2015) at IBM Global Process Services
    Compensation and Benefit, Salary restructuring, Analysis of Attrition Report, Budget for Incentive, Analysis of Budget, Created VBA macros to generate Excel reports, pdf letters like Promotion letter, Transfer letter, Salary Annexure, etc.

Education

  • MCA (Jan, 1999–Jun, 2003) from IGNOU, New Delhi

Fee details

    ₹500–1,000/hour (US$5.92–11.84/hour)

Reviews

No reviews yet. Be the first one to review this tutor.