Anurag John

Anurag John Email and Phone Number

Associate Director @ S&P Global Market Intelligence
Ahmedabad, GJ, IN
Anurag John's Location
Ahmedabad, Gujarat, India, India
Anurag John's Contact Details

Anurag John personal email

n/a

Anurag John phone numbers

About Anurag John

A competent professional with 10 years of experience in Research Operations & Financial Analysis of Insurance companies, Customer Relationship management & Financial data modelling and research. Experiences include Product management and research into Insurance Industry, Analysis & Use of Statutory Insurance data and public company data to provide custom solutions to clients (Insurance Clients, Investment Banks, Insurance related firms), Advanced Microsoft excel skills for financial modelling and data analysis, Intuit Quick books for Accounting, Teradata for data warehousing, SQL for data mining and Data warehousing, Erwin for physical and logical data modelling. Specialties include data modelling for financial analysis, Product Management of web based and excel based data products to provide financial data, Analysis and research into Insurance Industry including Statutory and GAAP accounting. Custom analysis into financial data for research, automated templates & publications, Use of SQL for data loading, mining, optimizing query performance and creation of reports according to requirements.Excellent skills in Accounts Payable/ Receivable, Business Intelligence, Data Warehousing, Logical and Physical data modelling, Data mining, Interactive website designing, Microsoft Office and VBA, Unix shell scripting, Operating system management/ networking & providing high level Technical Support.

Anurag John's Current Company Details
S&P Global Market Intelligence

S&P Global Market Intelligence

View
Associate Director
Ahmedabad, GJ, IN
Employees:
16
Anurag John Work Experience Details
  • S&P Global Market Intelligence
    Associate Director
    S&P Global Market Intelligence
    Ahmedabad, Gj, In
  • S&P Global Market Intelligence
    Associate Director
    S&P Global Market Intelligence Apr 2022 - Present
    Ahmedabad, Gujarat, India
    Maintaining and developing the global Insurance & FIG product across various different channels including desktop and DMSWork effectively with end users and clients to provide the best workflow solutions that include new product training, deep industry insights and custom analytical modelsRecurring meetings with senior client stakeholders across insurance companies, insurance brokers, investment banks, consulting & actuarial firms, reinsurance companies and investment management firms to communicate new enhancements and future roadmaps for the Financial institutions productCollaborate across various stakeholders to define product strategy and go to market plansDefining and communicating Financial Institutions product strategy and roadmaps to senior stakeholders and technology teamsManaging resources across FIG product team to ensure successful implementation of key regulatory changes and enhancements that drive deep industry data across Financial institutionsInvolve in extensive market and industry research to drive product enhancements for industry focused usersOverseeing and assisting development of new analytical applications and working to successfully migrate users from old to new platform applicationsEffective collaboration and communication across various teams for successful implementation of FIG product strategyDerive deep industry insights by custom analysis of US Insurance data for clients. Assist in creation of analytical models including risk based capital models for US InsuranceSuccessfully collaborate with industry research group to provide quarterly industry updates to commercialTrack and monitor industry updates across the global insurance industry with focus on US Insurance. Continuous research on Risk Based Capital, Modified Co Insurance and funds withheld reinsurance, Cyber insurance and its pricing, Implementation of RBC regulation across Asia- Pacific, NAIC's Group capital Calculations and ORSA & ESG disclosures by insurers globally
  • S&P Global Market Intelligence
    Senior Product Manager
    S&P Global Market Intelligence Jul 2015 - Apr 2022
    Ahmedabad Area, India
    - Product Management of GAAP and Statutory Insurance data products on the web and excel platforms- Comprehensive research into the US Insurance industry and NAIC regulatory changes to implement annual and quarterly changes on the product- Construct & update analytical models for risk based capital, Global Insurance Tear sheet & Peer Investment comparison for P&C, Life and Health Insurers- Analysis of trends in client usage and enhancement requests to undertake changes on the Insurance product- Conduct training sessions for clients on site or on line. Clients include Insurance companies, Insurance related firms, Investment banks and Accounting firms
  • Snl Financial
    Associate Product Manager
    Snl Financial Sep 2012 - Jul 2015
    Ahmedabad Area, India
    - Product Management of GAAP and Statutory Insurance data products on the web and excel platforms- Use of SQL for data mining and implementing product changes- Analysis of the Insurance Industry to implement product changes - Analysis of enhancement requests by clients (Insurance companies, Investment banks & Insurance related firms) to implement product changes according to client demand- Work with Reinsurance and Investment data for Insurance companies on the GAAP and Stat accounting basis for complex data analysis - Strategic initiatives for implementing product changes for Insurance- Analyze accounting and reporting changes by SEC and NAIC to translate those changes into existing product for Insurance- Understanding client's workflow and implement product solutions accordingly.- Undertake new projects to implement financial metrics, ratio calculations & custom analysis for Insurance data to aid clients- Communicating product enhancements & its importance to account managers, clients and internal stakeholders - Client communication for product training & support.
  • Snl Financial
    Senior Research Analyst
    Snl Financial Nov 2009 - Sep 2012
    Ahmedabad Area, India
    - Handle Custom Client template Projects for complex data analysis for the Insurance Industry- Analysis & Use of Statutory Insurance data from NAIC and public company GAAP data to provide custom template support to clients (Insurance Companies, Investment Banks, Insurance related firms)- Intense use of Microsoft Excel for creation of Client Templates with customized models for analysis- Understanding client requirements, client’s custom analysis and need for research to provide custom client template solutions- Active Client communication by Phone and email for Gathering requirements & Specifications, delivery, follow up and provide support for custom models- Creation & Sharing new documents which provide useful information on Insurance data and share with team members- Share Learning acquired by client interaction in support meetings by presenting on client cases- Research and Develop new techniques in MS Excel along with understanding changes in Insurance data set- Use of SQL and VBA for implementing automation in data products in excel and internal processes
  • Techgene Solutions Llc
    Manager, Accounts
    Techgene Solutions Llc Sep 2008 - Mar 2009
    Irving, Tx
    - Managing Quick Books enterprise edition 9.0 for multiple affiliated companies & handling all matters relating to Accounts Payable and Accounts receivable- Invoicing for payments, payment follow up, dispatching payments to vendors on timely basis- Entering invoice guidelines, running payroll, payment of payroll liabilities, handling payments of office expenses including rent, utilities, Employee Insurance, State and Federal Taxes- Making Employee Federal Tax return forms (W2s), Preparing and filing state taxes- Preparing analysis of cash flow using Microsoft Excel for reporting- Synchronizing online bank accounts with QuickBooks for automated debit and credit transactions.- Serving as an Operational Analyst revamping office procedures, providing assistance in upgrading and networking new computers with latest technology- Management of customer accounts with collection agencies and attorneys for filing legal suits- Handling office networking with management of Quick Books on Windows server 2003- Follow up with offshore team members for pending payments & legal issues relating to contracts, master services agreements and purchase orders
  • Dallas Baptist University
    International Admissions Counselor
    Dallas Baptist University Oct 2006 - May 2008
    Dallas/Fort Worth Area
    - Processing applications for international students for admissions to Undergraduate and Graduate programs- Updating the university website with new and updated information using Macromedia Contribute- Rendering assistance with recruiting students from South Asian Countries & designing orientation programs for new students- Business Development with continuous correspondence and support with existing and new student recruiters in South Asian Countries- Assistance in new student registrations, orientation programs and marketing different academic programs for the university- Assistance in Immigration of new International students with support on visa related issues- Correspondence with DHS (Department of Homeland Security) and USCIS (U.S Citizenship and Immigration Services) for immigration related issues and Pearson VUE and ETS (Educational Testing Services) for TOEFL
  • Icall India Limited
    Customer Service Executive
    Icall India Limited May 2002 - Jun 2003
    Ahmedabad Area, India
    - Handling customer query efficiently and resolving all issues in first instance- Wherever required up sell the appropriate product to customer - Meeting business targets for both quantity and quality & monitoring the quality of support services on voice and email- Formulating & designing training programs relevant to different projects for call agents- Reporting call performance to clients and rectifying errors in call quality

Anurag John Skills

Data Analysis Business Intelligence Microsoft Excel Crm Vba Data Mining Product Management Management Credit Risk Portfolio Management Us Gaap Reporting Property And Casualty Insurance Investment Management Reinsurance Technical Support Pivot Tables Sql Server Management Studio Teradata Data Warehouse Erwin Unix Shell Scripting Physical Data Modeling Logical Data Modeling Website Development Website Creation Microsoft Operating Systems Network Administration Custom Templates Microsoft Sql Server Sql Tuning Query Optimization Life Insurance Quickbooks Tally Erp Oracle Pl/sql Development Us Gaap Statutory Accounting Cost Accounting Statistical Modeling Statistical Data Analysis Matlab Spss 3d Studio Max Maya Dynamics Adobe Creative Suite Corel Draw Illustrator Html Computer Hardware Computer Maintenance Computer Graphics

Anurag John Education Details

Frequently Asked Questions about Anurag John

What company does Anurag John work for?

Anurag John works for S&p Global Market Intelligence

What is Anurag John's role at the current company?

Anurag John's current role is Associate Director.

What is Anurag John's email address?

Anurag John's email address is an****@****snl.com

What is Anurag John's direct phone number?

Anurag John's direct phone number is +131770*****

What schools did Anurag John attend?

Anurag John attended Dallas Baptist University, Gujarat University, Gujarat University, Asia English School, Dallas Texas.

What skills is Anurag John known for?

Anurag John has skills like Data Analysis, Business Intelligence, Microsoft Excel, Crm, Vba, Data Mining, Product Management, Management, Credit Risk, Portfolio Management, Us Gaap Reporting, Property And Casualty Insurance.

Not the Anurag John you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.