Mohammad Irshad

Nationality: Indian Date of birth: 25/05/1995 Gender: Male

 Phone number: (+966) 530862657  Phone number: (+91) 8929147279

 Email address: Mohd.Irshad3210@gmail.com
 WhatsApp Messenger: +919650478137
 LinkedIn: www.linkedin.com/in/mohammadirshad001

ABOUT ME

An Oracle PL/SQL Developer with 8 years of expertise in Oracle 11g/12c, advance PL/SQL, SQL performance tuning
and Oracle forms & Reports development with significant knowledge in Python, Jasper report development and
database migration with utmost quality in past experience so far.

DIGITAL SKILLS

Technical Skills
Oracle 11g & 12c / Oracle 19C / Oracle PLSQL / SQL / Analytical function / Using features like triggers, stored
procedures, function / Advanced Oracle SQL/PLSQL • SQL Tuning / Work knowledge with stored procedures, triggers,
T-SQL, scripts / Database Performance Tuning / Database optimisation / Data analytics and Data modeling / Python
Language - Basic knowledge / Power BI / agile methodologies / Oracle Forms and Oracle Reports / SQLLDR / JASPER
REPORTS / HTML / Data Collection, Data Cleaning, Data Analysis, Data Visualisations / MySQL / unix scripting / Data
Migration / ETL

Tools
PL/SQL Developer / SQL developer / Toad for SQL / Oracle Forms Developer / Oracle Report Builder / Git / Jira / Micro
soft PowerBi / Jenkins SonarQube / JasperSoft iReports / Word, Excel, Power pont intermediate knowledge

Domains
Insurance Domain / Manufacturing Domain / BFSI Domain / Airline Domain / Banking Domain

WORK EXPERIENCE

Lead Database Engineer

Conneqt Business Solution Private Limited [ 12/09/2023 – Current ]
City: Riyadh | Country: Saudi Arabia | Name of unit or department: Property & Casuality Insurance and Motor
Insurance - Business or sector: Financial and insurance activities

❖Working in a small but dynamic team for client Tawuniya which is largest insurance company in Saudi Arabia who
works in all vertical of insurance.

❖Developed wholly new database application in advance PL/SQL for SME Unified Portal which was crucial for the
project in integrating the various key application/modules.

❖Completed Oracle Pl/Sql development of home share product for P&C domain.

❖Implemented Domestic Helper Claim module in oracle PL/SQL and Oracle Forms and Report for P&C insurance
application which automated the claim journey and reduced the time and effort significantly to process the claims by
80%.

❖Created Complex database objects like Stored Procedures, Functions, Packages and Triggers etc using Advance PL/
SQL.

❖Implemented any modification to be made in the various database objects so as to modify data being received
from Central data warehouse.
❖Continuously engaged with the stakeholders for designing & validating test cases and strategy selection so as to
deliver the project on time and with best quality.

Module Lead
Sopra Steria India Private Limited [ 26/05/2021 – 08/09/2023 ]
City: Greater Noida | Country: India | Name of unit or department: ST Microelectronics - Business or sector:
Manufacturing

❖Performed the migration of applications from oracle 10g to oracle 19c successfully and done it’s testing and fixed
all the encountered issues to make sure applications works properly on the new environment.

❖Completed development and maintenance as per assigned CRs crucial for various key application/modules
through PL/SQL and Unix Scripting.

❖Used advance Pl/sql techniques like SQL Performance Tuning, PLSQL Collections, Bulk Collect, Forall, cursors,
Analytical Functions which drastically improved the database performance.

❖Implemented any modification to be made in the various database objects so as to modify data being received
from Central data warehouse.

❖Continuous meetings with the stakeholders for designing & validating test cases and strategy selection so as to
reduce development and testing time & effort.

❖Guided and provide Oracle Pl/sql training to subordinates.

Senior Software Engineer

Coforge Limited [ 17/04/2019 – 25/05/2021 ]
City: Greater Noida | Country: India | Name of unit or department: Passenger Airline Revenue Account(NATG) - B
usiness or sector: Transportation and storage

❖Created Procedures, Functions, Cursors, Triggers, Views and other database objects for enhancement &
maintenance of application for handling of Clients data.

❖Validating, Filtering, Analysis of data and clean up.

❖Worked on creation and maintenance of Oracle D2k Forms and Report.

❖DML and DDL Queries.

❖Import/ Export of data as per requirement.

❖Reporting of data through SQL scripts, as per business logic.

❖Identifying inconsistencies in data.

❖Responsible for resolving bugs and issues found in application.

❖Scheduling & delivering one on one meetings before delivering tasks to Clients.

❖Overall maintenance of NATG’s database of businesses.

❖Guided and trained other colleagues for various aspects of Oracle Database and Jasper Report Development.

Associate Engineering Analyst

QualtechEdge Private Limited [ 26/09/2016 – 04/04/2019 ]
City: Noida | Country: India | Name of unit or department: BFSI - Business or sector: Financial and insurance
activities
❖ Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing,
implementation and maintenance with timely delivery against aggressive deadlines.

❖Created Tables, Views, Constraints, Dbms jobs and Sequences and other database objects for enhancement &
maintenance of application for handling of Clients data.

❖DML and DDL Queries.

❖Effectively made use of Functions, Indexes, Collections, Analytical functions, Materialized Views to improve
performance of the applications.

❖ Developed stored procedures, functions, triggers and packages for validating and migrating the data to target.

❖Imported data from flat files to tables using sql*loader as per requirement.

❖Developed and designed jasper reports and GMM (Graphical Master Maintenance) for end user to maintain master
tables without having technical knowledge.

❖Coordinated with the front end design team to provide them with the necessary stored procedures and packages
and the necessary insight into the data.

❖Coordinated with clients one on one basis for better understanding of project requirements and successful project
deliveries.

EDUCATION AND TRAINING

❖ Bachelor Of Technology In Computer Science Engineering

Dr A.P.J Abdul Kalam Technical University [ 01/09/2012 – 01/07/2016 ]
City: Lucknow | Country: India | Website: https://aktu.ac.in/ | Field(s) of study: Computer Science Engineering
| Final grade: First Class | Level in EQF: EQF level 6

❖ Senior Secondary Education

CBSE [ 01/04/2011 – 31/03/2012 ]
City: New Delhi | Country: India | Website: https://www.cbse.gov.in/cbsenew/cbse.html | Level in EQF: EQF level
3

❖ Secondary Education
CBSE [ 01/04/2009 – 31/03/2010 ]
City: New Delhi | Country: India | Website: https://www.cbse.gov.in/cbsenew/cbse.html | Final grade: 8.0 |
Level in EQF: EQF level 2

LANGUAGE SKILLS

Mother tongue(s): Hindi | Urdu

Other language(s):
English Arabic
LISTENING C1 READING C2 WRITING C2 LISTENING A1 READING B2 WRITING A1
SPOKEN PRODUCTION C1 SPOKEN INTERACTION C1 SPOKEN PRODUCTION A1 SPOKEN INTERACTION A1

Levels: A1 and A2: Basic user; B1 and B2: Independent user; C1 and C2: Proficient user
HONOURS AND AWARDS

Sopra Steria India Private Limited

❖ THE FALCON AWARD Awarded with THE FALCON AWARD by Sopra Steria in Recognition of driving higher
organizational outcomes, resulting in overall enhanced operational efficiency and effectiveness with improved
timeliness and quality of service.

Sachdeva Institute Of Technology

❖ Gold Medal in C&C++ Coding Competition Gold Medallist in C&C++ Coding Competition and Googling
competition in college’s Tech Fest 2015.

UPGrad
❖ Basics of Python certification Basics of Python certification through Upgrad.

Oracle University
❖ Oracle Cloud Infrastructure Foundation 2021 certified Associate Earned Oracle Cloud Infrastructure
Foundation 2021 certified Associate Certification.

COMMUNICATION AND INTERPERSONAL SKILLS

Calm behavior, Punctuality, Honest, Confident Speaker, Flexibility, Ownership, Empathic Listener

MANAGEMENT AND LEADERSHIP SKILLS

❖ CSR Group Head Coordinator We Created a CSR Group "ASHA" under which we adopted a government primary
school to take responsibility of high quality primary education and the academic resources of the school.

I served as Head coordinator of the CSR Group where i managed the team of 30 active members, prepared daily
class schedules with backup schedules, planned commuting facilities, managed individual monetary contributions,
planned extra curriculum activities and taught classes.

❖ Head Coordinator of College tech fest Head Coordinator of IT Department’s tech fest during college in 2016. I
planned and executed the matches among different teams of technical quiz and indoor games.

HOBBIES AND INTERESTS

❖ Passionate about Cycling, Travelling, Web surfing, Physical Fitness Training