k
kgauravpoddar

Kumar Gaurav

@kgauravpoddar

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

Indien
Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
💎 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.... Mehr lesen

Kompetenzen

k
kgauravpoddar
Kumar Gaurav
offline • 

Meine Dienstleistungen

Datenanalyse-Beratung
I will create loan calculator with auto generated invoice, agreement
Ab50 $ / ProjektWeitere Details
Automatisierungen
I will develop advance dynamic excel vba spreadsheet software for excel and word, form
Ab50 $ / ProjektWeitere Details

Portfolio

Arbeitserfahrung

Freelancing_Career

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

Freelancing Career • Vollzeit

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