Bibin Antony

Experience

• 

  IQVIA

  Jul 2015 - Jan 2019

  Extracting data from SQL server, data wrangling in SAS, and modeling done in R or Rapid Miner and results were presented in BI tools and Excel files to stakeholders. Created multiple reports and dashboards for the sales analytics team.•Targeting Best Practice: Optimized salesforce for various pharma clients using Multiple Linear Regression and saving >5 million Euros for pharma clients for a financial year•Pharmacy Targeting: Extracting data from Xponent database using SQL and extrapolating sales using Random Forest Regression approach in R and helping optimize Salesforce budget around 20-40% across years and presenting results using BI tools.•Extrapolation of Icomed data: Extrapolation done based on K nearest neighborhood algorithm for Primary Market Research data.•Delivered outstanding BI service to clients to maintain and extend relationships for future business opportunities and over the years 10% increase in a number of projects. Show less

  • Associate Data Analytics Consultant

    Jun 2018 - Jan 2019

  • Data Analyst

    Jul 2015 - May 2018
• 

  Gallagher

  Jan 2019 - Jun 2022

  Senior Data Analyst Analytics

  Build statistical models, Data Visualization, Data Wrangling, and text mining to provide insights and solve complex business problems with a strong grasp of R, Python, SQL, PowerBI, and Machine Learning in the insurance domain.•Client Retention Analysis: Identify important variables for producers in retaining clients using Logistic Regression in R and result in Looker Studio dashboard on Auto and Home insurance producers.•Cross selling and Whitespace analysis: Cross-selling insurance policies for the UK region using Apriori Algorithm and increase in revenue by 1 million dollars.•Social Media Mining for Sales Enablement: Used text mining to perform analysis for employee feedback about Auto insurance, Home insurance, and other insurance companies and leveraging social media data to help in prioritizing prospects using sentiment score and a 15% increase in new clients from previous years.•Applied data modeling and statistical analysis techniques to note trends and draw conclusions.•Monitors and assesses personal project performance and timelines, and effectively communicates project status.•Implements project controls throughout the project lifecycle within assigned tasks.•Supports the development and design of moderately complex plans, programs, processes, and products.•Assists in creating communication strategies and materials to support new plans, programs, processes, and products, seeking input from stakeholders.•Segment customers based on their claims history, preferences, and risk profiles to personalize the claims handling process, resulting in enhanced customer experiences and retention. Show less

• 

  HSBC

  Jun 2022 - Dec 2022

  Manager - Data Analytics

  Worked in the WPB Analytics team in the Banking domain creating daily, weekly, monthly andquarterly reports using JIRA requests and solutions were made in SAS, SQL, and Qlikview for Australian Market.•Cash transactions performance review report using SAS, SQL, and Qliksense.•Calculated KPI of Savings accounts greater than 1 million using the dashboard.•Trained and guided team members to maintain high productivity and improve performance metrics by 20% using BI tools and Agile methodology.•Automated Daily Mortgage dashboard into monthly reports thereby increasing 25% more resources availability. Show less

• 

  Bk Liquor Inc

  Feb 2023 - Jul 2023

  Data Analytics Consulting

  •Using historical sales data to build a predictive model that forecasts future sales for different types of liquor products using Forecasting techniques and finding hidden patterns in the data. This helped with inventory management and planning for promotions or discounts in advance.•Analyzing customer purchase data to segment customers based on their preferences and buying patterns. This was used for targeted marketing and personalized recommendations using Machine Learning Algorithms in Python.•Building a sales overview dashboard using Looker Studio.•Building a Profitability dashboard to understand how different products perform at various time ranges using Looker studio. Show less

• 

  JIR Ventures Group Inc

  Aug 2023 - Jan 2024

  Data Science Consultant

  •Created automated financial data transformation using Python in Google Cloud Function•Mapping Salesforce and Hyperion data using Python in Excel and fuzzy look-up in python.•Applying clustering techniques using Python to categorize the sales data into useful clusters to categorize the companies.•Document Classification and extraction of financial data sheets using Machine Learning and Pytho

• 

  Sails Software Solutions

  Feb 2024 - now

  Data Science Engineer