Summary:

Oracle PL/SQL Developer with Over ** years of experience in developing and supporting all stages of systems life

cycle including Analysis, Development, Testing, Implementation and Support using Oracle SQL, PL/SQL on UNIX

and Windows environment.

Hands on experience working on Oracle 8i/9i/10g/11g databases on various platforms like SUN SOLARIS, UNIX,

Red Hat Linux and Windows (98/XP/2000).

Hands on experience in UNIX shell Scripts, Perl Scripts, Connect Direct NDM, MQ Series, and CDftp.

Extensive experience in developing Database Objects, Triggers, stored procedures, Functions, Packages.

Materialized views.

Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including

requirements gathering, design, coding and unit testing.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and

Query Level Performance tuning.

Extensively worked on Collections, Bulk Binds, Bulk Collects and Table Partitioning.

Excellent in writing Shell Scripts using (Sh, Ksh, Bsh) for database transactions and batch processing.

Experience in performance tuning of using EXPLAIN PLAN, TKPROF, SQL Trace, and Oracle Hints to improve the

performance.

Proficient in using Oracle tools such TOAD, SQL Developer, SQL*PLUS and SQL Navigator.

Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import/Export,

Data pump.

Strong interpersonal, analytical and communication skills, proven ability as an efficient team member in

System Analysis, Design, Development, Migrating and documentation.

Experienced in providing quality operational Support for Production Environments.

Good knowledge of domestic/international equities trading, options and Fixed Income Trading.

Good knowledge of Oracle Financials General Ledger module.

Implemented row & column level security on the database objects using VPD(Virtual Private database).

Technical Skills:

Databases : Oracle 8i/9i/10g/11g, MS SQL Server, MS Access

Operating Systems : Windows 95/98/XP/2000/NT 4.0, UNIX, Linux and Sun Solaris

Tools & Utilities : PL/SQL Developer, SQL*Plus, SQL Loader, Toad 8.6.1, SQL Developer, IBM MQSeries-5.1/5.3, Connect Direct NDM 3.3/3.6, Autosys

Reporting Tools : Oracle Report 6i

Tuning Tools : STATSPACK, TKPROF, EXPLAIN PLAN

Internet Technologies : ASP 2.0, JavaScript, HTML, XML, Coldfusion

Languages : C, C++, Java, SQL, PL\SQL, VB

Version Control : CVS, Clear Case, TFS

IT Concepts : Relational Database Management System, OOAD, Data Warehousing

Experience:

Bank of America, Pennington, NJ June 2018–Dec 2019

Senior Oracle Developer

HRISDM

Description:

HRISDM serves as a central hub for HR data provisioning. Sourcing data from several systems including workday, Fieldglass and all BOA vendors. It acts as an authorized copy of this data to a host of downstream applications & reporting application.

Responsibilities:

Involved in interaction with the client to identify the functional requirements.

Involved in the Analysis, Design, Coding, Testing, Implementation and Support of the applications.

Involved in re-writing existing functionality to a more robust design with improved performance.

Involved in the development of packages, materialized views, procedures, functions which were used by the front end/back end system

Involved in designing and implementing security architecture to secure all data elements at row & column level.

Environment: Oracle 11g, Sun Solaris, Shell Scripting (KSH), TOAD 12, TFS, Autosys, Informatica

Vanguard, New Jersey Feb 2018-May 2018

Project Developer

Description:

Neoxam is a third-party tool which facilitates front office workflow to manage order execution and trading with other systems like Trade flow & Custodian.

Responsibilities:

Closely work with business to get requirement details, development, support, testing and elevation.

Environment: NET Framework v4.5, Oracle 11g, Sun Solaris, Shell Scripting (KSH), TOAD

Bank of America, Pennington, NJ Sept 2014-Feb 2018

Senior Oracle Developer

FDW

Description:

FDW serves as a central hub for finance General Ledger data provisioning. Sourcing data from several systems including the new FGI general ledgers and the CTRDR, it acts as an authorized copy of this data to a host of downstream applications.

Responsibilities:

Production Support and Develop automated job generates report of terminated FDW users

Involved in interaction with the client to identify the functional requirements.

Involved in the Analysis, Design, Coding, Testing, Implementation and Support of the applications.

Involved in the development of packages, materialized views, procedures, functions which were used by the front end/back end system

Tuned the queries using the oracle hints and creating the necessary indexes using EXPLAIN PLAN utility.

Supported the frontend system developed by ColdFusion, Java

Wrote shell Script KSH, perform job schedule on CRONTAB on Solaris 8/9 and generate reports

Did various up gradations to the present application as per the customer request

Wrote Complex Queries, Store Procedures/Functions, Views, Triggers and Synonyms to maintain the Business Rules.

Extensively used SQL*LOADER to load data from flat files received from various facilities on daily basis into the database tables

Worked with Offshore Team and fix the troubleshooting in DBMS and Applications to support the customers remotely

Involved in migration of entire database from Oracle 9i to Oracle 11g.

Involved in migration of AIX to Unix upgrade & Autosys upgrade from 8 to 11.0.

Environment: NET Framework v4.5, Oracle 11g, Sun Solaris, Shell Scripting (KSH), Perl Scripting, TOAD 12, TFS, Autosys

Deutsche Bank, US May 07-Sep 2014

Senior Oracle Developer

NYBOSSS, Deutsche Bank Securities - NJ

Description:

NYBOSSS is the New York Back Office Securities Settlement System of Deutsche Bank. NYBOSSS consist of set of various applications dealing with back-office securities settlement which receives the trade from trade capture systems and sends them to third party systems, clearing agents for processing. The DTE (Distributed Trade Entry) Equities system deals with US domestic equity settlements and has interfaces to DTCC (Clearing Corporation), SIAC (Shared gateway for NYSE and AMEX) and ADP BPS (external vendor used for clearing and book-keeping). The reporting is done through ADP’s BPSA system.

Responsibilities:

Involved in interaction with the client to identify the functional requirements.

Involved in the Analysis, Design, Coding, Testing, Implementation and Support of the applications.

Involved in the development of packages, materialized views, procedures, functions which were used by the front end/back end system

Tuned the queries using the oracle hints and creating the necessary indexes using EXPLAIN PLAN utility.

Supported the frontend system developed by ColdFusion, Java

Wrote shell Script KSH, perform job schedule on CRONTAB on Solaris 8/9 and generate reports

Did various up gradations to the present application as per the customer request

Wrote Complex Queries, Store Procedures/Functions, Views, Triggers and Synonyms to maintain the Business Rules.

Extensively used SQL*LOADER to load data from flat files received from various facilities on daily basis into the database tables

Worked with Offshore Team and fix the troubleshooting in DBMS and Applications to support the customers remotely

Involved in migration of entire database from Oracle 9i to Oracle 10g.

Environment: Sun Solaris, Oracle10g, Shell Scripting (KSH), Perl Scripting, VSS, MQ Series, ConnectDirect FTP, ColdFusion, Java, Reports 6i, TOAD 8.6, PL/SQL Developer7.0 etc.

Capital Groups, US Aug 06-May 07

Oracle Developer

IDI Web-Index Data Information

Description:

The IDI-Web is a web-based application for Capital Groups, US envisaged to share the latest index related information available in a centralized repository to the users on the intranet. The application maintains the index information & Constituent information provided by external sources of MSCI, FTSE, S&P, TOPIX, DJStoxx, HangSeng, SPI, Citi Group and RUSSELL.

Responsibilities:

Analysed the business requirements of the project by studying the Business Requirement Specification document

Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.

Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.

Worked on Perl scripts to transfer files using FTP to all the servers at one time.

Maintained documentation of functional/technical designs and test cases to support development life cycle.

Assisted QA team User Acceptance Testing performed against the modified applications.

Environment: Windows, Oracle 9i, Java, Perl Script, Visual Source Safe (VSS), SQL*Plus, PL/SQL Developer, Eclipse, SQL * Loader, TKProf

Wipro, India Jan 06-Jun 06

Oracle Developer

MYERP-Enterprise Resource Planner

Description:

MYERP-Enterprise Resource Planner is an ERP package for Leather line Tanneries Pvt. Ltd. And Turbo Scaffolding Ludhiana. Under This ERP various Modules are covered such as Finance, Production, Warehouse, Purchase, Sales, and Personnel. The Finance Module covers all the vouchers, maintaining the ledgers, cash Book, Sales Registers, Purchase Register, Debit Note of any Party and Other Various Features.

Responsibities:

Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.

Involved in creating stored procedures, functions, database triggers and packages using Dynamic SQL.

Involved in design, implementation, testing and deployment of Forms using HTML, JavaScript, and ASP.

Involved in generating new reports using Reports 6i and Report Templates.

Enhanced the existing UNIX scripts to run batch processes, oracle background processes using JOBS & achieve better performance and throughput.

Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL *Loader.

Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Windows, Oracle 8i, HTML, CSS, JAVASCRIPT, XML, RATIONAL CLEARCASE etc.

Educational Qualifications:

Bachelor of Engineering in Computer Science from Punjab University, Punjab, India

Oracle SQL/PLSQL 9i certified professional

ITIL Certified

Contact this candidate