Prince Rana
Bangalore
Summary
Experienced analytics professional with 5 years of expertise in the e-commerce and insurer domains. Skilled in utilizing SQL, Python, pandas, and numpy to analyze large datasets and extract actionable insights. Proficient in developing and maintaining data pipelines, designing data visualization dashboards, and collaborating with cross-functional teams. Adept at managing complex projects and passionate about exploring innovative solutions to data challenges. Eager to continue expanding skills and knowledge in data science.
Overview
5
5
years of professional experience
Work History
Business Analyst
Medi Assist
Bangalore
10.2021 - Current
- Applied data-driven approaches to enhance claim processing and policy enrollment processes within the insurer domain.
- Utilized SQL Server, Python, pandas, and numpy to analyze insurer domain data, extract actionable insights, and improve operational efficiency.
- Developed and maintained data pipelines to ensure the collection, cleaning, and processing of insurer domain data with high quality and integrity.
- Designed and implemented data visualization dashboards using tools like Google Data Studio to provide stakeholders with intuitive insights into key performance indicators (KPIs) and business metrics.
- Collaborated with cross-functional teams to enhance claim processing tools, reduce manual touchpoints, and automate claim processing using data-driven approaches.
- Implemented cost-saving measures and efficiency improvements by optimizing inefficient processes and workflows in claim processing and policy enrollment.
- Conducted user research and gathered feedback to drive continuous improvement in claim processing and policy enrollment processes.
- Demonstrated strong analytical and problem-solving skills to identify growth opportunities and contribute to strategic business planning in the insurer domain.
- Acted as a liaison between technical and non-technical stakeholders, translating business requirements into technical specifications and ensuring alignment between business goals and technical solutions.
- Communicated regularly with stakeholders to provide project updates, gather feedback, and address concerns related to claim processing and policy enrollment processes.
- Demonstrated strong leadership and teamwork skills, fostering a collaborative work environment that encourages creativity, innovation, and continuous learning.
- Managed the entire claim processing and policy enrollment process, including client interactions, to ensure smooth operations and client satisfaction.
- Worked with insurers to automate the payment generation process, implementing data quality checks and eliminating manual touchpoints to improve efficiency and reduce turnaround time (TAT) for processors.
Technical Analyst
Sapiens
Bangalore
08.2021 - 10.2021
- Understand business requirements and configures medium to high complexity level customer requirements in the system with respect to insurance domain
- Understand the requirements
- Prepare Design document
- Unit Test case preparation
- Configuration of webpages for forms and policies
- Unit testing
- Communicated project status to stakeholders, authoring reports to provide up-to-date overviews of ongoing progress
- Log Analysis
Tech-Ops Associate(Analyst)
Amazon Development Centre Pvt Ltd
Bangalore
12.2018 - 08.2021
- Led a team of analysts responsible for analyzing catalog selection data across various marketplaces, comparing it with competitors worldwide, and providing data-driven recommendations to expand Amazon's product catalog.
- Identified opportunities to improve product selection and sales by analyzing price parity with competitors' e-commerce platforms and implementing strategies to enhance Amazon's competitiveness.
- Developed and implemented web crawling and scraping techniques to gather competitor data on product selection, reviews, prices, and other relevant catalog information.
- Utilized SQL queries to extract and manipulate data from MySQL databases, Hive, and AWS Redshift, ensuring data accuracy and completeness for analysis.
- Built and maintained dashboards using AWS QuickSight, Tableau, and Excel, providing stakeholders with efficient insights and visualizations to inform decision-making processes.
- Acquired data from primary and secondary sources, managed databases, and performed data cleansing and validation to ensure data quality and integrity.
- Wrote XML codes and regular expressions (regex's) for scraping data from competitor websites and executed SQL queries for data extraction and management from Redshift and other internal databases.
- Constructed and debugged queries for team and customer use, facilitating data exchange and communication between stakeholders.
- Conducted data analysis using statistical techniques to interpret results and generate metrics reports, providing insights to stakeholders and guiding strategic decision-making.
- Presented data and conclusions to the team, facilitating discussions to improve strategies and operations, and trained team members on process improvement opportunities.
- Collaborated with development teams to address anomalies and resolve issues identified during data analysis, ensuring continuous improvement and optimization of processes.
Education
Bachelor of Engineering - Electronics And Communications Engineering
Reva Institute of Technology And Management
Bangalore, Karnataka06-2018
High School - Science
Kendriya Vidyalaya No 1 AFS
Darbhanga, Bihar03-2014
Skills
- MS SQL Server
- Tableau
- Excel
- Data Modelling
- AWS Quicksight
- Python
- Power BI
- Pandas
- Numpy
- Google Data Studio
- Big Query
- Data Validation
- Database Programming and SQL
- Product Development
- Business performance analysis
- Analytical Problem Solving
- Data quality
- Statistical Analysis
- Data Analysis
- Reporting Tools
- Google Analytics
- Data Visualization and Presentations
Projects
Developed validation tools to compare previous and current month data, generating insights for users through simple SQL queries. Achieved an 11% reduction in cycle time and a 5.3% decrease in costs. Implemented an Interactive dashboard using AWS QuickSight, reducing manual work by 21% for Associates to validate anomalies and certify data, and enabling Managers and Non-Technical users to access data for daily analysis.
Languages
Hindi
First Language
English
Advanced (C1)
C1
Timeline
Business Analyst
Medi Assist
10.2021 - Current
Technical Analyst
Sapiens
08.2021 - 10.2021
Tech-Ops Associate(Analyst)
Amazon Development Centre Pvt Ltd
12.2018 - 08.2021
Bachelor of Engineering - Electronics And Communications Engineering
Reva Institute of Technology And Management
High School - Science
Kendriya Vidyalaya No 1 AFS
Similar Profiles
Jayasree A. VJayasree A. V
Claims Executive at Medi AssistClaims Executive at Medi Assist
K.Muhammed UmairK.Muhammed Umair
Senior Executive at Medi AssistSenior Executive at Medi Assist
SK MOJAHIDSK MOJAHID
Business development executive at Medi Assist TPABusiness development executive at Medi Assist TPA
Sanjeev Prasad YadavSanjeev Prasad Yadav
Senior IT Infrastructure Manager at Medi Assist Healthcare Pvt. Ltd.Senior IT Infrastructure Manager at Medi Assist Healthcare Pvt. Ltd.
Hisham ParveezHisham Parveez
AI Engineer at Optimum SolutionsAI Engineer at Optimum Solutions