Sql Information Technology

PRASHANT JHA

Email: ***.**********@*****.***

Cell: 484-***-****

PROFESSIONAL SUMMARY

IT professional with 4.5 years of experience as Oracle Developer, with strong technical Knowledge in development of Oracle PL/Sql entities like Objects, Cursors, Procedures, Packages, and Triggers.

Greater understanding and knowledge in requirement analysis, technical design, functional design, development, testing, maintenance, and support.

Developed custom packages and interfaces using Oracle PL/Sql.

Worked on the Optimization of Pl/Sql codes and Sql queries.

Experience in all phases of SDLC focusing on Pl/Sql application development in R&D and financial domain.

Excellent conceptual knowledge of Oracle 9I, 10G, 11G,12C

Extensive experience in database programming in Pl/Sql and Sql following industries best practices.

Extensively used advanced Pl/Sql concepts like collections, record types, Ref cursors and bulk collect operations.

Experience on materialized views, nested tables, objects, autonomous transactions and dynamic Sql.

Experience working with PL/SQL CLOB and BLOB data types

Knowledge in Debugging code and Performance tuning using Indexing and Partitioning.

Ability to learn & develop using new technologies quickly.

Hands on in analysis, database design and development in Agile environment.

Excellent communication and interpersonal skills developed through active participation in various team projects with a desire to work in diverse technologies.

Worked on concepts with respect to core java.

Knowledge on Unix related commands with shell scripting.

TECHNICAL PROFICIENCIES

Methodologies: Agile Methodology, Waterfall Methodology, Test Driven Development

Application Development and IT Operation Support: Banking and Financial Services, Investment Banking

Technologies and Programming Languages: Oracle Pl/Sql, Sql, Core Java, Unix/Shell Scripting

Software: Sql Developer, Git Hub, Toad, Oracle Sql Developer, Sql Loader

Database: Oracle 11g, Oracle 12c

Others: XML, Control-M, Microsoft Office

SWIFT messaging

Oracle OEM 12c.

RELEVANT EXPERIENCE

Forex Settlements: SEI Investments, Malvern,PA

01/14 - Present

Database Developer and Designer

SEI is a leading global provider of institutional and private client wealth management solutions, including asset management, investment processing, and investment operations. They help professional wealth managers, institutional investors and private investors create and manage wealth -- and enable their long-term success by providing solutions that are both comprehensive and innovative.

Creation of DB services via PL/Sql for FX models with respect to spots and forward transactions.

Creation of DB Services for the SWIFT Messages and passing them to UI via PL/Sql concepts like objects, functions, procedures, collections, triggers.

Implementing the use of GTT, Views and Collections in PL/Sql.

Creating the business validation in PL/Sql.

Handling the Performance related issues in the code via PL/Sql tuning.

Worked on Partitioning and indexing on the tables to optimize the Sql query.

Worked on the batch frame work for various FX related transactions.

Created PL/Sql batch codes for the batch frame work.

Extracting and Using AWR reports from OEM for tuning PL/SQL codes.

Working on standard DBMS packages for streaming of messages in the OAQ.

Change Systems: JP Morgan & Chase, Bangalore,India

11/12 – 12/13

Oracle Database Developer

JPMorgan Chase is an American multinational banking and financial services holding company. It is the largest bank in the United States.

In JPMC we created the Interface where the data from upstream was loaded in stage table and then we created various PL/Sql packages and procedure which performed the various validation to load the data into the base table.

Worked on the migration of data from subsystem database to system database using PL/Sql.

Creation of Custom PL/Sql Packages, Procedures, and triggers for various towers of Deposits and mortgages.

Worked on Partitioning and indexing on the tables to optimize the Sql query.

Creation of interfaces between two systems using PL/Sql.

Tuned The PL/Sql queries with the help of Analytic functions in Sql.

Handling the maintenance related issues in codes.

Preparing Weekly status report and communicating with Clients on the same.

PL/Sql tuning & Sql tuning using indexing which helped in running of the queries in minimal time.

Created various test scenarios and test cases during testing phasing to overcome bugs.

EDUCATION

Bachelor of Engineering in Information technology; Visveswaraiah Technological University, Belgaum, INDIA .

Contact this candidate