Dhanraj
Summary
Over 11 years of experience in Health & Welfare Domain, including 7 years in leadership roles. Proven track record in managing teams of 8+ and overseeing daily operations, project management, and talent retention. Certified CSPO with expertise in Scrum methodologies, data analysis, and ETL processes using AutoBene Data Mapping. Committed to enhancing client-focused environments through continuous process improvements and effective training programs.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead Specialist-Implementation Services
Aptia Group (previously Mercer)
Gurgaon
06.2022 - Current
- Led a team of over eight professionals in Health & Welfare domain for seven years.
- Managed daily operations and project transitions for more than 40 clients, including 7-Eleven and Transamerica.
- Executed requirement gathering and analysis to ensure alignment with client needs.
- Conducted extensive data extraction, transformation, and loading using AutoBene Data Mapping tool.
- Developed test plans and performed manual testing to validate system configurations.
- Utilized SQL Server, Microsoft Excel/Access, Oracle, and JIRA for effective project management.
- Promoted best practices to enhance team performance and achieve targets consistently.
- Facilitated training sessions and managed talent retention initiatives for global clients.
Lead Analyst
Wipro
01.2021 - 05.2022
- Led a team of 8+ colleagues to achieve business deliverables effectively.
- Converted client requirements into actionable business artifacts.
- Generated daily, weekly, and monthly performance metric reports.
- Executed manual test cases to ensure application quality in Health and Welfare.
- Analyzed functional requirements to enhance application performance.
- Transmitted and monitored client files during renewal periods.
- Updated test cases based on change requests and enhancements.
- Managed bug tracking activities using JIRA for efficient resolution.
Senior Lead Implementation Analyst
Mercer India
03.2018 - 01.2021
- Directed a team of six or more colleagues to achieve business deliverables.
- Analyzed client business and functional requirements to develop analysis artifacts.
- Configured and tested Alight’s Core Benefit Administration System for AON Hewitt Clients.
- Calculated time and cost estimates for new change orders.
- Created, tested, and deployed 834 Engine Files in production.
- Executed system testing and regression testing to ensure quality.
- Developed and executed effective manual test cases for Health and Welfare programs.
- Updated test cases in response to change requests and enhancements.
System Analyst
Alight (Aon Hewitt)
11.2013 - 03.2018
- Analyzed client business and functional requirements to develop comprehensive analysis artifacts.
- Configured and tested Alight’s Core Benefit Administration System for Health and Welfare Benefits programs.
- Created, tested, and deployed 834 Engine Files in production environments.
- Conducted unit testing, system testing, and regression testing to ensure quality assurance.
- Wrote and executed effective manual test cases for Health and Welfare applications.
- Updated test cases based on change requests and enhancements to maintain accuracy.
- Managed bug tracking activities using Maestro tool to ensure prompt resolution.
- Delivered detailed analysis through complex SQL queries and test plans that addressed client needs.
Education
B.Tech. With GPA: 67% - CSE
Guru Gobind Singh University
Delhi01.2013
Skills
- Sprint planning and backlog management
- User story development
- US healthcare expertise
- Project management
- Test planning and manual testing
- EDI engine file management
- Requirements analysis and gathering
- Training development
- Change management
- Process improvement
- System configuration
- Conflict resolution
- Database management (Oracle, SQL Server, MS Access)
- Advanced Excel functions (V-lookup, H-lookup, X-Lookup, Index-match, Pivot Table)
- Project management tools (JIRA, Citrix, Maestro)
Certification
Certified Scrum Product Owner (CSPO)
Accomplishments
- Awarded for client Delivery on 11 clients in very short period of time
- Awarded to Automate the Daily Files review process in Selenium.
- Awarded for Jira Implementation for work management, assigning the tasks and tracking them.
- Awarded for successful delivery of 7 client’s payroll files(Requirement gathering to File delivery).
Languages
Hindi
Proficient (C2)
C2
English
Proficient (C2)
C2
Timeline
Lead Specialist-Implementation Services
Aptia Group (previously Mercer)
06.2022 - Current
Lead Analyst
Wipro
01.2021 - 05.2022
Senior Lead Implementation Analyst
Mercer India
03.2018 - 01.2021
System Analyst
Alight (Aon Hewitt)
11.2013 - 03.2018
B.Tech. With GPA: 67% - CSE
Guru Gobind Singh University
Similar Profiles
Deeksha SoniDeeksha Soni
Plan Administration at APTIA GROUP INDIA PVT LTD (Previously MERCER)Plan Administration at APTIA GROUP INDIA PVT LTD (Previously MERCER)
Mary McGrailMary McGrail
Senior Manager - Implementation Services at Aptia Group US (formerly Mercer)Senior Manager - Implementation Services at Aptia Group US (formerly Mercer)
Joseph MahrJoseph Mahr
Senior Analyst at Mercer - Marsh & McLennan / AptiaSenior Analyst at Mercer - Marsh & McLennan / Aptia
SAMBIIT MISHRASAMBIIT MISHRA
Lead Specialist Implementation Services/Assistant Manager at Aptia Group IndiaLead Specialist Implementation Services/Assistant Manager at Aptia Group India
Prashant KumarPrashant Kumar
<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform