Mukul Jain
Catasauqua,PA
Summary
Seasoned Oracle PL/SQL Developer with a robust 15-year background in programming and business application design using Oracle RDBMS. Specialized in Property and Casualty insurance product development, with significant experience in Majesco Policy Administration System. Proficient in all SDLC phases, emphasizing SQL query performance tuning. Recognized for leadership and problem-solving, consistently achieving project goals within deadlines and budget constraints.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Principal Engineer, Services Implementation for Products (P&C)
Majesco
Morris Plains, USA
12.2015 - Current
- Design and create the Database objects including Table, Function, Procedure, Package, Triggers, Indexes etc. as per product requirement.
- Reviewing / creating / modifying SQL queries and table indexes to improve database object performance and application performance.
- Identifying and analyzing long running SQL queries.
- Design and customize the base product as per customer requirement and insuring the stability, reliability, and performance.
- Translate business requirement into development activity in secure and maintainable code.
- Liaison between developers, business analyst and customer and propose the design of the application based on standards and Lead the Off-Shore team.
- Automate the regular stuff and create the tool to minimize the development effort using Python based tool using libraries like beautiful soup, flask, SQL alchemy etc.
- Migration the database from legacy system to new Majesco Policy Administration System.
- Majesco is a product-based company, and we develop the product for US Insurance Domain. Our Product called Policy Administration System is a web-based application and it’s a database driven application. Our product is highly customizable as per customer requirement through in-house tool kit called Dev Studio(A alternative way to create the database objects through Toolkit).
- Environment & Technologies: Oracle, PLSQL, SQL, Oracle APEX, Java (Servlet and JSP), Jira, SVN, Python.
- Team Size: 8
Product Solution Specialist
Majesco Software and Solution India Pvt Ltd
Pune, India
12.2015 - 01.2019
- Design and create the Database objects like Table, Function, Procedure, Triggers, Indexes etc. as per product requirement.
- Design the new module or enhance the existing module to improve the performance of the application from database point of view.
- Design and customize the base product as per customer requirement as, end application is a database driven application.
- Responsible for Product quality and optimization of PLSQL and SQL code.
- Tech Support to customer, Offshore and Onshore team related to in-house toolkit Dev Studio which is used to configure the database objects.
- Environment & Technologies: Oracle, PLSQL, SQL, Oracle Apex, Java (Servlet and JSP), Jira, SVN, Python.
- Team Size: 8
Senior Executive
Vodafone Shared Services India Pvt Ltd
Pune, India
12.2014 - 11.2015
- Working as a Team Member of Production Support Team and have been involved in various activities, backend operations, day to day issues and Change Request (RFC).
- Resolution of issues directly reported in co-ordination with various teams and support desk.
- Ensuring SLA (Service Level Agreement) adherence by the teams for their respective tasks and ensure actual production support within target time.
- Automate the daily tasks and reports using shell Script and PLSQL code and reduce the total man hours and escalation of critical incident and ensure resolution.
- Document Incident Report, Analysis Report to inherit the experience in future.
- Managing special activities such as CRQ, Patch deployment, Bug fixing and CANVAS Activity with onsite team.
- Vodafone is a global telecom service provider, and I was working for Vodafone Italy to maintain the various telecom application including provisioning, activation, and network.
- Environment & Technologies: Oracle, PLSQL, SQL, Unix, Shell Scripting, Jobs Scheduling.
- Team Size: 28
TBO Executive
IBM India Pvt Ltd
Mumbai, India
02.2013 - 11.2014
- PL/SQL and J2EE (Servlet and JSP) coding for the Application Development and automate the provisioning process and simplify the process/solution for the client.
- Managing Application issues, bug fixing, RCA and resolve issue within the defined SLA.
- Resolution of issues directly reported in co-ordination with various teams.
- Managing special activities such as Application deployment, patch deployment and Application Up gradation.
- Environment & Technologies: Oracle, PLSQL, SQL, Java, .Net.
- Team Size: 6
Assistant Manager
Reliance Tech Services India Pvt Ltd
Mumbai, India
11.2010 - 01.2013
- Working as a Team Member of Provisioning Team and have been involved in various activities backend operations.
- PL/SQL coding for the provisioning process related to provisioning.
- Managing service assurance part of Provisioning.
- Resolution of issues directly reported in co-ordination with various teams of BSS Ops.
- Ensuring SLA (Service Level Agreement) adherence by the teams for their respective tasks and ensure actual production within target time.
- Escalation of critical incidences and ensure resolution. Document Incident Report, Analysis Report to inherit the experience in future.
- Reliance Tech Services is a telecom service provider company.
- Environment & Technologies: Oracle, PLSQL, SQL, Unix Shell Scripting.
- Team Size: 5
Education
Master of Computer Application -
Maulana Azad NIT
BhopalBachelor of Science -
Jiwaji University
GwaliorSkills
- Oracle database management
- PL/SQL programming
- SQL querying
- Oracle APEX development
- Oracle ERP systems
- UNIX operating system
- Shell scripting
- Python programming
- Oracle versions 9i to 12c
- PostgreSQL database
- MSSQL database management
- Java programming
- J2EE framework
- JSP development
- Servlet technology
- Apache Tomcat server
- IIS web server
- Eclipse IDE
- Anaconda distribution
- PyCharm IDE
- DBeaver database tool
- TOAD for Oracle
- SQL Developer tool
- Golden software solutions
- Tora database management tool
- Plus software editor
- Edit Plus text editor
- Ultra Edit text editor
- Notepad editor
- Autosys job scheduling tool
- WinSCP file transfer tool
- PuTTY SSH client
- Jira project management tool
- NetSuite ERP solution
- FileZilla FTP client
- SVN version control system
- Dev Studio development environment
- Windows operating systems (8, 7, XP)
- Ubuntu Linux distribution
- Excel spreadsheet software
- Word processing software (Microsoft Word)
- Presentation software (PowerPoint)
- Email client (Outlook)
- OneNote note-taking application
- Power BI data visualization tool
- Lotus Notes email and collaboration tool
- Lync communication platform (Skype for Business)
- Insurance industry knowledge
- Telecommunications expertise
- Database design
- SQL optimization
- PLSQL programming
- Application development
- Data migration
- Database management
- Critical thinking
- Technical support
- Quality assurance
- Problem resolution
- Team collaboration
- Effective communication
- Project leadership
- Process automation
- Performance analysis
- Solution building
- Big data processing
- Research and analysis
- Software debugging
- Requirements gathering
- Design requirements
- Data modeling
Certification
- AINS-21 Insurance General
- SAFE DevOps
- SAFE POPM
Accomplishments
- Awarded 4 times as Stellar Awards and multiple times with Client appreciation.
- Awarded multiple times as best Trainer and mentor on Insurance Product and mainly on Policy Administrator System.
- Implemented several 'Out of box' solutions to fix the issues and to reduce the development efforts.
Disclaimer
I hereby declare that the above details are true in the best of my knowledge & belief.
Languages
- Hindi
- English
Resume Highlights
15 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)., 10 years of experience on Insurance Product Design and development as per US market norms primarily in Property and Casualty (P&C) Domain., 10 years of experience on Majesco Policy Administration System (PAS) design and development., Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, development, testing, implementation, and maintenance., Analyze and ensure efficient transition of all technical design document and develop various database objects to provide support to application developers., Experience with Data flow diagram, Data dictionary, entity relationship mapping and design techniques., Created Tables, Views, Constraints, Sequence, Indexes (B Tree, Bitmap, Function Based)., Developed complex database objects like Stored Procedure, Functions, Packages and Triggers using SQL and PLSQL., Analyze existing SQL queries for performance improvement and suggest the same to other developers., Upload bulk data into oracle tables using SQL loader and perform the operation on respective data., Create Shell Scripts for invoking SQL scripts and scheduled them using crontab to automate the regular task/process., Partitioned large Tables using range partition technique., Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, and Indexes., Quick learner, Logical skills, willingness to learn new creative problem-solving technique and team player.
Personal Information
- Visa Type: US H1B with I-140 Approved
- Date of Birth: 07/06/86
Timeline
Principal Engineer, Services Implementation for Products (P&C)
Majesco
12.2015 - Current
Product Solution Specialist
Majesco Software and Solution India Pvt Ltd
12.2015 - 01.2019
Senior Executive
Vodafone Shared Services India Pvt Ltd
12.2014 - 11.2015
TBO Executive
IBM India Pvt Ltd
02.2013 - 11.2014
Assistant Manager
Reliance Tech Services India Pvt Ltd
11.2010 - 01.2013
Master of Computer Application -
Maulana Azad NIT
Bachelor of Science -
Jiwaji University