Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Roopesh Janmanchi

Hyderabad

Summary

  • Results-oriented Senior Consultant with extensive experience in designing and implementing data pipelines from the ground up, leveraging SQL and Excel to create detailed dashboards that empower business partners to make data-driven decisions.
  • 8-year veteran Business Analyst with a strong focus on software development projects in the Indian Insurance Industry, bringing a total of 14 years of professional experience.
  • Collaborative professional with a demonstrated ability to work closely with business users, project stakeholders, and Subject Matter Experts (SMEs) to fully understand and translate high-level business requirements into detailed specifications for both new applications and enhancements.
  • Expert in requirement gathering and in drafting thorough Functional Requirements Specifications/Documents (FRS/FRD).
  • Proficient in executing User Acceptance Testing (UAT) and in documenting test cases.
  • Skilled in managing and tracking requirements through the use of Requirement Traceability Matrix (RTM).

Overview

16
16
years of professional experience
1
1
Certification

Work History

Senior Consultant

Fractal Analytics
Client Name:Google
08.2022 - Current
  • Developed visually appealing global dashboards by extracting data using SQL
  • Optimized data handling and enhanced efficiency of workflows.
  • Contributed meaningful written insights for the Business Review.
  • Achieved an 80% improvement in dashboard loading speed by identifying and resolving issues and implementing standard dashboard creation practices
  • Ensured efficient coordination and collaboration among team members to optimize productivity.
  • Adept at leveraging the functionalities of Google Workspace to optimize teamwork and facilitate seamless operations.
  • Performed adhoc analysis to meet client requests

Business Analyst

Insurance Information Bureau of India
Hyderabad
12.2020 - 06.2022
  • Implemented Health Vertical initiatives directed by IRDAI or in accordance with the established roadmap for respective financial periods.
  • Owned and implemented product Roadmap for Industry-level applications such as Health Insurance Portability, Rural Insurance, Network Provider Rating, and Health Insurance Application.
  • Documented requirement gathering, creation of features, testing, and defect tracking for developed applications.
  • Ensured transparency, visibility, and comprehension of the Product Backlog
  • Developed personalized reports for Insurance companies, Department of Financial Services (DFS), and National Health Systems Resource Centre (NHSRC)
  • Collaborated with the leadership team to develop reports, analyze data, and facilitate effective business presentations.

Chief Manager

Kotak Mahindra General Insurance Co. Ltd.
Mumbai
04.2020 - 11.2020
  • Facilitated effective communication with developers to relay changes and updates for company applications.
  • Contributed to the review process of test strategy, plans, cases, and expected outcomes
  • Maintained regular monitoring and updates on progress against plan, immediately alerting IT management about any issues.
  • Kept management and stakeholders informed with frequent updates on product status.
  • Managed reporting obligations for various teams

Business Analyst

HDFC ERGO General Insurance
Mumbai
04.2015 - 05.2017
  • Led execution of integration projects for Maruti, Tafe, and Channel Portal. Managed tasks including requirement gathering, analysis, and documentation.
  • Contributed to the seamless transition of unexpired motor policies from IDIT to Genisys application.
  • Implemented user acceptance testing by documenting defects and executing test cases.
  • Overlooked the functioning of both Change the Business (CTB) and Run the Business (RTB) operations.
  • Kept reporting manager updated on project progress and developments at key stages.

Manager-CIE

L&T Access Distribution Services Limited
Mumbai
12.2013 - 03.2015
  • Established a partnership with the Life Insurance Corporation of India and functioned as a composite corporate agent to provide all-inclusive insurance services, enhancing customer satisfaction.
  • Successfully oversaw the implementation of tablet-based Policy Issuance system across the country, driving business expansion and advancement.
  • Ensured staff were proficient in tablet-based policy issuance, resulting in a smooth transition.
  • Implemented and executed newly designed procedures

Customer Service Manager

ICICI Lombard General Insurance Company Limited
Mumbai
04.2010 - 11.2013

Account Executive

Auditime Information System (I) Limited
Mumbai
06.2008 - 07.2009

Education

International Post Graduate Diploma - Risk Management

Institute of Insurance And Risk Management (IIRM)
Hyderabad
03-2010

Bachelors - Commerce; Accounting & Finance

K.J. Somaiya College of Science & Commerce
08-2008

Skills

  • Dashboard Building
  • Data Pipelines
  • Data Quality
  • Business Analysis
  • Project Documentation
  • Data Analysis
  • Requirements Gathering
  • Problem Solving

Certification

  • Professional Scrum Product Owner I (PSPO I)
  • Fellow of Insurance Institute of India
  • Certification of Completion on HIPAA Security and HIPAA Awareness for Business Associates

Timeline

Senior Consultant

Fractal Analytics
08.2022 - Current

Business Analyst

Insurance Information Bureau of India
12.2020 - 06.2022

Chief Manager

Kotak Mahindra General Insurance Co. Ltd.
04.2020 - 11.2020

Business Analyst

HDFC ERGO General Insurance
04.2015 - 05.2017

Manager-CIE

L&T Access Distribution Services Limited
12.2013 - 03.2015

Customer Service Manager

ICICI Lombard General Insurance Company Limited
04.2010 - 11.2013

Account Executive

Auditime Information System (I) Limited
06.2008 - 07.2009

International Post Graduate Diploma - Risk Management

Institute of Insurance And Risk Management (IIRM)

Bachelors - Commerce; Accounting & Finance

K.J. Somaiya College of Science & Commerce
Roopesh Janmanchi