VBA Developer and Sharepoint Developer

Thompsons HR Consulting LLP; Chennai; On-site; INR 450,000 - 650,000; Full time

Job summary

A leading HR consulting firm is seeking candidates to automate various processes and create tools for business reporting. Candidates should have 2-4 years of experience in VBA, SharePoint development, and Excel macros. This full-time position is based in Chennai. Interested applicants should send their resumes to [e-mail].

Qualifications

• 2 - 4 years of experience required.
• Proficiency with VBA for MS Office Automation.
• Experience in SharePoint development, including custom lists and forms.
• Excel macros and dashboarding skills, with data handling from multiple sources.
• HTML scripting for email templates and automation.

Responsibilities

• Automate fund status reporting and various processes.
• Create dashboards/tools for business reporting.
• Support data management operations.
• Automate comparisons and validate part numbers via data sources.
• Develop HTML scripts to trigger auto-mails for pre-check failures.
• Modify and deploy email templates to production and generate reports.
• Build automated processes for SWAT reports and scorecard emails.
• Integrate data inputs from SharePoint and Excel; coordinate with Governance weekly.
• Ensure 98% First Time Through quality on deliverables.

Skills

VBA (MS Office Automation)

SharePoint development

Excel macros

HTML scripting

Strong problem-solving skills

Data handling

Tools

Excel

SharePoint

Excel Macros & Dashboarding

HTML scripting

Job description

Overview

Hiring for one of our clients

Location: Chennai

Years of Experience: 2 - 4 Years

Responsibilities and requirements are described below.

Responsibilities

• Automate fund status reporting, Project ID creation, onboarding/offboarding, and OCM/BPR processes.
• Create dashboards/tools to support monthly business reporting and engagement data management.
• Support data management across SharePoint, shared drives, and Outlook.
• Automate comparison between BOM and Teamcenter data and validate part numbers.
• Develop HTML scripts to trigger auto-mails for pre-check failures.
• Modify and deploy P-Release mail templates to production.
• Generate and populate FTT break-up reports.
• Build fully automated processes for SWAT report generation and scorecard email delivery.
• Automate APT assessments and operator utilization dashboards.
• Integrate data inputs from various sources including SharePoint and Excel.
• Coordinate with the Governance team for weekly updates and reviews.
• Ensure 98% First Time Through (FTT) quality on all deliverables.
• Participate in production roll-out and support post-deployment activities.
• Ensure compliance with NDA and project protocols defined.

Qualifications / Experience

• 2 - 4 years of experience.
• Proficiency with VBA (MS Office Automation).
• SharePoint development (custom lists, forms, permissions, automation).
• Excel macros and dashboarding.
• HTML (for scripting and email templates).
• Strong problem-solving and debugging skills.
• Data handling from multiple sources: SharePoint, Outlook, DB2 queries, and shared drives.

Tools / Technologies

• VBA (MS Office Automation)
• SharePoint Development (custom lists, forms, permissions, automation)
• Excel Macros & Dashboarding
• HTML (for scripting and email templates)
• Strong problem-solving and debugging skills
• Data handling from multiple sources: SharePoint, Outlook, DB2 queries, shared drives

Employment details

• Seniority level: Executive
• Employment type: Full-time
• Job function: Engineering and Information Technology
• Industries: Human Resources Services

Interested candidates kindly forward your resume to [e-mail]

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.