Lead Consultant -Excel Expert with VBA
Genpact
5 - 10 years
Bengaluru
Posted: 05/03/2025
Job Description
Responsibilities
:Advanced Excel & VBA Automation:
Excel Expertise:
o Proficient in advanced Excel functionalities, including Power Query, pivot tables, data modeling, conditional formatting, and advanced formulas.
VBA Programming:
o Develops and optimizes VBA macros for process automation, error handling, and report generation.
o Designs custom Excel-based tools for data extraction, transformation, and analysis.
Insurance Domain Knowledge:
Bordereaux Processing:
o Automates bordereaux data processing for underwriting, claims, and premium analytics.
o Implements validation checks to ensure accuracy and compliance with insurance standards.
Data Insights:
o Prepares and visualizes reports for key insurance metrics, enabling data-driven decision-making.
Data Management & Analysis:
Data Integration:
o Merges, cleanses, and transforms complex datasets from multiple sources to deliver reliable reports.
Governance & Quality:
o Implements robust data quality checks and governance processes to ensure consistency and accuracy.
Collaboration & Support:
Partners with data architects and business stakeholders to design and deliver scalable, automated solutions.
Provides end-user support and training for tools and reports, ensuring seamless adoption.
Strengths:
Analytical mindset with a passion for solving complex data challenges.
Strong attention to detail and a proactive approach to optimizing processes.
Collaborative team player, capable of working with cross-functional teams.
Commitment to delivering high-quality solutions tailored to business goals.
About Company
Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).