Ankita Atorthy

Experience

• 

  Xceedance

  May 2016 - Jun 2018

  Process Expert - Insurance

  -Developed ideas for an automated clearance tool, reducing manual efforts in policy clearance checks.-Managed broker database through a universal log with unique broker codes.-Contributed ideas for designing and developing I-Next, an automated policy reservation tool.-Served as a Single Point of Contact (SPOC) for the region, focused on reducing Average Handling Time (AHT) for declined businesses.-Managed client data from various sources utilizing SQL, employing Alteryx for efficient data wrangling. Generated reports using advanced Excel formulas and KPIs for comprehensive analysis. -Utilized tools like Duck Creek and Genius for submission coding and reporting, achieving 95% reporting efficiency and 99% accuracy.-Designated as the primary client interface, entrusted with spearheading client meetings, conducting walkthroughs, delivering minutes of meetings (MOMs), independently addressing client inquiries, and providing necessary training.-Led 4 cross-team projects, optimizing workflows through collaborative efforts with regional teams. Effectively managed initiatives.Achievement:Recognized repeatedly as a high performer for initiating process refinements from inception and adeptly managing priorities. Show less

• 

  AXA XL, a division of AXA

  Jul 2018 - Apr 2021

  Risk Analyst

  -Proficiently converted large and complex datasets into model-readable formats following RMS guidelines, hands-on expertise with widely used models like RiskBrowser, RiskLink-Conducted in-depth analysis of Gross and ground-up loss cycles, AAL’s (Average Annual Loss), TVars’s (Tail Value at Risk), standard deviation, variance, and other parameters crucial for forecasting expected losses. -Collaborated closely with underwriters, provided insightful analysis reports to support pricing and underwriting decisions. Additionally, excel in handling modeling slips, reading reports, and applying policy special conditions. -Proactive in taking up direct projects and ad-hoc requests, they aim to contribute their expertise to enhance the cat modeling process.-Created an Excel tool with advanced features and VBA to automate the manual application of campus functionality in primary building accounts, improving process efficiency and saving Full-Time (FT) resources. Recognized with an i2i (innovation) award.-Developed a Power Query and VBA tool for the accounts database model. Enables access to relevant information with user inputs from a centrally placed database. Management-approved and universally utilized with restricted user access through VBA perform Show less

• 

  RMS

  Sept 2021 - Sept 2022

  Lead Risk Analyst( Technical Specialist)

  -Applied risk models such as RiskLink, Risk Browser, and peril-specific models to assess earthquake, windstorm, and flood risks etc- Conducted simulations to estimate financial impacts on insured assets.- Performed comprehensive data cleansing to rectify inaccuracies and standardize data formats.- Employed advanced geocoding techniques to convert addresses into precise geographic coordinates.- Mapped geographic distribution of risks and conducted spatial analysis.- Managed and manipulated data using SQL Management Studio.Integrated data from multiple sources and optimized SQL queries.- Ensured efficient database management for risk modeling.- Assessed property conditions and updated risk details based on survey reports.- Incorporated risk mitigation measures and adjusted risk profiles accordingly.- Analyzed model outputs and presented findings to underwriters.- Offered actionable suggestions for risk mitigation and management.- Modeled Diverse Policy Structures , Conducted scenario analysis to understand impacts of different policy structures.- Estimated potential losses and evaluated relative risk for various policy options.- Conducted regional risk analyses for North America, Europe, Asia Pacific, and the Arab Gulf.- Ensured compliance with local regulatory requirements and provided region-specific recommendations.- Prepared detailed loss reports and summarized impacts on loss computations.- Provided clients with recommendations for improving risk management and reducing expected loss (EP) estimates.- Conducted ongoing research to validate and update location data.- Implemented quality improvement initiatives to enhance data reliability leading to accuracy and quality improvement- Handled Large and Poor-Quality Data by utilising Power Query, Excel macros, and Alteryx to transform and clean large datasets.- Automated data processing tasks to improve efficiency and ensure timely data preparation. Show less

• 

  SBI Card

  Sept 2022 - Apr 2024

  Senior Manager Risk MIS(Portfolio Analytics and Reporting)

  -Tracked NPA levels, credit costs, and provisioning to ensure financial stability and regulatory compliance.-Utilized month-end predictions and multiple portfolio cuts for precise and timely reporting.-Collaborated closely on regulatory reporting, ensuring adherence to RBI requirements and facilitating smooth internal and external audits.-Refreshed quarterly expected credit loss models using PD, LGD, and EAD parameters for accurate risk assessment.-Conducted in-depth portfolio analysis, identifying stress segments and recommending adjustments in multi-department strategies, resulting in a direct reduction in credit costs.-Conducted ad-hoc analyses to address specific business questions, leveraging SQL Server and SAS for data manipulation and analysis.Achievement:Honored with the Champion of Quarter award for exceptional portfolio analysis, which directly contributed to cost reduction and improved risk management strategies. Show less

• 

  Emirates NBD

  Aug 2024 - Jan 2025

  Consultant BA - Portfolio Management

  -Utilize SAS and SQL to extract, manipulate, and analyze data from various sources.-Identify data inconsistencies, glitches, and anomalies, and develop solutions to address them.-Work closely with stakeholders to understand and rectify data-related issues.-Oversee the development, testing, and optimization of multiple dashboards across various platforms.-Implement corrective measures and preventive strategies to minimize future discrepancies.

• 

  Amazon

  Feb 2025 - now

  Senior Risk Analyst , Corporate Risk (GRMC)