SUMMARY

• Result driven technology professional with 14+ years of experience in design, development using Object Oriented Technology, testing, deployment, maintenance and production support. Development experience spreads over Parts Distribution, Inventory Control Management, Insurance, Human Resource Management and Fixed Asset Management sectors using UNIX, Oracle PL SQL, Pro*C, Oracle Forms and Oracle Reports. Familiarity with complete SDLC project life cycle from feasibility of projects.

TECHNICAL SKILLS

Frameworks: Oracle Development Framework(ADF)

RDBMS: Oracle 9i, 10g, 11g and 12c, MS Access

Languages: SQL and PL/SQL, Proc*C

GUIs: Form6i/9i/10g/12c, Report6i/9i/10g/12c

Utilities/Tools: SQL* Plus, TOAD, SQL*Loader, SQL Developer, Putty and WinSCP.

OS: Windows 2000/2007/2010/ XP and Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. UNIX scripting and Oracle PL/SQL Developer

Responsibilities:

• Performed requirement collection, analysis and design documentation for the trading utilities supporting manufacturing functionalities. Designed and developed PL/SQL packages/stored procedures/triggers to enhance the system User Entitlements, Trading Workflows as per business requirements.
• Designed and developed SQL*Loader scripts to load data - files of various formats. Created SQL and PL/SQL scripts to clean and process data for various compliance rules, UBS utilities, user reports and interfaces with other applications such as Accounting, Corporate Actions, Risk Monitoring.
• Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
• Involved in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to 12c.
• Wrote Oracle PL/SQL procedures for data migration and validation.
• Created database objects like tables, views, materialized views, indexes, procedures and packages using Toad and SQL* plus.
• Used DML for INSERT, UPDATE, DELETE and DDL (Data Definition Language) for creating and modifying tables and other database structures.
• Developed, tested and optimized SQL queries and PL/SQL code for migration of large database files to target Data Warehouse database.
• Created records, tables, collections (nested tables and arrays) for improving BULK Query performance by reducing context switching.
• Analyzed Oracle PL/SQL code for optimization. Performed SQL and PL/SQL tuning using EXPLAIN PLAN and using hints to direct the optimizer to choose an optimum query execution plan.
• Performed data analysis and modeling for client-server RDBMS.
• Designed and developed Unix shell script to perform data loading, BOD setting of systems, intra-day processing and reporting. Designed and developed PL/SQL packages/triggers to handle database tasks. Developed Autosys JIL scripts for scheduling. Created Unix shell scripts for Interface tool to run sessions.
• Performed day-to-day ETL progress monitoring and maintenance, for trade data loading and processing in datawarehouse schemas.
• Performed initial implementation and production support for Order Management System and subsequent upgrades.
• Used UNIX Shell scripts for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.

Environment: - Unix/Linux, Oracle Forms, Oracle Reports, Oracle 11G / 12C databases, OAF, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD.

Confidential

Sr. Oracle Developer

Responsibilities:

• Performed back end Oracle PL SQL development for Confidential System. This content management system has replaced existing Bloomberg system of gathering, processing and storing/retrieval of financial data in the form of News, Company related information as well as company’s financial and other documents.
• Performed database modeling, design and development of Profiles, Fundamentals sub-systems. Developed PL SQL stored procedures/ packages/ triggers to support business logic and front-end processes.
• Good knowledge on Upgrading Oracle Forms Reports
• Responsible to define the concurrent programs and their executables.
• Carried out registration of concurrent programs and request sets.
• Developed custom D2K forms using form builder.
• Developed reports using report builder.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Designed and developed SQL*Loader scripts to load data-files of various formats. Created SQL and PL/SQL scripts to clean and process data.
• Created of database objects like tables, views, procedures and packages using Toad and SQL* plus.
• Used DML and DDL (Data Definition Language) for creating and modifying tables and other database structures.
• Developed, tested and optimized Oracle queries and PL/SQL code.
• Created records, tables, collections (nested tables and arrays) for improving BULK Query performance by reducing context switching.
• Analyzed Oracle PL/SQL code for optimization. Performed SQL and PL/SQL tuning using EXPLAIN PLAN and hints.

Environment: - Oracle 11g/12c database, Unix, Oracle Forms, Oracle Reports, PL/SQL scripting, Oracle PL/SQL stored packages/procedures/triggers, SQL Developer.

Confidential

Sr. Oracle Consultant

Responsibilities:

• Involved in Analysis, Design, and Coding phases.
• Preparation of Technical specification based on Functional specification.
• Defect fixing / Test case Preparation.
• Development or enhancement in backend Procedures / Functions / Packages / Triggers.
• Involved in designing Flow charts, Data flow Diagrams etc. for the business documents and categories using Microsoft VISIO .
• Designed and developed Oracle Forms Reports using Forms11g/10g/6i and Reports11g/10g/ 6i Including Forms based on stored procedures.
• Development or enhancement in Oracle Forms, Reports and SAP BO report .
• Implementing the customized ERP application developed in ORACLE/PLSQL and D2K.
• Interaction with onsite coordinator on weekly basis. Allocation of work to team members and interaction with onsite coordinator.

Environment: - Unix/Linux, Oracle 11G databases, Unix, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD.

Confidential

Sr. Oracle Consultant

Responsibilities:

• As an Application developer, my key role is to understand the requirements and to develop the business cycle depends on the requirements.
• Analysis of existing application.
• Based on the requirement, modification as to be created , modified in Packages, Procedure, Functions, views and Triggers.
• Customization in Forms and Reports and Unit level testing.
• Review the Client specification.

Environment: - Oracle 11G databases, Unix, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD.

Confidential

Software Engineer

Responsibilities:

• Developed hourly reports for price and quantity variations between the order placed by the customer and the order filled by the inventory system.
• Developed various EDI interfaces using Pro*C and embedded PL/SQL stored packages and procedures. Also developed Unix and AutoSys job-scheduling scripts for the same.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.
• Re-engineering the application.
• Delivery the scheduled date.
• Co-coordinate with team members and achieved the targeted goals.

Environment: - Oracle 11G databases, Unix, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader.