k
kgauravpoddar

Kumar Gaurav

@kgauravpoddar

Certified Top VBA Developer, Excel, Word, Outlook, Automation Expert

Inde
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
💎 Certified Top Rated Excel VBA Developer: Design robust automation for Excel, Word & Outlook. VBA Expert in large scale data automation (1M+ rows), complex workflows, analytics & PDF conversion to maximize your productivity. Specializes in: 🏆 Data Analyst 🏆 Excel VBA 🏆 Word VBA 🏆Advance Excel 🏆 Multi-Layer Advance Formula 🏆 Custom VBA Formula 🏆 Power Query 🏆 Pivot Table 🏆 Dashboard 🏆 Excel Report 🏆 Template Design (Excel, Word) 🏆 Spreadsheet Software 🏆 Custom VBA User Form 🏆 Google Apps Script 🏆 Google Sheet 🏆Google Doc 🏆 Google Forms 🏆Auto Form Responder 🏆 Jotform.... Plus d’infos

Compétences

k
kgauravpoddar
Kumar Gaurav
hors ligne • 

Voir mes services

Consulting en analyse de données
I will create loan calculator with auto generated invoice, agreement
De50 $US / projetPlus de détails
Automatisations
I will develop advance dynamic excel vba spreadsheet software for excel and word, form
De50 $US / projetPlus de détails

Portfolio

Expérience professionnelle

Freelancing_Career

HR Operation, Data Analyst with Microsoft Excel & Word VBA Developer | Delhi Metro Rail Corporation (DMRC)

Freelancing Career • Temps plein

Dec 2016 - Present • 9 yrs 7 mos

HR operations at Delhi Metro Rail Corporation. Transforming complex HR datasets into actionable insights with interactive dashboards, while enhancing operational efficiency by developing automated tools using VBA and Google Apps Script Key Responsibilities HR Operations: Manage end-to-end HR operations data, ensuring accuracy and integrity of employee records, attendance, and payroll Advanced Data Analysis: Utilize Advanced Excel (includes complex Formulas, PivotTables, and Power Query) Dashboards: Design and maintain dynamic, real-time dashboards in Excel and Power BI with visual insights into key HR metrics VBA-Automation: Automation of repetitive HR tasks by developing robust macros and user forms using Microsoft Excel & Word VBA Google Workspace Integration: Automated workflows using Google Sheets and Google Apps Script Data Transformation: Employ Power Query to clean, transform, and consolidate data from multiple sources for advanced analysis in both Excel and Power BI