Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Timeline
Generic
Himanshu Rautela

Himanshu Rautela

New Delhi

Summary

Results-focused and proactive in planning day-to-day operations and solving service issues. Offers advanced abilities in tackling issues that impact team and business success. Excels at managing team and personal time to consistently exceed expectations.

Strong expertise in business analysis and project management within U.S. health and welfare. Successfully led teams to improve performance through strategic planning, training initiatives, and compliance oversight. Proficient in requirements gathering, configuration management, and defect tracking using JIRA and ServiceNow. Skilled in SQL for data analysis and report generation, aiming to drive organizational success and innovation.

Overview

11
11
years of professional experience

Work History

Manager Implementation Services

Aptia Group India
Gurugram, Haryana
01.2024 - Current
  • Monitored staff performance and created targeted improvement plans.
  • Developed and delivered comprehensive training programs, enhancing team skills and performance.
  • Conducted performance reviews, recognizing high achievers and identifying areas for development.
  • Cultivated a work environment emphasizing personal responsibility and continuous improvement.
  • Investigated operational issues, preparing detailed reports with actionable recommendations.
  • Oversaw regulatory compliance, achieving successful inspections without violations.
  • Supported employee morale through positive career development practices.
  • Led a collaborative team of 10 employees to efficiently meet project deadlines.

Lead Business Analyst

Mercer India Private Limited
Gurugram, Haryana
07.2021 - 12.2023

Renewals Client.

  • Gathered and analyzed requirements through continuous interactions with client team members and stakeholders.
  • Designed and implemented new workflows using SQL functions, joins, and stored procedures.
  • Hosted project status meetings to provide guidance and training for team implementation, and product testing.
  • Created reports to track and analyze data for business insights.

QA and transmission of files project.

  • Created various types of files, including Carrier, VIP, and Payroll files.
  • Participated in recruitment processes, assembling teams aligned with business objectives.
  • Developed optimized queries to collect data for population eligibility testing.
  • Verified and validated files to ensure utmost accuracy.
  • Tracked requirements in JIRA and SharePoint, producing dashboards for project status assessment.

Business Analyst

Conduent Business Services India Private Limited
Greater Noida
03.2017 - 06.2021
  • Ensured quality sign-off on completed projects.
  • Collaborated with onsite counterparts to gather and clarify requirements.
  • Identified requirement gaps and promptly corrected PRD/BRD documentation.
  • Designed and implemented new workflows utilizing SQL functions and stored procedures.
  • Configured system, conducted unit testing, and debugged TBO system per client specifications.
  • Prepared test data and secured testing environment prior to execution.
  • Executed functional, integration, and regression tests for new functionalities and enhancements.
  • Analysed business processes to identify inefficiencies and recommend improvements for operational excellence.
  • Documented process flows and created user manuals to support effective change management.
  • Managed cross-functional teams to deliver project outcomes within agreed timelines and budgets.
  • Led user acceptance testing to validate functionality and performance against business requirements.

Setup Configuration Specialist

Aon Hewitt
Gurugram
12.2014 - 02.2017
  • Implemented analysis handoffs from Sr. SCA and System Analysts into system configurations.
  • Configured and tested new requirements to ensure functionality.
  • Created comprehensive test plans by identifying testing scope and approaches.
  • Executed testing, debugged defects, documented issues, and tracked through task management.
  • Developed SQL queries for data analysis and report generation.
  • Mentored two SCSs in configuration and testing processes.
  • Engaged with clients regularly to communicate project status and maintain logs in JIRA.

Education

Bachelor of Technology - Computer Science

Dronacharya Group of Institutions, Dr. A. P. J. Abdul Kalam University (formerly Known As UPTU)
Greater Noida
07.2014

Intermediate

Kendriya Vidyalaya Pragati Vihar
New Delhi
06-2010

Skills

  • US health and welfare expertise
  • Business analysis
  • Requirements gathering
  • Configuration management
  • Defect tracking
  • Documentation control
  • RTM compliance
  • TFS, JIRA, HPQC, and ServiceNow proficiency
  • MS SQL Server and MySQL
  • Time management and organization
  • Business requirements documentation (BRD)
  • Functional requirements documentation (FRD)
  • Standard operating procedures (SOP)
  • Unit testing
  • Integration testing
  • Regression testing
  • Re-testing processes
  • Risk mitigation strategies
  • Staff performance management
  • Employee training programs
  • Regulatory compliance oversight
  • Project management methodologies
  • Strategic planning

Accomplishments

  • BU Super Star (team award), 12/01/18
  • Honor Roll (individual award), 06/01/19
  • Super Star (individual award), 06/01/20
  • Starlight (individual award), Q4 2024

Timeline

Manager Implementation Services

Aptia Group India
01.2024 - Current

Lead Business Analyst

Mercer India Private Limited
07.2021 - 12.2023

Business Analyst

Conduent Business Services India Private Limited
03.2017 - 06.2021

Setup Configuration Specialist

Aon Hewitt
12.2014 - 02.2017

Bachelor of Technology - Computer Science

Dronacharya Group of Institutions, Dr. A. P. J. Abdul Kalam University (formerly Known As UPTU)

Intermediate

Kendriya Vidyalaya Pragati Vihar
Himanshu Rautela