Oracle Developer

NIRMESH KUMAR

Oracle PL/SQL Developer

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

Phone: +1-732-***-****

SUMMARY:

Over 9.5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS), Oracle App R12.

Extensive experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed Materialized views for data replication in distributed environments.

Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Experience with Oracle Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Created Shell Scripts for invoking SQL scripts and scheduled them using Control-M.

Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE.

Extensively worked with third party database tools like TOAD, SQL Navigator, SQL*PLUS, MySql Workbench etc.

Proficient in writing and tuning complex SQL statements, complex joins co-related sub-queries and SQL statements.

Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions by utilizing business insights.

Ability to work within an aggressive and demanding project schedule and environment.

Team player with strong analytical, presentation, and problem solving skills.

TECHNICAL SKILLS:

EDUCATION:

Master of Computer Application from Punjab Technical University (PTU), India.

Bachelor of Computer Application from Chaudhary Charan Singh University (CCSU), India.

Professional Experience:

TechDemocracy LLC. June 2016 – Till Date

Role : Sr. Oracle Developer

Location: Edition NJ.

TechDemocracy LLC is a rapidly growing IT solutions and professional services firm, founded in year 2000. TechDemocracy has been recognized and awarded by renowned 3rd party organizations for our proven growth, reliability, exceptional service levels and client satisfaction levels. They are Oracle Gold Partner.

Credit Agricole, Credit and Investment Bank Nov 2014 - May 2016

Role: Sr. Oracle PL/SQL Developer

Location: NY-USA

With a staff of 9500 employees in 32 countries, Credit Agricole CIB is active in a broad range of capital markets, investment banking and financing activities. Clients are primarily corporate, governments, and banks, with a small footprint in the investor segment.

This project is Oracle E-Business Suite Release 12.1.3 implementation and support focused on financial modules for various US and Canada division and branches. We have customized and set up PO, AR and AP, GL, iExpense, Reports and Pl/Sql programs etc. as an Oracle Developer and part of Oracle Apps implementation team.

Responsibilities:

Coordinated with the Oracle Application Functional team, OIM team and Clips Plus to provide them with the necessary stored procedures, packages and the necessary insight into the data.

Developed and customize Oracle Program used for OIM team using PL/SQL, JAVA, BI Publisher etc.

Developed Database Programs used by Web Application team using Oracle SQL, MySql for Dot net environment.

Generating Ah-Hoc Reports as the business requirements.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Involved in the continuous enhancements and fixing of production problems.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to Oracle Application Database.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF .

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Developed an outbound interface program to transfer Invoice and GL extracts from Oracle to Clips Plus (Payment tool).

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Experience in providing Level 3 support to resolve high priority Oracle technical and functional production and support tickets.

Environment: Oracle Applications R12, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Oracle Reports, SQL Developer, Clips Plus, Dot Net (.net), Java, Shell Scripts, UNIX, Windows XP.

Project: Ooredoo Mar 2013- Oct 2014

Role: Oracle PL/SQL Developer

Location: NJ - USA

Ooredo is a Mobile applicaiton used for Oracle Application Approval processl, Leave creation and Approval Notification Status. We Customized the Database process that inract with the Oracle Appication Workflow API's and generate the notifications for Leave, Purchase Order, Requisitions, Expenses request. User can approve, forword and cancle the request using application.

Responsibilities:

Involved in gathering business requirements, and designed the process flow, Prepared the Technical Design Document based on the Business Requirement for various modules.

Developed Oracle interface programs for Mobile Application which interact with Oracle Apps R12 (iExpenses, PO, AP, HRMS etc).

Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections Web Application / Portals development team using Oracle SQL, PL/SQL, MySql used by Dot Net and Java environment.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.

Customized and developed Oracle forms & reports.

Generating Ah-Hoc Reports as the business requirements.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.

Developed MySQL Database program for Mobile Application.

Used External Tables to load test data from CSV files to the database tables from Front end.

Involved in Optimizing SQL queries involving large tables.

Created database triggers to track of the transaction changes and kick of the business events.

Created Indexes and Materialized Views to improve the overall system performance.

Involved in the maintenance and support of existing applications with the users.

Worked in the production support to debug and fix the issues on quick time frames.

Environment: Oracle Applications R12, Oracle database 11g, Oracle Reports, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, XML,Dot Net (.net), Java, Window XP etc.

Project: Platware DEC 2011- MAR 2013

Role: Oracle PL/SQL Developer

Worked in an application which is a customer transaction facility created for the Insurance customers (AVIVA / HSBC etc) to do payments, Create the new leads, Show the equity reports, financial reports, Schedule appointment, take the orders etc. The Project covered addition of new enhancements to the application like financial transfers, Reports and development of the same.

Responsibilities:

Involved in the requirement discussion, technical design and development. Supported the complete testing process and successful deployment.

Debugged the existing code, and listed out the changes needed as per the new requirement, and also provided suggestions for future enhancements.

Developed various Custom reports, Customized existing reports for mobile application and Web Application.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Performance tuning of Oracle Databases and User applications.

Improved the performance of the application by rewriting the SQL queries.

Involved in Logical & Physical Database Layout Design, Data Flow Design.

Used SQL*Loader as an ETL tool to load data into the staging tables.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Worked as a Database Architect for many mobile application using MySql, PL/SQL, SQL etc.

Provided user training and production support.

Used Ref-cursors, Collections and Bulk Collects for memory intensive processes and to improve trace-ability.

Used Autonomous transactions in triggers for supporting Audit and also used in packages for logging the process information.

Environment: Oracle 11i /10g, SQL, PL/SQL, MySql, SQL Server 2005, Dot Net (.net), Java, SQL*Plus, Toad.

IndiaMart InterMesh Ltd MAR 2011 – DEC 2011

Role- Oracle PL/SQL Developer/

IndiaMART is an Indian online marketplace based in Noida, India. The company claims to have 1.5 million suppliers listed on its website, with around 10 million buyers visiting the online platform every month. Provide B2B portals that customer used to find the buyers, raised request for leads, sales support and publicity.

Responsibilities:

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Designed logical and physical data models for Mobile and web applications.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Creation of database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.

Developed and customize various reports using Oracle Reports 6i.

Generating Ah-Hoc Reports for sales and marketing team as the business requirements.

To assist the Incident Management team to drive down the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents and prepare the documents for future prospective.

Fine Tuned procedures for the maximum efficiency in various schema across the database using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.

Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.

Wrote database program and scheduled using DBMS_Schedulers for data loading, Reports generate.

Tuned the SQL using Explain Plan, TKProf for better performance.

Worked in the production support to debug and fix the issues on quick time frames in all types of rice objects line interfaces, enhancements, forms and reports.

Environment: Oracle 10g, SQL, PL/SQL, SQL* Loader, Oracle PL/SQL, Dot Net (.net), Java, Oracle Reports 6i.

Celerity Network Pvt Ltd. MAR 2007 – Feb 2011

Role: Trainee / Oracle PL/SQL Developer / Oracle Developer

Celerity Networks (P), Ltd. provides IT managed services and project management services. The company offers IT managed services, which include monitoring, management and administration, and engineering services, as well as support for original equipment manufacturers.

Responsibilities:

Involved in the requirement discussion, technical design and development.

Supported the complete testing process and successful deployment.

Worked as an independent database developer for many Mobile and Web applications.

Developed and customized Oracle reports and Forms using Oracle Report Builder 6i.

Generating Ah-Hoc Reports as the business requirements.

Oracle Reports and Database Performance Tuning.

Debugged the existing code, and listed out the changes needed as per the new requirement, and also provided suggestions for future enhancements.

Prepared program specifications for PL/SQL (Procedures, Functions and Packages) for daily policies and for the development of the application.

Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Exception Handling, Records and Collections.

Creation of database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.

Used Ref-cursors, Collections and Bulk Collects for memory intensive processes and to improve traceability.

Used Autonomous transactions in triggers for supporting Audit and also used in packages for logging the process information.

Fine Tuned procedures for the maximum efficiency in various schema across the database using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.

Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.

Tuned the SQL using Explain Plan, TKProf for better performance.

Worked on XML along with PL/SQL to develop and modify web forms.

Participated in Freshers Oracle Development program.

Environment: Oracle 9i/ 10g, Oracle Developer 2000, MySql, SQL, PL/SQL, Dot Net (.net), Java, SQL*Plus, Toad, Oracle Reports, Putty.

Contact this candidate