Roopesh Janmanchi Email & Phone Number

Mumbai, MH, IN

Work From Home

• Handled analytical projects, ensuring timely completion and developed real time dashboard to enhance business performance.
• Built and maintained dashboards and addressed data pipeline failures, resulting in an 80% improvement in overall dashboard performance
• Developed and optimized SQL queries for building efficient data pipelines, ensuring seamless data flow
• Produced in-depth written analyses for Business Reviews that supported top-level executive decision-making.
• Re-engineered data processes and workflows, achieving major advancements in operational efficiency and procedure optimization.
• Enhanced team efficiency and collaboration by leveraging Google Workspace tools and setting a new internal communication and project management standard.

Hyderabad, Telangana, India

• Oversaw end-to-end development, from requirement gathering to testing, while providing data-driven insights for Health Vertical.
• Directed the comprehensive product roadmap for critical industry-level applications, including Health Insurance Portability and Rural Insurance.
• Spearheaded the implementation of Health Vertical initiatives in alignment with IRDAI's directives, driving significant advancements in insurance through strategic execution.
• Crafted customized reports for key stakeholders such as insurance companies, the Department of Financial Services (DFS), and the National Health Systems Resource Centre (NHSRC), providing essential insights for.
• Expertly managed the full requirement gathering, feature development, testing, and defect tracking lifecycle, ensuring robust functionality. Secured accessibility of the Product Backlog, maintaining clear visibility.
• Collaborated with senior leadership to develop data-driven reports and conduct in-depth analyses.

Maharashtra, India

• Supervised communication and reporting processes to ensure timely updates and accurate data handling.
• Orchestrated adequate communication with development teams to ensure accurate and timely updates on application changes, enhancing data integration and analytics accuracy.
• Managed 10-12 reporting processes (IIB, IRDAI) for diverse teams, ensuring the accurate presentation of data and facilitating strategic insights.
• Participated in manually reviewing and refining test strategies and 40-50 test plans to ensure comprehensive coverage of expected outcomes.
• Monitored project progress precisely, identifying and escalating issues to IT management, safeguarding data integrity, and project success.
• Delivered comprehensive and regular updates on product status to management and stakeholders, ensuring transparency and enabling data-driven decision-making.

Led integration projects for top clients like Maruti and Tafe, ensuring seamless data migration and system reliability. Oversaw motor policy transitions, conducted UATs, and optimized business processes for evolving data needs, delivering consistent operational excellence. Regularly provided strategic project updates to drive outcomes

Mumbai Area, India

Forged a strategic partnership with LIC to deliver comprehensive insurance services, boosting business growth. Led the nationwide rollout of a tablet-based policy issuance system and trained staff for seamless adoption.

Mumbai

Managed claims processing for RSBY, Artisans & Weavers and ensured timely reporting to stakeholders. Supported fraud investigations, RTI queries, and audit data requirements.

Mumbai Area, India

Handled payroll for 100+ personnel, supported audits, generated invoices, and optimized reporting processes for streamlined record-keeping.

International Post Graduate Diploma, Risk Management

Fellowship, Insurance

Fellow of Insurance Institute of India

Bachelors, Commerce; Accounting & Finance