Experience

RUBIX.
• Banking
• Senior Consultant

  • Jun 2020 - Present


Medibank

• Australia
• Insurance
• 700 & Above Employee

• Data Analyst

  • Nov 2019 - Jun 2020

  Analysed data from different sources and Identified opportunities that promote self-serve such as Payment by Apps , Direct debit which will lead to annualized benefit of saving of ~20 FTE’s and improvement of NPS score Create and deploy various custom reports in Power BI that captures the impact on different KPI’s such as Lapse Rate, FCR(First Call Resolution), RCR(Repeat Call Reduction) and NPS scores for different initiatives Created multiple complex reports using advanced DAX and Time Intelligence functions to implement MTD,YTD, Last Year, Last2years calculations ; Implemented row level security for differentiated access for different teams Automate the weekly and monthly refresh of code for different initiatives in SAS EG Show less



KPMG Global Services (KGS)

• India
• Financial Services
• 300 - 400 Employee

• Manager

  • Nov 2018 - Sep 2019

  Engaging with business partners and delivery teams to ensure projects are delivered on time and with qualityParticipate in Proof-Of-Concepts and RFP’s and contribute in creating capabilities and assets for the organization Synthesize data to provide actionable insights to the leadership and the product team to influence strategy and growth Build dashboards and tools, craft analyses, and tell stories with data to help our teams make better decisions. Primarily used Tableau and Power BI for creating interactive dashboardsDeveloped 20+ custom reports and dashboards for different RPC’s based on their regional requirements in Power BI which uses internal (Salesforce; Adobe Analytics) and external (Brightscope and Morning star) data Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massagingDesigned Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density chartsGood exposure in various Deep learning methods that spans across Text Generation , Summarization and Image Classification tasks. Implemented various projects that uses ANN (Artificial Neural Network), RNN(Recurrent Neural Network), CNN(Convolutional Neural Network) and LSTM (Long short term memory), Bi-Directional LSTM with Attention mechanism to perform Text AnalyticsTaking an active role and collaborate with the leadership team whilst showcasing capabilities to customersUsed Jira and Confluence for Project Management and team collaboration activities Show less

• Assistant Manager

  • May 2017 - Oct 2018

  Liaison with business users and stakeholders and manage their expectationsDeveloped high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applicationsDesigned ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planningDevelop and maintain state-of-the-art advanced statistical and machine learning models (Random Forest, GBM, xGBoost etc.) to fulfill customer requirementsHandled unstructured and structured data using NLP techniques such as Word2vec, Universal Sentence Encoders, NER (Named entity Recognition), Topic Modelling and much more.Involve in Data extraction, transformation and cleaning exercise from multiple data sources that includes databases, web pages and JSON files to create a master dataset that can be used for modelling.Coach and mentor team members and conduct regular sessions with wider audiences on different statistical and algorithmsBuilt a multi-class Classification model on Audit Reports and identifies the major clauses as per ISO 9001-2015 standards; Used Deep bidirectional LSTM model with attention mechanism for implementation Identify trends and insights to support business performanceAutomate the ETL process by writing SQL scripts/ procedures or by using ETL tool such as AlteryxOversee and validate data and reports for consistency, accuracy and completeness Implemented end-to-end machine learning models in collaboration with Client IT Team on AWS cloud using Amazon SageMaker, API Gateway and used Dockers and Kubernetes for deployment of code Created Visualization dashboards for Investment Advisors using internal & external data to cater client’s reporting requirements and provide actionable insights Show less



WNS Global Services

• Financial Services
• 300 - 400 Employee

• Deputy Manager

  • May 2015 - May 2017

   Delivered solutions primarily in Insurance domain for Australia based Insurance giant & built models in Customer Retention, Claim Analytics space  Developed ensembled Anti-fraud model that leverages structured and unstructured data and produced $20 Mn+ impact in motor claims within first 6 months of implementation  Built Segmentation model and churn models to calculate the propensity of Customers to churn and devise strategies as per target  Implemented Sentiment Analysis for the new Insurance product launched on digital platform; Extract data using Twitter API in Python  Implemented Product Recommendation model using Hybrid model approach and identified Cross-sell opportunities for Australia based Insurance  Involved in model validation using statistical procedures and A/B testing for different models developed  Used Python & R extensively for web crawling, data extraction, cleaning, transformation and applying statistical packages for predictive modelling  Automated ETL process by writing PL/SQL procedures and integrating it with Reporting tools on front end such as Tableau/ Power BI Show less



Confluo Inc.

• United States
• Software Development
• 1 - 100 Employee

• Senior Consultant

  • Oct 2014 - Apr 2015

  Interface with business partners within various teams of the client's functional & operational areas to understand the business process, business needs and detailed requirements around data analytics Used Base SAS and SAS-EMiner for the project implementation and analysis. Worked on Product recommendation and churn models and developed interactive reports to enhance end-user experience Used Power BI for creating dashboards and custom reports for retail client Interface with business partners within various teams of the client's functional & operational areas to understand the business process, business needs and detailed requirements around data analytics Used Base SAS and SAS-EMiner for the project implementation and analysis. Worked on Product recommendation and churn models and developed interactive reports to enhance end-user experience Used Power BI for creating dashboards and custom reports for retail client



Foresight Group International AG

• Switzerland
• Pharmaceutical Manufacturing
• 1 - 100 Employee

• Associate Principal

  • Jan 2014 - Oct 2014

  Designed Reports using Cognos Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up) Created Multidimensional models(pyi) and cubes(mdc) using Power play transformerEmployed Data level/object level and package level security in Cognos and Implemented Portlets in Cognos Connection to display the Picklist and Cube refresh status pageDeveloped Cross-sell model using MBA (Market basket Analysis) technique to increase the product penetration.Used SAS E-miner “Association” node to identify the affinity between the 2 or more products to be sold togetherBuilt a classification model (Logistic Regression) to predict the lapsing propensity of business package policy holders and score the current active portfolio to identify “At Risk” customers and suggest recommendationsUsed Decision Tree Model to identify over and under estimated hotspots with specific characteristics/attributes. Rules derived from these segments were applied on total closed claims and 16 Overestimation Hotspots and 10 Underestimation Hotspots identified as High and Medium RiskApplied various unsupervised algorithms such as K-means Clustering and PCA (Principal Component Analysis) on Claims data and derive segments with mild, moderate and high claims basedUsed Base SAS and PL/SQL procedures to perform ETL and data analysis for pharmaceutical giants Show less

• Senior Consultant Technology

  • Jul 2011 - Dec 2013



Aon Hewitt

• United States

• Software Engg. II

  • Nov 2009 - Jul 2011

  Coordinated with onshore counterparts/BA/Users for understanding and gathering the business requirements Writing down Functional Requirement specification and getting approval from the client. Developed customized and ad-hoc reports with varying degree of complexities to provide meaningful insights from the data. Developed visually appealing charts and drill through reports that provides users enhanced flexibility to access detailed reports. Created data models and implemented Data /object level and package level security in Cognos Developed Procedures and functions in the Oracle Database and fine tune the queries to obtain optimum performance Follow the proven guiding principles in the design of EDW(Enterprise data warehouse) and its custom reports. Automate the ETL (Extract , Transform and Load) process by writing Unix scripts and related commands Generate Insights from the Client's data and generate visualizations in Excel and BO Show less



Infosys

• India
• IT System Custom Software Development
• 1 - 100 Employee

• Software Engg.

  • Nov 2007 - Oct 2009

  Understand the user requirements Analyzing business requirements and design of decision support system Worked on creation of Datawarehouse and Datamart for retail giant Created ad-hoc and custom reports of varied complexity using Cognos Framework Manager and Report Studio for retail giant in US Involved in automation of ETL scripts using PL/SQL procedures and Unix scripting Used Cognos power play Transformer to build OLAP multidimensional cubes and provide drill down capability Worked extensively on database and have good exposure in writing optimized SQL queries and procedures Involved in entire SDLC (Software development Life cycle) that includes gathering requirements to writing Functional Requirement specification and testing Show less