Shanu Kumar Email & Phone Number

Noida, Up, In

Bengaluru, Karnataka, India

Project Title: Claims Performance Analytics DashboardOverview:As a Software Engineer in the insurance sector, I spearheaded a pivotal project to refine our claims performance monitoring. Leveraging SQL, Excel, and Power BI, I developed an interactive dashboard offering real-time insights into claims data and Understanding KPI's and business problem from clients to draw conclusions and create dashboard.Data processing: Extracted various econometric data, created newfeatures, and cleaned the data by following Data Pre-Processingtechniques● Performed EDA and Feature engineering techniques like RF Featureselection, stepwise regression to identify important features usingNumPy, Pandas, etc● Segmented data by Algorithms.Performed NLP Techniques like lemmatization, stemming, Bagof words and TFIDF.Key Responsibilities:Data Retrieval and Transformation:Executed intricate SQL queries for precise extraction from insurance databases.Utilized SQL to transform raw claims data into a structured, analyzable format.Power BI Dashboard Development:Designed a dynamic Power BI dashboard visualizing key performance indicators (KPIs) like claim settlements and processing times.Implemented advanced Power BI features for granular data exploration.Automation and Process Enhancement:Deployed automation scripts, reducing manual data manipulation and enhancing claims data analysis accuracy.Streamlined reporting processes, cutting claims performance analysis time by 15%.Collaboration and Training:Collaborated with claims management teams, tailoring the dashboard to their specific needs.Conducted training sessions for claims assessors, ensuring widespread adoption.Technologies:SQL for claims data extraction and transformationExcel for preliminary analysis and preprocessingPower BI for an intuitive claims performance dashboard

Rohtas, Bihar, India

My work is to control 114 centres in which I have to collect and keep the survey data records. Find One way compatibility scores between users using Preference Models. Analyze and present data to the management team in the form of reports using advanced tools and formulas viz. Pivot tables, Charts, VLOOKUP, Index & Match etc. Match making based on Question Answers data of Registration Form+ Business logic. Also Maintaining the integrity of data, Minimizing the data inconsistencies. Performed system analysis and dashboard design, optimization, documentation, and development. Provided administration and technical support, analyzed reports, and identified opportunities for improvement.

Jamshedpur, Jharkhand, India

Analyze manufacturing processes and identify areas for improvement.Supervise team of mechanical engineers to oversee and service day-to-day operations.Design and implement machinery upgrades, overhauls, and replacements.Created detailed structural steel models using industry standard software tools such as AutoCAD.Troubleshoot processes to reduce rates of errors, breakages, and sub-standard production. Ensure project completion within time and budget constraints.

Bachelor Of Engineering - Be , Mechanical Engineering, Mechanical Engineering, A

Data Science

Maths & Statistics | Machine Learning | Deep Learning

Data Analytic

Data Analyst | Python | MySQL | Excel | Power BI | Tableau | Statistics | ETL Tools