Developer Oracle

PROFESSIONAL SUMMARY

Over * years of Experience as an Oracle SQL and PL/SQL developer.

Experienced in gathering business requirements, analyzing functional and technical specifications.

Expertise in writing Oracle SQL, PL/SQL Packages, stored Procedures, Functions, Database Triggers.

Strong knowledge in creating and manipulating Database objects to extract, transform and load data.

Expertise in Design and development of interface and conversions in R12 using PL/SQL, SQL*Loader, UTL File.

Experience and knowledge on usage of advanced Oracle SQL like composite data types like collections and records.

Strong coding experience in PL/SQL development using Packages, Stored Procedures, Functions, Triggers, Alerts, Views and Indexes.

Experience in registering Concurrent Programs, creating value sets, Lookup values and Transaction types from back end.

Experience in TARs/SRs using Oracle Metalink in working with Oracle Support to resolve issues with Oracle applications standard functionality.

Experience in moving concurrent programs and value sets from one instance to another using FNDLOAD, Unix shell scripting.

Experienced on working with tools like SQL PLUS, TOAD 9.6, TOAD MYSQL 7.2, WINSCP, Tortoise SVN, Oracle Report and Form builder 10g, SQL developer and Putty.

Good knowledge in creating XML, XSD and WSDL scripts.

Strong ability to manage project tasks with changing priorities and tight deadlines.

Good Interpersonal, Reporting, trouble shooting and Communication skills.

EXPERIENCE SUMMARY

JDA Software, Scottsdale, Az. Mar’15 to Till Date

Role: Sr.Oracle Developer

Project:

JDA Software is the leading provider of end-to-end, integrated retail and supply chain planning and execution solutions worldwide.

SCOPE:

In order to enhance the productivity of the system, the company went for customization and development of objects and to train their staff they approached for a support team.

Responsibilities:

Worked closely with the Business Analysts and business users to understand the business requirements.

Designed and developed tables, views, SQL queries, stored procedures and functions to implement complex business logic and optimize system performance.

Developed a PL/SQL code to convert the data from legacy systems to Oracle 11i & R12 databases.

Performed data extraction and conversion in Oracle financial modules (AP Invoices, GL Balances).

Involved in the PL/SQL code review and modification for the development of new requirements.

Developed custom stored Procedures and functions to support new enhancement needs.

Developed Inbound Interfaces to import the flat file legacy data into the staging table.

Used Exception handling extensively for the ease of debugging and displaying the error messages in the application.

Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.

Executing the scripts and inserting data into the tables.

Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.

Adding Constraints, tables according to the changes in the design documents.

Documentation of Tables and Views.

Involved in preparation of MD70’s (Technical design documents).

Delivered the objects and respective documents by following Oracle’s AIM methodologies.

Carried out unit testing successfully.

Extensively interacted with Oracle metalink support to raise TAR/SRs and their resolution.

Provided go-live support and post go-live support.

Environment: Oracle Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, WINSCP, Unix Shell Scripting and Putty.

Client-1: Eventbrite (offshore: Hyderabad, India). Jan’14 to Mar’15

Employer: Dakshah EBiz Consulting, Pvt. Ltd (Total Duration Oct’2007 – Mar’2015)

Role: Sr.Oracle Developer

Project:

Eventbrite is a global marketplace for live experiences that allows people to find and create events in 190 countries. The platform allows event organizers to plan, promote, and sell tickets to events (event management) and publish them across social-networking tools directly from the site's interface.

SCOPE:

This is a Support project for already existing Oracle ERP system in order to resolve daily based issues.

Responsibilities:

Developed Packages, Procedures and Functions to validate data in the staging tables and insert into base tables using open interfaces or API’s.

Developed a custom layouts (in XML & XSL-FO format) according to the user specifications and worked on incorporating custom functions to the standard Print Purchase Order, Invoice and General Ledger reports using XML Publisher (BI publisher).

Created Triggers and Alerts messages to users for PO Approval Delay, Approval Limit.

Worked on Order Import Interface Program to import Sales Orders into Oracle systems instead of manually entering them.

Supported with Oracle form personalization to limit the access control for specific users and dealt with Oracle report issues.

Developed MD 70 for custom reports based on provided MD50.

Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.

Generating Unix Shell Script to pick data file from server and insert data into staging tables in General Ledger on daily basis and creating backup files.

Migration of data objects from one instance to another using Unix Scripts in Putty.

Interacted with Functional and DBA teams to discuss and resolve the ERP issues on Daily basis.

Environment: Oracle Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, WINSCP, Unix Shell Scripting, Putty.

Client-2: Immersion Corporation (offshore: Hyderabad, India). Apr’13 to Jan’14

Employer: Dakshah EBiz Consulting, Pvt. Ltd (Total Duration Oct’2007 – Mar’2015)

Role: Oracle Developer

Project:

Immersion Corporation of California, is a developer of haptic technology. It is employed in automotive, entertainment, medical training, mobility, personal computing, and three-dimensional simulation applications. Immersion's patent portfolio includes, according to their web site, over 700 issued or pending patents in the U.S. and other countries.

SCOPE:

This is a Support project for already existing Oracle ERP system in order to resolve daily based issues and data conversion specific to Order Management.

Responsibilities:

Involved in implementation of the complete life cycle of Order to Cash.

Developed PL/SQL scripts to load order data from external system to OM interface tables and OM base tables.

Designed and Developed Staging tables, Data Conversion, SQL * loader Program and Custom PL/SQL API to import the data from legacy system into database.

Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i/10g and registered as XML reports in applications.

Configuration of Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets, Lookups, Transaction Types.

Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheets and populated the Staging tables.

Used PL/SQL features like PL/SQL tables for error handling, implicit, explicit cursors for data processing.

Personalization of Oracle forms like, Order Entry and Material Transactions forms as per the client’s requirements, using Oracle Forms.

Developed and registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.

Environment: Oracle Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, WINSCP, Unix Shell Scripting and Putty.

Client-3: ITW Signode, Hyderabad, India. Oct’11 to Mar’13

Employer: Dakshah EBiz Consulting, Pvt. Ltd (Total Duration Oct’2007 – Mar’2015)

Role: Oracle Developer

Project:

ITW is into Providing Steel packaging solutions. They also manufacture other packaging products, and also manufacture custom packaging machinery as per their customer’s requirement. They have operating units in Hyderabad, Pune and Silvasa. They also do packaging as a contract for their top clients like, JINDAL, ESSAR and TATA Steel.

SCOPE:

This is an Implementation project, as a part of their organization re-structuring, they decided to upgrade from R11.5.10 to R12.1.3.

Responsibilities:

Involved in Up-gradation from 11i to R12 environment.

Worked on various applications like OM, INV, PO, AP, AR and GL.

Worked on validating invalid objects with R12 compliant.

Developed multiple custom reports in PO, AP and GL modules using Oracle Reports 10g and XML Publisher.

Developed SQL Loader scripts and PL/SQL scripts for validating and inserting the data into interface tables and then populated the Oracle base tables by using standard API.

Involved in scripting Customer and Supplier API’s to update customer and Supplier names and addresses.

Developed custom reports using the XML Publisher to meet the requirements of the client.

Moving of concurrent programs and value sets from 11i to R12 using FNDLOAD and UNIX scripts.

Delivered the objects and respective documents by following Oracle’s AIM methodologies.

Carried out unit testing successfully.

Extensively interacted with Oracle metalink support to raise TAR/SRs and their resolution.

Environment: Oracle Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 10g, XML Publisher, WINSCP, Unix Shell Scripting and Putty.

Client-4: Dharti Dredging and Infrastructure Ltd, Hyderabad, India. Jul’10 to Sep’11

Employer: Dakshah EBiz Consulting, Pvt. Ltd (Total Duration Oct’2007 – Mar’2015)

Role: Oracle Developer

Project:

Dharti Dredging & Infrastructure Limited (DDIL) is one of the largest Indian Dredging Company. Since its inception in 1993, DDIL has executed numerous dredging projects in India, Middle East and Indonesia.

SCOPE:

This is an Implementation project of Oracle EBS (R12) of different modules like SCM, Financials and Project Accounting to maximize the efficiency and accountability.

Responsibilities:

Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.

Automated custom Data Cleansing packages to normalize, cleanse, validate, extract, de-duplicate and interface the legacy Supplier and Customer data into the pre-staging tables of Oracle custom conversion programs.

Developed a custom API to create and update Projects using PA_PROJECT_PUB. Create related Tasks and Sub-tasks for respective Project.

Developed a custom layouts (in XML & XSL-FO format) according to the user specifications and worked on incorporating it to the standard Print Purchase Order, Invoice and General Ledger reports using XML Publisher (BI publisher).

Supported with Oracle custom form and reports issues developed based on custom objects and custom triggers.

Extensively used exception handling for the ease of debugging and displaying the error messages in the application. Moving of concurrent programs and value sets from 11i to R12 using FNDLOAD and Unix Shell Scripting.

Interacted with legacy data management developers by providing conversion data specifications on Supplier, Customer, and Open AR Transactions data. Also, interacted with end users by assisting them during CRP testing sessions.

Environment: Oracle Applications R12, TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 10g, WINSCP, Unix Shell Scripting and Putty.

Client-5: Kixeye (offshore: Hyderabad, India). Aug’09 to Jul’10

Employer: Dakshah EBiz Consulting, Pvt. Ltd. (Total Duration Oct’2007 – Mar’2015)

Role: MySQL developer

Project:

Kixeye (stylized as KIXEYE, formerly known as Casual Collective) is a San Francisco, California based developer of online strategy and combat games with over 5 million monthly active users.

SCOPE:

This is a support project of to generate daily, weekly and monthly data reports.

Responsibilities:

Running python scripts to load data into the custom tables with necessary customizations in the script.

Developed a custom procedures and functions to validate loaded data in the custom objects and to move them into base tables.

Creating procedure and functions to identify data validation and data integrity issues while loading data through python scripts.

Creating views and index based on the tables and their columns.

Developing scripts to generate weekly and monthly reports for reconciliation and disbursements.

Creating procedure to update exchange rates based on the file provided by the user.

Creating procedure to call all the functions and procedures created to generate reports based on monthly, weekly and daily basis.

Holding calls with the end user to discuss the issues with respect to data integrity and issues related to the reports generated for daily, weekly and monthly.

Generating sales summary reports and payment reports using MySQL scripts while running the report generation from PHP application.

Environment: PHP, Python, MySQL, TOAD for MySQL, Oracle Reports 6i, Putty.

Client-6: NCH Corporation (offshore: Hyderabad, India). Aug’08 to Jul’09

Employer: Dakshah EBiz Consulting, Pvt. Ltd. (Total Duration Oct’2007 – Mar’2015)

Role: Oracle developer

Project:

NCH Corporation is a major international marketer of maintenance products, and one of the largest companies in the world to sell such products through direct marketing. NCH's products include specialty chemicals, industrial maintenance supplies, pet products, and plumbing parts. Its branch offices and manufacturing plants are located on six continents, and its products are sold in over 50 different countries.

SCOPE:

This is a Support project for already existing Oracle ERP system in order to resolve daily based issues.

Responsibilities:

Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages.

Created logical and physical database objects - table spaces, tables, views, synonyms, indexes, referential integrity constraints, and triggers to development needs.

Prepared requirement specification document that gives the comprehensive details about the requirements.

Developed conversion Programs for Open Invoices in AP and open balances in GL.

Functions & Triggers using TOAD as development tool.

Created Materialized Views to reduce query run time for the end user. Involved in taking backups and exports, FTP in UNIX environment.

Developed Reports to extract the monthly information in Inventory, AP and GL.

Developed custom reports and added columns in the existing reports according to the requirement.

Coordinated with the business users to collect requirements.

Environment: Oracle Applications 11i, SQL, PL/SQL, TOAD, WINSCP, Unix Shell Scripting and Putty.

Client-7: Sai Life Scinces, Hyderabad, India. Oct’07 to Aug’08

Employer: Dakshah EBiz Consulting, Pvt. Ltd. (Total Duration Oct’2007 – Mar’2015)

Role: Oracle developer

Project:

Sai Life Sciences delivers advanced Discovery, Contract Development and Manufacturing Solutions, through a broad suite of expert capabilities across the molecular life cycle, exclusively for Pharma innovators.

SCOPE:

This is a Support project for already existing Oracle ERP system in order to resolve daily based issues.

Responsibilities:

Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages.

Created logical and physical database objects - table spaces, tables, views, synonyms, indexes, referential integrity constraints, and triggers to development needs.

Prepared requirement specification document that gives the comprehensive details about the requirements.

Developed conversion Programs for Open Invoices in AP and open balances in GL.

Functions & Triggers using TOAD as development tool.

Created Materialized Views to reduce query run time for the end user. Involved in taking backups and exports, FTP in UNIX environment.

Developed Reports to extract the monthly information in Inventory, AP and GL.

Developed custom reports and added columns in the existing reports according to the requirement.

Coordinated with the business users to collect requirements.

Environment: Oracle Applications 11i, SQL, PL/SQL, TOAD, WINSCP, Unix Shell Scripting and Putty.

Contact this candidate