Canadian PR HOLDER

PRAVEEN JINDAL ( +91-828-***-**** / +1-647-***-**** ) adc178@r.postjobfree.com

Oracle Senior PLSQL Developer / Performance Tuning Expert/ Oracle Dev DBA

Experience Summary

Praveen has total 18+ Years IT Experience working in Oracle Technology space. Currently working as Senior Oracle Consultant with UBS(United Bank of Switzerland). Prior to that worked with Citco(Canada, as Senior Applications DBA with OpenWare Pvt Ltd(Singapore) and Technical Architect in Sage Financials Ltd(Singapore). Also worked as Oracle Database Engineer with Database Engineering team handling primarily performance tuning issues in Barclays Global Investors, Singapore. He has played technical roles as Oracle Developer (Forms/Reports), Oracle Database Backend Programmer (SQL, PL/SQL, Pro*C, Pro*COBOL, OCI), Oracle PL/SQL Consultant & Oracle Dev DBA. Good Experience and exposure to Oracle Database Architecture(8i, 9i, 10g, 11g), Data Modeling, Oracle Database Designing, Application & database Performance Tuning( AWR, TKPROF, ADDM), Query Tuning & Oracle Database Administration( Database Installation, Cloning, Refresh ASM, RAC, Standby, RMAN). He also has a good knowledge and exposure to the Finance domain like Asset/Wealth Management, Portfolio Risk analytics and Financial Risk Management.

Skills Summary

11+ Year Experience as Oracle Database Programmer (SQL, PL/SQL, Forms/Reports, Pro*C,Pro*Cobol,OCI)

Schema Refresh using Traditional Exp/Imp Utility, Modern Expdp/Impdp utility, Oracle Transport Tablespace, DBMS_METADATA, DBMS_DATAPUMP, Toad Tool.

Schema Design, Table/Index Design, Data Modeling, Application & Database Tuning (8i, 9i, 10g and 11g)

Triggers, Procedures/Functions/Packages,Invoker/Definer Rights

Exception Handling, Dynamic SQL

Implicit/Explicit Cursors, Ref Cursors, Cursor Expressions,

Lobs, Objects,Collections, Native PL/SQL Compilation

Dynamic SQL, Bulk Insert/ FORALL

Oracle Supplied Packages like DBMS_OUTPUT, UTL_FILE, DBMS_JOB, DBMS_UTILITY

Autonomous Transactions, Database Links, Roles&Privileges

Generating Traces by setting events, Troubleshooting of pl/sql code

Performance Tuning of the SQL, PL/SQL Code, Pipeline Function, Bulk Bind/Collect, Collections

Oracle Analytical Functions, Materialized Views

Project development using SDLC methodologies, Waterfall and Iterative Waterfall Models, SRS, Prototyping, Design, Coding, UTP, System Testing, UAT, Implementation, Support, Writing Solution Design, Technical Design Docs.

4 Years Working Experience on Unix Systems, Writing Shell Scripts. Exposure to Sun Solaris, Linux, IBM RS 6000, HP-UX, Compaq Tru64, SGI IRIX

Written Technical Articles(as PRJINDAL.IN) on PL/SQL, Pro*C, Pro*Cobol for Oracle Metalink(http://metalink.oracle.com)

7+ Year as Oracle Database Engineer Plus DBA

SQL Performance Tuning ( RBO/CBO, Indexes, Explain Plan, TKProf, Partitioning, Parallel Queries, Statspack Reports, ADDM, AWR Reports, SQL Plan Management, OS Watcher, iostat, vmstat, sar)

Data Modeling and Database Design

Handling AWS RDS Database on EC2, Cloud Watch setup and monitoring.

RAC Instances and SQL Performance Tuning

Standalone and RAC Database Installation On Windows/Unix Boxes

DataFiles& Tablespace Management, Users Roles and Priviledges, Database Authentication

Backup/Restoration/Recovery/Cloning using RMAN (Recovery Manager)

Database Cloning Using Hot/Cold Backup

Data Upload using Export/Import, SQL*Loader.

Application tuning and optimization

Oracle Database Replication using Oracle Golden Gate.

Database and Apps 11i environment monitoring using OEM 9i/EM10g, Oracle application patching using adpatch.

Data Guard Standby Database 9i/10g Setup and monitoring

Oracle Database Design, Build and Installation Experience ( 9i/10g/11g)

Database Upgrade and Migration Experience.

7 Year Experience working on Finance Domain:

Banking Product, Insurance, Financial Risk Management, Corporate Banking Product, Insurance Projects, Fixed Income Risk Analytics, Bonds, Insurance, Corporate Banking, Market Risk, Credit Risk, Value at Risk, variance-covariance approach, historical simulation, EVT, Modified Duration, Treasury Yield Curve, OAS.

Domain Knowledge

Fixed Income Securities, Bonds, MBS, ABS, Corporate and Municipal Bonds, Mutual Funds, Equity Instruments, Equity Derivatives, Options/Futures, Stock Options, Warrants, Banking, Insurance, Consumer Lending, Loan Processing, Derivatives, Funds Transfer, Payment and Settlement, Credit Risk Management, Asset Liability Management, Operational and Market Risk, Risk Capital, Investment Banking, IPO, Share Repurchase, Company Valuation, Dividend Discount Method, Residual Earning Method, Discounted Cash Flow Method, Value at Risk.

Key Skills/Certifications:

CFA Level 1 Pass,

ITIL Certified,

Oracle PL/SQL Brainbench Certified

Oracle 10G OCA & OCP Certified

Databases :

Oracle 7.3.4 / 8.0.4 / 8i / 9i /10g / 11g, 12c, Sybase 12.5.4

Programming Languages & Tools :

SQL, PL/SQL, ADS, SQL Developer, TOAD, PL/SQL Developer, SQL*Tools4.1, C/C++, Pro*C, Pro*Cobol, OCI, PVCS Dimensions Tool, Flexmart, Oracle Forms and Oracle Reports, Unipass/Magic 4GL, SSRS 2008, Eclipse Tool

Operating Systems :

Solaris 5.8,5.9, Red Hat Enterprise Linux 2.1,

Windows 2000/NT

AIX 4.3, HP-UX 11i, Compaq Tru64

Trainings:

Oracle Database Fundamentals I + Fundamentals II( Oracle Internal Training)

Oracle Database Backup and Recovery (Oracle Internal Training)

Oracle 10g DBA WorkShop-II Training from Oracle University

Pro*C ( Oracle Internal Training )

Oracle 11g Performance & Tuning from Oracle University

JAVA1.2, Basic JAVA + Advance JAVA

Educational Summary

B.Tech (Electrical Engineering) from DCE(Delhi College Of Engineering), June 1998.

PGSEM from IIM Bangalore, March 2009

Organizational Experience

UBS( Pune, India )

(Oct 2019 – Till Now)

Working as Senior Oracle Consultant with UBS for DS^2 Project in Market Risk Team. The project involves calculation of Value at Risk across all the major portfolios, carrying out impact analysis based on combination of stress factors/scenarios. Risk not in VAR(RNIV) is also computed using Java Based Calc Engine. All these VAR Calculations at the Front Desk Trading level is to ensure that risk exposures are in line with market risk regulatory capital rules (FRTB norms). The Data from multiple Front Office sources( Rokenbok, Ratesbroil, Jetweb) comes as a Feed and loads into ARisk Database. Through ETL processes, Data Moves from Arisk Database to DS2 Database for further processing. In Future all components of Market Risk technology are being migrated to Azure Cloud.

Citco Technology( Toronto, Canada)

(Oct 2018 – Jun 2019)

Worked as Senior Oracle Developer to migrate Oracle Data from Oracle Exadata to Amazon AWS RDS environment. EDW project is currently running on Oracle Exadata, with around 400 Clients using the same. With the higher management decision to host services on Amazon AWS, the project is undergoing a major migration. A big risk is associated with the migration of the Oracle Metadata and Data Migration as it’s a huge Data Migration. The project criticalness is also enhanced due to the fact that 400 Clients need to migrated in a time window of 6 months with an average of 3-4 client on a daily basis.

Openware Pvt Ltd.(Singaore)

(Dec 2013 – Dec 2016)

Worked as Senior Oracle DBA with an instrumental role in setting up database configuration parameters, Performance Tuning Issues(Database + Application), Identification of High CPU caused by SQLS, Database Programming using SQL/PLSQL, Replication setup using Oracle Golden Gate, Oracle Schema Refresh from Production to Test Database using Expdp/ImpDp, Shell Script setup for Database/instance/Server Monitoring, OS Monitoring using Cacti, and Reporting Database creation using ETL Technology.

Sage Financial Systems Pvt Ltd.(Singapore)

(March 2011 – Oct 2013)

Worked as Technical Architect in the Asset Management Division for Sage’s flagship product PROSPERO, with an instrumental role in setting up database configuration parameters, Performance Tuning Issues(Database + Application), Database packages coding and best practices, handling database performance issues, capacity planning. The role also includes writing Technical Designs, database development using PL/SQL and unit testing. Working as The role involves writing solution design document, technical design document and carrying out development activity as well. Also played the role as Product Support Engineer handling clients issues, installation and maintenance of the Prospero product. Played a pivot role in improving the performance of the product.

Prospero product offers solution for Investment Tracking, Wealth Management, Asset Management, Risk Management and more. Another product named, BlackSwan, offers a unique risk management platform for portfolio optimization. In a nutshell, Blackswan is a Financial Platform that uses a unique algorithm to help you optimize your asset mix during uncertain investment environments.

Prospero Wealth Management manage the full front office to back office process of a bank from trade capture to trade processing and settlement.

Prospero Asset Management manages discretionary, Advisory Portfolios as well as Funds. Comes with complete risk analytics and Portfolio Rebalancing features.

Prospero Fund Administration is a comprehensive solution for Fund distribution, Registry of Shareholder and NAV Calculation.

Prospero IAM and Family Office, is an ideal solution for Independent Asset Managers, Single and Multi-Family offices with connections to custodians.

Barclays Global Investors(Singapore)

March 2009 – March 2011

Worked as Oracle Development DBA in Database Engineering Team. This is a Level 3 Support which involves interaction with Application Teams during Data Modeling Phase, Physical Database Design phase and Performance Issues (SQL, Application Plus Database Level). Engaging with application teams and assist then writing plsql procedures/packages in an efficient and performance oriented manner. Handling critical issues passed by Level 2 support for further research. In-depth analysis and engagement with Oracle Support. The role also involves laying down PLSQL,SQL coding and Database Best Practices and Standards as Part of Oracle Standards Committee. The team also writes Proof Of Concepts on the new Emerging features like Oracle 11g OLTP Advanced Table Compression, Schema Refresh using Transportable Tablespace Concept, improving plsql code performance using Bulk Bind and Forall. Working with DBA team on improving speed of schema refresh using export/import. Keeping development community abreast with new upcoming features like advanced table compression, virtual indexes, error tracking, loop management using continue construct, enhanced database triggers etc. On continually basis, carry out performance monitoring of the oracle applications using EM10g grid control. Apart from working on Oracle related ad-hoc projects, playing an instrumental role in filling gap between development community and DBAs.

Also got exposure to BlackRock’s one of the core products “Green Package”. Green Package is a comprehensive suite of portfolio risk management and compliance reports. It aggregates all risk exposures by asset type, sector and portfolio. Benchmarks and liabilities are also modeled at the individual security level, eliminating model risk and allowing for a detailed comparison of portfolio versus benchmarks. Risk analytics process involves analysis/quality check of risk results provided by the Green Package System. Green Package Reports mainly include

Fund and Benchmark Duration movements

Tracking Error

Value at Risk, Spread Risk, Credit Risk,

Oracle Finance Services/I-Flex Solutions(Bangalore)

March 2008 – March 2009

Worked as Tech Lead on projects related to Corporate Banking Product “Flexcube”. Role involved working on new Enhancements/ Design/ DS-FS Specifications/ Coding/ Testing / Releases for the European clients like RABO Bank, ACC Bank, Bank of Poland, Alpha Bank. Flexcube is the topmost end-to-end software product for corporate banking, retail banking, consumer banking, investment banking, internet banking, asset management, and investor servicing.

Unisys Global Services (Bangalore)

March 2005 – February 2008

Worked as Tech Lead: Writing procedures/ Packages/Triggers, mentoring the junior team members, reviewing the codes. . Role involved working on new Enhancements/ Design/ DS-FS Specifications/ Coding/ Testing / Releases for the existing clients. Also played role of Development DBA and worked on Application and SQL Code Tuning, Database Tuning, Writing SQL, PL/SQL Scripts to generate INSURANCE Domain reports, Performing Database Creation, Refresh, Cloning, Upgradation, Monitoring, Mentor and Guide subordinates technically, Code reviews, delivery/release of code, Enhancement and Maintenance of Existing Applications.

Oracle India Pvt. Ltd(Bangalore)

October 2001 - February 2005

Worked as Senior Associate consultant providing Technical support to Oracle World Wide customers in Oracle Database, SQL/PLSQL, Database Tuning, Pro*C, Pro*Cobol, OCI, OEM( Oracle Enterprise Manager ). Creating Notes/Articles (Technical Documents in Metalink ), Involved in SME ( Subject Matter Expertise ) for analyzing, testing and reviewing new features in latest Oracle release. Tested the new features of Oracle 10G. Reviewing Notes created by other Support Analysts and publishing the same with appropriate comments or changes.

CMC Ltd(Delhi)

July 1999 - Sep 2001

Worked as System Integration Engineer doing development on Payroll, Finance and Accounting project using Oracle Forms/Reports, SQL, PL/SQL. Role involved Requirement Gathering, SRS Design, DS-FS Specifications/ UTP/ Coding/ Testing /Implementation/Support.

1) UBS : Market Risk Calculation(VAR + RNIV)

Role as Senior Oracle Consultant:-

Work with Line Manager/BA in an CI/CD, Agile framework and perform Requirement analysis, design, planning, coding and unit testing.

Develop Oracle packages/functions/procedures / Shell Scripts

Write adhoc scripts to perform Production Data updates/changes.

Design existing code flow diagrams using Visio Tool.

Carrying out SQL Tuning activity of existing PLSQL Code /SQL Scripts.

Work with AWR/ASH Reports and recommend changes.

Work with Partitioned Tables, Converting Global Index to Local Index, Copying big Data Over DB Link.

UnitDB Creation for Testing Purpose using Export/Import/Materliazed Views methods.

Monitor ETL Loading, Batch Processing.

Work with ORACLE DBA Team and assist in SQL profiling of the Sqls with changing Planh Hash Values.

Work on Changes using Jira Tool, Github, Confluence.

2) Citco : Oracle Database Migration from Oracle Exadata to Amazon AWS

Role as Senior Oracle Developer:-

Requirement analysis, design, planning, coding and unit testing.

Writing PL/SQL packages to carry out Metadata and Data migration using DBMS_DATAPUMP package.

Check Data quality of migrated data & carry performance testing of End to End Data Migration.

Write documentation of the code flow.

Work on AWS secret manager. Message Queue System, RDS database performance monitoring.

Scripting using Unix Shell script, Perl script.

Build of AWS Stack.

Convert PLSQL code logic to SQL WITH ClAUSE to gain Performance benefit.

SQL Query tuning using appropriate hints like USE_HASH, Cardinality, no_merge.

Identify and fixing the execution plans of Problem Sqls using SQL profiling.

3)Project: Openware Internal Databases + 2Success + May Bank

Role as Senior Oracle Database Engineer

Define and implement Oracle database architecture and best practices.

Maintain documentation for all database related platforms.

Monitored the Long Running Queries via crontab job and tuning them.

Regular review of database maintenance and performance improvement procedures.

Reviewed the Checked-In code into SVN and implementing the data changes script on Production

Converted the Java Front End Program and Writing the PL/SQL code to implement the same functionality at Oracle back-end level.

Monitored RMAN backups, carrying out database exports and imports and doing schema refresh.

Participated in the Database Capacity Planning for the design and architecture of Database Size, CPU requirement, Disk Size requirement, Tables Size and Indexes Sizes etc.

Designed the Reporting Database catering to the report generating needs of the client.

Involved in Database Capacity Planning for the design and architecture of Database Size, CPU requirement, Disk Size requirement, Tables Size and Indexes Sizes etc.

Involved in designing of the Reporting Database. The database will cater to the report generating needs of the client. The Data extraction and Transformation is being carried using the ETL technology vis Pentaho tool.

Regular monitoring of Data deletion of high usage Tables and thereby engaze in process of carrying out analysis and best methods to keep tables/tablespaces without de-fragmentation.

4) Sage : Prospero Product Development DBA and Support Role

Role as Senior Oracle DBA:-

Provide Production / Dev Database Support.

Installation, configuration and administration of Oracle Databases

Monitoring the Alerts.

Refreshing the Databases.

Create, maintain and manage Physical & Logical objects of database.

Creation, configuration and administration of Oracle Databases.

Creation of tablespaces and adding more space by creating datafiles.

Check Alert Log for errors and take necessary actions to rectify them.

Auditing objects based on the requirement.

Export / Import of Tables, Tablespaces and Databases.

Scheduling Backups using RMAN.

Configuring Standby databases.

Database cloning.

Database Upgradation.

Applying Patches.

Role as Technical Architect :-

Handling Product performance issues by analyzing AWR reports.

Oracle Database Design with Table and Index Design Review

Prospero Schema Export/Import and Database Creation

Creating Data Patches

Prospero Schema Capacity Planning

SQL and PL/SQL code tuning by capturing SQL execution plans of executed sql statements.

Changing Query execution plan

PLSQL Code performance improvement using Bulk Bind and Forall.

Unit Test Plans, Code Changes/ Version Control (SVN).

Test environment creation, issue resolving for Unit Testing, Integration testing and Defect Analysis.

5) BlackRock: Internal Projects

Role as Dev DBA:-

Blackrock is a Financial asset management firm with the portfolios and other finance related data maintained in Oracle and Sybase Databases which includes some very sensitive and critical databases as “Portfolio Management, Fixed Income Data Warehousing, Fixed Income Equity, Sec Lending and Trading platform databases”. There are close to 120 internal production databases which are maintained by Oracle DBA team with level-1 & level-II support. The production DBA team work on production issues and act like fire fighters to restore systems back to normal so as to keep the applications/operations running. There comes another team(Dev DBA) holding responsibility as level-III support. The prime role of this team is to work on application and database performance issues, carry out root cause analysis of issues passed by level-II support, interact with Oracle Support to get resolved critical issues, provide input to Oracle Standards committee and recommend database best practices, align with level-II support in database upgrade projects, work on the adhoc internal development projects, engage with the development teams and help them in following best plsql code practices, database modeling with future application performance in mind, writing proof of concepts on new upcoming Oracle advanced features in the market. A few of the initiatives/projects I got chance to handle..

SQL and PL/SQL code tuning by capturing SQL execution plans of executed sql statements.

Changing Query execution plan Notification System

In-depth research and Proof of Concept on Oracle Schema Refresh using Transport Tablespace.

Re-Org and Performance tuning of application loading and fetching data from a 400GB table in core CPM(Central Portfolio Management) Oracle Database

Study and Analysis of 10.2.0.4 Upgrade and DST patch effect on the Oracle Database

Research on RMAN backup recovery method to improve the performance.

Interaction with Applications Users and carrying out Capacity Planning of Oracle Signal and data warehousing databases.

Oracle Assessment Project : Comparing databases configuration settings across 200 Oracle Standalone and RAC Production/Dev Databases

Proof of Concept on Oracle 11g OLTP advanced table compression

Table Segment Space Monitoring and notification system for abnormal growths

Project on feasibility of migration from Sybase to Oracle.

Evaluation and implementation of new upcoming technologies and tools in the database space.

6) Customer :- ACC Bank, RABO Bank, Bank of Poland, Alpha Bank, BRED Bank

Role as Tech Lead : -

Post Flexcube Implementation by implementation team, various new enhancements ( Loan / Fund Transfer / Derivatives/ Options / Basel-II reports interface etc. Modules) come to incorporate new changes in the existing functionality or develop new ones.

Responsibilities Involves Creation & Delivery OF

Design Specification / Functional Specification / System Specification /Program Specification Documents

Unit Test Plans, Release Base Lining, Code Changes/ Version Control (Flexmart)

Getting Codes/Changes pass through SQA( Software Quality Testing) and Integration testing

Build up of new Test Databases using Export/Import

Release deliverable documents

7) Customer :- UISL( Unisys Insurance Services Ltd), CSU(California State University), Bank West(Australia), ACC (NewZealand)

Role as Developer DBA :-

Handling 200+ Databases with 50+ Production Databases. Database programming Using SQL, PL/SQL. SQL Code and Application Tuning, Perform RMAN Backups/Restore, Cloning/Refresh Using RMAN, Database Migration Across Windows Environment., Database Upgradation and Build Activity, Application and Database Tuning using Statspack.

8) Customer :- UISL( Unisys Insurance Services Ltd)

Role as Tech Lead :- Migration Project : Data Migration from Legacy System running in Mainframe Environment to Unix Environment. The front end application was based on Linc Technology and backend was being moved from Mainframe to Oracle Database. Role included writing complex SQL Queries & Generate Reports on insurance data.

Based on functional spec from Business Analyst, carry out database objects development using PL/SQL, writing codes for Packages, Procedures, Functions, Triggers, Test Plan Preparation and Unit Testing, Technical Mentoring/Troubleshooting & Guidance to the Team, Take Initiative and lead the team for new Technical Areas.,

Enhancement/changes to the existing Procedures/Packages, using PVCS dimensions source control, PL/SQL developer tool, Testing, Review and Implementation. There were also cases where the team worked on improving the performance of procedures and packages..

9) Customer :- Oracle On-Demand (Oracle India Pvt Ltd.)

Role as Senior Analyst:- Database Support + Apps 11i Monitoring Using OEM9i/ Em10g, Setup of Alert System Using OEM9i/ EM10g, Setup of RMAN Backup Scripts

10) Customer:- Oracle ISC(India Support Centre) (Oracle India Pvt Ltd.)

Role as Support Analyst:- Handling technical issues for Oracle World Wide Customers on SQL, PL/SQL, Pro*C/C++, Pro*COBOL, OCI. Creating Notes/Articles ( Technical Documents in Metalink ), Involved in SME ( Subject Matter Expertise ) for analyzing, testing and reviewing new features of latest Oracle release. Testing new features of Oracle 10G., Reviewing Notes created by other Support Analysts and publishing the same with appropriate comments or changes ( if needed )., Creating PAA ( Problem Avoidance and Analysis ) reports on TARs (Technical Assistance Request) handled., Conducting Technical Seminars. Handling critical Sev1 issues on production systems. Handling request to debug the full testcode sent by customer. Trouble shoot and resolve issues in a pre-agreed SLA time. Assisted the technical issues via FORUM as well as TAR Work. The role also involved logging to customer box and trouble shoot the issue. Tested the codes and provided support in various Unix flavours like Sun Solaris, Linux, IBM RS 6000, HP-UX, Compaq Tru64, SGI IRIX.

11)Customer:- MIT ( Ministry of Information Technology) & Ministry of SSI

Role as System Integration Engineer : Finance and Accounting System: This module covered activities of Finance and Account Dept. including Drawing & Disbursement, Pay & Accounts and Budget Sections. It also included Payroll processing, Bill preparations(GPF advance/withdrawal bill, Medical Advance bill, Salary Bill, OTA(overtime allowance) bill, Contingency Bill, Arrears bill, TA(traveling allowance) bill. Challan Preparation., GPF Ledger Posting, Income-Tax Calculation, Interest Calculation & PF Balances, Form-16.Responsibilities included SRS Design, Screens & Reports Design, Unit Test Plans, Tables & Index Design, Oracle Forms/Reports Development and writing procedures, functions, packages using using PL/SQL, Testing, Implementation and Support.

Contact this candidate