Ranjan Mehto

Administrative and Documentation Specialist

Meerut Kidney Hospital • Full time

Jan 2025 - Present • 1 yr 9 mos

As an Administrative and Documentation Specialist, I manage end-to-end data processing, digital record keeping, and structured administrative workflows. My core responsibilities center around ensuring high accuracy, complete confidentiality, and zero-error documentation across diverse administrative and technical tasks. ​Key Responsibilities & Daily Workflow: • Excel Database & Records Management: Designing customized spreadsheets, organizing large databases, applying data validation rules, and executing advanced formulas to clean datasets and remove duplicate entries. • Claims & Billing Documentation: Handling complex billing summaries, cross-verifying panel queries, drafting official justification letters, and structuring institutional claims with strict compliance and precision. • Digital Document Conversion & Touch-ups: Converting scanned forms, handwritten records, and low-resolution PDFs into clean, standardized Word and Excel files. Performing precision text replacements inside PDF and image files while preserving layouts and typography. • Image Processing & Document Restoration: Using Adobe Photoshop for official document leveling, background cleanup, clarity enhancement, and formal passport-size photo preparation. • Data Verification & Web Research: Conducting in-depth internet research to verify organizational details, extract target contacts, and compile structured reports for operational decision-making. ​Achievements: • Maintained a 99%+ accuracy rate across large-scale billing and verification databases. • Streamlined routine data reconciliation cycles, reducing verification errors significantly. • Upheld strict institutional data confidentiality and security protocols.

HR & EDP Billing Executive

ARENA • Full time

Dec 2020 - Dec 2024 • 4 yrs

Managed end-to-end EDP billing operations, inventory reconciliations, and HR administrative workflows. Maintained structured employee records, digital attendance registers, and commercial billing documentation with high precision. ​Key Responsibilities: • High-Volume Billing & EDP Management: Generated daily customer and dealership invoices, processed inventory receipts, and reconciled sales databases using advanced MS Excel formulas and ERP systems. • HR Administration & Record Keeping: Maintained confidential staff documentation, attendance logs, and internal records ensuring 100% data integrity and zero discrepancies. • Data Validation & Reporting: Applied strict validation checks to prevent billing duplications, executed spreadsheet cleanup, and compiled monthly operational summaries for senior management. • Document Conversion & Archiving: Handled scanned paperwork conversion to structured Word and Excel formats, standardizing layout templates for official internal correspondence.