Experience

• 

  Rang technologies

  Jan 2007 - Apr 2011

  Sas programmer analyst

  Industry: Consulting in Clinical Trials/Drug Making IndustryFunction: Data Reporting (Safety and Efficacy)Tools: SAS/BASE, SAS/MACRO, UNIX• Contributed as a Senior Programmer to the clinical trial studies (Phases I-IV) of different therapeutic areas (Central Nervous System (CNS), Oncology, and Pain) by reporting of safety and efficacy parameters to compare the study drug with the comparator drug• Extracted data from Oracle Clinical domain, developed programs and reports (TLF) according to programming plan, table mock shells, and quality assessment/edit checks of various therapeutic areas• Prepared and took ownership of project programming related documents-Programming plan, QC programming plan, and consolidated change management tracking spreadsheet • Performed windowing, generated analysis datasets and reports for different project related populations according to the specifications and requirements in the statistical analysis plan (SAP), and protocol • Responsible for end-to-end delivery of reports cluster for different studies whilst collaborating with the clinical, statistical, and data management team• Generated demographic reports, laboratory reports, subject evaluation reports, listings and tables for adverse events, laboratory tests, and vital signs data for different reporting events-DSMB, IA, 25%-50%-75%-100% data reporting• Provided valuable data-driven insights to statisticians and clinical trial managers that resulted in redefining critical efficacy parameters and notified data managers about data discrepancies • Served as an internal auditor and carried out audits on different projects to check the team’s adherence and compliance to Optimizing Product Delivery Guidelines (OPD) and programming standards Show less

• 

  Capital one

  Apr 2011 - Oct 2012

  Senior data analyst

  Industry: Cards/PaymentsFunctions: Customer Segmentation, Campaign Support, CRM, Client Servicing, Strategy Implementation, Data GovernanceTools: SAS, SQL, JCL, UNIX• Impacted at least 6 million accounts by the implementation of sales propensity models for inbound call routing and punitive fee waiver segmentation strategies for different bank card and retail portfolios • Collaborated with risk teams for a multiple accounts relationship system project that supports Credit Limit Increase and Balance Transfer campaign efforts of the portfolio management team • Supported the monthly processes (call routing, fee waiver, MARs) related to HSBC portfolio to ensure business continuity subject to the temporary service agreement between HSBC and Capital One Financial • Implemented the self-governance documentation for all monthly and weekly activities-preparation of meta-data dictionaries of all monthly files and documented checklists for business continuity within the scope of my profile• Automated the monthly extraction, inbound call routing, and fee waiver segmentations strategies of different portfolios and thus reducing human intervention and saving 25 man hours annually • Performed requirement capture, resourcing, and finally re-designed CRM team’s monthly processes to handle the segregation of portfolios and delivery of respective audits during HSBC-COF transition Show less

• 

  Citibank

  Oct 2012 - Jan 2014

  Assistant manager

  Industry: BankingFunctions: Sales Reporting, Forecasting, Expenses Tracking, Incentive DisbursalTools: SAS, Excel• Responsible for sales analytics and reporting - channel-wise sales productivity and product sourcing, expense tracking(CPA-CPK), planning sales targets, and sales forecasting of retail products• Scorecard preparation for tracking the quality of files, performance-fraud-behavioral patterns of direct sales agents, tracked associated net credit loss at different time points for different products sourced by direct sales agents• Point of Contact for all activities associated with the disbursal of incentives of the sales force at all levels• Managed the analytics for 3rd party performance tracking and sales payouts based on vendor contract Show less

• 

  Allianz

  Aug 2014 - now

  Senior manager

  Industry: Insurance ServicesFunction: Process Mining, Data Analytics, MIS, UAT, Sales/Business DevelopmentTools&Languages: Celonis, R, SAS, SQL, Python, PowerBI, Cognos, Emblem, Risk Modeler, Risk link • Spearheaded the team’s sales development activities that on boarded 3 new contracts (Revenues~ EURO 100k/annually)• Lead a team of 15 including Data Scientists/Data Engineers/Natural Catastrophe (CAT) Modellers and managing functions such as on-boarding of new hires, project delivery, risk mitigation, escalation handling, audit and compliance adherence• Responsible for the development and maintenance of a quote to policy conversion model for an insurance intermediary in the P&C space in the UK market • Identified the factor influencing product selection in P& C space using predictive modelling/Machine Learning techniques- CHAID, decision trees, Gradient boosting method• Studied the impact of legislative change on incentive disbursal, and gender bias on rewards and compensation• Led a team of developers for MI Development activities and UAT testers for testing activities Show less