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)
Hyderabad03-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