Nilotpal Majumder

Data Analytics and Automation Consulant

Deloitte•  September 2022 - Present•  Gurugram, Onsite

Business Line: Consulting, Industry: Financial Services and Sector: Insurance ● Lead a Government project which involves providing data analytics and actuarial consulting to one of the largest states of the US in Medicaid rate setting along with revamping their reimbursement mechanism. ● Developed a VBA-validated cost report tool prototype that identified process leaks & secured a $40 million, 4-year contract by addressing client needs & outperforming a competitor. ● Primarily responsible for the successful delivery of client engagements and initiatives along with development of automation tools to streamline Actuarial pricing procedures. ● Develop and implement data visualization dashboards and reports using Power BI, enabling stakeholders to easily interpret and analyze data. ● Create and optimize ETL processes to ensure the smooth fl ow of data from various sources to the BI platform. ● Perform data analysis to identify trends, patterns, and opportunities for improvement. ● Lead a team (15 members) in executing complex data analysis projects, ensuring timely and accurate delivery of insights and recommendations to key stakeholders.

Intelligent Automation Subject Matter Expert

accenture•  June 2022 - September 2022•  Noida, Onsite

Business Line: Operations, Industry: Financial Services and Sector: Insurance ● Provided thought leadership and participated in projects/initiatives to improve upstream/downstream data fl ows and processes. ● Led the team's eff orts to identify areas where technology and automation could be better leveraged in the process to enable continuous process improvement. ● Maintained process documentations/SOP's and ensured timely and accurate updation. ● Tracked KPIs to drive profi tability and improve business performance and contribute to the development of standard business cases. ● Collaborated with TL/AM in preparing various MIS reports for internal analysis and for the review of Business teams/Owners.

Intelligent Automation Senior Associate

accenture•  September 2019 - May 2022•  Noida, Onsite

Business Line: Operations, Industry: Financial Services and Sector: Insurance ● Supervised automated reconciliation for one of the UK’s leading independent insurance brokers and risk management advisors' ledger through RPA along with exception management that came in the automated workfl ow. ● Identifi ed defects in the data being sent for reconciliation which led to an increase in accuracy of 20%. ● Developed automation tools to eliminate mundane manual tasks which boosted productivity by 35% and reduced manual errors to 0. ● Managed employee training for all new recruits over a 4 month period and off ered continuous advice, guidance and mentorship on duties and best practices. ● Spearheaded 6 deal level initiatives which required leading and supervising a team of POC's (11-15 members) to maintain a rigor on deal-wide metrics. ● Leveraged the capabilities of Power automate tool to transform 6 leadership reports enabling time saving of ~2.5 hrs./day. ● Collaborated with Service Delivery Lead on an automation project which garnered appreciation from Location Lead.

Financial Analyst

accenture•  June 2018 - August 2019•  Noida, Onsite

Business Line: Operations, Industry: Financial Services and Sector: Insurance ● Performed reconciliation for one of the UK's leading independent insurance brokers and risk management advisors' ledger through a 5-way match system. ● Led portfolio of 5 of the Top 10 business generators including query management and maintaining client relations. ● Spearheaded 2 deal level initiatives which required leading and supervising a team of POC's (5-6 members) to maintain a rigor on deal-wide metrics. ● Managed employee training for all new recruits over a 4 month period and offered continuous advice, guidance and mentorship on duties and best practices.