k
kgauravpoddar

Kumar Gaurav

@kgauravpoddar

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

India
Inglés
Parte de la información aparece en idioma inglés.
Sobre mí
💎 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.... Lee más

Habilidades

k
kgauravpoddar
Kumar Gaurav
desconectado • 

Revisa mis servicios

Consulta de Data Analytics
I will create loan calculator with auto generated invoice, agreement
DeUSD 50 / proyectoMás información
Automatizaciones
I will develop advance dynamic excel vba spreadsheet software for excel and word, form
DeUSD 50 / proyectoMás información

Porfolio

Experiencia laboral

Freelancing_Career

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

Freelancing Career • Tiempo completo

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