Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Pavan Kumar B Hiremath - Pavan Kumar B Hiremath - CV-1

    Uploaded by

    ruhy.bhatia
    CV-2

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Pavan Kumar B Hiremath - Pavan Kumar B Hiremath - CV-1

    Uploaded by

    ruhy.bhatia
    15 views3 pages
    CV-2

    Original Title

    Pavan kumar B Hiremath - Pavan kumar B Hiremath_CV-1

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    CV-2

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    15 views3 pages

    Pavan Kumar B Hiremath - Pavan Kumar B Hiremath - CV-1

    Uploaded by

    ruhy.bhatia
    CV-2

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 3

    PAVAN KUMAR B HIREMATH

    MOB NO: 9880980034


    [email protected]

    Adaptable Data Analyst with 7 years of experience in interpreting and analyzing data for
    driving business solutions. Proficiency in all aspects of Excel and SQL. Experience in
    preparing detailed documents and reports while managing complex internal and external
    data analysis responsibilities.

    PROFESSIONAL EXPERIENCE
    SOROCO INDIA PVT LTD
    Data Analyst. (December 2021 to Present)

    • My role involves writing SQL queries/ python codes to extract data as per requirements from client
    and provide insights around the data
    • Check the data quality and make assumptions as per the SOP for further processing of data
    • Analyze the extracted data and present to clients using Power BI or Excel charts
    • Cleaning data in Excel and CSV formats by writing Python codes
    • Use SQL or Python functions to merge the data and provide reports in Excel file
    • Maintaining track of the projects and following up with clients to provide meaningful insights
    • Train new hires in the team and provide technical support

    CHUBB BUSINESS SERVICES INDIA LLP


    Senior Associate. (July 2021 to December 2021)

    • My role was to perform Account modeling and Portfolio Roll-ups quarterly using RMS Tools
    • Day to Day activities included cleansing of exposure data provided by underwriter and carrying out
    Data Quality Improvements
    • Comparing the exposures, results for the data received and reporting the analysis of losses
    • Perform QA &QC for the work done by the team and lead communication with the clients

    AON CONSULTING PRIVATE LIMITED


    IND Analyst II Reinsurance Solutions. (November 2019 to November 2020)

    • Perform Modeling of Commercial Property and AHL using tools like RL and AIR
    • Assess data quality and make necessary assumptions for modeling and coding of policy financials
    • Preparing model input files & importing data into models with assumptions from the audit report
    • Preparing the questionnaire document and compiling the changes that an account goes through
    during the policy year
    • Perform QA & QC for the work done by team and lead communications with the stakeholders
    • Ability to give effective training and presentations to senior management & other team members
    • Train the new hires in the team. Being their Mentor for any technical issue until completion of
    Probation/go-live

    AIG Analytics & Services Pvt. Ltd


    Catastrophe Modeling Analyst - COE India. (October 2016 to November 2019)

    • Cleansing of data provided by underwriters for property and energy exposures, carrying out Data
    Quality Improvement
    • Generating AAL and TCP through modelling and ascertaining Catastrophic Losses
    • Scrub the Raw data and input them into the system to generate technical cost premium.
    • Performing Standard-Triage on High TIV and High Hazard locations
    • Assisting the Underwriters in finalizing the premiums and help them for documentation
    • Training taken to new joiners on workflow and activities performed

    T D POWER SYSTEMS
    Design Engineer. (August 2015 to September 2016)

    • Handled various projects of steam and hydro generators


    • Optimized standard drawings and designs to improve the efficiency and reduce cost
    • Exposure to AUTOCAD and UNIGRAPHICS

    TOOL KNOWLEDGE
    • Excel, SQL, RMS – (Risk Link, Risk Browser), AIR - Touchstone
    • Basic Knowledge on Python, Power BI, Tableau

    ADDITIONAL RESPONSIBILITIES
    • Assign the accounts and update the tracker daily to ensure the team works effectively
    • Supporting other teams and understanding their work process
    • Conducting weekly call with the offshore counterparts and clients
    EDUCATION

    Qualification Institution Year of passing Percentage

    B.E (Mechanical) M.S Ramaiah Institute of Technology 2015 84.2% (9.17 CGPA)

    PUC M.E.S College of Arts, science, and commerce 2011 85%


    SSLC St. Joseph's Indian High school 2009 90.72%

    HOBBIES & INTERESTS


    • I'm part of a theatre society called Chiraranga and have scripted few plays
    • Miniature diecast car collection and coin collection are my other interests.

    ACTIVITIES & PARTICIPATION


    • Participated in HYBRID GO-CART CHALLENGE.
    • Internship at BEML, Bangalore.
    • Published a paper titled "Design and Fabrication of a pedal-operated Floor mopping Machine" in
    International Journal of Emerging Technology & Advanced Engineering (ISSN 2250-2459,ISO
    9001:2008 Certified Journal),Volume 6,Issue 5,May,2016.

    You might also like