Arun Kumar Sha Sr Email & Phone Number

Chennai, Tn, In

Chennai, Tamil Nadu, India

• Project Name Premia Astra Insurance, the complete insurance management suite delivers best-in-class solutions across multiple insurance verticals with strong domain capabilities for General, Health, and Group life insurance.• Complete business view at all times, with integrated underwriting, claims, reinsurance, and finance modules.• As technical lead of the projects identify and analyze the business needs of the end users and build a project plan to translate the functional… Show more • Project Name Premia Astra Insurance, the complete insurance management suite delivers best-in-class solutions across multiple insurance verticals with strong domain capabilities for General, Health, and Group life insurance.• Complete business view at all times, with integrated underwriting, claims, reinsurance, and finance modules.• As technical lead of the projects identify and analyze the business needs of the end users and build a project plan to translate the functional requirements into technical tasks that guide the execution of the project and implementation of the road map points.• Involved in query optimization and performance tuning using explain plan, hints, indexes, query rewrite, DBMS profiler, SQL trace, TKPROF, and Bulk collection.• Having functionality knowledge in the insurance domain and leading a team of 15 members• Involved in designing the Business intelligence application for the insurance domain using Power BI and Data warehouse concept. Show less

Chennai, Tamil Nadu, India

• Project Name Bsmart, it's a Commercial loan application that provides loans for large-scale industries.• As one of the team members, I tracked the issues and provided the root fix.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PLSQL engines.• Implemented new tax GST in the application

Chennai Area, India

• Project Name Genesis Configurator, It's a general insurance application and my responsibilities are issues fixing and providing support to end users.• Creation of database objects like tables, views, procedures, and packages.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.• Used Pragma Autonomous Transaction to avoid mutating problems in database triggers

Chennai Area, India

• Resolve any critical issues and timely escalation of unresolved issues. Requirement gathering from the client side,• Developed Store Procedure, trigger, Cursor, Functions, views, and packages for data processing. Complex SQL Queries

Chennai Area, India

In the United States, Medicare is a national social insurance program, administered by the U.S. federal government since 1966, currently using about 30-50 private insurance companies across the United States under contract for administration. United States Medicare is funded by a Payroll Tax, premiums and surtaxes from beneficiaries, and general revenue. It provides health insurance for Americans aged 65 and older who have worked and paid into the system through the payroll tax. It also… Show more In the United States, Medicare is a national social insurance program, administered by the U.S. federal government since 1966, currently using about 30-50 private insurance companies across the United States under contract for administration. United States Medicare is funded by a Payroll Tax, premiums and surtaxes from beneficiaries, and general revenue. It provides health insurance for Americans aged 65 and older who have worked and paid into the system through the payroll tax. It also provides health insurance to younger people with some disabilities status as determined by the Social Security Administration Show less

Bachelor Of Engineering - Be, Electrical And Electronics Engineering, 6.24

Bachelor Of Engineering - Be, Electrical And Electronics Engineering