Name: Pranav Mali Email: pranavmali004@gmail.
com Mobile: 09730680943
CAREER OBJECTIVE:-
To make a strong career as Oracle Developer for challenging and critical production environment and to be a part
of a team, that utilizes acquired knowledge to provide leveraging Oracle database technology solutions.
PROFESSIONAL SUMMARY:-
Having 9.7 years of IT experience as an Oracle SQL, PL/SQL, IBM DB2, ETL Tool (Extract Transform and
Load) and PostgreSQL Developer in Analysis, Design and Implementation of Business Applications using
the Oracle Relational Database Management System (RDBMS).
Development of new importers and exporters in Eagle ePace tool for Integrating and sending data to
required downstream applications.
Good IT experience in Development and Maintenance of projects using Oracle SQL, PLSQL, IBM DB2,
PostgreSQL, Unix, Shell Scripting, My SQL Server, Forms and Reporting, SSRS and ETL Tool.
Extensive experience in writing/debugging Oracle Back-end PL/SQL development by writing Packages,
Stored Procedures, Functions and Triggers. Strong knowledge in using Oracle packages, Cursor
management and Exception handling.
Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views,
Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL
subprograms, packages, procedures, functions and DB triggers to implement the business logic.
Experienced in Tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record
type, Bulk Collects and Bulk Binds)
Experienced in Tuning using various types of Hints, Partitioning, Indexes, and Explain Plan.
Strong understanding of business processes with good experience in development.
Have got extensive experience of interaction with Client.
Excellent at adapting and picking up new skills in diverse areas.
Demonstrated ability to work as a team player as well as independently.
EDUCATIONAL QUALIFICATIONS & CERTIFICATIONS:-
Oracle Certified Associate 10g
Bachelor of Engineering in Information Technology from Sardar Patel University – 2010 Gujarat.
TECHNICAL SKILLS:-
Language: Scheduler:
o SQL, PLSQL, IBM DB2, PostgreSQL, Python o Crontab, DB Jobs
Tools & Technologies: Database:
o PL SQL Developer, TOAD, SQL o Oracle 10g, Oracle 11g, IBM DB2 9.7
Developer, Oracle Discover, Oracle o SQL Server 2000/2005
Portal, HTML, Cisco Composite tool,
WinSCP, Putty, Eagle ETL, JIRA, Report:
Informatica o SSRS Report
Version Control Tool:
o TFS, SVN, Harvest SCM, GIT
1
Name: Pranav Mali Email: pranavmali004@[Link] Mobile: 09730680943
Project Engagements:
Cognizant Technology Solutions India Pvt Ltd, Pune (13-NOV-2017 to till date)
BNYMellon | Data Integration Team (From 12-Feb-2020 to till date)
Client Name : Bank Of New York (USA)
Team size : 15
Role : Senior Associate
Languages : PL/SQL, SQL, ETL Tool, Unix
Database : Oracle
Project Description
Data Integration of Wealth Management data into EPace Database.
EPace is the application for maintaining Wealth Management Data Warehouse.
Receival of data to EPace Data warehouse from various sources and process it and send to the
downstream applications.
Cognizant Technology Solutions India Pvt Ltd, Pune
CATS - Carbon Asset Trading System (From 21-May-2019 to 04-Feb-2020)
Client Name : World Bank Group (USA)
Team size : 12
Role : Senior Associate
Languages : PL/SQL, SQL, PostgreSQL
Database : PostgreSQL, Oracle
Project Description
Carbon emissions trading is a type of policy that allows companies to buy or sell government-granted
allotments of carbon dioxide output in USA for which we as CTS team develops software applications
using Oracle, PostgreSQL and .Net Technologies.
This is the new project for World Bank group with agile methodology.
Cognizant Technology Solutions India Pvt Ltd, Mumbai
Life Insurance (From 14-Nov-2017 to 20-May-2019)
Client Name : Kotak Mahindra Old Mutual Life Insurance Limited
Team size 8
Role : Senior Associate
Languages : PL/SQL, SQL
Database : Oracle 11g
Project Description
Kotak Mahindra Old Mutual Life Insurance Ltd is a private Life Insurance company in India for which we
as CTS team develops software applications using Oracle and .Net Technologies.
Along with Application development we also provide maintenance for the same and also develop reports
using SSRS technology used by Operational & Management team.
2
Name: Pranav Mali Email: pranavmali004@[Link] Mobile: 09730680943
Tata Consultancy Services, Mumbai (12-NOV-2014 to 18-Oct-2017)
CES (Collection Eco System) (From 14-Nov-2014 to 18-Oct-2017)
Client Name : TCL (Tata Communications Limited)
Team size 8
Role : Software Developer
Languages : DB2, PL/SQL, SQL, Shell Scripting, IBM Process Designer [Link]
Database : IBM DB2 9.7
Project Description
CES consists of Collections, Credit Control, Cash Apps and Dispute Resolution modules.
There are many MIS reports that are extracted from different systems such as SAP, SFDC and Qlikview
etc. Daily monitoring and statistical report are extracted on daily, weekly or monthly basis based on the
schedulers.
The project providing the bulk upload feature to upload large amount of payment and billing customer
data. Invoices settled via RTGS payments and TDS mode that have to be identified to close invoices on
SAP so need to perform invoice allocation.
International Customer Allocation module is designed to move Collector from one Region to another.
Request can be raised by Collector or Regional head for this.
User will raise request of it through UI where user will put target region details. Once request is raised, it
will get flowed to Regional Head of source region for approval. If RH approved, it will get forwarded to
Credit Manager of target region.
Clover InfoTech Pvt Ltd, Mumbai (19-NOV-2012 to 31-OCT-2014)
Core Development and Enhancement (From 23-Nov-2012 to 28-Oct-2014)
Client Name : Kotak Mahindra Bank
Team size : 4
Role : Software Engineer
Languages : PL/SQL, Oracle Portal
Database : Oracle 10g
Project Description
Core application is related to LOANS, used for all the processes starting from Loan agreement to Loan
Maturity.
It includes EMI generation. EMI payments, on completion of loan issuing NOC and also includes payment
through this application.
Everest IT Services Pvt Ltd, Mumbai (01-JUN-2011 to 12-NOV-2012)
ARM (Advanced Reception Management) (From 01-Jun-2011 to 10 -Nov-2012)
Team size 8
Role : Software Engineer
Languages : SQL, PL/SQL
Database : Oracle 10g, MS SQL Server 2005
3
Name: Pranav Mali Email: pranavmali004@[Link] Mobile: 09730680943
Project Description:
The objective is to provide the best possible experience for visiting customers, from unmanaged
disorderly waiting to customized reception with active waiting time information.
ARM is specially designed to bring about order, efficiency and comfort in places such as Banks,
Hospital and Government and other places where people have to wait in line to get a service.
Flexible Token re-direction like “Counter to Counter” or “Service to Service”
Responsibilities:
Worked as Application developer implementing End to End ownership of developing reports from
analyzing the specification till production.
Designing and Developing advance reports based on request.
Worked closely with the business to resolve the production issues on time.
Gather business and functional requirements, feasibility study, Estimate time, design and
develop
Creation of database scripts, users and its execution.
Impact Analysis done for new change proposals & Technical Design Document preparation.
Created stored procedures, functions, packages & triggers.
Clients meetings on regular basis to solve runtime queries.
Interaction with the team regarding requirements and changes.
Registering Custom Applications, Concurrent Programs, Request Set.
Defining Request Groups.
Developed the dynamic pages and forms based on the procedures, tables and views.
Writing, modifying, executing shell script and scheduling the cronjobs on Linux server.
Involved in troubleshooting, monitoring and analyzing the business processes and flow using BPM
(Business Process Management) tools like IBM Process Admin and IBM Process Portal etc.
Requirement gathering, designing and implementation of Business Applications using the Oracle
Relational Database Management System (RDMS)
