Ashutosh Trivedi

Oracle-SQL and PL/SQL Professional with 16 years of experience

Majesco Cover-all Dev-Studio Professional with 13 years of experience

Majesco Policy Module Professional with 13 years of experience

Project Management Professional with 11 Years of experience

HIGHLIGHTS

Primary Skills:

Database: Oracle 10g/ 11g/12c SQL and PL/SQL Development

Majesco Dev-Studio development Experience

Domains:

USA Property and Casualty Insurance.

SUMMARY

Around 11+ years of professional Project Management experience in managing multiple (3 to 4) teams of 5-8 team members sizes for multiple different projects in Majesco DEV-studio / Majesco policy Admin module area for same or for different clients.

Around 11+ years of professional experience in managing multiple Teams at different Vendors location and getting the maximum through put and achieving the business deliverables in given time frame.

Around 11+ years of experience in creating new teams (in USA or India offshore location) for Majesco DEV-STUDIO Development and for managing delivery as a single point of contact for entire Majesco policy Module delivery.

Around 16+ years Rich experience with excellent programming skills in SQL and Oracle-PL/SQL technologies in insurance domain that includes exposure to system design, product development, package customization, implementation, migration, testing, debugging, and effort estimations.

Worked in every phase of Software Development Life Cycle (SDLC), developing projects from stage of concept to full implementation.

Highly supportive and enthusiastic team player dedicated to streamlining process and efficiently resolving project issues and have found it rewarding leading and Managing teams of up to 20-30 developers and experts.

Onsite Experience to work on crucial training program for client IT department.

Rich experience of project management processes. Have worked with Clients during planning, requirement phases, planned items estimation and creation of technical design document.

Co-ordinating with business and QA team, helping QA and BA teams during Testing and UAT phases, and provided critical help to QA team in completing all activities on time.

Expert in creating and reviewing technical design documents. Expert in effort estimations by using different project management practices, reviewing of effort estimation, and providing breakup.

Exposure towards highlighting project risk and creation/ execution of risk mitigation plan.

Extensive experience of defect management for multiple projects.

Project management experience includes–

oPreparation and presentation of weekly status reports to clients

oRetrospective meeting and Five-why Analysis

oChange Request Management

oDefect Management

oStakeholders’ management

oCreating roadmaps.

oRelease planning

EDUCATIONAL QUALIFICATION

Master of Computer Applications (MCA) with Specialization in Computer Science and Engineering, National Institute of Technology, REC, Warangal, Telangana

Bachelor of Science with Specialization in Mathematics and Physics, B.S.N.V. (PG) College, Lucknow University, Uttar Pradesh

TRAININGS/ CERTIFICATION

Oracle Database SQL Certified Associate

Oracle PLSQL Developer Certified Associate

Project Management Professional (PMP)®

PMI Agile Certified Practitioner (PMI-ACP) ®

Attended PMP facilitation program.

Attended Insurance Foundation Level Exam and Advanced Excel Training Courses.

EMPLOYMENT DETAILS

Hallmark Financial Services, Inc. Oct’18 to till Oct’23

Worked as Senior Developer from 08-Oct-2018 to till 31-Oct-2023

Synechron Inc. Aug’18 to Sep’18

worked as Assistant Manager - Software from 11-Aug-2018 to 28-Sep-2018

Synechron Technologies Pvt. Ltd, Pune Aug’10 to Aug’18

worked as Assistant Manager - Software from 1-April-2016 to 10-Aug-2018

worked as Team Lead from 1-Jan-2014 to 31-March-2016

worked as Senior Associate - software from 11-Aug-2010 to 31-Dec-2013

Accenture services Pvt Ltd July’07 to Aug’10

worked as Software engineer from 16 -July -2007 to 06-Aug-2010

PROJECT EXPERIENCE

Hallmark Financial Services, Inc. Oct’18 to till Oct’23

Designation: Senior Developer

Description: Managed and directed Digital transformation project for Hallmark Financial Services, Inc. related to below listed 9 products and 16 different Line of businesses for Specialty group and for CIS group for 16 USA states as a part of IT system consolidation project using Majesco Policy admin module and DEV-STUDIO configuration tool

Team Size: 20 to 30

Majesco Cover-All Products for specialty lines group

1.E&S Property (Monoline)

2.ProHealth or Medical Professional Liability (Monoline)

3.ProFinancial Lines

4.Excess Casualty (Monoline)

5.E&S Auto (Monoline)

Majesco Cover-All LOB’s for specialty lines group

1.E&S Property

2.Medical Professional Liability

3.Directors and Officers

4.Employment Practices Liability

5.Fiduciary Duties Liability

6.Miscellaneous Professional Liability

7.Excess Casualty

8.E&S Auto

Other Majesco Cover-All Products for CIS group

1.CIS - Package or Commercial Package

2.CIS - Umbrella or Umbrella (Monoline)

3.CIS - CAP or Businessowners

4.E&S Inland Marine (Monoline)

Other Majesco Cover-All LOB’s for CIS group

1.Property

2.General Liability

3.Inland Marine

4.Crime

5.Auto

6.Umbrella

7.Businessowners

8.E&S Inland Marine

Programming in Majesco Devstudio

Responsible for Application development using Majesco’s Developer studio (as front-end) to enhance and develop new insurance products features to existing Majesco products along with break-fixes and production support and Oracle (back-end), and related PL SQL

Worked on various Majesco software plug-in like Rating, Adoptions, Surcharges, Table, Images, Premium Summary plug-ins.

Developed and configured the Screen changes as per ISO and custom requirements by using Majesco DEV-studio Screen plug in and its different property panel.

Added different rules using Majesco DEV-studio screen plug-in for these various screen customizations and for different validation messages.

Performed multiple activities by using Majesco DEV-studio screen plug-in - like adding new fields in Majesco screen UI, setting up different attribute for these new fields, declaration of new tables, coverages (ratable and not ratable ), lookup design, lookup heading design, logic Development of these new fields, Auto generate logic for these new fields and rows.

Performed ISO Data load and Custom specific Data load using Majesco DEV-studio Table plug-in.

Performed different activities using below Majesco Cover-all DEV-studio plug-ins.

1.Majesco DEV-studio Setup plug-ins’

2.Majesco ISO Data Load plug-in

3.Majesco UI plug-in

4.Majesco Forms and Document plug-in

5.Majesco Dev-Studio adoption plug-in

6.Majesco Dev-Studio Rating plug-in

7.Majesco DEV-Studio Premium Summary plug-in

Oracle 12g, SQL and PL/SQL

Created Complex SQL queries for Majesco Cover-all application for different products.

Creation of new view for new product and new customer

Worked on in implementing, solutioning, Maintaining, enhancing, and automating various modules in Insurance based project using Oracle SQL and PL/SQL.

Deep expertise on all aspects of PL/SQL ranging from standard development (Functions, Procedures, packages etc.) to architectural guidance, expert reviews, performance tuning, deployment.

Ability to accurately estimate, plan, monitor and deliver SQL and PL/SQL based projects, especially in platforms.

Good understanding of methodologies ranging from Waterfall, Distributed and Scaled Agile.

Deep SME on Insurance platform of Majesco DEV-studio, specifically expertise in the Insurance, Policy workflow, Products and Policy Administration Modules.

Have done six from-scratch Majesco digital transformation implementations for 9 products and 16 lob’s, by directing and managing inhouse and vendors locations development team by engaging in and leading tasks ranging from Requirement gathering, Functional Designs, Training and mobilizing team, coding, unit testing, reviewing, test support and go-live support.

Have been architect in the team evaluating complex requirements, choosing integration mechanisms, setting best practices, reviewing key pieces of code, and ensuring the system works end to end.

Have also handled separate migration projects in Majesco Framework.

Handled client interactions and expectations on day-to-day basis.

Handled RFP/RFI for new assignments.

Solving all technical challenges including programming language based i.e., complex PLSQL constructs and queries.

Worked on concepts of table designing and use of advanced SQL and PLSQL concepts such as records and collections and dynamic SQL.

worked as Application Developer and have written PLSQL programming units encapsulated in packages to support enhancements using the existing framework logic and did integration of this code with other existing components.

Used SQL *Plus and Toad Tools for these program unit development, debug, and enhancement activities.

Used Jira application and Confluence application.

Other generic Details:

To provide Dev Estimation for Work orders

Prepared Hot fix scripts.

different software Development using programming skills in SQL and Oracle-PL/SQL technologies in insurance domain.

Implemented very changing and dynamic client requirement in given timeframe for this project.

Analyzed the production issues and discussed with customer regarding it.

Analyzed Business Requirement Documents and Functional specification with Business Analysts, System Analysts and Development Team

Performed Code Review of Team members.

Conducted training for new team members, and quickly learned new features such as data load and rating changes, and forms changes)

Provided quick resolutions on training and setup issues to Cover-All customers to resolve different issues on their environments through WebEx.

Other activities:

1)Majesco Framework related in-Premise environment setup and maintenance.

2)Coordination work with DBA and Rackspace team for different environment related issues on below environments.

3)managed infrastructure team member responsible for upgrading these environments after Majesco month end releases and patch releases upgrades.

1)Development

2)TEST

3)QA

4)UAT and

5)Production

4)Productions jobs execution ownership:

Handled Team responsible for running below types of manuals, semiautomated and fully automated jobs in production.

1)Daily job

2)Weekly jobs

3)Month end job

Directed and managed multiple development Teams for Majesco digital transformations projects for below USA based clients using Majesco Policy admin module, Majesco DEV-STUDIO configuration and SQL and PLSQL

1.Client: Society Insurance Company

2.Client: Hallmark Insurance Company

3.Client: Lexington Insurance Company

4.Client: Secura Insurance Company

5.Client: Majesco Cover-All (Commercial Auto Base Product Team)

Contact this candidate